From f51872c569dee969db7a8e83f03dad7fa0392106 Mon Sep 17 00:00:00 2001 From: jsnyder83 Date: Mon, 29 Dec 2014 13:55:55 +0700 Subject: [PATCH] Added missing Indonesian provinces and revised outdated names --- xml/templates/civicrm_state_province.tpl | 14 +++++++++----- 1 file changed, 9 insertions(+), 5 deletions(-) diff --git a/xml/templates/civicrm_state_province.tpl b/xml/templates/civicrm_state_province.tpl index 87a26ed772..af6c153ae4 100644 --- a/xml/templates/civicrm_state_province.tpl +++ b/xml/templates/civicrm_state_province.tpl @@ -1538,11 +1538,11 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES (3053, 1099, "TB", "Tatabánya"), (3054, 1099, "ZE", "Zalaegerszeg"), (3055, 1102, "BA", "Bali"), -(3056, 1102, "BB", "Bangka Belitung"), +(3056, 1102, "BB", "Kepulauan Bangka Belitung"), -- changed from "Bangka Belitung" (3057, 1102, "BT", "Banten"), (3058, 1102, "BE", "Bengkulu"), (3059, 1102, "GO", "Gorontalo"), -(3060, 1102, "IJ", "Irian Jaya"), +(3060, 1102, "PB", "Papua Barat"), -- changed from "IJ" and "Irian Jaya" (3061, 1102, "JA", "Jambi"), (3062, 1102, "JB", "Jawa Barat"), (3063, 1102, "JT", "Jawa Tengah"), @@ -1565,9 +1565,9 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES (3080, 1102, "SB", "Sumatra Barat"), (3081, 1102, "SS", "Sumatra Selatan"), (3082, 1102, "SU", "Sumatera Utara"), -(3083, 1102, "JK", "Jakarta Raya"), +(3083, 1102, "JK", "DKI Jakarta"), -- changed from "Jakarta Raya" (3084, 1102, "AC", "Aceh"), -(3085, 1102, "YO", "Yogyakarta"), +(3085, 1102, "YO", "DI Yogyakarta"), -- changed from "Yogyakarta" (3086, 1105, "C", "Cork"), (3087, 1105, "CE", "Clare"), (3088, 1105, "CN", "Cavan"), @@ -3911,4 +3911,8 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES (NULL, 1044, "AP", "Arica y Parinacota"), -- Add missing Peruvian State (Amazonas) -(NULL, 1169, "AMA", "Amazonas"); +(NULL, 1169, "AMA", "Amazonas"), + +-- Add missing Indonesian provinces (Kalimantan Tengah, Sulawesi Barat) and revised outdated names in code above +(NULL, 1102, "KLTG", "Kalimantan Tengah"), -- added +(NULL, 1102, "SLBT", "Sulawesi Barat"); -- added -- 2.25.1