diff flys-backend/ChangeLog @ 1212:dd948530fd57

Schema: Added missing columns in HYK tables. flys-backend/trunk@2338 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 15 Jul 2011 14:33:12 +0000
parents f08fe480092c
children cc88db4a5b34
line wrap: on
line diff
--- a/flys-backend/ChangeLog	Fri Jul 15 13:07:45 2011 +0000
+++ b/flys-backend/ChangeLog	Fri Jul 15 14:33:12 2011 +0000
@@ -1,3 +1,17 @@
+2011-07-15	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
+
+	* doc/schema/postgresql.sql: Added missing columns.
+	  To update existing databases:
+	  BEGIN;
+	    ALTER TABLE hyks ADD COLUMN measure TIMESTAMP;
+	    ALTER TABLE hyk_entries ADD COLUMN distance_vl NUMERIC NOT NULL;
+	    ALTER TABLE hyk_entries ADD COLUMN distance_hf NUMERIC NOT NULL;
+	    ALTER TABLE hyk_entries ADD COLUMN distance_vr NUMERIC NOT NULL;
+	  COMMIT;
+	* src/main/java/de/intevation/flys/model/HYKEntry.java,
+	  src/main/java/de/intevation/flys/model/HYK.java:
+	  Adjusted Hibernate models.
+
 2011-07-15	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
 
 	* src/main/java/de/intevation/flys/importer/parsers/*.java:

http://dive4elements.wald.intevation.org