--
-- Host: 51.91.10.129    Database: villa_gonatouki
-- ------------------------------------------------------


--
-- Table structure for table `accommodation`
--

CREATE TABLE `accommodation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rental_price_type_id` int(11) DEFAULT NULL,
  `real_estate_agent_id` int(11) DEFAULT NULL,
  `person_id` int(11) DEFAULT NULL,
  `primary_image_id` int(11) DEFAULT NULL,
  `secondary_image_id` int(11) DEFAULT NULL,
  `place_id` int(11) DEFAULT NULL,
  `label_id` int(11) DEFAULT NULL,
  `nature_id` int(11) DEFAULT NULL,
  `type_id` int(11) DEFAULT NULL,
  `duration_id` int(11) DEFAULT NULL,
  `gallery_id` int(11) DEFAULT NULL,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `headline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `geo` varchar(160) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(160) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `informations` longtext COLLATE utf8mb4_unicode_ci,
  `urban_taxes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `old_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `union_charges` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `turnover` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `our_opinion` longtext COLLATE utf8mb4_unicode_ci,
  `regenerate_reference` tinyint(1) NOT NULL,
  `regenerate_pdf` tinyint(1) NOT NULL,
  `hide_stamp` tinyint(1) NOT NULL,
  `regenerate_format` tinyint(1) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alternative_headline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `push_forward` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` longtext COLLATE utf8mb4_unicode_ci,
  `text_resume` longtext COLLATE utf8mb4_unicode_ci,
  `date_published` date DEFAULT NULL,
  `expire` date DEFAULT NULL,
  `meta_title` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(160) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pdf_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `numberOfPieces` smallint(6) DEFAULT NULL,
  `numberOfRooms` smallint(6) NOT NULL,
  `numberOfBathrooms` smallint(6) DEFAULT NULL,
  `maximumOccupants` smallint(6) DEFAULT NULL,
  `price` double NOT NULL,
  `labelPrice` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `floorSize` smallint(6) NOT NULL,
  `area_size` smallint(6) DEFAULT NULL,
  `area_terrace` smallint(6) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_2D385412989D9B62` (`slug`),
  KEY `IDX_2D385412F6E61FED` (`rental_price_type_id`),
  KEY `IDX_2D3854125CEDDA0C` (`real_estate_agent_id`),
  KEY `IDX_2D385412217BBB47` (`person_id`),
  KEY `IDX_2D3854121CDA489C` (`primary_image_id`),
  KEY `IDX_2D385412A604F92B` (`secondary_image_id`),
  KEY `IDX_2D385412DA6A219` (`place_id`),
  KEY `IDX_2D38541233B92F39` (`label_id`),
  KEY `IDX_2D3854123BCB2E4B` (`nature_id`),
  KEY `IDX_2D385412C54C8C93` (`type_id`),
  KEY `IDX_2D38541237B987D8` (`duration_id`),
  KEY `IDX_2D3854124E7AF8F` (`gallery_id`),
  KEY `IDX_2D385412F987D8A8` (`user_created_id`),
  KEY `IDX_2D3854129828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_2D3854121CDA489C` FOREIGN KEY (`primary_image_id`) REFERENCES `media_object` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_2D385412217BBB47` FOREIGN KEY (`person_id`) REFERENCES `person` (`id`),
  CONSTRAINT `FK_2D38541233B92F39` FOREIGN KEY (`label_id`) REFERENCES `accommodation_label` (`id`),
  CONSTRAINT `FK_2D38541237B987D8` FOREIGN KEY (`duration_id`) REFERENCES `accommodation_location` (`id`),
  CONSTRAINT `FK_2D3854123BCB2E4B` FOREIGN KEY (`nature_id`) REFERENCES `accommodation_nature` (`id`),
  CONSTRAINT `FK_2D3854124E7AF8F` FOREIGN KEY (`gallery_id`) REFERENCES `gallery` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_2D3854125CEDDA0C` FOREIGN KEY (`real_estate_agent_id`) REFERENCES `real_estate_agent` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_2D3854129828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_2D385412A604F92B` FOREIGN KEY (`secondary_image_id`) REFERENCES `media_object` (`id`),
  CONSTRAINT `FK_2D385412C54C8C93` FOREIGN KEY (`type_id`) REFERENCES `accommodation_type` (`id`),
  CONSTRAINT `FK_2D385412DA6A219` FOREIGN KEY (`place_id`) REFERENCES `accommodation_place` (`id`),
  CONSTRAINT `FK_2D385412F6E61FED` FOREIGN KEY (`rental_price_type_id`) REFERENCES `rental_price_type` (`id`),
  CONSTRAINT `FK_2D385412F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accommodation`
--


--
-- Table structure for table `accommodation_amenity`
--

CREATE TABLE `accommodation_amenity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `withPicto` tinyint(1) DEFAULT NULL,
  `slugPicto` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_E7540D995E237E06` (`name`),
  KEY `IDX_E7540D99F987D8A8` (`user_created_id`),
  KEY `IDX_E7540D999828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_E7540D999828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_E7540D99F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accommodation_amenity`
--

INSERT INTO `accommodation_amenity` VALUES (1,NULL,NULL,1,'swimming-pool','2021-10-12 22:29:17','2021-10-12 22:29:47','piscine','Piscine'),(2,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','piscine-chauffee','Piscine chauffée'),(3,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','climatisation','Climatisation'),(4,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','climatisation-reversible','Climatisation reversible'),(5,NULL,NULL,1,'warehouse','2021-10-12 22:29:17','2021-10-12 22:29:47','garage','Garage'),(6,NULL,NULL,1,'hot-tub','2021-10-12 22:29:17','2021-10-12 22:29:47','jacuzzi','Jacuzzi'),(7,NULL,NULL,1,'wifi','2021-10-12 22:29:17','2021-10-12 22:29:47','wifi','Wifi'),(8,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','air-conditionne','Air conditionné'),(9,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','balcon','Balcon'),(10,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','room-service','Room service'),(11,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','salle-de-sport','Salle de sport'),(12,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','parking','Parking'),(13,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','alarme','Alarme'),(14,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','gardien','Gardien'),(15,NULL,NULL,1,'bath','2021-10-12 22:29:17','2021-10-12 22:29:47','salle-de-bain','Salle de bain'),(16,NULL,NULL,1,'fire','2021-10-12 22:29:17','2021-10-12 22:29:47','cheminee','Cheminée'),(17,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','terrasse','Terrasse'),(18,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','solarium','Solarium'),(19,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','ascenseur','Ascenseur'),(20,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','vue-sur-mer','Vue sur mer'),(21,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','hammam','Hammam'),(22,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','terrasse-attenante','Terrasse attenante'),(23,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','vue-degagee','Vue dégagée'),(24,NULL,NULL,0,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','exposition-sud','Exposition Sud');

--
-- Table structure for table `accommodation_detail`
--

CREATE TABLE `accommodation_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accommodation_id` int(11) DEFAULT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_7362DBB28F3692CD` (`accommodation_id`),
  CONSTRAINT `FK_7362DBB28F3692CD` FOREIGN KEY (`accommodation_id`) REFERENCES `accommodation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accommodation_detail`
--


--
-- Table structure for table `accommodation_label`
--

CREATE TABLE `accommodation_label` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_21873125E237E06` (`name`),
  KEY `IDX_2187312F987D8A8` (`user_created_id`),
  KEY `IDX_21873129828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_21873129828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_2187312F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accommodation_label`
--

INSERT INTO `accommodation_label` VALUES (1,NULL,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','exclusivite','Exclusivité'),(2,NULL,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','coup-de-coeur','Coup de coeur');

--
-- Table structure for table `accommodation_location`
--

CREATE TABLE `accommodation_location` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_3BAA6BD5E237E06` (`name`),
  KEY `IDX_3BAA6BDF987D8A8` (`user_created_id`),
  KEY `IDX_3BAA6BD9828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_3BAA6BD9828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_3BAA6BDF987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accommodation_location`
--

INSERT INTO `accommodation_location` VALUES (1,NULL,NULL,1,'2021-10-12 22:29:17','2021-10-12 22:29:47','longue-duree','Longue durée'),(2,NULL,NULL,1,'2021-10-12 22:29:17','2021-10-12 22:29:47','saisonniere','Saisonnière');

--
-- Table structure for table `accommodation_nature`
--

CREATE TABLE `accommodation_nature` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_ECBC26865E237E06` (`name`),
  KEY `IDX_ECBC2686727ACA70` (`parent_id`),
  KEY `IDX_ECBC2686F987D8A8` (`user_created_id`),
  KEY `IDX_ECBC26869828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_ECBC2686727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `accommodation_nature` (`id`),
  CONSTRAINT `FK_ECBC26869828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_ECBC2686F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accommodation_nature`
--

INSERT INTO `accommodation_nature` VALUES (1,NULL,NULL,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','location','Location'),(2,NULL,NULL,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','vente','Vente');

--
-- Table structure for table `accommodation_place`
--

CREATE TABLE `accommodation_place` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_78A270375E237E06` (`name`),
  KEY `IDX_78A27037F987D8A8` (`user_created_id`),
  KEY `IDX_78A270379828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_78A270379828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_78A27037F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accommodation_place`
--

