From 7bdca92aadf956a3e4e65815fbdcccad2f791802 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Wed, 19 Jan 2005 16:22:52 +0000 Subject: - Patch #6847 by Gerhard: replaced vocabulary->nodes by a separate table and tidied up the taxonomy API a bit. This fixes a number of issues. --- database/database.mysql | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'database/database.mysql') diff --git a/database/database.mysql b/database/database.mysql index 18e9731e3..3a02be088 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -749,11 +749,20 @@ CREATE TABLE vocabulary ( hierarchy tinyint(3) unsigned NOT NULL default '0', multiple tinyint(3) unsigned NOT NULL default '0', required tinyint(3) unsigned NOT NULL default '0', - nodes longtext, weight tinyint(4) NOT NULL default '0', PRIMARY KEY (vid) ) TYPE=MyISAM; +-- +-- Table structure for table 'vocabulary_node_types' +-- + +CREATE TABLE vocabulary_node_types ( + vid int(10) unsigned NOT NULL DEFAULT '0', + type varchar(16) NOT NULL DEFAULT '', + PRIMARY KEY (vid, type) +) TYPE=MyISAM; + -- -- Table structure for table 'watchdog' -- -- cgit v1.2.3