[Sommaire] [Imprimer]

   1  CREATE TABLE forum (
   2      forum_id int(10) unsigned NOT NULL auto_increment,
   3      forum_name varchar(250) NOT NULL default '',
   4      forum_description text NOT NULL,
   5      forum_parent int(10) unsigned NOT NULL default '0',
   6      forum_sub int(10) unsigned NOT NULL default '0',
   7      forum_datestamp int(10) unsigned NOT NULL default '0',
   8      forum_moderators text NOT NULL,
   9      forum_threads int(10) unsigned NOT NULL default '0',
  10      forum_replies int(10) unsigned NOT NULL default '0',
  11      forum_lastpost_user varchar(200) NOT NULL default '',
  12      forum_lastpost_info varchar(40) NOT NULL default '',
  13      forum_class varchar(100) NOT NULL default '',
  14      forum_order int(10) unsigned NOT NULL default '0',
  15      forum_postclass tinyint(3) unsigned NOT NULL default '0',
  16      PRIMARY KEY  (forum_id)
  17      ) TYPE=MyISAM AUTO_INCREMENT=1
  18  
  19  CREATE TABLE forum_t (
  20      thread_id int(10) unsigned NOT NULL auto_increment,
  21      thread_name varchar(250) NOT NULL default '',
  22      thread_thread text NOT NULL,
  23      thread_forum_id int(10) unsigned NOT NULL default '0',
  24      thread_datestamp int(10) unsigned NOT NULL default '0',
  25      thread_parent int(10) unsigned NOT NULL default '0',
  26      thread_user varchar(250) NOT NULL default '',
  27      thread_views int(10) unsigned NOT NULL default '0',
  28      thread_active tinyint(3) unsigned NOT NULL default '0',
  29      thread_lastpost int(10) unsigned NOT NULL default '0',
  30      thread_s tinyint(1) unsigned NOT NULL default '0',
  31      thread_edit_datestamp int(10) unsigned NOT NULL default '0',
  32      thread_lastuser varchar(30) NOT NULL default '',
  33      thread_total_replies int(10) unsigned NOT NULL default '0',
  34      PRIMARY KEY  (thread_id),
  35      KEY thread_parent (thread_parent),
  36      KEY thread_datestamp (thread_datestamp),
  37      KEY thread_forum_id (thread_forum_id)
  38      ) TYPE=MyISAM AUTO_INCREMENT=1;
  39