[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 4.5.beta2.mysql.tpl

{* file to handle db changes in 4.5.beta2 during upgrade *}

{include file='../CRM/Upgrade/4.5.beta2.msg_template/civicrm_msg_template.tpl'}

--CRM-14948 To delete list of outdated Russian provinance
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`='Perm krai',`abbreviation`='PEK',`country_id`= 1177 WHERE `id` = 4270;

UPDATE `civicrm_state_province` SET `name`='Kamchatka Krai',`country_id`= 1177 WHERE `id` = 4252;

UPDATE `civicrm_state_province` SET `name`='Zabaykalsky Krai',`abbreviation`='ZSK',`country_id`= 1177 WHERE `id` = 4247;
Commit	Line	Data
0589777b	1	{* file to handle db changes in 4.5.beta2 during upgrade *}
95865041	2
7c3d751c DG	3	{include file='../CRM/Upgrade/4.5.beta2.msg_template/civicrm_msg_template.tpl'}
7c3d751c DG	4
95865041 RK	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
884a7ce3	9	UPDATE `civicrm_state_province` SET `name`='Perm krai',`abbreviation`='PEK',`country_id`= 1177 WHERE `id` = 4270;
95865041	10
884a7ce3	11	UPDATE `civicrm_state_province` SET `name`='Kamchatka Krai',`country_id`= 1177 WHERE `id` = 4252;
95865041	12
bc77d7c0	13	UPDATE `civicrm_state_province` SET `name`='Zabaykalsky Krai',`abbreviation`='ZSK',`country_id`= 1177 WHERE `id` = 4247;