diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-06-02 08:25:06 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-06-02 08:25:06 +0000 |
| commit | 2455cb0235f79b6b282a85a8b9b2a82c4f34959c (patch) | |
| tree | 0bf00de0190c6e1cb8015328804150717a864db1 /create/postgresql/schema.sql | |
| parent | 42d53b272f39f3764816e18c9aa18d832a2db1c8 (diff) | |
| download | zabbix-2455cb0235f79b6b282a85a8b9b2a82c4f34959c.tar.gz zabbix-2455cb0235f79b6b282a85a8b9b2a82c4f34959c.tar.xz zabbix-2455cb0235f79b6b282a85a8b9b2a82c4f34959c.zip | |
- added table escalation_rules (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@1805 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index e1526873..6fe43a7c 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -631,6 +631,19 @@ CREATE TABLE escalations ( CREATE UNIQUE INDEX escalations_name on escalations (name); -- +-- Table structure for table 'escalation_rules' +-- + +CREATE TABLE escalation_rules ( + ruleid serial, + escalationid int4 DEFAULT '0' NOT NULL, + level int4 DEFAULT '0' NOT NULL, + actiontype int4 DEFAULT '0' NOT NULL, + PRIMARY KEY (ruleid), + FOREIGN KEY (escalationid) REFERENCES escalations +); + +-- -- Table structure for table 'hosts_templates' -- |