在9100_state表中添加停电时长,续航时长,停电次数和流量等列

军

2018-09-29 b471d645e91846f3c54f4f1b3bcbf0a6729ed847

在9100_state表中添加停电时长,续航时长,停电次数和流量等列

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

Binary files differ

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

@@ -50,6 +50,11 @@
                    + "`dev_condcurr`  float NOT NULL DEFAULT 0, "

                    + "`dev_61850alarms`  varchar(64) NOT NULL DEFAULT '', "                    

                    

                    + "`dev_batt_xuhang_tlong` INT NOT NULL DEFAULT 0, "                //续航时长
                    + "`dev_station_poff_tlong` INT NOT NULL DEFAULT 0, "                //停电时长
                    + "`dev_station_poff_cnt` INT NOT NULL DEFAULT 0, "                    //停电次数
                    + "`dev_data_flowsum` BIGINT NOT NULL DEFAULT 0, "                    //机房流量
					
                    + " UNIQUE INDEX index_dev_id_uniq (`dev_id`), "

                    + " PRIMARY KEY (`num`) ) "

                    + " ENGINE=InnoDB DEFAULT CHARSET=utf8";