-- phpMyAdmin SQL Dump
-- version 2.11.11.3
-- https://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 03. August 2012 um 17:31
-- Server Version: 5.0.95
-- PHP-Version: 5.1.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Datenbank: `wviewDB`
--

USE wviewDB;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `archive`
--

CREATE TABLE IF NOT EXISTS `archive` (
  `dateTime` int(11) NOT NULL,
  `usUnits` int(11) NOT NULL,
  `arcInt` int(11) NOT NULL,
  `barometer` double default NULL,
  `pressure` double default NULL,
  `altimeter` double default NULL,
  `inTemp` double default NULL,
  `outTemp` double default NULL,
  `inHumidity` double default NULL,
  `outHumidity` double default NULL,
  `windSpeed` double default NULL,
  `windDir` double default NULL,
  `windGust` double default NULL,
  `windGustDir` double default NULL,
  `rainRate` double default NULL,
  `rain` double default NULL,
  `dewpoint` double default NULL,
  `windchill` double default NULL,
  `heatindex` double default NULL,
  `ET` double default NULL,
  `radiation` double default NULL,
  `UV` double default NULL,
  `extraTemp1` double default NULL,
  `extraTemp2` double default NULL,
  `extraTemp3` double default NULL,
  `soilTemp1` double default NULL,
  `soilTemp2` double default NULL,
  `soilTemp3` double default NULL,
  `soilTemp4` double default NULL,
  `leafTemp1` double default NULL,
  `leafTemp2` double default NULL,
  `extraHumid1` double default NULL,
  `extraHumid2` double default NULL,
  `soilMoist1` double default NULL,
  `soilMoist2` double default NULL,
  `soilMoist3` double default NULL,
  `soilMoist4` double default NULL,
  `leafWet1` double default NULL,
  `leafWet2` double default NULL,
  `rxCheckPercent` double default NULL,
  `txBatteryStatus` double default NULL,
  `consBatteryVoltage` double default NULL,
  `hail` double default NULL,
  `hailRate` double default NULL,
  `heatingTemp` double default NULL,
  `heatingVoltage` double default NULL,
  `supplyVoltage` double default NULL,
  `referenceVoltage` double default NULL,
  `windBatteryStatus` double default NULL,
  `rainBatteryStatus` double default NULL,
  `outTempBatteryStatus` double default NULL,
  `inTempBatteryStatus` double default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `baromPressure`
--

CREATE TABLE IF NOT EXISTS `baromPressure` (
  `dateTime` int(11) NOT NULL,
  `low` double default NULL,
  `timeLow` int(11) default NULL,
  `high` double default NULL,
  `timeHigh` int(11) default NULL,
  `whenHigh` double default NULL,
  `cumulative` double default NULL,
  `samples` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `dewPoint`
--

CREATE TABLE IF NOT EXISTS `dewPoint` (
  `dateTime` int(11) NOT NULL,
  `low` double default NULL,
  `timeLow` int(11) default NULL,
  `high` double default NULL,
  `timeHigh` int(11) default NULL,
  `whenHigh` double default NULL,
  `cumulative` double default NULL,
  `samples` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ET`
--

CREATE TABLE IF NOT EXISTS `ET` (
  `dateTime` int(11) NOT NULL,
  `low` double default NULL,
  `timeLow` int(11) default NULL,
  `high` double default NULL,
  `timeHigh` int(11) default NULL,
  `whenHigh` double default NULL,
  `cumulative` double default NULL,
  `samples` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `hail`
--

CREATE TABLE IF NOT EXISTS `hail` (
  `dateTime` int(11) NOT NULL,
  `low` double default NULL,
  `timeLow` int(11) default NULL,
  `high` double default NULL,
  `timeHigh` int(11) default NULL,
  `whenHigh` double default NULL,
  `cumulative` double default NULL,
  `samples` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `hailRate`
--

CREATE TABLE IF NOT EXISTS `hailRate` (
  `dateTime` int(11) NOT NULL,
  `low` double default NULL,
  `timeLow` int(11) default NULL,
  `high` double default NULL,
  `timeHigh` int(11) default NULL,
  `whenHigh` double default NULL,
  `cumulative` double default NULL,
  `samples` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `heatIndex`
--

CREATE TABLE IF NOT EXISTS `heatIndex` (
  `dateTime` int(11) NOT NULL,
  `low` double default NULL,
  `timeLow` int(11) default NULL,
  `high` double default NULL,
  `timeHigh` int(11) default NULL,
  `whenHigh` double default NULL,
  `cumulative` double default NULL,
  `samples` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `inHumidity`
--

CREATE TABLE IF NOT EXISTS `inHumidity` (
  `dateTime` int(11) NOT NULL,
  `low` double default NULL,
  `timeLow` int(11) default NULL,
  `high` double default NULL,
  `timeHigh` int(11) default NULL,
  `whenHigh` double default NULL,
  `cumulative` double default NULL,
  `samples` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `inTemp`
--

CREATE TABLE IF NOT EXISTS `inTemp` (
  `dateTime` int(11) NOT NULL,
  `low` double default NULL,
  `timeLow` int(11) default NULL,
  `high` double default NULL,
  `timeHigh` int(11) default NULL,
  `whenHigh` double default NULL,
  `cumulative` double default NULL,
  `samples` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `noaaHistory`
--

CREATE TABLE IF NOT EXISTS `noaaHistory` (
  `dateTime` int(11) NOT NULL,
  `meanTemp` double default NULL,
  `highTemp` double default NULL,
  `highTempTime` int(11) default NULL,
  `lowTemp` double default NULL,
  `lowTempTime` int(11) default NULL,
  `heatDegDays` double default NULL,
  `coolDegDays` double default NULL,
  `rain` double default NULL,
  `avgWind` double default NULL,
  `highWind` double default NULL,
  `highWindTime` int(11) default NULL,
  `domWindDir` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `outHumidity`
--

CREATE TABLE IF NOT EXISTS `outHumidity` (
  `dateTime` int(11) NOT NULL,
  `low` double default NULL,
  `timeLow` int(11) default NULL,
  `high` double default NULL,
  `timeHigh` int(11) default NULL,
  `whenHigh` double default NULL,
  `cumulative` double default NULL,
  `samples` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `outTemp`
--

CREATE TABLE IF NOT EXISTS `outTemp` (
  `dateTime` int(11) NOT NULL,
  `low` double default NULL,
  `timeLow` int(11) default NULL,
  `high` double default NULL,
  `timeHigh` int(11) default NULL,
  `whenHigh` double default NULL,
  `cumulative` double default NULL,
  `samples` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `rain`
--

CREATE TABLE IF NOT EXISTS `rain` (
  `dateTime` int(11) NOT NULL,
  `low` double default NULL,
  `timeLow` int(11) default NULL,
  `high` double default NULL,
  `timeHigh` int(11) default NULL,
  `whenHigh` double default NULL,
  `cumulative` double default NULL,
  `samples` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `rainRate`
--

CREATE TABLE IF NOT EXISTS `rainRate` (
  `dateTime` int(11) NOT NULL,
  `low` double default NULL,
  `timeLow` int(11) default NULL,
  `high` double default NULL,
  `timeHigh` int(11) default NULL,
  `whenHigh` double default NULL,
  `cumulative` double default NULL,
  `samples` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `solarRadiation`
--

CREATE TABLE IF NOT EXISTS `solarRadiation` (
  `dateTime` int(11) NOT NULL,
  `low` double default NULL,
  `timeLow` int(11) default NULL,
  `high` double default NULL,
  `timeHigh` int(11) default NULL,
  `whenHigh` double default NULL,
  `cumulative` double default NULL,
  `samples` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `UV`
--

CREATE TABLE IF NOT EXISTS `UV` (
  `dateTime` int(11) NOT NULL,
  `low` double default NULL,
  `timeLow` int(11) default NULL,
  `high` double default NULL,
  `timeHigh` int(11) default NULL,
  `whenHigh` double default NULL,
  `cumulative` double default NULL,
  `samples` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `windChill`
--

CREATE TABLE IF NOT EXISTS `windChill` (
  `dateTime` int(11) NOT NULL,
  `low` double default NULL,
  `timeLow` int(11) default NULL,
  `high` double default NULL,
  `timeHigh` int(11) default NULL,
  `whenHigh` double default NULL,
  `cumulative` double default NULL,
  `samples` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `windDir`
--

CREATE TABLE IF NOT EXISTS `windDir` (
  `dateTime` int(11) NOT NULL,
  `bin0` int(11) default NULL,
  `bin1` int(11) default NULL,
  `bin2` int(11) default NULL,
  `bin3` int(11) default NULL,
  `bin4` int(11) default NULL,
  `bin5` int(11) default NULL,
  `bin6` int(11) default NULL,
  `bin7` int(11) default NULL,
  `bin8` int(11) default NULL,
  `bin9` int(11) default NULL,
  `bin10` int(11) default NULL,
  `bin11` int(11) default NULL,
  `bin12` int(11) default NULL,
  `bin13` int(11) default NULL,
  `bin14` int(11) default NULL,
  `bin15` int(11) default NULL,
  `bin16` int(11) default NULL,
  `bin17` int(11) default NULL,
  `bin18` int(11) default NULL,
  `bin19` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `windGust`
--

CREATE TABLE IF NOT EXISTS `windGust` (
  `dateTime` int(11) NOT NULL,
  `low` double default NULL,
  `timeLow` int(11) default NULL,
  `high` double default NULL,
  `timeHigh` int(11) default NULL,
  `whenHigh` double default NULL,
  `cumulative` double default NULL,
  `samples` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `windSpeed`
--

CREATE TABLE IF NOT EXISTS `windSpeed` (
  `dateTime` int(11) NOT NULL,
  `low` double default NULL,
  `timeLow` int(11) default NULL,
  `high` double default NULL,
  `timeHigh` int(11) default NULL,
  `whenHigh` double default NULL,
  `cumulative` double default NULL,
  `samples` int(11) default NULL,
  PRIMARY KEY  (`dateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;