diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2002-03-31 12:52:37 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2002-03-31 12:52:37 +0000 |
| commit | 69ac0b14036019a94cc3ceb44d447773df4198d0 (patch) | |
| tree | 02c9c6fac12eedfad916693b50c76a3db9514328 /upgrades | |
| parent | 1cae722c88b6402f0c59a8c8503441d7e338252b (diff) | |
| download | zabbix-69ac0b14036019a94cc3ceb44d447773df4198d0.tar.gz zabbix-69ac0b14036019a94cc3ceb44d447773df4198d0.tar.xz zabbix-69ac0b14036019a94cc3ceb44d447773df4198d0.zip | |
- 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
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); |