From dee8365629f019dc407cf19d9f489d4567b39bcc Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Wed, 19 Apr 2006 18:45:46 +0000
Subject:  - removed unused escalator (Alexei)  - removed escalation tables
 (Alexei)

git-svn-id: svn://svn.zabbix.com/trunk@2745 97f52cf1-0a1b-0410-bd0e-c28be96e8082
---
 create/postgresql/schema.sql | 48 --------------------------------------------
 1 file changed, 48 deletions(-)

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index a8b82fd9..54522d18 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -678,54 +678,6 @@ CREATE TABLE trends (
   FOREIGN KEY (itemid) REFERENCES items
 );
 
---
--- Table structure for table 'escalations'
---
-
-CREATE TABLE escalations (
-  escalationid		serial,
-  name			varchar(64)	DEFAULT '0' NOT NULL,
-  dflt			int2		DEFAULT '0' NOT NULL,
-  PRIMARY KEY (escalationid)
-);
-
-CREATE UNIQUE INDEX escalations_name on escalations (name);
-
---
--- 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);
-
---
--- Table structure for table 'escalation_rules'
---
-
-CREATE TABLE escalation_rules (
-  escalationruleid	serial,
-  escalationid		int4		DEFAULT '0' NOT NULL,
-  level			int4		DEFAULT '0' NOT NULL,
-  period		varchar(100)	DEFAULT '1-7,00:00-23:59' NOT NULL,
-  delay			int4		DEFAULT '0' NOT NULL,
-  actiontype		int4		DEFAULT '0' NOT NULL,
-  PRIMARY KEY (escalationruleid),
-  FOREIGN KEY (escalationid) REFERENCES escalations
-);
-
 --
 -- Table structure for table 'hosts_templates'
 --
-- 
cgit 

