eQy08p8V

1-- MySQL dump 10.13  Distrib 5.7.21, for Linux (x86_64)
2--
3-- Host: localhost    Database: mydb
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-- Table structure for table `Reservations`
20--
21
22DROP TABLE IF EXISTS `Reservations`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `Reservations` (
26  `idreservations` int(11) NOT NULL AUTO_INCREMENT,
27  `begin` varchar(45) DEFAULT NULL,
28  `doration` int(11) DEFAULT NULL,
29  `room_idroom` int(11) DEFAULT NULL,
30  `people_id` int(11) DEFAULT NULL,
31  PRIMARY KEY (`idreservations`),
32  KEY `fk_reservations_room1_idx` (`room_idroom`),
33  KEY `fk_Reservations_peoble1_idx` (`people_id`),
34  CONSTRAINT `fk_Reservations_peoble1` FOREIGN KEY (`people_id`) REFERENCES `people` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
35  CONSTRAINT `fk_reservations_room1` FOREIGN KEY (`room_idroom`) REFERENCES `Room` (`idroom`) ON DELETE NO ACTION ON UPDATE NO ACTION
36) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
37/*!40101 SET character_set_client = @saved_cs_client */;
38
39--
40-- Dumping data for table `Reservations`
41--
42
43LOCK TABLES `Reservations` WRITE;
44/*!40000 ALTER TABLE `Reservations` DISABLE KEYS */;
45INSERT INTO `Reservations` VALUES (1,'21/03/2018',5,1,1),(2,'21/03/2018',2,1,2),(3,'21/03/2018',1,1,3),(4,'21/03/2018',4,5,4),(5,'21/03/2018',2,5,5),(6,'21/03/2018',2,3,6),(12,'22/03/2018',3,6,7),(13,'22/03/2018',2,6,8),(14,'22/03/2018',2,6,9),(15,'22/03/2018',2,6,10);
46/*!40000 ALTER TABLE `Reservations` ENABLE KEYS */;
47UNLOCK TABLES;
48
49--
50-- Table structure for table `Role`
51--
52
53DROP TABLE IF EXISTS `Role`;
54/*!40101 SET @saved_cs_client     = @@character_set_client */;
55/*!40101 SET character_set_client = utf8 */;
56CREATE TABLE `Role` (
57  `idRole` int(11) NOT NULL AUTO_INCREMENT,
58  `name` varchar(45) DEFAULT NULL,
59  PRIMARY KEY (`idRole`)
60) ENGINE=InnoDB DEFAULT CHARSET=utf8;
61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Dumping data for table `Role`
65--
66
67LOCK TABLES `Role` WRITE;
68/*!40000 ALTER TABLE `Role` DISABLE KEYS */;
69/*!40000 ALTER TABLE `Role` ENABLE KEYS */;
70UNLOCK TABLES;
71
72--
73-- Table structure for table `Room`
74--
75
76DROP TABLE IF EXISTS `Room`;
77/*!40101 SET @saved_cs_client     = @@character_set_client */;
78/*!40101 SET character_set_client = utf8 */;
79CREATE TABLE `Room` (
80  `idroom` int(11) NOT NULL AUTO_INCREMENT,
81  `nome` varchar(45) DEFAULT NULL,
82  `school_idschool` int(11) DEFAULT NULL,
83  PRIMARY KEY (`idroom`)
84) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
85/*!40101 SET character_set_client = @saved_cs_client */;
86
87--
88-- Dumping data for table `Room`
89--
90
91LOCK TABLES `Room` WRITE;
92/*!40000 ALTER TABLE `Room` DISABLE KEYS */;
93INSERT INTO `Room` VALUES (1,'Salle de dojo',NULL),(2,'Salle de réunion',NULL),(3,'Salle de repos',NULL),(4,'Cuisine',NULL),(5,'Bureau',NULL),(6,'OpenSpace',NULL);
94/*!40000 ALTER TABLE `Room` ENABLE KEYS */;
95UNLOCK TABLES;
96
97--
98-- Table structure for table `School`
99--
100
101DROP TABLE IF EXISTS `School`;
102/*!40101 SET @saved_cs_client     = @@character_set_client */;
103/*!40101 SET character_set_client = utf8 */;
104CREATE TABLE `School` (
105  `idschool` int(11) NOT NULL AUTO_INCREMENT,
106  `name` varchar(45) DEFAULT NULL,
107  PRIMARY KEY (`idschool`)
108) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
109/*!40101 SET character_set_client = @saved_cs_client */;
110
111--
112-- Dumping data for table `School`
113--
114
115LOCK TABLES `School` WRITE;
116/*!40000 ALTER TABLE `School` DISABLE KEYS */;
117INSERT INTO `School` VALUES (1,'Orleans');
118/*!40000 ALTER TABLE `School` ENABLE KEYS */;
119UNLOCK TABLES;
120
121--
122-- Table structure for table `langage`
123--
124
125DROP TABLE IF EXISTS `langage`;
126/*!40101 SET @saved_cs_client     = @@character_set_client */;
127/*!40101 SET character_set_client = utf8 */;
128CREATE TABLE `langage` (
129  `idlangage` int(11) NOT NULL AUTO_INCREMENT,
130  `nome` varchar(45) DEFAULT NULL,
131  PRIMARY KEY (`idlangage`)
132) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
133/*!40101 SET character_set_client = @saved_cs_client */;
134
135--
136-- Dumping data for table `langage`
137--
138
139LOCK TABLES `langage` WRITE;
140/*!40000 ALTER TABLE `langage` DISABLE KEYS */;
141INSERT INTO `langage` VALUES (1,'PHP'),(2,'JAVA'),(3,'ASP.net');
142/*!40000 ALTER TABLE `langage` ENABLE KEYS */;
143UNLOCK TABLES;
144
145--
146-- Table structure for table `people`
147--
148
149DROP TABLE IF EXISTS `people`;
150/*!40101 SET @saved_cs_client     = @@character_set_client */;
151/*!40101 SET character_set_client = utf8 */;
152CREATE TABLE `people` (
153  `id` int(11) NOT NULL AUTO_INCREMENT,
154  `firstname` varchar(45) DEFAULT NULL,
155  `lastname` varchar(45) DEFAULT NULL,
156  `address` varchar(45) DEFAULT NULL,
157  `langage_idlangage` int(11) DEFAULT NULL,
158  `Role_idRole` int(11) DEFAULT NULL,
159  `school_idschool` int(11) DEFAULT NULL,
160  PRIMARY KEY (`id`),
161  KEY `fk_person_langage_idx` (`langage_idlangage`),
162  KEY `fk_person_Role1_idx` (`Role_idRole`),
163  KEY `fk_person_school1_idx` (`school_idschool`),
164  CONSTRAINT `fk_person_Role1` FOREIGN KEY (`Role_idRole`) REFERENCES `Role` (`idRole`) ON DELETE NO ACTION ON UPDATE NO ACTION,
165  CONSTRAINT `fk_person_langage` FOREIGN KEY (`langage_idlangage`) REFERENCES `langage` (`idlangage`) ON DELETE NO ACTION ON UPDATE NO ACTION,
166  CONSTRAINT `fk_person_school1` FOREIGN KEY (`school_idschool`) REFERENCES `School` (`idschool`) ON DELETE NO ACTION ON UPDATE NO ACTION
167) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
168/*!40101 SET character_set_client = @saved_cs_client */;
169
170--
171-- Dumping data for table `people`
172--
173
174LOCK TABLES `people` WRITE;
175/*!40000 ALTER TABLE `people` DISABLE KEYS */;
176INSERT INTO `people` VALUES (1,'ziad','ibrahim','orleans',NULL,NULL,NULL),(2,'google','gio','washinghton',NULL,NULL,NULL),(3,'Laurie','Trotisky','Mosco',NULL,NULL,NULL),(4,'Jamal','Abdulnasser','qairo',NULL,NULL,NULL),(5,'lion','trotiski','stalingrad',NULL,NULL,NULL),(6,'Fladimair','LININ','Liningrade',NULL,NULL,NULL),(7,'Carle','Marx','Berlin',NULL,NULL,NULL),(8,'Fredrique','Anglis','Paris',NULL,NULL,NULL),(9,'Chi','Givara','Bonisaires',NULL,NULL,NULL),(10,'Ryad','ALturk','Damas',NULL,NULL,NULL);
177/*!40000 ALTER TABLE `people` ENABLE KEYS */;
178UNLOCK TABLES;
179/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
180
181/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
182/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
183/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
184/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
185/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
186/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
187/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
188
189-- Dump completed on 2018-03-20 23:56:11