CLOUDSTACK-2029 zone wide primary storage support for cloudstack over vmware 
deployments

Added new column 'hypervisor' to table storage_pool to associate a identify a 
pool at zone level by hypervisor type.

Signed-off-by: Sateesh Chodapuneedi <[email protected]>


Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/2705f016
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/2705f016
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/2705f016

Branch: refs/heads/master
Commit: 2705f01651adfaf600647e5c2ea76c357c08c02a
Parents: 5199609
Author: Sateesh Chodapuneedi <[email protected]>
Authored: Tue May 28 23:46:09 2013 +0530
Committer: Sateesh Chodapuneedi <[email protected]>
Committed: Sat Jun 1 00:05:27 2013 +0530

----------------------------------------------------------------------
 setup/db/db/schema-410to420.sql |    2 ++
 1 files changed, 2 insertions(+), 0 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/cloudstack/blob/2705f016/setup/db/db/schema-410to420.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql
index 502b36b..03e14a9 100644
--- a/setup/db/db/schema-410to420.sql
+++ b/setup/db/db/schema-410to420.sql
@@ -35,6 +35,7 @@ INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Network', 
'DEFAULT', 'manage
 INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Network', 'DEFAULT', 
'management-server', 'midonet.providerrouter.id', 
'd7c5e6a3-e2f4-426b-b728-b7ce6a0448e5', 'Specifies the UUID of the Midonet 
provider router (if using Midonet)');
 ALTER TABLE `cloud`.`load_balancer_vm_map` ADD state VARCHAR(40) NULL COMMENT 
'service status updated by LB healthcheck manager';
 
+alter table storage_pool add hypervisor varchar(32);
 alter table storage_pool change storage_provider_id storage_provider_name 
varchar(255);
 alter table template_host_ref add state varchar(255);
 alter table template_host_ref add update_count bigint unsigned;
@@ -830,6 +831,7 @@ CREATE VIEW `cloud`.`storage_pool_view` AS
         storage_pool.removed,
         storage_pool.capacity_bytes,
         storage_pool.scope,
+        storage_pool.hypervisor,
         cluster.id cluster_id,
         cluster.uuid cluster_uuid,
         cluster.name cluster_name,

Reply via email to