Mercurial > gemma

diff schema/gemma.sql @ 4057:b79b60c0cc5a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
date_info has to be provided by the data source
author Tom Gottfried <tom@intevation.de>
date Thu, 25 Jul 2019 08:16:34 +0200
parents 4f2f34f5d14d
children 4332b9e26e2f 419f28898db0
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Jul 25 08:06:22 2019 +0200
+++ b/schema/gemma.sql	Thu Jul 25 08:16:34 2019 +0200
@@ -733,12 +733,9 @@
         UNIQUE (bottleneck_id, surdat),
         -- additional_data xml -- Currently not relevant for GEMMA
         critical boolean,
-        date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
+        date_info timestamp with time zone NOT NULL,
         source_organization varchar NOT NULL
     )
-    CREATE TRIGGER fairway_availability_date_info
-        BEFORE UPDATE ON fairway_availability
-        FOR EACH ROW EXECUTE PROCEDURE update_date_info()
 
     CREATE TABLE fa_reference_values (
         fairway_availability_id int NOT NULL REFERENCES fairway_availability,