Mercurial > dive4elements > river
changeset 6177:573112007ec7
Remove stray semicolon from sql schema.
| author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
|---|---|
| date | Tue, 04 Jun 2013 10:27:54 +0200 |
| parents | 4edad3e414cb |
| children | d0f01bc92fd0 |
| files | backend/doc/schema/oracle.sql backend/doc/schema/postgresql.sql |
| diffstat | 2 files changed, 2 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql Mon Jun 03 18:17:45 2013 +0200 +++ b/backend/doc/schema/oracle.sql Tue Jun 04 10:27:54 2013 +0200 @@ -429,7 +429,7 @@ JOIN ranges r ON wqr.range_id=r.id JOIN wst_column_values wcv - ON wcv.wst_column_id=wc.id AND wcv.position between r.a and r.b; + ON wcv.wst_column_id=wc.id AND wcv.position between r.a and r.b ORDER BY wcv.position ASC, wc.position DESC;
--- a/backend/doc/schema/postgresql.sql Mon Jun 03 18:17:45 2013 +0200 +++ b/backend/doc/schema/postgresql.sql Tue Jun 04 10:27:54 2013 +0200 @@ -259,7 +259,7 @@ JOIN ranges r ON wqr.range_id=r.id JOIN wst_column_values wcv - ON wcv.wst_column_id=wc.id AND wcv.position between r.a and r.b; + ON wcv.wst_column_id=wc.id AND wcv.position between r.a and r.b ORDER BY wcv.position ASC, wc.position DESC;