1
ALTER TABLE sysmaps_hosts RENAME sysmaps_elements;
3
ALTER TABLE sysmaps_elements RENAME COLUMN shostid TO selementid;
4
ALTER TABLE sysmaps_elements RENAME COLUMN hostid TO elementid;
5
ALTER TABLE sysmaps_elements ADD elementtype int4 DEFAULT '0' NOT NULL;
6
ALTER TABLE sysmaps_elements ADD label_location int2 DEFAULT NULL;
8
ALTER TABLE sysmaps_links RENAME COLUMN shostid1 TO selementid1;
9
ALTER TABLE sysmaps_links RENAME COLUMN shostid2 TO selementid2;
11
ALTER TABLE alarms ADD acknowledged int2 DEFAULT '0' NOT NULL;
16
CREATE TABLE acknowledges (
18
userid int4 DEFAULT '0' NOT NULL,
19
alarmid int4 DEFAULT '0' NOT NULL,
20
clock int4 DEFAULT '0' NOT NULL,
21
message varchar(255) DEFAULT '' NOT NULL,
22
PRIMARY KEY (acknowledgeid),
23
FOREIGN KEY (alarmid) REFERENCES alarms,
24
FOREIGN KEY (userid) REFERENCES users
27
CREATE INDEX acknowledges_alarmid ON acknowledgeid (alarmid);
29
ALTER TABLE screens_items ADD valign int2 DEFAULT '0' NOT NULL;
30
ALTER TABLE screens_items ADD halign int2 DEFAULT '0' NOT NULL;
31
ALTER TABLE screens_items ADD style int4 DEFAULT '0' NOT NULL;
32
ALTER TABLE screens_items ADD url varchar(255) DEFAULT '' NOT NULL;
34
CREATE INDEX rights_userid on rights (userid);
36
ALTER TABLE actions ADD scripts text DEFAULT '' NOT NULL;