From 2455cb0235f79b6b282a85a8b9b2a82c4f34959c Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Thu, 2 Jun 2005 08:25:06 +0000
Subject:  - added table escalation_rules (Alexei)

git-svn-id: svn://svn.zabbix.com/trunk@1805 97f52cf1-0a1b-0410-bd0e-c28be96e8082
---
 upgrades/dbpatches/1.1alpha10_to_1.1alpha11/mysql/patch.sql | 13 +++++++++++++
 .../dbpatches/1.1alpha10_to_1.1alpha11/postgresql/patch.sql | 13 +++++++++++++
 2 files changed, 26 insertions(+)

(limited to 'upgrades/dbpatches')

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
+);
-- 
cgit