[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 5.32.alpha1.mysql.tpl

{* file to handle db changes in 5.32.alpha1 during upgrade *}

-- update italian provinces (pull request #18859)
UPDATE civicrm_state_province s
 INNER JOIN civicrm_country c
   on c.id = s.country_id AND c.name = 'Italy'
     AND s.abbreviation = 'Bar'
SET s.abbreviation = 'BT';

UPDATE civicrm_state_province s
 INNER JOIN civicrm_country c
   on c.id = s.country_id AND c.name = 'Italy'
     AND s.abbreviation = 'Fer'
SET s.abbreviation = 'FM';

UPDATE civicrm_state_province s
 INNER JOIN civicrm_country c
   on c.id = s.country_id AND c.name = 'Italy'
     AND s.abbreviation = 'Mon'
SET s.abbreviation = 'MB';
Commit	Line	Data
19402431	1	{* file to handle db changes in 5.32.alpha1 during upgrade *}
03c79b96 SM	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';