-- 000004_delivery_audit down migration -- Drop in reverse order: index first, then columns. DROP INDEX IF EXISTS idx_messages_tenant_status_updated; ALTER TABLE messages DROP COLUMN IF EXISTS failure_code; ALTER TABLE messages DROP COLUMN IF EXISTS provider_message_id; ALTER TABLE messages DROP COLUMN IF EXISTS delivery_method; ALTER TABLE messages DROP COLUMN IF EXISTS delivered_at;