Mercurial > gemma
annotate schema/updates/1302/after-update.sql_manual @ 4837:3b0ec9b56d7c
Merged
author | Sascha Wilde <wilde@intevation.de> |
---|---|
date | Fri, 08 Nov 2019 13:10:56 +0100 |
parents | c1fa4cf8a3f4 |
children |
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; |