From 5ad9a7a76d255d3cf47f8b678433efcbb9e57134 Mon Sep 17 00:00:00 2001 From: hugetoad 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