-- Table structure for table curr_avail -- DROP TABLE IF EXISTS curr_avail ; CREATE TABLE curr_avail ( unit_id int DEFAULT NULL, location_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL ) ; -- -- Table structure for table curr_availfail -- DROP TABLE IF EXISTS curr_availfail ; CREATE TABLE curr_availfail ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, lasthop1 varchar DEFAULT NULL, lasthop2 varchar DEFAULT NULL, lasthop3 varchar DEFAULT NULL, location_id int DEFAULT NULL ) ; -- -- Table structure for table curr_dlping -- DROP TABLE IF EXISTS curr_dlping ; CREATE TABLE curr_dlping ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, target varchar DEFAULT NULL, rtt_avg int DEFAULT NULL, rtt_min int DEFAULT NULL, rtt_max int DEFAULT NULL, rtt_std int DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL, location_id int DEFAULT NULL ) ; -- -- Table structure for table curr_dns -- DROP TABLE IF EXISTS curr_dns ; CREATE TABLE curr_dns ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, nameserver varchar DEFAULT NULL, lookup_host varchar DEFAULT NULL, response_ip varchar DEFAULT NULL, rtt int DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL, location_id int DEFAULT NULL ) ; -- -- Table structure for table curr_httpget -- DROP TABLE IF EXISTS curr_httpget ; CREATE TABLE curr_httpget ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, target varchar DEFAULT NULL, address varchar DEFAULT NULL, fetch_time int DEFAULT NULL, bytes_total int DEFAULT NULL, bytes_sec int DEFAULT NULL, bytes_sec_interval int DEFAULT NULL, warmup_time int DEFAULT NULL, warmup_bytes int DEFAULT NULL, sequence int DEFAULT NULL, threads int DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL, location_id int DEFAULT NULL ) ; -- -- Table structure for table curr_httpgetmt -- DROP TABLE IF EXISTS curr_httpgetmt ; CREATE TABLE curr_httpgetmt ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, target varchar DEFAULT NULL, address varchar DEFAULT NULL, fetch_time int DEFAULT NULL, bytes_total int DEFAULT NULL, bytes_sec int DEFAULT NULL, bytes_sec_interval int DEFAULT NULL, warmup_time int DEFAULT NULL, warmup_bytes int DEFAULT NULL, sequence int DEFAULT NULL, threads int DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL, location_id int DEFAULT NULL ) ; -- -- Table structure for table curr_httpgetmt6 -- DROP TABLE IF EXISTS curr_httpgetmt6 ; CREATE TABLE curr_httpgetmt6 ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, target varchar DEFAULT NULL, address varchar DEFAULT NULL, fetch_time int DEFAULT NULL, bytes_total int DEFAULT NULL, bytes_sec int DEFAULT NULL, bytes_sec_interval int DEFAULT NULL, warmup_time int DEFAULT NULL, warmup_bytes int DEFAULT NULL, sequence int DEFAULT NULL, threads int DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL, location_id int DEFAULT NULL ) ; -- -- Table structure for table curr_httppost -- DROP TABLE IF EXISTS curr_httppost ; CREATE TABLE curr_httppost ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, target varchar DEFAULT NULL, address varchar DEFAULT NULL, fetch_time int DEFAULT NULL, bytes_total int DEFAULT NULL, bytes_sec int DEFAULT NULL, bytes_sec_interval int DEFAULT NULL, warmup_time int DEFAULT NULL, warmup_bytes int DEFAULT NULL, sequence int DEFAULT NULL, threads int DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL, location_id int DEFAULT NULL ) ; -- -- Table structure for table curr_httppostmt -- DROP TABLE IF EXISTS curr_httppostmt ; CREATE TABLE curr_httppostmt ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, target varchar DEFAULT NULL, address varchar DEFAULT NULL, fetch_time int DEFAULT NULL, bytes_total int DEFAULT NULL, bytes_sec int DEFAULT NULL, bytes_sec_interval int DEFAULT NULL, warmup_time int DEFAULT NULL, warmup_bytes int DEFAULT NULL, sequence int DEFAULT NULL, threads int DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL, location_id int DEFAULT NULL ) ; -- -- Table structure for table curr_httppostmt6 -- DROP TABLE IF EXISTS curr_httppostmt6 ; CREATE TABLE curr_httppostmt6 ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, target varchar DEFAULT NULL, address varchar DEFAULT NULL, fetch_time int DEFAULT NULL, bytes_total int DEFAULT NULL, bytes_sec int DEFAULT NULL, bytes_sec_interval int DEFAULT NULL, warmup_time int DEFAULT NULL, warmup_bytes int DEFAULT NULL, sequence int DEFAULT NULL, threads int DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL, location_id int DEFAULT NULL ) ; -- -- Table structure for table curr_netusage -- DROP TABLE IF EXISTS curr_netusage ; CREATE TABLE curr_netusage ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, wan_rx_bytes bigint DEFAULT NULL, wan_tx_bytes bigint DEFAULT NULL, sk_rx_bytes bigint DEFAULT NULL, sk_tx_bytes bigint DEFAULT NULL, location_id int DEFAULT NULL ) ; -- -- Table structure for table curr_ping -- DROP TABLE IF EXISTS curr_ping ; CREATE TABLE curr_ping ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, target varchar DEFAULT NULL, rtt_avg int DEFAULT NULL, rtt_min int DEFAULT NULL, rtt_max int DEFAULT NULL, rtt_std int DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL, location_id int DEFAULT NULL ) ; -- -- Table structure for table curr_ping6 -- DROP TABLE IF EXISTS curr_ping6 ; CREATE TABLE curr_ping6 ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, target varchar DEFAULT NULL, rtt_avg int DEFAULT NULL, rtt_min int DEFAULT NULL, rtt_max int DEFAULT NULL, rtt_std int DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL, location_id int DEFAULT NULL ) ; -- -- Table structure for table curr_udpjitter -- DROP TABLE IF EXISTS curr_udpjitter ; CREATE TABLE curr_udpjitter ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, target varchar DEFAULT NULL, packet_size int DEFAULT NULL, stream_rate int DEFAULT NULL, duration int DEFAULT NULL, packets_up_sent int DEFAULT NULL, packets_down_sent int DEFAULT NULL, packets_up_recv int DEFAULT NULL, packets_down_recv int DEFAULT NULL, jitter_up int DEFAULT NULL, jitter_down int DEFAULT NULL, latency int DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL, location_id int DEFAULT NULL ) ; -- -- Table structure for table curr_udplatency -- DROP TABLE IF EXISTS curr_udplatency ; CREATE TABLE curr_udplatency ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, target varchar DEFAULT NULL, rtt_avg int DEFAULT NULL, rtt_min int DEFAULT NULL, rtt_max int DEFAULT NULL, rtt_std int DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL, location_id int DEFAULT NULL ) ; -- -- Table structure for table curr_ulping -- DROP TABLE IF EXISTS curr_ulping ; CREATE TABLE curr_ulping ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, target varchar DEFAULT NULL, rtt_avg int DEFAULT NULL, rtt_min int DEFAULT NULL, rtt_max int DEFAULT NULL, rtt_std int DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL, location_id int DEFAULT NULL ) ; -- -- Table structure for table curr_videostream -- DROP TABLE IF EXISTS curr_videostream ; CREATE TABLE curr_videostream ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, target varchar DEFAULT NULL, downthrpt int DEFAULT NULL, downjitter int DEFAULT NULL, latency int DEFAULT NULL, jitter int DEFAULT NULL, buffer_underruns int DEFAULT NULL, buffer_delay int DEFAULT NULL, buffer_filltime int DEFAULT NULL, duration int DEFAULT NULL, bitrate int DEFAULT NULL, buffer_size int DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL, location_id int DEFAULT NULL ) ; -- -- Table structure for table curr_webget -- DROP TABLE IF EXISTS curr_webget ; CREATE TABLE curr_webget ( unit_id int NOT NULL DEFAULT '0', dtime timestamp DEFAULT NULL, target varchar(200) NOT NULL DEFAULT '', address varchar(45) DEFAULT NULL, fetch_time int DEFAULT NULL, bytes_total int DEFAULT NULL, bytes_sec int DEFAULT NULL, objects int DEFAULT NULL, threads int DEFAULT NULL, requests int DEFAULT NULL, connections int DEFAULT NULL, reused_connections int DEFAULT NULL, lookups int DEFAULT NULL, request_total_time int DEFAULT NULL, request_min_time int DEFAULT NULL, request_avg_time int DEFAULT NULL, request_max_time int DEFAULT NULL, ttfb_total int DEFAULT NULL, ttfb_min int DEFAULT NULL, ttfb_avg int DEFAULT NULL, ttfb_max int DEFAULT NULL, lookup_total_time int DEFAULT NULL, lookup_min_time int DEFAULT NULL, lookup_avg_time int DEFAULT NULL, lookup_max_time int DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL, location_id int NOT NULL DEFAULT '0' ) ; -- -- Table structure for table curr_webgetobjects -- DROP TABLE IF EXISTS curr_webgetobjects ; CREATE TABLE curr_webgetobjects ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, referrer varchar DEFAULT NULL, target varchar DEFAULT NULL, fetch_time int DEFAULT NULL, bytes_total int DEFAULT NULL, bytes_sec int DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL, location_id int DEFAULT NULL ) ; -- -- Table structure for table curr_www -- DROP TABLE IF EXISTS curr_www ; CREATE TABLE curr_www ( unit_id int DEFAULT NULL, dtime timestamp DEFAULT NULL, target varchar DEFAULT NULL, fetch_time int DEFAULT NULL, bytes_total int DEFAULT NULL, bytes_sec int DEFAULT NULL, successes smallint DEFAULT NULL, failures smallint DEFAULT NULL, location_id int DEFAULT NULL ) ;