21 lines
1.0 KiB
SQL
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 $$;
|