geonames_postcodes_structure.sql

CREATE TABLE postcodes (
    country_code CHAR(2),
    postal_code VARCHAR(20),
    place_name VARCHAR(180),
    admin_name1 VARCHAR(100),
    admin_code1 VARCHAR(20),
    admin_name2 VARCHAR(100),
    admin_code2 VARCHAR(20),
    admin_name3 VARCHAR(100),
    admin_code3 VARCHAR(20),
    latitude DECIMAL(6,4),
    longitude DECIMAL(7,4),
    accuracy CHAR(1)
);