ruoyi-gitlink/sql/update/20230925112258_alert_user_phonenumber_length.sql

-- 用户手机号长度限制增大为100
SET FOREIGN_KEY_CHECKS = 0;

ALTER TABLE `sys_user`
    MODIFY COLUMN `phonenumber` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手机号码';

SET FOREIGN_KEY_CHECKS = 1;