From f0f00e9ba8a755e4317e029d73b69a92ad9f9df1 Mon Sep 17 00:00:00 2001
From: kongzy <kongzy>
Date: 星期六, 14 九月 2024 17:02:41 +0800
Subject: [PATCH] update

---
 exam-admin/src/main/resources/db/migration/V20240603001_exam_paper.sql |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/exam-admin/src/main/resources/db/migration/V20240603001_exam_paper.sql b/exam-admin/src/main/resources/db/migration/V20240603001_exam_paper.sql
index 52e4bc9..f1576e4 100644
--- a/exam-admin/src/main/resources/db/migration/V20240603001_exam_paper.sql
+++ b/exam-admin/src/main/resources/db/migration/V20240603001_exam_paper.sql
@@ -1,7 +1,6 @@
 -- ----------------------------
 -- 考卷(组卷)表
 -- ----------------------------
-drop table if exists `train_exam`.`ex_exam_paper`;
 CREATE TABLE `train_exam`.`ex_exam_paper`  (
 `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键' ,
 `code` varchar(12) NOT NULL COMMENT '编号',
@@ -10,7 +9,7 @@
 `company_id` bigint NOT NULL COMMENT '公司id',
 `category_id` bigint(20) NOT NULL COMMENT '分类ID',
 `limit_time` int NOT NULL DEFAULT 0 COMMENT '考试限制时长',
-`limit` tinyint NOT NULL DEFAULT 0 COMMENT '是否现在考试时间(0否，1是，默认0)',
+`limited` tinyint NOT NULL DEFAULT 0 COMMENT '是否现在考试时间(0否，1是，默认0)',
 `single_num` int NOT NULL DEFAULT 0 COMMENT '单选题目数量',
 `single_score` int NOT NULL DEFAULT 0 COMMENT '单选题每题分数',
 `single_bank_id` bigint(20)  NULL COMMENT '单选题题库id',
@@ -25,6 +24,7 @@
 `judge_method` tinyint NOT NULL DEFAULT 1 COMMENT '出题方式1随机，2顺序，默认1',
 `pass_score` int NOT NULL DEFAULT 0 COMMENT '合格分数',
 `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志(0代表存在，2代表删除，默认0)',
+`deadline` datetime NOT NULL  COMMENT '考试截止时间',
 `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