1
alter table hosts add templateid int(4) DEFAULT '0' NOT NULL;
2
alter table items add templateid int(4) DEFAULT '0' NOT NULL;
3
alter table triggers add templateid int(4) DEFAULT '0' NOT NULL;
4
alter table graphs add templateid int(4) DEFAULT '0' NOT NULL;
6
alter table items add valuemapid int(4) DEFAULT '0' NOT NULL;
8
alter table actions add status int(1) DEFAULT '0' NOT NULL;
13
CREATE TABLE valuemaps (
14
valuemapid int(4) NOT NULL auto_increment,
15
name varchar(64) DEFAULT '' NOT NULL,
16
PRIMARY KEY (valuemapid),
23
CREATE TABLE mappings (
24
mappingid int(4) NOT NULL auto_increment,
25
valuemapid int(4) DEFAULT '0' NOT NULL,
26
value varchar(64) DEFAULT '' NOT NULL,
27
newvalue varchar(64) DEFAULT '' NOT NULL,
28
PRIMARY KEY (mappingid),
29
KEY valuemapid (valuemapid)
35
CREATE TABLE housekeeper (
36
housekeeperid int(4) NOT NULL auto_increment,
37
tablename varchar(64) DEFAULT '' NOT NULL,
38
field varchar(64) DEFAULT '' NOT NULL,
39
value int(4) DEFAULT '0' NOT NULL,
40
PRIMARY KEY (housekeeperid)