diff options
| -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; |