Login   Register  
PHP Classes
elePHPant
Icontem

File: playbill.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Renat Vafin  >  Playbill  >  playbill.sql  >  Download  
File: playbill.sql
Role: Auxiliary data
Content type: text/plain
Description: Base
Class: Playbill
Manage database of scheduled cultural events
Author: By
Last change: Last version
Date: 9 years ago
Size: 766 bytes
 

Contents

Class file image Download
# MySQL-Front 3.1  (Build 8.1)


CREATE TABLE afisha_categories (
  id int(6) unsigned NOT NULL auto_increment,
  name char(20) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

CREATE TABLE afisha_event (
  id int(6) unsigned NOT NULL auto_increment,
  item_id int(6) default NULL,
  name varchar(100) default NULL,
  day_start varchar(10) default NULL,
  day_end varchar(10) default NULL,
  time text,
  desc1 text,
  days_week text,
  day_start_mt char(1) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

CREATE TABLE afisha_items (
  id int(6) unsigned NOT NULL auto_increment,
  category_id int(6) default NULL,
  item varchar(100) default NULL,
  desc1 text,
  logo varchar(64) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;