From c334f95fa681ebf90bd21fde418bfbf0aa94f022 Mon Sep 17 00:00:00 2001 From: hugetoad Date: Thu, 13 Jan 2005 23:09:28 +0000 Subject: Minor changes. git-svn-id: svn://svn.zabbix.com/trunk@1605 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- upgrades/dbpatches/1.1alpha4_to_1.1alpha5/mysql/patch.sql | 2 ++ upgrades/dbpatches/1.1alpha4_to_1.1alpha5/postgresql/patch.sql | 2 ++ 2 files changed, 4 insertions(+) diff --git a/upgrades/dbpatches/1.1alpha4_to_1.1alpha5/mysql/patch.sql b/upgrades/dbpatches/1.1alpha4_to_1.1alpha5/mysql/patch.sql index 046692cf..94c0b8fb 100644 --- a/upgrades/dbpatches/1.1alpha4_to_1.1alpha5/mysql/patch.sql +++ b/upgrades/dbpatches/1.1alpha4_to_1.1alpha5/mysql/patch.sql @@ -25,3 +25,5 @@ CREATE TABLE hosts_templates ( alter table hosts add available int(4) DEFAULT '0' NOT NULL; update hosts set available=1 where status=0; update hosts set available=2 where status=2; + +update hosts set status=0 where status=2; diff --git a/upgrades/dbpatches/1.1alpha4_to_1.1alpha5/postgresql/patch.sql b/upgrades/dbpatches/1.1alpha4_to_1.1alpha5/postgresql/patch.sql index 84fa48c7..ae4d1500 100644 --- a/upgrades/dbpatches/1.1alpha4_to_1.1alpha5/postgresql/patch.sql +++ b/upgrades/dbpatches/1.1alpha4_to_1.1alpha5/postgresql/patch.sql @@ -28,3 +28,5 @@ alter table hosts add available int4 DEFAULT '0' NOT NULL; update hosts set available=1 where status=0; update hosts set available=2 where status=2; + +update hosts set status=0 where status=2; -- cgit