From daf9d5934903aa5b8c3d9f69398266c774b0cb30 Mon Sep 17 00:00:00 2001
From: whycrzg <ruanzhigang@whycst.com>
Date: 星期三, 08 十二月 2021 16:11:30 +0800
Subject: [PATCH] V1.96 edit at date 2021-12-8 1：修改`db_battinf`.`tb_battinf` 表下字段 更改字段old_password 为 password_default tinyint(1) DEFAULT '1'
---
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | 4 ++--
1 files changed, 2 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 fbe02e7..72682cc 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
@@ -1006,10 +1006,10 @@
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ " WHERE table_schema='db_user'"
+ " AND table_name='tb_user_inf'"
- + " AND column_name='old_password'");
+ + " AND column_name='password_default'");
if(false == res.next()) {
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
- + " ADD COLUMN `old_password` varchar(64) DEFAULT NULL COMMENT '旧的密码';");
+ + " ADD COLUMN `password_default` tinyint(1) DEFAULT '1' COMMENT '密码是否为初始化密码,1:默认,0:非默认';");
}
//添加type
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
--
Gitblit v1.9.1