INSERT INTO `accommodation_place` VALUES (1,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','medina','medina'),(2,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','nouvelle-ville','nouvelle-ville'),(3,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','golf-mogador','golf mogador'),(4,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','campagne','campagne'),(5,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','diabet','diabet'),(6,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','ghazoua','ghazoua'),(7,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','douar-larab','douar larab'),(8,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','sidi-kaouki','sidi kaouki'),(9,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','ida-ougourd','ida ougourd'),(10,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','hrarta','hrarta'),(11,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','bouzama','bouzama'),(12,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','aeroport','aeroport'),(13,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','had-draa','had draa'),(14,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','ounagha','ounagha'),(15,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','moulay-bouzarktoun','moulay bouzarktoun'),(16,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','laraich','laraich'),(17,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','chicht','chicht'),(18,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','route-de-marrakech','route de marrakech'),(19,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2021-10-12 22:29:17','2021-10-12 22:29:47','route-de-safi','route de safi');

--
-- Table structure for table `accommodation_type`
--

CREATE TABLE `accommodation_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_location` tinyint(1) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_85E695E25E237E06` (`name`),
  KEY `IDX_85E695E2F987D8A8` (`user_created_id`),
  KEY `IDX_85E695E29828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_85E695E29828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_85E695E2F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accommodation_type`
--

INSERT INTO `accommodation_type` VALUES (1,NULL,NULL,1,0,'2021-10-12 22:29:17','2021-10-12 22:29:47','appartement','appartement'),(2,NULL,NULL,1,0,'2021-10-12 22:29:17','2021-10-12 22:29:47','riad','riad'),(3,NULL,NULL,1,0,'2021-10-12 22:29:17','2021-10-12 22:29:47','maisons-dhotes','maisons d\'hotes'),(4,NULL,NULL,1,0,'2021-10-12 22:29:17','2021-10-12 22:29:47','villa-golf','villa golf'),(5,NULL,NULL,1,0,'2021-10-12 22:29:17','2021-10-12 22:29:47','maison-de-campagne','maison de campagne'),(6,NULL,NULL,1,0,'2021-10-12 22:29:17','2021-10-12 22:29:47','maison-de-ville','maison de ville'),(7,NULL,NULL,1,0,'2021-10-12 22:29:17','2021-10-12 22:29:47','terrain','terrain'),(8,NULL,NULL,1,0,'2021-10-12 22:29:17','2021-10-12 22:29:47','affaires-commerciales','affaires commerciales'),(9,NULL,NULL,1,0,'2021-10-12 22:29:17','2021-10-12 22:29:47','location-gerance','location gérance'),(10,NULL,NULL,1,0,'2021-10-12 22:29:17','2021-10-12 22:29:47','local-commercial','local commercial');

--
-- Table structure for table `accommodations_amenities`
--

CREATE TABLE `accommodations_amenities` (
  `accommodation_id` int(11) NOT NULL,
  `accommodation_amenity_id` int(11) NOT NULL,
  PRIMARY KEY (`accommodation_id`,`accommodation_amenity_id`),
  KEY `IDX_F8DE56778F3692CD` (`accommodation_id`),
  KEY `IDX_F8DE56774D2BAD08` (`accommodation_amenity_id`),
  CONSTRAINT `FK_F8DE56774D2BAD08` FOREIGN KEY (`accommodation_amenity_id`) REFERENCES `accommodation_amenity` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_F8DE56778F3692CD` FOREIGN KEY (`accommodation_id`) REFERENCES `accommodation` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accommodations_amenities`
--


--
-- Table structure for table `accommodations_pdfs`
--

CREATE TABLE `accommodations_pdfs` (
  `accommodation_id` int(11) NOT NULL,
  `document_object_id` int(11) NOT NULL,
  PRIMARY KEY (`accommodation_id`,`document_object_id`),
  KEY `IDX_DEFA66778F3692CD` (`accommodation_id`),
  KEY `IDX_DEFA667731157E8A` (`document_object_id`),
  CONSTRAINT `FK_DEFA667731157E8A` FOREIGN KEY (`document_object_id`) REFERENCES `document_object` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_DEFA66778F3692CD` FOREIGN KEY (`accommodation_id`) REFERENCES `accommodation` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accommodations_pdfs`
--


--
-- Table structure for table `accommodations_tags`
--

CREATE TABLE `accommodations_tags` (
  `accommodation_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY (`accommodation_id`,`tag_id`),
  KEY `IDX_4E48028A8F3692CD` (`accommodation_id`),
  KEY `IDX_4E48028ABAD26311` (`tag_id`),
  CONSTRAINT `FK_4E48028A8F3692CD` FOREIGN KEY (`accommodation_id`) REFERENCES `accommodation` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_4E48028ABAD26311` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accommodations_tags`
--


--
-- Table structure for table `accommodations_videos`
--

CREATE TABLE `accommodations_videos` (
  `accommodation_id` int(11) NOT NULL,
  `media_object_id` int(11) NOT NULL,
  PRIMARY KEY (`accommodation_id`,`media_object_id`),
  KEY `IDX_327480528F3692CD` (`accommodation_id`),
  KEY `IDX_3274805264DE5A5` (`media_object_id`),
  CONSTRAINT `FK_3274805264DE5A5` FOREIGN KEY (`media_object_id`) REFERENCES `media_object` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_327480528F3692CD` FOREIGN KEY (`accommodation_id`) REFERENCES `accommodation` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accommodations_videos`
--


--
-- Table structure for table `address`
--

CREATE TABLE `address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `postcode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `address`
--

INSERT INTO `address` VALUES (1,NULL,'Villa Gonatouki Tagaydrt','44000','El Ghazoua - Essaouira','Maroc','2021-10-12 22:29:17','2021-10-12 22:29:17');

--
-- Table structure for table `aggregate_offer`
--

CREATE TABLE `aggregate_offer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `high_price` double DEFAULT NULL,
  `low_price` double DEFAULT NULL,
  `offer_count` int(11) DEFAULT NULL,
  `add_on` double DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` double DEFAULT NULL,
  `price_currency` longtext COLLATE utf8mb4_unicode_ci,
  `availability_end` datetime DEFAULT NULL,
  `availability_start` datetime DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C4EFFDD5F987D8A8` (`user_created_id`),
  KEY `IDX_C4EFFDD59828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_C4EFFDD59828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_C4EFFDD5F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `aggregate_offer`
--

INSERT INTO `aggregate_offer` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,'Basse saison',72,NULL,'2021-06-30 00:00:00','2021-01-01 00:00:00','2021-10-12 22:32:35','2021-10-16 16:45:04'),(2,NULL,NULL,NULL,NULL,NULL,NULL,'Haute saison',72,NULL,'2021-12-31 00:00:00','2021-07-01 00:00:00','2021-10-12 22:32:35','2021-10-16 16:45:04'),(3,NULL,NULL,NULL,NULL,NULL,15,'Basse saison',86,NULL,'2021-06-30 00:00:00','2021-01-01 00:00:00','2021-10-12 22:32:36','2021-10-12 22:32:43'),(4,NULL,NULL,NULL,NULL,NULL,15,'Haute saison',86,NULL,'2021-12-31 00:00:00','2021-07-01 00:00:00','2021-10-12 22:32:36','2021-10-12 22:32:43'),(5,NULL,NULL,NULL,NULL,NULL,15,'Basse saison',107,NULL,'2021-06-30 00:00:00','2021-01-01 00:00:00','2021-10-12 22:32:37','2021-10-12 22:32:43'),(6,NULL,NULL,NULL,NULL,NULL,15,'Haute saison',107,NULL,'2021-12-31 00:00:00','2021-07-01 00:00:00','2021-10-12 22:32:37','2021-10-12 22:32:43'),(7,NULL,NULL,NULL,NULL,NULL,NULL,'Basse saison',107,NULL,'2021-06-30 00:00:00','2021-01-01 00:00:00','2021-10-12 22:32:38','2021-10-12 22:32:43'),(8,NULL,NULL,NULL,NULL,NULL,NULL,'Haute saison',107,NULL,'2021-12-31 00:00:00','2021-07-01 00:00:00','2021-10-12 22:32:38','2021-10-12 22:32:43'),(9,NULL,NULL,NULL,NULL,NULL,15,'Basse saison',152,NULL,'2021-06-30 00:00:00','2021-01-01 00:00:00','2021-10-12 22:32:39','2021-10-12 22:32:43'),(10,NULL,NULL,NULL,NULL,NULL,15,'Haute saison',152,NULL,'2021-12-31 00:00:00','2021-07-01 00:00:00','2021-10-12 22:32:39','2021-10-12 22:32:43'),(11,NULL,NULL,NULL,NULL,NULL,15,'Basse saison',205,NULL,'2021-06-30 00:00:00','2021-01-01 00:00:00','2021-10-12 22:32:40','2021-10-12 22:32:43'),(12,NULL,NULL,NULL,NULL,NULL,15,'Haute saison',205,NULL,'2021-12-31 00:00:00','2021-07-01 00:00:00','2021-10-12 22:32:40','2021-10-12 22:32:43'),(13,NULL,NULL,NULL,NULL,NULL,15,'Basse saison',939,NULL,'2021-06-30 00:00:00','2021-01-01 00:00:00','2021-10-12 22:32:42','2021-10-12 22:32:43'),(14,NULL,NULL,NULL,NULL,NULL,15,'Haute saison',939,NULL,'2021-12-31 00:00:00','2021-07-01 00:00:00','2021-10-12 22:32:42','2021-10-12 22:32:43'),(15,NULL,NULL,NULL,NULL,NULL,15,'Basse saison',1145,NULL,'2021-06-30 00:00:00','2021-01-01 00:00:00','2021-10-12 22:32:43','2021-10-16 19:14:22'),(16,NULL,NULL,NULL,NULL,NULL,15,'Haute saison',1145,NULL,'2021-12-31 00:00:00','2021-07-01 00:00:00','2021-10-12 22:32:43','2021-10-16 19:14:22'),(17,NULL,NULL,NULL,NULL,NULL,NULL,'Moyenne saison',79,NULL,'2021-11-13 15:44:00','2021-10-17 15:43:00','2021-10-16 16:45:04','2021-10-16 16:45:04');

--
-- Table structure for table `article`
--

CREATE TABLE `article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `primary_image_id` int(11) DEFAULT NULL,
  `secondary_image_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `gallery_id` int(11) DEFAULT NULL,
  `gallery_vertical_id` int(11) DEFAULT NULL,
  `media_id` int(11) DEFAULT NULL,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `article_body` longtext COLLATE utf8mb4_unicode_ci,
  `article_resume` longtext COLLATE utf8mb4_unicode_ci,
  `last_reviewed` date DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `blockquote` longtext COLLATE utf8mb4_unicode_ci,
  `blockquote_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `hide_stamp` tinyint(1) NOT NULL,
  `regenerate_format` tinyint(1) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `headline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alternative_headline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `push_forward` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` longtext COLLATE utf8mb4_unicode_ci,
  `text_resume` longtext COLLATE utf8mb4_unicode_ci,
  `date_published` date DEFAULT NULL,
  `expire` date DEFAULT NULL,
  `meta_title` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(160) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_23A0E66989D9B62` (`slug`),
  KEY `IDX_23A0E661CDA489C` (`primary_image_id`),
  KEY `IDX_23A0E66A604F92B` (`secondary_image_id`),
  KEY `IDX_23A0E6612469DE2` (`category_id`),
  KEY `IDX_23A0E664E7AF8F` (`gallery_id`),
  KEY `IDX_23A0E668971A533` (`gallery_vertical_id`),
  KEY `IDX_23A0E66EA9FDD75` (`media_id`),
  KEY `IDX_23A0E66F987D8A8` (`user_created_id`),
  KEY `IDX_23A0E669828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_23A0E6612469DE2` FOREIGN KEY (`category_id`) REFERENCES `tag` (`id`),
  CONSTRAINT `FK_23A0E661CDA489C` FOREIGN KEY (`primary_image_id`) REFERENCES `media_object` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_23A0E664E7AF8F` FOREIGN KEY (`gallery_id`) REFERENCES `gallery` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_23A0E668971A533` FOREIGN KEY (`gallery_vertical_id`) REFERENCES `gallery` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_23A0E669828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_23A0E66A604F92B` FOREIGN KEY (`secondary_image_id`) REFERENCES `media_object` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_23A0E66EA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media_object` (`id`),
  CONSTRAINT `FK_23A0E66F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `article`
--

INSERT INTO `article` VALUES (1,77,NULL,11,NULL,NULL,NULL,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','Repellat excepturi beatae eum dignissimos aperiam. Ea ea sint sit amet.','2021-10-12','seminaire','Nemo rerum sequi quasi est. Aspernatur est vitae omnis quis laborum ducimus. Quasi odit tenetur omnis. Voluptatem maxime et non omnis quos.','Voluptatem iusto.',1,0,0,NULL,'Est animi ut consequatur earum sapiente voluptas odio. Omnis ea dolor alias. Necessitatibus ea id ratione est est maiores.',NULL,NULL,'Séminaire','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','Voluptatum repellendus repudiandae ipsam. Molestiae qui rerum aut dolorem. Ab quibusdam dignissimos qui optio.','Sapiente dolorem excepturi voluptatem ea voluptatem eveniet magnam. Aut id labore consequatur debitis consequuntur odit et hic. Ut eum excepturi odio at blanditiis. Nesciunt accusamus rerum sint qui.','2021-10-12',NULL,NULL,NULL,'2021-10-12 22:30:33','2021-10-12 22:30:34'),(2,77,NULL,11,NULL,NULL,NULL,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','Saepe consequatur est tempore sed expedita explicabo. Explicabo necessitatibus eos ex ut. Ratione eius incidunt minus velit mollitia. Error eos voluptatem consequatur assumenda.','2021-10-12','mariage','Iure et possimus est culpa velit voluptas. Animi commodi natus nobis et quidem asperiores. Odio voluptas modi ut omnis perferendis fugiat. Pariatur officiis odio saepe beatae cum placeat nihil.','Voluptatem suscipit expedita.',1,0,0,NULL,'Quo necessitatibus commodi rerum rem. Ducimus reprehenderit nemo sed iste velit. Quis reprehenderit quasi facere adipisci officiis aspernatur consequatur.',NULL,NULL,'Mariage','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','Sint est nostrum autem non ea omnis eum omnis. Tempore sint vel consequuntur explicabo. Aperiam recusandae sapiente et iusto adipisci magni.','Voluptatem repellendus ut ipsa est. Et consequatur quasi vero consequatur vel. Velit incidunt mollitia est est tempora.','2021-10-12',NULL,NULL,NULL,'2021-10-12 22:30:33','2021-10-12 22:30:34'),(3,77,NULL,11,NULL,NULL,NULL,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','Dolores quod vitae debitis quo possimus mollitia blanditiis. Non nesciunt sunt asperiores quia qui quam. Voluptatem cum et labore ut ut deserunt maxime.','2021-10-12','shooting','Nulla rem sit culpa enim minima molestias itaque. Blanditiis vero hic rerum ipsa sapiente ut. Et corporis tempora repellendus aperiam voluptas velit occaecati reiciendis.','Hic molestias aut.',1,0,0,NULL,'Eaque reiciendis sed non blanditiis. Distinctio animi beatae odio in. Nihil earum reiciendis deserunt molestiae. Vel impedit doloribus assumenda culpa inventore sequi officiis.',NULL,NULL,'Shooting','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','Tempora nobis ullam aspernatur sunt maiores soluta. Sed inventore veniam voluptatem consequuntur qui occaecati. Consequatur est nihil aut.','Quisquam libero sunt dicta nihil. Pariatur incidunt quam iusto eveniet ut autem. Fuga aspernatur quia deleniti.','2021-10-12',NULL,NULL,NULL,'2021-10-12 22:30:33','2021-10-12 22:30:34'),(4,77,NULL,11,NULL,NULL,NULL,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','Vitae aut corrupti voluptas veniam ea voluptatum aliquam. Voluptatem consequatur at nemo dolores quo vel aliquam. Atque magni qui nihil nam occaecati in recusandae.','2021-10-12','evenements-familliaux','Quia autem nesciunt a nesciunt iste perspiciatis. Eveniet excepturi quia voluptate cum quos recusandae.','Architecto neque unde.',1,0,0,NULL,'Ea voluptas veniam sint porro saepe. Quod quos error dolorem accusamus minima nulla. Libero dolorem facere ut illo illo ut dolores dolor. Vitae et eaque voluptate tempore.',NULL,NULL,'Évenements familliaux','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','Explicabo quisquam laborum quia ut odit omnis omnis libero. Sit et repudiandae voluptas nisi vel. Nostrum laudantium labore autem consequatur suscipit dolorum sunt.','Rerum voluptate nisi earum corporis ab porro. Aut sunt vero sequi et. Adipisci praesentium sit hic dolore facilis suscipit quaerat voluptatem.','2021-10-12',NULL,NULL,NULL,'2021-10-12 22:30:33','2021-10-12 22:30:34'),(5,77,NULL,12,NULL,NULL,NULL,NULL,NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','Sit minus placeat laboriosam et possimus. Deleniti quia animi dolor. Voluptatem asperiores quia voluptatem fugit.','2021-10-12','videos','Eos quia ut culpa rem et. Et officia vel vitae maiores. Animi aut mollitia consequatur illo. Laboriosam perspiciatis vel deserunt dignissimos quae maiores sed. Sunt sunt repudiandae sunt autem et et.','Iure quaerat et accusantium.',1,0,0,NULL,'Et beatae minima et at qui fugit est aliquam. Voluptas neque culpa rerum sunt odio. Ut qui voluptatem id quam at in necessitatibus. Recusandae officia odio dicta qui illo.',NULL,NULL,'Vidéos','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','Et quod unde et praesentium et voluptates. Officiis et qui explicabo. Sint velit tenetur sed a iure maiores tempore molestiae.','Molestiae rerum fuga ea consequatur. Quam sit repudiandae ipsa cum quidem. Dolor rerum est minus earum at.','2021-10-12',NULL,NULL,NULL,'2021-10-12 22:30:33','2021-10-16 16:51:06'),(6,77,NULL,12,NULL,NULL,NULL,NULL,1,'<p>Commencez vos vacances! Visitez la Villa, ses salons, sa cuisine, ses chambres, ses piscines, son spa, ses jardins. Rencontrez son équipe. Voyez les expériences des uns et des autres à Gonatouki et lors d’activités extérieures. Prenez des idées d’activités que vous pourrez pratiquer. Observez avec les yeux des hôtes qui vous ont précédés. Faites-vous plaisir avant même de partir!</p>','Doooolor pariatur possimus laboriosam quo aspernatur et sequi sed. Enim voluptatem laboriosam qui non. Iusto aliquam placeat rem fugit eligendi animi. Dolor odio optio corrupti impedit ipsum dolor.','2021-10-12','galerie','Culpa ipsa sint alias quibusdam sint ipsa. Ipsam impedit ipsa aliquam impedit. Necessitatibus sit eos totam quia quis harum. Similique et voluptas quaerat ut illum omnis.','Quas rerum deleniti est maiores.',1,0,0,NULL,'Aut omnis tempora sapiente temporibus. Voluptas dolor pariatur omnis. Officiis non ut consectetur et quae.',NULL,NULL,'Galerie','Looooorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','Loooooorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','Cooommencez vos vacances! Visitez la Villa, ses salons, sa cuisine, ses chambres, ses piscines, son spa, ses jardins. Rencontrez son équipe. Voyez les expériences des uns et des autres à Gonatouki et lors d’activités extérieures. Prenez des idées d’activités que vous pourrez pratiquer. Observez avec les yeux des hôtes qui vous ont précédés. Faites-vous plaisir avant même de partir!','Quod dolor consequatur nostrum provident. Amet sit voluptas sed quo. Sed veritatis labore corporis. Ut est est quas fugit nisi.','2021-10-12',NULL,'Galerie','Loooooorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','2021-10-12 22:30:33','2021-10-16 16:51:06');

--
-- Table structure for table `articles_components`
--

CREATE TABLE `articles_components` (
  `article_id` int(11) NOT NULL,
  `component_id` int(11) NOT NULL,
  PRIMARY KEY (`article_id`,`component_id`),
  KEY `IDX_ABBF99B7294869C` (`article_id`),
  KEY `IDX_ABBF99BE2ABAFFF` (`component_id`),
  CONSTRAINT `FK_ABBF99B7294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_ABBF99BE2ABAFFF` FOREIGN KEY (`component_id`) REFERENCES `component` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `articles_components`
--


--
-- Table structure for table `articles_tags`
--

CREATE TABLE `articles_tags` (
  `article_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY (`article_id`,`tag_id`),
  KEY `IDX_354053617294869C` (`article_id`),
  KEY `IDX_35405361BAD26311` (`tag_id`),
  CONSTRAINT `FK_354053617294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_35405361BAD26311` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `articles_tags`
--

INSERT INTO `articles_tags` VALUES (1,11),(2,11),(3,11),(4,11),(5,12),(6,12);

--
-- Table structure for table `articles_videos`
--

CREATE TABLE `articles_videos` (
  `article_id` int(11) NOT NULL,
  `media_object_id` int(11) NOT NULL,
  PRIMARY KEY (`article_id`,`media_object_id`),
  KEY `IDX_9392B01F7294869C` (`article_id`),
  KEY `IDX_9392B01F64DE5A5` (`media_object_id`),
  CONSTRAINT `FK_9392B01F64DE5A5` FOREIGN KEY (`media_object_id`) REFERENCES `media_object` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_9392B01F7294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `articles_videos`
--

INSERT INTO `articles_videos` VALUES (5,149),(5,150);

--
-- Table structure for table `build_route`
--

CREATE TABLE `build_route` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `build_route`
--


--
-- Table structure for table `comment`
--

CREATE TABLE `comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `article_id` int(11) DEFAULT NULL,
  `downvote_count` int(11) DEFAULT NULL,
  `upvote_count` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `headline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alternative_headline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `push_forward` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` longtext COLLATE utf8mb4_unicode_ci,
  `text_resume` longtext COLLATE utf8mb4_unicode_ci,
  `date_published` date DEFAULT NULL,
  `expire` date DEFAULT NULL,
  `meta_title` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(160) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_9474526C7294869C` (`article_id`),
  CONSTRAINT `FK_9474526C7294869C` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `comment`
--


--
-- Table structure for table `component`
--

CREATE TABLE `component` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `service` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_49FEA157989D9B62` (`slug`),
  KEY `IDX_49FEA157F987D8A8` (`user_created_id`),
  KEY `IDX_49FEA1579828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_49FEA1579828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_49FEA157F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `component`
--

INSERT INTO `component` VALUES (1,NULL,NULL,'form','contact','http://schema.org/Messsage','contact-form','contact-form','Contact form',NULL,NULL,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:17'),(2,NULL,NULL,'form','newsletter','http://schema.org/Messsage','newsletter-form','newsletter-form','Newsletter form',NULL,NULL,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:17'),(3,NULL,NULL,'list','article','null','related-articles','related-articles','Related articles',NULL,NULL,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:17'),(4,NULL,NULL,'article','lagence','null','welcome','welcome','Welcome',NULL,NULL,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:17'),(5,NULL,NULL,'article','nos-locaux','null','whoweare','whoweare','WhoWeAre',NULL,NULL,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:17'),(6,NULL,NULL,NULL,NULL,NULL,'informations','informations','Informations',NULL,NULL,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:17'),(7,NULL,NULL,NULL,NULL,'http://schema.org/MyEntity','google-analytics','google-analytics','Google Analytics',NULL,NULL,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:17');

--
-- Table structure for table `creative_work`
--

CREATE TABLE `creative_work` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `headline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alternative_headline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `push_forward` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` longtext COLLATE utf8mb4_unicode_ci,
  `text_resume` longtext COLLATE utf8mb4_unicode_ci,
  `date_published` date DEFAULT NULL,
  `expire` date DEFAULT NULL,
  `meta_title` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(160) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=159 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `creative_work`
--

INSERT INTO `creative_work` VALUES (1,NULL,NULL,NULL,'Homme',NULL,NULL,NULL,NULL,NULL),(2,NULL,NULL,NULL,'Femme',NULL,NULL,NULL,NULL,NULL),(3,NULL,NULL,NULL,'Explore',NULL,NULL,NULL,NULL,NULL),(4,NULL,NULL,NULL,'Prix total de votre séjour',NULL,NULL,NULL,NULL,NULL),(5,NULL,NULL,NULL,'pour la période du',NULL,NULL,NULL,NULL,NULL),(6,NULL,NULL,NULL,'pour',NULL,NULL,NULL,NULL,NULL),(7,NULL,NULL,NULL,'vous serez joignable au',NULL,NULL,NULL,NULL,NULL),(8,NULL,NULL,NULL,'votre réservation sera au nom de',NULL,NULL,NULL,NULL,NULL),(9,NULL,NULL,NULL,'et/ou par email',NULL,NULL,NULL,NULL,NULL),(10,NULL,NULL,NULL,'vous souhaitez nous faire part de',NULL,NULL,NULL,NULL,NULL),(11,NULL,NULL,NULL,'prix total de votre séjour',NULL,NULL,NULL,NULL,NULL),(12,NULL,NULL,NULL,'Valider',NULL,NULL,NULL,NULL,NULL),(13,NULL,NULL,NULL,'Une journée à la villa',NULL,NULL,NULL,NULL,NULL),(14,NULL,NULL,NULL,'Réserver',NULL,NULL,NULL,NULL,NULL),(15,NULL,NULL,NULL,'Nous preparons votre chambre',NULL,NULL,NULL,NULL,NULL),(16,NULL,NULL,NULL,'Une journée à la villa',NULL,NULL,NULL,NULL,NULL),(17,NULL,NULL,NULL,'Bienvenue',NULL,NULL,NULL,NULL,NULL),(18,NULL,NULL,NULL,'à la',NULL,NULL,NULL,NULL,NULL),(19,NULL,NULL,NULL,'Villa Gonatouki',NULL,NULL,NULL,NULL,NULL),(20,NULL,NULL,NULL,'personnes',NULL,NULL,NULL,NULL,NULL),(21,NULL,NULL,NULL,'Détails',NULL,NULL,NULL,NULL,NULL),(22,NULL,NULL,NULL,'Description',NULL,NULL,NULL,NULL,NULL),(23,NULL,NULL,NULL,'Lit Supplémentaire à la demande (15€ par pers.)',NULL,NULL,NULL,NULL,NULL),(24,NULL,NULL,NULL,'Les activités',NULL,NULL,NULL,NULL,NULL),(25,NULL,NULL,NULL,'La villa',NULL,NULL,NULL,NULL,NULL),(26,NULL,NULL,NULL,'Les services',NULL,NULL,NULL,NULL,NULL),(27,NULL,NULL,NULL,'Contacter-nous',NULL,NULL,NULL,NULL,NULL),(28,NULL,NULL,NULL,'Plus d\'infos',NULL,NULL,NULL,NULL,NULL),(29,NULL,NULL,NULL,'chambre',NULL,NULL,NULL,NULL,NULL),(30,NULL,NULL,NULL,'disponible',NULL,NULL,NULL,NULL,NULL),(31,NULL,NULL,NULL,'à partir de',NULL,NULL,NULL,NULL,NULL),(32,NULL,NULL,NULL,'Réserver cette chambre',NULL,NULL,NULL,NULL,NULL),(33,NULL,NULL,NULL,'Adultes',NULL,NULL,NULL,NULL,NULL),(34,NULL,NULL,NULL,'adultes',NULL,NULL,NULL,NULL,NULL),(35,NULL,NULL,NULL,'Enfants',NULL,NULL,NULL,NULL,NULL),(36,NULL,NULL,NULL,'enfants',NULL,NULL,NULL,NULL,NULL),(37,NULL,NULL,NULL,'et',NULL,NULL,NULL,NULL,NULL),(38,NULL,NULL,NULL,'Votre prénom',NULL,NULL,NULL,NULL,NULL),(39,NULL,NULL,NULL,'Votre nom',NULL,NULL,NULL,NULL,NULL),(40,NULL,NULL,NULL,'Votre téléphone',NULL,NULL,NULL,NULL,NULL),(41,NULL,NULL,NULL,'Votre e-mail',NULL,NULL,NULL,NULL,NULL),(42,NULL,NULL,NULL,'Vos remarques',NULL,NULL,NULL,NULL,NULL),(43,NULL,NULL,NULL,'Choisissez les dates de votre séjour qui vous font plaisir',NULL,NULL,NULL,NULL,NULL),(44,NULL,NULL,NULL,'Retour au site',NULL,NULL,NULL,NULL,NULL),(45,NULL,NULL,NULL,'Voir les chambres',NULL,NULL,NULL,NULL,NULL),(46,NULL,NULL,NULL,'Informations & réservation',NULL,NULL,NULL,NULL,NULL),(47,NULL,NULL,NULL,'Réservez votre séjour à la',NULL,NULL,NULL,NULL,NULL),(48,NULL,NULL,NULL,'Derniers articles',NULL,NULL,NULL,NULL,NULL),(49,NULL,NULL,NULL,'vente',NULL,NULL,NULL,NULL,NULL),(50,NULL,NULL,NULL,'location',NULL,NULL,NULL,NULL,NULL),(51,NULL,NULL,NULL,'nos experts',NULL,NULL,NULL,NULL,NULL),(52,NULL,NULL,NULL,'decoration',NULL,NULL,NULL,NULL,NULL),(53,NULL,NULL,NULL,'agence',NULL,NULL,NULL,NULL,NULL),(54,NULL,NULL,NULL,'accueil',NULL,NULL,NULL,NULL,NULL),(55,NULL,NULL,NULL,'calme',NULL,NULL,NULL,NULL,NULL),(56,NULL,NULL,NULL,'jardin',NULL,NULL,NULL,NULL,NULL),(57,NULL,NULL,NULL,'Experience Professionnelle',NULL,NULL,NULL,NULL,NULL),(58,NULL,NULL,NULL,'nos services',NULL,NULL,NULL,NULL,NULL),(59,NULL,NULL,NULL,'post',NULL,NULL,NULL,NULL,NULL),(60,NULL,NULL,NULL,'Blog',NULL,NULL,NULL,NULL,NULL),(61,NULL,NULL,NULL,'plus d\"infos',NULL,NULL,NULL,NULL,NULL),(62,NULL,NULL,NULL,'Projets',NULL,NULL,NULL,NULL,NULL),(63,NULL,NULL,NULL,'Accomplis',NULL,NULL,NULL,NULL,NULL),(64,NULL,NULL,NULL,'Tags',NULL,NULL,NULL,NULL,NULL),(65,NULL,NULL,NULL,'Liens utiles',NULL,NULL,NULL,NULL,NULL),(66,NULL,NULL,NULL,'mois',NULL,NULL,NULL,NULL,NULL),(67,NULL,NULL,NULL,'description',NULL,NULL,NULL,NULL,NULL),(68,NULL,NULL,NULL,'Détails',NULL,NULL,NULL,NULL,NULL),(69,NULL,NULL,NULL,'Identifiant de la propriété',NULL,NULL,NULL,NULL,NULL),(70,NULL,NULL,NULL,'Prix',NULL,NULL,NULL,NULL,NULL),(71,NULL,NULL,NULL,'Type de propriété',NULL,NULL,NULL,NULL,NULL),(72,NULL,NULL,NULL,'Salle de bain',NULL,NULL,NULL,NULL,NULL),(73,NULL,NULL,NULL,'Propriété Taille du lot',NULL,NULL,NULL,NULL,NULL),(74,NULL,NULL,NULL,'Aire d\"atterrissage',NULL,NULL,NULL,NULL,NULL),(75,NULL,NULL,NULL,'Endroit',NULL,NULL,NULL,NULL,NULL),(76,NULL,NULL,NULL,'fonctionnalités',NULL,NULL,NULL,NULL,NULL),(77,NULL,NULL,NULL,'plan d\"étage',NULL,NULL,NULL,NULL,NULL),(78,NULL,NULL,NULL,'Chercher',NULL,NULL,NULL,NULL,NULL),(79,NULL,NULL,NULL,'Partager cette publication',NULL,NULL,NULL,NULL,NULL),(80,NULL,NULL,NULL,'vidéos',NULL,NULL,NULL,NULL,NULL),(81,NULL,NULL,NULL,'appelez nous',NULL,NULL,NULL,NULL,NULL),(82,NULL,NULL,NULL,'Taille',NULL,NULL,NULL,NULL,NULL),(83,NULL,NULL,NULL,'Pièces',NULL,NULL,NULL,NULL,NULL),(84,NULL,NULL,NULL,'Garage',NULL,NULL,NULL,NULL,NULL),(85,NULL,NULL,NULL,'Numéro de téléphone',NULL,NULL,NULL,NULL,NULL),(86,NULL,NULL,NULL,'Adresse électronique',NULL,NULL,NULL,NULL,NULL),(87,NULL,NULL,NULL,'Lire la suite',NULL,NULL,NULL,NULL,NULL),(88,NULL,NULL,NULL,'Soumettre',NULL,NULL,NULL,NULL,NULL),(89,NULL,NULL,NULL,'adresse',NULL,NULL,NULL,NULL,NULL),(90,NULL,NULL,NULL,'ville & pays',NULL,NULL,NULL,NULL,NULL),(91,NULL,NULL,NULL,'Rénovation',NULL,NULL,NULL,NULL,NULL),(92,NULL,NULL,NULL,'Construction',NULL,NULL,NULL,NULL,NULL),(93,NULL,NULL,NULL,'Location saison',NULL,NULL,NULL,NULL,NULL),(94,NULL,NULL,NULL,'Longue durée',NULL,NULL,NULL,NULL,NULL),(95,NULL,NULL,NULL,'chambres',NULL,NULL,NULL,NULL,NULL),(96,NULL,NULL,NULL,'Réf. agence',NULL,NULL,NULL,NULL,NULL),(97,NULL,NULL,NULL,'Téléphone',NULL,NULL,NULL,NULL,NULL),(98,NULL,NULL,NULL,'Vidéo',NULL,NULL,NULL,NULL,NULL),(99,NULL,NULL,NULL,'Localisation',NULL,NULL,NULL,NULL,NULL),(100,NULL,NULL,NULL,'détails',NULL,NULL,NULL,NULL,NULL),(101,NULL,NULL,NULL,'plan d\"étage',NULL,NULL,NULL,NULL,NULL),(102,NULL,NULL,NULL,'video',NULL,NULL,NULL,NULL,NULL),(103,NULL,NULL,NULL,'Une erreur est survenue',NULL,NULL,NULL,NULL,NULL),(104,NULL,NULL,NULL,'Votre message a été envoyé',NULL,NULL,NULL,NULL,NULL),(105,NULL,NULL,NULL,'Votre message a bien été envoyé',NULL,NULL,NULL,NULL,NULL),(106,NULL,NULL,NULL,'Veuillez saisir un prénom',NULL,NULL,NULL,NULL,NULL),(107,NULL,NULL,NULL,'Veuillez saisir un nom',NULL,NULL,NULL,NULL,NULL),(108,NULL,NULL,NULL,'Veuillez saisir un email',NULL,NULL,NULL,NULL,NULL),(109,NULL,NULL,NULL,'Veuillez saisir un message',NULL,NULL,NULL,NULL,NULL),(110,NULL,NULL,NULL,'Veuillez saisir un email valide',NULL,NULL,NULL,NULL,NULL),(111,NULL,NULL,NULL,'Merci de patienter',NULL,NULL,NULL,NULL,NULL),(112,NULL,NULL,NULL,'Nous vous répondrons dans les meilleurs délais',NULL,NULL,NULL,NULL,NULL),(113,NULL,NULL,NULL,'Derniers biens',NULL,NULL,NULL,NULL,NULL),(114,NULL,NULL,NULL,'Chambres',NULL,NULL,NULL,NULL,NULL),(115,NULL,NULL,NULL,'Surface',NULL,NULL,NULL,NULL,NULL),(116,NULL,NULL,NULL,'Terrain',NULL,NULL,NULL,NULL,NULL),(117,NULL,NULL,NULL,'Terrasse',NULL,NULL,NULL,NULL,NULL),(118,NULL,NULL,NULL,'jacuzzi',NULL,NULL,NULL,NULL,NULL),(119,NULL,NULL,NULL,'garage',NULL,NULL,NULL,NULL,NULL),(120,NULL,NULL,NULL,'cheminée',NULL,NULL,NULL,NULL,NULL),(121,NULL,NULL,NULL,'Notre galerie',NULL,NULL,NULL,NULL,NULL),(122,NULL,NULL,NULL,'salle de bain',NULL,NULL,NULL,NULL,NULL),(123,NULL,NULL,NULL,'piscine',NULL,NULL,NULL,NULL,NULL),(124,NULL,NULL,NULL,'wifi',NULL,NULL,NULL,NULL,NULL),(125,NULL,NULL,NULL,'video',NULL,NULL,NULL,NULL,NULL),(126,NULL,NULL,NULL,'veuillez saisir un email valide',NULL,NULL,NULL,NULL,NULL),(127,NULL,NULL,NULL,'veuillez saisir un message',NULL,NULL,NULL,NULL,NULL),(128,NULL,NULL,NULL,'veuillez saisir un email',NULL,NULL,NULL,NULL,NULL),(129,NULL,NULL,NULL,'veuillez saisir un nom',NULL,NULL,NULL,NULL,NULL),(130,NULL,NULL,NULL,'veuillez saisir un prénom',NULL,NULL,NULL,NULL,NULL),(131,NULL,NULL,NULL,'Politique de confidentialité',NULL,NULL,NULL,NULL,NULL),(132,NULL,NULL,NULL,'Contactez nous',NULL,NULL,NULL,NULL,NULL),(133,NULL,NULL,NULL,'Termes et conditions',NULL,NULL,NULL,NULL,NULL),(134,NULL,NULL,NULL,'N\"hésitez pas à lui envoyer un email',NULL,NULL,NULL,NULL,NULL),(135,NULL,NULL,NULL,'Vous n\"avez pas réussi à joindre notre agent ?',NULL,NULL,NULL,NULL,NULL),(136,NULL,NULL,NULL,'Envoyer',NULL,NULL,NULL,NULL,NULL),(137,NULL,NULL,NULL,'Contacter l\"agence',NULL,NULL,NULL,NULL,NULL),(138,NULL,NULL,NULL,'Message',NULL,NULL,NULL,NULL,NULL),(139,NULL,NULL,NULL,'E-mail',NULL,NULL,NULL,NULL,NULL),(140,NULL,NULL,NULL,'Prénom',NULL,NULL,NULL,NULL,NULL),(141,NULL,NULL,NULL,'Nom',NULL,NULL,NULL,NULL,NULL),(142,NULL,NULL,NULL,'Voir plus de détails',NULL,NULL,NULL,NULL,NULL),(143,NULL,NULL,NULL,'A propos de nous',NULL,NULL,NULL,NULL,NULL),(144,NULL,NULL,NULL,'localisation',NULL,NULL,NULL,NULL,NULL),(145,NULL,NULL,NULL,'Saisir la référence',NULL,NULL,NULL,NULL,NULL),(146,NULL,NULL,NULL,'Budget max.',NULL,NULL,NULL,NULL,NULL),(147,NULL,NULL,NULL,'Budget max',NULL,NULL,NULL,NULL,NULL),(148,NULL,NULL,NULL,'Budget min.',NULL,NULL,NULL,NULL,NULL),(149,NULL,NULL,NULL,'Budget min',NULL,NULL,NULL,NULL,NULL),(150,NULL,NULL,NULL,'de surface de terrain',NULL,NULL,NULL,NULL,NULL),(151,NULL,NULL,NULL,'Biens similaires',NULL,NULL,NULL,NULL,NULL),(152,NULL,NULL,NULL,'Rechercher un bien immobilier',NULL,NULL,NULL,NULL,NULL),(153,NULL,NULL,NULL,'Vacances',NULL,NULL,NULL,NULL,NULL),(154,NULL,NULL,NULL,'vous connaissez votre référence ?',NULL,NULL,NULL,NULL,NULL),(155,NULL,NULL,NULL,'Achat',NULL,NULL,NULL,NULL,NULL),(156,NULL,NULL,NULL,'Envoyer',NULL,NULL,NULL,NULL,NULL),(157,NULL,NULL,NULL,'Votre message',NULL,NULL,NULL,NULL,NULL),(158,NULL,NULL,NULL,'Informations & réservations',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `customer_card`
--

CREATE TABLE `customer_card` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `person_id` int(11) DEFAULT NULL,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_42853CA4217BBB47` (`person_id`),
  KEY `IDX_42853CA4F987D8A8` (`user_created_id`),
  KEY `IDX_42853CA49828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_42853CA4217BBB47` FOREIGN KEY (`person_id`) REFERENCES `person` (`id`),
  CONSTRAINT `FK_42853CA49828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_42853CA4F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_card`
--


--
-- Table structure for table `document_object`
--

CREATE TABLE `document_object` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(11) DEFAULT NULL,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `content_size` int(11) DEFAULT NULL,
  `encoding_format` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `caption` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `original_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dimensions` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:simple_array)',
  `tmp_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_16CF1A8AC54C8C93` (`type_id`),
  KEY `IDX_16CF1A8AF987D8A8` (`user_created_id`),
  KEY `IDX_16CF1A8A9828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_16CF1A8A9828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_16CF1A8AC54C8C93` FOREIGN KEY (`type_id`) REFERENCES `document_object_type` (`id`),
  CONSTRAINT `FK_16CF1A8AF987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `document_object`
--


--
-- Table structure for table `document_object_type`
--

CREATE TABLE `document_object_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_93625C505E237E06` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `document_object_type`
--

INSERT INTO `document_object_type` VALUES (1,'2021-10-12 22:29:17','2021-10-12 22:29:47','plan','Plan'),(2,'2021-10-12 22:29:17','2021-10-12 22:29:47','mandat','Mandat'),(3,'2021-10-12 22:29:17','2021-10-12 22:29:47','titre','Titre'),(4,'2021-10-12 22:29:17','2021-10-12 22:29:47','contrat','Contrat');

--
-- Table structure for table `event`
--

CREATE TABLE `event` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `person_id` int(11) DEFAULT NULL,
  `accommodation_id` int(11) DEFAULT NULL,
  `rental_type_id` int(11) DEFAULT NULL,
  `rental_agreement_id` int(11) DEFAULT NULL,
  `accommodation_nature_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` longtext COLLATE utf8mb4_unicode_ci,
  `begin_at` datetime NOT NULL,
  `end_at` datetime NOT NULL,
  `deposit_amount` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deposit_status` tinyint(1) DEFAULT NULL,
  `document` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` longtext COLLATE utf8mb4_unicode_ci,
  `respond_at` datetime DEFAULT NULL,
  `number_of_adults` smallint(6) DEFAULT NULL,
  `number_of_children` smallint(6) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_3BAE0AA7989D9B62` (`slug`),
  KEY `IDX_3BAE0AA7217BBB47` (`person_id`),
  KEY `IDX_3BAE0AA78F3692CD` (`accommodation_id`),
  KEY `IDX_3BAE0AA716AA567C` (`rental_type_id`),
  KEY `IDX_3BAE0AA7C09E3816` (`rental_agreement_id`),
  KEY `IDX_3BAE0AA782F0DE6D` (`accommodation_nature_id`),
  KEY `IDX_3BAE0AA712469DE2` (`category_id`),
  KEY `IDX_3BAE0AA7F987D8A8` (`user_created_id`),
  KEY `IDX_3BAE0AA79828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_3BAE0AA712469DE2` FOREIGN KEY (`category_id`) REFERENCES `tag` (`id`),
  CONSTRAINT `FK_3BAE0AA716AA567C` FOREIGN KEY (`rental_type_id`) REFERENCES `rental_type` (`id`),
  CONSTRAINT `FK_3BAE0AA7217BBB47` FOREIGN KEY (`person_id`) REFERENCES `person` (`id`),
  CONSTRAINT `FK_3BAE0AA782F0DE6D` FOREIGN KEY (`accommodation_nature_id`) REFERENCES `accommodation_nature` (`id`),
  CONSTRAINT `FK_3BAE0AA78F3692CD` FOREIGN KEY (`accommodation_id`) REFERENCES `accommodation` (`id`),
  CONSTRAINT `FK_3BAE0AA79828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_3BAE0AA7C09E3816` FOREIGN KEY (`rental_agreement_id`) REFERENCES `document_object` (`id`),
  CONSTRAINT `FK_3BAE0AA7F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event`
--

INSERT INTO `event` VALUES (1,NULL,NULL,NULL,NULL,NULL,8,NULL,NULL,'les-nuits-photographiques',NULL,'2021-09-28 00:00:00','2021-10-03 00:00:00',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'Les nuits photographiques','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.',NULL,NULL,'2021-10-12 22:29:18','2021-10-12 22:29:47'),(2,NULL,NULL,NULL,NULL,NULL,9,NULL,NULL,'festival-des-andalousies-atlantiques',NULL,'2021-10-28 00:00:00','2021-11-03 00:00:00',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'Festival des Andalousies Atlantiques','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.',NULL,NULL,'2021-10-12 22:29:19','2021-10-12 22:29:47'),(3,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,'le-rallye-aicha-des-gazelles',NULL,'2021-03-28 00:00:00','2021-04-07 00:00:00',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'Le Rallye Aïcha des Gazelles','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.',NULL,NULL,'2021-10-12 22:29:19','2021-10-12 22:29:47'),(4,NULL,NULL,NULL,NULL,NULL,10,NULL,NULL,'festival-ganoua',NULL,'2021-06-28 00:00:00','2021-07-01 00:00:00',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'Festival Ganoua','Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.',NULL,NULL,'2021-10-12 22:29:19','2021-10-12 22:29:47'),(5,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'2021-10-19 23:00:00','2021-10-21 23:00:00',NULL,0,NULL,'216','{\"chambre-confort\":{\"numberOfRooms\":1,\"addOn\":0}}',NULL,1,1,NULL,NULL,NULL,NULL,'2021-10-16 16:34:46','2021-10-16 16:34:46'),(6,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'-1',NULL,'2021-11-15 23:00:00','2021-11-22 23:00:00',NULL,1,NULL,'6741','{\"chambre-prestige\":{\"numberOfRooms\":1,\"addOn\":0}}',NULL,1,1,NULL,NULL,NULL,NULL,'2021-10-16 18:01:51','2021-10-16 18:04:33');

--
-- Table structure for table `event_tag`
--

CREATE TABLE `event_tag` (
  `event_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY (`event_id`,`tag_id`),
  KEY `IDX_1246725071F7E88B` (`event_id`),
  KEY `IDX_12467250BAD26311` (`tag_id`),
  CONSTRAINT `FK_1246725071F7E88B` FOREIGN KEY (`event_id`) REFERENCES `event` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_12467250BAD26311` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_tag`
--

INSERT INTO `event_tag` VALUES (1,8),(2,9),(3,10),(4,10);

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `width` int(11) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `regenerate_format` tinyint(1) NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_472B783A989D9B62` (`slug`),
  KEY `IDX_472B783AF987D8A8` (`user_created_id`),
  KEY `IDX_472B783A9828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_472B783A9828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_472B783AF987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` VALUES (1,NULL,NULL,'day_type',NULL,NULL,'day-type',0,NULL,NULL,NULL,'2021-10-12 22:30:26','2021-10-16 17:33:39'),(2,NULL,NULL,'Chambre Prestige',NULL,NULL,'chambre-prestige',0,NULL,NULL,NULL,'2021-10-12 22:30:27','2021-10-12 22:32:43'),(3,NULL,NULL,'Patio',NULL,NULL,'patio',0,NULL,NULL,NULL,'2021-10-12 22:30:27','2021-10-12 22:32:43'),(4,NULL,NULL,'hotel',NULL,NULL,'hotel',0,NULL,NULL,NULL,'2021-10-12 22:30:27','2021-10-12 22:32:43'),(5,NULL,NULL,'Salons',NULL,NULL,'salons',0,NULL,NULL,NULL,'2021-10-12 22:30:28','2021-10-12 22:32:43'),(6,NULL,NULL,'Chambre Confort',NULL,NULL,'chambre-confort',0,NULL,NULL,NULL,'2021-10-12 22:30:28','2021-10-12 22:32:43'),(7,NULL,NULL,'Grande Suite',NULL,NULL,'grande-suite',0,NULL,NULL,NULL,'2021-10-12 22:30:28','2021-10-12 22:32:43'),(8,NULL,NULL,'Suite Moyenne',NULL,NULL,'suite-moyenne',0,NULL,NULL,NULL,'2021-10-12 22:30:29','2021-10-12 22:32:43'),(9,NULL,NULL,'Extérieur - Jardin',NULL,NULL,'exterieur-jardin',0,NULL,NULL,NULL,'2021-10-12 22:30:29','2021-10-16 17:33:39'),(10,NULL,NULL,'activities',NULL,NULL,'activities',0,NULL,NULL,NULL,'2021-10-12 22:30:29','2021-10-16 17:33:39'),(11,NULL,NULL,'Chambre Supérieure',NULL,NULL,'chambre-superieure',0,NULL,NULL,NULL,'2021-10-12 22:30:29','2021-10-12 22:32:43'),(12,NULL,NULL,'rooms',NULL,NULL,'rooms',0,NULL,NULL,NULL,'2021-10-12 22:30:30','2021-10-12 22:32:43'),(13,NULL,NULL,'Petite Suite',NULL,NULL,'petite-suite',0,NULL,NULL,NULL,'2021-10-12 22:30:30','2021-10-12 22:32:43'),(14,NULL,NULL,'Ch Confort 3',NULL,NULL,'ch-confort-3',0,NULL,NULL,NULL,'2021-10-12 22:30:30','2021-10-12 22:32:43'),(15,NULL,NULL,'Salle à manger',NULL,NULL,'salle-a-manger',0,NULL,NULL,NULL,'2021-10-12 22:30:31','2021-10-12 22:32:43'),(16,NULL,NULL,'Spa',NULL,NULL,'spa',0,NULL,NULL,NULL,'2021-10-12 22:30:31','2021-10-12 22:32:43'),(17,NULL,NULL,'villa',NULL,NULL,'villa',0,NULL,NULL,NULL,'2021-10-12 22:30:32','2021-10-12 22:32:43'),(18,NULL,NULL,'Piscines',NULL,NULL,'piscines',0,NULL,NULL,NULL,'2021-10-12 22:30:32','2021-10-16 17:33:39');

--
-- Table structure for table `gender`
--

CREATE TABLE `gender` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_C7470A425E237E06` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gender`
--

INSERT INTO `gender` VALUES (1,'2021-10-12 22:29:17','2021-10-12 22:29:47','m','M.'),(2,'2021-10-12 22:29:17','2021-10-12 22:29:47','mme','Mme.');

--
-- Table structure for table `hotel_activity`
--

CREATE TABLE `hotel_activity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `primary_image_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `headline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alternative_headline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `push_forward` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` longtext COLLATE utf8mb4_unicode_ci,
  `text_resume` longtext COLLATE utf8mb4_unicode_ci,
  `date_published` date DEFAULT NULL,
  `expire` date DEFAULT NULL,
  `meta_title` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(160) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_EE15DB281CDA489C` (`primary_image_id`),
  KEY `IDX_EE15DB2812469DE2` (`category_id`),
  KEY `IDX_EE15DB28F987D8A8` (`user_created_id`),
  KEY `IDX_EE15DB289828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_EE15DB2812469DE2` FOREIGN KEY (`category_id`) REFERENCES `tag` (`id`),
  CONSTRAINT `FK_EE15DB281CDA489C` FOREIGN KEY (`primary_image_id`) REFERENCES `media_object` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_EE15DB289828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_EE15DB28F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_activity`
--

INSERT INTO `hotel_activity` VALUES (1,13,32,NULL,1,NULL,NULL,1,'golf','Golf','Aa quelques longueurs de drive de Gonatouki, un somptueux golf parfaitement entretenu,dessiné par le prestigieux Gary Player, surplombe la mer. Il vient dʼêtre classé parmi les 10 plus beaux golfs du monde par une équipe de semi-pros. Profitez du climat exceptionnel pour découvrir ce 18 trous au parcours enchanteur. Par 72 de 6608 mètres qui convient tant aux joueurs expérimentés quʼaux amateurs, jeunes et moins jeunes. Le club est ouvert aux visiteurs toute lʼannée.',NULL,NULL,NULL,NULL,'Extraordinaire!',NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:49','2021-10-16 14:04:59'),(2,NULL,32,NULL,NULL,NULL,NULL,1,'sports-nautiques','SPORTS NAUTIQUES','Essaouira, Sidi Kaouki, Moulay… La côte atlantique marocaine offre elle aussi des spots réputés ! Equipez-vous dʼun kite, une planche à voile, un surf ou un bodyboard et partez à lʼassaut des vagues ! Pétole ? Profitez-en pour faire du kayak de mer et contourner lʼîle de Mogador. Les nombreux clubs bordant le littoral proposent des stages dʼinitiation ou de perfectionnement et du matériel de qualité en location.',NULL,NULL,NULL,NULL,'Fantastique!',NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:50','2021-10-16 14:04:59'),(3,NULL,32,NULL,NULL,NULL,NULL,1,'equitation-et-meharee','Equitation et MÉHARÉE','Vous pensiez que galoper sur une plage déserte au coucher du soleil nʼétait possible quʼau cinéma ? Détrompez-vous et tentez cette expérience unique lors de votre séjour ! Que vous soyez cavalier expert, confirmé ou débutant, Jawad vous emmènera faire dʼinoubliables balades en bord de mer ou en forêt. Vous voulez encore plus de dépaysement ? Jouez les Lawrence dʼArabie à lʼoccasion dʼune balade en dromadaire dans les dunes.',NULL,NULL,NULL,NULL,'Topissime!',NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:50','2021-10-16 14:04:59'),(4,NULL,32,NULL,NULL,NULL,NULL,1,'equitation','Equitation',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:50','2021-10-16 14:04:59'),(5,18,32,NULL,NULL,NULL,NULL,1,'quad','Quad','Mettez une pointe de frissons dans votre séjour et partez en quad pour un circuit inoubliable, à la beauté époustouflante ! Vous sillonnerez le bord de mer, en passant par les dunes et la lisière de la forêt lors dʼune sortie de 1 à 3 heures selon votre choix. Amateurs de sensations, vous apprécierez la pointe de vitesse sur la plage ou la descente dʼune dune à pic !',NULL,NULL,NULL,NULL,'De prodigieuses sensations!',NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:51','2021-10-16 14:04:59'),(6,NULL,32,NULL,NULL,NULL,NULL,1,'buggy','Buggy',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:51','2021-10-16 14:04:59'),(7,NULL,32,NULL,NULL,NULL,NULL,1,'surf','Surf',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:51','2021-10-16 14:04:59'),(8,NULL,32,NULL,NULL,NULL,NULL,1,'planche-a-voile','Planche à voile',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:52','2021-10-16 14:04:59'),(9,89,32,NULL,NULL,NULL,NULL,1,'kitesurf','Kitesurf',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:52','2021-10-16 14:04:59'),(10,NULL,32,NULL,NULL,NULL,NULL,1,'paddle','Paddle',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:53','2021-10-16 14:04:59'),(11,NULL,32,NULL,NULL,NULL,NULL,1,'running','Running',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:53','2021-10-16 14:04:59'),(12,NULL,32,NULL,NULL,NULL,NULL,1,'natation','Natation',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:53','2021-10-16 14:04:59'),(13,NULL,32,NULL,NULL,NULL,NULL,1,'stack','Stack',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:54','2021-10-16 14:04:59'),(14,NULL,32,NULL,NULL,NULL,NULL,1,'gymnastique-fitness-avec-ou-sans-coach','Gymnastique / fitness avec ou sans coach',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:54','2021-10-16 14:04:59'),(15,NULL,32,NULL,NULL,NULL,NULL,1,'yoga','Yoga',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:54','2021-10-16 14:04:59'),(16,NULL,32,NULL,NULL,NULL,NULL,1,'peche','Pêche',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:55','2021-10-16 14:04:59'),(17,NULL,32,NULL,NULL,NULL,NULL,1,'velo-mountain-bike','Vélo / mountain bike',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:55','2021-10-16 14:04:59'),(18,NULL,32,NULL,NULL,NULL,NULL,1,'petanque','Pétanque',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:55','2021-10-16 14:04:59'),(19,NULL,32,NULL,NULL,NULL,NULL,1,'slack-line','Slack line',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:56','2021-10-16 14:04:59'),(20,NULL,32,NULL,NULL,NULL,NULL,1,'frisbee','Frisbee',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:56','2021-10-16 14:04:59'),(21,NULL,33,NULL,NULL,NULL,NULL,1,'balades-avec-ou-sans-guides','Balades avec ou sans guides',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:57','2021-10-12 22:32:43'),(22,NULL,33,NULL,NULL,NULL,NULL,1,'pique-niques','Pique niques',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:57','2021-10-12 22:32:43'),(23,32,34,NULL,NULL,NULL,NULL,1,'piscine','Piscine','Essaouira, Sidi Kaouki, Moulay… La côte atlantique marocaine offre elle aussi des spots réputés ! Equipez-vous dʼun kite, une planche à voile, un surf ou un bodyboard et partez à lʼassaut des vagues ! Pétole ? Profitez-en pour faire du kayak, contourner lʼîle de Mogador. Les nombreux clubs bordant le littoral proposent des stages dʼinitiation ou de perfectionnement et du matériel de qualité en location.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:58','2021-10-12 22:32:43'),(24,85,34,NULL,NULL,NULL,NULL,1,'visites','Visites','Déambulez dans la célèbre médina grouillante d\'artisans et de commerçants pour découvrir bijoux berbères, épices ou poteries en tous genres. A l’occasion de la visite d’une coopérative, dénichez la célèbre huile d\'argan, véritable élixir de beauté pour la peau et les cheveux. Profitez des randonnées pédestres en forêt, flânez le long des plages de sable fin (grandiose), visitez les cascades, admirez les panoramas du littoral ou furetez dans les marchés locaux (retour au XIX siècle garanti). Essaouira et ses environs vous offrent un choix considérable de balades relaxantes et dépaysantes.',NULL,NULL,NULL,NULL,'Epoustouflant, dépaysant!',NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:58','2021-10-12 22:32:43'),(25,NULL,34,NULL,NULL,NULL,NULL,1,'visites-de-la-medina','Visites de la médina',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:59','2021-10-12 22:32:43'),(26,NULL,34,NULL,NULL,NULL,NULL,1,'les-marches','Les marchés','Had’dra, un marché gigantesque. Retour direct au 19ème siècle. Une expérience inoubliable.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:30:59','2021-10-12 22:32:43'),(27,NULL,34,NULL,NULL,NULL,NULL,1,'visites-de-marches','Visites de marchés',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:00','2021-10-12 22:32:43'),(28,NULL,34,NULL,NULL,NULL,NULL,1,'le-marche-aux-epices','Le marché aux épices',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:00','2021-10-12 22:32:43'),(29,NULL,34,NULL,NULL,NULL,NULL,1,'peche-et-bateau','Pêche et bateau','Mieux que taquiner le goujon, revenez avec une pêche miraculeuse. Faites vous plaisir en mer ou du bord de la plage et Layla cuisinera vos prises. Tournez autour des îles de Mogador à bord d\'un voilier de 12,50 m, observez les faucons Eléonors et les pêcheurs de sardines et regardez la medina avec un autre point de vue.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:00','2021-10-12 22:32:43'),(30,NULL,35,NULL,NULL,NULL,NULL,1,'hammam','Hammam',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:01','2021-10-12 22:32:43'),(31,2,36,NULL,NULL,NULL,NULL,1,'spa','Spa','Depuis quand nʼavez-vous pas pris un moment de pure détente, rien que pour vous ? Laissez-vous aller et expérimentez le traditionnel hammam avec gommage au savon noir, enveloppement au ghazoul et masque capillaire. Faites confiance aux mains expertes d’Hafssa et de Malika pour un massage tonique ou relaxant à lʼhuile dʼarganet avec le coeur. Vous pouvez également opter pour un soin beauté du visage, une manucure, une pédicure ou une épilation.',NULL,NULL,NULL,NULL,'Le bien être absolu!',NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:02','2021-10-12 22:32:43'),(32,NULL,36,NULL,NULL,NULL,NULL,1,'massage','Massage',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:03','2021-10-12 22:32:43'),(33,NULL,36,NULL,NULL,NULL,NULL,1,'soins-du-corps','Soins du corps',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:03','2021-10-12 22:32:43'),(34,NULL,36,NULL,NULL,NULL,NULL,1,'epilation','Epilation',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:03','2021-10-12 22:32:43'),(35,NULL,36,NULL,NULL,NULL,NULL,1,'soins-du-visage','Soins du visage',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:04','2021-10-12 22:32:43'),(36,NULL,37,NULL,NULL,NULL,NULL,1,'atelier-de-cuisine','Atelier de cuisine','Ramenez plus que vos souvenirs de vacances, prolongez lʼexpérience en apprenant les secrets de la cuisine locale avec notre chef Layla. Elle cuisine avec son cœur et adore partager ! Couscous, tajines, safa, soupes, pâtisseries... La cuisine marocaine est riche en saveurs issues du mélange des traditions culinaires berbère, arabe et même andalouse. Avec Layla, découvrez des recettes typiques et savoureuses, simples à refaire à la maison.',NULL,NULL,NULL,NULL,'Un savoir-faire ancestral à partager',NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:05','2021-10-12 22:32:43'),(37,NULL,37,NULL,NULL,NULL,NULL,1,'cours-de-cuisine','Cours de cuisine',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:05','2021-10-12 22:32:43'),(38,NULL,37,NULL,NULL,NULL,NULL,1,'cours-de-danse-marocaine','Cours de danse marocaine',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:06','2021-10-12 22:32:43'),(39,NULL,37,NULL,NULL,NULL,NULL,1,'cours-de-peinture','Cours de peinture',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:06','2021-10-12 22:32:43'),(40,NULL,37,NULL,NULL,NULL,NULL,1,'cours-de-massage','Cours de massage',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:07','2021-10-12 22:32:43'),(41,NULL,37,NULL,NULL,NULL,NULL,1,'cours-de-photos','Cours de photos',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:07','2021-10-12 22:32:43'),(42,NULL,37,NULL,NULL,NULL,NULL,1,'cours-de-marchandage','Cours de marchandage',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:08','2021-10-12 22:32:43'),(43,NULL,38,NULL,NULL,NULL,NULL,1,'lecture','Lecture',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:09','2021-10-12 22:32:43'),(44,NULL,38,NULL,NULL,NULL,NULL,1,'television','Télévision',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:09','2021-10-12 22:32:43'),(45,2,38,NULL,NULL,NULL,NULL,1,'jeux','Jeux','Découvrez et pratiquez des jeux passionnants qui donnent lieu à des parties acharnées. Il y en a pour tous les goûts et tous les âges, en solitaire, à deux, en famille ou en groupe. Voici quelquesexemples: jeux de cartes classiques, tarot, jeux de dés, dés de poker menteur, échecs, dames, majong, abalone, quarto, go, dominos, rubikubes, ballons de foot, balles, stack line, doodle…',NULL,NULL,NULL,NULL,'Passionnant!',NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:10','2021-10-12 22:32:43'),(46,NULL,38,NULL,NULL,NULL,NULL,1,'bains-de-soleil','Bains de soleil',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:11','2021-10-12 22:32:43'),(47,NULL,38,NULL,NULL,NULL,NULL,1,'rencontres','Rencontres',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:11','2021-10-12 22:32:43'),(48,NULL,38,NULL,NULL,NULL,NULL,1,'ne-rien-faire-et-en-profiter','Ne rien faire et en profiter',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:31:11','2021-10-12 22:32:43');

--
-- Table structure for table `hotel_activity_tag`
--

CREATE TABLE `hotel_activity_tag` (
  `hotel_activity_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY (`hotel_activity_id`,`tag_id`),
  KEY `IDX_DABFDA125F0E2AB9` (`hotel_activity_id`),
  KEY `IDX_DABFDA12BAD26311` (`tag_id`),
  CONSTRAINT `FK_DABFDA125F0E2AB9` FOREIGN KEY (`hotel_activity_id`) REFERENCES `hotel_activity` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_DABFDA12BAD26311` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_activity_tag`
--

INSERT INTO `hotel_activity_tag` VALUES (1,32),(2,32),(3,32),(4,32),(5,32),(6,32),(7,32),(8,32),(9,32),(10,32),(11,32),(12,32),(13,32),(14,32),(15,32),(16,32),(17,32),(18,32),(19,32),(20,32),(21,33),(22,33),(23,34),(24,34),(25,34),(26,34),(27,34),(28,34),(29,34),(30,35),(31,36),(32,36),(33,36),(34,36),(35,36),(36,37),(37,37),(38,37),(39,37),(40,37),(41,37),(42,37),(43,38),(44,38),(45,38),(46,38),(47,38),(48,38);

--
-- Table structure for table `hotel_amenity`
--

CREATE TABLE `hotel_amenity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `withPicto` tinyint(1) DEFAULT NULL,
  `slugPicto` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `more_info` longtext COLLATE utf8mb4_unicode_ci,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_782A674A12469DE2` (`category_id`),
  KEY `IDX_782A674AF987D8A8` (`user_created_id`),
  KEY `IDX_782A674A9828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_782A674A12469DE2` FOREIGN KEY (`category_id`) REFERENCES `tag` (`id`),
  CONSTRAINT `FK_782A674A9828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_782A674AF987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_amenity`
--

INSERT INTO `hotel_amenity` VALUES (1,13,NULL,NULL,NULL,NULL,'','lit-double-160-200','Lit double 160/200',NULL,NULL,NULL,'2021-10-12 22:31:12','2021-10-12 22:32:43'),(2,13,NULL,NULL,NULL,NULL,'','salle-de-bains-douche-ou-baignoire-douche','Salle de bains, douche ou baignoire/douche',NULL,NULL,NULL,'2021-10-12 22:31:13','2021-10-12 22:32:43'),(3,13,NULL,NULL,NULL,NULL,'commune aux 4 chambres face au jardin','terrasse-sur-jardin-orientee-ouest','Terrasse sur jardin orientée ouest',NULL,NULL,NULL,'2021-10-12 22:31:13','2021-10-12 22:32:43'),(4,13,NULL,NULL,NULL,NULL,'','toilettes','Toilettes',NULL,NULL,NULL,'2021-10-12 22:31:14','2021-10-12 22:32:43'),(5,13,NULL,NULL,NULL,NULL,'','salle-de-bains-2-vasques-baignoire-douche-ou-douche','salle de bains 2 vasques, baignoire/douche ou douche',NULL,NULL,NULL,'2021-10-12 22:31:16','2021-10-12 22:32:43'),(6,13,NULL,NULL,NULL,NULL,'','cheminee','Cheminée',NULL,NULL,NULL,'2021-10-12 22:31:17','2021-10-12 22:32:43'),(7,13,NULL,NULL,NULL,NULL,'','terrasse-orientee-sud','Terrasse orientée sud',NULL,NULL,NULL,'2021-10-12 22:31:17','2021-10-12 22:32:43'),(8,13,NULL,NULL,NULL,NULL,'','toilettes-separees','Toilettes séparées',NULL,NULL,NULL,'2021-10-12 22:31:17','2021-10-12 22:32:43'),(9,13,NULL,NULL,NULL,NULL,'15€/jour petit déjeuner compris','lit-supplementaire-a-la-demande','lit supplémentaire à la demande',NULL,NULL,NULL,'2021-10-12 22:31:18','2021-10-12 22:32:43'),(10,13,NULL,NULL,NULL,NULL,'','vue-sur-mer','Vue sur mer',NULL,NULL,NULL,'2021-10-12 22:31:19','2021-10-12 22:32:43'),(11,13,NULL,NULL,NULL,NULL,'toilettes séparées','salle-de-bains-2-vasques-douche','Salle de bains 2 vasques, douche',NULL,NULL,NULL,'2021-10-12 22:31:20','2021-10-12 22:32:43'),(12,13,NULL,NULL,NULL,NULL,'de 100m2 avec vue sur l’océan','grande-terrasse-privative','Grande terrasse privative',NULL,NULL,NULL,'2021-10-12 22:31:21','2021-10-12 22:32:43'),(13,13,NULL,NULL,NULL,NULL,'','grande-terrasse-privative-100m2','Grande terrasse privative (100m2)',NULL,NULL,NULL,'2021-10-12 22:31:22','2021-10-12 22:32:43'),(14,13,NULL,NULL,NULL,NULL,'','salle-de-bains-douche-toilettes','Salle de bains, douche, toilettes',NULL,NULL,NULL,'2021-10-12 22:31:23','2021-10-12 22:32:43'),(15,13,NULL,NULL,NULL,NULL,'canapés pouvant être transformés en 2 lits simples supplémentaires pour les enfants (supplément pour occupation)','salon','Salon',NULL,NULL,NULL,'2021-10-12 22:31:24','2021-10-12 22:32:43'),(16,44,NULL,NULL,NULL,NULL,'','lit-double-160-200-1','Lit double 160/200',NULL,NULL,NULL,'2021-10-12 22:31:26','2021-10-12 22:32:43'),(17,44,NULL,NULL,NULL,NULL,'','salle-de-bains-2-vasques-douche-1','Salle de bains 2 vasques, douche',NULL,NULL,NULL,'2021-10-12 22:31:26','2021-10-12 22:32:43'),(18,44,NULL,NULL,NULL,NULL,'','toilettes-separees-1','Toilettes séparées',NULL,NULL,NULL,'2021-10-12 22:31:27','2021-10-12 22:32:43'),(19,44,NULL,NULL,NULL,NULL,'','cheminee-1','Cheminée',NULL,NULL,NULL,'2021-10-12 22:31:27','2021-10-12 22:32:43'),(20,44,NULL,NULL,NULL,NULL,'de 100 m2 orientée nord avec vue sur l’océan','grande-terrasse-privative-1','Grande terrasse privative',NULL,NULL,NULL,'2021-10-12 22:31:27','2021-10-12 22:32:43'),(21,45,NULL,NULL,NULL,NULL,'ou par la porte communicante avec la chambre','entree-independante','Entrée indépendante',NULL,NULL,NULL,'2021-10-12 22:31:28','2021-10-12 22:32:43'),(22,45,NULL,NULL,NULL,NULL,'possibilité d’ajouter un lit supplémentaire (15€)','2-lits-simples-90-200-ou-3-banquettes-salon','2 lits simples 90/200 ou 3 banquettes salon',NULL,NULL,NULL,'2021-10-12 22:31:29','2021-10-12 22:32:43'),(23,44,NULL,NULL,NULL,NULL,'','vue-sur-mer-1','Vue sur mer',NULL,NULL,NULL,'2021-10-12 22:31:30','2021-10-12 22:32:43'),(24,44,NULL,NULL,NULL,NULL,'','salle-de-bains-2-vasques','Salle de bains 2 vasques',NULL,NULL,NULL,'2021-10-12 22:31:31','2021-10-12 22:32:43'),(25,44,NULL,NULL,NULL,NULL,'','baignoire-et-douche-separees','Baignoire et douche séparées',NULL,NULL,NULL,'2021-10-12 22:31:31','2021-10-12 22:32:43'),(26,44,NULL,NULL,NULL,NULL,'','2-terrasses-nord-et-sud','2 terrasses nord et sud',NULL,NULL,NULL,'2021-10-12 22:31:32','2021-10-12 22:32:43'),(27,44,NULL,NULL,NULL,NULL,'','dressing-10m2','Dressing 10m2',NULL,NULL,NULL,'2021-10-12 22:31:33','2021-10-12 22:32:43'),(28,47,NULL,NULL,NULL,NULL,'','vue-sur-mer-2','Vue sur mer',NULL,NULL,NULL,'2021-10-12 22:31:33','2021-10-12 22:32:43'),(29,47,NULL,NULL,NULL,NULL,'','canape-convertible','Canapé convertible',NULL,NULL,NULL,'2021-10-12 22:31:34','2021-10-12 22:32:43'),(30,47,NULL,NULL,NULL,NULL,'','cheminee-2','Cheminée',NULL,NULL,NULL,'2021-10-12 22:31:34','2021-10-12 22:32:43'),(31,47,NULL,NULL,NULL,NULL,'','double-terrasse','Double Terrasse',NULL,NULL,NULL,'2021-10-12 22:31:35','2021-10-12 22:32:43'),(32,13,NULL,NULL,NULL,NULL,'','cinq-salons-aux-ambiances-differentes','Cinq salons aux ambiances différentes.',NULL,NULL,NULL,'2021-10-12 22:31:36','2021-10-16 17:26:40'),(33,13,NULL,NULL,NULL,NULL,'','la-grande-suite-avec-son-salon-et-sa-vue-magnifique-et-un-patio','La Grande Suite avec son salon et sa vue magnifique et un patio.',NULL,NULL,NULL,'2021-10-12 22:31:36','2021-10-16 17:26:40'),(34,13,NULL,NULL,NULL,NULL,'et un toit plat pour admirer la vue ou contempler le ciel étoilé.','nombreuses-terrasses','Nombreuses terrasses',NULL,NULL,NULL,'2021-10-12 22:31:37','2021-10-16 17:26:40'),(35,13,NULL,NULL,NULL,NULL,'pour réunir tout le monde et d\'autres lieux pour manger de manière plus intime.','une-salle-a-manger','Une salle à manger',NULL,NULL,NULL,'2021-10-12 22:31:37','2021-10-16 17:26:40'),(36,13,NULL,NULL,NULL,NULL,'(lave vaisselle, robots, machine à laver, sèche linge …).','une-grande-cuisine-entierement-equipee','Une grande cuisine entièrement équipée',NULL,NULL,NULL,'2021-10-12 22:31:38','2021-10-16 17:26:40'),(37,13,NULL,NULL,NULL,NULL,'','une-piscine-15m-5-et-un-couloir-de-nage-22m-3-5','Une piscine (15m*5) et un couloir de nage (22m*3.5).',NULL,NULL,NULL,'2021-10-12 22:31:38','2021-10-16 17:26:40'),(38,13,NULL,NULL,NULL,NULL,'','differents-jardins-et-un-parking-prive','Différents jardins et un parking privé.',NULL,NULL,NULL,'2021-10-12 22:31:39','2021-10-16 17:26:40'),(39,13,NULL,NULL,NULL,NULL,'','un-hammam-et-deux-salons-de-massage','Un hammam et deux salons de massage.',NULL,NULL,NULL,'2021-10-12 22:31:39','2021-10-16 17:26:40'),(40,13,NULL,NULL,NULL,NULL,NULL,'nombreux-salons','Nombreux salons',NULL,NULL,NULL,'2021-10-12 22:31:44','2021-10-12 22:32:43'),(41,13,NULL,NULL,NULL,NULL,NULL,'piscine-de-15m','Piscine de 15m',NULL,NULL,NULL,'2021-10-12 22:31:45','2021-10-12 22:32:43'),(42,13,NULL,NULL,NULL,NULL,NULL,'pataugeoire-pour-les-enfants','Pataugeoire pour les enfants',NULL,NULL,NULL,'2021-10-12 22:31:45','2021-10-12 22:32:43'),(43,13,NULL,NULL,NULL,NULL,NULL,'couloir-de-nage-de-22m','Couloir de nage de 22m',NULL,NULL,NULL,'2021-10-12 22:31:46','2021-10-12 22:32:43'),(44,13,NULL,NULL,NULL,NULL,NULL,'solarium','Solarium',NULL,NULL,NULL,'2021-10-12 22:31:46','2021-10-12 22:32:43'),(45,13,NULL,NULL,NULL,NULL,NULL,'jardin','Jardin',NULL,NULL,NULL,'2021-10-12 22:31:46','2021-10-12 22:32:43'),(46,13,NULL,NULL,NULL,NULL,NULL,'terrasses','Terrasses',NULL,NULL,NULL,'2021-10-12 22:31:47','2021-10-12 22:32:43'),(47,13,NULL,NULL,NULL,NULL,NULL,'patio','Patio',NULL,NULL,NULL,'2021-10-12 22:31:47','2021-10-12 22:32:43'),(48,13,NULL,NULL,NULL,NULL,NULL,'wifi-disponible-sur-toute-la-propriete','WiFi disponible sur toute la propriété',NULL,NULL,NULL,'2021-10-12 22:31:48','2021-10-12 22:32:43'),(49,13,NULL,NULL,NULL,NULL,NULL,'seche-cheveux-dans-chaque-chambre','Sèche-cheveux dans chaque chambre',NULL,NULL,NULL,'2021-10-12 22:31:48','2021-10-12 22:32:43'),(50,13,NULL,NULL,NULL,NULL,NULL,'television-salon-tv-et-certaines-chambres','Télévision (salon TV et certaines chambres)',NULL,NULL,NULL,'2021-10-12 22:31:49','2021-10-12 22:32:43'),(51,13,NULL,NULL,NULL,NULL,NULL,'2-chaines-hifi','2 chaînes hifi',NULL,NULL,NULL,'2021-10-12 22:31:49','2021-10-12 22:32:43');

--
-- Table structure for table `hotel_amenity_tag`
--

CREATE TABLE `hotel_amenity_tag` (
  `hotel_amenity_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY (`hotel_amenity_id`,`tag_id`),
  KEY `IDX_C666FEA3EA4BF9E8` (`hotel_amenity_id`),
  KEY `IDX_C666FEA3BAD26311` (`tag_id`),
  CONSTRAINT `FK_C666FEA3BAD26311` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_C666FEA3EA4BF9E8` FOREIGN KEY (`hotel_amenity_id`) REFERENCES `hotel_amenity` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_amenity_tag`
--

INSERT INTO `hotel_amenity_tag` VALUES (1,39),(1,40),(1,41),(1,42),(2,39),(3,39),(3,42),(4,39),(5,40),(6,40),(6,41),(7,40),(8,40),(8,41),(9,40),(9,41),(10,41),(11,41),(12,41),(13,41),(14,42),(15,42),(16,43),(16,46),(17,43),(18,43),(18,46),(19,43),(19,46),(20,43),(21,43),(22,43),(23,46),(24,46),(25,46),(26,46),(27,46),(28,46),(29,46),(30,46),(31,46),(32,48),(32,49),(33,48),(33,49),(34,48),(34,49),(35,48),(35,49),(36,48),(36,49),(37,48),(37,49),(38,48),(38,49),(39,48),(39,49);

--
-- Table structure for table `hotel_room`
--

CREATE TABLE `hotel_room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `alternate_name` longtext COLLATE utf8mb4_unicode_ci,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C55A8713F987D8A8` (`user_created_id`),
  KEY `IDX_C55A87139828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_C55A87139828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_C55A8713F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_room`
--


--
-- Table structure for table `hotel_service`
--

CREATE TABLE `hotel_service` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `withPicto` tinyint(1) DEFAULT NULL,
  `slugPicto` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `more_info` longtext COLLATE utf8mb4_unicode_ci,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_32D784FB5E237E06` (`name`),
  KEY `IDX_32D784FB12469DE2` (`category_id`),
  KEY `IDX_32D784FBF987D8A8` (`user_created_id`),
  KEY `IDX_32D784FB9828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_32D784FB12469DE2` FOREIGN KEY (`category_id`) REFERENCES `tag` (`id`),
  CONSTRAINT `FK_32D784FB9828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_32D784FBF987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_service`
--

INSERT INTO `hotel_service` VALUES (1,50,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:31:50','2021-10-12 22:32:43','hygiene-proprete-en-conformite-avec-les-normes-du-covid-19','Hygiène / propreté en conformité avec les normes du Covid-19'),(2,50,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:31:51','2021-10-12 22:32:43','desinfection-des-chambres-a-chaque-changement-dhotes','Désinfection des chambres à chaque changement d’hôtes'),(3,50,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:31:51','2021-10-12 22:32:43','isolation-des-tables-pour-les-repas','Isolation des tables pour les repas'),(4,50,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:31:52','2021-10-12 22:32:43','eau-filtree-potable-et-gratuite','Eau filtrée potable et gratuite'),(5,50,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:31:52','2021-10-12 22:32:43','contact-medecin','Contact médecin'),(6,50,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:31:53','2021-10-12 22:32:43','gardien-de-nuit','Gardien de nuit'),(7,50,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:31:53','2021-10-12 22:32:43','parking-interieur','Parking Intérieur'),(8,51,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:31:54','2021-10-12 22:32:43','service-taxi-alentours-et-toute-destination-au-maroc','Service taxi, alentours et toute destination au Maroc'),(9,51,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:31:55','2021-10-12 22:32:43','navette-aeroport-payant','Navette aéroport (payant)'),(10,51,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:31:55','2021-10-12 22:32:43','location-de-voiture-avec-ou-sans-chauffeur','Location de voiture avec ou sans chauffeur'),(11,52,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:31:56','2021-10-12 22:32:43','preparation-minutieuse-de-votre-sejour','Préparation minutieuse de votre séjour'),(12,52,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:31:57','2021-10-12 22:32:43','check-in-et-check-out-24-24','Check in et check out 24/24'),(13,52,NULL,NULL,NULL,NULL,1,'nos records: dernier petit déjeuner servi à 15h30, dernier déjeuner à 18h et dernier dîner à 3h15','2021-10-12 22:31:57','2021-10-12 22:32:43','pas-dhoraires-pour-les-repas','Pas d’horaires pour les repas'),(14,52,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:31:58','2021-10-12 22:32:43','repas-vegetariens-ou-menus-specifiques-a-la-demande','Repas végétariens ou menus spécifiques à la demande'),(15,52,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:31:58','2021-10-12 22:32:43','reservations-de-toutes-les-activites-a-la-demande','Réservations de toutes les activités à la demande'),(16,52,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:31:59','2021-10-12 22:32:43','paiement-par-carte-bancaire-virement-especes','Paiement par carte bancaire / virement / espèces'),(17,52,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:00','2021-10-12 22:32:43','puce-telephonique-marocaine-a-la-demande','Puce téléphonique marocaine à la demande'),(18,52,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:00','2021-10-12 22:32:43','wifi-fibre-optique-dans-toute-la-villa-les-jardins-et-les-piscines','Wifi, fibre optique dans toute la villa les jardins et les piscines'),(19,52,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:01','2021-10-12 22:32:43','4-savons-maison-totalement-naturels-fournis-dans-les-chambres','4 savons maison totalement naturels fournis dans les chambres'),(20,52,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:01','2021-10-12 22:32:43','seche-cheveux-dans-chaque-chambre','Sèche-cheveux dans chaque chambre'),(21,52,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:02','2021-10-12 22:32:43','fer-a-repasser-a-la-demande','Fer à repasser à la demande'),(22,52,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:02','2021-10-12 22:32:43','service-pressing','Service pressing'),(23,52,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:03','2021-10-12 22:32:43','impression-des-billets-davion','Impression des billets d’avion'),(24,52,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:04','2021-10-12 22:32:43','quelques-mots-en-arabe-a-connaitre','Quelques mots en arabe à connaître'),(25,53,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:05','2021-10-12 22:32:43','selection-des-meilleurs-prestataires-pour-les-activites','Sélection des meilleurs prestataires pour les activités'),(26,53,NULL,NULL,NULL,NULL,1,'en fonction de vos souhaits: type de cuisine, animation/ tranquillité/ décoration, budget','2021-10-12 22:32:06','2021-10-12 22:32:43','conseils-pour-les-restaurants','Conseils pour les restaurants'),(27,53,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:06','2021-10-12 22:32:43','selection-des-meilleurs-prestataires','Sélection des meilleurs prestataires'),(28,53,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:07','2021-10-12 22:32:43','conseils-pour-les-restaurants-en-fonction-de-vos-souhaits','Conseils pour les restaurants en fonction de vos souhaits'),(29,53,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:08','2021-10-12 22:32:43','partage-de-la-culture-locale','Partage de la culture locale'),(30,53,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:09','2021-10-12 22:32:43','conseils-sur-les-visites-les-activites-les-marches-les-produits-locaux','Conseils sur les visites, les activités, les marchés, les produits locaux…'),(31,53,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:09','2021-10-12 22:32:43','accueil-en-cuisine-pour-apprendre-a-volonte','Accueil en cuisine pour apprendre à volonté'),(32,53,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:10','2021-10-12 22:32:43','un-the-chez-lhabitant','Un thé chez l’habitant'),(33,53,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:11','2021-10-12 22:32:43','huile-dargan-pure-a-prix-defiant-toute-concurrence','Huile d’Argan pure à prix défiant toute concurrence'),(34,54,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:12','2021-10-12 22:32:43','nombreux-espaces-pour-sisoler-au-calme','Nombreux espaces pour s’isoler au calme'),(35,54,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:12','2021-10-12 22:32:43','linge-de-maison-change-a-la-demande','Linge de maison changé à la demande'),(36,54,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:13','2021-10-12 22:32:43','serviettes-piscine','Serviettes piscine'),(37,54,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:13','2021-10-12 22:32:43','piscines-chauffees-a-29deg-toute-lannee','Piscines chauffées à 29° toute l’année'),(38,54,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:14','2021-10-12 22:32:43','couloir-de-nage','Couloir de nage'),(39,54,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:14','2021-10-12 22:32:43','solarium','Solarium'),(40,54,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:15','2021-10-12 22:32:43','television','Télévision'),(41,54,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:16','2021-10-12 22:32:43','netflix','Netflix'),(42,54,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:16','2021-10-12 22:32:43','hi-fi-bluetooth','Hi-fi/bluetooth'),(43,54,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:17','2021-10-12 22:32:43','fourniture-denceintes-en-chambre','Fourniture d’enceintes en chambre'),(44,54,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:18','2021-10-12 22:32:43','hammam-dans-notre-spa','Hammam dans notre spa'),(45,54,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:18','2021-10-12 22:32:43','soins-du-corps-dans-notre-spa','Soins du corps dans notre spa'),(46,54,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:19','2021-10-12 22:32:43','massage-dans-notre-spa','Massage dans notre spa'),(47,54,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:20','2021-10-12 22:32:43','feu-prepare-chaque-jour-dans-les-cheminees-des-chambres-et-des-salons','Feu préparé chaque jour dans les cheminées des chambres et des salons'),(48,54,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:20','2021-10-12 22:32:43','hamacs','Hamacs'),(49,55,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:22','2021-10-12 22:32:43','mise-a-disposition-de-jumelles','Mise à disposition de jumelles'),(50,55,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:22','2021-10-12 22:32:43','bibliotheque','Bibliothèque'),(51,55,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:23','2021-10-12 22:32:43','jeux-de-societe-a-disposition','Jeux de société à disposition'),(52,55,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:24','2021-10-12 22:32:43','organisation-devenements','Organisation d’évènements'),(53,55,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:25','2021-10-12 22:32:43','1-cadeau-surprise','+ 1 cadeau surprise'),(54,56,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:26','2021-10-12 22:32:43','baby-sitter-a-la-demande','Baby-Sitter à la demande'),(55,56,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:26','2021-10-12 22:32:43','lit-bebe','Lit bébé'),(56,56,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:27','2021-10-12 22:32:43','chauffe-biberon','Chauffe biberon'),(57,56,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:27','2021-10-12 22:32:43','chaises-enfants','Chaises enfants'),(58,56,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:28','2021-10-12 22:32:43','baignoire-bebe','Baignoire bébé'),(59,56,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:29','2021-10-12 22:32:43','poussette','Poussette'),(60,56,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:29','2021-10-12 22:32:43','bassin-pour-enfants','Bassin pour enfants'),(61,56,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:30','2021-10-12 22:32:43','livres-pour-enfants','Livres pour enfants'),(62,56,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:31','2021-10-12 22:32:43','jeux-pour-enfants','Jeux pour enfants'),(63,57,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:32','2021-10-12 22:32:43','sa-gentillesse-a-letat-pur-et-son-envie-de-vous-faire-plaisir','Sa gentillesse à l’état pur et son envie de vous faire plaisir'),(64,57,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:33','2021-10-12 22:32:43','sa-disponibilite-permanente','Sa disponibilité permanente'),(65,57,NULL,NULL,NULL,NULL,1,'','2021-10-12 22:32:33','2021-10-12 22:32:43','tour-daccueil','Tour d’accueil');

--
-- Table structure for table `hotel_service_tag`
--

CREATE TABLE `hotel_service_tag` (
  `hotel_service_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY (`hotel_service_id`,`tag_id`),
  KEY `IDX_FF178EDB9888430B` (`hotel_service_id`),
  KEY `IDX_FF178EDBBAD26311` (`tag_id`),
  CONSTRAINT `FK_FF178EDB9888430B` FOREIGN KEY (`hotel_service_id`) REFERENCES `hotel_service` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_FF178EDBBAD26311` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_service_tag`
--

INSERT INTO `hotel_service_tag` VALUES (1,50),(2,50),(3,50),(4,50),(5,50),(6,50),(7,50),(8,51),(9,51),(10,51),(11,52),(12,52),(13,52),(14,52),(15,52),(16,52),(17,52),(18,52),(19,52),(20,52),(21,52),(22,52),(23,52),(24,52),(25,53),(26,53),(27,53),(28,53),(29,53),(30,53),(31,53),(32,53),(33,53),(34,54),(35,54),(36,54),(37,54),(38,54),(39,54),(40,54),(41,54),(42,54),(43,54),(44,54),(45,54),(46,54),(47,54),(48,54),(49,55),(50,55),(51,55),(52,55),(53,55),(54,56),(55,56),(56,56),(57,56),(58,56),(59,56),(60,56),(61,56),(62,56),(63,57),(64,57),(65,57);

--
-- Table structure for table `hotel_typical_day`
--

CREATE TABLE `hotel_typical_day` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_6252F31812469DE2` (`category_id`),
  KEY `IDX_6252F318F987D8A8` (`user_created_id`),
  KEY `IDX_6252F3189828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_6252F31812469DE2` FOREIGN KEY (`category_id`) REFERENCES `tag` (`id`),
  CONSTRAINT `FK_6252F3189828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_6252F318F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_typical_day`
--

INSERT INTO `hotel_typical_day` VALUES (1,13,NULL,NULL,1,'une-journee-cool','Une journée cool',NULL,NULL,NULL,'2021-10-12 22:30:35','2021-10-16 17:33:39'),(2,13,NULL,NULL,1,'une-journee-tonique','Une journée tonique',NULL,NULL,NULL,'2021-10-12 22:30:40','2021-10-16 17:33:39'),(3,13,NULL,NULL,1,'une-journee-visite','Une journée visite',NULL,NULL,NULL,'2021-10-12 22:30:44','2021-10-16 17:33:39');

--
-- Table structure for table `hotel_typical_day_element`
--

CREATE TABLE `hotel_typical_day_element` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `primary_image_id` int(11) DEFAULT NULL,
  `secondary_image_id` int(11) DEFAULT NULL,
  `hotel_typical_day_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `event_id` int(11) DEFAULT NULL,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hours` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label_bg_transparent` tinyint(1) NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_6D74384F989D9B62` (`slug`),
  KEY `IDX_6D74384F1CDA489C` (`primary_image_id`),
  KEY `IDX_6D74384FA604F92B` (`secondary_image_id`),
  KEY `IDX_6D74384FCE80B53C` (`hotel_typical_day_id`),
  KEY `IDX_6D74384F12469DE2` (`category_id`),
  KEY `IDX_6D74384F71F7E88B` (`event_id`),
  KEY `IDX_6D74384FF987D8A8` (`user_created_id`),
  KEY `IDX_6D74384F9828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_6D74384F12469DE2` FOREIGN KEY (`category_id`) REFERENCES `tag` (`id`),
  CONSTRAINT `FK_6D74384F1CDA489C` FOREIGN KEY (`primary_image_id`) REFERENCES `media_object` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_6D74384F71F7E88B` FOREIGN KEY (`event_id`) REFERENCES `event` (`id`),
  CONSTRAINT `FK_6D74384F9828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_6D74384FA604F92B` FOREIGN KEY (`secondary_image_id`) REFERENCES `media_object` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_6D74384FCE80B53C` FOREIGN KEY (`hotel_typical_day_id`) REFERENCES `hotel_typical_day` (`id`),
  CONSTRAINT `FK_6D74384FF987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_typical_day_element`
--

INSERT INTO `hotel_typical_day_element` VALUES (1,36,36,1,15,NULL,NULL,NULL,'REVEIL EN DOUCEUR','Sur ma terrasse à mon rythme','sur-ma-terrasse-a-mon-rythme','10h',1,'Sur ma terrasse à mon rythme',1,'2021-10-12 22:30:35','2021-10-16 17:33:39'),(2,32,32,1,16,NULL,NULL,NULL,'FARNIENTE','Baignades, lecture, musique, discussions …','baignades-lecture-musique-discussions','11h',1,'Baignades, lecture, musique, discussions …',1,'2021-10-12 22:30:36','2021-10-16 17:33:39'),(3,85,85,1,17,NULL,NULL,NULL,'VUE SUR LA MER','Trop bon avec en plus le sourire d’Hafssa','trop-bon-avec-en-plus-le-sourire-dhafssa','14h',1,'Trop bon avec en plus le sourire d’Hafssa',1,'2021-10-12 22:30:37','2021-10-16 17:33:39'),(4,85,85,1,18,NULL,NULL,NULL,'UNE MERVEILLE','Ouah! Le petit galop sur la plage','ouah-le-petit-galop-sur-la-plage','15h30',1,'Ouah! Le petit galop sur la plage',1,'2021-10-12 22:30:37','2021-10-16 17:33:39'),(5,141,141,1,16,NULL,NULL,NULL,'RELAX','En sirotant un cocktail de fruits','en-sirotant-un-cocktail-de-fruits','17h30',1,'En sirotant un cocktail de fruits',1,'2021-10-12 22:30:37','2021-10-16 17:33:39'),(6,85,85,1,19,NULL,NULL,NULL,'DU CHARME','Bonne douche et coucher de soleil sur ma terrasse','bonne-douche-et-coucher-de-soleil-sur-ma-terrasse','19h30',1,'Bonne douche et coucher de soleil sur ma terrasse',1,'2021-10-12 22:30:38','2021-10-16 17:33:39'),(7,85,85,1,20,NULL,NULL,NULL,'QUEL PLAISIR','Les mignardises maison et les histoires de Bruno','les-mignardises-maison-et-les-histoires-de-bruno','20h',1,'Les mignardises maison et les histoires de Bruno',1,'2021-10-12 22:30:39','2021-10-16 17:33:39'),(8,141,141,1,21,NULL,NULL,NULL,'UN DELICE','Aux chandelles en amoureux à Gonatouki','aux-chandelles-en-amoureux-a-gonatouki','20h30',1,'Aux chandelles en amoureux à Gonatouki',1,'2021-10-12 22:30:40','2021-10-16 17:33:39'),(9,36,36,2,15,NULL,NULL,NULL,'MERCI!!!','jus frais, Fruits, pain maison, crêpe, pancake, beignet, œufs, café et thé…','jus-frais-fruits-pain-maison-crepe-pancake-beignet-oeufs-cafe-et-the','8h30',1,'jus frais, Fruits, pain maison, crêpe, pancake, beignet, œufs, café et thé…',1,'2021-10-12 22:30:40','2021-10-16 17:33:39'),(10,32,32,2,22,NULL,NULL,NULL,'QUEL PLAISIR!','Avec Gona et Touki','avec-gona-et-touki','9h',1,'Avec Gona et Touki',1,'2021-10-12 22:30:41','2021-10-16 17:33:39'),(11,81,81,2,23,NULL,NULL,NULL,'EN PLEINE FORME!','50 longueurs dans le couloir de nage','50-longueurs-dans-le-couloir-de-nage','10h30',1,'50 longueurs dans le couloir de nage',1,'2021-10-12 22:30:42','2021-10-16 17:33:39'),(12,86,86,2,24,NULL,NULL,NULL,'JE M’ÉCLATE!','Matériel top et conditions parfaites. Merci pour les conseils.','materiel-top-et-conditions-parfaites-merci-pour-les-conseils','12h',1,'Matériel top et conditions parfaites. Merci pour les conseils.',1,'2021-10-12 22:30:42','2021-10-16 17:33:39'),(13,24,24,2,17,NULL,NULL,NULL,'QUEL SPECTACLE!','En bordure de mer: diététique et très bon','en-bordure-de-mer-dietetique-et-tres-bon','14h30',1,'En bordure de mer: diététique et très bon',1,'2021-10-12 22:30:43','2021-10-16 17:33:39'),(14,24,24,2,25,NULL,NULL,NULL,'PASSIONNANT','La négo: une sacrée expérience','la-nego-une-sacree-experience','16h',1,'La négo: une sacrée expérience',1,'2021-10-12 22:30:43','2021-10-16 17:33:39'),(15,12,12,2,20,NULL,NULL,NULL,'SUPER SYMPA','Echanges avec d’autres hôtes sur nos expériences du jour','echanges-avec-dautres-hotes-sur-nos-experiences-du-jour','20h30',1,'Echanges avec d’autres hôtes sur nos expériences du jour',1,'2021-10-12 22:30:44','2021-10-16 17:33:39'),(16,12,12,2,21,NULL,NULL,NULL,'TROP BON!','Devant la cheminée. La pastilla de poisson quelle saveur!','devant-la-cheminee-la-pastilla-de-poisson-quelle-saveur','21h15',1,'Devant la cheminée. La pastilla de poisson quelle saveur!',1,'2021-10-12 22:30:44','2021-10-16 17:33:39'),(17,36,36,3,26,NULL,NULL,NULL,'DEPAYSANT','Retour direct au 19ème siècle','retour-direct-au-19eme-siecle','9h30',1,'Retour direct au 19ème siècle',1,'2021-10-12 22:30:45','2021-10-16 17:33:39'),(18,32,32,3,27,NULL,NULL,NULL,'ETONNANT','Le port et son marché aux poissons','le-port-et-son-marche-aux-poissons','11h30',1,'Le port et son marché aux poissons',1,'2021-10-12 22:30:46','2021-10-16 17:33:39'),(19,81,81,3,28,NULL,NULL,NULL,'SURPRENANT','A la découverte de l’objet improbable','a-la-decouverte-de-lobjet-improbable','13h30',1,'A la découverte de l’objet improbable',1,'2021-10-12 22:30:46','2021-10-16 17:33:39'),(20,86,86,3,29,NULL,NULL,NULL,'A COUPER LE SOUFFLE!','Seul au monde','seul-au-monde','14h30',1,'Seul au monde',1,'2021-10-12 22:30:47','2021-10-16 17:33:39'),(21,24,24,3,30,NULL,NULL,NULL,'AUTHENTIQUE','Les ruelles, les artisans, le marché aux épices…','les-ruelles-les-artisans-le-marche-aux-epices','17h',1,'Les ruelles, les artisans, le marché aux épices…',1,'2021-10-12 22:30:48','2021-10-16 17:33:39'),(22,24,24,3,31,NULL,NULL,NULL,'INCONTOURNABLE','Quelle détente! j’en veux un tous les jours','quelle-detente-jen-veux-un-tous-les-jours','19h',1,'Quelle détente! j’en veux un tous les jours',1,'2021-10-12 22:30:48','2021-10-16 17:33:39'),(23,12,12,3,21,NULL,NULL,NULL,'ENCORE!','Avec le sourire d’Hafssa de l’apéritif au dessert','avec-le-sourire-dhafssa-de-laperitif-au-dessert','21h',1,'Avec le sourire d’Hafssa de l’apéritif au dessert',1,'2021-10-12 22:30:49','2021-10-16 17:33:39');

--
-- Table structure for table `hotel_typical_day_tag`
--

CREATE TABLE `hotel_typical_day_tag` (
  `hotel_typical_day_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY (`hotel_typical_day_id`,`tag_id`),
  KEY `IDX_47FC2322CE80B53C` (`hotel_typical_day_id`),
  KEY `IDX_47FC2322BAD26311` (`tag_id`),
  CONSTRAINT `FK_47FC2322BAD26311` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_47FC2322CE80B53C` FOREIGN KEY (`hotel_typical_day_id`) REFERENCES `hotel_typical_day` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_typical_day_tag`
--

INSERT INTO `hotel_typical_day_tag` VALUES (1,13),(2,13),(3,13);

--
-- Table structure for table `image_gallerie`
--

CREATE TABLE `image_gallerie` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_id` int(11) NOT NULL,
  `gallery_id` int(11) NOT NULL,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `position` int(11) NOT NULL,
  `in_slider` tinyint(1) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_ECA314693DA5256D` (`image_id`),
  KEY `IDX_ECA314694E7AF8F` (`gallery_id`),
  KEY `IDX_ECA31469F987D8A8` (`user_created_id`),
  KEY `IDX_ECA314699828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_ECA314693DA5256D` FOREIGN KEY (`image_id`) REFERENCES `media_object` (`id`),
  CONSTRAINT `FK_ECA314694E7AF8F` FOREIGN KEY (`gallery_id`) REFERENCES `gallery` (`id`),
  CONSTRAINT `FK_ECA314699828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_ECA31469F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `image_gallerie`
--

INSERT INTO `image_gallerie` VALUES (1,32,1,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(2,33,1,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(3,34,1,NULL,NULL,3,0,NULL,NULL,NULL,NULL),(4,35,1,NULL,NULL,4,0,NULL,NULL,NULL,NULL),(5,36,1,NULL,NULL,5,0,NULL,NULL,NULL,NULL),(6,37,1,NULL,NULL,6,0,NULL,NULL,NULL,NULL),(7,38,2,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(8,39,2,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(9,40,2,NULL,NULL,3,0,NULL,NULL,NULL,NULL),(10,42,3,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(11,43,4,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(12,71,4,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(13,98,4,NULL,NULL,3,0,NULL,NULL,NULL,NULL),(14,45,5,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(15,47,5,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(16,48,5,NULL,NULL,3,0,NULL,NULL,NULL,NULL),(17,49,5,NULL,NULL,4,0,NULL,NULL,NULL,NULL),(18,50,5,NULL,NULL,5,0,NULL,NULL,NULL,NULL),(19,51,5,NULL,NULL,6,0,NULL,NULL,NULL,NULL),(20,53,5,NULL,NULL,7,0,NULL,NULL,NULL,NULL),(21,54,6,NULL,NULL,3,0,NULL,NULL,NULL,NULL),(22,56,6,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(23,57,6,NULL,NULL,3,0,NULL,NULL,NULL,NULL),(24,60,7,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(25,61,7,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(26,63,7,NULL,NULL,3,0,NULL,NULL,NULL,NULL),(27,64,7,NULL,NULL,4,0,NULL,NULL,NULL,NULL),(28,65,7,NULL,NULL,5,0,NULL,NULL,NULL,NULL),(29,66,7,NULL,NULL,6,0,NULL,NULL,NULL,NULL),(30,67,8,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(31,68,8,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(32,72,9,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(33,73,9,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(34,75,9,NULL,NULL,3,0,NULL,NULL,NULL,NULL),(35,76,9,NULL,NULL,4,0,NULL,NULL,NULL,NULL),(36,77,9,NULL,NULL,5,0,NULL,NULL,NULL,NULL),(37,78,10,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(38,79,10,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(39,80,10,NULL,NULL,3,0,NULL,NULL,NULL,NULL),(40,81,10,NULL,NULL,4,0,NULL,NULL,NULL,NULL),(41,82,10,NULL,NULL,5,0,NULL,NULL,NULL,NULL),(42,83,10,NULL,NULL,6,0,NULL,NULL,NULL,NULL),(43,84,10,NULL,NULL,7,0,NULL,NULL,NULL,NULL),(44,85,10,NULL,NULL,8,0,NULL,NULL,NULL,NULL),(45,86,10,NULL,NULL,9,0,NULL,NULL,NULL,NULL),(46,87,10,NULL,NULL,10,0,NULL,NULL,NULL,NULL),(47,88,10,NULL,NULL,11,0,NULL,NULL,NULL,NULL),(48,89,10,NULL,NULL,12,0,NULL,NULL,NULL,NULL),(49,90,11,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(50,91,11,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(51,93,11,NULL,NULL,3,0,NULL,NULL,NULL,NULL),(52,94,11,NULL,NULL,4,0,NULL,NULL,NULL,NULL),(53,96,11,NULL,NULL,5,0,NULL,NULL,NULL,NULL),(54,97,11,NULL,NULL,6,0,NULL,NULL,NULL,NULL),(55,99,12,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(56,100,12,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(57,101,12,NULL,NULL,3,0,NULL,NULL,NULL,NULL),(58,102,12,NULL,NULL,4,0,NULL,NULL,NULL,NULL),(59,103,12,NULL,NULL,5,0,NULL,NULL,NULL,NULL),(60,104,12,NULL,NULL,6,0,NULL,NULL,NULL,NULL),(61,105,13,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(62,106,13,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(63,107,13,NULL,NULL,3,0,NULL,NULL,NULL,NULL),(64,108,14,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(65,109,14,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(66,110,15,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(67,111,15,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(68,112,16,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(69,113,16,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(70,117,17,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(71,118,17,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(72,119,17,NULL,NULL,3,0,NULL,NULL,NULL,NULL),(73,120,17,NULL,NULL,4,0,NULL,NULL,NULL,NULL),(74,121,17,NULL,NULL,5,0,NULL,NULL,NULL,NULL),(75,122,17,NULL,NULL,6,0,NULL,NULL,NULL,NULL),(76,124,17,NULL,NULL,7,0,NULL,NULL,NULL,NULL),(77,125,17,NULL,NULL,8,0,NULL,NULL,NULL,NULL),(78,126,17,NULL,NULL,9,0,NULL,NULL,NULL,NULL),(79,127,17,NULL,NULL,10,0,NULL,NULL,NULL,NULL),(80,128,17,NULL,NULL,11,0,NULL,NULL,NULL,NULL),(81,130,17,NULL,NULL,12,0,NULL,NULL,NULL,NULL),(82,131,17,NULL,NULL,13,0,NULL,NULL,NULL,NULL),(83,132,17,NULL,NULL,14,0,NULL,NULL,NULL,NULL),(84,133,17,NULL,NULL,15,0,NULL,NULL,NULL,NULL),(85,134,17,NULL,NULL,16,0,NULL,NULL,NULL,NULL),(86,135,17,NULL,NULL,17,0,NULL,NULL,NULL,NULL),(87,136,17,NULL,NULL,18,0,NULL,NULL,NULL,NULL),(88,139,18,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(89,140,18,NULL,NULL,1,0,NULL,NULL,NULL,NULL),(90,141,18,NULL,NULL,2,0,NULL,NULL,NULL,NULL),(91,142,18,NULL,NULL,4,0,NULL,NULL,NULL,NULL),(92,144,18,NULL,NULL,5,0,NULL,NULL,NULL,NULL),(93,145,18,NULL,NULL,6,0,NULL,NULL,NULL,NULL),(94,146,18,NULL,NULL,7,0,NULL,NULL,NULL,NULL),(95,147,18,NULL,NULL,8,0,NULL,NULL,NULL,NULL),(96,148,18,NULL,NULL,9,0,NULL,NULL,NULL,NULL);

--
-- Table structure for table `images_galleries`
--

CREATE TABLE `images_galleries` (
  `gallery_id` int(11) NOT NULL,
  `media_object_id` int(11) NOT NULL,
  PRIMARY KEY (`gallery_id`,`media_object_id`),
  KEY `IDX_5ACAC58C4E7AF8F` (`gallery_id`),
  KEY `IDX_5ACAC58C64DE5A5` (`media_object_id`),
  CONSTRAINT `FK_5ACAC58C4E7AF8F` FOREIGN KEY (`gallery_id`) REFERENCES `gallery` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_5ACAC58C64DE5A5` FOREIGN KEY (`media_object_id`) REFERENCES `media_object` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `images_galleries`
--

INSERT INTO `images_galleries` VALUES (1,32),(1,33),(1,34),(1,35),(1,36),(1,37),(2,38),(2,39),(2,40),(3,42),(4,43),(4,71),(4,98),(5,45),(5,47),(5,48),(5,49),(5,50),(5,51),(5,53),(6,54),(6,56),(6,57),(7,60),(7,61),(7,63),(7,64),(7,65),(7,66),(8,67),(8,68),(9,72),(9,73),(9,75),(9,76),(9,77),(10,78),(10,79),(10,80),(10,81),(10,82),(10,83),(10,84),(10,85),(10,86),(10,87),(10,88),(10,89),(11,90),(11,91),(11,93),(11,94),(11,96),(11,97),(12,99),(12,100),(12,101),(12,102),(12,103),(12,104),(13,105),(13,106),(13,107),(14,108),(14,109),(15,110),(15,111),(16,112),(16,113),(17,117),(17,118),(17,119),(17,120),(17,121),(17,122),(17,124),(17,125),(17,126),(17,127),(17,128),(17,130),(17,131),(17,132),(17,133),(17,134),(17,135),(17,136),(18,139),(18,140),(18,141),(18,142),(18,144),(18,145),(18,146),(18,147),(18,148);

--
-- Table structure for table `invoice_element`
--

CREATE TABLE `invoice_element` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unitPrice` double NOT NULL,
  `totalWithoutTaxes` double DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_B39968EA2989F1FD` (`invoice_id`),
  CONSTRAINT `FK_B39968EA2989F1FD` FOREIGN KEY (`invoice_id`) REFERENCES `invoice` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invoice_element`
--


--
-- Table structure for table `invoice_order`
--

CREATE TABLE `invoice_order` (
  `invoice_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  PRIMARY KEY (`invoice_id`,`order_id`),
  UNIQUE KEY `UNIQ_C8F3C32D8D9F6D38` (`order_id`),
  KEY `IDX_C8F3C32D2989F1FD` (`invoice_id`),
  CONSTRAINT `FK_C8F3C32D2989F1FD` FOREIGN KEY (`invoice_id`) REFERENCES `invoice` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_C8F3C32D8D9F6D38` FOREIGN KEY (`order_id`) REFERENCES `order` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invoice_order`
--


--
-- Table structure for table `invoice_tracking`
--

CREATE TABLE `invoice_tracking` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `method_payment_id` int(11) DEFAULT NULL,
  `event_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `invoiceDate` datetime NOT NULL,
  `paymentDate` datetime DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `comment` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_B7543844D6D0C1D3` (`method_payment_id`),
  KEY `IDX_B754384471F7E88B` (`event_id`),
  CONSTRAINT `FK_B754384471F7E88B` FOREIGN KEY (`event_id`) REFERENCES `event` (`id`),
  CONSTRAINT `FK_B7543844D6D0C1D3` FOREIGN KEY (`method_payment_id`) REFERENCES `payment_method` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invoice_tracking`
--


--
-- Table structure for table `lounge_hotel_amenity`
--

CREATE TABLE `lounge_hotel_amenity` (
  `room_id` int(11) NOT NULL,
  `hotel_amenity_id` int(11) NOT NULL,
  PRIMARY KEY (`room_id`,`hotel_amenity_id`),
  KEY `IDX_7767D08754177093` (`room_id`),
  KEY `IDX_7767D087EA4BF9E8` (`hotel_amenity_id`),
  CONSTRAINT `FK_7767D08754177093` FOREIGN KEY (`room_id`) REFERENCES `room` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_7767D087EA4BF9E8` FOREIGN KEY (`hotel_amenity_id`) REFERENCES `hotel_amenity` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lounge_hotel_amenity`
--


--
-- Table structure for table `media_object`
--

CREATE TABLE `media_object` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `slug` varchar(160) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_size` int(11) DEFAULT NULL,
  `encoding_format` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `caption` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `original_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dimensions` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:simple_array)',
  `tmp_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_conform` tinyint(1) NOT NULL DEFAULT '0',
  `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `original_stamped_image` tinyint(1) NOT NULL,
  `alt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `regenerate_format` tinyint(1) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_14D43132989D9B62` (`slug`),
  KEY `IDX_14D43132F987D8A8` (`user_created_id`),
  KEY `IDX_14D431329828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_14D431329828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_14D43132F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_object`
--

INSERT INTO `media_object` VALUES (1,NULL,NULL,'demo-logo-jpg',27078,'image/jpg',NULL,'demo-logo.jpg','logo.jpg','800,800,2,width=\"800\" height=\"800\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Logo',0,'Demo Logo',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-logo.jpg',NULL,'2021-10-12 22:29:15','2021-10-12 22:32:43'),(2,NULL,NULL,'demo-spa-3184610-1920-jpg',174455,'image/jpg',NULL,'demo-spa-3184610-1920.jpg','spa-3184610_1920.jpg','1920,1280,2,width=\"1920\" height=\"1280\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Spa 3184610 1920',0,'Demo Spa 3184610 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-spa-3184610-1920.jpg',NULL,'2021-10-12 22:29:15','2021-10-12 22:32:43'),(3,NULL,NULL,'demo-kite-surfing-1030818-1920-jpg',243314,'image/jpg',NULL,'demo-kite-surfing-1030818-1920.jpg','kite-surfing-1030818_1920.jpg','1920,1280,2,width=\"1920\" height=\"1280\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Kite Surfing 1030818 1920',0,'Demo Kite Surfing 1030818 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-kite-surfing-1030818-1920.jpg',NULL,'2021-10-12 22:29:15','2021-10-12 22:32:43'),(4,NULL,NULL,'demo-essaouira-4621347-1920-jpg',444092,'image/jpg',NULL,'demo-essaouira-4621347-1920.jpg','essaouira-4621347_1920.jpg','1920,1283,2,width=\"1920\" height=\"1283\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Essaouira 4621347 1920',0,'Demo Essaouira 4621347 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-essaouira-4621347-1920.jpg',NULL,'2021-10-12 22:29:15','2021-10-12 22:32:43'),(5,NULL,NULL,'demo-beach-1673758-1920-jpg',414540,'image/jpg',NULL,'demo-beach-1673758-1920.jpg','beach-1673758_1920.jpg','1920,1280,2,width=\"1920\" height=\"1280\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Beach 1673758 1920',0,'Demo Beach 1673758 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-beach-1673758-1920.jpg',NULL,'2021-10-12 22:29:15','2021-10-12 22:32:43'),(6,NULL,NULL,'demo-image-not-found-png',202456,'image/png',NULL,'demo-image-not-found.png','image-not-found.png','2560,1440,3,width=\"2560\" height=\"1440\",8,image/png',NULL,0,NULL,1,0,'Demo Image Not Found',0,'Demo Image Not Found',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-image-not-found.png',NULL,'2021-10-12 22:29:15','2021-10-12 22:32:43'),(7,NULL,NULL,'demo-morocco-1327301-1920-jpg',876426,'image/jpg',NULL,'demo-morocco-1327301-1920.jpg','morocco-1327301_1920.jpg','1920,1281,2,width=\"1920\" height=\"1281\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Morocco 1327301 1920',0,'Demo Morocco 1327301 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-morocco-1327301-1920.jpg',NULL,'2021-10-12 22:29:15','2021-10-12 22:32:43'),(8,NULL,NULL,'demo-desert-4811850-1920-jpg',329723,'image/jpg',NULL,'demo-desert-4811850-1920.jpg','desert-4811850_1920.jpg','1920,1280,2,width=\"1920\" height=\"1280\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Desert 4811850 1920',0,'Demo Desert 4811850 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-desert-4811850-1920.jpg',NULL,'2021-10-12 22:29:15','2021-10-12 22:32:43'),(9,NULL,NULL,'demo-bed-3105994-1920-jpg',641466,'image/jpg',NULL,'demo-bed-3105994-1920.jpg','bed-3105994_1920.jpg','1920,1254,2,width=\"1920\" height=\"1254\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Bed 3105994 1920',0,'Demo Bed 3105994 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-bed-3105994-1920.jpg',NULL,'2021-10-12 22:29:15','2021-10-12 22:32:43'),(10,NULL,NULL,'demo-essaouira-1047484-1920-jpg',403773,'image/jpg',NULL,'demo-essaouira-1047484-1920.jpg','essaouira-1047484_1920.jpg','1920,1440,2,width=\"1920\" height=\"1440\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Essaouira 1047484 1920',0,'Demo Essaouira 1047484 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-essaouira-1047484-1920.jpg',NULL,'2021-10-12 22:29:16','2021-10-12 22:32:43'),(11,NULL,NULL,'demo-kite-2828045-1920-jpg',96967,'image/jpg',NULL,'demo-kite-2828045-1920.jpg','kite-2828045_1920.jpg','1920,1280,2,width=\"1920\" height=\"1280\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Kite 2828045 1920',0,'Demo Kite 2828045 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-kite-2828045-1920.jpg',NULL,'2021-10-12 22:29:16','2021-10-12 22:32:43'),(12,NULL,NULL,'demo-casablanca-4620328-1920-jpg',215466,'image/jpg',NULL,'demo-casablanca-4620328-1920.jpg','casablanca-4620328_1920.jpg','1920,1281,2,width=\"1920\" height=\"1281\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Casablanca 4620328 1920',0,'Demo Casablanca 4620328 1920',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-casablanca-4620328-1920.jpg',NULL,'2021-10-12 22:29:16','2021-10-16 17:33:39'),(13,NULL,NULL,'demo-5-nuits-en-riad-a-essaouira-jpg',267348,'image/jpg',NULL,'demo-5-nuits-en-riad-a-essaouira.jpg','5-nuits-en-riad-a-essaouira.jpg','2000,1142,2,width=\"2000\" height=\"1142\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo 5 Nuits En Riad A Essaouira',0,'Demo 5 Nuits En Riad A Essaouira',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-5-nuits-en-riad-a-essaouira.jpg',NULL,'2021-10-12 22:29:16','2021-10-16 14:04:59'),(14,NULL,NULL,'demo-desert-1270330-1920-jpg',261826,'image/jpg',NULL,'demo-desert-1270330-1920.jpg','desert-1270330_1920.jpg','1920,1281,2,width=\"1920\" height=\"1281\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Desert 1270330 1920',0,'Demo Desert 1270330 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-desert-1270330-1920.jpg',NULL,'2021-10-12 22:29:16','2021-10-12 22:32:43'),(15,NULL,NULL,'demo-essaouira-4902881-1920-jpg',527412,'image/jpg',NULL,'demo-essaouira-4902881-1920.jpg','essaouira-4902881_1920.jpg','1920,1278,2,width=\"1920\" height=\"1278\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Essaouira 4902881 1920',0,'Demo Essaouira 4902881 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-essaouira-4902881-1920.jpg',NULL,'2021-10-12 22:29:16','2021-10-12 22:32:43'),(16,NULL,NULL,'demo-essaouira-1139703-1920-jpg',324754,'image/jpg',NULL,'demo-essaouira-1139703-1920.jpg','essaouira-1139703_1920.jpg','1920,1080,2,width=\"1920\" height=\"1080\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Essaouira 1139703 1920',0,'Demo Essaouira 1139703 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-essaouira-1139703-1920.jpg',NULL,'2021-10-12 22:29:16','2021-10-12 22:32:43'),(17,NULL,NULL,'demo-abendstimmung-1047526-1920-jpg',240255,'image/jpg',NULL,'demo-abendstimmung-1047526-1920.jpg','abendstimmung-1047526_1920.jpg','1920,1440,2,width=\"1920\" height=\"1440\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Abendstimmung 1047526 1920',0,'Demo Abendstimmung 1047526 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-abendstimmung-1047526-1920.jpg',NULL,'2021-10-12 22:29:16','2021-10-12 22:32:43'),(18,NULL,NULL,'demo-desert-1979000-1920-jpg',214540,'image/jpg',NULL,'demo-desert-1979000-1920.jpg','desert-1979000_1920.jpg','1920,1280,2,width=\"1920\" height=\"1280\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Desert 1979000 1920',0,'Demo Desert 1979000 1920',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-desert-1979000-1920.jpg',NULL,'2021-10-12 22:29:16','2021-10-16 14:04:59'),(19,NULL,NULL,'demo-essaouira-1549947-1920-jpg',744602,'image/jpg',NULL,'demo-essaouira-1549947-1920.jpg','essaouira-1549947_1920.jpg','1920,1440,2,width=\"1920\" height=\"1440\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Essaouira 1549947 1920',0,'Demo Essaouira 1549947 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-essaouira-1549947-1920.jpg',NULL,'2021-10-12 22:29:16','2021-10-12 22:32:43'),(20,NULL,NULL,'demo-logo-orange-png',2919,'image/png',NULL,'demo-logo-orange.png','logo_orange.png','473,77,3,width=\"473\" height=\"77\",8,image/png',NULL,0,NULL,1,0,'Demo Logo Orange',0,'Demo Logo Orange',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-logo-orange.png',NULL,'2021-10-12 22:29:16','2021-10-12 22:32:43'),(21,NULL,NULL,'demo-logo-initial-jpg',33799,'image/jpg',NULL,'demo-logo-initial.jpg','logo-initial.jpg','692,519,2,width=\"692\" height=\"519\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Logo Initial',0,'Demo Logo Initial',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-logo-initial.jpg',NULL,'2021-10-12 22:29:16','2021-10-12 22:32:43'),(22,NULL,NULL,'demo-essaouira-4621340-1920-jpg',423648,'image/jpg',NULL,'demo-essaouira-4621340-1920.jpg','essaouira-4621340_1920.jpg','1920,1283,2,width=\"1920\" height=\"1283\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Essaouira 4621340 1920',0,'Demo Essaouira 4621340 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-essaouira-4621340-1920.jpg',NULL,'2021-10-12 22:29:16','2021-10-12 22:32:43'),(23,NULL,NULL,'demo-morocco-108639-1920-jpg',609239,'image/jpg',NULL,'demo-morocco-108639-1920.jpg','morocco-108639_1920.jpg','1920,1280,2,width=\"1920\" height=\"1280\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Morocco 108639 1920',0,'Demo Morocco 108639 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-morocco-108639-1920.jpg',NULL,'2021-10-12 22:29:16','2021-10-12 22:32:43'),(24,NULL,NULL,'demo-essaouira-1139708-1920-jpg',359236,'image/jpg',NULL,'demo-essaouira-1139708-1920.jpg','essaouira-1139708_1920.jpg','1920,1080,2,width=\"1920\" height=\"1080\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Essaouira 1139708 1920',0,'Demo Essaouira 1139708 1920',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-essaouira-1139708-1920.jpg',NULL,'2021-10-12 22:29:16','2021-10-16 17:33:39'),(25,NULL,NULL,'demo-trip-1422608-1920-jpg',206174,'image/jpg',NULL,'demo-trip-1422608-1920.jpg','trip-1422608_1920.jpg','1920,1280,2,width=\"1920\" height=\"1280\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Trip 1422608 1920',0,'Demo Trip 1422608 1920',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-trip-1422608-1920.jpg',NULL,'2021-10-12 22:29:16','2021-10-16 17:33:39'),(26,NULL,NULL,'demo-groynes-3044711-1920-jpg',391449,'image/jpg',NULL,'demo-groynes-3044711-1920.jpg','groynes-3044711_1920.jpg','1920,1079,2,width=\"1920\" height=\"1079\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Groynes 3044711 1920',0,'Demo Groynes 3044711 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-groynes-3044711-1920.jpg',NULL,'2021-10-12 22:29:16','2021-10-12 22:32:43'),(27,NULL,NULL,'demo-morocco-4730279-1920-jpg',504295,'image/jpg',NULL,'demo-morocco-4730279-1920.jpg','morocco-4730279_1920.jpg','1920,1280,2,width=\"1920\" height=\"1280\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Morocco 4730279 1920',0,'Demo Morocco 4730279 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-morocco-4730279-1920.jpg',NULL,'2021-10-12 22:29:16','2021-10-12 22:32:43'),(28,NULL,NULL,'demo-morocco-1463212-jpg',382076,'image/jpg',NULL,'demo-morocco-1463212.jpg','morocco-1463212.jpg','1920,1280,2,width=\"1920\" height=\"1280\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Morocco 1463212',0,'Demo Morocco 1463212',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-morocco-1463212.jpg',NULL,'2021-10-12 22:29:16','2021-10-12 22:32:43'),(29,NULL,NULL,'demo-desert-1101123-jpg',133583,'image/jpg',NULL,'demo-desert-1101123.jpg','desert-1101123.jpg','1920,1280,2,width=\"1920\" height=\"1280\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Desert 1101123',0,'Demo Desert 1101123',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-desert-1101123.jpg',NULL,'2021-10-12 22:29:16','2021-10-12 22:32:43'),(30,NULL,NULL,'demo-morocco-2465597-1920-jpg',334965,'image/jpg',NULL,'demo-morocco-2465597-1920.jpg','morocco-2465597_1920.jpg','1920,1280,2,width=\"1920\" height=\"1280\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Morocco 2465597 1920',0,'Demo Morocco 2465597 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-morocco-2465597-1920.jpg',NULL,'2021-10-12 22:29:16','2021-10-12 22:32:43'),(31,NULL,NULL,'demo-tajine-1623116-1920-jpg',365274,'image/jpg',NULL,'demo-tajine-1623116-1920.jpg','tajine-1623116_1920.jpg','1920,1122,2,width=\"1920\" height=\"1122\",8,3,image/jpeg',NULL,0,NULL,1,0,'Demo Tajine 1623116 1920',0,'Demo Tajine 1623116 1920',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/demo-tajine-1623116-1920.jpg',NULL,'2021-10-12 22:29:16','2021-10-12 22:32:43'),(32,NULL,NULL,'day-type-img-pool-jpg',232753,'image/jpg',NULL,'day-type-img-pool.jpg','IMG_POOL.jpg','1920,780,2,width=\"1920\" height=\"780\",8,3,image/jpeg',NULL,0,NULL,1,0,'Day Type Img Pool',0,'Day Type Img Pool',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/day-type-img-pool.jpg',NULL,'2021-10-12 22:30:10','2021-10-16 17:33:39'),(33,NULL,NULL,'day-type-img-diner-jpg',240238,'image/jpg',NULL,'day-type-img-diner.jpg','IMG_DINER.jpg','1920,780,2,width=\"1920\" height=\"780\",8,3,image/jpeg',NULL,0,NULL,1,0,'Day Type Img Diner',0,'Day Type Img Diner',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/day-type-img-diner.jpg',NULL,'2021-10-12 22:30:10','2021-10-16 17:33:39'),(34,NULL,NULL,'day-type-img-night-jpg',220472,'image/jpg',NULL,'day-type-img-night.jpg','IMG_NIGHT.jpg','1920,780,2,width=\"1920\" height=\"780\",8,3,image/jpeg',NULL,0,NULL,1,0,'Day Type Img Night',0,'Day Type Img Night',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/day-type-img-night.jpg',NULL,'2021-10-12 22:30:10','2021-10-16 17:33:39'),(35,NULL,NULL,'day-type-img-spa-jpg',183156,'image/jpg',NULL,'day-type-img-spa.jpg','IMG_SPA.jpg','2200,800,2,width=\"2200\" height=\"800\",8,3,image/jpeg',NULL,0,NULL,1,0,'Day Type Img Spa',0,'Day Type Img Spa',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/day-type-img-spa.jpg',NULL,'2021-10-12 22:30:10','2021-10-16 17:33:39'),(36,NULL,NULL,'day-type-img-ftour-jpg',363060,'image/jpg',NULL,'day-type-img-ftour.jpg','IMG_FTOUR.jpg','1500,1000,2,width=\"1500\" height=\"1000\",8,3,image/jpeg',NULL,0,NULL,1,0,'Day Type Img Ftour',0,'Day Type Img Ftour',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/day-type-img-ftour.jpg',NULL,'2021-10-12 22:30:10','2021-10-16 17:33:39'),(37,NULL,NULL,'day-type-img-trek-jpg',212676,'image/jpg',NULL,'day-type-img-trek.jpg','IMG_TREK.jpg','1663,868,2,width=\"1663\" height=\"868\",8,3,image/jpeg',NULL,0,NULL,1,0,'Day Type Img Trek',0,'Day Type Img Trek',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/day-type-img-trek.jpg',NULL,'2021-10-12 22:30:10','2021-10-16 17:33:39'),(38,NULL,NULL,'chambre-prestige-img-34181-jpg',1461451,'image/jpg',NULL,'chambre-prestige-img-34181.jpg','IMG_34181.jpg','4950,3300,2,width=\"4950\" height=\"3300\",8,3,image/jpeg',NULL,0,NULL,1,0,'Chambre Prestige Img 34181',0,'Chambre Prestige Img 34181',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/chambre-prestige-img-34181.jpg',NULL,'2021-10-12 22:30:10','2021-10-12 22:32:43'),(39,NULL,NULL,'chambre-prestige-img-34141-jpg',1575736,'image/jpg',NULL,'chambre-prestige-img-34141.jpg','IMG_34141.jpg','5200,3466,2,width=\"5200\" height=\"3466\",8,3,image/jpeg',NULL,0,NULL,1,0,'Chambre Prestige Img 34141',0,'Chambre Prestige Img 34141',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/chambre-prestige-img-34141.jpg',NULL,'2021-10-12 22:30:10','2021-10-12 22:32:43'),(40,NULL,NULL,'chambre-prestige-img-34231-jpg',1191340,'image/jpg',NULL,'chambre-prestige-img-34231.jpg','IMG_34231.jpg','5000,3332,2,width=\"5000\" height=\"3332\",8,3,image/jpeg',NULL,0,NULL,1,0,'Chambre Prestige Img 34231',0,'Chambre Prestige Img 34231',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/chambre-prestige-img-34231.jpg',NULL,'2021-10-12 22:30:10','2021-10-12 22:32:43'),(41,NULL,NULL,'patio-img-33181-vertical-jpg',1373293,'image/jpg',NULL,'patio-img-33181-vertical.jpg','IMG_33181.jpg','3400,5100,2,width=\"3400\" height=\"5100\",8,3,image/jpeg',NULL,0,NULL,1,0,'Patio Img 33181',0,'Patio Img 33181',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/patio-img-33181-vertical.jpg',NULL,'2021-10-12 22:30:10','2021-10-12 22:32:43'),(42,NULL,NULL,'patio-img-33191-jpg',1807337,'image/jpg',NULL,'patio-img-33191.jpg','IMG_33191.jpg','4800,3200,2,width=\"4800\" height=\"3200\",8,3,image/jpeg',NULL,0,NULL,1,0,'Patio Img 33191',0,'Patio Img 33191',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/patio-img-33191.jpg',NULL,'2021-10-12 22:30:10','2021-10-12 22:32:43'),(43,NULL,NULL,'hotel-logo-black-png',6197,'image/png',NULL,'hotel-logo-black.png','logo_black.png','473,77,3,width=\"473\" height=\"77\",8,image/png',NULL,0,NULL,1,0,'Hotel Logo Black',0,'Hotel Logo Black',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/hotel-logo-black.png',NULL,'2021-10-12 22:30:10','2021-10-12 22:32:43'),(44,NULL,NULL,'salons-img-38391-vertical-jpg',1711907,'image/jpg',NULL,'salons-img-38391-vertical.jpg','IMG_38391.jpg','3400,5100,2,width=\"3400\" height=\"5100\",8,3,image/jpeg',NULL,0,NULL,1,0,'Salons Img 38391',0,'Salons Img 38391',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/salons-img-38391-vertical.jpg',NULL,'2021-10-12 22:30:10','2021-10-12 22:32:43'),(45,NULL,NULL,'salons-img-32671-jpg',1695162,'image/jpg',NULL,'salons-img-32671.jpg','IMG_32671.jpg','4350,2900,2,width=\"4350\" height=\"2900\",8,3,image/jpeg',NULL,0,NULL,1,0,'Salons Img 32671',0,'Salons Img 32671',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/salons-img-32671.jpg',NULL,'2021-10-12 22:30:10','2021-10-12 22:32:43'),(46,NULL,NULL,'salons-img-32501-vertical-jpg',1713182,'image/jpg',NULL,'salons-img-32501-vertical.jpg','IMG_32501.jpg','2800,4200,2,width=\"2800\" height=\"4200\",8,3,image/jpeg',NULL,0,NULL,1,0,'Salons Img 32501',0,'Salons Img 32501',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/salons-img-32501-vertical.jpg',NULL,'2021-10-12 22:30:10','2021-10-12 22:32:43'),(47,NULL,NULL,'salons-img-32581-jpg',1612300,'image/jpg',NULL,'salons-img-32581.jpg','IMG_32581.jpg','5100,3400,2,width=\"5100\" height=\"3400\",8,3,image/jpeg',NULL,0,NULL,1,0,'Salons Img 32581',0,'Salons Img 32581',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/salons-img-32581.jpg',NULL,'2021-10-12 22:30:11','2021-10-12 22:32:43'),(48,NULL,NULL,'salons-img-32431-jpg',1906897,'image/jpg',NULL,'salons-img-32431.jpg','IMG_32431.jpg','5400,3600,2,width=\"5400\" height=\"3600\",8,3,image/jpeg',NULL,0,NULL,1,0,'Salons Img 32431',0,'Salons Img 32431',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/salons-img-32431.jpg',NULL,'2021-10-12 22:30:11','2021-10-12 22:32:43'),(49,NULL,NULL,'salons-img-32891-jpg',1666218,'image/jpg',NULL,'salons-img-32891.jpg','IMG_32891.jpg','6000,4000,2,width=\"6000\" height=\"4000\",8,3,image/jpeg',NULL,0,NULL,1,0,'Salons Img 32891',0,'Salons Img 32891',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/salons-img-32891.jpg',NULL,'2021-10-12 22:30:11','2021-10-12 22:32:43'),(50,NULL,NULL,'salons-img-32541-jpg',1868311,'image/jpg',NULL,'salons-img-32541.jpg','IMG_32541.jpg','4500,3000,2,width=\"4500\" height=\"3000\",8,3,image/jpeg',NULL,0,NULL,1,0,'Salons Img 32541',0,'Salons Img 32541',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/salons-img-32541.jpg',NULL,'2021-10-12 22:30:11','2021-10-12 22:32:43'),(51,NULL,NULL,'salons-img-32251-jpg',1734964,'image/jpg',NULL,'salons-img-32251.jpg','IMG_32251.jpg','4800,3200,2,width=\"4800\" height=\"3200\",8,3,image/jpeg',NULL,0,NULL,1,0,'Salons Img 32251',0,'Salons Img 32251',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/salons-img-32251.jpg',NULL,'2021-10-12 22:30:11','2021-10-12 22:32:43'),(52,NULL,NULL,'salons-img-32101-vertical-jpg',1798705,'image/jpg',NULL,'salons-img-32101-vertical.jpg','IMG_32101.jpg','3400,5100,2,width=\"3400\" height=\"5100\",8,3,image/jpeg',NULL,0,NULL,1,0,'Salons Img 32101',0,'Salons Img 32101',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/salons-img-32101-vertical.jpg',NULL,'2021-10-12 22:30:11','2021-10-12 22:32:43'),(53,NULL,NULL,'salons-img-32361-jpg',1772792,'image/jpg',NULL,'salons-img-32361.jpg','IMG_32361.jpg','5200,3466,2,width=\"5200\" height=\"3466\",8,3,image/jpeg',NULL,0,NULL,1,0,'Salons Img 32361',0,'Salons Img 32361',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/salons-img-32361.jpg',NULL,'2021-10-12 22:30:11','2021-10-12 22:32:43'),(54,NULL,NULL,'chambre-confort-img-37801-jpg',1829919,'image/jpg',NULL,'chambre-confort-img-37801.jpg','IMG_37801.jpg','6500,4331,2,width=\"6500\" height=\"4331\",8,3,image/jpeg',NULL,0,NULL,1,0,'Chambre Confort Img 37801',0,'Chambre Confort Img 37801',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/chambre-confort-img-37801.jpg',NULL,'2021-10-12 22:30:11','2021-10-12 22:32:43'),(55,NULL,NULL,'chambre-confort-img-35851-vertical-jpg',1402338,'image/jpg',NULL,'chambre-confort-img-35851-vertical.jpg','IMG_35851.jpg','3333,5000,2,width=\"3333\" height=\"5000\",8,3,image/jpeg',NULL,0,NULL,1,0,'Chambre Confort Img 35851',0,'Chambre Confort Img 35851',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/chambre-confort-img-35851-vertical.jpg',NULL,'2021-10-12 22:30:11','2021-10-12 22:32:43'),(56,NULL,NULL,'chambre-confort-img-37761-jpg',1344264,'image/jpg',NULL,'chambre-confort-img-37761.jpg','IMG_37761.jpg','5100,3400,2,width=\"5100\" height=\"3400\",8,3,image/jpeg',NULL,0,NULL,1,0,'Chambre Confort Img 37761',0,'Chambre Confort Img 37761',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/chambre-confort-img-37761.jpg',NULL,'2021-10-12 22:30:11','2021-10-12 22:32:43'),(57,NULL,NULL,'chambre-confort-img-37681-jpg',1687112,'image/jpg',NULL,'chambre-confort-img-37681.jpg','IMG_37681.jpg','6800,4531,2,width=\"6800\" height=\"4531\",8,3,image/jpeg',NULL,0,NULL,1,0,'Chambre Confort Img 37681',0,'Chambre Confort Img 37681',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/chambre-confort-img-37681.jpg',NULL,'2021-10-12 22:30:11','2021-10-12 22:32:43'),(58,NULL,NULL,'chambre-confort-img-37871-vertical-jpg',1501474,'image/jpg',NULL,'chambre-confort-img-37871-vertical.jpg','IMG_37871.jpg','3500,5250,2,width=\"3500\" height=\"5250\",8,3,image/jpeg',NULL,0,NULL,1,0,'Chambre Confort Img 37871',0,'Chambre Confort Img 37871',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/chambre-confort-img-37871-vertical.jpg',NULL,'2021-10-12 22:30:11','2021-10-12 22:32:43'),(59,NULL,NULL,'chambre-confort-img-37721-vertical-jpg',1289506,'image/jpg',NULL,'chambre-confort-img-37721-vertical.jpg','IMG_37721.jpg','3500,5250,2,width=\"3500\" height=\"5250\",8,3,image/jpeg',NULL,0,NULL,1,0,'Chambre Confort Img 37721',0,'Chambre Confort Img 37721',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/chambre-confort-img-37721-vertical.jpg',NULL,'2021-10-12 22:30:11','2021-10-12 22:32:43'),(60,NULL,NULL,'grande-suite-img-37971-jpg',1822804,'image/jpg',NULL,'grande-suite-img-37971.jpg','IMG_37971.jpg','4650,3100,2,width=\"4650\" height=\"3100\",8,3,image/jpeg',NULL,0,NULL,1,0,'Grande Suite Img 37971',0,'Grande Suite Img 37971',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/grande-suite-img-37971.jpg',NULL,'2021-10-12 22:30:11','2021-10-12 22:32:43'),(61,NULL,NULL,'grande-suite-img-38121-jpg',1311323,'image/jpg',NULL,'grande-suite-img-38121.jpg','IMG_38121.jpg','5000,3338,2,width=\"5000\" height=\"3338\",8,3,image/jpeg',NULL,0,NULL,1,0,'Grande Suite Img 38121',0,'Grande Suite Img 38121',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/grande-suite-img-38121.jpg',NULL,'2021-10-12 22:30:11','2021-10-12 22:32:43'),(62,NULL,NULL,'grande-suite-img-38331-vertical-jpg',1409459,'image/jpg',NULL,'grande-suite-img-38331-vertical.jpg','IMG_38331.jpg','3400,5100,2,width=\"3400\" height=\"5100\",8,3,image/jpeg',NULL,0,NULL,1,0,'Grande Suite Img 38331',0,'Grande Suite Img 38331',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/grande-suite-img-38331-vertical.jpg',NULL,'2021-10-12 22:30:11','2021-10-12 22:32:43'),(63,NULL,NULL,'grande-suite-img-38251-jpg',1599703,'image/jpg',NULL,'grande-suite-img-38251.jpg','IMG_38251.jpg','4600,3066,2,width=\"4600\" height=\"3066\",8,3,image/jpeg',NULL,0,NULL,1,0,'Grande Suite Img 38251',0,'Grande Suite Img 38251',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/grande-suite-img-38251.jpg',NULL,'2021-10-12 22:30:12','2021-10-12 22:32:43'),(64,NULL,NULL,'grande-suite-img-38171-jpg',1099061,'image/jpg',NULL,'grande-suite-img-38171.jpg','IMG_38171.jpg','5111,3400,2,width=\"5111\" height=\"3400\",8,3,image/jpeg',NULL,0,NULL,1,0,'Grande Suite Img 38171',0,'Grande Suite Img 38171',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/grande-suite-img-38171.jpg',NULL,'2021-10-12 22:30:12','2021-10-12 22:32:43'),(65,NULL,NULL,'grande-suite-img-38031-jpg',1560371,'image/jpg',NULL,'grande-suite-img-38031.jpg','IMG_38031.jpg','5100,3400,2,width=\"5100\" height=\"3400\",8,3,image/jpeg',NULL,0,NULL,1,0,'Grande Suite Img 38031',0,'Grande Suite Img 38031',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/grande-suite-img-38031.jpg',NULL,'2021-10-12 22:30:12','2021-10-16 17:26:40'),(66,NULL,NULL,'grande-suite-img-38041-jpg',1499717,'image/jpg',NULL,'grande-suite-img-38041.jpg','IMG_38041.jpg','5000,3333,2,width=\"5000\" height=\"3333\",8,3,image/jpeg',NULL,0,NULL,1,0,'Grande Suite Img 38041',0,'Grande Suite Img 38041',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/grande-suite-img-38041.jpg',NULL,'2021-10-12 22:30:12','2021-10-12 22:32:43'),(67,NULL,NULL,'suite-moyenne-img-34381-jpg',1707942,'image/jpg',NULL,'suite-moyenne-img-34381.jpg','IMG_34381.jpg','5100,3400,2,width=\"5100\" height=\"3400\",8,3,image/jpeg',NULL,0,NULL,1,0,'Suite Moyenne Img 34381',0,'Suite Moyenne Img 34381',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/suite-moyenne-img-34381.jpg',NULL,'2021-10-12 22:30:12','2021-10-12 22:32:43'),(68,NULL,NULL,'suite-moyenne-img-34491-jpg',1354447,'image/jpg',NULL,'suite-moyenne-img-34491.jpg','IMG_34491.jpg','5000,3333,2,width=\"5000\" height=\"3333\",8,3,image/jpeg',NULL,0,NULL,1,0,'Suite Moyenne Img 34491',0,'Suite Moyenne Img 34491',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/suite-moyenne-img-34491.jpg',NULL,'2021-10-12 22:30:12','2021-10-12 22:32:43'),(69,NULL,NULL,'suite-moyenne-img-34651-vertical-jpg',1062751,'image/jpg',NULL,'suite-moyenne-img-34651-vertical.jpg','IMG_34651.jpg','3400,5100,2,width=\"3400\" height=\"5100\",8,3,image/jpeg',NULL,0,NULL,1,0,'Suite Moyenne Img 34651',0,'Suite Moyenne Img 34651',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/suite-moyenne-img-34651-vertical.jpg',NULL,'2021-10-12 22:30:12','2021-10-12 22:32:43'),(70,NULL,NULL,'suite-moyenne-img-34721-vertical-jpg',1146323,'image/jpg',NULL,'suite-moyenne-img-34721-vertical.jpg','IMG_34721.jpg','3744,5616,2,width=\"3744\" height=\"5616\",8,3,image/jpeg',NULL,0,NULL,1,0,'Suite Moyenne Img 34721',0,'Suite Moyenne Img 34721',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/suite-moyenne-img-34721-vertical.jpg',NULL,'2021-10-12 22:30:12','2021-10-12 22:32:43'),(71,NULL,NULL,'hotel-logo-orange-png',2919,'image/png',NULL,'hotel-logo-orange.png','logo_orange.png','473,77,3,width=\"473\" height=\"77\",8,image/png',NULL,0,NULL,1,0,'Hotel Logo Orange',0,'Hotel Logo Orange',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/hotel-logo-orange.png',NULL,'2021-10-12 22:30:12','2021-10-12 22:32:43'),(72,NULL,NULL,'exterieur-jardin-img-38571-jpg',1618951,'image/jpg',NULL,'exterieur-jardin-img-38571.jpg','IMG_38571.jpg','5300,3533,2,width=\"5300\" height=\"3533\",8,3,image/jpeg',NULL,0,NULL,1,0,'Exterieur Jardin Img 38571',0,'Exterieur Jardin Img 38571',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/exterieur-jardin-img-38571.jpg',NULL,'2021-10-12 22:30:12','2021-10-16 17:33:39'),(73,NULL,NULL,'exterieur-jardin-img-38551-jpg',1934216,'image/jpg',NULL,'exterieur-jardin-img-38551.jpg','IMG_38551.jpg','4700,3133,2,width=\"4700\" height=\"3133\",8,3,image/jpeg',NULL,0,NULL,1,0,'Exterieur Jardin Img 38551',0,'Exterieur Jardin Img 38551',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/exterieur-jardin-img-38551.jpg',NULL,'2021-10-12 22:30:12','2021-10-16 17:33:39'),(74,NULL,NULL,'exterieur-jardin-img-38521-vertical-jpg',2108167,'image/jpg',NULL,'exterieur-jardin-img-38521-vertical.jpg','IMG_38521.jpg','3300,4950,2,width=\"3300\" height=\"4950\",8,3,image/jpeg',NULL,0,NULL,1,0,'Exterieur Jardin Img 38521',0,'Exterieur Jardin Img 38521',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/exterieur-jardin-img-38521-vertical.jpg',NULL,'2021-10-12 22:30:13','2021-10-12 22:32:43'),(75,NULL,NULL,'exterieur-jardin-img-37901-jpg',1701947,'image/jpg',NULL,'exterieur-jardin-img-37901.jpg','IMG_37901.jpg','4300,2866,2,width=\"4300\" height=\"2866\",8,3,image/jpeg',NULL,0,NULL,1,0,'Exterieur Jardin Img 37901',0,'Exterieur Jardin Img 37901',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/exterieur-jardin-img-37901.jpg',NULL,'2021-10-12 22:30:13','2021-10-16 17:33:39'),(76,NULL,NULL,'exterieur-jardin-img-37931-jpg',1879397,'image/jpg',NULL,'exterieur-jardin-img-37931.jpg','IMG_37931.jpg','5100,3400,2,width=\"5100\" height=\"3400\",8,3,image/jpeg',NULL,0,NULL,1,0,'Exterieur Jardin Img 37931',0,'Exterieur Jardin Img 37931',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/exterieur-jardin-img-37931.jpg',NULL,'2021-10-12 22:30:13','2021-10-16 17:33:39'),(77,NULL,NULL,'exterieur-jardin-img-38561-jpg',1380009,'image/jpg',NULL,'exterieur-jardin-img-38561.jpg','IMG_38561.jpg','5600,3733,2,width=\"5600\" height=\"3733\",8,3,image/jpeg',NULL,0,NULL,1,0,'Exterieur Jardin Img 38561',0,'Exterieur Jardin Img 38561',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/exterieur-jardin-img-38561.jpg',NULL,'2021-10-12 22:30:13','2021-10-16 18:56:38'),(78,NULL,NULL,'activities-img-spa-inversed-jpeg',314869,'image/jpeg',NULL,'activities-img-spa-inversed.jpeg','IMG_SPA-inversed.jpeg','2400,1600,2,width=\"2400\" height=\"1600\",8,3,image/jpeg',NULL,0,NULL,1,0,'Activities Img Spa Inversed',0,'Activities Img Spa Inversed',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/activities-img-spa-inversed.jpeg',NULL,'2021-10-12 22:30:13','2021-10-16 17:33:39'),(79,NULL,NULL,'activities-img-golf-inversed-jpeg',494684,'image/jpeg',NULL,'activities-img-golf-inversed.jpeg','IMG_GOLF-inversed.jpeg','1920,1080,2,width=\"1920\" height=\"1080\",8,3,image/jpeg',NULL,0,NULL,1,0,'Activities Img Golf Inversed',0,'Activities Img Golf Inversed',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/activities-img-golf-inversed.jpeg',NULL,'2021-10-12 22:30:13','2021-10-16 17:33:39'),(80,NULL,NULL,'activities-img-quad-jpeg',970675,'image/jpeg',NULL,'activities-img-quad.jpeg','IMG_QUAD.jpeg','4288,2848,2,width=\"4288\" height=\"2848\",8,3,image/jpeg',NULL,0,NULL,1,0,'Activities Img Quad',0,'Activities Img Quad',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/activities-img-quad.jpeg',NULL,'2021-10-12 22:30:13','2021-10-16 17:33:39'),(81,NULL,NULL,'activities-img-nautique-inversed-jpeg',106172,'image/jpeg',NULL,'activities-img-nautique-inversed.jpeg','IMG_NAUTIQUE-inversed.jpeg','1400,787,2,width=\"1400\" height=\"787\",8,3,image/jpeg',NULL,0,NULL,1,0,'Activities Img Nautique Inversed',0,'Activities Img Nautique Inversed',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/activities-img-nautique-inversed.jpeg',NULL,'2021-10-12 22:30:13','2021-10-16 17:33:39'),(82,NULL,NULL,'activities-img-pool-jpeg',263611,'image/jpeg',NULL,'activities-img-pool.jpeg','IMG_POOL.jpeg','1920,780,2,width=\"1920\" height=\"780\",8,3,image/jpeg',NULL,0,NULL,1,0,'Activities Img Pool',0,'Activities Img Pool',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/activities-img-pool.jpeg',NULL,'2021-10-12 22:30:13','2021-10-16 17:33:39'),(83,NULL,NULL,'activities-img-spa-jpeg',314805,'image/jpeg',NULL,'activities-img-spa.jpeg','IMG_SPA.jpeg','2400,1600,2,width=\"2400\" height=\"1600\",8,3,image/jpeg',NULL,0,NULL,1,0,'Activities Img Spa',0,'Activities Img Spa',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/activities-img-spa.jpeg',NULL,'2021-10-12 22:30:14','2021-10-16 17:33:39'),(84,NULL,NULL,'activities-img-pool-inversed-jpeg',263801,'image/jpeg',NULL,'activities-img-pool-inversed.jpeg','IMG_POOL-inversed.jpeg','1920,780,2,width=\"1920\" height=\"780\",8,3,image/jpeg',NULL,0,NULL,1,0,'Activities Img Pool Inversed',0,'Activities Img Pool Inversed',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/activities-img-pool-inversed.jpeg',NULL,'2021-10-12 22:30:14','2021-10-16 17:33:39'),(85,NULL,NULL,'activities-rag180331-essaouira-chr-020072-jpeg',739874,'image/jpeg',NULL,'activities-rag180331-essaouira-chr-020072.jpeg','rag180331-essaouira-chr-020072.jpeg','3840,2560,2,width=\"3840\" height=\"2560\",8,3,image/jpeg',NULL,0,NULL,1,0,'Activities Rag180331 Essaouira Chr 020072',0,'Activities Rag180331 Essaouira Chr 020072',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/activities-rag180331-essaouira-chr-020072.jpeg',NULL,'2021-10-12 22:30:14','2021-10-16 17:33:39'),(86,NULL,NULL,'activities-accueil-hotel-tasgua-yan-01-jpg',72478,'image/jpg',NULL,'activities-accueil-hotel-tasgua-yan-01.jpg','accueil-hotel-tasgua-yan-01.jpg','1300,800,2,width=\"1300\" height=\"800\",8,3,image/jpeg',NULL,0,NULL,1,0,'Activities Accueil Hotel Tasgua Yan 01',0,'Activities Accueil Hotel Tasgua Yan 01',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/activities-accueil-hotel-tasgua-yan-01.jpg',NULL,'2021-10-12 22:30:14','2021-10-16 17:33:39'),(87,NULL,NULL,'activities-img-golf-jpeg',494679,'image/jpeg',NULL,'activities-img-golf.jpeg','IMG_GOLF.jpeg','1920,1080,2,width=\"1920\" height=\"1080\",8,3,image/jpeg',NULL,0,NULL,1,0,'Activities Img Golf',0,'Activities Img Golf',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/activities-img-golf.jpeg',NULL,'2021-10-12 22:30:14','2021-10-16 17:33:39'),(88,NULL,NULL,'activities-img-quad-inversed-jpeg',971179,'image/jpeg',NULL,'activities-img-quad-inversed.jpeg','IMG_QUAD-inversed.jpeg','4288,2848,2,width=\"4288\" height=\"2848\",8,3,image/jpeg',NULL,0,NULL,1,0,'Activities Img Quad Inversed',0,'Activities Img Quad Inversed',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/activities-img-quad-inversed.jpeg',NULL,'2021-10-12 22:30:14','2021-10-16 17:33:39'),(89,NULL,NULL,'activities-img-nautique-jpeg',105816,'image/jpeg',NULL,'activities-img-nautique.jpeg','IMG_NAUTIQUE.jpeg','1400,787,2,width=\"1400\" height=\"787\",8,3,image/jpeg',NULL,0,NULL,1,0,'Activities Img Nautique',0,'Activities Img Nautique',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/activities-img-nautique.jpeg',NULL,'2021-10-12 22:30:14','2021-10-16 17:33:39'),(90,NULL,NULL,'chambre-superieure-img-34511-jpg',1442523,'image/jpg',NULL,'chambre-superieure-img-34511.jpg','IMG_34511.jpg','5000,3333,2,width=\"5000\" height=\"3333\",8,3,image/jpeg',NULL,0,NULL,1,0,'Chambre Superieure Img 34511',0,'Chambre Superieure Img 34511',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/chambre-superieure-img-34511.jpg',NULL,'2021-10-12 22:30:14','2021-10-12 22:32:43'),(91,NULL,NULL,'chambre-superieure-img-35691-jpg',1256635,'image/jpg',NULL,'chambre-superieure-img-35691.jpg','IMG_35691.jpg','5616,3744,2,width=\"5616\" height=\"3744\",8,3,image/jpeg',NULL,0,NULL,1,0,'Chambre Superieure Img 35691',0,'Chambre Superieure Img 35691',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/chambre-superieure-img-35691.jpg',NULL,'2021-10-12 22:30:15','2021-10-12 22:32:43'),(92,NULL,NULL,'chambre-superieure-img-35761-vertical-jpg',1420136,'image/jpg',NULL,'chambre-superieure-img-35761-vertical.jpg','IMG_35761.jpg','3744,5616,2,width=\"3744\" height=\"5616\",8,3,image/jpeg',NULL,0,NULL,1,0,'Chambre Superieure Img 35761',0,'Chambre Superieure Img 35761',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/chambre-superieure-img-35761-vertical.jpg',NULL,'2021-10-12 22:30:15','2021-10-12 22:32:43'),(93,NULL,NULL,'chambre-superieure-img-34911-jpg',1263009,'image/jpg',NULL,'chambre-superieure-img-34911.jpg','IMG_34911.jpg','5000,3333,2,width=\"5000\" height=\"3333\",8,3,image/jpeg',NULL,0,NULL,1,0,'Chambre Superieure Img 34911',0,'Chambre Superieure Img 34911',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/chambre-superieure-img-34911.jpg',NULL,'2021-10-12 22:30:15','2021-10-12 22:32:43'),(94,NULL,NULL,'chambre-superieure-img-34801-jpg',1941667,'image/jpg',NULL,'chambre-superieure-img-34801.jpg','IMG_34801.jpg','5616,3744,2,width=\"5616\" height=\"3744\",8,3,image/jpeg',NULL,0,NULL,1,0,'Chambre Superieure Img 34801',0,'Chambre Superieure Img 34801',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/chambre-superieure-img-34801.jpg',NULL,'2021-10-12 22:30:15','2021-10-12 22:32:43'),(95,NULL,NULL,'chambre-superieure-img-34631-vertical-jpg',1647331,'image/jpg',NULL,'chambre-superieure-img-34631-vertical.jpg','IMG_34631.jpg','4000,6405,2,width=\"4000\" height=\"6405\",8,3,image/jpeg',NULL,0,NULL,1,0,'Chambre Superieure Img 34631',0,'Chambre Superieure Img 34631',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/chambre-superieure-img-34631-vertical.jpg',NULL,'2021-10-12 22:30:15','2021-10-12 22:32:43'),(96,NULL,NULL,'chambre-superieure-img-34831-jpg',1795792,'image/jpg',NULL,'chambre-superieure-img-34831.jpg','IMG_34831.jpg','4800,3199,2,width=\"4800\" height=\"3199\",8,3,image/jpeg',NULL,0,NULL,1,0,'Chambre Superieure Img 34831',0,'Chambre Superieure Img 34831',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/chambre-superieure-img-34831.jpg',NULL,'2021-10-12 22:30:15','2021-10-12 22:32:43'),(97,NULL,NULL,'chambre-superieure-img-34541-jpg',1586929,'image/jpg',NULL,'chambre-superieure-img-34541.jpg','IMG_34541.jpg','4200,2799,2,width=\"4200\" height=\"2799\",8,3,image/jpeg',NULL,0,NULL,1,0,'Chambre Superieure Img 34541',0,'Chambre Superieure Img 34541',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/chambre-superieure-img-34541.jpg',NULL,'2021-10-12 22:30:15','2021-10-12 22:32:43'),(98,NULL,NULL,'hotel-logo-white-png',6404,'image/png',NULL,'hotel-logo-white.png','logo_white.png','473,77,3,width=\"473\" height=\"77\",8,image/png',NULL,0,NULL,1,0,'Hotel Logo White',0,'Hotel Logo White',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/hotel-logo-white.png',NULL,'2021-10-12 22:30:16','2021-10-12 22:32:43'),(99,NULL,NULL,'rooms-img-3423-jpg',59553,'image/jpg',NULL,'rooms-img-3423.jpg','IMG_3423.jpg','900,600,2,width=\"900\" height=\"600\",8,3,image/jpeg',NULL,0,NULL,1,0,'Rooms Img 3423',0,'Rooms Img 3423',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/rooms-img-3423.jpg',NULL,'2021-10-12 22:30:16','2021-10-12 22:32:43'),(100,NULL,NULL,'rooms-img-3438-jpg',74613,'image/jpg',NULL,'rooms-img-3438.jpg','IMG_3438.jpg','900,600,2,width=\"900\" height=\"600\",8,3,image/jpeg',NULL,0,NULL,1,0,'Rooms Img 3438',0,'Rooms Img 3438',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/rooms-img-3438.jpg',NULL,'2021-10-12 22:30:16','2021-10-12 22:32:43'),(101,NULL,NULL,'rooms-img-3451-jpg',43788,'image/jpg',NULL,'rooms-img-3451.jpg','IMG_3451.jpg','902,600,2,width=\"902\" height=\"600\",8,3,image/jpeg',NULL,0,NULL,1,0,'Rooms Img 3451',0,'Rooms Img 3451',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/rooms-img-3451.jpg',NULL,'2021-10-12 22:30:16','2021-10-12 22:32:43'),(102,NULL,NULL,'rooms-img-3418-jpg',66788,'image/jpg',NULL,'rooms-img-3418.jpg','IMG_3418.jpg','900,600,2,width=\"900\" height=\"600\",8,3,image/jpeg',NULL,0,NULL,1,0,'Rooms Img 3418',0,'Rooms Img 3418',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/rooms-img-3418.jpg',NULL,'2021-10-12 22:30:16','2021-10-12 22:32:43'),(103,NULL,NULL,'rooms-img-3454-jpg',46833,'image/jpg',NULL,'rooms-img-3454.jpg','IMG_3454.jpg','899,600,2,width=\"899\" height=\"600\",8,3,image/jpeg',NULL,0,NULL,1,0,'Rooms Img 3454',0,'Rooms Img 3454',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/rooms-img-3454.jpg',NULL,'2021-10-12 22:30:16','2021-10-12 22:32:43'),(104,NULL,NULL,'rooms-img-3414-jpg',60949,'image/jpg',NULL,'rooms-img-3414.jpg','IMG_3414.jpg','900,600,2,width=\"900\" height=\"600\",8,3,image/jpeg',NULL,0,NULL,1,0,'Rooms Img 3414',0,'Rooms Img 3414',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/rooms-img-3414.jpg',NULL,'2021-10-12 22:30:16','2021-10-12 22:32:43'),(105,NULL,NULL,'petite-suite-img-35871-jpg',1356281,'image/jpg',NULL,'petite-suite-img-35871.jpg','IMG_35871.jpg','5000,3333,2,width=\"5000\" height=\"3333\",8,3,image/jpeg',NULL,0,NULL,1,0,'Petite Suite Img 35871',0,'Petite Suite Img 35871',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/petite-suite-img-35871.jpg',NULL,'2021-10-12 22:30:17','2021-10-12 22:32:43'),(106,NULL,NULL,'petite-suite-img-35981-jpg',1718666,'image/jpg',NULL,'petite-suite-img-35981.jpg','IMG_35981.jpg','4200,2800,2,width=\"4200\" height=\"2800\",8,3,image/jpeg',NULL,0,NULL,1,0,'Petite Suite Img 35981',0,'Petite Suite Img 35981',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/petite-suite-img-35981.jpg',NULL,'2021-10-12 22:30:17','2021-10-12 22:32:43'),(107,NULL,NULL,'petite-suite-img-35951-jpg',1913252,'image/jpg',NULL,'petite-suite-img-35951.jpg','IMG_35951.jpg','4600,3066,2,width=\"4600\" height=\"3066\",8,3,image/jpeg',NULL,0,NULL,1,0,'Petite Suite Img 35951',0,'Petite Suite Img 35951',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/petite-suite-img-35951.jpg',NULL,'2021-10-12 22:30:17','2021-10-12 22:32:43'),(108,NULL,NULL,'ch-confort-3-img-35811-jpg',1849093,'image/jpg',NULL,'ch-confort-3-img-35811.jpg','IMG_35811.jpg','6000,3999,2,width=\"6000\" height=\"3999\",8,3,image/jpeg',NULL,0,NULL,1,0,'Ch Confort 3 Img 35811',0,'Ch Confort 3 Img 35811',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/ch-confort-3-img-35811.jpg',NULL,'2021-10-12 22:30:17','2021-10-12 22:32:43'),(109,NULL,NULL,'ch-confort-3-img-35801-jpg',1260105,'image/jpg',NULL,'ch-confort-3-img-35801.jpg','IMG_35801.jpg','4800,3199,2,width=\"4800\" height=\"3199\",8,3,image/jpeg',NULL,0,NULL,1,0,'Ch Confort 3 Img 35801',0,'Ch Confort 3 Img 35801',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/ch-confort-3-img-35801.jpg',NULL,'2021-10-12 22:30:17','2021-10-12 22:32:43'),(110,NULL,NULL,'salle-a-manger-img-32051-jpg',1666618,'image/jpg',NULL,'salle-a-manger-img-32051.jpg','IMG_32051.jpg','5000,3332,2,width=\"5000\" height=\"3332\",8,3,image/jpeg',NULL,0,NULL,1,0,'Salle A Manger Img 32051',0,'Salle A Manger Img 32051',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/salle-a-manger-img-32051.jpg',NULL,'2021-10-12 22:30:17','2021-10-12 22:32:43'),(111,NULL,NULL,'salle-a-manger-img-31981-jpg',1945753,'image/jpg',NULL,'salle-a-manger-img-31981.jpg','IMG_31981.jpg','4950,3300,2,width=\"4950\" height=\"3300\",8,3,image/jpeg',NULL,0,NULL,1,0,'Salle A Manger Img 31981',0,'Salle A Manger Img 31981',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/salle-a-manger-img-31981.jpg',NULL,'2021-10-12 22:30:18','2021-10-12 22:32:43'),(112,NULL,NULL,'spa-img-34031-jpg',1999570,'image/jpg',NULL,'spa-img-34031.jpg','IMG_34031.jpg','4950,3300,2,width=\"4950\" height=\"3300\",8,3,image/jpeg',NULL,0,NULL,1,0,'Spa Img 34031',0,'Spa Img 34031',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/spa-img-34031.jpg',NULL,'2021-10-12 22:30:18','2021-10-12 22:32:43'),(113,NULL,NULL,'spa-img-33721-jpg',1762810,'image/jpg',NULL,'spa-img-33721.jpg','IMG_33721.jpg','4500,3000,2,width=\"4500\" height=\"3000\",8,3,image/jpeg',NULL,0,NULL,1,0,'Spa Img 33721',0,'Spa Img 33721',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/spa-img-33721.jpg',NULL,'2021-10-12 22:30:18','2021-10-12 22:32:43'),(114,NULL,NULL,'charme-deco-img-38501-vertical-jpg',994660,'image/jpg',NULL,'charme-deco-img-38501-vertical.jpg','IMG_38501.jpg','3744,5616,2,width=\"3744\" height=\"5616\",8,3,image/jpeg',NULL,0,NULL,1,0,'Charme Deco Img 38501',0,'Charme Deco Img 38501',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/charme-deco-img-38501-vertical.jpg',NULL,'2021-10-12 22:30:18','2021-10-12 22:32:43'),(115,NULL,NULL,'charme-deco-img-38381-vertical-jpg',1046436,'image/jpg',NULL,'charme-deco-img-38381-vertical.jpg','IMG_38381.jpg','3600,5400,2,width=\"3600\" height=\"5400\",8,3,image/jpeg',NULL,0,NULL,1,0,'Charme Deco Img 38381',0,'Charme Deco Img 38381',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/charme-deco-img-38381-vertical.jpg',NULL,'2021-10-12 22:30:18','2021-10-12 22:32:43'),(116,NULL,NULL,'charme-deco-img-38411-vertical-jpg',1416458,'image/jpg',NULL,'charme-deco-img-38411-vertical.jpg','IMG_38411.jpg','3600,5400,2,width=\"3600\" height=\"5400\",8,3,image/jpeg',NULL,0,NULL,1,0,'Charme Deco Img 38411',0,'Charme Deco Img 38411',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/charme-deco-img-38411-vertical.jpg',NULL,'2021-10-12 22:30:19','2021-10-16 17:33:39'),(117,NULL,NULL,'villa-villa-37-109-jpg',43141,'image/jpg',NULL,'villa-villa-37-109.jpg','villa_37_109.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 109',0,'Villa Villa 37 109',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-109.jpg',NULL,'2021-10-12 22:30:19','2021-10-12 22:32:43'),(118,NULL,NULL,'villa-villa-37-05-jpg',90290,'image/jpg',NULL,'villa-villa-37-05.jpg','villa_37_05.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 05',0,'Villa Villa 37 05',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-05.jpg',NULL,'2021-10-12 22:30:19','2021-10-12 22:32:43'),(119,NULL,NULL,'villa-villa-37-16-jpg',89325,'image/jpg',NULL,'villa-villa-37-16.jpg','villa_37_16.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 16',0,'Villa Villa 37 16',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-16.jpg',NULL,'2021-10-12 22:30:19','2021-10-12 22:32:43'),(120,NULL,NULL,'villa-villa-37-08-jpg',78103,'image/jpg',NULL,'villa-villa-37-08.jpg','villa_37_08.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 08',0,'Villa Villa 37 08',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-08.jpg',NULL,'2021-10-12 22:30:20','2021-10-12 22:32:43'),(121,NULL,NULL,'villa-villa-37-19-jpg',78595,'image/jpg',NULL,'villa-villa-37-19.jpg','villa_37_19.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 19',0,'Villa Villa 37 19',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-19.jpg',NULL,'2021-10-12 22:30:20','2021-10-12 22:32:43'),(122,NULL,NULL,'villa-villa-37-112-jpg',65268,'image/jpg',NULL,'villa-villa-37-112.jpg','villa_37_112.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 112',0,'Villa Villa 37 112',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-112.jpg',NULL,'2021-10-12 22:30:20','2021-10-12 22:32:43'),(123,NULL,NULL,'villa-villa-37-17-vertical-jpg',92090,'image/jpg',NULL,'villa-villa-37-17-vertical.jpg','villa_37_17.jpg','567,852,2,width=\"567\" height=\"852\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 17',0,'Villa Villa 37 17',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-17-vertical.jpg',NULL,'2021-10-12 22:30:20','2021-10-12 22:32:43'),(124,NULL,NULL,'villa-villa-37-04-jpg',88038,'image/jpg',NULL,'villa-villa-37-04.jpg','villa_37_04.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 04',0,'Villa Villa 37 04',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-04.jpg',NULL,'2021-10-12 22:30:21','2021-10-12 22:32:43'),(125,NULL,NULL,'villa-villa-37-06-jpg',84749,'image/jpg',NULL,'villa-villa-37-06.jpg','villa_37_06.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 06',0,'Villa Villa 37 06',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-06.jpg',NULL,'2021-10-12 22:30:21','2021-10-12 22:32:43'),(126,NULL,NULL,'villa-villa-37-102-jpg',66211,'image/jpg',NULL,'villa-villa-37-102.jpg','villa_37_102.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 102',0,'Villa Villa 37 102',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-102.jpg',NULL,'2021-10-12 22:30:21','2021-10-12 22:32:43'),(127,NULL,NULL,'villa-villa-37-113-jpg',53800,'image/jpg',NULL,'villa-villa-37-113.jpg','villa_37_113.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 113',0,'Villa Villa 37 113',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-113.jpg',NULL,'2021-10-12 22:30:21','2021-10-12 22:32:43'),(128,NULL,NULL,'villa-villa-37-18-jpg',99542,'image/jpg',NULL,'villa-villa-37-18.jpg','villa_37_18.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 18',0,'Villa Villa 37 18',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-18.jpg',NULL,'2021-10-12 22:30:21','2021-10-12 22:32:43'),(129,NULL,NULL,'villa-villa-37-110-vertical-jpg',80412,'image/jpg',NULL,'villa-villa-37-110-vertical.jpg','villa_37_110.jpg','567,852,2,width=\"567\" height=\"852\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 110',0,'Villa Villa 37 110',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-110-vertical.jpg',NULL,'2021-10-12 22:30:22','2021-10-12 22:32:43'),(130,NULL,NULL,'villa-villa-37-108-jpg',60359,'image/jpg',NULL,'villa-villa-37-108.jpg','villa_37_108.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 108',0,'Villa Villa 37 108',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-108.jpg',NULL,'2021-10-12 22:30:22','2021-10-12 22:32:43'),(131,NULL,NULL,'villa-villa-37-11-jpg',94734,'image/jpg',NULL,'villa-villa-37-11.jpg','villa_37_11.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 11',0,'Villa Villa 37 11',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-11.jpg',NULL,'2021-10-12 22:30:22','2021-10-12 22:32:43'),(132,NULL,NULL,'villa-villa-37-09-jpg',80923,'image/jpg',NULL,'villa-villa-37-09.jpg','villa_37_09.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 09',0,'Villa Villa 37 09',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-09.jpg',NULL,'2021-10-12 22:30:22','2021-10-12 22:32:43'),(133,NULL,NULL,'villa-villa-37-103-jpg',64392,'image/jpg',NULL,'villa-villa-37-103.jpg','villa_37_103.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 103',0,'Villa Villa 37 103',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-103.jpg',NULL,'2021-10-12 22:30:23','2021-10-12 22:32:43'),(134,NULL,NULL,'villa-villa-37-106-jpg',67482,'image/jpg',NULL,'villa-villa-37-106.jpg','villa_37_106.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 106',0,'Villa Villa 37 106',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-106.jpg',NULL,'2021-10-12 22:30:23','2021-10-12 22:32:43'),(135,NULL,NULL,'villa-villa-37-21-jpg',88380,'image/jpg',NULL,'villa-villa-37-21.jpg','villa_37_21.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 21',0,'Villa Villa 37 21',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-21.jpg',NULL,'2021-10-12 22:30:23','2021-10-12 22:32:43'),(136,NULL,NULL,'villa-villa-37-02-jpg',81045,'image/jpg',NULL,'villa-villa-37-02.jpg','villa_37_02.jpg','855,569,2,width=\"855\" height=\"569\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 02',0,'Villa Villa 37 02',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-02.jpg',NULL,'2021-10-12 22:30:23','2021-10-12 22:32:43'),(137,NULL,NULL,'villa-villa-37-111-vertical-jpg',43114,'image/jpg',NULL,'villa-villa-37-111-vertical.jpg','villa_37_111.jpg','567,852,2,width=\"567\" height=\"852\",8,3,image/jpeg',NULL,0,NULL,1,0,'Villa Villa 37 111',0,'Villa Villa 37 111',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/villa-villa-37-111-vertical.jpg',NULL,'2021-10-12 22:30:23','2021-10-12 22:32:43'),(138,NULL,NULL,'piscines-img-31661-vertical-jpg',1617528,'image/jpg',NULL,'piscines-img-31661-vertical.jpg','IMG_31661.jpg','3400,5100,2,width=\"3400\" height=\"5100\",8,3,image/jpeg',NULL,0,NULL,1,0,'Piscines Img 31661',0,'Piscines Img 31661',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/piscines-img-31661-vertical.jpg',NULL,'2021-10-12 22:30:24','2021-10-12 22:32:43'),(139,NULL,NULL,'piscines-img-33361-jpg',1538491,'image/jpg',NULL,'piscines-img-33361.jpg','IMG_33361.jpg','4400,2933,2,width=\"4400\" height=\"2933\",8,3,image/jpeg',NULL,0,NULL,1,0,'Piscines Img 33361',0,'Piscines Img 33361',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/piscines-img-33361.jpg',NULL,'2021-10-12 22:30:24','2021-10-16 17:33:39'),(140,NULL,NULL,'piscines-img-33261-jpg',2043845,'image/jpg',NULL,'piscines-img-33261.jpg','IMG_33261.jpg','5100,3400,2,width=\"5100\" height=\"3400\",8,3,image/jpeg',NULL,0,NULL,1,0,'Piscines Img 33261',0,'Piscines Img 33261',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/piscines-img-33261.jpg',NULL,'2021-10-12 22:30:24','2021-10-16 17:33:39'),(141,NULL,NULL,'piscines-img-33321-jpg',2154162,'image/jpg',NULL,'piscines-img-33321.jpg','IMG_33321.jpg','4650,3100,2,width=\"4650\" height=\"3100\",8,3,image/jpeg',NULL,0,NULL,1,0,'Piscines Img 33321',0,'Piscines Img 33321',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/piscines-img-33321.jpg',NULL,'2021-10-12 22:30:24','2021-10-16 17:33:39'),(142,NULL,NULL,'piscines-img-33301-jpg',1796138,'image/jpg',NULL,'piscines-img-33301.jpg','IMG_33301.jpg','4350,2900,2,width=\"4350\" height=\"2900\",8,3,image/jpeg',NULL,0,NULL,1,0,'Piscines Img 33301',0,'Piscines Img 33301',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/piscines-img-33301.jpg',NULL,'2021-10-12 22:30:25','2021-10-16 17:33:39'),(143,NULL,NULL,'piscines-img-31821-vertical-jpg',2351416,'image/jpg',NULL,'piscines-img-31821-vertical.jpg','IMG_31821.jpg','3000,4500,2,width=\"3000\" height=\"4500\",8,3,image/jpeg',NULL,0,NULL,1,0,'Piscines Img 31821',0,'Piscines Img 31821',NULL,'http://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/piscines-img-31821-vertical.jpg',NULL,'2021-10-12 22:30:25','2021-10-12 22:32:43'),(144,NULL,NULL,'piscines-img-35171-jpg',1534390,'image/jpg',NULL,'piscines-img-35171.jpg','IMG_35171.jpg','4200,2799,2,width=\"4200\" height=\"2799\",8,3,image/jpeg',NULL,0,NULL,1,0,'Piscines Img 35171',0,'Piscines Img 35171',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/piscines-img-35171.jpg',NULL,'2021-10-12 22:30:25','2021-10-16 17:33:39'),(145,NULL,NULL,'piscines-img-38481-jpg',2015181,'image/jpg',NULL,'piscines-img-38481.jpg','IMG_38481.jpg','4800,3200,2,width=\"4800\" height=\"3200\",8,3,image/jpeg',NULL,0,NULL,1,0,'Piscines Img 38481',0,'Piscines Img 38481',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/piscines-img-38481.jpg',NULL,'2021-10-12 22:30:25','2021-10-16 17:33:39'),(146,NULL,NULL,'piscines-img-35191-jpg',2061986,'image/jpg',NULL,'piscines-img-35191.jpg','IMG_35191.jpg','4950,3300,2,width=\"4950\" height=\"3300\",8,3,image/jpeg',NULL,0,NULL,1,0,'Piscines Img 35191',0,'Piscines Img 35191',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/piscines-img-35191.jpg',NULL,'2021-10-12 22:30:26','2021-10-16 17:33:39'),(147,NULL,NULL,'piscines-img-38471-jpg',1892160,'image/jpg',NULL,'piscines-img-38471.jpg','IMG_38471.jpg','5000,3333,2,width=\"5000\" height=\"3333\",8,3,image/jpeg',NULL,0,NULL,1,0,'Piscines Img 38471',0,'Piscines Img 38471',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/piscines-img-38471.jpg',NULL,'2021-10-12 22:30:26','2021-10-16 17:33:39'),(148,NULL,NULL,'piscines-img-35151-jpg',1910218,'image/jpg',NULL,'piscines-img-35151.jpg','IMG_35151.jpg','5800,3865,2,width=\"5800\" height=\"3865\",8,3,image/jpeg',NULL,0,NULL,1,0,'Piscines Img 35151',0,'Piscines Img 35151',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/piscines-img-35151.jpg',NULL,'2021-10-12 22:30:26','2021-10-16 17:33:39'),(149,NULL,NULL,'villa-gonatouki-essaouira',NULL,'video/youtube',NULL,'Villa Gonatouki, Essaouira',NULL,NULL,NULL,0,NULL,1,0,'Villa Gonatouki, Essaouira',0,'Villa Gonatouki, Essaouira',NULL,'https://www.youtube.com/watch?v=P-i5MEnwXAQ',NULL,'2021-10-12 22:30:33','2021-10-16 16:51:06'),(150,NULL,NULL,'gonatouki-villa',NULL,'video/youtube',NULL,'Gonatouki Villa',NULL,NULL,NULL,0,NULL,1,0,'Gonatouki Villa',0,'Gonatouki Villa',NULL,'https://www.youtube.com/watch?v=SGP9pT0oxOw',NULL,'2021-10-12 22:30:33','2021-10-16 16:51:06'),(153,NULL,NULL,'cours-de-cuisine-1-dsc-6321-jpg',1513048,'image/jpeg',NULL,'cours-de-cuisine-1-dsc-6321.JPG','Cours de cuisine 1 DSC_6321.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 1 DSC_6321.JPG',0,'Cours de cuisine 1 DSC_6321.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-1-dsc-6321.JPG',NULL,'2021-10-18 12:39:43','2021-10-18 12:39:50'),(154,NULL,NULL,'cours-de-cuisine-2-dsc-6322-jpg',1287679,'image/jpeg',NULL,'cours-de-cuisine-2-dsc-6322.JPG','Cours de cuisine 2 DSC_6322.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 2 DSC_6322.JPG',0,'Cours de cuisine 2 DSC_6322.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-2-dsc-6322.JPG',NULL,'2021-10-18 12:39:52','2021-10-18 12:39:57'),(155,NULL,NULL,'cours-de-cuisine-3-dsc-6323-jpg',1426104,'image/jpeg',NULL,'cours-de-cuisine-3-dsc-6323.JPG','Cours de cuisine 3 DSC_6323.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 3 DSC_6323.JPG',0,'Cours de cuisine 3 DSC_6323.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-3-dsc-6323.JPG',NULL,'2021-10-18 12:39:57','2021-10-18 12:40:03'),(156,NULL,NULL,'cours-de-cuisine-4-dsc-6324-jpg',1645261,'image/jpeg',NULL,'cours-de-cuisine-4-dsc-6324.JPG','Cours de cuisine 4 DSC_6324.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 4 DSC_6324.JPG',0,'Cours de cuisine 4 DSC_6324.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-4-dsc-6324.JPG',NULL,'2021-10-18 12:40:03','2021-10-18 12:40:08'),(157,NULL,NULL,'cours-de-cuisine-5-dsc-6325-jpg',1429502,'image/jpeg',NULL,'cours-de-cuisine-5-dsc-6325.JPG','Cours de cuisine 5 DSC_6325.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 5 DSC_6325.JPG',0,'Cours de cuisine 5 DSC_6325.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-5-dsc-6325.JPG',NULL,'2021-10-18 12:40:08','2021-10-18 12:40:13'),(158,NULL,NULL,'cours-de-cuisine-6-dsc-6326-jpg',1483464,'image/jpeg',NULL,'cours-de-cuisine-6-dsc-6326.JPG','Cours de cuisine 6 DSC_6326.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 6 DSC_6326.JPG',0,'Cours de cuisine 6 DSC_6326.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-6-dsc-6326.JPG',NULL,'2021-10-18 12:40:14','2021-10-18 12:40:19'),(159,NULL,NULL,'cours-de-cuisine-7-dsc-6327-jpg',1618448,'image/jpeg',NULL,'cours-de-cuisine-7-dsc-6327.JPG','Cours de cuisine 7 DSC_6327.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 7 DSC_6327.JPG',0,'Cours de cuisine 7 DSC_6327.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-7-dsc-6327.JPG',NULL,'2021-10-18 12:40:19','2021-10-18 12:40:24'),(160,NULL,NULL,'cours-de-cuisine-8-dsc-6328-jpg',1494055,'image/jpeg',NULL,'cours-de-cuisine-8-dsc-6328.JPG','Cours de cuisine 8 DSC_6328.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 8 DSC_6328.JPG',0,'Cours de cuisine 8 DSC_6328.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-8-dsc-6328.JPG',NULL,'2021-10-18 12:40:24','2021-10-18 12:40:30'),(161,NULL,NULL,'cours-de-cuisine-9-dsc-6329-jpg',1306333,'image/jpeg',NULL,'cours-de-cuisine-9-dsc-6329.JPG','Cours de cuisine 9 DSC_6329.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 9 DSC_6329.JPG',0,'Cours de cuisine 9 DSC_6329.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-9-dsc-6329.JPG',NULL,'2021-10-18 12:40:30','2021-10-18 12:40:35'),(162,NULL,NULL,'cours-de-cuisine-10-dsc-6330-jpg',1625102,'image/jpeg',NULL,'cours-de-cuisine-10-dsc-6330.JPG','Cours de cuisine 10 DSC_6330.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 10 DSC_6330.JPG',0,'Cours de cuisine 10 DSC_6330.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-10-dsc-6330.JPG',NULL,'2021-10-18 12:46:32','2021-10-18 12:46:38'),(163,NULL,NULL,'cours-de-cuisine-12-dsc-6332-jpg',1521906,'image/jpeg',NULL,'cours-de-cuisine-12-dsc-6332.JPG','Cours de cuisine 12 DSC_6332.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 12 DSC_6332.JPG',0,'Cours de cuisine 12 DSC_6332.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-12-dsc-6332.JPG',NULL,'2021-10-18 12:46:40','2021-10-18 12:46:45'),(164,NULL,NULL,'cours-de-cuisine-11-dsc-6331-jpg',1585583,'image/jpeg',NULL,'cours-de-cuisine-11-dsc-6331.JPG','Cours de cuisine 11 DSC_6331.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 11 DSC_6331.JPG',0,'Cours de cuisine 11 DSC_6331.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-11-dsc-6331.JPG',NULL,'2021-10-18 12:46:45','2021-10-18 12:46:50'),(165,NULL,NULL,'cours-de-cuisine-13-dsc-6336-jpg',1365309,'image/jpeg',NULL,'cours-de-cuisine-13-dsc-6336.JPG','Cours de cuisine 13 DSC_6336.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 13 DSC_6336.JPG',0,'Cours de cuisine 13 DSC_6336.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-13-dsc-6336.JPG',NULL,'2021-10-18 12:46:50','2021-10-18 12:46:55'),(166,NULL,NULL,'cours-de-cuisine-14-dsc-6337-jpg',1666895,'image/jpeg',NULL,'cours-de-cuisine-14-dsc-6337.JPG','Cours de cuisine 14 DSC_6337.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 14 DSC_6337.JPG',0,'Cours de cuisine 14 DSC_6337.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-14-dsc-6337.JPG',NULL,'2021-10-18 12:46:55','2021-10-18 12:47:00'),(167,NULL,NULL,'cours-de-cuisine-15-dsc-6338-jpg',1849567,'image/jpeg',NULL,'cours-de-cuisine-15-dsc-6338.JPG','Cours de cuisine 15 DSC_6338.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 15 DSC_6338.JPG',0,'Cours de cuisine 15 DSC_6338.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-15-dsc-6338.JPG',NULL,'2021-10-18 12:47:00','2021-10-18 12:47:06'),(168,NULL,NULL,'cours-de-cuisine-16-dsc-6339-jpg',1700939,'image/jpeg',NULL,'cours-de-cuisine-16-dsc-6339.JPG','Cours de cuisine 16 DSC_6339.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 16 DSC_6339.JPG',0,'Cours de cuisine 16 DSC_6339.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-16-dsc-6339.JPG',NULL,'2021-10-18 12:47:06','2021-10-18 12:47:11'),(169,NULL,NULL,'cours-de-cuisine-17-dsc-6359-jpg',1448430,'image/jpeg',NULL,'cours-de-cuisine-17-dsc-6359.JPG','Cours de cuisine 17 DSC_6359.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 17 DSC_6359.JPG',0,'Cours de cuisine 17 DSC_6359.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-17-dsc-6359.JPG',NULL,'2021-10-18 12:47:11','2021-10-18 12:47:16'),(170,NULL,NULL,'cours-de-cuisine-18-dsc-6360-jpg',1159627,'image/jpeg',NULL,'cours-de-cuisine-18-dsc-6360.JPG','Cours de cuisine 18 DSC_6360.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 18 DSC_6360.JPG',0,'Cours de cuisine 18 DSC_6360.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-18-dsc-6360.JPG',NULL,'2021-10-18 12:47:16','2021-10-18 12:47:21'),(171,NULL,NULL,'cours-de-cuisine-20-dsc-6362-jpg',1172382,'image/jpeg',NULL,'cours-de-cuisine-20-dsc-6362.JPG','Cours de cuisine 20 DSC_6362.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 20 DSC_6362.JPG',0,'Cours de cuisine 20 DSC_6362.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-20-dsc-6362.JPG',NULL,'2021-10-23 10:33:20','2021-10-23 10:33:32'),(172,NULL,NULL,'cours-de-cuisine-19-dsc-6361-jpg',1311260,'image/jpeg',NULL,'cours-de-cuisine-19-dsc-6361.JPG','Cours de cuisine 19 DSC_6361.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 19 DSC_6361.JPG',0,'Cours de cuisine 19 DSC_6361.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-19-dsc-6361.JPG',NULL,'2021-10-23 10:33:32','2021-10-23 10:33:37'),(173,NULL,NULL,'cours-de-cuisine-21-dsc-6363-jpg',1448211,'image/jpeg',NULL,'cours-de-cuisine-21-dsc-6363.JPG','Cours de cuisine 21 DSC_6363.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 21 DSC_6363.JPG',0,'Cours de cuisine 21 DSC_6363.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-21-dsc-6363.JPG',NULL,'2021-10-23 10:33:37','2021-10-23 10:33:42'),(174,NULL,NULL,'cours-de-cuisine-22-dsc-6365-jpg',1491420,'image/jpeg',NULL,'cours-de-cuisine-22-dsc-6365.JPG','Cours de cuisine 22 DSC_6365.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 22 DSC_6365.JPG',0,'Cours de cuisine 22 DSC_6365.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-22-dsc-6365.JPG',NULL,'2021-10-23 10:33:42','2021-10-23 10:33:47'),(175,NULL,NULL,'cours-de-cuisine-23-dsc-6366-jpg',1522196,'image/jpeg',NULL,'cours-de-cuisine-23-dsc-6366.JPG','Cours de cuisine 23 DSC_6366.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 23 DSC_6366.JPG',0,'Cours de cuisine 23 DSC_6366.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-23-dsc-6366.JPG',NULL,'2021-10-23 10:33:47','2021-10-23 10:33:52'),(176,NULL,NULL,'cours-de-cuisine-24-dsc-6367-jpg',1690791,'image/jpeg',NULL,'cours-de-cuisine-24-dsc-6367.JPG','Cours de cuisine 24 DSC_6367.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 24 DSC_6367.JPG',0,'Cours de cuisine 24 DSC_6367.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-24-dsc-6367.JPG',NULL,'2021-10-23 10:33:52','2021-10-23 10:33:57'),(177,NULL,NULL,'cours-de-cuisine-25-dsc-6368-jpg',1397040,'image/jpeg',NULL,'cours-de-cuisine-25-dsc-6368.JPG','Cours de cuisine 25 DSC_6368.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 25 DSC_6368.JPG',0,'Cours de cuisine 25 DSC_6368.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-25-dsc-6368.JPG',NULL,'2021-10-23 10:33:57','2021-10-23 10:34:01'),(178,NULL,NULL,'cours-de-cuisine-26-dsc-6369-jpg',1274383,'image/jpeg',NULL,'cours-de-cuisine-26-dsc-6369.JPG','Cours de cuisine 26 DSC_6369.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 26 DSC_6369.JPG',0,'Cours de cuisine 26 DSC_6369.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-26-dsc-6369.JPG',NULL,'2021-10-23 10:34:02','2021-10-23 10:34:06'),(179,NULL,NULL,'cours-de-cuisine-27-dsc-6370-jpg',1657517,'image/jpeg',NULL,'cours-de-cuisine-27-dsc-6370.JPG','Cours de cuisine 27 DSC_6370.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 27 DSC_6370.JPG',0,'Cours de cuisine 27 DSC_6370.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-27-dsc-6370.JPG',NULL,'2021-10-23 10:34:06','2021-10-23 10:34:11'),(180,NULL,NULL,'cours-de-cuisine-28-dsc-6371-jpg',1087489,'image/jpeg',NULL,'cours-de-cuisine-28-dsc-6371.JPG','Cours de cuisine 28 DSC_6371.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 28 DSC_6371.JPG',0,'Cours de cuisine 28 DSC_6371.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-28-dsc-6371.JPG',NULL,'2021-10-23 10:37:30','2021-10-23 10:37:35'),(181,NULL,NULL,'cours-de-cuisine-29-dsc-6372-jpg',1196795,'image/jpeg',NULL,'cours-de-cuisine-29-dsc-6372.JPG','Cours de cuisine 29 DSC_6372.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 29 DSC_6372.JPG',0,'Cours de cuisine 29 DSC_6372.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-29-dsc-6372.JPG',NULL,'2021-10-23 10:37:35','2021-10-23 10:37:39'),(182,NULL,NULL,'cours-de-cuisine-30-dsc-6373-jpg',1118570,'image/jpeg',NULL,'cours-de-cuisine-30-dsc-6373.JPG','Cours de cuisine 30 DSC_6373.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 30 DSC_6373.JPG',0,'Cours de cuisine 30 DSC_6373.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-30-dsc-6373.JPG',NULL,'2021-10-23 10:37:39','2021-10-23 10:37:44'),(183,NULL,NULL,'cours-de-cuisine-31-dsc-6374-jpg',1003362,'image/jpeg',NULL,'cours-de-cuisine-31-dsc-6374.JPG','Cours de cuisine 31 DSC_6374.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 31 DSC_6374.JPG',0,'Cours de cuisine 31 DSC_6374.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-31-dsc-6374.JPG',NULL,'2021-10-23 10:37:44','2021-10-23 10:37:49'),(184,NULL,NULL,'cours-de-cuisine-32-dsc-6375-jpg',1568205,'image/jpeg',NULL,'cours-de-cuisine-32-dsc-6375.JPG','Cours de cuisine 32 DSC_6375.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 32 DSC_6375.JPG',0,'Cours de cuisine 32 DSC_6375.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-32-dsc-6375.JPG',NULL,'2021-10-23 10:37:49','2021-10-23 10:37:54'),(185,NULL,NULL,'cours-de-cuisine-33-dsc-6376-jpg',1263528,'image/jpeg',NULL,'cours-de-cuisine-33-dsc-6376.JPG','Cours de cuisine 33 DSC_6376.JPG','4496,3000',NULL,0,NULL,1,0,'Cours de cuisine 33 DSC_6376.JPG',0,'Cours de cuisine 33 DSC_6376.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/cours-de-cuisine-33-dsc-6376.JPG',NULL,'2021-10-23 10:37:54','2021-10-23 10:37:58'),(186,NULL,NULL,'initiation-danse-orientale-1-dsc-6486-jpg',1921167,'image/jpeg',NULL,'initiation-danse-orientale-1-dsc-6486.JPG','Initiation danse orientale 1 DSC_6486.JPG','4496,3000',NULL,0,NULL,1,0,'Initiation danse orientale 1 DSC_6486.JPG',0,'Initiation danse orientale 1 DSC_6486.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/initiation-danse-orientale-1-dsc-6486.JPG',NULL,'2021-10-23 10:38:03','2021-10-23 10:38:08'),(187,NULL,NULL,'initiation-danse-orientale-2-dsc-6492-jpg',2011020,'image/jpeg',NULL,'initiation-danse-orientale-2-dsc-6492.JPG','Initiation danse orientale 2 DSC_6492.JPG','4496,3000',NULL,0,NULL,1,0,'Initiation danse orientale 2 DSC_6492.JPG',0,'Initiation danse orientale 2 DSC_6492.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/initiation-danse-orientale-2-dsc-6492.JPG',NULL,'2021-10-23 11:45:21','2021-10-23 11:45:26'),(188,NULL,NULL,'initiation-danse-orientale-3-dsc-6493-jpg',2071971,'image/jpeg',NULL,'initiation-danse-orientale-3-dsc-6493.JPG','Initiation danse orientale 3 DSC_6493.JPG','4496,3000',NULL,0,NULL,1,0,'Initiation danse orientale 3 DSC_6493.JPG',0,'Initiation danse orientale 3 DSC_6493.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/initiation-danse-orientale-3-dsc-6493.JPG',NULL,'2021-10-23 11:55:31','2021-10-23 11:55:36'),(189,NULL,NULL,'initiation-danse-orientale-4-dsc-6502-jpg',1995685,'image/jpeg',NULL,'initiation-danse-orientale-4-dsc-6502.JPG','Initiation danse orientale 4 DSC_6502.JPG','4496,3000',NULL,0,NULL,1,0,'Initiation danse orientale 4 DSC_6502.JPG',0,'Initiation danse orientale 4 DSC_6502.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/initiation-danse-orientale-4-dsc-6502.JPG',NULL,'2021-10-23 11:55:36','2021-10-23 11:55:41'),(190,NULL,NULL,'initiation-danse-orientale-5-dsc-6503-jpg',1993781,'image/jpeg',NULL,'initiation-danse-orientale-5-dsc-6503.JPG','Initiation danse orientale 5 DSC_6503.JPG','4496,3000',NULL,0,NULL,1,0,'Initiation danse orientale 5 DSC_6503.JPG',0,'Initiation danse orientale 5 DSC_6503.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/initiation-danse-orientale-5-dsc-6503.JPG',NULL,'2021-10-23 11:55:41','2021-10-23 11:55:46'),(191,NULL,NULL,'initiation-danse-orientale-6-dsc-6504-jpg',1952454,'image/jpeg',NULL,'initiation-danse-orientale-6-dsc-6504.JPG','Initiation danse orientale 6 DSC_6504.JPG','4496,3000',NULL,0,NULL,1,0,'Initiation danse orientale 6 DSC_6504.JPG',0,'Initiation danse orientale 6 DSC_6504.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/initiation-danse-orientale-6-dsc-6504.JPG',NULL,'2021-10-23 11:55:46','2021-10-23 11:55:51'),(192,NULL,NULL,'initiation-danse-orientale-7-dsc-6507-jpg',1988811,'image/jpeg',NULL,'initiation-danse-orientale-7-dsc-6507.JPG','Initiation danse orientale 7 DSC_6507.JPG','4496,3000',NULL,0,NULL,1,0,'Initiation danse orientale 7 DSC_6507.JPG',0,'Initiation danse orientale 7 DSC_6507.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/initiation-danse-orientale-7-dsc-6507.JPG',NULL,'2021-10-23 11:55:51','2021-10-23 11:55:56'),(193,NULL,NULL,'pdj-1dsc-6302-jpg',1943194,'image/jpeg',NULL,'pdj-1dsc-6302.JPG','Pdj 1DSC_6302.JPG','4496,3000',NULL,0,NULL,1,0,'Pdj 1DSC_6302.JPG',0,'Pdj 1DSC_6302.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/pdj-1dsc-6302.JPG',NULL,'2021-10-23 11:55:56','2021-10-23 11:56:01'),(194,NULL,NULL,'pdj-3-dsc-6300-jpg',1839103,'image/jpeg',NULL,'pdj-3-dsc-6300.JPG','Pdj 3 DSC_6300.JPG','4496,3000',NULL,0,NULL,1,0,'Pdj 3 DSC_6300.JPG',0,'Pdj 3 DSC_6300.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/pdj-3-dsc-6300.JPG',NULL,'2021-10-23 11:56:01','2021-10-23 11:56:06'),(195,NULL,NULL,'pdj-4-dsc-6299-jpg',2009711,'image/jpeg',NULL,'pdj-4-dsc-6299.JPG','Pdj 4 DSC_6299.JPG','4496,3000',NULL,0,NULL,1,0,'Pdj 4 DSC_6299.JPG',0,'Pdj 4 DSC_6299.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/pdj-4-dsc-6299.JPG',NULL,'2021-10-23 11:56:06','2021-10-23 11:56:11'),(196,NULL,NULL,'pdj-5-dsc-6301-jpg',1848894,'image/jpeg',NULL,'pdj-5-dsc-6301.JPG','Pdj 5 DSC_6301.JPG','4496,3000',NULL,0,NULL,1,0,'Pdj 5 DSC_6301.JPG',0,'Pdj 5 DSC_6301.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/pdj-5-dsc-6301.JPG',NULL,'2021-10-23 12:00:52','2021-10-23 12:00:57'),(197,NULL,NULL,'pdj-7-dsc-6308-jpg',1816354,'image/jpeg',NULL,'pdj-7-dsc-6308.JPG','Pdj 7 DSC_6308.JPG','4496,3000',NULL,0,NULL,1,0,'Pdj 7 DSC_6308.JPG',0,'Pdj 7 DSC_6308.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/pdj-7-dsc-6308.JPG',NULL,'2021-10-23 12:01:00','2021-10-23 12:01:05'),(198,NULL,NULL,'pdj-6-dsc-6298-jpg',1995908,'image/jpeg',NULL,'pdj-6-dsc-6298.JPG','Pdj 6 DSC_6298.JPG','4496,3000',NULL,0,NULL,1,0,'Pdj 6 DSC_6298.JPG',0,'Pdj 6 DSC_6298.JPG',NULL,'https://cdn-villa-gonatouki.graines-digitales.onlineuploads/media/files/pdj-6-dsc-6298.JPG',NULL,'2021-10-23 12:01:05','2021-10-23 12:01:10');

--
-- Table structure for table `message`
--

CREATE TABLE `message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `recipient_id` int(11) DEFAULT NULL,
  `sender_id` int(11) DEFAULT NULL,
  `event_id` int(11) DEFAULT NULL,
  `date_sent` datetime DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `text` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `origin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `identifier` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_B6BD307FE92F8F78` (`recipient_id`),
  KEY `IDX_B6BD307FF624B39D` (`sender_id`),
  KEY `IDX_B6BD307F71F7E88B` (`event_id`),
  CONSTRAINT `FK_B6BD307F71F7E88B` FOREIGN KEY (`event_id`) REFERENCES `event` (`id`),
  CONSTRAINT `FK_B6BD307FE92F8F78` FOREIGN KEY (`recipient_id`) REFERENCES `real_estate_agent` (`id`),
  CONSTRAINT `FK_B6BD307FF624B39D` FOREIGN KEY (`sender_id`) REFERENCES `person` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `message`
--

INSERT INTO `message` VALUES (1,NULL,3,NULL,'2021-10-16 15:34:47','unused subject','dsqddqsfdqfdsq','booking form',NULL,NULL,'2021-10-16 16:34:48','2021-10-16 16:34:48'),(2,NULL,4,NULL,'2021-10-16 17:01:51','unused subject','sans','booking form',NULL,NULL,'2021-10-16 18:01:51','2021-10-16 18:01:51');

--
-- Table structure for table `order`
--

CREATE TABLE `order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `confirmation_number` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order`
--


--
-- Table structure for table `organization`
--

CREATE TABLE `organization` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `organization_type_id` int(11) DEFAULT NULL,
  `primary_image_id` int(11) DEFAULT NULL,
  `secondary_image_id` int(11) DEFAULT NULL,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `legal_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Phone',
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Email',
  `foundingDate` date DEFAULT NULL,
  `number_of_employees` int(11) DEFAULT NULL,
  `number_of_projects` smallint(6) DEFAULT NULL,
  `mobile_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Mobile Phone',
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C1EE637C89E04D0` (`organization_type_id`),
  KEY `IDX_C1EE637C1CDA489C` (`primary_image_id`),
  KEY `IDX_C1EE637CA604F92B` (`secondary_image_id`),
  KEY `IDX_C1EE637CF987D8A8` (`user_created_id`),
  KEY `IDX_C1EE637C9828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_C1EE637C1CDA489C` FOREIGN KEY (`primary_image_id`) REFERENCES `media_object` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_C1EE637C89E04D0` FOREIGN KEY (`organization_type_id`) REFERENCES `organization_type` (`id`),
  CONSTRAINT `FK_C1EE637C9828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_C1EE637CA604F92B` FOREIGN KEY (`secondary_image_id`) REFERENCES `media_object` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_C1EE637CF987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `organization`
--

INSERT INTO `organization` VALUES (1,NULL,2,3,NULL,NULL,'villa-gonatouki','Villa Gonatouki','Villa Gonatouki','+212 (0) 524 79 29 66','reservation@gonatouki.com','1970-01-01',2,50,'+33 (0) 6 26 64 58 28',NULL,'www.gonatouki.com',NULL,'2021-10-12 22:29:17','2025-06-29 19:15:15'),(2,NULL,NULL,NULL,NULL,NULL,'facebook','Facebook',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'https://web.facebook.com/ImmobilierEssaouira/',NULL,'2021-10-12 22:29:17','2021-10-12 22:29:17'),(3,NULL,NULL,NULL,NULL,NULL,'youtube','Youtube',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'https://www.youtube.com/channel/UC_5LBYKZCyI3C54KmHjiTWQ',NULL,'2021-10-12 22:29:17','2021-10-12 22:29:17'),(4,NULL,NULL,NULL,NULL,NULL,'instagram','Instagram',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'https://www.instagram.com/explore/locations/276862122394945/limmobiliere-dessaouira/',NULL,'2021-10-12 22:29:17','2021-10-12 22:29:17');

--
-- Table structure for table `organization_type`
--

CREATE TABLE `organization_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_B5D769B45E237E06` (`name`),
  KEY `IDX_B5D769B4F987D8A8` (`user_created_id`),
  KEY `IDX_B5D769B49828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_B5D769B49828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_B5D769B4F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `organization_type`
--

INSERT INTO `organization_type` VALUES (1,NULL,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','societe','Société'),(2,NULL,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','lien-reseau-social','Lien réseau social');

--
-- Table structure for table `organizations_addresses`
--

CREATE TABLE `organizations_addresses` (
  `organisation_id` int(11) NOT NULL,
  `address_id` int(11) NOT NULL,
  PRIMARY KEY (`organisation_id`,`address_id`),
  KEY `IDX_478B5BF49E6B1585` (`organisation_id`),
  KEY `IDX_478B5BF4F5B7AF75` (`address_id`),
  CONSTRAINT `FK_478B5BF49E6B1585` FOREIGN KEY (`organisation_id`) REFERENCES `organization` (`id`),
  CONSTRAINT `FK_478B5BF4F5B7AF75` FOREIGN KEY (`address_id`) REFERENCES `address` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `organizations_addresses`
--

INSERT INTO `organizations_addresses` VALUES (1,1);

--
-- Table structure for table `payment_method`
--

CREATE TABLE `payment_method` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_7B61A1F65E237E06` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_method`
--

INSERT INTO `payment_method` VALUES (1,'2021-10-12 22:29:17','2021-10-12 22:29:47','cheque','Chèque'),(2,'2021-10-12 22:29:17','2021-10-12 22:29:47','virement','Virement'),(3,'2021-10-12 22:29:17','2021-10-12 22:29:47','espece','Espèce'),(4,'2021-10-12 22:29:17','2021-10-12 22:29:47','account-france','Account France'),(5,'2021-10-12 22:29:17','2021-10-12 22:29:47','account-maroc','Account Maroc');

--
-- Table structure for table `person`
--

CREATE TABLE `person` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gender_id` int(11) DEFAULT NULL,
  `position_id` int(11) DEFAULT NULL,
  `nature_id` int(11) DEFAULT NULL,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `firstname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Firstname',
  `lastname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Lastname',
  `birthday` date DEFAULT NULL COMMENT 'Birthday',
  `place_of_birth` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Place of birth',
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Phone',
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Email',
  `origin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_traffic` json DEFAULT NULL,
  `informations` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_34DCD176708A0E0` (`gender_id`),
  KEY `IDX_34DCD176DD842E46` (`position_id`),
  KEY `IDX_34DCD1763BCB2E4B` (`nature_id`),
  KEY `IDX_34DCD176F987D8A8` (`user_created_id`),
  KEY `IDX_34DCD1769828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_34DCD1763BCB2E4B` FOREIGN KEY (`nature_id`) REFERENCES `person_nature` (`id`),
  CONSTRAINT `FK_34DCD176708A0E0` FOREIGN KEY (`gender_id`) REFERENCES `gender` (`id`),
  CONSTRAINT `FK_34DCD1769828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_34DCD176DD842E46` FOREIGN KEY (`position_id`) REFERENCES `person_position` (`id`),
  CONSTRAINT `FK_34DCD176F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `person`
--

INSERT INTO `person` VALUES (1,NULL,NULL,NULL,NULL,NULL,'Johan','REMY',NULL,NULL,'','johan.remy@graines-digitales.online','','[]',NULL,'',NULL,NULL,NULL,NULL,'2021-10-12 22:29:14','2025-06-29 19:15:15'),(2,NULL,NULL,NULL,NULL,NULL,'Bruno','Ernst',NULL,NULL,'','johan.remy@graines-digitales.online','','[]',NULL,NULL,NULL,NULL,NULL,NULL,'2021-10-12 22:29:15','2021-10-12 22:29:15'),(3,NULL,NULL,NULL,NULL,NULL,'johan','remy',NULL,NULL,'0102030201','johan13.remy+125@gmail.com','booking form','[]',NULL,'+212',NULL,NULL,NULL,NULL,'2021-10-16 16:34:44','2021-10-16 16:34:48'),(4,NULL,NULL,NULL,NULL,NULL,'Bruno','Ernst',NULL,NULL,'0671730728','bruno@gonatouki.com','booking form','[]',NULL,'+212',NULL,NULL,NULL,NULL,'2021-10-16 18:01:50','2021-10-16 18:01:51');

--
-- Table structure for table `person_nature`
--

CREATE TABLE `person_nature` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_2D7DB2115E237E06` (`name`),
  KEY `IDX_2D7DB211F987D8A8` (`user_created_id`),
  KEY `IDX_2D7DB2119828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_2D7DB2119828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_2D7DB211F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `person_nature`
--

INSERT INTO `person_nature` VALUES (1,NULL,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','locataire','Locataire'),(2,NULL,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','acheteur','Acheteur');

--
-- Table structure for table `person_position`
--

CREATE TABLE `person_position` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_D26A41C25E237E06` (`name`),
  KEY `IDX_D26A41C2F987D8A8` (`user_created_id`),
  KEY `IDX_D26A41C29828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_D26A41C29828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_D26A41C2F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `person_position`
--

INSERT INTO `person_position` VALUES (1,NULL,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','notaire','Notaire'),(2,NULL,NULL,'2021-10-12 22:29:17','2021-10-12 22:29:47','gardien','Gardien');

--
-- Table structure for table `persons_accommodations`
--

CREATE TABLE `persons_accommodations` (
  `person_id` int(11) NOT NULL,
  `accommodation_id` int(11) NOT NULL,
  PRIMARY KEY (`person_id`,`accommodation_id`),
  KEY `IDX_457AB3B6217BBB47` (`person_id`),
  KEY `IDX_457AB3B68F3692CD` (`accommodation_id`),
  CONSTRAINT `FK_457AB3B6217BBB47` FOREIGN KEY (`person_id`) REFERENCES `person` (`id`),
  CONSTRAINT `FK_457AB3B68F3692CD` FOREIGN KEY (`accommodation_id`) REFERENCES `accommodation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `persons_accommodations`
--


--
-- Table structure for table `persons_addresses`
--

CREATE TABLE `persons_addresses` (
  `person_id` int(11) NOT NULL,
  `address_id` int(11) NOT NULL,
  PRIMARY KEY (`person_id`,`address_id`),
  KEY `IDX_986BAA0E217BBB47` (`person_id`),
  KEY `IDX_986BAA0EF5B7AF75` (`address_id`),
  CONSTRAINT `FK_986BAA0E217BBB47` FOREIGN KEY (`person_id`) REFERENCES `person` (`id`),
  CONSTRAINT `FK_986BAA0EF5B7AF75` FOREIGN KEY (`address_id`) REFERENCES `address` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `persons_addresses`
--


--
-- Table structure for table `persons_pdfs`
--

CREATE TABLE `persons_pdfs` (
  `person_id` int(11) NOT NULL,
  `document_object_id` int(11) NOT NULL,
  PRIMARY KEY (`person_id`,`document_object_id`),
  KEY `IDX_7E735A49217BBB47` (`person_id`),
  KEY `IDX_7E735A4931157E8A` (`document_object_id`),
  CONSTRAINT `FK_7E735A49217BBB47` FOREIGN KEY (`person_id`) REFERENCES `person` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_7E735A4931157E8A` FOREIGN KEY (`document_object_id`) REFERENCES `document_object` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `persons_pdfs`
--


--
-- Table structure for table `property_value`
--

CREATE TABLE `property_value` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `component_id` int(11) DEFAULT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_DB6499395E237E06` (`name`),
  KEY `IDX_DB649939E2ABAFFF` (`component_id`),
  CONSTRAINT `FK_DB649939E2ABAFFF` FOREIGN KEY (`component_id`) REFERENCES `component` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_value`
--

INSERT INTO `property_value` VALUES (1,6,'Villa Gonatouki','nom-du-site','Nom du site','2021-10-12 22:29:17','2021-10-12 22:29:17'),(2,6,'Bienvenue à la Villa Gonatouki','slogan','Slogan','2021-10-12 22:29:17','2021-10-12 22:29:17'),(3,6,'reservation@gonatouki.com','email','Email','2021-10-12 22:29:17','2021-10-12 22:29:17'),(4,7,'UA-XXXXXXXX-X','account','Account','2021-10-12 22:29:17','2021-10-12 22:29:17');

--
-- Table structure for table `rating`
--

CREATE TABLE `rating` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `author_id` int(11) DEFAULT NULL,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `best_rating` double DEFAULT NULL,
  `rating_value` longtext COLLATE utf8mb4_unicode_ci,
  `worst_rating` double DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_D8892622F675F31B` (`author_id`),
  KEY `IDX_D8892622F987D8A8` (`user_created_id`),
  KEY `IDX_D88926229828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_D88926229828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_D8892622F675F31B` FOREIGN KEY (`author_id`) REFERENCES `organization` (`id`),
  CONSTRAINT `FK_D8892622F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rating`
--


--
-- Table structure for table `real_estate_agent`
--

CREATE TABLE `real_estate_agent` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `person_id` int(11) DEFAULT NULL,
  `primary_image_id` int(11) DEFAULT NULL,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `price_range` longtext COLLATE utf8mb4_unicode_ci,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Phone',
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Email',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_C6062FB6217BBB47` (`person_id`),
  KEY `IDX_C6062FB61CDA489C` (`primary_image_id`),
  KEY `IDX_C6062FB6F987D8A8` (`user_created_id`),
  KEY `IDX_C6062FB69828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_C6062FB61CDA489C` FOREIGN KEY (`primary_image_id`) REFERENCES `media_object` (`id`),
  CONSTRAINT `FK_C6062FB6217BBB47` FOREIGN KEY (`person_id`) REFERENCES `person` (`id`),
  CONSTRAINT `FK_C6062FB69828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_C6062FB6F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `real_estate_agent`
--


--
-- Table structure for table `rental`
--

CREATE TABLE `rental` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_1619C27DC54C8C93` (`type_id`),
  CONSTRAINT `FK_1619C27DC54C8C93` FOREIGN KEY (`type_id`) REFERENCES `rental_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rental`
--


--
-- Table structure for table `rental_price_type`
--

CREATE TABLE `rental_price_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_618C58055E237E06` (`name`),
  KEY `IDX_618C5805F987D8A8` (`user_created_id`),
  KEY `IDX_618C58059828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_618C58059828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_618C5805F987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rental_price_type`
--

INSERT INTO `rental_price_type` VALUES (1,NULL,NULL,'2021-10-12 22:29:18','2021-10-12 22:29:47','a-la-semaine','À la semaine'),(2,NULL,NULL,'2021-10-12 22:29:18','2021-10-12 22:29:47','au-mois','Au mois');

--
-- Table structure for table `rental_type`
--

CREATE TABLE `rental_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_39208E95E237E06` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rental_type`
--

INSERT INTO `rental_type` VALUES (1,'2021-10-12 22:29:18','2021-10-12 22:29:47','location-appartement','Location appartement'),(2,'2021-10-12 22:29:18','2021-10-12 22:29:47','location-maison','Location maison'),(3,'2021-10-12 22:29:18','2021-10-12 22:29:47','location-villa-du-golf','Location villa du golf');

--
-- Table structure for table `review`
--

CREATE TABLE `review` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_reviewed_id` int(11) DEFAULT NULL,
  `review_rating_id` int(11) DEFAULT NULL,
  `review_body` longtext COLLATE utf8mb4_unicode_ci,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_794381C6E54D1663` (`item_reviewed_id`),
  UNIQUE KEY `UNIQ_794381C69DC374C7` (`review_rating_id`),
  CONSTRAINT `FK_794381C69DC374C7` FOREIGN KEY (`review_rating_id`) REFERENCES `rating` (`id`),
  CONSTRAINT `FK_794381C6E54D1663` FOREIGN KEY (`item_reviewed_id`) REFERENCES `thing` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `review`
--


--
-- Table structure for table `room`
--

CREATE TABLE `room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `primary_image_id` int(11) DEFAULT NULL,
  `secondary_image_id` int(11) DEFAULT NULL,
  `gallery_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `user_created_id` int(11) DEFAULT NULL,
  `user_last_modified_id` int(11) DEFAULT NULL,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alternate_name` longtext COLLATE utf8mb4_unicode_ci,
  `maximumOccupants` smallint(6) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `label_bg_transparent` tinyint(1) NOT NULL,
  `number_of_rooms` int(11) DEFAULT NULL,
  `minimum_occupants` smallint(6) NOT NULL,
  `description_resume` longtext COLLATE utf8mb4_unicode_ci,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_entity_of_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_created` datetime NOT NULL,
  `date_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_729F519B989D9B62` (`slug`),
  KEY `IDX_729F519B1CDA489C` (`primary_image_id`),
  KEY `IDX_729F519BA604F92B` (`secondary_image_id`),
  KEY `IDX_729F519B4E7AF8F` (`gallery_id`),
  KEY `IDX_729F519B12469DE2` (`category_id`),
  KEY `IDX_729F519BF987D8A8` (`user_created_id`),
  KEY `IDX_729F519B9828C0C1` (`user_last_modified_id`),
  CONSTRAINT `FK_729F519B12469DE2` FOREIGN KEY (`category_id`) REFERENCES `tag` (`id`),
  CONSTRAINT `FK_729F519B1CDA489C` FOREIGN KEY (`primary_image_id`) REFERENCES `media_object` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_729F519B4E7AF8F` FOREIGN KEY (`gallery_id`) REFERENCES `gallery` (`id`),
  CONSTRAINT `FK_729F519B9828C0C1` FOREIGN KEY (`user_last_modified_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_729F519BA604F92B` FOREIGN KEY (`secondary_image_id`) REFERENCES `media_object` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_729F519BF987D8A8` FOREIGN KEY (`user_created_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
