diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-06-04 09:38:37 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-06-04 09:38:37 +0000 |
| commit | dee7748ce3a458856713e608569c47c6d5ea65d4 (patch) | |
| tree | 01c473e4920745f705c13649845522e59c1c7444 /create/postgresql/schema.sql | |
| parent | 5109cb828698fe2aea7376b876c55e9b501c4c2c (diff) | |
| download | zabbix-dee7748ce3a458856713e608569c47c6d5ea65d4.tar.gz zabbix-dee7748ce3a458856713e608569c47c6d5ea65d4.tar.xz zabbix-dee7748ce3a458856713e608569c47c6d5ea65d4.zip | |
New structure for escalation and escalation rules tables (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@1812 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 6fe43a7c..b02ab2c3 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -625,6 +625,7 @@ CREATE TABLE trends ( CREATE TABLE escalations ( escalationid serial, name varchar(64) DEFAULT '0' NOT NULL, + dflt int2 DEFAULT '0' NOT NULL, PRIMARY KEY (escalationid) ); @@ -637,6 +638,7 @@ CREATE UNIQUE INDEX escalations_name on escalations (name); CREATE TABLE escalation_rules ( ruleid 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, actiontype int4 DEFAULT '0' NOT NULL, PRIMARY KEY (ruleid), |