Minor changes.

git-svn-id: svn://svn.zabbix.com/trunk@1955 97f52cf1-0a1b-0410-bd0e-c28be96e8082

2 files changed, 39 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 437b7ec4..a3ca2310 100644
--- a/upgrades/dbpatches/1.1alpha10_to_1.1alpha11/mysql/patch.sql
+++ b/upgrades/dbpatches/1.1alpha10_to_1.1alpha11/mysql/patch.sql
@@ -31,3 +31,22 @@ CREATE TABLE escalation_rules (
   PRIMARY KEY (escalationruleid),
   KEY (escalationid)
 ) type=InnoDB;
+
+--
+-- Table structure for table 'escalation_log'
+--
+
+CREATE TABLE escalation_log (
+  escalationlogid       int(4)          NOT NULL auto_increment,
+  triggerid             int(4)          DEFAULT '0' NOT NULL,
+  alarmid               int(4)          DEFAULT '0' NOT NULL,
+  escalationid          int(4)          DEFAULT '0' NOT NULL,
+  actiontype            int(4)          DEFAULT '0' NOT NULL,
+  level                 int(4)          DEFAULT '0' NOT NULL,
+  adminlevel            int(4)          DEFAULT '0' NOT NULL,
+  nextcheck             int(4)          DEFAULT '0' NOT NULL,
+  status                int(4)          DEFAULT '0' NOT NULL,
+  PRIMARY KEY (escalationlogid),
+  KEY (alarmid,escalationid),
+  KEY (triggerid)
+) 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 05ca0299..513bb177 100644
--- a/upgrades/dbpatches/1.1alpha10_to_1.1alpha11/postgresql/patch.sql
+++ b/upgrades/dbpatches/1.1alpha10_to_1.1alpha11/postgresql/patch.sql
@@ -32,3 +32,23 @@ CREATE TABLE escalation_rules (
   PRIMARY KEY (escalationruleid),
   FOREIGN KEY (escalationid) REFERENCES escalations
 );
+
+--
+-- Table structure for table 'escalation_log'
+--
+
+CREATE TABLE escalation_log (
+  escalationlogid       serial,
+  triggerid             int4            DEFAULT '0' NOT NULL,
+  alarmid               int4            DEFAULT '0' NOT NULL,
+  escalationid          int4            DEFAULT '0' NOT NULL,
+  actiontype            int4            DEFAULT '0' NOT NULL,
+  level                 int4            DEFAULT '0' NOT NULL,
+  adminlevel            int4            DEFAULT '0' NOT NULL,
+  nextcheck             int4            DEFAULT '0' NOT NULL,
+  status                int4            DEFAULT '0' NOT NULL,
+  PRIMARY KEY (escalationlogid)
+);
+
+CREATE INDEX escalations_log_alarmid_escalationid on escalations_log (alarmid,escalationid);
+CREATE INDEX escalations_log_triggerid on escalations_log (triggerid);