CREATE DATABASE  IF NOT EXISTS `smear` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `smear`;
-- MySQL dump 10.13  Distrib 5.5.16, for Win32 (x86)
--
-- Host: db5.csc.fi    Database: smear
-- ------------------------------------------------------
-- Server version	5.5.24-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `ERO_EDDY`
--

DROP TABLE IF EXISTS `ERO_EDDY`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ERO_EDDY` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `H` double DEFAULT NULL,
  `H_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_H` int(11) DEFAULT NULL,
  `Qc_H_EMEP` tinyint(4) DEFAULT NULL,
  `LE` double DEFAULT NULL,
  `LE_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_LE` int(11) DEFAULT NULL,
  `Qc_LE_EMEP` tinyint(4) DEFAULT NULL,
  `E` double DEFAULT NULL,
  `E_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_E` int(11) DEFAULT NULL,
  `Qc_E_EMEP` tinyint(4) DEFAULT NULL,
  `F_c` double DEFAULT NULL,
  `F_c_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_F_c` int(11) DEFAULT NULL,
  `Qc_F_c_EMEP` tinyint(4) DEFAULT NULL,
  `tau` double DEFAULT NULL,
  `tau_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_tau` int(11) DEFAULT NULL,
  `Qc_tau_EMEP` tinyint(4) DEFAULT NULL,
  `u_star` double DEFAULT NULL,
  `u_star_EMEP` tinyint(4) DEFAULT NULL,
  `MO_length` double DEFAULT NULL,
  `MO_length_EMEP` tinyint(4) DEFAULT NULL,
  `std_u` double DEFAULT NULL,
  `std_u_EMEP` tinyint(4) DEFAULT NULL,
  `std_v` double DEFAULT NULL,
  `std_v_EMEP` tinyint(4) DEFAULT NULL,
  `std_w` double DEFAULT NULL,
  `std_w_EMEP` tinyint(4) DEFAULT NULL,
  `std_t` double DEFAULT NULL,
  `std_t_EMEP` tinyint(4) DEFAULT NULL,
  `std_c` double DEFAULT NULL,
  `std_c_EMEP` tinyint(4) DEFAULT NULL,
  `std_h` double DEFAULT NULL,
  `std_h_EMEP` tinyint(4) DEFAULT NULL,
  `av_u` double DEFAULT NULL,
  `av_u_EMEP` tinyint(4) DEFAULT NULL,
  `av_v` double DEFAULT NULL,
  `av_v_EMEP` tinyint(4) DEFAULT NULL,
  `av_w` double DEFAULT NULL,
  `av_w_EMEP` tinyint(4) DEFAULT NULL,
  `av_t` double DEFAULT NULL,
  `av_t_EMEP` tinyint(4) DEFAULT NULL,
  `av_c` double DEFAULT NULL,
  `av_c_EMEP` tinyint(4) DEFAULT NULL,
  `av_h` double DEFAULT NULL,
  `av_h_EMEP` tinyint(4) DEFAULT NULL,
  `U` double DEFAULT NULL,
  `U_EMEP` tinyint(4) DEFAULT NULL,
  `wind_dir` double DEFAULT NULL,
  `wind_dir_EMEP` tinyint(4) DEFAULT NULL,
  `eta` double DEFAULT NULL,
  `eta_EMEP` tinyint(4) DEFAULT NULL,
  `theta` double DEFAULT NULL,
  `theta_EMEP` tinyint(4) DEFAULT NULL,
  `beta` double DEFAULT NULL,
  `beta_EMEP` tinyint(4) DEFAULT NULL,
  `c_lag` double DEFAULT NULL,
  `c_lag_EMEP` tinyint(4) DEFAULT NULL,
  `h_lag` double DEFAULT NULL,
  `h_lag_EMEP` tinyint(4) DEFAULT NULL,
  `err_packet` double DEFAULT NULL,
  `err_packet_EMEP` tinyint(4) DEFAULT NULL,
  `licor_t_std` double DEFAULT NULL,
  `licor_t_std_EMEP` tinyint(4) DEFAULT NULL,
  `licor_t_av` double DEFAULT NULL,
  `licor_t_av_EMEP` tinyint(4) DEFAULT NULL,
  `licor_p_std` double DEFAULT NULL,
  `licor_p_std_EMEP` tinyint(4) DEFAULT NULL,
  `licor_p_av` double DEFAULT NULL,
  `licor_p_av_EMEP` tinyint(4) DEFAULT NULL,
  `LE_op` double DEFAULT NULL,
  `LE_op_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_LE_op` int(11) DEFAULT NULL,
  `Qc_LE_op_EMEP` tinyint(4) DEFAULT NULL,
  `E_op` double DEFAULT NULL,
  `E_op_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_E_op` int(11) DEFAULT NULL,
  `Qc_E_op_EMEP` tinyint(4) DEFAULT NULL,
  `F_c_op` double DEFAULT NULL,
  `F_c_op_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_F_c_op` int(11) DEFAULT NULL,
  `Qc_F_c_op_EMEP` tinyint(4) DEFAULT NULL,
  `std_c_op` double DEFAULT NULL,
  `std_c_op_EMEP` tinyint(4) DEFAULT NULL,
  `std_h_op` double DEFAULT NULL,
  `std_h_op_EMEP` tinyint(4) DEFAULT NULL,
  `av_c_op` double DEFAULT NULL,
  `av_c_op_EMEP` tinyint(4) DEFAULT NULL,
  `av_h_op` double DEFAULT NULL,
  `av_h_op_EMEP` tinyint(4) DEFAULT NULL,
  `c_lag_op` double DEFAULT NULL,
  `c_lag_op_EMEP` tinyint(4) DEFAULT NULL,
  `h_lag_op` double DEFAULT NULL,
  `h_lag_op_EMEP` tinyint(4) DEFAULT NULL,
  `F_CPC` double DEFAULT NULL,
  `F_CPC_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_F_CPC` int(11) DEFAULT NULL,
  `Qc_F_CPC_EMEP` tinyint(4) DEFAULT NULL,
  `std_CPC` double DEFAULT NULL,
  `std_CPC_EMEP` tinyint(4) DEFAULT NULL,
  `av_CPC` double DEFAULT NULL,
  `av_CPC_EMEP` tinyint(4) DEFAULT NULL,
  `CPC_lag` double DEFAULT NULL,
  `CPC_lag_EMEP` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `Events`
--

DROP TABLE IF EXISTS `Events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Events` (
  `eventID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(30) NOT NULL COMMENT 'Lack, Processing, Change',
  `event` varchar(1024) NOT NULL,
  `who` varchar(45) NOT NULL,
  `period_start` datetime NOT NULL,
  `period_end` datetime DEFAULT NULL,
  `etimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`eventID`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `HYY_DMPS`
--

DROP TABLE IF EXISTS `HYY_DMPS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `HYY_DMPS` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `t1` float DEFAULT NULL,
  `t2` float DEFAULT NULL,
  `p1` float DEFAULT NULL,
  `p2` float DEFAULT NULL,
  `rh1` float DEFAULT NULL,
  `rh2` float DEFAULT NULL,
  `d100e1` float DEFAULT NULL,
  `d112e1` float DEFAULT NULL,
  `d126e1` float DEFAULT NULL,
  `d141e1` float DEFAULT NULL,
  `d158e1` float DEFAULT NULL,
  `d178e1` float DEFAULT NULL,
  `d200e1` float DEFAULT NULL,
  `d224e1` float DEFAULT NULL,
  `d251e1` float DEFAULT NULL,
  `d282e1` float DEFAULT NULL,
  `d316e1` float DEFAULT NULL,
  `d355e1` float DEFAULT NULL,
  `d398e1` float DEFAULT NULL,
  `d447e1` float DEFAULT NULL,
  `d501e1` float DEFAULT NULL,
  `d562e1` float DEFAULT NULL,
  `d631e1` float DEFAULT NULL,
  `d708e1` float DEFAULT NULL,
  `d794e1` float DEFAULT NULL,
  `d891e1` float DEFAULT NULL,
  `d100e2` float DEFAULT NULL,
  `d112e2` float DEFAULT NULL,
  `d126e2` float DEFAULT NULL,
  `d141e2` float DEFAULT NULL,
  `d158e2` float DEFAULT NULL,
  `d178e2` float DEFAULT NULL,
  `d200e2` float DEFAULT NULL,
  `d224e2` float DEFAULT NULL,
  `d251e2` float DEFAULT NULL,
  `d282e2` float DEFAULT NULL,
  `d316e2` float DEFAULT NULL,
  `d355e2` float DEFAULT NULL,
  `d398e2` float DEFAULT NULL,
  `d447e2` float DEFAULT NULL,
  `d501e2` float DEFAULT NULL,
  `d562e2` float DEFAULT NULL,
  `d631e2` float DEFAULT NULL,
  `d708e2` float DEFAULT NULL,
  `d794e2` float DEFAULT NULL,
  `d891e2` float DEFAULT NULL,
  `d100e3` float DEFAULT NULL,
  `d112e3` float DEFAULT NULL,
  `d126e3` float DEFAULT NULL,
  `d141e3` float DEFAULT NULL,
  `d158e3` float DEFAULT NULL,
  `d178e3` float DEFAULT NULL,
  `d200e3` float DEFAULT NULL,
  `d224e3` float DEFAULT NULL,
  `d251e3` float DEFAULT NULL,
  `d282e3` float DEFAULT NULL,
  `d316e3` float DEFAULT NULL,
  `d355e3` float DEFAULT NULL,
  `d398e3` float DEFAULT NULL,
  `d447e3` float DEFAULT NULL,
  `d501e3` float DEFAULT NULL,
  `d562e3` float DEFAULT NULL,
  `d631e3` float DEFAULT NULL,
  `d708e3` float DEFAULT NULL,
  `d794e3` float DEFAULT NULL,
  `d891e3` float DEFAULT NULL,
  `d100e4` float DEFAULT NULL,
  `tconc` float DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Hyytiala DMPS data';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `HYY_EDDY233`
--

DROP TABLE IF EXISTS `HYY_EDDY233`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `HYY_EDDY233` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `H` double DEFAULT NULL,
  `LE` double DEFAULT NULL,
  `E` double DEFAULT NULL,
  `F_c` double DEFAULT NULL,
  `tau` double DEFAULT NULL,
  `u_star` double DEFAULT NULL,
  `MO_length` double DEFAULT NULL,
  `std_u` double DEFAULT NULL,
  `std_v` double DEFAULT NULL,
  `std_w` double DEFAULT NULL,
  `av_u` double DEFAULT NULL,
  `av_v` double DEFAULT NULL,
  `av_w` double DEFAULT NULL,
  `av_t` double DEFAULT NULL,
  `av_c` double DEFAULT NULL,
  `av_h` double DEFAULT NULL,
  `U` double DEFAULT NULL,
  `wind_dir` double DEFAULT NULL,
  `eta` double DEFAULT NULL,
  `theta` double DEFAULT NULL,
  `beta` double DEFAULT NULL,
  `c_lag` int(11) DEFAULT NULL,
  `h_lag` int(11) DEFAULT NULL,
  `err_packet` int(11) DEFAULT NULL,
  `licor_t_av` double DEFAULT NULL,
  `licor_t_std` double DEFAULT NULL,
  `licor_p_av` double DEFAULT NULL,
  `licor_p_std` double DEFAULT NULL,
  `F_CPC` double DEFAULT NULL,
  `std_CPC` double DEFAULT NULL,
  `av_CPC` double DEFAULT NULL,
  `CPC_lag` int(11) DEFAULT NULL,
  `std_t` double DEFAULT NULL,
  `std_c` double DEFAULT NULL,
  `std_h` double DEFAULT NULL,
  `quality` int(11) DEFAULT '0',
  `Qc_H` int(11) DEFAULT NULL,
  `Qc_LE` int(11) DEFAULT NULL,
  `Qc_E` int(11) DEFAULT NULL,
  `Qc_F_c` int(11) DEFAULT NULL,
  `Qc_tau` int(11) DEFAULT NULL,
  `Qc_F_CPC` int(11) DEFAULT NULL,
  `H_EMEP` tinyint(4) DEFAULT NULL,
  `LE_EMEP` tinyint(4) DEFAULT NULL,
  `E_EMEP` tinyint(4) DEFAULT NULL,
  `F_c_EMEP` tinyint(4) DEFAULT NULL,
  `tau_EMEP` tinyint(4) DEFAULT NULL,
  `u_star_EMEP` tinyint(4) DEFAULT NULL,
  `MO_length_EMEP` tinyint(4) DEFAULT NULL,
  `std_u_EMEP` tinyint(4) DEFAULT NULL,
  `std_v_EMEP` tinyint(4) DEFAULT NULL,
  `std_w_EMEP` tinyint(4) DEFAULT NULL,
  `av_u_EMEP` tinyint(4) DEFAULT NULL,
  `av_v_EMEP` tinyint(4) DEFAULT NULL,
  `av_w_EMEP` tinyint(4) DEFAULT NULL,
  `av_t_EMEP` tinyint(4) DEFAULT NULL,
  `av_c_EMEP` tinyint(4) DEFAULT NULL,
  `av_h_EMEP` tinyint(4) DEFAULT NULL,
  `U_EMEP` tinyint(4) DEFAULT NULL,
  `wind_dir_EMEP` tinyint(4) DEFAULT NULL,
  `eta_EMEP` tinyint(4) DEFAULT NULL,
  `theta_EMEP` tinyint(4) DEFAULT NULL,
  `beta_EMEP` tinyint(4) DEFAULT NULL,
  `c_lag_EMEP` tinyint(4) DEFAULT NULL,
  `h_lag_EMEP` tinyint(4) DEFAULT NULL,
  `err_packet_EMEP` tinyint(4) DEFAULT NULL,
  `licor_t_av_EMEP` tinyint(4) DEFAULT NULL,
  `licor_t_std_EMEP` tinyint(4) DEFAULT NULL,
  `licor_p_av_EMEP` tinyint(4) DEFAULT NULL,
  `licor_p_std_EMEP` tinyint(4) DEFAULT NULL,
  `F_CPC_EMEP` tinyint(4) DEFAULT NULL,
  `std_CPC_EMEP` tinyint(4) DEFAULT NULL,
  `av_CPC_EMEP` tinyint(4) DEFAULT NULL,
  `CPC_lag_EMEP` tinyint(4) DEFAULT NULL,
  `std_t_EMEP` tinyint(4) DEFAULT NULL,
  `std_c_EMEP` tinyint(4) DEFAULT NULL,
  `std_h_EMEP` tinyint(4) DEFAULT NULL,
  `quality_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_H_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_LE_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_E_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_F_c_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_tau_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_F_CPC_EMEP` tinyint(4) DEFAULT NULL,
  `NEE` double DEFAULT NULL,
  `Qc_gapf_NEE` int(11) DEFAULT NULL,
  `GPP` double DEFAULT NULL,
  `TER` double DEFAULT NULL,
  `H_gapf` double DEFAULT NULL,
  `Qc_gapf_H` int(11) DEFAULT NULL,
  `ET_gapf` double DEFAULT NULL,
  `Qc_gapf_ET` int(11) DEFAULT NULL,
  `NEE_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_gapf_NEE_EMEP` tinyint(4) DEFAULT NULL,
  `GPP_EMEP` tinyint(4) DEFAULT NULL,
  `TER_EMEP` tinyint(4) DEFAULT NULL,
  `H_gapf_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_gapf_H_EMEP` tinyint(4) DEFAULT NULL,
  `ET_gapf_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_gapf_ET_EMEP` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `HYY_EDDYSUB`
