9h5TV56R

1CREATE DATABASE  IF NOT EXISTS `wild_code_school` /*!40100 DEFAULT CHARACTER SET utf8 */;
2USE `wild_code_school`;
3-- MySQL dump 10.13  Distrib 5.7.23, for Linux (x86_64)
4--
5-- Host: localhost    Database: wild_code_school
6-- ------------------------------------------------------
7-- Server version	5.7.23-0ubuntu0.18.04.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 `ecole`
22--
23
24DROP TABLE IF EXISTS `ecole`;
25/*!40101 SET @saved_cs_client     = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `ecole` (
28  `idecole` int(11) NOT NULL AUTO_INCREMENT,
29  `ville` varchar(45) DEFAULT NULL,
30  PRIMARY KEY (`idecole`)
31) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Dumping data for table `ecole`
36--
37
38LOCK TABLES `ecole` WRITE;
39/*!40000 ALTER TABLE `ecole` DISABLE KEYS */;
40INSERT INTO `ecole` VALUES (1,'orleans'),(2,'tours'),(3,'angers'),(4,'paris');
41/*!40000 ALTER TABLE `ecole` ENABLE KEYS */;
42UNLOCK TABLES;
43
44--
45-- Table structure for table `eleve`
46--
47
48DROP TABLE IF EXISTS `eleve`;
49/*!40101 SET @saved_cs_client     = @@character_set_client */;
50/*!40101 SET character_set_client = utf8 */;
51CREATE TABLE `eleve` (
52  `ideleve` int(11) NOT NULL AUTO_INCREMENT,
53  `nom` varchar(250) DEFAULT NULL,
54  `prenom` varchar(250) DEFAULT NULL,
55  `adresse` varchar(250) DEFAULT NULL,
56  `langage_idlangage` int(11) NOT NULL,
57  `ecole_idecole` int(11) NOT NULL,
58  PRIMARY KEY (`ideleve`,`langage_idlangage`,`ecole_idecole`),
59  KEY `fk_eleve_langage_idx` (`langage_idlangage`),
60  KEY `fk_eleve_ecole1_idx` (`ecole_idecole`),
61  CONSTRAINT `fk_eleve_ecole1` FOREIGN KEY (`ecole_idecole`) REFERENCES `ecole` (`idecole`) ON DELETE NO ACTION ON UPDATE NO ACTION,
62  CONSTRAINT `fk_eleve_langage` FOREIGN KEY (`langage_idlangage`) REFERENCES `langage` (`idlangage`) ON DELETE NO ACTION ON UPDATE NO ACTION
63) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
64/*!40101 SET character_set_client = @saved_cs_client */;
65
66--
67-- Dumping data for table `eleve`
68--
69
70LOCK TABLES `eleve` WRITE;
71/*!40000 ALTER TABLE `eleve` DISABLE KEYS */;
72INSERT INTO `eleve` VALUES (1,'lorie','lorie','paris',1,1),(2,'iron','man','paris',1,2),(3,'goo','gle','paris',3,3),(4,'meli','ssa','paris',2,4),(5,'diana','prince','paris',2,4);
73/*!40000 ALTER TABLE `eleve` ENABLE KEYS */;
74UNLOCK TABLES;
75
76--
77-- Table structure for table `langage`
78--
79
80DROP TABLE IF EXISTS `langage`;
81/*!40101 SET @saved_cs_client     = @@character_set_client */;
82/*!40101 SET character_set_client = utf8 */;
83CREATE TABLE `langage` (
84  `idlangage` int(11) NOT NULL AUTO_INCREMENT,
85  `nom_langage` varchar(45) DEFAULT NULL,
86  PRIMARY KEY (`idlangage`)
87) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
88/*!40101 SET character_set_client = @saved_cs_client */;
89
90--
91-- Dumping data for table `langage`
92--
93
94LOCK TABLES `langage` WRITE;
95/*!40000 ALTER TABLE `langage` DISABLE KEYS */;
96INSERT INTO `langage` VALUES (1,'PHP'),(2,'java'),(3,'JavaScript');
97/*!40000 ALTER TABLE `langage` ENABLE KEYS */;
98UNLOCK TABLES;
99/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
100
101/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
102/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
103/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
104/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
105/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
106/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
107/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
108
109-- Dump completed on 2018-09-26 13:22:25