db_ram_db.tb_fbs9100_state表新增字段 `a059_onlineSaveVol` float NOT NULL DEFAULT...

Administrator

2022-07-05 29a44791122e98b10dbe6648ad0151d679325e1d

db_ram_db.tb_fbs9100_state表新增字段
`a059_onlineSaveVol` float NOT NULL DEFAULT '0' COMMENT
'充放电一体机切换电池组保护电压',

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -561,3 +561,7 @@
    1.修复之前默认添加的superuser账号为临时账号bug    
    2.'db_battinf.tb_battinf'和'db_pwrdev_inf.tb_pwrdev_inf'表新增关联字段 '二维码信息标识位'如下
        `mId` bigint(20) DEFAULT '0' COMMENT '二维码信息标识位'

V1.35 edit at date 2022-07-05
    1.表'db_ram_db.tb_fbs9100_state'表新增字段
        `a059_onlineSaveVol` float NOT NULL DEFAULT '0' COMMENT '充放电一体机切换电池组保护电压',

 BattMonitor_DB_Builder/config.xml

@@ -2,7 +2,7 @@

<root>
  <mysql_ramdb_recreate_en>false</mysql_ramdb_recreate_en>
  <mysql_server_ip>127.0.0.1</mysql_server_ip>
  <mysql_server_ip>192.168.10.79</mysql_server_ip>
  <!--SOURCE_BATTDATA_TYPE_FBSDEV = 0-->
  <!--SOURCE_BATTDATA_TYPE_SQLSERVER = 1-->
  <!--SOURCE_BATTDATA_TYPE_C_INTERFACE = 2-->

 BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java

@@ -1876,6 +1876,7 @@
            }
            sql.sqlMysqlExecute(sql_str02);

            res = null;
            //添加字段a059_group_vol1
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
@@ -1885,7 +1886,7 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table 
                        + " ADD COLUMN `a059_group_vol1` float NOT NULL DEFAULT '0' COMMENT '充放电一体机组1组端电压';");
            }
			
            res = null;
            //添加字段a059_group_vol2
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
@@ -1895,7 +1896,7 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table 
                        + " ADD COLUMN `a059_group_vol2` float NOT NULL DEFAULT '0' COMMENT '充放电一体机组2组端电压';");
            }
			
            res = null;
            //添加字段a059_group_curr1
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
@@ -1905,7 +1906,7 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table 
                        + " ADD COLUMN `a059_group_curr1` float NOT NULL DEFAULT '0' COMMENT '充放电一体机组1组端电流';");
            }
			
            res = null;
            //添加字段a059_group_curr2
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
@@ -1915,7 +1916,7 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table 
                        + " ADD COLUMN `a059_group_curr2` float NOT NULL DEFAULT '0' COMMENT '充放电一体机组2组端电流';");
            }
			
            res = null;
            //添加字段dev_pos_states
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
@@ -1925,6 +1926,7 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table 
                        + " ADD COLUMN `dev_pos_states` varchar(30) NOT NULL DEFAULT '0,0,0,0' COMMENT '切换箱接触器正极开关状态[0没通信上；1；正常；2；异常]';");
            }
            res = null;
            //添加字段dev_neg_states
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
@@ -1934,6 +1936,16 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table 
                        + " ADD COLUMN `dev_neg_states` varchar(30) NOT NULL DEFAULT '0,0,0,0' COMMENT '切换箱接触器负极开关状态[0没通信上；1；正常；2；异常]';");
            }
            res = null;
            //添加字段a059_onlineSaveVol
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
                    + " AND table_name='tb_fbs9100_state'"
                    + " AND column_name='a059_onlineSaveVol'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table 
                        + " ADD COLUMN `a059_onlineSaveVol` float NOT NULL DEFAULT '0' COMMENT '充放电一体机切换电池组保护电压';");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -561,3 +561,7 @@
    1.修复之前默认添加的superuser账号为临时账号bug    
    2.'db_battinf.tb_battinf'和'db_pwrdev_inf.tb_pwrdev_inf'表新增关联字段 '二维码信息标识位'如下
        `mId` bigint(20) DEFAULT '0' COMMENT '二维码信息标识位'

V1.35 edit at date 2022-07-05
    1.表'db_ram_db.tb_fbs9100_state'表新增字段
        `a059_onlineSaveVol` float NOT NULL DEFAULT '0' COMMENT '充放电一体机切换电池组保护电压',