From 50d286d6535eb4683c0f607ec1fcab91d3d8dcc6 Mon Sep 17 00:00:00 2001 From: alex Date: Wed, 18 Apr 2007 12:08:14 +0000 Subject: Database patches git-svn-id: svn://svn.zabbix.com/trunk@4037 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- upgrades/dbpatches/1.4/mysql/patch/dchecks.sql | 2 ++ upgrades/dbpatches/1.4/mysql/patch/dservices.sql | 2 ++ upgrades/dbpatches/1.4/postgresql/patch/dchecks.sql | 2 ++ upgrades/dbpatches/1.4/postgresql/patch/dservices.sql | 2 ++ 4 files changed, 8 insertions(+) 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, -- cgit