You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by ni...@apache.org on 2013/10/31 21:53:43 UTC
git commit: updated refs/heads/master to 03b27c0
Updated Branches:
refs/heads/master 0db10ad55 -> 03b27c02a
CLOUDSTACK-5013:
Add the format for volumes table for uploaded volumes. Since volume_host_ref still exists, using that for populating it
Signed off by : nitin mehta<ni...@citrix.com>
Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/03b27c02
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/03b27c02
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/03b27c02
Branch: refs/heads/master
Commit: 03b27c02a3fdc31a7cb9931bb01902f8963058c3
Parents: 0db10ad
Author: Nitin Mehta <ni...@citrix.com>
Authored: Thu Oct 31 13:51:49 2013 -0700
Committer: Nitin Mehta <ni...@citrix.com>
Committed: Thu Oct 31 13:53:24 2013 -0700
----------------------------------------------------------------------
setup/db/db/schema-420to421.sql | 7 ++++++-
1 file changed, 6 insertions(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/cloudstack/blob/03b27c02/setup/db/db/schema-420to421.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-420to421.sql b/setup/db/db/schema-420to421.sql
index e72e1b2..d429b30 100644
--- a/setup/db/db/schema-420to421.sql
+++ b/setup/db/db/schema-420to421.sql
@@ -215,4 +215,9 @@ CREATE VIEW `cloud`.`user_vm_view` AS
left join
`cloud`.`affinity_group` ON affinity_group_vm_map.affinity_group_id = affinity_group.id
left join
- `cloud`.`user_vm_details` as all_details ON all_details.vm_id = vm_instance.id;
\ No newline at end of file
+ `cloud`.`user_vm_details` as all_details ON all_details.vm_id = vm_instance.id;
+
+--Add the format for volumes table for uploaded volumes (CLOUDSTACK-5013)
+update `cloud`.`volumes` v, `cloud`.`volume_host_ref` vhr set v.format=vhr.format where v.id=vhr.volume_id and v.format is null;
+
+