1
update items set key_='check_service[ftp]' where key_='net[listen_21]';
2
update items set key_='check_service[ssh]' where key_='net[listen_22]';
3
update items set key_='check_service[smtp]' where key_='net[listen_25]';
4
update items set key_='check_service[pop]' where key_='net[listen_110]';
6
alter table triggers add dep_level int2 not null default '0';
8
CREATE TABLE trigger_depends (
9
triggerid_down int4 DEFAULT '0' NOT NULL,
10
triggerid_up int4 DEFAULT '0' NOT NULL,
11
PRIMARY KEY (triggerid_down, triggerid_up)
14
CREATE INDEX trigger_depends_down on trigger_depends (triggerid_down);
15
CREATE INDEX trigger_depends_up on trigger_depends (triggerid_up);