# HG changeset patch # User Felix Wolfsteller # Date 1370334474 -7200 # Node ID 573112007ec7e8d5efd1cbbda0bfd6a0d4e68f1c # Parent 4edad3e414cb59932c5bf216683a75aec5f160f8 Remove stray semicolon from sql schema. diff -r 4edad3e414cb -r 573112007ec7 backend/doc/schema/oracle.sql --- 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; diff -r 4edad3e414cb -r 573112007ec7 backend/doc/schema/postgresql.sql --- 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;