diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-01-13 23:09:28 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-01-13 23:09:28 +0000 |
| commit | c334f95fa681ebf90bd21fde418bfbf0aa94f022 (patch) | |
| tree | 65d9b4e01b58ffe1146c8249deb00a6c226b395c | |
| parent | 9f6106016da8948042892ffd5c7cc3cdd51ce595 (diff) | |
| download | zabbix-c334f95fa681ebf90bd21fde418bfbf0aa94f022.tar.gz zabbix-c334f95fa681ebf90bd21fde418bfbf0aa94f022.tar.xz zabbix-c334f95fa681ebf90bd21fde418bfbf0aa94f022.zip | |
Minor changes.
git-svn-id: svn://svn.zabbix.com/trunk@1605 97f52cf1-0a1b-0410-bd0e-c28be96e8082
| -rw-r--r-- | upgrades/dbpatches/1.1alpha4_to_1.1alpha5/mysql/patch.sql | 2 | ||||
| -rw-r--r-- | upgrades/dbpatches/1.1alpha4_to_1.1alpha5/postgresql/patch.sql | 2 |
2 files changed, 4 insertions, 0 deletions
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; |