Mercurial > gemma
changeset 2172:7e2c77ccc02f
Removed trigger to update date_info on gauge_measurements.
The date info can be explicitly set by imported data, e.g. in approved
gauge measurements. Overwriting this provided data seems wrong...
author | Sascha Wilde <wilde@intevation.de> |
---|---|
date | Fri, 08 Feb 2019 17:55:42 +0100 |
parents | 543b5d071a69 |
children | 1b1cb6cbfbf0 |
files | schema/gemma.sql |
diffstat | 1 files changed, 2 insertions(+), 4 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/gemma.sql Fri Feb 08 16:52:18 2019 +0100 +++ b/schema/gemma.sql Fri Feb 08 17:55:42 2019 +0100 @@ -4,13 +4,14 @@ -- SPDX-License-Identifier: AGPL-3.0-or-later -- License-Filename: LICENSES/AGPL-3.0.txt --- Copyright (C) 2018 by via donau +-- Copyright (C) 2018,2019 by via donau -- – Österreichische Wasserstraßen-Gesellschaft mbH -- Software engineering by Intevation GmbH -- Author(s): -- * Tom Gottfried <tom@intevation.de> -- * Sascha Teichmann <sascha.teichmann@intevation.de> +-- * Sascha Wilde <sascha.wilde@intevation.de> BEGIN; @@ -292,9 +293,6 @@ -- a non-staged fk_gauge_id/measure_date pair. UNIQUE (fk_gauge_id, measure_date, staging_done) ) - CREATE TRIGGER gauge_measurements_date_info - BEFORE UPDATE ON gauge_measurements - FOR EACH ROW EXECUTE PROCEDURE update_date_info() CREATE TABLE waterway_axis ( id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,