Mercurial > gemma

annotate schema/updates/1302/after-update.sql_manual @ 4754:64979fec89a7

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
SR import: Reduce the point density in interpolation 1 point per meter².
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 18 Oct 2019 17:32:02 +0200
parents c1fa4cf8a3f4
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
4661
c1fa4cf8a3f4 Added an SQL script to be manually executed after the 1302 update.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
1 --
c1fa4cf8a3f4 Added an SQL script to be manually executed after the 1302 update.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
2 -- Before executing this script you have to build the cmd/oct2str tool.
c1fa4cf8a3f4 Added an SQL script to be manually executed after the 1302 update.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
3 -- $ cd cmd/oct2str && go build
c1fa4cf8a3f4 Added an SQL script to be manually executed after the 1302 update.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
4 -- Use
c1fa4cf8a3f4 Added an SQL script to be manually executed after the 1302 update.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
5 -- $ ./oct2str --help
c1fa4cf8a3f4 Added an SQL script to be manually executed after the 1302 update.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
6 -- to find out how to use it:
c1fa4cf8a3f4 Added an SQL script to be manually executed after the 1302 update.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
7 -- Passing the right db credentials should be enough.
c1fa4cf8a3f4 Added an SQL script to be manually executed after the 1302 update.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
8 --
c1fa4cf8a3f4 Added an SQL script to be manually executed after the 1302 update.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
9
c1fa4cf8a3f4 Added an SQL script to be manually executed after the 1302 update.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
10 ALTER TABLE waterway.sounding_results DROP COLUMN octree_index;
c1fa4cf8a3f4 Added an SQL script to be manually executed after the 1302 update.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
11 ALTER TABLE waterway.sounding_results DROP COLUMN octree_checksum;