From aa8feb98f29a60e23b2d11e93d3e186d72dd2426 Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Wed, 10 Aug 2005 08:28:50 +0000
Subject: Minor changes.

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 80d2489b..10063400 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -633,6 +633,26 @@ CREATE TABLE escalations (
 
 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'
 --
-- 
cgit 

