Mercurial > gemma
diff schema/updates/1204/02.delete-contours.sql @ 4578:c657dec6b0fa iso-areas
Removed old contours from backend and database.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Tue, 08 Oct 2019 12:10:55 +0200 |
parents | |
children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/schema/updates/1204/02.delete-contours.sql Tue Oct 08 12:10:55 2019 +0200 @@ -0,0 +1,8 @@ +DELETE FROM sys_admin.published_services WHERE name = 'waterway.sounding_differences'::regclass; +DELETE FROM sys_admin.published_services WHERE name = 'waterway.sounding_results_contour_lines_geoserver'::regclass; + +DROP VIEW waterway.sounding_results_contour_lines_geoserver; +DROP VIEW waterway.sounding_differences; +DROP TABLE caching.sounding_differences_contour_lines; +DROP TABLE waterway.sounding_results_contour_lines; +