--

DROP TABLE IF EXISTS `HYY_EDDYSUB`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `HYY_EDDYSUB` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `H_subm` double DEFAULT NULL,
  `H_subm_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_H_subm` int(11) DEFAULT NULL,
  `Qc_H_subm_EMEP` tinyint(4) DEFAULT NULL,
  `LE_subm` double DEFAULT NULL,
  `LE_subm_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_LE_subm` int(11) DEFAULT NULL,
  `Qc_LE_subm_EMEP` tinyint(4) DEFAULT NULL,
  `E_subm` double DEFAULT NULL,
  `E_subm_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_E_subm` int(11) DEFAULT NULL,
  `Qc_E_subm_EMEP` tinyint(4) DEFAULT NULL,
  `F_c_subm` double DEFAULT NULL,
  `F_c_subm_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_F_c_subm` int(11) DEFAULT NULL,
  `Qc_F_c_subm_EMEP` tinyint(4) DEFAULT NULL,
  `tau_subm` double DEFAULT NULL,
  `tau_subm_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_tau_subm` int(11) DEFAULT NULL,
  `Qc_tau_subm_EMEP` tinyint(4) DEFAULT NULL,
  `u_star_subm` double DEFAULT NULL,
  `u_star_subm_EMEP` tinyint(4) DEFAULT NULL,
  `MO_length_subm` double DEFAULT NULL,
  `MO_length_subm_EMEP` tinyint(4) DEFAULT NULL,
  `std_u_subm` double DEFAULT NULL,
  `std_u_subm_EMEP` tinyint(4) DEFAULT NULL,
  `std_v_subm` double DEFAULT NULL,
  `std_v_subm_EMEP` tinyint(4) DEFAULT NULL,
  `std_w_subm` double DEFAULT NULL,
  `std_w_subm_EMEP` tinyint(4) DEFAULT NULL,
  `std_t_subm` double DEFAULT NULL,
  `std_t_subm_EMEP` tinyint(4) DEFAULT NULL,
  `std_c_subm` double DEFAULT NULL,
  `std_c_subm_EMEP` tinyint(4) DEFAULT NULL,
  `std_h_subm` double DEFAULT NULL,
  `std_h_subm_EMEP` tinyint(4) DEFAULT NULL,
  `av_u_subm` double DEFAULT NULL,
  `av_u_subm_EMEP` tinyint(4) DEFAULT NULL,
  `av_v_subm` double DEFAULT NULL,
  `av_v_subm_EMEP` tinyint(4) DEFAULT NULL,
  `av_w_subm` double DEFAULT NULL,
  `av_w_subm_EMEP` tinyint(4) DEFAULT NULL,
  `av_t_subm` double DEFAULT NULL,
  `av_t_subm_EMEP` tinyint(4) DEFAULT NULL,
  `av_c_subm` double DEFAULT NULL,
  `av_c_subm_EMEP` tinyint(4) DEFAULT NULL,
  `av_h_subm` double DEFAULT NULL,
  `av_h_subm_EMEP` tinyint(4) DEFAULT NULL,
  `U_subm` double DEFAULT NULL,
  `U_subm_EMEP` tinyint(4) DEFAULT NULL,
  `wind_dir_subm` double DEFAULT NULL,
  `wind_dir_subm_EMEP` tinyint(4) DEFAULT NULL,
  `eta_subm` double DEFAULT NULL,
  `eta_subm_EMEP` tinyint(4) DEFAULT NULL,
  `theta_subm` double DEFAULT NULL,
  `theta_subm_EMEP` tinyint(4) DEFAULT NULL,
  `beta_subm` double DEFAULT NULL,
  `beta_subm_EMEP` tinyint(4) DEFAULT NULL,
  `c_lag_subm` double DEFAULT NULL,
  `c_lag_subm_EMEP` tinyint(4) DEFAULT NULL,
  `h_lag_subm` double DEFAULT NULL,
  `h_lag_subm_EMEP` tinyint(4) DEFAULT NULL,
  `err_packet_subm` double DEFAULT NULL,
  `err_packet_subm_EMEP` tinyint(4) DEFAULT NULL,
  `licor_t_std_subm` double DEFAULT NULL,
  `licor_t_std_subm_EMEP` tinyint(4) DEFAULT NULL,
  `licor_t_av_subm` double DEFAULT NULL,
  `licor_t_av_subm_EMEP` tinyint(4) DEFAULT NULL,
  `licor_p_std_subm` double DEFAULT NULL,
  `licor_p_std_subm_EMEP` tinyint(4) DEFAULT NULL,
  `licor_p_av_subm` double DEFAULT NULL,
  `licor_p_av_subm_EMEP` tinyint(4) DEFAULT NULL,
  `av_O3_subm` double DEFAULT NULL,
  `av_O3_subm_EMEP` tinyint(4) DEFAULT NULL,
  `std_O3_subm` double DEFAULT NULL,
  `std_O3_subm_EMEP` tinyint(4) DEFAULT NULL,
  `O3_lag_subm` double DEFAULT NULL,
  `O3_lag_subm_EMEP` tinyint(4) DEFAULT NULL,
  `F_O3_subm` double DEFAULT NULL,
  `F_O3_subm_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_F_O3_subm` int(11) DEFAULT NULL,
  `Qc_F_O3_subm_EMEP` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `HYY_EDDYTOW`
--

DROP TABLE IF EXISTS `HYY_EDDYTOW`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `HYY_EDDYTOW` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `H_radtow` double DEFAULT NULL,
  `H_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_H_radtow` int(11) DEFAULT NULL,
  `Qc_H_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `LE_radtow` double DEFAULT NULL,
  `LE_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_LE_radtow` int(11) DEFAULT NULL,
  `Qc_LE_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `E_radtow` double DEFAULT NULL,
  `E_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_E_radtow` int(11) DEFAULT NULL,
  `Qc_E_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `F_c_radtow` double DEFAULT NULL,
  `F_c_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_F_c_radtow` int(11) DEFAULT NULL,
  `Qc_F_c_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `tau_radtow` double DEFAULT NULL,
  `tau_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_tau_radtow` int(11) DEFAULT NULL,
  `Qc_tau_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `u_star_radtow` double DEFAULT NULL,
  `u_star_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `MO_length_radtow` double DEFAULT NULL,
  `MO_length_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `std_u_radtow` double DEFAULT NULL,
  `std_u_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `std_v_radtow` double DEFAULT NULL,
  `std_v_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `std_w_radtow` double DEFAULT NULL,
  `std_w_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `std_t_radtow` double DEFAULT NULL,
  `std_t_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `std_c_radtow` double DEFAULT NULL,
  `std_c_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `std_h_radtow` double DEFAULT NULL,
  `std_h_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `av_u_radtow` double DEFAULT NULL,
  `av_u_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `av_v_radtow` double DEFAULT NULL,
  `av_v_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `av_w_radtow` double DEFAULT NULL,
  `av_w_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `av_t_radtow` double DEFAULT NULL,
  `av_t_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `av_c_radtow` double DEFAULT NULL,
  `av_c_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `av_h_radtow` double DEFAULT NULL,
  `av_h_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `U_radtow` double DEFAULT NULL,
  `U_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `wind_dir_radtow` double DEFAULT NULL,
  `wind_dir_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `eta_radtow` double DEFAULT NULL,
  `eta_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `theta_radtow` double DEFAULT NULL,
  `theta_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `beta_radtow` double DEFAULT NULL,
  `beta_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `c_lag_radtow` double DEFAULT NULL,
  `c_lag_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `h_lag_radtow` double DEFAULT NULL,
  `h_lag_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `err_packet_radtow` double DEFAULT NULL,
  `err_packet_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `licor_t_std_radtow` double DEFAULT NULL,
  `licor_t_std_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `licor_t_av_radtow` double DEFAULT NULL,
  `licor_t_av_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `licor_p_std_radtow` double DEFAULT NULL,
  `licor_p_std_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `licor_p_av_radtow` double DEFAULT NULL,
  `licor_p_av_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `F_O3_radtow` double DEFAULT NULL,
  `F_O3_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_F_O3_radtow` int(11) DEFAULT NULL,
  `Qc_F_O3_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `std_O3_radtow` double DEFAULT NULL,
  `std_O3_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `av_O3_radtow` double DEFAULT NULL,
  `av_O3_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `O3_lag_radtow` double DEFAULT NULL,
  `O3_lag_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `NEE_radtow` double DEFAULT NULL,
  `NEE_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_gapf_NEE_radtow` int(11) DEFAULT NULL,
  `Qc_gapf_NEE_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `GPP_radtow` double DEFAULT NULL,
  `GPP_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `TER_radtow` double DEFAULT NULL,
  `TER_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `F_COS_radtow` double DEFAULT NULL,
  `F_COS_radtow_EMEP` tinyint(4) DEFAULT NULL,
  `av_COS_radtow` double DEFAULT NULL,
  `av_COS_radtow_EMEP` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `HYY_META`
--

