From 49d3de7745d8703c00ce9c468bc5b85c418a7850 Mon Sep 17 00:00:00 2001
From: whycrzg <ruanzhigang@whycst.com>
Date: 星期二, 14 十二月 2021 10:44:16 +0800
Subject: [PATCH] V2.01 edit at date 2021-12-13 1：修改 `db_app_sys`.`tb_page_param2`表下字段 category改为categoryId
---
BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java | 11 +++++++++++
1 files changed, 11 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java b/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
index 1e797f2..fbc7330 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
@@ -117,6 +117,17 @@
+ "('account_fail_time', '账号允许连续失败次数(24小时内)', '6', '1'),"
+ "('account_lock_time', '账号锁定时间(-1为管理员解锁)', '20', '1')");
}
+
+ //修改category改为categoryId
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_app_sys'"
+ + " AND table_name='tb_page_param2'"
+ + " AND column_name='category'");
+ if(true == res.next()) {
+// System.out.println("true");
+ sql.sqlMysqlExecute("ALTER TABLE `db_app_sys`.`tb_page_param2` CHANGE `category` `categoryId` int(11) DEFAULT NULL COMMENT '分类';");
+ }else{
+ }
}
} catch (SQLException e) {
e.printStackTrace();
--
Gitblit v1.9.1