diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-06-04 12:45:23 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-06-04 12:45:23 +0000 |
| commit | 546e672bbc33aae643ff0ed08275db89da9bde31 (patch) | |
| tree | 642923d9ac4467debb0dd2b3c2ad5bb3043bddb8 /create/postgresql/schema.sql | |
| parent | 4aa6a1f2f879f2564386c713e3e601e3012db512 (diff) | |
| download | zabbix-546e672bbc33aae643ff0ed08275db89da9bde31.tar.gz zabbix-546e672bbc33aae643ff0ed08275db89da9bde31.tar.xz zabbix-546e672bbc33aae643ff0ed08275db89da9bde31.zip | |
Minor changes.
git-svn-id: svn://svn.zabbix.com/trunk@1815 97f52cf1-0a1b-0410-bd0e-c28be96e8082
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 ); |