diff schema/gemma.sql @ 4070:4332b9e26e2f historization_ng

Merged default
author Sascha Wilde <wilde@intevation.de>
date Thu, 25 Jul 2019 13:20:32 +0200
parents 76482935b6e5 b79b60c0cc5a
children c1c6a375305f
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Jul 25 12:54:30 2019 +0200
+++ b/schema/gemma.sql	Thu Jul 25 13:20:32 2019 +0200
@@ -729,12 +729,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()
     -- FIXME: From the DRC it is unclear what the exact semantics of
     --   surdat and Date_Info ar unclear.  Currently we assume that
     --   (fk_bn_fid,surdat) has to be unique, but that might be false.