diff options
Diffstat (limited to 'create/postgresql/schema.sql')
| -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; |