[Sommaire] [Imprimer]

   1  ALTER TABLE links MODIFY lid varchar(20) DEFAULT '' NOT NULL;
   2  ALTER TABLE links MODIFY hits int(11) DEFAULT '0' NOT NULL;
   3  ALTER TABLE comments ADD uid mediumint(8) DEFAULT '-1' NOT NULL;
   4  ALTER TABLE comments DROP name;
   5  ALTER TABLE comments DROP email;
   6  ALTER TABLE comments DROP url;
   7  ALTER TABLE stories DROP author;
   8  ALTER TABLE stories DROP authoremail;
   9  ALTER TABLE stories DROP authorurl;
  10  ALTER TABLE stories MODIFY uid mediumint(8) DEFAULT '-1' NOT NULL;
  11  ALTER TABLE users MODIFY uid mediumint(8) DEFAULT '-1' NOT NULL auto_increment;
  12  INSERT INTO users VALUES (-1,'Anonymous','Anonymous',NULL,NULL,NULL,NULL);
  13  INSERT INTO blocks VALUES (0,'blockheader','all',255,0,'layout','','0000-00-00 00:00:00','<table border=0 cellpadding=1 cellspacing=0 width=\"100%\"><tr bgcolor=666666><td>\r\n<table width=\"100%\" border=0 cellspacing=0 cellpadding=2>\r\n<tr bgcolor=666666><td class=blocktitle>%title</td><td align=right>%help</td></tr>\r\n<tr><td bgcolor=FFFFFF colspan=2>');
  14  INSERT INTO blocks VALUES (0,'blockfooter','all',255,0,'layout','','0000-00-00 00:00:00','</td></tr></table>\r\n</td></tr></table><br>');
  15  
  16  CREATE TABLE eventsubmission (
  17    eid varchar(20) DEFAULT '' NOT NULL,
  18    title varchar(128),
  19    description text,
  20    location text,
  21    datestart date,
  22    dateend date,
  23    url varchar(128),
  24    PRIMARY KEY (eid)
  25  );
  26  
  27  CREATE TABLE linksubmission (
  28    lid varchar(20) DEFAULT '' NOT NULL,
  29    category varchar(32),
  30    url varchar(96),
  31    description text,
  32    title varchar(96),
  33    hits int(11),
  34    PRIMARY KEY (lid)
  35  );
  36  
  37  CREATE TABLE storysubmission (
  38    sid varchar(20) DEFAULT '' NOT NULL,
  39    uid mediumint(8) DEFAULT '-1' NOT NULL,
  40    tid varchar(20) DEFAULT 'General' NOT NULL,
  41    title varchar(128),
  42    introtext text,
  43    date datetime,
  44    PRIMARY KEY (sid)
  45  );
  46  
  47  CREATE TABLE vars (
  48    name varchar(20) DEFAULT '' NOT NULL,
  49    value varchar(128),
  50    PRIMARY KEY (name)
  51  );
  52  
  53  CREATE TABLE userinfo (
  54    uid mediumint(8) unsigned DEFAULT '0' NOT NULL,
  55    about text,
  56    pgpkey text,
  57    PRIMARY KEY (uid)
  58  );
  59  
  60  CREATE TABLE userprefs (
  61    uid mediumint(8) unsigned DEFAULT '0' NOT NULL,
  62    emailstories tinyint(3),
  63    PRIMARY KEY (uid)
  64  );
  65  
  66  CREATE TABLE submitspeedlimit (
  67    id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  68    ipaddress varchar(15) DEFAULT '' NOT NULL,
  69    date int(10) unsigned,
  70    PRIMARY KEY (id)
  71  );
  72  
  73  CREATE TABLE commentspeedlimit (
  74    id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  75    ipaddress varchar(15) DEFAULT '' NOT NULL,
  76    date int(10) unsigned,
  77    PRIMARY KEY (id)
  78  );