ruscomap/initDb.sql

CREATE DATABASE ruscomap;
CREATE USER 'ruscone'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON ruscomap.* TO 'ruscone'@'localhost';
FLUSH PRIVILEGES;

CREATE TABLE ruscomap.markers (
    name VARCHAR(256) NOT NULL,
    description VARCHAR(1024),
    filename VARCHAR(256) NOT NULL,
    coordinate POINT NOT NULL,
    ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);