Mercurial > gemma

changeset 3387:d9eda49a52f4

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remove obsolete DEFAULT values date_info is mandatorily comming from ERDMS.
author Tom Gottfried <tom@intevation.de>
date Wed, 22 May 2019 16:17:18 +0200
parents 0ba142a4bf43
children 1876b204b004
files schema/gemma.sql
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Wed May 22 16:13:38 2019 +0200
+++ b/schema/gemma.sql	Wed May 22 16:17:18 2019 +0200
@@ -321,7 +321,7 @@
             NOT NULL CHECK (date_issue <@ validity),
         reference_code varchar(4) NOT NULL REFERENCES depth_references,
         water_level double precision NOT NULL,
-        date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
+        date_info timestamp with time zone NOT NULL,
         source_organization varchar NOT NULL, -- "originator" from NtS response
         staging_done boolean NOT NULL DEFAULT false,
         UNIQUE (location, validity, measure_date, staging_done)
@@ -342,7 +342,7 @@
         water_level double precision NOT NULL,
         conf_interval numrange
             CHECK (conf_interval @> CAST(water_level AS numeric)),
-        date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
+        date_info timestamp with time zone NOT NULL,
         source_organization varchar NOT NULL, -- "originator" from NtS response
         PRIMARY KEY (location, validity, measure_date, date_issue)
     )