24 lines
1.5 KiB
Smarty
24 lines
1.5 KiB
Smarty
|
{* 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;
|
||
|
|
|
||
|
|
-- 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;
|
||
|
|
|
||
|
|
-- CRM-17637
|
||
|
|
INSERT INTO `civicrm_job`
|
||
|
|
( domain_id, run_frequency, last_run, name, description, api_entity, api_action, parameters, is_active )
|
||
|
|
VALUES
|
||
|
|
( {$domainID}, 'Daily' , NULL, '{ts escape="sql" skip="true"}CiviCRM Update Check{/ts}', '{ts escape="sql" skip="true"}Checks for CiviCRM version updates. Important for keeping the database secure. Also sends anonymous usage statistics to civicrm.org to to assist in prioritizing ongoing development efforts.{/ts}', 'job', 'version_check', NULL, 1);
|