comparison schema/default_sysconfig.sql @ 5059:c4f90dcd7c15 time-sliding

merge default into time-slinding branch
author Fadi Abbud <fadi.abbud@intevation.de>
date Mon, 09 Mar 2020 12:41:47 +0100
parents ac846e085553
children bb2123358bd8
comparison
equal deleted inserted replaced
5058:e916651d3f93 5059:c4f90dcd7c15
94 -- Directly accessed tables 94 -- Directly accessed tables
95 ('waterway', 'waterway_axis', NULL, NULL, NULL), 95 ('waterway', 'waterway_axis', NULL, NULL, NULL),
96 ('waterway', 'waterway_area', NULL, NULL, NULL), 96 ('waterway', 'waterway_area', NULL, NULL, NULL),
97 ('waterway', 'waterway_profiles', NULL, NULL, NULL), 97 ('waterway', 'waterway_profiles', NULL, NULL, NULL),
98 ('waterway', 'fairway_dimensions', NULL, NULL, NULL), 98 ('waterway', 'fairway_dimensions', NULL, NULL, NULL),
99 ('waterway', 'fairway_marks_bcnlat', NULL, NULL, NULL), 99 ('waterway', 'fairway_marks_bcnlat_hydro', NULL, NULL, NULL),
100 ('waterway', 'fairway_marks_bcnlat_ienc', NULL, NULL, NULL),
100 ('waterway', 'fairway_marks_boycar', NULL, NULL, NULL), 101 ('waterway', 'fairway_marks_boycar', NULL, NULL, NULL),
101 ('waterway', 'fairway_marks_boylat', NULL, NULL, NULL), 102 ('waterway', 'fairway_marks_boylat_hydro', NULL, NULL, NULL),
103 ('waterway', 'fairway_marks_boylat_ienc', NULL, NULL, NULL),
102 ('waterway', 'fairway_marks_boysaw', NULL, NULL, NULL), 104 ('waterway', 'fairway_marks_boysaw', NULL, NULL, NULL),
103 ('waterway', 'fairway_marks_boyspp', NULL, NULL, NULL), 105 ('waterway', 'fairway_marks_boyspp', NULL, NULL, NULL),
104 ('waterway', 'fairway_marks_daymar', NULL, NULL, NULL), 106 ('waterway', 'fairway_marks_daymar_hydro', NULL, NULL, NULL),
107 ('waterway', 'fairway_marks_daymar_ienc', NULL, NULL, NULL),
105 ('waterway', 'fairway_marks_lights', NULL, NULL, NULL), 108 ('waterway', 'fairway_marks_lights', NULL, NULL, NULL),
106 ('waterway', 'fairway_marks_rtpbcn', NULL, NULL, NULL), 109 ('waterway', 'fairway_marks_rtpbcn', NULL, NULL, NULL),
107 ('waterway', 'fairway_marks_topmar', NULL, NULL, NULL), 110 ('waterway', 'fairway_marks_topmar', NULL, NULL, NULL),
108 ('waterway', 'fairway_marks_notmrk', NULL, NULL, NULL), 111 ('waterway', 'fairway_marks_notmrk', NULL, NULL, NULL),
109 -- GeoServer SQL views 112 -- GeoServer SQL views
289 -- group layers 292 -- group layers
290 -- 293 --
291 INSERT INTO sys_admin.layer_groups VALUES ('fairway_marks'); 294 INSERT INTO sys_admin.layer_groups VALUES ('fairway_marks');
292 295
293 INSERT INTO sys_admin.grouped_layers VALUES 296 INSERT INTO sys_admin.grouped_layers VALUES
294 ('fairway_marks', 'waterway', 'fairway_marks_boylat', 0), 297 ('fairway_marks', 'waterway', 'fairway_marks_boylat_hydro', 0),
298 ('fairway_marks', 'waterway', 'fairway_marks_boylat_ienc', 0),
295 ('fairway_marks', 'waterway', 'fairway_marks_boycar', 1), 299 ('fairway_marks', 'waterway', 'fairway_marks_boycar', 1),
296 ('fairway_marks', 'waterway', 'fairway_marks_bcnlat', 2), 300 ('fairway_marks', 'waterway', 'fairway_marks_bcnlat_hydro', 2),
301 ('fairway_marks', 'waterway', 'fairway_marks_bcnlat_ienc', 2),
297 ('fairway_marks', 'waterway', 'fairway_marks_boysaw', 3), 302 ('fairway_marks', 'waterway', 'fairway_marks_boysaw', 3),
298 ('fairway_marks', 'waterway', 'fairway_marks_boyspp', 4), 303 ('fairway_marks', 'waterway', 'fairway_marks_boyspp', 4),
299 ('fairway_marks', 'waterway', 'fairway_marks_daymar', 5), 304 ('fairway_marks', 'waterway', 'fairway_marks_daymar_hydro', 5),
305 ('fairway_marks', 'waterway', 'fairway_marks_daymar_ienc', 5),
300 ('fairway_marks', 'waterway', 'fairway_marks_lights', 6), 306 ('fairway_marks', 'waterway', 'fairway_marks_lights', 6),
301 ('fairway_marks', 'waterway', 'fairway_marks_rtpbcn', 7), 307 ('fairway_marks', 'waterway', 'fairway_marks_rtpbcn', 7),
302 ('fairway_marks', 'waterway', 'fairway_marks_topmar', 8), 308 ('fairway_marks', 'waterway', 'fairway_marks_topmar', 8),
303 ('fairway_marks', 'waterway', 'fairway_marks_notmrk', 9); 309 ('fairway_marks', 'waterway', 'fairway_marks_notmrk', 9);
304 310