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; |