Files
Enterprise-Knowledge-Base/migrations/versioned/000064_message_audit.down.sql
2026-07-15 14:00:16 +08:00

21 lines
1.0 KiB
SQL

-- 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 $$;