summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorDries Buytaert2001-09-09 16:52:31 +0000
committerDries Buytaert2001-09-09 16:52:31 +0000
commit9fc5727c0823d8d3300ba5aae3328d5998033e45 (patch)
tree4b825dc642cb6eb9a060e54bf8d69288fbee4904
parentb0bfccfad2915d59bf192d779ca42301cbdaa833 (diff)
- Renamed the SQL upgrade script.3-00
-rw-r--r--updates/2.00-to-x.xx.sql342
1 files changed, 0 insertions, 342 deletions
diff --git a/updates/2.00-to-x.xx.sql b/updates/2.00-to-x.xx.sql
deleted file mode 100644
index 7a58c6a..0000000
--- 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 = '';