/**
 * Add acknowledged_at timestamp to tuneops_tickets.
 *
 * Records when a ticket transitioned to ACKNOWLEDGED, so the TuneOps detail
 * panel can render an accurate status timeline (OPEN → ACKNOWLEDGED →
 * EXECUTING → RESOLVED). Set by db.acknowledgeTicket(). Additive + idempotent.
 */
module.exports = {
  name: 'tuneops_tickets_add_acknowledged_at',
  up: async (client) => {
    await client.query(
      `ALTER TABLE tuneops_tickets ADD COLUMN IF NOT EXISTS acknowledged_at TIMESTAMPTZ`
    );
  },
};
