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

diff --git a/exam-admin/src/main/resources/db/migration/V20240619001_exercise_answer.sql b/exam-admin/src/main/resources/db/migration/V20240619001_exercise_answer.sql
index a790c7f..72ce674 100644
--- a/exam-admin/src/main/resources/db/migration/V20240619001_exercise_answer.sql
+++ b/exam-admin/src/main/resources/db/migration/V20240619001_exercise_answer.sql
@@ -1,7 +1,6 @@
 -- ----------------------------
 -- 学员与练习题关系表
 -- ----------------------------
-drop table if exists `train_exam`.`ex_exercise_answer`;
 CREATE TABLE `train_exam`.`ex_exercise_answer`  (
 `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键' ,
 `bank_id` bigint(20) NOT NULL COMMENT '题库id',
@@ -16,5 +15,5 @@
 `remark` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
 `version` int NULL DEFAULT 0 COMMENT '乐观锁',
 PRIMARY KEY (`id`) USING BTREE,
-UNIQUE KEY `paper_student_id` (`student_id`,`question_id`)
+UNIQUE KEY `question_student_id` (`student_id`,`question_id`)
 ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '学员与练习题关系表' ROW_FORMAT = DYNAMIC;

--
Gitblit v1.9.2