-- MySQL dump 10.13  Distrib 8.0.23, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: projectone
-- ------------------------------------------------------
-- Server version	8.0.23

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

DROP TABLE IF EXISTS `actuator`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `actuator` (
  `Actuatorid` int NOT NULL AUTO_INCREMENT,
  `Naam` varchar(45) DEFAULT NULL,
  `Beschrijving` varchar(145) DEFAULT NULL,
  PRIMARY KEY (`Actuatorid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `actuator`
--

LOCK TABLES `actuator` WRITE;
/*!40000 ALTER TABLE `actuator` DISABLE KEYS */;
INSERT INTO `actuator` VALUES (1,'LCD','Display die toont wat jij zegt dat het moet aantonen'),(2,'ISD1820 Sound module','Soundmodule waarmee je geluiden kan opnemen en afspelen');
/*!40000 ALTER TABLE `actuator` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `historiekactuator`
--

DROP TABLE IF EXISTS `historiekactuator`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `historiekactuator` (
  `Historiekid` int NOT NULL,
  `Actuatorid` int DEFAULT NULL,
  `Meting` float NOT NULL,
  `DatumTijd` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`Historiekid`),
  KEY `FK_historiek_actuator_idx` (`Actuatorid`),
  CONSTRAINT `FK_historiek_actuator` FOREIGN KEY (`Actuatorid`) REFERENCES `actuator` (`Actuatorid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `historiekactuator`
--

LOCK TABLES `historiekactuator` WRITE;
/*!40000 ALTER TABLE `historiekactuator` DISABLE KEYS */;
INSERT INTO `historiekactuator` VALUES (1,1,12,'2021-05-24 21:24:14'),(2,2,11,'2021-05-24 21:24:14'),(3,1,18,'2021-05-24 21:24:14'),(4,2,11,'2021-05-24 21:24:14'),(5,2,12,'2021-05-24 21:24:14'),(6,2,13,'2021-05-24 21:24:14'),(7,1,16,'2021-05-24 21:24:14'),(8,2,18,'2021-05-24 21:24:14'),(9,1,17,'2021-05-24 21:24:14'),(10,1,11,'2021-05-24 21:24:14'),(11,1,15,'2021-05-24 21:24:14'),(12,1,19,'2021-05-24 21:24:14'),(13,1,19,'2021-05-24 21:24:14'),(14,1,16,'2021-05-24 21:24:14'),(15,1,11,'2021-05-24 21:24:14'),(16,2,15,'2021-05-24 21:24:14'),(17,2,11,'2021-05-24 21:24:14'),(18,2,15,'2021-05-24 21:24:14'),(19,2,17,'2021-05-24 21:24:14'),(20,1,12,'2021-05-24 21:24:14'),(21,1,18,'2021-05-24 21:24:14'),(22,2,13,'2021-05-24 21:24:14'),(23,1,19,'2021-05-24 21:24:14'),(24,2,16,'2021-05-24 21:24:14'),(25,2,11,'2021-05-24 21:24:14'),(26,2,12,'2021-05-24 21:24:14'),(27,2,14,'2021-05-24 21:24:14'),(28,1,15,'2021-05-24 21:24:14'),(29,2,13,'2021-05-24 21:24:14'),(30,2,13,'2021-05-24 21:24:14'),(31,2,18,'2021-05-24 21:24:14'),(32,2,14,'2021-05-24 21:24:14'),(33,2,19,'2021-05-24 21:24:14'),(34,2,14,'2021-05-24 21:24:14'),(35,1,15,'2021-05-24 21:24:14'),(36,1,13,'2021-05-24 21:24:14'),(37,1,17,'2021-05-24 21:24:14'),(38,1,14,'2021-05-24 21:24:14'),(39,1,19,'2021-05-24 21:24:14'),(40,2,16,'2021-05-24 21:24:14'),(41,1,12,'2021-05-24 21:24:14'),(42,1,19,'2021-05-24 21:24:14'),(43,2,16,'2021-05-24 21:24:14'),(44,1,15,'2021-05-24 21:24:14'),(45,1,16,'2021-05-24 21:24:14'),(46,2,13,'2021-05-24 21:24:14'),(47,1,18,'2021-05-24 21:24:14'),(48,2,14,'2021-05-24 21:24:14'),(49,1,16,'2021-05-24 21:24:14'),(50,1,16,'2021-05-24 21:24:14');
/*!40000 ALTER TABLE `historiekactuator` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `historieksensor`
--

DROP TABLE IF EXISTS `historieksensor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `historieksensor` (
  `Historiekid` int NOT NULL,
  `Sensorid` int DEFAULT NULL,
  `Meting` float NOT NULL,
  `DatumTijd` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`Historiekid`),
  KEY `FK_historiek_sensor_idx` (`Sensorid`),
  CONSTRAINT `FK_historiek_sensor` FOREIGN KEY (`Sensorid`) REFERENCES `sensor` (`Sensorid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `historieksensor`
--

LOCK TABLES `historieksensor` WRITE;
/*!40000 ALTER TABLE `historieksensor` DISABLE KEYS */;
INSERT INTO `historieksensor` VALUES (1,1,12,'2021-05-24 21:24:14'),(2,1,11,'2021-05-24 21:24:14'),(3,2,18,'2021-05-24 21:24:14'),(4,1,11,'2021-05-24 21:24:14'),(5,3,12,'2021-05-24 21:24:14'),(6,1,13,'2021-05-24 21:24:14'),(7,2,16,'2021-05-24 21:24:14'),(8,3,18,'2021-05-24 21:24:14'),(9,2,17,'2021-05-24 21:24:14'),(10,1,11,'2021-05-24 21:24:14'),(11,3,15,'2021-05-24 21:24:14'),(12,2,19,'2021-05-24 21:24:14'),(13,2,19,'2021-05-24 21:24:14'),(14,2,16,'2021-05-24 21:24:14'),(15,2,11,'2021-05-24 21:24:14'),(16,3,15,'2021-05-24 21:24:14'),(17,3,11,'2021-05-24 21:24:14'),(18,3,15,'2021-05-24 21:24:14'),(19,1,17,'2021-05-24 21:24:14'),(20,3,12,'2021-05-24 21:24:14'),(21,1,18,'2021-05-24 21:24:14'),(22,1,13,'2021-05-24 21:24:14'),(23,2,19,'2021-05-24 21:24:14'),(24,1,16,'2021-05-24 21:24:14'),(25,2,11,'2021-05-24 21:24:14'),(26,1,12,'2021-05-24 21:24:14'),(27,3,14,'2021-05-24 21:24:14'),(28,2,15,'2021-05-24 21:24:14'),(29,1,13,'2021-05-24 21:24:14'),(30,1,13,'2021-05-24 21:24:14'),(31,2,18,'2021-05-24 21:24:14'),(32,1,14,'2021-05-24 21:24:14'),(33,1,19,'2021-05-24 21:24:14'),(34,2,14,'2021-05-24 21:24:14'),(35,2,15,'2021-05-24 21:24:14'),(36,1,13,'2021-05-24 21:24:14'),(37,3,17,'2021-05-24 21:24:14'),(38,2,14,'2021-05-24 21:24:14'),(39,1,19,'2021-05-24 21:24:14'),(40,2,16,'2021-05-24 21:24:14'),(41,2,12,'2021-05-24 21:24:14'),(42,2,19,'2021-05-24 21:24:14'),(43,1,16,'2021-05-24 21:24:14'),(44,2,15,'2021-05-24 21:24:14'),(45,1,16,'2021-05-24 21:24:14'),(46,1,13,'2021-05-24 21:24:14'),(47,3,18,'2021-05-24 21:24:14'),(48,2,14,'2021-05-24 21:24:14'),(49,3,16,'2021-05-24 21:24:14'),(50,2,16,'2021-05-24 21:24:14');
/*!40000 ALTER TABLE `historieksensor` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `score`
--

DROP TABLE IF EXISTS `score`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `score` (
  `Scoreid` int NOT NULL,
  `Naam` varchar(45) NOT NULL,
  `Score` int DEFAULT NULL,
  `Keuzespel` int DEFAULT NULL,
  `DatumTijd` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`Scoreid`),
  KEY `FK_score__keuze_idx` (`Keuzespel`),
  CONSTRAINT `FK_score__keuze` FOREIGN KEY (`Keuzespel`) REFERENCES `spelkeuze` (`Spelkeuzeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `score`
--

LOCK TABLES `score` WRITE;
/*!40000 ALTER TABLE `score` DISABLE KEYS */;
INSERT INTO `score` VALUES (1,'James',17,1,'2021-05-24 21:24:14'),(2,'Tom',20,3,'2021-05-24 21:24:14'),(3,'Tim',9,2,'2021-05-24 21:24:14'),(4,'Giles',18,1,'2021-05-24 21:24:14'),(5,'Kevin',8,2,'2021-05-24 21:24:14'),(6,'Kwinten',14,3,'2021-05-24 21:24:14'),(7,'James',17,3,'2021-05-24 21:24:14'),(8,'Tom',8,1,'2021-05-24 21:24:14'),(9,'Tim',16,3,'2021-05-24 21:24:14'),(10,'Giles',11,3,'2021-05-24 21:24:14'),(11,'Kevin',20,1,'2021-05-24 21:24:14'),(12,'Kwinten',13,1,'2021-05-24 21:24:14'),(13,'James',19,1,'2021-05-24 21:24:14'),(14,'Tom',15,2,'2021-05-24 21:24:14'),(15,'Tim',19,1,'2021-05-24 21:24:14'),(16,'Giles',8,3,'2021-05-24 21:24:14'),(17,'Kevin',18,3,'2021-05-24 21:24:14'),(18,'Kwinten',11,1,'2021-05-24 21:24:14'),(19,'James',11,1,'2021-05-24 21:24:14'),(20,'Tom',18,1,'2021-05-24 21:24:14'),(21,'Tim',11,1,'2021-05-24 21:24:14'),(22,'Giles',10,2,'2021-05-24 21:24:14'),(23,'Kevin',11,1,'2021-05-24 21:24:14'),(24,'Kwinten',18,1,'2021-05-24 21:24:14'),(25,'James',8,3,'2021-05-24 21:24:14'),(26,'Tom',16,3,'2021-05-24 21:24:14'),(27,'Tim',15,1,'2021-05-24 21:24:14'),(28,'Giles',9,2,'2021-05-24 21:24:14'),(29,'Kevin',19,2,'2021-05-24 21:24:14'),(30,'Kwinten',9,2,'2021-05-24 21:24:14'),(31,'James',10,2,'2021-05-24 21:24:14'),(32,'Tom',20,2,'2021-05-24 21:24:14'),(33,'Tim',16,3,'2021-05-24 21:24:14'),(34,'Giles',20,2,'2021-05-24 21:24:14'),(35,'Kevin',18,2,'2021-05-24 21:24:14'),(36,'Kwinten',20,3,'2021-05-24 21:24:14'),(37,'James',9,2,'2021-05-24 21:24:14'),(38,'Tom',12,1,'2021-05-24 21:24:14'),(39,'Tim',16,2,'2021-05-24 21:24:14'),(40,'Giles',12,3,'2021-05-24 21:24:14'),(41,'Kevin',12,1,'2021-05-24 21:24:14'),(42,'Kwinten',18,3,'2021-05-24 21:24:14'),(43,'James',11,3,'2021-05-24 21:24:14'),(44,'Tom',12,2,'2021-05-24 21:24:14'),(45,'Tim',8,3,'2021-05-24 21:24:14'),(46,'Giles',13,3,'2021-05-24 21:24:14'),(47,'Kevin',9,2,'2021-05-24 21:24:14'),(48,'Kwinten',17,1,'2021-05-24 21:24:14'),(49,'James',11,1,'2021-05-24 21:24:14'),(50,'Tom',15,2,'2021-05-24 21:24:14');
/*!40000 ALTER TABLE `score` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sensor`
--

DROP TABLE IF EXISTS `sensor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sensor` (
  `Sensorid` int NOT NULL AUTO_INCREMENT,
  `Naam` varchar(45) NOT NULL,
  `Beschrijving` varchar(145) NOT NULL,
  `Meeteenheid` varchar(45) NOT NULL,
  PRIMARY KEY (`Sensorid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sensor`
--

LOCK TABLES `sensor` WRITE;
/*!40000 ALTER TABLE `sensor` DISABLE KEYS */;
INSERT INTO `sensor` VALUES (1,'HC-SR501 PIR motion sensor','Een sensor die aangeeft wanner er beweging is','volt'),(2,'HC-SR04 Ultrasone sensor','Een sensor die werkt met behulp van geluidsgolven','volt'),(3,'FSR Pressure Pad','Een sensor die bij aanraking een melding geeft','ohm');
/*!40000 ALTER TABLE `sensor` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `spelkeuze`
--

DROP TABLE IF EXISTS `spelkeuze`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `spelkeuze` (
  `Spelkeuzeid` int NOT NULL AUTO_INCREMENT,
  `Beschrijving` varchar(45) NOT NULL,
  `Minuten` int NOT NULL,
  PRIMARY KEY (`Spelkeuzeid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `spelkeuze`
--

LOCK TABLES `spelkeuze` WRITE;
/*!40000 ALTER TABLE `spelkeuze` DISABLE KEYS */;
INSERT INTO `spelkeuze` VALUES (1,'Eerste keuze: Je speelt 5 minuten',5),(2,'Tweede keuze: Je speelt 7 minuten',7),(3,'Derde keuze: Je speelt 10 minuten',10);
/*!40000 ALTER TABLE `spelkeuze` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2021-05-28 21:44:26