From 7edbc60ec2a89ad7dcd859895de546a81ca55e7f Mon Sep 17 00:00:00 2001 From: Saurabh Batra Date: Fri, 4 Dec 2015 07:49:43 +0530 Subject: [PATCH] CRM-17404 - NULL values in 'do_not_*' fields if blank in contact:create API https://issues.civicrm.org/jira/browse/CRM-17404 --- CRM/Upgrade/Incremental/sql/4.7.beta2.mysql.tpl | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.7.beta2.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.beta2.mysql.tpl index 06cf35b74f..770920a528 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.beta2.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.beta2.mysql.tpl @@ -1 +1,13 @@ {* file to handle db changes in 4.7.beta2 during upgrade *} + +-- CRM-17404 NULL values in 'do_not_*' fields if blank in contact:create API +UPDATE civicrm_contact SET do_not_email = 0 WHERE do_not_email IS NULL; +UPDATE civicrm_contact SET do_not_phone = 0 WHERE do_not_phone IS NULL; +UPDATE civicrm_contact SET do_not_mail = 0 WHERE do_not_mail IS NULL; +UPDATE civicrm_contact SET do_not_sms = 0 WHERE do_not_sms IS NULL; +UPDATE civicrm_contact SET do_not_trade = 0 WHERE do_not_trade IS NULL; +ALTER TABLE civicrm_contact ALTER COLUMN do_not_email SET DEFAULT 0; +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; -- 2.25.1