From 546e672bbc33aae643ff0ed08275db89da9bde31 Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Sat, 4 Jun 2005 12:45:23 +0000
Subject: Minor changes.

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index b02ab2c3..1c3d1952 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -636,12 +636,13 @@ CREATE UNIQUE INDEX escalations_name on escalations (name);
 --
 
 CREATE TABLE escalation_rules (
-  ruleid		serial,
+  escalationruleid	serial,
   escalationid		int4		DEFAULT '0' NOT NULL,
-  period		varchar(100)	DEFAULT '1-7,00:00-23:59' 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 (ruleid),
+  PRIMARY KEY (escalationruleid),
   FOREIGN KEY (escalationid) REFERENCES escalations
 );
 
-- 
cgit 

