hAEgKN7Q

1-- MySQL dump 10.13  Distrib 5.7.21, for Linux (x86_64)
2--
3-- Host: localhost    Database: roomresa
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 `Eleve`
20--
21
22DROP TABLE IF EXISTS `Eleve`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `Eleve` (
26  `id` int(11) DEFAULT NULL,
27  `Adresse` varchar(25) DEFAULT NULL,
28  `Numero_de_Dossier` int(11) NOT NULL,
29  PRIMARY KEY (`Numero_de_Dossier`)
30) ENGINE=InnoDB DEFAULT CHARSET=latin1;
31/*!40101 SET character_set_client = @saved_cs_client */;
32
33--
34-- Dumping data for table `Eleve`
35--
36
37LOCK TABLES `Eleve` WRITE;
38/*!40000 ALTER TABLE `Eleve` DISABLE KEYS */;
39/*!40000 ALTER TABLE `Eleve` ENABLE KEYS */;
40UNLOCK TABLES;
41
42--
43-- Table structure for table `Personne`
44--
45
46DROP TABLE IF EXISTS `Personne`;
47/*!40101 SET @saved_cs_client     = @@character_set_client */;
48/*!40101 SET character_set_client = utf8 */;
49CREATE TABLE `Personne` (
50  `Nom` varchar(25) DEFAULT NULL,
51  `Prenom` varchar(25) DEFAULT NULL,
52  `Numero_de_Dossier` int(11) NOT NULL,
53  PRIMARY KEY (`Numero_de_Dossier`)
54) ENGINE=InnoDB DEFAULT CHARSET=latin1;
55/*!40101 SET character_set_client = @saved_cs_client */;
56
57--
58-- Dumping data for table `Personne`
59--
60
61LOCK TABLES `Personne` WRITE;
62/*!40000 ALTER TABLE `Personne` DISABLE KEYS */;
63INSERT INTO `Personne` VALUES ('Peyrat','Alexandre',10),('Jean','Bon',12),('Sarr','Georges',14),('Hoareau','Nicolas',16),('hdssh','jean',17),('Gregoire','Mathieu',126),('Combes','Anouchka',328),('Pavie','Hugo',654),('Google','Google',56789),('Perdue','Laurie',286396);
64/*!40000 ALTER TABLE `Personne` ENABLE KEYS */;
65UNLOCK TABLES;
66
67--
68-- Table structure for table `Reservation`
69--
70
71DROP TABLE IF EXISTS `Reservation`;
72/*!40101 SET @saved_cs_client     = @@character_set_client */;
73/*!40101 SET character_set_client = utf8 */;
74CREATE TABLE `Reservation` (
75  `dates` date DEFAULT NULL,
76  `duree` int(11) DEFAULT NULL,
77  `Numero_de_Dossier` int(11) NOT NULL,
78  `id` int(11) NOT NULL,
79  PRIMARY KEY (`Numero_de_Dossier`,`id`)
80) ENGINE=InnoDB DEFAULT CHARSET=latin1;
81/*!40101 SET character_set_client = @saved_cs_client */;
82
83--
84-- Dumping data for table `Reservation`
85--
86
87LOCK TABLES `Reservation` WRITE;
88/*!40000 ALTER TABLE `Reservation` DISABLE KEYS */;
89INSERT INTO `Reservation` VALUES ('2018-04-12',30,10,1),('2018-05-14',30,12,1),('2018-06-15',30,14,1),('2018-06-19',27,16,6),('2018-03-18',20,17,6),('2018-03-18',20,126,6),('2018-03-17',15,328,6),('2018-02-17',50,654,2),('2018-02-13',45,56789,5),('2018-02-12',40,286396,5);
90/*!40000 ALTER TABLE `Reservation` ENABLE KEYS */;
91UNLOCK TABLES;
92
93--
94-- Table structure for table `Room`
95--
96
97DROP TABLE IF EXISTS `Room`;
98/*!40101 SET @saved_cs_client     = @@character_set_client */;
99/*!40101 SET character_set_client = utf8 */;
100CREATE TABLE `Room` (
101  `Nom` varchar(25) DEFAULT NULL,
102  `id` int(11) NOT NULL,
103  PRIMARY KEY (`id`)
104) ENGINE=InnoDB DEFAULT CHARSET=latin1;
105/*!40101 SET character_set_client = @saved_cs_client */;
106
107--
108-- Dumping data for table `Room`
109--
110
111LOCK TABLES `Room` WRITE;
112/*!40000 ALTER TABLE `Room` DISABLE KEYS */;
113INSERT INTO `Room` VALUES ('Salle de Dojo',1),('Salle de Repos',2),('Salle de Reunion',3),('Cuisine',4),('Bureau',5),('OpenSpace',6);
114/*!40000 ALTER TABLE `Room` ENABLE KEYS */;
115UNLOCK TABLES;
116
117--
118-- Table structure for table `formateur`
119--
120
121DROP TABLE IF EXISTS `formateur`;
122/*!40101 SET @saved_cs_client     = @@character_set_client */;
123/*!40101 SET character_set_client = utf8 */;
124CREATE TABLE `formateur` (
125  `langage` varchar(25) DEFAULT NULL,
126  `id` int(11) DEFAULT NULL,
127  `numero_de_dossier` int(11) NOT NULL,
128  PRIMARY KEY (`numero_de_dossier`)
129) ENGINE=InnoDB DEFAULT CHARSET=latin1;
130/*!40101 SET character_set_client = @saved_cs_client */;
131
132--
133-- Dumping data for table `formateur`
134--
135
136LOCK TABLES `formateur` WRITE;
137/*!40000 ALTER TABLE `formateur` DISABLE KEYS */;
138/*!40000 ALTER TABLE `formateur` ENABLE KEYS */;
139UNLOCK TABLES;
140/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
141
142/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
143/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
144/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
145/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
146/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
147/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
148/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
149
150-- Dump completed on 2018-03-28 10:52:46