From 77643cd5f817eea5d0a73cce8e79e8c5d0da7f3e Mon Sep 17 00:00:00 2001 From: hejianhao <15708179461@qq.com> Date: 星期五, 21 八月 2026 10:35:02 +0800 Subject: [PATCH] fix0806: 修复初始化脚本 --- tcm-training-admin-backend/sql/init.sql | 30 ++++++++++++++++++++++++++++-- 1 files changed, 28 insertions(+), 2 deletions(-) diff --git a/tcm-training-admin-backend/sql/init.sql b/tcm-training-admin-backend/sql/init.sql index 6f931dd..81d8cd8 100644 --- a/tcm-training-admin-backend/sql/init.sql +++ b/tcm-training-admin-backend/sql/init.sql @@ -937,8 +937,8 @@ (103, 1, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '19:30:00'), 'https://example.com/live/recent-session-103.mp4', 3000, 10, 16, 4, 4, 40.00, 75.00, 75.00, 1, 12, 2, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '19:30:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '20:20:00'), 0), (104, 2, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '19:30:00'), 'https://example.com/live/recent-session-104.mp4', 3000, 12, 18, 5, 5, 41.67, 80.00, 80.00, 1, 14, 2, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '19:30:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '20:20:00'), 0), (105, 1, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '19:30:00'), 'https://example.com/live/recent-session-105.mp4', 3000, 12, 20, 5, 5, 41.67, 80.00, 80.00, 1, 16, 2, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '19:30:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '20:20:00'), 0), -(106, 2, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '19:30:00'), 'https://example.com/live/recent-session-106.mp4', 14, 24, 6, 6, 42.86, 83.33, 83.33, 1, 18, 2, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '19:30:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '20:20:00'), 0), -(107, 1, TIMESTAMP(CURDATE(), '19:30:00'), 'https://example.com/live/recent-session-107.mp4', 16, 28, 7, 7, 43.75, 85.71, 85.71, 1, 20, 2, TIMESTAMP(CURDATE(), '19:30:00'), TIMESTAMP(CURDATE(), '20:20:00'), 0); +(106, 2, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '19:30:00'), 'https://example.com/live/recent-session-106.mp4', 3000, 14, 24, 6, 6, 42.86, 83.33, 83.33, 1, 18, 2, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '19:30:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '20:20:00'), 0), +(107, 1, TIMESTAMP(CURDATE(), '19:30:00'), 'https://example.com/live/recent-session-107.mp4', 3000, 16, 28, 7, 7, 43.75, 85.71, 85.71, 1, 20, 2, TIMESTAMP(CURDATE(), '19:30:00'), TIMESTAMP(CURDATE(), '20:20:00'), 0); INSERT IGNORE INTO `tcm_live_session_question` (`id`, `session_id`, `sort`, `stem`, `option_a`, `option_b`, `option_c`, `correct_option`, `deleted`) @@ -1139,6 +1139,32 @@ UNIQUE KEY `uk_message_push_notice_type_code` (`notice_type_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='消息推送配置表'; +-- ---------------------------- +-- 项目介绍表 +-- ---------------------------- +CREATE TABLE IF NOT EXISTS `tcm_project_introduction` ( + `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, + `title` VARCHAR(128) NOT NULL COMMENT '标题', + `cover_img` VARCHAR(512) DEFAULT NULL COMMENT '封面图', + `category` VARCHAR(32) NOT NULL COMMENT '类别：平台介绍、营销模式、营销动作', + `content_type` TINYINT NOT NULL COMMENT '类型：1图文 2视频', + `content` MEDIUMTEXT COMMENT '图文内容（富文本HTML）', + `video_url` VARCHAR(512) DEFAULT NULL COMMENT '视频地址', + `video_file_name` VARCHAR(255) DEFAULT NULL COMMENT '视频文件名', + `click_count` INT NOT NULL DEFAULT 0 COMMENT '点击量', + `status` TINYINT NOT NULL DEFAULT 1 COMMENT '状态：1启用 0禁用', + `deleted` TINYINT(1) NOT NULL DEFAULT 0, + `created_by` VARCHAR(64) NOT NULL DEFAULT '系统' COMMENT '创建人', + `updated_by` VARCHAR(64) NOT NULL DEFAULT '系统' COMMENT '更新人', + `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, + `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + PRIMARY KEY (`id`), + KEY `idx_category` (`category`), + KEY `idx_content_type` (`content_type`), + KEY `idx_status` (`status`), + KEY `idx_created_at` (`created_at`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='项目介绍表'; + INSERT IGNORE INTO `tcm_message_push_config` (`id`, `notice_type_code`, `notice_type_name`, `push_enabled`, `sms_enabled`, `deleted`) VALUES -- Gitblit v1.7.1