# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1567698103 -7200
# Node ID 1b928c0a08947511f29ca7cef59b4d14341889c2
# Parent  1bf26d18b4d78105fc4dfaf0968429974cf4dcdc
Adapt demo data to new database model

Also add an ON CONFLICT clause to allow resetting entries in a
partly populated table.

diff -r 1bf26d18b4d7 -r 1b928c0a0894 schema/demo-data/published_services.sql
--- a/schema/demo-data/published_services.sql	Thu Sep 05 17:27:34 2019 +0200
+++ b/schema/demo-data/published_services.sql	Thu Sep 05 17:41:43 2019 +0200
@@ -11,17 +11,18 @@
 -- Author(s):
 --  * Tom Gottfried <tom@intevation.de>
 
-INSERT INTO sys_admin.published_services (name) VALUES
-    ('waterway.sections_geoserver'),
-    ('waterway.stretches_geoserver'),
-    ('waterway.fairway_dimensions'),
-    ('waterway.gauges_geoserver'),
-    ('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'),
-    ('waterway.sounding_differences')
+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