From 52068ff54198179508ace16e58b9e814dc3261df Mon Sep 17 00:00:00 2001 From: Mathieu Lutfy Date: Thu, 1 May 2014 14:46:42 -0400 Subject: [PATCH] CRM-14598: Fix sql/4.5.alpha1.mysql.tpl FK declaration for the civicrm_mailing_settings. --- CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl index 649c33fd90..f50c9588ef 100644 --- a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl @@ -267,7 +267,7 @@ VALUES -- CRM-14435 ALTER TABLE `civicrm_mail_settings` - ADD CONSTRAINT `FK_civicrm_mail_settings_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`) ON DELETE SET NULL; + ADD CONSTRAINT `FK_civicrm_mail_settings_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`) ON DELETE CASCADE; -- CRM-14436 ALTER TABLE `civicrm_mailing` -- 2.25.1