# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1538649925 -7200
# Node ID 5b90217aa1bbc4b8661a06112f0a1ace220aba5c
# Parent  69394644bc73cf1cd56d254538c431ce75a373ac
Fix nullability in sounding results

point_cloud represents the actual sounding data and thus should
not be NULL. The area is required for processing.

diff -r 69394644bc73 -r 5b90217aa1bb schema/gemma.sql
--- a/schema/gemma.sql	Thu Oct 04 12:28:09 2018 +0200
+++ b/schema/gemma.sql	Thu Oct 04 12:45:25 2018 +0200
@@ -402,13 +402,11 @@
         bottleneck_id varchar NOT NULL REFERENCES bottlenecks,
         date_info date NOT NULL,
         UNIQUE (bottleneck_id, date_info),
-        area geography(POLYGON, 4326),
+        area geography(POLYGON, 4326) NOT NULL,
         surtyp varchar REFERENCES survey_types,
         coverage varchar REFERENCES coverage_types,
         depth_reference char(3) NOT NULL REFERENCES depth_references,
-        point_cloud geography(MULTIPOINTZ, 4326),
-        -- XXX: We may raster the data later.
-        -- sounding_data raster NOT NULL,
+        point_cloud geography(MULTIPOINTZ, 4326) NOT NULL,
         staging_done boolean NOT NULL DEFAULT false
     )