1 ALTER TABLE geoloc_countries
MODIFY COLUMN phoneFormat
VARCHAR(255) NOT NULL DEFAULT "";
3 DELETE FROM geoloc_countries
4 WHERE iso_3166_1_a2
= "TP" OR iso_3166_1_a2
= "YU";
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",
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",
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);
27 UPDATE geoloc_countries
28 SET country
= "Croatia"
29 WHERE iso_3166_1_a2
= "HR";
31 UPDATE geoloc_countries
32 SET country
= "Slovakia"
33 WHERE iso_3166_1_a2
= "SK";
35 UPDATE geoloc_countries
36 SET country
= "Saint Helena"
37 WHERE iso_3166_1_a2
= "SH";
39 UPDATE geoloc_countries
40 SET countryFR
= "Antigua-et-Barbuda"
41 WHERE iso_3166_1_a2
= "AG";
43 UPDATE geoloc_countries
44 SET countryFR
= "Cameroun"
45 WHERE iso_3166_1_a2
= "CM";
47 UPDATE geoloc_countries
48 SET countryFR
= "Centrafricaine, République"
49 WHERE iso_3166_1_a2
= "CF";
51 UPDATE geoloc_countries
52 SET countryFR
= "Cocos (Keeling), Îles"
53 WHERE iso_3166_1_a2
= "CC";
55 UPDATE geoloc_countries
56 SET countryFR
= "Égypte"
57 WHERE iso_3166_1_a2
= "EG";
59 UPDATE geoloc_countries
60 SET countryFR
= "Émirats arabes unis"
61 WHERE iso_3166_1_a2
= "AE";
63 UPDATE geoloc_countries
64 SET countryFR
= "Équateur"
65 WHERE iso_3166_1_a2
= "EC";
67 UPDATE geoloc_countries
68 SET countryFR
= "Érythrée"
69 WHERE iso_3166_1_a2
= "ER";
71 UPDATE geoloc_countries
72 SET countryFR
= "Èthiopie"
73 WHERE iso_3166_1_a2
= "ET";
75 UPDATE geoloc_countries
76 SET countryFR
= "États-Unis"
77 WHERE iso_3166_1_a2
= "US";
79 UPDATE geoloc_countries
80 SET countryFR
= "Géorgie du Sud et les Îles Sandwich du Sud"
81 WHERE iso_3166_1_a2
= "GS";
83 UPDATE geoloc_countries
84 SET countryFR
= "Guinée-Bissau"
85 WHERE iso_3166_1_a2
= "GW";
87 UPDATE geoloc_countries
88 SET countryFR
= "Heard, Île et MacDonald"
89 WHERE iso_3166_1_a2
= "HM";
91 UPDATE geoloc_countries
92 SET countryFR
= "Îles mineures éloignées des États-Unis"
93 WHERE iso_3166_1_a2
= "UM";
95 UPDATE geoloc_countries
96 SET countryFR
= "Îles vierges britanniques", country
= "Virgin Islands, British"
97 WHERE iso_3166_1_a2
= "VG";
99 UPDATE geoloc_countries
100 SET countryFR
= "Îles vierges des États-Unis", country
= "Virgin Islands, US"
101 WHERE iso_3166_1_a2
= "VI";
103 UPDATE geoloc_countries
104 SET countryFR
= "Iran, République islamique d'"
105 WHERE iso_3166_1_a2
= "IR";
107 UPDATE geoloc_countries
108 SET countryFR
= "Lao, République démocratique populaire"
109 WHERE iso_3166_1_a2
= "LA";
111 UPDATE geoloc_countries
112 SET countryFR
= "Macédoine, L'Ex-République Yougoslave"
113 WHERE iso_3166_1_a2
= "MK";
115 UPDATE geoloc_countries
116 SET countryFR
= "Micronésie, États fédérés de"
117 WHERE iso_3166_1_a2
= "FM";
119 UPDATE geoloc_countries
120 SET countryFR
= "Océan Indien, Territoire britannique de l'"
121 WHERE iso_3166_1_a2
= "IO";
123 UPDATE geoloc_countries
124 SET countryFR
= "Russie, Fédération de"
125 WHERE iso_3166_1_a2
= "RU";
127 UPDATE geoloc_countries
128 SET countryFR
= "Saint-Siège (État de la Cité du Vatican)"
129 WHERE iso_3166_1_a2
= "VA";
131 UPDATE geoloc_countries
132 SET countryFR
= "Saint-Kitts-et-Nevis"
133 WHERE iso_3166_1_a2
= "KN";
135 UPDATE geoloc_countries
136 SET countryFR
= "Congo, La République démocratique du"
137 WHERE iso_3166_1_a2
= "CD";
139 UPDATE geoloc_countries
140 SET countryFR
= "Saint-Vincent-et-les-Grenadines"
141 WHERE iso_3166_1_a2
= "VC";
143 UPDATE geoloc_countries
144 SET countryFR
= "Samoa"
145 WHERE iso_3166_1_a2
= "WS";
147 UPDATE geoloc_countries
148 SET countryFR
= "Sao Tomé-et-Principe"
149 WHERE iso_3166_1_a2
= "ST";
151 UPDATE geoloc_countries
152 SET countryFR
= "Svalbard et Île Jan Mayen"
153 WHERE iso_3166_1_a2
= "SJ";
155 UPDATE geoloc_countries
156 SET countryFR
= "Trinité-et-Tobago"
157 WHERE iso_3166_1_a2
= "TT";
159 UPDATE geoloc_countries
160 SET countryFR
= "Venezuela"
161 WHERE iso_3166_1_a2
= "VE";
163 UPDATE geoloc_countries
164 SET countryFR
= "Viet Nam"
165 WHERE iso_3166_1_a2
= "VN";
167 UPDATE geoloc_countries
168 SET countryFR
= "Wallis et Futuna", country
= "Wallis and Futuna"
169 WHERE iso_3166_1_a2
= "WF";
171 UPDATE geoloc_countries
172 SET countryFR
= "Yémen"
173 WHERE iso_3166_1_a2
= "YE";
175 UPDATE geoloc_countries
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";
181 UPDATE geoloc_countries
182 SET belongsTo
= "US", nationalityFR
= NULL
183 WHERE iso_3166_1_a2
= "UM";
185 UPDATE geoloc_countries
186 SET nationalityFR
= "Afghan"
187 WHERE iso_3166_1_a2
= "AF";
189 UPDATE geoloc_countries
190 SET nationalityFR
= "Andorran"
191 WHERE iso_3166_1_a2
= "AD";
193 UPDATE geoloc_countries
194 SET nationalityFR
= NULL, belongsTo
= "GB", capital
= "The Valley"
195 WHERE iso_3166_1_a2
= "AI";
197 UPDATE geoloc_countries
198 SET nationalityFR
= "Angolais"
199 WHERE iso_3166_1_a2
= "AO";
201 UPDATE geoloc_countries
202 SET nationalityFR
= NULL
203 WHERE iso_3166_1_a2
= "AQ";
205 UPDATE geoloc_countries
206 SET nationalityFR
= "Antiguais"
207 WHERE iso_3166_1_a2
= "AG";
209 UPDATE geoloc_countries
210 SET nationalityFR
= NULL, belongsTo
= "NL", capital
= "Willemstad"
211 WHERE iso_3166_1_a2
= "AN";
213 UPDATE geoloc_countries
214 SET nationalityFR
= "Saoudien", capital
= "Riyad"
215 WHERE iso_3166_1_a2
= "SA";
217 UPDATE geoloc_countries
218 SET nationalityFR
= "Arménien"
219 WHERE iso_3166_1_a2
= "AM";
221 UPDATE geoloc_countries
222 SET nationalityFR
= "Arubais", capital
= "Oranjestad"
223 WHERE iso_3166_1_a2
= "AW";
225 UPDATE geoloc_countries
226 SET nationalityFR
= "Azerbaïdjanais"
227 WHERE iso_3166_1_a2
= "AZ";
229 UPDATE geoloc_countries
230 SET nationalityFR
= "Bahaméen"
231 WHERE iso_3166_1_a2
= "BS";
233 UPDATE geoloc_countries
234 SET nationalityFR
= "Bahreïnien"
235 WHERE iso_3166_1_a2
= "BH";
237 UPDATE geoloc_countries
238 SET nationalityFR
= "Bangladais"
239 WHERE iso_3166_1_a2
= "BD";
241 UPDATE geoloc_countries
242 SET nationalityFR
= "Barbadien"
243 WHERE iso_3166_1_a2
= "BB";
245 UPDATE geoloc_countries
246 SET nationalityFR
= "Biélorusse", capital
= "Minsk"
247 WHERE iso_3166_1_a2
= "BY";
249 UPDATE geoloc_countries
250 SET nationalityFR
= "Béliziens"
251 WHERE iso_3166_1_a2
= "BZ";
253 UPDATE geoloc_countries
254 SET nationalityFR
= NULL, belongsTo
= "GB"
255 WHERE iso_3166_1_a2
= "BM";
257 UPDATE geoloc_countries
258 SET nationalityFR
= "Bolivien"
259 WHERE iso_3166_1_a2
= "BO";
261 UPDATE geoloc_countries
262 SET nationalityFR
= "Bosnien"
263 WHERE iso_3166_1_a2
= "BA";
265 UPDATE geoloc_countries
266 SET nationalityFR
= NULL, belongsTo
= "NO"
267 WHERE iso_3166_1_a2
= "BV";
269 UPDATE geoloc_countries
270 SET nationalityFR
= "Brunéiens"
271 WHERE iso_3166_1_a2
= "BN";
273 UPDATE geoloc_countries
274 SET nationalityFR
= "Burundais"
275 WHERE iso_3166_1_a2
= "BI";
277 UPDATE geoloc_countries
278 SET nationalityFR
= NULL, belongsTo
= "GB", capital
= "George Town"
279 WHERE iso_3166_1_a2
= "KY";
281 UPDATE geoloc_countries
282 SET nationalityFR
= "Cap-verdiens"
283 WHERE iso_3166_1_a2
= "CV";
285 UPDATE geoloc_countries
286 SET nationalityFR
= "Centrafricain"
287 WHERE iso_3166_1_a2
= "CF";
289 UPDATE geoloc_countries
290 SET nationalityFR
= NULL, belongsTo
= "AU", capital
= "Flying Fish Cove"
291 WHERE iso_3166_1_a2
= "CX";
293 UPDATE geoloc_countries
294 SET nationalityFR
= "Chypriotes"
295 WHERE iso_3166_1_a2
= "CY";
297 UPDATE geoloc_countries
298 SET nationalityFR
= NULL, belongsTo
= "AU", capital
= "West Island"
299 WHERE iso_3166_1_a2
= "CC";
301 UPDATE geoloc_countries
302 SET nationalityFR
= "Comorien"
303 WHERE iso_3166_1_a2
= "KM";
305 UPDATE geoloc_countries
306 SET nationalityFR
= "Congolais"
307 WHERE iso_3166_1_a2
= "CG";
309 UPDATE geoloc_countries
310 SET nationalityFR
= "Nord-Coréens"
311 WHERE iso_3166_1_a2
= "CK";
313 UPDATE geoloc_countries
314 SET nationalityFR
= "Maori des îles Cook"
315 WHERE iso_3166_1_a2
= "KP";
317 UPDATE geoloc_countries
318 SET nationalityFR
= "Djibouti"
319 WHERE iso_3166_1_a2
= "DJ";
321 UPDATE geoloc_countries
322 SET nationalityFR
= "Dominicain"
323 WHERE iso_3166_1_a2
= "DO";
325 UPDATE geoloc_countries
326 SET nationalityFR
= "Dominiquais"
327 WHERE iso_3166_1_a2
= "DM";
329 UPDATE geoloc_countries
330 SET nationalityFR
= "Salvadorien"
331 WHERE iso_3166_1_a2
= "SV";
333 UPDATE geoloc_countries
334 SET nationalityFR
= "Émirien"
335 WHERE iso_3166_1_a2
= "AE";
337 UPDATE geoloc_countries
338 SET nationalityFR
= "Érythréen"
339 WHERE iso_3166_1_a2
= "ER";
341 UPDATE geoloc_countries
342 SET nationalityFR
= "Éthiopiens"
343 WHERE iso_3166_1_a2
= "ET";
345 UPDATE geoloc_countries
346 SET nationalityFR
= NULL, belongsTo
= "GB", capital
= "Port Stanley"
347 WHERE iso_3166_1_a2
= "FK";
349 UPDATE geoloc_countries
350 SET nationalityFR
= NULL, belongsTo
= "DK"
351 WHERE iso_3166_1_a2
= "FO";
353 UPDATE geoloc_countries
354 SET nationalityFR
= "Fidjiens"
355 WHERE iso_3166_1_a2
= "FJ";
357 UPDATE geoloc_countries
358 SET nationalityFR
= "Gambiens"
359 WHERE iso_3166_1_a2
= "GM";
361 UPDATE geoloc_countries
362 SET nationalityFR
= NULL, belongsTo
= "GB", capital
= "Grytviken"
363 WHERE iso_3166_1_a2
= "GS";
365 UPDATE geoloc_countries
366 SET nationalityFR
= "Géorgien", capital
= "Tbilissi"
367 WHERE iso_3166_1_a2
= "GE";
369 UPDATE geoloc_countries
370 SET nationalityFR
= "Ghanéen"
371 WHERE iso_3166_1_a2
= "GH";
373 UPDATE geoloc_countries
374 SET nationalityFR
= NULL, belongsTo
= "GB"
375 WHERE iso_3166_1_a2
= "GI";
377 UPDATE geoloc_countries
378 SET nationalityFR
= "Grenadien"
379 WHERE iso_3166_1_a2
= "GD";
381 UPDATE geoloc_countries
382 SET nationalityFR
= NULL, belongsTo
= "DK", capital
= "Nuuk"
383 WHERE iso_3166_1_a2
= "GL";
385 UPDATE geoloc_countries
386 SET nationalityFR
= NULL, belongsTo
= "US"
387 WHERE iso_3166_1_a2
= "GU";
389 UPDATE geoloc_countries
390 SET nationalityFR
= "Guatémaltèque"
391 WHERE iso_3166_1_a2
= "GT";
393 UPDATE geoloc_countries
394 SET nationalityFR
= "Guinéens"
395 WHERE iso_3166_1_a2
= "GN";
397 UPDATE geoloc_countries
398 SET nationalityFR
= "Bissau-Guinéens"
399 WHERE iso_3166_1_a2
= "GW";
401 UPDATE geoloc_countries
402 SET nationalityFR
= "Équato-Guinéens"
403 WHERE iso_3166_1_a2
= "GQ";
405 UPDATE geoloc_countries
406 SET nationalityFR
= NULL, belongsTo
= "FR", capital
= "Cayenne"
407 WHERE iso_3166_1_a2
= "GF";
409 UPDATE geoloc_countries
410 SET nationalityFR
= NULL, belongsTo
= "AU"
411 WHERE iso_3166_1_a2
= "HM";
413 UPDATE geoloc_countries
414 SET nationalityFR
= "Hondurien"
415 WHERE iso_3166_1_a2
= "HN";
417 UPDATE geoloc_countries
418 SET nationalityFR
= NULL, belongsTo
= "GB", capital
= "Road Town"
419 WHERE iso_3166_1_a2
= "VG";
421 UPDATE geoloc_countries
422 SET nationalityFR
= NULL, belongsTo
= "US", capital
= "Charlotte Amalie"
423 WHERE iso_3166_1_a2
= "VI";
425 UPDATE geoloc_countries
426 SET nationalityFR
= "Indonésien", capital
= "Jakarta"
427 WHERE iso_3166_1_a2
= "ID";
429 UPDATE geoloc_countries
430 SET nationalityFR
= "Irakien", capital
= "Bagdad"
431 WHERE iso_3166_1_a2
= "IQ";
433 UPDATE geoloc_countries
434 SET nationalityFR
= "Jordanien", capital
= "Amman"
435 WHERE iso_3166_1_a2
= "JO";
437 UPDATE geoloc_countries
438 SET capital
= "New Delhi"
439 WHERE iso_3166_1_a2
= "IN";
441 UPDATE geoloc_countries
442 SET capital
= "Téhéran"
443 WHERE iso_3166_1_a2
= "IR";
445 UPDATE geoloc_countries
446 SET capital
= "Jérusalem"
447 WHERE iso_3166_1_a2
= "IL";
449 UPDATE geoloc_countries
450 SET capital
= "Tōkyō"
451 WHERE iso_3166_1_a2
= "JP";
453 UPDATE geoloc_countries
454 SET capital
= "Astana"
455 WHERE iso_3166_1_a2
= "KZ";
457 UPDATE geoloc_countries
458 SET nationalityFR
= "Kirghiz", capital
= "Bichkek"
459 WHERE iso_3166_1_a2
= "KG";
461 UPDATE geoloc_countries
462 SET nationalityFR
= "Koweïtien", capital
= "Koweït"
463 WHERE iso_3166_1_a2
= "KW";
465 UPDATE geoloc_countries
466 SET nationalityFR
= "Kényan"
467 WHERE iso_3166_1_a2
= "KE";
469 UPDATE geoloc_countries
470 SET nationalityFR
= "Gilbertins"
471 WHERE iso_3166_1_a2
= "KI";
473 UPDATE geoloc_countries
474 SET nationalityFR
= "Laotien", capital
= "Vientiane"
475 WHERE iso_3166_1_a2
= "LA";
477 UPDATE geoloc_countries
478 SET nationalityFR
= "Lesothans"
479 WHERE iso_3166_1_a2
= "LS";
481 UPDATE geoloc_countries
482 SET nationalityFR
= "Libérien"
483 WHERE iso_3166_1_a2
= "LR";
485 UPDATE geoloc_countries
486 SET nationalityFR
= "Libyen"
487 WHERE iso_3166_1_a2
= "LY";
489 UPDATE geoloc_countries
490 SET nationalityFR
= "Liechtensteinois"
491 WHERE iso_3166_1_a2
= "LI";
493 UPDATE geoloc_countries
494 SET capital
= "Beyrouth"
495 WHERE iso_3166_1_a2
= "LB";
497 UPDATE geoloc_countries
498 SET nationalityFR
= "Malaisien", capital
= "Putrajaya"
499 WHERE iso_3166_1_a2
= "MY";
501 UPDATE geoloc_countries
502 SET nationalityFR
= "Malawites"
503 WHERE iso_3166_1_a2
= "MW";
505 UPDATE geoloc_countries
506 SET nationalityFR
= "Maldivien", capital
= "Malé"
507 WHERE iso_3166_1_a2
= "MV";
509 UPDATE geoloc_countries
510 SET nationalityFR
= "Maltais"
511 WHERE iso_3166_1_a2
= "MT";
513 UPDATE geoloc_countries
514 SET nationalityFR
= NULL, belongsTo
= "US", capital
= "Saipan"
515 WHERE iso_3166_1_a2
= "MP";
517 UPDATE geoloc_countries
518 SET nationalityFR
= "Marshallais"
519 WHERE iso_3166_1_a2
= "MH";
521 UPDATE geoloc_countries
522 SET nationalityFR
= "Mauricien"
523 WHERE iso_3166_1_a2
= "MU";
525 UPDATE geoloc_countries
526 SET nationalityFR
= "Mauritanien"
527 WHERE iso_3166_1_a2
= "MR";
529 UPDATE geoloc_countries
530 SET nationalityFR
= "Micronésien"
531 WHERE iso_3166_1_a2
= "FM";
533 UPDATE geoloc_countries
534 SET nationalityFR
= "Moldave"
535 WHERE iso_3166_1_a2
= "MD";
537 UPDATE geoloc_countries
538 SET nationalityFR
= "Monégasque"
539 WHERE iso_3166_1_a2
= "MC";
541 UPDATE geoloc_countries
542 SET nationalityFR
= "Mongol", capital
= "Oulan-Bator"
543 WHERE iso_3166_1_a2
= "MN";
545 UPDATE geoloc_countries
546 SET nationalityFR
= NULL, belongsTo
= "GB", capital
= "Plymouth["
547 WHERE iso_3166_1_a2
= "MS";
549 UPDATE geoloc_countries
550 SET nationalityFR
= "Mozambicain"
551 WHERE iso_3166_1_a2
= "MZ";
553 UPDATE geoloc_countries
554 SET nationalityFR
= "Birman", capital
= "Naypyidaw"
555 WHERE iso_3166_1_a2
= "MM";
557 UPDATE geoloc_countries
558 SET capital
= "Mamoudzou"
559 WHERE iso_3166_1_a2
= "YT";
561 UPDATE geoloc_countries
562 SET nationalityFR
= "Namibien"
563 WHERE iso_3166_1_a2
= "NA";
565 UPDATE geoloc_countries
566 SET nationalityFR
= "Nauruan"
567 WHERE iso_3166_1_a2
= "NR";
569 UPDATE geoloc_countries
570 SET nationalityFR
= "Népalais", capital
= "Katmandou"
571 WHERE iso_3166_1_a2
= "NP";
573 UPDATE geoloc_countries
574 SET nationalityFR
= "Nicaraguayen"
575 WHERE iso_3166_1_a2
= "NI";
577 UPDATE geoloc_countries
578 SET nationalityFR
= "Nigérien"
579 WHERE iso_3166_1_a2
= "NE";
581 UPDATE geoloc_countries
582 SET nationalityFR
= "Nigérian"
583 WHERE iso_3166_1_a2
= "NG";
585 UPDATE geoloc_countries
586 SET nationalityFR
= "Niuéen"
587 WHERE iso_3166_1_a2
= "NU";
589 UPDATE geoloc_countries
590 SET nationalityFR
= NULL, belongsTo
= "AU", capital
= "Kingston"
591 WHERE iso_3166_1_a2
= "NF";
593 UPDATE geoloc_countries
594 SET capital
= "Nouméa"
595 WHERE iso_3166_1_a2
= "NC";
597 UPDATE geoloc_countries
598 SET nationalityFR
= NULL, belongsTo
= "GB", capital
= "Diego Garcia"
599 WHERE iso_3166_1_a2
= "IO";
601 UPDATE geoloc_countries
602 SET nationalityFR
= "Omani", capital
= "Mascate"
603 WHERE iso_3166_1_a2
= "OM";
605 UPDATE geoloc_countries
606 SET nationalityFR
= "Ougandais"
607 WHERE iso_3166_1_a2
= "UG";
609 UPDATE geoloc_countries
610 SET nationalityFR
= "Ouzbek", capital
= "Tachkent"
611 WHERE iso_3166_1_a2
= "UZ";
613 UPDATE geoloc_countries
614 SET nationalityFR
= "Qatari", capital
= "Doha"
615 WHERE iso_3166_1_a2
= "QA";
617 UPDATE geoloc_countries
618 SET nationalityFR
= "Pakistanais", capital
= "Islamabad"
619 WHERE iso_3166_1_a2
= "PK";
621 UPDATE geoloc_countries
622 SET nationalityFR
= "Philippins", capital
= "Manille"
623 WHERE iso_3166_1_a2
= "PH";
625 UPDATE geoloc_countries
626 SET nationalityFR
= NULL, belongsTo
= "GB", capital
= "Adamstown"
627 WHERE iso_3166_1_a2
= "PN";
629 UPDATE geoloc_countries
630 SET capital
= "Papeete"
631 WHERE iso_3166_1_a2
= "PF";
633 UPDATE geoloc_countries
634 SET nationalityFR
= "Palaien"
635 WHERE iso_3166_1_a2
= "PW";
637 UPDATE geoloc_countries
638 SET nationalityFR
= "Panaméen"
639 WHERE iso_3166_1_a2
= "PA";
641 UPDATE geoloc_countries
642 SET nationalityFR
= "Papouasien"
643 WHERE iso_3166_1_a2
= "PG";
645 UPDATE geoloc_countries
646 SET nationalityFR
= "Paraguayen"
647 WHERE iso_3166_1_a2
= "PY";
649 UPDATE geoloc_countries
650 SET nationalityFR
= NULL, belongsTo
= "US"
651 WHERE iso_3166_1_a2
= "PR";
653 UPDATE geoloc_countries
654 SET nationalityFR
= "Congolais"
655 WHERE iso_3166_1_a2
= "CD";
657 UPDATE geoloc_countries
658 SET nationalityFR
= "Rwandais"
659 WHERE iso_3166_1_a2
= "RW";
661 UPDATE geoloc_countries
662 SET nationalityFR
= NULL, capital
= ""
663 WHERE iso_3166_1_a2
= "EH";
665 UPDATE geoloc_countries
666 SET nationalityFR
= "Vatican"
667 WHERE iso_3166_1_a2
= "VA";
669 UPDATE geoloc_countries
670 SET nationalityFR
= "Kititien"
671 WHERE iso_3166_1_a2
= "KN";
673 UPDATE geoloc_countries
674 SET nationalityFR
= "Saint-marinois"
675 WHERE iso_3166_1_a2
= "SM";
677 UPDATE geoloc_countries
678 SET nationalityFR
= "Saint-Vincentais, Grenadin"
679 WHERE iso_3166_1_a2
= "VC";
681 UPDATE geoloc_countries
682 SET nationalityFR
= NULL, belongsTo
= "GB", capital
= "Jamestown"
683 WHERE iso_3166_1_a2
= "SH";
685 UPDATE geoloc_countries
686 SET nationalityFR
= "Saint-Lucien"
687 WHERE iso_3166_1_a2
= "LC";
689 UPDATE geoloc_countries
690 SET nationalityFR
= "Salomonien"
691 WHERE iso_3166_1_a2
= "SB";
693 UPDATE geoloc_countries
694 SET nationalityFR
= NULL, belongsTo
= "US", capital
= "Fagatogo"
695 WHERE iso_3166_1_a2
= "AS";
697 UPDATE geoloc_countries
698 SET nationalityFR
= "Samoan"
699 WHERE iso_3166_1_a2
= "WS";
701 UPDATE geoloc_countries
702 SET nationalityFR
= "Santoméen"
703 WHERE iso_3166_1_a2
= "ST";
705 UPDATE geoloc_countries
706 SET nationalityFR
= "Seychellois"
707 WHERE iso_3166_1_a2
= "SC";
709 UPDATE geoloc_countries
710 SET nationalityFR
= "Sierra-Léonais"
711 WHERE iso_3166_1_a2
= "SL";
713 UPDATE geoloc_countries
714 SET capital
= "Singapour"
715 WHERE iso_3166_1_a2
= "SG";
717 UPDATE geoloc_countries
718 SET nationalityFR
= "Slovaques"
719 WHERE iso_3166_1_a2
= "SK";
721 UPDATE geoloc_countries
722 SET nationalityFR
= "Somalien"
723 WHERE iso_3166_1_a2
= "SO";
725 UPDATE geoloc_countries
726 SET nationalityFR
= "Soudanais"
727 WHERE iso_3166_1_a2
= "SD";
729 UPDATE geoloc_countries
730 SET nationalityFR
= "Sri Lankais", capital
= "Sri Jayawardenapura"
731 WHERE iso_3166_1_a2
= "LK";
733 UPDATE geoloc_countries
734 SET nationalityFR
= "Surinamien"
735 WHERE iso_3166_1_a2
= "SR";
737 UPDATE geoloc_countries
738 SET nationalityFR
= NULL, belongsTo
= "NO"
739 WHERE iso_3166_1_a2
= "SJ";
741 UPDATE geoloc_countries
742 SET nationalityFR
= "Swazi", capital
= "Mbabane"
743 WHERE iso_3166_1_a2
= "SZ";
745 UPDATE geoloc_countries
746 SET nationalityFR
= "Syrien", capital
= "Damas"
747 WHERE iso_3166_1_a2
= "SY";
749 UPDATE geoloc_countries
750 SET capital
= "Douchanbé"
751 WHERE iso_3166_1_a2
= "TJ";
753 UPDATE geoloc_countries
754 SET capital
= "Taipei"
755 WHERE iso_3166_1_a2
= "TW";
757 UPDATE geoloc_countries
758 SET capital
= "Saint-Pierre", nationalityFR
= NULL, belongsTo
= "FR"
759 WHERE iso_3166_1_a2
= "TF";
761 UPDATE geoloc_countries
762 SET nationalityFR
= "Thaïlandais", capital
= "Bangkok"
763 WHERE iso_3166_1_a2
= "TH";
765 UPDATE geoloc_countries
766 SET nationalityFR
= NULL, belongsTo
= "NZ"
767 WHERE iso_3166_1_a2
= "TK";
769 UPDATE geoloc_countries
770 SET nationalityFR
= "Turkmène", capital
= "Achgabat"
771 WHERE iso_3166_1_a2
= "TM";
773 UPDATE geoloc_countries
774 SET nationalityFR
= NULL, belongsTo
= "GB", capital
= "Cockburn Town"
775 WHERE iso_3166_1_a2
= "TC";
777 UPDATE geoloc_countries
778 SET capital
= "Ankara"
779 WHERE iso_3166_1_a2
= "TR";
781 UPDATE geoloc_countries
782 SET nationalityFR
= "Tanzanien"
783 WHERE iso_3166_1_a2
= "TZ";
785 UPDATE geoloc_countries
786 SET nationalityFR
= "Tchadien"
787 WHERE iso_3166_1_a2
= "TD";
789 UPDATE geoloc_countries
790 SET nationalityFR
= "Togolais"
791 WHERE iso_3166_1_a2
= "TG";
793 UPDATE geoloc_countries
794 SET nationalityFR
= "Tongien"
795 WHERE iso_3166_1_a2
= "TO";
797 UPDATE geoloc_countries
798 SET nationalityFR
= "Trinidadien"
799 WHERE iso_3166_1_a2
= "TT";
801 UPDATE geoloc_countries
802 SET nationalityFR
= "Tuvaluan"
803 WHERE iso_3166_1_a2
= "TV";
805 UPDATE geoloc_countries
806 SET capital
= "Hanoi"
807 WHERE iso_3166_1_a2
= "VN";
809 UPDATE geoloc_countries
810 SET nationalityFR
= "Vanuatais"
811 WHERE iso_3166_1_a2
= "VU";
813 UPDATE geoloc_countries
814 SET nationalityFR
= NULL, belongsTo
= "FR", capital
= "Mata-Utu"
815 WHERE iso_3166_1_a2
= "WF";
817 UPDATE geoloc_countries
818 SET nationalityFR
= "Yéménite", capital
= "Sanaa"
819 WHERE iso_3166_1_a2
= "YE";
821 UPDATE geoloc_countries
822 SET nationalityFR
= "Zambien"
823 WHERE iso_3166_1_a2
= "ZM";
825 UPDATE geoloc_countries
826 SET nationalityFR
= "Zimbabwéen"
827 WHERE iso_3166_1_a2
= "ZW";
829 -- vim:set syntax=mysql: