diff options
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 4 |
1 files changed, 3 insertions, 1 deletions
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 ); |