· 8 years ago · Mar 23, 2018, 10:34 AM
1-- MySQL dump 10.13 Distrib 5.7.21, for Linux (x86_64)
2--
3-- Host: localhost Database: RoomManagement
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: `RoomManagement`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `RoomManagement` /*!40100 DEFAULT CHARACTER SET utf8 */;
23
24USE `RoomManagement`;
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(45) NOT NULL,
36 PRIMARY KEY (`id`)
37) ENGINE=InnoDB AUTO_INCREMENT=4 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,'JavaScript'),(3,'Ruby');
47/*!40000 ALTER TABLE `Language` ENABLE KEYS */;
48UNLOCK TABLES;
49
50--
51-- Table structure for table `Person`
52--
53
54DROP TABLE IF EXISTS `Person`;
55/*!40101 SET @saved_cs_client = @@character_set_client */;
56/*!40101 SET character_set_client = utf8 */;
57CREATE TABLE `Person` (
58 `file_number` int(11) NOT NULL AUTO_INCREMENT,
59 `name` varchar(45) NOT NULL,
60 `firstname` varchar(45) NOT NULL,
61 `address` varchar(150) NOT NULL,
62 `language_id` int(11) NOT NULL,
63 `role_id` int(11) NOT NULL,
64 `school_id` int(11) NOT NULL,
65 PRIMARY KEY (`file_number`),
66 KEY `fk_Person_Language_idx` (`language_id`),
67 KEY `fk_Person_Role1_idx` (`role_id`),
68 KEY `fk_Person_Scool1_idx` (`school_id`),
69 CONSTRAINT `fk_Person_Language` FOREIGN KEY (`language_id`) REFERENCES `Language` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
70 CONSTRAINT `fk_Person_Role` FOREIGN KEY (`role_id`) REFERENCES `Role` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
71 CONSTRAINT `fk_Person_Scool` FOREIGN KEY (`school_id`) REFERENCES `School` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
72) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
73/*!40101 SET character_set_client = @saved_cs_client */;
74
75--
76-- Dumping data for table `Person`
77--
78
79LOCK TABLES `Person` WRITE;
80/*!40000 ALTER TABLE `Person` DISABLE KEYS */;
81INSERT INTO `Person` VALUES (1,'Alexandre','Julien','3 rue de la Tour qui Penche - 45000 ORLEANS',1,1,1),(2,'Roy','Louise','3 rue de la Tour qui Penche - 45000 ORLEANS',1,1,1),(3,'Bourgadel','Julien','3 rue de la Tour qui Penche - 45000 ORLEANS',1,1,1),(4,'Beauchamp','Yoan','3 rue de la Tour qui Penche - 45000 ORLEANS',2,1,1),(5,'Meckler','Xavier','3 rue de la Tour qui Penche - 45000 ORLEANS',3,1,1),(6,'Picard','Quentin','3 rue de la Tour qui Penche - 45000 ORLEANS',1,1,1),(7,'Juin','Nicolas','3 rue de la Tour qui Penche - 45000 ORLEANS',2,1,1),(8,'Goyard','Maxime','3 rue de la Tour qui Penche - 45000 ORLEANS',1,1,1),(9,'Ami','Google','3 rue de la Tour qui Penche - 45000 ORLEANS',3,1,1),(10,'Copine','Lorie','3 rue de la Tour qui Penche - 45000 ORLEANS',1,1,1),(11,'Blondeau','Sylvain','3 rue de la Tour qui Penche - 45000 ORLEANS',1,2,1),(12,'Vincent','Nicolas','3 rue de la Tour qui Penche - 45000 ORLEANS',1,2,1),(13,'Devos','John','3 rue de la Tour qui Penche - 45000 ORLEANS',1,3,1);
82/*!40000 ALTER TABLE `Person` ENABLE KEYS */;
83UNLOCK TABLES;
84
85--
86-- Table structure for table `Reservation`
87--
88
89DROP TABLE IF EXISTS `Reservation`;
90/*!40101 SET @saved_cs_client = @@character_set_client */;
91/*!40101 SET character_set_client = utf8 */;
92CREATE TABLE `Reservation` (
93 `id` int(11) NOT NULL AUTO_INCREMENT,
94 `date` datetime NOT NULL,
95 `duration` int(11) NOT NULL,
96 `room_id` int(11) NOT NULL,
97 `person_file_number` int(11) NOT NULL,
98 PRIMARY KEY (`id`),
99 KEY `fk_Reservation_Room1_idx` (`room_id`),
100 KEY `fk_Reservation_Person1_idx` (`person_file_number`),
101 CONSTRAINT `fk_Reservation_Person` FOREIGN KEY (`person_file_number`) REFERENCES `Person` (`file_number`) ON DELETE NO ACTION ON UPDATE NO ACTION,
102 CONSTRAINT `fk_Reservation_Room` FOREIGN KEY (`room_id`) REFERENCES `Room` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
103) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
104/*!40101 SET character_set_client = @saved_cs_client */;
105
106--
107-- Dumping data for table `Reservation`
108--
109
110LOCK TABLES `Reservation` WRITE;
111/*!40000 ALTER TABLE `Reservation` DISABLE KEYS */;
112INSERT INTO `Reservation` VALUES (1,'2018-03-14 00:00:00',30,1,1),(2,'2018-03-15 00:00:00',40,1,2),(3,'2018-03-16 00:00:00',20,1,3),(4,'2018-03-20 00:00:00',30,5,6),(5,'2018-03-21 00:00:00',40,5,7),(6,'2018-04-02 00:00:00',15,3,12),(7,'2018-04-03 00:00:00',15,6,7),(8,'2018-04-04 00:00:00',60,6,8),(9,'2018-04-05 00:00:00',80,6,9),(10,'2018-04-06 00:00:00',10,6,13);
113/*!40000 ALTER TABLE `Reservation` ENABLE KEYS */;
114UNLOCK TABLES;
115
116--
117-- Table structure for table `Role`
118--
119
120DROP TABLE IF EXISTS `Role`;
121/*!40101 SET @saved_cs_client = @@character_set_client */;
122/*!40101 SET character_set_client = utf8 */;
123CREATE TABLE `Role` (
124 `id` int(11) NOT NULL AUTO_INCREMENT,
125 `name` varchar(45) NOT NULL,
126 PRIMARY KEY (`id`)
127) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
128/*!40101 SET character_set_client = @saved_cs_client */;
129
130--
131-- Dumping data for table `Role`
132--
133
134LOCK TABLES `Role` WRITE;
135/*!40000 ALTER TABLE `Role` DISABLE KEYS */;
136INSERT INTO `Role` VALUES (1,'Eleve'),(2,'Formateur'),(3,'Campus Manager');
137/*!40000 ALTER TABLE `Role` ENABLE KEYS */;
138UNLOCK TABLES;
139
140--
141-- Table structure for table `Room`
142--
143
144DROP TABLE IF EXISTS `Room`;
145/*!40101 SET @saved_cs_client = @@character_set_client */;
146/*!40101 SET character_set_client = utf8 */;
147CREATE TABLE `Room` (
148 `id` int(11) NOT NULL AUTO_INCREMENT,
149 `name` varchar(45) NOT NULL,
150 `school_id` int(11) NOT NULL,
151 PRIMARY KEY (`id`),
152 KEY `fk_Room_School1_idx` (`school_id`),
153 CONSTRAINT `fk_Room_School` FOREIGN KEY (`school_id`) REFERENCES `School` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
154) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
155/*!40101 SET character_set_client = @saved_cs_client */;
156
157--
158-- Dumping data for table `Room`
159--
160
161LOCK TABLES `Room` WRITE;
162/*!40000 ALTER TABLE `Room` DISABLE KEYS */;
163INSERT INTO `Room` VALUES (1,'Salle de dojo',1),(2,'Salle de réunion',1),(3,'Salle de repos',1),(4,'Cuisine',1),(5,'Bureau',1),(6,'OpenSpace',1);
164/*!40000 ALTER TABLE `Room` ENABLE KEYS */;
165UNLOCK TABLES;
166
167--
168-- Table structure for table `School`
169--
170
171DROP TABLE IF EXISTS `School`;
172/*!40101 SET @saved_cs_client = @@character_set_client */;
173/*!40101 SET character_set_client = utf8 */;
174CREATE TABLE `School` (
175 `id` int(11) NOT NULL AUTO_INCREMENT,
176 `name` varchar(45) DEFAULT NULL,
177 PRIMARY KEY (`id`)
178) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
179/*!40101 SET character_set_client = @saved_cs_client */;
180
181--
182-- Dumping data for table `School`
183--
184
185LOCK TABLES `School` WRITE;
186/*!40000 ALTER TABLE `School` DISABLE KEYS */;
187INSERT INTO `School` VALUES (1,'Orléans'),(2,'Reims'),(3,'Toulouse');
188/*!40000 ALTER TABLE `School` ENABLE KEYS */;
189UNLOCK TABLES;
190/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
191
192/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
193/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
194/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
195/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
196/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
197/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
198/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
199
200-- Dump completed on 2018-03-14 18:39:43