-- 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 by via donau
--   – Österreichische Wasserstraßen-Gesellschaft mbH
-- Software engineering by Intevation GmbH

-- Author(s):
--  * Sascha Wilde <wilde@intevation.de>

BEGIN;

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

--
-- Style definitions
--
INSERT INTO systemconf.feature_colours VALUES ('Bottlenecks', 'stroke', 250, 40, 255, 1);
INSERT INTO systemconf.feature_colours VALUES ('Bottlenecks', 'fill', 255, 37, 196, 0.14);

--
-- 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','#ff25c4');
INSERT INTO sys_admin.system_config VALUES ('stretches_stroke','#fac800');
INSERT INTO sys_admin.system_config VALUES ('stretches_fill','#fac80a');
INSERT INTO sys_admin.system_config VALUES ('sections_stroke','#ff960a');
INSERT INTO sys_admin.system_config VALUES ('sections_fill','#ff9600');
INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos1_stroke','#0000ff');
INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos1_fill','#f0e600');
INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos2_stroke','#0000ff');
INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos2_fill','#f0e600');
INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos3_stroke','#0000ff');
INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos3_fill','#ffffff');
INSERT INTO sys_admin.system_config VALUES ('waterwayprofiles_stroke','#0000ff');

COMMIT;