annotate schema/updates/1402/02.fairwaymarks_group_layer.sql @ 5560:f2204f91d286

Join the log lines of imports to the log exports to recover data from them. Used in SR export to extract information that where in the meta json but now are only found in the log.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 09 Feb 2022 18:34:40 +0100
parents c6af373b0832
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
4934
c6af373b0832 Added fairwaymarks group layer in configuration.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
1 INSERT INTO sys_admin.layer_groups VALUES ('fairway_marks');
c6af373b0832 Added fairwaymarks group layer in configuration.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
2
c6af373b0832 Added fairwaymarks group layer in configuration.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
3 INSERT INTO sys_admin.grouped_layers VALUES
c6af373b0832 Added fairwaymarks group layer in configuration.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
4 ('fairway_marks', 'waterway', 'fairway_marks_boylat', 0),
c6af373b0832 Added fairwaymarks group layer in configuration.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
5 ('fairway_marks', 'waterway', 'fairway_marks_boycar', 1),
c6af373b0832 Added fairwaymarks group layer in configuration.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
6 ('fairway_marks', 'waterway', 'fairway_marks_bcnlat', 2);