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<[email protected]> 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 <[email protected]> Authored: Thu Oct 31 13:51:49 2013 -0700 Committer: Nitin Mehta <[email protected]> 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; + +
