# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1571060978 -7200
# Node ID c1fa4cf8a3f48f9549569f56a365bcfddb8c9d1c
# Parent  6eab3ac0e849ae94dbb89293fe2de8ef6b574a8b
Added an SQL script to be manually executed after the 1302 update.

diff -r 6eab3ac0e849 -r c1fa4cf8a3f4 schema/update-db.sh
--- a/schema/update-db.sh	Mon Oct 14 15:27:34 2019 +0200
+++ b/schema/update-db.sh	Mon Oct 14 15:49:38 2019 +0200
@@ -104,7 +104,7 @@
     echo "Running updates for $new_ver ..."
 
     file_args=""
-    for f in "$d"/* ; do
+    for f in "$d"/*.sql ; do
       file_args+=" -f $f"
     done
 
diff -r 6eab3ac0e849 -r c1fa4cf8a3f4 schema/updates/1302/after-update.sql_manual
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/1302/after-update.sql_manual	Mon Oct 14 15:49:38 2019 +0200
@@ -0,0 +1,11 @@
+--
+-- Before executing this script you have to build the cmd/oct2str tool.
+-- $ cd cmd/oct2str && go build
+-- Use
+-- $ ./oct2str --help
+-- to find out how to use it:
+-- Passing the right db credentials should be enough.
+--
+
+ALTER TABLE waterway.sounding_results DROP COLUMN octree_index;
+ALTER TABLE waterway.sounding_results DROP COLUMN octree_checksum;