diff options
author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-04-18 12:08:14 +0000 |
---|---|---|
committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-04-18 12:08:14 +0000 |
commit | 50d286d6535eb4683c0f607ec1fcab91d3d8dcc6 (patch) | |
tree | 644f97e57300ccd6c159694e7cabdf4242572397 /upgrades/dbpatches | |
parent | 0ae3a0ca67fd055ba7735ccd0b010f5508271cb3 (diff) | |
download | zabbix-50d286d6535eb4683c0f607ec1fcab91d3d8dcc6.tar.gz zabbix-50d286d6535eb4683c0f607ec1fcab91d3d8dcc6.tar.xz zabbix-50d286d6535eb4683c0f607ec1fcab91d3d8dcc6.zip |
Database patches
git-svn-id: svn://svn.zabbix.com/trunk@4037 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades/dbpatches')
4 files changed, 8 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.4/mysql/patch/dchecks.sql b/upgrades/dbpatches/1.4/mysql/patch/dchecks.sql index cb00b398..a185415d 100644 --- a/upgrades/dbpatches/1.4/mysql/patch/dchecks.sql +++ b/upgrades/dbpatches/1.4/mysql/patch/dchecks.sql @@ -2,6 +2,8 @@ CREATE TABLE dchecks ( dcheckid bigint unsigned DEFAULT '0' NOT NULL, druleid bigint unsigned DEFAULT '0' NOT NULL, type integer DEFAULT '0' NOT NULL, + key_ varchar(255) DEFAULT '0' NOT NULL, + snmp_community varchar(255) DEFAULT '0' NOT NULL, ports varchar(255) DEFAULT '0' NOT NULL, PRIMARY KEY (dcheckid) ) type=InnoDB; diff --git a/upgrades/dbpatches/1.4/mysql/patch/dservices.sql b/upgrades/dbpatches/1.4/mysql/patch/dservices.sql index 1e37f046..c55abbb7 100644 --- a/upgrades/dbpatches/1.4/mysql/patch/dservices.sql +++ b/upgrades/dbpatches/1.4/mysql/patch/dservices.sql @@ -2,6 +2,8 @@ CREATE TABLE dservices ( dserviceid bigint unsigned DEFAULT '0' NOT NULL, dhostid bigint unsigned DEFAULT '0' NOT NULL, type integer DEFAULT '0' NOT NULL, + key_ varchar(255) DEFAULT '0' NOT NULL, + value varchar(255) DEFAULT '0' NOT NULL, port integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, lastup integer DEFAULT '0' NOT NULL, diff --git a/upgrades/dbpatches/1.4/postgresql/patch/dchecks.sql b/upgrades/dbpatches/1.4/postgresql/patch/dchecks.sql index 5cf5d873..7e6830e4 100644 --- a/upgrades/dbpatches/1.4/postgresql/patch/dchecks.sql +++ b/upgrades/dbpatches/1.4/postgresql/patch/dchecks.sql @@ -2,6 +2,8 @@ CREATE TABLE dchecks ( dcheckid bigint DEFAULT '0' NOT NULL, druleid bigint DEFAULT '0' NOT NULL, type integer DEFAULT '0' NOT NULL, + key_ varchar(255) DEFAULT '0' NOT NULL, + snmp_community varchar(255) DEFAULT '0' NOT NULL, ports varchar(255) DEFAULT '0' NOT NULL, PRIMARY KEY (dcheckid) ); diff --git a/upgrades/dbpatches/1.4/postgresql/patch/dservices.sql b/upgrades/dbpatches/1.4/postgresql/patch/dservices.sql index 3a2ec37a..6bf25ca1 100644 --- a/upgrades/dbpatches/1.4/postgresql/patch/dservices.sql +++ b/upgrades/dbpatches/1.4/postgresql/patch/dservices.sql @@ -2,6 +2,8 @@ CREATE TABLE dservices ( dserviceid bigint DEFAULT '0' NOT NULL, dhostid bigint DEFAULT '0' NOT NULL, type integer DEFAULT '0' NOT NULL, + key_ varchar(255) DEFAULT '0' NOT NULL, + value varchar(255) DEFAULT '0' NOT NULL, port integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, lastup integer DEFAULT '0' NOT NULL, |