Mercurial > gemma
changeset 4661:c1fa4cf8a3f4 stree-experiment
Added an SQL script to be manually executed after the 1302 update.
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Mon, 14 Oct 2019 15:49:38 +0200 |
| parents | 6eab3ac0e849 |
| children | a2f8b3ad237a |
| files | schema/update-db.sh schema/updates/1302/after-update.sql_manual |
| diffstat | 2 files changed, 12 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- 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
--- /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;