SQLite format 3@ WW-  YT77Kviewconnection_test_statsconnection_test_statsCREATE VIEW connection_test_stats AS SELECT 'GSM' as type,gsm_cell_lac as id1, gsm_short_cell_id as id2, gsm_full_cell_id as id3, extra_info as label, google_connection_test as test_result, COUNT(google_connection_test) as test_count FROM networkmonitor WHERE (data_state='CONNECTED') AND (id1 NOT NULL OR id2 NOT NULL OR id3 NOT NULL ) GROUP BY id1,id2,id3,label,test_result UNION SELECT 'CDMA' as type,cdma_cell_base_station_id as id1, cdma_cell_network_id as id2, cdma_cell_system_id as id3, extra_info as label, google_connection_test as test_result, COUNT(google_connection_test) as test_count FROM networkmonitor WHERE (data_state='CONNECTED') AND (id1 NOT NULL OR id2 NOT NULL OR id3 NOT NULL ) GROUP BY id1,id2,id3,label,test_result UNION SELECT 'WIFI' as type,wifi_bssid as id1, NULL as id2, NULL as id3, wifi_ssid as label, google_connection_test as test_result, COUNT(google_connection_test) as test_count FROM networkmonitor WHERE (network_type='WIFI') AND (id1 NOT NULL OR id2 NOT NULL OR id3 NOT NULL ) GROUP BY id1,id2,id3,label,test_resultP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)y))-tablenetworkmonitornetworkmonitorCREATE TABLE networkmonitor ( _id INTEGER PRIMARY KEY AUTOINCREMENT, timestamp INTEGER, google_connection_test TEXT, http_connection_test TEXT, network_type TEXT, mobile_data_network_type TEXT, sim_state TEXT, detailed_state TEXT, is_connected INTEGER, is_roaming INTEGER, is_available INTEGER, is_failover INTEGER, data_activity TEXT, data_state TEXT, reason TEXT, extra_info TEXT, wifi_ssid TEXT, wifi_bssid TEXT, wifi_frequency INTEGER, wifi_channel INTEGER, wifi_signal_strength INTEGER, wifi_rssi INTEGER, sim_operator TEXT, sim_mcc TEXT, sim_mnc TEXT, network_operator TEXT, network_mcc TEXT, network_mnc TEXT, is_network_metered INTEGER, device_latitude REAL, device_longitude REAL, device_position_accuracy REAL, cell_signal_strength INTEGER, cell_signal_strength_dbm INTEGER, cell_asu_level INTEGER, gsm_ber INTEGER, lte_rsrq INTEGER, cdma_cell_base_station_id INTEGER, cdma_cell_latitude INTEGER, cdma_cell_longitude INTEGER, cdma_cell_network_id INTEGER, cdma_cell_system_id INTEGER, gsm_full_cell_id INTEGER, gsm_rnc INTEGER, gsm_short_cell_id INTEGER, gsm_cell_lac INTEGER, gsm_cell_psc INTEGER, network_interface TEXT, ipv4_address TEXT,ipv6_address TEXT,battery_level INTEGER, download_speed TEXT, upload_speed TEXt )W--ctableandroid_metadataandroid_metadataCREATE TABLE android_metadata (locale TEXT) sv_SE  c B!|vpjd^XRLF@:4.(" ztnhb\VPJD>82,&  SPAREADYCONNECTEDNONEDISCONNECTED"eduroam""eduroam"70:10:5c:92:e2:6fdTele22400724005JJJp2p0;wlan0130.236.205.13fe80::bcf5:acff:fee1:ba59%p2p0;fe80::bef5:acff:fee1:ba59%wlan0d25,868[7  %/ !) MMa}uWIFIHSPAREADYCONNECTEDNONEDISCONNECTED"eduroam""eduroam"70:10:5c:92:e2:6fdTele22400724005JJJp2p0;wlan0130.236.205.13fe80::bcf5:acff:fee1:ba59%p2p0;fe80::bef5:acff:fee1:ba59%wlan0d27,437Z7  %/ !) MMaVfWIFIHSPAREADYCONNECTEDNONEDISCONNECTED"eduroam""eduroam"70:10:5c:92:e2:6fdTele22400724005JJJp2p0;wlan0130.236.205.13fe80::bcf5:acff:fee1:ba59%p2p0;fe80::bef5:acff:fee1:ba59%wlan0d29,855Y7  %/ !) MMa/UWIFIHSPAREADYCONNECTEDNONEDISCONNECTED"eduroam""eduroam"70:10:5c:92:e2:6fdTele22400724005JJJp2p0;wlan0130.236.205.13fe80::bcf5:acff:fee1:ba59%p2p0;fe80::bef5:acff:fee1:ba59%wlan0d23,416X7  %/ !) MMaBWIFIHSPAREADYCONNECTEDNONEDISCONNECTED"eduroam""eduroam"70:10:5c:92:e2:6fdTele22400724005JJJp2p0;wlan0130.236.205.13fe80::bcf5:acff:fee1:ba59%p2p0;fe80::bef5:acff:fee1:ba59%wlan0d8,487W7  %/ !) MM`/WIFIHSPAREADYCONNECTEDNONEDISCONNECTED"eduroam""eduroam"70:10:5c:92:e2:6fdTele22400724005JJJp2p0;wlan0130.236.205.13fe80::bcf5:acff:fee1:ba59%p2p0;fe80::bef5:acff:fee1:ba59%wlan0d22,891V7  %/ !) MM`WIFIHSPAREADYCONNECTEDNONEDISCONNECTED"eduroam""eduroam"70:10:5c:92:e2:6fdTele22400724005JJJp2p0;wlan0130.236.205.13fe80::bcf5:acff:fee1:ba59%p2p0;fe80::bef5:acff:fee1:ba59%wlan0d12,674U7  %/ !) MM`WIFIHSPAREADYCONNECTEDNONEDISCONNECTED"eduroam""eduroaN7  %!!/!' M^PASSPASSWIFILTEREADYCONNECTEDNONEDISCONNECTED"PandaINC""PandaINC"c8:d7:19:91:42:26<Tele224007Tele224007$Ϋp2p0;wlan0192.168.1.147fe80::bcf5:acff:fee1:ba59%p2p0;fe80::bef5:acff:fee1:ba59%wlan0dDisabledDisabledM7  %!!/!' M^PASSPASSWIFILTEREADYCONNECTEDNONEDISCONNECTED"PandaINC""PandaINC"c8:d7:19:91:42:26<Tele224007Tele224007'Ϋp2p0;wlan0192.168.1.147fe80::bcf5:acff:fee1:ba59%p2p0;fe80::bef5:acff:fee1:ba59%wlan0dDisabledDisabledL7  %!!/!' M^PASSPASSWIFILTEREADYCONNECTEDNONEDISCONNECTED"PandaINC""PandaINC"c8:d7:19:91:42:26<Tele224007Tele224007&Ϋp2p0;wlan0192.168.1.147fe80::bcf5:acff:fee1:ba59%p2p0;fe80::bef5:acff:fee1:ba59%wlan0dDisabledDisabledK7  %!!/!' M^PASSPASSWIFILTEREADYCONNECTEDNONEDISCONNECTED"PandaINC""PandaINC"c8:d7:19:91:42:26<Tele224007Tele224007(Ϋp2p0;wlan0192.168.1.147fe80::bcf5:acff:fee1:ba59%p2p0;fe80::bef5:acff:fee1:ba59%wlan0dDisabledDisabledJ7  %!!/!' M^bPASSPASSWIFILTEREADYCONNECTEDNONEDISCONNECTED"PandaINC""PandaINC"c8:d7:19:91:42:26<Tele224007Tele224007'Ϋp2p0;wlan0192.168.1.147fe80::bcf5:acff:fee1:ba59%p2p0;fe80::bef5:acff:fee1:ba59%wlan0dDisabledDisabledI7  %!!/!' M^;PASSPASSWIFILTEREADYCONNECTEDNONEDISCONNECTED"PandaINC""PandaINC"c8:d7:19:91:42:26<Tele224007Tele224007%Ϋp2p0;wlan0192.168.1.147fe80::bcf5:acff:fee1:ba59%p2p0;fe80::bef5:acff:fee1:ba59%wlan0d28,07619,630H7  %!!/!' M^PASSPASSWIFILTEREADYCONNECTEDNONEDISCONNECTED"PandaINC""PandaINC"c8:d7:19:91:42:26<Tele224007Tele224007'Ϋp2p0;wlan0192.168.1.147fe80::bcf5:acff:fee1:ba59%p2p0;fe80::bef5:acff:fee1:ba59%wlan0d12,18124,735 )networkmonitorN