· 8 years ago · Mar 25, 2018, 11:34 AM
1CREATE DATABASE IF NOT EXISTS `mydb` /*!40100 DEFAULT CHARACTER SET utf8 */;
2USE `mydb`;
3-- MySQL dump 10.13 Distrib 5.7.21, for Linux (x86_64)
4--
5-- Host: localhost Database: mydb
6-- ------------------------------------------------------
7-- Server version 5.7.21-0ubuntu0.17.10.1
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `ecoles`
22--
23
24DROP TABLE IF EXISTS `ecoles`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `ecoles` (
28 `id` int(11) NOT NULL AUTO_INCREMENT,
29 `name` varchar(45) DEFAULT NULL,
30 PRIMARY KEY (`id`)
31) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Dumping data for table `ecoles`
36--
37
38LOCK TABLES `ecoles` WRITE;
39/*!40000 ALTER TABLE `ecoles` DISABLE KEYS */;
40INSERT INTO `ecoles` VALUES (1,'Orleans');
41/*!40000 ALTER TABLE `ecoles` ENABLE KEYS */;
42UNLOCK TABLES;
43
44--
45-- Table structure for table `langages`
46--
47
48DROP TABLE IF EXISTS `langages`;
49/*!40101 SET @saved_cs_client = @@character_set_client */;
50/*!40101 SET character_set_client = utf8 */;
51CREATE TABLE `langages` (
52 `id` int(11) NOT NULL AUTO_INCREMENT,
53 `name` varchar(45) DEFAULT NULL,
54 PRIMARY KEY (`id`)
55) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
56/*!40101 SET character_set_client = @saved_cs_client */;
57
58--
59-- Dumping data for table `langages`
60--
61
62LOCK TABLES `langages` WRITE;
63/*!40000 ALTER TABLE `langages` DISABLE KEYS */;
64INSERT INTO `langages` VALUES (1,'php');
65/*!40000 ALTER TABLE `langages` ENABLE KEYS */;
66UNLOCK TABLES;
67
68--
69-- Table structure for table `personnes`
70--
71
72DROP TABLE IF EXISTS `personnes`;
73/*!40101 SET @saved_cs_client = @@character_set_client */;
74/*!40101 SET character_set_client = utf8 */;
75CREATE TABLE `personnes` (
76 `id` int(11) NOT NULL AUTO_INCREMENT,
77 `nom` varchar(45) DEFAULT NULL,
78 `prenom` varchar(45) DEFAULT NULL,
79 `adresse` varchar(200) DEFAULT NULL,
80 `ecoles_id` int(11) NOT NULL,
81 `role_id` int(11) NOT NULL,
82 `langage_id` int(11) NOT NULL,
83 PRIMARY KEY (`id`),
84 KEY `fk_personnes_ecoles_idx` (`ecoles_id`),
85 KEY `fk_personnes_role1_idx` (`role_id`),
86 KEY `fk_personnes_langages1_idx` (`langage_id`),
87 CONSTRAINT `fk_personnes_ecoles` FOREIGN KEY (`ecoles_id`) REFERENCES `ecoles` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
88 CONSTRAINT `fk_personnes_langages1` FOREIGN KEY (`langage_id`) REFERENCES `langages` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
89 CONSTRAINT `fk_personnes_role1` FOREIGN KEY (`role_id`) REFERENCES `role` (`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 `personnes`
95--
96
97LOCK TABLES `personnes` WRITE;
98/*!40000 ALTER TABLE `personnes` DISABLE KEYS */;
99INSERT INTO `personnes` VALUES (1,'goggle','g','orleans',1,1,1),(2,'lorie','l','orleans',1,1,1),(3,'marie','m','orleans',1,1,1),(4,'justine','j','orleans',1,1,1),(5,'pierre','p','orleans',1,1,1),(6,'henri','h','orleans',1,1,1),(7,'martin','m','orleans',1,1,1),(8,'paul','p','orleans',1,1,1),(9,'thomas','t','orleans',1,1,1),(10,'laura','l','orleans',1,1,1);
100/*!40000 ALTER TABLE `personnes` ENABLE KEYS */;
101UNLOCK TABLES;
102
103--
104-- Table structure for table `reservation`
105--
106
107DROP TABLE IF EXISTS `reservation`;
108/*!40101 SET @saved_cs_client = @@character_set_client */;
109/*!40101 SET character_set_client = utf8 */;
110CREATE TABLE `reservation` (
111 `id` int(11) NOT NULL AUTO_INCREMENT,
112 `jour_heure` varchar(100) DEFAULT NULL,
113 `duree` varchar(45) DEFAULT NULL,
114 `salle_id` int(11) NOT NULL,
115 `personnes_id` int(11) NOT NULL,
116 PRIMARY KEY (`id`),
117 KEY `fk_reservation_salle1_idx` (`salle_id`),
118 KEY `fk_reservation_personnes1_idx` (`personnes_id`),
119 CONSTRAINT `fk_reservation_personnes1` FOREIGN KEY (`personnes_id`) REFERENCES `personnes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
120 CONSTRAINT `fk_reservation_salle1` FOREIGN KEY (`salle_id`) REFERENCES `salle` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
121) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
122/*!40101 SET character_set_client = @saved_cs_client */;
123
124--
125-- Dumping data for table `reservation`
126--
127
128LOCK TABLES `reservation` WRITE;
129/*!40000 ALTER TABLE `reservation` DISABLE KEYS */;
130INSERT INTO `reservation` VALUES (1,'lundi 8h','1h',3,1),(2,'mardi 8h','1h',3,2),(3,'mercredi 8h','1h',3,3),(4,'jeudi 8h','1h',7,4),(5,'vendredi 8h','1h',7,5),(6,'lundi 9h','1h',5,6),(7,'mardi 9h','1h',8,7),(8,'mercredi 9h','1h',8,8),(9,'jeudi 9h','1h',8,9),(10,'vendredi 9h','1h',8,10);
131/*!40000 ALTER TABLE `reservation` ENABLE KEYS */;
132UNLOCK TABLES;
133
134--
135-- Table structure for table `role`
136--
137
138DROP TABLE IF EXISTS `role`;
139/*!40101 SET @saved_cs_client = @@character_set_client */;
140/*!40101 SET character_set_client = utf8 */;
141CREATE TABLE `role` (
142 `id` int(11) NOT NULL AUTO_INCREMENT,
143 `name` varchar(45) DEFAULT NULL,
144 PRIMARY KEY (`id`)
145) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
146/*!40101 SET character_set_client = @saved_cs_client */;
147
148--
149-- Dumping data for table `role`
150--
151
152LOCK TABLES `role` WRITE;
153/*!40000 ALTER TABLE `role` DISABLE KEYS */;
154INSERT INTO `role` VALUES (1,'formateur'),(2,'eleve');
155/*!40000 ALTER TABLE `role` ENABLE KEYS */;
156UNLOCK TABLES;
157
158--
159-- Table structure for table `salle`
160--
161
162DROP TABLE IF EXISTS `salle`;
163/*!40101 SET @saved_cs_client = @@character_set_client */;
164/*!40101 SET character_set_client = utf8 */;
165CREATE TABLE `salle` (
166 `id` int(11) NOT NULL AUTO_INCREMENT,
167 `name` varchar(45) DEFAULT NULL,
168 `ecole_id` int(11) NOT NULL,
169 PRIMARY KEY (`id`),
170 KEY `fk_salle_ecoles1_idx` (`ecole_id`),
171 CONSTRAINT `fk_salle_ecoles1` FOREIGN KEY (`ecole_id`) REFERENCES `ecoles` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
172) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
173/*!40101 SET character_set_client = @saved_cs_client */;
174
175--
176-- Dumping data for table `salle`
177--
178
179LOCK TABLES `salle` WRITE;
180/*!40000 ALTER TABLE `salle` DISABLE KEYS */;
181INSERT INTO `salle` VALUES (1,NULL,1),(3,'Salle de dojo',1),(4,'Salle de réunion',1),(5,'Salle de repos',1),(6,'Cuisine',1),(7,'Bureau',1),(8,'OpenSpace',1);
182/*!40000 ALTER TABLE `salle` ENABLE KEYS */;
183UNLOCK TABLES;
184/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
185
186/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
187/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
188/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
189/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
190/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
191/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
192/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
193
194-- Dump completed on 2018-03-16 17:48:11