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

{* file to handle db changes in 4.7.32 during upgrade *}

-- CRM-21837 - Missing states for Gabon
SELECT @country_id := id from civicrm_country where name = 'Gabon' AND iso_code = 'GA';
INSERT IGNORE INTO `civicrm_state_province` (`id`, `country_id`, `abbreviation`, `name`) VALUES
(NULL, @country_id, "01", "Estuaire"),
(NULL, @country_id, "02", "Haut-Ogooué"),
(NULL, @country_id, "03", "Moyen-Ogooué"),
(NULL, @country_id, "04", "Ngounié"),
(NULL, @country_id, "05", "Nyanga"),
(NULL, @country_id, "06", "Ogooué-Ivindo"),
(NULL, @country_id, "07", "Ogooué-Lolo"),
(NULL, @country_id, "08", "Ogooué-Maritime"),
(NULL, @country_id, "09", "Woleu-Ntem");
Commit	Line	Data
951ab9f5	1	{* file to handle db changes in 4.7.32 during upgrade *}
9792675b LK	2
	3	-- CRM-21837 - Missing states for Gabon
	4	SELECT @country_id := id from civicrm_country where name = 'Gabon' AND iso_code = 'GA';
02ae7511	5	INSERT IGNORE INTO `civicrm_state_province` (`id`, `country_id`, `abbreviation`, `name`) VALUES
9792675b LK	6	(NULL, @country_id, "01", "Estuaire"),
	7	(NULL, @country_id, "02", "Haut-Ogooué"),
	8	(NULL, @country_id, "03", "Moyen-Ogooué"),
	9	(NULL, @country_id, "04", "Ngounié"),
	10	(NULL, @country_id, "05", "Nyanga"),
	11	(NULL, @country_id, "06", "Ogooué-Ivindo"),
	12	(NULL, @country_id, "07", "Ogooué-Lolo"),
	13	(NULL, @country_id, "08", "Ogooué-Maritime"),
	14	(NULL, @country_id, "09", "Woleu-Ntem");