Mercurial > gemma

annotate schema/updates/1204/02.delete-contours.sql @ 5560:f2204f91d286

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Join the log lines of imports to the log exports to recover data from them. Used in SR export to extract information that where in the meta json but now are only found in the log.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 09 Feb 2022 18:34:40 +0100
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