Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 1216:f8b5c37f15e4 | 1217:d5e39c16fd2a |
|---|---|
| 1 2011-07-17 Sascha L. Teichmann <sascha.teichmann@intevation.de> | |
| 2 | |
| 3 * doc/schema/postgresql.sql: Each entry in a HYK can have | |
| 4 an optional 'Peilungsjahr' (measure) not only the whole HYK. | |
| 5 To update existing databases: | |
| 6 BEGIN; | |
| 7 ALTER TABLE hyks DROP COLUMN measure; | |
| 8 ALTER TABLE hyk_entries ADD COLUMN measure TIMESTAMP; | |
| 9 COMMIT; | |
| 10 | |
| 11 * src/main/java/de/intevation/flys/model/HYKEntry.java, | |
| 12 src/main/java/de/intevation/flys/model/HYK.java: | |
| 13 Adjusted Hibernate models. | |
| 14 | |
| 1 2011-07-17 Sascha L. Teichmann <sascha.teichmann@intevation.de> | 15 2011-07-17 Sascha L. Teichmann <sascha.teichmann@intevation.de> |
| 2 | 16 |
| 3 * src/main/java/de/intevation/flys/importer/parsers/HYKParser.java: | 17 * src/main/java/de/intevation/flys/importer/parsers/HYKParser.java: |
| 4 Added callback mechanism and recursive file search like in the PRF parser. | 18 Added callback mechanism and recursive file search like in the PRF parser. |
| 5 All BfG-HYK files seem to parse correctly now. TODO: Build the data structures. | 19 All BfG-HYK files seem to parse correctly now. TODO: Build the data structures. |
| 22 To update existing databases: | 36 To update existing databases: |
| 23 BEGIN; | 37 BEGIN; |
| 24 ALTER TABLE hyk_entries DROP COLUMN distance_vl; | 38 ALTER TABLE hyk_entries DROP COLUMN distance_vl; |
| 25 ALTER TABLE hyk_entries DROP COLUMN distance_hf; | 39 ALTER TABLE hyk_entries DROP COLUMN distance_hf; |
| 26 ALTER TABLE hyk_entries DROP COLUMN distance_vr; | 40 ALTER TABLE hyk_entries DROP COLUMN distance_vr; |
| 27 ALTER TABLE hyk_formations ADD COLUMN distance_vl NUMERIC NOT NULL; | 41 ALTER TABLE hyk_formations ADD COLUMN distance_vl NUMERIC NOT NULL; |
| 28 ALTER TABLE hyk_formations ADD COLUMN distance_hf NUMERIC NOT NULL; | 42 ALTER TABLE hyk_formations ADD COLUMN distance_hf NUMERIC NOT NULL; |
| 29 ALTER TABLE hyk_formations ADD COLUMN distance_vr NUMERIC NOT NULL; | 43 ALTER TABLE hyk_formations ADD COLUMN distance_vr NUMERIC NOT NULL; |
| 30 COMMIT; | 44 COMMIT; |
| 31 | 45 |
| 32 * src/main/java/de/intevation/flys/model/HYKFormation.java, | 46 * src/main/java/de/intevation/flys/model/HYKFormation.java, |
| 33 src/main/java/de/intevation/flys/model/HYKEntry.java: | 47 src/main/java/de/intevation/flys/model/HYKEntry.java: |
| 34 Adjusted Hibernate models. | 48 Adjusted Hibernate models. |