From e92ada77fcae1e4bb8fe97eabb59e4e553623608 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期二, 10 五月 2022 10:32:39 +0800
Subject: [PATCH] V2.24 edit at date 2022-05-10 1.禁用数据库表删除功能，避免重新删除功能 2.修复插入BTS停电机房信息时错误bug 3.修改`db_user`.`tb_user_log`中的'uOprateMsg'字段格式为 `uOprateMsg` text NOT NULL,
---
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | 66 ++++++++++++++++++++++++++++++++-
1 files changed, 64 insertions(+), 2 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java b/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
index 4b0e309..7fe2a5a 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
@@ -678,7 +678,7 @@
ResultSet res = null;
try {
if(recreate) {
- sql.sqlMysqlExecute(sql_str_del);
+ //sql.sqlMysqlExecute(sql_str_del);
}
sql.sqlMysqlExecute(sql_str);
//添加上一次重启时间字段
@@ -686,6 +686,57 @@
if(res.next()) {
int count = res.getInt("sum_count");
if(count<10) {
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','battinf_report_query_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','battgroup_report_query_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','battmant_report_query_permit',0);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','battlarm_report_query_permit',0);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','monomer_report_query_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','batttest_data_query_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','batttest_data_edit_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','task_query_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','task_edit_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','task_check_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','task_recheck_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','usr_query_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','usr_edit_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','permit_query_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','permit_edit_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','server_param_query_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','server_param_edit_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','analog_loader_op_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','batt_test_op_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','battcfg_query_permit',0);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','battcfg_add_permit',0);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','battcfg_modify_permit',0);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','battcfg_del_permit',0);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','batt_alm_query_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','batt_alm_confirm_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','batt_alm_clear_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','batt_alm_delete_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','batt_alm_param_query_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','batt_alm_param_edit_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','dev_alm_query_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','dev_alm_confirm_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','dev_alm_clear_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','dev_alm_delete_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','battfault_query_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','battfault_add_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','battfault_edit_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','battfault_delete_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','battmaint_confirm_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','usrtaskcheck_query_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','usrtaskcheck_add_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','usrtaskcheck_edit_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','usrtaskcheck_delete_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','usrtaskcheck_confirm_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','taskchange_query_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','taskchange_add_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','taskchange_delete_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','taskchange_shenpi_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','batt_map_edit_permit',1);");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'管理员组','batt_map_delete_permit',1);");
+
+
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1736', '100002', '超级管理员组', 'battinf_report_query_permit', '1');");
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1737', '100002', '超级管理员组', 'battgroup_report_query_permit', '1');");
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1738', '100002', '超级管理员组', 'battmant_report_query_permit', '1');");
@@ -1483,13 +1534,24 @@
+ " AND column_name='operation_detail'");
if(false == res.next()) {
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Log_Table
- + " ADD COLUMN `operation_detail` int(5) NOT NULL DEFAULT '1'");
+ + " ADD COLUMN `operation_detail` text COMMENT '操作的具体数据';");
}else{
//修改当前字段的类型
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Log_Table
+ " CHANGE `operation_detail` `operation_detail` text COMMENT '操作的具体数据';");
}
+ //修改uOprateMsg格式为text
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_user'"
+ + " AND table_name='tb_user_log'"
+ + " AND column_name='uOprateMsg'");
+ if(res.next()) {
+ //修改当前字段的类型为text
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Log_Table
+ + " CHANGE `uOprateMsg` `uOprateMsg` text NOT NULL;");
+ }
+
//添加read_flag
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
--
Gitblit v1.9.1