· 8 years ago · Mar 28, 2018, 03:20 AM
1-- MySQL dump 10.13 Distrib 5.7.21, for Linux (x86_64)
2--
3-- Host: localhost Database: mydb
4-- ------------------------------------------------------
5-- Server version 5.7.21-0ubuntu0.17.10.1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `Formateur`
20--
21
22DROP TABLE IF EXISTS `Formateur`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `Formateur` (
26 `ID` int(11) NOT NULL AUTO_INCREMENT,
27 `Nom` varchar(45) DEFAULT NULL,
28 `Prenom` varchar(45) DEFAULT NULL,
29 `Language` varchar(45) DEFAULT NULL,
30 PRIMARY KEY (`ID`)
31) ENGINE=InnoDB DEFAULT CHARSET=utf8;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Dumping data for table `Formateur`
36--
37
38LOCK TABLES `Formateur` WRITE;
39/*!40000 ALTER TABLE `Formateur` DISABLE KEYS */;
40/*!40000 ALTER TABLE `Formateur` ENABLE KEYS */;
41UNLOCK TABLES;
42
43--
44-- Table structure for table `Person`
45--
46
47DROP TABLE IF EXISTS `Person`;
48/*!40101 SET @saved_cs_client = @@character_set_client */;
49/*!40101 SET character_set_client = utf8 */;
50CREATE TABLE `Person` (
51 `ID` int(11) NOT NULL AUTO_INCREMENT,
52 `Nom` varchar(45) DEFAULT NULL,
53 `Prenom` varchar(45) DEFAULT NULL,
54 `Adresse` varchar(45) DEFAULT NULL,
55 PRIMARY KEY (`ID`)
56) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
57/*!40101 SET character_set_client = @saved_cs_client */;
58
59--
60-- Dumping data for table `Person`
61--
62
63LOCK TABLES `Person` WRITE;
64/*!40000 ALTER TABLE `Person` DISABLE KEYS */;
65INSERT INTO `Person` VALUES (1,'Google','Home','OnTheWeb'),(2,'Laurie','maMeilleurAmie',''),(3,'Uber','Thomash','Chez sa mère'),(4,'Picard','Quentin','Chez ton père'),(5,'Beauchamp','Yoan',NULL),(6,'Meckler','Xavier',NULL),(7,'Grillon','Steven',NULL),(8,'Huet','Sebastien',NULL),(9,'Berthier','Benjamin',NULL),(10,'Grina','Anas',NULL);
66/*!40000 ALTER TABLE `Person` ENABLE KEYS */;
67UNLOCK TABLES;
68
69--
70-- Table structure for table `Reservation`
71--
72
73DROP TABLE IF EXISTS `Reservation`;
74/*!40101 SET @saved_cs_client = @@character_set_client */;
75/*!40101 SET character_set_client = utf8 */;
76CREATE TABLE `Reservation` (
77 `ID` int(11) NOT NULL AUTO_INCREMENT,
78 `date` date DEFAULT NULL,
79 `Formateur_ID` int(11) DEFAULT NULL,
80 `Person_ID` int(11) DEFAULT NULL,
81 `Salle_ID` int(11) NOT NULL,
82 `durée` int(11) DEFAULT NULL,
83 PRIMARY KEY (`ID`),
84 KEY `fk_Reservation_Formateur_idx` (`Formateur_ID`),
85 KEY `fk_Reservation_Person1_idx` (`Person_ID`),
86 KEY `fk_Reservation_Salle1_idx` (`Salle_ID`),
87 CONSTRAINT `fk_Reservation_Formateur` FOREIGN KEY (`Formateur_ID`) REFERENCES `Formateur` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
88 CONSTRAINT `fk_Reservation_Person1` FOREIGN KEY (`Person_ID`) REFERENCES `Person` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
89 CONSTRAINT `fk_Reservation_Salle1` FOREIGN KEY (`Salle_ID`) REFERENCES `Salle` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
90) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
91/*!40101 SET character_set_client = @saved_cs_client */;
92
93--
94-- Dumping data for table `Reservation`
95--
96
97LOCK TABLES `Reservation` WRITE;
98/*!40000 ALTER TABLE `Reservation` DISABLE KEYS */;
99INSERT INTO `Reservation` VALUES (1,'2012-11-02',NULL,1,1,2),(2,'2014-02-02',NULL,2,1,3),(3,'2014-07-02',NULL,3,1,2),(4,'2016-07-02',NULL,4,5,2),(5,'2014-02-02',NULL,5,5,2),(6,'2014-02-02',NULL,6,3,2),(7,'2011-02-02',NULL,7,6,2),(8,'2012-05-02',NULL,8,6,2),(9,'2012-05-12',NULL,9,6,2),(10,'2012-06-12',NULL,10,6,2);
100/*!40000 ALTER TABLE `Reservation` ENABLE KEYS */;
101UNLOCK TABLES;
102
103--
104-- Table structure for table `Salle`
105--
106
107DROP TABLE IF EXISTS `Salle`;
108/*!40101 SET @saved_cs_client = @@character_set_client */;
109/*!40101 SET character_set_client = utf8 */;
110CREATE TABLE `Salle` (
111 `ID` int(11) NOT NULL AUTO_INCREMENT,
112 `Nom` varchar(45) DEFAULT NULL,
113 PRIMARY KEY (`ID`)
114) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
115/*!40101 SET character_set_client = @saved_cs_client */;
116
117--
118-- Dumping data for table `Salle`
119--
120
121LOCK TABLES `Salle` WRITE;
122/*!40000 ALTER TABLE `Salle` DISABLE KEYS */;
123INSERT INTO `Salle` VALUES (1,'Salle de dojo'),(2,'Salle de reunion'),(3,'Salle de repos'),(4,'Cuisine'),(5,'Bureau'),(6,'OpenSpace');
124/*!40000 ALTER TABLE `Salle` ENABLE KEYS */;
125UNLOCK TABLES;
126/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
127
128/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
129/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
130/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
131/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
132/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
133/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
134/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
135
136-- Dump completed on 2018-03-19 18:24:43