# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1310051130 0
# Node ID 4e1b475a8cba046bb0f6c0a40b7a2f02526423d2
# Parent  7c88650ff5489b4b8569f7240dccca68c6221877
Schema: Dropped unique constraint of x in a single line of a "Querprofil-Spur".

flys-backend/trunk@2306 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r 7c88650ff548 -r 4e1b475a8cba flys-backend/ChangeLog
--- a/flys-backend/ChangeLog	Thu Jul 07 14:51:08 2011 +0000
+++ b/flys-backend/ChangeLog	Thu Jul 07 15:05:30 2011 +0000
@@ -1,3 +1,13 @@
+2011-07-07	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
+
+	* doc/schema/postgresql.sql: Dropped constraint that enforces the
+	  uniquness of x in a "Querprofil-Spur". There are vertical lines
+	  in the soundings so this constraint is violated.
+
+	  To update existing databases:
+	
+		ALTER TABLE cross_section_points DROP CONSTRAINT cross_section_points_cross_section_id_key2;
+
 2011-07-07	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
 
 	* src/main/java/de/intevation/flys/importer/PRFParser.java:
diff -r 7c88650ff548 -r 4e1b475a8cba flys-backend/doc/schema/postgresql.sql
--- a/flys-backend/doc/schema/postgresql.sql	Thu Jul 07 14:51:08 2011 +0000
+++ b/flys-backend/doc/schema/postgresql.sql	Thu Jul 07 15:05:30 2011 +0000
@@ -280,7 +280,6 @@
     col_pos          int NOT NULL,
     x                NUMERIC NOT NULL,
     y                NUMERIC NOT NULL
-    UNIQUE (cross_section_id, x),
     UNIQUE (cross_section_id, col_pos)
 );