QUq0Y1js

1-- MySQL dump 10.13  Distrib 5.5.42, for osx10.6 (i386)
2--
3-- Host: localhost    Database: quete_resa_salle
4-- ------------------------------------------------------
5-- Server version	5.5.42
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 `personnes`
20--
21
22DROP TABLE IF EXISTS `personnes`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `personnes` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `nom_personne` varchar(100) DEFAULT NULL,
28  `role_personne` varchar(100) DEFAULT NULL,
29  PRIMARY KEY (`id`)
30) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
31/*!40101 SET character_set_client = @saved_cs_client */;
32
33--
34-- Dumping data for table `personnes`
35--
36
37LOCK TABLES `personnes` WRITE;
38/*!40000 ALTER TABLE `personnes` DISABLE KEYS */;
39INSERT INTO `personnes` VALUES (1,'Laurie','meilleure amie'),(2,'Caroline','Php Wizard'),(3,'Elisa','Balerina'),(4,'Cindy','Blabla Queen'),(5,'Goo','navi'),(6,'gle','gateur'),(7,'Jack','Special guest'),(8,'Cyrielle','Hackaton teammate'),(9,'Hélène','Airtable Manager'),(10,'Agathe','Mom to be');
40/*!40000 ALTER TABLE `personnes` ENABLE KEYS */;
41UNLOCK TABLES;
42
43--
44-- Table structure for table `reservation`
45--
46
47DROP TABLE IF EXISTS `reservation`;
48/*!40101 SET @saved_cs_client     = @@character_set_client */;
49/*!40101 SET character_set_client = utf8 */;
50CREATE TABLE `reservation` (
51  `id_reservation` int(11) NOT NULL AUTO_INCREMENT,
52  `id_salle` int(11) DEFAULT NULL,
53  `id_personne` int(11) DEFAULT NULL,
54  `date` date DEFAULT NULL,
55  `heure` time DEFAULT NULL,
56  `duree` text,
57  PRIMARY KEY (`id_reservation`),
58  KEY `id_salle` (`id_salle`),
59  KEY `id_personne` (`id_personne`),
60  CONSTRAINT `reservation_ibfk_1` FOREIGN KEY (`id_salle`) REFERENCES `salles` (`id`),
61  CONSTRAINT `reservation_ibfk_2` FOREIGN KEY (`id_personne`) REFERENCES `personnes` (`id`)
62) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
63/*!40101 SET character_set_client = @saved_cs_client */;
64
65--
66-- Dumping data for table `reservation`
67--
68
69LOCK TABLES `reservation` WRITE;
70/*!40000 ALTER TABLE `reservation` DISABLE KEYS */;
71INSERT INTO `reservation` VALUES (1,1,1,'2017-11-21','09:00:00','1h'),(2,1,2,'0000-00-00','09:00:00','1h'),(3,1,3,'2017-11-21','11:00:00','1h'),(4,3,4,'2017-11-21','12:00:00','1h'),(5,5,5,'2017-11-21','13:00:00','1h'),(6,5,6,'2017-11-21','14:00:00','1h'),(7,6,7,'2017-11-21','15:00:00','1h'),(8,6,8,'2017-11-21','16:00:00','1h'),(9,6,9,'2017-11-21','17:00:00','1h'),(10,6,10,'2017-11-21','18:00:00','1h');
72/*!40000 ALTER TABLE `reservation` ENABLE KEYS */;
73UNLOCK TABLES;
74
75--
76-- Table structure for table `salles`
77--
78
79DROP TABLE IF EXISTS `salles`;
80/*!40101 SET @saved_cs_client     = @@character_set_client */;
81/*!40101 SET character_set_client = utf8 */;
82CREATE TABLE `salles` (
83  `id` int(11) NOT NULL AUTO_INCREMENT,
84  `nom_salle` varchar(100) DEFAULT NULL,
85  PRIMARY KEY (`id`)
86) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
87/*!40101 SET character_set_client = @saved_cs_client */;
88
89--
90-- Dumping data for table `salles`
91--
92
93LOCK TABLES `salles` WRITE;
94/*!40000 ALTER TABLE `salles` DISABLE KEYS */;
95INSERT INTO `salles` VALUES (1,'Salle de Dojo'),(2,'Salle de réunion'),(3,'Salle de repos'),(4,'Cuisine'),(5,'Bureau'),(6,'OpenSpace');
96/*!40000 ALTER TABLE `salles` ENABLE KEYS */;
97UNLOCK TABLES;
98/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
99
100/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
101/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
102/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
103/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
104/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
105/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
106/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
107
108-- Dump completed on 2017-11-21 18:29:38