diff options
Diffstat (limited to 'database/database.pgsql')
| -rw-r--r-- | database/database.pgsql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/database/database.pgsql b/database/database.pgsql index 717c59093..ba43d9cd9 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -199,10 +199,12 @@ CREATE INDEX comments_nid_idx ON comments(nid); -- CREATE TABLE contact ( + cid int NOT NULL, category varchar(255) NOT NULL default '', recipients text NOT NULL default '', reply text NOT NULL default '', - PRIMARY KEY (category) + PRIMARY KEY (cid), + UNIQUE (category) ); -- |