# HG changeset patch
# User Fadi Abbud <fadi.abbud@intevation.de>
# Date 1567667982 -7200
# Node ID fe01e997d66f3c03c4803a06ee7bd83414676461
# Parent  83eb99662a91403105d5ae3bd994ae7300c2d85b
adjust sys-config values for geo styling in schema

	* add opacity values for distanc-marks-axis/ashore
	* update schema version
	* update script will overwrite the user changed style-values with default values.

diff -r 83eb99662a91 -r fe01e997d66f schema/default_sysconfig.sql
--- a/schema/default_sysconfig.sql	Wed Sep 04 17:05:43 2019 +0200
+++ b/schema/default_sysconfig.sql	Thu Sep 05 09:19:42 2019 +0200
@@ -47,11 +47,11 @@
 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', '#ff9999');
+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', '#8888FF');
-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 ('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;
diff -r 83eb99662a91 -r fe01e997d66f schema/updates/1111/01.styles_config.sql
--- a/schema/updates/1111/01.styles_config.sql	Wed Sep 04 17:05:43 2019 +0200
+++ b/schema/updates/1111/01.styles_config.sql	Thu Sep 05 09:19:42 2019 +0200
@@ -1,4 +1,7 @@
-INSERT INTO sys_admin.system_config VALUES ('distance_marks_ashore_fill', '#8888FF') ON CONFLICT (config_key) DO NOTHING;
-INSERT INTO sys_admin.system_config VALUES ('distance_marks_ashore_stroke', '#3333FF') ON CONFLICT (config_key) DO NOTHING;
-INSERT INTO sys_admin.system_config VALUES ('waterway_axis_stroke', '#0000FF') ON CONFLICT (config_key) DO NOTHING;
-INSERT INTO sys_admin.system_config VALUES ('waterway_area_stroke', '#006600') ON CONFLICT (config_key) DO NOTHING;
\ No newline at end of file
+INSERT INTO sys_admin.system_config VALUES ('distance_marks_fill', '#ff99994d') ON CONFLICT (config_key) DO NOTHING;
+INSERT INTO sys_admin.system_config VALUES ('distance_marks_ashore_fill', '#8888ff1a') ON CONFLICT (config_key) DO NOTHING;
+INSERT INTO sys_admin.system_config VALUES ('distance_marks_ashore_stroke', '#3333ff') ON CONFLICT (config_key) DO NOTHING;
+INSERT INTO sys_admin.system_config VALUES ('waterway_axis_stroke', '#0000ff') ON CONFLICT (config_key) DO NOTHING;
+INSERT INTO sys_admin.system_config VALUES ('waterway_area_stroke', '#006600') ON CONFLICT (config_key) DO NOTHING;
+
+-- The user changed styles will be overwritten with the default values.
\ No newline at end of file
diff -r 83eb99662a91 -r fe01e997d66f schema/version.sql
--- a/schema/version.sql	Wed Sep 04 17:05:43 2019 +0200
+++ b/schema/version.sql	Thu Sep 05 09:19:42 2019 +0200
@@ -1,1 +1,1 @@
-INSERT INTO gemma_schema_version(version) VALUES (1110);
+INSERT INTO gemma_schema_version(version) VALUES (1111);