Adding defaults to new columns

Prachi Damle · Prachi Damle · commit 3cc9f3ff06a6 · 2013-01-22T12:54:12.000-08:00
diff --git a/engine/orchestration/test/org/apache/cloudstack/engine/provisioning/test/ProvisioningTest.java b/engine/orchestration/test/org/apache/cloudstack/engine/provisioning/test/ProvisioningTest.java
@@ -127,9 +127,9 @@ private void registerAndEnableHost() {
 
 	@Test
 	public void testProvisioning() {
-		//registerAndEnableZone();
-		//registerAndEnablePod();
-		//registerAndEnableCluster();
+		registerAndEnableZone();
+		registerAndEnablePod();
+		registerAndEnableCluster();
 		registerAndEnableHost();
 	}
 
diff --git a/setup/db/4.1-new-db-schema.sql b/setup/db/4.1-new-db-schema.sql
@@ -27,20 +27,20 @@ alter table vm_instance add column disk_offering_id bigint unsigned;
 alter table data_center add column owner varchar(255);
 alter table data_center add column created datetime COMMENT 'date created';
 alter table data_center add column lastUpdated datetime COMMENT 'last updated';
-alter table data_center add column engine_state varchar(32) NOT NULL COMMENT 'the engine state of the zone';
+alter table data_center add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled' COMMENT 'the engine state of the zone';
 alter table host_pod_ref add column owner varchar(255);
 alter table host_pod_ref add column created datetime COMMENT 'date created';
 alter table host_pod_ref add column lastUpdated datetime COMMENT 'last updated';
-alter table host_pod_ref add column engine_state varchar(32) NOT NULL COMMENT 'the engine state of the zone';
+alter table host_pod_ref add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled' COMMENT 'the engine state of the zone';
 alter table host add column owner varchar(255);
 alter table host add column lastUpdated datetime COMMENT 'last updated';
-alter table host add column engine_state varchar(32) NOT NULL COMMENT 'the engine state of the zone';
+alter table host add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled' COMMENT 'the engine state of the zone';
 
 
 alter table cluster add column owner varchar(255);
 alter table cluster add column created datetime COMMENT 'date created';
 alter table cluster add column lastUpdated datetime COMMENT 'last updated';
-alter table cluster add column engine_state varchar(32) NOT NULL COMMENT 'the engine state of the zone';
+alter table cluster add column engine_state varchar(32) NOT NULL DEFAULT 'Disabled' COMMENT 'the engine state of the zone';
 
 CREATE TABLE `cloud`.`data_store_provider` (
   `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
