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 a83393945..1628a4b74 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -293,7 +293,8 @@ CREATE TABLE filter_formats (
name varchar(255) NOT NULL default '',
roles varchar(255) NOT NULL default '',
cache smallint NOT NULL default '0',
- PRIMARY KEY (format)
+ PRIMARY KEY (format),
+ UNIQUE (name)
);
--