From b56c3c0f1bc87935a8b59f6ee39f78b4796250ff Mon Sep 17 00:00:00 2001
From: “djh” <“3298565835@qq.com”>
Date: 星期三, 06 十一月 2024 15:01:02 +0800
Subject: [PATCH] 修改前台页面对应的后台效果，新增学习记录的自然时间差

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

diff --git a/update.sql b/update.sql
index 9f3584e..f86715e 100644
--- a/update.sql
+++ b/update.sql
@@ -1,8 +1,8 @@
 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`  (
+CREATE TABLE `swspkmas`.`th_cert`  (
 `id` bigint NOT NULL AUTO_INCREMENT,
 `uuid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
 `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
@@ -33,6 +33,7 @@
 CREATE TABLE `swspkmas`.`th_question_bank`  (
 `id` bigint NOT NULL AUTO_INCREMENT,
 `uuid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
+`name` 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