Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE places (
- geonameid INT,
- name VARCHAR(200),
- asciiname VARCHAR(200),
- alternatenames VARCHAR(10000),
- latitude DECIMAL(7,5),
- longitude DECIMAL(8,5),
- feature_class CHAR(1),
- feature_code VARCHAR(10),
- country_code CHAR(2),
- cc2 CHAR(200),
- admin1_code VARCHAR(20),
- admin2_code VARCHAR(80),
- admin3_code VARCHAR(20),
- admin4_code VARCHAR(20),
- population BIGINT,
- elevation VARCHAR(10),
- dem INT,
- timezone VARCHAR(40),
- modification_date DATE
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement