From 3da79e6d41d7feb6eb2f6e61a1712fdeca4fb46c Mon Sep 17 00:00:00 2001 From: hugetoad Date: Sun, 8 Aug 2004 15:13:06 +0000 Subject: - added housekeeping of trends (Alexei) - added column items.trends (Alexei) - added escaping of SQL statements where needed (Alexei) - added src/zabbix_sucker/checks_agent.[h,c] (Alexei) - added src/zabbix_sucker/checks_internal.[h,c] (Alexei) - added src/zabbix_sucker/checks_snmp.[h,c] (Alexei) - added src/zabbix_sucker/checks_simple.[h,c] (Alexei) git-svn-id: svn://svn.zabbix.com/trunk@1378 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- upgrades/dbpatches/1.0_to_1.1alpha1/mysql/patch.sql | 2 ++ upgrades/dbpatches/1.0_to_1.1alpha1/postgresql/patch.sql | 4 ++++ 2 files changed, 6 insertions(+) (limited to 'upgrades/dbpatches') diff --git a/upgrades/dbpatches/1.0_to_1.1alpha1/mysql/patch.sql b/upgrades/dbpatches/1.0_to_1.1alpha1/mysql/patch.sql index c44a8b65..bce92c94 100644 --- a/upgrades/dbpatches/1.0_to_1.1alpha1/mysql/patch.sql +++ b/upgrades/dbpatches/1.0_to_1.1alpha1/mysql/patch.sql @@ -1,3 +1,5 @@ alter table users add url varchar(255) DEFAULT '' NOT NULL; alter table sysmaps add use_background int(4) DEFAULT 0 NOT NULL; alter table sysmaps add background longblob DEFAULT '' NOT NULL; + +alter table items add trends int(4) DEFAULT '365' NOT NULL; diff --git a/upgrades/dbpatches/1.0_to_1.1alpha1/postgresql/patch.sql b/upgrades/dbpatches/1.0_to_1.1alpha1/postgresql/patch.sql index 15b41af3..b25a4ba6 100644 --- a/upgrades/dbpatches/1.0_to_1.1alpha1/postgresql/patch.sql +++ b/upgrades/dbpatches/1.0_to_1.1alpha1/postgresql/patch.sql @@ -1 +1,5 @@ alter table users add url varchar(255) DEFAULT '' NOT NULL; +alter table sysmaps add use_background int4 DEFAULT 0 NOT NULL; +alter table sysmaps add background blob DEFAULT '' NOT NULL; + +alter table items add trends int4 DEFAULT '365' NOT NULL; -- cgit