Mercurial > dive4elements > river
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