Mercurial > gemma

annotate schema/updates/1302/after-update.sql_manual @ 4808:db450fcc8ed7

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
client: add title for the exported image
author Fadi Abbud <fadi.abbud@intevation.de>
date Tue, 29 Oct 2019 11:04:14 +0100
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;