create table country( 
	id serial primary key,
        name varchar(255),
        iso char(2),
	fips char(2)
);
create table feature (
	id serial primary key,
	name varchar(64),
	code varchar(5),
	fc char(2)
);

CREATE TABLE place (
        id serial primary key,
        name varchar(255),
        name_nd varchar(255),
        country integer,
        ufi integer,
	feature_type integer,
        lat float,
        lon float,
        alt float
);
create index name_index on place (name);
create index name_nd_index on place (name_nd);