diff options
| author | Dries Buytaert <dries@buytaert.net> | 2005-01-19 16:22:52 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2005-01-19 16:22:52 +0000 |
| commit | 7bdca92aadf956a3e4e65815fbdcccad2f791802 (patch) | |
| tree | 1aa9dca9f7ae4460230375b54b7c8eb941c2a53f /database/database.pgsql | |
| parent | 6adc3dd055f2747514f555d5616cfd3f5a791796 (diff) | |
| download | brdo-7bdca92aadf956a3e4e65815fbdcccad2f791802.tar.gz brdo-7bdca92aadf956a3e4e65815fbdcccad2f791802.tar.bz2 | |
- 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.
Diffstat (limited to 'database/database.pgsql')
| -rw-r--r-- | database/database.pgsql | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/database/database.pgsql b/database/database.pgsql index 7e312e54c..d2d807f24 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -736,12 +736,21 @@ 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 -- |