| 1 | {* file to handle db changes in 4.5.beta2 during upgrade *} |
| 2 | |
| 3 | {include file='../CRM/Upgrade/4.5.beta2.msg_template/civicrm_msg_template.tpl'} |
| 4 | |
| 5 | --CRM-14948 To delete list of outdated Russian provinance |
| 6 | 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'); |
| 7 | |
| 8 | --CRM-14948 To update new list of new Russian provinance |
| 9 | UPDATE `civicrm_state_province` SET `name`='Perm krai',`abbreviation`='PEK',`country_id`= 1177 WHERE `id` = 4270; |
| 10 | |
| 11 | UPDATE `civicrm_state_province` SET `name`='Kamchatka Krai',`country_id`= 1177 WHERE `id` = 4252; |
| 12 | |
| 13 | UPDATE `civicrm_state_province` SET `name`='Zabaykalsky Krai',`abbreviation`='ZSK',`country_id`= 1177 WHERE `id` = 4247; |