--- a/flys-backend/doc/schema/oracle.sql	Thu Dec 06 13:10:27 2012 +0100
+++ b/flys-backend/doc/schema/oracle.sql	Thu Dec 06 17:30:09 2012 +0100
@@ -473,3 +473,15 @@
          JOIN q_main_values qmv
            ON ol.river_id = qmv.river_id
               AND ol.name = qmv.name;
+
+CREATE VIEW wst_ranges
+AS
+  SELECT wc.id             AS wst_column_id,
+         wc.wst_id         AS wst_id,
+         Min(wcv.position) AS a,
+         Max(wcv.position) AS b
+  FROM   wst_columns wc
+         JOIN wst_column_values wcv
+           ON wc.id = wcv.wst_column_id
+  GROUP  BY wc.id,
+            wc.wst_id;