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

http://dive4elements.wald.intevation.org