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

http://dive4elements.wald.intevation.org