Postgresql Table Instantiation Sample - Measuring Broadband America Data April 2012

-- 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
) ;