diff options
author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2002-01-20 09:36:35 +0000 |
---|---|---|
committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2002-01-20 09:36:35 +0000 |
commit | 2d0d67b4c6c0f5e6953cca43d133eafabceb81e9 (patch) | |
tree | 5a646a6fcc348c856eb91f2c715e0fb49cce0cf3 /create | |
parent | 5332ae7dadc62e7001afbe36779d03b148c8e705 (diff) | |
download | zabbix-2d0d67b4c6c0f5e6953cca43d133eafabceb81e9.tar.gz zabbix-2d0d67b4c6c0f5e6953cca43d133eafabceb81e9.tar.xz zabbix-2d0d67b4c6c0f5e6953cca43d133eafabceb81e9.zip |
Updated schemas and patches for 1.0beta1.
git-svn-id: svn://svn.zabbix.com/trunk@290 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create')
-rw-r--r-- | create/postgresql/schema.sql | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 606dafd2..a07d931b 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -77,6 +77,7 @@ CREATE TABLE triggers ( triggerid serial, expression varchar(255) DEFAULT '' NOT NULL, description varchar(255) DEFAULT '' NOT NULL, + url varchar(255) DEFAULT '' NOT NULL, istrue int4 DEFAULT '0' NOT NULL, priority int2 DEFAULT '0' NOT NULL, lastchange int4 DEFAULT '0' NOT NULL, @@ -318,4 +319,32 @@ CREATE TABLE graphs_items ( FOREIGN KEY (itemid) REFERENCES items ); +-- +-- Table structure for table 'services' +-- + +CREATE TABLE services ( + serviceid serial, + name varchar(128) DEFAULT '' NOT NULL, + status int2 DEFAULT '0' NOT NULL, + triggerid int4, + PRIMARY KEY (serviceid) +); + +CREATE INDEX services_triggerid on services (triggerid); + +-- +-- Table structure for table 'services_links' +-- + +CREATE TABLE services_links ( + serviceupid int4 DEFAULT '0' NOT NULL, + servicedownid int4 DEFAULT '0' NOT NULL, + soft int2 DEFAULT '0' NOT NULL +); + +CREATE INDEX services_links_serviceupid on services_links (serviceupid); +CREATE INDEX services_links_servicedownid on services_links (servicedownid); +CREATE UNIQUE INDEX services_links_upidownid on services_links (serviceupid, servicedownid); + VACUUM ANALYZE; |