summaryrefslogtreecommitdiff
path: root/database/database.pgsql
diff options
context:
space:
mode:
Diffstat (limited to 'database/database.pgsql')
-rw-r--r--database/database.pgsql3
1 files changed, 2 insertions, 1 deletions
diff --git a/database/database.pgsql b/database/database.pgsql
index 41665bf11..c5e33e0a3 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -649,7 +649,8 @@ CREATE INDEX term_hierarchy_parent_idx ON term_hierarchy(parent);
CREATE TABLE term_node (
nid integer NOT NULL default '0',
- tid integer NOT NULL default '0'
+ tid integer NOT NULL default '0',
+ PRIMARY KEY (tid,nid)
);
CREATE INDEX term_node_nid_idx ON term_node(nid);
CREATE INDEX term_node_tid_idx ON term_node(tid);