V4zF4psp

1-- MySQL dump 10.13  Distrib 5.7.21, for Linux (x86_64)
2--
3-- Host: localhost    Database: pascal_a_wcs_toulouse
4-- ------------------------------------------------------
5-- Server version	5.7.21-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-- Current Database: `pascal_a_wcs_toulouse`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `pascal_a_wcs_toulouse` /*!40100 DEFAULT CHARACTER SET latin1 */;
23
24USE `pascal_a_wcs_toulouse`;
25
26--
27-- Table structure for table `résa`
28--
29
30DROP TABLE IF EXISTS `résa`;
31/*!40101 SET @saved_cs_client     = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `résa` (
34  `nom` text,
35  `date_résa` date DEFAULT NULL,
36  `durée` time DEFAULT NULL,
37  `numéro_dossier` int(11) NOT NULL,
38  `numéro` int(11) NOT NULL,
39  PRIMARY KEY (`numéro_dossier`,`numéro`),
40  KEY `FK_résa_numéro` (`numéro`),
41  CONSTRAINT `FK_résa_numéro` FOREIGN KEY (`numéro`) REFERENCES `salles` (`numéro`),
42  CONSTRAINT `FK_résa_numéro_dossier` FOREIGN KEY (`numéro_dossier`) REFERENCES `wilder` (`numéro_dossier`)
43) ENGINE=InnoDB DEFAULT CHARSET=latin1;
44/*!40101 SET character_set_client = @saved_cs_client */;
45
46--
47-- Dumping data for table `résa`
48--
49
50LOCK TABLES `résa` WRITE;
51/*!40000 ALTER TABLE `résa` DISABLE KEYS */;
52INSERT INTO `résa` VALUES ('Tournoi de Mario Kart','2018-06-21','05:00:00',1,3),('Quêtes','2018-03-28','08:30:00',2,4),('RDV Client','2018-04-05','01:00:00',3,2),('RDV Campus Manager','2018-04-30','00:30:00',4,2),('Dojo relou','2018-04-01','02:00:00',5,1),('Le meilleur dojo','2018-07-04','02:30:00',6,1),('Dojo mieux que l\'autre','2018-04-05','02:30:00',7,1),('Planning Poker','2018-05-15','00:30:00',8,4),('Tournée de café','2018-04-08','01:45:00',9,4),('Collage de post-it','2018-05-22','01:00:00',10,4);
53/*!40000 ALTER TABLE `résa` ENABLE KEYS */;
54UNLOCK TABLES;
55
56--
57-- Table structure for table `salles`
58--
59
60DROP TABLE IF EXISTS `salles`;
61/*!40101 SET @saved_cs_client     = @@character_set_client */;
62/*!40101 SET character_set_client = utf8 */;
63CREATE TABLE `salles` (
64  `nom` text,
65  `numéro` int(11) NOT NULL AUTO_INCREMENT,
66  PRIMARY KEY (`numéro`)
67) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
68/*!40101 SET character_set_client = @saved_cs_client */;
69
70--
71-- Dumping data for table `salles`
72--
73
74LOCK TABLES `salles` WRITE;
75/*!40000 ALTER TABLE `salles` DISABLE KEYS */;
76INSERT INTO `salles` VALUES ('Salle de dojo',1),('Salle de réunion',2),('Salle de repos',3),('Open Space',4),('Cuisine',5),('Bureau',6);
77/*!40000 ALTER TABLE `salles` ENABLE KEYS */;
78UNLOCK TABLES;
79
80--
81-- Table structure for table `wilder`
82--
83
84DROP TABLE IF EXISTS `wilder`;
85/*!40101 SET @saved_cs_client     = @@character_set_client */;
86/*!40101 SET character_set_client = utf8 */;
87CREATE TABLE `wilder` (
88  `nom` varchar(30) DEFAULT NULL,
89  `prénom` varchar(30) DEFAULT NULL,
90  `adresse` text,
91  `langage` varchar(30) DEFAULT NULL,
92  `numéro_dossier` int(11) NOT NULL AUTO_INCREMENT,
93  PRIMARY KEY (`numéro_dossier`)
94) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
95/*!40101 SET character_set_client = @saved_cs_client */;
96
97--
98-- Dumping data for table `wilder`
99--
100
101LOCK TABLES `wilder` WRITE;
102/*!40000 ALTER TABLE `wilder` DISABLE KEYS */;
103INSERT INTO `wilder` VALUES ('Lataupe','René','33 Rue du Taco',NULL,1),('Tartine','Kimberley','6 Impasse Spaghetti',NULL,2),('Talu','Jean','54 Boulevard Ratatouille',NULL,3),('Sardou','Michel','Lieu-dit Connemara',NULL,4),('Brettly','Kastien',NULL,'Javandroid',5),(NULL,'Google',NULL,'Too_many',6),('Fréchit','Sarah','45 Avenue de la Frite',NULL,7),('Zuckerberg','Mark',NULL,'Facebook',8),('Egée','Yves','88 Rue du Fromage',NULL,9),('Pester','Laurie','1 Place de la Bourse',NULL,10);
104/*!40000 ALTER TABLE `wilder` 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-03-26 16:42:13