Mercurial > gemma
view schema/updates/1410/01.distinct_hydro_ienc_layers.sql @ 5677:a57be8bfb6ea sr-v2
More suited file names.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Sun, 11 Feb 2024 09:51:21 +0100 |
parents | ac846e085553 |
children |
line wrap: on
line source
INSERT INTO sys_admin.published_services ( schema, name, style ) VALUES ('waterway', 'fairway_marks_bcnlat_ienc', ( SELECT style FROM sys_admin.published_services WHERE schema = 'waterway' AND name = 'fairway_marks_bcnlat')), ('waterway', 'fairway_marks_boylat_ienc', ( SELECT style FROM sys_admin.published_services WHERE schema = 'waterway' AND name = 'fairway_marks_boylat')), ('waterway', 'fairway_marks_daymar_ienc', ( SELECT style FROM sys_admin.published_services WHERE schema = 'waterway' AND name = 'fairway_marks_daymar')); INSERT INTO sys_admin.grouped_layers VALUES ('fairway_marks', 'waterway', 'fairway_marks_boylat_ienc', 0), ('fairway_marks', 'waterway', 'fairway_marks_bcnlat_ienc', 2), ('fairway_marks', 'waterway', 'fairway_marks_daymar_ienc', 5); WITH upd AS ( UPDATE sys_admin.grouped_layers SET name = name || '_hydro' WHERE schema = 'waterway' AND name IN( 'fairway_marks_bcnlat', 'fairway_marks_boylat', 'fairway_marks_daymar')) UPDATE sys_admin.published_services SET name = name || '_hydro' WHERE schema = 'waterway' AND name IN( 'fairway_marks_bcnlat', 'fairway_marks_boylat', 'fairway_marks_daymar');