-- This is Free Software under GNU Affero General Public License v >= 3.0
-- without warranty, see README.md and license for details.

-- SPDX-License-Identifier: AGPL-3.0-or-later
-- License-Filename: LICENSES/AGPL-3.0.txt

-- Copyright (C) 2018 by via donau
--   – Österreichische Wasserstraßen-Gesellschaft mbH
-- Software engineering by Intevation GmbH

-- Author(s):
--  * Sascha Wilde <wilde@intevation.de>


-- Tables for data from geonames database
-- https://download.geonames.org/
-- used for searching cities and villages...

CREATE TABLE waterway.geonames (
       geonameid int PRIMARY KEY,
       name varchar(200) NOT NULL,
       asciiname varchar(200),
       alternatenames varchar(10000),
       location geography(POINT, 4326) NOT NULL,
       feature_class char(1),
       feature_code varchar(10),
       country_code char(2),
       cc2 varchar(200),
       admin1_code varchar(20),
       admin2_code varchar(80),
       admin3_code varchar(20),
       admin4_code varchar(20),
       population int,
       elevation int,
       dem int,
       timezone varchar(40),
       modification_date timestamp
);