# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1564035394 -7200
# Node ID b79b60c0cc5a540fb72fe55cf3175f47bea58859
# Parent  1ecfe5d015b0f09b5d913242aa997f3035c34eef
date_info has to be provided by the data source

diff -r 1ecfe5d015b0 -r b79b60c0cc5a schema/gemma.sql
--- 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,
diff -r 1ecfe5d015b0 -r b79b60c0cc5a schema/updates/1009/01.drop-fa-date_info-default.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/1009/01.drop-fa-date_info-default.sql	Thu Jul 25 08:16:34 2019 +0200
@@ -0,0 +1,2 @@
+ALTER TABLE waterway.fairway_availability ALTER COLUMN date_info DROP DEFAULT;
+DROP TRIGGER fairway_availability_date_info ON waterway.fairway_availability;
diff -r 1ecfe5d015b0 -r b79b60c0cc5a schema/version.sql
--- a/schema/version.sql	Thu Jul 25 08:06:22 2019 +0200
+++ b/schema/version.sql	Thu Jul 25 08:16:34 2019 +0200
@@ -1,1 +1,1 @@
-INSERT INTO gemma_schema_version(version) VALUES (1008);
+INSERT INTO gemma_schema_version(version) VALUES (1009);