Mercurial > gemma
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.