Mercurial > dive4elements > river
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) );