summaryrefslogtreecommitdiff
path: root/database/database.mysql
diff options
context:
space:
mode:
Diffstat (limited to 'database/database.mysql')
-rw-r--r--database/database.mysql3
1 files changed, 2 insertions, 1 deletions
diff --git a/database/database.mysql b/database/database.mysql
index 85c1a44d2..131b43940 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -712,7 +712,8 @@ CREATE TABLE term_hierarchy (
tid int(10) unsigned NOT NULL default '0',
parent int(10) unsigned NOT NULL default '0',
KEY tid (tid),
- KEY parent (parent)
+ KEY parent (parent),
+ PRIMARY KEY (tid, parent)
) TYPE=MyISAM;
--