-- For installations where the notification-template columns already exist.
-- Preserves saved content; question marks from earlier lossy writes are not recoverable.
SET NAMES utf8mb4;
ALTER TABLE config_tb
    MODIFY COLUMN zalo_tpl_tuition_body TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    MODIFY COLUMN email_tpl_receipt_subject VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    MODIFY COLUMN email_tpl_receipt_body TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL;