· 8 years ago · Mar 27, 2018, 11:34 PM
1-- MySQL dump 10.13 Distrib 5.7.21, for Linux (x86_64)
2--
3-- Host: localhost Database: WildcodeSchool
4-- ------------------------------------------------------
5-- Server version 5.7.21-0ubuntu0.16.04.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 `ecole`
20--
21
22DROP TABLE IF EXISTS `ecole`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `ecole` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `ville` varchar(25) DEFAULT NULL,
28 `adresse` varchar(255) NOT NULL,
29 `numero_de_telephone` int(11) NOT NULL,
30 PRIMARY KEY (`id`)
31) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Dumping data for table `ecole`
36--
37
38LOCK TABLES `ecole` WRITE;
39/*!40000 ALTER TABLE `ecole` DISABLE KEYS */;
40INSERT INTO `ecole` VALUES (1,'bodeaux','adresse bordeaux',111111),(2,'la loupe','adresse la loupe',2222),(3,'lille','adresse lille',3333),(4,'lyon','adresse lyon',4444),(5,'orleans','adresse orleans',55555),(6,'paris','adresse paris',6666),(7,'reims','adresse reims ',7777);
41/*!40000 ALTER TABLE `ecole` ENABLE KEYS */;
42UNLOCK TABLES;
43
44--
45-- Table structure for table `eleve`
46--
47
48DROP TABLE IF EXISTS `eleve`;
49/*!40101 SET @saved_cs_client = @@character_set_client */;
50/*!40101 SET character_set_client = utf8 */;
51CREATE TABLE `eleve` (
52 `id` int(11) NOT NULL AUTO_INCREMENT,
53 `nom` varchar(50) DEFAULT NULL,
54 `prenom` varchar(50) DEFAULT NULL,
55 `adresse` varchar(50) DEFAULT NULL,
56 `IDdossier` int(11) NOT NULL,
57 `langage` varchar(50) DEFAULT NULL,
58 `id_ecole` int(11) NOT NULL,
59 PRIMARY KEY (`id`),
60 KEY `FK_eleve_id_ecole` (`id_ecole`),
61 CONSTRAINT `FK_eleve_id_ecole` FOREIGN KEY (`id_ecole`) REFERENCES `ecole` (`id`)
62) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
63/*!40101 SET character_set_client = @saved_cs_client */;
64
65--
66-- Dumping data for table `eleve`
67--
68
69LOCK TABLES `eleve` WRITE;
70/*!40000 ALTER TABLE `eleve` DISABLE KEYS */;
71INSERT INTO `eleve` VALUES (1,'google','yahoo','usa',23,'php',1),(2,'laurie','pepet','france',89,'javascript',2),(3,'boloss','saint denis','paris ',909,'php',1),(4,'jiren','mechant','univers 9',9,'javascript',4),(5,'sangohan','san','univers 7 ',2222,'php',4),(6,'trunk','vegeta','univers 7',83736,'javascript',3),(7,'vegeta','prince','univers 7',474774,'php',4),(8,'goten','san','univers 7',1,'php',7),(9,'naruto','hockage','konoha',45,'javascript',3),(10,'macluckie','dimitri','16 rue des saules 33500 libourne ',300,'php',1);
72/*!40000 ALTER TABLE `eleve` ENABLE KEYS */;
73UNLOCK TABLES;
74
75--
76-- Table structure for table `formateur`
77--
78
79DROP TABLE IF EXISTS `formateur`;
80/*!40101 SET @saved_cs_client = @@character_set_client */;
81/*!40101 SET character_set_client = utf8 */;
82CREATE TABLE `formateur` (
83 `id` int(11) NOT NULL AUTO_INCREMENT,
84 `nom` varchar(50) DEFAULT NULL,
85 `prenom` varchar(50) DEFAULT NULL,
86 `IDdossier` int(11) DEFAULT NULL,
87 `langage` varchar(50) DEFAULT NULL,
88 `adresse` varchar(50) DEFAULT NULL,
89 `id_ecole` int(11) NOT NULL,
90 PRIMARY KEY (`id`),
91 KEY `FK_formateur_id_ecole` (`id_ecole`),
92 CONSTRAINT `FK_formateur_id_ecole` FOREIGN KEY (`id_ecole`) REFERENCES `ecole` (`id`)
93) ENGINE=InnoDB DEFAULT CHARSET=latin1;
94/*!40101 SET character_set_client = @saved_cs_client */;
95
96--
97-- Dumping data for table `formateur`
98--
99
100LOCK TABLES `formateur` WRITE;
101/*!40000 ALTER TABLE `formateur` DISABLE KEYS */;
102/*!40000 ALTER TABLE `formateur` ENABLE KEYS */;
103UNLOCK TABLES;
104
105--
106-- Table structure for table `reservation_eleve`
107--
108
109DROP TABLE IF EXISTS `reservation_eleve`;
110/*!40101 SET @saved_cs_client = @@character_set_client */;
111/*!40101 SET character_set_client = utf8 */;
112CREATE TABLE `reservation_eleve` (
113 `id` int(11) NOT NULL AUTO_INCREMENT,
114 `date_de_reservation` datetime NOT NULL,
115 `duree_de_reservation` int(11) NOT NULL,
116 `id_eleve` int(11) NOT NULL,
117 `id_salle` int(11) DEFAULT NULL,
118 PRIMARY KEY (`id`),
119 KEY `FK_reservation_eleve_id_eleve` (`id_eleve`),
120 KEY `FK_reservation_eleve_id_salle` (`id_salle`),
121 CONSTRAINT `FK_reservation_eleve_id_eleve` FOREIGN KEY (`id_eleve`) REFERENCES `eleve` (`id`),
122 CONSTRAINT `FK_reservation_eleve_id_salle` FOREIGN KEY (`id_salle`) REFERENCES `salle` (`id`)
123) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
124/*!40101 SET character_set_client = @saved_cs_client */;
125
126--
127-- Dumping data for table `reservation_eleve`
128--
129
130LOCK TABLES `reservation_eleve` WRITE;
131/*!40000 ALTER TABLE `reservation_eleve` DISABLE KEYS */;
132INSERT INTO `reservation_eleve` VALUES (1,'2018-03-19 11:00:00',1,1,1),(2,'2018-03-19 11:00:00',1,2,1),(3,'2018-03-19 11:00:00',1,3,1),(4,'2018-03-21 00:00:00',1,4,5),(5,'2018-03-21 15:00:00',1,5,5),(6,'2018-03-20 09:00:00',3,7,3),(7,'2018-03-23 11:00:00',1,6,6),(8,'2018-03-23 10:00:00',1,8,6),(9,'2018-03-23 10:00:00',1,9,6),(10,'2018-03-23 10:00:00',1,10,6);
133/*!40000 ALTER TABLE `reservation_eleve` ENABLE KEYS */;
134UNLOCK TABLES;
135
136--
137-- Table structure for table `reservation_formateur`
138--
139
140DROP TABLE IF EXISTS `reservation_formateur`;
141/*!40101 SET @saved_cs_client = @@character_set_client */;
142/*!40101 SET character_set_client = utf8 */;
143CREATE TABLE `reservation_formateur` (
144 `id` int(11) NOT NULL AUTO_INCREMENT,
145 `date_de_reservation` datetime NOT NULL,
146 `duree_de_reservation` int(11) NOT NULL,
147 `id_formateur` int(11) NOT NULL,
148 `id_salle` int(11) DEFAULT NULL,
149 PRIMARY KEY (`id`),
150 KEY `FK_reservation_formateur_id_formateur` (`id_formateur`),
151 KEY `FK_reservation_formateur_id_salle` (`id_salle`),
152 CONSTRAINT `FK_reservation_formateur_id_formateur` FOREIGN KEY (`id_formateur`) REFERENCES `formateur` (`id`),
153 CONSTRAINT `FK_reservation_formateur_id_salle` FOREIGN KEY (`id_salle`) REFERENCES `salle` (`id`)
154) ENGINE=InnoDB DEFAULT CHARSET=latin1;
155/*!40101 SET character_set_client = @saved_cs_client */;
156
157--
158-- Dumping data for table `reservation_formateur`
159--
160
161LOCK TABLES `reservation_formateur` WRITE;
162/*!40000 ALTER TABLE `reservation_formateur` DISABLE KEYS */;
163/*!40000 ALTER TABLE `reservation_formateur` ENABLE KEYS */;
164UNLOCK TABLES;
165
166--
167-- Table structure for table `salle`
168--
169
170DROP TABLE IF EXISTS `salle`;
171/*!40101 SET @saved_cs_client = @@character_set_client */;
172/*!40101 SET character_set_client = utf8 */;
173CREATE TABLE `salle` (
174 `id` int(11) NOT NULL AUTO_INCREMENT,
175 `numero_salle` varchar(25) NOT NULL,
176 `nom_de_la_salle` varchar(25) DEFAULT NULL,
177 `id_ecole` int(11) NOT NULL,
178 PRIMARY KEY (`id`),
179 KEY `FK_salle_id_ecole` (`id_ecole`),
180 CONSTRAINT `FK_salle_id_ecole` FOREIGN KEY (`id_ecole`) REFERENCES `ecole` (`id`)
181) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
182/*!40101 SET character_set_client = @saved_cs_client */;
183
184--
185-- Dumping data for table `salle`
186--
187
188LOCK TABLES `salle` WRITE;
189/*!40000 ALTER TABLE `salle` DISABLE KEYS */;
190INSERT INTO `salle` VALUES (1,'salle 1','salle de dojo',1),(2,'salle 4','salle de reunion',1),(3,'salle 4','salle de repos ',3),(4,'salle 78','cuisine',5),(5,'salle 39','bureau',4),(6,'salle 9','openspace',1);
191/*!40000 ALTER TABLE `salle` ENABLE KEYS */;
192UNLOCK TABLES;
193/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
194
195/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
196/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
197/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
198/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
199/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
200/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
201/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
202
203-- Dump completed on 2018-03-19 15:57:33