summaryrefslogtreecommitdiffstats
path: root/create/schema/schema.sql
diff options
context:
space:
mode:
authoralex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2007-03-23 07:58:39 +0000
committeralex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2007-03-23 07:58:39 +0000
commitc9ab150760446741460d7ef65de9f5ca643beb82 (patch)
tree9142e7c94e7d26e65a45de4c956628d26fa58b6c /create/schema/schema.sql
parent67caec0a308312b19cc85f6c09e482d717c0f252 (diff)
downloadzabbix-c9ab150760446741460d7ef65de9f5ca643beb82.tar.gz
zabbix-c9ab150760446741460d7ef65de9f5ca643beb82.tar.xz
zabbix-c9ab150760446741460d7ef65de9f5ca643beb82.zip
- support of multiple actions per set of conidtions (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@3910 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/schema/schema.sql')
-rw-r--r--create/schema/schema.sql18
1 files changed, 11 insertions, 7 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql
index 170adca9..3285a01b 100644
--- a/create/schema/schema.sql
+++ b/create/schema/schema.sql
@@ -269,15 +269,19 @@ INDEX |3 |clock
TABLE|actions|actionid|ZBX_SYNC
FIELD |actionid |t_id |'0' |NOT NULL |ZBX_SYNC
-FIELD |userid |t_id |'0' |NOT NULL |ZBX_SYNC
-FIELD |subject |t_varchar(255) |'' |NOT NULL |ZBX_SYNC
-FIELD |message |t_blob |'' |NOT NULL |ZBX_SYNC
-FIELD |recipient |t_integer |'0' |NOT NULL |ZBX_SYNC
-FIELD |source |t_integer |'0' |NOT NULL |ZBX_SYNC
-FIELD |actiontype |t_integer |'0' |NOT NULL |ZBX_SYNC
+FIELD |eventsource |t_integer |'0' |NOT NULL |ZBX_SYNC
FIELD |evaltype |t_integer |'0' |NOT NULL |ZBX_SYNC
FIELD |status |t_integer |'0' |NOT NULL |ZBX_SYNC
-FIELD |scripts |t_blob |'' |NOT NULL |ZBX_SYNC
+
+TABLE|operations|operationid|ZBX_SYNC
+FIELD |operationid |t_id |'0' |NOT NULL |ZBX_SYNC
+FIELD |actionid |t_id |'0' |NOT NULL |ZBX_SYNC
+FIELD |operationtype |t_integer |'0' |NOT NULL |ZBX_SYNC
+FIELD |object |t_integer |'0' |NOT NULL |ZBX_SYNC
+FIELD |objectid |t_id |'0' |NOT NULL |ZBX_SYNC
+FIELD |shortdata |t_varchar(255) |'' |NOT NULL |ZBX_SYNC
+FIELD |longdata |t_blob |'' |NOT NULL |ZBX_SYNC
+INDEX |1 |actionid
TABLE|applications|applicationid|ZBX_SYNC
FIELD |applicationid |t_id |'0' |NOT NULL |ZBX_SYNC