· 8 years ago · Mar 25, 2018, 01:44 AM
1-- MySQL dump 10.13 Distrib 5.7.21, for Linux (x86_64)
2--
3-- Host: localhost Database: wcs_quest_35
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: `wcs_quest_35`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `wcs_quest_35` /*!40100 DEFAULT CHARACTER SET utf8 */;
23
24USE `wcs_quest_35`;
25
26--
27-- Table structure for table `classroom`
28--
29
30DROP TABLE IF EXISTS `classroom`;
31/*!40101 SET @saved_cs_client = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `classroom` (
34 `id` int(11) NOT NULL AUTO_INCREMENT,
35 `name` varchar(45) NOT NULL,
36 `school_id` int(11) NOT NULL,
37 PRIMARY KEY (`id`),
38 UNIQUE KEY `id_UNIQUE` (`id`),
39 KEY `fk_classroom_school1_idx` (`school_id`),
40 CONSTRAINT `fk_classroom_school1` FOREIGN KEY (`school_id`) REFERENCES `school` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
41) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
42/*!40101 SET character_set_client = @saved_cs_client */;
43
44--
45-- Dumping data for table `classroom`
46--
47
48LOCK TABLES `classroom` WRITE;
49/*!40000 ALTER TABLE `classroom` DISABLE KEYS */;
50INSERT INTO `classroom` 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);
51/*!40000 ALTER TABLE `classroom` ENABLE KEYS */;
52UNLOCK TABLES;
53
54--
55-- Table structure for table `language`
56--
57
58DROP TABLE IF EXISTS `language`;
59/*!40101 SET @saved_cs_client = @@character_set_client */;
60/*!40101 SET character_set_client = utf8 */;
61CREATE TABLE `language` (
62 `id` int(11) NOT NULL AUTO_INCREMENT,
63 `name` varchar(45) NOT NULL,
64 PRIMARY KEY (`id`),
65 UNIQUE KEY `id_UNIQUE` (`id`)
66) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
67/*!40101 SET character_set_client = @saved_cs_client */;
68
69--
70-- Dumping data for table `language`
71--
72
73LOCK TABLES `language` WRITE;
74/*!40000 ALTER TABLE `language` DISABLE KEYS */;
75INSERT INTO `language` VALUES (1,'French'),(2,'English'),(3,'Kekkei Genkai'),(4,'Dojutsu'),(5,'Fuinjutsu'),(6,'Kinjutsu');
76/*!40000 ALTER TABLE `language` ENABLE KEYS */;
77UNLOCK TABLES;
78
79--
80-- Table structure for table `person`
81--
82
83DROP TABLE IF EXISTS `person`;
84/*!40101 SET @saved_cs_client = @@character_set_client */;
85/*!40101 SET character_set_client = utf8 */;
86CREATE TABLE `person` (
87 `id` int(11) NOT NULL AUTO_INCREMENT,
88 `name` varchar(45) NOT NULL,
89 `first_name` varchar(45) NOT NULL,
90 `address` varchar(45) NOT NULL,
91 `school_id` int(11) NOT NULL,
92 `language_id` int(11) DEFAULT NULL,
93 `role_id` int(11) NOT NULL,
94 PRIMARY KEY (`id`),
95 UNIQUE KEY `id_UNIQUE` (`id`),
96 KEY `fk_person_school1_idx` (`school_id`),
97 KEY `fk_person_language1_idx` (`language_id`),
98 KEY `fk_person_role1_idx` (`role_id`),
99 CONSTRAINT `fk_person_language1` FOREIGN KEY (`language_id`) REFERENCES `language` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
100 CONSTRAINT `fk_person_role1` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
101 CONSTRAINT `fk_person_school1` FOREIGN KEY (`school_id`) REFERENCES `school` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
102) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
103/*!40101 SET character_set_client = @saved_cs_client */;
104
105--
106-- Dumping data for table `person`
107--
108
109LOCK TABLES `person` WRITE;
110/*!40000 ALTER TABLE `person` DISABLE KEYS */;
111INSERT INTO `person` VALUES (1,'Google','Inc','California',1,2,2),(2,'Laurie','Prester','On the top',1,NULL,1),(3,'Naruto','Uzumaki','Konoha',1,3,2),(4,'Nagato','Uzumaki','Amegakure',1,4,2),(5,'Hinata','Hyūga','Konoha',1,NULL,1),(6,'Hashirama','Senju','Konoha',1,NULL,1),(7,'Madara','Uchiha','Konoha',1,NULL,1),(8,'Kaguya','Ōtsutsuki','Galaxy',1,NULL,1),(9,'Julien','Lepers','Paris',1,NULL,1),(10,'Pepe','The Frog','Internet',1,NULL,1);
112/*!40000 ALTER TABLE `person` ENABLE KEYS */;
113UNLOCK TABLES;
114
115--
116-- Table structure for table `reservation`
117--
118
119DROP TABLE IF EXISTS `reservation`;
120/*!40101 SET @saved_cs_client = @@character_set_client */;
121/*!40101 SET character_set_client = utf8 */;
122CREATE TABLE `reservation` (
123 `id` int(11) NOT NULL AUTO_INCREMENT,
124 `person_id` int(11) NOT NULL,
125 `classroom_id` int(11) NOT NULL,
126 `date_begin` int(11) NOT NULL,
127 `date_finish` int(11) NOT NULL,
128 PRIMARY KEY (`id`),
129 UNIQUE KEY `id_UNIQUE` (`id`),
130 UNIQUE KEY `person_id_UNIQUE` (`person_id`),
131 KEY `fk_reservation_person_idx` (`person_id`),
132 KEY `fk_reservation_classroom_idx` (`classroom_id`),
133 CONSTRAINT `fk_reservation_classroom1` FOREIGN KEY (`classroom_id`) REFERENCES `classroom` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
134 CONSTRAINT `fk_reservation_person` FOREIGN KEY (`person_id`) REFERENCES `person` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
135) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
136/*!40101 SET character_set_client = @saved_cs_client */;
137
138--
139-- Dumping data for table `reservation`
140--
141
142LOCK TABLES `reservation` WRITE;
143/*!40000 ALTER TABLE `reservation` DISABLE KEYS */;
144INSERT INTO `reservation` VALUES (1,1,1,1521139712,1521139715),(3,2,1,1521139716,1521139719),(4,3,1,1521139720,1521139723),(5,4,3,1521139712,1521139754),(6,5,5,1521139712,1521139713),(7,6,5,1521139714,1521139715),(8,7,6,1521139716,1521139717),(9,8,6,1521139718,1521139719),(10,9,6,1521139720,1521139721),(11,10,6,1521139722,1521139723);
145/*!40000 ALTER TABLE `reservation` ENABLE KEYS */;
146UNLOCK TABLES;
147
148--
149-- Table structure for table `role`
150--
151
152DROP TABLE IF EXISTS `role`;
153/*!40101 SET @saved_cs_client = @@character_set_client */;
154/*!40101 SET character_set_client = utf8 */;
155CREATE TABLE `role` (
156 `id` int(11) NOT NULL AUTO_INCREMENT,
157 `name` varchar(45) NOT NULL,
158 PRIMARY KEY (`id`),
159 UNIQUE KEY `id_UNIQUE` (`id`)
160) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
161/*!40101 SET character_set_client = @saved_cs_client */;
162
163--
164-- Dumping data for table `role`
165--
166
167LOCK TABLES `role` WRITE;
168/*!40000 ALTER TABLE `role` DISABLE KEYS */;
169INSERT INTO `role` VALUES (1,'Student'),(2,'Teacher');
170/*!40000 ALTER TABLE `role` ENABLE KEYS */;
171UNLOCK TABLES;
172
173--
174-- Table structure for table `school`
175--
176
177DROP TABLE IF EXISTS `school`;
178/*!40101 SET @saved_cs_client = @@character_set_client */;
179/*!40101 SET character_set_client = utf8 */;
180CREATE TABLE `school` (
181 `id` int(11) NOT NULL AUTO_INCREMENT,
182 `name` varchar(45) NOT NULL,
183 PRIMARY KEY (`id`),
184 UNIQUE KEY `id_UNIQUE` (`id`)
185) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
186/*!40101 SET character_set_client = @saved_cs_client */;
187
188--
189-- Dumping data for table `school`
190--
191
192LOCK TABLES `school` WRITE;
193/*!40000 ALTER TABLE `school` DISABLE KEYS */;
194INSERT INTO `school` VALUES (1,'Orléans');
195/*!40000 ALTER TABLE `school` ENABLE KEYS */;
196UNLOCK TABLES;
197/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
198
199/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
200/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
201/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
202/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
203/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
204/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
205/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
206
207-- Dump completed on 2018-03-16 10:25:18