NwZmNYDU

1Resa Room:
2-- MySQL dump 10.13  Distrib 5.7.21, for Linux (x86_64)
3--
4-- Host: localhost    Database: reservationroom
5-- ------------------------------------------------------
6-- Server version	5.7.21-0ubuntu0.16.04.1
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
10/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
11/*!40101 SET NAMES utf8 */;
12/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
13/*!40103 SET TIME_ZONE='+00:00' */;
14/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
15/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
16/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
17/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
18
19--
20-- Current Database: `reservationroom`
21--
22
23CREATE DATABASE /*!32312 IF NOT EXISTS*/ `reservationroom` /*!40100 DEFAULT CHARACTER SET latin1 */;
24
25USE `reservationroom`;
26
27--
28-- Table structure for table `Personn`
29--
30
31DROP TABLE IF EXISTS `Personn`;
32/*!40101 SET @saved_cs_client     = @@character_set_client */;
33/*!40101 SET character_set_client = utf8 */;
34CREATE TABLE `Personn` (
35  `id` int(11) NOT NULL AUTO_INCREMENT,
36  `firstname` varchar(30) DEFAULT NULL,
37  `lastname` varchar(30) DEFAULT NULL,
38  `address` varchar(30) DEFAULT NULL,
39  `langage` varchar(30) DEFAULT NULL,
40  PRIMARY KEY (`id`)
41) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
42/*!40101 SET character_set_client = @saved_cs_client */;
43
44--
45-- Dumping data for table `Personn`
46--
47
48LOCK TABLES `Personn` WRITE;
49/*!40000 ALTER TABLE `Personn` DISABLE KEYS */;
50INSERT INTO `Personn` VALUES (1,'Lorie','Lumiere','rue de la star',NULL),(2,'Google','Search','Hollywood Road New-York',NULL),(3,'George','Sarr','Saint Cyperien',NULL),(4,'Nicolas','Hoarau','rue des Estudine',NULL),(5,'Hugo','Calas','Plaisance_du_Touch',NULL),(6,'Loic','Perrand','Rue des Loies',NULL),(7,'Benjamin','Barret','rue des arenes',NULL),(8,'Pablo','Leutchmann','allée de Gimont',NULL),(9,'Benoit','Hubert','rue du Prieuré','Javascript'),(10,'Bastien','Krettly','Place de la Bourse','Java');
51/*!40000 ALTER TABLE `Personn` ENABLE KEYS */;
52UNLOCK TABLES;
53
54--
55-- Table structure for table `Reservation`
56--
57
58DROP TABLE IF EXISTS `Reservation`;
59/*!40101 SET @saved_cs_client     = @@character_set_client */;
60/*!40101 SET character_set_client = utf8 */;
61CREATE TABLE `Reservation` (
62  `datetime` date DEFAULT NULL,
63  `duration` int(11) DEFAULT NULL,
64  `personn_id` int(11) DEFAULT NULL,
65  `room_id` int(11) DEFAULT NULL,
66  KEY `FK_Reservation_personn_id` (`personn_id`),
67  KEY `FK_Reservation_room_id` (`room_id`),
68  CONSTRAINT `FK_Reservation_personn_id` FOREIGN KEY (`personn_id`) REFERENCES `Personn` (`id`),
69  CONSTRAINT `FK_Reservation_room_id` FOREIGN KEY (`room_id`) REFERENCES `Room` (`id`)
70) ENGINE=InnoDB DEFAULT CHARSET=latin1;
71/*!40101 SET character_set_client = @saved_cs_client */;
72
73--
74-- Dumping data for table `Reservation`
75--
76
77LOCK TABLES `Reservation` WRITE;
78/*!40000 ALTER TABLE `Reservation` DISABLE KEYS */;
79INSERT INTO `Reservation` VALUES ('2018-01-01',230,1,1),('2018-01-02',130,1,1),('2018-01-03',150,3,1),('2018-01-04',300,4,5),('2018-01-05',230,5,5),('2018-01-06',400,6,3),('2018-01-07',200,7,6),('2018-03-07',200,7,6),('2018-04-15',150,8,6),('2018-05-14',300,9,6),('2018-06-15',150,10,6);
80/*!40000 ALTER TABLE `Reservation` ENABLE KEYS */;
81UNLOCK TABLES;
82
83--
84-- Table structure for table `Room`
85--
86
87DROP TABLE IF EXISTS `Room`;
88/*!40101 SET @saved_cs_client     = @@character_set_client */;
89/*!40101 SET character_set_client = utf8 */;
90CREATE TABLE `Room` (
91  `id` int(11) NOT NULL AUTO_INCREMENT,
92  `name` varchar(30) DEFAULT NULL,
93  PRIMARY KEY (`id`)
94) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
95/*!40101 SET character_set_client = @saved_cs_client */;
96
97--
98-- Dumping data for table `Room`
99--
100
101LOCK TABLES `Room` WRITE;
102/*!40000 ALTER TABLE `Room` DISABLE KEYS */;
103INSERT INTO `Room` VALUES (1,'dojo'),(2,'meeting'),(3,'break'),(4,'kitchen'),(5,'desk'),(6,'openspace');
104/*!40000 ALTER TABLE `Room` ENABLE KEYS */;
105UNLOCK TABLES;
106/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
107
108/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
109/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
110/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
111/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
112/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
113/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
114/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
115
116-- Dump completed on 2018-03-27 17:49:19