uCS5ddc0

1-- MySQL dump 10.13  Distrib 5.7.24, for Linux (x86_64)
2--
3-- Host: localhost    Database: richard_f_wcs_toulouse
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: `richard_f_wcs_toulouse`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `richard_f_wcs_toulouse` /*!40100 DEFAULT CHARACTER SET latin1 */;
23
24USE `richard_f_wcs_toulouse`;
25
26--
27-- Table structure for table `eleve`
28--
29
30DROP TABLE IF EXISTS `eleve`;
31/*!40101 SET @saved_cs_client     = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `eleve` (
34  `ideleve` int(11) NOT NULL,
35  `nom` varchar(45) DEFAULT NULL,
36  `prenom` varchar(45) DEFAULT NULL,
37  `ecole` varchar(45) DEFAULT NULL,
38  `langage` varchar(45) DEFAULT NULL,
39  PRIMARY KEY (`ideleve`)
40) ENGINE=InnoDB DEFAULT CHARSET=latin1;
41/*!40101 SET character_set_client = @saved_cs_client */;
42
43--
44-- Dumping data for table `eleve`
45--
46
47LOCK TABLES `eleve` WRITE;
48/*!40000 ALTER TABLE `eleve` DISABLE KEYS */;
49INSERT INTO `eleve` VALUES (0,'Laurie','Laurie','1','1'),(1,'Google','Google','2','1'),(2,'Jean','Michel','2','2'),(3,'Jeannine','Marieux','1','3'),(4,'Frigide','Barjot','3','3');
50/*!40000 ALTER TABLE `eleve` ENABLE KEYS */;
51UNLOCK TABLES;
52
53--
54-- Table structure for table `langage`
55--
56
57DROP TABLE IF EXISTS `langage`;
58/*!40101 SET @saved_cs_client     = @@character_set_client */;
59/*!40101 SET character_set_client = utf8 */;
60CREATE TABLE `langage` (
61  `idlangage` int(11) NOT NULL,
62  `nameLangage` varchar(45) DEFAULT NULL,
63  PRIMARY KEY (`idlangage`)
64) ENGINE=InnoDB DEFAULT CHARSET=latin1;
65/*!40101 SET character_set_client = @saved_cs_client */;
66
67--
68-- Dumping data for table `langage`
69--
70
71LOCK TABLES `langage` WRITE;
72/*!40000 ALTER TABLE `langage` DISABLE KEYS */;
73INSERT INTO `langage` VALUES (1,'PHP'),(2,'JavaScript'),(3,'Java');
74/*!40000 ALTER TABLE `langage` ENABLE KEYS */;
75UNLOCK TABLES;
76
77--
78-- Table structure for table `ville`
79--
80
81DROP TABLE IF EXISTS `ville`;
82/*!40101 SET @saved_cs_client     = @@character_set_client */;
83/*!40101 SET character_set_client = utf8 */;
84CREATE TABLE `ville` (
85  `idville` int(11) NOT NULL,
86  `nameville` varchar(45) DEFAULT NULL,
87  PRIMARY KEY (`idville`)
88) ENGINE=InnoDB DEFAULT CHARSET=latin1;
89/*!40101 SET character_set_client = @saved_cs_client */;
90
91--
92-- Dumping data for table `ville`
93--
94
95LOCK TABLES `ville` WRITE;
96/*!40000 ALTER TABLE `ville` DISABLE KEYS */;
97INSERT INTO `ville` VALUES (1,'Toulouse'),(2,'Bordeaux'),(3,'Paris'),(4,'Tours'),(5,'Portugal');
98/*!40000 ALTER TABLE `ville` ENABLE KEYS */;
99UNLOCK TABLES;
100/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
101
102/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
103/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
104/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
105/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
106/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
107/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
108/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
109
110-- Dump completed on 2018-12-11 15:12:24