From 463ef09d65c7c11c29f77ffe8c4f00543f0b7771 Mon Sep 17 00:00:00 2001 From: sunil pawar Date: Thu, 14 Dec 2017 03:21:26 +0530 Subject: [PATCH] CRM-21532 add missing French state/departments (#11392) * CRM-21532 add missing French state/departments * get country id using name and iso code for state insert statement --- CRM/Upgrade/Incremental/sql/4.7.29.mysql.tpl | 6 ++++++ xml/templates/civicrm_state_province.tpl | 3 +++ 2 files changed, 9 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.7.29.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.29.mysql.tpl index 220be2115a..228b4453f8 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.29.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.29.mysql.tpl @@ -8,3 +8,9 @@ UPDATE `civicrm_state_province` SET `name` = 'Thüringen' WHERE `name` = 'Thueri -- CRM-21378 Ensure that email abuse reports are treated as spam SELECT @bounceTypeID := max(id) FROM civicrm_mailing_bounce_type WHERE name = 'Spam'; INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern) VALUES (@bounceTypeID, 'abuse report'); + + +-- CRM-21532 Add French state/departments +SELECT @country_id := id from civicrm_country where name = 'France' AND iso_code = 'FR'; +INSERT INTO `civicrm_state_province` (`id`, `country_id`, `abbreviation`, `name`) VALUES +(NULL, @country_id, "52", "Haute-Marne"); \ No newline at end of file diff --git a/xml/templates/civicrm_state_province.tpl b/xml/templates/civicrm_state_province.tpl index ff93c97eb7..3a6318f64e 100644 --- a/xml/templates/civicrm_state_province.tpl +++ b/xml/templates/civicrm_state_province.tpl @@ -4087,6 +4087,9 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES (NULL, 1076, "WF", "Wallis-et-Futuna"), (NULL, 1076, "NC", "Nouvelle-Calédonie"), +-- CRM-21532 Add French state/departments +(NULL, 1076, "52", "Haute-Marne"), + -- Add states for: Barbados and Antigua and Barbuda (NULL, 1009, "03", "Saint George"), (NULL, 1009, "04", "Saint John"), -- 2.25.1