From 6a598cfca96b698d7018789fa1837d24818f8de5 Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期一, 28 十月 2024 10:13:06 +0800
Subject: [PATCH] V2.07 edit at date 2024-10-28 1.表'db_app_sys.tb_page_param'表中默认新增用户密码时效配置，默认插入值'-1'-永不失效 INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('57', '用户密码时效', '-1', '15',''); 2.表'db_user.tb_user_inf'更新字段'password_update_time'中密码为'Null'的记录为当前时间 UPDATE db_user.tb_user_inf SET password_update_time = NOW() WHERE password_update_time IS NULL;
---
BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java b/BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java
index 0050f86..4c2569a 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/SqlsUtils.java
@@ -48,7 +48,7 @@
static {
- Integer[] temp= {1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,47,48,49,50,51,52,53,54,55,56};
+ Integer[] temp= {1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,47,48,49,50,51,52,53,54,55,56,57};
idsDefault = Arrays.asList(temp);
Integer[] temp2= {1,2,3,4,5};
@@ -115,6 +115,7 @@
"INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('54', '核容充电时间过滤', '2', '14','');" +
"INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('55', '监测放电时间过滤', '2', '14','');" +
"INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('56', '监测充电时间过滤', '2', '14','');" +
+ "INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('57', '用户密码时效', '-1', '15','');" +
"";
String[] strs = tb_page_param.split(";");
for (int i = 0; i < strs.length; i++) {
--
Gitblit v1.9.1