· 8 years ago · Mar 24, 2018, 05:56 AM
1CREATE DATABASE IF NOT EXISTS `egerard` /*!40100 DEFAULT CHARACTER SET utf8 */;
2USE `egerard`;
3-- MySQL dump 10.13 Distrib 5.7.21, for Linux (x86_64)
4--
5-- Host: localhost Database: egerard
6-- ------------------------------------------------------
7-- Server version 5.7.21-0ubuntu0.17.10.1
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `Langage`
22--
23
24DROP TABLE IF EXISTS `Langage`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `Langage` (
28 `ID` int(11) NOT NULL,
29 `Langage` varchar(45) DEFAULT NULL,
30 PRIMARY KEY (`ID`)
31) ENGINE=InnoDB DEFAULT CHARSET=utf8;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Dumping data for table `Langage`
36--
37
38LOCK TABLES `Langage` WRITE;
39/*!40000 ALTER TABLE `Langage` DISABLE KEYS */;
40INSERT INTO `Langage` VALUES (1,'PhP');
41/*!40000 ALTER TABLE `Langage` ENABLE KEYS */;
42UNLOCK TABLES;
43
44--
45-- Table structure for table `People`
46--
47
48DROP TABLE IF EXISTS `People`;
49/*!40101 SET @saved_cs_client = @@character_set_client */;
50/*!40101 SET character_set_client = utf8 */;
51CREATE TABLE `People` (
52 `ID` int(11) NOT NULL,
53 `Lastname` varchar(45) DEFAULT NULL,
54 `Firstname` varchar(45) DEFAULT NULL,
55 `Adress` varchar(45) DEFAULT NULL,
56 `Langage_ID` int(11) NOT NULL,
57 `Role_ID` int(11) NOT NULL,
58 `School_ID` int(11) NOT NULL,
59 PRIMARY KEY (`ID`),
60 KEY `fk_People_Langage_idx` (`Langage_ID`),
61 KEY `fk_People_Role1_idx` (`Role_ID`),
62 KEY `fk_People_School1_idx` (`School_ID`),
63 CONSTRAINT `fk_People_Langage` FOREIGN KEY (`Langage_ID`) REFERENCES `Langage` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
64 CONSTRAINT `fk_People_Role1` FOREIGN KEY (`Role_ID`) REFERENCES `Role` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
65 CONSTRAINT `fk_People_School1` FOREIGN KEY (`School_ID`) REFERENCES `School` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
66) ENGINE=InnoDB DEFAULT CHARSET=utf8;
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,'LeHobbit','Sylvain','CulDeSac',1,1,1),(2,'Skywalker','Nicolas','Tatooine',1,1,1),(3,'LePatron','Google','Partout',1,2,1),(4,'Loubliee','Laurie','Inconnu',1,2,1),(5,'Beauchamp','Yoan','Orleans',1,2,1),(6,'Li','John','Orleans',1,2,1),(7,'Burton','Tim','Londres',1,1,1),(8,'Limousin','Julia','Orleans',1,2,1),(9,'Berger','Emilie','Orleans',1,2,1),(10,'Gerard','Edwin','Nowhere',1,2,1);
76/*!40000 ALTER TABLE `People` ENABLE KEYS */;
77UNLOCK TABLES;
78
79--
80-- Table structure for table `Reservation`
81--
82
83DROP TABLE IF EXISTS `Reservation`;
84/*!40101 SET @saved_cs_client = @@character_set_client */;
85/*!40101 SET character_set_client = utf8 */;
86CREATE TABLE `Reservation` (
87 `ID` int(11) NOT NULL,
88 `date_reservee` datetime DEFAULT NULL,
89 `duree` int(11) DEFAULT NULL,
90 `People_ID` int(11) NOT NULL,
91 `Salle_ID` int(11) NOT NULL,
92 PRIMARY KEY (`ID`),
93 KEY `fk_Reservation_People1_idx` (`People_ID`),
94 KEY `fk_Reservation_Salle1_idx` (`Salle_ID`),
95 CONSTRAINT `fk_Reservation_People1` FOREIGN KEY (`People_ID`) REFERENCES `People` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
96 CONSTRAINT `fk_Reservation_Salle1` FOREIGN KEY (`Salle_ID`) REFERENCES `Salle` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
97) ENGINE=InnoDB DEFAULT CHARSET=utf8;
98/*!40101 SET character_set_client = @saved_cs_client */;
99
100--
101-- Dumping data for table `Reservation`
102--
103
104LOCK TABLES `Reservation` WRITE;
105/*!40000 ALTER TABLE `Reservation` DISABLE KEYS */;
106INSERT INTO `Reservation` VALUES (1,'2018-03-15 12:15:10',60,1,1),(2,'2018-03-16 12:15:10',60,2,1),(3,'2018-03-17 12:15:10',60,3,1),(4,'2018-03-18 12:15:10',60,4,5),(5,'2018-03-19 12:15:10',60,5,5),(6,'2018-03-20 12:15:10',60,6,3),(7,'2018-03-21 12:15:10',60,7,6),(8,'2018-03-22 12:15:10',60,8,6),(9,'2018-03-23 12:15:10',60,9,6),(10,'2018-03-24 12:15:10',60,10,6);
107/*!40000 ALTER TABLE `Reservation` ENABLE KEYS */;
108UNLOCK TABLES;
109
110--
111-- Table structure for table `Role`
112--
113
114DROP TABLE IF EXISTS `Role`;
115/*!40101 SET @saved_cs_client = @@character_set_client */;
116/*!40101 SET character_set_client = utf8 */;
117CREATE TABLE `Role` (
118 `ID` int(11) NOT NULL,
119 `Name` varchar(45) DEFAULT NULL,
120 PRIMARY KEY (`ID`)
121) ENGINE=InnoDB DEFAULT CHARSET=utf8;
122/*!40101 SET character_set_client = @saved_cs_client */;
123
124--
125-- Dumping data for table `Role`
126--
127
128LOCK TABLES `Role` WRITE;
129/*!40000 ALTER TABLE `Role` DISABLE KEYS */;
130INSERT INTO `Role` VALUES (1,'Formateur'),(2,'Eleve');
131/*!40000 ALTER TABLE `Role` ENABLE KEYS */;
132UNLOCK TABLES;
133
134--
135-- Table structure for table `Salle`
136--
137
138DROP TABLE IF EXISTS `Salle`;
139/*!40101 SET @saved_cs_client = @@character_set_client */;
140/*!40101 SET character_set_client = utf8 */;
141CREATE TABLE `Salle` (
142 `ID` int(11) NOT NULL,
143 `Name` varchar(45) DEFAULT NULL,
144 `School_ID` int(11) NOT NULL,
145 PRIMARY KEY (`ID`),
146 KEY `fk_Salle_School1_idx` (`School_ID`),
147 CONSTRAINT `fk_Salle_School1` FOREIGN KEY (`School_ID`) REFERENCES `School` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
148) ENGINE=InnoDB DEFAULT CHARSET=utf8;
149/*!40101 SET character_set_client = @saved_cs_client */;
150
151--
152-- Dumping data for table `Salle`
153--
154
155LOCK TABLES `Salle` WRITE;
156/*!40000 ALTER TABLE `Salle` DISABLE KEYS */;
157INSERT INTO `Salle` VALUES (1,'Salle de Dojo',1),(2,'Salle de reunion',1),(3,'Salle de repos',1),(4,'Cuisine',1),(5,'Bureau',1),(6,'OpenSpace',1);
158/*!40000 ALTER TABLE `Salle` ENABLE KEYS */;
159UNLOCK TABLES;
160
161--
162-- Table structure for table `School`
163--
164
165DROP TABLE IF EXISTS `School`;
166/*!40101 SET @saved_cs_client = @@character_set_client */;
167/*!40101 SET character_set_client = utf8 */;
168CREATE TABLE `School` (
169 `ID` int(11) NOT NULL,
170 `Name` varchar(45) DEFAULT NULL,
171 PRIMARY KEY (`ID`)
172) ENGINE=InnoDB DEFAULT CHARSET=utf8;
173/*!40101 SET character_set_client = @saved_cs_client */;
174
175--
176-- Dumping data for table `School`
177--
178
179LOCK TABLES `School` WRITE;
180/*!40000 ALTER TABLE `School` DISABLE KEYS */;
181INSERT INTO `School` VALUES (1,'Orleans');
182/*!40000 ALTER TABLE `School` ENABLE KEYS */;
183UNLOCK TABLES;
184/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
185
186/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
187/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
188/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
189/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
190/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
191/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
192/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
193
194-- Dump completed on 2018-03-15 14:13:30