From 2685a63087fd53d9592434dbec1ecb9bfd4d26d0 Mon Sep 17 00:00:00 2001 From: Coleman Watts Date: Sat, 1 Aug 2015 15:33:29 -0400 Subject: [PATCH] CRM-16447 - Fix province name 'Northern Ostrobothnia' --- CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl | 2 ++ 1 file changed, 2 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl index 3de4e3b9a5..260c07b272 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl @@ -38,3 +38,5 @@ ADD COLUMN -- CRM-16876 Set country names to UPPERCASE UPDATE civicrm_country SET `name` = UPPER( `name` ); +-- CRM-16447 +UPDATE civicrm_state_province SET name = 'Northern Ostrobothnia' WHERE name = 'Nothern Ostrobothnia'; \ No newline at end of file -- 2.25.1