[Sommaire] [Imprimer]

   1  ALTER TABLE userinfo MODIFY uid mediumint DEFAULT '-1' NOT NULL;
   2  ALTER TABLE userinfo ADD userspace varchar(255) DEFAULT '' NOT NULL;
   3  ALTER TABLE userinfo ADD tokens tinyint unsigned DEFAULT '0' NOT NULL;
   4  ALTER TABLE userinfo ADD totalcomments mediumint DEFAULT '0' NOT NULL;
   5  ALTER TABLE userinfo ADD lastgranted int unsigned DEFAULT '0' NOT NULL;
   6  ALTER TABLE userprefs DROP emailstories;
   7  ALTER TABLE userprefs MODIFY uid mediumint DEFAULT '-1' NOT NULL;
   8  ALTER TABLE userprefs ADD emailstories tinyint DEFAULT '1' NOT NULL;
   9  ALTER TABLE userprefs ADD noicons tinyint unsigned DEFAULT '0' NOT NULL;
  10  ALTER TABLE userprefs ADD willing tinyint unsigned DEFAULT '1' NOT NULL;
  11  ALTER TABLE userprefs ADD dfid tinyint unsigned DEFAULT '0' NOT NULL;
  12  ALTER TABLE userprefs ADD tzid char(3) DEFAULT 'edt' NOT NULL;
  13  ALTER TABLE users ADD sig varchar(160) DEFAULT '' NOT NULL;
  14  ALTER TABLE users MODIFY passwd char(32) DEFAULT '' NOT NULL;
  15  ALTER TABLE users MODIFY seclev tinyint DEFAULT 0 NOT NULL;
  16  ALTER TABLE users MODIFY username varchar(16) DEFAULT '' NOT NULL;
  17  ALTER TABLE users ADD INDEX LOGIN (uid,passwd,username);
  18  ALTER TABLE stories ADD commentcode tinyint DEFAULT '0' NOT NULL;
  19  ALTER TABLE stories ADD statuscode tinyint DEFAULT '0' NOT NULL;
  20  ALTER TABLE stories ADD postmode char(10) DEFAULT 'html' NOT NULL;
  21  ALTER TABLE storysubmission ADD postmode char(10) DEFAULT 'html' NOT NULL;
  22  ALTER TABLE pollquestions ADD commentcode tinyint DEFAULT '0' NOT NULL;
  23  ALTER TABLE pollquestions ADD statuscode tinyint DEFAULT '0' NOT NULL;
  24  
  25  INSERT INTO vars VALUES ('totalhits','383');
  26  INSERT INTO userprefs (uid) SELECT (uid) from users;
  27  INSERT INTO userinfo (uid) SELECT (uid) from users;
  28  
  29  CREATE TABLE usercomment (
  30    uid mediumint(8) DEFAULT '0' NOT NULL,
  31    commentmode varchar(10) DEFAULT 'threaded' NOT NULL,
  32    commentorder char(4) DEFAULT 'ASC' NOT NULL,
  33    commentlimit mediumint unsigned DEFAULT '100' NOT NULL,
  34    PRIMARY KEY (uid)
  35  );
  36  
  37  INSERT INTO usercomment (uid) SELECT (uid) from users;
  38  
  39  CREATE TABLE userindex (
  40    uid mediumint(8) DEFAULT '0' NOT NULL,
  41    tids varchar(255) DEFAULT '' NOT NULL,
  42    aids varchar(255) DEFAULT '' NOT NULL,
  43    boxes varchar(255) DEFAULT '' NOT NULL,
  44    noboxes tinyint DEFAULT '0' NOT NULL,
  45    maxstories tinyint DEFAULT '10' NOT NULL,
  46    PRIMARY KEY (uid)
  47  );
  48  
  49  INSERT INTO userindex (uid) SELECT (uid) from users;
  50  
  51  CREATE TABLE commentcodes (
  52    code tinyint DEFAULT '' NOT NULL,
  53    name varchar(32),
  54    PRIMARY KEY (code)
  55  );
  56  
  57  INSERT INTO commentcodes VALUES (0,'Comments Enabled');
  58  INSERT INTO commentcodes VALUES (1,'Read-Only');
  59  INSERT INTO commentcodes VALUES (-1,'Comments Disabled');
  60  
  61  CREATE TABLE featurecodes (
  62    code tinyint DEFAULT '' NOT NULL,
  63    name varchar(32),
  64    PRIMARY KEY (code)
  65  );
  66  
  67  INSERT INTO featurecodes VALUES (0,'Not Featured');
  68  INSERT INTO featurecodes VALUES (1,'Featured');
  69  
  70  CREATE TABLE commentmodes (
  71    mode varchar(10) DEFAULT '' NOT NULL,
  72    name varchar(32),
  73    PRIMARY KEY (mode)
  74  );
  75  
  76  INSERT INTO commentmodes VALUES ('flat','Flat');
  77  INSERT INTO commentmodes VALUES ('nested','Nested');
  78  INSERT INTO commentmodes VALUES ('threaded','Threaded');
  79  INSERT INTO commentmodes VALUES ('nocomment','No Comments');
  80  
  81  CREATE TABLE dateformats (
  82    dfid tinyint DEFAULT '0' NOT NULL,
  83    format varchar(32),
  84    description varchar(64),
  85    PRIMARY KEY (dfid)
  86  );
  87  
  88  INSERT INTO dateformats VALUES (0,'','System Default');
  89  INSERT INTO dateformats VALUES (1,'%A %B %d, %Y @%I:%M%p','Sunday March 21, 1999 @10:00PM');
  90  INSERT INTO dateformats VALUES (2,'%A %b %d, %Y @%H:%M','Sunday March 21, 1999 @22:00');
  91  INSERT INTO dateformats VALUES (3,'%A %B %d @%I:%M%p','Sunday March 21 @10:00PM');
  92  INSERT INTO dateformats VALUES (4,'%A %b %d @%H:%M','Sunday March 21 @22:00');
  93  INSERT INTO dateformats VALUES (5,'%H:%M %d %B %Y','22:00 21 March 1999');
  94  INSERT INTO dateformats VALUES (6,'%H:%M %A %d %B %Y','22:00 Sunday 21 March 1999');
  95  INSERT INTO dateformats VALUES (7,'%I:%M%p - %A %B %d %Y','10:00PM -- Sunday March 21 1999');
  96  INSERT INTO dateformats VALUES (8,'%a %B %d, %I:%M%p','Sun March 21, 10:00PM');
  97  INSERT INTO dateformats VALUES (9,'%a %B %d, %H:%M','Sun March 21, 22:00');
  98  INSERT INTO dateformats VALUES (10,'%m-%d-%y %H:%M','3-21-99 22:00');
  99  INSERT INTO dateformats VALUES (11,'%d-%m-%y %H:%M','21-3-99 22:00');
 100  INSERT INTO dateformats VALUES (12,'%m-%d-%y %I:%M%p','3-21-99 10:00PM');
 101  INSERT INTO dateformats VALUES (13,'%I:%M%p  %B %D, %Y','10:00PM  March 21st, 1999');
 102  INSERT INTO dateformats VALUES (14,'%a %b %d, \'%y %I:%M%p','Sun Mar 21, \'99 10:00PM');
 103  INSERT INTO dateformats VALUES (15,'Day %j, %I ish','Day 80, 10 ish');
 104  INSERT INTO dateformats VALUES (16,'%y-%m-%d %I:%M','99-03-21 10:00');
 105  INSERT INTO dateformats VALUES (17,'%d/%m/%y %H:%M','21/03/99 22:00');
 106  INSERT INTO dateformats VALUES (18,'%a %d %b %I:%M%p','Sun 21 Mar 10:00PM');
 107  
 108  CREATE TABLE maillist (
 109    code int(1) DEFAULT '0' NOT NULL,
 110    name char(32),
 111    PRIMARY KEY (code)
 112  );
 113  
 114  INSERT INTO maillist VALUES (0,'Don\'t Email');
 115  INSERT INTO maillist VALUES (1,'Email Headlines Each Night');
 116  
 117  CREATE TABLE postmodes (
 118    code char(10) DEFAULT '' NOT NULL,
 119    name char(32),
 120    PRIMARY KEY (code)
 121  );
 122  
 123  INSERT INTO postmodes VALUES ('html','HTML Formatted');
 124  INSERT INTO postmodes VALUES ('plaintext','Plain Old Text');
 125  
 126  CREATE TABLE sortcodes (
 127    code char(4) DEFAULT '0' NOT NULL,
 128    name char(32),
 129    PRIMARY KEY (code)
 130  );
 131  
 132  INSERT INTO sortcodes VALUES ('ASC','Oldest First');
 133  INSERT INTO sortcodes VALUES ('DESC','Newest First');
 134  
 135  CREATE TABLE statuscodes (
 136    code int(1) DEFAULT '0' NOT NULL,
 137    name char(32),
 138    PRIMARY KEY (code)
 139  );
 140  
 141  INSERT INTO statuscodes VALUES (1,'Refreshing');
 142  INSERT INTO statuscodes VALUES (0,'Normal');
 143  INSERT INTO statuscodes VALUES (10,'Archive');
 144  
 145  CREATE TABLE tzcodes (
 146    tz char(3) DEFAULT '' NOT NULL,
 147    offset int(1),
 148    description varchar(64),
 149    PRIMARY KEY (tz)
 150  );
 151  
 152  INSERT INTO tzcodes VALUES ('ndt',-9000,'Newfoundland Daylight');
 153  INSERT INTO tzcodes VALUES ('adt',-10800,'Atlantic Daylight');
 154  INSERT INTO tzcodes VALUES ('edt',-14400,'Eastern Daylight');
 155  INSERT INTO tzcodes VALUES ('cdt',-18000,'Central Daylight');
 156  INSERT INTO tzcodes VALUES ('mdt',-21600,'Mountain Daylight');
 157  INSERT INTO tzcodes VALUES ('pdt',-25200,'Pacific Daylight');
 158  INSERT INTO tzcodes VALUES ('ydt',-28800,'Yukon Daylight');
 159  INSERT INTO tzcodes VALUES ('hdt',-32400,'Hawaii Daylight');
 160  INSERT INTO tzcodes VALUES ('bst',3600,'British Summer');
 161  INSERT INTO tzcodes VALUES ('mes',7200,'Middle European Summer');
 162  INSERT INTO tzcodes VALUES ('sst',7200,'Swedish Summer');
 163  INSERT INTO tzcodes VALUES ('fst',7200,'French Summer');
 164  INSERT INTO tzcodes VALUES ('wad',28800,'West Australian Daylight');
 165  INSERT INTO tzcodes VALUES ('cad',37800,'Central Australian Daylight');
 166  INSERT INTO tzcodes VALUES ('ead',39600,'Eastern Australian Daylight');
 167  INSERT INTO tzcodes VALUES ('nzd',46800,'New Zealand Daylight');
 168  INSERT INTO tzcodes VALUES ('gmt',0,'Greenwich Mean');
 169  INSERT INTO tzcodes VALUES ('utc',0,'Universal (Coordinated)');
 170  INSERT INTO tzcodes VALUES ('wet',0,'Western European');
 171  INSERT INTO tzcodes VALUES ('wat',-3600,'West Africa');
 172  INSERT INTO tzcodes VALUES ('at',-7200,'Azores');
 173  INSERT INTO tzcodes VALUES ('gst',-10800,'Greenland Standard');
 174  INSERT INTO tzcodes VALUES ('nft',-12600,'Newfoundland');
 175  INSERT INTO tzcodes VALUES ('nst',-12600,'Newfoundland Standard');
 176  INSERT INTO tzcodes VALUES ('ast',-14400,'Atlantic Standard');
 177  INSERT INTO tzcodes VALUES ('est',-18000,'Eastern Standard');
 178  INSERT INTO tzcodes VALUES ('cst',-21600,'Central Standard');
 179  INSERT INTO tzcodes VALUES ('mst',-25200,'Mountain Standard');
 180  INSERT INTO tzcodes VALUES ('pst',-28800,'Pacific Standard');
 181  INSERT INTO tzcodes VALUES ('yst',-32400,'Yukon Standard');
 182  INSERT INTO tzcodes VALUES ('hst',-36000,'Hawaii Standard');
 183  INSERT INTO tzcodes VALUES ('cat',-36000,'Central Alaska');
 184  INSERT INTO tzcodes VALUES ('ahs',-36000,'Alaska-Hawaii Standard');
 185  INSERT INTO tzcodes VALUES ('nt',-39600,'Nome');
 186  INSERT INTO tzcodes VALUES ('idl',-43200,'International Date Line West');
 187  INSERT INTO tzcodes VALUES ('cet',3600,'Central European');
 188  INSERT INTO tzcodes VALUES ('met',3600,'Middle European');
 189  INSERT INTO tzcodes VALUES ('mew',3600,'Middle European Winter');
 190  INSERT INTO tzcodes VALUES ('swt',3600,'Swedish Winter');
 191  INSERT INTO tzcodes VALUES ('fwt',3600,'French Winter');
 192  INSERT INTO tzcodes VALUES ('eet',7200,'Eastern Europe, USSR Zone 1');
 193  INSERT INTO tzcodes VALUES ('bt',10800,'Baghdad, USSR Zone 2');
 194  INSERT INTO tzcodes VALUES ('it',12600,'Iran');
 195  INSERT INTO tzcodes VALUES ('zp4',14400,'USSR Zone 3');
 196  INSERT INTO tzcodes VALUES ('zp5',18000,'USSR Zone 4');
 197  INSERT INTO tzcodes VALUES ('ist',19800,'Indian Standard');
 198  INSERT INTO tzcodes VALUES ('zp6',21600,'USSR Zone 5');
 199  INSERT INTO tzcodes VALUES ('was',25200,'West Australian Standard');
 200  INSERT INTO tzcodes VALUES ('jt',27000,'Java (3pm in Cronusland!)');
 201  INSERT INTO tzcodes VALUES ('cct',28800,'China Coast, USSR Zone 7');
 202  INSERT INTO tzcodes VALUES ('jst',32400,'Japan Standard, USSR Zone 8');
 203  INSERT INTO tzcodes VALUES ('cas',34200,'Central Australian Standard');
 204  INSERT INTO tzcodes VALUES ('eas',36000,'Eastern Australian Standard');
 205  INSERT INTO tzcodes VALUES ('nzt',43200,'New Zealand');
 206  INSERT INTO tzcodes VALUES ('nzs',43200,'New Zealand Standard');
 207  INSERT INTO tzcodes VALUES ('id2',43200,'International Date Line East');
 208  INSERT INTO tzcodes VALUES ('idt',10800,'Israel Daylight');
 209  INSERT INTO tzcodes VALUES ('iss',7200,'Israel Standard');