diff backend/doc/schema/oracle-minfo.sql @ 6200:53fca3392c9f

Schema change and Importer: use double to prevent rounding at import time
author Tom Gottfried <tom.gottfried@intevation.de>
date Fri, 24 May 2013 16:03:52 +0200
parents 2d16f4a0bdcc
children dc166b225775
line wrap: on
line diff
--- a/backend/doc/schema/oracle-minfo.sql	Fri May 24 13:57:40 2013 +0200
+++ b/backend/doc/schema/oracle-minfo.sql	Fri May 24 16:03:52 2013 +0200
@@ -85,12 +85,12 @@
 CREATE TABLE bed_height_single_values (
     id                      NUMBER(38,0) NOT NULL,
     bed_height_single_id    NUMBER(38,0) NOT NULL,
-    station                 NUMBER(38,2) NOT NULL,
-    height                  NUMBER(38,2),
-    uncertainty             NUMBER(38,2),
-    data_gap                NUMBER(38,2),
-    sounding_width          NUMBER(38,2),
-    width                   NUMBER(38,2),
+    station                 DOUBLE PRECISION NOT NULL,
+    height                  DOUBLE PRECISION,
+    uncertainty             DOUBLE PRECISION,
+    data_gap                DOUBLE PRECISION,
+    sounding_width          DOUBLE PRECISION,
+    width                   DOUBLE PRECISION,
     PRIMARY KEY(id),
     UNIQUE (station, bed_height_single_id),
     CONSTRAINT fk_bed_single_values_parent FOREIGN KEY (bed_height_single_id) REFERENCES bed_height_single(id) ON DELETE CASCADE

http://dive4elements.wald.intevation.org