Mysql Table Instantiation Sample - Measuring Broadband America Data April 2012

-- MySQL-Table-Script.sql

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

CREATE TABLE `d7_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 `d7_curr_availfail`
--
DROP TABLE IF EXISTS `d7_curr_availfail`;
CREATE TABLE `d7_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 `d7_curr_dlping`
--
DROP TABLE IF EXISTS `d7_curr_dlping`;
CREATE TABLE `d7_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 `d7_curr_dns`
--
DROP TABLE IF EXISTS `d7_curr_dns`;
CREATE TABLE `d7_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 `d7_curr_httpget`
--
DROP TABLE IF EXISTS `d7_curr_httpget`;
CREATE TABLE `d7_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 `d7_curr_httpgetmt`
--
DROP TABLE IF EXISTS `d7_curr_httpgetmt`;
CREATE TABLE `d7_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 `d7_curr_httpgetmt6`
--
DROP TABLE IF EXISTS `d7_curr_httpgetmt6`;
CREATE TABLE `d7_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 `d7_curr_httppost`
--
DROP TABLE IF EXISTS `d7_curr_httppost`;
CREATE TABLE `d7_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 `d7_curr_httppostmt`
--
DROP TABLE IF EXISTS `d7_curr_httppostmt`;
CREATE TABLE `d7_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 `d7_curr_httppostmt6`
--
DROP TABLE IF EXISTS `d7_curr_httppostmt6`;
CREATE TABLE `d7_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 `d7_curr_netusage`
--
DROP TABLE IF EXISTS `d7_curr_netusage`;
CREATE TABLE `d7_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 `d7_curr_ping`
--
DROP TABLE IF EXISTS `d7_curr_ping`;
CREATE TABLE `d7_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 `d7_curr_ping6`
--
DROP TABLE IF EXISTS `d7_curr_ping6`;
CREATE TABLE `d7_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 `d7_curr_udpjitter`
--
DROP TABLE IF EXISTS `d7_curr_udpjitter`;
CREATE TABLE `d7_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 `d7_curr_udplatency`
--
DROP TABLE IF EXISTS `d7_curr_udplatency`;
CREATE TABLE `d7_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 `d7_curr_ulping`
--
DROP TABLE IF EXISTS `d7_curr_ulping`;
CREATE TABLE `d7_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 `d7_curr_videostream`
--
DROP TABLE IF EXISTS `d7_curr_videostream`;
CREATE TABLE `d7_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 `d7_curr_webget`
--
DROP TABLE IF EXISTS `d7_curr_webget`;
CREATE TABLE `d7_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 `d7_curr_webgetobjects`
--
DROP TABLE IF EXISTS `d7_curr_webgetobjects`;
CREATE TABLE `d7_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 `d7_curr_www`
--
DROP TABLE IF EXISTS `d7_curr_www`;
CREATE TABLE `d7_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
) ;