geonames_alternate_names_structure.sql

CREATE TABLE alternate_names (
    alternateNameId INT,
    geonameid INT,
    isolanguage VARCHAR(7),
    alternate_name VARCHAR(400),
    isPreferredName CHAR(1),
    isShortName CHAR(1),
    isColloquial CHAR(1),
    isHistoric CHAR(1)
);