From b4942b68162cb3606056b71e46ae91d630e10523 Mon Sep 17 00:00:00 2001
From: hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
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 

