gistfile1.txt

CREATE TABLE `config` (
    `name` varchar(20) PRIMARY KEY,
    `value` tinyblob NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `config` (`name`, `value`) VALUES
    ('color_extra', 's:7:"#cccccc";'),
    ('color_hilite', 's:7:"#feff6a";'),
    ('color_normal', 's:7:"#ffffff";'),
    ('color_start', 's:7:"#55b500";'),
    ('color_stop', 's:7:"#ff6a00";'),
    ('google_key', 's:0:"";'),
    ('interval_seconds', 'i:10;'),
    ('lang', 's:2:"en";'),
    ('latitude', 'd:52.229999999999997;'),
    ('longitude', 'd:21.010000000000002;'),
    ('map_api', 's:10:"openlayers";'),
    ('pass_lenmin', 'i:10;'),
    ('pass_strength', 'i:2;'),
    ('public_tracks', 'b:1;'),
    ('require_auth', 'b:1;'),
    ('stroke_color', 's:7:"#ff0000";'),
    ('stroke_opacity', 'd:1;'),
    ('stroke_weight', 'i:2;'),
    ('units', 's:6:"metric";');

CREATE TABLE `ol_layers` (
      `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
      `name` varchar(50) NOT NULL,
      `url` varchar(255) NOT NULL,
      `priority` int(11) NOT NULL DEFAULT '0'
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `ol_layers` (`id`, `name`, `url`, `priority`) VALUES
    (1, 'OpenCycleMap', 'https://{a-c}.tile.thunderforest.com/cycle/{z}/{x}/{y}.png', 0),
    (2, 'OpenTopoMap', 'https://{a-c}.tile.opentopomap.org/{z}/{x}/{y}.png', 0),
    (3, 'OpenSeaMap', 'https://tiles.openseamap.org/seamark/{z}/{x}/{y}.png', 0),
    (4, 'ESRI', 'https://server.arcgisonline.com/ArcGIS/rest/services/World_Imagery/MapServer/tile/{z}/{y}/{x}', 0),
    (5, 'UMP', 'http://{1-3}.tiles.ump.waw.pl/ump_tiles/{z}/{x}/{y}.png', 0),
    (6, 'Osmapa.pl', 'http://{a-c}.tile.openstreetmap.pl/osmapa.pl/{z}/{x}/{y}.png', 0);

ALTER TABLE users ADD admin BOOLEAN NOT NULL DEFAULT FALSE AFTER password;

ALTER TABLE positions CHANGE image_id image VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

#lazily set the highest id as admin
UPDATE users SET admin = 1 ORDER BY id LIMIT 1;