From 130b35b91680a88b950607268a550f9cda822aea Mon Sep 17 00:00:00 2001
From: whycrzg <ruanzhigang@whycst.com>
Date: 星期一, 18 十月 2021 15:14:33 +0800
Subject: [PATCH] V1.84 edit at date 2021-10-18 1.新增'db_app_sys.tb_page_param_user'表的创建语句
---
BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java | 32 ++++++++++++++++++++++++++++++++
1 files changed, 32 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 e45363a..c416402 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
@@ -36,8 +36,40 @@
createTb_dashboard_module_Table(pool, recreate);
createTb_dashboard_module_chart_Table(pool, recreate);
+ createTb_Page_Param_User_Table(pool, recreate);
+
}
+ /**
+ *
+ * @Title: createTb_Page_Param_User_Table
+ * @Description: 创建表db_app_sys.tb_page_param_user
+ * @param pool
+ * @param recreate
+ */
+ private static void createTb_Page_Param_User_Table(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Page_Param_User_Table;
+ String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Page_Param_User_Table + " (" +
+ "`id` int(11) NOT NULL AUTO_INCREMENT," +
+ " `key` varchar(45) CHARACTER SET utf8 DEFAULT NULL," +
+ " `label` varchar(45) CHARACTER SET utf8 DEFAULT NULL," +
+ " `show` tinyint(4) DEFAULT NULL," +
+ " `user_id` int(11) DEFAULT NULL," +
+ " PRIMARY KEY (`id`)" +
+ ") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='页面可配置,关联用户id';";
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ try {
+ if(true == recreate) {
+ sql.sqlMysqlExecute(sql_str01);
+ }
+ sql.sqlMysqlExecute(sql_str02);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
+
private static void createTb_dashboard_module_chart_Table(MysqlConnPool pool, boolean recreate) {
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_dashboard_module_chart_Table;
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_dashboard_module_chart_Table + " (" +
--
Gitblit v1.9.1