diff options
author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-01-04 10:43:38 +0000 |
---|---|---|
committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-01-04 10:43:38 +0000 |
commit | b8edeec169a068a810f812b4d77ab0c64146238d (patch) | |
tree | 54a863d61b423b471ad1996d12fc8ecc7c83ed4d /create/postgresql | |
parent | bd443d5587cb568520c8ca2ea0e98ac0c7e5ac29 (diff) | |
download | zabbix-b8edeec169a068a810f812b4d77ab0c64146238d.tar.gz zabbix-b8edeec169a068a810f812b4d77ab0c64146238d.tar.xz zabbix-b8edeec169a068a810f812b4d77ab0c64146238d.zip |
Minor changes.
git-svn-id: svn://svn.zabbix.com/trunk@1579 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql')
-rw-r--r-- | create/postgresql/schema.sql | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index a406da91..3fb3dcf0 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -617,7 +617,7 @@ CREATE TABLE trends ( -- CREATE TABLE escalations ( - escalationid serial DEFAULT '0' NOT NULL, + escalationid serial, name varchar(64) DEFAULT '0' NOT NULL, PRIMARY KEY (escalationid) ); @@ -629,6 +629,7 @@ CREATE UNIQUE INDEX escalations_name on escalations (name); -- CREATE TABLE hosts_templates ( + hosttemplateid serial, hostid int4 DEFAULT '0' NOT NULL, templateid int4 DEFAULT '0' NOT NULL, items int2 DEFAULT '0' NOT NULL, @@ -636,7 +637,9 @@ CREATE TABLE hosts_templates ( actions int2 DEFAULT '0' NOT NULL, graphs int2 DEFAULT '0' NOT NULL, screens int2 DEFAULT '0' NOT NULL, - PRIMARY KEY (hostid, templateid) + PRIMARY KEY (hosttemplateid) ); +CREATE UNIQUE INDEX hosts_templates_hostid_templateid on hosts_templates (hostid, templateid); + VACUUM ANALYZE; |