| 1 | {* CRM-16846 - This file may have been accidentally skipped and so is conditionally re-run during 4.6.6 upgrade *} |
| 2 | |
| 3 | -- Use proper names for Slovenian municipalities |
| 4 | UPDATE `civicrm_state_province` SET `name` = (N'Ajdovščina') WHERE `id` = 4383; |
| 5 | UPDATE `civicrm_state_province` SET `name` = (N'Braslovče') WHERE `id` = 4392; |
| 6 | UPDATE `civicrm_state_province` SET `name` = (N'Brežice') WHERE `id` = 4395; |
| 7 | UPDATE `civicrm_state_province` SET `name` = (N'Črenšovci') WHERE `id` = 4402; |
| 8 | UPDATE `civicrm_state_province` SET `name` = (N'Črna na Koroškem') WHERE `id` = 4403; |
| 9 | UPDATE `civicrm_state_province` SET `name` = (N'Črnomelj') WHERE `id` = 4404; |
| 10 | UPDATE `civicrm_state_province` SET `name` = (N'Divača') WHERE `id` = 4406; |
| 11 | UPDATE `civicrm_state_province` SET `name` = (N'Domžale') WHERE `id` = 4414; |
| 12 | UPDATE `civicrm_state_province` SET `name` = (N'Gorišnica') WHERE `id` = 4419; |
| 13 | UPDATE `civicrm_state_province` SET `name` = (N'Hoče-Slivnica') WHERE `id` = 4426; |
| 14 | UPDATE `civicrm_state_province` SET `name` = (N'Hodoš') WHERE `id` = 4427; |
| 15 | UPDATE `civicrm_state_province` SET `name` = (N'Horjul') WHERE `id` = 4428; |
| 16 | UPDATE `civicrm_state_province` SET `name` = (N'Ilirska Bistrica') WHERE `id` = 4433; |
| 17 | UPDATE `civicrm_state_province` SET `name` = (N'Ivančna Gorica') WHERE `id` = 4434; |
| 18 | UPDATE `civicrm_state_province` SET `name` = (N'Juršinci') WHERE `id` = 4438; |
| 19 | UPDATE `civicrm_state_province` SET `name` = (N'Kidričevo') WHERE `id` = 4441; |
| 20 | UPDATE `civicrm_state_province` SET `name` = (N'Kočevje') WHERE `id` = 4444; |
| 21 | UPDATE `civicrm_state_province` SET `name` = (N'Križevci') WHERE `id` = 4452; |
| 22 | UPDATE `civicrm_state_province` SET `name` = (N'Krško') WHERE `id` = 4453; |
| 23 | UPDATE `civicrm_state_province` SET `name` = (N'Laško') WHERE `id` = 4456; |
| 24 | UPDATE `civicrm_state_province` SET `name` = (N'Loška dolina') WHERE `id` = 4464; |
| 25 | UPDATE `civicrm_state_province` SET `name` = (N'Loški Potok') WHERE `id` = 4465; |
| 26 | UPDATE `civicrm_state_province` SET `name` = (N'Luče') WHERE `id` = 4467; |
| 27 | UPDATE `civicrm_state_province` SET `name` = (N'Majšperk') WHERE `id` = 4469; |
| 28 | UPDATE `civicrm_state_province` SET `name` = (N'Mengeš') WHERE `id` = 4473; |
| 29 | UPDATE `civicrm_state_province` SET `name` = (N'Mežica') WHERE `id` = 4475; |
| 30 | UPDATE `civicrm_state_province` SET `name` = (N'Miklavž na Dravskem polju') WHERE `id` = 4476; |
| 31 | UPDATE `civicrm_state_province` SET `name` = (N'Mirna Peč') WHERE `id` = 4478; |
| 32 | UPDATE `civicrm_state_province` SET `name` = (N'Moravče') WHERE `id` = 4480; |
| 33 | UPDATE `civicrm_state_province` SET `name` = (N'Novo mesto') WHERE `id` = 4488; |
| 34 | UPDATE `civicrm_state_province` SET `name` = (N'Sveti Andraž v Slovenskih goricah') WHERE `id` = 4490; |
| 35 | UPDATE `civicrm_state_province` SET `name` = (N'Šalovci') WHERE `id` = 4492; |
| 36 | UPDATE `civicrm_state_province` SET `name` = (N'Šempeter-Vrtojba') WHERE `id` = 4493; |
| 37 | UPDATE `civicrm_state_province` SET `name` = (N'Šenčur') WHERE `id` = 4494; |
| 38 | UPDATE `civicrm_state_province` SET `name` = (N'Šentilj') WHERE `id` = 4495; |
| 39 | UPDATE `civicrm_state_province` SET `name` = (N'Šentjernej') WHERE `id` = 4496; |
| 40 | UPDATE `civicrm_state_province` SET `name` = (N'Šentjur') WHERE `id` = 4497; |
| 41 | UPDATE `civicrm_state_province` SET `name` = (N'Škocjan') WHERE `id` = 4498; |
| 42 | UPDATE `civicrm_state_province` SET `name` = (N'Škofja Loka') WHERE `id` = 4499; |
| 43 | UPDATE `civicrm_state_province` SET `name` = (N'Škofljica') WHERE `id` = 4500; |
| 44 | UPDATE `civicrm_state_province` SET `name` = (N'Šmarje pri Jelšah') WHERE `id` = 4501; |
| 45 | UPDATE `civicrm_state_province` SET `name` = (N'Šmartno ob Paki') WHERE `id` = 4502; |
| 46 | UPDATE `civicrm_state_province` SET `name` = (N'Šmartno pri Litiji') WHERE `id` = 4503; |
| 47 | UPDATE `civicrm_state_province` SET `name` = (N'Šoštanj') WHERE `id` = 4504; |
| 48 | UPDATE `civicrm_state_province` SET `name` = (N'Štore') WHERE `id` = 4505; |
| 49 | UPDATE `civicrm_state_province` SET `name` = (N'Tišina') WHERE `id` = 4507; |
| 50 | UPDATE `civicrm_state_province` SET `name` = (N'Trbovlje') WHERE `id` = 4509; |
| 51 | UPDATE `civicrm_state_province` SET `name` = (N'Tržič') WHERE `id` = 4512; |
| 52 | UPDATE `civicrm_state_province` SET `name` = (N'Turnišče') WHERE `id` = 4514; |
| 53 | UPDATE `civicrm_state_province` SET `name` = (N'Velike Lašče') WHERE `id` = 4517; |
| 54 | UPDATE `civicrm_state_province` SET `name` = (N'Veržej') WHERE `id` = 4518; |
| 55 | UPDATE `civicrm_state_province` SET `name` = (N'Zavrč') WHERE `id` = 4527; |
| 56 | UPDATE `civicrm_state_province` SET `name` = (N'Zreče') WHERE `id` = 4528; |
| 57 | UPDATE `civicrm_state_province` SET `name` = (N'Žalec') WHERE `id` = 4529; |
| 58 | UPDATE `civicrm_state_province` SET `name` = (N'Železniki') WHERE `id` = 4530; |
| 59 | UPDATE `civicrm_state_province` SET `name` = (N'Žetale') WHERE `id` = 4531; |
| 60 | UPDATE `civicrm_state_province` SET `name` = (N'Žiri') WHERE `id` = 4532; |
| 61 | UPDATE `civicrm_state_province` SET `name` = (N'Žirovnica') WHERE `id` = 4533; |
| 62 | UPDATE `civicrm_state_province` SET `name` = (N'Žužemberk') WHERE `id` = 4534; |
| 63 | |
| 64 | -- Add missing Slovenian municipalities |
| 65 | INSERT INTO civicrm_state_province (country_id, abbreviation, name) |
| 66 | VALUES |
| 67 | (1193, "86", "Ankaran"), |
| 68 | (1193, "87", "Apače"), |
| 69 | (1193, "88", "Cirkulane"), |
| 70 | (1193, "89", "Gorje"), |
| 71 | (1193, "90", "Kostanjevica na Krki"), |
| 72 | (1193, "91", "Log-Dragomer"), |
| 73 | (1193, "92", "Makole"), |
| 74 | (1193, "93", "Mirna"), |
| 75 | (1193, "94", "Mokronog-Trebelno"), |
| 76 | (1193, "95", "Odranci"), |
| 77 | (1193, "96", "Oplotnica"), |
| 78 | (1193, "97", "Ormož"), |
| 79 | (1193, "98", "Osilnica"), |
| 80 | (1193, "99", "Pesnica"), |
| 81 | (1193, "100", "Piran"), |
| 82 | (1193, "101", "Pivka"), |
| 83 | (1193, "102", "Podčetrtek"), |
| 84 | (1193, "103", "Podlehnik"), |
| 85 | (1193, "104", "Podvelka"), |
| 86 | (1193, "105", "Poljčane"), |
| 87 | (1193, "106", "Polzela"), |
| 88 | (1193, "107", "Postojna"), |
| 89 | (1193, "108", "Prebold"), |
| 90 | (1193, "109", "Preddvor"), |
| 91 | (1193, "110", "Prevalje"), |
| 92 | (1193, "111", "Ptuj"), |
| 93 | (1193, "112", "Puconci"), |
| 94 | (1193, "113", "Rače-Fram"), |
| 95 | (1193, "114", "Radeče"), |
| 96 | (1193, "115", "Radenci"), |
| 97 | (1193, "139", "Radlje ob Dravi"), |
| 98 | (1193, "145", "Radovljica"), |
| 99 | (1193, "171", "Ravne na Koroškem"), |
| 100 | (1193, "172", "Razkrižje"), |
| 101 | (1193, "173", "Rečica ob Savinji"), |
| 102 | (1193, "174", "Renče-Vogrsko"), |
| 103 | (1193, "175", "Ribnica"), |
| 104 | (1193, "176", "Ribnica na Pohorju"), |
| 105 | (1193, "177", "Rogaška Slatina"), |
| 106 | (1193, "178", "Rogašovci"), |
| 107 | (1193, "179", "Rogatec"), |
| 108 | (1193, "180", "Ruše"), |
| 109 | (1193, "195", "Selnica ob Dravi"), |
| 110 | (1193, "196", "Semič"), |
| 111 | (1193, "197", "Šentrupert"), |
| 112 | (1193, "198", "Sevnica"), |
| 113 | (1193, "199", "Sežana"), |
| 114 | (1193, "200", "Slovenj Gradec"), |
| 115 | (1193, "201", "Slovenska Bistrica"), |
| 116 | (1193, "202", "Slovenske Konjice"), |
| 117 | (1193, "203", "Šmarješke Toplice"), |
| 118 | (1193, "204", "Sodražica"), |
| 119 | (1193, "205", "Solčava"), |
| 120 | (1193, "206", "Središče ob Dravi"), |
| 121 | (1193, "207", "Starše"), |
| 122 | (1193, "208", "Straža"), |
| 123 | (1193, "209", "Sveta Trojica v Slovenskih goricah"), |
| 124 | (1193, "210", "Sveti Jurij v Slovenskih goricah"), |
| 125 | (1193, "211", "Sveti Tomaž"), |
| 126 | (1193, "212", "Vodice"); |