From 68d09eea4a0667d9563eced3d5e3ff5964fcee2b Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Sun, 26 Dec 2004 21:18:45 +0000
Subject:  - added table 'escalations' (Alexei)

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index fc9ef9b9..2a7b43ca 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -612,4 +612,16 @@ CREATE TABLE trends (
   FOREIGN KEY (itemid) REFERENCES items
 );
 
+--
+-- Table structure for table 'escalations'
+--
+
+CREATE TABLE escalations (
+  escalationid		serial		DEFAULT '0' NOT NULL,
+  name			varchar(64)	DEFAULT '0' NOT NULL,
+  PRIMARY KEY (escalationid)
+);
+
+CREATE UNIQUE INDEX escalations_name on escalations (name);
+
 VACUUM ANALYZE;
-- 
cgit