countries.sql

[michael_s]

sqldump for table countries, modified according to
Official country names used by the ISO 3166/MA
http://www.iso.org/iso/country_codes/

PLEASE BACKUP YOUR TABLE COUNTRIES BEFORE!

officially added countries:

Åland Islands AX ALA
Congo, Democratic Republic of the CD COD
Guernsey GG GGY
Isle of Man IM IMN
Jersey JE JEY
Montenegro ME MNE
Palestinian Territory, Occupied PS PSE
Serbia RS SRB
Saint Barthélemy BL BLM
Saint Martin (French part) MF MAF

inofficially added countries:
Canary Islands IC CNR

removed countries:
Yugoslavia YU YUG
Zaire ZR ZAR

modified:
East Timor TP TMP
to
Timor-Leste TL TLS

renamed:
Cote d'Ivoire CI CIV
to
Côte d'Ivoire CI CIV

Reunion RE REU
to
Réunion RE REU

St. Helena SH SHN
to
Saint Helena SH SHN

St. Pierre and Miquelon PM SPM
to
Saint Pierre and Miquelon PM SPM

More...