dhTc7xAP

1-- MySQL dump 10.13  Distrib 5.7.23, for Linux (x86_64)
2--
3-- Host: localhost    Database: wild_promo_strasbourg
4-- ------------------------------------------------------
5-- Server version	5.7.23-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: `wild_promo_strasbourg`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `wild_promo_strasbourg` /*!40100 DEFAULT CHARACTER SET latin1 */;
23
24USE `wild_promo_strasbourg`;
25
26--
27-- Table structure for table `Eleves`
28--
29
30DROP TABLE IF EXISTS `Eleves`;
31/*!40101 SET @saved_cs_client     = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `Eleves` (
34  `id` int(11) NOT NULL AUTO_INCREMENT,
35  `Nom` varchar(60) DEFAULT NULL,
36  `Prenom` varchar(60) DEFAULT NULL,
37  `Adresse` text,
38  `fk_ville` int(11) DEFAULT NULL,
39  `fk_language` int(11) DEFAULT NULL,
40  PRIMARY KEY (`id`),
41  KEY `fk_language` (`fk_language`),
42  KEY `fk_ville` (`fk_ville`),
43  CONSTRAINT `Eleves_ibfk_1` FOREIGN KEY (`fk_language`) REFERENCES `language` (`id`),
44  CONSTRAINT `Eleves_ibfk_2` FOREIGN KEY (`fk_ville`) REFERENCES `ville` (`id`)
45) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
46/*!40101 SET character_set_client = @saved_cs_client */;
47
48--
49-- Dumping data for table `Eleves`
50--
51
52LOCK TABLES `Eleves` WRITE;
53/*!40000 ALTER TABLE `Eleves` DISABLE KEYS */;
54INSERT INTO `Eleves` VALUES (1,'Boutigny','Sébastien','Lichtenberg',1,1),(2,'Bournac','Damien','Strasbourg',1,1),(3,'Walch','Etienne','Mulhouse',2,3),(4,'Daniel','Jules','Strasbourg',3,3),(5,'Google','Google','USA',2,NULL),(6,'MonAmie','Lorie','Jesaispas',3,2);
55/*!40000 ALTER TABLE `Eleves` ENABLE KEYS */;
56UNLOCK TABLES;
57
58--
59-- Table structure for table `language`
60--
61
62DROP TABLE IF EXISTS `language`;
63/*!40101 SET @saved_cs_client     = @@character_set_client */;
64/*!40101 SET character_set_client = utf8 */;
65CREATE TABLE `language` (
66  `id` int(11) NOT NULL AUTO_INCREMENT,
67  `code` varchar(50) DEFAULT NULL,
68  PRIMARY KEY (`id`),
69  CONSTRAINT `language_ibfk_1` FOREIGN KEY (`id`) REFERENCES `Eleves` (`id`),
70  CONSTRAINT `language_ibfk_2` FOREIGN KEY (`id`) REFERENCES `ville` (`id`)
71) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
72/*!40101 SET character_set_client = @saved_cs_client */;
73
74--
75-- Dumping data for table `language`
76--
77
78LOCK TABLES `language` WRITE;
79/*!40000 ALTER TABLE `language` DISABLE KEYS */;
80INSERT INTO `language` VALUES (1,'php'),(2,'javascript'),(3,'java');
81/*!40000 ALTER TABLE `language` ENABLE KEYS */;
82UNLOCK TABLES;
83
84--
85-- Table structure for table `ville`
86--
87
88DROP TABLE IF EXISTS `ville`;
89/*!40101 SET @saved_cs_client     = @@character_set_client */;
90/*!40101 SET character_set_client = utf8 */;
91CREATE TABLE `ville` (
92  `id` int(11) NOT NULL AUTO_INCREMENT,
93  `ville` varchar(100) DEFAULT NULL,
94  PRIMARY KEY (`id`),
95  CONSTRAINT `ville_ibfk_1` FOREIGN KEY (`id`) REFERENCES `language` (`id`),
96  CONSTRAINT `ville_idfk_2` FOREIGN KEY (`id`) REFERENCES `Eleves` (`id`)
97) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
98/*!40101 SET character_set_client = @saved_cs_client */;
99
100--
101-- Dumping data for table `ville`
102--
103
104LOCK TABLES `ville` WRITE;
105/*!40000 ALTER TABLE `ville` DISABLE KEYS */;
106INSERT INTO `ville` VALUES (1,'Strasbourg'),(2,'Reims'),(3,'Laloupe');
107/*!40000 ALTER TABLE `ville` ENABLE KEYS */;
108UNLOCK TABLES;
109/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
110
111/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
112/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
113/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
114/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
115/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
116/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
117/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
118
119-- Dump completed on 2018-10-02 10:58:48