[Sommaire] [Imprimer]

   1  CREATE TABLE frontpagecodes (
   2    code tinyint(4) DEFAULT '0' NOT NULL,
   3    name varchar(32),
   4    PRIMARY KEY (code)
   5  );
   6  
   7  CREATE TABLE sessions (
   8    sess_id int(10) unsigned DEFAULT '0' NOT NULL,
   9    start_time int(10) unsigned DEFAULT '0' NOT NULL,
  10    remote_ip varchar(15) DEFAULT '' NOT NULL,
  11    uid mediumint(8) DEFAULT '1' NOT NULL,
  12    md5_sess_id varchar(128),
  13    PRIMARY KEY (sess_id),
  14    KEY sess_id (sess_id),
  15    KEY start_time (start_time),
  16    KEY remote_ip (remote_ip)
  17  );
  18  
  19  CREATE TABLE userevent (
  20    uid mediumint(8) DEFAULT '1' NOT NULL,
  21    eid varchar(20) DEFAULT '' NOT NULL,
  22    PRIMARY KEY (uid,eid)
  23  );
  24  
  25  ALTER TABLE userindex MODIFY maxstories tinyint(4);
  26  ALTER TABLE stories ADD frontpage tinyint(3) unsigned DEFAULT '0';
  27  ALTER TABLE topics ADD sortnum tinyint(3);
  28  ALTER TABLE topics ADD limitnews tinyint(3);
  29  INSERT INTO frontpagecodes VALUES (0,'Show Only in Topic');
  30  INSERT INTO frontpagecodes VALUES (1,'Show on Front Page');
  31  UPDATE stories SET frontpage = 1;