baptx

geonames_alternate_names_structure.sql

Oct 18th, 2017
113
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE alternate_names (
  2.     alternateNameId INT,
  3.     geonameid INT,
  4.     isolanguage VARCHAR(7),
  5.     alternate_name VARCHAR(400),
  6.     isPreferredName CHAR(1),
  7.     isShortName CHAR(1),
  8.     isColloquial CHAR(1),
  9.     isHistoric CHAR(1)
  10. );
RAW Paste Data