c5FahLQ5

1-- MySQL dump 10.16  Distrib 10.1.31-MariaDB, for Linux (x86_64)
2--
3-- Host: localhost    Database: coucou
4-- ------------------------------------------------------
5-- Server version	10.1.31-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: `quetesql2`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `quetesql2` /*!40100 DEFAULT CHARACTER SET latin1 */;
23
24USE `quetesql2`;
25
26--
27-- Table structure for table `reservation`
28--
29
30DROP TABLE IF EXISTS `reservation`;
31/*!40101 SET @saved_cs_client     = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `reservation` (
34  `dateReservation` datetime DEFAULT NULL,
35  `duree` time DEFAULT NULL,
36  `numeroDossier` int(11) DEFAULT NULL,
37  `numeroSalle` int(11) DEFAULT NULL,
38  KEY `numeroDossier` (`numeroDossier`),
39  KEY `numeroSalle` (`numeroSalle`),
40  CONSTRAINT `reservation_ibfk_1` FOREIGN KEY (`numeroDossier`) REFERENCES `utilisateur` (`numeroDossier`),
41  CONSTRAINT `reservation_ibfk_2` FOREIGN KEY (`numeroSalle`) REFERENCES `salle` (`numeroSalle`)
42) ENGINE=InnoDB DEFAULT CHARSET=latin1;
43/*!40101 SET character_set_client = @saved_cs_client */;
44
45--
46-- Dumping data for table `reservation`
47--
48
49LOCK TABLES `reservation` WRITE;
50/*!40000 ALTER TABLE `reservation` DISABLE KEYS */;
51INSERT INTO `reservation` VALUES ('2018-04-02 08:00:00','01:00:00',11,1),('2018-04-11 08:00:00','01:00:00',12,1),('2018-04-04 08:00:00','02:00:00',13,1),('2018-05-20 08:00:00','02:00:00',14,5),('2018-05-01 08:00:00','01:00:00',15,5),('2018-07-27 08:00:00','18:00:00',16,3),('2018-06-11 08:00:00','03:00:00',17,6),('2018-05-10 08:00:00','04:00:00',18,6),('2018-05-11 08:00:00','01:00:00',19,6),('2018-07-11 08:00:00','02:00:00',20,6);
52/*!40000 ALTER TABLE `reservation` ENABLE KEYS */;
53UNLOCK TABLES;
54
55--
56-- Table structure for table `salle`
57--
58
59DROP TABLE IF EXISTS `salle`;
60/*!40101 SET @saved_cs_client     = @@character_set_client */;
61/*!40101 SET character_set_client = utf8 */;
62CREATE TABLE `salle` (
63  `numeroSalle` int(11) NOT NULL AUTO_INCREMENT,
64  `nomSalle` varchar(20) DEFAULT NULL,
65  PRIMARY KEY (`numeroSalle`)
66) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
67/*!40101 SET character_set_client = @saved_cs_client */;
68
69--
70-- Dumping data for table `salle`
71--
72
73LOCK TABLES `salle` WRITE;
74/*!40000 ALTER TABLE `salle` DISABLE KEYS */;
75INSERT INTO `salle` VALUES (1,'dojo'),(2,'reunion'),(3,'repos'),(4,'cuisine'),(5,'bureau'),(6,'openSPace');
76/*!40000 ALTER TABLE `salle` ENABLE KEYS */;
77UNLOCK TABLES;
78
79--
80-- Table structure for table `utilisateur`
81--
82
83DROP TABLE IF EXISTS `utilisateur`;
84/*!40101 SET @saved_cs_client     = @@character_set_client */;
85/*!40101 SET character_set_client = utf8 */;
86CREATE TABLE `utilisateur` (
87  `numeroDossier` int(11) NOT NULL AUTO_INCREMENT,
88  `nom` varchar(20) DEFAULT NULL,
89  `prenom` varchar(20) DEFAULT NULL,
90  `age` int(11) DEFAULT NULL,
91  `role` varchar(20) DEFAULT NULL,
92  `adresse` varchar(20) DEFAULT NULL,
93  `language` varchar(10) DEFAULT NULL,
94  PRIMARY KEY (`numeroDossier`)
95) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
96/*!40101 SET character_set_client = @saved_cs_client */;
97
98--
99-- Dumping data for table `utilisateur`
100--
101
102LOCK TABLES `utilisateur` WRITE;
103/*!40000 ALTER TABLE `utilisateur` DISABLE KEYS */;
104INSERT INTO `utilisateur` VALUES (11,'DesNeiges','Julien',31,'eleve','Disney','JS'),(12,'Fufu','Léa',25,'eleve','LaCave','PHP'),(13,'Google','Google',50,'formateur','USA','google'),(14,'P','Lorie',40,'formateur','FRA','chant'),(15,'S','Cédric',31,'eleve','Pierrick','JS'),(16,'DePlata','Pierrick',26,'eleve','caravane','JS'),(17,'Maco','Maco',0,'eleve','caravane','JS'),(18,'DaSilveira','Esteban',41,'eleve','jungle','JS'),(19,'B','Val',22,'eleve','jungle','JS'),(20,'Ripley','Ellen',30,'formateur','NOstromo','feu');
105/*!40000 ALTER TABLE `utilisateur` ENABLE KEYS */;
106UNLOCK TABLES;
107/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
108
109/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
110/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
111/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
112/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
113/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
114/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
115/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
116
117-- Dump completed on 2018-04-03 12:02:23