microservices/sql/update/hisotry_sql/2023-06-12-002.sql

7 lines
407 B
SQL

SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE `ruoyi-gitlink`.`zone_detail` ADD COLUMN `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '特色专区标识' AFTER `id`;
ALTER TABLE `ruoyi-gitlink`.`zone_detail` MODIFY COLUMN `template` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'zone' COMMENT '专区模板';
SET FOREIGN_KEY_CHECKS=1;