-- 007: record when an await row was created, so a timeout can report the
-- configured budget (plan §P5.4) instead of `timeout_ms: 0`.
--
-- The budget is derived as `deadline_at - created_at` at expiry — no need to
-- store the duration separately. Append-only & idempotent (ADD COLUMN IF NOT
-- EXISTS); the DEFAULT now() backfills any pre-existing rows with the
-- migration time (their derived budget is approximate, acceptable for an
-- error-detail field). New rows get it at insert via the default.
ALTER TABLE es_saga_awaits ADD COLUMN IF NOT EXISTS created_at TIMESTAMPTZ NOT NULL DEFAULT now();
