From 065ffec9339beb2ceeb3e8d2a0a28af9bb989c97 Mon Sep 17 00:00:00 2001 From: Tim Otten Date: Mon, 25 Apr 2016 16:13:07 -0700 Subject: [PATCH] CRM-18006 - civicrm_install_canary - Ensure ENGINE is InnoDB This should resolve warnings on systems where MyISAM was default engine. --- CRM/Upgrade/Incremental/php/FourSeven.php | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/CRM/Upgrade/Incremental/php/FourSeven.php b/CRM/Upgrade/Incremental/php/FourSeven.php index 94ed0dfb1b..971c58486b 100644 --- a/CRM/Upgrade/Incremental/php/FourSeven.php +++ b/CRM/Upgrade/Incremental/php/FourSeven.php @@ -183,6 +183,13 @@ class CRM_Upgrade_Incremental_php_FourSeven extends CRM_Upgrade_Incremental_Base $this->addTask('Add Contact Deleted by Merge Activity Type', 'addDeletedByMergeActivityType'); } + public function upgrade_4_7_7($rev) { + // https://issues.civicrm.org/jira/browse/CRM-18006 + if (CRM_Core_DAO::checkTableExists('civicrm_install_canary')) { + CRM_Core_DAO::executeQuery('ALTER TABLE civicrm_install_canary ENGINE=InnoDB'); + } + } + /** * CRM-16354 * -- 2.25.1