# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1306234154 0
# Node ID 5bcf338eadb9b535f54e60fd2c449d5b99cdaa87
# Parent  677a6fceea6e7cf3119f8a7b705075927018581c
Added a new view to select ws of a WST.

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

diff -r 677a6fceea6e -r 5bcf338eadb9 flys-backend/ChangeLog
--- a/flys-backend/ChangeLog	Mon May 23 15:01:58 2011 +0000
+++ b/flys-backend/ChangeLog	Tue May 24 10:49:14 2011 +0000
@@ -1,3 +1,18 @@
+2011-05-24	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
+
+	* doc/schema/postgresql.sql: Added a new view to select ws of a WST.
+	  To update existing databases:
+
+	    CREATE VIEW wst_w_values AS
+	        SELECT wcv."position" AS km, 
+	               wcv.w          AS w,  
+	               wc."position"  AS column_pos, 
+	               w.id           AS wst_id
+	            FROM wst_column_values wcv
+	            JOIN wst_columns wc ON wcv.wst_column_id = wc.id
+	            JOIN wsts w         ON wc.wst_id = w.id
+	        ORDER BY wcv."position", wc."position";
+
 2011-05-23	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
 
 	 flys/issue76
diff -r 677a6fceea6e -r 5bcf338eadb9 flys-backend/doc/schema/postgresql.sql
--- a/flys-backend/doc/schema/postgresql.sql	Mon May 23 15:01:58 2011 +0000
+++ b/flys-backend/doc/schema/postgresql.sql	Tue May 24 10:49:14 2011 +0000
@@ -217,4 +217,15 @@
     ORDER  BY wcv.position ASC,
           wc.position DESC;
 
+-- view to select the w values of a WST
+CREATE VIEW wst_w_values AS
+    SELECT wcv."position" AS km, 
+           wcv.w          AS w,  
+           wc."position"  AS column_pos, 
+           w.id           AS wst_id
+        FROM wst_column_values wcv
+        JOIN wst_columns wc ON wcv.wst_column_id = wc.id
+        JOIN wsts w         ON wc.wst_id = w.id
+    ORDER BY wcv."position", wc."position";
+
 COMMIT;