89 lines
2.7 KiB
SQL
89 lines
2.7 KiB
SQL
/*
|
|
* μlogger
|
|
*
|
|
* Copyright(C) 2020 Bartek Fabiszewski (www.fabiszewski.net)
|
|
*
|
|
* This is free software; you can redistribute it and/or modify it under
|
|
* the terms of the GNU General Public License as published by
|
|
* the Free Software Foundation; either version 3 of the License, or
|
|
* (at your option) any later version.
|
|
*
|
|
* This program is distributed in the hope that it will be useful, but
|
|
* WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
|
|
* General Public License for more details.
|
|
*
|
|
* You should have received a copy of the GNU General Public License
|
|
* along with this program; if not, see <http://www.gnu.org/licenses/>.
|
|
*/
|
|
|
|
--
|
|
-- Table structure for table `config`
|
|
--
|
|
|
|
CREATE TABLE `config` (
|
|
`name` varchar(20) PRIMARY KEY,
|
|
`value` tinyblob NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
--
|
|
-- Data for table `config`
|
|
--
|
|
|
|
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";'),
|
|
('upload_maxsize', 'i:0;');
|
|
|
|
--
|
|
-- Table structure for table `ol_layers`
|
|
--
|
|
|
|
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;
|
|
|
|
--
|
|
-- Data for table `ol_layers`
|
|
--
|
|
|
|
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);
|
|
|
|
--
|
|
-- Add admin column to `users` table
|
|
--
|
|
|
|
ALTER TABLE `users` ADD `admin` BOOLEAN NOT NULL DEFAULT FALSE AFTER `password`;
|
|
|
|
--
|
|
-- Modify image column in `positions` table
|
|
--
|
|
|
|
ALTER TABLE `positions` CHANGE `image_id` `image` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
|