Commit | Line | Data |
---|---|---|
644f8ee5 SJ |
1 | ALTER TABLE geoloc_countries MODIFY COLUMN phoneFormat VARCHAR(255) NOT NULL DEFAULT ""; |
2 | ||
3 | DELETE FROM geoloc_countries | |
eb209054 | 4 | WHERE iso_3166_1_a2 = "TP" OR iso_3166_1_a2 = "YU" OR iso_3166_1_a2 = "00"; |
644f8ee5 SJ |
5 | |
6 | INSERT INTO geoloc_countries (iso_3166_1_a2, iso_3166_1_a3, iso_3166_1_num, worldRegion, | |
7 | country, countryFR, capital, nationalityFR, | |
8 | licensePlate, belongsTo, phonePrefix) | |
9 | VALUES ("AX", "ALA", 248, "EU", "Åland, Îles", "Åland Islands", "Mariehamn", NULL, "AX", "FI", 358), | |
10 | ("GG", "GGY", 831, "EU", "Guernsey", "Guernesey", "St Peter Port", NULL, "GBG", "GB", 44), | |
11 | ("GY", "GUY", 328, NULL, "Guyana", "Guyana", "Georgetown", "Guyanien", "GUY", NULL, 592), | |
12 | ("HK", "HKG", 344, NULL, "Hong Kong", "Hong-Kong", "Hong-Kong", "Hongkongais", "HK", NULL, 852), | |
13 | ("IM", "IMN", 833, NULL, "Isle of Man", "Île de Man", "Douglas", "Mannois", "GBM", NULL, 44), | |
14 | ("JE", "JEY", 832, NULL, "Jersey", "Jersey", "Saint-Hélier", "Jersiais", "GBJ", NULL, 44), | |
15 | ("MO", "MAC", 446, NULL, "Macao", "Macao", "Macao", "Macanais", "MO", NULL, 853), | |
16 | ("ME", "MNE", 499, NULL, "Montenegro", "Monténégro", "Podgorica", "Monténégrin", "MNE", | |
17 | NULL, 382), | |
18 | ("PS", "PSE", 275, NULL, "Palestinian Territory, Occupied", "Palestiniens occupé, Territoire", | |
19 | "Jérusalem", "Palestinien", "PS", NULL, 970), | |
20 | ("BL", "BLM", 652, "EU", "Saint Barthélemy", "Saint-Barthélemy", "Gustavia", NULL, "F", "FR", 33), | |
21 | ("MF", "MAF", 663, "EU", "Saint Martin", "Saint-Martin", "Marigot", NULL, "F", "FR", 33), | |
22 | ("PM", "SPM", 666, "EU", "Saint Pierre and Miquelon", "Saint-Pierre-et-Miquelon", "Saint-Pierre", | |
23 | NULL, "F", "FR", 33), | |
24 | ("RS", "SRB", 688, NULL, "Serbia", "Serbie", "Belgrade", "Serbe", "SRB", NULL, 381), | |
25 | ("TL", "TLS", 626, NULL, "Timor-Leste", "Timor-Leste", "Dili", "Timorais", "TL", NULL, 670); | |
26 | ||
27 | UPDATE geoloc_countries | |
28 | SET country = "Croatia" | |
29 | WHERE iso_3166_1_a2 = "HR"; | |
30 | ||
31 | UPDATE geoloc_countries | |
32 | SET country = "Slovakia" | |
33 | WHERE iso_3166_1_a2 = "SK"; | |
34 | ||
35 | UPDATE geoloc_countries | |
36 | SET country = "Saint Helena" | |
37 | WHERE iso_3166_1_a2 = "SH"; | |
38 | ||
39 | UPDATE geoloc_countries | |
40 | SET countryFR = "Antigua-et-Barbuda" | |
41 | WHERE iso_3166_1_a2 = "AG"; | |
42 | ||
43 | UPDATE geoloc_countries | |
44 | SET countryFR = "Cameroun" | |
45 | WHERE iso_3166_1_a2 = "CM"; | |
46 | ||
47 | UPDATE geoloc_countries | |
48 | SET countryFR = "Centrafricaine, République" | |
49 | WHERE iso_3166_1_a2 = "CF"; | |
50 | ||
51 | UPDATE geoloc_countries | |
52 | SET countryFR = "Cocos (Keeling), Îles" | |
53 | WHERE iso_3166_1_a2 = "CC"; | |
54 | ||
55 | UPDATE geoloc_countries | |
56 | SET countryFR = "Égypte" | |
57 | WHERE iso_3166_1_a2 = "EG"; | |
58 | ||
59 | UPDATE geoloc_countries | |
60 | SET countryFR = "Émirats arabes unis" | |
61 | WHERE iso_3166_1_a2 = "AE"; | |
62 | ||
63 | UPDATE geoloc_countries | |
64 | SET countryFR = "Équateur" | |
65 | WHERE iso_3166_1_a2 = "EC"; | |
66 | ||
67 | UPDATE geoloc_countries | |
68 | SET countryFR = "Érythrée" | |
69 | WHERE iso_3166_1_a2 = "ER"; | |
70 | ||
71 | UPDATE geoloc_countries | |
72 | SET countryFR = "Èthiopie" | |
73 | WHERE iso_3166_1_a2 = "ET"; | |
74 | ||
75 | UPDATE geoloc_countries | |
76 | SET countryFR = "États-Unis" | |
77 | WHERE iso_3166_1_a2 = "US"; | |
78 | ||
79 | UPDATE geoloc_countries | |
80 | SET countryFR = "Géorgie du Sud et les Îles Sandwich du Sud" | |
81 | WHERE iso_3166_1_a2 = "GS"; | |
82 | ||
83 | UPDATE geoloc_countries | |
84 | SET countryFR = "Guinée-Bissau" | |
85 | WHERE iso_3166_1_a2 = "GW"; | |
86 | ||
87 | UPDATE geoloc_countries | |
88 | SET countryFR = "Heard, Île et MacDonald" | |
89 | WHERE iso_3166_1_a2 = "HM"; | |
90 | ||
91 | UPDATE geoloc_countries | |
92 | SET countryFR = "Îles mineures éloignées des États-Unis" | |
93 | WHERE iso_3166_1_a2 = "UM"; | |
94 | ||
95 | UPDATE geoloc_countries | |
96 | SET countryFR = "Îles vierges britanniques", country = "Virgin Islands, British" | |
97 | WHERE iso_3166_1_a2 = "VG"; | |
98 | ||
99 | UPDATE geoloc_countries | |
100 | SET countryFR = "Îles vierges des États-Unis", country = "Virgin Islands, US" | |
101 | WHERE iso_3166_1_a2 = "VI"; | |
102 | ||
103 | UPDATE geoloc_countries | |
104 | SET countryFR = "Iran, République islamique d'" | |
105 | WHERE iso_3166_1_a2 = "IR"; | |
106 | ||
107 | UPDATE geoloc_countries | |
108 | SET countryFR = "Lao, République démocratique populaire" | |
109 | WHERE iso_3166_1_a2 = "LA"; | |
110 | ||
111 | UPDATE geoloc_countries | |
112 | SET countryFR = "Macédoine, L'Ex-République Yougoslave" | |
113 | WHERE iso_3166_1_a2 = "MK"; | |
114 | ||
115 | UPDATE geoloc_countries | |
116 | SET countryFR = "Micronésie, États fédérés de" | |
117 | WHERE iso_3166_1_a2 = "FM"; | |
118 | ||
119 | UPDATE geoloc_countries | |
120 | SET countryFR = "Océan Indien, Territoire britannique de l'" | |
121 | WHERE iso_3166_1_a2 = "IO"; | |
122 | ||
123 | UPDATE geoloc_countries | |
124 | SET countryFR = "Russie, Fédération de" | |
125 | WHERE iso_3166_1_a2 = "RU"; | |
126 | ||
127 | UPDATE geoloc_countries | |
128 | SET countryFR = "Saint-Siège (État de la Cité du Vatican)" | |
129 | WHERE iso_3166_1_a2 = "VA"; | |
130 | ||
131 | UPDATE geoloc_countries | |
132 | SET countryFR = "Saint-Kitts-et-Nevis" | |
133 | WHERE iso_3166_1_a2 = "KN"; | |
134 | ||
135 | UPDATE geoloc_countries | |
136 | SET countryFR = "Congo, La République démocratique du" | |
137 | WHERE iso_3166_1_a2 = "CD"; | |
138 | ||
139 | UPDATE geoloc_countries | |
140 | SET countryFR = "Saint-Vincent-et-les-Grenadines" | |
141 | WHERE iso_3166_1_a2 = "VC"; | |
142 | ||
143 | UPDATE geoloc_countries | |
144 | SET countryFR = "Samoa" | |
145 | WHERE iso_3166_1_a2 = "WS"; | |
146 | ||
147 | UPDATE geoloc_countries | |
148 | SET countryFR = "Sao Tomé-et-Principe" | |
149 | WHERE iso_3166_1_a2 = "ST"; | |
150 | ||
151 | UPDATE geoloc_countries | |
152 | SET countryFR = "Svalbard et Île Jan Mayen" | |
153 | WHERE iso_3166_1_a2 = "SJ"; | |
154 | ||
155 | UPDATE geoloc_countries | |
156 | SET countryFR = "Trinité-et-Tobago" | |
157 | WHERE iso_3166_1_a2 = "TT"; | |
158 | ||
159 | UPDATE geoloc_countries | |
160 | SET countryFR = "Venezuela" | |
161 | WHERE iso_3166_1_a2 = "VE"; | |
162 | ||
163 | UPDATE geoloc_countries | |
164 | SET countryFR = "Viet Nam" | |
165 | WHERE iso_3166_1_a2 = "VN"; | |
166 | ||
167 | UPDATE geoloc_countries | |
168 | SET countryFR = "Wallis et Futuna", country = "Wallis and Futuna" | |
169 | WHERE iso_3166_1_a2 = "WF"; | |
170 | ||
171 | UPDATE geoloc_countries | |
172 | SET countryFR = "Yémen" | |
173 | WHERE iso_3166_1_a2 = "YE"; | |
174 | ||
175 | UPDATE geoloc_countries | |
176 | SET belongsTo = "FR" | |
177 | WHERE iso_3166_1_a2 = "GF" OR iso_3166_1_a2 = "PF" OR iso_3166_1_a2 = "TF" | |
178 | OR iso_3166_1_a2 = "GP" OR iso_3166_1_a2 = "MQ" OR iso_3166_1_a2 = "YT" | |
179 | OR iso_3166_1_a2 = "NC" OR iso_3166_1_a2 = "RE"; | |
180 | ||
181 | UPDATE geoloc_countries | |
182 | SET belongsTo = "US", nationalityFR = NULL | |
183 | WHERE iso_3166_1_a2 = "UM"; | |
184 | ||
185 | UPDATE geoloc_countries | |
186 | SET nationalityFR = "Afghan" | |
187 | WHERE iso_3166_1_a2 = "AF"; | |
188 | ||
189 | UPDATE geoloc_countries | |
190 | SET nationalityFR = "Andorran" | |
191 | WHERE iso_3166_1_a2 = "AD"; | |
192 | ||
193 | UPDATE geoloc_countries | |
194 | SET nationalityFR = NULL, belongsTo = "GB", capital = "The Valley" | |
195 | WHERE iso_3166_1_a2 = "AI"; | |
196 | ||
197 | UPDATE geoloc_countries | |
198 | SET nationalityFR = "Angolais" | |
199 | WHERE iso_3166_1_a2 = "AO"; | |
200 | ||
201 | UPDATE geoloc_countries | |
202 | SET nationalityFR = NULL | |
203 | WHERE iso_3166_1_a2 = "AQ"; | |
204 | ||
205 | UPDATE geoloc_countries | |
206 | SET nationalityFR = "Antiguais" | |
207 | WHERE iso_3166_1_a2 = "AG"; | |
208 | ||
209 | UPDATE geoloc_countries | |
210 | SET nationalityFR = NULL, belongsTo = "NL", capital = "Willemstad" | |
211 | WHERE iso_3166_1_a2 = "AN"; | |
212 | ||
213 | UPDATE geoloc_countries | |
214 | SET nationalityFR = "Saoudien", capital = "Riyad" | |
215 | WHERE iso_3166_1_a2 = "SA"; | |
216 | ||
217 | UPDATE geoloc_countries | |
218 | SET nationalityFR = "Arménien" | |
219 | WHERE iso_3166_1_a2 = "AM"; | |
220 | ||
221 | UPDATE geoloc_countries | |
222 | SET nationalityFR = "Arubais", capital = "Oranjestad" | |
223 | WHERE iso_3166_1_a2 = "AW"; | |
224 | ||
225 | UPDATE geoloc_countries | |
226 | SET nationalityFR = "Azerbaïdjanais" | |
227 | WHERE iso_3166_1_a2 = "AZ"; | |
228 | ||
229 | UPDATE geoloc_countries | |
230 | SET nationalityFR = "Bahaméen" | |
231 | WHERE iso_3166_1_a2 = "BS"; | |
232 | ||
233 | UPDATE geoloc_countries | |
234 | SET nationalityFR = "Bahreïnien" | |
235 | WHERE iso_3166_1_a2 = "BH"; | |
236 | ||
237 | UPDATE geoloc_countries | |
238 | SET nationalityFR = "Bangladais" | |
239 | WHERE iso_3166_1_a2 = "BD"; | |
240 | ||
241 | UPDATE geoloc_countries | |
242 | SET nationalityFR = "Barbadien" | |
243 | WHERE iso_3166_1_a2 = "BB"; | |
244 | ||
245 | UPDATE geoloc_countries | |
246 | SET nationalityFR = "Biélorusse", capital = "Minsk" | |
247 | WHERE iso_3166_1_a2 = "BY"; | |
248 | ||
249 | UPDATE geoloc_countries | |
250 | SET nationalityFR = "Béliziens" | |
251 | WHERE iso_3166_1_a2 = "BZ"; | |
252 | ||
253 | UPDATE geoloc_countries | |
254 | SET nationalityFR = NULL, belongsTo = "GB" | |
255 | WHERE iso_3166_1_a2 = "BM"; | |
256 | ||
257 | UPDATE geoloc_countries | |
258 | SET nationalityFR = "Bolivien" | |
259 | WHERE iso_3166_1_a2 = "BO"; | |
260 | ||
261 | UPDATE geoloc_countries | |
262 | SET nationalityFR = "Bosnien" | |
263 | WHERE iso_3166_1_a2 = "BA"; | |
264 | ||
265 | UPDATE geoloc_countries | |
266 | SET nationalityFR = NULL, belongsTo = "NO" | |
267 | WHERE iso_3166_1_a2 = "BV"; | |
268 | ||
269 | UPDATE geoloc_countries | |
270 | SET nationalityFR = "Brunéiens" | |
271 | WHERE iso_3166_1_a2 = "BN"; | |
272 | ||
273 | UPDATE geoloc_countries | |
274 | SET nationalityFR = "Burundais" | |
275 | WHERE iso_3166_1_a2 = "BI"; | |
276 | ||
277 | UPDATE geoloc_countries | |
278 | SET nationalityFR = NULL, belongsTo = "GB", capital = "George Town" | |
279 | WHERE iso_3166_1_a2 = "KY"; | |
280 | ||
281 | UPDATE geoloc_countries | |
282 | SET nationalityFR = "Cap-verdiens" | |
283 | WHERE iso_3166_1_a2 = "CV"; | |
284 | ||
285 | UPDATE geoloc_countries | |
286 | SET nationalityFR = "Centrafricain" | |
287 | WHERE iso_3166_1_a2 = "CF"; | |
288 | ||
289 | UPDATE geoloc_countries | |
290 | SET nationalityFR = NULL, belongsTo = "AU", capital = "Flying Fish Cove" | |
291 | WHERE iso_3166_1_a2 = "CX"; | |
292 | ||
293 | UPDATE geoloc_countries | |
294 | SET nationalityFR = "Chypriotes" | |
295 | WHERE iso_3166_1_a2 = "CY"; | |
296 | ||
297 | UPDATE geoloc_countries | |
298 | SET nationalityFR = NULL, belongsTo = "AU", capital = "West Island" | |
299 | WHERE iso_3166_1_a2 = "CC"; | |
300 | ||
301 | UPDATE geoloc_countries | |
302 | SET nationalityFR = "Comorien" | |
303 | WHERE iso_3166_1_a2 = "KM"; | |
304 | ||
305 | UPDATE geoloc_countries | |
306 | SET nationalityFR = "Congolais" | |
307 | WHERE iso_3166_1_a2 = "CG"; | |
308 | ||
309 | UPDATE geoloc_countries | |
310 | SET nationalityFR = "Nord-Coréens" | |
311 | WHERE iso_3166_1_a2 = "CK"; | |
312 | ||
313 | UPDATE geoloc_countries | |
314 | SET nationalityFR = "Maori des îles Cook" | |
315 | WHERE iso_3166_1_a2 = "KP"; | |
316 | ||
317 | UPDATE geoloc_countries | |
318 | SET nationalityFR = "Djibouti" | |
319 | WHERE iso_3166_1_a2 = "DJ"; | |
320 | ||
321 | UPDATE geoloc_countries | |
322 | SET nationalityFR = "Dominicain" | |
323 | WHERE iso_3166_1_a2 = "DO"; | |
324 | ||
325 | UPDATE geoloc_countries | |
326 | SET nationalityFR = "Dominiquais" | |
327 | WHERE iso_3166_1_a2 = "DM"; | |
328 | ||
329 | UPDATE geoloc_countries | |
330 | SET nationalityFR = "Salvadorien" | |
331 | WHERE iso_3166_1_a2 = "SV"; | |
332 | ||
333 | UPDATE geoloc_countries | |
334 | SET nationalityFR = "Émirien" | |
335 | WHERE iso_3166_1_a2 = "AE"; | |
336 | ||
337 | UPDATE geoloc_countries | |
338 | SET nationalityFR = "Érythréen" | |
339 | WHERE iso_3166_1_a2 = "ER"; | |
340 | ||
341 | UPDATE geoloc_countries | |
342 | SET nationalityFR = "Éthiopiens" | |
343 | WHERE iso_3166_1_a2 = "ET"; | |
344 | ||
345 | UPDATE geoloc_countries | |
346 | SET nationalityFR = NULL, belongsTo = "GB", capital = "Port Stanley" | |
347 | WHERE iso_3166_1_a2 = "FK"; | |
348 | ||
349 | UPDATE geoloc_countries | |
350 | SET nationalityFR = NULL, belongsTo = "DK" | |
351 | WHERE iso_3166_1_a2 = "FO"; | |
352 | ||
353 | UPDATE geoloc_countries | |
354 | SET nationalityFR = "Fidjiens" | |
355 | WHERE iso_3166_1_a2 = "FJ"; | |
356 | ||
357 | UPDATE geoloc_countries | |
358 | SET nationalityFR = "Gambiens" | |
359 | WHERE iso_3166_1_a2 = "GM"; | |
360 | ||
361 | UPDATE geoloc_countries | |
362 | SET nationalityFR = NULL, belongsTo = "GB", capital = "Grytviken" | |
363 | WHERE iso_3166_1_a2 = "GS"; | |
364 | ||
365 | UPDATE geoloc_countries | |
366 | SET nationalityFR = "Géorgien", capital = "Tbilissi" | |
367 | WHERE iso_3166_1_a2 = "GE"; | |
368 | ||
369 | UPDATE geoloc_countries | |
370 | SET nationalityFR = "Ghanéen" | |
371 | WHERE iso_3166_1_a2 = "GH"; | |
372 | ||
373 | UPDATE geoloc_countries | |
374 | SET nationalityFR = NULL, belongsTo = "GB" | |
375 | WHERE iso_3166_1_a2 = "GI"; | |
376 | ||
377 | UPDATE geoloc_countries | |
378 | SET nationalityFR = "Grenadien" | |
379 | WHERE iso_3166_1_a2 = "GD"; | |
380 | ||
381 | UPDATE geoloc_countries | |
382 | SET nationalityFR = NULL, belongsTo = "DK", capital = "Nuuk" | |
383 | WHERE iso_3166_1_a2 = "GL"; | |
384 | ||
385 | UPDATE geoloc_countries | |
386 | SET nationalityFR = NULL, belongsTo = "US" | |
387 | WHERE iso_3166_1_a2 = "GU"; | |
388 | ||
389 | UPDATE geoloc_countries | |
390 | SET nationalityFR = "Guatémaltèque" | |
391 | WHERE iso_3166_1_a2 = "GT"; | |
392 | ||
393 | UPDATE geoloc_countries | |
394 | SET nationalityFR = "Guinéens" | |
395 | WHERE iso_3166_1_a2 = "GN"; | |
396 | ||
397 | UPDATE geoloc_countries | |
398 | SET nationalityFR = "Bissau-Guinéens" | |
399 | WHERE iso_3166_1_a2 = "GW"; | |
400 | ||
401 | UPDATE geoloc_countries | |
402 | SET nationalityFR = "Équato-Guinéens" | |
403 | WHERE iso_3166_1_a2 = "GQ"; | |
404 | ||
405 | UPDATE geoloc_countries | |
406 | SET nationalityFR = NULL, belongsTo = "FR", capital = "Cayenne" | |
407 | WHERE iso_3166_1_a2 = "GF"; | |
408 | ||
409 | UPDATE geoloc_countries | |
410 | SET nationalityFR = NULL, belongsTo = "AU" | |
411 | WHERE iso_3166_1_a2 = "HM"; | |
412 | ||
413 | UPDATE geoloc_countries | |
414 | SET nationalityFR = "Hondurien" | |
415 | WHERE iso_3166_1_a2 = "HN"; | |
416 | ||
417 | UPDATE geoloc_countries | |
418 | SET nationalityFR = NULL, belongsTo = "GB", capital = "Road Town" | |
419 | WHERE iso_3166_1_a2 = "VG"; | |
420 | ||
421 | UPDATE geoloc_countries | |
422 | SET nationalityFR = NULL, belongsTo = "US", capital = "Charlotte Amalie" | |
423 | WHERE iso_3166_1_a2 = "VI"; | |
424 | ||
425 | UPDATE geoloc_countries | |
426 | SET nationalityFR = "Indonésien", capital = "Jakarta" | |
427 | WHERE iso_3166_1_a2 = "ID"; | |
428 | ||
429 | UPDATE geoloc_countries | |
430 | SET nationalityFR = "Irakien", capital = "Bagdad" | |
431 | WHERE iso_3166_1_a2 = "IQ"; | |
432 | ||
433 | UPDATE geoloc_countries | |
434 | SET nationalityFR = "Jordanien", capital = "Amman" | |
435 | WHERE iso_3166_1_a2 = "JO"; | |
436 | ||
437 | UPDATE geoloc_countries | |
438 | SET capital = "New Delhi" | |
439 | WHERE iso_3166_1_a2 = "IN"; | |
440 | ||
441 | UPDATE geoloc_countries | |
442 | SET capital = "Téhéran" | |
443 | WHERE iso_3166_1_a2 = "IR"; | |
444 | ||
445 | UPDATE geoloc_countries | |
446 | SET capital = "Jérusalem" | |
447 | WHERE iso_3166_1_a2 = "IL"; | |
448 | ||
449 | UPDATE geoloc_countries | |
450 | SET capital = "Tōkyō" | |
451 | WHERE iso_3166_1_a2 = "JP"; | |
452 | ||
453 | UPDATE geoloc_countries | |
454 | SET capital = "Astana" | |
455 | WHERE iso_3166_1_a2 = "KZ"; | |
456 | ||
457 | UPDATE geoloc_countries | |
458 | SET nationalityFR = "Kirghiz", capital = "Bichkek" | |
459 | WHERE iso_3166_1_a2 = "KG"; | |
460 | ||
461 | UPDATE geoloc_countries | |
462 | SET nationalityFR = "Koweïtien", capital = "Koweït" | |
463 | WHERE iso_3166_1_a2 = "KW"; | |
464 | ||
465 | UPDATE geoloc_countries | |
466 | SET nationalityFR = "Kényan" | |
467 | WHERE iso_3166_1_a2 = "KE"; | |
468 | ||
469 | UPDATE geoloc_countries | |
470 | SET nationalityFR = "Gilbertins" | |
471 | WHERE iso_3166_1_a2 = "KI"; | |
472 | ||
473 | UPDATE geoloc_countries | |
474 | SET nationalityFR = "Laotien", capital = "Vientiane" | |
475 | WHERE iso_3166_1_a2 = "LA"; | |
476 | ||
477 | UPDATE geoloc_countries | |
478 | SET nationalityFR = "Lesothans" | |
479 | WHERE iso_3166_1_a2 = "LS"; | |
480 | ||
481 | UPDATE geoloc_countries | |
482 | SET nationalityFR = "Libérien" | |
483 | WHERE iso_3166_1_a2 = "LR"; | |
484 | ||
485 | UPDATE geoloc_countries | |
486 | SET nationalityFR = "Libyen" | |
487 | WHERE iso_3166_1_a2 = "LY"; | |
488 | ||
489 | UPDATE geoloc_countries | |
490 | SET nationalityFR = "Liechtensteinois" | |
491 | WHERE iso_3166_1_a2 = "LI"; | |
492 | ||
493 | UPDATE geoloc_countries | |
494 | SET capital = "Beyrouth" | |
495 | WHERE iso_3166_1_a2 = "LB"; | |
496 | ||
497 | UPDATE geoloc_countries | |
498 | SET nationalityFR = "Malaisien", capital = "Putrajaya" | |
499 | WHERE iso_3166_1_a2 = "MY"; | |
500 | ||
501 | UPDATE geoloc_countries | |
502 | SET nationalityFR = "Malawites" | |
503 | WHERE iso_3166_1_a2 = "MW"; | |
504 | ||
505 | UPDATE geoloc_countries | |
506 | SET nationalityFR = "Maldivien", capital = "Malé" | |
507 | WHERE iso_3166_1_a2 = "MV"; | |
508 | ||
509 | UPDATE geoloc_countries | |
510 | SET nationalityFR = "Maltais" | |
511 | WHERE iso_3166_1_a2 = "MT"; | |
512 | ||
513 | UPDATE geoloc_countries | |
514 | SET nationalityFR = NULL, belongsTo = "US", capital = "Saipan" | |
515 | WHERE iso_3166_1_a2 = "MP"; | |
516 | ||
517 | UPDATE geoloc_countries | |
518 | SET nationalityFR = "Marshallais" | |
519 | WHERE iso_3166_1_a2 = "MH"; | |
520 | ||
521 | UPDATE geoloc_countries | |
522 | SET nationalityFR = "Mauricien" | |
523 | WHERE iso_3166_1_a2 = "MU"; | |
524 | ||
525 | UPDATE geoloc_countries | |
526 | SET nationalityFR = "Mauritanien" | |
527 | WHERE iso_3166_1_a2 = "MR"; | |
528 | ||
529 | UPDATE geoloc_countries | |
530 | SET nationalityFR = "Micronésien" | |
531 | WHERE iso_3166_1_a2 = "FM"; | |
532 | ||
533 | UPDATE geoloc_countries | |
534 | SET nationalityFR = "Moldave" | |
535 | WHERE iso_3166_1_a2 = "MD"; | |
536 | ||
537 | UPDATE geoloc_countries | |
538 | SET nationalityFR = "Monégasque" | |
539 | WHERE iso_3166_1_a2 = "MC"; | |
540 | ||
541 | UPDATE geoloc_countries | |
542 | SET nationalityFR = "Mongol", capital = "Oulan-Bator" | |
543 | WHERE iso_3166_1_a2 = "MN"; | |
544 | ||
545 | UPDATE geoloc_countries | |
546 | SET nationalityFR = NULL, belongsTo = "GB", capital = "Plymouth[" | |
547 | WHERE iso_3166_1_a2 = "MS"; | |
548 | ||
549 | UPDATE geoloc_countries | |
550 | SET nationalityFR = "Mozambicain" | |
551 | WHERE iso_3166_1_a2 = "MZ"; | |
552 | ||
553 | UPDATE geoloc_countries | |
554 | SET nationalityFR = "Birman", capital = "Naypyidaw" | |
555 | WHERE iso_3166_1_a2 = "MM"; | |
556 | ||
557 | UPDATE geoloc_countries | |
558 | SET capital = "Mamoudzou" | |
559 | WHERE iso_3166_1_a2 = "YT"; | |
560 | ||
561 | UPDATE geoloc_countries | |
562 | SET nationalityFR = "Namibien" | |
563 | WHERE iso_3166_1_a2 = "NA"; | |
564 | ||
565 | UPDATE geoloc_countries | |
566 | SET nationalityFR = "Nauruan" | |
567 | WHERE iso_3166_1_a2 = "NR"; | |
568 | ||
569 | UPDATE geoloc_countries | |
570 | SET nationalityFR = "Népalais", capital = "Katmandou" | |
571 | WHERE iso_3166_1_a2 = "NP"; | |
572 | ||
573 | UPDATE geoloc_countries | |
574 | SET nationalityFR = "Nicaraguayen" | |
575 | WHERE iso_3166_1_a2 = "NI"; | |
576 | ||
577 | UPDATE geoloc_countries | |
578 | SET nationalityFR = "Nigérien" | |
579 | WHERE iso_3166_1_a2 = "NE"; | |
580 | ||
581 | UPDATE geoloc_countries | |
582 | SET nationalityFR = "Nigérian" | |
583 | WHERE iso_3166_1_a2 = "NG"; | |
584 | ||
585 | UPDATE geoloc_countries | |
586 | SET nationalityFR = "Niuéen" | |
587 | WHERE iso_3166_1_a2 = "NU"; | |
588 | ||
589 | UPDATE geoloc_countries | |
590 | SET nationalityFR = NULL, belongsTo = "AU", capital = "Kingston" | |
591 | WHERE iso_3166_1_a2 = "NF"; | |
592 | ||
593 | UPDATE geoloc_countries | |
594 | SET capital = "Nouméa" | |
595 | WHERE iso_3166_1_a2 = "NC"; | |
596 | ||
597 | UPDATE geoloc_countries | |
598 | SET nationalityFR = NULL, belongsTo = "GB", capital = "Diego Garcia" | |
599 | WHERE iso_3166_1_a2 = "IO"; | |
600 | ||
601 | UPDATE geoloc_countries | |
602 | SET nationalityFR = "Omani", capital = "Mascate" | |
603 | WHERE iso_3166_1_a2 = "OM"; | |
604 | ||
605 | UPDATE geoloc_countries | |
606 | SET nationalityFR = "Ougandais" | |
607 | WHERE iso_3166_1_a2 = "UG"; | |
608 | ||
609 | UPDATE geoloc_countries | |
610 | SET nationalityFR = "Ouzbek", capital = "Tachkent" | |
611 | WHERE iso_3166_1_a2 = "UZ"; | |
612 | ||
613 | UPDATE geoloc_countries | |
614 | SET nationalityFR = "Qatari", capital = "Doha" | |
615 | WHERE iso_3166_1_a2 = "QA"; | |
616 | ||
617 | UPDATE geoloc_countries | |
618 | SET nationalityFR = "Pakistanais", capital = "Islamabad" | |
619 | WHERE iso_3166_1_a2 = "PK"; | |
620 | ||
621 | UPDATE geoloc_countries | |
622 | SET nationalityFR = "Philippins", capital = "Manille" | |
623 | WHERE iso_3166_1_a2 = "PH"; | |
624 | ||
625 | UPDATE geoloc_countries | |
626 | SET nationalityFR = NULL, belongsTo = "GB", capital = "Adamstown" | |
627 | WHERE iso_3166_1_a2 = "PN"; | |
628 | ||
629 | UPDATE geoloc_countries | |
630 | SET capital = "Papeete" | |
631 | WHERE iso_3166_1_a2 = "PF"; | |
632 | ||
633 | UPDATE geoloc_countries | |
634 | SET nationalityFR = "Palaien" | |
635 | WHERE iso_3166_1_a2 = "PW"; | |
636 | ||
637 | UPDATE geoloc_countries | |
638 | SET nationalityFR = "Panaméen" | |
639 | WHERE iso_3166_1_a2 = "PA"; | |
640 | ||
641 | UPDATE geoloc_countries | |
642 | SET nationalityFR = "Papouasien" | |
643 | WHERE iso_3166_1_a2 = "PG"; | |
644 | ||
645 | UPDATE geoloc_countries | |
646 | SET nationalityFR = "Paraguayen" | |
647 | WHERE iso_3166_1_a2 = "PY"; | |
648 | ||
649 | UPDATE geoloc_countries | |
eb209054 | 650 | SET nationalityFR = "Porto-ricain", belongsTo = "US" |
644f8ee5 SJ |
651 | WHERE iso_3166_1_a2 = "PR"; |
652 | ||
653 | UPDATE geoloc_countries | |
654 | SET nationalityFR = "Congolais" | |
655 | WHERE iso_3166_1_a2 = "CD"; | |
656 | ||
657 | UPDATE geoloc_countries | |
658 | SET nationalityFR = "Rwandais" | |
659 | WHERE iso_3166_1_a2 = "RW"; | |
660 | ||
661 | UPDATE geoloc_countries | |
eb209054 | 662 | SET nationalityFR = "Saharien occidental", capital = "" |
644f8ee5 SJ |
663 | WHERE iso_3166_1_a2 = "EH"; |
664 | ||
665 | UPDATE geoloc_countries | |
666 | SET nationalityFR = "Vatican" | |
667 | WHERE iso_3166_1_a2 = "VA"; | |
668 | ||
669 | UPDATE geoloc_countries | |
670 | SET nationalityFR = "Kititien" | |
671 | WHERE iso_3166_1_a2 = "KN"; | |
672 | ||
673 | UPDATE geoloc_countries | |
674 | SET nationalityFR = "Saint-marinois" | |
675 | WHERE iso_3166_1_a2 = "SM"; | |
676 | ||
677 | UPDATE geoloc_countries | |
678 | SET nationalityFR = "Saint-Vincentais, Grenadin" | |
679 | WHERE iso_3166_1_a2 = "VC"; | |
680 | ||
681 | UPDATE geoloc_countries | |
682 | SET nationalityFR = NULL, belongsTo = "GB", capital = "Jamestown" | |
683 | WHERE iso_3166_1_a2 = "SH"; | |
684 | ||
685 | UPDATE geoloc_countries | |
686 | SET nationalityFR = "Saint-Lucien" | |
687 | WHERE iso_3166_1_a2 = "LC"; | |
688 | ||
689 | UPDATE geoloc_countries | |
690 | SET nationalityFR = "Salomonien" | |
691 | WHERE iso_3166_1_a2 = "SB"; | |
692 | ||
693 | UPDATE geoloc_countries | |
694 | SET nationalityFR = NULL, belongsTo = "US", capital = "Fagatogo" | |
695 | WHERE iso_3166_1_a2 = "AS"; | |
696 | ||
697 | UPDATE geoloc_countries | |
698 | SET nationalityFR = "Samoan" | |
699 | WHERE iso_3166_1_a2 = "WS"; | |
700 | ||
701 | UPDATE geoloc_countries | |
702 | SET nationalityFR = "Santoméen" | |
703 | WHERE iso_3166_1_a2 = "ST"; | |
704 | ||
705 | UPDATE geoloc_countries | |
706 | SET nationalityFR = "Seychellois" | |
707 | WHERE iso_3166_1_a2 = "SC"; | |
708 | ||
709 | UPDATE geoloc_countries | |
710 | SET nationalityFR = "Sierra-Léonais" | |
711 | WHERE iso_3166_1_a2 = "SL"; | |
712 | ||
713 | UPDATE geoloc_countries | |
714 | SET capital = "Singapour" | |
715 | WHERE iso_3166_1_a2 = "SG"; | |
716 | ||
717 | UPDATE geoloc_countries | |
718 | SET nationalityFR = "Slovaques" | |
719 | WHERE iso_3166_1_a2 = "SK"; | |
720 | ||
721 | UPDATE geoloc_countries | |
722 | SET nationalityFR = "Somalien" | |
723 | WHERE iso_3166_1_a2 = "SO"; | |
724 | ||
725 | UPDATE geoloc_countries | |
726 | SET nationalityFR = "Soudanais" | |
727 | WHERE iso_3166_1_a2 = "SD"; | |
728 | ||
729 | UPDATE geoloc_countries | |
730 | SET nationalityFR = "Sri Lankais", capital = "Sri Jayawardenapura" | |
731 | WHERE iso_3166_1_a2 = "LK"; | |
732 | ||
733 | UPDATE geoloc_countries | |
734 | SET nationalityFR = "Surinamien" | |
735 | WHERE iso_3166_1_a2 = "SR"; | |
736 | ||
737 | UPDATE geoloc_countries | |
738 | SET nationalityFR = NULL, belongsTo = "NO" | |
739 | WHERE iso_3166_1_a2 = "SJ"; | |
740 | ||
741 | UPDATE geoloc_countries | |
742 | SET nationalityFR = "Swazi", capital = "Mbabane" | |
743 | WHERE iso_3166_1_a2 = "SZ"; | |
744 | ||
745 | UPDATE geoloc_countries | |
746 | SET nationalityFR = "Syrien", capital = "Damas" | |
747 | WHERE iso_3166_1_a2 = "SY"; | |
748 | ||
749 | UPDATE geoloc_countries | |
750 | SET capital = "Douchanbé" | |
751 | WHERE iso_3166_1_a2 = "TJ"; | |
752 | ||
753 | UPDATE geoloc_countries | |
754 | SET capital = "Taipei" | |
755 | WHERE iso_3166_1_a2 = "TW"; | |
756 | ||
757 | UPDATE geoloc_countries | |
758 | SET capital = "Saint-Pierre", nationalityFR = NULL, belongsTo = "FR" | |
759 | WHERE iso_3166_1_a2 = "TF"; | |
760 | ||
761 | UPDATE geoloc_countries | |
762 | SET nationalityFR = "Thaïlandais", capital = "Bangkok" | |
763 | WHERE iso_3166_1_a2 = "TH"; | |
764 | ||
765 | UPDATE geoloc_countries | |
766 | SET nationalityFR = NULL, belongsTo = "NZ" | |
767 | WHERE iso_3166_1_a2 = "TK"; | |
768 | ||
769 | UPDATE geoloc_countries | |
770 | SET nationalityFR = "Turkmène", capital = "Achgabat" | |
771 | WHERE iso_3166_1_a2 = "TM"; | |
772 | ||
773 | UPDATE geoloc_countries | |
774 | SET nationalityFR = NULL, belongsTo = "GB", capital = "Cockburn Town" | |
775 | WHERE iso_3166_1_a2 = "TC"; | |
776 | ||
777 | UPDATE geoloc_countries | |
778 | SET capital = "Ankara" | |
779 | WHERE iso_3166_1_a2 = "TR"; | |
780 | ||
781 | UPDATE geoloc_countries | |
782 | SET nationalityFR = "Tanzanien" | |
783 | WHERE iso_3166_1_a2 = "TZ"; | |
784 | ||
785 | UPDATE geoloc_countries | |
786 | SET nationalityFR = "Tchadien" | |
787 | WHERE iso_3166_1_a2 = "TD"; | |
788 | ||
789 | UPDATE geoloc_countries | |
790 | SET nationalityFR = "Togolais" | |
791 | WHERE iso_3166_1_a2 = "TG"; | |
792 | ||
793 | UPDATE geoloc_countries | |
794 | SET nationalityFR = "Tongien" | |
795 | WHERE iso_3166_1_a2 = "TO"; | |
796 | ||
797 | UPDATE geoloc_countries | |
798 | SET nationalityFR = "Trinidadien" | |
799 | WHERE iso_3166_1_a2 = "TT"; | |
800 | ||
801 | UPDATE geoloc_countries | |
802 | SET nationalityFR = "Tuvaluan" | |
803 | WHERE iso_3166_1_a2 = "TV"; | |
804 | ||
805 | UPDATE geoloc_countries | |
806 | SET capital = "Hanoi" | |
807 | WHERE iso_3166_1_a2 = "VN"; | |
808 | ||
809 | UPDATE geoloc_countries | |
810 | SET nationalityFR = "Vanuatais" | |
811 | WHERE iso_3166_1_a2 = "VU"; | |
812 | ||
813 | UPDATE geoloc_countries | |
814 | SET nationalityFR = NULL, belongsTo = "FR", capital = "Mata-Utu" | |
815 | WHERE iso_3166_1_a2 = "WF"; | |
816 | ||
817 | UPDATE geoloc_countries | |
818 | SET nationalityFR = "Yéménite", capital = "Sanaa" | |
819 | WHERE iso_3166_1_a2 = "YE"; | |
820 | ||
821 | UPDATE geoloc_countries | |
822 | SET nationalityFR = "Zambien" | |
823 | WHERE iso_3166_1_a2 = "ZM"; | |
824 | ||
825 | UPDATE geoloc_countries | |
826 | SET nationalityFR = "Zimbabwéen" | |
827 | WHERE iso_3166_1_a2 = "ZW"; | |
828 | ||
829 | -- vim:set syntax=mysql: |