Skip to content

Commit ed757f2

Browse files
author
Koushik Das
committed
As part of the upgrade changes, some db changes got removed from create-schema.sql.
Moved the changes to the corresponding upgrade sql.
1 parent a4510ef commit ed757f2

1 file changed

Lines changed: 4 additions & 0 deletions

File tree

setup/db/db/schema-410to420.sql

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -19,3 +19,7 @@
1919
-- Schema upgrade from 4.1.0 to 4.2.0;
2020
--;
2121

22+
ALTER TABLE `cloud`.`hypervisor_capabilities` ADD COLUMN `max_hosts_per_cluster` int unsigned DEFAULT NULL COMMENT 'Max. hosts in cluster supported by hypervisor';
23+
UPDATE `cloud`.`hypervisor_capabilities` SET `max_hosts_per_cluster`=32 WHERE `hypervisor_type`='VMware';
24+
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);
25+
DELETE FROM `cloud`.`configuration` where name='vmware.percluster.host.max';

0 commit comments

Comments
 (0)