Skip Navigation

Federal Communications Commission

English Display Options

Mysql Table Instantiation Sample - Measuring Broadband America Data April 2012

-- MySQL-Table-Script.sql

--
-- Table structure for table `curr_avail`
--
DROP TABLE IF EXISTS `curr_avail`;

CREATE TABLE `curr_avail` (
 `unit_id` int(11) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL
) ;
--
-- Table structure for table `curr_availfail`
--
DROP TABLE IF EXISTS `curr_availfail`;
CREATE TABLE `curr_availfail` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `lasthop1` varchar(15) DEFAULT NULL,
 `lasthop2` varchar(15) DEFAULT NULL,
 `lasthop3` varchar(15) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;
--
-- Table structure for table `curr_dlping`
--
DROP TABLE IF EXISTS `curr_dlping`;
CREATE TABLE `curr_dlping` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `target` varchar(100) DEFAULT NULL,
 `rtt_avg` int(11) DEFAULT NULL,
 `rtt_min` int(11) DEFAULT NULL,
 `rtt_max` int(11) DEFAULT NULL,
 `rtt_std` int(11) DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;
--
-- Table structure for table `curr_dns`
--
DROP TABLE IF EXISTS `curr_dns`;
CREATE TABLE `curr_dns` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `nameserver` varchar(15) DEFAULT NULL,
 `lookup_host` varchar(45) DEFAULT NULL,
 `response_ip` varchar(45) DEFAULT NULL,
 `rtt` int(11) DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL,
 KEY `unit_id` (`unit_id`),
 KEY `dtime` (`dtime`)
) ;
--
-- Table structure for table `curr_httpget`
--
DROP TABLE IF EXISTS `curr_httpget`;
CREATE TABLE `curr_httpget` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `target` varchar(200) DEFAULT NULL,
 `address` varchar(20) DEFAULT NULL,
 `fetch_time` int(11) DEFAULT NULL,
 `bytes_total` int(11) DEFAULT NULL,
 `bytes_sec` int(11) DEFAULT NULL,
 `bytes_sec_interval` int(11) DEFAULT NULL,
 `warmup_time` int(11) DEFAULT NULL,
 `warmup_bytes` int(11) DEFAULT NULL,
 `sequence` int(11) DEFAULT NULL,
 `threads` int(11) DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;
--
-- Table structure for table `curr_httpgetmt`
--
DROP TABLE IF EXISTS `curr_httpgetmt`;
CREATE TABLE `curr_httpgetmt` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `target` varchar(200) DEFAULT NULL,
 `address` varchar(20) DEFAULT NULL,
 `fetch_time` int(11) DEFAULT NULL,
 `bytes_total` int(11) DEFAULT NULL,
 `bytes_sec` int(11) DEFAULT NULL,
 `bytes_sec_interval` int(11) DEFAULT NULL,
 `warmup_time` int(11) DEFAULT NULL,
 `warmup_bytes` int(11) DEFAULT NULL,
 `sequence` int(11) DEFAULT NULL,
 `threads` int(11) DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;
--
-- Table structure for table `curr_httpgetmt6`
--
DROP TABLE IF EXISTS `curr_httpgetmt6`;
CREATE TABLE `curr_httpgetmt6` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `target` varchar(200) DEFAULT NULL,
 `address` varchar(20) DEFAULT NULL,
 `fetch_time` int(11) DEFAULT NULL,
 `bytes_total` int(11) DEFAULT NULL,
 `bytes_sec` int(11) DEFAULT NULL,
 `bytes_sec_interval` int(11) DEFAULT NULL,
 `warmup_time` int(11) DEFAULT NULL,
 `warmup_bytes` int(11) DEFAULT NULL,
 `sequence` int(11) DEFAULT NULL,
 `threads` int(11) DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;
--
-- Table structure for table `curr_httppost`
--
DROP TABLE IF EXISTS `curr_httppost`;
CREATE TABLE `curr_httppost` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `target` varchar(200) DEFAULT NULL,
 `address` varchar(20) DEFAULT NULL,
 `fetch_time` int(11) DEFAULT NULL,
 `bytes_total` int(11) DEFAULT NULL,
 `bytes_sec` int(11) DEFAULT NULL,
 `bytes_sec_interval` int(11) DEFAULT NULL,
 `warmup_time` int(11) DEFAULT NULL,
 `warmup_bytes` int(11) DEFAULT NULL,
 `sequence` int(11) DEFAULT NULL,
 `threads` int(11) DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;
--
-- Table structure for table `curr_httppostmt`
--
DROP TABLE IF EXISTS `curr_httppostmt`;
CREATE TABLE `curr_httppostmt` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `target` varchar(200) DEFAULT NULL,
 `address` varchar(20) DEFAULT NULL,
 `fetch_time` int(11) DEFAULT NULL,
 `bytes_total` int(11) DEFAULT NULL,
 `bytes_sec` int(11) DEFAULT NULL,
 `bytes_sec_interval` int(11) DEFAULT NULL,
 `warmup_time` int(11) DEFAULT NULL,
 `warmup_bytes` int(11) DEFAULT NULL,
 `sequence` int(11) DEFAULT NULL,
 `threads` int(11) DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;
--
-- Table structure for table `curr_httppostmt6`
--
DROP TABLE IF EXISTS `curr_httppostmt6`;
CREATE TABLE `curr_httppostmt6` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `target` varchar(200) DEFAULT NULL,
 `address` varchar(20) DEFAULT NULL,
 `fetch_time` int(11) DEFAULT NULL,
 `bytes_total` int(11) DEFAULT NULL,
 `bytes_sec` int(11) DEFAULT NULL,
 `bytes_sec_interval` int(11) DEFAULT NULL,
 `warmup_time` int(11) DEFAULT NULL,
 `warmup_bytes` int(11) DEFAULT NULL,
 `sequence` int(11) DEFAULT NULL,
 `threads` int(11) DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;
