Where I can update the country list?

Hi,
where I can update the country list (with code)?


I want to change the first countries in the list. By the way on the ISO site (http://www.iso.org/iso/home/standards/country_codes/country_names_and_code_elements_txt.htm) they are only 249 countries listed (aMember have 251).

Thanks!

They are listed in the database. Table 'am_country'

Thanks, but how can I now move United States to U and Canda to C.
I don't want to have United States and Canda in the first position of my list :|

The database table contains 8 columns, one of which is the tables ID one 'country_id' which I cannot envisage aMember (uses since any changes to the table during any update might cause problems) but even if it did your own copy of the table would contain them also, still linked to the correct country.

This would mean that there should be no problem creating your own version of this table, using a simple mySQL query to copy each row of the existing table to your own new one. Order the table by 'country'.

IMPORTANT bit would be to make sure each row is copied over complete with all the rows respective columns.

The original data for this table is contained in '-----\amember\setup\sql-country.sql but remember your modified table will be overwritten if this file is changed in any future upgrade.