- added table escalation_rules (Alexei)

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

2 files changed, 26 insertions, 0 deletions

diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql
index ee76195e..b074351f 100644
--- a/create/mysql/schema.sql
+++ b/create/mysql/schema.sql
@@ -626,6 +626,19 @@ CREATE TABLE escalations (
 ) type=InnoDB;
 
 --
+-- 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;
+
+--
 -- Table structure for table 'hosts_templates'
 --
 
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'
 --