· 8 years ago · May 05, 2018, 02:48 PM
1-- MySQL dump 10.13 Distrib 5.7.22, for Linux (x86_64)
2--
3-- Host: localhost Database: brun
4-- ------------------------------------------------------
5-- Server version 5.7.22-0ubuntu0.16.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-- Table structure for table `Personne`
20--
21
22DROP TABLE IF EXISTS `Personne`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `Personne` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `numDossier` varchar(25) DEFAULT NULL,
28 `nom` varchar(25) DEFAULT NULL,
29 `prenom` varchar(25) DEFAULT NULL,
30 PRIMARY KEY (`id`)
31) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Dumping data for table `Personne`
36--
37
38LOCK TABLES `Personne` WRITE;
39/*!40000 ALTER TABLE `Personne` DISABLE KEYS */;
40INSERT INTO `Personne` VALUES (1,'1','Google','Facebook'),(2,'2','Laurie','Lo'),(3,'3','Sebastien','Po'),(4,'4','Gaelle','Gi'),(5,'5','Laurent','Pa'),(6,'6','Thomas','To'),(7,'7','Julien','Ji'),(8,'8','Stephen','Se'),(9,'9','Paul','Pi'),(10,'10','Sophie','So');
41/*!40000 ALTER TABLE `Personne` 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 `adresse` varchar(25) DEFAULT NULL,
54 `id_Personne` int(11) DEFAULT NULL,
55 PRIMARY KEY (`id`),
56 KEY `FK_Eleve_id_Personne` (`id_Personne`),
57 CONSTRAINT `FK_Eleve_id_Personne` FOREIGN KEY (`id_Personne`) REFERENCES `Personne` (`id`)
58) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
59/*!40101 SET character_set_client = @saved_cs_client */;
60
61--
62-- Dumping data for table `Eleve`
63--
64
65LOCK TABLES `Eleve` WRITE;
66/*!40000 ALTER TABLE `Eleve` DISABLE KEYS */;
67INSERT INTO `Eleve` VALUES (1,'1 rue Google',1),(2,'2 rue Laurie',2),(3,'3 rue Sebastien',3),(4,'4 rue Gaelle',4),(5,'5 rue Laurent',5);
68/*!40000 ALTER TABLE `Eleve` ENABLE KEYS */;
69UNLOCK TABLES;
70
71--
72-- Table structure for table `Formateur`
73--
74
75DROP TABLE IF EXISTS `Formateur`;
76/*!40101 SET @saved_cs_client = @@character_set_client */;
77/*!40101 SET character_set_client = utf8 */;
78CREATE TABLE `Formateur` (
79 `id` int(11) NOT NULL AUTO_INCREMENT,
80 `langage` varchar(25) DEFAULT NULL,
81 `id_Personne` int(11) DEFAULT NULL,
82 PRIMARY KEY (`id`),
83 KEY `FK_Formateur_id_Personne` (`id_Personne`),
84 CONSTRAINT `FK_Formateur_id_Personne` FOREIGN KEY (`id_Personne`) REFERENCES `Personne` (`id`)
85) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
86/*!40101 SET character_set_client = @saved_cs_client */;
87
88--
89-- Dumping data for table `Formateur`
90--
91
92LOCK TABLES `Formateur` WRITE;
93/*!40000 ALTER TABLE `Formateur` DISABLE KEYS */;
94INSERT INTO `Formateur` VALUES (1,'Java',6),(2,'PHP',7),(3,'Windev',8),(4,'JavaScript',9),(5,'AngularTS',10);
95/*!40000 ALTER TABLE `Formateur` ENABLE KEYS */;
96UNLOCK TABLES;
97
98--
99-- Table structure for table `Salle`
100--
101
102DROP TABLE IF EXISTS `Salle`;
103/*!40101 SET @saved_cs_client = @@character_set_client */;
104/*!40101 SET character_set_client = utf8 */;
105CREATE TABLE `Salle` (
106 `id` int(11) NOT NULL AUTO_INCREMENT,
107 `nom` varchar(25) DEFAULT NULL,
108 PRIMARY KEY (`id`)
109) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
110/*!40101 SET character_set_client = @saved_cs_client */;
111
112--
113-- Dumping data for table `Salle`
114--
115
116LOCK TABLES `Salle` WRITE;
117/*!40000 ALTER TABLE `Salle` DISABLE KEYS */;
118INSERT INTO `Salle` VALUES (1,'Salle de dojo'),(2,'Salle de réunion'),(3,'Salle de repos'),(4,'Cuisine'),(5,'Bureau'),(6,'OpenSpace');
119/*!40000 ALTER TABLE `Salle` ENABLE KEYS */;
120UNLOCK TABLES;
121
122
123--
124-- Table structure for table `Reserve`
125--
126
127DROP TABLE IF EXISTS `Reserve`;
128/*!40101 SET @saved_cs_client = @@character_set_client */;
129/*!40101 SET character_set_client = utf8 */;
130CREATE TABLE `Reserve` (
131 `duree_reservation` varchar(25) DEFAULT NULL,
132 `date_reservation` varchar(25) DEFAULT NULL,
133 `id` int(11) NOT NULL,
134 `id_Salle` int(11) NOT NULL,
135 PRIMARY KEY (`id`,`id_Salle`),
136 KEY `FK_Reserve_id_Salle` (`id_Salle`),
137 CONSTRAINT `FK_Reserve_id` FOREIGN KEY (`id`) REFERENCES `Personne` (`id`),
138 CONSTRAINT `FK_Reserve_id_Salle` FOREIGN KEY (`id_Salle`) REFERENCES `Salle` (`id`)
139) ENGINE=InnoDB DEFAULT CHARSET=latin1;
140/*!40101 SET character_set_client = @saved_cs_client */;
141
142--
143-- Dumping data for table `Reserve`
144--
145
146LOCK TABLES `Reserve` WRITE;
147/*!40000 ALTER TABLE `Reserve` DISABLE KEYS */;
148INSERT INTO `Reserve` VALUES ('2','2008-11-11',1,1),('4','2008-12-11',2,1),('2','2009-11-11',3,1),('2','2008-01-11',4,5),('2','2008-05-11',5,5),('2','2008-13-11',6,3),('2','2008-11-12',7,6),('2','2008-10-11',8,6),('2','2007-11-11',9,6),('2','2005-11-11',10,6);
149/*!40000 ALTER TABLE `Reserve` ENABLE KEYS */;
150UNLOCK TABLES;
151
152/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
153
154/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
155/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
156/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
157/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
158/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
159/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
160/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
161
162-- Dump completed on 2018-04-29 13:08:29
163
164SELECT * FROM Personne;
165SELECT * FROM Eleve;
166SELECT * FROM Formateur;
167SELECT * FROM Salle;
168SELECT * FROM Reserve;