机房状态表中添加续航列以及创建机房状态历史记录表

LiJun

2018-10-18 9348f97afb69f6c65e8b456ae6ac585bf9789477

机房状态表中添加续航列以及创建机房状态历史记录表

 BattMonitor_DB_Builder/bin/com/dev/fbs9100/FBS9100_Task_Thread_SQL.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/sql/Sql_Mysql.class

Binary files differ

 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>123.207.82.239</mysql_server_ip>
  <!--SOURCE_BATTDATA_TYPE_FBSDEV = 0-->
  <!--SOURCE_BATTDATA_TYPE_SQLSERVER = 1-->
  <!--SOURCE_BATTDATA_TYPE_C_INTERFACE = 2-->

 BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java

@@ -213,15 +213,16 @@
                + "`record_datetime` varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00', "                
                + "`station_stat` INT NOT NULL DEFAULT 0, "                
                + "`station_poff_start_time` varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00', "
                + "`station_poff_tlong` INT NOT NULL DEFAULT 0, "				
                //+ "`station_poff_tlong` INT NOT NULL DEFAULT 0, "				
                + "`station_fadian_start_time` varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00', "
                + "`station_fadian_tlong` INT NOT NULL DEFAULT 0, "				
                //+ "`station_fadian_tlong` INT NOT NULL DEFAULT 0, "				
                + "`station_diaozhan_start_time` varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00', "
                + "`station_diaozhan_tlong` INT NOT NULL DEFAULT 0, "				
                //+ "`station_diaozhan_tlong` INT NOT NULL DEFAULT 0, "				
                + "`station_temp` float NOT NULL DEFAULT 0, "    //温度
                + "`station_damp` float NOT NULL DEFAULT 0, "    //湿度                
                + "`station_dooropen_start_time` varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00', "
                + "`station_dooropen_tlong` INT NOT NULL DEFAULT 0, "				
                //+ "`station_dooropen_tlong` INT NOT NULL DEFAULT 0, "				
                + "`station_xuhang_start_time` varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00', "

                + " UNIQUE INDEX index_station_id_uniq (`station_id`), "
                + " PRIMARY KEY (`num`) ) "
                + " ENGINE=InnoDB DEFAULT CHARSET=utf8";

 BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java

@@ -113,6 +113,9 @@
    public final static String UserPermitGroupTable = DB_USER + ".`tb_user_permitgroup`";

    public final static String UserPermitGroupDataTable = DB_USER + ".`tb_user_permitgroup_data`";

    public final static String UserJieJiaRiTable = DB_USER + ".`tb_user_jiejiari`";

	
	
    public final static String BTSStationEvent_Table = DB_ALARM + ".`tb_bts_station_event`";                            //机房状态历史表

    //--------------------------------------------------------------------------------------------//

    //--------------------------------------------------------------------------------------------//

    public Connection mysql_con;

@@ -396,6 +399,23 @@
                        + "INDEX index_dev_id (`dev_id`), "

                        + "PRIMARY KEY (`num`)) "

                        + "ENGINE=InnoDB DEFAULT CHARSET=utf8;";

		
		
		
		
        String table_9 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.BTSStationEvent_Table

                        + " ( `num` BIGINT NOT NULL AUTO_INCREMENT, "

                        + "`station_id` BIGINT NOT NULL DEFAULT 0, "

                        + "`dev_id` BIGINT NOT NULL DEFAULT 0, "

                        + "`record_datetime` varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00', "

						
                        + "`station_event_type` INT NOT NULL DEFAULT 0, "

                        + "`station_event_trig` INT NOT NULL DEFAULT 0, "

						
                        + " INDEX index_dev_id (`dev_id`), "

                        + " INDEX index_station_id (`station_id`), "

                        + " PRIMARY KEY (`num`) ) "

                        + " ENGINE=InnoDB DEFAULT CHARSET=utf8";

        //-------------------------------------------------------------------------------------//

        //-------------------------------------------------------------------------------------//

        sqlMysqlUseDB(Sql_Mysql.DB_AppSys);

@@ -453,6 +473,7 @@
        sqlMysqlExecute(table_6);

        sqlMysqlExecute(table_7);

        sqlMysqlExecute(table_8);

        sqlMysqlExecute(table_9);

        

        //---------------------------------------------------------------------------------------------//

        ResultSet res = sqlMysqlQuery("show index from " + BattInf_Table + " where column_name='BattGroupId'");