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/V20240531004_category.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/exam-admin/src/main/resources/db/migration/V20240531004_category.sql b/exam-admin/src/main/resources/db/migration/V20240531004_category.sql index d68395a..a41751c 100644 --- a/exam-admin/src/main/resources/db/migration/V20240531004_category.sql +++ b/exam-admin/src/main/resources/db/migration/V20240531004_category.sql @@ -2,12 +2,12 @@ -- ---------------------------- -- 课程分类表 -- ---------------------------- -drop table if exists `train_exam`.`sys_category`; CREATE TABLE `train_exam`.`sys_category` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键' , `parent_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '父分类id', `name` varchar(30) NOT NULL COMMENT '分类名称', `category_type` tinyint NOT NULL DEFAULT 1 COMMENT '类型(1课程，2资源)', +`del_flag` tinyint NOT NULL DEFAULT 0 COMMENT '删除标志(0为删除，1删除，默认0)', `status` tinyint NOT NULL DEFAULT 0 COMMENT '账号状态(0正常，1停用，默认0)', `sort` int UNSIGNED NOT NULL DEFAULT 1 COMMENT '排序', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', -- Gitblit v1.9.2