Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle.sql @ 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 | c3e049961685 |
children | 790c12c55abb |
line wrap: on
line diff
--- 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