· 7 years ago · Nov 29, 2018, 08:36 PM
1-- MySQL dump 10.13 Distrib 5.7.24, for Linux (x86_64)
2--
3-- Host: localhost Database: florent_l_wcs_bordeaux
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/-- MySQL dump 10.13 Distrib 5.7.24, for Linux (x86_64)
13--
14-- Host: localhost Database: florent_l_wcs_bordeaux
15-- ------------------------------------------------------
16-- Server version 5.7.24-0ubuntu0.18.04.1
17
18/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
19/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
20/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
21/*!40101 SET NAMES utf8 */;
22/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
23/*!40103 SET TIME_ZONE='+00:00' */;
24/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
25/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
26/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
27/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
28
29--
30-- Current Database: `florent_l_wcs_bordeaux`
31--
32
33CREATE DATABASE /*!32312 IF NOT EXISTS*/ `florent_l_wcs_bordeaux` /*!40100 DEFAULT CHARACTER SET latin1 */;
34
35USE `florent_l_wcs_bordeaux`;
36
37--
38-- Table structure for table `ecole`
39--
40
41DROP TABLE IF EXISTS `ecole`;
42/*!40101 SET @saved_cs_client = @@character_set_client */;
43/*!40101 SET character_set_client = utf8 */;
44CREATE TABLE `ecole` (
45 `id_ecole` int(11) NOT NULL AUTO_INCREMENT,
46 `ville` varchar(100) DEFAULT NULL,
47 PRIMARY KEY (`id_ecole`)
48) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
49/*!40101 SET character_set_client = @saved_cs_client */;
50
51--
52-- Dumping data for table `ecole`
53--
54
55LOCK TABLES `ecole` WRITE;
56/*!40000 ALTER TABLE `ecole` DISABLE KEYS */;
57INSERT INTO `ecole` VALUES (1,'Bordeaux'),(2,'Paris');
58/*!40000 ALTER TABLE `ecole` ENABLE KEYS */;
59UNLOCK TABLES;
60
61--
62-- Table structure for table `eleve`
63--
64
65DROP TABLE IF EXISTS `eleve`;
66/*!40101 SET @saved_cs_client = @@character_set_client */;
67/*!40101 SET character_set_client = utf8 */;
68CREATE TABLE `eleve` (
69 `id` int(11) NOT NULL AUTO_INCREMENT,
70 `nom` varchar(100) DEFAULT NULL,
71 `prenom` varchar(100) DEFAULT NULL,
72 `adresse` varchar(500) DEFAULT NULL,
73 `id_langage` int(11) NOT NULL DEFAULT '1',
74 `id_ecole` int(11) NOT NULL DEFAULT '1',
75 PRIMARY KEY (`id`),
76 KEY `id_langage` (`id_langage`),
77 KEY `id_ecole` (`id_ecole`),
78 CONSTRAINT `eleve_ibfk_1` FOREIGN KEY (`id_langage`) REFERENCES `langage` (`id_langage`),
79 CONSTRAINT `eleve_ibfk_2` FOREIGN KEY (`id_ecole`) REFERENCES `ecole` (`id_ecole`)
80) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
81/*!40101 SET character_set_client = @saved_cs_client */;
82
83--
84-- Dumping data for table `eleve`
85--
86
87LOCK TABLES `eleve` WRITE;
88/*!40000 ALTER TABLE `eleve` DISABLE KEYS */;
89INSERT INTO `eleve` VALUES (3,'Heaulme','Francis','Prison de la santé',1,1),(4,'Georges','Guy','Prison de Fresnes',1,1),(5,'Fourniret','Michel','prison des baumettes',2,1),(6,'Google','','L\'internet du futur',3,2),(7,'Gami','Laurie','Sur la planète des stars',3,2);
90/*!40000 ALTER TABLE `eleve` ENABLE KEYS */;
91UNLOCK TABLES;
92
93--
94-- Table structure for table `langage`
95--
96
97DROP TABLE IF EXISTS `langage`;
98/*!40101 SET @saved_cs_client = @@character_set_client */;
99/*!40101 SET character_set_client = utf8 */;
100CREATE TABLE `langage` (
101 `id_langage` int(11) NOT NULL AUTO_INCREMENT,
102 `nom` varchar(100) DEFAULT NULL,
103 PRIMARY KEY (`id_langage`)
104) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
105/*!40101 SET character_set_client = @saved_cs_client */;
106
107--
108-- Dumping data for table `langage`
109--
110
111LOCK TABLES `langage` WRITE;
112/*!40000 ALTER TABLE `langage` DISABLE KEYS */;
113INSERT INTO `langage` VALUES (1,'PHP'),(2,'Javasript'),(3,'Java');
114/*!40000 ALTER TABLE `langage` ENABLE KEYS */;
115UNLOCK TABLES;
116/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
117
118/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
119/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
120/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
121/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
122/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
123/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
124/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
125
126-- Dump completed on 2018-11-29 16:51:05
127*!40103 SET TIME_ZONE='+00:00' */;
128/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
129/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
130/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
131/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
132
133--
134-- Current Database: `florent_l_wcs_bordeaux`
135--
136
137CREATE DATABASE /*!32312 IF NOT EXISTS*/ `florent_l_wcs_bordeaux` /*!40100 DEFAULT CHARACTER SET latin1 */;
138
139USE `florent_l_wcs_bordeaux`;
140
141--
142-- Table structure for table `ecole`
143--
144
145DROP TABLE IF EXISTS `ecole`;
146/*!40101 SET @saved_cs_client = @@character_set_client */;
147/*!40101 SET character_set_client = utf8 */;
148CREATE TABLE `ecole` (
149 `id_ecole` int(11) NOT NULL AUTO_INCREMENT,
150 `ville` varchar(100) DEFAULT NULL,
151 PRIMARY KEY (`id_ecole`)
152) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
153/*!40101 SET character_set_client = @saved_cs_client */;
154
155--
156-- Dumping data for table `ecole`
157--
158
159LOCK TABLES `ecole` WRITE;
160/*!40000 ALTER TABLE `ecole` DISABLE KEYS */;
161INSERT INTO `ecole` VALUES (1,'Bordeaux'),(2,'Paris');
162/*!40000 ALTER TABLE `ecole` ENABLE KEYS */;
163UNLOCK TABLES;
164
165--
166-- Table structure for table `eleve`
167--
168
169DROP TABLE IF EXISTS `eleve`;
170/*!40101 SET @saved_cs_client = @@character_set_client */;
171/*!40101 SET character_set_client = utf8 */;
172CREATE TABLE `eleve` (
173 `id` int(11) NOT NULL AUTO_INCREMENT,
174 `nom` varchar(100) DEFAULT NULL,
175 `prenom` varchar(100) DEFAULT NULL,
176 `adresse` varchar(500) DEFAULT NULL,
177 `id_langage` int(11) NOT NULL DEFAULT '1',
178 `id_ecole` int(11) NOT NULL DEFAULT '1',
179 PRIMARY KEY (`id`),
180 KEY `id_langage` (`id_langage`),
181 KEY `id_ecole` (`id_ecole`),
182 CONSTRAINT `eleve_ibfk_1` FOREIGN KEY (`id_langage`) REFERENCES `langage` (`id_langage`),
183 CONSTRAINT `eleve_ibfk_2` FOREIGN KEY (`id_ecole`) REFERENCES `ecole` (`id_ecole`)
184) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
185/*!40101 SET character_set_client = @saved_cs_client */;
186
187--
188-- Dumping data for table `eleve`
189--
190
191LOCK TABLES `eleve` WRITE;
192/*!40000 ALTER TABLE `eleve` DISABLE KEYS */;
193INSERT INTO `eleve` VALUES (3,'Heaulme','Francis','Prison de la santé',1,1),(4,'Georges','Guy','Prison de Fresnes',1,1),(5,'Fourniret','Michel','prison des baumettes',2,1),(6,'Google','','L\'internet du futur',3,2),(7,'Gami','Laurie','Sur la planète des stars',3,2);
194/*!40000 ALTER TABLE `eleve` ENABLE KEYS */;
195UNLOCK TABLES;
196
197--
198-- Table structure for table `langage`
199--
200
201DROP TABLE IF EXISTS `langage`;
202/*!40101 SET @saved_cs_client = @@character_set_client */;
203/*!40101 SET character_set_client = utf8 */;
204CREATE TABLE `langage` (
205 `id_langage` int(11) NOT NULL AUTO_INCREMENT,
206 `nom` varchar(100) DEFAULT NULL,
207 PRIMARY KEY (`id_langage`)
208) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
209/*!40101 SET character_set_client = @saved_cs_client */;
210
211--
212-- Dumping data for table `langage`
213--
214
215LOCK TABLES `langage` WRITE;
216/*!40000 ALTER TABLE `langage` DISABLE KEYS */;
217INSERT INTO `langage` VALUES (1,'PHP'),(2,'Javasript'),(3,'Java');
218/*!40000 ALTER TABLE `langage` ENABLE KEYS */;
219UNLOCK TABLES;
220/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
221
222/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
223/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
224/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
225/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
226/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
227/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
228/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
229
230-- Dump completed on 2018-11-29 16:51:05