From f89677352605c672e4b0bec1a754aa816154ce90 Mon Sep 17 00:00:00 2001 From: Seamus Lee Date: Fri, 23 Sep 2016 11:26:58 +1000 Subject: [PATCH] Alter a couple of other tables to InnoDB from MyISAM --- CRM/Activity/BAO/Activity.php | 2 +- sql/zipcodes.mysql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/CRM/Activity/BAO/Activity.php b/CRM/Activity/BAO/Activity.php index 54a522b1ee..35cd6d52db 100644 --- a/CRM/Activity/BAO/Activity.php +++ b/CRM/Activity/BAO/Activity.php @@ -768,7 +768,7 @@ LEFT JOIN civicrm_case_activity ON ( civicrm_case_activity.activity_id = tbl.ac $query = "CREATE TEMPORARY TABLE {$activityContactTempTable} ( activity_id int unsigned, contact_id int unsigned, record_type_id varchar(16), contact_name varchar(255), is_deleted int unsigned, counter int unsigned, INDEX index_activity_id( activity_id ) ) - ENGINE=MYISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci"; + ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci"; CRM_Core_DAO::executeQuery($query); diff --git a/sql/zipcodes.mysql b/sql/zipcodes.mysql index 7c27ed57df..f929ac5cc0 100644 --- a/sql/zipcodes.mysql +++ b/sql/zipcodes.mysql @@ -20,7 +20,7 @@ CREATE TABLE zipcodes ( KEY zip (zip), KEY latitude (latitude), KEY longitude (longitude) -) ENGINE=MYISAM; +) ENGINE=InnoDB; -- -- Dumping data for table `zipcodes` -- 2.25.1