CRM/Upgrade/Incremental/sql/4.5.beta2.mysql.tpl

   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;