From f798a9ec355646be5bca810954f9caf9f603551c Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期二, 24 八月 2021 14:56:56 +0800
Subject: [PATCH] V1.68 edit at date 2021-08-24 1.db_battinf.tb_battinf表新增'uRole'字段'告警角色：0-管理员、1-维护组长、2-维护组员'
---
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | 10 ++++++++++
1 files changed, 10 insertions(+), 0 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 aa70975..f7b2ebf 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
@@ -977,6 +977,16 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
+ " ADD COLUMN `login_type` tinyint(1) DEFAULT '1' COMMENT '登录类型:1-密码,2-人脸';");
}
+ //`uRole` tinyint(1) DEFAULT NULL COMMENT '告警角色：0-管理员、1-维护组长、2-维护组员'
+ //添加uRole['告警角色：0-管理员、1-维护组长、2-维护组员']
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_user'"
+ + " AND table_name='tb_user_inf'"
+ + " AND column_name='uRole'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
+ + " ADD COLUMN `uRole` tinyint(1) DEFAULT NULL COMMENT '告警角色：0-管理员、1-维护组长、2-维护组员';");
+ }
res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf);
if(res.next()) {
int count = res.getInt("num_count");
--
Gitblit v1.9.1