· 8 years ago · Mar 21, 2018, 07:58 AM
1-- MySQL dump 10.13 Distrib 5.7.21, for Linux (x86_64)
2--
3-- Host: localhost Database: RoomBooking
4-- ------------------------------------------------------
5-- Server version 5.7.21-0ubuntu0.17.10.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: `RoomBooking`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `RoomBooking` /*!40100 DEFAULT CHARACTER SET utf8 */;
23
24USE `RoomBooking`;
25
26--
27-- Table structure for table `Language`
28--
29
30DROP TABLE IF EXISTS `Language`;
31/*!40101 SET @saved_cs_client = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `Language` (
34 `id` int(11) NOT NULL AUTO_INCREMENT,
35 `language` varchar(50) DEFAULT NULL,
36 PRIMARY KEY (`id`)
37) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
38/*!40101 SET character_set_client = @saved_cs_client */;
39
40--
41-- Dumping data for table `Language`
42--
43
44LOCK TABLES `Language` WRITE;
45/*!40000 ALTER TABLE `Language` DISABLE KEYS */;
46INSERT INTO `Language` VALUES (1,'php'),(2,'java'),(3,'c#'),(4,'html'),(5,'css'),(6,'ruby'),(7,'go');
47/*!40000 ALTER TABLE `Language` ENABLE KEYS */;
48UNLOCK TABLES;
49
50--
51-- Table structure for table `People`
52--
53
54DROP TABLE IF EXISTS `People`;
55/*!40101 SET @saved_cs_client = @@character_set_client */;
56/*!40101 SET character_set_client = utf8 */;
57CREATE TABLE `People` (
58 `id` int(11) NOT NULL AUTO_INCREMENT,
59 `last_name` varchar(45) DEFAULT NULL,
60 `first_name` varchar(45) DEFAULT NULL,
61 `address` varchar(255) DEFAULT NULL,
62 `language_id` int(11) DEFAULT NULL,
63 PRIMARY KEY (`id`),
64 KEY `fk_People_Language1_idx` (`language_id`),
65 CONSTRAINT `fk_People_Language1` FOREIGN KEY (`language_id`) REFERENCES `Language` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
66) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='Un proffesseur est une personne avec un langage et sans adresse.\nUn étudiant est une personne avec une adresse et sans langage.';
67/*!40101 SET character_set_client = @saved_cs_client */;
68
69--
70-- Dumping data for table `People`
71--
72
73LOCK TABLES `People` WRITE;
74/*!40000 ALTER TABLE `People` DISABLE KEYS */;
75INSERT INTO `People` VALUES (1,'legrand','jerome','chécy',1),(7,'mouton','raphael','rillons',NULL),(8,'sauttejeau','anthony','ingre',NULL),(9,'vincent','nicolas','orleans',1),(10,'blondeau','sylvain','orleans',1),(11,'google',NULL,'partout',7),(12,'pester','lorie','val d\'oise',NULL),(13,'paquin','clement','orleans',NULL),(14,'do','cyril',NULL,NULL),(15,'roy','louise','saran',3);
76/*!40000 ALTER TABLE `People` ENABLE KEYS */;
77UNLOCK TABLES;
78
79--
80-- Table structure for table `Room`
81--
82
83DROP TABLE IF EXISTS `Room`;
84/*!40101 SET @saved_cs_client = @@character_set_client */;
85/*!40101 SET character_set_client = utf8 */;
86CREATE TABLE `Room` (
87 `id` int(11) NOT NULL AUTO_INCREMENT,
88 `name` varchar(45) DEFAULT NULL,
89 PRIMARY KEY (`id`)
90) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
91/*!40101 SET character_set_client = @saved_cs_client */;
92
93--
94-- Dumping data for table `Room`
95--
96
97LOCK TABLES `Room` WRITE;
98/*!40000 ALTER TABLE `Room` DISABLE KEYS */;
99INSERT INTO `Room` VALUES (1,'salle de dojo'),(2,'salle de reunion'),(3,'salle de repos'),(4,'cuisine'),(5,'bureau'),(6,'openspace');
100/*!40000 ALTER TABLE `Room` ENABLE KEYS */;
101UNLOCK TABLES;
102
103--
104-- Table structure for table `Room_reservation`
105--
106
107DROP TABLE IF EXISTS `Room_reservation`;
108/*!40101 SET @saved_cs_client = @@character_set_client */;
109/*!40101 SET character_set_client = utf8 */;
110CREATE TABLE `Room_reservation` (
111 `room_id` int(11) NOT NULL,
112 `people_id` int(11) NOT NULL,
113 `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
114 `duration` int(11) NOT NULL,
115 PRIMARY KEY (`room_id`,`date`,`people_id`),
116 KEY `fk_Room_has_People_People1_idx` (`people_id`),
117 KEY `fk_Room_has_People_Room_idx` (`room_id`),
118 CONSTRAINT `fk_Room_has_People_People1` FOREIGN KEY (`people_id`) REFERENCES `People` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
119 CONSTRAINT `fk_Room_has_People_Room` FOREIGN KEY (`room_id`) REFERENCES `Room` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
120) ENGINE=InnoDB DEFAULT CHARSET=utf8;
121/*!40101 SET character_set_client = @saved_cs_client */;
122
123--
124-- Dumping data for table `Room_reservation`
125--
126
127LOCK TABLES `Room_reservation` WRITE;
128/*!40000 ALTER TABLE `Room_reservation` DISABLE KEYS */;
129INSERT INTO `Room_reservation` VALUES (1,1,'2018-03-12 17:13:00',1),(1,7,'2018-03-12 17:13:25',3),(1,10,'2018-03-12 17:13:25',4),(3,14,'2018-03-12 17:16:47',8),(5,12,'2018-03-12 17:14:13',2),(5,13,'2018-03-12 17:14:13',1),(6,8,'2018-03-12 17:16:47',3),(6,9,'2018-03-12 17:16:47',3),(6,11,'2018-03-12 17:16:47',3),(6,15,'2018-03-12 17:16:47',3);
130/*!40000 ALTER TABLE `Room_reservation` ENABLE KEYS */;
131UNLOCK TABLES;
132/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
133
134/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
135/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
136/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
137/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
138/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
139/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
140/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
141
142-- Dump completed on 2018-03-12 17:36:31