From d70314f923d57cc5c623da7cd10b4eed632e851d Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Sat, 11 Jan 2003 09:19:34 +0000
Subject:  - assured uniqueness of host names (Alexei)  - added
 upgrades/dbpatches/1.0beta7_to_1.0beta8/ with patches (Alexei)

git-svn-id: svn://svn.zabbix.com/trunk@633 97f52cf1-0a1b-0410-bd0e-c28be96e8082
---
 create/postgresql/schema.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'create/postgresql/schema.sql')

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'
-- 
cgit 

