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/V20240614001_question_bank.sql | 3 +-- 1 files changed, 1 insertions(+), 2 deletions(-) diff --git a/exam-admin/src/main/resources/db/migration/V20240614001_question_bank.sql b/exam-admin/src/main/resources/db/migration/V20240614001_question_bank.sql index 85c8d88..282249a 100644 --- a/exam-admin/src/main/resources/db/migration/V20240614001_question_bank.sql +++ b/exam-admin/src/main/resources/db/migration/V20240614001_question_bank.sql @@ -1,11 +1,10 @@ -- ---------------------------- -- 题库表 -- ---------------------------- -drop table if exists `train_exam`.`ex_question_bank`; CREATE TABLE `train_exam`.`ex_question_bank` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键' , `name` varchar(50) NOT NULL COMMENT '题库名称', -`company_id` bigint NOT NULL COMMENT '公司id', +`company_id` bigint NULL COMMENT '公司id', `category_id` bigint(20) NOT NULL COMMENT '分类ID', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志(0代表存在,2代表删除,默认0)', `privatize` tinyint NOT NULL DEFAULT 0 COMMENT '课程公开私有属性(0私有,1公开 默认0)', -- Gitblit v1.9.2