cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ni...@apache.org
Subject git commit: updated refs/heads/master to 26edfa1
Date Tue, 06 Aug 2013 11:45:59 GMT
Updated Branches:
  refs/heads/master 95e15833b -> 26edfa1b2


CLOUDSTACK-4043
Introduced new column format for volumes as per the hypervisor by joining the storage pool
and cluster table. Since pre 4.2 storage pool will always have cluster id populated.
Signed off by : nitin mehta<nitin.mehta@citrix.com>


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

Branch: refs/heads/master
Commit: 26edfa1b23d4d537f805576130882bc434004532
Parents: 95e1583
Author: Nitin Mehta <nitin.mehta@citrix.com>
Authored: Tue Aug 6 17:14:11 2013 +0530
Committer: Nitin Mehta <nitin.mehta@citrix.com>
Committed: Tue Aug 6 17:15:45 2013 +0530

----------------------------------------------------------------------
 setup/db/db/schema-410to420.sql | 4 ++++
 1 file changed, 4 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/cloudstack/blob/26edfa1b/setup/db/db/schema-410to420.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql
index 089cedd..1ca9d64 100644
--- a/setup/db/db/schema-410to420.sql
+++ b/setup/db/db/schema-410to420.sql
@@ -487,6 +487,10 @@ ALTER TABLE `cloud`.`user_vm_details` ADD COLUMN `display_detail` tinyint(1)
NOT
 ALTER TABLE `cloud`.`volumes` ADD COLUMN `display_volume` tinyint(1) NOT NULL DEFAULT 1 COMMENT
'Should volume be displayed to the end user';
 
 ALTER TABLE `cloud`.`volumes` ADD COLUMN `format` varchar(255) COMMENT 'volume format';
+update  `cloud`.`volumes` v,  `cloud`.`storage_pool` s,  `cloud`.`cluster` c  set v.format='VHD'
where v.pool_id=s.id and s.cluster_id=c.id and c.hypervisor_type='XenServer';
+update  `cloud`.`volumes` v,  `cloud`.`storage_pool` s,  `cloud`.`cluster` c  set v.format='OVA'
where v.pool_id=s.id and s.cluster_id=c.id and c.hypervisor_type='VMware';
+update  `cloud`.`volumes` v,  `cloud`.`storage_pool` s,  `cloud`.`cluster` c  set v.format='QCOW2'
where v.pool_id=s.id and s.cluster_id=c.id and c.hypervisor_type='KVM';
+update  `cloud`.`volumes` v,  `cloud`.`storage_pool` s,  `cloud`.`cluster` c  set v.format='RAW'
where v.pool_id=s.id and s.cluster_id=c.id and c.hypervisor_type='Ovm';
 
 ALTER TABLE `cloud`.`networks` ADD COLUMN `display_network` tinyint(1) NOT NULL DEFAULT 1
COMMENT 'Should network be displayed to the end user';
 


Mime
View raw message