For the next version of Amore, I’m trying to get away from my too-clever-to-be-its-own-good makeid function. For most of the tables there are other fields that I can use as a primary key, but the locations table really needs some sort of identifier for each record. After looking around, it seems there is no standardized codes for locations. The closest is ISO 3166-2 which goes down to the state/province level, while I’m looking for something that goes down to the city or neighborhood level. In the end, I opted to use an auto-incrementing numeric primary key.
Since deciding that, it’s been a matter of re-entering all the continents and countries into the table. I may add states and provinces later, but this is good enough for the time being.
For future reference, here are the lists of countries by continent/region:
- List of sovereign states and dependent territories in Africa
- List of sovereign states and dependent territories in Asia
- List of sovereign states and dependent territories in Europe
- List of sovereign states and dependent territories in North America
- List of sovereign states and dependent territories in Oceania
- List of sovereign states and dependent territories in South America
Be First to Comment