Mercurial > dive4elements > river
comparison flys-backend/ChangeLog @ 1202:44581b40b968
Schema: Added description column to the cross section table
flys-backend/trunk@2307 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Thu, 07 Jul 2011 15:20:19 +0000 |
| parents | 4e1b475a8cba |
| children | 3c01bef43a98 |
comparison
equal
deleted
inserted
replaced
| 1201:4e1b475a8cba | 1202:44581b40b968 |
|---|---|
| 1 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de> | |
| 2 | |
| 3 * doc/schema/postgresql.sql: Dropped constraint that enforces the | |
| 4 uniquness of km and river. This is violated because there are | |
| 5 more than one sounding in different year at the same km of a river. | |
| 6 Added column 'description' to the cross section table to make it | |
| 7 human readable. | |
| 8 | |
| 9 To update existing databases: | |
| 10 | |
| 11 ALTER TABLE cross_sections DROP CONSTRAINT cross_sections_km_key; | |
| 12 ALTER TABLE cross_sections ADD COLUMN description VARCHAR(256); | |
| 13 | |
| 14 * src/main/java/de/intevation/flys/model/CrossSection.java: | |
| 15 Added the description column to the Hibernate model. | |
| 16 | |
| 1 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de> | 17 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de> |
| 2 | 18 |
| 3 * doc/schema/postgresql.sql: Dropped constraint that enforces the | 19 * doc/schema/postgresql.sql: Dropped constraint that enforces the |
| 4 uniquness of x in a "Querprofil-Spur". There are vertical lines | 20 uniquness of x in a "Querprofil-Spur". There are vertical lines |
| 5 in the soundings so this constraint is violated. | 21 in the soundings so this constraint is violated. |