From 5ad9a7a76d255d3cf47f8b678433efcbb9e57134 Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Sun, 8 Feb 2004 20:31:07 +0000
Subject:  - changed DB schema. Dropped foreign key for table actions (Alexei)

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

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

diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql
index 311cc19c..09dd8954 100644
--- a/create/postgresql/schema.sql
+++ b/create/postgresql/schema.sql
@@ -178,7 +178,9 @@ CREATE TABLE actions (
   nextcheck		int4		DEFAULT '0' NOT NULL,
   recipient		int4		DEFAULT '0' NOT NULL,
   PRIMARY KEY (actionid),
-  FOREIGN KEY (triggerid) REFERENCES triggers
+--  depends on scope. Could be hostid or 0.
+--  FOREIGN KEY (triggerid) REFERENCES triggers
+--  could be groupid
 --  FOREIGN KEY (userid) REFERENCES users
 );
 
-- 
cgit 

