diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-01-03 19:30:29 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-01-03 19:30:29 +0000 |
| commit | ea1add8bb3ca2f7396be6d4ef1f6772aaf3f3f26 (patch) | |
| tree | f7b441f64b71dbcaf40f873f830bdad3c4db15e0 /create/postgresql | |
| parent | 13ea6377b078793ee736b7c35b8b101d630967d5 (diff) | |
| download | zabbix-ea1add8bb3ca2f7396be6d4ef1f6772aaf3f3f26.tar.gz zabbix-ea1add8bb3ca2f7396be6d4ef1f6772aaf3f3f26.tar.xz zabbix-ea1add8bb3ca2f7396be6d4ef1f6772aaf3f3f26.zip | |
- added table 'hosts_templates' (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@1575 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql')
| -rw-r--r-- | create/postgresql/schema.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 2a7b43ca..a406da91 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -624,4 +624,19 @@ CREATE TABLE escalations ( CREATE UNIQUE INDEX escalations_name on escalations (name); +-- +-- Table structure for table 'hosts_templates' +-- + +CREATE TABLE hosts_templates ( + hostid int4 DEFAULT '0' NOT NULL, + templateid int4 DEFAULT '0' NOT NULL, + items int2 DEFAULT '0' NOT NULL, + triggers int2 DEFAULT '0' NOT NULL, + actions int2 DEFAULT '0' NOT NULL, + graphs int2 DEFAULT '0' NOT NULL, + screens int2 DEFAULT '0' NOT NULL, + PRIMARY KEY (hostid, templateid) +); + VACUUM ANALYZE; |