view schema/updates/1302/after-update.sql_manual @ 5560:f2204f91d286

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 c1fa4cf8a3f4
children
line wrap: on
line source

--
-- 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;