From d70314f923d57cc5c623da7cd10b4eed632e851d Mon Sep 17 00:00:00 2001 From: hugetoad 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