From bfe5b85dbdab7b0c9f868dcb3beb71848ffbd295 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Tue, 20 Aug 2002 19:29:16 +0000 Subject: - Applied a (modified) version of Marco's SQL sequence patch. --- database/database.mysql | 25 ++++--------------------- 1 file changed, 4 insertions(+), 21 deletions(-) (limited to 'database/database.mysql') diff --git a/database/database.mysql b/database/database.mysql index fa6eba04e..8618128fc 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -93,18 +93,6 @@ CREATE TABLE cache ( PRIMARY KEY (cid) ) 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; # -- cgit v1.2.3