# HG changeset patch
# User Sascha Wilde <wilde@intevation.de>
# Date 1549644942 -3600
# Node ID 7e2c77ccc02f20367c466664c11c9fa03f471fbd
# Parent  543b5d071a692f78b1499efdc63a41eee2b9d073
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...

diff -r 543b5d071a69 -r 7e2c77ccc02f schema/gemma.sql
--- 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,