From 757a198757dc13ab9cd1b8ec755354c173e906b4 Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Mon, 17 Sep 2001 15:20:22 +0000
Subject: Added support for trigger dependencies

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 5193453d..207147fa 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -78,12 +78,26 @@ CREATE TABLE triggers (
   lastcheck		int4		DEFAULT '0' NOT NULL,
   priority		int2		DEFAULT '0' NOT NULL,
   lastchange		int4		DEFAULT '0' NOT NULL,
+  dep_level		int2		DEFAULT '0' NOT NULL,
   comments		text,
   PRIMARY KEY (triggerid)
 );
 
 CREATE INDEX triggers_istrue on triggers (istrue);
 
+--
+-- Table structure for table 'trigger_depends'
+--
+
+CREATE TABLE trigger_depends (
+  triggerid_down	int4	DEFAULT '0' NOT NULL,
+  triggerid_up		int4	DEFAULT '0' NOT NULL,
+  PRIMARY KEY		(triggerid_down, triggerid_up)
+);
+
+CREATE INDEX trigger_depends_down on trigger_depends (triggerid_down);
+CREATE INDEX trigger_depends_up   on trigger_depends (triggerid_up);
+
 --
 -- Table structure for table 'users'
 --
-- 
cgit 

