1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
| -- 最近一周内容统计 mock 数据（相对执行当天最近 7 天）
| -- 用途：给「统计-内容数据」页面提供最近 7 天的播放、收藏、咨询、积分趋势数据
| -- 说明：
| -- 1. 本脚本仅包含插入数据，不重复建表
| -- 2. 执行前请确认以下表已存在：
| -- tcm_live_session
| -- tcm_live_session_question
| -- tcm_live_watch_record
| -- tcm_health_course_play_record
| -- tcm_health_course_favorite_record
| -- tcm_content_consult_click_record
| -- tcm_live_session_quiz_record
| -- 3. 脚本使用 CURDATE()，可在任意日期执行并自动生成“最近 7 天”数据
|
| INSERT IGNORE INTO `tcm_live_session`
| (`id`, `live_course_id`, `start_time`, `video_url`, `base_reserve_count`, `base_watch_count`, `real_reserve_count`, `real_watch_count`,
| `reserve_convert_rate`, `completion_rate`, `effective_watch_rate`, `quiz_correct_count`, `points_issued`, `live_status`,
| `actual_start_time`, `actual_end_time`, `deleted`)
| VALUES
| (101, 1, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 6 DAY), '19:30:00'), 'https://example.com/live/recent-session-101.mp4', 8, 12, 3, 3, 37.50, 66.67, 66.67, 1, 8, 2, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 6 DAY), '19:30:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 6 DAY), '20:20:00'), 0),
| (102, 2, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '19:30:00'), 'https://example.com/live/recent-session-102.mp4', 9, 14, 4, 4, 44.44, 75.00, 75.00, 1, 10, 2, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '19:30:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '20:20:00'), 0),
| (103, 1, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '19:30:00'), 'https://example.com/live/recent-session-103.mp4', 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', 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', 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);
|
| INSERT IGNORE INTO `tcm_live_session_question`
| (`id`, `session_id`, `sort`, `stem`, `option_a`, `option_b`, `option_c`, `correct_option`, `deleted`)
| VALUES
| (1001, 101, 1, '直播课程101演示题目', '选项A', '选项B', '选项C', 'A', 0),
| (1002, 102, 1, '直播课程102演示题目', '选项A', '选项B', '选项C', 'A', 0),
| (1003, 103, 1, '直播课程103演示题目', '选项A', '选项B', '选项C', 'A', 0),
| (1004, 104, 1, '直播课程104演示题目', '选项A', '选项B', '选项C', 'A', 0),
| (1005, 105, 1, '直播课程105演示题目', '选项A', '选项B', '选项C', 'A', 0),
| (1006, 106, 1, '直播课程106演示题目', '选项A', '选项B', '选项C', 'A', 0),
| (1007, 107, 1, '直播课程107演示题目', '选项A', '选项B', '选项C', 'A', 0);
|
| INSERT IGNORE INTO `tcm_live_watch_record`
| (`id`, `live_course_id`, `session_id`, `app_user_id`, `watch_start`, `watch_end`, `duration_seconds`, `is_completed`, `is_effective`)
| VALUES
| (5001, 1, 101, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 6 DAY), '19:35:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 6 DAY), '19:55:00'), 1200, 1, 1),
| (5002, 1, 101, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 6 DAY), '20:00:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 6 DAY), '20:08:00'), 480, 0, 1),
| (5003, 1, 101, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 6 DAY), '20:12:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 6 DAY), '20:18:00'), 360, 0, 1),
| (5004, 2, 102, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '19:34:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '19:58:00'), 1440, 1, 1),
| (5005, 2, 102, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '20:02:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '20:10:00'), 480, 0, 1),
| (5006, 2, 102, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '20:11:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '20:18:00'), 420, 0, 1),
| (5007, 2, 102, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '20:19:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '20:25:00'), 360, 0, 1),
| (5008, 1, 103, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '19:33:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '19:56:00'), 1380, 1, 1),
| (5009, 1, 103, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '19:58:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '20:06:00'), 480, 0, 1),
| (5010, 1, 103, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '20:08:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '20:16:00'), 480, 0, 1),
| (5011, 1, 103, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '20:18:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '20:24:00'), 360, 0, 1),
| (5012, 2, 104, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '19:32:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '19:58:00'), 1560, 1, 1),
| (5013, 2, 104, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '20:00:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '20:07:00'), 420, 0, 1),
| (5014, 2, 104, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '20:08:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '20:14:00'), 360, 0, 1),
| (5015, 2, 104, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '20:15:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '20:21:00'), 360, 0, 1),
| (5016, 2, 104, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '20:22:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '20:28:00'), 360, 0, 1),
| (5017, 1, 105, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '19:31:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '19:58:00'), 1620, 1, 1),
| (5018, 1, 105, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '20:00:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '20:08:00'), 480, 0, 1),
| (5019, 1, 105, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '20:09:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '20:15:00'), 360, 0, 1),
| (5020, 1, 105, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '20:16:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '20:22:00'), 360, 0, 1),
| (5021, 1, 105, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '20:23:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '20:29:00'), 360, 0, 1),
| (5022, 2, 106, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '19:30:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '19:59:00'), 1740, 1, 1),
| (5023, 2, 106, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '20:00:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '20:07:00'), 420, 0, 1),
| (5024, 2, 106, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '20:08:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '20:15:00'), 420, 0, 1),
| (5025, 2, 106, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '20:16:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '20:22:00'), 360, 0, 1),
| (5026, 2, 106, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '20:23:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '20:29:00'), 360, 0, 1),
| (5027, 2, 106, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '20:30:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '20:36:00'), 360, 0, 1),
| (5028, 1, 107, 200, TIMESTAMP(CURDATE(), '19:30:00'), TIMESTAMP(CURDATE(), '20:00:00'), 1800, 1, 1),
| (5029, 1, 107, 200, TIMESTAMP(CURDATE(), '20:02:00'), TIMESTAMP(CURDATE(), '20:10:00'), 480, 0, 1),
| (5030, 1, 107, 200, TIMESTAMP(CURDATE(), '20:11:00'), TIMESTAMP(CURDATE(), '20:18:00'), 420, 0, 1),
| (5031, 1, 107, 200, TIMESTAMP(CURDATE(), '20:19:00'), TIMESTAMP(CURDATE(), '20:25:00'), 360, 0, 1),
| (5032, 1, 107, 200, TIMESTAMP(CURDATE(), '20:26:00'), TIMESTAMP(CURDATE(), '20:32:00'), 360, 0, 1),
| (5033, 1, 107, 200, TIMESTAMP(CURDATE(), '20:33:00'), TIMESTAMP(CURDATE(), '20:39:00'), 360, 0, 1),
| (5034, 1, 107, 200, TIMESTAMP(CURDATE(), '20:40:00'), TIMESTAMP(CURDATE(), '20:46:00'), 360, 0, 1);
|
| INSERT IGNORE INTO `tcm_health_course_play_record`
| (`id`, `course_id`, `video_id`, `app_user_id`, `play_start`, `play_end`, `duration_seconds`, `is_completed`)
| VALUES
| (5101, 1, 1, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 6 DAY), '10:00:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 6 DAY), '10:18:00'), 1080, 1),
| (5102, 1, 2, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 6 DAY), '15:10:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 6 DAY), '15:18:00'), 480, 0),
| (5103, 1, 1, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '10:02:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '10:20:00'), 1080, 1),
| (5104, 1, 3, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '14:30:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '14:38:00'), 480, 0),
| (5105, 1, 1, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '09:55:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '10:13:00'), 1080, 1),
| (5106, 1, 2, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '13:20:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '13:28:00'), 480, 0),
| (5107, 1, 3, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '19:10:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '19:18:00'), 480, 0),
| (5108, 1, 1, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '10:05:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '10:23:00'), 1080, 1),
| (5109, 1, 2, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '12:40:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '12:48:00'), 480, 0),
| (5110, 1, 3, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '18:25:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '18:33:00'), 480, 0),
| (5111, 1, 1, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '10:08:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '10:26:00'), 1080, 1),
| (5112, 1, 2, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '13:10:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '13:18:00'), 480, 0),
| (5113, 1, 3, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '18:00:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '18:08:00'), 480, 0),
| (5114, 1, 1, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '20:10:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '20:18:00'), 480, 0),
| (5115, 1, 1, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '09:58:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '10:16:00'), 1080, 1),
| (5116, 1, 2, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '12:20:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '12:28:00'), 480, 0),
| (5117, 1, 3, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '17:42:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '17:50:00'), 480, 0),
| (5118, 1, 2, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '21:00:00'), TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '21:08:00'), 480, 0),
| (5119, 1, 1, 200, TIMESTAMP(CURDATE(), '09:50:00'), TIMESTAMP(CURDATE(), '10:08:00'), 1080, 1),
| (5120, 1, 2, 200, TIMESTAMP(CURDATE(), '12:15:00'), TIMESTAMP(CURDATE(), '12:23:00'), 480, 0),
| (5121, 1, 3, 200, TIMESTAMP(CURDATE(), '15:30:00'), TIMESTAMP(CURDATE(), '15:38:00'), 480, 0),
| (5122, 1, 1, 200, TIMESTAMP(CURDATE(), '18:20:00'), TIMESTAMP(CURDATE(), '18:28:00'), 480, 0),
| (5123, 1, 2, 200, TIMESTAMP(CURDATE(), '21:10:00'), TIMESTAMP(CURDATE(), '21:18:00'), 480, 0);
|
| INSERT IGNORE INTO `tcm_health_course_favorite_record`
| (`id`, `course_id`, `app_user_id`, `action_type`, `action_time`)
| VALUES
| (5201, 1, 200, 'FAVORITE', TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 6 DAY), '11:20:00')),
| (5202, 1, 200, 'FAVORITE', TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '10:50:00')),
| (5203, 1, 200, 'FAVORITE', TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '19:20:00')),
| (5204, 1, 200, 'FAVORITE', TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '09:40:00')),
| (5205, 1, 200, 'FAVORITE', TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '17:10:00')),
| (5206, 1, 200, 'FAVORITE', TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '11:30:00')),
| (5207, 1, 200, 'FAVORITE', TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '15:20:00')),
| (5208, 1, 200, 'FAVORITE', TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '21:10:00')),
| (5209, 1, 200, 'FAVORITE', TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '10:35:00')),
| (5210, 1, 200, 'FAVORITE', TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '14:10:00')),
| (5211, 1, 200, 'FAVORITE', TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '20:40:00')),
| (5212, 1, 200, 'FAVORITE', TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '09:25:00')),
| (5213, 1, 200, 'FAVORITE', TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '13:18:00')),
| (5214, 1, 200, 'FAVORITE', TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '18:45:00')),
| (5215, 1, 200, 'FAVORITE', TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '22:00:00')),
| (5216, 1, 200, 'FAVORITE', TIMESTAMP(CURDATE(), '10:10:00')),
| (5217, 1, 200, 'FAVORITE', TIMESTAMP(CURDATE(), '13:00:00')),
| (5218, 1, 200, 'FAVORITE', TIMESTAMP(CURDATE(), '16:40:00')),
| (5219, 1, 200, 'FAVORITE', TIMESTAMP(CURDATE(), '20:05:00'));
|
| INSERT IGNORE INTO `tcm_content_consult_click_record`
| (`id`, `content_type`, `content_id`, `app_user_id`, `clicked_at`)
| VALUES
| (5301, 'HEALTH_COURSE', 1, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 6 DAY), '11:25:00')),
| (5302, 'LIVE', 2, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '20:26:00')),
| (5303, 'LIVE', 1, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '10:06:00')),
| (5304, 'HEALTH_COURSE', 1, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '15:48:00')),
| (5305, 'LIVE', 2, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '11:36:00')),
| (5306, 'HEALTH_COURSE', 1, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '21:15:00')),
| (5307, 'LIVE', 1, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '10:40:00')),
| (5308, 'HEALTH_COURSE', 1, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '14:15:00')),
| (5309, 'LIVE', 2, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '20:44:00')),
| (5310, 'LIVE', 2, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '09:28:00')),
| (5311, 'HEALTH_COURSE', 1, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '13:22:00')),
| (5312, 'LIVE', 1, 200, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '18:50:00')),
| (5313, 'LIVE', 1, 200, TIMESTAMP(CURDATE(), '10:15:00')),
| (5314, 'HEALTH_COURSE', 1, 200, TIMESTAMP(CURDATE(), '13:05:00')),
| (5315, 'LIVE', 2, 200, TIMESTAMP(CURDATE(), '16:45:00')),
| (5316, 'HEALTH_COURSE', 1, 200, TIMESTAMP(CURDATE(), '20:12:00'));
|
| INSERT IGNORE INTO `tcm_live_session_quiz_record`
| (`id`, `session_id`, `app_user_id`, `question_id`, `chosen_option`, `is_correct`, `points_earned`, `answered_at`)
| VALUES
| (5401, 101, 200, 1001, 'A', 1, 8, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 6 DAY), '20:05:00')),
| (5402, 102, 200, 1002, 'A', 1, 10, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 DAY), '20:08:00')),
| (5403, 103, 200, 1003, 'A', 1, 12, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 4 DAY), '20:10:00')),
| (5404, 104, 200, 1004, 'A', 1, 14, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 3 DAY), '20:12:00')),
| (5405, 105, 200, 1005, 'A', 1, 16, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 2 DAY), '20:15:00')),
| (5406, 106, 200, 1006, 'A', 1, 18, TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 DAY), '20:18:00')),
| (5407, 107, 200, 1007, 'A', 1, 20, TIMESTAMP(CURDATE(), '20:20:00'));
|
|
