From d5ea8fad4b31686d74f46a850c79cab4229f8659 Mon Sep 17 00:00:00 2001 From: jitendrapurohit Date: Wed, 29 Jul 2015 14:00:55 +0530 Subject: [PATCH] CRM-16752 - Mispell in Province for Philippines - Bataan --- CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl | 1 + xml/templates/civicrm_state_province.tpl | 2 +- 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl index 2b3ed8f6c4..e9eb3e1fae 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl @@ -24,3 +24,4 @@ UPDATE civicrm_option_value SET {localize field="label"}label = 'Activity Summar {include file='../CRM/Upgrade/4.7.alpha1.msg_template/civicrm_msg_template.tpl'} +UPDATE civicrm_state_province SET name = 'Bataan' WHERE name = 'Batasn'; diff --git a/xml/templates/civicrm_state_province.tpl b/xml/templates/civicrm_state_province.tpl index 76cdcb498a..f549211723 100644 --- a/xml/templates/civicrm_state_province.tpl +++ b/xml/templates/civicrm_state_province.tpl @@ -2505,7 +2505,7 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES (4046, 1170, "APA", "Apayao"), (4047, 1170, "AUR", "Aurora"), (4048, 1170, "BAS", "Basilan"), -(4049, 1170, "BAN", "Batasn"), +(4049, 1170, "BAN", "Bataan"), (4050, 1170, "BTN", "Batanes"), (4051, 1170, "BTG", "Batangas"), (4052, 1170, "BEN", "Benguet"), -- 2.25.1