1
update items set history=history/(24*3600);
3
update config set alert_history=alert_history/(24*3600);
4
update config set alarm_history=alarm_history/(24*3600);
6
alter table triggers add status int(4) DEFAULT '0' NOT NULL;
7
alter table triggers add value int(4) DEFAULT '0' NOT NULL;
9
alter table alerts add status int(4) DEFAULT '0' NOT NULL;
10
alter table alerts add retries int(4) DEFAULT '0' NOT NULL;
11
create index status_retries on alerts (status,retries);
13
alter table items add trapper_hosts varchar(255) DEFAULT '' NOT NULL;
15
update triggers set status=0 where istrue in (0,1,3);
16
update triggers set status=1 where istrue in (2);
17
update triggers set status=2 where istrue in (4);
19
update triggers set value=0 where istrue in (0);
20
update triggers set value=1 where istrue in (1);
21
update triggers set value=2 where istrue in (2,3,4);
23
alter table triggers drop istrue;
25
alter table alarms add value int(4) DEFAULT '0' NOT NULL;
26
update alarms set value=0 where istrue in (0);
27
update alarms set value=1 where istrue in (1);
28
update alarms set value=2 where istrue not in (0,1);
30
alter table services add algorithm int(1) DEFAULT '0' NOT NULL;
32
insert into items_template (itemtemplateid,description,key_,delay,value_type)
33
values (69,'Host status','status', 60, 0);
34
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
35
values (69,69,'Server %s is unreachable','{:.last(0)}=2');
37
insert into users (userid,alias,name,surname,passwd) values (2,'guest','Default','User','d41d8cd98f00b204e9800998ecf8427e');
38
insert into rights (rightid,userid,name,permission,id) values (3,2,'Default permission','R',0);
43
CREATE TABLE sessions (
44
sessionid varchar(32) NOT NULL DEFAULT '',
45
userid int(4) NOT NULL DEFAULT '0',
46
lastaccess int(4) NOT NULL DEFAULT '0',
47
PRIMARY KEY (sessionid)