- Applied a (modified) version of Marco's SQL sequence patch.

1 files changed, 4 insertions, 21 deletions

diff --git a/database/database.mysql b/database/database.mysql
index fa6eba04e..8618128fc 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -94,18 +94,6 @@ CREATE TABLE cache (
 ) TYPE=MyISAM;
 
 #
-# Table structure for table 'collection'
-#
-
-CREATE TABLE collection (
-  cid int(10) unsigned NOT NULL auto_increment,
-  name varchar(32) NOT NULL default '',
-  types varchar(128) NOT NULL default '',
-  PRIMARY KEY  (cid),
-  UNIQUE KEY name (name)
-) TYPE=MyISAM;
-
-#
 # Table structure for table 'comments'
 #
 
@@ -385,19 +373,14 @@ CREATE TABLE system (
   description varchar(255) NOT NULL default '',
   status int(2) NOT NULL default '0',
   PRIMARY KEY  (filename)
-) TYPE=MyISAM;
 
 #
-# Table structure for table 'tag'
+# Table structure for table 'sequences'
 #
 
-CREATE TABLE tag (
-  tid int(10) unsigned NOT NULL auto_increment,
-  name varchar(32) NOT NULL default '',
-  attributes varchar(255) NOT NULL default '',
-  collections varchar(32) NOT NULL default '',
-  PRIMARY KEY  (tid),
-  UNIQUE KEY name (name,collections)
+CREATE TABLE sequences (
+  name VARCHAR(255) NOT NULL PRIMARY KEY,
+  id INT UNSIGNED NOT NULL
 ) TYPE=MyISAM;
 
 #