Mercurial > dive4elements > river
comparison flys-backend/ChangeLog @ 754:5bcf338eadb9
Added a new view to select ws of a WST.
flys-backend/trunk@1986 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Tue, 24 May 2011 10:49:14 +0000 |
| parents | 677a6fceea6e |
| children | a29fd0916803 |
comparison
equal
deleted
inserted
replaced
| 753:677a6fceea6e | 754:5bcf338eadb9 |
|---|---|
| 1 2011-05-24 Sascha L. Teichmann <sascha.teichmann@intevation.de> | |
| 2 | |
| 3 * doc/schema/postgresql.sql: Added a new view to select ws of a WST. | |
| 4 To update existing databases: | |
| 5 | |
| 6 CREATE VIEW wst_w_values AS | |
| 7 SELECT wcv."position" AS km, | |
| 8 wcv.w AS w, | |
| 9 wc."position" AS column_pos, | |
| 10 w.id AS wst_id | |
| 11 FROM wst_column_values wcv | |
| 12 JOIN wst_columns wc ON wcv.wst_column_id = wc.id | |
| 13 JOIN wsts w ON wc.wst_id = w.id | |
| 14 ORDER BY wcv."position", wc."position"; | |
| 15 | |
| 1 2011-05-23 Sascha L. Teichmann <sascha.teichmann@intevation.de> | 16 2011-05-23 Sascha L. Teichmann <sascha.teichmann@intevation.de> |
| 2 | 17 |
| 3 flys/issue76 | 18 flys/issue76 |
| 4 | 19 |
| 5 * src/main/java/de/intevation/flys/importer/WstParser.java: | 20 * src/main/java/de/intevation/flys/importer/WstParser.java: |