Mercurial > gemma
view schema/updates/1410/01.distinct_hydro_ienc_layers.sql @ 5132:8d5e3ce27d20
client: Time based search
* Add Time parameter to the search request when Time slider is active
author | Fadi Abbud <fadi.abbud@intevation.de> |
---|---|
date | Fri, 27 Mar 2020 15:30:15 +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');