· 8 years ago · Apr 11, 2018, 09:54 PM
1CREATE DATABASE IF NOT EXISTS `rado_r_wcs_bordeaux` /*!40100 DEFAULT CHARACTER SET utf8 */;
2USE `rado_r_wcs_bordeaux`;
3-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
4--
5-- Host: localhost Database: rado_r_wcs_bordeaux
6-- ------------------------------------------------------
7-- Server version 5.7.21-log
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 `eleves`
22--
23
24DROP TABLE IF EXISTS `eleves`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `eleves` (
28 `id` int(11) NOT NULL AUTO_INCREMENT,
29 `Nom` varchar(30) DEFAULT NULL,
30 `Prénom` varchar(30) DEFAULT NULL,
31 `Age` int(11) DEFAULT NULL,
32 `Lieu_de_résidence` varchar(50) DEFAULT NULL,
33 PRIMARY KEY (`id`)
34) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
35/*!40101 SET character_set_client = @saved_cs_client */;
36
37--
38-- Dumping data for table `eleves`
39--
40
41LOCK TABLES `eleves` WRITE;
42/*!40000 ALTER TABLE `eleves` DISABLE KEYS */;
43INSERT INTO `eleves` VALUES (1,'Sen','Orhan',25,'Bordeaux'),(2,'Rulqin','Simonn',35,'Bordeaux'),(3,'Dieng','Macodou',26,'Bordeaux'),(4,'Dos Santos','Marc',25,'Bordeaux'),(5,'Quetille','Pierrick',28,'Bordeaux'),(6,'Google','Google',25,'Silicon Valley'),(7,'Pester','Laurie',35,'Paris'),(8,'Mouse','Mickey',75,'NY'),(9,'Simpson','Homer',45,'Springfield'),(10,'Mario','Bros',36,'Nintendo');
44/*!40000 ALTER TABLE `eleves` ENABLE KEYS */;
45UNLOCK TABLES;
46
47--
48-- Table structure for table `formateur`
49--
50
51DROP TABLE IF EXISTS `formateur`;
52/*!40101 SET @saved_cs_client = @@character_set_client */;
53/*!40101 SET character_set_client = utf8 */;
54CREATE TABLE `formateur` (
55 `idformateur` int(11) NOT NULL AUTO_INCREMENT,
56 `nom` varchar(45) DEFAULT NULL,
57 `prénom` varchar(45) DEFAULT NULL,
58 `language` varchar(45) DEFAULT NULL,
59 PRIMARY KEY (`idformateur`)
60) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Dumping data for table `formateur`
65--
66
67LOCK TABLES `formateur` WRITE;
68/*!40000 ALTER TABLE `formateur` DISABLE KEYS */;
69INSERT INTO `formateur` VALUES (1,'Man','Bat','JS'),(2,'Verne','Jules','PHP'),(3,'Twain','Mark','Java');
70/*!40000 ALTER TABLE `formateur` ENABLE KEYS */;
71UNLOCK TABLES;
72
73--
74-- Table structure for table `reservation`
75--
76
77DROP TABLE IF EXISTS `reservation`;
78/*!40101 SET @saved_cs_client = @@character_set_client */;
79/*!40101 SET character_set_client = utf8 */;
80CREATE TABLE `reservation` (
81 `idreservation` int(11) NOT NULL AUTO_INCREMENT,
82 `début réservation` datetime DEFAULT NULL,
83 `fin réservation` datetime DEFAULT NULL,
84 `durée` int(11) DEFAULT NULL,
85 `fk_eleves` int(11) DEFAULT NULL,
86 `fk_formateur` int(11) DEFAULT NULL,
87 `fk_salle` int(11) DEFAULT NULL,
88 PRIMARY KEY (`idreservation`),
89 KEY `eleve_idx` (`fk_eleves`),
90 KEY `salle_idx` (`fk_salle`),
91 KEY `formateur_idx` (`fk_formateur`),
92 CONSTRAINT `eleve` FOREIGN KEY (`fk_eleves`) REFERENCES `eleves` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
93 CONSTRAINT `formateur` FOREIGN KEY (`fk_formateur`) REFERENCES `formateur` (`idformateur`) ON DELETE NO ACTION ON UPDATE NO ACTION,
94 CONSTRAINT `salle` FOREIGN KEY (`fk_salle`) REFERENCES `salles` (`idSalles`) ON DELETE NO ACTION ON UPDATE NO ACTION
95) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
96/*!40101 SET character_set_client = @saved_cs_client */;
97
98--
99-- Dumping data for table `reservation`
100--
101
102LOCK TABLES `reservation` WRITE;
103/*!40000 ALTER TABLE `reservation` DISABLE KEYS */;
104INSERT INTO `reservation` VALUES (1,'2018-04-18 10:00:00','2018-04-18 12:00:00',2,NULL,1,1),(2,'2018-04-18 14:00:00','2018-04-18 18:00:00',4,NULL,2,1),(4,'2018-04-18 10:00:00','2018-04-18 12:00:00',2,3,NULL,5),(5,'2018-04-18 10:00:00','2018-04-18 12:00:00',2,9,NULL,3),(6,'2018-04-18 10:00:00','2018-04-18 12:00:00',4,NULL,3,6),(7,'2018-04-18 14:00:00','2018-04-18 18:00:00',4,10,NULL,6),(8,'2018-04-19 14:00:00','2018-04-19 18:00:00',4,8,NULL,6),(9,'2018-04-19 14:00:00','2018-04-19 18:00:00',4,4,NULL,1),(10,'2018-04-19 10:00:00','2018-04-19 12:00:00',2,1,NULL,5),(11,'2018-04-19 10:00:00','2018-04-19 12:00:00',2,7,NULL,6);
105/*!40000 ALTER TABLE `reservation` ENABLE KEYS */;
106UNLOCK TABLES;
107
108--
109-- Table structure for table `salles`
110--
111
112DROP TABLE IF EXISTS `salles`;
113/*!40101 SET @saved_cs_client = @@character_set_client */;
114/*!40101 SET character_set_client = utf8 */;
115CREATE TABLE `salles` (
116 `idSalles` int(11) NOT NULL AUTO_INCREMENT,
117 `name` varchar(50) DEFAULT NULL,
118 PRIMARY KEY (`idSalles`)
119) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
120/*!40101 SET character_set_client = @saved_cs_client */;
121
122--
123-- Dumping data for table `salles`
124--
125
126LOCK TABLES `salles` WRITE;
127/*!40000 ALTER TABLE `salles` DISABLE KEYS */;
128INSERT INTO `salles` VALUES (1,'dojo'),(2,'réunion'),(3,'repos'),(4,'cuisine'),(5,'bureau'),(6,'openspace');
129/*!40000 ALTER TABLE `salles` ENABLE KEYS */;
130UNLOCK TABLES;
131/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
132
133/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
134/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
135/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
136/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
137/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
138/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
139/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
140
141-- Dump completed on 2018-04-03 21:49:00