Mercurial > dive4elements > river
changeset 3338:e19a503e4150
Partial fix for flys/issue697: Increased the decimal places of Ws, Qs and Kms to 5.
flys-backend/trunk@4923 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Wed, 11 Jul 2012 08:09:32 +0000 |
| parents | 69f06b83b3ec |
| children | 790c12c55abb |
| files | flys-backend/ChangeLog flys-backend/doc/schema/oracle.sql |
| diffstat | 2 files changed, 11 insertions(+), 5 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/ChangeLog Tue Jul 03 10:02:14 2012 +0000 +++ b/flys-backend/ChangeLog Wed Jul 11 08:09:32 2012 +0000 @@ -1,3 +1,9 @@ +2012-07-11 Sascha L. Teichmann <sascha.teichmann@intevation.de> + + Partial fix for flys/issue697 + + * doc/schema/oracle.sql: Increased the decimal places of Ws, Qs and Kms to 5. + 2012-07-03 Ingo Weinzierl <ingo@intevation.de> * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
--- a/flys-backend/doc/schema/oracle.sql Tue Jul 03 10:02:14 2012 +0000 +++ b/flys-backend/doc/schema/oracle.sql Wed Jul 11 08:09:32 2012 +0000 @@ -288,8 +288,8 @@ CREATE TABLE wst_column_values ( id NUMBER(38,0) NOT NULL, - position NUMBER(38,2), - w NUMBER(38,2), + position NUMBER(38,5), + w NUMBER(38,5), wst_column_id NUMBER(38,0), PRIMARY KEY (id) ); @@ -314,7 +314,7 @@ CREATE TABLE wst_q_ranges ( id NUMBER(38,0) NOT NULL, - q NUMBER(38,2), + q NUMBER(38,5), range_id NUMBER(38,0), PRIMARY KEY (id) ); @@ -435,7 +435,7 @@ r.b AS b, REGEXP_REPLACE( nmv.name, '[:space:]*\(.*\)[:space:]*', '') AS name, - CAST(mv.value AS NUMERIC(38, 2)) AS value + CAST(mv.value AS NUMERIC(38, 5)) AS value FROM main_values mv JOIN named_main_values nmv ON mv.named_value_id = nmv.id @@ -448,7 +448,7 @@ JOIN rivers riv ON g.river_id = riv.id WHERE mvt.name = 'Q' - ORDER BY g.id, CAST(mv.value AS NUMERIC(38,2)); + ORDER BY g.id, CAST(mv.value AS NUMERIC(38,5)); CREATE VIEW official_q_values AS