diff options
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' -- |