changeset 6735:839f1a889c4a double-precision

Schema change: Store station of cross section lines with higher precision to avoid duplicates due to rounding.
author Tom Gottfried <tom@intevation.de>
date Wed, 31 Jul 2013 14:29:12 +0200
parents d2fddd344d7c
children baae6cbc1086
files backend/doc/schema/oracle.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql	Wed Jul 31 12:31:09 2013 +0200
+++ b/backend/doc/schema/oracle.sql	Wed Jul 31 14:29:12 2013 +0200
@@ -38,7 +38,7 @@
 
 CREATE TABLE cross_section_lines (
     id                  NUMBER(38,0) NOT NULL,
-    km                  NUMBER(38,2) NOT NULL,
+    km                  NUMBER(38,5) NOT NULL,
     cross_section_id    NUMBER(38,0) NOT NULL, 
     PRIMARY KEY         (id),
     UNIQUE (km, cross_section_id)

http://dive4elements.wald.intevation.org