-- MySQL dump 10.13  Distrib 5.7.20, for Linux (x86_64)
--
-- Host: localhost    Database: biker
-- ------------------------------------------------------
-- Server version   5.7.20

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

--
-- Dumping data for table `accessories`
--

LOCK TABLES `accessories` WRITE;
/*!40000 ALTER TABLE `accessories` DISABLE KEYS */;
INSERT INTO `accessories` VALUES (1,2,1,'Product 1',50,60),(2,1,1,'Product 2',40,50),(3,4,3,'Product 54',120,100);
/*!40000 ALTER TABLE `accessories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `accessories_types`
--

LOCK TABLES `accessories_types` WRITE;
/*!40000 ALTER TABLE `accessories_types` DISABLE KEYS */;
INSERT INTO `accessories_types` VALUES (1,'Zadel',NULL),(2,'Handschoenen','Van echt leer.'),(3,'Licht','Xenon lampen');
/*!40000 ALTER TABLE `accessories_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `addresses`
--

LOCK TABLES `addresses` WRITE;
/*!40000 ALTER TABLE `addresses` DISABLE KEYS */;
INSERT INTO `addresses` VALUES (1,'Mangrovestraat',5,NULL,'5037JH','Tilburg','Nederland'),(2,'Mijnsherenlaan',89,'D','3081GG','Rotterdam','Nederland'),(3,'de Lint',81,NULL,'4761XN','Zevenbergen','Nederland');
/*!40000 ALTER TABLE `addresses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `bike_types`
--

LOCK TABLES `bike_types` WRITE;
/*!40000 ALTER TABLE `bike_types` DISABLE KEYS */;
INSERT INTO `bike_types` VALUES (1,'Oma','Oma fietsen'),(2,'City','City bikes'),(3,'Cruiser','Cruiser bikes');
/*!40000 ALTER TABLE `bike_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `bikes`
--

LOCK TABLES `bikes` WRITE;
/*!40000 ALTER TABLE `bikes` DISABLE KEYS */;
INSERT INTO `bikes` VALUES (1,3,3,'A','M',50,75,NULL),(2,2,2,'A','M',300,250,NULL),(3,1,1,'A','M',250,275,NULL);
/*!40000 ALTER TABLE `bikes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `brands`
--

LOCK TABLES `brands` WRITE;
/*!40000 ALTER TABLE `brands` DISABLE KEYS */;
INSERT INTO `brands` VALUES (1,'Gazelle','Gazelle fietsen'),(2,'Lidl','Lidl bikes'),(3,'Aldi','Aldi fietsen'),(4,'Batavus','Batavus fietsen');
/*!40000 ALTER TABLE `brands` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `payment_methods`
--

LOCK TABLES `payment_methods` WRITE;
/*!40000 ALTER TABLE `payment_methods` DISABLE KEYS */;
INSERT INTO `payment_methods` VALUES (1,'Contant'),(2,'PIN'),(3,'iDeal'),(4,'Paypal');
/*!40000 ALTER TABLE `payment_methods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `payments`
--

LOCK TABLES `payments` WRITE;
/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
INSERT INTO `payments` VALUES (1,1,500),(2,2,400),(3,2,300),(4,1,247);
/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `rent_agreements`
--

LOCK TABLES `rent_agreements` WRITE;
/*!40000 ALTER TABLE `rent_agreements` DISABLE KEYS */;
INSERT INTO `rent_agreements` VALUES (1,1,'2017-11-20 18:09:40','R','AV77473773','2017-11-20 18:09:16','2017-11-22 18:09:16',400,100,NULL),(2,2,'2017-11-20 18:10:13','R','AV73737472','2017-11-20 18:09:59','2018-11-20 18:09:59',300,80,NULL),(3,4,'2017-11-20 18:10:42','R','AV37727347','2017-11-25 18:09:59','2017-11-27 18:09:59',500,125,NULL);
/*!40000 ALTER TABLE `rent_agreements` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `rent_agreements_has_accessories`
--

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

--
-- Dumping data for table `rent_agreements_has_bikes`
--

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

--
-- Dumping data for table `roles`
--

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES (1,'Klant','Klant rol'),(2,'Medewerker','Medewerker rol'),(3,'Administratie','Administratie rol');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'woutervu','34819d7beeabb9260a5c854bc85b3e44','Wouter','van Unen','M','1991-11-23','0681357460',1),(2,'joris','34819d7beeabb9260a5c854bc85b3e44','Joris','van Kuijk','M','1992-11-22','0685475478',2),(3,'randy','0d28e4080dc8f64fc9603639bb7aa1b9','Randy','Stuurmans','M','1993-11-21','0654124547',3),(4,'danielle','f1bc69265be1165f64296bcb7ca180d5','Danielle','van Aavendonk','M','1994-11-20','0665985658',NULL);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `users_has_roles`
--

LOCK TABLES `users_has_roles` WRITE;
/*!40000 ALTER TABLE `users_has_roles` DISABLE KEYS */;
INSERT INTO `users_has_roles` VALUES (1,1),(1,2),(2,2),(3,2),(3,3);
/*!40000 ALTER TABLE `users_has_roles` 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 2017-11-20 18:13:54