# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1321631587 0
# Node ID 418a0918863b32fcaf6b677832392c1c8ec95738
# Parent  2246348ff90e9fe0e7c3223a247fcc92513c95f5
Fixed flys/issue415: Increased precision of a and b in ranges.

flys-backend/trunk@3292 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r 2246348ff90e -r 418a0918863b flys-backend/ChangeLog
--- a/flys-backend/ChangeLog	Thu Nov 10 13:58:33 2011 +0000
+++ b/flys-backend/ChangeLog	Fri Nov 18 15:53:07 2011 +0000
@@ -1,3 +1,9 @@
+2011-11-18	Sascha L. Teichmann	<sascha.teichmann@intevation.de>:
+
+	Fixed flys/issue415
+
+	* doc/schema/oracle.sql: Increased precision of a and b in ranges.
+
 2011-11-10  Ingo Weinzierl <ingo@intevation.de>
 
 	* src/main/java/de/intevation/flys/model/Building.java,
diff -r 2246348ff90e -r 418a0918863b flys-backend/doc/schema/oracle.sql
--- a/flys-backend/doc/schema/oracle.sql	Thu Nov 10 13:58:33 2011 +0000
+++ b/flys-backend/doc/schema/oracle.sql	Fri Nov 18 15:53:07 2011 +0000
@@ -231,8 +231,8 @@
 
 CREATE TABLE ranges (
     id                  NUMBER(38,0) NOT NULL,
-    a                   NUMBER(38,2),
-    b                   NUMBER(38,2),
+    a                   NUMBER(38,10),
+    b                   NUMBER(38,10),
     river_id            NUMBER(38,0),
     PRIMARY KEY         (id)
 );