Home
mcloide edited this page May 30, 2012
·
2 revisions
This is a small project where the GeoCityLite data from Maxmind, together with the Regions and Countries data, were structured to use a similar formatting as the standard used with CakePHP.
Tables:
- cities
- regions
- countries
It uses the part of the original structure from Maxmind so to bind a city to regions / countries you will need to Join region by region_id and countries by iso_code. Binding the regions to countries is also by iso code.