Jrqt3x5B

1-- MySQL dump 10.13  Distrib 5.7.21, for Linux (x86_64)
2--
3-- Host: localhost    Database: quete2sql
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: `quete2sql`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `quete2sql` /*!40100 DEFAULT CHARACTER SET latin1 */;
23
24USE `quete2sql`;
25
26--
27-- Table structure for table `Person`
28--
29
30DROP TABLE IF EXISTS `Person`;
31/*!40101 SET @saved_cs_client     = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `Person` (
34  `person_id` int(11) NOT NULL AUTO_INCREMENT,
35  `firstname` varchar(25) NOT NULL,
36  `lastname` varchar(25) NOT NULL,
37  `address` varchar(25) DEFAULT NULL,
38  `language` varchar(25) DEFAULT NULL,
39  PRIMARY KEY (`person_id`)
40) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
41/*!40101 SET character_set_client = @saved_cs_client */;
42
43--
44-- Dumping data for table `Person`
45--
46
47LOCK TABLES `Person` WRITE;
48/*!40000 ALTER TABLE `Person` DISABLE KEYS */;
49INSERT INTO `Person` VALUES (1,'Laforgue','Loïc','Toulouse','null'),(2,'Konor','Sarah','Los Angeles',''),(3,'','Lorie','Aucune idee','ado'),(4,'Google','','Silicon Valley',''),(5,'Gregoire','Mathieu','Toulouse',''),(6,'Calas','Hugo','Toulouse',''),(7,'prof','prof','Toulouse','php'),(8,'eleve','eleve','Toulouse',''),(9,'je ne sais','pas qui ajouter','','sql'),(10,'enfin~','le dernier','','sql');
50/*!40000 ALTER TABLE `Person` ENABLE KEYS */;
51UNLOCK TABLES;
52
53--
54-- Table structure for table `Reservation`
55--
56
57DROP TABLE IF EXISTS `Reservation`;
58/*!40101 SET @saved_cs_client     = @@character_set_client */;
59/*!40101 SET character_set_client = utf8 */;
60CREATE TABLE `Reservation` (
61  `person_id` int(11) NOT NULL,
62  `room_id` int(11) NOT NULL,
63  `duration` varchar(25) DEFAULT NULL,
64  `date` varchar(25) DEFAULT NULL,
65  PRIMARY KEY (`person_id`,`room_id`),
66  CONSTRAINT `FK_Reservation_person_id` FOREIGN KEY (`person_id`) REFERENCES `Person` (`person_id`)
67) ENGINE=InnoDB DEFAULT CHARSET=latin1;
68/*!40101 SET character_set_client = @saved_cs_client */;
69
70--
71-- Dumping data for table `Reservation`
72--
73
74LOCK TABLES `Reservation` WRITE;
75/*!40000 ALTER TABLE `Reservation` DISABLE KEYS */;
76INSERT INTO `Reservation` VALUES (1,1,'13h-14h','lundi'),(2,1,'13h-14h','lundi'),(3,1,'13h-14h','lundi'),(4,5,'14h-15h','mardi'),(5,5,'14h-15h','mardi'),(6,3,'14h-18h','mercredi'),(7,6,'14h-20h','mercredi'),(8,6,'14h-20h','mercredi'),(9,6,'14h-20h','mercredi'),(10,6,'14h-20h','mercredi');
77/*!40000 ALTER TABLE `Reservation` ENABLE KEYS */;
78UNLOCK TABLES;
79
80--
81-- Table structure for table `Room`
82--
83
84DROP TABLE IF EXISTS `Room`;
85/*!40101 SET @saved_cs_client     = @@character_set_client */;
86/*!40101 SET character_set_client = utf8 */;
87CREATE TABLE `Room` (
88  `room_id` int(11) NOT NULL AUTO_INCREMENT,
89  `name` varchar(25) NOT NULL,
90  PRIMARY KEY (`room_id`)
91) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
92/*!40101 SET character_set_client = @saved_cs_client */;
93
94--
95-- Dumping data for table `Room`
96--
97
98LOCK TABLES `Room` WRITE;
99/*!40000 ALTER TABLE `Room` DISABLE KEYS */;
100INSERT INTO `Room` VALUES (1,'salle de dojo'),(2,'salle de reunion'),(3,'salle de repos'),(4,'cuisine'),(5,'bureau'),(6,'openspace');
101/*!40000 ALTER TABLE `Room` ENABLE KEYS */;
102UNLOCK TABLES;
103/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
104
105/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
106/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
107/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
108/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
109/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
110/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
111/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
112
113-- Dump completed on 2018-03-28 17:09:26