· 8 years ago · Jun 01, 2018, 06:08 AM
1-- MySQL dump 10.13 Distrib 5.7.22, for osx10.13 (x86_64)
2--
3-- Host: localhost Database: salles_wcs_paris
4-- ------------------------------------------------------
5-- Server version 5.5.5-10.2.14-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-- Current Database: `salles_wcs_paris`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `salles_wcs_paris` /*!40100 DEFAULT CHARACTER SET utf8 */;
23
24USE `salles_wcs_paris`;
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 `id` int(11) NOT NULL AUTO_INCREMENT,
35 `nom` varchar(50) NOT NULL,
36 `prenom` varchar(50) NOT NULL,
37 `adresse` varchar(250) NOT NULL,
38 `N__dossier` varchar(50) NOT NULL,
39 PRIMARY KEY (`id`)
40) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
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 (1,'Google','one','15 rue de la lune 75010 PARIS','001_A'),(2,'Laurie ','laur','151 rue des fleurs 75005 PARIS','002_B'),(3,'BERNE','TOM','18 rue Cujas 75005 Paris','003_C'),(4,'ILLIAM ','JERRY','151 rue des fleurs 75005 PARIS','004_D'),(5,'SIMPSON ','BART','742 evergreen terrece Springfield','005_E'),(6,'DUPONT ','EDWARD','17 Rue la Fayette 75009 PARIS','006_F'),(7,'SARROW ','JACK','19 Rue Saulnier 75010 PARIS','007_G'),(8,'ELI ','WALLACH','120 quai Marcel Dassault 92000 Saint Cloud','008_H'),(9,'OATMAN ','OLIVE','2 route des tribunes 75016 PARIS','010_J'),(10,'BUD ','SPENCER','83 Boulevard de l\'Hôpital 75013 PARIS','009_I');
50/*!40000 ALTER TABLE `eleve` ENABLE KEYS */;
51UNLOCK TABLES;
52
53--
54-- Table structure for table `formateur`
55--
56
57DROP TABLE IF EXISTS `formateur`;
58/*!40101 SET @saved_cs_client = @@character_set_client */;
59/*!40101 SET character_set_client = utf8 */;
60CREATE TABLE `formateur` (
61 `id` int(11) NOT NULL AUTO_INCREMENT,
62 `nom` varchar(50) NOT NULL,
63 `prenom` varchar(50) NOT NULL,
64 `N__dossier` varchar(50) NOT NULL,
65 `adresse` varchar(250) NOT NULL,
66 `langage` varchar(50) NOT NULL,
67 PRIMARY KEY (`id`)
68) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
69/*!40101 SET character_set_client = @saved_cs_client */;
70
71--
72-- Dumping data for table `formateur`
73--
74
75LOCK TABLES `formateur` WRITE;
76/*!40000 ALTER TABLE `formateur` DISABLE KEYS */;
77INSERT INTO `formateur` VALUES (1,'BUD ','SPENCER','009_I','83 Boulevard de l\'Hôpital 75013 PARIS','Javascript');
78/*!40000 ALTER TABLE `formateur` ENABLE KEYS */;
79UNLOCK TABLES;
80
81--
82-- Table structure for table `reservation`
83--
84
85DROP TABLE IF EXISTS `reservation`;
86/*!40101 SET @saved_cs_client = @@character_set_client */;
87/*!40101 SET character_set_client = utf8 */;
88CREATE TABLE `reservation` (
89 `id` int(11) NOT NULL,
90 `id_salles` int(11) NOT NULL,
91 `id_formateur` int(11) NOT NULL,
92 `num` varchar(50) DEFAULT NULL,
93 `date__jour_heur_` date NOT NULL,
94 `duree` varchar(50) NOT NULL,
95 `personne_qui_reserve` varchar(50) NOT NULL,
96 PRIMARY KEY (`id`,`id_salles`,`id_formateur`),
97 KEY `reservation_salles0_FK` (`id_salles`),
98 KEY `reservation_formateur1_FK` (`id_formateur`),
99 CONSTRAINT `reservation_eleve_FK` FOREIGN KEY (`id`) REFERENCES `eleve` (`id`),
100 CONSTRAINT `reservation_formateur1_FK` FOREIGN KEY (`id_formateur`) REFERENCES `formateur` (`id`),
101 CONSTRAINT `reservation_salles0_FK` FOREIGN KEY (`id_salles`) REFERENCES `salles` (`id`)
102) ENGINE=InnoDB DEFAULT CHARSET=utf8;
103/*!40101 SET character_set_client = @saved_cs_client */;
104
105--
106-- Dumping data for table `reservation`
107--
108
109LOCK TABLES `reservation` WRITE;
110/*!40000 ALTER TABLE `reservation` DISABLE KEYS */;
111INSERT INTO `reservation` VALUES (1,1,1,'01','2018-02-12','02:00','GOOGLE One'),(2,1,1,'02','2018-02-12','02:00','LAURIE Laur'),(3,1,1,'03','2018-02-12','02:00','BERNE Tom'),(4,3,1,'04','2018-02-12','01:00','ILLIAM Jerry'),(5,5,1,'05','2018-02-12','01:30','BUD SPENCER'),(6,5,1,'06','2018-02-12','01:30','ELI WALLACH'),(7,6,1,'07','2018-02-12','01:00','SIMPSON BART'),(8,6,1,'08','2018-02-12','01:00','DUPONT Edward'),(9,6,1,'09','2018-02-12','01:00','SPARROW Jack'),(10,6,1,'10','2018-02-12','01:00','BUD Spencer');
112/*!40000 ALTER TABLE `reservation` ENABLE KEYS */;
113UNLOCK TABLES;
114
115--
116-- Table structure for table `salles`
117--
118
119DROP TABLE IF EXISTS `salles`;
120/*!40101 SET @saved_cs_client = @@character_set_client */;
121/*!40101 SET character_set_client = utf8 */;
122CREATE TABLE `salles` (
123 `id` int(11) NOT NULL AUTO_INCREMENT,
124 `nom` varchar(50) DEFAULT NULL,
125 `n__unique` varchar(50) NOT NULL,
126 PRIMARY KEY (`id`)
127) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
128/*!40101 SET character_set_client = @saved_cs_client */;
129
130--
131-- Dumping data for table `salles`
132--
133
134LOCK TABLES `salles` WRITE;
135/*!40000 ALTER TABLE `salles` DISABLE KEYS */;
136INSERT INTO `salles` VALUES (1,'Salles de dojo','001_001'),(2,'Salles de réunion','001_002'),(3,'Salles de repos','001_003'),(4,'Cuisine','001_004'),(5,'Bureau','001_005'),(6,'OpenSpace','001_006');
137/*!40000 ALTER TABLE `salles` ENABLE KEYS */;
138UNLOCK TABLES;
139/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
140
141/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
142/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
143/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
144/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
145/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
146/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
147/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
148
149-- Dump completed on 2018-05-28 10:13:00