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/V20240531002_company.sql | 6 ++---- 1 files changed, 2 insertions(+), 4 deletions(-) diff --git a/exam-admin/src/main/resources/db/migration/V20240531002_company.sql b/exam-admin/src/main/resources/db/migration/V20240531002_company.sql index b9b3ec6..6e5c414 100644 --- a/exam-admin/src/main/resources/db/migration/V20240531002_company.sql +++ b/exam-admin/src/main/resources/db/migration/V20240531002_company.sql @@ -2,16 +2,14 @@ -- ---------------------------- -- 企业表 -- ---------------------------- -drop table if exists `train_exam`.`sys_company`; CREATE TABLE `train_exam`.`sys_company` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(80) NOT NULL COMMENT '企业名称', `credit_code` varchar(30) NOT NULL COMMENT '企业信用代码', `major` varchar(30) NOT NULL COMMENT '负责人', `phone` varchar(11) NOT NULL COMMENT '联系电话', -`remain_period` int NOT NULL DEFAULT 0 COMMENT '剩余课时(分)', -`spend_period` int NOT NULL DEFAULT 0 COMMENT '已用课时(分)', -`total_period` int NOT NULL DEFAULT 0 COMMENT '总课时(分)', +`remain_period` bigint(20) NOT NULL DEFAULT 0 COMMENT '剩余课时(秒)', +`total_period` bigint(20) NOT NULL DEFAULT 0 COMMENT '总课时(秒)', `del_flag` tinyint NOT NULL DEFAULT 0 COMMENT '删除标志(0为删除，1删除，默认0)', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人', -- Gitblit v1.9.2