From 69ac0b14036019a94cc3ceb44d447773df4198d0 Mon Sep 17 00:00:00 2001 From: hugetoad Date: Sun, 31 Mar 2002 12:52:37 +0000 Subject: - added column value_type to table items_template (Alexei) - support for system[uname] (Alexei) - support for system[hostname] (Alexei) git-svn-id: svn://svn.zabbix.com/trunk@342 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- upgrades/dbpatches/1.0beta2_to_1.0beta3/mysql/patch.sql | 6 ++++++ upgrades/dbpatches/1.0beta2_to_1.0beta3/postgresql/patch.sql | 5 +++++ 2 files changed, 11 insertions(+) (limited to 'upgrades') 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); -- cgit