File: playbill.sql

# 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;