# HG changeset patch
# User Felix Wolfsteller <felix.wolfsteller@intevation.de>
# Date 1348740910 0
# Node ID fc32a495508720e8933b8ecec45fe1ff0cd7e1b3
# Parent  5d8db3349b779bbf91c61d25e482b86ee8887606
Towards fix for issue863 (gaps in bedheight data).

flys-backend/trunk@5610 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r 5d8db3349b77 -r fc32a4955087 flys-backend/ChangeLog
--- a/flys-backend/ChangeLog	Thu Sep 27 08:08:38 2012 +0000
+++ b/flys-backend/ChangeLog	Thu Sep 27 10:15:10 2012 +0000
@@ -1,3 +1,11 @@
+2012-09-27  Felix Wolfsteller <felix.wolfsteller@intevation.de>
+
+	Towards fix for issue863 (data gaps in bed height single values).
+
+	* doc/schema/postgresql-minfo.sql,
+	  doc/schema/oracle-minfo.sql:
+	  Drop "NOT NULL" constraints on some single bed height value columns.
+
 2012-09-27	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
 
 	* src/main/java/de/intevation/flys/model/BedHeightSingle.java:
diff -r 5d8db3349b77 -r fc32a4955087 flys-backend/doc/schema/oracle-minfo.sql
--- a/flys-backend/doc/schema/oracle-minfo.sql	Thu Sep 27 08:08:38 2012 +0000
+++ b/flys-backend/doc/schema/oracle-minfo.sql	Thu Sep 27 10:15:10 2012 +0000
@@ -84,9 +84,9 @@
     station                 NUMBER(38,2) NOT NULL,
     height                  NUMBER(38,2),
     uncertainty             NUMBER(38,2),
-    data_gap                NUMBER(38,2) NOT NULL,
-    sounding_width          NUMBER(38,2) NOT NULL,
-    width                   NUMBER(38,2) NOT NULL,
+    data_gap                NUMBER(38,2),
+    sounding_width          NUMBER(38,2),
+    width                   NUMBER(38,2),
     PRIMARY KEY(id),
     CONSTRAINT fk_bed_single_values_parent FOREIGN KEY (bed_height_single_id) REFERENCES bed_height_single(id)
 );
diff -r 5d8db3349b77 -r fc32a4955087 flys-backend/doc/schema/postgresql-minfo.sql
--- a/flys-backend/doc/schema/postgresql-minfo.sql	Thu Sep 27 08:08:38 2012 +0000
+++ b/flys-backend/doc/schema/postgresql-minfo.sql	Thu Sep 27 10:15:10 2012 +0000
@@ -84,9 +84,9 @@
     station                 NUMERIC NOT NULL,
     height                  NUMERIC,
     uncertainty             NUMERIC,
-    data_gap                NUMERIC NOT NULL,
-    sounding_width          NUMERIC NOT NULL,
-    width                   NUMERIC NOT NULL,
+    data_gap                NUMERIC,
+    sounding_width          NUMERIC,
+    width                   NUMERIC,
     PRIMARY KEY(id),
     CONSTRAINT fk_bed_single_values_parent FOREIGN KEY (bed_height_single_id) REFERENCES bed_height_single(id)
 );