diff flys-backend/ChangeLog @ 1202:44581b40b968

Schema: Added description column to the cross section table flys-backend/trunk@2307 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 07 Jul 2011 15:20:19 +0000
parents 4e1b475a8cba
children 3c01bef43a98
line wrap: on
line diff
--- a/flys-backend/ChangeLog	Thu Jul 07 15:05:30 2011 +0000
+++ b/flys-backend/ChangeLog	Thu Jul 07 15:20:19 2011 +0000
@@ -1,3 +1,19 @@
+2011-07-07	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
+
+	* doc/schema/postgresql.sql: Dropped constraint that enforces the
+	  uniquness of km and river. This is violated because there are
+	  more than one sounding in different year at the same km of a river.
+	  Added column 'description' to the cross section table to make it
+	  human readable.
+
+	  To update existing databases:
+
+		ALTER TABLE cross_sections DROP CONSTRAINT cross_sections_km_key;
+		ALTER TABLE cross_sections ADD COLUMN description VARCHAR(256);
+
+	* src/main/java/de/intevation/flys/model/CrossSection.java:
+	  Added the description column to the Hibernate model.
+	
 2011-07-07	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
 
 	* doc/schema/postgresql.sql: Dropped constraint that enforces the

http://dive4elements.wald.intevation.org