Mercurial > gemma
changeset 3387:d9eda49a52f4
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) )