Mercurial > dive4elements > river
diff backend/doc/schema/postgresql.sql @ 8658:3531f0cee5e1
Whitespace-cleanup schema files.
author | "Tom Gottfried <tom@intevation.de>" |
---|---|
date | Thu, 02 Apr 2015 17:17:51 +0200 |
parents | b8c6cb36607e |
children | cfafe5764509 |
line wrap: on
line diff
--- a/backend/doc/schema/postgresql.sql Thu Apr 02 15:48:48 2015 +0200 +++ b/backend/doc/schema/postgresql.sql Thu Apr 02 17:17:51 2015 +0200 @@ -257,9 +257,9 @@ ); CREATE VIEW wst_value_table AS - SELECT + SELECT wcv.position AS position, - w, + w, q, wc.position AS column_pos, w.id AS wst_id @@ -279,9 +279,9 @@ -- 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, + 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 @@ -291,8 +291,8 @@ -- view to select the q values of a WST CREATE VIEW wst_q_values AS SELECT wc.position AS column_pos, - wqr.q AS q, - r.a AS a, + wqr.q AS q, + r.a AS a, r.b AS b, wc.wst_id AS wst_id FROM wst_column_q_ranges wcqr