From 8c614a0f3377cb14d80c9a921bfc9182e7f79e5a Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期六, 05 三月 2022 14:49:08 +0800
Subject: [PATCH] 2.修改表 `db_user`.`tb_user_inf`表字段 'upassword' 长度 varchar(64)->varchar(200)
---
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | 5 ++++-
1 files changed, 4 insertions(+), 1 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java b/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
index b061e05..701f795 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
@@ -1054,7 +1054,10 @@
+ " AND column_name='upassword'");
if(false == res.next()) {
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
- + " ADD COLUMN `upassword` varchar(64) NOT NULL DEFAULT ''");
+ + " ADD COLUMN `upassword` varchar(200) NOT NULL DEFAULT ''");
+ }else{
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
+ + " MODIFY COLUMN `upassword` varchar(200) NOT NULL DEFAULT '';");
}
//添加公钥X
--
Gitblit v1.9.1