CRM/Upgrade/Incremental/sql/4.7.beta2.mysql.tpl

   1 {* file to handle db changes in 4.7.beta2 during upgrade *}
   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;
  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;
  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
  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);