Mercurial > gemma

comparison 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
comparison
equal deleted inserted replaced
4609:1bf26d18b4d7 4610:1b928c0a0894
9 -- Software engineering by Intevation GmbH 9 -- Software engineering by Intevation GmbH
10 10
11 -- Author(s): 11 -- Author(s):
12 -- * Tom Gottfried <tom@intevation.de> 12 -- * Tom Gottfried <tom@intevation.de>
13 13
14 INSERT INTO sys_admin.published_services (name) VALUES 14 INSERT INTO sys_admin.published_services (schema, name, view_def) VALUES
15 ('waterway.sections_geoserver'), 15 ('waterway', 'sections_geoserver', NULL),
16 ('waterway.stretches_geoserver'), 16 ('waterway', 'stretches_geoserver', NULL),
17 ('waterway.fairway_dimensions'), 17 ('waterway', 'fairway_dimensions', NULL),
18 ('waterway.gauges_geoserver'), 18 ('waterway', 'gauges_geoserver', NULL),
19 ('waterway.distance_marks_ashore_geoserver'), 19 ('waterway', 'distance_marks_ashore_geoserver', NULL),
20 ('waterway.distance_marks_geoserver'), 20 ('waterway', 'distance_marks_geoserver', NULL),
21 ('waterway.sounding_results_contour_lines_geoserver'), 21 ('waterway', 'sounding_results_contour_lines_geoserver', NULL),
22 ('waterway.bottlenecks_geoserver'), 22 ('waterway', 'bottlenecks_geoserver', NULL),
23 ('waterway.bottleneck_overview'), 23 ('waterway', 'bottleneck_overview', NULL),
24 ('waterway.waterway_axis'), 24 ('waterway', 'waterway_axis', NULL),
25 ('waterway.waterway_area'), 25 ('waterway', 'waterway_area', NULL),
26 ('waterway.waterway_profiles'), 26 ('waterway', 'waterway_profiles', NULL),
27 ('waterway.sounding_differences') 27 ('waterway', 'sounding_differences', NULL)
28 ON CONFLICT DO NOTHING