V1.34 edit at date 2022-06-30 1.修复之前默认添加的superuser账号为临时账号bug 2.'db_battin...

Administrator

2022-06-30 9f75e8c972c7607b215204c5842e5f5b634608c3

V1.34 edit at date 2022-06-30
	1.修复之前默认添加的superuser账号为临时账号bug
	2.'db_battinf.tb_battinf'和'db_pwrdev_inf.tb_pwrdev_inf'表新增关联字段
'二维码信息标识位'如下
		`mId` bigint(20) DEFAULT '0' COMMENT '二维码信息标识位'

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -559,4 +559,5 @@
    
V1.34 edit at date 2022-06-30
    1.修复之前默认添加的superuser账号为临时账号bug    
	
    2.'db_battinf.tb_battinf'和'db_pwrdev_inf.tb_pwrdev_inf'表新增关联字段 '二维码信息标识位'如下
        `mId` bigint(20) DEFAULT '0' COMMENT '二维码信息标识位'

 BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java

@@ -84,7 +84,7 @@
            }

            sql.sqlMysqlExecute(sql_str02);    

            

            //添加字段AppServer_Reinit_PowerData_Charger_EN

            //添加字段runCompany 
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"

                    + " WHERE table_schema='db_pwrdev_inf'"

                    + " AND table_name='tb_pwrdev_inf'"

@@ -93,6 +93,16 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table 

                        + " ADD COLUMN `runCompany` varchar(45) NOT NULL DEFAULT '';");

            }

            res = null;

            //添加字段mId ----- 二维码信息标识位

            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"

                    + " WHERE table_schema='db_pwrdev_inf'"

                    + " AND table_name='tb_pwrdev_inf'"

                    + " AND column_name='mId'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table 
                        + " ADD COLUMN `mId` bigint(20) DEFAULT '0' COMMENT '二维码信息标识位';");

            }

        } catch (SQLException e) {

            e.printStackTrace();

        } finally {


 BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java

@@ -1112,6 +1112,17 @@
                        + " CHANGE `dev_num` `dev_num` varchar(255) NOT NULL DEFAULT '0' COMMENT '设备编号[a059用于标识设备]';");
            }
            
            res = null;
            //添加mId  ----   二维码信息标识位
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_battinf'"
                    + " AND table_name='tb_battinf'"
                    + " AND column_name='mId'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table 
                        + " ADD COLUMN `mId` bigint(20) DEFAULT '0' COMMENT '二维码信息标识位';");
            }
			
            //设置column 去掉默认NOT NULL
            {


 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -559,4 +559,5 @@
    
V1.34 edit at date 2022-06-30
    1.修复之前默认添加的superuser账号为临时账号bug    
	
    2.'db_battinf.tb_battinf'和'db_pwrdev_inf.tb_pwrdev_inf'表新增关联字段 '二维码信息标识位'如下
        `mId` bigint(20) DEFAULT '0' COMMENT '二维码信息标识位'