# HG changeset patch
# User Felix Wolfsteller <felix.wolfsteller@intevation.de>
# Date 1342603491 0
# Node ID 3442304b430ac17035ab2602c10351541b71e39c
# Parent  09e906487024a0a898f915ce4066a39edb717831
Adjusted official lines views schemata to include wst column pos.

flys-backend/trunk@5031 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r 09e906487024 -r 3442304b430a flys-backend/ChangeLog
--- 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'.
diff -r 09e906487024 -r 3442304b430a flys-backend/doc/schema/oracle.sql
--- 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
diff -r 09e906487024 -r 3442304b430a flys-backend/doc/schema/postgresql.sql
--- 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