summaryrefslogtreecommitdiffstats
path: root/create/postgresql/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'create/postgresql/schema.sql')
-rw-r--r--create/postgresql/schema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 961c5a56..11cc9c71 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -36,6 +36,7 @@ CREATE TABLE hosts (
);
CREATE INDEX hosts_status on hosts (status);
+CREATE UNIQUE INDEX hosts_host on hosts (host);
--
-- Table structure for table 'items'