姚章浩
16 lines
408 B
SQL
16 lines
408 B
SQL
-- 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; |