diff options
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 7 |
1 files changed, 4 insertions, 3 deletions
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 ); |