· 8 years ago · Aug 29, 2018, 07:12 PM
1-- MySQL dump 10.13 Distrib 5.7.23, for Linux (x86_64)
2--
3-- Host: localhost Database: aniya_k_wcs_bordeaux
4-- ------------------------------------------------------
5-- Server version 5.7.23-0ubuntu0.18.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 `Etudiants`
20--
21
22DROP TABLE IF EXISTS `Etudiants`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `Etudiants` (
26 `id_etudiant` int(11) NOT NULL,
27 `Nom` varchar(30) DEFAULT NULL,
28 `Prenom` varchar(30) DEFAULT NULL,
29 `Age` int(11) DEFAULT NULL,
30 `Residence` varchar(50) DEFAULT NULL,
31 PRIMARY KEY (`id_etudiant`)
32) ENGINE=InnoDB DEFAULT CHARSET=latin1;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Dumping data for table `Etudiants`
37--
38
39LOCK TABLES `Etudiants` WRITE;
40/*!40000 ALTER TABLE `Etudiants` DISABLE KEYS */;
41INSERT INTO `Etudiants` VALUES (1,'Apalama','Kandane',30,'Bordeaux'),(2,'Delas','Marina',26,'Talence'),(3,'Fieu','Cedric',34,'Libourne'),(4,'Voirin','Mickael',35,'Bordeaux'),(5,'GOOGLE',NULL,NULL,NULL),(6,'Lorie',NULL,NULL,NULL),(7,'Schlegel','Fabien',35,'Mios'),(8,'Laurent','Marie',26,'Bordeaux'),(9,'Caratini','Paulin',26,'Bordeaux'),(10,'Kouene','Aniya',35,'Cenon');
42/*!40000 ALTER TABLE `Etudiants` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `Reservations`
47--
48
49DROP TABLE IF EXISTS `Reservations`;
50/*!40101 SET @saved_cs_client = @@character_set_client */;
51/*!40101 SET character_set_client = utf8 */;
52CREATE TABLE `Reservations` (
53 `id_reservation` int(11) NOT NULL AUTO_INCREMENT,
54 `etudiant` int(11) DEFAULT NULL,
55 `salle` int(11) DEFAULT NULL,
56 `date_reservation` date DEFAULT NULL,
57 `duree` varchar(50) DEFAULT NULL,
58 PRIMARY KEY (`id_reservation`),
59 KEY `etudiant` (`etudiant`),
60 KEY `salle` (`salle`),
61 CONSTRAINT `Reservations_ibfk_1` FOREIGN KEY (`etudiant`) REFERENCES `Etudiants` (`id_etudiant`),
62 CONSTRAINT `Reservations_ibfk_2` FOREIGN KEY (`salle`) REFERENCES `Salles` (`id_salle`)
63) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
64/*!40101 SET character_set_client = @saved_cs_client */;
65
66--
67-- Dumping data for table `Reservations`
68--
69
70LOCK TABLES `Reservations` WRITE;
71/*!40000 ALTER TABLE `Reservations` DISABLE KEYS */;
72INSERT INTO `Reservations` VALUES (1,1,1,'2018-08-28','2 heures'),(2,2,1,'2018-08-28','2 heures'),(3,3,1,'2018-08-28','2 heures'),(4,4,2,'2018-08-28','1 heures'),(5,5,5,'2018-08-28','1 heures'),(6,10,3,'2018-08-28','1 heures'),(7,6,6,'2018-08-28','2 heures'),(8,7,6,'2018-08-28','2 heures'),(9,8,6,'2018-08-28','2 heures'),(10,9,6,'2018-08-28','2 heures');
73/*!40000 ALTER TABLE `Reservations` ENABLE KEYS */;
74UNLOCK TABLES;
75
76--
77-- Table structure for table `Salles`
78--
79
80DROP TABLE IF EXISTS `Salles`;
81/*!40101 SET @saved_cs_client = @@character_set_client */;
82/*!40101 SET character_set_client = utf8 */;
83CREATE TABLE `Salles` (
84 `id_salle` int(11) NOT NULL AUTO_INCREMENT,
85 `Nom` varchar(50) DEFAULT NULL,
86 PRIMARY KEY (`id_salle`)
87) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
88/*!40101 SET character_set_client = @saved_cs_client */;
89
90--
91-- Dumping data for table `Salles`
92--
93
94LOCK TABLES `Salles` WRITE;
95/*!40000 ALTER TABLE `Salles` DISABLE KEYS */;
96INSERT INTO `Salles` VALUES (1,'Salle_de_Dojo'),(2,'Salle_de_reunion'),(3,'Salle_de_repos'),(4,'Cuisine'),(5,'Bureau'),(6,'OpenSpace');
97/*!40000 ALTER TABLE `Salles` ENABLE KEYS */;
98UNLOCK TABLES;
99/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
100
101/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
102/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
103/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
104/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
105/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
106/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
107/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
108
109-- Dump completed on 2018-08-29 17:58:12