Created
February 5, 2016 08:15
-
-
Save dotku/c733eb245cbd4efeaf5c to your computer and use it in GitHub Desktop.
GeoLite2 SQL Schema
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE GeoLite2 ( | |
geoname_id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY, | |
locale_code VARCHAR(10) NOT NULL, | |
continent_code VARCHAR(10) NOT NULL, | |
continent_name VARCHAR(10) NOT NULL, | |
country_iso_code VARCHAR(10) NOT NULL, | |
country_name VARCHAR(50) NOT NULL, | |
subdivision_1_iso_code VARCHAR(10), | |
subdivision_1_name VARCHAR(50), | |
subdivision_2_iso_code VARCHAR(10), | |
subdivision_2_name VARCHAR(50), | |
city_name VARCHAR(50), | |
metro_code INT(10), | |
time_zone VARCHAR(50) | |
) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment