From 861ee7cdacd5527b82f06fe9ddb34848df089200 Mon Sep 17 00:00:00 2001 From: hejianhao <15708179461@qq.com> Date: 星期三, 19 八月 2026 16:09:39 +0800 Subject: [PATCH] feat0806: 管理后台设置微赞直播间密码 --- tcm-training-admin-backend/sql/20260806_admin.sql | 14 ++++++++++++++ 1 files changed, 14 insertions(+), 0 deletions(-) diff --git a/tcm-training-admin-backend/sql/20260806_admin.sql b/tcm-training-admin-backend/sql/20260806_admin.sql index 9e15f81..44219cd 100644 --- a/tcm-training-admin-backend/sql/20260806_admin.sql +++ b/tcm-training-admin-backend/sql/20260806_admin.sql @@ -60,3 +60,17 @@ INSERT INTO sys_menu (id, parent_id, name, menu_code, type, sort, status, visible, permission_key, remark, deleted) VALUES (5045, 2118, '编辑', 'member_clinic_edit', 'B', 1, 1, 1, 'member:clinic:edit', '编辑诊所按钮', 0) ON DUPLICATE KEY UPDATE permission_key = VALUES(permission_key), deleted = 0; + +-- 微赞直播间单例设置：仅保留 Banner 图片地址和直播间地址两个业务字段 +CREATE TABLE IF NOT EXISTS tcm_live_room_setting ( + banner_image_url VARCHAR(500) NOT NULL COMMENT 'Banner图片地址', + live_room_url VARCHAR(500) NULL COMMENT '直播间地址' +) COMMENT='微赞直播间设置'; + +INSERT INTO sys_menu (id, parent_id, name, menu_code, type, path, component, icon, sort, status, visible, permission_key, remark, deleted) +VALUES (6000, 3050, '微赞直播间设置', 'live_room_setting', 'C', '/live/course/live-room-setting', 'Live/LiveRoomSetting', NULL, 18, 1, 1, 'live:room-setting: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 (6001, 6000, '编辑微赞直播间设置', 'live_room_setting_edit', 'B', NULL, NULL, NULL, 1, 1, 1, 'live:room-setting: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; \ No newline at end of file -- Gitblit v1.7.1