Fossil SCM
On the <tt>/rptsql</tt> page wrap a report's source code and the tickets schema with CODE elements having class="language-sql".
Commit
d3ca01a81e5778b1ffa5b7a850ea43e4c9daef4744b71b9d6185c9580a4f0aed
Parent
2fa43ef4fb5adaf…
1 file changed
+2
-2
+2
-2
| --- src/report.c | ||
| +++ src/report.c | ||
| @@ -352,11 +352,11 @@ | ||
| 352 | 352 | @ <td colspan="3">%h(zTitle)</td></tr> |
| 353 | 353 | @ <tr><td valign="top" align="right">Owner:</td><td></td> |
| 354 | 354 | @ <td colspan="3">%h(zOwner)</td></tr> |
| 355 | 355 | @ <tr><td valign="top" align="right">SQL:</td><td></td> |
| 356 | 356 | @ <td valign="top"><pre> |
| 357 | - @ %h(zSQL) | |
| 357 | + @ <code class="language-sql">%h(zSQL)</code> | |
| 358 | 358 | @ </pre></td> |
| 359 | 359 | @ <td width=15></td><td valign="top"> |
| 360 | 360 | output_color_key(zClrKey, 0, "border=0 cellspacing=0 cellpadding=3"); |
| 361 | 361 | @ </td> |
| 362 | 362 | @ </tr></table> |
| @@ -537,11 +537,11 @@ | ||
| 537 | 537 | zSchema = db_text(0,"SELECT sql FROM repository.sqlite_schema" |
| 538 | 538 | " WHERE name='ticket'"); |
| 539 | 539 | } |
| 540 | 540 | @ <hr /><h3>TICKET Schema</h3> |
| 541 | 541 | @ <blockquote><pre> |
| 542 | - @ %h(zSchema) | |
| 542 | + @ <code class="language-sql">%h(zSchema)</code> | |
| 543 | 543 | @ </pre></blockquote> |
| 544 | 544 | @ <h3>Notes</h3> |
| 545 | 545 | @ <ul> |
| 546 | 546 | @ <li><p>The SQL must consist of a single SELECT statement</p></li> |
| 547 | 547 | @ |
| 548 | 548 |
| --- src/report.c | |
| +++ src/report.c | |
| @@ -352,11 +352,11 @@ | |
| 352 | @ <td colspan="3">%h(zTitle)</td></tr> |
| 353 | @ <tr><td valign="top" align="right">Owner:</td><td></td> |
| 354 | @ <td colspan="3">%h(zOwner)</td></tr> |
| 355 | @ <tr><td valign="top" align="right">SQL:</td><td></td> |
| 356 | @ <td valign="top"><pre> |
| 357 | @ %h(zSQL) |
| 358 | @ </pre></td> |
| 359 | @ <td width=15></td><td valign="top"> |
| 360 | output_color_key(zClrKey, 0, "border=0 cellspacing=0 cellpadding=3"); |
| 361 | @ </td> |
| 362 | @ </tr></table> |
| @@ -537,11 +537,11 @@ | |
| 537 | zSchema = db_text(0,"SELECT sql FROM repository.sqlite_schema" |
| 538 | " WHERE name='ticket'"); |
| 539 | } |
| 540 | @ <hr /><h3>TICKET Schema</h3> |
| 541 | @ <blockquote><pre> |
| 542 | @ %h(zSchema) |
| 543 | @ </pre></blockquote> |
| 544 | @ <h3>Notes</h3> |
| 545 | @ <ul> |
| 546 | @ <li><p>The SQL must consist of a single SELECT statement</p></li> |
| 547 | @ |
| 548 |
| --- src/report.c | |
| +++ src/report.c | |
| @@ -352,11 +352,11 @@ | |
| 352 | @ <td colspan="3">%h(zTitle)</td></tr> |
| 353 | @ <tr><td valign="top" align="right">Owner:</td><td></td> |
| 354 | @ <td colspan="3">%h(zOwner)</td></tr> |
| 355 | @ <tr><td valign="top" align="right">SQL:</td><td></td> |
| 356 | @ <td valign="top"><pre> |
| 357 | @ <code class="language-sql">%h(zSQL)</code> |
| 358 | @ </pre></td> |
| 359 | @ <td width=15></td><td valign="top"> |
| 360 | output_color_key(zClrKey, 0, "border=0 cellspacing=0 cellpadding=3"); |
| 361 | @ </td> |
| 362 | @ </tr></table> |
| @@ -537,11 +537,11 @@ | |
| 537 | zSchema = db_text(0,"SELECT sql FROM repository.sqlite_schema" |
| 538 | " WHERE name='ticket'"); |
| 539 | } |
| 540 | @ <hr /><h3>TICKET Schema</h3> |
| 541 | @ <blockquote><pre> |
| 542 | @ <code class="language-sql">%h(zSchema)</code> |
| 543 | @ </pre></blockquote> |
| 544 | @ <h3>Notes</h3> |
| 545 | @ <ul> |
| 546 | @ <li><p>The SQL must consist of a single SELECT statement</p></li> |
| 547 | @ |
| 548 |