2.表 `db_user`.`tb_user_inf` 默认插入默认账号 ['未登录的用户账号','sys_admin','audit_admin']

Administrator

2022-03-01 f7e3bdab2bfe045ce3d0e68ecdddd54ce358a9c5

2.表 `db_user`.`tb_user_inf` 默认插入默认账号
['未登录的用户账号','sys_admin','audit_admin']

 BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java

@@ -1001,6 +1001,41 @@
                }
            }
            
            //默认新增指定UID = 0;1;2的 账号
            {
                res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf + " WHERE uName = '未登录的用户账号';");
                if(res.next()) {
                    int count = res.getInt("num_count");
                    if(count<1) {
                        //默认没有添加用户信息时添加'未登录的用户账号'
                        sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+"(uId,uSnId,uName,uMobilephone,uJobGroup,upassword,login_type,uRole,type,status,last_login_time,password_update_time,create_time,visit_time,visit_ip) VALUES('0','未登录的用户账号','未登录的用户账号','','','',1,0,1,1,null,'2021-12-14 16:18:44','2021-12-14 16:18:44','00:00:00~23:59:59','*');");
						
                    }
                    sql.sqlMysqlExecute("UPDATE " + Sql_Mysql.TB_UserInf + " SET uId = 0 WHERE uName = '未登录的用户账号'");
                }	
				
                res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf + " WHERE uName = 'sys_admin';");
                if(res.next()) {					
                    int count = res.getInt("num_count");
                    if(count<1) {
                        //默认没有添加用户信息时添加'未登录的用户账号'
                        sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+"(uId,uSnId,uName,uMobilephone,uJobGroup,upassword,login_type,uRole,type,status,last_login_time,password_update_time,create_time,visit_time,visit_ip) VALUES(1,'sys123456',             'sys_admin','','默认班组','61b3151941bb43fad57005524d1a967c',1,0,1,1,'2022-02-14 16:02:01',null,'2021-12-14 16:16:04','00:00:00~23:59:59','*');");
                    }
                }
				
                res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf + " WHERE uName = 'audit_admin';");
                if(res.next()) {					
                    int count = res.getInt("num_count");
                    if(count<1) {
                        //默认没有添加用户信息时添加'未登录的用户账号'
                        sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+"(uId,uSnId,uName,uMobilephone,uJobGroup,upassword,login_type,uRole,type,status,last_login_time,password_update_time,create_time,visit_time,visit_ip) VALUES(2,'audit123456',  'audit_admin','','默认班组','2abdaafa43d93077a514146476ed59db',1,0,1,1,null,'2021-12-14 16:18:44','2021-12-14 16:18:44','00:00:00~23:59:59','*');");
                    }
                }
				
            }
			
			
			
            //添加type
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_user'"

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -388,7 +388,11 @@
    1.表 `db_user`.`tb_user_log` 新增修改字段 
        CHANGE `operation_detail` `operation_detail` text COMMENT '操作的具体数据'
        ADD COLUMN `read_flag` TINYINT(1) NULL DEFAULT 1 COMMENT '是否已阅读,此功能针对异常信息' AFTER `operation_detail`;

    2.表 `db_user`.`tb_user_inf` 默认插入默认账号 ['未登录的用户账号','sys_admin','audit_admin']
        INSERT INTO `tb_user_inf`(uId,uSnId,uName,uMobilephone,uJobGroup,upassword,login_type,uRole,type,status,last_login_time,password_update_time,create_time,visit_time,visit_ip) VALUES(0,'未登录的用户账号','未登录的用户账号','','','',1,0,1,1,null,'2021-12-14 16:18:44','2021-12-14 16:18:44','00:00:00~23:59:59','*');
        INSERT INTO `tb_user_inf`(uId,uSnId,uName,uMobilephone,uJobGroup,upassword,login_type,uRole,type,status,last_login_time,password_update_time,create_time,visit_time,visit_ip) VALUES(1,'sys123456',             'sys_admin','','默认班组','61b3151941bb43fad57005524d1a967c',1,0,1,1,'2022-02-14 16:02:01',null,'2021-12-14 16:16:04','00:00:00~23:59:59','*');
        INSERT INTO `tb_user_inf`(uId,uSnId,uName,uMobilephone,uJobGroup,upassword,login_type,uRole,type,status,last_login_time,password_update_time,create_time,visit_time,visit_ip) VALUES(2,'audit123456',  'audit_admin','','默认班组','2abdaafa43d93077a514146476ed59db',1,0,1,1,null,'2021-12-14 16:18:44','2021-12-14 16:18:44','00:00:00~23:59:59','*');