Mercurial > gemma
diff schema/default_sysconfig.sql @ 4364:496bbf0f618c
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.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 09 Sep 2019 17:39:57 +0200 |
parents | fe01e997d66f |
children | c657dec6b0fa 32d3e0cecf4f |
line wrap: on
line diff
--- 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/');