DROP TABLE IF EXISTS `HYY_META`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `HYY_META` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `UV_A` double DEFAULT NULL,
  `UV_B` double DEFAULT NULL,
  `diffPAR` double DEFAULT NULL,
  `diffGLOB` double DEFAULT NULL,
  `dirGLOB` double DEFAULT NULL,
  `Net` double DEFAULT NULL,
  `RGlob` double DEFAULT NULL,
  `Glob` double DEFAULT NULL,
  `RPAR` double DEFAULT NULL,
  `PAR` double DEFAULT NULL,
  `dirPAR` double DEFAULT NULL,
  `canIR` double DEFAULT NULL,
  `skyIR` double DEFAULT NULL,
  `Precip` double DEFAULT NULL,
  `SWS` double DEFAULT NULL,
  `Td` double DEFAULT NULL,
  `Pamb0` double DEFAULT NULL,
  `T672` double DEFAULT NULL,
  `T504` double DEFAULT NULL,
  `T336` double DEFAULT NULL,
  `T168` double DEFAULT NULL,
  `T84` double DEFAULT NULL,
  `T42` double DEFAULT NULL,
  `WS672` double DEFAULT NULL,
  `WS504` double DEFAULT NULL,
  `WS336` double DEFAULT NULL,
  `WS168` double DEFAULT NULL,
  `WS84` double DEFAULT NULL,
  `WS42` double DEFAULT NULL,
  `WSU740` double DEFAULT NULL,
  `WSU336` double DEFAULT NULL,
  `WSU168` double DEFAULT NULL,
  `WSU84` double DEFAULT NULL,
  `WD` double DEFAULT NULL,
  `WD504` double DEFAULT NULL,
  `WD336` double DEFAULT NULL,
  `WD168` double DEFAULT NULL,
  `WDU740` double DEFAULT NULL,
  `WDU336` double DEFAULT NULL,
  `WDU168` double DEFAULT NULL,
  `WDU84` double DEFAULT NULL,
  `NO672` double DEFAULT NULL,
  `NO504` double DEFAULT NULL,
  `NO336` double DEFAULT NULL,
  `NO168` double DEFAULT NULL,
  `NO84` double DEFAULT NULL,
  `NO42` double DEFAULT NULL,
  `NOx672` double DEFAULT NULL,
  `NOx504` double DEFAULT NULL,
  `NOx336` double DEFAULT NULL,
  `NOx168` double DEFAULT NULL,
  `NOx84` double DEFAULT NULL,
  `NOx42` double DEFAULT NULL,
  `O3672` double DEFAULT NULL,
  `O3504` double DEFAULT NULL,
  `O3336` double DEFAULT NULL,
  `O3168` double DEFAULT NULL,
  `O384` double DEFAULT NULL,
  `O342` double DEFAULT NULL,
  `SO2672` double DEFAULT NULL,
  `SO2504` double DEFAULT NULL,
  `SO2336` double DEFAULT NULL,
  `SO2168` double DEFAULT NULL,
  `SO284` double DEFAULT NULL,
  `SO242` double DEFAULT NULL,
  `H2O672` double DEFAULT NULL,
  `H2O504` double DEFAULT NULL,
  `H2O336` double DEFAULT NULL,
  `H2O168` double DEFAULT NULL,
  `H2O84` double DEFAULT NULL,
  `H2O42` double DEFAULT NULL,
  `CO2672` double DEFAULT NULL,
  `CO2504` double DEFAULT NULL,
  `CO2336` double DEFAULT NULL,
  `CO2168` double DEFAULT NULL,
  `CO284` double DEFAULT NULL,
  `CO242` double DEFAULT NULL,
  `H2S672` double DEFAULT NULL,
  `H2S504` double DEFAULT NULL,
  `H2S336` double DEFAULT NULL,
  `H2S168` double DEFAULT NULL,
  `H2S84` double DEFAULT NULL,
  `H2S42` double DEFAULT NULL,
  `RHIRGA672` double DEFAULT NULL,
  `RHIRGA504` double DEFAULT NULL,
  `RHIRGA336` double DEFAULT NULL,
  `RHIRGA168` double DEFAULT NULL,
  `RHIRGA84` double DEFAULT NULL,
  `RHIRGA42` double DEFAULT NULL,
  `CO672` double DEFAULT NULL,
  `CO504` double DEFAULT NULL,
  `CO336` double DEFAULT NULL,
  `CO168` double DEFAULT NULL,
  `CO84` double DEFAULT NULL,
  `CO42` double DEFAULT NULL,
  `RHTd` double DEFAULT NULL,
  `PTG` double DEFAULT NULL,
  `Visibility` double DEFAULT NULL,
  `Visibilitymin` double DEFAULT NULL,
  `Visibilitymax` double DEFAULT NULL,
  `Precipint` double DEFAULT NULL,
  `Precipintmin` double DEFAULT NULL,
  `Precipintmax` double DEFAULT NULL,
  `Precipacc` double DEFAULT NULL,
  `Snowfallacc` double DEFAULT NULL,
  `wthcode` int(11) DEFAULT NULL,
  `wthcodemin` int(11) DEFAULT NULL,
  `wthcodemax` int(11) DEFAULT NULL,
  `tsoil_humus` double DEFAULT NULL,
  `tsoil_A` double DEFAULT NULL,
  `tsoil_B1` double DEFAULT NULL,
  `tsoil_B2` double DEFAULT NULL,
  `tsoil_C1` double DEFAULT NULL,
  `H2OTd` double DEFAULT NULL,
  `CO2_storage_flux` double DEFAULT NULL,
  `H_storage_flux` double DEFAULT NULL,
  `LE_storage_flux` double DEFAULT NULL,
  `wsoil_humus` double DEFAULT NULL,
  `wsoil_A` double DEFAULT NULL,
  `wsoil_B1` double DEFAULT NULL,
  `wsoil_B2` double DEFAULT NULL,
  `wsoil_C1` double DEFAULT NULL,
  `LWin` double DEFAULT NULL,
  `LWout` double DEFAULT NULL,
  `PRI` double DEFAULT NULL,
  `NDVI` double DEFAULT NULL,
  `bNDVI` double DEFAULT NULL,
  `canPAR1` double DEFAULT NULL,
  `canPAR2` double DEFAULT NULL,
  `canPAR3` double DEFAULT NULL,
  `maaPAR` double DEFAULT NULL,
  `maaNet` double DEFAULT NULL,
  `PAR2` double DEFAULT NULL,
  `Globmast` double DEFAULT NULL,
  `WDU672` double DEFAULT NULL,
  `WSU672` double DEFAULT NULL,
  `RGlob125` double DEFAULT NULL,
  `CH4168` double DEFAULT NULL,
  `CH4672` double DEFAULT NULL,
  `CH41250` double DEFAULT NULL,
  `T1250` double DEFAULT NULL,
  `wpsoil_A` double DEFAULT NULL,
  `wpsoil_B` double DEFAULT NULL,
  `runoff1` double DEFAULT NULL,
  `runoff2` double DEFAULT NULL,
  `drainage1` double DEFAULT NULL,
  `drainage2` double DEFAULT NULL,
  `CO2icos168` double DEFAULT NULL,
  `CO2icos672` double DEFAULT NULL,
  `CO2icos1250` double DEFAULT NULL,
  `H2Oicos168` double DEFAULT NULL,
  `H2Oicos672` double DEFAULT NULL,
  `H2Oicos1250` double DEFAULT NULL,
  `tsoil_humus_EMEP` tinyint(4) DEFAULT NULL,
  `tsoil_A_EMEP` tinyint(4) DEFAULT NULL,
  `tsoil_B1_EMEP` tinyint(4) DEFAULT NULL,
  `tsoil_B2_EMEP` tinyint(4) DEFAULT NULL,
  `tsoil_C1_EMEP` tinyint(4) DEFAULT NULL,
  `wsoil_humus_EMEP` tinyint(4) DEFAULT NULL,
  `wsoil_A_EMEP` tinyint(4) DEFAULT NULL,
  `wsoil_B1_EMEP` tinyint(4) DEFAULT NULL,
  `wsoil_B2_EMEP` tinyint(4) DEFAULT NULL,
  `wsoil_C1_EMEP` tinyint(4) DEFAULT NULL,
  `wpsoil_A_EMEP` tinyint(4) DEFAULT NULL,
  `wpsoil_B_EMEP` tinyint(4) DEFAULT NULL,
  `runoff1_EMEP` tinyint(4) DEFAULT NULL,
  `runoff2_EMEP` tinyint(4) DEFAULT NULL,
  `drainage1_EMEP` tinyint(4) DEFAULT NULL,
  `drainage2_EMEP` tinyint(4) DEFAULT NULL,
  `NO1250` double DEFAULT NULL,
  `NO1010` double DEFAULT NULL,
  `NOx1250` double DEFAULT NULL,
  `NOx1010` double DEFAULT NULL,
  `O31250` double DEFAULT NULL,
  `O31010` double DEFAULT NULL,
  `SO21250` double DEFAULT NULL,
  `SO21010` double DEFAULT NULL,
  `H2O1250` double DEFAULT NULL,
  `H2O1010` double DEFAULT NULL,
  `CO21250` double DEFAULT NULL,
  `CO21010` double DEFAULT NULL,
  `H2S1250` double DEFAULT NULL,
  `H2S1010` double DEFAULT NULL,
  `RHIRGA1250` double DEFAULT NULL,
  `RHIRGA1010` double DEFAULT NULL,
  `CO1250` double DEFAULT NULL,
  `CO1010` double DEFAULT NULL,
  `Td_EMEP` tinyint(4) DEFAULT NULL,
  `Pamb0_EMEP` tinyint(4) DEFAULT NULL,
  `T672_EMEP` tinyint(4) DEFAULT NULL,
  `T504_EMEP` tinyint(4) DEFAULT NULL,
  `T336_EMEP` tinyint(4) DEFAULT NULL,
  `T168_EMEP` tinyint(4) DEFAULT NULL,
  `T84_EMEP` tinyint(4) DEFAULT NULL,
  `T42_EMEP` tinyint(4) DEFAULT NULL,
  `WS672_EMEP` tinyint(4) DEFAULT NULL,
  `WS504_EMEP` tinyint(4) DEFAULT NULL,
  `WS336_EMEP` tinyint(4) DEFAULT NULL,
  `WS168_EMEP` tinyint(4) DEFAULT NULL,
  `WS84_EMEP` tinyint(4) DEFAULT NULL,
  `WS42_EMEP` tinyint(4) DEFAULT NULL,
  `WSU672_EMEP` tinyint(4) DEFAULT NULL,
  `WSU336_EMEP` tinyint(4) DEFAULT NULL,
  `WSU168_EMEP` tinyint(4) DEFAULT NULL,
  `WSU84_EMEP` tinyint(4) DEFAULT NULL,
  `WD_EMEP` tinyint(4) DEFAULT NULL,
  `WD504_EMEP` tinyint(4) DEFAULT NULL,
  `WD336_EMEP` tinyint(4) DEFAULT NULL,
  `WD168_EMEP` tinyint(4) DEFAULT NULL,
  `WDU672_EMEP` tinyint(4) DEFAULT NULL,
  `WDU336_EMEP` tinyint(4) DEFAULT NULL,
  `WDU168_EMEP` tinyint(4) DEFAULT NULL,
  `WDU84_EMEP` tinyint(4) DEFAULT NULL,
  `RHTd_EMEP` tinyint(4) DEFAULT NULL,
  `PTG_EMEP` tinyint(4) DEFAULT NULL,
  `NO1250_EMEP` tinyint(4) DEFAULT NULL,
  `NO1010_EMEP` tinyint(4) DEFAULT NULL,
  `NO672_EMEP` tinyint(4) DEFAULT NULL,
  `NO504_EMEP` tinyint(4) DEFAULT NULL,
  `NO336_EMEP` tinyint(4) DEFAULT NULL,
  `NO168_EMEP` tinyint(4) DEFAULT NULL,
  `NO84_EMEP` tinyint(4) DEFAULT NULL,
  `NO42_EMEP` tinyint(4) DEFAULT NULL,
  `NOx1250_EMEP` tinyint(4) DEFAULT NULL,
  `NOx1010_EMEP` tinyint(4) DEFAULT NULL,
  `NOx672_EMEP` tinyint(4) DEFAULT NULL,
  `NOx504_EMEP` tinyint(4) DEFAULT NULL,
  `NOx336_EMEP` tinyint(4) DEFAULT NULL,
  `NOx168_EMEP` tinyint(4) DEFAULT NULL,
  `NOx84_EMEP` tinyint(4) DEFAULT NULL,
  `NOx42_EMEP` tinyint(4) DEFAULT NULL,
  `O31250_EMEP` tinyint(4) DEFAULT NULL,
  `O31010_EMEP` tinyint(4) DEFAULT NULL,
  `O3672_EMEP` tinyint(4) DEFAULT NULL,
  `O3504_EMEP` tinyint(4) DEFAULT NULL,
  `O3336_EMEP` tinyint(4) DEFAULT NULL,
  `O3168_EMEP` tinyint(4) DEFAULT NULL,
  `O384_EMEP` tinyint(4) DEFAULT NULL,
  `O342_EMEP` tinyint(4) DEFAULT NULL,
  `SO21250_EMEP` tinyint(4) DEFAULT NULL,
  `SO21010_EMEP` tinyint(4) DEFAULT NULL,
  `SO2672_EMEP` tinyint(4) DEFAULT NULL,
  `SO2504_EMEP` tinyint(4) DEFAULT NULL,
  `SO2336_EMEP` tinyint(4) DEFAULT NULL,
  `SO2168_EMEP` tinyint(4) DEFAULT NULL,
  `SO284_EMEP` tinyint(4) DEFAULT NULL,
  `SO242_EMEP` tinyint(4) DEFAULT NULL,
  `H2O1250_EMEP` tinyint(4) DEFAULT NULL,
  `H2O1010_EMEP` tinyint(4) DEFAULT NULL,
  `H2O672_EMEP` tinyint(4) DEFAULT NULL,
  `H2O504_EMEP` tinyint(4) DEFAULT NULL,
  `H2O336_EMEP` tinyint(4) DEFAULT NULL,
  `H2O168_EMEP` tinyint(4) DEFAULT NULL,
  `H2O84_EMEP` tinyint(4) DEFAULT NULL,
  `H2O42_EMEP` tinyint(4) DEFAULT NULL,
  `CO21250_EMEP` tinyint(4) DEFAULT NULL,
  `CO21010_EMEP` tinyint(4) DEFAULT NULL,
  `CO2672_EMEP` tinyint(4) DEFAULT NULL,
  `CO2504_EMEP` tinyint(4) DEFAULT NULL,
  `CO2336_EMEP` tinyint(4) DEFAULT NULL,
  `CO2168_EMEP` tinyint(4) DEFAULT NULL,
  `CO284_EMEP` tinyint(4) DEFAULT NULL,
  `CO242_EMEP` tinyint(4) DEFAULT NULL,
  `H2S1250_EMEP` tinyint(4) DEFAULT NULL,
  `H2S1010_EMEP` tinyint(4) DEFAULT NULL,
  `H2S672_EMEP` tinyint(4) DEFAULT NULL,
  `H2S504_EMEP` tinyint(4) DEFAULT NULL,
  `H2S336_EMEP` tinyint(4) DEFAULT NULL,
  `H2S168_EMEP` tinyint(4) DEFAULT NULL,
  `H2S84_EMEP` tinyint(4) DEFAULT NULL,
  `H2S42_EMEP` tinyint(4) DEFAULT NULL,
  `RHIRGA1250_EMEP` tinyint(4) DEFAULT NULL,
  `RHIRGA1010_EMEP` tinyint(4) DEFAULT NULL,
  `RHIRGA672_EMEP` tinyint(4) DEFAULT NULL,
  `RHIRGA504_EMEP` tinyint(4) DEFAULT NULL,
  `RHIRGA336_EMEP` tinyint(4) DEFAULT NULL,
  `RHIRGA168_EMEP` tinyint(4) DEFAULT NULL,
  `RHIRGA84_EMEP` tinyint(4) DEFAULT NULL,
  `RHIRGA42_EMEP` tinyint(4) DEFAULT NULL,
  `CO1250_EMEP` tinyint(4) DEFAULT NULL,
  `CO1010_EMEP` tinyint(4) DEFAULT NULL,
  `CO672_EMEP` tinyint(4) DEFAULT NULL,
  `CO504_EMEP` tinyint(4) DEFAULT NULL,
  `CO336_EMEP` tinyint(4) DEFAULT NULL,
  `CO168_EMEP` tinyint(4) DEFAULT NULL,
  `CO84_EMEP` tinyint(4) DEFAULT NULL,
  `CO42_EMEP` tinyint(4) DEFAULT NULL,
  `Visibility_EMEP` tinyint(4) DEFAULT NULL,
  `Visibilitymin_EMEP` tinyint(4) DEFAULT NULL,
  `Visibilitymax_EMEP` tinyint(4) DEFAULT NULL,
  `Precipint_EMEP` tinyint(4) DEFAULT NULL,
  `Precipintmin_EMEP` tinyint(4) DEFAULT NULL,
  `Precipintmax_EMEP` tinyint(4) DEFAULT NULL,
  `Precipacc_EMEP` tinyint(4) DEFAULT NULL,
  `Snowfallacc_EMEP` tinyint(4) DEFAULT NULL,
  `wthcode_EMEP` tinyint(4) DEFAULT NULL,
  `wthcodemin_EMEP` tinyint(4) DEFAULT NULL,
  `wthcodemax_EMEP` tinyint(4) DEFAULT NULL,
  `Precip_EMEP` tinyint(4) DEFAULT NULL,
  `SWS_EMEP` tinyint(4) DEFAULT NULL,
  `UV_A_EMEP` tinyint(4) DEFAULT NULL,
  `UV_B_EMEP` tinyint(4) DEFAULT NULL,
  `diffPAR_EMEP` tinyint(4) DEFAULT NULL,
  `diffGLOB_EMEP` tinyint(4) DEFAULT NULL,
  `dirGLOB_EMEP` tinyint(4) DEFAULT NULL,
  `Net_EMEP` tinyint(4) DEFAULT NULL,
  `RGlob_EMEP` tinyint(4) DEFAULT NULL,
  `Glob_EMEP` tinyint(4) DEFAULT NULL,
  `RPAR_EMEP` tinyint(4) DEFAULT NULL,
  `PAR_EMEP` tinyint(4) DEFAULT NULL,
  `dirPAR_EMEP` tinyint(4) DEFAULT NULL,
  `canIR_EMEP` tinyint(4) DEFAULT NULL,
  `PAR2_EMEP` tinyint(4) DEFAULT NULL,
  `LWin_EMEP` tinyint(4) DEFAULT NULL,
  `LWout_EMEP` tinyint(4) DEFAULT NULL,
  `PRI_EMEP` tinyint(4) DEFAULT NULL,
  `NDVI_EMEP` tinyint(4) DEFAULT NULL,
  `bNDVI_EMEP` tinyint(4) DEFAULT NULL,
  `maaPAR_EMEP` tinyint(4) DEFAULT NULL,
  `maaNet_EMEP` tinyint(4) DEFAULT NULL,
  `canPAR1_EMEP` tinyint(4) DEFAULT NULL,
  `canPAR2_EMEP` tinyint(4) DEFAULT NULL,
  `canPAR3_EMEP` tinyint(4) DEFAULT NULL,
  `Globmast_EMEP` tinyint(4) DEFAULT NULL,
  `RGlob125_EMEP` tinyint(4) DEFAULT NULL,
  `RH1250` double DEFAULT NULL,
  `T1010` double DEFAULT NULL,
  `RH1250_EMEP` tinyint(4) DEFAULT NULL,
  `T1250_EMEP` tinyint(4) DEFAULT NULL,
  `T1010_EMEP` tinyint(4) DEFAULT NULL,
  `WSU740_EMEP` tinyint(4) DEFAULT NULL,
  `WDU740_EMEP` tinyint(4) DEFAULT NULL,
  `H2OTd_EMEP` tinyint(4) DEFAULT NULL,
  `CO2_storage_flux_EMEP` tinyint(4) DEFAULT NULL,
  `H_storage_flux_EMEP` tinyint(4) DEFAULT NULL,
  `LE_storage_flux_EMEP` tinyint(4) DEFAULT NULL,
  `RH672` double DEFAULT NULL,
  `Tmm672` double DEFAULT NULL,
  `RH672_EMEP` tinyint(4) DEFAULT NULL,
  `Tmm672_EMEP` tinyint(4) DEFAULT NULL,
  `RH168` double DEFAULT NULL,
  `Tmm168` double DEFAULT NULL,
  `RH168_EMEP` tinyint(4) DEFAULT NULL,
  `Tmm168_EMEP` tinyint(4) DEFAULT NULL,
  `G_sc` double DEFAULT NULL,
  `G_sc_EMEP` tinyint(4) DEFAULT NULL,
  `CH4168_EMEP` tinyint(4) DEFAULT NULL,
  `CH4672_EMEP` tinyint(4) DEFAULT NULL,
  `CH41250_EMEP` tinyint(4) DEFAULT NULL,
  `CO2icos168_EMEP` tinyint(4) DEFAULT NULL,
  `CO2icos672_EMEP` tinyint(4) DEFAULT NULL,
  `CO2icos1250_EMEP` tinyint(4) DEFAULT NULL,
  `H2Oicos168_EMEP` tinyint(4) DEFAULT NULL,
  `H2Oicos672_EMEP` tinyint(4) DEFAULT NULL,
  `H2Oicos1250_EMEP` tinyint(4) DEFAULT NULL,
  `COicos168` double DEFAULT NULL,
  `COicos672` double DEFAULT NULL,
  `COicos1250` double DEFAULT NULL,
  `COicos168_EMEP` tinyint(4) DEFAULT NULL,
  `COicos672_EMEP` tinyint(4) DEFAULT NULL,
  `COicos1250_EMEP` tinyint(4) DEFAULT NULL,
  `Cloud_layer_1` double DEFAULT NULL,
  `Cloud_layer_2` double DEFAULT NULL,
  `Cloud_layer_3` double DEFAULT NULL,
  `CH4_gradient_flux` double DEFAULT NULL,
  `CH4_gradient_flux_EMEP` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `HYY_SLOW`
