| 1 | ALTER TABLE geoloc_countries MODIFY COLUMN phoneFormat VARCHAR(255) NOT NULL DEFAULT ""; |
| 2 | |
| 3 | DELETE FROM geoloc_countries |
| 4 | WHERE iso_3166_1_a2 = "TP" OR iso_3166_1_a2 = "YU" OR iso_3166_1_a2 = "00"; |
| 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 |
| 650 | SET nationalityFR = "Porto-ricain", belongsTo = "US" |
| 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 |
| 662 | SET nationalityFR = "Saharien occidental", capital = "" |
| 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: |