Mercurial > dive4elements > river
changeset 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 | 09e906487024 |
| children | e4250c6e1538 22d608ef25dc |
| files | flys-backend/ChangeLog flys-backend/doc/schema/oracle.sql flys-backend/doc/schema/postgresql.sql |
| diffstat | 3 files changed, 13 insertions(+), 4 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/ChangeLog Mon Jul 16 06:42:12 2012 +0000 +++ b/flys-backend/ChangeLog Wed Jul 18 09:24:51 2012 +0000 @@ -1,3 +1,8 @@ +2012-07-18 Felix Wolfsteller <felix.wolfstellre@intevation.de> + + * doc/schema/postgresql.sql, doc/schema/oracle.sql: + Adjusted the official_lines views to include wst column pos. + 2012-07-16 Ingo Weinzierl <ingo@intevation.de> * Tagged module as '2.8'.
--- a/flys-backend/doc/schema/oracle.sql Mon Jul 16 06:42:12 2012 +0000 +++ b/flys-backend/doc/schema/oracle.sql Wed Jul 18 09:24:51 2012 +0000 @@ -425,7 +425,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 @@ -465,7 +466,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
--- 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