# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1341994172 0
# Node ID e19a503e4150d8c9f1f985d1787fbc85979ae0bb
# Parent  69f06b83b3ecdf388891653fb0998fd0215aff24
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

diff -r 69f06b83b3ec -r e19a503e4150 flys-backend/ChangeLog
--- 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:
diff -r 69f06b83b3ec -r e19a503e4150 flys-backend/doc/schema/oracle.sql
--- 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