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;

http://dive4elements.wald.intevation.org