From 546e672bbc33aae643ff0ed08275db89da9bde31 Mon Sep 17 00:00:00 2001 From: hugetoad Date: Sat, 4 Jun 2005 12:45:23 +0000 Subject: Minor changes. git-svn-id: svn://svn.zabbix.com/trunk@1815 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- create/postgresql/schema.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'create/postgresql/schema.sql') diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index b02ab2c3..1c3d1952 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -636,12 +636,13 @@ CREATE UNIQUE INDEX escalations_name on escalations (name); -- CREATE TABLE escalation_rules ( - ruleid serial, + escalationruleid serial, escalationid int4 DEFAULT '0' NOT NULL, - period varchar(100) DEFAULT '1-7,00:00-23:59' NOT NULL, level int4 DEFAULT '0' NOT NULL, + period varchar(100) DEFAULT '1-7,00:00-23:59' NOT NULL, + delay int4 DEFAULT '0' NOT NULL, actiontype int4 DEFAULT '0' NOT NULL, - PRIMARY KEY (ruleid), + PRIMARY KEY (escalationruleid), FOREIGN KEY (escalationid) REFERENCES escalations ); -- cgit