forked from Gitlink/microservices
20 lines
1.7 KiB
SQL
20 lines
1.7 KiB
SQL
|
||
SET FOREIGN_KEY_CHECKS=0;
|
||
|
||
ALTER TABLE `ruoyi-gitlink`.`zone_detail` ADD COLUMN `cms_show` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '资讯板块是否展示（0:不展示，1：展示）' AFTER `first_title`;
|
||
|
||
ALTER TABLE `ruoyi-gitlink`.`zone_detail` ADD COLUMN `project_show` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '项目板块是否展示（0:不展示，1：展示）' AFTER `cms_show`;
|
||
|
||
ALTER TABLE `ruoyi-gitlink`.`zone_detail` ADD COLUMN `member_show` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '会员板块是否展示（0:不展示，1：展示）' AFTER `project_show`;
|
||
|
||
ALTER TABLE `ruoyi-gitlink`.`zone_detail` ADD COLUMN `partners_show` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '合作伙伴板块是否展示（0:不展示，1：展示）' AFTER `member_show`;
|
||
|
||
ALTER TABLE `ruoyi-gitlink`.`zone_detail` ADD COLUMN `homepage_cms_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '新闻动态' COMMENT '首页资讯标题' AFTER `partners_show`;
|
||
|
||
ALTER TABLE `ruoyi-gitlink`.`zone_detail` ADD COLUMN `homepage_project_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '精选项目' COMMENT '首页项目标题' AFTER `homepage_cms_title`;
|
||
|
||
ALTER TABLE `ruoyi-gitlink`.`zone_detail` ADD COLUMN `homepage_member_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '核心贡献者' COMMENT '首页会员标题' AFTER `homepage_project_title`;
|
||
|
||
ALTER TABLE `ruoyi-gitlink`.`zone_detail` ADD COLUMN `homepage_partners_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '合作伙伴' COMMENT '首页合作伙伴标题' AFTER `homepage_member_title`;
|
||
|
||
SET FOREIGN_KEY_CHECKS=1; |