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

13 lines
655 B
SQL

SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE `ruoyi-gitlink`.`zone_detail` ADD COLUMN `sort` int(4) NULL DEFAULT 1 COMMENT '排序' AFTER `template`;
ALTER TABLE `ruoyi-gitlink`.`zone_member` ADD COLUMN `sort` int(4) NULL DEFAULT 1 COMMENT '排序' AFTER `is_homepage`;
ALTER TABLE `ruoyi-gitlink`.`zone_member_type` ADD COLUMN `sort` int(4) NULL DEFAULT 1 COMMENT '排序' AFTER `zone_id`;
ALTER TABLE `ruoyi-gitlink`.`zone_project` ADD COLUMN `sort` int(4) NULL DEFAULT 1 COMMENT '排序' AFTER `is_homepage`;
ALTER TABLE `ruoyi-gitlink`.`zone_project_type` ADD COLUMN `sort` int(4) NULL DEFAULT 1 COMMENT '排序' AFTER `name`;
SET FOREIGN_KEY_CHECKS=1;