Mercurial > dive4elements > river
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