[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 4.7.beta2.mysql.tpl

{* 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);
Commit	Line	Data
4cfa4f79	1	{* file to handle db changes in 4.7.beta2 during upgrade *}
7edbc60e SB	2
	3	-- CRM-17404 NULL values in 'do_not_*' fields if blank in contact:create API
	4	UPDATE civicrm_contact SET do_not_email = 0 WHERE do_not_email IS NULL;
	5	UPDATE civicrm_contact SET do_not_phone = 0 WHERE do_not_phone IS NULL;
	6	UPDATE civicrm_contact SET do_not_mail = 0 WHERE do_not_mail IS NULL;
	7	UPDATE civicrm_contact SET do_not_sms = 0 WHERE do_not_sms IS NULL;
	8	UPDATE civicrm_contact SET do_not_trade = 0 WHERE do_not_trade IS NULL;
	9	ALTER TABLE civicrm_contact ALTER COLUMN do_not_email SET DEFAULT 0;
	10	ALTER TABLE civicrm_contact ALTER COLUMN do_not_phone SET DEFAULT 0;
	11	ALTER TABLE civicrm_contact ALTER COLUMN do_not_mail SET DEFAULT 0;
	12	ALTER TABLE civicrm_contact ALTER COLUMN do_not_sms SET DEFAULT 0;
	13	ALTER TABLE civicrm_contact ALTER COLUMN do_not_trade SET DEFAULT 0;
d4947661 DG	14
	15	-- CRM-17147 People with empty deceased-flag ('is null') get removed from recipient list of a mailing
	16	UPDATE civicrm_contact SET is_deceased = 0 WHERE is_deceased IS NULL;
e9e60a8c CW	17	ALTER TABLE civicrm_contact ALTER COLUMN is_deceased SET DEFAULT 0;
	18
	19	-- CRM-17637
	20	INSERT INTO `civicrm_job`
	21	( domain_id, run_frequency, last_run, name, description, api_entity, api_action, parameters, is_active )
	22	VALUES
3aa47203	23	( {$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);