PX05x324

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 `eleves`
20--
21
22DROP TABLE IF EXISTS `eleves`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `eleves` (
26  `dossier` int(11) NOT NULL AUTO_INCREMENT,
27  `nom` varchar(45) NOT NULL,
28  `prenom` varchar(45) NOT NULL,
29  `adresse` varchar(45) NOT NULL,
30  PRIMARY KEY (`dossier`)
31) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Dumping data for table `eleves`
36--
37
38LOCK TABLES `eleves` WRITE;
39/*!40000 ALTER TABLE `eleves` DISABLE KEYS */;
40INSERT INTO `eleves` VALUES (1,'Inspecteur','Gadget','Dinotopia'),(2,'Vandame','Jean-Claude','City'),(3,'Lucky','Luke','Colorado'),(4,'Valjean','Jean','Poitier'),(5,'Hugo','Victor','Anger'),(6,'Coco','L\'asticot','Kaamelott'),(7,'Les malheurs','Sophie','Versailles'),(8,'Lilith','Anne','Doomtown'),(9,'Lol','Laurie','France'),(10,'Chrome','Google','Silicon Valley');
41/*!40000 ALTER TABLE `eleves` ENABLE KEYS */;
42UNLOCK TABLES;
43
44--
45-- Table structure for table `formateurs`
46--
47
48DROP TABLE IF EXISTS `formateurs`;
49/*!40101 SET @saved_cs_client     = @@character_set_client */;
50/*!40101 SET character_set_client = utf8 */;
51CREATE TABLE `formateurs` (
52  `dossier` int(11) NOT NULL AUTO_INCREMENT,
53  `nom` varchar(45) NOT NULL,
54  `prenom` varchar(45) NOT NULL,
55  `langage` varchar(45) NOT NULL,
56  PRIMARY KEY (`dossier`)
57) ENGINE=InnoDB DEFAULT CHARSET=utf8;
58/*!40101 SET character_set_client = @saved_cs_client */;
59
60--
61-- Dumping data for table `formateurs`
62--
63
64LOCK TABLES `formateurs` WRITE;
65/*!40000 ALTER TABLE `formateurs` DISABLE KEYS */;
66/*!40000 ALTER TABLE `formateurs` ENABLE KEYS */;
67UNLOCK TABLES;
68
69--
70-- Table structure for table `reservations`
71--
72
73DROP TABLE IF EXISTS `reservations`;
74/*!40101 SET @saved_cs_client     = @@character_set_client */;
75/*!40101 SET character_set_client = utf8 */;
76CREATE TABLE `reservations` (
77  `id` int(11) NOT NULL AUTO_INCREMENT,
78  `date` date NOT NULL,
79  `duree` int(11) NOT NULL,
80  `formateurs_dossier` int(11) DEFAULT NULL,
81  `salles_salle` int(11) NOT NULL,
82  `eleves_dossier` int(11) DEFAULT NULL,
83  PRIMARY KEY (`id`),
84  KEY `fk_reservations_formateurs1_idx` (`formateurs_dossier`),
85  KEY `fk_reservations_salles1_idx` (`salles_salle`),
86  KEY `fk_reservations_eleves1_idx` (`eleves_dossier`),
87  CONSTRAINT `fk_reservations_eleves1` FOREIGN KEY (`eleves_dossier`) REFERENCES `eleves` (`dossier`) ON DELETE NO ACTION ON UPDATE NO ACTION,
88  CONSTRAINT `fk_reservations_formateurs1` FOREIGN KEY (`formateurs_dossier`) REFERENCES `formateurs` (`dossier`) ON DELETE NO ACTION ON UPDATE NO ACTION,
89  CONSTRAINT `fk_reservations_salles1` FOREIGN KEY (`salles_salle`) REFERENCES `salles` (`salle`) 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 `reservations`
95--
96
97LOCK TABLES `reservations` WRITE;
98/*!40000 ALTER TABLE `reservations` DISABLE KEYS */;
99INSERT INTO `reservations` VALUES (1,'2020-03-17',2,NULL,1,1),(2,'2020-03-17',2,NULL,1,2),(3,'2020-03-17',2,NULL,1,3),(4,'2021-03-17',2,NULL,5,4),(5,'2021-03-17',2,NULL,5,5),(6,'2022-03-17',2,NULL,3,6),(7,'2023-03-17',2,NULL,6,7),(8,'2023-03-17',2,NULL,6,8),(9,'2023-03-17',2,NULL,6,9),(10,'2023-03-17',2,NULL,6,10);
100/*!40000 ALTER TABLE `reservations` ENABLE KEYS */;
101UNLOCK TABLES;
102
103--
104-- Table structure for table `salles`
105--
106
107DROP TABLE IF EXISTS `salles`;
108/*!40101 SET @saved_cs_client     = @@character_set_client */;
109/*!40101 SET character_set_client = utf8 */;
110CREATE TABLE `salles` (
111  `salle` int(11) NOT NULL AUTO_INCREMENT,
112  `nom` varchar(45) NOT NULL,
113  PRIMARY KEY (`salle`)
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 `salles`
119--
120
121LOCK TABLES `salles` WRITE;
122/*!40000 ALTER TABLE `salles` DISABLE KEYS */;
123INSERT INTO `salles` VALUES (1,'Dojo'),(2,'Réunion'),(3,'Repos'),(4,'Cuisine'),(5,'Bureau'),(6,'OpenSpace');
124/*!40000 ALTER TABLE `salles` 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:19:40