diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-12-26 20:32:02 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-12-26 20:32:02 +0000 |
| commit | b4942b68162cb3606056b71e46ae91d630e10523 (patch) | |
| tree | 55f6eaeb4eccedd69f967f35260bbf41a0213f75 /create/postgresql/schema.sql | |
| parent | eac15533a497e31e41f44dd38518d7ad91c4e6dc (diff) | |
| download | zabbix-b4942b68162cb3606056b71e46ae91d630e10523.tar.gz zabbix-b4942b68162cb3606056b71e46ae91d630e10523.tar.xz zabbix-b4942b68162cb3606056b71e46ae91d630e10523.zip | |
Not finished:
- new concept of defenition of actions, one screen (Alexei)
- new fields for table 'actions' (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@2429 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 92bd5a5b..75b05b68 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -202,9 +202,7 @@ CREATE INDEX audit_clock on audit (clock); CREATE TABLE actions ( actionid serial, - triggerid int4 DEFAULT '0' NOT NULL, userid int4 DEFAULT '0' NOT NULL, - scope int4 DEFAULT '0' NOT NULL, severity int4 DEFAULT '0' NOT NULL, good int4 DEFAULT '0' NOT NULL, delay int4 DEFAULT '0' NOT NULL, @@ -214,6 +212,12 @@ CREATE TABLE actions ( recipient int4 DEFAULT '0' NOT NULL, maxrepeats int4 DEFAULT '0' NOT NULL, repeatdelay int4 DEFAULT '600' NOT NULL, + source int2 DEFAULT '0' NOT NULL, + actiontype int2 DEFAULT '0' NOT NULL, + filter_triggerid int4 DEFAULT '0' NOT NULL, + filter_hostid int4 DEFAULT '0' NOT NULL, + filter_groupid int4 DEFAULT '0' NOT NULL, + filter_trigger_name varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (actionid) -- depends on scope. Could be hostid or 0. -- FOREIGN KEY (triggerid) REFERENCES triggers |