· 8 years ago · Apr 12, 2018, 09:32 AM
1-- MySQL dump 10.13 Distrib 5.7.21, for Linux (x86_64)
2--
3-- Host: localhost Database: Ecole
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: `Ecole`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `Ecole` /*!40100 DEFAULT CHARACTER SET latin1 */;
23
24USE `Ecole`;
25
26--
27-- Table structure for table `eleves`
28--
29
30DROP TABLE IF EXISTS `eleves`;
31/*!40101 SET @saved_cs_client = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `eleves` (
34 `student_nbr` int(11) NOT NULL AUTO_INCREMENT,
35 `nom` varchar(30) DEFAULT NULL,
36 `prenom` varchar(30) DEFAULT NULL,
37 `adresse` varchar(50) DEFAULT NULL,
38 PRIMARY KEY (`student_nbr`)
39) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
40/*!40101 SET character_set_client = @saved_cs_client */;
41
42--
43-- Dumping data for table `eleves`
44--
45
46LOCK TABLES `eleves` WRITE;
47/*!40000 ALTER TABLE `eleves` DISABLE KEYS */;
48INSERT INTO `eleves` VALUES (1,'Google','le genie','USA'),(2,'Laurie','la chanteuse','FRANCE'),(3,'Gilbert','l alcolique','PMU'),(4,'Maxence','Monsieur CSS','BRETAGNE'),(5,'Gregoire','fait du velo','LILLE'),(6,'Stephane','le colombien','COLOMBIE'),(7,'Alexandre','always blue','LILLE'),(8,'Michel','Druker','FRANCE 2'),(9,'Donald','TRUMP','USA'),(10,'Francois','la francais','FRANCE');
49/*!40000 ALTER TABLE `eleves` ENABLE KEYS */;
50UNLOCK TABLES;
51
52--
53-- Table structure for table `formateur`
54--
55
56DROP TABLE IF EXISTS `formateur`;
57/*!40101 SET @saved_cs_client = @@character_set_client */;
58/*!40101 SET character_set_client = utf8 */;
59CREATE TABLE `formateur` (
60 `form_nbr` int(11) NOT NULL AUTO_INCREMENT,
61 `nom` varchar(30) DEFAULT NULL,
62 `prenom` varchar(30) DEFAULT NULL,
63 `language` varchar(30) DEFAULT NULL,
64 PRIMARY KEY (`form_nbr`)
65) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
66/*!40101 SET character_set_client = @saved_cs_client */;
67
68--
69-- Dumping data for table `formateur`
70--
71
72LOCK TABLES `formateur` WRITE;
73/*!40000 ALTER TABLE `formateur` DISABLE KEYS */;
74INSERT INTO `formateur` VALUES (1,'Lucas','en pyjama','JS'),(2,'Gaetan','a lunette','PHP');
75/*!40000 ALTER TABLE `formateur` ENABLE KEYS */;
76UNLOCK TABLES;
77
78--
79-- Table structure for table `reservation`
80--
81
82DROP TABLE IF EXISTS `reservation`;
83/*!40101 SET @saved_cs_client = @@character_set_client */;
84/*!40101 SET character_set_client = utf8 */;
85CREATE TABLE `reservation` (
86 `order_nbr` int(11) NOT NULL AUTO_INCREMENT,
87 `date` date DEFAULT NULL,
88 `duree` int(11) NOT NULL,
89 `SalleID` int(11) NOT NULL,
90 `UserID` int(11) NOT NULL,
91 PRIMARY KEY (`order_nbr`),
92 KEY `fk_salle_id` (`SalleID`),
93 KEY `fk_user_id` (`UserID`),
94 CONSTRAINT `fk_salle_id` FOREIGN KEY (`SalleID`) REFERENCES `salle` (`room_id`),
95 CONSTRAINT `fk_user_id` FOREIGN KEY (`UserID`) REFERENCES `eleves` (`student_nbr`)
96) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
97/*!40101 SET character_set_client = @saved_cs_client */;
98
99--
100-- Dumping data for table `reservation`
101--
102
103LOCK TABLES `reservation` WRITE;
104/*!40000 ALTER TABLE `reservation` DISABLE KEYS */;
105INSERT INTO `reservation` VALUES (10,'2019-04-04',60,1,4),(13,'2008-04-04',120,1,2),(14,'2008-04-04',60,1,1),(15,'1999-04-04',60,6,5),(16,'1999-04-04',60,6,8),(17,'1999-04-04',120,4,3),(18,'1999-04-04',120,7,6),(19,'1999-04-04',120,7,7),(20,'1999-04-04',60,7,8),(21,'1999-04-04',90,7,9);
106/*!40000 ALTER TABLE `reservation` ENABLE KEYS */;
107UNLOCK TABLES;
108
109--
110-- Table structure for table `salle`
111--
112
113DROP TABLE IF EXISTS `salle`;
114/*!40101 SET @saved_cs_client = @@character_set_client */;
115/*!40101 SET character_set_client = utf8 */;
116CREATE TABLE `salle` (
117 `room_id` int(11) NOT NULL AUTO_INCREMENT,
118 `nom` varchar(50) DEFAULT NULL,
119 PRIMARY KEY (`room_id`)
120) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
121/*!40101 SET character_set_client = @saved_cs_client */;
122
123--
124-- Dumping data for table `salle`
125--
126
127LOCK TABLES `salle` WRITE;
128/*!40000 ALTER TABLE `salle` DISABLE KEYS */;
129INSERT INTO `salle` VALUES (1,'Salle de dojo'),(3,'Salle de reunion'),(4,'Salle de repos'),(5,'Cuisine'),(6,'Bureau'),(7,'OpenSpace');
130/*!40000 ALTER TABLE `salle` ENABLE KEYS */;
131UNLOCK TABLES;
132/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
133
134/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
135/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
136/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
137/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
138/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
139/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
140/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
141
142-- Dump completed on 2018-04-04 12:14:54