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

http://dive4elements.wald.intevation.org