c8kTmGDN

1-- MySQL dump 10.13  Distrib 5.7.22, for Linux (x86_64)
2--
3-- Host: localhost    Database: quete_sql
4-- ------------------------------------------------------
5-- Server version	5.7.22-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-- Current Database: `quete_sql`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `quete_sql` /*!40100 DEFAULT CHARACTER SET latin1 */;
23
24USE `quete_sql`;
25
26--
27-- Table structure for table `Eleve`
28--
29
30DROP TABLE IF EXISTS `Eleve`;
31/*!40101 SET @saved_cs_client     = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `Eleve` (
34  `N°Dossier` int(11) NOT NULL AUTO_INCREMENT,
35  `nom` varchar(150) DEFAULT NULL,
36  `prenom` varchar(150) DEFAULT NULL,
37  `adresse` varchar(155) DEFAULT NULL,
38  PRIMARY KEY (`N°Dossier`)
39) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
40/*!40101 SET character_set_client = @saved_cs_client */;
41
42--
43-- Dumping data for table `Eleve`
44--
45
46LOCK TABLES `Eleve` WRITE;
47/*!40000 ALTER TABLE `Eleve` DISABLE KEYS */;
48INSERT INTO `Eleve` VALUES (1,'De_Paep','Yvan','Toulouse'),(2,'Nivlet','Nicolas','Toulouse'),(3,'Kosc','Sylvain','Toulouse'),(4,'Dellanel','Thomas','Toulouse'),(5,'Yos','Vanthika','Toulouse'),(6,'Pester','Lorie','Zimbabwe'),(7,'Google','Google','Silicon Valley, California'),(8,'Luchini','Fabrice','Paris'),(9,'Rachida','Darty','Paris'),(10,'Dqiqi','Leila','Toulouse');
49/*!40000 ALTER TABLE `Eleve` ENABLE KEYS */;
50UNLOCK TABLES;
51
52--
53-- Table structure for table `Formateur`
54--
55
56DROP TABLE IF EXISTS `Formateur`;
57/*!40101 SET @saved_cs_client     = @@character_set_client */;
58/*!40101 SET character_set_client = utf8 */;
59CREATE TABLE `Formateur` (
60  `ID` int(11) NOT NULL AUTO_INCREMENT,
61  `nom` varchar(150) DEFAULT NULL,
62  `prenom` varchar(155) DEFAULT NULL,
63  `langage` varchar(155) DEFAULT NULL,
64  PRIMARY KEY (`ID`)
65) ENGINE=InnoDB DEFAULT CHARSET=latin1;
66/*!40101 SET character_set_client = @saved_cs_client */;
67
68--
69-- Dumping data for table `Formateur`
70--
71
72LOCK TABLES `Formateur` WRITE;
73/*!40000 ALTER TABLE `Formateur` DISABLE KEYS */;
74/*!40000 ALTER TABLE `Formateur` ENABLE KEYS */;
75UNLOCK TABLES;
76
77--
78-- Table structure for table `Réservation`
79--
80
81DROP TABLE IF EXISTS `Réservation`;
82/*!40101 SET @saved_cs_client     = @@character_set_client */;
83/*!40101 SET character_set_client = utf8 */;
84CREATE TABLE `Réservation` (
85  `n°Réservation` int(11) NOT NULL AUTO_INCREMENT,
86  `dateRéservation` date DEFAULT NULL,
87  `tempsRéservation` int(11) DEFAULT NULL,
88  `ID` int(11) DEFAULT NULL,
89  `n°Dossier` int(11) DEFAULT NULL,
90  `n°Salle` int(11) DEFAULT NULL,
91  PRIMARY KEY (`n°Réservation`),
92  KEY `ID` (`ID`),
93  KEY `n°Dossier` (`n°Dossier`),
94  KEY `n°Salle` (`n°Salle`),
95  CONSTRAINT `Réservation_ibfk_1` FOREIGN KEY (`ID`) REFERENCES `Formateur` (`ID`),
96  CONSTRAINT `Réservation_ibfk_2` FOREIGN KEY (`n°Dossier`) REFERENCES `Eleve` (`N°Dossier`),
97  CONSTRAINT `Réservation_ibfk_3` FOREIGN KEY (`n°Salle`) REFERENCES `Salle` (`n°Salle`)
98) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
99/*!40101 SET character_set_client = @saved_cs_client */;
100
101--
102-- Dumping data for table `Réservation`
103--
104
105LOCK TABLES `Réservation` WRITE;
106/*!40000 ALTER TABLE `Réservation` DISABLE KEYS */;
107INSERT INTO `Réservation` VALUES (1,'2018-05-31',2,NULL,1,1),(2,'2018-05-31',2,NULL,2,1),(3,'2018-05-31',2,NULL,3,1),(4,'2018-06-02',1,NULL,4,5),(5,'2018-06-02',1,NULL,5,5),(6,'2018-05-02',1,NULL,6,3),(7,'2018-05-31',3,NULL,7,6),(8,'2018-05-31',3,NULL,8,6),(9,'2018-05-31',3,NULL,9,6),(10,'2018-05-31',3,NULL,10,6);
108/*!40000 ALTER TABLE `Réservation` ENABLE KEYS */;
109UNLOCK TABLES;
110
111--
112-- Table structure for table `Salle`
113--
114
115DROP TABLE IF EXISTS `Salle`;
116/*!40101 SET @saved_cs_client     = @@character_set_client */;
117/*!40101 SET character_set_client = utf8 */;
118CREATE TABLE `Salle` (
119  `n°Salle` int(11) NOT NULL AUTO_INCREMENT,
120  `nom` varchar(155) DEFAULT NULL,
121  PRIMARY KEY (`n°Salle`)
122) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
123/*!40101 SET character_set_client = @saved_cs_client */;
124
125--
126-- Dumping data for table `Salle`
127--
128
129LOCK TABLES `Salle` WRITE;
130/*!40000 ALTER TABLE `Salle` DISABLE KEYS */;
131INSERT INTO `Salle` VALUES (1,'Salle de dojo'),(2,'salle de réunion'),(3,'Salle de repos'),(4,'Cuisine'),(5,'Bureau'),(6,'OpenSpace');
132/*!40000 ALTER TABLE `Salle` ENABLE KEYS */;
133UNLOCK TABLES;
134/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
135
136/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
137/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
138/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
139/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
140/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
141/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
142/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
143
144-- Dump completed on 2018-05-31 17:02:58