ISO3166 Data

Created by: Lester Caine, Last modification: 24 Sep 2013 (09:14 UTC)

ISO 3166 is the International Standard for country codes and codes for their subdivisions.

There is also a history of changes to these codes back to 2002, and prior to that although there will not be valid codes, the history of changes of affiliations will be an important element of the identification of what rules a particular location is associated with.

We have a database of ISO3166 codes and is currently documented in the bitweaver/commerce schema file and this is used as the initial base.

{code source=sql}
'com_countries' ( 
countries_id I4 PRIMARY AUTO, 
countries_name C(64), 
countries_iso_code_2 C(2), 
countries_iso_code_3 C(3), 
countries_iso_code_num I4, 
address_format_id I4 ) 

'com_zones' ( 
zone_id I4 PRIMARY AUTO, 
zone_country_id I4, 
zone_code C(32), 
zone_name C(64) )