Mercurial > gemma

annotate schema/default_sysconfig.sql @ 4207:9264d6405b4d stylesconfig

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
styles-config: revert from changeset 4288:cd267ed8371e
author Fadi Abbud <fadi.abbud@intevation.de>
date Wed, 14 Aug 2019 17:35:52 +0200
parents cd267ed8371e
children 984bf74ad3cf
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
1298
6590208e3ee1 add headers for licensing to some schema files
Fadi Abbud <fadi.abbud@intevation.de>
parents: 904
diff changeset
1 -- This is Free Software under GNU Affero General Public License v >= 3.0
6590208e3ee1 add headers for licensing to some schema files
Fadi Abbud <fadi.abbud@intevation.de>
parents: 904
diff changeset
2 -- without warranty, see README.md and license for details.
6590208e3ee1 add headers for licensing to some schema files
Fadi Abbud <fadi.abbud@intevation.de>
parents: 904
diff changeset
3
6590208e3ee1 add headers for licensing to some schema files
Fadi Abbud <fadi.abbud@intevation.de>
parents: 904
diff changeset
4 -- SPDX-License-Identifier: AGPL-3.0-or-later
6590208e3ee1 add headers for licensing to some schema files
Fadi Abbud <fadi.abbud@intevation.de>
parents: 904
diff changeset
5 -- License-Filename: LICENSES/AGPL-3.0.txt
6590208e3ee1 add headers for licensing to some schema files
Fadi Abbud <fadi.abbud@intevation.de>
parents: 904
diff changeset
6
6590208e3ee1 add headers for licensing to some schema files
Fadi Abbud <fadi.abbud@intevation.de>
parents: 904
diff changeset
7 -- Copyright (C) 2018 by via donau
6590208e3ee1 add headers for licensing to some schema files
Fadi Abbud <fadi.abbud@intevation.de>
parents: 904
diff changeset
8 -- – Österreichische Wasserstraßen-Gesellschaft mbH
6590208e3ee1 add headers for licensing to some schema files
Fadi Abbud <fadi.abbud@intevation.de>
parents: 904
diff changeset
9 -- Software engineering by Intevation GmbH
6590208e3ee1 add headers for licensing to some schema files
Fadi Abbud <fadi.abbud@intevation.de>
parents: 904
diff changeset
10
6590208e3ee1 add headers for licensing to some schema files
Fadi Abbud <fadi.abbud@intevation.de>
parents: 904
diff changeset
11 -- Author(s):
1301
2304778c4432 add headers for licensing to some schema files
Fadi Abbud <fadi.abbud@intevation.de>
parents: 1298
diff changeset
12 -- * Sascha Wilde <wilde@intevation.de>
1298
6590208e3ee1 add headers for licensing to some schema files
Fadi Abbud <fadi.abbud@intevation.de>
parents: 904
diff changeset
13
831
fa417ff1f355 Extended schema to save feature style information.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
14 BEGIN;
fa417ff1f355 Extended schema to save feature style information.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
15
fa417ff1f355 Extended schema to save feature style information.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
16 --
fa417ff1f355 Extended schema to save feature style information.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
17 -- Default system configurations for the GEMMA database
fa417ff1f355 Extended schema to save feature style information.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
18 --
fa417ff1f355 Extended schema to save feature style information.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
19
fa417ff1f355 Extended schema to save feature style information.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
20 --
fa417ff1f355 Extended schema to save feature style information.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
21 -- Style definitions
fa417ff1f355 Extended schema to save feature style information.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
22 --
904
e4b72a199258 New default bottleneck colors
Sascha Wilde <wilde@intevation.de>
parents: 831
diff changeset
23 INSERT INTO systemconf.feature_colours VALUES ('Bottlenecks', 'stroke', 250, 40, 255, 1);
e4b72a199258 New default bottleneck colors
Sascha Wilde <wilde@intevation.de>
parents: 831
diff changeset
24 INSERT INTO systemconf.feature_colours VALUES ('Bottlenecks', 'fill', 255, 37, 196, 0.14);
831
fa417ff1f355 Extended schema to save feature style information.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
25
3625
a688a478e35f implemented configuration backend and frontend
Markus Kottlaender <markus@intevation.de>
parents: 1301
diff changeset
26 --
a688a478e35f implemented configuration backend and frontend
Markus Kottlaender <markus@intevation.de>
parents: 1301
diff changeset
27 -- Settings
a688a478e35f implemented configuration backend and frontend
Markus Kottlaender <markus@intevation.de>
parents: 1301
diff changeset
28 --
3641
32d7bb1afdc9 client: configuration: support wms services with nested layers
Markus Kottlaender <markus@intevation.de>
parents: 3637
diff changeset
29 INSERT INTO sys_admin.system_config VALUES ('ecdis_wms_url', 'https://service.d4d-portal.info/wms/');
32d7bb1afdc9 client: configuration: support wms services with nested layers
Markus Kottlaender <markus@intevation.de>
parents: 3637
diff changeset
30 INSERT INTO sys_admin.system_config VALUES ('ecdis_wms_params', '{"LAYERS": "d4d", "VERSION": "1.1.1", "TILED": true}');
3625
a688a478e35f implemented configuration backend and frontend
Markus Kottlaender <markus@intevation.de>
parents: 1301
diff changeset
31 INSERT INTO sys_admin.system_config VALUES ('bn_revtime_multiplier', 1.5);
a688a478e35f implemented configuration backend and frontend
Markus Kottlaender <markus@intevation.de>
parents: 1301
diff changeset
32 INSERT INTO sys_admin.system_config VALUES ('gm_min_values_14d', 1224);
a688a478e35f implemented configuration backend and frontend
Markus Kottlaender <markus@intevation.de>
parents: 1301
diff changeset
33 INSERT INTO sys_admin.system_config VALUES ('gm_latest_hours', 24);
a688a478e35f implemented configuration backend and frontend
Markus Kottlaender <markus@intevation.de>
parents: 1301
diff changeset
34 INSERT INTO sys_admin.system_config VALUES ('gm_forecast_offset_24h', 15);
a688a478e35f implemented configuration backend and frontend
Markus Kottlaender <markus@intevation.de>
parents: 1301
diff changeset
35 INSERT INTO sys_admin.system_config VALUES ('gm_forecast_offset_72h', 15);
a688a478e35f implemented configuration backend and frontend
Markus Kottlaender <markus@intevation.de>
parents: 1301
diff changeset
36 INSERT INTO sys_admin.system_config VALUES ('gm_forecast_vs_reality_nsc_24h', -12.5);
a688a478e35f implemented configuration backend and frontend
Markus Kottlaender <markus@intevation.de>
parents: 1301
diff changeset
37 INSERT INTO sys_admin.system_config VALUES ('gm_forecast_vs_reality_nsc_72h', -12.5);
3846
f1ce295d9283 added classbreak color for morphology classbreaks
Markus Kottlaender <markus@intevation.de>
parents: 3763
diff changeset
38 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');
3763
a1bb7c894058 client: configuration: morphology classbreaks: added color selection
Markus Kottlaender <markus@intevation.de>
parents: 3641
diff changeset
39 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');
4203
c56db74e2f9b Forget new system config for geo stylintg in schema.
Fadi Abbud <fadi.abbud@intevation.de>
parents: 3846
diff changeset
40 INSERT INTO sys_admin.system_config VALUES ('bottlenecks_stroke','#fa28ff');
4207
9264d6405b4d styles-config: revert from changeset 4288:cd267ed8371e
Fadi Abbud <fadi.abbud@intevation.de>
parents: 4206
diff changeset
41 INSERT INTO sys_admin.system_config VALUES ('bottlenecks_fill','#ff25c4');
9264d6405b4d styles-config: revert from changeset 4288:cd267ed8371e
Fadi Abbud <fadi.abbud@intevation.de>
parents: 4206
diff changeset
42 INSERT INTO sys_admin.system_config VALUES ('stretches_stroke','#fac800');
9264d6405b4d styles-config: revert from changeset 4288:cd267ed8371e
Fadi Abbud <fadi.abbud@intevation.de>
parents: 4206
diff changeset
43 INSERT INTO sys_admin.system_config VALUES ('stretches_fill','#fac80a');
9264d6405b4d styles-config: revert from changeset 4288:cd267ed8371e
Fadi Abbud <fadi.abbud@intevation.de>
parents: 4206
diff changeset
44 INSERT INTO sys_admin.system_config VALUES ('sections_stroke','#ff960a');
9264d6405b4d styles-config: revert from changeset 4288:cd267ed8371e
Fadi Abbud <fadi.abbud@intevation.de>
parents: 4206
diff changeset
45 INSERT INTO sys_admin.system_config VALUES ('sections_fill','#ff9600');
9264d6405b4d styles-config: revert from changeset 4288:cd267ed8371e
Fadi Abbud <fadi.abbud@intevation.de>
parents: 4206
diff changeset
46 INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos1_stroke','#0000ff');
9264d6405b4d styles-config: revert from changeset 4288:cd267ed8371e
Fadi Abbud <fadi.abbud@intevation.de>
parents: 4206
diff changeset
47 INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos1_fill','#f0e600');
9264d6405b4d styles-config: revert from changeset 4288:cd267ed8371e
Fadi Abbud <fadi.abbud@intevation.de>
parents: 4206
diff changeset
48 INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos2_stroke','#0000ff');
9264d6405b4d styles-config: revert from changeset 4288:cd267ed8371e
Fadi Abbud <fadi.abbud@intevation.de>
parents: 4206
diff changeset
49 INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos2_fill','#f0e600');
4203
c56db74e2f9b Forget new system config for geo stylintg in schema.
Fadi Abbud <fadi.abbud@intevation.de>
parents: 3846
diff changeset
50 INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos3_stroke','#0000ff');
4207
9264d6405b4d styles-config: revert from changeset 4288:cd267ed8371e
Fadi Abbud <fadi.abbud@intevation.de>
parents: 4206
diff changeset
51 INSERT INTO sys_admin.system_config VALUES ('fairwaydimensionslos3_fill','#ffffff');
9264d6405b4d styles-config: revert from changeset 4288:cd267ed8371e
Fadi Abbud <fadi.abbud@intevation.de>
parents: 4206
diff changeset
52 INSERT INTO sys_admin.system_config VALUES ('waterwayprofiles_stroke','#0000ff');
3625
a688a478e35f implemented configuration backend and frontend
Markus Kottlaender <markus@intevation.de>
parents: 1301
diff changeset
53
831
fa417ff1f355 Extended schema to save feature style information.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
54 COMMIT;