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/V20240604001_exam_record.sql |    3 +--
 1 files changed, 1 insertions(+), 2 deletions(-)

diff --git a/exam-admin/src/main/resources/db/migration/V20240604001_exam_record.sql b/exam-admin/src/main/resources/db/migration/V20240604001_exam_record.sql
index e4410e7..a3589e0 100644
--- a/exam-admin/src/main/resources/db/migration/V20240604001_exam_record.sql
+++ b/exam-admin/src/main/resources/db/migration/V20240604001_exam_record.sql
@@ -1,14 +1,13 @@
 -- ----------------------------
 -- 线下教育登记表
 -- ----------------------------
-drop table if exists `train_exam`.`ex_exam_record`;
 CREATE TABLE `train_exam`.`ex_exam_record`  (
 `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键' ,
 `company_id` bigint(20) NOT NULL COMMENT '公司id',
 `student_id` bigint(20) NOT NULL COMMENT '学员id',
 `plan_name` varchar(50) NOT NULL COMMENT '计划名称',
 `course_name` varchar(50) NOT NULL COMMENT '课程名称',
-`level` varchar(20) NOT NULL COMMENT '培训等级',
+`level` tinyint NOT NULL DEFAULT 1 COMMENT '培训等级(1公司级 2部门级 3车间级 默认1)',
 `period` int NOT NULL COMMENT '要求课时(分)',
 `actual_period` int NOT NULL COMMENT '实际课时(分)',
 `score` int NOT NULL COMMENT '考试成绩',

--
Gitblit v1.9.2