-- 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;