From 8458e64aab474c0fc2f49ae4ff22fb11ce5cf6e2 Mon Sep 17 00:00:00 2001 From: “djh” <“3298565835@qq.com”> Date: 星期一, 11 十一月 2024 16:55:28 +0800 Subject: [PATCH] 批次新增学员查询条件，新增题目导入接口 --- exam-admin/src/main/resources/db/migration/V20240531010_student_study.sql | 2 -- 1 files changed, 0 insertions(+), 2 deletions(-) diff --git a/exam-admin/src/main/resources/db/migration/V20240531010_student_study.sql b/exam-admin/src/main/resources/db/migration/V20240531010_student_study.sql index 5dec065..8e8f1c3 100644 --- a/exam-admin/src/main/resources/db/migration/V20240531010_student_study.sql +++ b/exam-admin/src/main/resources/db/migration/V20240531010_student_study.sql @@ -1,7 +1,6 @@ -- ---------------------------- -- 课程学习学习日志表 -- ---------------------------- -drop table if exists `train_exam`.`ex_student_study`; CREATE TABLE `train_exam`.`ex_student_study` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键' , `phase_id` bigint(20) NOT NULL COMMENT '课时批次id', @@ -12,7 +11,6 @@ `current_duration` bigint(20) NOT NULL DEFAULT 0 COMMENT '当前学习时长，单位秒', `current_page` int NOT NULL DEFAULT 0 COMMENT '当前学习页数，单位页', `progress` decimal(5, 2) NOT NULL DEFAULT 0 COMMENT '进度(百分比)', -`resource_type` varchar(10) NOT NULL COMMENT '资源类型(PPT,MP4,PDF)', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `create_by` varchar(50) NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', -- Gitblit v1.9.2