What's new
- Added a validated database CHECK constraint for
public.broadcast_outbox.status, limiting rows topending,sent, orfailed.
Security and operations
- A live preflight confirmed there are currently zero
broadcast_outboxrows and zero invalid status values. - The migration uses
NOT VALIDfollowed byVALIDATE CONSTRAINTso incompatible environments fail clearly during rollout. - This narrows a DB hardening gap where the prior live schema only guaranteed
status IS NOT NULL.