蓄电池监控管理平台数据库初始化程序
Administrator
2022-12-28 05400e898de01bb507bbe1b026700805e4d6c8cd
5.db_app_sys.tb_app_sys 新增字段
`AppServer_Reinit_BattGroupData_FBO4830_EN` tinyint(1) NOT NULL
DEFAULT '0',
4个文件已修改
20 ■■■■ 已修改文件
BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt 4 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
BattMonitor_DB_Builder/src/com/battdata_rt/BattData_RT_RamDB_Thread_SQL.java 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java 10 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt 4 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt
@@ -22,8 +22,10 @@
      3.web_site.tb_peak_statistics 新增字段
          `electric_fromelec` float NOT NULL DEFAULT '0' COMMENT '电能表展示的用电量'
          
      4.web_site.tb_process_survey 新增线程数据  - FBO4830NT通信线程
      4.web_site.tb_process_survey 新增线程数据  - FBO4830NT通信线程 - 11021
    5.db_app_sys.tb_app_sys 新增字段
        `AppServer_Reinit_BattGroupData_FBO4830_EN` tinyint(1) NOT NULL DEFAULT '0',
BattMonitor_DB_Builder/src/com/battdata_rt/BattData_RT_RamDB_Thread_SQL.java
@@ -446,7 +446,7 @@
                                + " AppServer_Reinit_BattGroupData_EN = 1,"
                                + " AppServer_Reinit_BattGroupData_LD9_EN = 1,"
                                + " AppServer_Reinit_BattGroupData_A059_EN = 1,"
                                + " AppServer_Reinit_BattGroupData_61851_EN = 1"
                                + " AppServer_Reinit_BattGroupData_61851_EN = 1,"
                                + " AppServer_Reinit_BattGroupData_FBO4830_EN = 1"
                                + " WHERE num > 0"
                                ;
BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -717,6 +717,16 @@
                            + " ADD COLUMN `AppServer_Reinit_BattGroupData_LD9_EN` BOOLEAN NOT NULL DEFAULT false"
                            + " AFTER `AppServer_Reinit_BattGroupData_EN`");
            }
            /**************************** db_app_sys 表中添加 AppServer_Reinit_BattGroupData_FBO4830_EN 列(用于4830主程序动态加载设备参数) *******************************************/
            res0 = sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_app_sys'"
                    + " AND table_name='tb_app_sys'"
                    + " AND column_name='AppServer_Reinit_BattGroupData_FBO4830_EN'");
            if(false == res0.next()) {
                sqlMysqlExecute("ALTER TABLE " + AppSys_Table
                        + " ADD COLUMN `AppServer_Reinit_BattGroupData_FBO4830_EN` BOOLEAN NOT NULL DEFAULT false"
                        + " AFTER `AppServer_Reinit_BattGroupData_LD9_EN`");
            }
        //---------------------------------------------------------------------------------------------//
        
        sqlMysqlExecute(table_1);
BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt
@@ -22,8 +22,10 @@
      3.web_site.tb_peak_statistics 新增字段
          `electric_fromelec` float NOT NULL DEFAULT '0' COMMENT '电能表展示的用电量'
          
      4.web_site.tb_process_survey 新增线程数据  - FBO4830NT通信线程
      4.web_site.tb_process_survey 新增线程数据  - FBO4830NT通信线程 - 11021
    5.db_app_sys.tb_app_sys 新增字段
        `AppServer_Reinit_BattGroupData_FBO4830_EN` tinyint(1) NOT NULL DEFAULT '0',