# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1568043597 -7200
# Node ID 496bbf0f618c27416b3668424e9ea8b85043e198
# Parent  d6439e7c8b1c79c0457999625b73ff3d8ebd062b
Move definition of published services to default configuration

We rely on existance of these layers in some places, e.g. default
configuration, already in some places. Further, default configuration
setup is, in contrast to demo data, part of automatic database tests.

diff -r d6439e7c8b1c -r 496bbf0f618c schema/default_sysconfig.sql
--- a/schema/default_sysconfig.sql	Mon Sep 09 17:26:59 2019 +0200
+++ b/schema/default_sysconfig.sql	Mon Sep 09 17:39:57 2019 +0200
@@ -12,6 +12,7 @@
 --  * Sascha Wilde <wilde@intevation.de>
 --  * Bernhard Reiter <bernhard.reiter@intevation.de>
 --  * Fadi Abbund <fadi.abbud@intevation.de>
+--  * Tom Gottfried <tom@intevation.de>
 
 BEGIN;
 
@@ -20,6 +21,24 @@
 --
 
 --
+-- 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/');
diff -r d6439e7c8b1c -r 496bbf0f618c schema/demo-data/published_services.sql
--- a/schema/demo-data/published_services.sql	Mon Sep 09 17:26:59 2019 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,27 +0,0 @@
--- 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):
---  * Tom Gottfried <tom@intevation.de>
-
-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')