microservices/sql/update/hisotry_sql/2023-07-11-001.sql

9 lines
419 B
SQL

SET FOREIGN_KEY_CHECKS = 0;
ALTER TABLE `ruoyi-gitlink`.`zone_resource`
ADD COLUMN `editor_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'markdown_editor' COMMENT '编辑器类型';
ALTER TABLE `ruoyi-gitlink`.`zone_resource`
MODIFY COLUMN `introduction` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '资源介绍';
SET FOREIGN_KEY_CHECKS = 1;