Community Add-Ons
| Maintainers: | texmaxx |
 Add file to this package |
|
countries.sql
for osCommerce Online Merchant v2.2
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
Download 
Report
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