mysql字段修改脚本
-- help_text:帮助说明
-- help_content
-- raw
USE pro_seal_chip_sell_portal_v1;
-- 表修改
ALTER TABLE `help_text` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_general_ci;
-- 字段修改
-- ALTER TABLE `user` MODIFY COLUMN `username` VARCHAR(105) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT "默认" COMMENT '默认';
-- ALTER TABLE `user` MODIFY COLUMN `dtime` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '默认时间';
-- ALTER TABLE `user` ADD INDEX index_u_name (`username`) COMMENT '创建index_u_name索引';
ALTER TABLE `help_text` MODIFY COLUMN `help_content` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `help_text` MODIFY COLUMN `raw` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;