CREATE TABLE data (
    id int NOT NULL AUTO_INCREMENT,
    kind_id int NOT NULL,
    lat float,
    lon float,
    country text NOT NULL,
    city text,
    name text NOT NULL,
    descr text NOT NULL,
    established text, 
    updated timestamp,
    url text NOT NULL,
    img text NOT NULL,
    manual boolean,
    primary key (id)
);

CREATE TABLE kind (
    id int NOT NULL AUTO_INCREMENT,
    type    text NOT NULL,
    color   text NOT NULL,
    primary key (id)
);
