-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generato il: Dic 06, 2015 alle 12:13
-- Versione del server: 5.5.37-0ubuntu0.14.04.1
-- Versione PHP: 5.5.9-1ubuntu4.2

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `OscarDB`
--
CREATE DATABASE IF NOT EXISTS `OscarDB` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `OscarDB`;

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

--
-- Struttura della tabella `gps`
--
-- Creazione: Ago 08, 2014 alle 09:22
--

DROP TABLE IF EXISTS `gps`;
CREATE TABLE IF NOT EXISTS `gps` (
  `id_gps` int(11) NOT NULL AUTO_INCREMENT,
  `latitude` float(15,12) NOT NULL,
  `longitude` float(15,12) NOT NULL,
  `height` float(10,5) NOT NULL,
  `latitudeErr` float(8,5) NOT NULL,
  `longitudeErr` float(8,5) NOT NULL,
  `heightErr` float(8,5) NOT NULL,
  `elevation` float(5,2) NOT NULL,
  `data` datetime DEFAULT NULL,
  PRIMARY KEY (`id_gps`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=120332 ;

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

--
-- Struttura della tabella `humidity`
--
-- Creazione: Lug 16, 2015 alle 10:52
--

DROP TABLE IF EXISTS `humidity`;
CREATE TABLE IF NOT EXISTS `humidity` (
  `id_humidity` int(11) NOT NULL AUTO_INCREMENT,
  `humidity_value` float(10,2) NOT NULL,
  `data` datetime DEFAULT NULL,
  PRIMARY KEY (`id_humidity`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=767932 ;

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

--
-- Struttura della tabella `ipwv`
--
-- Creazione: Lug 16, 2015 alle 10:52
--

DROP TABLE IF EXISTS `ipwv`;
CREATE TABLE IF NOT EXISTS `ipwv` (
  `id_ipwv` int(11) NOT NULL AUTO_INCREMENT,
  `ipwv_value` float(10,2) NOT NULL,
  `data` datetime DEFAULT NULL,
  PRIMARY KEY (`id_ipwv`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=321317 ;

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

--
-- Struttura della tabella `pressure`
--
-- Creazione: Lug 16, 2015 alle 10:52
--

DROP TABLE IF EXISTS `pressure`;
CREATE TABLE IF NOT EXISTS `pressure` (
  `id_pressure` int(11) NOT NULL AUTO_INCREMENT,
  `pressure_value` float(10,2) NOT NULL,
  `data` datetime DEFAULT NULL,
  PRIMARY KEY (`id_pressure`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=783011 ;

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

--
-- Struttura della tabella `radiance`
--
-- Creazione: Lug 02, 2014 alle 12:04
--

DROP TABLE IF EXISTS `radiance`;
CREATE TABLE IF NOT EXISTS `radiance` (
  `id_radiance` int(11) NOT NULL AUTO_INCREMENT,
  `radiance_value` float(10,2) NOT NULL,
  `data` datetime DEFAULT NULL,
  PRIMARY KEY (`id_radiance`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=83991 ;

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

--
-- Struttura della tabella `raingauge`
--
-- Creazione: Lug 02, 2014 alle 12:04
--

DROP TABLE IF EXISTS `raingauge`;
CREATE TABLE IF NOT EXISTS `raingauge` (
  `id_raingauge` int(11) NOT NULL AUTO_INCREMENT,
  `raingauge_value` int(11) NOT NULL,
  `data` datetime DEFAULT NULL,
  PRIMARY KEY (`id_raingauge`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1032593 ;

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

--
-- Struttura della tabella `temperature`
--
-- Creazione: Lug 16, 2015 alle 10:53
--

DROP TABLE IF EXISTS `temperature`;
CREATE TABLE IF NOT EXISTS `temperature` (
  `id_temperature` int(11) NOT NULL AUTO_INCREMENT,
  `temperature_value` float(10,2) NOT NULL,
  `data` datetime DEFAULT NULL,
  PRIMARY KEY (`id_temperature`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=890532 ;

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

--
-- Struttura della tabella `troposphericDelay`
--
-- Creazione: Mar 13, 2015 alle 14:34
--

DROP TABLE IF EXISTS `troposphericDelay`;
CREATE TABLE IF NOT EXISTS `troposphericDelay` (
  `id_td` int(11) NOT NULL AUTO_INCREMENT,
  `latitude` float(15,12) NOT NULL,
  `longitude` float(15,12) NOT NULL,
  `height` float(10,5) NOT NULL,
  `latitudeErr` float(8,5) NOT NULL,
  `longitudeErr` float(8,5) NOT NULL,
  `heightErr` float(8,5) NOT NULL,
  `prn` int(11) NOT NULL,
  `elevation` float(5,2) NOT NULL,
  `td` float(10,5) NOT NULL,
  `data` datetime DEFAULT NULL,
  PRIMARY KEY (`id_td`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2602145 ;

/*!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 */;
