From a6fa7ee721b028f5008972f38d96dfa4c80708cf Mon Sep 17 00:00:00 2001 From: hejianhao <15708179461@qq.com> Date: 星期一, 24 八月 2026 16:33:35 +0800 Subject: [PATCH] Merge branch 'dev-0806-wql' --- tcm-training-admin-backend/sql/20260806_admin.sql | 59 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 58 insertions(+), 1 deletions(-) diff --git a/tcm-training-admin-backend/sql/20260806_admin.sql b/tcm-training-admin-backend/sql/20260806_admin.sql index 20c2baa..bf5e6a6 100644 --- a/tcm-training-admin-backend/sql/20260806_admin.sql +++ b/tcm-training-admin-backend/sql/20260806_admin.sql @@ -151,4 +151,61 @@ ALTER TABLE `tcm_health_popularization` ADD COLUMN `video_description` VARCHAR(255) DEFAULT NULL COMMENT '视频介绍' -AFTER `video_file_name`; \ No newline at end of file +AFTER `video_file_name`; + + +-- ---------------------------- +-- 新增二级菜单：宣传知识（与课程管理平级，父级为课程与学习 3000） +-- 并将「项目介绍」「项目介绍密码」菜单从课程管理(3050)迁移到宣传知识下 +-- 添加时间：2026-08-22 +-- ---------------------------- + +-- 宣传知识菜单（id: 6100） +INSERT INTO sys_menu (id, parent_id, name, menu_code, type, path, component, icon, sort, status, visible, permission_key, remark, deleted) +VALUES (6100, 3000, '宣传知识', 'live_promotion_root', 'M', '/live/promotion', NULL, NULL, 20, 1, 1, NULL, '宣传知识目录', 0) +ON DUPLICATE KEY UPDATE parent_id = VALUES(parent_id), name = VALUES(name), menu_code = VALUES(menu_code), type = VALUES(type), path = VALUES(path), component = VALUES(component), sort = VALUES(sort), status = VALUES(status), visible = VALUES(visible), permission_key = VALUES(permission_key), remark = VALUES(remark), deleted = 0; + +-- 将「项目介绍」(6010) 迁移到「宣传知识」(6100) 下，并将路由前缀改为 /live/promotion +UPDATE sys_menu SET parent_id = 6100, path = '/live/promotion/project-introduction' WHERE id = 6010; + +-- 将「项目介绍密码」(6014) 迁移到「宣传知识」(6100) 下，并将路由前缀改为 /live/promotion +UPDATE sys_menu SET parent_id = 6100, path = '/live/promotion/project-introduction-password' WHERE id = 6014; + +-- ---------------------------- +-- 「健康科普」改名为「健康知识」，并从课程管理(3050)迁移到宣传知识(6100)下 +-- 主菜单 id: 3120，子按钮 3121/3122/3123 随父级一起迁移（parent_id 不变，无需单独处理） +-- 添加时间：2026-08-22 +-- ---------------------------- +UPDATE sys_menu +SET parent_id = 6100, + name = '健康知识', + path = '/live/promotion/health-popularization', + remark = '健康知识菜单' +WHERE id = 3120; + +-- 子按钮随主菜单改名（parent_id 仍为 3120，不变） +UPDATE sys_menu SET name = '新增健康知识', remark = '健康知识新增按钮' WHERE id = 3121; +UPDATE sys_menu SET name = '编辑健康知识', remark = '健康知识编辑按钮' WHERE id = 3122; +UPDATE sys_menu SET name = '删除健康知识', remark = '健康知识删除按钮' WHERE id = 3123; + +-- ---------------------------- +-- 新增「养生科普」菜单及按钮权限（宣传知识 6100 下，与健康知识平级） +-- 养生科普与健康知识共用 tcm_health_popularization 表，contentType=2（仅视频） +-- 主菜单 id: 6110，子按钮 6111/6112/6113 +-- 添加时间：2026-08-22 +-- ---------------------------- +INSERT INTO sys_menu (id, parent_id, name, menu_code, type, path, component, icon, sort, status, visible, permission_key, remark, deleted) +VALUES (6110, 6100, '养生科普', 'live_health_promotion_manage', 'C', '/live/promotion/health-promotion', 'Live/HealthPromotionList', NULL, 51, 1, 1, 'live:health-promotion:view', '养生科普菜单', 0) +ON DUPLICATE KEY UPDATE parent_id = VALUES(parent_id), name = VALUES(name), menu_code = VALUES(menu_code), type = VALUES(type), path = VALUES(path), component = VALUES(component), sort = VALUES(sort), status = VALUES(status), visible = VALUES(visible), permission_key = VALUES(permission_key), remark = VALUES(remark), deleted = 0; + +INSERT INTO sys_menu (id, parent_id, name, menu_code, type, path, component, icon, sort, status, visible, permission_key, remark, deleted) +VALUES (6111, 6110, '新增养生科普', 'live_health_promotion_add', 'B', NULL, NULL, NULL, 1, 1, 1, 'live:health-promotion:add', '养生科普新增按钮', 0) +ON DUPLICATE KEY UPDATE parent_id = VALUES(parent_id), name = VALUES(name), menu_code = VALUES(menu_code), type = VALUES(type), sort = VALUES(sort), status = VALUES(status), visible = VALUES(visible), permission_key = VALUES(permission_key), remark = VALUES(remark), deleted = 0; + +INSERT INTO sys_menu (id, parent_id, name, menu_code, type, path, component, icon, sort, status, visible, permission_key, remark, deleted) +VALUES (6112, 6110, '编辑养生科普', 'live_health_promotion_edit', 'B', NULL, NULL, NULL, 2, 1, 1, 'live:health-promotion:edit', '养生科普编辑按钮', 0) +ON DUPLICATE KEY UPDATE parent_id = VALUES(parent_id), name = VALUES(name), menu_code = VALUES(menu_code), type = VALUES(type), sort = VALUES(sort), status = VALUES(status), visible = VALUES(visible), permission_key = VALUES(permission_key), remark = VALUES(remark), deleted = 0; + +INSERT INTO sys_menu (id, parent_id, name, menu_code, type, path, component, icon, sort, status, visible, permission_key, remark, deleted) +VALUES (6113, 6110, '删除养生科普', 'live_health_promotion_delete', 'B', NULL, NULL, NULL, 3, 1, 1, 'live:health-promotion:delete', '养生科普删除按钮', 0) +ON DUPLICATE KEY UPDATE parent_id = VALUES(parent_id), name = VALUES(name), menu_code = VALUES(menu_code), type = VALUES(type), sort = VALUES(sort), status = VALUES(status), visible = VALUES(visible), permission_key = VALUES(permission_key), remark = VALUES(remark), deleted = 0; \ No newline at end of file -- Gitblit v1.7.1