--
-- Table structure for table `curr_netusage`
--
DROP TABLE IF EXISTS `curr_netusage`;
CREATE TABLE `curr_netusage` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `wan_rx_bytes` bigint(20) DEFAULT NULL,
 `wan_tx_bytes` bigint(20) DEFAULT NULL,
 `sk_rx_bytes` bigint(20) DEFAULT NULL,
 `sk_tx_bytes` bigint(20) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;
--
-- Table structure for table `curr_ping`
--
DROP TABLE IF EXISTS `curr_ping`;
CREATE TABLE `curr_ping` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `target` varchar(100) DEFAULT NULL,
 `rtt_avg` int(11) DEFAULT NULL,
 `rtt_min` int(11) DEFAULT NULL,
 `rtt_max` int(11) DEFAULT NULL,
 `rtt_std` int(11) DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;
--
-- Table structure for table `curr_ping6`
--
DROP TABLE IF EXISTS `curr_ping6`;
CREATE TABLE `curr_ping6` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `target` varchar(100) DEFAULT NULL,
 `rtt_avg` int(11) DEFAULT NULL,
 `rtt_min` int(11) DEFAULT NULL,
 `rtt_max` int(11) DEFAULT NULL,
 `rtt_std` int(11) DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;
--
-- Table structure for table `curr_udpjitter`
--
DROP TABLE IF EXISTS `curr_udpjitter`;
CREATE TABLE `curr_udpjitter` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `target` varchar(100) DEFAULT NULL,
 `packet_size` int(11) DEFAULT NULL,
 `stream_rate` int(11) DEFAULT NULL,
 `duration` int(11) DEFAULT NULL,
 `packets_up_sent` int(11) DEFAULT NULL,
 `packets_down_sent` int(11) DEFAULT NULL,
 `packets_up_recv` int(11) DEFAULT NULL,
 `packets_down_recv` int(11) DEFAULT NULL,
 `jitter_up` int(11) DEFAULT NULL,
 `jitter_down` int(11) DEFAULT NULL,
 `latency` int(11) DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;
--
-- Table structure for table `curr_udplatency`
--
DROP TABLE IF EXISTS `curr_udplatency`;
CREATE TABLE `curr_udplatency` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `target` varchar(100) DEFAULT NULL,
 `rtt_avg` int(11) DEFAULT NULL,
 `rtt_min` int(11) DEFAULT NULL,
 `rtt_max` int(11) DEFAULT NULL,
 `rtt_std` int(11) DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;
--
-- Table structure for table `curr_ulping`
--
DROP TABLE IF EXISTS `curr_ulping`;
CREATE TABLE `curr_ulping` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `target` varchar(100) DEFAULT NULL,
 `rtt_avg` int(11) DEFAULT NULL,
 `rtt_min` int(11) DEFAULT NULL,
 `rtt_max` int(11) DEFAULT NULL,
 `rtt_std` int(11) DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;
--
-- Table structure for table `curr_videostream`
--
DROP TABLE IF EXISTS `curr_videostream`;
CREATE TABLE `curr_videostream` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `target` varchar(100) DEFAULT NULL,
 `downthrpt` int(11) DEFAULT NULL,
 `downjitter` int(11) DEFAULT NULL,
 `latency` int(11) DEFAULT NULL,
 `jitter` int(11) DEFAULT NULL,
 `buffer_underruns` int(11) DEFAULT NULL,
 `buffer_delay` int(11) DEFAULT NULL,
 `buffer_filltime` int(11) DEFAULT NULL,
 `duration` int(11) DEFAULT NULL,
 `bitrate` int(11) DEFAULT NULL,
 `buffer_size` int(11) DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;
--
-- Table structure for table `curr_webget`
--
DROP TABLE IF EXISTS `curr_webget`;
CREATE TABLE `curr_webget` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `target` varchar(200) DEFAULT NULL,
 `fetch_time` int(11) DEFAULT NULL,
 `bytes_total` int(11) DEFAULT NULL,
 `bytes_sec` int(11) DEFAULT NULL,
 `objects` int(11) DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;
--
-- Table structure for table `curr_webgetobjects`
--
DROP TABLE IF EXISTS `curr_webgetobjects`;
CREATE TABLE `curr_webgetobjects` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `referrer` varchar(200) DEFAULT NULL,
 `target` varchar(1024) DEFAULT NULL,
 `fetch_time` int(11) DEFAULT NULL,
 `bytes_total` int(11) DEFAULT NULL,
 `bytes_sec` int(11) DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;
--
-- Table structure for table `curr_www`
--
DROP TABLE IF EXISTS `curr_www`;
CREATE TABLE `curr_www` (
 `unit_id` int(11) DEFAULT NULL,
 `dtime` datetime DEFAULT NULL,
 `target` varchar(200) DEFAULT NULL,
 `fetch_time` int(11) DEFAULT NULL,
 `bytes_total` int(11) DEFAULT NULL,
 `bytes_sec` int(11) DEFAULT NULL,
 `successes` smallint(5) DEFAULT NULL,
 `failures` smallint(5) DEFAULT NULL,
 `location_id` int(11) DEFAULT NULL
) ;

close
FCC

You are leaving the FCC website

You are about to leave the FCC website and visit a third-party, non-governmental website that the FCC does not maintain or control. The FCC does not endorse any product or service, and is not responsible for, nor can it guarantee the validity or timeliness of the content on the page you are about to visit. Additionally, the privacy policies of this third-party page may differ from those of the FCC.