Updated Branches:
  refs/heads/4.2 feeffeaf1 -> f1636203f

CLOUDSTACK-3497: Updated the hypervisor_capabilities table to include 
capabilities for xenserver 6.2.
Also made a change to update the capabilities for storage motion support based 
on hypervisor type and
version. It was being done based on 'id'.


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

Branch: refs/heads/4.2
Commit: f1636203f7f5d90aa0e62540e216cf5be5b2c222
Parents: feeffea
Author: Devdeep Singh <[email protected]>
Authored: Mon Jul 15 11:55:55 2013 +0530
Committer: Devdeep Singh <[email protected]>
Committed: Mon Jul 15 12:01:30 2013 +0530

----------------------------------------------------------------------
 setup/db/db/schema-410to420.sql | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/cloudstack/blob/f1636203/setup/db/db/schema-410to420.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql
index b48ae6a..e9fa995 100644
--- a/setup/db/db/schema-410to420.sql
+++ b/setup/db/db/schema-410to420.sql
@@ -26,9 +26,10 @@ ALTER TABLE `cloud`.`hypervisor_capabilities` ADD COLUMN 
`max_hosts_per_cluster`
 ALTER TABLE `cloud`.`hypervisor_capabilities` ADD COLUMN 
`storage_motion_supported` int(1) unsigned DEFAULT 0 COMMENT 'Is storage motion 
supported';
 UPDATE `cloud`.`hypervisor_capabilities` SET `max_hosts_per_cluster`=32 WHERE 
`hypervisor_type`='VMware';
 INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid, hypervisor_type, 
hypervisor_version, max_guests_limit, security_group_enabled, 
max_data_volumes_limit, storage_motion_supported) VALUES (UUID(), 'XenServer', 
'6.1.0', 50, 1, 13, 1);
+INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid, hypervisor_type, 
hypervisor_version, max_guests_limit, security_group_enabled, 
max_data_volumes_limit, storage_motion_supported) VALUES (UUID(), 'XenServer', 
'6.2.0', 50, 1, 13, 1);
 INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(uuid, hypervisor_type, 
hypervisor_version, max_guests_limit, security_group_enabled, 
max_hosts_per_cluster) VALUES (UUID(), 'VMware', '5.1', 128, 0, 32);
-UPDATE `cloud`.`hypervisor_capabilities` SET `storage_motion_supported`=true 
WHERE id=16;
-UPDATE `cloud`.`hypervisor_capabilities` SET `storage_motion_supported`=true 
WHERE id=11;
+UPDATE `cloud`.`hypervisor_capabilities` SET `storage_motion_supported`=true 
WHERE `hypervisor_type`='VMware' AND `hypervisor_version`='5.1';
+UPDATE `cloud`.`hypervisor_capabilities` SET `storage_motion_supported`=true 
WHERE `hypervisor_type`='VMware' AND `hypervisor_version`='5.0';
 DELETE FROM `cloud`.`configuration` where name='vmware.percluster.host.max';
 DELETE FROM `cloud`.`configuration` where name='router.template.id';
 INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 
'AgentManager', 'xen.nics.max', '7', 'Maximum allowed nics for Vms created on 
Xen');

Reply via email to