· 8 years ago · Apr 11, 2018, 02:16 PM
1-- MySQL dump 10.13 Distrib 5.7.21, for osx10.13 (x86_64)
2--
3-- Host: localhost Database: reservation_salles
4-- ------------------------------------------------------
5-- Server version 5.7.21
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 `reservation`
20--
21
22DROP TABLE IF EXISTS `reservation`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `reservation` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `date_reservation` date DEFAULT NULL,
28 `duree_reservation` time DEFAULT NULL,
29 `id_salle` int(11) NOT NULL,
30 `id_utilisateur` int(11) NOT NULL,
31 PRIMARY KEY (`id`),
32 KEY `id_salle` (`id_salle`),
33 KEY `id_utilisateur` (`id_utilisateur`),
34 CONSTRAINT `id_salle` FOREIGN KEY (`id_salle`) REFERENCES `salle` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
35 CONSTRAINT `id_utilisateur` FOREIGN KEY (`id_utilisateur`) REFERENCES `utilisateur` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
36) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
37/*!40101 SET character_set_client = @saved_cs_client */;
38
39--
40-- Dumping data for table `reservation`
41--
42
43LOCK TABLES `reservation` WRITE;
44/*!40000 ALTER TABLE `reservation` DISABLE KEYS */;
45INSERT INTO `reservation` VALUES (1,'2018-04-15','02:00:00',1,1),(2,'2018-04-15','02:00:00',1,2),(3,'2018-04-15','02:00:00',1,3),(4,'2018-04-16','04:00:00',5,4),(5,'2018-04-16','04:00:00',5,5),(6,'2018-04-17','03:00:00',3,6),(7,'2018-04-18','01:00:00',6,7),(8,'2018-04-18','01:00:00',6,8),(9,'2018-04-18','01:00:00',6,9),(10,'2018-04-18','01:00:00',6,10);
46/*!40000 ALTER TABLE `reservation` ENABLE KEYS */;
47UNLOCK TABLES;
48
49--
50-- Table structure for table `salle`
51--
52
53DROP TABLE IF EXISTS `salle`;
54/*!40101 SET @saved_cs_client = @@character_set_client */;
55/*!40101 SET character_set_client = utf8 */;
56CREATE TABLE `salle` (
57 `id` int(11) NOT NULL AUTO_INCREMENT,
58 `reservation_salle` varchar(50) DEFAULT NULL,
59 `nom_salle` varchar(50) DEFAULT NULL,
60 `numero_salle` varchar(50) DEFAULT NULL,
61 PRIMARY KEY (`id`)
62) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
63/*!40101 SET character_set_client = @saved_cs_client */;
64
65--
66-- Dumping data for table `salle`
67--
68
69LOCK TABLES `salle` WRITE;
70/*!40000 ALTER TABLE `salle` DISABLE KEYS */;
71INSERT INTO `salle` VALUES (1,NULL,'salle de dojo','1'),(2,NULL,'salle de réunion','2'),(3,NULL,'salle de repos','3'),(4,NULL,'cuisine','4'),(5,NULL,'bureau','5'),(6,NULL,'open space','6');
72/*!40000 ALTER TABLE `salle` ENABLE KEYS */;
73UNLOCK TABLES;
74
75--
76-- Table structure for table `utilisateur`
77--
78
79DROP TABLE IF EXISTS `utilisateur`;
80/*!40101 SET @saved_cs_client = @@character_set_client */;
81/*!40101 SET character_set_client = utf8 */;
82CREATE TABLE `utilisateur` (
83 `id` int(11) NOT NULL AUTO_INCREMENT,
84 `nom_utilisateur` varchar(50) DEFAULT NULL,
85 `prenom_utilisateur` varchar(50) DEFAULT NULL,
86 `statut_utilisateur` varchar(50) DEFAULT NULL,
87 `adresse_utilisateur` varchar(50) DEFAULT NULL,
88 `numero_dossier_utilisateur` int(11) DEFAULT NULL,
89 PRIMARY KEY (`id`)
90) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
91/*!40101 SET character_set_client = @saved_cs_client */;
92
93--
94-- Dumping data for table `utilisateur`
95--
96
97LOCK TABLES `utilisateur` WRITE;
98/*!40000 ALTER TABLE `utilisateur` DISABLE KEYS */;
99INSERT INTO `utilisateur` VALUES (1,'Roberto','Paul','eleve','32 rue du code 33000 Bordeaux',124534),(2,'Alberto','Jean','eleve','32 rue du code 33000 Bordeaux',431534),(3,'Giovanni','Baptiste','eleve','32 rue du code 33000 Bordeaux',435324),(4,'Bien','Yvon','eleve','32 rue du code 33000 Bordeaux',451824),(5,'Dupain','Yvan','professeur','32 rue du code 33000 Bordeaux',453784),(6,'Dubureau','Roger','professeur','32 rue du code 33000 Bordeaux',409984),(7,'Dubonnet','Michel','eleve','32 rue du code 33000 Bordeaux',424984),(8,'Grobourrin','Jean Michel','eleve','32 rue du code 33000 Bordeaux',424534),(9,'O','Albert','eleve','32 rue du code 33000 Bordeaux',424154),(10,'Lol','René','eleve','32 rue du code 33000 Bordeaux',152154);
100/*!40000 ALTER TABLE `utilisateur` ENABLE KEYS */;
101UNLOCK TABLES;
102/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
103
104/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
105/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
106/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
107/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
108/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
109/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
110/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
111
112-- Dump completed on 2018-04-03 15:49:18