Mercurial > gemma
annotate schema/updates/1401/01.add_fairway_marks_layers.sql @ 5545:a4fa1bf9b208 aggregate-gm-import-logging
Aggregate to 'bla: 1 (baz); 2 (foo, bar)' instead of 'bla: foo (2), baz (1), bar (2)'.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Fri, 29 Oct 2021 00:07:50 +0200 |
parents | 9b9b4150f296 |
children |
rev | line source |
---|---|
4929
9b9b4150f296
Add fairway marks layers to GeoServer
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
1 INSERT INTO sys_admin.published_services ( |
9b9b4150f296
Add fairway marks layers to GeoServer
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
2 schema, name, srid, key_column, view_def |
9b9b4150f296
Add fairway marks layers to GeoServer
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
3 ) VALUES |
9b9b4150f296
Add fairway marks layers to GeoServer
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
4 ('waterway', 'fairway_marks_bcnlat', NULL, NULL, NULL), |
9b9b4150f296
Add fairway marks layers to GeoServer
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
5 ('waterway', 'fairway_marks_boycar', NULL, NULL, NULL), |
9b9b4150f296
Add fairway marks layers to GeoServer
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
6 ('waterway', 'fairway_marks_boylat', NULL, NULL, NULL); |