changeset 3953:fc32a4955087

Towards fix for issue863 (gaps in bedheight data). flys-backend/trunk@5610 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Felix Wolfsteller <felix.wolfsteller@intevation.de>
date Thu, 27 Sep 2012 10:15:10 +0000
parents 5d8db3349b77
children ffb2aac9a5b6
files flys-backend/ChangeLog flys-backend/doc/schema/oracle-minfo.sql flys-backend/doc/schema/postgresql-minfo.sql
diffstat 3 files changed, 14 insertions(+), 6 deletions(-) [+]
line wrap: on
line diff
--- 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:
--- 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)
 );
--- 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)
 );

http://dive4elements.wald.intevation.org