As part of the upgrade changes, some db changes got removed from create-schema.sql. Moved the changes to the corresponding upgrade sql.
Project: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/commit/ed757f24 Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/ed757f24 Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/ed757f24 Branch: refs/heads/qemu-img Commit: ed757f24aea31a3befacc0f6ee0646c8e4e02b19 Parents: a4510ef Author: Koushik Das <[email protected]> Authored: Mon Feb 18 15:25:09 2013 +0530 Committer: Koushik Das <[email protected]> Committed: Mon Feb 18 15:25:09 2013 +0530 ---------------------------------------------------------------------- setup/db/db/schema-410to420.sql | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/ed757f24/setup/db/db/schema-410to420.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql index d1f90be..8bd9bfd 100644 --- a/setup/db/db/schema-410to420.sql +++ b/setup/db/db/schema-410to420.sql @@ -19,3 +19,7 @@ -- Schema upgrade from 4.1.0 to 4.2.0; --; +ALTER TABLE `cloud`.`hypervisor_capabilities` ADD COLUMN `max_hosts_per_cluster` int unsigned DEFAULT NULL COMMENT 'Max. hosts in cluster supported by hypervisor'; +UPDATE `cloud`.`hypervisor_capabilities` SET `max_hosts_per_cluster`=32 WHERE `hypervisor_type`='VMware'; +INSERT IGNORE INTO `cloud`.`hypervisor_capabilities`(hypervisor_type, hypervisor_version, max_guests_limit, security_group_enabled, max_hosts_per_cluster) VALUES ('VMware', '5.1', 128, 0, 32); +DELETE FROM `cloud`.`configuration` where name='vmware.percluster.host.max';
