k6RnePMa

1--- -	2018-04-04 11:29:15.814760640 +0200
2+++ /home/lucas-p/lucas_p_wcs_lille.sql	2018-04-04 11:29:10.548707007 +0200
3@@ -45,9 +45,65 @@
4 
5 LOCK TABLES `colleague` WRITE;
6 /*!40000 ALTER TABLE `colleague` DISABLE KEYS */;
7-INSERT INTO `colleague` VALUES ('Bruges','Louis',26,'Loos'),('Lucky','Google',36,'Far-West'),('Martens','Finn',17,'Terre de Ooo'),('Sanchez','Rick',63,'Terre C-137'),('Tin','Lorie',32,'Bruxelles');
8+INSERT INTO `colleague` VALUES ('Bruges','Louis',26,'Loos'),('Hendrix','Jimmy',27,'Woodstock'),('Lee','Bruce',33,'Shangai'),('Lucky','Google',36,'Far-West'),('Martens','Finn',17,'Terre de Ooo'),('Sanchez','Rick',63,'Terre C-137'),('Simpson','Homer',33,'Springfield'),('Sponge','Bob',12,'Bikini Bottom'),('Tin','Lorie',32,'Bruxelles'),('Vega','Vincent',30,'Los Angeles');
9 /*!40000 ALTER TABLE `colleague` ENABLE KEYS */;
10 UNLOCK TABLES;
11+
12+--
13+-- Table structure for table `reserv`
14+--
15+
16+DROP TABLE IF EXISTS `reserv`;
17+/*!40101 SET @saved_cs_client     = @@character_set_client */;
18+/*!40101 SET character_set_client = utf8 */;
19+CREATE TABLE `reserv` (
20+  `id` int(11) NOT NULL AUTO_INCREMENT,
21+  `dateRes` date NOT NULL,
22+  `hDebut` time NOT NULL,
23+  `hFin` time NOT NULL,
24+  `nomCol` varchar(40) NOT NULL,
25+  `idSal` int(11) NOT NULL,
26+  PRIMARY KEY (`id`),
27+  KEY `nomCol` (`nomCol`),
28+  KEY `idSal` (`idSal`),
29+  CONSTRAINT `reserv_ibfk_1` FOREIGN KEY (`nomCol`) REFERENCES `colleague` (`nom`),
30+  CONSTRAINT `reserv_ibfk_2` FOREIGN KEY (`idSal`) REFERENCES `salle` (`id`)
31+) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
32+/*!40101 SET character_set_client = @saved_cs_client */;
33+
34+--
35+-- Dumping data for table `reserv`
36+--
37+
38+LOCK TABLES `reserv` WRITE;
39+/*!40000 ALTER TABLE `reserv` DISABLE KEYS */;
40+INSERT INTO `reserv` VALUES (1,'2018-04-23','15:00:00','16:30:00','Simpson',1),(2,'2018-04-23','15:00:00','16:30:00','Sponge',1),(3,'2018-04-23','15:00:00','16:30:00','Bruges',1),(4,'2018-04-12','10:15:00','12:30:00','Tin',5),(5,'2018-04-12','10:15:00','12:30:00','Lucky',5),(6,'2018-05-02','12:00:00','14:30:00','Martens',3),(7,'2018-05-17','14:30:00','18:00:00','Lee',6),(8,'2018-05-17','14:30:00','18:00:00','Hendrix',6),(9,'2018-05-17','14:30:00','18:00:00','Vega',6),(10,'2018-05-17','14:30:00','18:00:00','Sanchez',6);
41+/*!40000 ALTER TABLE `reserv` ENABLE KEYS */;
42+UNLOCK TABLES;
43+
44+--
45+-- Table structure for table `salle`
46+--
47+
48+DROP TABLE IF EXISTS `salle`;
49+/*!40101 SET @saved_cs_client     = @@character_set_client */;
50+/*!40101 SET character_set_client = utf8 */;
51+CREATE TABLE `salle` (
52+  `id` int(11) NOT NULL AUTO_INCREMENT,
53+  `nom` varchar(40) NOT NULL,
54+  PRIMARY KEY (`id`)
55+) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
56+/*!40101 SET character_set_client = @saved_cs_client */;
57+
58+--
59+-- Dumping data for table `salle`
60+--
61+
62+LOCK TABLES `salle` WRITE;
63+/*!40000 ALTER TABLE `salle` DISABLE KEYS */;
64+INSERT INTO `salle` VALUES (1,'Salle de dojo'),(2,'Salle de réunion'),(3,'Salle de repos'),(4,'Cuisine'),(5,'Bureau'),(6,'OpenSpace');
65+/*!40000 ALTER TABLE `salle` ENABLE KEYS */;
66+UNLOCK TABLES;
67 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
68 
69 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
70@@ -58,4 +114,4 @@
71 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
72 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
73 
74--- Dump completed on 2018-03-27 18:28:09
75+-- Dump completed on 2018-04-04 11:29:10