From 884a7ce311af031855c2f6f77a15c4ac244ae1a6 Mon Sep 17 00:00:00 2001 From: Rohan Katkar Date: Tue, 8 Jul 2014 16:18:17 +0530 Subject: [PATCH] CRM-14948 Modification in names of Russian provinces. --- CRM/Upgrade/Incremental/sql/4.5.beta2.mysql.tpl | 6 +++--- xml/templates/civicrm_state_province.tpl | 6 +++--- 2 files changed, 6 insertions(+), 6 deletions(-) diff --git a/CRM/Upgrade/Incremental/sql/4.5.beta2.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.5.beta2.mysql.tpl index bb114bbb33..360a9e80f8 100644 --- a/CRM/Upgrade/Incremental/sql/4.5.beta2.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.5.beta2.mysql.tpl @@ -4,8 +4,8 @@ DELETE FROM `civicrm_state_province` WHERE `name` IN ('Komi-Permyatskiy avtonomnyy okrug','Taymyrskiy (Dolgano-Nenetskiy)','Evenkiyskiy avtonomnyy okrug','Koryakskiy avtonomnyy okrug','Ust\'-Ordynskiy Buryatskiy','Aginskiy Buryatskiy avtonomnyy'); --CRM-14948 To update new list of new Russian provinance -UPDATE `civicrm_state_province` SET `name`='Permskiy kray',`abbreviation`='PEK',`country_id`= 1177 WHERE `id` = 4270; +UPDATE `civicrm_state_province` SET `name`='Perm krai',`abbreviation`='PEK',`country_id`= 1177 WHERE `id` = 4270; -UPDATE `civicrm_state_province` SET `name`='Kamchatskiy kray',`country_id`= 1177 WHERE `id` = 4252; +UPDATE `civicrm_state_province` SET `name`='Kamchatka Krai',`country_id`= 1177 WHERE `id` = 4252; -UPDATE `civicrm_state_province` SET `name`='Zabaykal skiy kray',`abbreviation`='ZSK',`country_id`= 1177 WHERE `id` = 4247; \ No newline at end of file +UPDATE `civicrm_state_province` SET `name`='Zabaykalsky Krai',`abbreviation`='ZSK',`country_id`= 1177 WHERE `id` = 4247; \ No newline at end of file diff --git a/xml/templates/civicrm_state_province.tpl b/xml/templates/civicrm_state_province.tpl index 5c9853cc25..c643bd3aff 100644 --- a/xml/templates/civicrm_state_province.tpl +++ b/xml/templates/civicrm_state_province.tpl @@ -2703,12 +2703,12 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES (4244, 1177, "BEL", "Belgorodskaya oblast\'"), (4245, 1177, "BRY", "Bryanskaya oblast\'"), (4246, 1177, "CHE", "Chelyabinskaya oblast\'"), -(4247, 1177, "ZSK", "Zabaykal'skiy kray\'"), +(4247, 1177, "ZSK", "Zabaykalsky Krai\'"), (4248, 1177, "IRK", "Irkutskaya oblast\'"), (4249, 1177, "IVA", "Ivanovskaya oblast\'"), (4250, 1177, "KGD", "Kaliningradskaya oblast\'"), (4251, 1177, "KLU", "Kaluzhskaya oblast\'"), -(4252, 1177, "KAM", "Kamchatskiy kray\'"), +(4252, 1177, "KAM", "Kamchatka Krai\'"), (4253, 1177, "KEM", "Kemerovskaya oblast\'"), (4254, 1177, "KIR", "Kirovskaya oblast\'"), (4255, 1177, "KOS", "Kostromskaya oblast\'"), @@ -2726,7 +2726,7 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES (4267, 1177, "ORE", "Orenburgskaya oblast\'"), (4268, 1177, "ORL", "Orlovskaya oblast\'"), (4269, 1177, "PNZ", "Penzenskaya oblast\'"), -(4270, 1177, "PEK", "Permskiy kray\'"), +(4270, 1177, "PEK", "Perm krai\'"), (4271, 1177, "PSK", "Pskovskaya oblast\'"), (4272, 1177, "ROS", "Rostovskaya oblast\'"), (4273, 1177, "RYA", "Ryazanskaya oblast\'"), -- 2.25.1