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

diff --git a/exam-admin/src/main/resources/db/migration/V20240531012_company_period.sql b/exam-admin/src/main/resources/db/migration/V20240531012_company_period.sql
index f941070..5d47ba5 100644
--- a/exam-admin/src/main/resources/db/migration/V20240531012_company_period.sql
+++ b/exam-admin/src/main/resources/db/migration/V20240531012_company_period.sql
@@ -1,14 +1,13 @@
 -- ----------------------------
 -- 公司课时变更记录表
 -- ----------------------------
-drop table if exists `train_exam`.`ex_company_period`;
 CREATE TABLE `train_exam`.`ex_company_period`  (
 `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键' ,
 `company_id` bigint NOT NULL COMMENT '公司id',
 `phase_id` bigint  NULL COMMENT '批次id',
 `origin` varchar(50) NOT NULL COMMENT '变动来源',
-`modify_period` int NOT NULL COMMENT '变动情况(增减课时)',
-`remain_period` int NOT NULL COMMENT '变动后剩余(分)',
+`modify_period` bigint(20) NOT NULL COMMENT '变动情况(增减课时)秒',
+`remain_period` bigint(20) 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