CRM/Upgrade/Incremental/sql/5.40.alpha1.mysql.tpl

   1 {* file to handle db changes in 5.40.alpha1 during upgrade *}
   2
   3 SELECT @option_group_id_tuf := max(id) from civicrm_option_group where name = 'tag_used_for';
   4
   5 UPDATE civicrm_option_value SET name = 'Contact'
   6   WHERE value = 'civicrm_contact' AND option_group_id = @option_group_id_tuf;
   7 UPDATE civicrm_option_value SET name = 'Activity'
   8   WHERE value = 'civicrm_activity' AND option_group_id = @option_group_id_tuf;
   9 UPDATE civicrm_option_value SET name = 'Case'
  10   WHERE value = 'civicrm_case' AND option_group_id = @option_group_id_tuf;
  11 UPDATE civicrm_option_value SET name = 'File'
  12   WHERE value = 'civicrm_file' AND option_group_id = @option_group_id_tuf;
  13
  14 ALTER TABLE civicrm_mailing
  15 MODIFY COLUMN `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Date and time this mailing was created.';