Mercurial > dive4elements > river
comparison backend/doc/schema/oracle.sql @ 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 | 6cdb3ee687a9 |
| children | 0711ce5ca701 |
comparison
equal
deleted
inserted
replaced
| 6176:4edad3e414cb | 6177:573112007ec7 |
|---|---|
| 427 JOIN wst_q_ranges wqr | 427 JOIN wst_q_ranges wqr |
| 428 ON wcqr.wst_q_range_id=wqr.id | 428 ON wcqr.wst_q_range_id=wqr.id |
| 429 JOIN ranges r | 429 JOIN ranges r |
| 430 ON wqr.range_id=r.id | 430 ON wqr.range_id=r.id |
| 431 JOIN wst_column_values wcv | 431 JOIN wst_column_values wcv |
| 432 ON wcv.wst_column_id=wc.id AND wcv.position between r.a and r.b; | 432 ON wcv.wst_column_id=wc.id AND wcv.position between r.a and r.b |
| 433 ORDER BY wcv.position ASC, | 433 ORDER BY wcv.position ASC, |
| 434 wc.position DESC; | 434 wc.position DESC; |
| 435 | 435 |
| 436 -- view to select the w values of a WST | 436 -- view to select the w values of a WST |
| 437 CREATE VIEW wst_w_values AS | 437 CREATE VIEW wst_w_values AS |