Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 6733:d2fddd344d7c | 6735:839f1a889c4a |
|---|---|
| 36 -- CROSS_SECTION_LINES | 36 -- CROSS_SECTION_LINES |
| 37 CREATE SEQUENCE CROSS_SECTION_LINES_ID_SEQ; | 37 CREATE SEQUENCE CROSS_SECTION_LINES_ID_SEQ; |
| 38 | 38 |
| 39 CREATE TABLE cross_section_lines ( | 39 CREATE TABLE cross_section_lines ( |
| 40 id NUMBER(38,0) NOT NULL, | 40 id NUMBER(38,0) NOT NULL, |
| 41 km NUMBER(38,2) NOT NULL, | 41 km NUMBER(38,5) NOT NULL, |
| 42 cross_section_id NUMBER(38,0) NOT NULL, | 42 cross_section_id NUMBER(38,0) NOT NULL, |
| 43 PRIMARY KEY (id), | 43 PRIMARY KEY (id), |
| 44 UNIQUE (km, cross_section_id) | 44 UNIQUE (km, cross_section_id) |
| 45 ); | 45 ); |
| 46 | 46 |