-- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
--
-- Host: localhost    Database: project1
-- ------------------------------------------------------
-- Server version	5.7.17-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 `co`
--

DROP TABLE IF EXISTS `co`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `co` (
  `ID` int(11) NOT NULL,
  `Date` date DEFAULT NULL,
  `Time` time DEFAULT NULL,
  `CO_aanwezig` varchar(45) DEFAULT NULL,
  `Relatieve_kwaliteit_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `co`
--

LOCK TABLES `co` WRITE;
/*!40000 ALTER TABLE `co` DISABLE KEYS */;
INSERT INTO `co` VALUES (1,'2017-06-02','04:10:00','Gevaar!',3),(2,'2017-06-03','04:05:00','geen CO',1),(3,'2017-06-04','04:00:00','geen CO',1);
/*!40000 ALTER TABLE `co` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `co2`
--

DROP TABLE IF EXISTS `co2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `co2` (
  `ID` int(11) NOT NULL,
  `Date` date DEFAULT NULL,
  `Time` time DEFAULT NULL,
  `Waarde_ppm` decimal(15,1) DEFAULT NULL,
  `Stijging_daling_ppm` decimal(15,1) DEFAULT NULL,
  `relatieve_kwaliteit_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `co2`
--

LOCK TABLES `co2` WRITE;
/*!40000 ALTER TABLE `co2` DISABLE KEYS */;
INSERT INTO `co2` VALUES (1,'2017-06-02','04:10:00',1500.0,300.0,3),(2,'2017-06-03','04:05:00',1200.0,300.0,2),(3,'2017-06-04','04:00:00',900.0,NULL,1);
/*!40000 ALTER TABLE `co2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `luchtvochtigheid`
--

DROP TABLE IF EXISTS `luchtvochtigheid`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `luchtvochtigheid` (
  `ID` int(11) NOT NULL,
  `Date` date DEFAULT NULL,
  `Time` time DEFAULT NULL,
  `Waarde_procent` decimal(5,1) DEFAULT NULL,
  `Stijging_daling_procent` decimal(5,1) DEFAULT NULL,
  `Relatieve_kwaliteit_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `luchtvochtigheid`
--

LOCK TABLES `luchtvochtigheid` WRITE;
/*!40000 ALTER TABLE `luchtvochtigheid` DISABLE KEYS */;
INSERT INTO `luchtvochtigheid` VALUES (1,'2017-06-02','04:10:00',50.0,-5.0,2),(2,'2017-06-03','04:05:00',55.0,-25.0,2),(3,'2017-06-03','04:00:00',80.0,NULL,1);
/*!40000 ALTER TABLE `luchtvochtigheid` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `relatieve_kwaliteit`
--

DROP TABLE IF EXISTS `relatieve_kwaliteit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `relatieve_kwaliteit` (
  `ID` int(11) NOT NULL,
  `kwaliteit` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `relatieve_kwaliteit`
--

LOCK TABLES `relatieve_kwaliteit` WRITE;
/*!40000 ALTER TABLE `relatieve_kwaliteit` DISABLE KEYS */;
INSERT INTO `relatieve_kwaliteit` VALUES (1,'GOOD'),(2,'AVERAGE'),(3,'BAD');
/*!40000 ALTER TABLE `relatieve_kwaliteit` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `relay`
--

DROP TABLE IF EXISTS `relay`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `relay` (
  `ID` int(11) NOT NULL,
  `state` varchar(45) DEFAULT NULL,
  `relay` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `relay`
--

LOCK TABLES `relay` WRITE;
/*!40000 ALTER TABLE `relay` DISABLE KEYS */;
INSERT INTO `relay` VALUES (1,'1','230V_ALWAYS'),(2,'1','230V_GAS'),(3,'1','Motor');
/*!40000 ALTER TABLE `relay` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `systeem`
--

DROP TABLE IF EXISTS `systeem`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `systeem` (
  `ID` int(11) NOT NULL,
  `Temperatuur_ID` int(11) DEFAULT NULL,
  `CO_ID` int(11) DEFAULT NULL,
  `CO2_ID` int(11) DEFAULT NULL,
  `Fijnstof_ID` int(11) DEFAULT NULL,
  `Luchtvochtigheid_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `systeem`
--

LOCK TABLES `systeem` WRITE;
/*!40000 ALTER TABLE `systeem` DISABLE KEYS */;
INSERT INTO `systeem` VALUES (1,1,1,1,1,1),(2,2,2,2,2,2),(3,3,3,3,3,3);
/*!40000 ALTER TABLE `systeem` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `temperatuur`
--

DROP TABLE IF EXISTS `temperatuur`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temperatuur` (
  `ID` int(11) NOT NULL,
  `Date` date DEFAULT NULL,
  `Time` time DEFAULT NULL,
  `Waarde_celcius` decimal(5,1) DEFAULT NULL,
  `Stijging_daling_celsius` decimal(5,1) DEFAULT NULL,
  `waarde_fahrenheit` decimal(5,1) DEFAULT NULL,
  `stijging_daling_fahrenheit` decimal(5,1) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `temperatuur`
--

LOCK TABLES `temperatuur` WRITE;
/*!40000 ALTER TABLE `temperatuur` DISABLE KEYS */;
/*!40000 ALTER TABLE `temperatuur` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `time_between`
--

DROP TABLE IF EXISTS `time_between`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `time_between` (
  `ID` int(11) NOT NULL,
  `minutes` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `time_between`
--

LOCK TABLES `time_between` WRITE;
/*!40000 ALTER TABLE `time_between` DISABLE KEYS */;
/*!40000 ALTER TABLE `time_between` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'project1'
--

--
-- Dumping routines for database 'project1'
--
/*!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 2017-06-20  3:13:34
