Commit | Line | Data |
---|---|---|
aac793a0 | 1 | {* CRM-16846 - This file may have been accidentally skipped and so is conditionally re-run during 4.6.6 upgrade *} |
f7bfe544 | 2 | |
36876ea7 JK |
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; | |
04304920 JK |
63 | |
64 | -- Add missing Slovenian municipalities | |
aac793a0 CW |
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"); |