diff backend/doc/schema/oracle-minfo.sql @ 6201:dc166b225775

Backed out changeset 53fca3392c9f
author Tom Gottfried <tom.gottfried@intevation.de>
date Fri, 24 May 2013 16:26:41 +0200
parents 53fca3392c9f
children a3fb76cf79b6 df402b3e0281
line wrap: on
line diff
--- a/backend/doc/schema/oracle-minfo.sql	Fri May 24 16:03:52 2013 +0200
+++ b/backend/doc/schema/oracle-minfo.sql	Fri May 24 16:26:41 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                 DOUBLE PRECISION NOT NULL,
-    height                  DOUBLE PRECISION,
-    uncertainty             DOUBLE PRECISION,
-    data_gap                DOUBLE PRECISION,
-    sounding_width          DOUBLE PRECISION,
-    width                   DOUBLE PRECISION,
+    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),
     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