-- ============================================================
-- Teléfono de Meta en el canal del chatbot (MySQL)
-- scripts/chatbot/04-chatbot-channel-meta-phone.sql
--
-- Columna nueva en chatbot_channel_configuration:
--   meta_phone_number_id
--
-- Las tablas chatbot_conversation y chatbot_message no van aquí.
-- Se crean en la base MySQL separada del chatbot:
--   scripts/chatbot/mysql/01-chatbot-conversations.sql
--   scripts/chatbot/mysql/02-chatbot-handoff.sql
--
-- Equivalente a: migrations/Version20261015190000.php
--
-- Prerrequisito: chatbot_channel_configuration
-- No modifica twilio ni whatsapp_phone.
-- ============================================================

ALTER TABLE `chatbot_channel_configuration`
    ADD COLUMN `meta_phone_number_id` VARCHAR(32) DEFAULT NULL AFTER `priority`,
    ADD UNIQUE INDEX `uniq_chatbot_channel_meta_phone_number_id` (`meta_phone_number_id`);