diff flys-backend/ChangeLog @ 1214:32ee9babe42c

Schema: Argh! Added distance_{vl|hf|vr} to wrong table. flys-backend/trunk@2340 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 15 Jul 2011 15:53:33 +0000
parents cc88db4a5b34
children 8aef353e54fb
line wrap: on
line diff
--- a/flys-backend/ChangeLog	Fri Jul 15 15:36:59 2011 +0000
+++ b/flys-backend/ChangeLog	Fri Jul 15 15:53:33 2011 +0000
@@ -1,3 +1,21 @@
+2011-07-15	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
+
+	* doc/schema/postgresql.sql: Argh! Added distance_{vl|hf|vr} to
+	  wrong table.
+	  To update existing databases:
+	  BEGIN;
+	    ALTER TABLE hyk_entries DROP COLUMN distance_vl;
+	    ALTER TABLE hyk_entries DROP COLUMN distance_hf;
+	    ALTER TABLE hyk_entries DROP COLUMN distance_vr;
+		ALTER TABLE hyk_formations ADD COLUMN distance_vl NUMERIC NOT NULL;
+		ALTER TABLE hyk_formations ADD COLUMN distance_hf NUMERIC NOT NULL;
+		ALTER TABLE hyk_formations ADD COLUMN distance_vr NUMERIC NOT NULL;
+	  COMMIT;
+
+	* src/main/java/de/intevation/flys/model/HYKFormation.java,
+	  src/main/java/de/intevation/flys/model/HYKEntry.java:
+	  Adjusted Hibernate models.
+
 2011-07-15	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
 
 	* src/main/java/de/intevation/flys/utils/FileTools.java: Added method

http://dive4elements.wald.intevation.org