From 07cccc9e552a066ad3178814b9edd42b0bf0d2c4 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Sat, 3 Mar 2001 15:27:00 +0000 Subject: - renamed upgrade file --- updates/1.00-to-1.xx | 31 ------------------------------- updates/1.00-to-2.00 | 41 +++++++++++++++++++++++++++++++++++++++++ 2 files changed, 41 insertions(+), 31 deletions(-) delete mode 100644 updates/1.00-to-1.xx create mode 100644 updates/1.00-to-2.00 diff --git a/updates/1.00-to-1.xx b/updates/1.00-to-1.xx deleted file mode 100644 index 98209523b..000000000 --- a/updates/1.00-to-1.xx +++ /dev/null @@ -1,31 +0,0 @@ -# 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 b/updates/1.00-to-2.00 new file mode 100644 index 000000000..dd9bec7aa --- /dev/null +++ b/updates/1.00-to-2.00 @@ -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'; -- cgit v1.2.3