Mercurial > gemma

annotate schema/updates/1302/after-update.sql_manual @ 5437:eeee1c411576 marking-single-beam

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Pdf-Template: Use survey-date for {date-minor} when bottleneck survey is visible.
author Thomas Junk <thomas.junk@intevation.de>
date Tue, 13 Jul 2021 12:24:29 +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;