view schema/demo-data/published_services.sql @ 2367:0aedae39726e

Print templates: Removed primary key from templates table and add a unique constraint to template name and country instead to make possible that different countries can use templates with same name.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 21 Feb 2019 10:46:38 +0100
parents 3dd2de314b1b
children 960550ccca55
line wrap: on
line source

-- 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.stretches_geoserver'),
    ('waterway.fairway_dimensions'),
    ('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')