From 85ae68bdbd7e373fb6f3e6f5eb04c57e3d86efd0 Mon Sep 17 00:00:00 2001
From: kongzy <kongzy>
Date: 星期三, 16 十月 2024 10:28:33 +0800
Subject: [PATCH] 补全缺失字段

---
 update.sql |   10 +++++-----
 1 files changed, 5 insertions(+), 5 deletions(-)

diff --git a/update.sql b/update.sql
index 0587aa5..1dc3ec7 100644
--- a/update.sql
+++ b/update.sql
@@ -1,15 +1,15 @@
 ALTER TABLE `swspkmas`.`th_study_auth`
 ADD COLUMN `ip` varchar(30) NULL,
-ADD COLUMN `max` varchar(40) NULL;
+ADD COLUMN `mac` varchar(40) NULL;
 
 CREATE TABLE `swspkmas`.`tr_cert`  (
 `id` bigint NOT NULL AUTO_INCREMENT,
-`uuid` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
-`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
+`uuid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
+`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
 `idcard` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
 `institution_id` bigint NOT NULL,
 `institution_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
-`batch_uuid` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
+`batch_uuid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
 `del_flag` tinyint NOT NULL DEFAULT 0,
 `train_org_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
 `cert_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
@@ -32,7 +32,7 @@
 drop table if exists `swspkmas`.`th_question_bank`;
 CREATE TABLE `swspkmas`.`th_question_bank`  (
 `id` bigint NOT NULL AUTO_INCREMENT,
-`uuid` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
+`uuid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
 `institution_id` bigint NOT NULL,
 `institution_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
 `total_count` int NOT NULL COMMENT '题库题目总数量',

--
Gitblit v1.9.2