From c04815b9c122f1f8ce0aa91c59be67445a0f9988 Mon Sep 17 00:00:00 2001
From: hejianhao <15708179461@qq.com>
Date: 星期一, 24 八月 2026 16:21:25 +0800
Subject: [PATCH] fix0806: 生产上线配置

---
 tcm-training-admin-backend/sql/20260806_prd.sql |   21 +++++++++++++++++++++
 1 files changed, 21 insertions(+), 0 deletions(-)

diff --git a/tcm-training-admin-backend/sql/20260806_prd.sql b/tcm-training-admin-backend/sql/20260806_prd.sql
index cf9c75e..1b232a2 100644
--- a/tcm-training-admin-backend/sql/20260806_prd.sql
+++ b/tcm-training-admin-backend/sql/20260806_prd.sql
@@ -1,3 +1,24 @@
+-- 2026-08-06 变更前数据备份
+DROP TABLE IF EXISTS `tcm_live_course_2026_0806_back`;
+CREATE TABLE `tcm_live_course_2026_0806_back` LIKE `tcm_live_course`;
+INSERT INTO `tcm_live_course_2026_0806_back` SELECT * FROM `tcm_live_course`;
+
+DROP TABLE IF EXISTS `tcm_clinic_2026_0806_back`;
+CREATE TABLE `tcm_clinic_2026_0806_back` LIKE `tcm_clinic`;
+INSERT INTO `tcm_clinic_2026_0806_back` SELECT * FROM `tcm_clinic`;
+
+DROP TABLE IF EXISTS `tcm_health_popularization_2026_0806_back`;
+CREATE TABLE `tcm_health_popularization_2026_0806_back` LIKE `tcm_health_popularization`;
+INSERT INTO `tcm_health_popularization_2026_0806_back` SELECT * FROM `tcm_health_popularization`;
+
+DROP TABLE IF EXISTS `sys_menu_2026_0806_back`;
+CREATE TABLE `sys_menu_2026_0806_back` LIKE `sys_menu`;
+INSERT INTO `sys_menu_2026_0806_back` SELECT * FROM `sys_menu`;
+
+DROP TABLE IF EXISTS `sys_role_menu_2026_0806_back`;
+CREATE TABLE `sys_role_menu_2026_0806_back` LIKE `sys_role_menu`;
+INSERT INTO `sys_role_menu_2026_0806_back` SELECT * FROM `sys_role_menu`;
+
 ALTER TABLE tcm_live_course
 ADD COLUMN `password` VARCHAR(255) DEFAULT NULL COMMENT '直播间密码' AFTER `status`;
 

--
Gitblit v1.7.1