Although I'm personally not satisfied with the ISO 3166, here are the changes that will be needed:
NEW ENTRIES (nothing needed on members table)
AMERICAN SAMOA
ANTARCTICA
BOUVET ISLAND
COCOS (KEELING) ISLANDS
CONGO
COOK ISLANDS
FRENCH SOUTHERN TERRITORIES
GUAM
HEARD ISLAND AND MCDONALD ISLANDS
MARSHALL ISLANDS
MAYOTTE
MICRONESIA, FEDERATED STATES OF
NORFOLK ISLAND
NORTHERN MARIANA ISLANDS
PALAU
PALESTINIAN TERRITORY, OCCUPIED
PUERTO RICO
SVALBARD AND JAN MAYEN
TOKELAU
UNITED STATES MINOR OUTLYING ISLANDS
DELETIONS (info must be dleeted from members table, because no assumptions can be made)
Borneo (it is an island with multiple countries)
Fed Rep Yugoslavia (divided to multiple countries)
MERGER/UPDATE (info must be updated in the members table, "moving" people)
Azores => Portugal
Canary Islands => Spain
Saint Barthelemy => France
Saint Croix => VIRGIN ISLANDS, U.S.
RENAME/UPDATE (info must be updated in the members table, renaming people's countries)
British Indian Ocean Territories BRITISH INDIAN OCEAN TERRITORY
Brunei BRUNEI DARUSSALAM
Burkina Faso (Upper Volta) BURKINA FASO
Camaroon CAMEROON
Cape Vere Islands CAPE VERDE
Central African Rep CENTRAL AFRICAN REPUBLIC
Comoros Islands COMOROS
Congo, Democratic Republic of CONGO, THE DEMOCRATIC REPUBLIC OF THE
Eritria ERITREA
Falkland Islands FALKLAND ISLANDS (MALVINAS)
Fyro Macedonia MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF
Iran IRAN, ISLAMIC REPUBLIC OF
Ivory Coast COTE D'IVOIRE
Korea KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF
Republic of Korea KOREA, REPUBLIC OF
Laos LAO PEOPLE'S DEMOCRATIC REPUBLIC
Libya LIBYAN ARAB JAMAHIRIYA
Moldova MOLDOVA, REPUBLIC OF
Myanmar (Burma) MYANMAR
Naura NAURU
Pitcairn Island PITCAIRN
Reunion Island REUNION
Russia RUSSIAN FEDERATION
Saint Vincent and Grenadi SAINT VINCENT AND THE GRENADINES
Western Samoa SAMOA
Somalia Northern Region SOMALIA
Somalia Southern Region SOMALIA
South Sandwich Islands SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS
Syria SYRIAN ARAB REPUBLIC
Taiwan TAIWAN, PROVINCE OF CHINA
Tanzania TANZANIA, UNITED REPUBLIC OF
Turks and Caicos Islnd TURKS AND CAICOS ISLANDS
USA UNITED STATES
Vatican City HOLY SEE (VATICAN CITY STATE)
Vietnam VIET NAM
Virgin Islands (United Kingdom) VIRGIN ISLANDS, BRITISH
Wallis and Futuna Islands WALLIS AND FUTUNA
The ISO list is a bit problematic. Sometimes it takes a territory in the list (although it belongs to US for example), sometimes not. This can mean, who pays gets in the list...
Any ideas/objections/thoughts?
Topic Locked
Posted - 27 October 2002 : 11:57:45
Stop the WAR!
