pR8ykV4Q

1CREATE DATABASE  IF NOT EXISTS `jovanela_d_wcs_orleans` /*!40100 DEFAULT CHARACTER SET latin1 */;
2USE `jovanela_d_wcs_orleans`;
3-- MySQL dump 10.13  Distrib 5.7.23, for Linux (x86_64)
4--
5-- Host: localhost    Database: jovanela_d_wcs_orleans
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 `eleve`
22--
23
24DROP TABLE IF EXISTS `eleve`;
25/*!40101 SET @saved_cs_client     = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `eleve` (
28  `ideleve` int(11) NOT NULL AUTO_INCREMENT,
29  `Nom` varchar(45) NOT NULL,
30  `Prénom` varchar(45) NOT NULL,
31  `Adresse` varchar(255) NOT NULL,
32  `school_idschool` int(11) NOT NULL,
33  `langage_idlangage` int(11) NOT NULL,
34  PRIMARY KEY (`ideleve`),
35  KEY `fk_eleve_school_idx` (`school_idschool`),
36  KEY `fk_eleve_langage1_idx` (`langage_idlangage`),
37  CONSTRAINT `fk_eleve_langage1` FOREIGN KEY (`langage_idlangage`) REFERENCES `langage` (`idlangage`) ON DELETE NO ACTION ON UPDATE NO ACTION,
38  CONSTRAINT `fk_eleve_school` FOREIGN KEY (`school_idschool`) REFERENCES `school` (`idschool`) ON DELETE NO ACTION ON UPDATE NO ACTION
39) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
40/*!40101 SET character_set_client = @saved_cs_client */;
41
42--
43-- Dumping data for table `eleve`
44--
45
46LOCK TABLES `eleve` WRITE;
47/*!40000 ALTER TABLE `eleve` DISABLE KEYS */;
48INSERT INTO `eleve` VALUES (1,'Bestfriend','Google','Univers',1,1),(10,'Pester','Laurie','Paris',2,1),(11,'Network','Clarence','Saran',2,6),(12,'Legrand','Sumo','Orléans',1,5),(13,'Carré','Jeff','Lasource',1,6);
49/*!40000 ALTER TABLE `eleve` ENABLE KEYS */;
50UNLOCK TABLES;
51
52--
53-- Table structure for table `langage`
54--
55
56DROP TABLE IF EXISTS `langage`;
57/*!40101 SET @saved_cs_client     = @@character_set_client */;
58/*!40101 SET character_set_client = utf8 */;
59CREATE TABLE `langage` (
60  `idlangage` int(11) NOT NULL AUTO_INCREMENT,
61  `Nom` varchar(45) NOT NULL,
62  PRIMARY KEY (`idlangage`)
63) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
64/*!40101 SET character_set_client = @saved_cs_client */;
65
66--
67-- Dumping data for table `langage`
68--
69
70LOCK TABLES `langage` WRITE;
71/*!40000 ALTER TABLE `langage` DISABLE KEYS */;
72INSERT INTO `langage` VALUES (1,'PHP'),(5,'JavaScript'),(6,'Java');
73/*!40000 ALTER TABLE `langage` ENABLE KEYS */;
74UNLOCK TABLES;
75
76--
77-- Table structure for table `school`
78--
79
80DROP TABLE IF EXISTS `school`;
81/*!40101 SET @saved_cs_client     = @@character_set_client */;
82/*!40101 SET character_set_client = utf8 */;
83CREATE TABLE `school` (
84  `idschool` int(11) NOT NULL AUTO_INCREMENT,
85  `Ville` varchar(45) NOT NULL,
86  PRIMARY KEY (`idschool`)
87) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
88/*!40101 SET character_set_client = @saved_cs_client */;
89
90--
91-- Dumping data for table `school`
92--
93
94LOCK TABLES `school` WRITE;
95/*!40000 ALTER TABLE `school` DISABLE KEYS */;
96INSERT INTO `school` VALUES (1,'Orléans'),(2,'Lyon');
97/*!40000 ALTER TABLE `school` 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-10-01 20:02:13