From 4fe9eb1f4a7990c284e6383650f59d6d05cd6a5a Mon Sep 17 00:00:00 2001
From: whycrzg <ruanzhigang@whycst.com>
Date: 星期四, 11 十一月 2021 16:18:36 +0800
Subject: [PATCH] V1.92 edit at date 2021-11-11 1：新增`db_app_sys`.`tb_page_param_user` 表下字段type
---
BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java | 14 +++++++++++++-
1 files changed, 13 insertions(+), 1 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 c416402..0430df5 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
@@ -55,14 +55,26 @@
" `label` varchar(45) CHARACTER SET utf8 DEFAULT NULL," +
" `show` tinyint(4) DEFAULT NULL," +
" `user_id` int(11) DEFAULT NULL," +
+ " `type` int(11) DEFAULT NULL COMMENT '分类'," +
" PRIMARY KEY (`id`)" +
") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='页面可配置,关联用户id';";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ ResultSet res = null;
try {
if(true == recreate) {
sql.sqlMysqlExecute(sql_str01);
}
- sql.sqlMysqlExecute(sql_str02);
+ sql.sqlMysqlExecute(sql_str02);
+
+ //添加price_factor
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_app_sys'"
+ + " AND table_name='tb_page_param_user'"
+ + " AND column_name='type'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Page_Param_User_Table
+ + " ADD COLUMN `type` int(11) COMMENT '电价系数';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1