From 72934a3e52d32a7c38a44c144a16c39e29c7363e Mon Sep 17 00:00:00 2001 From: jitendrapurohit Date: Fri, 4 Mar 2016 14:10:57 +0530 Subject: [PATCH] upgrade handling for CRM-18037 --- CRM/Upgrade/Incremental/sql/4.7.4.mysql.tpl | 3 +++ 1 file changed, 3 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.7.4.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.4.mysql.tpl index 3a5a2c7a94..ee1875fd78 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.4.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.4.mysql.tpl @@ -1,2 +1,5 @@ {* file to handle db changes in 4.7.4 during upgrade *} {include file='../CRM/Upgrade/4.7.4.msg_template/civicrm_msg_template.tpl'} + +// CRM-18037 - update preferred mail format to set as default +UPDATE `civicrm_contact` SET `preferred_mail_format` = 'Both' WHERE `preferred_mail_format` IS NULL; -- 2.25.1