1 files changed, 3 insertions, 34 deletions
diff --git a/updates/2.00-to-x.xx.sql b/updates/2.00-to-x.xx.sql
index 1b10a887a..5a94039e7 100644
--- a/updates/2.00-to-x.xx.sql
+++ b/updates/2.00-to-x.xx.sql
@@ -1,4 +1,7 @@
 # 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;
+
 CREATE TABLE category (
   cid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
   name varchar(32) DEFAULT '' NOT NULL,
@@ -20,40 +23,6 @@ CREATE TABLE topic (
   PRIMARY KEY (tid)
 );
 
-CREATE TABLE node_category (
-  cid int(10) unsigned DEFAULT '0' NOT NULL,
-  nid int(10) unsigned DEFAULT '0' NOT NULL,
-  PRIMARY KEY (cid, nid)
-);
-
-CREATE TABLE node_topic (
-  tid int(10) unsigned DEFAULT '0' NOT NULL,
-  nid int(10) unsigned DEFAULT '0' NOT NULL,
-  PRIMARY KEY (tid, nid)
-);
-
-///// revise
-
-CREATE TABLE section (
-  sid 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 (sid)
-);
-
-CREATE TABLE section_type (
-  sid int(10) unsigned DEFAULT '0' NOT NULL,
-  type varchar(16) DEFAULT '' NOT NULL,
-  PRIMARY KEY (sid, type)
-);
-
-CREATE TABLE section_node (
-  sid int(10) unsigned DEFAULT '0' NOT NULL,
-  nid int(10) unsigned DEFAULT '0' NOT NULL,
-  PRIMARY KEY (sid, nid)
-);
-
 # 07/04/2001:
 CREATE TABLE page (
   lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,