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 3895fa336..78b7f5865 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -308,7 +308,8 @@ CREATE TABLE filter_formats (
name varchar(255) NOT NULL default '',
roles varchar(255) NOT NULL default '',
cache tinyint(2) NOT NULL default '0',
- PRIMARY KEY (format)
+ PRIMARY KEY (format),
+ UNIQUE KEY (name)
)
/*!40100 DEFAULT CHARACTER SET utf8 */ ;