From 9f19520e742ec66226466fd72116a77b81d5eb32 Mon Sep 17 00:00:00 2001
From: quling <377956897@qq.com>
Date: 星期六, 22 八月 2026 11:42:48 +0800
Subject: [PATCH] feat0806: 新增宣传知识菜单并移植项目介绍菜单

---
 tcm-training-admin-backend/sql/20260806_admin.sql |   20 +++++++++++++++++++-
 1 files changed, 19 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..660d431 100644
--- a/tcm-training-admin-backend/sql/20260806_admin.sql
+++ b/tcm-training-admin-backend/sql/20260806_admin.sql
@@ -151,4 +151,22 @@
 
 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;
\ No newline at end of file

--
Gitblit v1.7.1