- removed unused escalator (Alexei)

 - removed escalation tables (Alexei)


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

1 files changed, 0 insertions, 48 deletions

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
@@ -679,54 +679,6 @@ CREATE TABLE trends (
 );
 
 --
--- 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'
 --