# $Id: create.sql,v 1.4 2002/04/22 21:54:25 mdean Exp $
# database used to mirror NIMA GeoNames

create table map
        (country char(2),
         feature bigint,
         name bigint,
	 modified date);

create index map_feature_index on map(feature);
create index map_country_index on map(country);

create table feature
	(id bigint,
	 latitude double,
	 longitude double,
         primary_country char(2),
         dimension text,
         secondary_country char(2),
         designation char(5));

create index feature_index on feature(id);

create table name
        (id bigint,
         short_name text,
         sort_name text,
         full_name text);

create index name_index on name(id);

# extra information for use by SONAT ENP agent

create table sonat
        (designation char(5),
         uri text);

create index sonat_index on sonat(designation);