summaryrefslogtreecommitdiffstats
path: root/upgrades
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2004-08-08 15:13:06 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2004-08-08 15:13:06 +0000
commit3da79e6d41d7feb6eb2f6e61a1712fdeca4fb46c (patch)
tree4474956ae190044aa59bf8c4be23d3131427ade2 /upgrades
parent37568f78334d10a6b9b68e9c96f0694fce3ae6b0 (diff)
downloadzabbix-3da79e6d41d7feb6eb2f6e61a1712fdeca4fb46c.tar.gz
zabbix-3da79e6d41d7feb6eb2f6e61a1712fdeca4fb46c.tar.xz
zabbix-3da79e6d41d7feb6eb2f6e61a1712fdeca4fb46c.zip
- 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
Diffstat (limited to 'upgrades')
-rw-r--r--upgrades/dbpatches/1.0_to_1.1alpha1/mysql/patch.sql2
-rw-r--r--upgrades/dbpatches/1.0_to_1.1alpha1/postgresql/patch.sql4
2 files changed, 6 insertions, 0 deletions
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;