-- 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 (schema, name, view_def) VALUES
    ('waterway', 'sections_geoserver', NULL),
    ('waterway', 'stretches_geoserver', NULL),
    ('waterway', 'fairway_dimensions', NULL),
    ('waterway', 'gauges_geoserver', NULL),
    ('waterway', 'distance_marks_ashore_geoserver', NULL),
    ('waterway', 'distance_marks_geoserver', NULL),
    ('waterway', 'sounding_results_contour_lines_geoserver', NULL),
    ('waterway', 'bottlenecks_geoserver', NULL),
    ('waterway', 'bottleneck_overview', NULL),
    ('waterway', 'waterway_axis', NULL),
    ('waterway', 'waterway_area', NULL),
    ('waterway', 'waterway_profiles', NULL),
    ('waterway', 'sounding_differences', NULL)
ON CONFLICT DO NOTHING