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

   1 {* file to handle db changes in 5.37.alpha1 during upgrade *}
   2
   3 DROP VIEW IF EXISTS civicrm_view_case_activity_upcoming;
   4 DROP VIEW IF EXISTS civicrm_view_case_activity_recent;
   5
   6 UPDATE civicrm_state_province s
   7  INNER JOIN civicrm_country c
   8    on c.id = s.country_id AND c.name = 'United Kingdom' AND s.name = 'Carmarthenshire' AND s.abbreviation = 'CRF'
   9  SET s.abbreviation = 'CMN';
  10
  11 ALTER TABLE `civicrm_case_type` CHANGE `is_active`  `is_active` tinyint DEFAULT 1 COMMENT 'Is this case type enabled?';
  12
  13 -- https://lab.civicrm.org/dev/core/-/issues/2442
  14
  15 SELECT @option_group_id_activity_contacts := id FROM civicrm_option_group WHERE name = 'activity_contacts';
  16
  17 UPDATE civicrm_option_value SET weight = 1 WHERE name = 'Activity Targets' AND option_group_id = @option_group_id_activity_contacts;
  18 UPDATE civicrm_option_value SET weight = 2 WHERE name = 'Activity Source' AND option_group_id = @option_group_id_activity_contacts;
  19 UPDATE civicrm_option_value SET weight = 3 WHERE name = 'Activity Assignees' AND option_group_id = @option_group_id_activity_contacts;