From 8542e2a3f7f0fd542a79908a7cd9f718a38e7d9e Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Mon, 15 Oct 2001 22:23:45 +0000 Subject: - Renamed the SQL update files to be more consistent with the database definitions in the ./database/ directory. And like that we can also start adding .pgsql update files ... --- updates/1.00-to-2.00.mysql | 41 ++++++ updates/1.00-to-2.00.sql | 41 ------ updates/2.00-to-x.xx.mysql | 342 +++++++++++++++++++++++++++++++++++++++++++++ updates/2.00-to-x.xx.sql | 342 --------------------------------------------- updates/3.00-to-x.xx.mysql | 65 +++++++++ updates/3.00-to-x.xx.sql | 65 --------- 6 files changed, 448 insertions(+), 448 deletions(-) create mode 100644 updates/1.00-to-2.00.mysql delete mode 100644 updates/1.00-to-2.00.sql create mode 100644 updates/2.00-to-x.xx.mysql delete mode 100644 updates/2.00-to-x.xx.sql create mode 100644 updates/3.00-to-x.xx.mysql delete mode 100644 updates/3.00-to-x.xx.sql (limited to 'updates') diff --git a/updates/1.00-to-2.00.mysql b/updates/1.00-to-2.00.mysql new file mode 100644 index 000000000..dd9bec7aa --- /dev/null +++ b/updates/1.00-to-2.00.mysql @@ -0,0 +1,41 @@ +# 03/03/2001: FAQ module +CREATE TABLE faqs ( + id int(11) DEFAULT '0' NOT NULL auto_increment, + question varchar(255) DEFAULT '' NOT NULL, + answer text NOT NULL, + weight tinyint(3) DEFAULT '0' NOT NULL, + UNIQUE question (question), + PRIMARY KEY (id) +); + +# 26/02/2001: performance optimization +ALTER TABLE comments ADD INDEX lid_link (lid, link); + +# 19/02/2001: internationalization / translation +alter table users add language varchar(2) DEFAULT '0' NOT NULL; +CREATE TABLE locales ( + id int(11) DEFAULT '0' NOT NULL auto_increment, + location varchar(128) DEFAULT '' NOT NULL, + string TEXT DEFAULT '' NOT NULL, + en TEXT DEFAULT '' NOT NULL, + PRIMARY KEY (id) +); + +# 18/02/2001: permissions / access / group +alter table users drop permissions; +alter table users add access varchar(255) DEFAULT '' NOT NULL; + +# 07/02/2001: value calculation +alter table users add rating decimal(8,4) DEFAULT '0' NOT NULL; + +# 31/01/2001: block rehashing +alter table blocks add remove tinyint(1) DEFAULT '0' NOT NULL; + +# 21/01/2001: section manager +alter table stories change category section varchar(64) DEFAULT '' NOT NULL; + +# 20/01/2001: comment/discussion code rewrite: +alter table users modify mode tinyint(1) DEFAULT '' NOT NULL; +alter table comments change sid lid int(6) DEFAULT '0' NOT NULL; +alter table comments add link varchar(16) DEFAULT '' NOT NULL; +update comments set link = 'article'; diff --git a/updates/1.00-to-2.00.sql b/updates/1.00-to-2.00.sql deleted file mode 100644 index dd9bec7aa..000000000 --- a/updates/1.00-to-2.00.sql +++ /dev/null @@ -1,41 +0,0 @@ -# 03/03/2001: FAQ module -CREATE TABLE faqs ( - id int(11) DEFAULT '0' NOT NULL auto_increment, - question varchar(255) DEFAULT '' NOT NULL, - answer text NOT NULL, - weight tinyint(3) DEFAULT '0' NOT NULL, - UNIQUE question (question), - PRIMARY KEY (id) -); - -# 26/02/2001: performance optimization -ALTER TABLE comments ADD INDEX lid_link (lid, link); - -# 19/02/2001: internationalization / translation -alter table users add language varchar(2) DEFAULT '0' NOT NULL; -CREATE TABLE locales ( - id int(11) DEFAULT '0' NOT NULL auto_increment, - location varchar(128) DEFAULT '' NOT NULL, - string TEXT DEFAULT '' NOT NULL, - en TEXT DEFAULT '' NOT NULL, - PRIMARY KEY (id) -); - -# 18/02/2001: permissions / access / group -alter table users drop permissions; -alter table users add access varchar(255) DEFAULT '' NOT NULL; - -# 07/02/2001: value calculation -alter table users add rating decimal(8,4) DEFAULT '0' NOT NULL; - -# 31/01/2001: block rehashing -alter table blocks add remove tinyint(1) DEFAULT '0' NOT NULL; - -# 21/01/2001: section manager -alter table stories change category section varchar(64) DEFAULT '' NOT NULL; - -# 20/01/2001: comment/discussion code rewrite: -alter table users modify mode tinyint(1) DEFAULT '' NOT NULL; -alter table comments change sid lid int(6) DEFAULT '0' NOT NULL; -alter table comments add link varchar(16) DEFAULT '' NOT NULL; -update comments set link = 'article'; diff --git a/updates/2.00-to-x.xx.mysql b/updates/2.00-to-x.xx.mysql new file mode 100644 index 000000000..7a58c6a08 --- /dev/null +++ b/updates/2.00-to-x.xx.mysql @@ -0,0 +1,342 @@ +# 01/04/2001: +CREATE TABLE access ( + id tinyint(10) DEFAULT '0' NOT NULL auto_increment, + mask varchar(255) DEFAULT '' NOT NULL, + reason text NOT NULL, + UNIQUE mask (mask), + PRIMARY KEY (id) +); + +CREATE TABLE book ( + lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + nid int(10) unsigned DEFAULT '0' NOT NULL, + body text NOT NULL, + section int(10) DEFAULT '0' NOT NULL, + parent int(10) DEFAULT '0' NOT NULL, + weight tinyint(3) DEFAULT '0' NOT NULL, + PRIMARY KEY (lid) +); + +CREATE TABLE story ( + lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + nid int(10) unsigned DEFAULT '0' NOT NULL, + abstract text NOT NULL, + body text NOT NULL, + section varchar(64) DEFAULT '' NOT NULL, + PRIMARY KEY (lid) +); + +CREATE TABLE node ( + nid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + lid int(10) DEFAULT '0' NOT NULL, + pid int(10) DEFAULT '0' NOT NULL, + log text NOT NULL, + type varchar(16) DEFAULT '' NOT NULL, + title varchar(128) DEFAULT '' NOT NULL, + score int(11) DEFAULT '0' NOT NULL, + votes int(11) DEFAULT '0' NOT NULL, + author int(6) DEFAULT '0' NOT NULL, + status int(4) DEFAULT '1' NOT NULL, + timestamp int(11) NOT NULL, + KEY type (lid, type), + KEY author (author), + KEY title (title, type), + PRIMARY KEY (nid) +); + +alter table users change stories nodes tinyint(2) DEFAULT '10'; +alter table comments drop link; + +# 07/04/2001: +CREATE TABLE page ( + lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + nid int(10) unsigned DEFAULT '0' NOT NULL, + body text NOT NULL, + format tinyint(2) DEFAULT '0' NOT NULL, + PRIMARY KEY (lid) +); + +CREATE TABLE variable ( + name varchar(32) DEFAULT '' NOT NULL, + value text DEFAULT '' NOT NULL, + PRIMARY KEY (name) +); + +CREATE TABLE rating ( + user int(6) DEFAULT '0' NOT NULL, + new int(6) DEFAULT '0' NOT NULL, + old int(6) DEFAULT '0' NOT NULL, + PRIMARY KEY (user) +); + +CREATE TABLE watchdog ( + id int(5) DEFAULT '0' NOT NULL auto_increment, + user int(6) DEFAULT '0' NOT NULL, + type varchar(16) DEFAULT '' NOT NULL, + link varchar(16) DEFAULT '' NOT NULL, + message varchar(255) DEFAULT '' NOT NULL, + location varchar(128) DEFAULT '' NOT NULL, + hostname varchar(128) DEFAULT '' NOT NULL, + timestamp int(11) DEFAULT '0' NOT NULL, + PRIMARY KEY (id) +); + +ALTER TABLE users CHANGE rating rating decimal(8,2); + +# 14/04/2001: +ALTER TABLE node ADD cid int(10) unsigned DEFAULT '0' NOT NULL; +ALTER TABLE node ADD tid int(10) unsigned DEFAULT '0' NOT NULL; +ALTER TABLE story DROP section; +ALTER TABLE comments ADD KEY(lid); + +CREATE TABLE category ( + cid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + name varchar(32) DEFAULT '' NOT NULL, + type varchar(16) DEFAULT '' NOT NULL, + post int(3) DEFAULT '0' NOT NULL, + dump int(3) DEFAULT '0' NOT NULL, + expire int(3) DEFAULT '0' NOT NULL, + comment int(2) unsigned DEFAULT '0' NOT NULL, + submission int(2) unsigned DEFAULT '0' NOT NULL, + UNIQUE (name), + PRIMARY KEY (cid) +); + +CREATE TABLE topic ( + tid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + pid int(10) unsigned DEFAULT '0' NOT NULL, + name varchar(32) DEFAULT '' NOT NULL, + UNIQUE (name), + PRIMARY KEY (tid) +); + +# 19/04/2001: +ALTER TABLE node ADD comment int(2) DEFAULT '1' NOT NULL; +ALTER TABLE node ADD promote int(2) DEFAULT '1' NOT NULL; +ALTER TABLE category ADD promote int(2) unsigned DEFAULT '0' NOT NULL; + +CREATE TABLE cvs ( + user varchar(32) DEFAULT '' NOT NULL, + files text, + status int(2) DEFAULT '0' NOT NULL, + message text, + timestamp int(11) DEFAULT '0' NOT NULL +); + +# 27/04/2001: +CREATE TABLE forum ( + lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + nid int(10) unsigned DEFAULT '0' NOT NULL, + body text NOT NULL, + PRIMARY KEY (lid) +); + +# 01/05/2001: +ALTER TABLE node ADD moderate TEXT NOT NULL; + +# 10/05/2001: +ALTER TABLE topic ADD moderate TEXT NOT NULL; + +# 16/05/2001 +ALTER TABLE node ADD users TEXT NOT NULL; +ALTER TABLE comments ADD users TEXT NOT NULL; +ALTER TABLE users DROP history; + +# 19/05/2001 +DROP TABLE crons; + +# 25/05/2001 - TEMPORARY - UNDER HEAVY CHANGE - + +CREATE TABLE entry ( + eid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + name varchar(32) DEFAULT '' NOT NULL, + keyword varchar(255) DEFAULT '' NOT NULL, + collection varchar(32) DEFAULT '' NOT NULL, + UNIQUE name (name, collection), + PRIMARY KEY (eid) +); + +CREATE TABLE bundle ( + bid int(11) DEFAULT '0' NOT NULL auto_increment, + title varchar(255) DEFAULT '' NOT NULL, + attribute varchar(255) DEFAULT '' NOT NULL, + UNIQUE (title), + PRIMARY KEY (bid) +); + +CREATE TABLE feed ( + fid int(11) DEFAULT '0' NOT NULL auto_increment, + title varchar(255) DEFAULT '' NOT NULL, + url varchar(255) DEFAULT '' NOT NULL, + link varchar(255) DEFAULT '' NOT NULL, + refresh int(11), + uncache int(11), + timestamp int(11), + attribute varchar(255) DEFAULT '' NOT NULL, + UNIQUE (title), + UNIQUE (link), + PRIMARY KEY (fid) +); + +CREATE TABLE item ( + iid int(11) DEFAULT '0' NOT NULL auto_increment, + fid int(11) DEFAULT '0' NOT NULL, + title varchar(255) DEFAULT '' NOT NULL, + link varchar(255) DEFAULT '' NOT NULL, + author varchar(255) DEFAULT '' NOT NULL, + description TEXT DEFAULT '' NOT NULL, + timestamp int(11), + attribute varchar(255) DEFAULT '' NOT NULL, + PRIMARY KEY (iid) +); + +# 31/05/01 + +CREATE TABLE poll ( + lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + nid int(10) unsigned DEFAULT '0' NOT NULL, + runtime int(10) DEFAULT '0' NOT NULL, + voters text NOT NULL, + active int(2) unsigned DEFAULT '0' NOT NULL, + PRIMARY KEY (lid) +); + +CREATE TABLE poll_choices ( + chid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + nid int(10) unsigned DEFAULT '0' NOT NULL, + chtext varchar(128) DEFAULT '' NOT NULL, + chvotes int(6) DEFAULT '0' NOT NULL, + chorder int(2) DEFAULT '0' NOT NULL, + PRIMARY KEY (chid) +); + +# 04/06/01 + +ALTER TABLE node ADD timestamp_posted int(11) NOT NULL; +ALTER TABLE node ADD timestamp_queued int(11) NOT NULL; +ALTER TABLE node ADD timestamp_hidden int(11) NOT NULL; +ALTER TABLE node ADD attribute varchar(255) DEFAULT '' NOT NULL; + +# 10/06/01 +ALTER TABLE node DROP cid; +ALTER TABLE node DROP tid; + +# 11/06/01 +UPDATE users SET access = REPLACE(access, ':', '='); +UPDATE users SET access = REPLACE(access, ';', ','); +UPDATE comments SET users = REPLACE(users, ';', ','); +UPDATE comments SET users = REPLACE(users, ':', '='); +UPDATE node SET users = REPLACE(users, ';', ','); +UPDATE node SET users = REPLACE(users, ':', '='); +UPDATE node SET attributes = REPLACE(attributes, ';', ','); +UPDATE node SET attributes = REPLACE(attributes, ':', '='); +UPDATE entry SET attributes = REPLACE(attributes, ';', ','); +UPDATE entry SET attributes = REPLACE(attributes, ':', '='); + +ALTER TABLE entry CHANGE keyword attributes varchar(255) DEFAULT '' NOT NULL; +ALTER TABLE node CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL; +ALTER TABLE bundle CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL; +ALTER TABLE feed CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL; +ALTER TABLE item CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL; + +# 12/06/01 +ALTER TABLE watchdog DROP link; + +# 15/06/01 +CREATE TABLE tag ( + tid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + name varchar(32) DEFAULT '' NOT NULL, + attributes varchar(255) DEFAULT '' NOT NULL, + collections varchar(32) DEFAULT '' NOT NULL, + UNIQUE name (name, collections), + PRIMARY KEY (tid) +); + +CREATE TABLE collection ( + cid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + name varchar(32) DEFAULT '' NOT NULL, + types varchar(128) DEFAULT '' NOT NULL, + UNIQUE name (name), + PRIMARY KEY (cid) +); + +# 17/06/01 +ALTER TABLE book ADD pid int(10) DEFAULT '0' NOT NULL; +ALTER TABLE book ADD log text NOT NULL; +ALTER TABLE node DROP pid; +ALTER TABLE node DROP log; +DROP TABLE headlines; + +# 20/06/01 +CREATE TABLE role ( + rid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + name varchar(32) DEFAULT '' NOT NULL, + perm text DEFAULT '' NOT NULL, + UNIQUE name (name), + PRIMARY KEY (rid) +); + +ALTER TABLE users ADD role varchar(32) DEFAULT '' NOT NULL; +ALTER TABLE users DROP access; +UPDATE users SET role = 'authenticated user'; + +# 23/06/01 +ALTER TABLE users CHANGE userid userid VARCHAR(32) DEFAULT '' NOT NULL; + +# 24/06/01 +CREATE TABLE referer ( + url varchar(255) DEFAULT '' NOT NULL, + timestamp int(11) NOT NULL +); + +# 30/06/01 +ALTER TABLE boxes CHANGE subject title varchar(64) DEFAULT '' NOT NULL; +ALTER TABLE boxes CHANGE content body TEXT; +ALTER TABLE boxes CHANGE id bid tinyint(4) DEFAULT '0' NOT NULL auto_increment; + +CREATE TABLE cache ( + url varchar(255) DEFAULT '' NOT NULL, + data text NOT NULL, + timestamp int(11) NOT NULL, + PRIMARY KEY (url) +); + +# 08/06/01 +CREATE TABLE site ( + sid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + title varchar(128) DEFAULT '' NOT NULL, + url varchar(255) DEFAULT '' NOT NULL, + size text NOT NULL, + timestamp int(11) NOT NULL, + UNIQUE (title), + UNIQUE (url), + PRIMARY KEY (sid) +); + +# 09/06/01 +ALTER TABLE feed CHANGE link url varchar(255) DEFAULT '' NOT NULL; +ALTER TABLE feed ADD link varchar(255) DEFAULT '' NOT NULL; +ALTER TABLE feed ADD description TEXT DEFAULT '' NOT NULL; + +# 12/06/01 +CREATE TABLE blog ( + lid int(10) unsigned NOT NULL auto_increment, + nid int(10) unsigned NOT NULL, + body text NOT NULL, + PRIMARY KEY (lid) +); + +#13/06/01 +ALTER TABLE site CHANGE title name varchar(128) DEFAULT '' NOT NULL; +ALTER TABLE site CHANGE url link varchar(255) DEFAULT '' NOT NULL; +ALTER TABLE site ADD feed varchar(255) DEFAULT '' NOT NULL; + + +#17/06/01 +ALTER TABLE page ADD link varchar(128) DEFAULT '' NOT NULL AFTER nid; + +#09/08/01 +ALTER TABLE users ADD UNIQUE name (name); +ALTER TABLE users ADD UNIQUE userid (userid); +ALTER TABLE users ADD UNIQUE real_email (real_email); +UPDATE users SET name = userid WHERE name = ''; diff --git a/updates/2.00-to-x.xx.sql b/updates/2.00-to-x.xx.sql deleted file mode 100644 index 7a58c6a08..000000000 --- a/updates/2.00-to-x.xx.sql +++ /dev/null @@ -1,342 +0,0 @@ -# 01/04/2001: -CREATE TABLE access ( - id tinyint(10) DEFAULT '0' NOT NULL auto_increment, - mask varchar(255) DEFAULT '' NOT NULL, - reason text NOT NULL, - UNIQUE mask (mask), - PRIMARY KEY (id) -); - -CREATE TABLE book ( - lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - nid int(10) unsigned DEFAULT '0' NOT NULL, - body text NOT NULL, - section int(10) DEFAULT '0' NOT NULL, - parent int(10) DEFAULT '0' NOT NULL, - weight tinyint(3) DEFAULT '0' NOT NULL, - PRIMARY KEY (lid) -); - -CREATE TABLE story ( - lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - nid int(10) unsigned DEFAULT '0' NOT NULL, - abstract text NOT NULL, - body text NOT NULL, - section varchar(64) DEFAULT '' NOT NULL, - PRIMARY KEY (lid) -); - -CREATE TABLE node ( - nid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - lid int(10) DEFAULT '0' NOT NULL, - pid int(10) DEFAULT '0' NOT NULL, - log text NOT NULL, - type varchar(16) DEFAULT '' NOT NULL, - title varchar(128) DEFAULT '' NOT NULL, - score int(11) DEFAULT '0' NOT NULL, - votes int(11) DEFAULT '0' NOT NULL, - author int(6) DEFAULT '0' NOT NULL, - status int(4) DEFAULT '1' NOT NULL, - timestamp int(11) NOT NULL, - KEY type (lid, type), - KEY author (author), - KEY title (title, type), - PRIMARY KEY (nid) -); - -alter table users change stories nodes tinyint(2) DEFAULT '10'; -alter table comments drop link; - -# 07/04/2001: -CREATE TABLE page ( - lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - nid int(10) unsigned DEFAULT '0' NOT NULL, - body text NOT NULL, - format tinyint(2) DEFAULT '0' NOT NULL, - PRIMARY KEY (lid) -); - -CREATE TABLE variable ( - name varchar(32) DEFAULT '' NOT NULL, - value text DEFAULT '' NOT NULL, - PRIMARY KEY (name) -); - -CREATE TABLE rating ( - user int(6) DEFAULT '0' NOT NULL, - new int(6) DEFAULT '0' NOT NULL, - old int(6) DEFAULT '0' NOT NULL, - PRIMARY KEY (user) -); - -CREATE TABLE watchdog ( - id int(5) DEFAULT '0' NOT NULL auto_increment, - user int(6) DEFAULT '0' NOT NULL, - type varchar(16) DEFAULT '' NOT NULL, - link varchar(16) DEFAULT '' NOT NULL, - message varchar(255) DEFAULT '' NOT NULL, - location varchar(128) DEFAULT '' NOT NULL, - hostname varchar(128) DEFAULT '' NOT NULL, - timestamp int(11) DEFAULT '0' NOT NULL, - PRIMARY KEY (id) -); - -ALTER TABLE users CHANGE rating rating decimal(8,2); - -# 14/04/2001: -ALTER TABLE node ADD cid int(10) unsigned DEFAULT '0' NOT NULL; -ALTER TABLE node ADD tid int(10) unsigned DEFAULT '0' NOT NULL; -ALTER TABLE story DROP section; -ALTER TABLE comments ADD KEY(lid); - -CREATE TABLE category ( - cid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - name varchar(32) DEFAULT '' NOT NULL, - type varchar(16) DEFAULT '' NOT NULL, - post int(3) DEFAULT '0' NOT NULL, - dump int(3) DEFAULT '0' NOT NULL, - expire int(3) DEFAULT '0' NOT NULL, - comment int(2) unsigned DEFAULT '0' NOT NULL, - submission int(2) unsigned DEFAULT '0' NOT NULL, - UNIQUE (name), - PRIMARY KEY (cid) -); - -CREATE TABLE topic ( - tid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - pid int(10) unsigned DEFAULT '0' NOT NULL, - name varchar(32) DEFAULT '' NOT NULL, - UNIQUE (name), - PRIMARY KEY (tid) -); - -# 19/04/2001: -ALTER TABLE node ADD comment int(2) DEFAULT '1' NOT NULL; -ALTER TABLE node ADD promote int(2) DEFAULT '1' NOT NULL; -ALTER TABLE category ADD promote int(2) unsigned DEFAULT '0' NOT NULL; - -CREATE TABLE cvs ( - user varchar(32) DEFAULT '' NOT NULL, - files text, - status int(2) DEFAULT '0' NOT NULL, - message text, - timestamp int(11) DEFAULT '0' NOT NULL -); - -# 27/04/2001: -CREATE TABLE forum ( - lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - nid int(10) unsigned DEFAULT '0' NOT NULL, - body text NOT NULL, - PRIMARY KEY (lid) -); - -# 01/05/2001: -ALTER TABLE node ADD moderate TEXT NOT NULL; - -# 10/05/2001: -ALTER TABLE topic ADD moderate TEXT NOT NULL; - -# 16/05/2001 -ALTER TABLE node ADD users TEXT NOT NULL; -ALTER TABLE comments ADD users TEXT NOT NULL; -ALTER TABLE users DROP history; - -# 19/05/2001 -DROP TABLE crons; - -# 25/05/2001 - TEMPORARY - UNDER HEAVY CHANGE - - -CREATE TABLE entry ( - eid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - name varchar(32) DEFAULT '' NOT NULL, - keyword varchar(255) DEFAULT '' NOT NULL, - collection varchar(32) DEFAULT '' NOT NULL, - UNIQUE name (name, collection), - PRIMARY KEY (eid) -); - -CREATE TABLE bundle ( - bid int(11) DEFAULT '0' NOT NULL auto_increment, - title varchar(255) DEFAULT '' NOT NULL, - attribute varchar(255) DEFAULT '' NOT NULL, - UNIQUE (title), - PRIMARY KEY (bid) -); - -CREATE TABLE feed ( - fid int(11) DEFAULT '0' NOT NULL auto_increment, - title varchar(255) DEFAULT '' NOT NULL, - url varchar(255) DEFAULT '' NOT NULL, - link varchar(255) DEFAULT '' NOT NULL, - refresh int(11), - uncache int(11), - timestamp int(11), - attribute varchar(255) DEFAULT '' NOT NULL, - UNIQUE (title), - UNIQUE (link), - PRIMARY KEY (fid) -); - -CREATE TABLE item ( - iid int(11) DEFAULT '0' NOT NULL auto_increment, - fid int(11) DEFAULT '0' NOT NULL, - title varchar(255) DEFAULT '' NOT NULL, - link varchar(255) DEFAULT '' NOT NULL, - author varchar(255) DEFAULT '' NOT NULL, - description TEXT DEFAULT '' NOT NULL, - timestamp int(11), - attribute varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (iid) -); - -# 31/05/01 - -CREATE TABLE poll ( - lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - nid int(10) unsigned DEFAULT '0' NOT NULL, - runtime int(10) DEFAULT '0' NOT NULL, - voters text NOT NULL, - active int(2) unsigned DEFAULT '0' NOT NULL, - PRIMARY KEY (lid) -); - -CREATE TABLE poll_choices ( - chid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - nid int(10) unsigned DEFAULT '0' NOT NULL, - chtext varchar(128) DEFAULT '' NOT NULL, - chvotes int(6) DEFAULT '0' NOT NULL, - chorder int(2) DEFAULT '0' NOT NULL, - PRIMARY KEY (chid) -); - -# 04/06/01 - -ALTER TABLE node ADD timestamp_posted int(11) NOT NULL; -ALTER TABLE node ADD timestamp_queued int(11) NOT NULL; -ALTER TABLE node ADD timestamp_hidden int(11) NOT NULL; -ALTER TABLE node ADD attribute varchar(255) DEFAULT '' NOT NULL; - -# 10/06/01 -ALTER TABLE node DROP cid; -ALTER TABLE node DROP tid; - -# 11/06/01 -UPDATE users SET access = REPLACE(access, ':', '='); -UPDATE users SET access = REPLACE(access, ';', ','); -UPDATE comments SET users = REPLACE(users, ';', ','); -UPDATE comments SET users = REPLACE(users, ':', '='); -UPDATE node SET users = REPLACE(users, ';', ','); -UPDATE node SET users = REPLACE(users, ':', '='); -UPDATE node SET attributes = REPLACE(attributes, ';', ','); -UPDATE node SET attributes = REPLACE(attributes, ':', '='); -UPDATE entry SET attributes = REPLACE(attributes, ';', ','); -UPDATE entry SET attributes = REPLACE(attributes, ':', '='); - -ALTER TABLE entry CHANGE keyword attributes varchar(255) DEFAULT '' NOT NULL; -ALTER TABLE node CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL; -ALTER TABLE bundle CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL; -ALTER TABLE feed CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL; -ALTER TABLE item CHANGE attribute attributes varchar(255) DEFAULT '' NOT NULL; - -# 12/06/01 -ALTER TABLE watchdog DROP link; - -# 15/06/01 -CREATE TABLE tag ( - tid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - name varchar(32) DEFAULT '' NOT NULL, - attributes varchar(255) DEFAULT '' NOT NULL, - collections varchar(32) DEFAULT '' NOT NULL, - UNIQUE name (name, collections), - PRIMARY KEY (tid) -); - -CREATE TABLE collection ( - cid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - name varchar(32) DEFAULT '' NOT NULL, - types varchar(128) DEFAULT '' NOT NULL, - UNIQUE name (name), - PRIMARY KEY (cid) -); - -# 17/06/01 -ALTER TABLE book ADD pid int(10) DEFAULT '0' NOT NULL; -ALTER TABLE book ADD log text NOT NULL; -ALTER TABLE node DROP pid; -ALTER TABLE node DROP log; -DROP TABLE headlines; - -# 20/06/01 -CREATE TABLE role ( - rid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - name varchar(32) DEFAULT '' NOT NULL, - perm text DEFAULT '' NOT NULL, - UNIQUE name (name), - PRIMARY KEY (rid) -); - -ALTER TABLE users ADD role varchar(32) DEFAULT '' NOT NULL; -ALTER TABLE users DROP access; -UPDATE users SET role = 'authenticated user'; - -# 23/06/01 -ALTER TABLE users CHANGE userid userid VARCHAR(32) DEFAULT '' NOT NULL; - -# 24/06/01 -CREATE TABLE referer ( - url varchar(255) DEFAULT '' NOT NULL, - timestamp int(11) NOT NULL -); - -# 30/06/01 -ALTER TABLE boxes CHANGE subject title varchar(64) DEFAULT '' NOT NULL; -ALTER TABLE boxes CHANGE content body TEXT; -ALTER TABLE boxes CHANGE id bid tinyint(4) DEFAULT '0' NOT NULL auto_increment; - -CREATE TABLE cache ( - url varchar(255) DEFAULT '' NOT NULL, - data text NOT NULL, - timestamp int(11) NOT NULL, - PRIMARY KEY (url) -); - -# 08/06/01 -CREATE TABLE site ( - sid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, - title varchar(128) DEFAULT '' NOT NULL, - url varchar(255) DEFAULT '' NOT NULL, - size text NOT NULL, - timestamp int(11) NOT NULL, - UNIQUE (title), - UNIQUE (url), - PRIMARY KEY (sid) -); - -# 09/06/01 -ALTER TABLE feed CHANGE link url varchar(255) DEFAULT '' NOT NULL; -ALTER TABLE feed ADD link varchar(255) DEFAULT '' NOT NULL; -ALTER TABLE feed ADD description TEXT DEFAULT '' NOT NULL; - -# 12/06/01 -CREATE TABLE blog ( - lid int(10) unsigned NOT NULL auto_increment, - nid int(10) unsigned NOT NULL, - body text NOT NULL, - PRIMARY KEY (lid) -); - -#13/06/01 -ALTER TABLE site CHANGE title name varchar(128) DEFAULT '' NOT NULL; -ALTER TABLE site CHANGE url link varchar(255) DEFAULT '' NOT NULL; -ALTER TABLE site ADD feed varchar(255) DEFAULT '' NOT NULL; - - -#17/06/01 -ALTER TABLE page ADD link varchar(128) DEFAULT '' NOT NULL AFTER nid; - -#09/08/01 -ALTER TABLE users ADD UNIQUE name (name); -ALTER TABLE users ADD UNIQUE userid (userid); -ALTER TABLE users ADD UNIQUE real_email (real_email); -UPDATE users SET name = userid WHERE name = ''; diff --git a/updates/3.00-to-x.xx.mysql b/updates/3.00-to-x.xx.mysql new file mode 100644 index 000000000..9d29dfb03 --- /dev/null +++ b/updates/3.00-to-x.xx.mysql @@ -0,0 +1,65 @@ + +ALTER TABLE boxes DROP link; + +ALTER TABLE users RENAME AS user; +ALTER TABLE user DROP INDEX real_email; +ALTER TABLE user DROP fake_email; +ALTER TABLE user DROP nodes; +ALTER TABLE user DROP bio; +ALTER TABLE user DROP hash; +ALTER TABLE user ADD session varchar(32) DEFAULT '' NOT NULL; +ALTER TABLE user ADD jabber varchar(128) DEFAULT '' NULL; +ALTER TABLE user ADD drupal varchar(128) DEFAULT '' NULL; +ALTER TABLE user ADD init varchar(64) DEFAULT '' NULL; +ALTER TABLE user CHANGE passwd pass varchar(24) DEFAULT '' NOT NULL; +ALTER TABLE user CHANGE real_email mail varchar(64) DEFAULT '' NULL; +ALTER TABLE user CHANGE last_access timestamp int(11) DEFAULT '0' NOT NULL; +ALTER TABLE user CHANGE last_host hostname varchar(128) DEFAULT '' NOT NULL; +ALTER TABLE user CHANGE id uid int(10) unsigned DEFAULT '0' NOT NULL auto_increment; +ALTER TABLE user CHANGE url homepage varchar(128) DEFAULT '' NOT NULL; +UPDATE user SET status = 1 WHERE status = 2; +UPDATE user SET name = userid; +ALTER TABLE user DROP userid; +UPDATE user SET init = mail; + +DROP TABLE access; + +CREATE TABLE access ( + aid tinyint(10) DEFAULT '0' NOT NULL auto_increment, + mask varchar(255) DEFAULT '' NOT NULL, + type varchar(255) DEFAULT '' NOT NULL, + status tinyint(2) DEFAULT '0' NOT NULL, + UNIQUE mask (mask), + PRIMARY KEY (aid) +); + +CREATE TABLE moderate ( + cid int(10) DEFAULT '0' NOT NULL, + nid int(10) DEFAULT '0' NOT NULL, + uid int(10) DEFAULT '0' NOT NULL, + score int(2) DEFAULT '0' NOT NULL, + timestamp int(11) DEFAULT '0' NOT NULL, + INDEX (cid), + INDEX (nid) +); + +ALTER TABLE comments DROP score; +ALTER TABLE comments DROP votes; +ALTER TABLE comments DROP users; + +# PEAR + +ALTER TABLE user RENAME AS users; +ALTER TABLE users CHANGE pass pass varchar(32) DEFAULT '' NOT NULL; +ALTER TABLE watchdog CHANGE user userid int(10) DEFAULT '0' NOT NULL; +ALTER TABLE rating CHANGE user userid int(10) DEFAULT '0' NOT NULL; +ALTER TABLE layout CHANGE user userid int(10) DEFAULT '0' NOT NULL; +ALTER TABLE blocks CHANGE offset delta tinyint(2) DEFAULT '0' NOT NULL; + +# 14/10/01 + +ALTER TABLE watchdog CHANGE id wid int(5) DEFAULT '0' NOT NULL auto_increment; +ALTER TABLE watchdog CHANGE userid uid int(10) DEFAULT '0' NOT NULL; +ALTER TABLE layout CHANGE userid uid int(10) DEFAULT '0' NOT NULL; +ALTER TABLE rating CHANGE userid uid int(10) DEFAULT '0' NOT NULL; +ALTER TABLE locales CHANGE id lid int(10) DEFAULT '0' NOT NULL; diff --git a/updates/3.00-to-x.xx.sql b/updates/3.00-to-x.xx.sql deleted file mode 100644 index 9d29dfb03..000000000 --- a/updates/3.00-to-x.xx.sql +++ /dev/null @@ -1,65 +0,0 @@ - -ALTER TABLE boxes DROP link; - -ALTER TABLE users RENAME AS user; -ALTER TABLE user DROP INDEX real_email; -ALTER TABLE user DROP fake_email; -ALTER TABLE user DROP nodes; -ALTER TABLE user DROP bio; -ALTER TABLE user DROP hash; -ALTER TABLE user ADD session varchar(32) DEFAULT '' NOT NULL; -ALTER TABLE user ADD jabber varchar(128) DEFAULT '' NULL; -ALTER TABLE user ADD drupal varchar(128) DEFAULT '' NULL; -ALTER TABLE user ADD init varchar(64) DEFAULT '' NULL; -ALTER TABLE user CHANGE passwd pass varchar(24) DEFAULT '' NOT NULL; -ALTER TABLE user CHANGE real_email mail varchar(64) DEFAULT '' NULL; -ALTER TABLE user CHANGE last_access timestamp int(11) DEFAULT '0' NOT NULL; -ALTER TABLE user CHANGE last_host hostname varchar(128) DEFAULT '' NOT NULL; -ALTER TABLE user CHANGE id uid int(10) unsigned DEFAULT '0' NOT NULL auto_increment; -ALTER TABLE user CHANGE url homepage varchar(128) DEFAULT '' NOT NULL; -UPDATE user SET status = 1 WHERE status = 2; -UPDATE user SET name = userid; -ALTER TABLE user DROP userid; -UPDATE user SET init = mail; - -DROP TABLE access; - -CREATE TABLE access ( - aid tinyint(10) DEFAULT '0' NOT NULL auto_increment, - mask varchar(255) DEFAULT '' NOT NULL, - type varchar(255) DEFAULT '' NOT NULL, - status tinyint(2) DEFAULT '0' NOT NULL, - UNIQUE mask (mask), - PRIMARY KEY (aid) -); - -CREATE TABLE moderate ( - cid int(10) DEFAULT '0' NOT NULL, - nid int(10) DEFAULT '0' NOT NULL, - uid int(10) DEFAULT '0' NOT NULL, - score int(2) DEFAULT '0' NOT NULL, - timestamp int(11) DEFAULT '0' NOT NULL, - INDEX (cid), - INDEX (nid) -); - -ALTER TABLE comments DROP score; -ALTER TABLE comments DROP votes; -ALTER TABLE comments DROP users; - -# PEAR - -ALTER TABLE user RENAME AS users; -ALTER TABLE users CHANGE pass pass varchar(32) DEFAULT '' NOT NULL; -ALTER TABLE watchdog CHANGE user userid int(10) DEFAULT '0' NOT NULL; -ALTER TABLE rating CHANGE user userid int(10) DEFAULT '0' NOT NULL; -ALTER TABLE layout CHANGE user userid int(10) DEFAULT '0' NOT NULL; -ALTER TABLE blocks CHANGE offset delta tinyint(2) DEFAULT '0' NOT NULL; - -# 14/10/01 - -ALTER TABLE watchdog CHANGE id wid int(5) DEFAULT '0' NOT NULL auto_increment; -ALTER TABLE watchdog CHANGE userid uid int(10) DEFAULT '0' NOT NULL; -ALTER TABLE layout CHANGE userid uid int(10) DEFAULT '0' NOT NULL; -ALTER TABLE rating CHANGE userid uid int(10) DEFAULT '0' NOT NULL; -ALTER TABLE locales CHANGE id lid int(10) DEFAULT '0' NOT NULL; -- cgit v1.2.3