diff options
Diffstat (limited to 'database/database.mysql')
| -rw-r--r-- | database/database.mysql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/database/database.mysql b/database/database.mysql index a6a6defda..c70982086 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -204,10 +204,12 @@ CREATE TABLE comments ( -- CREATE TABLE contact ( + cid int(10) unsigned NOT NULL auto_increment, category varchar(255) NOT NULL default '', recipients longtext NOT NULL default '', reply longtext NOT NULL default '', - PRIMARY KEY (category) + PRIMARY KEY (cid), + UNIQUE KEY category (category) ) TYPE=MyISAM; -- |