Mercurial > gemma

annotate schema/updates/1204/02.delete-contours.sql @ 4796:199c49f967d2

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Some Go clean-ups.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 25 Oct 2019 17:28:00 +0200
parents c657dec6b0fa
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
4578
c657dec6b0fa Removed old contours from backend and database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
1 DELETE FROM sys_admin.published_services WHERE name = 'waterway.sounding_differences'::regclass;
c657dec6b0fa Removed old contours from backend and database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
2 DELETE FROM sys_admin.published_services WHERE name = 'waterway.sounding_results_contour_lines_geoserver'::regclass;
c657dec6b0fa Removed old contours from backend and database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
3
c657dec6b0fa Removed old contours from backend and database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
4 DROP VIEW waterway.sounding_results_contour_lines_geoserver;
c657dec6b0fa Removed old contours from backend and database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
5 DROP VIEW waterway.sounding_differences;
c657dec6b0fa Removed old contours from backend and database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
6 DROP TABLE caching.sounding_differences_contour_lines;
c657dec6b0fa Removed old contours from backend and database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
7 DROP TABLE waterway.sounding_results_contour_lines;
c657dec6b0fa Removed old contours from backend and database.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
8