rAJXm6Wh

1-- MySQL dump 10.13  Distrib 5.7.24, for Linux (x86_64)
2--
3-- Host: localhost    Database: quete3
4-- ------------------------------------------------------
5-- Server version	5.7.24-0ubuntu0.18.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: `quete3`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `quete3` /*!40100 DEFAULT CHARACTER SET latin1 */;
23
24USE `quete3`;
25
26--
27-- Table structure for table `Ecole`
28--
29
30DROP TABLE IF EXISTS `Ecole`;
31/*!40101 SET @saved_cs_client     = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `Ecole` (
34  `id_ecole` int(100) NOT NULL AUTO_INCREMENT,
35  `ville_ecole` varchar(100) NOT NULL,
36  PRIMARY KEY (`id_ecole`)
37) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
38/*!40101 SET character_set_client = @saved_cs_client */;
39
40--
41-- Dumping data for table `Ecole`
42--
43
44LOCK TABLES `Ecole` WRITE;
45/*!40000 ALTER TABLE `Ecole` DISABLE KEYS */;
46INSERT INTO `Ecole` VALUES (1,'Tours'),(2,'Orleans');
47/*!40000 ALTER TABLE `Ecole` ENABLE KEYS */;
48UNLOCK TABLES;
49
50--
51-- Table structure for table `Langage`
52--
53
54DROP TABLE IF EXISTS `Langage`;
55/*!40101 SET @saved_cs_client     = @@character_set_client */;
56/*!40101 SET character_set_client = utf8 */;
57CREATE TABLE `Langage` (
58  `id_langage` int(100) NOT NULL AUTO_INCREMENT,
59  `nom_langage` varchar(100) NOT NULL,
60  PRIMARY KEY (`id_langage`)
61) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Dumping data for table `Langage`
66--
67
68LOCK TABLES `Langage` WRITE;
69/*!40000 ALTER TABLE `Langage` DISABLE KEYS */;
70INSERT INTO `Langage` VALUES (1,'PHP'),(2,'Javascript'),(3,'Java');
71/*!40000 ALTER TABLE `Langage` ENABLE KEYS */;
72UNLOCK TABLES;
73
74--
75-- Table structure for table `eleve`
76--
77
78DROP TABLE IF EXISTS `eleve`;
79/*!40101 SET @saved_cs_client     = @@character_set_client */;
80/*!40101 SET character_set_client = utf8 */;
81CREATE TABLE `eleve` (
82  `id_eleve` int(100) NOT NULL AUTO_INCREMENT,
83  `nom_eleve` varchar(100) NOT NULL,
84  `prenom_eleve` varchar(100) NOT NULL,
85  `adresse_eleve` varchar(100) NOT NULL,
86  `id_ecole` int(11) NOT NULL,
87  `id_langage` int(11) NOT NULL,
88  PRIMARY KEY (`id_eleve`),
89  UNIQUE KEY `id_eleve` (`id_eleve`)
90) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COMMENT='Eleve';
91/*!40101 SET character_set_client = @saved_cs_client */;
92
93--
94-- Dumping data for table `eleve`
95--
96
97LOCK TABLES `eleve` WRITE;
98/*!40000 ALTER TABLE `eleve` DISABLE KEYS */;
99INSERT INTO `eleve` VALUES (1,'Des étoiles','Jo','30 rue de Moncuq',2,1),(2,'Google','OO','Palo Alto',2,1),(3,'Blabliblou','Lorie','50 rue General De Gaulle',2,3),(4,'Roi','Arthur','Broceliande',2,3),(5,'Lab','Math','20 rue du champ Joli - 25730 Issy-lès-Moulinaux',1,2);
100/*!40000 ALTER TABLE `eleve` ENABLE KEYS */;
101UNLOCK TABLES;
102
103--
104-- Table structure for table `enseigne`
105--
106
107DROP TABLE IF EXISTS `enseigne`;
108/*!40101 SET @saved_cs_client     = @@character_set_client */;
109/*!40101 SET character_set_client = utf8 */;
110CREATE TABLE `enseigne` (
111  `id_ecole` int(11) NOT NULL,
112  `id_langage` int(11) NOT NULL,
113  UNIQUE KEY `id_langage` (`id_langage`)
114) ENGINE=InnoDB DEFAULT CHARSET=latin1;
115/*!40101 SET character_set_client = @saved_cs_client */;
116
117--
118-- Dumping data for table `enseigne`
119--
120
121LOCK TABLES `enseigne` WRITE;
122/*!40000 ALTER TABLE `enseigne` DISABLE KEYS */;
123INSERT INTO `enseigne` VALUES (1,1),(2,2),(2,3);
124/*!40000 ALTER TABLE `enseigne` ENABLE KEYS */;
125UNLOCK TABLES;
126/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
127
128/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
129/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
130/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
131/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
132/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
133/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
134/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
135
136-- Dump completed on 2018-11-22 17:52:57