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.pgsql | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'database/database.pgsql') diff --git a/database/database.pgsql b/database/database.pgsql index 7e312e54c..d2d807f24 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -736,11 +736,20 @@ CREATE TABLE vocabulary ( hierarchy smallint NOT NULL default '0', multiple smallint NOT NULL default '0', required smallint NOT NULL default '0', - nodes text default '', weight smallint NOT NULL default '0', PRIMARY KEY (vid) ); +-- +-- Table structure for vocabulary_node_types +-- + +CREATE TABLE vocabulary_node_types ( + vid integer NOT NULL default '0', + type varchar(16) NOT NULL default '', + PRIMARY KEY (vid, type) +); + -- -- Table structure for watchdog -- -- cgit v1.2.3