changeset 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 a8adf19fbde3
children cc7df824d5c4
files backend/doc/schema/oracle.sql backend/doc/schema/postgresql.sql
diffstat 2 files changed, 0 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql	Fri May 31 16:38:57 2013 +0200
+++ b/backend/doc/schema/oracle.sql	Fri May 31 17:24:22 2013 +0200
@@ -54,7 +54,6 @@
     y                       NUMBER(38,2) NOT NULL,
     cross_section_line_id   NUMBER(38,0) NOT NULL,
     PRIMARY KEY             (id),
-    UNIQUE (cross_section_line_id, col_pos)
 );
 
 
--- a/backend/doc/schema/postgresql.sql	Fri May 31 16:38:57 2013 +0200
+++ b/backend/doc/schema/postgresql.sql	Fri May 31 17:24:22 2013 +0200
@@ -315,7 +315,6 @@
     col_pos               int             NOT NULL,
     x                     NUMERIC         NOT NULL,
     y                     NUMERIC         NOT NULL,
-    UNIQUE (cross_section_line_id, col_pos)
 );
 
 -- Indices for faster access of the points

http://dive4elements.wald.intevation.org