Diff -- /var/www/vhosts/3dshawn.com/site1/TEMPLATES/schema_changes.html
Diff
/var/www/vhosts/3dshawn.com/site1/TEMPLATES/schema_changes.html
modified on local at 2026-07-10 23:21:59
Added
+10
lines
Removed
-15
lines
Context
41
unchanged
Blobs
from a557ada4dbf6
to e44d80f7076d
to e44d80f7076d
Unified diff
Naive LCS-based line diff. Additions in emerald, deletions in rose. Both sides decompressed live from BLOB_STORE.| 1 | 1 | <div class="page-head"> |
| 2 | 2 | <span class="page-eyebrow"><span class="dot"></span> Monitor</span> |
| 3 | 3 | <h1 class="page-title">Schema changes</h1> |
| 4 | 4 | <p class="page-subtitle">Every DDL change captured across every monitored database. Someone ALTERs a column? It shows up here whether they told you or not.</p> |
| 5 | 5 | </div> |
| 6 | 6 | |
| 7 | <form method="get" action="/schema_changes.cgi" style="display:flex;gap:10px;align-items:center;padding:12px 14px;background:var(--bg-2);border:1px solid var(--border);border-radius:12px;margin-bottom:16px"> | |
| 8 | <span class="dim mono" style="font-size:11px;letter-spacing:1.4px;text-transform:uppercase">Range</span> | |
| 9 | <select name="days" onchange="this.form.submit()"> | |
| 10 | <option value="1">Last 24h</option> | |
| 11 | <option value="7">Last 7 days</option> | |
| 12 | <option value="30" selected>Last 30 days</option> | |
| 13 | <option value="90">Last 90 days</option> | |
| 14 | <option value="365">Last year</option> | |
| 15 | </select> | |
| 16 | <input type="text" name="q" value="$q" placeholder="db or table name filter" style="flex:1"> | |
| 17 | <button type="submit" class="btn">Filter</button> | |
| 18 | <span style="margin-left:auto" class="dim">$total results</span> | |
| 7 | $picker_html | |
| 8 | ||
| 9 | <form method="get" action="/schema_changes.cgi" style="display:flex;gap:8px;align-items:center;margin-bottom:16px"> | |
| 10 | <span class="rb-label" style="font-size:11px;letter-spacing:1.4px;text-transform:uppercase;color:var(--text-muted);font-weight:700">Table filter</span> | |
| 11 | <input type="text" name="q" value="$q" placeholder="db or table name substring" style="flex:1;background:var(--bg-2);color:var(--text);border:1px solid var(--border);border-radius:8px;padding:6px 12px;font-size:12.5px;font-family:inherit"> | |
| 12 | <button type="submit" class="tr-chip is-active" style="border:none">Apply</button> | |
| 13 | [if:$q]<a class="tr-chip" href="/schema_changes.cgi">Clear</a>[/if] | |
| 19 | 14 | </form> |
| 20 | 15 | |
| 21 | 16 | <div class="module glow-amber"> |
| 22 | 17 | <div class="module-head"><div class="left"> |
| 23 | 18 | <div class="module-icon"><svg viewBox="0 0 24 24" width="14" height="14" fill="none" stroke="currentColor" stroke-width="2"><ellipse cx="12" cy="5" rx="9" ry="3"/><path d="M3 5v6c0 1.7 4 3 9 3s9-1.3 9-3V5"/></svg></div> |
| 24 | 19 | <div class="module-title">DDL diffs</div> |
| 25 | <span class="module-subtitle">Each row shows what the schema looked like before and after. Click to see the full unified diff of column adds, drops, and alters.</span> | |
| 20 | <span class="module-subtitle">Each row shows what the schema looked like before and after. Click to see the full unified diff of column adds, drops, and alters. $total match this window.</span> | |
| 26 | 21 | </div></div> |
| 27 | 22 | <div class="module-body tight"> |
| 28 | 23 | [if:$has_rows] |
| 29 | 24 | <table class="tbl"> |
| 30 | 25 | <thead><tr> |
| 31 | 26 | <th style="width:220px">Database.Table</th> |
| 32 | 27 | <th>Change</th> |
| 33 | 28 | <th style="width:110px">30-day rhythm</th> |
| 34 | 29 | <th style="width:110px">Server</th> |
| 35 | 30 | <th style="width:180px">When</th> |
| 36 | 31 | </tr></thead> |
| 37 | 32 | <tbody> |
| 38 | 33 | [loop:@rows] |
| 39 | 34 | <tr> |
| 40 | 35 | <td class="mono"><a href="$diff_url" style="color:var(--accent-hi);text-decoration:none"><strong>$database_name</strong>.<span class="dim">$table_name</span></a></td> |
| 41 | 36 | <td class="mono dim" style="font-size:12px"><a href="$diff_url" style="color:inherit;text-decoration:none">$changes_preview</a></td> |
| 42 | 37 | <td>$sparkline_svg</td> |
| 43 | 38 | <td class="dim">$server_name</td> |
| 44 | <td class="mono dim">$change_datetime</td> | |
| 39 | <td class="mono dim"><span class="ts" data-ts="$ts_epoch" data-fmt="datetime">$change_datetime</span></td> | |
| 45 | 40 | </tr> |
| 46 | 41 | [/loop] |
| 47 | 42 | </tbody> |
| 48 | 43 | </table> |
| 49 | 44 | [/if] |
| 50 | 45 | [if:!$has_rows] |
| 51 | 46 | <div style="padding:36px 14px;text-align:center;color:var(--text-dim);font-size:13.5px"> |
| 52 | No schema changes captured. Configure a database monitor in <a href="[url:databases]" style="color:var(--accent-hi)">Databases</a>. | |
| 47 | No schema changes captured in this window. Try widening the range with the chips above, or configure a database monitor in <a href="[url:databases]" style="color:var(--accent-hi)">Databases</a>. | |
| 53 | 48 | </div> |
| 54 | 49 | [/if] |
| 55 | 50 | </div> |
| 56 | 51 | </div> |