-- Migration: 000064_message_audit (rollback) DO $$ BEGIN RAISE NOTICE '[Migration 000064 rollback] Removing message audit metadata'; END $$; DROP INDEX IF EXISTS idx_messages_source_user; DROP INDEX IF EXISTS idx_messages_source_delivery; DROP INDEX IF EXISTS idx_messages_source_message; DROP INDEX IF EXISTS idx_messages_source_channel; DROP INDEX IF EXISTS idx_messages_request_role; ALTER TABLE messages DROP COLUMN IF EXISTS token_usage; ALTER TABLE messages DROP COLUMN IF EXISTS searched_knowledge_base_ids; ALTER TABLE messages DROP COLUMN IF EXISTS source_thread_id; ALTER TABLE messages DROP COLUMN IF EXISTS source_chat_id; ALTER TABLE messages DROP COLUMN IF EXISTS source_user_id; ALTER TABLE messages DROP COLUMN IF EXISTS source_delivery_id; ALTER TABLE messages DROP COLUMN IF EXISTS source_message_id; ALTER TABLE messages DROP COLUMN IF EXISTS source_channel_id; ALTER TABLE messages DROP COLUMN IF EXISTS source_platform; DO $$ BEGIN RAISE NOTICE '[Migration 000064 rollback] Message audit metadata removed'; END $$;