bmc_hub/migrations/139_email_attachment_content_data.sql

8 lines
351 B
MySQL
Raw Permalink Normal View History

-- Migration 139: Store email attachment bytes in DB
-- Allows PDF text extraction even when file is not on disk (container restarts etc.)
ALTER TABLE email_attachments
ADD COLUMN IF NOT EXISTS content_data BYTEA;
COMMENT ON COLUMN email_attachments.content_data IS 'Raw attachment bytes stored in DB as fallback when file_path is unavailable';