1
alter table screens_items add rowspan int(4) DEFAULT '0' NOT NULL;
2
alter table users add autologout int(4) DEFAULT '900' NOT NULL;
3
alter table users add lang varchar(5) DEFAULT 'en_gb' NOT NULL;
5
drop table escalation_rules;
6
drop table escalations;
11
CREATE TABLE escalations (
12
escalationid int(4) NOT NULL auto_increment,
13
name varchar(64) DEFAULT '0' NOT NULL,
14
dflt int(2) DEFAULT '0' NOT NULL,
15
PRIMARY KEY (escalationid),
22
CREATE TABLE escalation_rules (
23
escalationruleid int(4) NOT NULL auto_increment,
24
escalationid int(4) DEFAULT '0' NOT NULL,
25
level int(4) DEFAULT '0' NOT NULL,
26
period varchar(100) DEFAULT '1-7,00:00-23:59' NOT NULL,
27
delay int(4) DEFAULT '0' NOT NULL,
28
actiontype int(4) DEFAULT '0' NOT NULL,
29
PRIMARY KEY (escalationruleid),
36
CREATE TABLE escalation_log (
37
escalationlogid int(4) NOT NULL auto_increment,
38
triggerid int(4) DEFAULT '0' NOT NULL,
39
alarmid int(4) DEFAULT '0' NOT NULL,
40
escalationid int(4) DEFAULT '0' NOT NULL,
41
actiontype int(4) DEFAULT '0' NOT NULL,
42
level int(4) DEFAULT '0' NOT NULL,
43
adminlevel int(4) DEFAULT '0' NOT NULL,
44
nextcheck int(4) DEFAULT '0' NOT NULL,
45
status int(4) DEFAULT '0' NOT NULL,
46
PRIMARY KEY (escalationlogid),
47
KEY (alarmid,escalationid),