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 /upgrades/dbpatches | |
| 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 'upgrades/dbpatches')
| -rw-r--r-- | upgrades/dbpatches/1.1alpha10_to_1.1alpha11/mysql/patch.sql | 13 | ||||
| -rw-r--r-- | upgrades/dbpatches/1.1alpha10_to_1.1alpha11/postgresql/patch.sql | 13 |
2 files changed, 26 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.1alpha10_to_1.1alpha11/mysql/patch.sql b/upgrades/dbpatches/1.1alpha10_to_1.1alpha11/mysql/patch.sql index 6d704c4d..a0c3a809 100644 --- a/upgrades/dbpatches/1.1alpha10_to_1.1alpha11/mysql/patch.sql +++ b/upgrades/dbpatches/1.1alpha10_to_1.1alpha11/mysql/patch.sql @@ -1 +1,14 @@ alter table screens_items add rowspan int(4) DEFAULT '0' NOT NULL; + +-- +-- Table structure for table 'escalation_rules' +-- + +CREATE TABLE escalation_rules ( + ruleid int(4) NOT NULL auto_increment, + escalationid int(4) DEFAULT '0' NOT NULL, + level int(4) DEFAULT '0' NOT NULL, + actiontype int(4) DEFAULT '0' NOT NULL, + PRIMARY KEY (ruleid), + KEY (escalationid) +) type=InnoDB; diff --git a/upgrades/dbpatches/1.1alpha10_to_1.1alpha11/postgresql/patch.sql b/upgrades/dbpatches/1.1alpha10_to_1.1alpha11/postgresql/patch.sql index 9a29f520..d3c1a151 100644 --- a/upgrades/dbpatches/1.1alpha10_to_1.1alpha11/postgresql/patch.sql +++ b/upgrades/dbpatches/1.1alpha10_to_1.1alpha11/postgresql/patch.sql @@ -1 +1,14 @@ alter table screens_items add rowspan int4 DEFAULT '0' NOT NULL; + +-- +-- 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 +); |