Diff -- /var/www/vhosts/3dshawn.com/site1/TEMPLATES/schema_changes.html

O Operator
Diff

/var/www/vhosts/3dshawn.com/site1/TEMPLATES/schema_changes.html

added on local at 2026-07-10 22:19:13

Added
+56
lines
Removed
-0
lines
Context
0
unchanged
Blobs
from
to a557ada4dbf6
Restore this content →
Unified diff
Naive LCS-based line diff. Additions in emerald, deletions in rose. Both sides decompressed live from BLOB_STORE.
1<div class="page-head">
2 <span class="page-eyebrow"><span class="dot"></span> Monitor</span>
3 <h1 class="page-title">Schema changes</h1>
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</div>
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>
19</form>
20
21<div class="module glow-amber">
22 <div class="module-head"><div class="left">
23 <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 <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>
26 </div></div>
27 <div class="module-body tight">
28 [if:$has_rows]
29 <table class="tbl">
30 <thead><tr>
31 <th style="width:220px">Database.Table</th>
32 <th>Change</th>
33 <th style="width:110px">30-day rhythm</th>
34 <th style="width:110px">Server</th>
35 <th style="width:180px">When</th>
36 </tr></thead>
37 <tbody>
38 [loop:@rows]
39 <tr>
40 <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 <td class="mono dim" style="font-size:12px"><a href="$diff_url" style="color:inherit;text-decoration:none">$changes_preview</a></td>
42 <td>$sparkline_svg</td>
43 <td class="dim">$server_name</td>
44 <td class="mono dim">$change_datetime</td>
45 </tr>
46 [/loop]
47 </tbody>
48 </table>
49 [/if]
50 [if:!$has_rows]
51 <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>.
53 </div>
54 [/if]
55 </div>
56</div>