-- This is Free Software under GNU Affero General Public License v >= 3.0
-- without warranty, see README.md and license for details.

-- SPDX-License-Identifier: AGPL-3.0-or-later
-- License-Filename: LICENSES/AGPL-3.0.txt

-- Copyright (C) 2018, 2019 by via donau
--   – Österreichische Wasserstraßen-Gesellschaft mbH
-- Software engineering by Intevation GmbH

-- Author(s):
--  * Sascha Wilde <wilde@intevation.de>
--  * Bernhard Reiter <bernhard.reiter@intevation.de>
--  * Fadi Abbund <fadi.abbud@intevation.de>
--  * Tom Gottfried <tom@intevation.de>

BEGIN;

--
-- Default system configurations for the GEMMA database
--

--
-- Tables and views published via GeoServer
--
INSERT INTO sys_admin.published_services (name) VALUES
    ('waterway.sections_geoserver'),
    ('waterway.stretches_geoserver'),
    ('waterway.fairway_dimensions'),
    ('waterway.gauges_geoserver'),
    ('waterway.distance_marks_ashore_geoserver'),
    ('waterway.distance_marks_geoserver'),
    ('waterway.sounding_results_contour_lines_geoserver'),
    ('waterway.bottlenecks_geoserver'),
    ('waterway.bottleneck_overview'),
    ('waterway.waterway_axis'),
    ('waterway.waterway_area'),
    ('waterway.waterway_profiles'),
    ('waterway.sounding_differences');

--
-- Settings
--
INSERT INTO sys_admin.system_config VALUES ('ecdis_wms_url', 'https://service.d4d-portal.info/wms/');
INSERT INTO sys_admin.system_config VALUES ('ecdis_wms_params', '{"LAYERS": "d4d", "VERSION": "1.1.1", "TILED": true}');
INSERT INTO sys_admin.system_config VALUES ('bn_revtime_multiplier', 1.5);
INSERT INTO sys_admin.system_config VALUES ('gm_min_values_14d', 1224);
INSERT INTO sys_admin.system_config VALUES ('gm_latest_hours', 24);
INSERT INTO sys_admin.system_config VALUES ('gm_forecast_offset_24h', 15);
INSERT INTO sys_admin.system_config VALUES ('gm_forecast_offset_72h', 15);
INSERT INTO sys_admin.system_config VALUES ('gm_forecast_vs_reality_nsc_24h', -12.5);
INSERT INTO sys_admin.system_config VALUES ('gm_forecast_vs_reality_nsc_72h', -12.5);
INSERT INTO sys_admin.system_config VALUES ('morphology_classbreaks', '1:#ff00dd,1.5,1.7,1.9,2.1,2.3,2.5:#f25f20,2.7,2.9,3.1:#f7e40e,3.3,3.5,4:#8ad51a,4.5,5,5.5,6,6.5,7:#1414ff');
INSERT INTO sys_admin.system_config VALUES ('morphology_classbreaks_compare', '-2:#06b100,-1.9,-1.8,-1.7,-1.6,-1.5,-1.4,-1.3,-1.2,-1.1,-1:#1cc68e,-0.9,-0.8,-0.7,-0.6,-0.5,-0.4,-0.3,-0.2,-0.1,0:#c2c2c2,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1:#fff01a,1.1,1.2,1.3,1.4,1.5,1.6,1.7,1.8,1.9,2:#f80012');
INSERT INTO sys_admin.system_config VALUES ('bottlenecks_stroke','#fa28ff');
INSERT INTO sys_admin.system_config VALUES ('bottlenecks_fill','#ff25c424');
INSERT INTO sys_admin.system_config VALUES ('stretches_stroke','#fac800cc');
INSERT INTO sys_admin.system_config VALUES ('stretches_fill','#fac80a4d');
INSERT INTO sys_admin.system_config VALUES ('sections_stroke','#ff960acc');
INSERT INTO sys_admin.system_config VALUES ('sections_fill','#ff96004d');
INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos1_stroke','#0000ffcc');
INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos1_fill','#f0e60033');
INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos2_stroke','#0000ffe6');
INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos2_fill','#f0e6001a');
INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos3_stroke','#0000ff');
INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos3_fill','#ffffff66');
INSERT INTO sys_admin.system_config VALUES ('waterwayprofiles_stroke','#0000ff80');

INSERT INTO sys_admin.system_config VALUES ('distance_marks_fill', '#ff99994d');
INSERT INTO sys_admin.system_config VALUES ('distance_marks_stroke', '#6666ff');
INSERT INTO sys_admin.system_config VALUES ('distance_marks_ashore_fill', '#8888ff1a');
INSERT INTO sys_admin.system_config VALUES ('distance_marks_ashore_stroke', '#3333ff');
INSERT INTO sys_admin.system_config VALUES ('waterway_axis_stroke', '#0000ff');
INSERT INTO sys_admin.system_config VALUES ('waterway_area_stroke', '#006600');

COMMIT;