From aab1b4dc61a4793b624f241fe1f098b393004b8a Mon Sep 17 00:00:00 2001 From: jitendrapurohit Date: Tue, 30 Dec 2014 12:25:52 +0530 Subject: [PATCH] upgrade changes for CRM-15765 --- CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl index d27a035602..566717cade 100755 --- a/CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl @@ -122,4 +122,14 @@ VALUES ALTER TABLE civicrm_line_item MODIFY COLUMN qty decimal(20,2); -- CRM-15740 -ALTER TABLE `civicrm_mailing_trackable_url` CHANGE `url` `url` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT; \ No newline at end of file +ALTER TABLE `civicrm_mailing_trackable_url` CHANGE `url` `url` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT; + +-- CRM-15765 missing Indonesian provinces and revise outdated names +INSERT INTO `civicrm_state_province` (`id`, `country_id`, `abbreviation`, `name`) +VALUES (NULL, 1102, "SR", "Sulawesi Barat"), (NULL, 1102, "KT", "Kalimantan Tengah"), (NULL, 1102, "KU", "Kalimantan Utara"); + +UPDATE `civicrm_state_province` SET `name`='Kepulauan Bangka Belitung' WHERE `id` = 3056; +UPDATE `civicrm_state_province` SET `name`='Papua Barat', `abbreviation`='PB' WHERE `id` = 3060; +UPDATE `civicrm_state_province` SET `name`='DKI Jakarta' WHERE `id` = 3083; +UPDATE `civicrm_state_province` SET `name`='DI Yogyakarta' WHERE `id` = 3085; +UPDATE `civicrm_state_province` SET `abbreviation`='KI' WHERE `id` = 3066; -- 2.25.1