eyzZMst5

1-- MySQL dump 10.13  Distrib 8.0.11, for Win64 (x86_64)
2--
3-- Host: localhost    Database: jeanfrancois_m_wcs_lyon
4-- ------------------------------------------------------
5-- Server version	8.0.11
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 SET NAMES utf8mb4 ;
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: `jeanfrancois_m_wcs_lyon`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `jeanfrancois_m_wcs_lyon` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
23
24USE `jeanfrancois_m_wcs_lyon`;
25
26--
27-- Table structure for table `langage`
28--
29
30DROP TABLE IF EXISTS `langage`;
31/*!40101 SET @saved_cs_client     = @@character_set_client */;
32 SET character_set_client = utf8mb4 ;
33CREATE TABLE `langage` (
34  `LangageID` int(11) NOT NULL,
35  `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
36  PRIMARY KEY (`LangageID`)
37) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
38/*!40101 SET character_set_client = @saved_cs_client */;
39
40--
41-- Dumping data for table `langage`
42--
43
44LOCK TABLES `langage` WRITE;
45/*!40000 ALTER TABLE `langage` DISABLE KEYS */;
46INSERT INTO `langage` VALUES (1,'PHP'),(2,'JavaScript'),(3,'Java');
47/*!40000 ALTER TABLE `langage` ENABLE KEYS */;
48UNLOCK TABLES;
49
50--
51-- Table structure for table `school`
52--
53
54DROP TABLE IF EXISTS `school`;
55/*!40101 SET @saved_cs_client     = @@character_set_client */;
56 SET character_set_client = utf8mb4 ;
57CREATE TABLE `school` (
58  `SchoolID` int(11) NOT NULL,
59  `City` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
60  PRIMARY KEY (`SchoolID`)
61) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Dumping data for table `school`
66--
67
68LOCK TABLES `school` WRITE;
69/*!40000 ALTER TABLE `school` DISABLE KEYS */;
70INSERT INTO `school` VALUES (1,'Bordeaux'),(2,'Bayonne'),(3,'Lyon');
71/*!40000 ALTER TABLE `school` ENABLE KEYS */;
72UNLOCK TABLES;
73
74--
75-- Table structure for table `student`
76--
77
78DROP TABLE IF EXISTS `student`;
79/*!40101 SET @saved_cs_client     = @@character_set_client */;
80 SET character_set_client = utf8mb4 ;
81CREATE TABLE `student` (
82  `last_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
83  `first_name` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
84  `age` int(3) DEFAULT NULL,
85  `location` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
86  `ID` int(11) NOT NULL AUTO_INCREMENT,
87  `LangageID` int(11) NOT NULL,
88  `SchoolID` int(11) NOT NULL,
89  PRIMARY KEY (`ID`),
90  KEY `LangageID` (`LangageID`),
91  KEY `SchoolID` (`SchoolID`),
92  CONSTRAINT `student_ibfk_1` FOREIGN KEY (`LangageID`) REFERENCES `langage` (`langageid`),
93  CONSTRAINT `student_ibfk_2` FOREIGN KEY (`SchoolID`) REFERENCES `school` (`schoolid`)
94) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
95/*!40101 SET character_set_client = @saved_cs_client */;
96
97--
98-- Dumping data for table `student`
99--
100
101LOCK TABLES `student` WRITE;
102/*!40000 ALTER TABLE `student` DISABLE KEYS */;
103INSERT INTO `student` VALUES ('CORDENOD','Julien',37,'Lyon',1,1,1),('COUEDELO','Stephane',30,'Nantes',2,1,1),('Google','Chrome',300,'Cloud',3,2,2),('LORIE','Beauty',28,'Disney',4,3,2),('MARION','Herve',47,'Lyon',6,3,3);
104/*!40000 ALTER TABLE `student` ENABLE KEYS */;
105UNLOCK TABLES;
106/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
107
108/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
109/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
110/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
111/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
112/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
113/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
114/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
115
116-- Dump completed on 2018-11-07 17:29:40