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

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

-- Add missing state for South Korea
SELECT @country_id := id from civicrm_country where name = 'Korea, Republic of' AND iso_code = 'KR';
INSERT IGNORE INTO `civicrm_state_province` (`id`, `country_id`, `abbreviation`, `name`) VALUES
(NULL, @country_id, '50', 'Sejong');

-- Remove any references to custom fields from mapping field table that no longer exist
DELETE FROM civicrm_mapping_field
WHERE name NOT IN ( SELECT concat('custom_', id) FROM civicrm_custom_field)
AND name LIKE 'custom_%';
Commit	Line	Data
e10c0223	1	{* file to handle db changes in 5.34.alpha1 during upgrade *}
04ce1ca9 JG	2
	3	-- Add missing state for South Korea
	4	SELECT @country_id := id from civicrm_country where name = 'Korea, Republic of' AND iso_code = 'KR';
	5	INSERT IGNORE INTO `civicrm_state_province` (`id`, `country_id`, `abbreviation`, `name`) VALUES
6db44f5a	6	(NULL, @country_id, '50', 'Sejong');
dce0a4a7 SL	7
	8	-- Remove any references to custom fields from mapping field table that no longer exist
	9	DELETE FROM civicrm_mapping_field
	10	WHERE name NOT IN ( SELECT concat('custom_', id) FROM civicrm_custom_field)
	11	AND name LIKE 'custom_%';