From 8c2741629710782ae62fc8f9fb41d4e425b82d8a Mon Sep 17 00:00:00 2001
From: systopia <endres@systopia.de>
Date: Mon, 22 May 2017 14:10:47 +0200
Subject: [PATCH] incremental script for CRM-20606

---
 CRM/Upgrade/Incremental/sql/4.7.21.mysql.tpl | 11 +++++++++++
 1 file changed, 11 insertions(+)

diff --git a/CRM/Upgrade/Incremental/sql/4.7.21.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.21.mysql.tpl
index ffdd5c3d6b..6fadcfa256 100644
--- a/CRM/Upgrade/Incremental/sql/4.7.21.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/4.7.21.mysql.tpl
@@ -1 +1,12 @@
 {* file to handle db changes in 4.7.21 during upgrade *}
+
+-- CRM-20606 (spelling mistake in Austrian provinces)
+UPDATE civicrm_state_province
+   SET name = 'Niederösterreich'
+ WHERE country_id = 1014
+   AND name = 'Niederosterreich';
+
+UPDATE civicrm_state_province
+   SET name = 'Oberösterreich'
+ WHERE country_id = 1014
+   AND name = 'Oberosterreich';
-- 
2.25.1