| | |
| | | -- 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`; |
| | | |