Mercurial > gemma
comparison schema/updates/1404/01.add_grouped_fm_layers.sql @ 4945:97533bbfaa2d fairway-marks-import
Add missing fairway mark types to layer group
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Tue, 18 Feb 2020 13:00:25 +0100 |
parents | |
children |
comparison
equal
deleted
inserted
replaced
4944:6256d1bca8f6 | 4945:97533bbfaa2d |
---|---|
1 INSERT INTO sys_admin.published_services ( | |
2 schema, name, srid, key_column, view_def | |
3 ) VALUES | |
4 ('waterway', 'fairway_marks_boysaw', NULL, NULL, NULL), | |
5 ('waterway', 'fairway_marks_boyspp', NULL, NULL, NULL), | |
6 ('waterway', 'fairway_marks_daymar', NULL, NULL, NULL), | |
7 ('waterway', 'fairway_marks_lights', NULL, NULL, NULL), | |
8 ('waterway', 'fairway_marks_rtpbcn', NULL, NULL, NULL), | |
9 ('waterway', 'fairway_marks_topmar', NULL, NULL, NULL), | |
10 ('waterway', 'fairway_marks_notmrk', NULL, NULL, NULL); | |
11 | |
12 INSERT INTO sys_admin.grouped_layers VALUES | |
13 ('fairway_marks', 'waterway', 'fairway_marks_boysaw', 3), | |
14 ('fairway_marks', 'waterway', 'fairway_marks_boyspp', 4), | |
15 ('fairway_marks', 'waterway', 'fairway_marks_daymar', 5), | |
16 ('fairway_marks', 'waterway', 'fairway_marks_lights', 6), | |
17 ('fairway_marks', 'waterway', 'fairway_marks_rtpbcn', 7), | |
18 ('fairway_marks', 'waterway', 'fairway_marks_topmar', 8), | |
19 ('fairway_marks', 'waterway', 'fairway_marks_notmrk', 9); |