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
---
 create/postgresql/schema.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)

(limited to 'create/postgresql/schema.sql')

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
@@ -630,6 +630,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'
 --
-- 
cgit 

