ThGiyRBQ

1-- MySQL dump 10.13  Distrib 5.7.21, for Linux (x86_64)
2--
3-- Host: localhost    Database: gabriel_d_wcs_bordeaux
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-- Current Database: `gabriel_d_wcs_bordeaux`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `gabriel_d_wcs_bordeaux` /*!40100 DEFAULT CHARACTER SET latin1 */;
23
24USE `gabriel_d_wcs_bordeaux`;
25
26--
27-- Table structure for table `ecoles`
28--
29
30DROP TABLE IF EXISTS `ecoles`;
31/*!40101 SET @saved_cs_client     = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `ecoles` (
34  `id` int(11) NOT NULL AUTO_INCREMENT,
35  `ville` varchar(55) DEFAULT NULL,
36  PRIMARY KEY (`id`)
37) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
38/*!40101 SET character_set_client = @saved_cs_client */;
39
40--
41-- Dumping data for table `ecoles`
42--
43
44LOCK TABLES `ecoles` WRITE;
45/*!40000 ALTER TABLE `ecoles` DISABLE KEYS */;
46INSERT INTO `ecoles` VALUES (1,'Bordeaux');
47/*!40000 ALTER TABLE `ecoles` ENABLE KEYS */;
48UNLOCK TABLES;
49
50--
51-- Table structure for table `reservations`
52--
53
54DROP TABLE IF EXISTS `reservations`;
55/*!40101 SET @saved_cs_client     = @@character_set_client */;
56/*!40101 SET character_set_client = utf8 */;
57CREATE TABLE `reservations` (
58  `id` int(11) NOT NULL AUTO_INCREMENT,
59  `date_hour` datetime DEFAULT NULL,
60  `time` time NOT NULL,
61  `salleID` int(11) DEFAULT NULL,
62  `utilisateurID` int(11) DEFAULT NULL,
63  PRIMARY KEY (`id`),
64  KEY `salleID` (`salleID`),
65  KEY `utilisateurID` (`utilisateurID`),
66  CONSTRAINT `reservations_ibfk_1` FOREIGN KEY (`salleID`) REFERENCES `salles` (`id`),
67  CONSTRAINT `reservations_ibfk_2` FOREIGN KEY (`utilisateurID`) REFERENCES `utilisateurs` (`n_dossier`)
68) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
69/*!40101 SET character_set_client = @saved_cs_client */;
70
71--
72-- Dumping data for table `reservations`
73--
74
75LOCK TABLES `reservations` WRITE;
76/*!40000 ALTER TABLE `reservations` DISABLE KEYS */;
77INSERT INTO `reservations` VALUES (1,'2018-03-21 11:30:00','00:30:00',2,3);
78/*!40000 ALTER TABLE `reservations` ENABLE KEYS */;
79UNLOCK TABLES;
80
81--
82-- Table structure for table `salles`
83--
84
85DROP TABLE IF EXISTS `salles`;
86/*!40101 SET @saved_cs_client     = @@character_set_client */;
87/*!40101 SET character_set_client = utf8 */;
88CREATE TABLE `salles` (
89  `id` int(11) NOT NULL AUTO_INCREMENT,
90  `nom` varchar(55) DEFAULT NULL,
91  `n_salle` int(11) DEFAULT NULL,
92  `ecoleID` int(11) DEFAULT NULL,
93  PRIMARY KEY (`id`),
94  UNIQUE KEY `id` (`id`),
95  KEY `FK_salles_id_ecole` (`ecoleID`),
96  CONSTRAINT `FK_salles_id_ecole` FOREIGN KEY (`ecoleID`) REFERENCES `ecoles` (`id`)
97) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
98/*!40101 SET character_set_client = @saved_cs_client */;
99
100--
101-- Dumping data for table `salles`
102--
103
104LOCK TABLES `salles` WRITE;
105/*!40000 ALTER TABLE `salles` DISABLE KEYS */;
106INSERT INTO `salles` VALUES (1,'Salle de dojo',8,1),(2,'Salle de réunion',1,1),(3,'Salle de repos',1,1),(4,'Cuisine',1,1),(5,'Bureau',1,1),(6,'OpenSpace',1,1);
107/*!40000 ALTER TABLE `salles` ENABLE KEYS */;
108UNLOCK TABLES;
109
110--
111-- Table structure for table `utilisateurs`
112--
113
114DROP TABLE IF EXISTS `utilisateurs`;
115/*!40101 SET @saved_cs_client     = @@character_set_client */;
116/*!40101 SET character_set_client = utf8 */;
117CREATE TABLE `utilisateurs` (
118  `n_dossier` int(11) NOT NULL AUTO_INCREMENT,
119  `nom` varchar(55) DEFAULT NULL,
120  `prenom` varchar(55) DEFAULT NULL,
121  `adresse` varchar(55) DEFAULT NULL,
122  `salleID` int(11) DEFAULT NULL,
123  `ecoleID` int(11) DEFAULT NULL,
124  PRIMARY KEY (`n_dossier`),
125  KEY `FK_utilisateurs_id_salles` (`salleID`),
126  KEY `ecoleID` (`ecoleID`),
127  CONSTRAINT `FK_utilisateurs_id_salles` FOREIGN KEY (`salleID`) REFERENCES `salles` (`id`),
128  CONSTRAINT `utilisateurs_ibfk_1` FOREIGN KEY (`ecoleID`) REFERENCES `ecoles` (`id`)
129) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
130/*!40101 SET character_set_client = @saved_cs_client */;
131
132--
133-- Dumping data for table `utilisateurs`
134--
135
136LOCK TABLES `utilisateurs` WRITE;
137/*!40000 ALTER TABLE `utilisateurs` DISABLE KEYS */;
138INSERT INTO `utilisateurs` VALUES (1,'Potter','Harry','Poudlard',1,1),(2,'Granger','Hermione','Poudlard',1,1),(3,'Rubeus','Hagrid','Hagrid\'s House',1,1),(4,'Sacquet','Frodon','Comté',3,1),(5,'Baggins','Bilbo','Comté',6,1),(6,'Sauron',NULL,'Mordor',5,1),(7,'Dark','Vador','Death Star',5,1),(8,'Kenobi','Ben','Stewjon',6,1),(9,'Holy','Laurie','Far far away',6,1),(10,'Google','it','in the Cloud',6,1);
139/*!40000 ALTER TABLE `utilisateurs` ENABLE KEYS */;
140UNLOCK TABLES;
141/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
142
143/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
144/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
145/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
146/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
147/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
148/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
149/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
150
151-- Dump completed on 2018-03-20 18:57:14