1
alter table screens_items add elements int4 DEFAULT '25' NOT NULL;
3
alter table hosts_templates drop screens;
4
alter table hosts_templates drop actions;
9
CREATE TABLE conditions (
11
actionid int4 DEFAULT '0' NOT NULL,
12
conditiontype int4 DEFAULT '0' NOT NULL,
13
operator int1 DEFAULT '0' NOT NULL,
14
value varchar(255) DEFAULT '' NOT NULL,
15
PRIMARY KEY (conditionid),
19
insert into conditions (actionid, conditiontype, operator, value)
20
select actionid, 2, 0, triggerid from actions where scope=0;
22
insert into conditions (actionid, conditiontype, operator, value)
23
select actionid, 1, 0, triggerid from actions where scope=1;
25
insert into conditions (actionid, conditiontype, operator, value)
26
select actionid, 5, 0, '0' from actions where good in (0,2);
28
insert into conditions (actionid, conditiontype, operator, value)
29
select actionid, 5, 0, '1' from actions where good in (1,2);
31
insert into conditions (actionid, conditiontype, operator, value)
32
select actionid, 4, 5, severity from actions where scope in (1,2);
34
alter table actions drop triggerid;
35
alter table actions drop scope;
36
alter table actions drop good;
37
alter table actions drop severity;
39
alter table actions add source int2 DEFAULT '0' NOT NULL;
40
alter table actions add actiontype int2 DEFAULT '0' NOT NULL;
42
update actions set message="{TRIGGER.NAME}: {STATUS}" where message="*Automatically generated*";
43
update actions set subject="{TRIGGER.NAME}: {STATUS}" where subject="*Automatically generated*";