From bc1bcfd3c1bc77deff73ec0deb8bf65eaad81616 Mon Sep 17 00:00:00 2001
From: whycrzg <ruanzhigang@whycst.com>
Date: 星期一, 13 十二月 2021 16:05:57 +0800
Subject: [PATCH] V1.99 edit at date 2021-12-13 1：新增`db_app_sys`.`tb_menu_approve` 模板表创建
---
BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java | 49 +++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 47 insertions(+), 2 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 16add9c..1e797f2 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
@@ -38,11 +38,56 @@
createTb_Page_Param_User_Table(pool, recreate);
- createTb_Page_Param2_Table(pool, recreate);//创建表并初始化值
-// tb_page_param2
+ createTb_Page_Param2_Table(pool, recreate);//创建表并初始化值
+
+ createTb_Menu_Approve_Table(pool, recreate);//创建表tb_menu_approve
+
}
+ /**
+ *
+ * @Title: createTb_Menu_Approve_Table
+ * @Description: 建表tb_menu_approve
+ * @param pool
+ * @param recreate
+ * @author author
+ * @date 2021年12月13日
+ */
+ private static void createTb_Menu_Approve_Table(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Menu_Approve_Table;
+ String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Menu_Approve_Table + " (" +
+ " `id` int(11) NOT NULL," +
+ " `label` varchar(255) DEFAULT NULL COMMENT '中文名称'," +
+ " `name` varchar(255) DEFAULT NULL COMMENT '名称'," +
+ " `src` varchar(255) DEFAULT NULL COMMENT '路径'," +
+ " `icon` varchar(100) DEFAULT NULL COMMENT '图标'," +
+ " `closable` tinyint(4) DEFAULT NULL COMMENT '是否可关闭'," +
+ " `enableduse` tinyint(4) DEFAULT NULL COMMENT '是否启用'," +
+ " `permitName` varchar(255) DEFAULT NULL COMMENT '权限'," +
+ " `level` tinyint(4) DEFAULT NULL COMMENT '菜单等级'," +
+ " `ord` tinyint(4) DEFAULT NULL COMMENT '排序'," +
+ " `menuId` int(11) DEFAULT NULL COMMENT '上级菜单id'," +
+ " `createTime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '申请时间'," +
+ " `approveTime` datetime DEFAULT NULL COMMENT '审批时间'," +
+ " `userId` int(11) DEFAULT NULL COMMENT '申请用户'," +
+ " `status` tinyint(1) DEFAULT '0' COMMENT '审批状态 0:未审批,1:已审批-通过,2:已审批-拒绝'," +
+ " KEY `idx_id` (`id`)," +
+ " KEY `idx_userId` (`userId`)" +
+ ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";
+ 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_Page_Param2_Table(MysqlConnPool pool, boolean recreate) {
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Page_Param2_Table;
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Page_Param2_Table + " (" +
--
Gitblit v1.9.1