diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2004-02-08 20:31:07 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2004-02-08 20:31:07 +0000 |
| commit | 5ad9a7a76d255d3cf47f8b678433efcbb9e57134 (patch) | |
| tree | 073a6a52fc03d8cb6ec5db17227a1cc87d14dd67 /create/postgresql | |
| parent | 88e356bd3c51be5db7f7bafdc6b0acaedcc68182 (diff) | |
| download | zabbix-5ad9a7a76d255d3cf47f8b678433efcbb9e57134.tar.gz zabbix-5ad9a7a76d255d3cf47f8b678433efcbb9e57134.tar.xz zabbix-5ad9a7a76d255d3cf47f8b678433efcbb9e57134.zip | |
- changed DB schema. Dropped foreign key for table actions (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@1247 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql')
| -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 ); |