[Sommaire] [Imprimer]

   1  CREATE TABLE event (
   2      event_id int(11) unsigned NOT NULL auto_increment,
   3      event_start int(10) NOT NULL default '0',
   4      event_end int(10) NOT NULL default '0',
   5      event_allday tinyint(1) unsigned NOT NULL default '0',
   6      event_recurring tinyint(1) unsigned NOT NULL default '0',
   7      event_datestamp int(10) unsigned NOT NULL default '0',
   8      event_title varchar(200) NOT NULL default '',
   9      event_location text NOT NULL,
  10      event_details text NOT NULL,
  11      event_author varchar(100) NOT NULL default '',
  12      event_contact varchar(200) NOT NULL default '',
  13      event_category smallint(5) unsigned NOT NULL default '0',
  14      event_thread varchar(100) NOT NULL default '',
  15      event_rec_m tinyint(2) unsigned NOT NULL default '0',
  16      event_rec_y tinyint(2) unsigned NOT NULL default '0',
  17      PRIMARY KEY  (event_id)
  18      ) TYPE=MyISAM;,
  19      CREATE TABLE event_cat (
  20      event_cat_id smallint(5) unsigned NOT NULL auto_increment,
  21      event_cat_name varchar(100) NOT NULL default '',
  22      event_cat_icon varchar(100) NOT NULL default '',
  23      event_cat_class int(10) unsigned NOT NULL default '0',
  24      event_cat_subs tinyint(3) unsigned NOT NULL default '0',
  25      event_cat_ahead tinyint(3) unsigned NOT NULL default '0',
  26      event_cat_msg1 text,
  27      event_cat_msg2 text,
  28      event_cat_notify  tinyint(3) unsigned NOT NULL default '0',
  29      event_cat_last int(10) unsigned NOT NULL default '0',
  30      event_cat_today int(10) unsigned NOT NULL default '0',
  31      event_cat_lastupdate int(10) unsigned NOT NULL default '0',
  32      event_cat_addclass int(10) unsigned NOT NULL default '0',
  33      event_cat_description text,
  34      event_cat_force_class int(10) unsigned NOT NULL default '0',
  35      PRIMARY KEY  (event_cat_id)
  36      ) TYPE=MyISAM;,
  37      CREATE TABLE event_subs (
  38      event_subid int(10) unsigned NOT NULL auto_increment,
  39      event_userid  int(10) unsigned NOT NULL default '0',
  40      event_cat  int(10) unsigned NOT NULL default '0',
  41      PRIMARY KEY  (event_subid)
  42      ) TYPE=MyISAM;