diff options
Diffstat (limited to 'database/database.pgsql')
| -rw-r--r-- | database/database.pgsql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/database/database.pgsql b/database/database.pgsql index 3abb1fa1a..2bb1095d0 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -705,7 +705,8 @@ CREATE INDEX term_data_vid_idx ON term_data(vid); CREATE TABLE term_hierarchy ( tid integer NOT NULL default '0', - parent integer NOT NULL default '0' + parent integer NOT NULL default '0', + PRIMARY KEY (tid, parent) ); CREATE INDEX term_hierarchy_tid_idx ON term_hierarchy(tid); CREATE INDEX term_hierarchy_parent_idx ON term_hierarchy(parent); |