c84y4KSW

1-- MySQL dump 10.13  Distrib 5.7.22, for Linux (x86_64)
2--
3-- Host: localhost    Database: julien_t_wcs_bidart_final
4-- ------------------------------------------------------
5-- Server version	5.7.22-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-- Current Database: `julien_t_wcs_bidart_final`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `julien_t_wcs_bidart_final` /*!40100 DEFAULT CHARACTER SET latin1 */;
23
24USE `julien_t_wcs_bidart_final`;
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  `adresse` varchar(255) DEFAULT NULL,
35  `id_personne` int(11) NOT NULL,
36  PRIMARY KEY (`id_personne`),
37  CONSTRAINT `FK_eleve_id_personne` FOREIGN KEY (`id_personne`) REFERENCES `personne` (`id_personne`)
38) ENGINE=InnoDB DEFAULT CHARSET=latin1;
39/*!40101 SET character_set_client = @saved_cs_client */;
40
41--
42-- Dumping data for table `eleve`
43--
44
45LOCK TABLES `eleve` WRITE;
46/*!40000 ALTER TABLE `eleve` DISABLE KEYS */;
47INSERT INTO `eleve` VALUES ('asie',1),('states',2),('brooklyn',3),('col de borgo',4),('states',5),('Paris',6),('Melun',7),('Lyon',8),('california',9),('jakarta',10);
48/*!40000 ALTER TABLE `eleve` ENABLE KEYS */;
49UNLOCK TABLES;
50
51--
52-- Table structure for table `formateur`
53--
54
55DROP TABLE IF EXISTS `formateur`;
56/*!40101 SET @saved_cs_client     = @@character_set_client */;
57/*!40101 SET character_set_client = utf8 */;
58CREATE TABLE `formateur` (
59  `id_personne` int(11) NOT NULL,
60  `id_langage` int(11) NOT NULL,
61  PRIMARY KEY (`id_personne`),
62  KEY `FK_formateur_id_langage` (`id_langage`),
63  CONSTRAINT `FK_formateur_id_langage` FOREIGN KEY (`id_langage`) REFERENCES `langage` (`id_langage`),
64  CONSTRAINT `FK_formateur_id_personne` FOREIGN KEY (`id_personne`) REFERENCES `personne` (`id_personne`)
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 `langage`
79--
80
81DROP TABLE IF EXISTS `langage`;
82/*!40101 SET @saved_cs_client     = @@character_set_client */;
83/*!40101 SET character_set_client = utf8 */;
84CREATE TABLE `langage` (
85  `id_langage` int(11) NOT NULL AUTO_INCREMENT,
86  `nom` varchar(25) NOT NULL,
87  PRIMARY KEY (`id_langage`)
88) ENGINE=InnoDB DEFAULT CHARSET=latin1;
89/*!40101 SET character_set_client = @saved_cs_client */;
90
91--
92-- Dumping data for table `langage`
93--
94
95LOCK TABLES `langage` WRITE;
96/*!40000 ALTER TABLE `langage` DISABLE KEYS */;
97/*!40000 ALTER TABLE `langage` ENABLE KEYS */;
98UNLOCK TABLES;
99
100--
101-- Table structure for table `personne`
102--
103
104DROP TABLE IF EXISTS `personne`;
105/*!40101 SET @saved_cs_client     = @@character_set_client */;
106/*!40101 SET character_set_client = utf8 */;
107CREATE TABLE `personne` (
108  `id_personne` int(11) NOT NULL AUTO_INCREMENT,
109  `nom` varchar(255) DEFAULT NULL,
110  `prenom` varchar(255) DEFAULT NULL,
111  `num_dossier` varchar(25) NOT NULL,
112  PRIMARY KEY (`id_personne`),
113  UNIQUE KEY `num_dossier` (`num_dossier`)
114) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
115/*!40101 SET character_set_client = @saved_cs_client */;
116
117--
118-- Dumping data for table `personne`
119--
120
121LOCK TABLES `personne` WRITE;
122/*!40000 ALTER TABLE `personne` DISABLE KEYS */;
123INSERT INTO `personne` VALUES (1,'Dupre','Steph','wcs_45254'),(2,'Petitjean','Thomas','wcs_38245'),(3,'Bernabe','Laurent','wcs_12121'),(4,'Aurel','Sebastien','wcs_6554'),(5,'Petitjean','Gaelle','wcs_56214'),(6,'Braiek','Amel','wcs_151421'),(7,'Dupont','Pierre','wcs_654214'),(8,'Nette','Jeanne','wcs_11232'),(9,'Gle','Goo','wcs_565154'),(10,'Amie','Lorie','wcs_689454');
124/*!40000 ALTER TABLE `personne` ENABLE KEYS */;
125UNLOCK TABLES;
126
127--
128-- Table structure for table `reservation`
129--
130
131DROP TABLE IF EXISTS `reservation`;
132/*!40101 SET @saved_cs_client     = @@character_set_client */;
133/*!40101 SET character_set_client = utf8 */;
134CREATE TABLE `reservation` (
135  `id_reservation` int(11) NOT NULL AUTO_INCREMENT,
136  `date_reservation` date NOT NULL,
137  `heure_debut` time NOT NULL,
138  `heure_fin` time NOT NULL,
139  `id_personne` int(11) NOT NULL,
140  `id_salle` int(11) NOT NULL,
141  PRIMARY KEY (`id_reservation`),
142  KEY `FK_reservation_id_personne` (`id_personne`),
143  KEY `FK_reservation_id_salle` (`id_salle`),
144  CONSTRAINT `FK_reservation_id_personne` FOREIGN KEY (`id_personne`) REFERENCES `personne` (`id_personne`),
145  CONSTRAINT `FK_reservation_id_salle` FOREIGN KEY (`id_salle`) REFERENCES `salle` (`id_salle`)
146) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
147/*!40101 SET character_set_client = @saved_cs_client */;
148
149--
150-- Dumping data for table `reservation`
151--
152
153LOCK TABLES `reservation` WRITE;
154/*!40000 ALTER TABLE `reservation` DISABLE KEYS */;
155INSERT INTO `reservation` VALUES (1,'2018-05-02','09:00:00','10:00:00',1,1),(2,'2018-05-02','10:00:00','11:00:00',2,1),(3,'2018-05-02','14:00:00','16:00:00',3,1),(4,'2018-05-02','09:00:00','12:00:00',3,5),(5,'2018-05-02','14:00:00','16:00:00',3,5),(6,'2018-05-02','14:00:00','16:00:00',3,3),(7,'2018-05-02','09:00:00','10:00:00',3,6),(8,'2018-05-02','11:00:00','12:00:00',3,6),(9,'2018-05-02','14:00:00','16:00:00',3,6),(10,'2018-05-02','16:00:00','18:00:00',3,6);
156/*!40000 ALTER TABLE `reservation` ENABLE KEYS */;
157UNLOCK TABLES;
158
159--
160-- Table structure for table `salle`
161--
162
163DROP TABLE IF EXISTS `salle`;
164/*!40101 SET @saved_cs_client     = @@character_set_client */;
165/*!40101 SET character_set_client = utf8 */;
166CREATE TABLE `salle` (
167  `id_salle` int(11) NOT NULL AUTO_INCREMENT,
168  `nom` varchar(255) NOT NULL,
169  PRIMARY KEY (`id_salle`)
170) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
171/*!40101 SET character_set_client = @saved_cs_client */;
172
173--
174-- Dumping data for table `salle`
175--
176
177LOCK TABLES `salle` WRITE;
178/*!40000 ALTER TABLE `salle` DISABLE KEYS */;
179INSERT INTO `salle` VALUES (1,'Salle de dojo'),(2,'Salle de réunion'),(3,'Salle de repos'),(4,'Cuisine'),(5,'Bureau'),(6,'OpenSpace');
180/*!40000 ALTER TABLE `salle` ENABLE KEYS */;
181UNLOCK TABLES;
182/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
183
184/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
185/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
186/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
187/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
188/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
189/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
190/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
191
192-- Dump completed on 2018-04-30 12:20:16