Mercurial > gemma

annotate schema/demo-data/published_services.sql @ 4610:1b928c0a0894 geoserver_sql_views

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adapt demo data to new database model Also add an ON CONFLICT clause to allow resetting entries in a partly populated table.
author Tom Gottfried <tom@intevation.de>
date Thu, 05 Sep 2019 17:41:43 +0200
parents b90b17d0b5a9
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
1318
50dd4ff7907e Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1110
diff changeset
1 -- This is Free Software under GNU Affero General Public License v >= 3.0
50dd4ff7907e Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1110
diff changeset
2 -- without warranty, see README.md and license for details.
50dd4ff7907e Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1110
diff changeset
3
50dd4ff7907e Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1110
diff changeset
4 -- SPDX-License-Identifier: AGPL-3.0-or-later
50dd4ff7907e Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1110
diff changeset
5 -- License-Filename: LICENSES/AGPL-3.0.txt
50dd4ff7907e Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1110
diff changeset
6
50dd4ff7907e Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1110
diff changeset
7 -- Copyright (C) 2018 by via donau
50dd4ff7907e Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1110
diff changeset
8 -- – Österreichische Wasserstraßen-Gesellschaft mbH
50dd4ff7907e Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1110
diff changeset
9 -- Software engineering by Intevation GmbH
50dd4ff7907e Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1110
diff changeset
10
50dd4ff7907e Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1110
diff changeset
11 -- Author(s):
50dd4ff7907e Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1110
diff changeset
12 -- * Tom Gottfried <tom@intevation.de>
50dd4ff7907e Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 1110
diff changeset
13
4610
1b928c0a0894 Adapt demo data to new database model
Tom Gottfried <tom@intevation.de>
parents: 3307
diff changeset
14 INSERT INTO sys_admin.published_services (schema, name, view_def) VALUES
1b928c0a0894 Adapt demo data to new database model
Tom Gottfried <tom@intevation.de>
parents: 3307
diff changeset
15 ('waterway', 'sections_geoserver', NULL),
1b928c0a0894 Adapt demo data to new database model
Tom Gottfried <tom@intevation.de>
parents: 3307
diff changeset
16 ('waterway', 'stretches_geoserver', NULL),
1b928c0a0894 Adapt demo data to new database model
Tom Gottfried <tom@intevation.de>
parents: 3307
diff changeset
17 ('waterway', 'fairway_dimensions', NULL),
1b928c0a0894 Adapt demo data to new database model
Tom Gottfried <tom@intevation.de>
parents: 3307
diff changeset
18 ('waterway', 'gauges_geoserver', NULL),
1b928c0a0894 Adapt demo data to new database model
Tom Gottfried <tom@intevation.de>
parents: 3307
diff changeset
19 ('waterway', 'distance_marks_ashore_geoserver', NULL),
1b928c0a0894 Adapt demo data to new database model
Tom Gottfried <tom@intevation.de>
parents: 3307
diff changeset
20 ('waterway', 'distance_marks_geoserver', NULL),
1b928c0a0894 Adapt demo data to new database model
Tom Gottfried <tom@intevation.de>
parents: 3307
diff changeset
21 ('waterway', 'sounding_results_contour_lines_geoserver', NULL),
1b928c0a0894 Adapt demo data to new database model
Tom Gottfried <tom@intevation.de>
parents: 3307
diff changeset
22 ('waterway', 'bottlenecks_geoserver', NULL),
1b928c0a0894 Adapt demo data to new database model
Tom Gottfried <tom@intevation.de>
parents: 3307
diff changeset
23 ('waterway', 'bottleneck_overview', NULL),
1b928c0a0894 Adapt demo data to new database model
Tom Gottfried <tom@intevation.de>
parents: 3307
diff changeset
24 ('waterway', 'waterway_axis', NULL),
1b928c0a0894 Adapt demo data to new database model
Tom Gottfried <tom@intevation.de>
parents: 3307
diff changeset
25 ('waterway', 'waterway_area', NULL),
1b928c0a0894 Adapt demo data to new database model
Tom Gottfried <tom@intevation.de>
parents: 3307
diff changeset
26 ('waterway', 'waterway_profiles', NULL),
1b928c0a0894 Adapt demo data to new database model
Tom Gottfried <tom@intevation.de>
parents: 3307
diff changeset
27 ('waterway', 'sounding_differences', NULL)
1b928c0a0894 Adapt demo data to new database model
Tom Gottfried <tom@intevation.de>
parents: 3307
diff changeset
28 ON CONFLICT DO NOTHING