-- ============================================================
-- Patch: campos de perfil pastor en tabla users
-- Compatible con MySQL 5.7+
-- Ejecutar UNA sola vez en producción
-- ============================================================

ALTER TABLE `users`
    ADD COLUMN `titulo`        VARCHAR(100)  NULL DEFAULT NULL AFTER `role`,
    ADD COLUMN `versiculo`     TEXT          NULL DEFAULT NULL AFTER `bio`,
    ADD COLUMN `versiculo_ref` VARCHAR(100)  NULL DEFAULT NULL AFTER `versiculo`,
    ADD COLUMN `facebook`      VARCHAR(300)  NULL DEFAULT NULL AFTER `versiculo_ref`,
    ADD COLUMN `instagram`     VARCHAR(300)  NULL DEFAULT NULL AFTER `facebook`,
    ADD COLUMN `youtube`       VARCHAR(300)  NULL DEFAULT NULL AFTER `instagram`,
    ADD COLUMN `is_active`     TINYINT(1)    NOT NULL DEFAULT 1 AFTER `youtube`;