-- Migration: Add whatsapp_media_id column to conversations
-- This column stores the WhatsApp Media ID returned when uploading files
-- Date: 27 de enero de 2026

ALTER TABLE conversations
    ADD COLUMN whatsapp_media_id VARCHAR(255) NULL AFTER media_url,
    ADD INDEX idx_whatsapp_media (whatsapp_media_id);