Mercurial > gemma
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 |
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); |