Updated Branches: refs/heads/4.2 12c711cef -> 89237554e
CLOUDSTACK-3648: 3.0.6 to ASF 4.2 Upgrade: "hypervisor_capabilites" table has duplicate VMware 5.1 entries on the Upgraded Setup Added a unique constraint on "hypervisor_capabilities" table based on hypervisor type and version Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/89237554 Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/89237554 Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/89237554 Branch: refs/heads/4.2 Commit: 89237554e91b055e87f6bfcafc9bdf03864f660a Parents: 12c711c Author: Koushik Das <[email protected]> Authored: Fri Jul 19 12:12:51 2013 +0530 Committer: Koushik Das <[email protected]> Committed: Fri Jul 19 12:20:46 2013 +0530 ---------------------------------------------------------------------- setup/db/db/schema-410to420.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/89237554/setup/db/db/schema-410to420.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql index 4086f2f..921d5fa 100644 --- a/setup/db/db/schema-410to420.sql +++ b/setup/db/db/schema-410to420.sql @@ -22,6 +22,9 @@ -- Disable foreign key checking SET foreign_key_checks = 0; +-- All new inserts to the hypervisor_capabilities table should be after this +ALTER TABLE `cloud`.`hypervisor_capabilities` ADD CONSTRAINT `uc_hypervisor` UNIQUE (`hypervisor_type`, `hypervisor_version`); + ALTER TABLE `cloud`.`hypervisor_capabilities` ADD COLUMN `max_hosts_per_cluster` int unsigned DEFAULT NULL COMMENT 'Max. hosts in cluster supported by hypervisor'; 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'; @@ -2243,4 +2246,4 @@ CREATE VIEW `cloud`.`project_view` AS ALTER TABLE `cloud`.`sync_queue` MODIFY `queue_size` smallint(6) NOT NULL DEFAULT '0' COMMENT 'number of items being processed by the queue'; -ALTER TABLE `cloud`.`sync_queue` MODIFY `queue_size_limit` smallint(6) NOT NULL DEFAULT '1' COMMENT 'max number of items the queue can process concurrently'; \ No newline at end of file +ALTER TABLE `cloud`.`sync_queue` MODIFY `queue_size_limit` smallint(6) NOT NULL DEFAULT '1' COMMENT 'max number of items the queue can process concurrently';
