AirTrack BugTracker V2

Goblin desk online

Ticket #5

DB migrations system — schema version tracking + startup validation

Edit Ticket
closed
task
high
-
2026-05-22T03:32:51Z
2026-05-27 14:28:54

Description

No migration system exists. Need schema version tracking, safe additive upgrades (ALTER TABLE IF NOT EXISTS pattern), and startup validation that confirms the running schema matches the expected version. Blocks safe updates to client installs.

Add Comment

Ticket Events

  • comment — Fixed alongside #4. wait-for-mariadb.sh now runs all *.sql files in /app/migrations/ in sort order after schema bootstrap. Uses migrations table to track applied migrations — skips already-applied ones. Also creates migrations table if missing (safe for installs that pre-date this system).
    2026-05-27 14:28:55
  • status_change — closed
    2026-05-27 14:28:55