CREATE DATABASE  IF NOT EXISTS `project` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */;
USE `project`;
-- MySQL dump 10.13  Distrib 8.0.15, for Win64 (x86_64)
--
-- Host: localhost    Database: project
-- ------------------------------------------------------
-- Server version	8.0.15

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

DROP TABLE IF EXISTS `connectoren`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `connectoren` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `connectorNaam` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `connectoren`
--

LOCK TABLES `connectoren` WRITE;
/*!40000 ALTER TABLE `connectoren` DISABLE KEYS */;
INSERT INTO `connectoren` VALUES (1,'lightning'),(2,'micro usb a'),(3,'mini usb a'),(4,'usb a'),(5,'usb b'),(6,'hdmi'),(7,'vga'),(8,'dvi'),(9,'rj45'),(10,'rj11'),(11,'rj6'),(12,'usb c'),(13,'euro plug'),(14,'c7'),(15,'c13'),(16,'c5'),(17,'Schuko'),(18,'aux 3.5'),(19,'rca'),(20,'Auto voedingsadapter'),(21,'flash memory'),(22,'scart'),(23,'oortjes'),(24,'batterij');
/*!40000 ALTER TABLE `connectoren` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kabel_has_connectoren`
--

DROP TABLE IF EXISTS `kabel_has_connectoren`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `kabel_has_connectoren` (
  `kabel_id` int(10) NOT NULL,
  `connectoren_id` int(11) NOT NULL,
  PRIMARY KEY (`kabel_id`,`connectoren_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kabel_has_connectoren`
--

LOCK TABLES `kabel_has_connectoren` WRITE;
/*!40000 ALTER TABLE `kabel_has_connectoren` DISABLE KEYS */;
INSERT INTO `kabel_has_connectoren` VALUES (1,1),(1,4),(2,4),(2,12),(3,2),(4,4),(5,4),(5,5),(6,4),(6,13),(7,4),(7,20),(8,4),(8,21),(9,9),(10,10),(11,6),(12,8),(13,7),(14,6),(14,8),(15,4),(16,18),(17,19),(18,19),(18,22),(19,18),(19,23),(20,4),(20,24),(21,22),(22,16),(22,17),(23,15),(23,17),(24,13),(24,14);
/*!40000 ALTER TABLE `kabel_has_connectoren` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kabels`
--

DROP TABLE IF EXISTS `kabels`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `kabels` (
  `kabelId` int(11) NOT NULL AUTO_INCREMENT,
  `kabelnaam` varchar(45) NOT NULL,
  `plaats` int(11) DEFAULT NULL,
  PRIMARY KEY (`kabelId`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kabels`
--

LOCK TABLES `kabels` WRITE;
/*!40000 ALTER TABLE `kabels` DISABLE KEYS */;
INSERT INTO `kabels` VALUES (1,'lightning',1),(2,'usb-c',2),(3,'micro-usb',3),(4,'mini-usb',4),(5,'usb-b',5),(6,'usb-voeding',6),(7,'autolader',7),(8,'usb-stick',8),(9,'ethernet',9),(10,'telefoon',10),(11,'hdmi',11),(12,'dvi',12),(13,'vga',13),(14,'hdmi-dvi',14),(15,'usb-verleng',15),(16,'aux',16),(17,'rca',17),(18,'scart-rca',18),(19,'oortjes',19),(20,'powerbank',20),(21,'scart',21),(22,'lc5-voeding',22),(23,'c13-voeding',23),(24,'c7-voeding',24);
/*!40000 ALTER TABLE `kabels` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kabels_has_tags`
--

DROP TABLE IF EXISTS `kabels_has_tags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `kabels_has_tags` (
  `kabels_kabelId` int(11) NOT NULL,
  `tags_tagId` int(11) NOT NULL,
  PRIMARY KEY (`kabels_kabelId`,`tags_tagId`),
  KEY `fk_kabels_has_tags_tags1_idx` (`tags_tagId`),
  KEY `fk_kabels_has_tags_kabels1_idx` (`kabels_kabelId`),
  CONSTRAINT `fk_kabels_has_tags_kabels1` FOREIGN KEY (`kabels_kabelId`) REFERENCES `kabels` (`kabelId`),
  CONSTRAINT `fk_kabels_has_tags_tags1` FOREIGN KEY (`tags_tagId`) REFERENCES `tags` (`tagId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kabels_has_tags`
--

LOCK TABLES `kabels_has_tags` WRITE;
/*!40000 ALTER TABLE `kabels_has_tags` DISABLE KEYS */;
INSERT INTO `kabels_has_tags` VALUES (2,1),(3,1),(1,2),(1,3),(2,3),(3,3),(4,3),(5,3),(6,3),(7,3),(8,3),(15,3),(20,3),(1,4),(2,5),(1,6),(2,6),(11,7),(14,7),(18,7),(21,7),(2,8),(11,8),(12,8),(13,8),(14,8),(2,9),(9,10),(11,11),(12,11),(13,11),(14,11),(18,11),(21,11),(16,12),(17,12),(19,12),(6,13),(20,13),(22,13),(23,13),(24,13),(6,14),(22,14),(23,14),(24,14),(7,15),(16,16),(17,16),(19,16),(8,17);
/*!40000 ALTER TABLE `kabels_has_tags` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log`
--

DROP TABLE IF EXISTS `log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `log` (
  `idlog` int(11) NOT NULL AUTO_INCREMENT,
  `datum` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `persoon` int(11) NOT NULL,
  `kabel` int(11) NOT NULL,
  `hoeveelheid` varchar(45) NOT NULL,
  PRIMARY KEY (`idlog`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log`
--

LOCK TABLES `log` WRITE;
/*!40000 ALTER TABLE `log` DISABLE KEYS */;
INSERT INTO `log` VALUES (1,'2019-06-12 10:54:20',1,1,'10'),(2,'2019-06-12 10:54:21',1,2,'10'),(3,'2019-06-12 10:54:22',1,3,'7'),(4,'2019-06-12 10:54:23',1,4,'6'),(5,'2019-06-12 10:54:24',1,5,'12'),(6,'2019-06-12 10:54:25',1,6,'3');
/*!40000 ALTER TABLE `log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `persoon`
--

DROP TABLE IF EXISTS `persoon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `persoon` (
  `persoonId` int(11) NOT NULL AUTO_INCREMENT,
  `persoonNaam` varchar(45) DEFAULT NULL,
  `persoonVoorNaam` varchar(45) DEFAULT NULL,
  `badge` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`persoonId`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `persoon`
--

LOCK TABLES `persoon` WRITE;
/*!40000 ALTER TABLE `persoon` DISABLE KEYS */;
INSERT INTO `persoon` VALUES (1,'cluyse','jarmo','578848674690'),(2,'niet','gebadged',''),(3,'gebruiker','1','988646845845'),(4,'gebruiker','2','805202391932');
/*!40000 ALTER TABLE `persoon` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `plaats`
--

DROP TABLE IF EXISTS `plaats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `plaats` (
  `plaatsId` int(11) NOT NULL AUTO_INCREMENT,
  `row` int(11) DEFAULT NULL,
  `collum` int(11) DEFAULT NULL,
  PRIMARY KEY (`plaatsId`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `plaats`
--

LOCK TABLES `plaats` WRITE;
/*!40000 ALTER TABLE `plaats` DISABLE KEYS */;
INSERT INTO `plaats` VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4),(5,1,5),(6,2,1),(7,2,2),(8,2,3),(9,2,4),(10,2,5),(11,3,1),(12,3,2),(13,3,3),(14,3,4),(15,3,5),(16,4,1),(17,4,2),(18,4,3),(19,4,4),(20,4,5),(21,5,1),(22,5,2),(23,5,3),(24,5,4);
/*!40000 ALTER TABLE `plaats` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tags`
--

DROP TABLE IF EXISTS `tags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `tags` (
  `tagId` int(11) NOT NULL AUTO_INCREMENT,
  `tagbeschrijving` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`tagId`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tags`
--

LOCK TABLES `tags` WRITE;
/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
INSERT INTO `tags` VALUES (1,'samsung'),(2,'iphone'),(3,'usb'),(4,'apple'),(5,'macbook'),(6,'ipad'),(7,'tv'),(8,'monitor'),(9,'c'),(10,'internet'),(11,'beeld'),(12,'muziek'),(13,'voeding'),(14,'230V'),(15,'auto'),(16,'audio'),(17,'gegeugen');
/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'project'
--

--
-- Dumping routines for database 'project'
--
/*!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 2019-06-16 16:53:00
