Mercurial > gemma
changeset 4057:b79b60c0cc5a
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 | 1ecfe5d015b0 |
children | 6c5c15b2fb64 |
files | schema/gemma.sql schema/updates/1009/01.drop-fa-date_info-default.sql schema/version.sql |
diffstat | 3 files changed, 4 insertions(+), 5 deletions(-) [+] |
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,
--- /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;