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.mysql | |
| 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.mysql')
| -rw-r--r-- | database/database.mysql | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/database/database.mysql b/database/database.mysql index 18e9731e3..3a02be088 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -749,12 +749,21 @@ 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' -- |