Mercurial > dive4elements > river
diff flys-backend/ChangeLog @ 1217:d5e39c16fd2a
Schema: Fixed location of 'Peilungsjahre' in HYKs
flys-backend/trunk@2343 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Sun, 17 Jul 2011 10:24:20 +0000 |
| parents | f8b5c37f15e4 |
| children | 00e37d22a589 |
line wrap: on
line diff
--- a/flys-backend/ChangeLog Sun Jul 17 10:00:13 2011 +0000 +++ b/flys-backend/ChangeLog Sun Jul 17 10:24:20 2011 +0000 @@ -1,3 +1,17 @@ +2011-07-17 Sascha L. Teichmann <sascha.teichmann@intevation.de> + + * doc/schema/postgresql.sql: Each entry in a HYK can have + an optional 'Peilungsjahr' (measure) not only the whole HYK. + To update existing databases: + BEGIN; + ALTER TABLE hyks DROP COLUMN measure; + ALTER TABLE hyk_entries ADD COLUMN measure TIMESTAMP; + COMMIT; + + * src/main/java/de/intevation/flys/model/HYKEntry.java, + src/main/java/de/intevation/flys/model/HYK.java: + Adjusted Hibernate models. + 2011-07-17 Sascha L. Teichmann <sascha.teichmann@intevation.de> * src/main/java/de/intevation/flys/importer/parsers/HYKParser.java: @@ -24,9 +38,9 @@ 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; + 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,