Mercurial > gemma
diff schema/gemma.sql @ 345:b97b3172c61a
Add staging feature to more tables
Added tables currently only have limited visibility for waterway_user
but not yet policies for write access.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 06 Aug 2018 15:19:05 +0200 |
| parents | c6b32c6ae95e |
| children | f5087cebc740 |
line wrap: on
line diff
--- a/schema/gemma.sql Mon Aug 06 14:52:04 2018 +0200 +++ b/schema/gemma.sql Mon Aug 06 15:19:05 2018 +0200 @@ -249,7 +249,8 @@ value_max double precision, -- XXX: NOT NULL if predicted? --- TODO: Add a double range type for checking? date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP, - source_organization varchar NOT NULL -- "originator" + source_organization varchar NOT NULL, -- "originator" + staging_done boolean NOT NULL DEFAULT false ) CREATE TRIGGER gauge_measurements_date_info BEFORE UPDATE ON gauge_measurements @@ -282,7 +283,8 @@ objnam varchar NOT NULL, nobjnam varchar, date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP, - source_organization varchar NOT NULL + source_organization varchar NOT NULL, + staging_done boolean NOT NULL DEFAULT false ) CREATE TRIGGER sections_stretches_date_info BEFORE UPDATE ON sections_stretches @@ -302,7 +304,8 @@ CHECK(COALESCE(lnwl, mwl, hnwl, fe30, fe100) IS NULL OR validity IS NOT NULL), date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP, - source_organization varchar NOT NULL + source_organization varchar NOT NULL, + staging_done boolean NOT NULL DEFAULT false ) CREATE TRIGGER waterway_profiles_date_info BEFORE UPDATE ON waterway_profiles @@ -315,7 +318,8 @@ max_width smallint NOT NULL, min_depth smallint NOT NULL, date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP, - source_organization varchar NOT NULL + source_organization varchar NOT NULL, + staging_done boolean NOT NULL DEFAULT false ) CREATE TRIGGER fairway_dimensions_date_info BEFORE UPDATE ON fairway_dimensions