Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 3470:3442304b430a
Adjusted official lines views schemata to include wst column pos.
flys-backend/trunk@5031 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
|---|---|
| date | Wed, 18 Jul 2012 09:24:51 +0000 |
| parents | 790c12c55abb |
| children | 61195d14b844 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Mon Jul 16 06:42:12 2012 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Wed Jul 18 09:24:51 2012 +0000 @@ -364,7 +364,8 @@ SELECT w.river_id AS river_id, w.id AS wst_id, wc.id AS wst_column_id, - wc.name AS name + wc.name AS name, + wc.position AS wst_column_pos FROM wsts w JOIN wst_columns wc ON wc.wst_id = w.id @@ -404,7 +405,8 @@ a, b, ol.name, - value + value, + wst_column_pos FROM official_lines ol JOIN q_main_values qmv ON ol.river_id = qmv.river_id