--

DROP TABLE IF EXISTS `HYY_SLOW`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `HYY_SLOW` (
  `start_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `stop_time` datetime DEFAULT NULL,
  `variable` varchar(45) NOT NULL DEFAULT '',
  `value1` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `HYY_TREE`
--

DROP TABLE IF EXISTS `HYY_TREE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `HYY_TREE` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cuv_no` int(11) NOT NULL DEFAULT '0',
  `F_CO2_stem` double DEFAULT NULL,
  `F_CO2_leaf` double DEFAULT NULL,
  `F_H2O_leaf` double DEFAULT NULL,
  `F_O3_leaf` double DEFAULT NULL,
  `F_NO_leaf` double DEFAULT NULL,
  `F_NOx_leaf` double DEFAULT NULL,
  `Tcuv_leaf` double DEFAULT NULL,
  `PARcuv_leaf` double DEFAULT NULL,
  `VOC_M33_leaf` double DEFAULT NULL,
  `F_VOC_M33_leaf` double DEFAULT NULL,
  `F_VOC_M33_stem` double DEFAULT NULL,
  `VOC_M45_leaf` double DEFAULT NULL,
  `F_VOC_M45_leaf` double DEFAULT NULL,
  `F_VOC_M45_stem` double DEFAULT NULL,
  `VOC_M59_leaf` double DEFAULT NULL,
  `F_VOC_M59_leaf` double DEFAULT NULL,
  `F_VOC_M59_stem` double DEFAULT NULL,
  `VOC_M69_leaf` double DEFAULT NULL,
  `F_VOC_M69_leaf` double DEFAULT NULL,
  `F_VOC_M69_stem` double DEFAULT NULL,
  `VOC_M79_leaf` double DEFAULT NULL,
  `F_VOC_M79_leaf` double DEFAULT NULL,
  `F_VOC_M79_stem` double DEFAULT NULL,
  `VOC_M81_leaf` double DEFAULT NULL,
  `F_VOC_M81_leaf` double DEFAULT NULL,
  `F_VOC_M81_stem` double DEFAULT NULL,
  `VOC_M99_leaf` double DEFAULT NULL,
  `F_VOC_M99_leaf` double DEFAULT NULL,
  `F_VOC_M99_stem` double DEFAULT NULL,
  `VOC_M101_leaf` double DEFAULT NULL,
  `F_VOC_M101_leaf` double DEFAULT NULL,
  `F_VOC_M101_stem` double DEFAULT NULL,
  `VOC_M137_leaf` double DEFAULT NULL,
  `F_VOC_M137_leaf` double DEFAULT NULL,
  `F_VOC_M137_stem` double DEFAULT NULL,
  `VOC_M153_leaf` double DEFAULT NULL,
  `F_VOC_M153_leaf` double DEFAULT NULL,
  `F_VOC_M153_stem` double DEFAULT NULL,
  `Tcuv_stem` double DEFAULT NULL,
  `F_CO2_stem_EMEP` tinyint(4) DEFAULT NULL,
  `F_CO2_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_H2O_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_O3_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_NO_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_NOx_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `Tcuv_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `PARcuv_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `VOC_M33_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M33_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M33_stem_EMEP` tinyint(4) DEFAULT NULL,
  `VOC_M45_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M45_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M45_stem_EMEP` tinyint(4) DEFAULT NULL,
  `VOC_M59_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M59_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M59_stem_EMEP` tinyint(4) DEFAULT NULL,
  `VOC_M69_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M69_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M69_stem_EMEP` tinyint(4) DEFAULT NULL,
  `VOC_M79_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M79_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M79_stem_EMEP` tinyint(4) DEFAULT NULL,
  `VOC_M81_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M81_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M81_stem_EMEP` tinyint(4) DEFAULT NULL,
  `VOC_M99_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M99_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M99_stem_EMEP` tinyint(4) DEFAULT NULL,
  `VOC_M101_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M101_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M101_stem_EMEP` tinyint(4) DEFAULT NULL,
  `VOC_M137_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M137_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M137_stem_EMEP` tinyint(4) DEFAULT NULL,
  `VOC_M153_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M153_leaf_EMEP` tinyint(4) DEFAULT NULL,
  `F_VOC_M153_stem_EMEP` tinyint(4) DEFAULT NULL,
  `Tcuv_stem_EMEP` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `KPS_DMPS`
--

DROP TABLE IF EXISTS `KPS_DMPS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `KPS_DMPS` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `t` float DEFAULT NULL,
  `p` float DEFAULT NULL,
  `d100e1` float DEFAULT NULL,
  `d112e1` float DEFAULT NULL,
  `d126e1` float DEFAULT NULL,
  `d141e1` float DEFAULT NULL,
  `d158e1` float DEFAULT NULL,
  `d178e1` float DEFAULT NULL,
  `d200e1` float DEFAULT NULL,
  `d224e1` float DEFAULT NULL,
  `d251e1` float DEFAULT NULL,
  `d282e1` float DEFAULT NULL,
  `d316e1` float DEFAULT NULL,
  `d355e1` float DEFAULT NULL,
  `d398e1` float DEFAULT NULL,
  `d447e1` float DEFAULT NULL,
  `d501e1` float DEFAULT NULL,
  `d562e1` float DEFAULT NULL,
  `d631e1` float DEFAULT NULL,
  `d708e1` float DEFAULT NULL,
  `d794e1` float DEFAULT NULL,
  `d891e1` float DEFAULT NULL,
  `d100e2` float DEFAULT NULL,
  `d112e2` float DEFAULT NULL,
  `d126e2` float DEFAULT NULL,
  `d141e2` float DEFAULT NULL,
  `d158e2` float DEFAULT NULL,
  `d178e2` float DEFAULT NULL,
  `d200e2` float DEFAULT NULL,
  `d224e2` float DEFAULT NULL,
  `d251e2` float DEFAULT NULL,
  `d282e2` float DEFAULT NULL,
  `d316e2` float DEFAULT NULL,
  `d355e2` float DEFAULT NULL,
  `d398e2` float DEFAULT NULL,
  `d447e2` float DEFAULT NULL,
  `d501e2` float DEFAULT NULL,
  `d562e2` float DEFAULT NULL,
  `d631e2` float DEFAULT NULL,
  `d708e2` float DEFAULT NULL,
  `d794e2` float DEFAULT NULL,
  `d891e2` float DEFAULT NULL,
  `d100e3` float DEFAULT NULL,
  `d112e3` float DEFAULT NULL,
  `d126e3` float DEFAULT NULL,
  `d141e3` float DEFAULT NULL,
  `d158e3` float DEFAULT NULL,
  `d178e3` float DEFAULT NULL,
  `d200e3` float DEFAULT NULL,
  `d224e3` float DEFAULT NULL,
  `d251e3` float DEFAULT NULL,
  `d282e3` float DEFAULT NULL,
  `d316e3` float DEFAULT NULL,
  `d355e3` float DEFAULT NULL,
  `d398e3` float DEFAULT NULL,
  `d447e3` float DEFAULT NULL,
  `d501e3` float DEFAULT NULL,
  `d562e3` float DEFAULT NULL,
  `d631e3` float DEFAULT NULL,
  `d708e3` float DEFAULT NULL,
  `d794e3` float DEFAULT NULL,
  `d891e3` float DEFAULT NULL,
  `d100e4` float DEFAULT NULL,
  `tconc` float DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='K-Puszta DMPS data';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `KUM_DMPS`
--

DROP TABLE IF EXISTS `KUM_DMPS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `KUM_DMPS` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `t1` float DEFAULT NULL,
  `t2` float DEFAULT NULL,
  `p1` float DEFAULT NULL,
  `p2` float DEFAULT NULL,
  `rh1` float DEFAULT NULL,
  `rh2` float DEFAULT NULL,
  `d100e1` float DEFAULT NULL,
  `d112e1` float DEFAULT NULL,
  `d126e1` float DEFAULT NULL,
  `d141e1` float DEFAULT NULL,
  `d158e1` float DEFAULT NULL,
  `d178e1` float DEFAULT NULL,
  `d200e1` float DEFAULT NULL,
  `d224e1` float DEFAULT NULL,
  `d251e1` float DEFAULT NULL,
  `d282e1` float DEFAULT NULL,
  `d316e1` float DEFAULT NULL,
  `d355e1` float DEFAULT NULL,
  `d398e1` float DEFAULT NULL,
  `d447e1` float DEFAULT NULL,
  `d501e1` float DEFAULT NULL,
  `d562e1` float DEFAULT NULL,
  `d631e1` float DEFAULT NULL,
  `d708e1` float DEFAULT NULL,
  `d794e1` float DEFAULT NULL,
  `d891e1` float DEFAULT NULL,
  `d100e2` float DEFAULT NULL,
  `d112e2` float DEFAULT NULL,
  `d126e2` float DEFAULT NULL,
  `d141e2` float DEFAULT NULL,
  `d158e2` float DEFAULT NULL,
  `d178e2` float DEFAULT NULL,
  `d200e2` float DEFAULT NULL,
  `d224e2` float DEFAULT NULL,
  `d251e2` float DEFAULT NULL,
  `d282e2` float DEFAULT NULL,
  `d316e2` float DEFAULT NULL,
  `d355e2` float DEFAULT NULL,
  `d398e2` float DEFAULT NULL,
  `d447e2` float DEFAULT NULL,
  `d501e2` float DEFAULT NULL,
  `d562e2` float DEFAULT NULL,
  `d631e2` float DEFAULT NULL,
  `d708e2` float DEFAULT NULL,
  `d794e2` float DEFAULT NULL,
  `d891e2` float DEFAULT NULL,
  `d100e3` float DEFAULT NULL,
  `d112e3` float DEFAULT NULL,
  `d126e3` float DEFAULT NULL,
  `d141e3` float DEFAULT NULL,
  `d158e3` float DEFAULT NULL,
  `d178e3` float DEFAULT NULL,
  `d200e3` float DEFAULT NULL,
  `d224e3` float DEFAULT NULL,
  `d251e3` float DEFAULT NULL,
  `d282e3` float DEFAULT NULL,
  `d316e3` float DEFAULT NULL,
  `d355e3` float DEFAULT NULL,
  `d398e3` float DEFAULT NULL,
  `d447e3` float DEFAULT NULL,
  `d501e3` float DEFAULT NULL,
  `d562e3` float DEFAULT NULL,
  `d631e3` float DEFAULT NULL,
  `d708e3` float DEFAULT NULL,
  `d794e3` float DEFAULT NULL,
  `d891e3` float DEFAULT NULL,
  `d100e4` float DEFAULT NULL,
  `tconc` float DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Kumpula DMPS data';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `KUM_EDDY`
--

DROP TABLE IF EXISTS `KUM_EDDY`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `KUM_EDDY` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `H` double DEFAULT NULL,
  `H_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_H` int(11) DEFAULT NULL,
  `Qc_H_EMEP` tinyint(4) DEFAULT NULL,
  `LE` double DEFAULT NULL,
  `LE_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_LE` int(11) DEFAULT NULL,
  `Qc_LE_EMEP` tinyint(4) DEFAULT NULL,
  `E` double DEFAULT NULL,
  `E_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_E` int(11) DEFAULT NULL,
  `Qc_E_EMEP` tinyint(4) DEFAULT NULL,
  `F_c` double DEFAULT NULL,
  `F_c_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_F_c` int(11) DEFAULT NULL,
  `Qc_F_c_EMEP` tinyint(4) DEFAULT NULL,
  `tau` double DEFAULT NULL,
  `tau_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_tau` int(11) DEFAULT NULL,
  `Qc_tau_EMEP` tinyint(4) DEFAULT NULL,
  `u_star` double DEFAULT NULL,
  `u_star_EMEP` tinyint(4) DEFAULT NULL,
  `MO_length` double DEFAULT NULL,
  `MO_length_EMEP` tinyint(4) DEFAULT NULL,
  `std_u` double DEFAULT NULL,
  `std_u_EMEP` tinyint(4) DEFAULT NULL,
  `std_v` double DEFAULT NULL,
  `std_v_EMEP` tinyint(4) DEFAULT NULL,
  `std_w` double DEFAULT NULL,
  `std_w_EMEP` tinyint(4) DEFAULT NULL,
  `std_t` double DEFAULT NULL,
  `std_t_EMEP` tinyint(4) DEFAULT NULL,
  `std_c` double DEFAULT NULL,
  `std_c_EMEP` tinyint(4) DEFAULT NULL,
  `std_h` double DEFAULT NULL,
  `std_h_EMEP` tinyint(4) DEFAULT NULL,
  `av_u` double DEFAULT NULL,
  `av_u_EMEP` tinyint(4) DEFAULT NULL,
  `av_v` double DEFAULT NULL,
  `av_v_EMEP` tinyint(4) DEFAULT NULL,
  `av_w` double DEFAULT NULL,
  `av_w_EMEP` tinyint(4) DEFAULT NULL,
  `av_t` double DEFAULT NULL,
  `av_t_EMEP` tinyint(4) DEFAULT NULL,
  `av_c` double DEFAULT NULL,
  `av_c_EMEP` tinyint(4) DEFAULT NULL,
  `av_h` double DEFAULT NULL,
  `av_h_EMEP` tinyint(4) DEFAULT NULL,
  `U` double DEFAULT NULL,
  `U_EMEP` tinyint(4) DEFAULT NULL,
  `wind_dir` double DEFAULT NULL,
  `wind_dir_EMEP` tinyint(4) DEFAULT NULL,
  `eta` double DEFAULT NULL,
  `eta_EMEP` tinyint(4) DEFAULT NULL,
  `theta` double DEFAULT NULL,
  `theta_EMEP` tinyint(4) DEFAULT NULL,
  `beta` double DEFAULT NULL,
  `beta_EMEP` tinyint(4) DEFAULT NULL,
  `c_lag` double DEFAULT NULL,
  `c_lag_EMEP` tinyint(4) DEFAULT NULL,
  `h_lag` double DEFAULT NULL,
  `h_lag_EMEP` tinyint(4) DEFAULT NULL,
  `err_packet` double DEFAULT NULL,
  `err_packet_EMEP` tinyint(4) DEFAULT NULL,
  `licor_t_std` double DEFAULT NULL,
  `licor_t_std_EMEP` tinyint(4) DEFAULT NULL,
  `licor_t_av` double DEFAULT NULL,
  `licor_t_av_EMEP` tinyint(4) DEFAULT NULL,
  `licor_p_std` double DEFAULT NULL,
  `licor_p_std_EMEP` tinyint(4) DEFAULT NULL,
  `licor_p_av` double DEFAULT NULL,
  `licor_p_av_EMEP` tinyint(4) DEFAULT NULL,
  `LE_op` double DEFAULT NULL,
  `LE_op_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_LE_op` int(11) DEFAULT NULL,
  `Qc_LE_op_EMEP` tinyint(4) DEFAULT NULL,
  `E_op` double DEFAULT NULL,
  `E_op_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_E_op` int(11) DEFAULT NULL,
  `Qc_E_op_EMEP` tinyint(4) DEFAULT NULL,
  `F_c_op` double DEFAULT NULL,
  `F_c_op_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_F_c_op` int(11) DEFAULT NULL,
  `Qc_F_c_op_EMEP` tinyint(4) DEFAULT NULL,
  `std_c_op` double DEFAULT NULL,
  `std_c_op_EMEP` tinyint(4) DEFAULT NULL,
  `std_h_op` double DEFAULT NULL,
  `std_h_op_EMEP` tinyint(4) DEFAULT NULL,
  `av_c_op` double DEFAULT NULL,
  `av_c_op_EMEP` tinyint(4) DEFAULT NULL,
  `av_h_op` double DEFAULT NULL,
  `av_h_op_EMEP` tinyint(4) DEFAULT NULL,
  `c_lag_op` double DEFAULT NULL,
  `c_lag_op_EMEP` tinyint(4) DEFAULT NULL,
  `h_lag_op` double DEFAULT NULL,
  `h_lag_op_EMEP` tinyint(4) DEFAULT NULL,
  `F_CPC` double DEFAULT NULL,
  `F_CPC_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_F_CPC` int(11) DEFAULT NULL,
  `Qc_F_CPC_EMEP` tinyint(4) DEFAULT NULL,
  `std_CPC` double DEFAULT NULL,
  `std_CPC_EMEP` tinyint(4) DEFAULT NULL,
  `av_CPC` double DEFAULT NULL,
  `av_CPC_EMEP` tinyint(4) DEFAULT NULL,
  `CPC_lag` double DEFAULT NULL,
  `CPC_lag_EMEP` tinyint(4) DEFAULT NULL,
  `F_N2O` double DEFAULT NULL,
  `F_N2O_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_F_N2O` int(11) DEFAULT NULL,
  `Qc_F_N2O_EMEP` tinyint(4) DEFAULT NULL,
  `std_N2O` double DEFAULT NULL,
  `std_N2O_EMEP` tinyint(4) DEFAULT NULL,
  `av_N2O` double DEFAULT NULL,
  `av_N2O_EMEP` tinyint(4) DEFAULT NULL,
  `N2O_lag` double DEFAULT NULL,
  `N2O_lag_EMEP` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `KUM_META`
--

DROP TABLE IF EXISTS `KUM_META`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `KUM_META` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `t` double DEFAULT NULL,
  `dp` double DEFAULT NULL,
  `rh` double DEFAULT NULL,
  `p` double DEFAULT NULL,
  `ws` double DEFAULT NULL,
  `wdir` double DEFAULT NULL,
  `rmm` double DEFAULT NULL,
  `p0` double DEFAULT NULL,
  `glob` double DEFAULT NULL,
  `par` double DEFAULT NULL,
  `skyir` double DEFAULT NULL,
  `pwd_visibility_1` double DEFAULT NULL,
  `pwd_visibility_10` double DEFAULT NULL,
  `pwd_wmo_0` double DEFAULT NULL,
  `pwd_wmo_15` double DEFAULT NULL,
  `pwd_wmo_60` double DEFAULT NULL,
  `pwd_intensity_w` double DEFAULT NULL,
  `pwd_rmm` double DEFAULT NULL,
  `pwd_smm` double DEFAULT NULL,
  `pwd_nws` char(3) DEFAULT NULL,
  `Tower_T_4m` double DEFAULT NULL,
  `Tower_T_8m` double DEFAULT NULL,
  `Tower_T_16m` double DEFAULT NULL,
  `Tower_T_32m` double DEFAULT NULL,
  `Tower_WS_32m` double DEFAULT NULL,
  `Tower_WS_16m` double DEFAULT NULL,
  `Tower_WS_8m` double DEFAULT NULL,
  `Tower_WS_4m` double DEFAULT NULL,
  `Tower_WDIR_32m` double DEFAULT NULL,
  `Tower_WDIR_16m` double DEFAULT NULL,
  `Tower_WDIR_8m` double DEFAULT NULL,
  `Tower_WDIR_4m` double DEFAULT NULL,
  `Tower_PAR_32m` double DEFAULT NULL,
  `Tower_PAR_REFL_32m` double DEFAULT NULL,
  `Tower_GLOB_32m` double DEFAULT NULL,
  `Tower_GLOB_REFL_32m` double DEFAULT NULL,
  `Tower_IR_32m` double DEFAULT NULL,
  `Tower_IR_REFL_32m` double DEFAULT NULL,
  `Tower_VT_4m` double DEFAULT NULL,
  `Tower_VT_8m` double DEFAULT NULL,
  `Tower_VT_16m` double DEFAULT NULL,
  `Tower_VT_32m` double DEFAULT NULL,
  `O_3` double DEFAULT NULL,
  `NO` double DEFAULT NULL,
  `NO_x` double DEFAULT NULL,
  `SO_2` double DEFAULT NULL,
  `CO` double DEFAULT NULL,
  `Tower_WS_MAX_32m` double DEFAULT NULL,
  `Tower_WS_MAX_16m` double DEFAULT NULL,
  `Tower_WS_MAX_8m` double DEFAULT NULL,
  `Tower_WS_MAX_4m` double DEFAULT NULL,
  `fs11_visibility_1` double DEFAULT NULL,
  PRIMARY KEY (`samptime`),
  KEY `saa` (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `KVJ_META`
--

DROP TABLE IF EXISTS `KVJ_META`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `KVJ_META` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Tw2` double DEFAULT NULL,
  `Tw5` double DEFAULT NULL,
  `Tw10` double DEFAULT NULL,
  `Tw15` double DEFAULT NULL,
  `Tw20` double DEFAULT NULL,
  `Tw25` double DEFAULT NULL,
  `Tw30` double DEFAULT NULL,
  `Tw35` double DEFAULT NULL,
  `Tw40` double DEFAULT NULL,
  `Tw45` double DEFAULT NULL,
  `Tw50` double DEFAULT NULL,
  `Tw60` double DEFAULT NULL,
  `Tw70` double DEFAULT NULL,
  `Tw80` double DEFAULT NULL,
  `Tw100` double DEFAULT NULL,
  `Tw120` double DEFAULT NULL,
  `CO2w02` double DEFAULT NULL,
  `CO2w15` double DEFAULT NULL,
  `CO2w25` double DEFAULT NULL,
  `CO2w70` double DEFAULT NULL,
  `Glob` double DEFAULT NULL,
  `RGlob` double DEFAULT NULL,
  `LWin` double DEFAULT NULL,
  `LWout` double DEFAULT NULL,
  `PARw` double DEFAULT NULL,
  `Ta` double DEFAULT NULL,
  `RH` double DEFAULT NULL,
  `Tw2_EMEP` tinyint(4) DEFAULT NULL,
  `Tw5_EMEP` tinyint(4) DEFAULT NULL,
  `Tw10_EMEP` tinyint(4) DEFAULT NULL,
  `Tw15_EMEP` tinyint(4) DEFAULT NULL,
  `Tw20_EMEP` tinyint(4) DEFAULT NULL,
  `Tw25_EMEP` tinyint(4) DEFAULT NULL,
  `Tw30_EMEP` tinyint(4) DEFAULT NULL,
  `Tw35_EMEP` tinyint(4) DEFAULT NULL,
  `Tw40_EMEP` tinyint(4) DEFAULT NULL,
  `Tw45_EMEP` tinyint(4) DEFAULT NULL,
  `Tw50_EMEP` tinyint(4) DEFAULT NULL,
  `Tw60_EMEP` tinyint(4) DEFAULT NULL,
  `Tw70_EMEP` tinyint(4) DEFAULT NULL,
  `Tw80_EMEP` tinyint(4) DEFAULT NULL,
  `Tw100_EMEP` tinyint(4) DEFAULT NULL,
  `Tw120_EMEP` tinyint(4) DEFAULT NULL,
  `CO2w02_EMEP` tinyint(4) DEFAULT NULL,
  `CO2w15_EMEP` tinyint(4) DEFAULT NULL,
  `CO2w25_EMEP` tinyint(4) DEFAULT NULL,
  `CO2w70_EMEP` tinyint(4) DEFAULT NULL,
  `Glob_EMEP` tinyint(4) DEFAULT NULL,
  `RGlob_EMEP` tinyint(4) DEFAULT NULL,
  `LWin_EMEP` tinyint(4) DEFAULT NULL,
  `LWout_EMEP` tinyint(4) DEFAULT NULL,
  `PARw_EMEP` tinyint(4) DEFAULT NULL,
  `Ta_EMEP` tinyint(4) DEFAULT NULL,
  `RH_EMEP` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `Metadata`
--

DROP TABLE IF EXISTS `Metadata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Metadata` (
  `title` varchar(255) DEFAULT NULL,
  `rightsCategory` varchar(30) DEFAULT NULL,
  `access_rights` varchar(255) NOT NULL,
  `public` tinyint(1) NOT NULL,
  `project` varchar(255) NOT NULL,
  `maintaining_organisation` varchar(255) NOT NULL,
  `contact` varchar(255) NOT NULL,
  `ref` varchar(255) DEFAULT NULL,
  `creator` varchar(80) DEFAULT NULL,
  `discipline` varchar(80) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SII1_EDDY`
--

DROP TABLE IF EXISTS `SII1_EDDY`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SII1_EDDY` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `U` double DEFAULT NULL,
  `U_EMEP` tinyint(4) DEFAULT NULL,
  `wind_dir` double DEFAULT NULL,
  `wind_dir_EMEP` tinyint(4) DEFAULT NULL,
  `eta` double DEFAULT NULL,
  `eta_EMEP` tinyint(4) DEFAULT NULL,
  `theta` double DEFAULT NULL,
  `theta_EMEP` tinyint(4) DEFAULT NULL,
  `beta` double DEFAULT NULL,
  `beta_EMEP` tinyint(4) DEFAULT NULL,
  `H` double DEFAULT NULL,
  `H_EMEP` tinyint(4) DEFAULT NULL,
  `tau` double DEFAULT NULL,
  `tau_EMEP` tinyint(4) DEFAULT NULL,
  `u_star` double DEFAULT NULL,
  `u_star_EMEP` tinyint(4) DEFAULT NULL,
  `MO_length` double DEFAULT NULL,
  `MO_length_EMEP` tinyint(4) DEFAULT NULL,
  `err_packet` double DEFAULT NULL,
  `err_packet_EMEP` tinyint(4) DEFAULT NULL,
  `F_c_LI70` double DEFAULT NULL,
  `F_c_LI70_EMEP` tinyint(4) DEFAULT NULL,
  `F_H2O_LI70` double DEFAULT NULL,
  `F_H2O_LI70_EMEP` tinyint(4) DEFAULT NULL,
  `F_CH4_LGR` double DEFAULT NULL,
  `F_CH4_LGR_EMEP` tinyint(4) DEFAULT NULL,
  `F_CH4_TGA` double DEFAULT NULL,
  `F_CH4_TGA_EMEP` tinyint(4) DEFAULT NULL,
  `F_H2O_PIC` double DEFAULT NULL,
  `F_H2O_PIC_EMEP` tinyint(4) DEFAULT NULL,
  `F_CH4_PIC` double DEFAULT NULL,
  `F_CH4_PIC_EMEP` tinyint(4) DEFAULT NULL,
  `LE_LI70` double DEFAULT NULL,
  `LE_LI70_EMEP` tinyint(4) DEFAULT NULL,
  `LE_PIC` double DEFAULT NULL,
  `LE_PIC_EMEP` tinyint(4) DEFAULT NULL,
  `av_u` double DEFAULT NULL,
  `av_u_EMEP` tinyint(4) DEFAULT NULL,
  `av_v` double DEFAULT NULL,
  `av_v_EMEP` tinyint(4) DEFAULT NULL,
  `av_w` double DEFAULT NULL,
  `av_w_EMEP` tinyint(4) DEFAULT NULL,
  `T_s` double DEFAULT NULL,
  `T_s_EMEP` tinyint(4) DEFAULT NULL,
  `av_c` double DEFAULT NULL,
  `av_c_EMEP` tinyint(4) DEFAULT NULL,
  `av_H2O_LI70` double DEFAULT NULL,
  `av_H2O_LI70_EMEP` tinyint(4) DEFAULT NULL,
  `av_CH4_LGR` double DEFAULT NULL,
  `av_CH4_LGR_EMEP` tinyint(4) DEFAULT NULL,
  `av_CH4_TGA` double DEFAULT NULL,
  `av_CH4_TGA_EMEP` tinyint(4) DEFAULT NULL,
  `av_H2O_PIC` double DEFAULT NULL,
  `av_H2O_PIC_EMEP` tinyint(4) DEFAULT NULL,
  `av_CH4_PIC` double DEFAULT NULL,
  `av_CH4_PIC_EMEP` tinyint(4) DEFAULT NULL,
  `std_u` double DEFAULT NULL,
  `std_u_EMEP` tinyint(4) DEFAULT NULL,
  `std_v` double DEFAULT NULL,
  `std_v_EMEP` tinyint(4) DEFAULT NULL,
  `std_w` double DEFAULT NULL,
  `std_w_EMEP` tinyint(4) DEFAULT NULL,
  `std_T_s` double DEFAULT NULL,
  `std_T_s_EMEP` tinyint(4) DEFAULT NULL,
  `std_c_LI70` double DEFAULT NULL,
  `std_c_LI70_EMEP` tinyint(4) DEFAULT NULL,
  `std_H2O_LI70` double DEFAULT NULL,
  `std_H2O_LI70_EMEP` tinyint(4) DEFAULT NULL,
  `std_CH4_LGR` double DEFAULT NULL,
  `std_CH4_LGR_EMEP` tinyint(4) DEFAULT NULL,
  `std_CH4_TGA` double DEFAULT NULL,
  `std_CH4_TGA_EMEP` tinyint(4) DEFAULT NULL,
  `std_H2O_PIC` double DEFAULT NULL,
  `std_H2O_PIC_EMEP` tinyint(4) DEFAULT NULL,
  `std_CH4_PIC` double DEFAULT NULL,
  `std_CH4_PIC_EMEP` tinyint(4) DEFAULT NULL,
  `c_lag_LI70` double DEFAULT NULL,
  `c_lag_LI70_EMEP` tinyint(4) DEFAULT NULL,
  `H2O_lag_LI70` double DEFAULT NULL,
  `H2O_lag_LI70_EMEP` tinyint(4) DEFAULT NULL,
  `CH4_lag_LGR` double DEFAULT NULL,
  `CH4_lag_LGR_EMEP` tinyint(4) DEFAULT NULL,
  `CH4_lag_TGA` double DEFAULT NULL,
  `CH4_lag_TGA_EMEP` tinyint(4) DEFAULT NULL,
  `H2O_lag_PIC` double DEFAULT NULL,
  `H2O_lag_PIC_EMEP` tinyint(4) DEFAULT NULL,
  `CH4_lag_PIC` double DEFAULT NULL,
  `CH4_lag_PIC_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_H` int(11) DEFAULT NULL,
  `Qc_H_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_CO2_LI70` int(11) DEFAULT NULL,
  `Qc_CO2_LI70_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_CH4_LGR` int(11) DEFAULT NULL,
  `Qc_CH4_LGR_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_CH4_TGA` int(11) DEFAULT NULL,
  `Qc_CH4_TGA_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_CH4_PIC` int(11) DEFAULT NULL,
  `Qc_CH4_PIC_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_LE_LI70` int(11) DEFAULT NULL,
  `Qc_LE_LI70_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_LE_PIC` int(11) DEFAULT NULL,
  `Qc_LE_PIC_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_tau` int(11) DEFAULT NULL,
  `Qc_tau_EMEP` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SII1_META`
--

DROP TABLE IF EXISTS `SII1_META`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SII1_META` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `T_a` double DEFAULT NULL,
  `T_a_EMEP` tinyint(4) DEFAULT NULL,
  `RH` double DEFAULT NULL,
  `RH_EMEP` tinyint(4) DEFAULT NULL,
  `PAR` double DEFAULT NULL,
  `PAR_EMEP` tinyint(4) DEFAULT NULL,
  `R_PAR` double DEFAULT NULL,
  `R_PAR_EMEP` tinyint(4) DEFAULT NULL,
  `Net_CNR4` double DEFAULT NULL,
  `Net_CNR4_EMEP` tinyint(4) DEFAULT NULL,
  `Net_NRLite` double DEFAULT NULL,
  `Net_NRLite_EMEP` tinyint(4) DEFAULT NULL,
  `Wsoil_1` double DEFAULT NULL,
  `Wsoil_1_EMEP` tinyint(4) DEFAULT NULL,
  `Wsoil_2` double DEFAULT NULL,
  `Wsoil_2_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_B5` double DEFAULT NULL,
  `T_p_B5_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_B20` double DEFAULT NULL,
  `T_p_B20_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_B35` double DEFAULT NULL,
  `T_p_B35_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_B50` double DEFAULT NULL,
  `T_p_B50_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_C1` double DEFAULT NULL,
  `T_p_C1_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_C2` double DEFAULT NULL,
  `T_p_C2_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_C5` double DEFAULT NULL,
  `T_p_C5_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_C10` double DEFAULT NULL,
  `T_p_C10_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_C15` double DEFAULT NULL,
  `T_p_C15_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_C20` double DEFAULT NULL,
  `T_p_C20_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_C30` double DEFAULT NULL,
  `T_p_C30_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_C50` double DEFAULT NULL,
  `T_p_C50_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_C70` double DEFAULT NULL,
  `T_p_C70_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_C100` double DEFAULT NULL,
  `T_p_C100_EMEP` tinyint(4) DEFAULT NULL,
  `WTD` double DEFAULT NULL,
  `WTD_EMEP` tinyint(4) DEFAULT NULL,
  `Precip` double DEFAULT NULL,
  `Precip_EMEP` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SII2_EDDY`
--

DROP TABLE IF EXISTS `SII2_EDDY`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SII2_EDDY` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `U` double DEFAULT NULL,
  `U_EMEP` tinyint(4) DEFAULT NULL,
  `wind_dir` double DEFAULT NULL,
  `wind_dir_EMEP` tinyint(4) DEFAULT NULL,
  `eta` double DEFAULT NULL,
  `eta_EMEP` tinyint(4) DEFAULT NULL,
  `theta` double DEFAULT NULL,
  `theta_EMEP` tinyint(4) DEFAULT NULL,
  `beta` double DEFAULT NULL,
  `beta_EMEP` tinyint(4) DEFAULT NULL,
  `H` double DEFAULT NULL,
  `H_EMEP` tinyint(4) DEFAULT NULL,
  `tau` double DEFAULT NULL,
  `tau_EMEP` tinyint(4) DEFAULT NULL,
  `u_star` double DEFAULT NULL,
  `u_star_EMEP` tinyint(4) DEFAULT NULL,
  `MO_length` double DEFAULT NULL,
  `MO_length_EMEP` tinyint(4) DEFAULT NULL,
  `err_packet` double DEFAULT NULL,
  `err_packet_EMEP` tinyint(4) DEFAULT NULL,
  `F_c_LI72` double DEFAULT NULL,
  `F_c_LI72_EMEP` tinyint(4) DEFAULT NULL,
  `F_H2O_LI72` double DEFAULT NULL,
  `F_H2O_LI72_EMEP` tinyint(4) DEFAULT NULL,
  `F_CH4_LI77` double DEFAULT NULL,
  `F_CH4_LI77_EMEP` tinyint(4) DEFAULT NULL,
  `LE_LI72` double DEFAULT NULL,
  `LE_LI72_EMEP` tinyint(4) DEFAULT NULL,
  `av_u` double DEFAULT NULL,
  `av_u_EMEP` tinyint(4) DEFAULT NULL,
  `av_v` double DEFAULT NULL,
  `av_v_EMEP` tinyint(4) DEFAULT NULL,
  `av_w` double DEFAULT NULL,
  `av_w_EMEP` tinyint(4) DEFAULT NULL,
  `T_s` double DEFAULT NULL,
  `T_s_EMEP` tinyint(4) DEFAULT NULL,
  `av_c` double DEFAULT NULL,
  `av_c_EMEP` tinyint(4) DEFAULT NULL,
  `av_H2O_LI72` double DEFAULT NULL,
  `av_H2O_LI72_EMEP` tinyint(4) DEFAULT NULL,
  `av_CH4_LI77` double DEFAULT NULL,
  `av_CH4_LI77_EMEP` tinyint(4) DEFAULT NULL,
  `std_u` double DEFAULT NULL,
  `std_u_EMEP` tinyint(4) DEFAULT NULL,
  `std_v` double DEFAULT NULL,
  `std_v_EMEP` tinyint(4) DEFAULT NULL,
  `std_w` double DEFAULT NULL,
  `std_w_EMEP` tinyint(4) DEFAULT NULL,
  `std_T_s` double DEFAULT NULL,
  `std_T_s_EMEP` tinyint(4) DEFAULT NULL,
  `std_c_LI72` double DEFAULT NULL,
  `std_c_LI72_EMEP` tinyint(4) DEFAULT NULL,
  `std_H2O_LI72` double DEFAULT NULL,
  `std_H2O_LI72_EMEP` tinyint(4) DEFAULT NULL,
  `std_CH4_LI77` double DEFAULT NULL,
  `std_CH4_LI77_EMEP` tinyint(4) DEFAULT NULL,
  `c_lag_LI72` double DEFAULT NULL,
  `c_lag_LI72_EMEP` tinyint(4) DEFAULT NULL,
  `H2O_lag_LI72` double DEFAULT NULL,
  `H2O_lag_LI72_EMEP` tinyint(4) DEFAULT NULL,
  `CH4_lag_LI77` double DEFAULT NULL,
  `CH4_lag_LI77_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_H` int(11) DEFAULT NULL,
  `Qc_H_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_CO2_LI70` int(11) DEFAULT NULL,
  `Qc_CO2_LI70_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_CH4_LI77` int(11) DEFAULT NULL,
  `Qc_CH4_LI77_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_LE_LI72` int(11) DEFAULT NULL,
  `Qc_LE_LI72_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_tau` int(11) DEFAULT NULL,
  `Qc_tau_EMEP` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SII2_META`
--

DROP TABLE IF EXISTS `SII2_META`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SII2_META` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `T_a` double DEFAULT NULL,
  `T_a_EMEP` tinyint(4) DEFAULT NULL,
  `RH` double DEFAULT NULL,
  `RH_EMEP` tinyint(4) DEFAULT NULL,
  `Net` double DEFAULT NULL,
  `Net_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_5` double DEFAULT NULL,
  `T_p_5_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_B20` double DEFAULT NULL,
  `T_p_B20_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_B35` double DEFAULT NULL,
  `T_p_B35_EMEP` tinyint(4) DEFAULT NULL,
  `T_p_B50` double DEFAULT NULL,
  `T_p_B50_EMEP` tinyint(4) DEFAULT NULL,
  `WTD` double DEFAULT NULL,
  `WTD_EMEP` tinyint(4) DEFAULT NULL,
  `Precip` double DEFAULT NULL,
  `Precip_EMEP` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TOR_EDDY`
--

DROP TABLE IF EXISTS `TOR_EDDY`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TOR_EDDY` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `H` double DEFAULT NULL,
  `H_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_H` int(11) DEFAULT NULL,
  `Qc_H_EMEP` tinyint(4) DEFAULT NULL,
  `LE` double DEFAULT NULL,
  `LE_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_LE` int(11) DEFAULT NULL,
  `Qc_LE_EMEP` tinyint(4) DEFAULT NULL,
  `E` double DEFAULT NULL,
  `E_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_E` int(11) DEFAULT NULL,
  `Qc_E_EMEP` tinyint(4) DEFAULT NULL,
  `F_c` double DEFAULT NULL,
  `F_c_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_F_c` int(11) DEFAULT NULL,
  `Qc_F_c_EMEP` tinyint(4) DEFAULT NULL,
  `tau` double DEFAULT NULL,
  `tau_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_tau` int(11) DEFAULT NULL,
  `Qc_tau_EMEP` tinyint(4) DEFAULT NULL,
  `u_star` double DEFAULT NULL,
  `u_star_EMEP` tinyint(4) DEFAULT NULL,
  `MO_length` double DEFAULT NULL,
  `MO_length_EMEP` tinyint(4) DEFAULT NULL,
  `std_u` double DEFAULT NULL,
  `std_u_EMEP` tinyint(4) DEFAULT NULL,
  `std_v` double DEFAULT NULL,
  `std_v_EMEP` tinyint(4) DEFAULT NULL,
  `std_w` double DEFAULT NULL,
  `std_w_EMEP` tinyint(4) DEFAULT NULL,
  `std_t` double DEFAULT NULL,
  `std_t_EMEP` tinyint(4) DEFAULT NULL,
  `std_c` double DEFAULT NULL,
  `std_c_EMEP` tinyint(4) DEFAULT NULL,
  `std_h` double DEFAULT NULL,
  `std_h_EMEP` tinyint(4) DEFAULT NULL,
  `av_u` double DEFAULT NULL,
  `av_u_EMEP` tinyint(4) DEFAULT NULL,
  `av_v` double DEFAULT NULL,
  `av_v_EMEP` tinyint(4) DEFAULT NULL,
  `av_w` double DEFAULT NULL,
  `av_w_EMEP` tinyint(4) DEFAULT NULL,
  `av_t` double DEFAULT NULL,
  `av_t_EMEP` tinyint(4) DEFAULT NULL,
  `av_c` double DEFAULT NULL,
  `av_c_EMEP` tinyint(4) DEFAULT NULL,
  `av_h` double DEFAULT NULL,
  `av_h_EMEP` tinyint(4) DEFAULT NULL,
  `U` double DEFAULT NULL,
  `U_EMEP` tinyint(4) DEFAULT NULL,
  `wind_dir` double DEFAULT NULL,
  `wind_dir_EMEP` tinyint(4) DEFAULT NULL,
  `eta` double DEFAULT NULL,
  `eta_EMEP` tinyint(4) DEFAULT NULL,
  `theta` double DEFAULT NULL,
  `theta_EMEP` tinyint(4) DEFAULT NULL,
  `beta` double DEFAULT NULL,
  `beta_EMEP` tinyint(4) DEFAULT NULL,
  `c_lag` double DEFAULT NULL,
  `c_lag_EMEP` tinyint(4) DEFAULT NULL,
  `h_lag` double DEFAULT NULL,
  `h_lag_EMEP` tinyint(4) DEFAULT NULL,
  `err_packet` double DEFAULT NULL,
  `err_packet_EMEP` tinyint(4) DEFAULT NULL,
  `licor_t_std` double DEFAULT NULL,
  `licor_t_std_EMEP` tinyint(4) DEFAULT NULL,
  `licor_t_av` double DEFAULT NULL,
  `licor_t_av_EMEP` tinyint(4) DEFAULT NULL,
  `licor_p_std` double DEFAULT NULL,
  `licor_p_std_EMEP` tinyint(4) DEFAULT NULL,
  `licor_p_av` double DEFAULT NULL,
  `licor_p_av_EMEP` tinyint(4) DEFAULT NULL,
  `F_CPC` double DEFAULT NULL,
  `F_CPC_EMEP` tinyint(4) DEFAULT NULL,
  `Qc_F_CPC` int(11) DEFAULT NULL,
  `Qc_F_CPC_EMEP` tinyint(4) DEFAULT NULL,
  `std_CPC` double DEFAULT NULL,
  `std_CPC_EMEP` tinyint(4) DEFAULT NULL,
  `av_CPC` double DEFAULT NULL,
  `av_CPC_EMEP` tinyint(4) DEFAULT NULL,
  `CPC_lag` double DEFAULT NULL,
  `CPC_lag_EMEP` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `TableMetadata`
--

DROP TABLE IF EXISTS `TableMetadata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `TableMetadata` (
  `tableID` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `identifier` varchar(80) NOT NULL,
  `title` varchar(80) NOT NULL,
  `spatial_coverage` varchar(80) NOT NULL,
  `name` varchar(80) NOT NULL,
  `period` smallint(5) DEFAULT NULL COMMENT 'Min',
  `ttimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`tableID`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `Tags`
--

DROP TABLE IF EXISTS `Tags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Tags` (
  `tagID` int(10) unsigned NOT NULL,
  `vocabulary` varchar(120) NOT NULL,
  `tag` varchar(100) NOT NULL,
  `displaykeyword` varchar(100) NOT NULL,
  PRIMARY KEY (`tagID`,`vocabulary`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `VAR_DMPS`
--

DROP TABLE IF EXISTS `VAR_DMPS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `VAR_DMPS` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `t1` float DEFAULT NULL,
  `t2` float DEFAULT NULL,
  `p1` float DEFAULT NULL,
  `p2` float DEFAULT NULL,
  `rh1` float DEFAULT NULL,
  `rh2` float DEFAULT NULL,
  `d100e1` float DEFAULT NULL,
  `d112e1` float DEFAULT NULL,
  `d126e1` float DEFAULT NULL,
  `d141e1` float DEFAULT NULL,
  `d158e1` float DEFAULT NULL,
  `d178e1` float DEFAULT NULL,
  `d200e1` float DEFAULT NULL,
  `d224e1` float DEFAULT NULL,
  `d251e1` float DEFAULT NULL,
  `d282e1` float DEFAULT NULL,
  `d316e1` float DEFAULT NULL,
  `d355e1` float DEFAULT NULL,
  `d398e1` float DEFAULT NULL,
  `d447e1` float DEFAULT NULL,
  `d501e1` float DEFAULT NULL,
  `d562e1` float DEFAULT NULL,
  `d631e1` float DEFAULT NULL,
  `d708e1` float DEFAULT NULL,
  `d794e1` float DEFAULT NULL,
  `d891e1` float DEFAULT NULL,
  `d100e2` float DEFAULT NULL,
  `d112e2` float DEFAULT NULL,
  `d126e2` float DEFAULT NULL,
  `d141e2` float DEFAULT NULL,
  `d158e2` float DEFAULT NULL,
  `d178e2` float DEFAULT NULL,
  `d200e2` float DEFAULT NULL,
  `d224e2` float DEFAULT NULL,
  `d251e2` float DEFAULT NULL,
  `d282e2` float DEFAULT NULL,
  `d316e2` float DEFAULT NULL,
  `d355e2` float DEFAULT NULL,
  `d398e2` float DEFAULT NULL,
  `d447e2` float DEFAULT NULL,
  `d501e2` float DEFAULT NULL,
  `d562e2` float DEFAULT NULL,
  `d631e2` float DEFAULT NULL,
  `d708e2` float DEFAULT NULL,
  `d794e2` float DEFAULT NULL,
  `d891e2` float DEFAULT NULL,
  `d100e3` float DEFAULT NULL,
  `d112e3` float DEFAULT NULL,
  `d126e3` float DEFAULT NULL,
  `d141e3` float DEFAULT NULL,
  `d158e3` float DEFAULT NULL,
  `d178e3` float DEFAULT NULL,
  `d200e3` float DEFAULT NULL,
  `d224e3` float DEFAULT NULL,
  `d251e3` float DEFAULT NULL,
  `d282e3` float DEFAULT NULL,
  `d316e3` float DEFAULT NULL,
  `d355e3` float DEFAULT NULL,
  `d398e3` float DEFAULT NULL,
  `d447e3` float DEFAULT NULL,
  `d501e3` float DEFAULT NULL,
  `d562e3` float DEFAULT NULL,
  `d631e3` float DEFAULT NULL,
  `d708e3` float DEFAULT NULL,
  `d794e3` float DEFAULT NULL,
  `d891e3` float DEFAULT NULL,
  `d100e4` float DEFAULT NULL,
  `tconc` float DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Varrio DMPS data';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `VAR_EDDY`
--

DROP TABLE IF EXISTS `VAR_EDDY`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `VAR_EDDY` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `H` double DEFAULT NULL,
  `H_EMEP` tinyint(4) DEFAULT NULL,
  `LE` double DEFAULT NULL,
  `LE_EMEP` tinyint(4) DEFAULT NULL,
  `E` double DEFAULT NULL,
  `E_EMEP` tinyint(4) DEFAULT NULL,
  `F_c` double DEFAULT NULL,
  `F_c_EMEP` tinyint(4) DEFAULT NULL,
  `tau` double DEFAULT NULL,
  `tau_EMEP` tinyint(4) DEFAULT NULL,
  `u_star` double DEFAULT NULL,
  `u_star_EMEP` tinyint(4) DEFAULT NULL,
  `MO_length` double DEFAULT NULL,
  `MO_length_EMEP` tinyint(4) DEFAULT NULL,
  `std_u` double DEFAULT NULL,
  `std_u_EMEP` tinyint(4) DEFAULT NULL,
  `std_v` double DEFAULT NULL,
  `std_v_EMEP` tinyint(4) DEFAULT NULL,
  `std_w` double DEFAULT NULL,
  `std_w_EMEP` tinyint(4) DEFAULT NULL,
  `std_t` double DEFAULT NULL,
  `std_t_EMEP` tinyint(4) DEFAULT NULL,
  `std_c` double DEFAULT NULL,
  `std_c_EMEP` tinyint(4) DEFAULT NULL,
  `std_h` double DEFAULT NULL,
  `std_h_EMEP` tinyint(4) DEFAULT NULL,
  `av_u` double DEFAULT NULL,
  `av_u_EMEP` tinyint(4) DEFAULT NULL,
  `av_v` double DEFAULT NULL,
  `av_v_EMEP` tinyint(4) DEFAULT NULL,
  `av_w` double DEFAULT NULL,
  `av_w_EMEP` tinyint(4) DEFAULT NULL,
  `av_t` double DEFAULT NULL,
  `av_t_EMEP` tinyint(4) DEFAULT NULL,
  `av_c` double DEFAULT NULL,
  `av_c_EMEP` tinyint(4) DEFAULT NULL,
  `av_h` double DEFAULT NULL,
  `av_h_EMEP` tinyint(4) DEFAULT NULL,
  `U` double DEFAULT NULL,
  `U_EMEP` tinyint(4) DEFAULT NULL,
  `wind_dir` double DEFAULT NULL,
  `wind_dir_EMEP` tinyint(4) DEFAULT NULL,
  `c_lag` double DEFAULT NULL,
  `c_lag_EMEP` tinyint(4) DEFAULT NULL,
  `h_lag` double DEFAULT NULL,
  `h_lag_EMEP` tinyint(4) DEFAULT NULL,
  `licor_t_std` double DEFAULT NULL,
  `licor_t_std_EMEP` tinyint(4) DEFAULT NULL,
  `licor_t_av` double DEFAULT NULL,
  `licor_t_av_EMEP` tinyint(4) DEFAULT NULL,
  `licor_p_std` double DEFAULT NULL,
  `licor_p_std_EMEP` tinyint(4) DEFAULT NULL,
  `licor_p_av` double DEFAULT NULL,
  `licor_p_av_EMEP` tinyint(4) DEFAULT NULL,
  `H_sub` double DEFAULT NULL,
  `H_sub_EMEP` tinyint(4) DEFAULT NULL,
  `LE_sub` double DEFAULT NULL,
  `LE_sub_EMEP` tinyint(4) DEFAULT NULL,
  `E_sub` double DEFAULT NULL,
  `E_sub_EMEP` tinyint(4) DEFAULT NULL,
  `F_c_sub` double DEFAULT NULL,
  `F_c_sub_EMEP` tinyint(4) DEFAULT NULL,
  `tau_sub` double DEFAULT NULL,
  `tau_sub_EMEP` tinyint(4) DEFAULT NULL,
  `u_star_sub` double DEFAULT NULL,
  `u_star_sub_EMEP` tinyint(4) DEFAULT NULL,
  `MO_length_sub` double DEFAULT NULL,
  `MO_length_sub_EMEP` tinyint(4) DEFAULT NULL,
  `std_u_sub` double DEFAULT NULL,
  `std_u_sub_EMEP` tinyint(4) DEFAULT NULL,
  `std_v_sub` double DEFAULT NULL,
  `std_v_sub_EMEP` tinyint(4) DEFAULT NULL,
  `std_w_sub` double DEFAULT NULL,
  `std_w_sub_EMEP` tinyint(4) DEFAULT NULL,
  `std_t_sub` double DEFAULT NULL,
  `std_t_sub_EMEP` tinyint(4) DEFAULT NULL,
  `std_c_sub` double DEFAULT NULL,
  `std_c_sub_EMEP` tinyint(4) DEFAULT NULL,
  `std_h_sub` double DEFAULT NULL,
  `std_h_sub_EMEP` tinyint(4) DEFAULT NULL,
  `av_u_sub` double DEFAULT NULL,
  `av_u_sub_EMEP` tinyint(4) DEFAULT NULL,
  `av_v_sub` double DEFAULT NULL,
  `av_v_sub_EMEP` tinyint(4) DEFAULT NULL,
  `av_w_sub` double DEFAULT NULL,
  `av_w_sub_EMEP` tinyint(4) DEFAULT NULL,
  `av_t_sub` double DEFAULT NULL,
  `av_t_sub_EMEP` tinyint(4) DEFAULT NULL,
  `av_c_sub` double DEFAULT NULL,
  `av_c_sub_EMEP` tinyint(4) DEFAULT NULL,
  `av_h_sub` double DEFAULT NULL,
  `av_h_sub_EMEP` tinyint(4) DEFAULT NULL,
  `U_sub` double DEFAULT NULL,
  `U_sub_EMEP` tinyint(4) DEFAULT NULL,
  `wind_dir_sub` double DEFAULT NULL,
  `wind_dir_sub_EMEP` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `VAR_HOURLY`
--

DROP TABLE IF EXISTS `VAR_HOURLY`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `VAR_HOURLY` (
  `SAMPTIME` datetime DEFAULT NULL,
  `WS0` double DEFAULT NULL,
  `WS1` double DEFAULT NULL,
  `WS2` double DEFAULT NULL,
  `WS3` double DEFAULT NULL,
  `WS4` double DEFAULT NULL,
  `RMM` double DEFAULT NULL,
  `TLOG` double DEFAULT NULL,
  `PAR` double DEFAULT NULL,
  `GLOB` double DEFAULT NULL,
  `REFL` double DEFAULT NULL,
  `NET` double DEFAULT NULL,
  `UVA` double DEFAULT NULL,
  `UVB` double DEFAULT NULL,
  `UVAT` double DEFAULT NULL,
  `UVBT` double DEFAULT NULL,
  `BAR` double DEFAULT NULL,
  `RAIN` double DEFAULT NULL,
  `TDRY0` double DEFAULT NULL,
  `TWET0` double DEFAULT NULL,
  `TDRY1` double DEFAULT NULL,
  `TWET1` double DEFAULT NULL,
  `TDRY2` double DEFAULT NULL,
  `TWET2` double DEFAULT NULL,
  `TDRY3` double DEFAULT NULL,
  `TWET3` double DEFAULT NULL,
  `TDRY4` double DEFAULT NULL,
  `TWET4` double DEFAULT NULL,
  `ST` double DEFAULT NULL,
  `WDIR` double DEFAULT NULL,
  `CPC1` double DEFAULT NULL,
  `CPC2` double DEFAULT NULL,
  `CPC3` double DEFAULT NULL,
  `CPC4` double DEFAULT NULL,
  `CO2_A_0` double DEFAULT NULL,
  `CO2_A_1` double DEFAULT NULL,
  `CO2_A_3` double DEFAULT NULL,
  `CO2_A_H` double DEFAULT NULL,
  `CO2_A_I` double DEFAULT NULL,
  `CO2_A_J` double DEFAULT NULL,
  `CO2_0_1` double DEFAULT NULL,
  `CO2_0_2` double DEFAULT NULL,
  `CO2_0_3` double DEFAULT NULL,
  `CO2_0_4` double DEFAULT NULL,
  `CO2_1_2` double DEFAULT NULL,
  `CO2_1_3` double DEFAULT NULL,
  `CO2_1_4` double DEFAULT NULL,
  `O3_0` double DEFAULT NULL,
  `O3_1` double DEFAULT NULL,
  `O3_2` double DEFAULT NULL,
  `O3_3` double DEFAULT NULL,
  `O3_4` double DEFAULT NULL,
  `SO2_0` double DEFAULT NULL,
  `SO2_1` double DEFAULT NULL,
  `SO2_2` double DEFAULT NULL,
  `SO2_3` double DEFAULT NULL,
  `SO2_4` double DEFAULT NULL,
  `NO_0` double DEFAULT NULL,
  `NO_1` double DEFAULT NULL,
  `NO_2` double DEFAULT NULL,
  `NO_4` double DEFAULT NULL,
  `NOX_0` double DEFAULT NULL,
  `NOX_1` double DEFAULT NULL,
  `NOX_2` double DEFAULT NULL,
  `NOX_4` double DEFAULT NULL,
  `P` double DEFAULT NULL,
  `HUM_RH` double DEFAULT NULL,
  `HUM_T` double DEFAULT NULL,
  `temp` double DEFAULT NULL,
  `WS00` double DEFAULT NULL,
  `visibility` double DEFAULT NULL,
  `rainint` double DEFAULT NULL,
  `rainintmax` double DEFAULT NULL,
  `rainintmin` double DEFAULT NULL,
  `Precipacc` double DEFAULT NULL,
  `wthcodemin` int(11) DEFAULT NULL,
  `wthcodemax` int(11) DEFAULT NULL,
  `haildiammax` double DEFAULT NULL,
  `snowint` double DEFAULT NULL,
  `snowintmin` double DEFAULT NULL,
  `snowintmax` double DEFAULT NULL,
  `visibilitylpm` double DEFAULT NULL,
  `visibilitylpmmin` double DEFAULT NULL,
  `visibilitylpmmax` double DEFAULT NULL,
  `wthcode` int(11) DEFAULT NULL,
  `CO_1` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `VAR_META`
--

DROP TABLE IF EXISTS `VAR_META`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `VAR_META` (
  `SAMPTIME` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `WS0` double DEFAULT NULL,
  `WS1` double DEFAULT NULL,
  `WS2` double DEFAULT NULL,
  `WS3` double DEFAULT NULL,
  `WS4` double DEFAULT NULL,
  `RMM` double DEFAULT NULL,
  `TLOG` double DEFAULT NULL,
  `PAR` double DEFAULT NULL,
  `GLOB` double DEFAULT NULL,
  `REFL` double DEFAULT NULL,
  `NET` double DEFAULT NULL,
  `UVA` double DEFAULT NULL,
  `UVB` double DEFAULT NULL,
  `UVAT` double DEFAULT NULL,
  `UVBT` double DEFAULT NULL,
  `RAIN` double DEFAULT NULL,
  `TDRY0` double DEFAULT NULL,
  `TWET0` double DEFAULT NULL,
  `TDRY1` double DEFAULT NULL,
  `TWET1` double DEFAULT NULL,
  `TDRY2` double DEFAULT NULL,
  `TWET2` double DEFAULT NULL,
  `TDRY3` double DEFAULT NULL,
  `TWET3` double DEFAULT NULL,
  `TDRY4` double DEFAULT NULL,
  `TWET4` double DEFAULT NULL,
  `ST` double DEFAULT NULL,
  `WDIR` double DEFAULT NULL,
  `CPC1` double DEFAULT NULL,
  `O3_0` double DEFAULT NULL,
  `O3_1` double DEFAULT NULL,
  `O3_2` double DEFAULT NULL,
  `O3_3` double DEFAULT NULL,
  `O3_4` double DEFAULT NULL,
  `SO2_0` double DEFAULT NULL,
  `SO2_1` double DEFAULT NULL,
  `SO2_2` double DEFAULT NULL,
  `SO2_3` double DEFAULT NULL,
  `SO2_4` double DEFAULT NULL,
  `NO_0` double DEFAULT NULL,
  `NO_1` double DEFAULT NULL,
  `NO_2` double DEFAULT NULL,
  `NO_4` double DEFAULT NULL,
  `NOX_0` double DEFAULT NULL,
  `NOX_1` double DEFAULT NULL,
  `NOX_2` double DEFAULT NULL,
  `NOX_4` double DEFAULT NULL,
  `P` double DEFAULT NULL,
  `HUM_RH` double DEFAULT NULL,
  `HUM_T` double DEFAULT NULL,
  `temp` double DEFAULT NULL,
  `WS00` double DEFAULT NULL,
  `visibility` double DEFAULT NULL,
  `rainint` double DEFAULT NULL,
  `Precipacc` double DEFAULT NULL,
  `haildiammax` double DEFAULT NULL,
  `snowint` double DEFAULT NULL,
  `visibilitylpm` double DEFAULT NULL,
  `wthcode` int(11) DEFAULT NULL,
  `CO_1` double DEFAULT NULL,
  `quality` int(11) DEFAULT '0',
  `Tsoil` double DEFAULT NULL,
  `wsoil` double DEFAULT NULL,
  `CO206` double DEFAULT NULL,
  `CO2soil` double DEFAULT NULL,
  `WS0_EMEP` tinyint(4) DEFAULT NULL,
  `WS1_EMEP` tinyint(4) DEFAULT NULL,
  `WS2_EMEP` tinyint(4) DEFAULT NULL,
  `WS3_EMEP` tinyint(4) DEFAULT NULL,
  `WS4_EMEP` tinyint(4) DEFAULT NULL,
  `RMM_EMEP` tinyint(4) DEFAULT NULL,
  `TLOG_EMEP` tinyint(4) DEFAULT NULL,
  `PAR_EMEP` tinyint(4) DEFAULT NULL,
  `GLOB_EMEP` tinyint(4) DEFAULT NULL,
  `REFL_EMEP` tinyint(4) DEFAULT NULL,
  `NET_EMEP` tinyint(4) DEFAULT NULL,
  `UVA_EMEP` tinyint(4) DEFAULT NULL,
  `UVB_EMEP` tinyint(4) DEFAULT NULL,
  `UVAT_EMEP` tinyint(4) DEFAULT NULL,
  `UVBT_EMEP` tinyint(4) DEFAULT NULL,
  `RAIN_EMEP` tinyint(4) DEFAULT NULL,
  `TDRY0_EMEP` tinyint(4) DEFAULT NULL,
  `TWET0_EMEP` tinyint(4) DEFAULT NULL,
  `TDRY1_EMEP` tinyint(4) DEFAULT NULL,
  `TWET1_EMEP` tinyint(4) DEFAULT NULL,
  `TDRY2_EMEP` tinyint(4) DEFAULT NULL,
  `TWET2_EMEP` tinyint(4) DEFAULT NULL,
  `TDRY3_EMEP` tinyint(4) DEFAULT NULL,
  `TWET3_EMEP` tinyint(4) DEFAULT NULL,
  `TDRY4_EMEP` tinyint(4) DEFAULT NULL,
  `TWET4_EMEP` tinyint(4) DEFAULT NULL,
  `ST_EMEP` tinyint(4) DEFAULT NULL,
  `WDIR_EMEP` tinyint(4) DEFAULT NULL,
  `CPC1_EMEP` tinyint(4) DEFAULT NULL,
  `O3_0_EMEP` tinyint(4) DEFAULT NULL,
  `O3_1_EMEP` tinyint(4) DEFAULT NULL,
  `O3_2_EMEP` tinyint(4) DEFAULT NULL,
  `O3_3_EMEP` tinyint(4) DEFAULT NULL,
  `O3_4_EMEP` tinyint(4) DEFAULT NULL,
  `SO2_0_EMEP` tinyint(4) DEFAULT NULL,
  `SO2_1_EMEP` tinyint(4) DEFAULT NULL,
  `SO2_2_EMEP` tinyint(4) DEFAULT NULL,
  `SO2_3_EMEP` tinyint(4) DEFAULT NULL,
  `SO2_4_EMEP` tinyint(4) DEFAULT NULL,
  `NO_0_EMEP` tinyint(4) DEFAULT NULL,
  `NO_1_EMEP` tinyint(4) DEFAULT NULL,
  `NO_2_EMEP` tinyint(4) DEFAULT NULL,
  `NO_4_EMEP` tinyint(4) DEFAULT NULL,
  `NOX_0_EMEP` tinyint(4) DEFAULT NULL,
  `NOX_1_EMEP` tinyint(4) DEFAULT NULL,
  `NOX_2_EMEP` tinyint(4) DEFAULT NULL,
  `NOX_4_EMEP` tinyint(4) DEFAULT NULL,
  `P_EMEP` tinyint(4) DEFAULT NULL,
  `HUM_RH_EMEP` tinyint(4) DEFAULT NULL,
  `HUM_T_EMEP` tinyint(4) DEFAULT NULL,
  `temp_EMEP` tinyint(4) DEFAULT NULL,
  `WS00_EMEP` tinyint(4) DEFAULT NULL,
  `visibility_EMEP` tinyint(4) DEFAULT NULL,
  `rainint_EMEP` tinyint(4) DEFAULT NULL,
  `Precipacc_EMEP` tinyint(4) DEFAULT NULL,
  `haildiammax_EMEP` tinyint(4) DEFAULT NULL,
  `snowint_EMEP` tinyint(4) DEFAULT NULL,
  `visibilitylpm_EMEP` tinyint(4) DEFAULT NULL,
  `wthcode_EMEP` tinyint(4) DEFAULT NULL,
  `CO_1_EMEP` tinyint(4) DEFAULT NULL,
  `Tsoil_EMEP` tinyint(4) DEFAULT NULL,
  `wsoil_EMEP` tinyint(4) DEFAULT NULL,
  `CO206_EMEP` tinyint(4) DEFAULT NULL,
  `CO2soil_EMEP` tinyint(4) DEFAULT NULL,
  `H2O_0` double DEFAULT NULL,
  `H2O_1` double DEFAULT NULL,
  `H2O_2` double DEFAULT NULL,
  `H2O_3` double DEFAULT NULL,
  `H2O_4` double DEFAULT NULL,
  `H2O_0_EMEP` tinyint(4) DEFAULT NULL,
  `H2O_1_EMEP` tinyint(4) DEFAULT NULL,
  `H2O_2_EMEP` tinyint(4) DEFAULT NULL,
  `H2O_3_EMEP` tinyint(4) DEFAULT NULL,
  `H2O_4_EMEP` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`SAMPTIME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `VAR_TREE`
--

DROP TABLE IF EXISTS `VAR_TREE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `VAR_TREE` (
  `samptime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `F_CO2_tree0` double DEFAULT NULL,
  `F_H2O_tree0` double DEFAULT NULL,
  `Tcuv_tree0` double DEFAULT NULL,
  `PARcuv_tree0` double DEFAULT NULL,
  `CO2_tree0` double DEFAULT NULL,
  `H2O_tree0` double DEFAULT NULL,
  `F_CO2_tree1` double DEFAULT NULL,
  `F_H2O_tree1` double DEFAULT NULL,
  `Tcuv_tree1` double DEFAULT NULL,
  `PARcuv_tree1` double DEFAULT NULL,
  `CO2_tree1` double DEFAULT NULL,
  `H2O_tree1` double DEFAULT NULL,
  `F_CO2_tree2` double DEFAULT NULL,
  `F_H2O_tree2` double DEFAULT NULL,
  `Tcuv_tree2` double DEFAULT NULL,
  `PARcuv_tree2` double DEFAULT NULL,
  `CO2_tree2` double DEFAULT NULL,
  `H2O_tree2` double DEFAULT NULL,
  `F_CO2_tree3` double DEFAULT NULL,
  `F_H2O_tree3` double DEFAULT NULL,
  `Tcuv_tree3` double DEFAULT NULL,
  `PARcuv_tree3` double DEFAULT NULL,
  `CO2_tree3` double DEFAULT NULL,
  `H2O_tree3` double DEFAULT NULL,
  `F_CO2_tree0_EMEP` tinyint(4) DEFAULT NULL,
  `F_H2O_tree0_EMEP` tinyint(4) DEFAULT NULL,
  `Tcuv_tree0_EMEP` tinyint(4) DEFAULT NULL,
  `PARcuv_tree0_EMEP` tinyint(4) DEFAULT NULL,
  `CO2_tree0_EMEP` tinyint(4) DEFAULT NULL,
  `H2O_tree0_EMEP` tinyint(4) DEFAULT NULL,
  `F_CO2_tree1_EMEP` tinyint(4) DEFAULT NULL,
  `F_H2O_tree1_EMEP` tinyint(4) DEFAULT NULL,
  `Tcuv_tree1_EMEP` tinyint(4) DEFAULT NULL,
  `PARcuv_tree1_EMEP` tinyint(4) DEFAULT NULL,
  `CO2_tree1_EMEP` tinyint(4) DEFAULT NULL,
  `H2O_tree1_EMEP` tinyint(4) DEFAULT NULL,
  `F_CO2_tree2_EMEP` tinyint(4) DEFAULT NULL,
  `F_H2O_tree2_EMEP` tinyint(4) DEFAULT NULL,
  `Tcuv_tree2_EMEP` tinyint(4) DEFAULT NULL,
  `PARcuv_tree2_EMEP` tinyint(4) DEFAULT NULL,
  `CO2_tree2_EMEP` tinyint(4) DEFAULT NULL,
  `H2O_tree2_EMEP` tinyint(4) DEFAULT NULL,
  `F_CO2_tree3_EMEP` tinyint(4) DEFAULT NULL,
  `F_H2O_tree3_EMEP` tinyint(4) DEFAULT NULL,
  `Tcuv_tree3_EMEP` tinyint(4) DEFAULT NULL,
  `PARcuv_tree3_EMEP` tinyint(4) DEFAULT NULL,
  `CO2_tree3_EMEP` tinyint(4) DEFAULT NULL,
  `H2O_tree3_EMEP` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`samptime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `VariableMetadata`
--

DROP TABLE IF EXISTS `VariableMetadata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `VariableMetadata` (
  `variableID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tableID` smallint(5) unsigned NOT NULL,
  `variable` varchar(80) NOT NULL,
  `description` varchar(1024) NOT NULL,
  `type` varchar(30) NOT NULL,
  `unit` varchar(20) DEFAULT NULL,
  `title` varchar(80) NOT NULL,
  `source` varchar(80) NOT NULL,
  `period_start` datetime NOT NULL,
  `period_end` datetime DEFAULT NULL,
  `coverage` tinyint(4) NOT NULL COMMENT '%',
  `rights` varchar(255) NOT NULL,
  `category` varchar(20) DEFAULT NULL,
  `mandatory` tinyint(1) NOT NULL,
  `derivative` tinyint(1) NOT NULL,
  `vtimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`variableID`),
  KEY `fk_tableID_1_idx` (`tableID`),
  CONSTRAINT `fk_tableID_1` FOREIGN KEY (`tableID`) REFERENCES `TableMetadata` (`tableID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1118 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `station`
--

DROP TABLE IF EXISTS `station`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `station` (
  `stationID` tinyint(3) unsigned NOT NULL,
  `dcmipoint` varchar(80) NOT NULL,
  `name` varchar(20) NOT NULL,
  `dataAvail` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `variableEvent`
--

DROP TABLE IF EXISTS `variableEvent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `variableEvent` (
  `eventID` int(10) unsigned NOT NULL,
  `variableID` int(10) unsigned NOT NULL,
  PRIMARY KEY (`eventID`,`variableID`),
  KEY `fk_variableEvent_2_idx` (`variableID`),
  CONSTRAINT `fk_variableEvent_1` FOREIGN KEY (`eventID`) REFERENCES `Events` (`eventID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_variableEvent_2` FOREIGN KEY (`variableID`) REFERENCES `VariableMetadata` (`variableID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `variableTags`
--

DROP TABLE IF EXISTS `variableTags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `variableTags` (
  `variableID` int(10) unsigned NOT NULL,
  `TagID` int(10) unsigned NOT NULL,
  KEY `variableID` (`variableID`),
  KEY `TagID` (`TagID`),
  CONSTRAINT `variableTags_ibfk_1` FOREIGN KEY (`variableID`) REFERENCES `VariableMetadata` (`variableID`),
  CONSTRAINT `variableTags_ibfk_2` FOREIGN KEY (`TagID`) REFERENCES `Tags` (`tagID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2015-02-16 14:48:43
