1 files changed, 40 insertions, 0 deletions
diff --git a/updates/2.00-to-x.xx.sql b/updates/2.00-to-x.xx.sql
new file mode 100644
index 000000000..2fdb0bdcb
--- /dev/null
+++ b/updates/2.00-to-x.xx.sql
@@ -0,0 +1,40 @@
+# 25/03/2001:
+CREATE TABLE book (
+  id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
+  node 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 (id)
+);
+
+CREATE TABLE story (
+  id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
+  node int(10) unsigned DEFAULT '0' NOT NULL,
+  abstract text NOT NULL,
+  body text NOT NULL,
+  section varchar(64) DEFAULT '' NOT NULL,
+  PRIMARY KEY (id)
+);
+
+CREATE TABLE nodes (
+  nid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
+  lid int(6) DEFAULT '0' NOT NULL,
+  pid int(6) 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 type;