Mercurial > gemma

comparison schema/updates/1203/01.fa_fix_position_field.sql @ 4461:7128741faeb9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Changed fa data to accept "position" as strings, not a 2char "position_code"
author Sascha Wilde <wilde@intevation.de>
date Mon, 23 Sep 2019 12:59:48 +0200
parents
children
comparison
equal deleted inserted replaced
4460:ace7c8d6290d 4461:7128741faeb9
1 -- This is Free Software under GNU Affero General Public License v >= 3.0
2 -- without warranty, see README.md and license for details.
3
4 -- SPDX-License-Identifier: AGPL-3.0-or-later
5 -- License-Filename: LICENSES/AGPL-3.0.txt
6
7 -- Copyright (C) 2019 by via donau
8 -- – Österreichische Wasserstraßen-Gesellschaft mbH
9 -- Software engineering by Intevation GmbH
10
11 -- Author(s):
12 -- * Sascha Wilde <sascha.wilde@intevation.de>
13
14 ALTER TABLE waterway.fairway_availability
15 ADD COLUMN IF NOT EXISTS position varchar;
16
17 UPDATE waterway.fairway_availability SET position = position_code;
18
19 ALTER TABLE waterway.fairway_availability
20 DROP COLUMN IF EXISTS position_code;