Mercurial > gemma

comparison schema/default_sysconfig.sql @ 4364:496bbf0f618c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
comparison
equal deleted inserted replaced
4363:d6439e7c8b1c 4364:496bbf0f618c
10 10
11 -- Author(s): 11 -- Author(s):
12 -- * Sascha Wilde <wilde@intevation.de> 12 -- * Sascha Wilde <wilde@intevation.de>
13 -- * Bernhard Reiter <bernhard.reiter@intevation.de> 13 -- * Bernhard Reiter <bernhard.reiter@intevation.de>
14 -- * Fadi Abbund <fadi.abbud@intevation.de> 14 -- * Fadi Abbund <fadi.abbud@intevation.de>
15 -- * Tom Gottfried <tom@intevation.de>
15 16
16 BEGIN; 17 BEGIN;
17 18
18 -- 19 --
19 -- Default system configurations for the GEMMA database 20 -- Default system configurations for the GEMMA database
20 -- 21 --
22
23 --
24 -- Tables and views published via GeoServer
25 --
26 INSERT INTO sys_admin.published_services (name) VALUES
27 ('waterway.sections_geoserver'),
28 ('waterway.stretches_geoserver'),
29 ('waterway.fairway_dimensions'),
30 ('waterway.gauges_geoserver'),
31 ('waterway.distance_marks_ashore_geoserver'),
32 ('waterway.distance_marks_geoserver'),
33 ('waterway.sounding_results_contour_lines_geoserver'),
34 ('waterway.bottlenecks_geoserver'),
35 ('waterway.bottleneck_overview'),
36 ('waterway.waterway_axis'),
37 ('waterway.waterway_area'),
38 ('waterway.waterway_profiles'),
39 ('waterway.sounding_differences');
21 40
22 -- 41 --
23 -- Settings 42 -- Settings
24 -- 43 --
25 INSERT INTO sys_admin.system_config VALUES ('ecdis_wms_url', 'https://service.d4d-portal.info/wms/'); 44 INSERT INTO sys_admin.system_config VALUES ('ecdis_wms_url', 'https://service.d4d-portal.info/wms/');