From 043049203c0ae8e1b4672c2eefa860032859bea2 Mon Sep 17 00:00:00 2001 From: Jaka Kranjc Date: Sat, 17 Jan 2015 22:41:45 +0100 Subject: [PATCH] civicrm_state_province.tpl: added missing Slovenian "provinces" --- .../Incremental/sql/4.6.alpha3.mysql.tpl | 62 ++++++++++++++++++ xml/templates/civicrm_state_province.tpl | 64 ++++++++++++++++++- 2 files changed, 125 insertions(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/4.6.alpha3.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.6.alpha3.mysql.tpl index e5633c56d0..1ef31aeb35 100644 --- a/CRM/Upgrade/Incremental/sql/4.6.alpha3.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.6.alpha3.mysql.tpl @@ -60,3 +60,65 @@ UPDATE `civicrm_state_province` SET `name` = (N'Žetale') WHERE `id` = 4531; UPDATE `civicrm_state_province` SET `name` = (N'Žiri') WHERE `id` = 4532; UPDATE `civicrm_state_province` SET `name` = (N'Žirovnica') WHERE `id` = 4533; UPDATE `civicrm_state_province` SET `name` = (N'Žužemberk') WHERE `id` = 4534; + +-- Add missing Slovenian municipalities +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "86", (N'Ankaran')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "87", (N'Apače')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "88", (N'Cirkulane')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "89", (N'Gorje')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "90", (N'Kostanjevica na Krki')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "91", (N'Log-Dragomer')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "92", (N'Makole')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "93", (N'Mirna')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "94", (N'Mokronog-Trebelno')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "95", (N'Odranci')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "96", (N'Oplotnica')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "97", (N'Ormož')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "98", (N'Osilnica')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "99", (N'Pesnica')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "100", (N'Piran')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "101", (N'Pivka')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "102", (N'Podčetrtek')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "103", (N'Podlehnik')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "104", (N'Podvelka')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "105", (N'Poljčane')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "106", (N'Polzela')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "107", (N'Postojna')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "108", (N'Prebold')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "109", (N'Preddvor')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "110", (N'Prevalje')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "111", (N'Ptuj')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "112", (N'Puconci')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "113", (N'Rače-Fram')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "114", (N'Radeče')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "115", (N'Radenci')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "139", (N'Radlje ob Dravi')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "145", (N'Radovljica')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "171", (N'Ravne na Koroškem')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "172", (N'Razkrižje')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "173", (N'Rečica ob Savinji')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "174", (N'Renče-Vogrsko')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "175", (N'Ribnica')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "176", (N'Ribnica na Pohorju')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "177", (N'Rogaška Slatina')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "178", (N'Rogašovci')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "179", (N'Rogatec')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "180", (N'Ruše')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "195", (N'Selnica ob Dravi')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "196", (N'Semič')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "197", (N'Šentrupert')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "198", (N'Sevnica')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "199", (N'Sežana')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "200", (N'Slovenj Gradec')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "201", (N'Slovenska Bistrica')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "202", (N'Slovenske Konjice')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "203", (N'Šmarješke Toplice')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "204", (N'Sodražica')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "205", (N'Solčava')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "206", (N'Središče ob Dravi')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "207", (N'Starše')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "208", (N'Straža')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "209", (N'Sveta Trojica v Slovenskih goricah')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "210", (N'Sveti Jurij v Slovenskih goricah')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "211", (N'Sveti Tomaž')); +INSERT INTO civicrm_state_province (country_id, abbreviation, name) VALUES (1193, "212", (N'Vodice')); diff --git a/xml/templates/civicrm_state_province.tpl b/xml/templates/civicrm_state_province.tpl index beaaf25722..296786b001 100644 --- a/xml/templates/civicrm_state_province.tpl +++ b/xml/templates/civicrm_state_province.tpl @@ -3916,4 +3916,66 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES -- Add missing Indonesian provinces (Kalimantan Tengah, Sulawesi Barat, Kalimantan Utara) and revised outdated names in code above (NULL, 1102, "KT", "Kalimantan Tengah"), (NULL, 1102, "SR", "Sulawesi Barat"), -(NULL, 1102, "KU", "Kalimantan Utara"); +(NULL, 1102, "KU", "Kalimantan Utara"), + +-- Add missing Slovenian municipalities +(NULL, 1193, "86", "Ankaran"), +(NULL, 1193, "87", "Apače"), +(NULL, 1193, "88", "Cirkulane"), +(NULL, 1193, "89", "Gorje"), +(NULL, 1193, "90", "Kostanjevica na Krki"), +(NULL, 1193, "91", "Log-Dragomer"), +(NULL, 1193, "92", "Makole"), +(NULL, 1193, "93", "Mirna"), +(NULL, 1193, "94", "Mokronog-Trebelno"), +(NULL, 1193, "95", "Odranci"), +(NULL, 1193, "96", "Oplotnica"), +(NULL, 1193, "97", "Ormož"), +(NULL, 1193, "98", "Osilnica"), +(NULL, 1193, "99", "Pesnica"), +(NULL, 1193, "100", "Piran"), +(NULL, 1193, "101", "Pivka"), +(NULL, 1193, "102", "Podčetrtek"), +(NULL, 1193, "103", "Podlehnik"), +(NULL, 1193, "104", "Podvelka"), +(NULL, 1193, "105", "Poljčane"), +(NULL, 1193, "106", "Polzela"), +(NULL, 1193, "107", "Postojna"), +(NULL, 1193, "108", "Prebold"), +(NULL, 1193, "109", "Preddvor"), +(NULL, 1193, "110", "Prevalje"), +(NULL, 1193, "111", "Ptuj"), +(NULL, 1193, "112", "Puconci"), +(NULL, 1193, "113", "Rače-Fram"), +(NULL, 1193, "114", "Radeče"), +(NULL, 1193, "115", "Radenci"), +(NULL, 1193, "139", "Radlje ob Dravi"), +(NULL, 1193, "145", "Radovljica"), +(NULL, 1193, "171", "Ravne na Koroškem"), +(NULL, 1193, "172", "Razkrižje"), +(NULL, 1193, "173", "Rečica ob Savinji"), +(NULL, 1193, "174", "Renče-Vogrsko"), +(NULL, 1193, "175", "Ribnica"), +(NULL, 1193, "176", "Ribnica na Pohorju"), +(NULL, 1193, "177", "Rogaška Slatina"), +(NULL, 1193, "178", "Rogašovci"), +(NULL, 1193, "179", "Rogatec"), +(NULL, 1193, "180", "Ruše"), +(NULL, 1193, "195", "Selnica ob Dravi"), +(NULL, 1193, "196", "Semič"), +(NULL, 1193, "197", "Šentrupert"), +(NULL, 1193, "198", "Sevnica"), +(NULL, 1193, "199", "Sežana"), +(NULL, 1193, "200", "Slovenj Gradec"), +(NULL, 1193, "201", "Slovenska Bistrica"), +(NULL, 1193, "202", "Slovenske Konjice"), +(NULL, 1193, "203", "Šmarješke Toplice"), +(NULL, 1193, "204", "Sodražica"), +(NULL, 1193, "205", "Solčava"), +(NULL, 1193, "206", "Središče ob Dravi"), +(NULL, 1193, "207", "Starše"), +(NULL, 1193, "208", "Straža"), +(NULL, 1193, "209", "Sveta Trojica v Slovenskih goricah"), +(NULL, 1193, "210", "Sveti Jurij v Slovenskih goricah"), +(NULL, 1193, "211", "Sveti Tomaž"), +(NULL, 1193, "212", "Vodice"); -- 2.25.1