From 8e2c06d3cf82be192505a02af654cdde9d4723a5 Mon Sep 17 00:00:00 2001 From: hejianhao <15708179461@qq.com> Date: 星期四, 20 八月 2026 13:06:29 +0800 Subject: [PATCH] feat0806: 项目介绍密码功能 --- tcm-training-admin-backend/sql/20260806_admin.sql | 22 ++++++++++++++++++++++ 1 files changed, 22 insertions(+), 0 deletions(-) diff --git a/tcm-training-admin-backend/sql/20260806_admin.sql b/tcm-training-admin-backend/sql/20260806_admin.sql index 58df591..c0e0256 100644 --- a/tcm-training-admin-backend/sql/20260806_admin.sql +++ b/tcm-training-admin-backend/sql/20260806_admin.sql @@ -124,3 +124,25 @@ KEY `idx_status` (`status`), KEY `idx_created_at` (`created_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='项目介绍表'; + +-- ---------------------------- +-- 项目介绍密码配置表 +-- ---------------------------- +CREATE TABLE IF NOT EXISTS `tcm_project_introduction_password` ( + `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, + `password_enabled` TINYINT NOT NULL DEFAULT 0 COMMENT '是否启用密码访问：1启用 0不启用', + `password` VARCHAR(255) DEFAULT NULL COMMENT '访问密码（加密）', + `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, + `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='项目介绍密码配置表'; + +-- 项目介绍密码菜单（id: 6014） +INSERT INTO sys_menu (id, parent_id, name, menu_code, type, path, component, icon, sort, status, visible, permission_key, remark, deleted) +VALUES (6014, 3050, '项目介绍密码', 'live_project_introduction_password', 'C', '/live/course/project-introduction-password', 'Live/ProjectIntroductionPassword', NULL, 61, 1, 1, 'live:project-introduction-password: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; + +-- 编辑项目介绍密码按钮（id: 6015） +INSERT INTO sys_menu (id, parent_id, name, menu_code, type, path, component, icon, sort, status, visible, permission_key, remark, deleted) +VALUES (6015, 6014, '编辑项目介绍密码', 'live_project_introduction_password_edit', 'B', NULL, NULL, NULL, 1, 1, 1, 'live:project-introduction-password: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; -- Gitblit v1.7.1