From 11426142f045800073fcc162becfe619abf0fde5 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期一, 13 六月 2022 09:12:15 +0800
Subject: [PATCH] V1.30 edit at date 2022-06-13 1.修复新老平台升级时账号密码长度不够bug
---
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | 22 ++++++++++++++++++++--
1 files changed, 20 insertions(+), 2 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 eb0d371..8c60812 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
@@ -1233,8 +1233,8 @@
* 创建线程手动启动工具表
*/
public static void createTb_user_infTable(MysqlConnPool pool, boolean recreate) {
- String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.TB_UserInf;
- String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.TB_UserInf + " (" +
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.UserInfTable;
+ String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.UserInfTable + " (" +
" `uId` bigint(20) NOT NULL AUTO_INCREMENT," +
" `uSnId` varchar(50) NOT NULL DEFAULT '123456'," +
" `uName` varchar(50) NOT NULL DEFAULT ' '," +
@@ -1355,6 +1355,24 @@
}
+ //修改usnid的长度
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_user'"
+ + " AND table_name='tb_user_inf'"
+ + " AND column_name='uSnId'");
+ if(res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
+ + " CHANGE COLUMN `uSnId` `uSnId` VARCHAR(200) NOT NULL DEFAULT '123456';");
+ }
+ //修改password的长度
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_user'"
+ + " AND table_name='tb_user_inf'"
+ + " AND column_name='upassword'");
+ if(res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
+ + " CHANGE COLUMN `upassword` `upassword` VARCHAR(200) NOT NULL DEFAULT '';");
+ }
//添加type
--
Gitblit v1.9.1