ALHQdpHA

1CREATE DATABASE  IF NOT EXISTS `guillaume_g_wcs` /*!40100 DEFAULT CHARACTER SET latin1 */;
2USE `guillaume_g_wcs`;
3-- MySQL dump 10.13  Distrib 5.7.23, for Linux (x86_64)
4--
5-- Host: localhost    Database: guillaume_g_wcs
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  `id` int(11) NOT NULL AUTO_INCREMENT,
29  `ville` varchar(45) DEFAULT NULL,
30  PRIMARY KEY (`id`)
31) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
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,'Orléans'),(2,'Tours'),(3,'La loupe');
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  `id` int(11) NOT NULL AUTO_INCREMENT,
53  `nom` varchar(45) DEFAULT NULL,
54  `prenom` varchar(45) DEFAULT NULL,
55  `adresse` varchar(45) DEFAULT NULL,
56  `Ecole` int(11) DEFAULT NULL,
57  `langage` int(11) DEFAULT NULL,
58  PRIMARY KEY (`id`),
59  KEY `fk_Ecole_idx` (`Ecole`),
60  KEY `fk_Langage_idx` (`langage`),
61  CONSTRAINT `fk_Ecole` FOREIGN KEY (`Ecole`) REFERENCES `Ecole` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
62  CONSTRAINT `fk_Langage` FOREIGN KEY (`langage`) REFERENCES `langage` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
63) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
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,'No-name','laurie','disparue',1,1),(2,'gle','goo','everywhere',2,2),(3,'cartman','eric','southpark',3,3),(4,'strife','cloud','nibelheim',1,1),(5,'mouse','mickey','disneyland',3,3);
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  `id` int(11) NOT NULL AUTO_INCREMENT,
85  `langage` varchar(45) DEFAULT NULL,
86  PRIMARY KEY (`id`)
87) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
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,'Javascript'),(3,'Java');
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-27  8:33:36