Mercurial > dive4elements > river
comparison backend/doc/schema/oracle.sql @ 6143:6cdb3ee687a9
Schema change: remove UNIQUE-constraint which allows importing cross sections only from PRF
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 31 May 2013 17:24:22 +0200 |
| parents | 176664f84d86 |
| children | 573112007ec7 |
comparison
equal
deleted
inserted
replaced
| 6142:a8adf19fbde3 | 6143:6cdb3ee687a9 |
|---|---|
| 52 col_pos NUMBER(38,0) NOT NULL, | 52 col_pos NUMBER(38,0) NOT NULL, |
| 53 x NUMBER(38,2) NOT NULL, | 53 x NUMBER(38,2) NOT NULL, |
| 54 y NUMBER(38,2) NOT NULL, | 54 y NUMBER(38,2) NOT NULL, |
| 55 cross_section_line_id NUMBER(38,0) NOT NULL, | 55 cross_section_line_id NUMBER(38,0) NOT NULL, |
| 56 PRIMARY KEY (id), | 56 PRIMARY KEY (id), |
| 57 UNIQUE (cross_section_line_id, col_pos) | |
| 58 ); | 57 ); |
| 59 | 58 |
| 60 | 59 |
| 61 -- CROSS_SECTIONS | 60 -- CROSS_SECTIONS |
| 62 CREATE SEQUENCE CROSS_SECTIONS_ID_SEQ; | 61 CREATE SEQUENCE CROSS_SECTIONS_ID_SEQ; |