CfBpvsMR

1-- MySQL dump 10.16  Distrib 10.1.28-MariaDB, for Linux (x86_64)
2--
3-- Host: localhost    Database: gestionecole
4-- ------------------------------------------------------
5-- Server version	10.1.28-MariaDB
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-- Table structure for table `classe`
20--
21
22DROP TABLE IF EXISTS `classe`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `classe` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `anneePromotion` int(11) NOT NULL,
28  `nom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
29  PRIMARY KEY (`id`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
31/*!40101 SET character_set_client = @saved_cs_client */;
32
33--
34-- Dumping data for table `classe`
35--
36
37LOCK TABLES `classe` WRITE;
38/*!40000 ALTER TABLE `classe` DISABLE KEYS */;
39/*!40000 ALTER TABLE `classe` ENABLE KEYS */;
40UNLOCK TABLES;
41
42--
43-- Table structure for table `classe_matiere`
44--
45
46DROP TABLE IF EXISTS `classe_matiere`;
47/*!40101 SET @saved_cs_client     = @@character_set_client */;
48/*!40101 SET character_set_client = utf8 */;
49CREATE TABLE `classe_matiere` (
50  `Classe_id` int(11) NOT NULL,
51  `matieres_id` int(11) NOT NULL,
52  KEY `FK8h7x8yu3iqc97yyls3udfg592` (`matieres_id`),
53  KEY `FK2n82xe6e2cj1iycrlcd4swtgt` (`Classe_id`),
54  CONSTRAINT `FK2n82xe6e2cj1iycrlcd4swtgt` FOREIGN KEY (`Classe_id`) REFERENCES `classe` (`id`),
55  CONSTRAINT `FK8h7x8yu3iqc97yyls3udfg592` FOREIGN KEY (`matieres_id`) REFERENCES `matiere` (`id`)
56) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
57/*!40101 SET character_set_client = @saved_cs_client */;
58
59--
60-- Dumping data for table `classe_matiere`
61--
62
63LOCK TABLES `classe_matiere` WRITE;
64/*!40000 ALTER TABLE `classe_matiere` DISABLE KEYS */;
65/*!40000 ALTER TABLE `classe_matiere` ENABLE KEYS */;
66UNLOCK TABLES;
67
68--
69-- Table structure for table `eleve`
70--
71
72DROP TABLE IF EXISTS `eleve`;
73/*!40101 SET @saved_cs_client     = @@character_set_client */;
74/*!40101 SET character_set_client = utf8 */;
75CREATE TABLE `eleve` (
76  `id` int(11) NOT NULL AUTO_INCREMENT,
77  `allergies` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
78  `dateInscription` datetime DEFAULT NULL,
79  `etablissementPrecedent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
80  `code_postal` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
81  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
82  `nom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
83  `nom_rue` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
84  `numero_rue` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
85  `prenom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
86  `sexe` char(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
87  `telephone_domicile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
88  `telephone_portable` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
89  `ville` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
90  `medecinTraitant` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
91  `remarquesMedicales` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
92  `telephoneMedecinTraitant` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
93  `classe_id` int(11) NOT NULL,
94  PRIMARY KEY (`id`),
95  KEY `FK8nrji46bsbcoohx749w9j78yx` (`classe_id`),
96  CONSTRAINT `FK8nrji46bsbcoohx749w9j78yx` FOREIGN KEY (`classe_id`) REFERENCES `classe` (`id`)
97) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
98/*!40101 SET character_set_client = @saved_cs_client */;
99
100--
101-- Dumping data for table `eleve`
102--
103
104LOCK TABLES `eleve` WRITE;
105/*!40000 ALTER TABLE `eleve` DISABLE KEYS */;
106/*!40000 ALTER TABLE `eleve` ENABLE KEYS */;
107UNLOCK TABLES;
108
109--
110-- Table structure for table `evaluation`
111--
112
113DROP TABLE IF EXISTS `evaluation`;
114/*!40101 SET @saved_cs_client     = @@character_set_client */;
115/*!40101 SET character_set_client = utf8 */;
116CREATE TABLE `evaluation` (
117  `id` int(11) NOT NULL AUTO_INCREMENT,
118  `note` float NOT NULL,
119  `eleve_id` int(11) NOT NULL,
120  `matiere_id` int(11) NOT NULL,
121  PRIMARY KEY (`id`),
122  KEY `FKr84sr1wl8siktoprkut6oitn8` (`eleve_id`),
123  KEY `FKr0i9fijfxr3pubdv8kfg7i07h` (`matiere_id`),
124  CONSTRAINT `FKr0i9fijfxr3pubdv8kfg7i07h` FOREIGN KEY (`matiere_id`) REFERENCES `matiere` (`id`),
125  CONSTRAINT `FKr84sr1wl8siktoprkut6oitn8` FOREIGN KEY (`eleve_id`) REFERENCES `eleve` (`id`)
126) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
127/*!40101 SET character_set_client = @saved_cs_client */;
128
129--
130-- Dumping data for table `evaluation`
131--
132
133LOCK TABLES `evaluation` WRITE;
134/*!40000 ALTER TABLE `evaluation` DISABLE KEYS */;
135/*!40000 ALTER TABLE `evaluation` ENABLE KEYS */;
136UNLOCK TABLES;
137
138--
139-- Table structure for table `matiere`
140--
141
142DROP TABLE IF EXISTS `matiere`;
143/*!40101 SET @saved_cs_client     = @@character_set_client */;
144/*!40101 SET character_set_client = utf8 */;
145CREATE TABLE `matiere` (
146  `id` int(11) NOT NULL AUTO_INCREMENT,
147  `nom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
148  PRIMARY KEY (`id`)
149) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
150/*!40101 SET character_set_client = @saved_cs_client */;
151
152--
153-- Dumping data for table `matiere`
154--
155
156LOCK TABLES `matiere` WRITE;
157/*!40000 ALTER TABLE `matiere` DISABLE KEYS */;
158/*!40000 ALTER TABLE `matiere` ENABLE KEYS */;
159UNLOCK TABLES;
160
161--
162-- Table structure for table `responsable`
163--
164
165DROP TABLE IF EXISTS `responsable`;
166/*!40101 SET @saved_cs_client     = @@character_set_client */;
167/*!40101 SET character_set_client = utf8 */;
168CREATE TABLE `responsable` (
169  `id` int(11) NOT NULL AUTO_INCREMENT,
170  `code_postal` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
171  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
172  `nom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
173  `nom_rue` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
174  `numero_rue` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
175  `prenom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
176  `sexe` char(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
177  `telephone_domicile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
178  `telephone_portable` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
179  `ville` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
180  `eleve_id` int(11) NOT NULL,
181  PRIMARY KEY (`id`),
182  KEY `FK8foq6a53bm3uuxvlejphi3w42` (`eleve_id`),
183  CONSTRAINT `FK8foq6a53bm3uuxvlejphi3w42` FOREIGN KEY (`eleve_id`) REFERENCES `eleve` (`id`)
184) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
185/*!40101 SET character_set_client = @saved_cs_client */;
186
187--
188-- Dumping data for table `responsable`
189--
190
191LOCK TABLES `responsable` WRITE;
192/*!40000 ALTER TABLE `responsable` DISABLE KEYS */;
193/*!40000 ALTER TABLE `responsable` ENABLE KEYS */;
194UNLOCK TABLES;
195/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
196
197/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
198/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
199/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
200/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
201/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
202/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
203/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
204
205-- Dump completed on 2017-11-26 21:27:11