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

   1 {* file to handle db changes in 5.32.alpha1 during upgrade *}
   2
   3 -- update italian provinces (pull request #18859)
   4 UPDATE civicrm_state_province s
   5  INNER JOIN civicrm_country c
   6    on c.id = s.country_id AND c.name = 'Italy'
   7      AND s.abbreviation = 'Bar'
   8 SET s.abbreviation = 'BT';
   9
  10 UPDATE civicrm_state_province s
  11  INNER JOIN civicrm_country c
  12    on c.id = s.country_id AND c.name = 'Italy'
  13      AND s.abbreviation = 'Fer'
  14 SET s.abbreviation = 'FM';
  15
  16 UPDATE civicrm_state_province s
  17  INNER JOIN civicrm_country c
  18    on c.id = s.country_id AND c.name = 'Italy'
  19      AND s.abbreviation = 'Mon'
  20 SET s.abbreviation = 'MB';