WSRaAmEF

1-- MySQL dump 10.13  Distrib 5.7.21, for Linux (x86_64)
2--
3-- Host: localhost    Database: classroom_booking
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: `classroom_booking`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `classroom_booking` /*!40100 DEFAULT CHARACTER SET utf8 */;
23
24USE `classroom_booking`;
25
26--
27-- Table structure for table `booking`
28--
29
30DROP TABLE IF EXISTS `booking`;
31/*!40101 SET @saved_cs_client     = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `booking` (
34  `id` int(11) NOT NULL AUTO_INCREMENT,
35  `date` date DEFAULT NULL,
36  `duration` int(11) DEFAULT NULL,
37  `student_id` int(11) DEFAULT NULL,
38  `trainer_id` int(11) DEFAULT NULL,
39  `classroom_id` int(11) NOT NULL,
40  PRIMARY KEY (`id`),
41  KEY `fk_booking_student_idx` (`student_id`),
42  KEY `fk_booking_trainer1_idx` (`trainer_id`),
43  KEY `fk_booking_classroom1_idx` (`classroom_id`),
44  CONSTRAINT `fk_booking_classroom1` FOREIGN KEY (`classroom_id`) REFERENCES `classroom` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
45  CONSTRAINT `fk_booking_student` FOREIGN KEY (`student_id`) REFERENCES `student` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
46  CONSTRAINT `fk_booking_trainer1` FOREIGN KEY (`trainer_id`) REFERENCES `trainer` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
47) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
48/*!40101 SET character_set_client = @saved_cs_client */;
49
50--
51-- Dumping data for table `booking`
52--
53
54LOCK TABLES `booking` WRITE;
55/*!40000 ALTER TABLE `booking` DISABLE KEYS */;
56INSERT INTO `booking` VALUES (1,'2018-11-03',1,1,NULL,1),(2,'2018-11-04',2,2,NULL,1),(3,'2018-11-05',1,3,NULL,1),(4,'2018-11-06',2,4,NULL,5),(5,'2018-11-06',1,NULL,1,5),(6,'2018-11-07',5,5,NULL,3),(7,'2018-11-08',2,6,NULL,6),(8,'2018-11-09',2,7,NULL,6),(9,'2018-11-10',2,8,NULL,6),(10,'2018-11-09',1,NULL,2,6);
57/*!40000 ALTER TABLE `booking` ENABLE KEYS */;
58UNLOCK TABLES;
59
60--
61-- Table structure for table `classroom`
62--
63
64DROP TABLE IF EXISTS `classroom`;
65/*!40101 SET @saved_cs_client     = @@character_set_client */;
66/*!40101 SET character_set_client = utf8 */;
67CREATE TABLE `classroom` (
68  `id` int(11) NOT NULL AUTO_INCREMENT,
69  `name` varchar(32) DEFAULT NULL,
70  PRIMARY KEY (`id`)
71) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
72/*!40101 SET character_set_client = @saved_cs_client */;
73
74--
75-- Dumping data for table `classroom`
76--
77
78LOCK TABLES `classroom` WRITE;
79/*!40000 ALTER TABLE `classroom` DISABLE KEYS */;
80INSERT INTO `classroom` VALUES (1,'Salle de dojo'),(2,'Salle de réunion'),(3,'Salle de repos'),(4,'Cuisine'),(5,'Bureau'),(6,'OpenSpace');
81/*!40000 ALTER TABLE `classroom` ENABLE KEYS */;
82UNLOCK TABLES;
83
84--
85-- Table structure for table `student`
86--
87
88DROP TABLE IF EXISTS `student`;
89/*!40101 SET @saved_cs_client     = @@character_set_client */;
90/*!40101 SET character_set_client = utf8 */;
91CREATE TABLE `student` (
92  `id` int(11) NOT NULL AUTO_INCREMENT,
93  `name` varchar(64) DEFAULT NULL,
94  `firstname` varchar(64) DEFAULT NULL,
95  `adress` text,
96  PRIMARY KEY (`id`)
97) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
98/*!40101 SET character_set_client = @saved_cs_client */;
99
100--
101-- Dumping data for table `student`
102--
103
104LOCK TABLES `student` WRITE;
105/*!40000 ALTER TABLE `student` DISABLE KEYS */;
106INSERT INTO `student` VALUES (1,'Lombaert','Sylvain','Valenciennes'),(2,'Serre','Thibault','Lille'),(3,'Copin','Thomas','Belgique'),(4,'Legrand','Cannelle','Lille'),(5,'Duquesne','Raphael','Lille'),(6,'Tutu','Toto','Biarritz'),(7,'Lemaire','Julien','Lambersart'),(8,'Claude','Amandine','Lambersart');
107/*!40000 ALTER TABLE `student` ENABLE KEYS */;
108UNLOCK TABLES;
109
110--
111-- Table structure for table `trainer`
112--
113
114DROP TABLE IF EXISTS `trainer`;
115/*!40101 SET @saved_cs_client     = @@character_set_client */;
116/*!40101 SET character_set_client = utf8 */;
117CREATE TABLE `trainer` (
118  `id` int(11) NOT NULL AUTO_INCREMENT,
119  `name` varchar(64) DEFAULT NULL,
120  `firstname` varchar(64) DEFAULT NULL,
121  `langage` varchar(32) DEFAULT NULL,
122  PRIMARY KEY (`id`)
123) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
124/*!40101 SET character_set_client = @saved_cs_client */;
125
126--
127-- Dumping data for table `trainer`
128--
129
130LOCK TABLES `trainer` WRITE;
131/*!40000 ALTER TABLE `trainer` DISABLE KEYS */;
132INSERT INTO `trainer` VALUES (1,'Monami','Google','PHP'),(2,'Pester','Lorie','PHP');
133/*!40000 ALTER TABLE `trainer` ENABLE KEYS */;
134UNLOCK TABLES;
135/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
136
137/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
138/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
139/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
140/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
141/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
142/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
143/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
144
145-- Dump completed on 2018-03-19 12:11:51