From 82fdd5289c5ca77fda07f6c88034feebcc76387b Mon Sep 17 00:00:00 2001 From: Eileen McNaughton Date: Thu, 28 Aug 2014 11:37:49 +1200 Subject: [PATCH] CRM-15196 mysql 5.6 is too strict on altering columns which have fks --- CRM/Upgrade/Incremental/sql/4.4.alpha1.mysql.tpl | 2 ++ 1 file changed, 2 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.4.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.4.alpha1.mysql.tpl index d82c8ae125..c3c3c63f3d 100644 --- a/CRM/Upgrade/Incremental/sql/4.4.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.4.alpha1.mysql.tpl @@ -67,9 +67,11 @@ ALTER TABLE `civicrm_custom_group` ADD COLUMN `is_reserved` tinyint(4) DEFAULT '0' COMMENT 'Is this a reserved Custom Group?'; --CRM-12986 fix event_id & contact_id to NOT NULL fields on participant table +SET foreign_key_checks = 0; ALTER TABLE `civicrm_participant` CHANGE COLUMN `event_id` `event_id` INT(10) UNSIGNED NOT NULL, CHANGE COLUMN `contact_id` `contact_id` INT(10) UNSIGNED NOT NULL; +SET foreign_key_checks = 1; -- CRM-12964 civicrm_print_label table creation CREATE TABLE IF NOT EXISTS `civicrm_print_label` ( -- 2.25.1