baptx

geonames_postcodes_structure.sql

Oct 18th, 2017
113
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE postcodes (
  2.     country_code CHAR(2),
  3.     postal_code VARCHAR(20),
  4.     place_name VARCHAR(180),
  5.     admin_name1 VARCHAR(100),
  6.     admin_code1 VARCHAR(20),
  7.     admin_name2 VARCHAR(100),
  8.     admin_code2 VARCHAR(20),
  9.     admin_name3 VARCHAR(100),
  10.     admin_code3 VARCHAR(20),
  11.     latitude DECIMAL(6,4),
  12.     longitude DECIMAL(7,4),
  13.     accuracy CHAR(1)
  14. );
RAW Paste Data