text: -- MySQL dump 10.13  Distrib 5.7.24, for Win64 (x86_64)
  --
  -- Host: localhost    Database: bullao
  -- ------------------------------------------------------
  -- Server version	5.7.24
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `accessoires`
  --
  
  DROP TABLE IF EXISTS `accessoires`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `accessoires` (
    `accessoire_id` int(11) NOT NULL AUTO_INCREMENT,
    `accessoire_libelle` varchar(100) NOT NULL,
    `accessoire_description` text,
    `accessoire_prix` decimal(10,2) NOT NULL,
    `accessoire_stock` int(11) NOT NULL DEFAULT '0',
    `accessoire_conso` int(1) NOT NULL DEFAULT '0',
    `accessoire_chemin_img` varchar(100) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`accessoire_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `accessoires`
  --
  
  LOCK TABLES `accessoires` WRITE;
  /*!40000 ALTER TABLE `accessoires` DISABLE KEYS */;
  INSERT INTO `accessoires` VALUES (1,'Enceinte Bose','Description',9.00,12,0,'medias/img/accessoires/enceinte.png',NULL,'2020-10-20 14:22:26'),(2,'Marche pied','Description',6.00,1,0,'medias/img/accessoires/marche-pied.png',NULL,'2020-10-31 12:22:34'),(3,'Parfum positivant','Description',3.00,14,1,'medias/img/accessoires/parfum-positive.png',NULL,'2020-12-18 12:47:22'),(4,'Parfum fraicheur','Description',3.00,14,1,'medias/img/accessoires/parfum-energie.png',NULL,'2021-03-18 14:16:39'),(5,'Parfum Love','Description',3.00,22,1,'medias/img/accessoires/parfum-love.png',NULL,'2021-03-18 14:16:39'),(6,'Pouf lumineux','Description',5.00,2,0,'medias/img/accessoires/pouf-lumineux.png',NULL,'2020-10-31 12:22:57'),(7,'Porte verre','Description',2.00,3,0,'medias/img/accessoires/porte-verre.png',NULL,NULL),(8,'Lot 2 sièges confort','Description',10.00,1,0,'medias/img/accessoires/siege-confort.png',NULL,NULL);
  /*!40000 ALTER TABLE `accessoires` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `administrateurs`
  --
  
  DROP TABLE IF EXISTS `administrateurs`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `administrateurs` (
    `administrateur_id` int(11) NOT NULL AUTO_INCREMENT,
    `administrateur_name` varchar(100) NOT NULL,
    `administrateur_phone` varchar(10) DEFAULT NULL,
    `administrateur_email` varchar(100) NOT NULL,
    `administrateur_user_id` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`administrateur_id`),
    KEY `administrateur_user_id` (`administrateur_user_id`),
    CONSTRAINT `administrateurs_ibfk_1` FOREIGN KEY (`administrateur_user_id`) REFERENCES `users` (`user_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `administrateurs`
  --
  
  LOCK TABLES `administrateurs` WRITE;
  /*!40000 ALTER TABLE `administrateurs` DISABLE KEYS */;
  INSERT INTO `administrateurs` VALUES (1,'Jérémy Lémont','0631727083','jerem-lem@hotmail.fr',1,'2020-09-19 22:00:00',NULL),(2,'Alexandre','0613377128','cnl.alexandre@gmail.com',3,NULL,NULL),(3,'Greg','0613377128','gregoireconil@bullao.fr',7,NULL,NULL),(4,'Alessandra Caillaud',NULL,'alessandra.caillaud@yahoo.com',6,NULL,NULL);
  /*!40000 ALTER TABLE `administrateurs` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `adresses`
  --
  
  DROP TABLE IF EXISTS `adresses`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `adresses` (
    `adresse_id` int(11) NOT NULL AUTO_INCREMENT,
    `adresse_name` varchar(100) NOT NULL,
    `adresse_client_id` int(11) NOT NULL,
    `adresse_rue` varchar(100) NOT NULL,
    `adresse_cp` varchar(5) DEFAULT NULL,
    `adresse_ville` varchar(100) NOT NULL,
    `adresse_complement` varchar(100) DEFAULT NULL,
    `adresse_departement` varchar(100) DEFAULT NULL,
    `adresse_ascenseur` varchar(3) DEFAULT NULL,
    `adresse_etage` varchar(30) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`adresse_id`),
    KEY `adresse_client_id` (`adresse_client_id`),
    CONSTRAINT `adresses_ibfk_1` FOREIGN KEY (`adresse_client_id`) REFERENCES `clients` (`client_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `adresses`
  --
  
  LOCK TABLES `adresses` WRITE;
  /*!40000 ALTER TABLE `adresses` DISABLE KEYS */;
  INSERT INTO `adresses` VALUES (5,'Principale',4,'19 CHEMIN DE LA PORTE VERTE',NULL,'MONTEVRAIN',NULL,'77',NULL,NULL,'2020-11-04 17:29:53','2020-11-04 17:29:53'),(6,'Principale',5,'19 chemin de la porte verte',NULL,'Montévrain',NULL,'77',NULL,NULL,'2020-11-06 16:27:19','2020-11-06 16:27:19'),(7,'Principale',7,'12 rue d\'annet',NULL,'Thorigny-sur-Marne',NULL,'77',NULL,NULL,NULL,NULL),(8,'Principale',8,'chemin de la glacière',NULL,'Montévrain',NULL,'77',NULL,NULL,NULL,NULL),(9,'Principale',9,'9 rue des binaches',NULL,'Montevrain',NULL,'77',NULL,NULL,'2020-12-18 12:45:21','2020-12-18 12:45:21'),(10,'Principale',10,'3 allée des tonnelles',NULL,'Lognes','Rdc porte droite','77',NULL,NULL,'2020-12-28 23:01:53','2020-12-28 23:01:53'),(11,'Principale',11,'5 rue du docteur Dufraigne',NULL,'Meaux','4ieme étage. Code 1973. Interphone : frot','77',NULL,NULL,'2021-01-16 18:20:48','2021-01-16 18:20:48'),(12,'Principale',12,'3 rue Antoine de saint exupery',NULL,'Coupvray',NULL,'77',NULL,NULL,'2021-01-16 22:29:51','2021-01-16 22:29:51'),(13,'Principale',13,'25 bis rue de la fraternité',NULL,'Esbly',NULL,'77',NULL,NULL,'2021-01-17 08:14:24','2021-01-17 08:14:24'),(14,'Principale',14,'6 rue du Gripet',NULL,'Magny-le-Hongre','6 rue du Gripet','77',NULL,NULL,'2021-01-18 11:57:01','2021-01-18 11:57:01'),(15,'Principale',15,'3 rue de l’arcade',NULL,'Lagny sur Marne','2eme étage avec ascenseur','77',NULL,NULL,'2021-01-18 19:39:36','2021-01-18 19:39:36'),(16,'Principale',16,'12 rue du lievre',NULL,'thorigny sur marne',NULL,'77',NULL,NULL,'2021-01-19 15:44:17','2021-01-19 15:44:17'),(17,'Principale',17,'16 rue du 8 mai 1945',NULL,'77450 esbly',NULL,'77',NULL,NULL,'2021-01-20 12:14:27','2021-01-20 12:14:27'),(18,'Principale',21,'9 rue de torcy',NULL,'Chelles',NULL,'77',NULL,NULL,'2021-01-23 11:01:36','2021-01-23 11:01:36'),(19,'Principale',22,'15 ALLEE DES FENAISONS',NULL,'CHANTELOUP EN BRIE',NULL,'77',NULL,NULL,'2021-01-23 11:12:44','2021-01-23 11:12:44'),(20,'Principale',23,'9 rue du bois de la fontaine',NULL,'VAIRES SUR MARNE','9 rue du bois de la fontaine','77',NULL,NULL,'2021-01-24 08:13:26','2021-01-24 08:13:26'),(21,'Principale',24,'52 BOUCLE BELLE JOSEPHINE',NULL,'MAGNY LE HONGRE',NULL,'77',NULL,NULL,'2021-01-29 09:30:05','2021-01-29 09:30:05'),(22,'Principale',25,'3 rue de la vallée',NULL,'Collegien','Interphone ; Douraguia','77',NULL,NULL,'2021-02-01 19:51:47','2021-02-01 19:51:47'),(23,'Principale',29,'6 rue de l\'orangerie',NULL,'TORCY','3 ème étage code 23081','77',NULL,NULL,'2021-02-03 14:41:20','2021-02-03 14:41:20'),(24,'Principale',30,'6 rue d\'Ariane',NULL,'Chessy','codes A2910, B1506, C21','77',NULL,NULL,'2021-02-03 15:20:16','2021-02-03 15:20:16'),(25,'Principale',32,'19 chemin de la porte verte',NULL,'77144 - MONTEVRAIN',NULL,'77',NULL,NULL,'2021-02-06 14:01:37','2021-02-06 14:01:37'),(26,'Principale',4,'19 CHEMIN DE LA PORTE VERTE, 19',NULL,'MONTEVRAIN',NULL,'77',NULL,NULL,'2021-02-10 21:38:51','2021-02-10 21:38:51'),(27,'Principale',40,'19 che du pré',NULL,'LAgny Zoo',NULL,'77',NULL,NULL,'2021-02-11 13:43:25','2021-02-11 13:43:25'),(28,'Principale',42,'19 chemin de la porte verte',NULL,'Montévrain',NULL,NULL,NULL,NULL,'2021-02-11 13:52:10','2021-02-11 13:52:10'),(29,'Principale',43,'93 efzjks',NULL,'Clay Souilly',NULL,NULL,NULL,NULL,'2021-02-11 13:53:58','2021-02-11 13:53:58'),(30,'Principal',44,'11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77',NULL,NULL,'2021-03-14 17:50:25','2021-03-14 17:50:25'),(31,'Principal',45,'11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77',NULL,NULL,'2021-03-14 18:08:59','2021-03-14 18:08:59'),(32,'Principal',46,'11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77',NULL,NULL,'2021-03-14 18:25:21','2021-03-14 18:25:21'),(33,'Principal',47,'11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77',NULL,NULL,'2021-03-14 18:43:31','2021-03-14 18:43:31'),(34,'Principal',48,'11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77','Oui','Rez-de-chaussé','2021-03-14 18:48:40','2021-03-14 18:48:40'),(35,'Principal',49,'11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77',NULL,NULL,'2021-03-15 17:30:43','2021-03-15 17:30:43'),(36,'Principal',50,'11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77',NULL,NULL,'2021-03-15 17:47:10','2021-03-15 17:47:10'),(37,'Principal',51,'11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77',NULL,NULL,'2021-03-15 17:54:15','2021-03-15 17:54:15'),(38,'Principal',52,'11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77',NULL,NULL,'2021-03-15 17:57:37','2021-03-15 17:57:37'),(39,'Principal',53,'11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77','Oui','Rez-de-chaussé','2021-03-18 11:42:11','2021-03-18 11:42:11'),(40,'Principal',54,'11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77','Oui','Rez-de-chaussé','2021-03-18 11:53:31','2021-03-18 11:53:31'),(41,'Principal',55,'2350 route de Bourideys','40430','Sore',NULL,'77','Oui','Rez-de-chaussé','2021-03-18 11:59:25','2021-03-18 11:59:25'),(42,'Principal',56,'2350 route de Bourideys','40430','Sore',NULL,'77',NULL,NULL,'2021-03-18 12:04:25','2021-03-18 12:04:25'),(43,'Principal',57,'11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77','Oui','Rez-de-chaussé','2021-03-18 14:14:24','2021-03-18 14:14:24');
  /*!40000 ALTER TABLE `adresses` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `cadeaux`
  --
  
  DROP TABLE IF EXISTS `cadeaux`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `cadeaux` (
    `cadeau_id` int(11) NOT NULL AUTO_INCREMENT,
    `cadeau_client_id` int(11) DEFAULT NULL,
    `cadeau_montant` decimal(10,2) NOT NULL,
    `cadeau_montant_restant` decimal(10,2) NOT NULL DEFAULT '0.00',
    `cadeau_date_debut` date DEFAULT NULL,
    `cadeau_date_fin` date DEFAULT NULL,
    `cadeau_code` varchar(12) DEFAULT NULL,
    `cadeau_offre` varchar(100) DEFAULT NULL,
    `cadeau_date_paie` date DEFAULT NULL,
    `cadeau_rue` varchar(100) DEFAULT NULL,
    `cadeau_cp` varchar(5) DEFAULT NULL,
    `cadeau_ville` varchar(100) DEFAULT NULL,
    `cadeau_complement` varchar(100) DEFAULT NULL,
    `cadeau_departement` varchar(100) DEFAULT NULL,
    `cadeau_client_id_used` int(11) DEFAULT NULL,
    `cadeau_date_used` date DEFAULT NULL,
    `cadeau_used` int(11) NOT NULL DEFAULT '0',
    `cadeau_paye` int(1) DEFAULT '0',
    `cadeau_payment_id` varchar(100) DEFAULT NULL,
    `cadeau_email` varchar(50) DEFAULT NULL,
    `cadeau_phone` varchar(10) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`cadeau_id`),
    KEY `cadeau_client_id` (`cadeau_client_id`),
    KEY `cadeau_client_id_used` (`cadeau_client_id_used`),
    KEY `cadeau_id` (`cadeau_id`),
    CONSTRAINT `cadeaux_ibfk_1` FOREIGN KEY (`cadeau_client_id`) REFERENCES `clients` (`client_id`),
    CONSTRAINT `cadeaux_ibfk_2` FOREIGN KEY (`cadeau_client_id_used`) REFERENCES `clients` (`client_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `cadeaux`
  --
  
  LOCK TABLES `cadeaux` WRITE;
  /*!40000 ALTER TABLE `cadeaux` DISABLE KEYS */;
  INSERT INTO `cadeaux` VALUES (2,49,120.00,120.00,'2021-03-15','2022-03-15',NULL,'Carte Grand Bain','2021-03-15','11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77',NULL,NULL,0,1,'pi_1IVKPaGOBvkHIeeTMt2mntgu','jerem-lem@hotmail.fr','0631727083','2021-03-15 17:14:04','2021-03-15 17:44:36'),(3,50,140.00,140.00,'2021-03-15','2022-03-15',NULL,'Carte Sensation','2021-03-15','11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77',NULL,NULL,0,1,'pi_1IVKVVGOBvkHIeeTrHUtLy2N','jerem-lem@hotmail.fr','0631727083','2021-03-15 17:46:19','2021-03-15 17:47:28'),(4,51,140.00,140.00,'2021-03-15','2022-03-15',NULL,'Carte Sensation','2021-03-15','11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77',NULL,NULL,0,1,'pi_1IVKdAGOBvkHIeeTiYg6T6Es','jerem-lem@hotmail.fr','0631727083','2021-03-15 17:53:33','2021-03-15 17:55:21');
  /*!40000 ALTER TABLE `cadeaux` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `clients`
  --
  
  DROP TABLE IF EXISTS `clients`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `clients` (
    `client_id` int(11) NOT NULL AUTO_INCREMENT,
    `client_name` varchar(100) NOT NULL,
    `client_user_id` int(11) DEFAULT NULL,
    `client_email` varchar(100) DEFAULT NULL,
    `client_phone` varchar(10) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`client_id`),
    KEY `client_user_id` (`client_user_id`),
    CONSTRAINT `clients_ibfk_1` FOREIGN KEY (`client_user_id`) REFERENCES `users` (`user_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `clients`
  --
  
  LOCK TABLES `clients` WRITE;
  /*!40000 ALTER TABLE `clients` DISABLE KEYS */;
  INSERT INTO `clients` VALUES (1,'Bullao',NULL,'contact@bullao.fr','0613377128','2020-10-31 23:00:00','2020-10-31 23:00:00'),(4,'Sophie Conil',8,'cnl.sophie@gmail.com','0686928915','2020-11-04 17:29:53','2020-11-04 17:29:53'),(5,'Alexandre',4,'cnl.alexandre@gmail.com','0613377128','2020-11-06 16:27:19','2020-11-06 16:27:19'),(7,'Alexandra Menny',NULL,'alexandra.menny@hotmail.fr','0634542127','2020-11-17 22:34:00','2020-12-15 23:00:00'),(8,'Sandrine Vaysse',NULL,'nomail@mail.com','0785388262','2020-11-17 22:34:00',NULL),(9,'Morini',9,'cf.morini@free.fr','0675250340','2020-12-18 12:45:21','2020-12-18 12:45:21'),(10,'Anaïs Thomas Febvre',10,'evaadoc77@gmail.com','0680175204','2020-12-28 23:01:53','2020-12-28 23:01:53'),(11,'Frot fabien',11,'ffrot@hotmail.com','0617345744','2021-01-16 18:20:48','2021-01-16 18:20:48'),(12,'Céline MUNOZ',12,'celine.munoz@gmail.com','0649801688','2021-01-16 22:29:51','2021-01-16 22:29:51'),(13,'Vibet renaud',13,'renaud.vibet@laposte.net','0663338919','2021-01-17 08:14:24','2021-01-17 08:14:24'),(14,'Bordet-Davignon Sandrine',14,'sbordet@orange.fr','0659756660','2021-01-18 11:57:01','2021-01-18 11:57:01'),(15,'LUU marine',15,'marineluu2201@yahoo.fr','0677847018','2021-01-18 19:39:36','2021-01-18 19:39:36'),(16,'GUILLAUME CHAUVIN',16,'guycho974@gmail.com','0622705831','2021-01-19 15:44:17','2021-01-19 15:44:17'),(17,'Moreira stephanie',17,'stephaniechascomoreira@gmail.com','0685217186','2021-01-20 12:14:27','2021-01-20 12:14:27'),(21,'Devulder claudie',18,'claudie.87@hotmail.com','0635151124','2021-01-23 11:01:36','2021-01-23 11:01:36'),(22,'TE STEPHANIE',19,'stephanie.tesooukian@gmail.com','0632920453','2021-01-23 11:12:44','2021-01-23 11:12:44'),(23,'Carrere ludivine',20,'ludivinepierre@live.fr','0658628942','2021-01-24 08:13:26','2021-01-24 08:13:26'),(24,'Noël Christelle',21,'gouleret.christelle@gmail.com','0785386976','2021-01-29 09:30:05','2021-01-29 09:30:05'),(25,'Douraguia Jennifer',22,'jennifer.douraguia@gmail.com','0766385263','2021-02-01 19:51:47','2021-02-01 19:51:47'),(26,'Lhomel Vincent',NULL,'vincentdu77600@gmail.com','0761754985',NULL,NULL),(27,'Thomas Fouchy',NULL,'fouchythomas@gmail.com',NULL,NULL,NULL),(28,'Claudie Devulder',NULL,'claudie.87@hotmail.com','0635151124',NULL,NULL),(29,'Nicolas Tranchant',23,'Nicow1816@gmail.com','0658231488','2021-02-03 14:41:20','2021-02-03 14:41:20'),(30,'BRANDI Marisa',24,'marisabrandi235@gmail.com','0753712444','2021-02-03 15:20:15','2021-02-03 15:20:15'),(31,'Seinde Toure',NULL,'seinde@hotmail.fr','0622025780',NULL,NULL),(32,'Alessandra',6,'alessandra.caillaud@yahoo.com','0606060606',NULL,NULL),(33,'Adeline Chan',26,'adeline.barthe20@gmail.com','0642482866',NULL,NULL),(34,'Madeline Rayer',27,'madi_cool77@hotmail.fr','0615148371','2021-02-10 13:00:00',NULL),(35,'Sylvie Da Costa',28,'msylvie77@gmail.com','0609666585','2021-02-10 13:00:00',NULL),(36,'Xavier Couttelle',29,'xaviercouttelle@gmail.com','0603201169',NULL,NULL),(38,'Benjamin Beaupré',30,'benjamin.beaupre@laposte.net',NULL,NULL,NULL),(39,'Valérie Gowry',31,'valerie.gowry@outlook.com','0695972756',NULL,NULL),(40,'Beauf Service',32,'cejzinczi@fzjno.fr','0284924729','2021-02-11 13:43:25','2021-02-11 13:43:25'),(41,'Beauf 2',33,'cziezbci@vzodzo.fr','0138424328','2021-02-11 13:49:55','2021-02-11 13:49:55'),(42,'Beauf 2',33,'cziezbci@vzodzo.fr','0138424328','2021-02-11 13:52:10','2021-02-11 13:52:10'),(43,'Beauf 3 de service',34,'céeijn.cezo@vez.fr',NULL,'2021-02-11 13:53:58','2021-02-11 13:53:58'),(44,'Jérémy Lémont',35,'jerem-lem@hotmail.fr','0631727083','2021-03-14 17:50:25','2021-03-14 17:50:25'),(45,'Jérémy Lémont',35,'jerem-lem@hotmail.fr','0631727083','2021-03-14 18:08:59','2021-03-14 18:08:59'),(46,'Jérémy Lémont',35,'jerem-lem@hotmail.fr','0631727083','2021-03-14 18:25:21','2021-03-14 18:25:21'),(47,'Jérémy Lémont',35,'jerem-lem@hotmail.fr','0631727083','2021-03-14 18:43:31','2021-03-14 18:43:31'),(48,'Jérémy Lémont',35,'jerem-lem@hotmail.fr','0631727083','2021-03-14 18:48:40','2021-03-14 18:48:40'),(49,'Jérémy Lémont',35,'jerem-lem@hotmail.fr','0631727083','2021-03-15 17:30:43','2021-03-15 17:30:43'),(50,'Jérémy Lémont',35,'jerem-lem@hotmail.fr','0631727083','2021-03-15 17:47:10','2021-03-15 17:47:10'),(51,'Jérémy Lémont',35,'jerem-lem@hotmail.fr','0631727083','2021-03-15 17:54:15','2021-03-15 17:54:15'),(52,'Jérémy Lémont',35,'jerem-lem@hotmail.fr','0631727083','2021-03-15 17:57:37','2021-03-15 17:57:37'),(53,'Jérémy Lémont',35,'jerem-lem@hotmail.fr','0631727083','2021-03-18 11:42:11','2021-03-18 11:42:11'),(54,'Jérémy Lémont',35,'jerem-lem@hotmail.fr','0631727083','2021-03-18 11:53:31','2021-03-18 11:53:31'),(55,'Jérémy Lémont',35,'jerem-lem@hotmail.fr','0631727083','2021-03-18 11:59:25','2021-03-18 11:59:25'),(56,'Jérémy Lémont',35,'jerem-lem@hotmail.fr','0631727083','2021-03-18 12:04:25','2021-03-18 12:04:25'),(57,'Jérémy Lémont',35,'jerem-lem@hotmail.fr','0631727083','2021-03-18 14:14:24','2021-03-18 14:14:24');
  /*!40000 ALTER TABLE `clients` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `indisponibilites`
  --
  
  DROP TABLE IF EXISTS `indisponibilites`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `indisponibilites` (
    `indisponibilite_id` int(11) NOT NULL AUTO_INCREMENT,
    `indisponibilite_date` date NOT NULL,
    `indisponibilite_desc` text,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`indisponibilite_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `indisponibilites`
  --
  
  LOCK TABLES `indisponibilites` WRITE;
  /*!40000 ALTER TABLE `indisponibilites` DISABLE KEYS */;
  INSERT INTO `indisponibilites` VALUES (1,'2020-09-21',NULL,NULL,NULL),(2,'2020-09-22',NULL,NULL,NULL),(3,'2020-11-16','caserne','2020-10-23 13:28:51','2020-10-23 13:29:06'),(4,'2020-11-02','caserne','2020-10-31 14:40:22','2020-10-31 14:40:22'),(5,'2020-11-03','caserne','2020-10-31 14:40:32','2020-10-31 14:40:32'),(6,'2020-11-09',NULL,'2020-10-31 14:40:42','2020-10-31 14:40:42'),(7,'2020-11-16',NULL,'2020-10-31 14:40:56','2020-10-31 14:40:56'),(8,'2020-11-18',NULL,'2020-10-31 14:41:32','2020-10-31 14:41:32'),(9,'2020-11-25',NULL,'2020-10-31 14:41:42','2020-10-31 14:41:42'),(10,'2020-11-28','COMPLET','2020-11-15 14:46:18','2020-11-15 14:46:18'),(11,'2020-12-30',NULL,'2020-12-29 00:08:30','2020-12-29 00:08:30'),(12,'2020-12-31','full','2020-12-29 00:08:39','2020-12-29 00:08:39'),(13,'2021-01-01',NULL,'2020-12-29 00:08:52','2020-12-29 00:08:52'),(14,'2021-01-02',NULL,'2020-12-29 00:08:57','2020-12-29 00:08:57'),(15,'2021-01-22',NULL,'2021-01-18 21:17:14','2021-01-18 21:17:14'),(16,'2021-01-23',NULL,'2021-01-18 21:17:20','2021-01-18 21:17:20'),(17,'2021-01-24',NULL,'2021-01-18 21:17:26','2021-01-18 21:17:26'),(18,'2021-01-20',NULL,'2021-01-18 21:17:58','2021-01-18 21:17:58'),(19,'2021-01-21',NULL,'2021-01-18 21:18:04','2021-01-18 21:18:04'),(20,'2021-02-12',NULL,'2021-01-24 10:14:34','2021-01-24 10:14:43'),(21,'2021-02-13',NULL,'2021-01-24 10:15:06','2021-01-24 10:15:06'),(22,'2021-02-14',NULL,'2021-01-24 10:15:15','2021-01-24 10:15:15'),(23,'2021-02-15',NULL,'2021-01-24 10:15:22','2021-01-24 10:15:22'),(24,'2021-02-05',NULL,'2021-02-01 21:40:42','2021-02-01 21:40:42'),(25,'2021-02-06',NULL,'2021-02-01 21:40:46','2021-02-01 21:40:46'),(26,'2021-02-07',NULL,'2021-02-01 21:40:51','2021-02-01 21:40:51'),(27,'2021-02-08',NULL,'2021-02-01 21:40:56','2021-02-01 21:40:56'),(28,'2021-02-16',NULL,'2021-02-03 18:01:28','2021-02-03 18:01:28'),(29,'2021-02-17',NULL,'2021-02-03 18:01:33','2021-02-03 18:01:33'),(30,'2021-02-22',NULL,'2021-02-03 18:01:47','2021-02-03 18:01:47'),(31,'2021-02-01',NULL,'2021-02-11 10:58:26','2021-02-11 10:58:26');
  /*!40000 ALTER TABLE `indisponibilites` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `packs`
  --
  
  DROP TABLE IF EXISTS `packs`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `packs` (
    `pack_id` int(11) NOT NULL AUTO_INCREMENT,
    `pack_libelle` varchar(100) NOT NULL,
    `pack_description` text,
    `pack_stock` int(11) NOT NULL DEFAULT '0',
    `pack_prix` decimal(10,2) NOT NULL,
    `pack_chemin_img` varchar(100) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`pack_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `packs`
  --
  
  LOCK TABLES `packs` WRITE;
  /*!40000 ALTER TABLE `packs` DISABLE KEYS */;
  INSERT INTO `packs` VALUES (1,'Pack Fun','Pour une fête réussie : une guirlande lumineuse, des ballons brillants métallisés, un pose-verre en plus, une enceinte portable étanche Bose©, une petite machine à fumée et une dose de parfum positivant.',1,20.00,'medias/img/packs/pack-fun.png',NULL,'2020-10-20 13:49:22'),(2,'Pack Romance','Sortez-lui le grand jeu avec ce pack romantique comprenant : des pétales de   rose en soie, des ballons en forme de coeur, une lumière tamisée, un spa parfumé « Love ».',1,20.00,'medias/img/packs/pack-love.png',NULL,NULL);
  /*!40000 ALTER TABLE `packs` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `parametres`
  --
  
  DROP TABLE IF EXISTS `parametres`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `parametres` (
    `parametre_id` int(11) NOT NULL AUTO_INCREMENT,
    `parametre_libelle` varchar(110) NOT NULL,
    `parametre_value` text,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`parametre_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `parametres`
  --
  
  LOCK TABLES `parametres` WRITE;
  /*!40000 ALTER TABLE `parametres` DISABLE KEYS */;
  INSERT INTO `parametres` VALUES (1,'maintenance','0','2021-01-31 21:26:51','2021-01-31 22:55:02'),(2,'maintenance_message','Bonjour, une mise à jour du site est en cours. \r\n<br>Nous allons revenir dans pas longtemps !','2021-01-31 21:26:51','2021-01-31 22:55:02');
  /*!40000 ALTER TABLE `parametres` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `promos`
  --
  
  DROP TABLE IF EXISTS `promos`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `promos` (
    `promo_id` int(5) NOT NULL AUTO_INCREMENT,
    `promo_libelle` varchar(25) NOT NULL,
    `promo_valeur` int(5) NOT NULL,
    `promo_date_debut` date DEFAULT NULL,
    `promo_date_fin` date DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`promo_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `promos`
  --
  
  LOCK TABLES `promos` WRITE;
  /*!40000 ALTER TABLE `promos` DISABLE KEYS */;
  INSERT INTO `promos` VALUES (1,'MONTEV2020',10,'2020-11-01',NULL,NULL,NULL),(2,'COPAIN2020',15,'2020-11-01','2020-12-31',NULL,'2020-10-22 14:45:02'),(3,'LGM2020',15,'2020-11-01','2021-05-31',NULL,'2021-02-11 10:59:33'),(4,'NEW2020',10,'2020-11-03','2021-01-31','2020-11-03 16:14:36','2020-11-03 16:14:36'),(5,'BLACKFRIDAY',15,'2020-11-27','2020-11-30','2020-11-27 12:04:46','2020-11-27 12:04:46');
  /*!40000 ALTER TABLE `promos` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `ranks`
  --
  
  DROP TABLE IF EXISTS `ranks`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `ranks` (
    `rank_id` int(11) NOT NULL AUTO_INCREMENT,
    `rank_libelle` varchar(100) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`rank_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `ranks`
  --
  
  LOCK TABLES `ranks` WRITE;
  /*!40000 ALTER TABLE `ranks` DISABLE KEYS */;
  INSERT INTO `ranks` VALUES (1,'Administrateur',NULL,NULL),(2,'Client',NULL,NULL);
  /*!40000 ALTER TABLE `ranks` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `reservations`
  --
  
  DROP TABLE IF EXISTS `reservations`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `reservations` (
    `reservation_id` int(11) NOT NULL AUTO_INCREMENT,
    `reservation_active` int(1) NOT NULL DEFAULT '0',
    `reservation_date_debut` date NOT NULL,
    `reservation_heure_install` time DEFAULT NULL,
    `reservation_date_fin` date NOT NULL,
    `reservation_heure_desinstall` time DEFAULT NULL,
    `reservation_creneau` varchar(50) DEFAULT NULL,
    `reservation_emplacement` varchar(100) DEFAULT NULL,
    `reservation_rue` varchar(100) DEFAULT NULL,
    `reservation_cp` varchar(5) DEFAULT NULL,
    `reservation_ville` varchar(100) DEFAULT NULL,
    `reservation_complement` varchar(100) DEFAULT NULL,
    `reservation_departement` varchar(100) DEFAULT NULL,
    `reservation_type_logement` varchar(100) DEFAULT NULL,
    `reservation_remplissage` varchar(100) DEFAULT NULL,
    `reservation_spa_id` int(11) DEFAULT NULL,
    `reservation_spa_libelle` varchar(100) DEFAULT NULL,
    `reservation_prix` decimal(10,2) DEFAULT NULL,
    `reservation_pack_id` int(11) DEFAULT NULL,
    `reservation_prix_pack` decimal(10,2) DEFAULT NULL,
    `reservation_montant_total` decimal(10,2) DEFAULT NULL,
    `reservation_promo` varchar(20) DEFAULT NULL,
    `reservation_cadeau_id` int(11) DEFAULT NULL,
    `reservation_frais_km` decimal(10,2) NOT NULL DEFAULT '0.00',
    `reservation_moyen_paiement` varchar(100) DEFAULT NULL,
    `reservation_moyen_contact` varchar(100) DEFAULT NULL,
    `reservation_paye` int(1) NOT NULL DEFAULT '0',
    `reservation_payment_id` varchar(100) DEFAULT NULL,
    `reservation_notation_prestation` int(1) NOT NULL DEFAULT '0',
    `reservation_client_id` int(11) DEFAULT NULL,
    `reservation_email` varchar(100) DEFAULT NULL,
    `reservation_phone` varchar(10) DEFAULT NULL,
    `reservation_info_complementaires` text,
    `reservation_ascenseur` varchar(3) DEFAULT NULL,
    `reservation_etage` varchar(30) DEFAULT NULL,
    `reservation_source` varchar(50) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`reservation_id`),
    KEY `reservation_pack_id` (`reservation_pack_id`),
    KEY `reservation_spa_id` (`reservation_spa_id`),
    KEY `reservation_client_id` (`reservation_client_id`),
    KEY `reservation_cadeau_id` (`reservation_cadeau_id`),
    CONSTRAINT `reservations_ibfk_3` FOREIGN KEY (`reservation_pack_id`) REFERENCES `packs` (`pack_id`),
    CONSTRAINT `reservations_ibfk_4` FOREIGN KEY (`reservation_spa_id`) REFERENCES `spas` (`spa_id`),
    CONSTRAINT `reservations_ibfk_5` FOREIGN KEY (`reservation_client_id`) REFERENCES `clients` (`client_id`),
    CONSTRAINT `reservations_ibfk_6` FOREIGN KEY (`reservation_cadeau_id`) REFERENCES `cadeaux` (`cadeau_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=387 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `reservations`
  --
  
  LOCK TABLES `reservations` WRITE;
  /*!40000 ALTER TABLE `reservations` DISABLE KEYS */;
  INSERT INTO `reservations` VALUES (67,1,'2020-11-28',NULL,'2020-11-29',NULL,'Entre 8h et 12h','Interieur','12 rue d\'annet',NULL,'Thorigny-sur-Marne',NULL,'77','Maison',NULL,2,'Spa Navy 4 places',90.00,NULL,NULL,90.00,NULL,NULL,0.00,NULL,NULL,1,NULL,0,7,'alexandra.menny@hotmail.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(113,1,'2020-12-12',NULL,'2020-12-14',NULL,'Entre 8h et 12h','Interieur','31 chemin de la glacière',NULL,'Chessy',NULL,'77','Maison',NULL,2,'Spa Navy 4 places',90.00,NULL,NULL,90.00,NULL,NULL,0.00,NULL,NULL,1,NULL,0,8,'nomail@nomail.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(117,1,'2020-12-20',NULL,'2020-12-21',NULL,'Entre 12h et 15h','Intérieur','9 rue des binaches',NULL,'Montevrain',NULL,'77','Maison',NULL,1,'Spa Sahara 4 places',90.00,NULL,NULL,93.00,NULL,NULL,0.00,NULL,NULL,1,'pi_1HziKkGOBvkHIeeT7ZqWRxMA',0,9,'cf.morini@free.fr',NULL,NULL,NULL,NULL,NULL,'2020-12-18 12:43:31','2020-12-18 12:47:22'),(122,1,'2020-12-31',NULL,'2021-01-01',NULL,'Entre 12h et 15h','Intérieur','3 allée des tonnelles',NULL,'Lognes','Rdc porte droite','77','Appartement',NULL,1,'Spa Sahara 4 places',90.00,NULL,NULL,90.00,NULL,NULL,0.00,NULL,NULL,1,'pi_1I3UisGOBvkHIeeTXAcMSYlZ',0,10,'evaadoc77@gmail.com',NULL,NULL,NULL,NULL,NULL,'2020-12-28 22:58:35','2020-12-28 23:03:08'),(126,1,'2021-01-01',NULL,'2021-01-04',NULL,NULL,NULL,'59 rue Berthelot','77','Pomponne',NULL,'77','Maison',NULL,4,'Spa Baltik 6 places',120.00,NULL,NULL,150.00,NULL,NULL,0.00,NULL,NULL,1,NULL,0,1,'cnl.alexandre@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,'2021-02-11 13:25:36'),(227,1,'2021-02-14',NULL,'2021-02-15',NULL,'Entre 8h et 12h','Intérieur','3 rue Antoine de saint exupery','77','Coupvray',NULL,'77','Maison',NULL,1,'Sahara 4 places',90.00,2,20.00,99.00,'PromoInstagram',NULL,0.00,NULL,NULL,1,NULL,0,12,'celine.munoz@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(252,1,'2021-01-22',NULL,'2021-01-24',NULL,'Entre 12h et 15h','Intérieur','3 rue de l’arcade',NULL,'Lagny sur Marne','2eme étage avec ascenseur','77','Appartement',NULL,2,'Spa Navy 4 places',90.00,NULL,NULL,120.00,NULL,NULL,0.00,NULL,NULL,1,'pi_1IB3ZdGOBvkHIeeTYUeyq0tw',0,15,'marineluu2201@yahoo.fr',NULL,NULL,NULL,NULL,NULL,'2021-01-18 19:37:18','2021-01-18 19:40:38'),(265,1,'2021-02-21',NULL,'2021-02-22',NULL,'Entre 8h et 12h','Intérieur','12 rue du lievre',NULL,'Thorigny sur marne','12 rue du lievre','77','Maison',NULL,2,'Spa Navy 4 places',90.00,2,20.00,110.00,NULL,NULL,0.00,NULL,NULL,1,'pi_1IBNWiGOBvkHIeeTc5eRoAYR',0,16,'guycho974@gmail.com',NULL,NULL,NULL,NULL,NULL,'2021-01-19 16:57:01','2021-01-19 16:59:16'),(272,1,'2021-02-06',NULL,'2021-02-07',NULL,'Entre 8h et 12h','Intérieur','16 rue du 8 mai 1945',NULL,'Esbly',NULL,'77','Maison',NULL,5,'Spa Carbone 6 places',160.00,NULL,NULL,160.00,NULL,NULL,0.00,NULL,NULL,1,'pi_1IBfZwGOBvkHIeeTPsyxoL9T',0,17,'stephaniechascomoreira@gmail.com',NULL,NULL,NULL,NULL,NULL,'2021-01-20 12:12:49','2021-01-20 12:14:52'),(273,1,'2020-12-31',NULL,'2021-01-01',NULL,'Entre 8h et 12h','Intérieur','31 rue Louis Braille',NULL,'Chalifert',NULL,'77','Maison',NULL,5,'Spa Carbone 6 places',120.00,NULL,NULL,120.00,NULL,NULL,0.00,NULL,NULL,1,'',0,1,'',NULL,NULL,NULL,NULL,NULL,'2021-01-20 12:12:49','2021-01-20 12:14:52'),(274,1,'2021-01-09',NULL,'2021-01-10',NULL,'Entre 8h et 12h','Intérieur','11 cours de la gondoire',NULL,'Serris',NULL,'77','Maison',NULL,2,'Spa Navy 4 places',90.00,NULL,NULL,90.00,NULL,NULL,0.00,NULL,NULL,1,'',0,1,'',NULL,NULL,NULL,NULL,NULL,'2021-01-20 12:12:49','2021-01-20 12:14:52'),(276,1,'2021-01-23',NULL,'2021-01-24',NULL,'Entre 8h et 12h','Intérieur','6 rue du gripet',NULL,'Magny-le-Hongre',NULL,'77','Maison',NULL,1,'Spa Sahara 4 places',90.00,NULL,NULL,90.00,NULL,NULL,0.00,NULL,NULL,1,'',0,1,'',NULL,NULL,NULL,NULL,NULL,'2021-01-20 12:12:49','2021-01-20 12:14:52'),(281,1,'2021-01-30',NULL,'2021-01-31',NULL,'Entre 8h et 12h','Intérieur',NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,'Spa Baltik 4 places',90.00,NULL,NULL,90.00,NULL,NULL,0.00,NULL,NULL,1,NULL,0,1,'Fanny Bobo',NULL,NULL,NULL,NULL,NULL,'2021-01-21 18:42:19','2021-01-21 18:42:19'),(290,1,'2021-01-30',NULL,'2021-01-31',NULL,'Entre 8h et 12h','Intérieur','15 ALLEE DES FENAISONS',NULL,'Chanteloup-en-Brie',NULL,'77','Maison',NULL,1,'Spa Sahara 4 places',90.00,NULL,NULL,90.00,NULL,NULL,0.00,NULL,NULL,1,'pi_1ICk2uGOBvkHIeeTxeNYl4BO',0,22,'stephanie.tesooukian@gmail.com',NULL,NULL,NULL,NULL,NULL,'2021-01-23 11:11:25','2021-01-23 11:14:48'),(295,1,'2021-02-13',NULL,'2021-02-14',NULL,'Entre 8h et 12h','Intérieur','9 rue du bois de la fontaine',NULL,'Vaires-sur-Marne','9 rue du bois de la fontaine','77','Maison',NULL,3,'Spa Baltik 4 places',90.00,2,20.00,110.00,NULL,NULL,0.00,NULL,NULL,1,'pi_1ID3mnGOBvkHIeeTDho8hYCl',0,23,'ludivinepierre@live.fr',NULL,NULL,NULL,NULL,NULL,'2021-01-24 08:17:05','2021-01-24 08:17:55'),(307,1,'2021-02-06',NULL,'2021-02-07',NULL,'Entre 8h et 12h','Intérieur','52 Boucle Belle Josephine',NULL,'Magny-le-Hongre',NULL,'77','Maison',NULL,2,'Spa Navy 4 places',90.00,NULL,NULL,90.00,NULL,NULL,0.00,NULL,NULL,1,'pi_1IEtIpGOBvkHIeeTUjCpTzp2',0,24,'gouleret.christelle@gmail.com',NULL,NULL,NULL,NULL,NULL,'2021-01-29 08:08:44','2021-01-29 09:31:16'),(316,1,'2021-02-06',NULL,'2021-02-07',NULL,'Entre 8h et 12h','Intérieur','3 rue de la vallée',NULL,'Collegien','Interphone ; Douraguia','77','Maison',NULL,1,'Spa Sahara 4 places',90.00,NULL,NULL,90.00,NULL,NULL,0.00,NULL,NULL,1,'pi_1IG8R7GOBvkHIeeT7GOWQX6E',0,25,'jennifer.douraguia@gmail.com',NULL,NULL,NULL,NULL,NULL,'2021-02-01 19:50:38','2021-02-01 19:53:27'),(317,1,'2021-02-06',NULL,'2021-02-07',NULL,NULL,NULL,'','77','Ferrieres-en-Brie',NULL,'77',NULL,NULL,1,'Spa Sahara 4 Places',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,1,NULL,0,26,'vincentdu77600@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(318,1,'2021-02-05',NULL,'2021-02-06',NULL,NULL,NULL,'23 rue saint denis','77700','Coupvray',NULL,NULL,NULL,NULL,3,'Spa Baltik 4 places',110.00,NULL,NULL,110.00,NULL,NULL,0.00,NULL,NULL,1,NULL,0,27,'fouchythomas@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(319,1,'2021-02-13',NULL,'2021-02-14',NULL,NULL,NULL,'9 rue de Torcy','77','Chelles',NULL,'77',NULL,NULL,4,'Spa Baltik 6 places',120.00,NULL,NULL,120.00,NULL,NULL,0.00,NULL,NULL,1,NULL,0,28,'claudie.87@hotmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(333,1,'2021-02-16',NULL,'2021-02-17',NULL,'Entre 15h et 20h','Intérieur','6 rue de l\'orangerie',NULL,'TORCY','3 ème étage code 23081','77','Appartement',NULL,2,'Spa Navy 4 places',90.00,2,20.00,112.00,NULL,NULL,0.00,NULL,NULL,1,'pi_1IGmXlGOBvkHIeeTUjOmI3k5',0,29,'Nicow1816@gmail.com',NULL,NULL,NULL,NULL,NULL,'2021-02-03 14:40:51','2021-02-03 14:41:48'),(335,1,'2021-02-17',NULL,'2021-02-18',NULL,'Entre 8h et 12h','Intérieur','6 rue d\'Ariane',NULL,'Chessy','codes A2910, B1506, C21','77','Appartement',NULL,2,'Spa Navy 4 places',90.00,NULL,NULL,90.00,NULL,NULL,0.00,NULL,NULL,1,'pi_1IGn9QGOBvkHIeeTvwgt7WYF',0,30,'marisabrandi235@gmail.com',NULL,NULL,NULL,NULL,NULL,'2021-02-03 15:12:48','2021-02-03 15:22:49'),(337,1,'2021-02-20',NULL,'2021-02-21',NULL,'10h','Intérieur','160 rue de malnoue','77','Noisy-le-Grand','1er étage','77',NULL,NULL,2,'Spa Navy 4 places',90.00,2,10.00,NULL,NULL,NULL,5.00,NULL,NULL,1,NULL,0,31,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(358,1,'2021-02-26',NULL,'2021-03-01',NULL,'12h','Intérieur','59 avenue Francois Mittérand','77144','Montévrain','4e étage','77','Appartement',NULL,2,'Spa Navy 4 places',150.00,NULL,NULL,150.00,NULL,NULL,0.00,NULL,NULL,1,NULL,0,33,'adeline.barthe20@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(359,1,'2021-02-13',NULL,'2021-02-14',NULL,'9h30','Intérieur','2 impasse du grand clos','77','Villeneuve Saint-Denis',NULL,'77','Maison',NULL,NULL,NULL,120.00,NULL,NULL,120.00,NULL,NULL,0.00,NULL,NULL,1,NULL,0,34,'madi_cool@hotmail.fr',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(360,1,'2021-02-13',NULL,'2021-02-14',NULL,'13h30','Intérieur','25 rue des scandinaves','77','Serris',NULL,'77','Appartement résidence',NULL,NULL,NULL,90.00,2,NULL,120.00,NULL,NULL,0.00,NULL,NULL,1,NULL,0,35,'msylvie77@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(361,1,'2021-02-20',NULL,'2021-02-21',NULL,NULL,'Intérieur','40 rue de la brosse','77','Coutevroult',NULL,NULL,'Maison',NULL,NULL,NULL,90.00,NULL,NULL,90.00,NULL,NULL,0.00,NULL,NULL,1,NULL,0,36,'xaviercouttelle@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(362,1,'2021-02-16',NULL,'2021-02-17',NULL,NULL,NULL,'31 rue jean Mermoz','77','Claye-Souilly',NULL,'77','Maison',NULL,3,'Spa Baltik 4 places',90.00,2,30.00,120.00,NULL,NULL,0.00,NULL,NULL,1,NULL,0,38,'benjamin.beaupre@laposte.net',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(363,1,'2021-02-23',NULL,'2021-02-24',NULL,'12h',NULL,'5 chemin de la bergerie','77515','Hautefeuille',NULL,'77','Maison',NULL,2,'Spa Navy 4 places',90.00,NULL,NULL,90.00,NULL,NULL,0.00,NULL,NULL,1,NULL,0,39,'valerie.gowry@outlook.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(374,1,'2021-03-18','09:00:00','2021-03-21','09:00:00',NULL,'Extérieur','11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77','Appartement','Jet d’eau extérieur',2,'Spa Navy 4 pers.',90.00,1,20.00,205.00,NULL,NULL,0.00,NULL,NULL,1,'pi_1IUycuGOBvkHIeeTDIpYGxrF',0,46,'jerem-lem@hotmail.fr','0631727083',NULL,NULL,NULL,NULL,'2021-03-14 18:24:47','2021-03-14 18:25:43'),(376,1,'2021-03-25','16:00:00','2021-03-26','16:00:00',NULL,'Extérieur','11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77','Appartement','Jet d’eau extérieur',1,'Spa Sahara 4 pers.',90.00,2,20.00,115.00,NULL,NULL,0.00,'Stripe',NULL,1,'pi_1IUyzTGOBvkHIeeTLZn4IgBz',0,48,'jerem-lem@hotmail.fr','0631727083',NULL,'Oui','Rez-de-chaussé','Eau collective','2021-03-14 18:45:34','2021-03-14 18:51:16'),(378,0,'2021-03-22',NULL,'2021-03-23',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'Spa Sahara 4 pers.',90.00,1,20.00,115.00,NULL,NULL,0.00,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-03-17 22:34:04','2021-03-17 22:34:04'),(379,0,'2021-03-22','09:00:00','2021-03-23','09:00:00',NULL,'Extérieur','11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77','Appartement','Jet d’eau extérieur',1,'Spa Sahara 4 pers.',90.00,1,20.00,125.00,NULL,NULL,0.00,NULL,NULL,0,'pi_1IWKEwGOBvkHIeeT46l3Yrw2',0,53,'jerem-lem@hotmail.fr','0631727083',NULL,'Oui','Rez-de-chaussé','Eau collective','2021-03-18 10:50:47','2021-03-18 11:42:11'),(380,0,'2021-03-29','10:00:00','2021-03-30','10:00:00',NULL,'Extérieur','11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77','Appartement','Jet d’eau extérieur',1,'Spa Sahara 4 pers.',90.00,1,20.00,135.00,NULL,NULL,0.00,NULL,NULL,0,'pi_1IWKPvGOBvkHIeeTsLZIW7aa',0,54,'jerem-lem@hotmail.fr','0631727083',NULL,'Oui','Rez-de-chaussé','Eau collective','2021-03-18 11:47:14','2021-03-18 11:53:32'),(381,1,'2021-03-31','14:00:00','2021-04-01','14:00:00',NULL,'Extérieur','2350 route de Bourideys','40430','Sore',NULL,'77','Appartement','Jet d’eau extérieur',2,'Spa Navy 4 pers.',90.00,2,20.00,145.00,NULL,NULL,30.00,'Stripe',NULL,1,'pi_1IWKVdGOBvkHIeeTAeXSzgB8',0,55,'jerem-lem@hotmail.fr','0631727083',NULL,'Oui','Rez-de-chaussé','Eau collective','2021-03-18 11:56:18','2021-03-18 12:00:15'),(382,1,'2021-04-15','14:00:00','2021-04-16','14:00:00',NULL,'Extérieur','2350 route de Bourideys','40430','Sore',NULL,'77','Maison','Jet d’eau extérieur',2,'Spa Navy 4 pers.',90.00,2,20.00,145.00,NULL,NULL,30.00,'Stripe',NULL,1,'pi_1IWKaSGOBvkHIeeTpQeUfYqy',0,56,'jerem-lem@hotmail.fr','0631727083',NULL,NULL,NULL,'À préciser','2021-03-18 12:02:05','2021-03-18 12:04:38'),(383,1,'2021-04-28','16:00:00','2021-04-29','16:00:00',NULL,'Extérieur','11 rue Pablo Neruda','77200','Torcy','Interphone au nom de SKYBYK','77','Appartement','Jet d’eau extérieur',2,'Spa Navy 4 pers.',90.00,1,20.00,143.00,NULL,NULL,0.00,'Stripe',NULL,1,'pi_1IWMe8GOBvkHIeeTyLsBpQXp',0,57,'jerem-lem@hotmail.fr','0631727083',NULL,'Oui','Rez-de-chaussé','Eau collective','2021-03-18 14:13:16','2021-03-18 14:16:39'),(384,0,'2021-04-19',NULL,'2021-04-21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'Spa Sahara 4 pers.',90.00,1,20.00,140.00,NULL,NULL,0.00,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-03-18 14:34:16','2021-03-18 14:34:16'),(385,0,'2021-04-23',NULL,'2021-04-24',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'Spa Sahara 4 pers.',90.00,1,20.00,112.00,NULL,NULL,0.00,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-03-18 18:45:32','2021-03-18 18:45:32'),(386,0,'2021-04-27',NULL,'2021-04-28',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'Spa Sahara 4 pers.',90.00,NULL,NULL,90.00,NULL,NULL,0.00,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-04-25 09:46:07','2021-04-25 09:46:07');
  /*!40000 ALTER TABLE `reservations` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `reservations_accessoires`
  --
  
  DROP TABLE IF EXISTS `reservations_accessoires`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `reservations_accessoires` (
    `ra_id` int(11) NOT NULL AUTO_INCREMENT,
    `ra_reservation_id` int(11) NOT NULL,
    `ra_accessoire_id` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`ra_id`),
    KEY `ra_accessoire_id` (`ra_accessoire_id`),
    KEY `ra_reservation_id` (`ra_reservation_id`,`ra_accessoire_id`),
    CONSTRAINT `reservations_accessoires_ibfk_1` FOREIGN KEY (`ra_reservation_id`) REFERENCES `reservations` (`reservation_id`),
    CONSTRAINT `reservations_accessoires_ibfk_2` FOREIGN KEY (`ra_accessoire_id`) REFERENCES `accessoires` (`accessoire_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=182 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `reservations_accessoires`
  --
  
  LOCK TABLES `reservations_accessoires` WRITE;
  /*!40000 ALTER TABLE `reservations_accessoires` DISABLE KEYS */;
  INSERT INTO `reservations_accessoires` VALUES (51,117,3,'2020-12-18 12:43:31','2020-12-18 12:43:31'),(120,333,7,'2021-02-03 14:40:51','2021-02-03 14:40:51'),(150,374,5,'2021-03-14 18:24:47','2021-03-14 18:24:47'),(151,374,1,'2021-03-14 18:24:47','2021-03-14 18:24:47'),(152,374,7,'2021-03-14 18:24:47','2021-03-14 18:24:47'),(153,374,6,'2021-03-14 18:24:47','2021-03-14 18:24:47'),(154,374,8,'2021-03-14 18:24:47','2021-03-14 18:24:47'),(155,374,2,'2021-03-14 18:24:47','2021-03-14 18:24:47'),(162,376,5,'2021-03-14 18:45:34','2021-03-14 18:45:34'),(163,376,7,'2021-03-14 18:45:34','2021-03-14 18:45:34'),(164,378,5,'2021-03-17 22:34:04','2021-03-17 22:34:04'),(165,378,7,'2021-03-17 22:34:04','2021-03-17 22:34:04'),(166,379,5,'2021-03-18 10:50:47','2021-03-18 10:50:47'),(167,379,7,'2021-03-18 10:50:47','2021-03-18 10:50:47'),(168,380,1,'2021-03-18 11:47:14','2021-03-18 11:47:14'),(169,380,8,'2021-03-18 11:47:14','2021-03-18 11:47:14'),(170,380,2,'2021-03-18 11:47:14','2021-03-18 11:47:14'),(171,381,5,'2021-03-18 11:56:18','2021-03-18 11:56:18'),(172,381,7,'2021-03-18 11:56:18','2021-03-18 11:56:18'),(173,382,5,'2021-03-18 12:02:05','2021-03-18 12:02:05'),(174,382,7,'2021-03-18 12:02:05','2021-03-18 12:02:05'),(175,383,5,'2021-03-18 14:13:16','2021-03-18 14:13:16'),(176,383,4,'2021-03-18 14:13:16','2021-03-18 14:13:16'),(177,383,1,'2021-03-18 14:13:16','2021-03-18 14:13:16'),(178,383,7,'2021-03-18 14:13:16','2021-03-18 14:13:16'),(179,383,8,'2021-03-18 14:13:16','2021-03-18 14:13:16'),(180,383,2,'2021-03-18 14:13:16','2021-03-18 14:13:16'),(181,385,7,'2021-03-18 18:45:32','2021-03-18 18:45:32');
  /*!40000 ALTER TABLE `reservations_accessoires` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `spas`
  --
  
  DROP TABLE IF EXISTS `spas`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `spas` (
    `spa_id` int(11) NOT NULL AUTO_INCREMENT,
    `spa_stock` int(11) NOT NULL DEFAULT '0',
    `spa_libelle` varchar(100) NOT NULL,
    `spa_nb_place` int(11) NOT NULL DEFAULT '0',
    `spa_desc` text,
    `spa_color` varchar(10) NOT NULL,
    `spa_chemin_img` varchar(100) DEFAULT NULL,
    `spa_prix` decimal(10,2) NOT NULL DEFAULT '0.00',
    `spa_prix_jour_supp` decimal(10,2) NOT NULL DEFAULT '0.00',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`spa_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `spas`
  --
  
  LOCK TABLES `spas` WRITE;
  /*!40000 ALTER TABLE `spas` DISABLE KEYS */;
  INSERT INTO `spas` VALUES (1,2,'Spa Sahara',4,'Couleur beige sable<br>120 diffuseurs de bulles','FFB300','medias/img/spas/spa-sahara-4.png',90.00,30.00,'2020-10-20 14:07:33','2021-01-21 14:27:07'),(2,2,'Spa Navy',4,'Couleur bleu nuit<br>140 diffuseurs de bulles','29B6F6','medias/img/spas/spa-navy-4.png',90.00,30.00,'2020-10-20 14:07:33','2021-01-21 14:27:23'),(3,1,'Spa Baltik',4,'Couleur gris boisé<br>140 diffuseurs de bulles','039BE5','medias/img/spas/spa-baltik-4.png',90.00,30.00,'2020-10-20 14:07:33','2021-01-21 14:26:47'),(4,0,'Spa Baltik',6,'Octogonal et gris boisé<br>170 diffuseurs de bulles','546e7a','medias/img/spas/spa-baltik-6.png',120.00,30.00,'2020-10-20 14:07:33','2021-01-21 14:26:42'),(5,1,'Spa Carbone',6,'Octogonal noir et blanc<br>140 diffuseurs et 6 jets massants','263238','medias/img/spas/spa-carbone-6.png',150.00,40.00,'2020-10-20 14:07:33','2020-10-30 22:54:10');
  /*!40000 ALTER TABLE `spas` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `users`
  --
  
  DROP TABLE IF EXISTS `users`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `users` (
    `user_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_login` varchar(100) NOT NULL,
    `user_password` varchar(100) NOT NULL,
    `user_rank_id` int(11) NOT NULL,
    `user_last_connection` datetime DEFAULT NULL,
    `remember_token` varchar(100) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`user_id`),
    KEY `user_rank_id` (`user_rank_id`),
    CONSTRAINT `users_ibfk_1` FOREIGN KEY (`user_rank_id`) REFERENCES `ranks` (`rank_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `users`
  --
  
  LOCK TABLES `users` WRITE;
  /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  INSERT INTO `users` VALUES (1,'jer.lemont@gmail.com','8feddb3014a070097df081ed63f1ca7c2cae3499',1,NULL,NULL,'2020-09-19 22:00:00',NULL),(2,'jlemontCustomer','8feddb3014a070097df081ed63f1ca7c2cae3499',2,NULL,NULL,'2020-09-20 22:00:00',NULL),(3,'Alexandre','a64df9f267517d5caddc282637e244bd0688dc3a',1,NULL,NULL,NULL,NULL),(4,'cnl.alexandre@gmail.com','afb847c7a95b2f235f302e856e9181e52b50fdeb',2,NULL,NULL,'2020-10-30 19:46:00','2020-10-30 19:46:00'),(5,'test@test.fr','8587f16632db25b07f69606d364e11af6ae75828',2,NULL,NULL,'2020-10-30 23:30:16','2020-10-30 23:30:16'),(6,'alessandra.caillaud@yahoo.com','a64df9f267517d5caddc282637e244bd0688dc3a',1,NULL,'2e3b73d331fb10a437f96e0b6cee5140','2020-10-31 11:50:01','2021-02-10 13:42:25'),(7,'Greg','a64df9f267517d5caddc282637e244bd0688dc3a',1,NULL,NULL,NULL,'2020-11-20 00:11:02'),(8,'cnl.sophie@gmail.com','e6bb1e4796d27e3ec853ff3adf5b357713a6bf3f',2,NULL,NULL,'2020-11-04 17:29:53','2020-11-04 17:29:53'),(9,'cf.morini@free.fr','bcb457135fb4ae9644ff51bcf41ad58cc447fea1',2,NULL,NULL,'2020-12-18 12:45:21','2020-12-18 12:45:21'),(10,'evaadoc77@gmail.com','f4d4282c52b746d0f8f394a5f973394210a62840',2,NULL,NULL,'2020-12-28 23:01:53','2020-12-28 23:01:53'),(11,'ffrot@hotmail.com','b8556707efc09c405658b479dda62082d294c73b',2,NULL,NULL,'2021-01-16 18:20:48','2021-01-16 18:20:48'),(12,'celine.munoz@gmail.com','ca6f3c7665f6dc6dc86986b94fd627f38a7fe1fc',2,NULL,NULL,'2021-01-16 22:26:24','2021-01-16 22:26:24'),(13,'renaud.vibet@laposte.net','1498174261b3941355e1c0d6fe965d11299c5536',2,NULL,NULL,'2021-01-17 08:14:24','2021-01-17 08:14:24'),(14,'sbordet@orange.fr','3e661d8b3af2560345f9306751be6e08bf91aa6d',2,NULL,NULL,'2021-01-18 11:57:01','2021-01-18 11:57:01'),(15,'marineluu2201@yahoo.fr','e01da5a03dd9cdcfec8d7e594e41d22c73d96d1d',2,NULL,NULL,'2021-01-18 19:39:36','2021-01-18 19:39:36'),(16,'guycho974@gmail.com','7158d8105e2250645c09233e5255a9a9e827ed84',2,NULL,NULL,'2021-01-19 15:44:17','2021-01-19 15:44:17'),(17,'stephaniechascomoreira@gmail.com','b4574526faeec7edab13575bba99d15b6eb6ec74',2,NULL,NULL,'2021-01-20 12:14:27','2021-01-20 12:14:27'),(18,'claudie.87@hotmail.com','1d203cf208cb3abae08d6cacde5eb3cab4014ba2',2,NULL,NULL,'2021-01-23 09:00:40','2021-01-23 09:00:40'),(19,'stephanie.tesooukian@gmail.com','1dc23c3b35997c9498c7904369e022770a289476',2,NULL,NULL,'2021-01-23 11:12:44','2021-01-23 11:12:44'),(20,'ludivinepierre@live.fr','27b6f7d5d2a520ce152aa1d6fdc9506ef9607564',2,NULL,NULL,'2021-01-24 08:13:26','2021-01-24 08:13:26'),(21,'gouleret.christelle@gmail.com','6436e15b101a6bc3c23a3919ac9a1c5db9642340',2,NULL,NULL,'2021-01-29 09:30:05','2021-01-29 09:30:05'),(22,'jennifer.douraguia@gmail.com','8c19b3cae9909f6073c78e029157ffa948fcce76',2,NULL,NULL,'2021-02-01 19:51:47','2021-02-01 19:51:47'),(23,'Nicow1816@gmail.com','5ac0383764d9758c5040bea4864e9aee169a8d67',2,NULL,NULL,'2021-02-03 14:41:20','2021-02-03 14:41:20'),(24,'marisabrandi235@gmail.com','5b0e658e3d763b389ae410fc74559ad0e35e23f3',2,NULL,NULL,'2021-02-03 15:20:15','2021-02-03 15:20:15'),(26,'adeline.barthe20@gmail.com','5b0e658e3d763b389ae410fc74559ad0e35e23f3',2,NULL,NULL,'2021-02-03 15:20:15','2021-02-03 15:20:15'),(27,'madi_cool77@hotmail.fr','5b0e658e3d763b389ae410fc74559ad0e35e23f3',2,NULL,NULL,'2021-02-03 15:20:15','2021-02-03 15:20:15'),(28,'msylvie77@gmail.com','5b0e658e3d763b389ae410fc74559ad0e35e23f3',2,NULL,NULL,'2021-02-10 15:20:15','2021-02-10 15:20:15'),(29,'xaviercouttelle@gmail.com','5b0e658e3d763b389ae410fc74559ad0e35e23f3',2,NULL,NULL,'2021-02-10 15:20:15','2021-02-10 15:20:15'),(30,'benjamin.beaupre@laposte.net','5b0e658e3d763b389ae410fc74559ad0e35e23f3',2,NULL,NULL,'2021-02-10 15:20:15','2021-02-10 15:20:15'),(31,'valerie.gowry@outlook.com','5b0e658e3d763b389ae410fc74559ad0e35e23f3',2,NULL,NULL,'2021-02-10 15:20:15','2021-02-10 15:20:15'),(32,'cejzinczi@fzjno.fr','adb3d664e0c6e6cb56746243d5c741f7792e5ea0',2,NULL,NULL,'2021-02-11 13:43:25','2021-02-11 13:43:25'),(33,'cziezbci@vzodzo.fr','0a6218928cb559896ad2b24dd6001f06cc8c609d',2,NULL,NULL,'2021-02-11 13:49:55','2021-02-11 13:49:55'),(34,'céeijn.cezo@vez.fr','aebd4949b8e10daa3250239cc0bcf05aa7ad8ac7',2,NULL,NULL,'2021-02-11 13:53:58','2021-02-11 13:53:58'),(35,'jerem-lem@hotmail.fr','7e40ab4efc53531198273702ca22242b0ba388fe',2,NULL,NULL,'2021-03-14 17:50:25','2021-03-14 17:50:25');
  /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2021-05-31 17:14:06
  