CLOUDSTACK-9481: Convert MyISAM table to InnoDB for consistency Signed-off-by: Rohit Yadav <[email protected]>
Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/180406e8 Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/180406e8 Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/180406e8 Branch: refs/heads/4.9-bountycastle-daan Commit: 180406e89538671437618b2e2581ef6edf393405 Parents: 3e6f49d Author: Abhinandan Prateek <[email protected]> Authored: Tue Aug 30 16:16:40 2016 +0530 Committer: Rohit Yadav <[email protected]> Committed: Thu Sep 1 14:02:08 2016 +0530 ---------------------------------------------------------------------- setup/db/db/schema-490to491.sql | 8 ++++++++ 1 file changed, 8 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/180406e8/setup/db/db/schema-490to491.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-490to491.sql b/setup/db/db/schema-490to491.sql index ced79de..4346cad 100644 --- a/setup/db/db/schema-490to491.sql +++ b/setup/db/db/schema-490to491.sql @@ -23,3 +23,11 @@ UPDATE `cloud`.`roles` SET `description`='Default user role' WHERE `id`=4 AND `role_type`='User' AND `description`='Default Root Admin role'; +ALTER TABLE cloud.load_balancer_cert_map ENGINE=INNODB; +ALTER TABLE cloud.monitoring_services ENGINE=INNODB; +ALTER TABLE cloud.nic_ip_alias ENGINE=INNODB; +ALTER TABLE cloud.sslcerts ENGINE=INNODB; +ALTER TABLE cloud.op_lock ENGINE=INNODB; +ALTER TABLE cloud.op_nwgrp_work ENGINE=INNODB; + +ALTER TABLE cloud_usage.quota_account ENGINE=INNODB;
