diff options
Diffstat (limited to 'upgrades')
| -rw-r--r-- | upgrades/dbpatches/1.0beta2_to_1.0beta3/mysql/patch.sql | 6 | ||||
| -rw-r--r-- | upgrades/dbpatches/1.0beta2_to_1.0beta3/postgresql/patch.sql | 5 |
2 files changed, 11 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.0beta2_to_1.0beta3/mysql/patch.sql b/upgrades/dbpatches/1.0beta2_to_1.0beta3/mysql/patch.sql index 75f60653..4e2437be 100644 --- a/upgrades/dbpatches/1.0beta2_to_1.0beta3/mysql/patch.sql +++ b/upgrades/dbpatches/1.0beta2_to_1.0beta3/mysql/patch.sql @@ -1,4 +1,5 @@ alter table items add value_type int(4) DEFAULT '0' NOT NULL; +alter table items_template add value_type int(4) DEFAULT '0' NOT NULL; CREATE TABLE history_str ( itemid int(4) DEFAULT '0' NOT NULL, @@ -6,3 +7,8 @@ CREATE TABLE history_str ( value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (itemid,clock) ); + +insert into items_template (itemtemplateid,description,key_,delay,value_type) + values (65,'Host name','system[hostname]', 1800, 1); +insert into items_template (itemtemplateid,description,key_,delay,value_type) + values (66,'Host information','system[uname]', 1800, 1); diff --git a/upgrades/dbpatches/1.0beta2_to_1.0beta3/postgresql/patch.sql b/upgrades/dbpatches/1.0beta2_to_1.0beta3/postgresql/patch.sql index b77de8d8..9aff2bf8 100644 --- a/upgrades/dbpatches/1.0beta2_to_1.0beta3/postgresql/patch.sql +++ b/upgrades/dbpatches/1.0beta2_to_1.0beta3/postgresql/patch.sql @@ -1,4 +1,5 @@ alter table items add value_type int4 DEFAULT '0' NOT NULL; +alter table items_template add value_type int4 DEFAULT '0' NOT NULL; CREATE TABLE history_str ( itemid int4 DEFAULT '0' NOT NULL, @@ -8,3 +9,7 @@ CREATE TABLE history_str ( FOREIGN KEY (itemid) REFERENCES items ); +insert into items_template (itemtemplateid,description,key_,delay,value_type) + values (65,'Host name','system[hostname]', 1800, 1); +insert into items_template (itemtemplateid,description,key_,delay,value_type) + values (66,'Host information','system[uname]', 1800, 1); |