Mercurial > gemma
diff schema/updates/1203/01.fa_fix_position_field.sql @ 4461:7128741faeb9
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 |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/schema/updates/1203/01.fa_fix_position_field.sql Mon Sep 23 12:59:48 2019 +0200 @@ -0,0 +1,20 @@ +-- This is Free Software under GNU Affero General Public License v >= 3.0 +-- without warranty, see README.md and license for details. + +-- SPDX-License-Identifier: AGPL-3.0-or-later +-- License-Filename: LICENSES/AGPL-3.0.txt + +-- Copyright (C) 2019 by via donau +-- – Österreichische Wasserstraßen-Gesellschaft mbH +-- Software engineering by Intevation GmbH + +-- Author(s): +-- * Sascha Wilde <sascha.wilde@intevation.de> + +ALTER TABLE waterway.fairway_availability + ADD COLUMN IF NOT EXISTS position varchar; + +UPDATE waterway.fairway_availability SET position = position_code; + +ALTER TABLE waterway.fairway_availability + DROP COLUMN IF EXISTS position_code;