From d494766162857e694acb8ef69e92eb04da5873f5 Mon Sep 17 00:00:00 2001 From: Dave Greenberg Date: Fri, 4 Dec 2015 14:56:08 -0800 Subject: [PATCH] CRM-17147 - ensure is_deceased FALSE values are 0, not NULL ---------------------------------------- * CRM-17147: People with empty deceased-flag ('is null') get removed from recipient list of a mailing https://issues.civicrm.org/jira/browse/CRM-17147 --- CRM/Upgrade/Incremental/sql/4.7.beta2.mysql.tpl | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.7.beta2.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.beta2.mysql.tpl index 770920a528..da64587e5d 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.beta2.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.beta2.mysql.tpl @@ -11,3 +11,7 @@ ALTER TABLE civicrm_contact ALTER COLUMN do_not_phone SET DEFAULT 0; ALTER TABLE civicrm_contact ALTER COLUMN do_not_mail SET DEFAULT 0; ALTER TABLE civicrm_contact ALTER COLUMN do_not_sms SET DEFAULT 0; ALTER TABLE civicrm_contact ALTER COLUMN do_not_trade SET DEFAULT 0; + +-- CRM-17147 People with empty deceased-flag ('is null') get removed from recipient list of a mailing +UPDATE civicrm_contact SET is_deceased = 0 WHERE is_deceased IS NULL; +ALTER TABLE civicrm_contact ALTER COLUMN is_deceased SET DEFAULT 0; \ No newline at end of file -- 2.25.1