From b4942b68162cb3606056b71e46ae91d630e10523 Mon Sep 17 00:00:00 2001 From: hugetoad Date: Mon, 26 Dec 2005 20:32:02 +0000 Subject: 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 --- create/postgresql/schema.sql | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'create/postgresql/schema.sql') 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 -- cgit