CRM/Upgrade/Incremental/sql/4.7.4.mysql.tpl

   1 {* file to handle db changes in 4.7.4 during upgrade *}
   2 {include file='../CRM/Upgrade/4.7.4.msg_template/civicrm_msg_template.tpl'}
   3
   4 -- CRM-18037 - update preferred mail format to set as default
   5 UPDATE `civicrm_contact` SET `preferred_mail_format` = 'Both' WHERE `preferred_mail_format` IS NULL;