Mercurial > dive4elements > river
diff backend/doc/schema/oracle.sql @ 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 | b1fa193fa5db |
| children | 5ce6a3d7d632 |
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)