
--
-- Table structure for table `project_documents`
--

CREATE TABLE `project_documents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'image/doc',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `project_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `project_documents_project_id_foreign` (`project_id`),
  CONSTRAINT `project_documents_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_documents`
--


--
-- Table structure for table `project_plans`
--

CREATE TABLE `project_plans` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `document` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `project_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `project_plans_project_id_foreign` (`project_id`),
  CONSTRAINT `project_plans_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_plans`
--


--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_link` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `latitude` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `longitude` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'under_construction,upcoming',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `added_by` bigint unsigned DEFAULT NULL,
  `category_id` bigint unsigned NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `total_click` bigint NOT NULL DEFAULT '0',
  `is_admin_listing` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `projects_slug_id_unique` (`slug_id`),
  KEY `projects_added_by_foreign` (`added_by`),
  KEY `projects_category_id_foreign` (`category_id`),
  CONSTRAINT `projects_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `projects_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `projects`
--


--
-- Table structure for table `properties_documents`
--

CREATE TABLE `properties_documents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `property_id` bigint unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'file name with folder',
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'file type',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `properties_documents_property_id_foreign` (`property_id`),
  CONSTRAINT `properties_documents_property_id_foreign` FOREIGN KEY (`property_id`) REFERENCES `propertys` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `properties_documents`
--

INSERT INTO `properties_documents` VALUES (1,22,'1742800852.3772.pdf','pdf',NULL,NULL,NULL),(3,92,'1751369299.1133.pdf','pdf',NULL,NULL,NULL);

--
-- Table structure for table `property_images`
--

CREATE TABLE `property_images` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `propertys_id` bigint NOT NULL,
  `image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=255 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_images`
--

INSERT INTO `property_images` VALUES (3,39,'1745387319.7616.jpg','2025-04-23 05:48:39','2025-04-23 05:48:39'),(4,39,'1745387319.7697.jpg','2025-04-23 05:48:39','2025-04-23 05:48:39'),(5,39,'1745387319.7719.jpg','2025-04-23 05:48:39','2025-04-23 05:48:39'),(6,39,'1745387319.7751.jpg','2025-04-23 05:48:39','2025-04-23 05:48:39'),(7,39,'1745387319.7777.jpg','2025-04-23 05:48:39','2025-04-23 05:48:39'),(8,39,'1745387319.7804.jpg','2025-04-23 05:48:39','2025-04-23 05:48:39'),(9,39,'1745407509.0311.jpg','2025-04-23 11:25:09','2025-04-23 11:25:09'),(11,42,'1746003124.0306.jpg','2025-04-30 08:52:04','2025-04-30 08:52:04'),(12,43,'1746003847.2727.jpg','2025-04-30 09:04:07','2025-04-30 09:04:07'),(13,43,'1746003847.2743.jpg','2025-04-30 09:04:07','2025-04-30 09:04:07'),(14,43,'1746003847.2753.jpg','2025-04-30 09:04:07','2025-04-30 09:04:07'),(15,44,'1746004425.5372.jpg','2025-04-30 09:13:45','2025-04-30 09:13:45'),(16,46,'1746527245.7063.jpg','2025-05-06 10:27:25','2025-05-06 10:27:25'),(17,46,'1746527245.7093.jpg','2025-05-06 10:27:25','2025-05-06 10:27:25'),(18,46,'1746527245.7099.jpg','2025-05-06 10:27:25','2025-05-06 10:27:25'),(19,46,'1746527245.7104.jpg','2025-05-06 10:27:25','2025-05-06 10:27:25'),(20,47,'1746528047.3539.jpg','2025-05-06 10:40:47','2025-05-06 10:40:47'),(21,48,'1746528709.4709.jpg','2025-05-06 10:51:49','2025-05-06 10:51:49'),(22,48,'1746528709.4715.jpg','2025-05-06 10:51:49','2025-05-06 10:51:49'),(23,48,'1746528709.4721.jpg','2025-05-06 10:51:49','2025-05-06 10:51:49'),(24,48,'1746528709.4726.jpg','2025-05-06 10:51:49','2025-05-06 10:51:49'),(25,48,'1746528709.4731.jpg','2025-05-06 10:51:49','2025-05-06 10:51:49'),(26,51,'1747072965.7935.jpg','2025-05-12 18:02:45','2025-05-12 18:02:45'),(27,52,'1747075184.1037.jpg','2025-05-12 18:39:44','2025-05-12 18:39:44'),(28,52,'1747075184.1052.jpg','2025-05-12 18:39:44','2025-05-12 18:39:44'),(29,52,'1747075184.1064.jpg','2025-05-12 18:39:44','2025-05-12 18:39:44'),(30,52,'1747075184.1073.jpg','2025-05-12 18:39:44','2025-05-12 18:39:44'),(31,51,'1747075412.8515.jpg','2025-05-12 18:43:32','2025-05-12 18:43:32'),(32,54,'1747412778.1985.jpg','2025-05-16 16:26:18','2025-05-16 16:26:18'),(33,54,'1747412778.1993.jpg','2025-05-16 16:26:18','2025-05-16 16:26:18'),(34,54,'1747412778.2.jpg','2025-05-16 16:26:18','2025-05-16 16:26:18'),(35,54,'1747412778.2006.jpg','2025-05-16 16:26:18','2025-05-16 16:26:18'),(36,54,'1747412778.2012.jpg','2025-05-16 16:26:18','2025-05-16 16:26:18'),(37,54,'1747412778.2019.jpg','2025-05-16 16:26:18','2025-05-16 16:26:18'),(38,55,'1747413333.3943.jpg','2025-05-16 16:35:33','2025-05-16 16:35:33'),(39,55,'1747413333.395.jpg','2025-05-16 16:35:33','2025-05-16 16:35:33'),(40,56,'1747413610.1337.jpg','2025-05-16 16:40:10','2025-05-16 16:40:10'),(41,56,'1747413610.1344.jpg','2025-05-16 16:40:10','2025-05-16 16:40:10'),(42,56,'1747413610.135.jpg','2025-05-16 16:40:10','2025-05-16 16:40:10'),(43,58,'1747941487.561.jpg','2025-05-22 19:18:07','2025-05-22 19:18:07'),(44,58,'1747941487.5621.jpg','2025-05-22 19:18:07','2025-05-22 19:18:07'),(45,58,'1747941487.5631.jpg','2025-05-22 19:18:07','2025-05-22 19:18:07'),(46,58,'1747941487.564.jpg','2025-05-22 19:18:07','2025-05-22 19:18:07'),(47,51,'1747942123.9677.jpg','2025-05-22 19:28:43','2025-05-22 19:28:43'),(48,59,'1748082373.79.jpg','2025-05-24 10:26:13','2025-05-24 10:26:13'),(49,59,'1748082373.7948.jpg','2025-05-24 10:26:13','2025-05-24 10:26:13'),(50,59,'1748082373.7954.jpg','2025-05-24 10:26:13','2025-05-24 10:26:13'),(51,59,'1748082373.7965.jpg','2025-05-24 10:26:13','2025-05-24 10:26:13'),(56,53,'1748308554.0416.jpg','2025-05-27 01:15:54','2025-05-27 01:15:54'),(57,53,'1748308554.0467.jpg','2025-05-27 01:15:54','2025-05-27 01:15:54'),(58,53,'1748308554.048.jpg','2025-05-27 01:15:54','2025-05-27 01:15:54'),(59,61,'1748518396.1554.jpg','2025-05-29 11:33:16','2025-05-29 11:33:16'),(60,61,'1748518396.1585.jpg','2025-05-29 11:33:16','2025-05-29 11:33:16'),(61,61,'1748518396.1592.jpg','2025-05-29 11:33:16','2025-05-29 11:33:16'),(62,60,'1748518788.1895.jpg','2025-05-29 11:39:48','2025-05-29 11:39:48'),(63,60,'1748518788.1927.jpg','2025-05-29 11:39:48','2025-05-29 11:39:48'),(64,60,'1748518788.1935.jpg','2025-05-29 11:39:48','2025-05-29 11:39:48'),(65,60,'1748518788.194.jpg','2025-05-29 11:39:48','2025-05-29 11:39:48'),(66,60,'1748518788.1945.jpg','2025-05-29 11:39:48','2025-05-29 11:39:48'),(67,60,'1748518788.1951.jpg','2025-05-29 11:39:48','2025-05-29 11:39:48'),(68,60,'1748518788.1956.jpg','2025-05-29 11:39:48','2025-05-29 11:39:48'),(74,56,'1749157318.5987.jpg','2025-06-05 21:01:58','2025-06-05 21:01:58'),(75,56,'1749157318.6064.jpg','2025-06-05 21:01:58','2025-06-05 21:01:58'),(76,56,'1749157318.6078.jpg','2025-06-05 21:01:58','2025-06-05 21:01:58'),(77,56,'1749157318.6093.jpg','2025-06-05 21:01:58','2025-06-05 21:01:58'),(78,56,'1749157318.6106.jpg','2025-06-05 21:01:58','2025-06-05 21:01:58'),(79,56,'1749157318.6121.jpg','2025-06-05 21:01:58','2025-06-05 21:01:58'),(80,54,'1749157853.5033.jpg','2025-06-05 21:10:53','2025-06-05 21:10:53'),(81,54,'1749157853.5072.jpg','2025-06-05 21:10:53','2025-06-05 21:10:53'),(82,53,'1749158009.1809.jpg','2025-06-05 21:13:29','2025-06-05 21:13:29'),(83,53,'1749158009.1869.jpg','2025-06-05 21:13:29','2025-06-05 21:13:29'),(84,53,'1749158009.1885.jpg','2025-06-05 21:13:29','2025-06-05 21:13:29'),(85,53,'1749158009.1899.jpg','2025-06-05 21:13:29','2025-06-05 21:13:29'),(86,53,'1749158009.1912.jpg','2025-06-05 21:13:29','2025-06-05 21:13:29'),(87,66,'1749411012.0671.jpg','2025-06-08 19:30:12','2025-06-08 19:30:12'),(88,66,'1749411012.0679.jpg','2025-06-08 19:30:12','2025-06-08 19:30:12'),(89,66,'1749411012.0685.jpg','2025-06-08 19:30:12','2025-06-08 19:30:12'),(90,66,'1749411012.0691.jpg','2025-06-08 19:30:12','2025-06-08 19:30:12'),(91,66,'1749411012.0699.jpg','2025-06-08 19:30:12','2025-06-08 19:30:12'),(92,66,'1749411012.0705.jpg','2025-06-08 19:30:12','2025-06-08 19:30:12'),(93,66,'1749411012.0713.jpg','2025-06-08 19:30:12','2025-06-08 19:30:12'),(94,66,'1749411012.0719.jpg','2025-06-08 19:30:12','2025-06-08 19:30:12'),(95,66,'1749411012.0726.jpg','2025-06-08 19:30:12','2025-06-08 19:30:12'),(96,66,'1749411012.0734.jpg','2025-06-08 19:30:12','2025-06-08 19:30:12'),(97,66,'1749411012.0741.jpg','2025-06-08 19:30:12','2025-06-08 19:30:12'),(98,66,'1749411012.0749.jpg','2025-06-08 19:30:12','2025-06-08 19:30:12'),(99,66,'1749411012.0756.jpg','2025-06-08 19:30:12','2025-06-08 19:30:12'),(100,66,'1749411012.0764.jpg','2025-06-08 19:30:12','2025-06-08 19:30:12'),(101,66,'1749411012.0771.jpg','2025-06-08 19:30:12','2025-06-08 19:30:12'),(102,67,'1749471117.5421.jpg','2025-06-09 12:11:57','2025-06-09 12:11:57'),(103,67,'1749471117.5431.jpg','2025-06-09 12:11:57','2025-06-09 12:11:57'),(104,67,'1749471117.5439.jpg','2025-06-09 12:11:57','2025-06-09 12:11:57'),(105,67,'1749471117.5447.jpg','2025-06-09 12:11:57','2025-06-09 12:11:57'),(106,67,'1749471117.5464.jpg','2025-06-09 12:11:57','2025-06-09 12:11:57'),(107,67,'1749471117.5482.jpg','2025-06-09 12:11:57','2025-06-09 12:11:57'),(108,67,'1749471117.5498.jpg','2025-06-09 12:11:57','2025-06-09 12:11:57'),(109,67,'1749471117.5512.jpg','2025-06-09 12:11:57','2025-06-09 12:11:57'),(110,67,'1749471117.5537.jpg','2025-06-09 12:11:57','2025-06-09 12:11:57'),(111,67,'1749471117.5545.jpg','2025-06-09 12:11:57','2025-06-09 12:11:57'),(112,67,'1749471117.556.jpg','2025-06-09 12:11:57','2025-06-09 12:11:57'),(123,70,'1749496905.8379.jpg','2025-06-09 19:21:45','2025-06-09 19:21:45'),(124,70,'1749496905.8402.jpg','2025-06-09 19:21:45','2025-06-09 19:21:45'),(125,70,'1749496905.8423.jpg','2025-06-09 19:21:45','2025-06-09 19:21:45'),(126,70,'1749496905.8442.jpg','2025-06-09 19:21:45','2025-06-09 19:21:45'),(127,70,'1749496905.8458.jpg','2025-06-09 19:21:45','2025-06-09 19:21:45'),(128,70,'1749496905.8467.jpg','2025-06-09 19:21:45','2025-06-09 19:21:45'),(129,71,'1749501638.2637.jpg','2025-06-09 20:40:38','2025-06-09 20:40:38'),(130,71,'1749501638.2661.jpg','2025-06-09 20:40:38','2025-06-09 20:40:38'),(131,71,'1749501638.2682.jpg','2025-06-09 20:40:38','2025-06-09 20:40:38'),(132,71,'1749501638.2696.jpg','2025-06-09 20:40:38','2025-06-09 20:40:38'),(133,71,'1749501638.2716.jpg','2025-06-09 20:40:38','2025-06-09 20:40:38'),(134,71,'1749501638.2835.jpg','2025-06-09 20:40:38','2025-06-09 20:40:38'),(135,71,'1749501638.2846.jpg','2025-06-09 20:40:38','2025-06-09 20:40:38'),(143,81,'1750260220.257.jpg','2025-06-18 15:23:40','2025-06-18 15:23:40'),(144,81,'1750260220.2591.jpg','2025-06-18 15:23:40','2025-06-18 15:23:40'),(145,81,'1750260220.2609.jpg','2025-06-18 15:23:40','2025-06-18 15:23:40'),(146,81,'1750260220.2632.jpg','2025-06-18 15:23:40','2025-06-18 15:23:40'),(147,81,'1750260220.2651.jpg','2025-06-18 15:23:40','2025-06-18 15:23:40'),(148,81,'1750260220.267.jpg','2025-06-18 15:23:40','2025-06-18 15:23:40'),(149,81,'1750260220.2689.jpg','2025-06-18 15:23:40','2025-06-18 15:23:40'),(150,81,'1750260220.2704.jpg','2025-06-18 15:23:40','2025-06-18 15:23:40'),(151,81,'1750260220.2719.jpg','2025-06-18 15:23:40','2025-06-18 15:23:40'),(152,81,'1750260220.2741.jpg','2025-06-18 15:23:40','2025-06-18 15:23:40'),(153,81,'1750260220.2758.jpg','2025-06-18 15:23:40','2025-06-18 15:23:40'),(154,81,'1750260220.2774.jpg','2025-06-18 15:23:40','2025-06-18 15:23:40'),(155,82,'1750309690.9523.jpg','2025-06-19 05:08:10','2025-06-19 05:08:10'),(156,82,'1750309690.953.jpg','2025-06-19 05:08:10','2025-06-19 05:08:10'),(157,82,'1750309690.9538.jpg','2025-06-19 05:08:10','2025-06-19 05:08:10'),(158,82,'1750309690.9544.jpg','2025-06-19 05:08:10','2025-06-19 05:08:10'),(159,82,'1750309690.955.jpg','2025-06-19 05:08:10','2025-06-19 05:08:10'),(160,82,'1750309690.9556.jpg','2025-06-19 05:08:10','2025-06-19 05:08:10'),(161,83,'1750311147.742.jpg','2025-06-19 05:32:27','2025-06-19 05:32:27'),(162,83,'1750311147.7429.jpg','2025-06-19 05:32:27','2025-06-19 05:32:27'),(163,83,'1750311147.7435.jpg','2025-06-19 05:32:27','2025-06-19 05:32:27'),(164,83,'1750311147.7445.jpg','2025-06-19 05:32:27','2025-06-19 05:32:27'),(165,83,'1750311147.7453.jpg','2025-06-19 05:32:27','2025-06-19 05:32:27'),(166,83,'1750311147.746.jpg','2025-06-19 05:32:27','2025-06-19 05:32:27'),(167,83,'1750311147.7468.jpg','2025-06-19 05:32:27','2025-06-19 05:32:27'),(168,83,'1750311147.7475.jpg','2025-06-19 05:32:27','2025-06-19 05:32:27'),(169,83,'1750311147.7483.jpg','2025-06-19 05:32:27','2025-06-19 05:32:27'),(170,83,'1750311147.7492.jpg','2025-06-19 05:32:27','2025-06-19 05:32:27'),(171,83,'1750311147.7498.jpg','2025-06-19 05:32:27','2025-06-19 05:32:27'),(172,83,'1750311147.7508.jpg','2025-06-19 05:32:27','2025-06-19 05:32:27'),(173,83,'1750311147.7516.jpg','2025-06-19 05:32:27','2025-06-19 05:32:27'),(176,86,'1750314317.0029.png','2025-06-19 06:25:17','2025-06-19 06:25:17'),(177,86,'1750314317.0049.png','2025-06-19 06:25:17','2025-06-19 06:25:17'),(178,86,'1750314317.0065.png','2025-06-19 06:25:17','2025-06-19 06:25:17'),(179,86,'1750314317.008.png','2025-06-19 06:25:17','2025-06-19 06:25:17'),(180,86,'1750314317.01.png','2025-06-19 06:25:17','2025-06-19 06:25:17'),(181,86,'1750314317.0115.png','2025-06-19 06:25:17','2025-06-19 06:25:17'),(189,61,'1750955414.713.jpg','2025-06-26 16:30:14','2025-06-26 16:30:14'),(190,61,'1750955941.545.jpg','2025-06-26 16:39:01','2025-06-26 16:39:01'),(191,61,'1750955941.55.jpg','2025-06-26 16:39:01','2025-06-26 16:39:01'),(192,61,'1750955941.5507.jpg','2025-06-26 16:39:01','2025-06-26 16:39:01'),(193,61,'1750955941.5514.jpg','2025-06-26 16:39:01','2025-06-26 16:39:01'),(194,61,'1750955941.5521.jpg','2025-06-26 16:39:01','2025-06-26 16:39:01'),(195,60,'1750956360.5131.jpg','2025-06-26 16:46:00','2025-06-26 16:46:00'),(196,60,'1750956360.5186.jpg','2025-06-26 16:46:00','2025-06-26 16:46:00'),(197,60,'1750956360.5193.jpg','2025-06-26 16:46:00','2025-06-26 16:46:00'),(198,60,'1750956360.5202.jpg','2025-06-26 16:46:00','2025-06-26 16:46:00'),(199,60,'1750956360.5209.jpg','2025-06-26 16:46:00','2025-06-26 16:46:00'),(200,60,'1750956360.5216.jpg','2025-06-26 16:46:00','2025-06-26 16:46:00'),(201,60,'1750956360.5221.jpg','2025-06-26 16:46:00','2025-06-26 16:46:00'),(202,60,'1750956360.5226.jpg','2025-06-26 16:46:00','2025-06-26 16:46:00'),(203,60,'1750956360.5234.jpg','2025-06-26 16:46:00','2025-06-26 16:46:00'),(204,60,'1750956360.5241.jpg','2025-06-26 16:46:00','2025-06-26 16:46:00'),(205,60,'1750956360.5248.jpg','2025-06-26 16:46:00','2025-06-26 16:46:00'),(206,60,'1750956360.5255.jpg','2025-06-26 16:46:00','2025-06-26 16:46:00'),(207,60,'1750956360.5261.jpg','2025-06-26 16:46:00','2025-06-26 16:46:00'),(208,60,'1750956360.5268.jpg','2025-06-26 16:46:00','2025-06-26 16:46:00'),(209,60,'1750956360.5275.jpg','2025-06-26 16:46:00','2025-06-26 16:46:00'),(210,92,'1751369299.1122.jpg','2025-07-01 11:28:19','2025-07-01 11:28:19'),(223,95,'1751781718.5657.jpg','2025-07-06 06:01:58','2025-07-06 06:01:58'),(224,95,'1751781718.5684.jpg','2025-07-06 06:01:58','2025-07-06 06:01:58'),(225,95,'1751781718.5718.jpg','2025-07-06 06:01:58','2025-07-06 06:01:58'),(226,95,'1751781718.5752.jpg','2025-07-06 06:01:58','2025-07-06 06:01:58'),(227,95,'1751781718.5788.jpg','2025-07-06 06:01:58','2025-07-06 06:01:58'),(228,95,'1751781718.582.jpg','2025-07-06 06:01:58','2025-07-06 06:01:58'),(229,95,'1751781718.5857.jpg','2025-07-06 06:01:58','2025-07-06 06:01:58'),(230,95,'1751781718.589.jpg','2025-07-06 06:01:58','2025-07-06 06:01:58'),(231,95,'1751781718.5908.jpg','2025-07-06 06:01:58','2025-07-06 06:01:58'),(232,95,'1751781718.5933.jpg','2025-07-06 06:01:58','2025-07-06 06:01:58'),(233,96,'1752139814.3283.jpg','2025-07-10 09:30:14','2025-07-10 09:30:14'),(234,96,'1752139814.3311.jpg','2025-07-10 09:30:14','2025-07-10 09:30:14'),(235,96,'1752139814.3336.jpg','2025-07-10 09:30:14','2025-07-10 09:30:14'),(236,96,'1752139814.3362.jpg','2025-07-10 09:30:14','2025-07-10 09:30:14'),(237,96,'1752139814.3379.jpg','2025-07-10 09:30:14','2025-07-10 09:30:14'),(238,96,'1752139814.34.jpg','2025-07-10 09:30:14','2025-07-10 09:30:14'),(239,96,'1752139814.3415.jpg','2025-07-10 09:30:14','2025-07-10 09:30:14'),(240,96,'1752139814.3427.jpg','2025-07-10 09:30:14','2025-07-10 09:30:14'),(241,96,'1752139814.344.jpg','2025-07-10 09:30:14','2025-07-10 09:30:14'),(242,96,'1752139814.3452.jpg','2025-07-10 09:30:14','2025-07-10 09:30:14'),(243,96,'1752139814.3463.jpg','2025-07-10 09:30:14','2025-07-10 09:30:14'),(244,97,'1752481485.3512.jpg','2025-07-14 08:24:45','2025-07-14 08:24:45'),(245,97,'1752481485.3528.jpg','2025-07-14 08:24:45','2025-07-14 08:24:45'),(246,97,'1752481485.3538.jpg','2025-07-14 08:24:45','2025-07-14 08:24:45'),(247,97,'1752481485.355.jpg','2025-07-14 08:24:45','2025-07-14 08:24:45'),(248,97,'1752481485.356.jpg','2025-07-14 08:24:45','2025-07-14 08:24:45'),(249,97,'1752481485.3569.jpg','2025-07-14 08:24:45','2025-07-14 08:24:45'),(250,97,'1752481485.3576.jpg','2025-07-14 08:24:45','2025-07-14 08:24:45'),(251,97,'1752481485.3583.jpg','2025-07-14 08:24:45','2025-07-14 08:24:45'),(252,97,'1752481485.3591.jpg','2025-07-14 08:24:45','2025-07-14 08:24:45'),(253,97,'1752481485.3598.jpg','2025-07-14 08:24:45','2025-07-14 08:24:45'),(254,97,'1752481485.3606.jpg','2025-07-14 08:24:45','2025-07-14 08:24:45');

--
-- Table structure for table `propertys`
--

CREATE TABLE `propertys` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `package_id` int DEFAULT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `propery_type` tinyint NOT NULL COMMENT '0:Sell 1:Rent',
  `price` decimal(10,2) NOT NULL,
  `post_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '0 :admin 1:customer',
  `city` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Kutch',
  `country` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `three_d_image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_link` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `latitude` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `longitude` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `added_by` int NOT NULL DEFAULT '0',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT ' 0: Deactive 1: Active',
  `request_status` enum('approved','rejected','pending') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `total_click` bigint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `rentduration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_premium` tinyint(1) NOT NULL DEFAULT '0',
  `request_access` tinyint(1) NOT NULL,
  `currency_id` int DEFAULT '196',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `propertys_slug_id_unique` (`slug_id`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `propertys`
--

INSERT INTO `propertys` VALUES (10,'1',NULL,'Luxury 3-Bedroom Villa','Discover this stunning 3-bedroom villa located in the heart of [City Name]. This modern home offers a spacious living area, a fully equipped kitchen, and luxurious en-suite bathrooms. Enjoy breathtaking views from the private balcony, along with top-notch amenities such as a swimming pool, gym, and 24/7 security. Perfect for families or investors looking for a prime location. Don\'t miss this incredible opportunity!','456 Boulevard de la Liberté, Bonanjo, Douala, Cameroon','kribi',0,99999999.99,'1','Cairo','Egypt','Cairo Governorate','1743152099.3306.jpg','','','30.0444196','31.2357116',7,0,'rejected',0,'2025-03-01 07:09:39','2025-05-26 11:23:28','','luxury-3-bedroom-villa','Luxury 3-Bedroom Villa for Sale in Downtown City','Explore this luxury 3-bedroom villa in downtown [City Name]. Featuring spacious rooms, modern amenities, and breathtaking views. Perfect for families & investors!','luxury villa, house for sale, 3-bedroom home, real estate, modern villa, property investment, city apartments, beachfront property, furnished homes, affordable housing','1740812979.7902.jpg',1,0,196,NULL),(11,'1',NULL,'Luxury Beachfront Villa','Even for a dummy property, create a clear and concise title. Examples: \"Multiple Property Options Available,\" \"Explore Diverse Property Suggestions,\" or \"Sample Property Showcase.','900 Boulevard de la Liberté, Bonanjo, Douala, Cameroon','1234 Elm Street, Brooklyn, NY 11201, USA',1,99999999.99,'1','Cameron','Cameroon','Texas','1742986053.2438.jpg','','','30.8532454','-96.9769304',7,0,'approved',13,'2025-03-01 07:15:42','2025-05-29 09:51:54','Quarterly','luxury-beachfront-villa','Stunning Beachfront Villa with Ocean View','Enjoy breathtaking ocean views from this luxury beachfront villa. A perfect retreat with modern amenities and private access to the beach.','beachfront villa, ocean view, luxury home, private retreat, seaside escape','1740813342.4321.jpg',1,0,196,NULL),(12,'1',NULL,'Stylish City Apartment in Prime Location','This showcase presents a variety of potential property options, designed to illustrate the range of possibilities available.','476 Boulevard de la Liberté, Bonanjo, Texas, Cameroon','1234 Elm Street, Brooklyn, NY 11201, USA',1,450000.00,'1','Cameron','Cameroon','Texas','1742374655.5798.jpg','','','30.8532454','-96.9769304',7,0,'approved',14,'2025-03-01 07:21:40','2025-05-29 09:52:00','Monthly','stylish-city-apartment-in-prime-location','Stylish City Apartment in Prime Location','A modern and stylish apartment located in the heart of the city. Enjoy easy access to shops, restaurants, and entertainment.','city apartment, modern living, urban home, downtown, furnished rental','1740813700.0627.jpg',1,0,196,NULL),(13,'1',NULL,'Spacious Family House','Imagine the potential of these sample properties, each offering unique opportunities for customization and personalization','102 New South Wales, Cameroon','kribi',0,35000000.00,'1','Cameron Park','Cameroon','New South Wales','1742480188.79.jpg','','','-32.9107871','151.6156653',7,0,'approved',0,'2025-03-01 07:25:00','2025-06-04 12:36:30','Monthly','spacious-family-house','Spacious Family Home with Large Garden','A perfect family home with a large garden, multiple bedrooms, and a welcoming atmosphere for comfortable living.','family home, large house, spacious living, garden, suburban home','1740813900.0314.jpg',1,0,196,NULL),(14,'8',NULL,'Elegant Penthouse Suite','Your dream property awaits. Explore diverse suggestions and take the first step towards your new home','Swastik Society','kribi',0,150.00,'1','Ahmedabad','India','Gujarat','1748514541.0313.jpg','','','23.037298','72.56095100000002',7,1,'approved',9,'2025-03-01 07:30:43','2025-07-18 11:11:36','USD','elegant-penthouse-suite','Luxury Penthouse with Stunning City Views','Live in style with this elegant penthouse suite offering stunning city skyline views and top-tier amenities.','penthouse suite, luxury apartment, high-rise, skyline view, executive living','1740814243.4494.jpg',1,0,196,NULL),(17,'1',NULL,'Luxury villa','Villa de Luxe\r\nSuperbe villa de luxe au Cameroun avec architecture moderne, piscine privée, grandes baies vitrées, et jardin tropical. Située dans un quartier prestigieux, elle offre sécurité, confort et élégance. Idéale pour un style de vie exclusif. 🌴🏡','Douala , Cameroon','Kribi, Cameroon',3,100000.00,'1','Douala','Cameroon','Littoral Region','1742389670.1219.jpg','','','4.0510564','9.7678687',12,0,'approved',12,'2025-03-18 05:36:07','2025-06-20 11:12:13','Yearly','luxury-villa','Testing purpose','Testing','Testing','1742276167.1894.png',1,0,196,NULL),(21,'14',NULL,'Luxury Commercial space','A modern multi-story commercial building in Cameroon with glass windows, office spaces, and retail shops. It features a spacious parking lot, palm trees, and a clean paved road, creating a vibrant and professional business environment.','4th floor Sarthak House, Swastik Cross Roads, C. G. Road, Swastik Society, Navrangpura, Ahmedabad, Gujarat 380009, India','kribi',0,99999999.99,'1','Ahmedabad','India','Gujarat','1743414163.4355.jpg','','','23.037298','72.56095100000002',7,0,'approved',7,'2025-03-19 13:27:14','2025-05-29 09:51:40','','luxury-commercial-space',NULL,NULL,NULL,NULL,0,0,196,NULL),(22,'12',NULL,'3 BHK  Apartment','Experience the epitome of luxury living in this stunning 3 BHK apartment, designed to offer the perfect balance of sophistication, comfort, and convenience.','kribi,cameroon','kribi',0,3700000.00,'1','Kribi','Cameroon','South Region','1743497900.5529.jpg','','','2.9405941','9.9101915',7,0,'approved',13,'2025-03-24 07:20:52','2025-05-29 09:51:29','','3-bhk-apartment',NULL,NULL,NULL,NULL,1,0,196,NULL),(24,'17',NULL,'5 BHK villa','A villa is a luxurious, spacious residence that offers privacy, comfort, and elegance, often located in scenic destinations such as coastal areas, countryside estates, or exclusive gated communities. Villas are designed to provide a serene and upscale living experience, combining modern amenities with stunning architecture.','kribi','kribi',0,99999999.99,'1','Kribi','Cameroon','South Region','1748510130.5784.jpg','','','2.9405941','9.9101915',7,0,'approved',0,'2025-03-25 09:49:15','2025-05-29 09:15:30','USD','5-bhk-villa',NULL,NULL,NULL,NULL,0,0,196,NULL),(29,'1',NULL,'1 BHK luxury','luxury bungalow','douala','Kribi, Cameroon',3,390000.00,'1','Douala','Cameroon','Littoral Region','1742987416.2527.jpg','','','4.0510564','9.7678687',12,0,'approved',0,'2025-03-26 11:10:16','2025-06-20 11:11:58','Quarterly','1-bhk-luxury','','','',NULL,0,0,196,NULL),(39,'12',NULL,'Lep Residence','Building is located at Bonendale 100 m after San Francisco Hotel City,Bonaberi.  Provide secured parking, night watchman and a Water tower holding 10000 litters of water for continuous water supply 😀. The rooms are spacious equipped with individual pre-paid Eneo meters.','Bonaberi,Douala, Cameroon','Douala',1,120000.00,'1','Bonabéri,bonendale','Cameroon','Littoral Region','1751638616.2815.jpg','','','4.1124321','9.6359866',48,1,'approved',93,'2025-04-15 06:24:03','2025-07-17 06:41:11','Monthly','lep-residence','Two bedrooms Apartment in douala','Luxury two bedrooms apartment with secured parking','unfurnished two bedrooms Apartment. Comfortable Apartment, Nice two bedroom apartment','1747131869.8934.jpg',0,0,196,NULL),(41,'14',NULL,'Eco Shops','Eco Shop is located beside Eco Hotel 🏨Rail Bonaberi. Made up of six spacious shops. Eco Shop is just 100 m to the main road.','3JWX+85R, Entrée SONEL, Bonabéri, Cameroon','Douala',1,100000.00,'1','Bonabéri','Cameroon','Région du Littoral','1748619600.7668.jpg','','','4.0958732','9.647896099999999',48,1,'approved',46,'2025-04-26 12:27:33','2025-07-14 08:55:56','Monthly','eco-shops',NULL,NULL,NULL,NULL,0,0,196,NULL),(42,'17',NULL,'Twin Guesthouse','Three-Bedroom Apartment\nSpacious and elegantly designed, this fully furnished three-bedroom apartment features two modern bathrooms, a well-equipped kitchen, and tasteful interiors ideal for families or groups. With ample space and comfort, it offers a perfect blend of functionality and style.','Douala,  Bonaberi Ndobo','Douala',1,70000.00,'1','Bonabéri','Cameroon','Littoral Region','1746003124.0227.jpg','','','4.0944469','9.6394955',99,1,'approved',22,'2025-04-30 08:52:04','2025-07-02 09:36:46','Night','twin-guesthouse',NULL,'Twin Guesthouse',NULL,NULL,0,0,196,NULL),(43,'17',NULL,'Twin Guesthouse','Two-Bedroom Apartment \nSituated in Ndobo, just a short 70-meter walk from the main road, this beautifully furnished two-bedroom apartment includes two private bathrooms and a contemporary kitchen. Perfect for small families or business travelers seeking both convenience and comfort in a quiet environment.','Ndobo','Douala',1,50000.00,'1','Bonabéri','Cameroon','Littoral Region','1746003847.2652.jpg','','','4.0944469','9.6394955',99,1,'approved',32,'2025-04-30 09:04:07','2025-07-11 16:35:03','Night','twin-guesthouse-1',NULL,NULL,NULL,NULL,0,0,196,NULL),(44,'17',NULL,'Twin Guesthouse','One-Bedroom Suite\nPerfect for solo travelers or couples, this fully furnished one-bedroom suite combines comfort and privacy. It features stylish décor and all essential amenities, making it an excellent choice for a relaxed and enjoyable stay.','Ndobo','Douala',1,35000.00,'1','Bonabéri','Cameroon','Littoral Region','1746004425.5321.jpg','','','4.0944515','9.6394941',99,1,'approved',88,'2025-04-30 09:13:45','2025-07-08 14:27:28','Night','twin-guesthouse-2',NULL,NULL,NULL,NULL,0,0,196,NULL),(46,'17',NULL,'Résidence Fé','2 BEDROOMS | Short & Long Term Stay.  \nWHY US?    \n🔶️Tranquility, Steps away from 🍜 🥂 🏦 🏥 🚕, & more.\n🔶️CCTV Cameras, Security Personnels & Police close-by \n🔶️24/7 Customer Care, Electricity, High-speed Internet plus Streaming.\n🔶 ️In-house Parking.','📍50 Meters Opposite Domino Supermarket, Ancienne Route Bonaberi.','📍50 Meters Opposite Domino Supermarket, Ancienne Route Bonaberi.',1,50000.00,'1','Bonabéri','Cameroon','Littoral Region','1746523665.1616.jpg','','','4.0749954','9.6761203',145,1,'approved',28,'2025-05-06 09:27:45','2025-07-10 13:21:33','Night','residencefe',NULL,NULL,NULL,NULL,0,0,196,NULL),(47,'17',NULL,'Résidence Fé','1 BEDROOM | Short & Long Term Stay.Call/Whatsapp : +237 658970544 / +237 677867139\nWHY US? \n🔶️Tranquility, Steps away from 🍜 🥂 🏦 🏥 🚕, & more.\n🔶️CCTV Cameras, Security Personnels & Police close-by \n🔶️24/7 Customer Care, Electricity, High-speed Internet plus Streaming.\n🔶 ️In-house Parking.','📍50 Meters Opposite Domino Supermarket, Ancienne Route Bonaberi.','',1,30000.00,'1','Bonabéri','Cameroon','Littoral Region','1746527086.5621.jpg','','','4.0749928','9.6761198',145,0,'rejected',0,'2025-05-06 10:24:46','2025-05-06 13:07:09','Night','residencefe-1',NULL,NULL,NULL,NULL,0,0,196,NULL),(48,'16',NULL,'Epee','Duplex aménagé situé à Bonaberi à quelques pas de la route 150m ancienne  route entrée TOP RANK PLAZA près du collège St Bernard.','Bonaberi','2811',1,1000000.00,'1','Bonabéri','Cameroon','Littoral Region','1746528709.4624.jpg','','','4.0873513','9.6681165',88,1,'approved',44,'2025-05-06 10:51:49','2025-07-16 17:43:21','Monthly','epee',NULL,NULL,NULL,NULL,0,0,196,NULL),(51,'18',NULL,'Bisso Hotel','Executive Room: Bed for three space wity good waterheater and a smart and fridge and a security safe for your valuables.','Ancient Route opposite Hotel DK','Bonaberi, Douala',1,35000.00,'1','Bonabéri','Cameroon','Région du Littoral','1747072965.786.jpg','','','4.0761565','9.6736494',157,1,'approved',40,'2025-05-12 18:02:45','2025-07-03 16:41:08','Night','bisso-hotel','Luxury Hotel','Nice Hotel in Douala with clean and affordable.Our staffs are professionals in handling clients.','Cheap Hotel, Affordable hotel,Nice hotel, hotel with AC Rooms. Hotels with Free WiFi.hotel with parking. hotel with restaurant',NULL,0,0,196,NULL),(52,'17',NULL,'Bisso Hotel Guest House','One bedroom apartment,well equipped for both short and and long stay. unique sofas and a workspace.','Ancien Route','Bonaberi, Douala',1,65000.00,'1','Bonabéri','Cameroon','Région du Littoral','1747941769.0572.jpg','','','4.0761568','9.6736258',157,1,'approved',23,'2025-05-12 18:39:44','2025-07-05 21:31:48','Night','bisso-hotel-guest-house','Guest House','Spacious Rooms and Comfortable','Guest House, Guest in Douala, Guest House in Bonaberi, Nice Guest House, furnished apartment. guest house with AC. Guest House with standby power supply. guest with airport pickup',NULL,0,0,196,NULL),(53,'17',NULL,'Rovie Estate Guest House','Enjoy a peaceful stay in this fully furnished 1-bedroom with a comfortable bed, equipped kitchen, and dining table. Perfect for solo guests or couples seeking comfort, privacy, and convenience in a secure setting. Ideal for both short and long stays.','Behind Molyko Police','Buea',1,50000.00,'1','Buea','Cameroon','Southwest Region','1749158009.1511.jpg','','','4.1585318','9.276572',166,1,'approved',14,'2025-05-16 16:17:59','2025-07-08 14:30:27','Night','rovie-estate-guest-house',NULL,NULL,NULL,NULL,0,0,196,NULL),(54,'17',NULL,'Rovie Estate Guest House','Luxury 2-Bedroom VIP  with King Beds & Kitchen\r\nStay in comfort at this upscale 2-bedroom guest house, featuring two king-size beds, a fully equipped kitchen, and a private dining area. Ideal for families, couples, or business travelers, this clean and quiet space offers fast Wi-Fi, a smart TV, and secure surroundings. Located near top attractions and amenities, it’s perfect for short or extended stays. Enjoy a peaceful retreat with all the comforts of home in a VIP setting. Book now for your next stay!','Behind Molyko Police','Buea',1,250000.00,'1','Buea','Cameroon','Southwest Region','1749157853.4786.jpg','','','4.1586033','9.2765845',166,1,'approved',18,'2025-05-16 16:26:18','2025-07-08 14:26:35','Night','rovie-estate-guest-house-1',NULL,NULL,NULL,NULL,0,0,196,NULL),(55,'17',NULL,'Rovie Estate Guest House','Cozy 2-Bedroom with Kitchen & Dining Area\nEnjoy a comfortable stay in this fully furnished 2-bedroom guest house, perfect for families, couples, or business travelers. It features clean, spacious bedrooms, a well-equipped kitchen, and a dining table for easy meals or work. Located in a peaceful and secure area, you\'ll have everything you need for a relaxing short or long-term stay. Free Wi-Fi and essential amenities included. Book now for comfort, convenience, and great value!','Behind Molyko Police','Buea',1,750000.00,'1','Buea','Cameroon','Southwest Region','1747413333.3747.jpg','','','4.1585929','9.2765815',166,1,'pending',0,'2025-05-16 16:35:33','2025-05-16 16:35:33','Night','rovie-estate-guest-house-2','','','',NULL,0,0,196,NULL),(56,'17',NULL,'Rovie Estate Guest House','Cozy 2-Bedroom with Kitchen & Dining Area\r\nEnjoy a comfortable stay in this fully furnished 2-bedroom guest house, perfect for families, couples, or business travelers. It features clean, spacious bedrooms, a well-equipped kitchen, and a dining table for easy meals or work. Located in a peaceful and secure area, you\'ll have everything you need for a relaxing short or long-term stay. Free Wi-Fi and essential amenities included. Book now for comfort, convenience, and great value!','Molyko Behind Police Station','Buea',1,75000.00,'1','Buea','Cameroon','Southwest Region','1749157318.5748.jpg','','','4.1585272','9.2765744',166,1,'approved',30,'2025-05-16 16:40:10','2025-07-10 12:18:49','Night','rovie-estate-guest-house-3',NULL,NULL,NULL,NULL,0,0,196,NULL),(58,'18',NULL,'Bisso Hotel','Clean and affordable','Bonaberi opposite DK Hotel','Bonaberi, Douala',1,30000.00,'1','Bonabéri','Cameroon','Région du Littoral','1747941487.5419.jpg','','','4.0763034','9.6737146',157,1,'approved',22,'2025-05-22 19:18:07','2025-07-07 17:07:57','Night','bisso-hotel-1','','','',NULL,1,0,196,NULL),(59,'17',NULL,'Residence Fé','1 BEDROOM / STUDIO | Short & Long Term Stay.  \nWHY US?    \n🔶️Tranquility, Steps away from 🍜 🥂 🏦 🏥 🚕, & more.\n🔶️CCTV Cameras, Security Personnels & Police close-by \n🔶️24/7 Customer Care, Electricity, High-speed Internet plus Streaming.\n🔶 ️In-house Parking.','📍50 Meters Opposite Domino Supermarket, Ancienne Route Bonaberi.','📍50 Meters Opposite Domino Supermarket, Ancienne Route Bonaberi.',1,30000.00,'1','Bonabéri','Cameroon','Littoral Region','1748082043.5105.jpg','','','4.0749736','9.6761523',145,1,'approved',28,'2025-05-24 10:20:43','2025-07-01 15:21:07','Night','residencefe-2',NULL,NULL,NULL,NULL,0,0,196,NULL),(60,'17',NULL,'Dada Modern Estate','Two bedrooms comfortable for family stay.','Limbe, Cameroon','Opposite main entrance to the stadium',1,45000.00,'1','Limbe','Cameroon','Southwest Region','1748518788.1611.jpg','','','4.011915399999999','9.1575214',178,1,'approved',33,'2025-05-29 11:16:39','2025-07-02 13:45:33','Night','dada-modern-estate',NULL,NULL,NULL,NULL,0,0,196,NULL),(61,'17',NULL,'Dada Modern Estate','Cozy one bedroom  with modern facilities .','Limbe, Cameroon','Opposite main entrance to the stadium',1,30000.00,'1','Limbe','Cameroon','Southwest Region','1748518396.1282.jpg','','','4.011915399999999','9.1575214',178,1,'approved',55,'2025-05-29 11:26:11','2025-07-16 17:10:13','Night','dada-modern-estate-1','Dada Modern Estate','Cozy one bedroom  with modern facilities .',NULL,NULL,0,0,196,NULL),(64,'17',NULL,'Luxury Guest House','Luxury Guest House','Cameroon','kribi',0,535544.00,'1','Douala','Cameroon','Région du Littoral','1749034193.6034.jpg','','','4.050554196315366','9.76823259391785',7,0,'approved',1,'2025-06-04 10:48:41','2025-06-19 04:05:43','','luxury-guest-house',NULL,NULL,NULL,NULL,0,0,196,NULL),(66,'17',NULL,'résidence air charleroi','Coucou mes amours ne venez pas me dire après que vous ne savez pas où passer votre séjour à Douala 😉 nous avons toujours des bonnes choses pour vous avez les prix incroyable 🫢🫢une promotion imbattable sur nos appartements meublés, je dis bien imbattable 😍😋😋\r\nPour vos moyens et longs séjours dans la ville de Douala, nous vous proposons ces magnifiques \r\n\r\nTarifs : par nuitée \r\nAppartement :\r\nLong séjour : 20mil \r\nCourte durée : 25mil \r\n\r\nStudio :\r\nLong séjours :15mil \r\nCourte séjours :20mil \r\n\r\nChambre meublée : long séjours : 10mil\r\nCourte séjours : 13500f \r\n\r\nChambre climatisé : 10mil \r\nSieste : 5mil \r\nManifestation 50mil (anniversaire et bien d\'autres.....)\r\n\r\n Oui-oui se sont les vrais prix 🤫🤫\r\n\r\n appartements meublés discrets,confortables 😍😍\r\nAMAC(appartements meublés air charleroi) met  à votre disposition:\r\n-Des appartements meublés haut standing.\r\n-Des appartements à louer.\r\nConstituer de:\r\n1 salon climatisé \r\n2 chambres climatisées \r\n2 douches moderne\r\n1 cuisine moderne\r\n-WiFi illimité haut débit \r\n-1 buanderie . \r\n-Camera de surveillance 7/7\r\n- gardien jour et nuit \r\n-service de ménage 6jours sur 7\r\n-comsommation du courant électrique à Notre charge \r\n-canal +\r\n-forage disponibles \r\n-Un service de lingerie.\r\n-Location de voiture \r\nNous sommes dans la ville de douala,  a 5 minutes de l\'aéroport en face du lycée de Brazzaville et il est écrit sur l\'immeuble air Charleroi. \r\nAlors nous réservons une belle surprise au futur premiers occupants, alors venez nombreux.  Pour plus d\'informations contactez le numéro suivant: 656583484(WhatsApp,  et appel','Nylon','Douala',1,25000.00,'1','Douala','Cameroon','Littoral Region','1749411012.0498.jpg','1749411012.05.jpg','','4.0262437','9.7285685',191,0,'rejected',0,'2025-06-08 19:30:12','2025-06-09 14:20:30','Night','rsidence-air-charleroi','','','',NULL,0,0,196,NULL),(67,'18',NULL,'Debolonia Palace Hotel','Standard room with double beds','Bojongo, Bocom Ndobo','',1,25000.00,'1','Bonabéri','Cameroon','Littoral Region','1749471117.5286.jpg','','','4.104323235779387','9.615580524465596',176,1,'approved',8,'2025-06-09 12:11:57','2025-07-08 14:34:31','Night','debolonia-palace-hotel',NULL,NULL,NULL,NULL,0,0,196,NULL),(70,'17',NULL,'Studios (UK Styled)','Studios(UK style) - Consist of a large room with open plan fully fitted kitchen, a sofa area,  a toilet and a balcony. It is fully furnished too - with air conditioning, free internet (WiFi), constant water supply and standby generator  -  hence 24hrs power supply.\r\n\r\nApart from being secured due to its location (Clerks\' Quarters),Toilcam  has 24hrs security coupled with CCTV as well as  Audio/Video intercom\r\n\r\nAccessibility, comfort, excellent customer services and luxury at affordable prices is our forte','Clerks\' Quarters - ENAP Entrance - Buea','Buea',1,35000.00,'1','Buea','Cameroon','Southwest Region','1749545162.1765.jpg','','','4.1534878','9.2533855',188,1,'approved',35,'2025-06-09 19:21:45','2025-07-16 20:04:49','Night','studios-uk-styled','Hotel, Guest house, Buea, luxury',NULL,'Luxury, Accessibility, Spacious, Conference Room,',NULL,1,0,196,NULL),(71,'17',NULL,'Toilcam - 2 Bedroom Apartments','2 Bedroom Apartments, located at Clerk\'s Quarters, Enap Entrance','Clerk\'s Quarters, EnapEntrance','',1,50000.00,'1','Buéa','Cameroon','Région du Sud-Ouest','1749501879.6582.jpg','','','4.1541291','9.2413124',188,1,'approved',4,'2025-06-09 20:40:38','2025-07-11 12:19:09','Night','toilcam-2-bedroom-apartments',NULL,NULL,NULL,NULL,0,0,196,NULL),(73,'2',NULL,'Co-working Space','Co-working office space for hire.\r\nFlexible working - Daily, weekly and monthly rates available','Clerks\' Quarters, ENAP Entrance, Buea','null',1,0.00,'1','Buéa','Cameroon','Région du Sud-Ouest','1749560699.4582.jpg','','','4.154194043103554','9.24132628826903',188,0,'rejected',0,'2025-06-10 13:04:59','2025-06-11 12:10:59','Night','co-working-space','','','',NULL,0,0,196,NULL),(74,'14',NULL,'Conference Room & Events Hall','Conference Room\r\nEvents Hall','Clerks\' Quarter, ENAP Entrance, Buea','null',1,250000.00,'1','Buéa','Cameroon','Région du Sud-Ouest','1749561128.4438.jpg','','','4.154135189535753','9.241304830596912',188,0,'rejected',0,'2025-06-10 13:12:08','2025-06-11 12:11:21','Night','conference-room-events-hall','','','',NULL,0,0,196,NULL),(75,'15',NULL,'Beach side luxury villa','beach side luxury villa','heathrow airport','',0,78464848.00,'1','heathrow','United Kingdom','England','1749795096.5564.png','','','51.5072178','-0.1275862',136,0,'approved',8,'2025-06-13 06:11:36','2025-06-18 03:27:42','','beach-side-luxury-villa',NULL,NULL,NULL,NULL,0,0,193,NULL),(78,'16',NULL,'Irma','at the top of the hill','bonendallé','Douala',1,250000.00,'1','Bonabéri','Cameroon','Littoral Region','1750233389.5634.jpg','1750233389.5641.jpg','','4.1124061','9.6359826',49,0,'pending',0,'2025-06-18 07:56:29','2025-06-20 09:52:20','Monthly','irma','','','',NULL,1,0,196,'2025-06-20 09:52:20'),(81,'17',NULL,'Residence Denza Premium','Cozy three-bedroom apartment with a rooftop for parties. Smart and fully automated. Ideal for Family and special parties.','Bonanberi, Douala, Cameroon','Ancient Route Bonanberi',1,150000.00,'1','Douala','Cameroon','Région du Littoral','1750524863.6489.jpg','','','4.083053','9.6675962',206,1,'approved',14,'2025-06-18 15:23:40','2025-07-10 12:17:23','Night','residence-denza-premium',NULL,NULL,NULL,NULL,0,0,196,NULL),(82,'17',NULL,'Residence Le Progres','Profitez d\'un espace convivial, épuré et agréable dans un quartier résidentiel  en plein cœur de Denver à Bonamoussadi -Douala\r\nAvec une capacité d\'accueil de près de 5 personnes, nous mettons à votre disposition dans des appartements meublés haut-standing:','Résidence le progrès, Bonamoussadi, Douala, Cameroon','DOUALA',1,75000.00,'1','Douala','Cameroon','Région du Littoral','1750541081.6933.png','','','4.095254','9.7286994',205,1,'approved',9,'2025-06-19 05:08:10','2025-07-05 21:32:42','','residence-le-progres',NULL,NULL,NULL,NULL,0,0,196,NULL),(83,'17',NULL,'Residence Le Progres','Profitez d\'un espace convivial, épuré et agréable dans un quartier résidentiel  en plein cœur de Denver à Bonamoussadi -Douala\r\nAvec une capacité d\'accueil de près de 5 personnes, nous mettons à votre disposition dans des appartements meublés haut-standing:','Résidence le progrès, Bonamoussadi, Douala, Cameroon','DOUALA',1,50000.00,'1','Douala','Cameroon','Région du Littoral','1750541222.4178.jpg','','','4.095254','9.7286994',205,1,'approved',17,'2025-06-19 05:32:27','2025-07-11 16:31:59','Night','residence-le-progres-2',NULL,NULL,NULL,NULL,0,0,196,NULL),(84,'16',NULL,'Luxury duplex house','Luxury duplex house','cameroon','kribi',0,456744.00,'1','Douala','Cameroon','Littoral Region','1750311258.7717.jpg','','','4.0507200778663135','9.767379651451114',7,0,'approved',0,'2025-06-19 05:34:18','2025-06-19 09:31:16','','luxury-duplex-house','','','',NULL,0,0,23,NULL),(86,'17',NULL,'Residence Le Progres','Profitez d\'un espace convivial, épuré et agréable dans un quartier résidentiel  en plein cœur de Denver à Bonamoussadi -Douala\r\nAvec une capacité d\'accueil de près de 5 personnes, nous mettons à votre disposition dans des appartements meublés haut-standing:','Résidence le progrès, Bonamoussadi, Douala, Cameroon','DOUALA',1,65000.00,'1','Douala','Cameroon','Région du Littoral','1750314316.9885.png','','','4.095254','9.7286994',205,1,'approved',86,'2025-06-19 06:25:16','2025-07-10 10:04:05','Night','residence-le-progres-1','','','',NULL,0,0,196,NULL),(87,'2',NULL,'Office space','Office space','237, Douala, Cameroon','kribi',0,46464.00,'1','Douala','Cameroon','Région du Littoral','1750322476.382.jpg','','','4.053347423056613','9.767079244041446',7,0,'approved',0,'2025-06-19 08:41:16','2025-06-20 06:26:14','','office-space','','','',NULL,0,0,53,NULL),(88,'17',NULL,'Elegant Houses','Elegant Houses','Building, Sardar Patel Nagar, Ellisbridge, Ahmedabad, Gujarat 380009, India','Douala',0,65656.00,'1','Ahmedabad','India','Gujarat','1751636052.5853.jpg','','','23.0320787','72.555963',7,1,'approved',87,'2025-06-19 09:02:49','2025-07-18 11:25:14','','elegant-houses',NULL,NULL,NULL,NULL,0,0,53,NULL),(89,'1',NULL,'Luxury bungalow','Luxury bungalow','237, Douala, Cameroon','kribi',0,46466.00,'1','Douala','Cameroon','Région du Littoral','1750329648.7386.jpg','','','4.051512028027826','9.767873177909854',7,0,'approved',0,'2025-06-19 10:40:48','2025-06-19 10:42:18','','luxury-bungalow','','','',NULL,0,0,53,'2025-06-19 10:42:18'),(92,'12',NULL,'Appartment','we’ll furnish with clean toilets with water flowing round the clock, 4 bed rooms and a big parlour for relaxation.','Bonaberi','',1,65000.00,'1','Douala','Cameroon','Région du Littoral','1751369299.0997.jpg','1751369299.1004.jpg','','4.09119','9.6609819',214,1,'pending',0,'2025-07-01 11:28:19','2025-07-01 11:28:19','Monthly','appartment','Apartments','Large apartment with clean toilets and good,','','1751369299.1001.jpg',1,0,196,NULL),(93,'8',NULL,'Bonaberi studio','This property contains well drainage system, clean rooms which are large.','Douala, Cameroon','Bonaberi',1,35000.00,'1','Douala','Cameroon','Littoral Region','1751634582.0655.jpg','1751634582.0659.jpg','','4.0510564','9.7678687',214,0,'pending',0,'2025-07-04 13:09:42','2025-07-04 13:10:32','Monthly','bonaberi-studio','','','',NULL,1,0,196,'2025-07-04 13:10:32'),(95,'12',NULL,'NWI NI FO BUILDING','Fully Built Property for Sale in Bonaberi (Carrefour Ewane, Rail)\r\n\r\nStep into a smart investment with this beautifully constructed and securely landed property located in the highly accessible Carrefour Ewane (Nwi Ni Fo Building), Rail – Bonaberi, just 5 minutes from the bustling Rail Market.\r\n\r\n🏠 Property Features:\r\n\r\n8 spacious two-bedroom apartments\r\n\r\n3 comfortable one-bedroom units\r\n\r\nTotal of 11 income-generating apartments\r\n\r\n🪙 Monthly Rental Income: 965,000 FCFA – consistent and reliable cash flow from long-term tenants.Key Location Benefits:\r\n\r\nJust a stone’s throw from the Rail Market\r\n\r\nEasy access to transportation and commercial hubs\r\n\r\nWell-developed neighborhood with high rental demand','4J3R+2JV, Bonabéri,Douala,Cameroon','Douala',0,99999999.99,'1','Bonabéri','Cameroon','Littoral Region','1751801298.9419.jpg','','','4.1017506','9.642257400000002',48,1,'approved',14,'2025-07-06 06:01:58','2025-07-16 10:18:59','','nwi-ni-fo-building',NULL,NULL,NULL,NULL,0,0,196,NULL),(96,'12',NULL,'SEPAL COURTS','PENTHOUSE FOR SALE.\r\n4 bedrooms, all self-contained\r\nLiving room\r\nDining \r\nKitchen\r\nLaundry space\r\nA total of five bathrooms (washrooms)','13c Mumia Rd, Kampala, Uganda','Douala',0,230000.00,'1','Kampala','Uganda','Central Region','1752142896.1621.jpg','','','0.3230394999999999','32.616756',48,1,'approved',4,'2025-07-10 09:30:14','2025-07-15 21:07:48','','sepal-courts',NULL,NULL,NULL,NULL,0,0,53,NULL),(97,'17',NULL,'TA APPARTS','VENEZ PAR CHOIX ET RESTEZ AVEC CONVICTION...','677821282 / 233393717/ 653959457 / 681476104','Douala- Bonaberi',1,50000.00,'1','Bonabéri','Cameroon','Littoral Region','1752481485.3334.jpg','','','4.0923873','9.670465',221,1,'pending',0,'2025-07-14 08:24:45','2025-07-14 08:24:45','Night','ta-apparts','TA APPARTS','','',NULL,1,0,196,NULL),(98,'12',NULL,'Cathy\'s Residence','Cathy\'s residence is a building suituated at Petrolex Ndobo Bepelle. it is semi funished and comtain 3 bed rooms 2 pallors 1 kitchen and a dining section','Petrolex , Ndobo Bonaberi Douala, Cameroon','Bonaberi',1,30000.00,'1','Douala','Cameroon','Littoral Region','1752493634.0685.jpg','','','4.0510564','9.7678687',214,1,'pending',0,'2025-07-14 11:47:14','2025-07-14 11:47:14','Monthly','cathys-residence','','','',NULL,1,0,196,NULL),(99,'18',NULL,'Hotel Test','test','213, Devpath Behind Super Mall, Chimanlal Girdharlal Rd, Ellisbridge, Ahmedabad, Gujarat 380006, India','Douala',0,1200.00,'1','Ahmedabad','India','Gujarat','1752668088.53.png','','','23.026207','72.5559631',7,1,'pending',0,'2025-07-16 12:14:48','2025-07-16 12:14:48','','hotel-test','','','',NULL,0,0,53,NULL);

--
-- Table structure for table `propertys_inquiry`
--

CREATE TABLE `propertys_inquiry` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `propertys_id` bigint unsigned NOT NULL,
  `customers_id` bigint unsigned NOT NULL,
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '0 : Pending 1:Accept  2: Complete 3:Cancle',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `propertys_inquiry_propertys_id_foreign` (`propertys_id`),
  KEY `propertys_inquiry_customers_id_foreign` (`customers_id`),
  CONSTRAINT `propertys_inquiry_customers_id_foreign` FOREIGN KEY (`customers_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `propertys_inquiry_propertys_id_foreign` FOREIGN KEY (`propertys_id`) REFERENCES `propertys` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `propertys_inquiry`
--


--
-- Table structure for table `reject_reasons`
--

CREATE TABLE `reject_reasons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `property_id` bigint unsigned DEFAULT NULL,
  `project_id` bigint unsigned DEFAULT NULL,
  `reason` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `reject_reasons_property_id_foreign` (`property_id`),
  KEY `reject_reasons_project_id_foreign` (`project_id`),
  CONSTRAINT `reject_reasons_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE,
  CONSTRAINT `reject_reasons_property_id_foreign` FOREIGN KEY (`property_id`) REFERENCES `propertys` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reject_reasons`
--

INSERT INTO `reject_reasons` VALUES (4,22,NULL,'Bad property construction is not good building is weak',1,'2025-03-24 09:03:01','2025-03-24 09:03:01',NULL),(5,21,NULL,'bad',1,'2025-03-24 09:16:17','2025-03-24 09:16:17',NULL),(7,10,NULL,'test',1,'2025-03-25 06:42:35','2025-03-25 06:42:35',NULL),(8,10,NULL,'test',1,'2025-03-25 06:42:37','2025-03-25 06:42:37',NULL),(9,10,NULL,'test',1,'2025-03-25 06:42:42','2025-03-25 06:42:42',NULL),(18,39,NULL,'Reject',1,'2025-04-15 09:23:42','2025-04-15 09:23:42',NULL),(21,47,NULL,'Kindly share the interior photos of the apartment.\r\nLex House Team',1,'2025-05-06 13:07:09','2025-05-06 13:07:09',NULL),(23,66,NULL,'We regret to inform you that your listing on the Lex Group platform has been rejected due to the quality of your photos not meeting our standards. We recommend hiring a professional photographer to obtain high-quality images. If you\'d like, Lex Group can assist you by providing a photographer at your expense.\r\n  \r\nNous avons le regret de vous informer que votre annonce sur la plateforme Lex Group a été refusée car la qualité de vos photos ne répond pas à nos critères. Nous vous recommandons de faire appel à un photographe professionnel pour obtenir des images de haute qualité. Si vous le souhaitez, Lex Group peut vous aider en mettant à votre disposition un photographe à vos frais.',1,'2025-06-09 14:20:30','2025-06-09 14:20:30',NULL),(24,73,NULL,'Lex Group cannot approve your listing at this time because you have not attached high-quality photos to showcase the property. Please upload good-quality images; providing 16 or more images will give a better view of the property. Thank you.',1,'2025-06-11 12:10:59','2025-06-11 12:10:59',NULL),(25,74,NULL,'Lex Group cannot approve your listing at this time because you have not attached high-quality photos to showcase the property. Please upload good-quality images; providing 16 or more images will give a better view of the property. Thank you.',1,'2025-06-11 12:11:21','2025-06-11 12:11:21',NULL),(26,71,NULL,'We cannot approve this listing because the images do not showcase the property. Selling online is complicated, and we prefer professional photos. We do not accept images taken with cell phones.\r\nKindly get the right images and upload again.\r\nYou can contact our team if you need our assistance. \r\nThanks',1,'2025-06-11 12:21:23','2025-06-11 12:21:23',NULL),(28,64,NULL,'reject',1,'2025-06-18 06:10:12','2025-06-18 06:10:12',NULL),(29,88,NULL,'Reject Reason',1,'2025-07-18 09:25:27','2025-07-18 09:25:27',NULL),(30,88,NULL,'Reject Reason',1,'2025-07-18 09:28:59','2025-07-18 09:28:59',NULL),(31,88,NULL,'Reject Reason',1,'2025-07-18 09:32:02','2025-07-18 09:32:02',NULL),(32,88,NULL,'Reject Reason',1,'2025-07-18 09:52:04','2025-07-18 09:52:04',NULL),(33,88,NULL,'Reject Reason',1,'2025-07-18 09:56:08','2025-07-18 09:56:08',NULL);

--
-- Table structure for table `report_reasons`
--

CREATE TABLE `report_reasons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `report_reasons`
--


--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint unsigned NOT NULL,
  `property_id` bigint unsigned NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rating` int NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_approved` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `reviews_customer_id_foreign` (`customer_id`),
  KEY `reviews_property_id_foreign` (`property_id`),
  CONSTRAINT `reviews_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `reviews_property_id_foreign` FOREIGN KEY (`property_id`) REFERENCES `propertys` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reviews`
--

INSERT INTO `reviews` VALUES (1,7,43,'Nice property',5,'I stayed at this property for over a year and had a wonderful experience. The apartment was clean, well-maintained, and located in a safe neighborhood. The landlord was responsive and helpful with any issues. I especially loved the natural light and the spacious living room. Highly recommend this place to anyone looking for a hassle-free rental!',0,'2025-06-19 07:23:33','2025-06-19 07:24:16'),(2,7,84,'luxury duplex house',4,'property is good',1,'2025-06-19 08:32:56','2025-06-19 08:32:56'),(3,7,87,'Office space review',5,'very good spacious office',1,'2025-06-19 08:43:21','2025-06-19 08:43:21'),(4,7,88,'elegant houses',5,'property is good and is on sea face side environment is pleasant',1,'2025-06-19 09:04:25','2025-06-19 09:04:25'),(5,7,89,'bungaloew review',4,'good property',1,'2025-06-19 10:41:38','2025-06-19 10:41:38'),(6,92,39,'Good',3,'Good and comfortable for family stay',1,'2025-06-21 20:41:32','2025-06-21 20:41:32');

--
-- Table structure for table `schedule_property_visits`
--

CREATE TABLE `schedule_property_visits` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `full_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_id` bigint unsigned DEFAULT NULL,
  `phone_prefix` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `preferred_date` date NOT NULL,
  `preferred_time` time NOT NULL,
  `purpose_of_visit` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `property_id` bigint unsigned NOT NULL,
  `property_owner_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_approved` tinyint(1) NOT NULL DEFAULT '0',
  `reject_reason` text COLLATE utf8mb4_unicode_ci,
  `status` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `schedule_property_visits_customer_id_foreign` (`customer_id`),
  KEY `schedule_property_visits_property_id_foreign` (`property_id`),
  CONSTRAINT `schedule_property_visits_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE SET NULL,
  CONSTRAINT `schedule_property_visits_property_id_foreign` FOREIGN KEY (`property_id`) REFERENCES `propertys` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `schedule_property_visits`
--

INSERT INTO `schedule_property_visits` VALUES (1,'rupal','rupal.gohel@moweb.com',170,NULL,'843295','2025-07-10','12:00:00','test visit to roveeet',88,7,'2025-07-02 08:22:41','2025-07-02 08:23:52',1,NULL,0),(2,'rupal nee','rupal.gohel@moweb.com',170,NULL,'43894','2025-07-10','10:25:00','new visit as I have to cancel previous plan.',88,7,'2025-07-02 08:25:06','2025-07-02 08:27:36',1,NULL,1),(3,'joesph','robertt@mailinator.com',215,NULL,'5236855132','2025-07-25','08:11:00','interested in your property',88,7,'2025-07-02 12:41:49','2025-07-02 12:57:54',1,NULL,1),(4,'Bobga Nwana Ngati','ngatibobga@icrsp.net',NULL,NULL,'677966717','2025-07-17','17:00:00','bb',43,99,'2025-07-02 14:24:30','2025-07-02 14:24:30',0,NULL,1),(5,'Bobga Nwana Ngati','ngatibobga@icrsp.net',NULL,NULL,'677966717','2025-07-10','15:31:00','Booking',39,48,'2025-07-02 14:31:35','2025-07-02 14:35:01',1,NULL,1),(6,'Ngati  Bobga','ineceprigram@gmail.com',206,NULL,'674208577','2025-07-09','18:55:00','check',39,48,'2025-07-02 17:56:00','2025-07-02 17:59:13',1,NULL,0),(10,'David QA','davidqa123@yopmail.com',216,NULL,'916578764536','2025-07-16','08:20:00','interested',88,7,'2025-07-03 13:50:44','2025-07-03 13:57:21',0,NULL,0),(11,'David QA','davidqa123@yopmail.com',216,NULL,'916578764536','2025-07-18','19:27:00','interested',88,7,'2025-07-03 13:57:56','2025-07-07 11:28:07',2,'Please provide a reason for rejection',1),(12,'david','robertt@mailinator.com',216,NULL,'57687665479','2025-07-18','23:17:00','visiting',88,7,'2025-07-04 13:47:53','2025-07-04 13:48:37',1,NULL,1),(13,'David QA','davidqa123@yopmail.com',216,NULL,'916578764536','2025-08-26','08:00:00','visiting',88,7,'2025-07-07 11:30:15','2025-07-07 11:30:55',1,NULL,1),(14,'david','robertt@mailinator.com',216,NULL,'56764537897','2025-08-24','21:24:00','Purpose of Visit',88,7,'2025-07-07 12:54:50','2025-07-07 13:14:16',1,NULL,1),(15,'David QA','davidqa123@yopmail.com',216,NULL,'916578764536','2025-07-07','18:45:00','visiting',88,7,'2025-07-07 13:15:23','2025-07-07 13:59:39',0,NULL,0),(16,'David QA','davidqa123@yopmail.com',216,NULL,'916578764536','2025-08-13','07:30:00','visiting',88,7,'2025-07-07 14:00:30','2025-07-08 06:09:18',1,NULL,1),(17,'David QA','davidqa123@yopmail.com',216,NULL,'916578764536','2025-07-31','08:46:00','visiting',88,7,'2025-07-08 06:22:15','2025-07-08 08:38:21',1,NULL,1),(18,'David QA','davidqa123@yopmail.com',216,NULL,'916578764536','2025-08-07','08:48:00','visiting',88,7,'2025-07-08 11:18:45','2025-07-18 06:53:57',0,NULL,0),(19,'Owolabi Oluwadare','greatlightstore@gmail.com',219,NULL,'08104602318','2025-07-11','09:00:00','Inspection',39,48,'2025-07-10 20:09:54','2025-07-14 10:19:08',1,NULL,1),(20,'Bobga Nwana Ngati','ngatibobga@icrsp.net',NULL,NULL,'677966717','2025-07-15','12:00:00','Visit the property to inspect',39,48,'2025-07-14 10:13:50','2025-07-14 10:15:52',1,NULL,1),(21,'david','robertt@mailinator.com',216,NULL,'7678756895','2025-07-19','13:25:00','Purpose of Visit',88,7,'2025-07-18 06:54:46','2025-07-18 08:59:14',1,NULL,1),(22,'david','robertt@mailinator.com',216,NULL,'4568764532','2025-07-20','17:33:00','Purpose of Visit',88,7,'2025-07-18 09:01:42','2025-07-18 09:09:53',1,NULL,1);

--
-- Table structure for table `seo_settings`
--

CREATE TABLE `seo_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `page` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `seo_settings`
--

INSERT INTO `seo_settings` VALUES (1,'homepage','1738646207.8699.png','LexHouse','Lex House is a Property Marketplace','LexHouse, Broker, Realestate, house, home, apartment, buy, sell, rental','2025-02-04 05:16:47','2025-05-13 11:11:50');

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'category_background','#087C7C14','2025-01-31 09:52:06','2025-01-31 09:52:06'),(2,'sell_web_color','#14B8DCFF','2025-01-31 09:52:06','2025-01-31 09:52:06'),(3,'sell_web_background_color','#14B8DC1F','2025-01-31 09:52:06','2025-01-31 09:52:06'),(4,'rent_web_color','#E48D18FF','2025-01-31 09:52:06','2025-01-31 09:52:06'),(5,'rent_web_background_color','#E48D181F','2025-01-31 09:52:06','2025-01-31 09:52:06'),(6,'number_with_otp_login','0','2025-01-31 09:52:07','2025-03-26 10:31:42'),(7,'social_login','1','2025-01-31 09:52:07','2025-01-31 09:52:07'),(8,'distance_option','km','2025-01-31 09:52:07','2025-01-31 09:52:07'),(9,'otp_service_provider','firebase','2025-01-31 09:52:07','2025-01-31 09:52:07'),(10,'text_property_submission','Your property has been added and is pending review. The admin will enable it once the review is complete.','2025-01-31 09:52:09','2025-01-31 09:52:09'),(11,'email_configuration_verification','1','2025-01-31 09:52:10','2025-07-10 12:58:00'),(12,'verify_mail_template','<p>Hello,</p> <p>Thank you for signing up with <strong>{app_name}</strong>. To complete your registration and verify your email address, please use the following One-Time Password (OTP): <strong>{otp}</strong>. This OTP is valid for the next 10 minutes.</p> <p>If you did not initiate this request, please ignore this email.</p> <p>Best regards,</p> <p>The <strong>{app_name} </strong>Team</p>','2025-01-31 09:52:10','2025-01-31 09:52:10'),(13,'property_status_mail_template','<p>Hello <strong>{user_name}</strong>,</p> <p>We wanted to inform you that the status of your property, <strong>{property_name}</strong>, has been <strong>{status}</strong>.</p> <p><strong>{reject_reason}</strong></p> <p>If you have any questions or need further assistance, please feel free to reach out to our support team.</p> <p>Best regards,</p> <p>The <strong>{app_name}</strong>&nbsp;Team</p> <div>&nbsp;</div>','2025-01-31 09:52:10','2025-01-31 09:52:10'),(14,'project_status_mail_template','<p>Hello <strong>{user_name}</strong>,</p> <p>We wanted to inform you that the status of your project, <strong>{project_name}</strong>, in <strong>{app_name}</strong> has been <strong>{status}</strong>.</p> <p>If you have any questions or need further assistance, please feel free to reach out to our support team.</p> <p>Best regards,</p> <p>The <strong>{app_name}</strong>&nbsp;Team</p>','2025-01-31 09:52:10','2025-01-31 09:52:10'),(15,'property_ads_mail_template','<p>Dear<strong> <strong>{user_name}</strong>,</strong></p> <p>We are excited to inform you about the latest update regarding your property on <strong>{app_name}</strong>.</p> <p>Property Name: <strong>{property_name}</strong>,&nbsp;Advertisement Status: <strong>{advertisement_status}</strong></p> <p>If you have any questions or need further assistance, please feel free to reach out to our support team.</p> <p>Thank you for using <strong>{app_name}</strong>!<br /><br /></p> <p>Best regards,</p> <p><strong>{app_name}</strong>,</p> <p><strong>Support Team</strong></p>','2025-01-31 09:52:10','2025-01-31 09:52:10'),(16,'user_status_mail_template','<p>Hello <strong>{user_name}</strong>,</p> <p>We wanted to inform you that your account status on <strong>{app_name}</strong> has been updated to <strong>{status}</strong>.</p> <p>If you have any questions or need further assistance, please feel free to reach out to our support team.</p> <p>Best regards,</p> <p>The <strong>{app_name}</strong>&nbsp;Team</p>','2025-01-31 09:52:10','2025-01-31 09:52:10'),(17,'password_reset_mail_template','<p>Hello,</p> <p>We received a request to reset your password for your <strong>{app_name}</strong>&nbsp;account. To reset your password, please click on the following link:</p> <p><a title=\'{link}\' href=\'{link}\'><strong>{link}</strong></a></p> <p>If you did not request a password reset, please ignore this email or contact support for assistance.</p> <p>Best regards,</p> <p>The <strong>{app_name}</strong>&nbsp;Team</p>','2025-01-31 09:52:10','2025-01-31 09:52:10'),(18,'welcome_mail_template','<p>Hello <strong>{user_name}</strong>,</p> <p>Welcome to <strong>{app_name}</strong>! We\'re thrilled to have you on board. Thank you for registering with us.</p> <p>Get ready to explore and enjoy all the features we have to offer. If you have any questions or need assistance, feel free to reach out to our support team.</p> <p>Best regards,</p> <p>The <strong>{app_name}</strong>&nbsp;Team</p>','2025-01-31 09:52:10','2025-01-31 09:52:10'),(19,'agent_verification_status_mail_template','<p><strong>Dear <strong>{user_name}</strong>,</strong></p> <p>We hope this email finds you well.</p> <p>We are writing to inform you about the current status of your agent verification process with <strong>{app_name}</strong>.</p> <p><strong>Status:</strong> <strong>{status}</strong></p> <p>If you have any questions or need further assistance, please don\'t hesitate to reach out to our support team.</p> <p>Thank you for your patience and cooperation.</p> <p>Best regards,</p> <p><strong>{app_name}</strong>,<br /><strong>Support Team</strong></p>','2025-01-31 09:52:10','2025-01-31 09:52:10'),(20,'company_name','LexHouse',NULL,'2025-02-05 10:41:10'),(21,'currency_symbol','FCFA',NULL,'2025-02-04 11:56:22'),(22,'ios_version','1.9',NULL,'2025-07-02 12:30:06'),(23,'default_language','en-new',NULL,'2025-04-07 06:09:06'),(24,'force_update','1',NULL,'2025-05-30 12:54:35'),(25,'android_version','1.2.9',NULL,'2025-07-02 12:21:17'),(26,'number_with_suffix','0',NULL,NULL),(27,'maintenance_mode','0',NULL,NULL),(28,'privacy_policy','<h1>Lex Group Company Policy</h1>\r\n<p><strong>Effective Date: 02/04/2025</strong></p>\r\n<p>At Lex Group, we are committed to maintaining a professional, ethical, and safe environment for our users, partners, and employees. Our company policy outlines the standards and guidelines that govern the use of our platforms, services, and interactions within our digital marketplaces, including <strong>Lex House</strong> and <strong>LexJobs</strong>. By using our platforms, you agree to comply with these terms and policies.</p>\r\n<h3>1. User Conduct and Responsibilities</h3>\r\n<ul>\r\n<li><strong>Respectful Communication:</strong> Engage with others in a professional, polite, and respectful manner.</li>\r\n<li><strong>Legal Compliance:</strong> Users must comply with all applicable laws, including property and employment laws.</li>\r\n<li><strong>Accuracy of Information:</strong> Ensure all information provided is accurate and truthful.</li>\r\n<li><strong>No Harassment or Discrimination:</strong> Any form of abuse is strictly prohibited.</li>\r\n</ul>\r\n<h3>2. Intellectual Property</h3>\r\n<ul>\r\n<li><strong>User Content:</strong> Users retain ownership of their content but grant Lex Group a license to use it.</li>\r\n<li><strong>Platform Content:</strong> Lex Group owns all rights to its platform, including design and trademarks.</li>\r\n</ul>\r\n<h3>3. Privacy and Data Protection</h3>\r\n<ul>\r\n<li><strong>Data Collection:</strong> We collect personal information as outlined in our Privacy Policy.</li>\r\n<li><strong>Confidentiality:</strong> We protect sensitive data with industry-standard protocols.</li>\r\n<li><strong>Third-Party Sharing:</strong> We do not share data except where necessary.</li>\r\n</ul>\r\n<h3>4. Payments and Transactions</h3>\r\n<ul>\r\n<li><strong>Lex House Transactions:</strong> Users must ensure compliance with property laws.</li>\r\n<li><strong>LexJobs Payments:</strong> Secure payment methods are encouraged.</li>\r\n<li><strong>Transaction Disputes:</strong> Disputes should be resolved between the involved parties.</li>\r\n</ul>\r\n<h3>5. Prohibited Activities</h3>\r\n<ul>\r\n<li>Fraudulent or Deceptive Practices</li>\r\n<li>Illegal Activities</li>\r\n<li>Harmful Content</li>\r\n<li>Inappropriate Advertising</li>\r\n</ul>\r\n<h3>6. User Account Security</h3>\r\n<ul>\r\n<li><strong>Account Access:</strong> Users must protect their login credentials.</li>\r\n<li><strong>Prohibited Account Sharing:</strong> Account sharing is not allowed.</li>\r\n</ul>\r\n<h3>7. Platform Availability and Maintenance</h3>\r\n<ul>\r\n<li><strong>Service Interruptions:</strong> We strive for high uptime but may experience occasional downtime.</li>\r\n<li><strong>Updates and Changes:</strong> We may modify platform features and policies.</li>\r\n</ul>\r\n<h3>8. Termination of Accounts</h3>\r\n<ul>\r\n<li>Repeated violation of company policies.</li>\r\n<li>Engagement in illegal or fraudulent activities.</li>\r\n<li>Failure to resolve disputes or comply with payment obligations.</li>\r\n</ul>\r\n<h3>9. Dispute Resolution</h3>\r\n<p>Lex Group encourages users to resolve conflicts directly. If unresolved, users may seek mediation, but Lex Group is not responsible for the outcome.</p>\r\n<h3>10. Amendments to This Policy</h3>\r\n<p>Lex Group reserves the right to update this policy at any time. Changes will be posted on our platform.</p>\r\n<h2>Contact Us</h2>\r\n<p>For questions, contact us at:</p>\r\n<p><strong>Lex Group</strong></p>\r\n<p>Douala, Cameroon</p>\r\n<p>By using Lex Group&rsquo;s platforms, you agree to comply with these terms and conditions. Thank you for choosing Lex Group.</p>',NULL,'2025-04-02 11:32:08'),(29,'terms_conditions','<p class=\"p1\"><strong>1. Introduction</strong></p>\r\n<p class=\"p2\">Welcome to LexHouse! By accessing our website or using our services, you agree to comply with and be bound by the following terms and conditions of use. Please review these terms carefully.</p>\r\n<p class=\"p3\">&nbsp;</p>\r\n<p class=\"p1\"><strong>2. Definitions</strong></p>\r\n<p class=\"p4\">&bull;<span class=\"s1\"><strong>&ldquo;Service&rdquo;</strong></span> refers to the services provided by LexHouse, including but not limited to property listing, property management, and real estate consultancy.</p>\r\n<p class=\"p4\">&bull;<span class=\"s1\"><strong>&ldquo;User&rdquo;</strong></span> refers to any individual or entity who uses our Service.</p>\r\n<p class=\"p4\">&bull;<span class=\"s1\"><strong>&ldquo;Content&rdquo;</strong></span> refers to any text, images, video, or other information made available through LexHouse.</p>\r\n<p class=\"p3\">&nbsp;</p>\r\n<p class=\"p1\"><strong>3. Use License</strong></p>\r\n<p class=\"p4\">&bull;<span class=\"s1\"><strong>Grant of License:</strong></span> LexHouse grants you a limited license to access and make personal use of the Service. This license does not include any resale or commercial use of the Service or its contents.</p>\r\n<p class=\"p4\">&bull;<span class=\"s1\"><strong>Restrictions:</strong></span> You are prohibited from modifying, copying, distributing, transmitting, displaying, performing, reproducing, publishing, licensing, creating derivative works from, transferring, or selling any information, software, products, or services obtained from LexHouse.</p>\r\n<p class=\"p3\">&nbsp;</p>\r\n<p class=\"p1\"><strong>4. User Account</strong></p>\r\n<p class=\"p4\">&bull;<span class=\"s1\"><strong>Account Creation:</strong></span> To access certain features of the Service, you must create an account. You agree to provide accurate, current, and complete information during the registration process.</p>\r\n<p class=\"p4\">&bull;<span class=\"s1\"><strong>Account Responsibilities:</strong></span> You are responsible for safeguarding the password that you use to access the Service and for any activities or actions under your account.</p>\r\n<p class=\"p3\">&nbsp;</p>\r\n<p class=\"p1\"><strong>5. Property Listings</strong></p>\r\n<p class=\"p4\">&bull;<span class=\"s1\"><strong>Accuracy of Information:</strong></span> LexHouse strives to ensure that all property listings are described accurately; however, LexHouse is not responsible for the accuracy of information provided by users or third parties.</p>\r\n<p class=\"p4\">&bull;<span class=\"s1\"><strong>Responsibility for Listings:</strong></span> Users are solely responsible for the content of their listings and the legality of any properties listed.</p>\r\n<p class=\"p3\">&nbsp;</p>\r\n<p class=\"p1\"><strong>6. Intellectual Property</strong></p>\r\n<p class=\"p4\">&bull;<span class=\"s1\"><strong>Ownership:</strong></span> The Content provided on LexHouse, including all software, text, visual, and audio content and trademarks, is owned by LexHouse or its licensors and is protected by copyright and other intellectual property laws.</p>\r\n<p class=\"p4\">&bull;<span class=\"s1\"><strong>User Content:</strong></span> By posting content to LexHouse, you grant LexHouse a non-exclusive, royalty-free, perpetual, and worldwide license to use, reproduce, display, and distribute your content in connection with LexHouse&rsquo;s Service.</p>\r\n<p class=\"p3\">&nbsp;</p>\r\n<p class=\"p1\"><strong>7. Prohibited Activities</strong></p>\r\n<p class=\"p2\">You agree not to engage in any of the following activities:</p>\r\n<p class=\"p4\">&bull;<span class=\"s1\"><strong>Illegal Activities:</strong></span> Any illegal activities, including but not limited to fraud, money laundering, or the financing of terrorism.</p>\r\n<p class=\"p4\">&bull;<span class=\"s1\"><strong>Infringing Rights:</strong></span> Infringing on the rights of others, including privacy and intellectual property rights.</p>\r\n<p class=\"p3\">&nbsp;</p>\r\n<p class=\"p1\"><strong>8. Termination</strong></p>\r\n<p class=\"p2\">LexHouse may terminate or suspend your account and bar access to the Service immediately, without prior notice or liability, under our sole discretion, for any reason whatsoever, including without limitation if you breach the Terms.</p>\r\n<p class=\"p3\">&nbsp;</p>\r\n<p class=\"p1\"><strong>9. Disclaimer of Warranties</strong></p>\r\n<p class=\"p2\">LexHouse makes no warranty that the Service will meet your requirements or be available on an uninterrupted, secure, or error-free basis. No advice or information, whether oral or written, obtained from LexHouse or through the Service, will create any warranty not expressly made herein.</p>\r\n<p class=\"p3\">&nbsp;</p>\r\n<p class=\"p1\"><strong>10. Limitation of Liability</strong></p>\r\n<p class=\"p2\">LexHouse shall not be liable for any indirect, incidental, special, consequential, or punitive damages, including without limitation, loss of profits, data, use, goodwill, or other intangible losses, resulting from your access to or use of or inability to access or use the Service.</p>\r\n<p class=\"p3\">&nbsp;</p>\r\n<p class=\"p1\"><strong>11. Governing Law</strong></p>\r\n<p class=\"p2\">These Terms shall be governed and construed in accordance with the laws of Cameroon, without regard to its conflict of law provisions.</p>\r\n<p class=\"p3\">&nbsp;</p>\r\n<p class=\"p1\"><strong>12. Changes to Terms</strong></p>\r\n<p class=\"p2\">LexHouse reserves the right, at our sole discretion, to modify or replace these Terms at any time. If a revision is material, we will provide at least 30 days&rsquo; notice prior to any new terms taking effect.</p>\r\n<p class=\"p3\">&nbsp;</p>\r\n<p class=\"p1\"><strong>13. Contact Us</strong></p>\r\n<p class=\"p2\">If you have any questions about these Terms, please contact us at info@lexhouse.com.</p>',NULL,'2025-04-13 21:41:39'),(30,'company_tel1','+237674208577',NULL,'2025-02-05 09:55:33'),(31,'company_tel2',NULL,NULL,'2025-01-31 12:33:53'),(32,'razorpay_gateway','0',NULL,NULL),(33,'paystack_gateway','0',NULL,NULL),(34,'paypal_gateway','0',NULL,NULL),(35,'system_version','1.2.2',NULL,NULL),(36,'company_logo','1739188832.4363.png',NULL,'2025-02-10 12:00:32'),(37,'web_logo','1739188212.8253.png',NULL,'2025-02-10 11:50:12'),(38,'favicon_icon','1739189681.9396.ico',NULL,'2025-02-10 12:14:41'),(39,'web_footer_logo','1739188212.8259.png',NULL,'2025-02-10 11:50:12'),(40,'web_placeholder_logo','1738330210.3597.png',NULL,'2025-01-31 12:30:10'),(41,'app_home_screen','1738330225.0271.png',NULL,'2025-01-31 12:30:25'),(42,'placeholder_logo','1738330225.0277.png',NULL,'2025-01-31 12:30:25'),(43,'iframe_link','https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d254715.1500944226!2d9.576991603177493!3d4.035887107793933!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x1061128be2e1fe6d%3A0x92daa1444781c48b!2sDouala%2C%20Cameroon!5e0!3m2!1sen!2sin!4v1742983530210!5m2!1sen!2sin','2025-01-31 12:30:10','2025-03-26 10:06:33'),(44,'facebook_id','https://www.facebook.com/lexgroup01/?_rdc=1&_rdr#','2025-01-31 12:30:10','2025-04-18 14:23:37'),(45,'instagram_id','https://www.instagram.com/lexhouse01/','2025-01-31 12:30:10','2025-04-24 07:47:30'),(46,'twitter_id','https://www.twitter.com','2025-01-31 12:30:10','2025-03-27 10:31:52'),(47,'youtube_id','https://www.youtube.com','2025-01-31 12:30:10','2025-03-27 10:31:52'),(48,'web_maintenance_mode','0','2025-01-31 12:30:10','2025-01-31 12:30:10'),(49,'allow_cookies','1','2025-01-31 12:30:10','2025-02-04 05:33:52'),(50,'btnAdd1','btnAdd','2025-01-31 12:30:10','2025-01-31 12:30:10'),(51,'light_tertiary','#1e4a9f','2025-01-31 12:30:25','2025-01-31 12:32:15'),(52,'light_secondary','#ffffff','2025-01-31 12:30:25','2025-01-31 12:30:25'),(53,'light_primary','#fafafa','2025-01-31 12:30:25','2025-01-31 12:30:25'),(54,'dark_tertiary','#1e4a9f','2025-01-31 12:30:25','2025-01-31 12:32:15'),(55,'dark_secondary','#1c1c1c','2025-01-31 12:30:25','2025-01-31 12:30:25'),(56,'dark_primary','#0c0c0c','2025-01-31 12:30:25','2025-01-31 12:30:25'),(57,'show_admob_ads','0','2025-01-31 12:30:25','2025-01-31 12:30:25'),(58,'android_banner_ad_id',NULL,'2025-01-31 12:30:25','2025-01-31 12:30:25'),(59,'ios_banner_ad_id',NULL,'2025-01-31 12:30:25','2025-01-31 12:30:25'),(60,'android_interstitial_ad_id',NULL,'2025-01-31 12:30:25','2025-01-31 12:30:25'),(61,'ios_interstitial_ad_id',NULL,'2025-01-31 12:30:25','2025-01-31 12:30:25'),(62,'android_native_ad_id',NULL,'2025-01-31 12:30:25','2025-01-31 12:30:25'),(63,'ios_native_ad_id',NULL,'2025-01-31 12:30:25','2025-01-31 12:30:25'),(64,'company_email','info@lexgroup.live','2025-01-31 12:33:53','2025-04-04 06:49:22'),(65,'latitude','4.0511','2025-01-31 12:33:53','2025-02-05 09:55:33'),(66,'longitude','9.7679','2025-01-31 12:33:53','2025-02-05 09:55:33'),(67,'company_address','Douala, Cameroon.','2025-01-31 12:33:53','2025-02-05 09:55:33'),(68,'currency_code','XAF','2025-01-31 12:33:53','2025-01-31 12:33:53'),(69,'unsplash_api_key',NULL,'2025-01-31 12:33:53','2025-01-31 12:33:53'),(70,'place_api_key','AIzaSyCW4myTxNF-Uy2KAEa2IABZFLwq0eWT76Y','2025-01-31 12:33:53','2025-03-26 09:55:19'),(71,'playstore_id','https://play.google.com/store/apps/details?id=com.app.lexhouse&hl=en','2025-01-31 12:33:53','2025-01-31 12:33:53'),(72,'appstore_id','https://apps.apple.com/app/id6744919996','2025-01-31 12:33:53','2025-01-31 12:33:53'),(73,'svg_clr','0','2025-01-31 12:33:53','2025-01-31 12:35:01'),(74,'system_color','#1e4a9f','2025-01-31 12:33:53','2025-01-31 12:33:53'),(75,'rgb_color','rgb(30, 74, 159,0.15)','2025-01-31 12:33:53','2025-01-31 12:33:53'),(76,'web_url','https://lexhouse.undhi.com','2025-01-31 12:33:53','2025-01-31 12:33:53'),(77,'twilio_account_sid',NULL,'2025-01-31 12:33:53','2025-01-31 12:33:53'),(78,'twilio_auth_token',NULL,'2025-01-31 12:33:53','2025-01-31 12:33:53'),(79,'twilio_my_phone_number',NULL,'2025-01-31 12:33:53','2025-01-31 12:33:53'),(80,'paypal_business_id',NULL,'2025-01-31 12:33:53','2025-01-31 12:33:53'),(81,'paypal_webhook_url','https://lexhouse-admin.undhi.com/webhook/paypal','2025-01-31 12:33:53','2025-01-31 12:33:53'),(82,'paypal_currency','USD','2025-01-31 12:33:53','2025-01-31 12:33:53'),(83,'sandbox_mode','0','2025-01-31 12:33:53','2025-01-31 12:33:53'),(84,'razor_key',NULL,'2025-01-31 12:33:53','2025-01-31 12:33:53'),(85,'razorpay_webhook_url','https://lexhouse-admin.undhi.com/webhook/razorpay','2025-01-31 12:33:53','2025-01-31 12:33:53'),(86,'razor_secret',NULL,'2025-01-31 12:33:53','2025-01-31 12:33:53'),(87,'razor_webhook_secret',NULL,'2025-01-31 12:33:53','2025-01-31 12:33:53'),(88,'paystack_secret_key',NULL,'2025-01-31 12:33:53','2025-01-31 12:33:53'),(89,'paystack_webhook_url','https://lexhouse-admin.undhi.com/webhook/paystack','2025-01-31 12:33:53','2025-01-31 12:33:53'),(90,'paystack_currency','GHS','2025-01-31 12:33:53','2025-01-31 12:33:53'),(91,'paystack_public_key',NULL,'2025-01-31 12:33:53','2025-01-31 12:33:53'),(92,'stripe_publishable_key',NULL,'2025-01-31 12:33:53','2025-01-31 12:33:53'),(93,'stripe_webhook_url','https://lexhouse-admin.undhi.com/webhook/stripe','2025-01-31 12:33:53','2025-01-31 12:33:53'),(94,'stripe_currency','USD','2025-01-31 12:33:53','2025-01-31 12:33:53'),(95,'stripe_gateway','0','2025-01-31 12:33:53','2025-01-31 12:33:53'),(96,'stripe_secret_key',NULL,'2025-01-31 12:33:53','2025-01-31 12:33:53'),(97,'stripe_webhook_secret_key',NULL,'2025-01-31 12:33:54','2025-01-31 12:33:54'),(98,'flutterwave_public_key',NULL,'2025-01-31 12:33:54','2025-01-31 12:33:54'),(99,'flutterwave_secret_key',NULL,'2025-01-31 12:33:54','2025-01-31 12:33:54'),(100,'flutterwave_encryption_key',NULL,'2025-01-31 12:33:54','2025-01-31 12:33:54'),(101,'flutterwave_webhook_url','https://lexhouse-admin.undhi.com/webhook/flutterwave','2025-01-31 12:33:54','2025-01-31 12:33:54'),(102,'flutterwave_currency','GBP','2025-01-31 12:33:54','2025-01-31 12:33:54'),(103,'flutterwave_status','0','2025-01-31 12:33:54','2025-01-31 12:33:54'),(104,'login_image','1738670182.8643.svg','2025-01-31 12:33:54','2025-02-04 11:56:22'),(105,'about_us','<h1 class=\"p1\">Welcome to Lex Group</h1>\r\n<p class=\"p3\">At <strong>Lex Group</strong>, we believe that visibility leads to economic empowerment. Our mission is to create digital marketplaces that connect people with the opportunities they need to thrive. Whether you\'re a freelancer looking to showcase your skills, a property owner ready to sell or rent, or a seeker looking for the perfect home or service, <strong>Lex Group</strong> offers the platform to bring you the visibility you deserve.</p>\r\n<h1><br />Our Products</h1>\r\n<p>&nbsp;</p>\r\n<h2><strong>Lex House - Your Marketplace for Property</strong></h2>\r\n<p>Lex House is an online marketplace that connects property owners, renters, and buyers and sellers of houses and land. Whether you\'re looking for your dream home or a rental property or you want to sell or rent out your property, Lex House provides the platform to make the process easy, transparent, and seamless.</p>\r\n<ul>\r\n<li><strong>For Property Owners:</strong> List your properties, gain exposure, and connect with potential buyers or renters.</li>\r\n<li><strong>For Renters/Buyers:</strong> Browse a wide selection of properties that match your needs and budget.</li>\r\n</ul>\r\n<p class=\"p3\">Explore Lex House Today! <a href=\"https://lexhouse.undhi.com/\">https://lexhouse.undhi.com/</a></p>\r\n<p class=\"p3\">&nbsp; &nbsp;<strong>&nbsp;</strong></p>\r\n<p class=\"p1\">&nbsp;</p>\r\n<h2><strong>LexJobs - Empowering Freelancers, One Project at a Time</strong></h2>\r\n<p>LexJobs is an online marketplace that empowers freelancers by providing them with a platform to showcase their skills, connect with clients, and find rewarding opportunities. Whether you\'re a designer, developer, writer, marketer, or any other skilled professional, LexJobs gives you the visibility you need to thrive.</p>\r\n<ul>\r\n<li><strong>For Freelancers:</strong> Create a professional profile, display your portfolio, and gain access to a wide range of job opportunities.</li>\r\n<li><strong>For Employers:</strong> Find top-notch freelancers who match your project needs and budget.</li>\r\n</ul>\r\n<p class=\"p3\">Start Showcasing Your Skills on LexJobs!&nbsp;</p>\r\n<p class=\"p3\">&nbsp; &nbsp;<strong>&nbsp;</strong></p>\r\n<p class=\"p1\">&nbsp;</p>\r\n<h2><strong>Why Lex Group?</strong></h2>\r\n<p>At <strong>Lex Group</strong>, we understand the importance of visibility in the digital age. Our platforms offer:</p>\r\n<ul>\r\n<li><strong>Transparency:</strong> Clear, straightforward, and honest transactions between users.</li>\r\n<li><strong>User-Friendly Platforms:</strong> Easy-to-use interfaces that make buying, renting, or hiring simple and efficient.</li>\r\n<li><strong>Economic Empowerment:</strong> Visibility leads to new opportunities. We are here to help you grow, connect, and succeed.</li>\r\n</ul>\r\n<p class=\"p3\">&nbsp; &nbsp;<strong>&nbsp;</strong></p>\r\n<p class=\"p1\">&nbsp;</p>\r\n<h1 class=\"p1\">Our Vision</h1>\r\n<p class=\"p3\">We aim to empower people by giving them the visibility they deserve.</p>\r\n<p class=\"p3\">&nbsp; &nbsp;<strong>&nbsp;</strong></p>\r\n<p class=\"p1\">&nbsp;</p>\r\n<h1 class=\"p1\">Get in Touch</h1>\r\n<p class=\"p3\">Have a question? Want to learn more about our products? Contact us today! <br /><strong>Email: </strong> <a href=\"mailto:info@lexgroup.live\" target=\"_blank\" rel=\"noopener\">info@lexgroup.live</a></p>','2025-02-04 06:14:02','2025-04-05 17:12:55'),(106,'mail_mailer','smtp',NULL,NULL),(107,'mail_host','smtpout.secureserver.net',NULL,NULL),(108,'mail_port','587',NULL,NULL),(109,'mail_username','noreply@lexgroup.live',NULL,NULL),(110,'mail_password','booking123',NULL,NULL),(111,'mail_encryption','SSL',NULL,NULL),(112,'mail_send_from','noreply@lexgroup.live',NULL,NULL),(113,'apiKey','AIzaSyD-AAololsgu8VevYY8JyI-LGKTe14gdj8','2025-02-04 10:09:08','2025-05-20 07:03:27'),(114,'authDomain','lexhouse-64336.firebaseapp.com','2025-02-04 10:09:08','2025-05-20 07:03:27'),(115,'projectId','lexhouse-64336','2025-02-04 10:09:08','2025-05-20 07:03:27'),(116,'storageBucket','lexhouse-64336.firebasestorage.app','2025-02-04 10:09:08','2025-05-20 07:03:27'),(117,'messagingSenderId','98742734201','2025-02-04 10:09:08','2025-05-20 07:03:27'),(118,'appId','1:98742734201:web:65d2b478502dabfa1a33a8','2025-02-04 10:09:08','2025-05-20 07:03:27'),(119,'measurementId','G-GZVVCX6J5Z','2025-02-04 10:09:08','2025-05-20 07:03:27'),(120,'firebase_service_json_file','1747392058.9566.json',NULL,'2025-05-16 10:40:58'),(121,'project_id','lexhouse-64336','2025-05-16 10:40:58','2025-05-16 10:40:58'),(123,'verification_required_for_user','0','2025-05-19 10:11:14','2025-05-19 10:13:33'),(124,'place_api_key_ios','AIzaSyCSoq-Ww8IVblfsG5R2E4RAnJFfBz__1UA','2025-01-31 12:33:53','2025-03-26 09:55:19'),(125,'currencies','FCFA, UGX, KSh, TZS, USD','2025-01-31 12:33:53','2025-03-26 09:55:19'),(126,'scheduled_property_submit_mail_template','<p><strong>Dear <strong>{user_name}</strong>,</strong></p> <p>We hope this email finds you well.</p> <p>This is to confirm that your property <strong>{property_name}</strong> has been scheduled for submission on <strong>{scheduled_date}</strong>.</p> <br /><strong>Thank You</strong></p>','2025-07-02 05:50:00','2025-07-02 05:50:00'),(127,'scheduled_property_approval_mail_template','<p><strong>Dear <strong>{user_name}</strong>,</strong></p>\n            <p>We hope this email finds you well.</p>\n            <p>We are pleased to inform you that your scheduled visiting property <strong>{property_name}</strong> has been approved.</p>\n            <br />\n            <p><strong>Thank You</strong></p>','2025-07-02 05:50:08','2025-07-02 05:50:08'),(128,'scheduled_property_rejection_mail_template','<p><strong>Dear <strong>{user_name}</strong>,</strong></p>\n            <p>We hope this email finds you well.</p>\n            <p>We regret to inform you that your scheduled visiting property <strong>{property_name}</strong> has not been approved at this time.</p>\n            <br />\n            <p><strong>Thank You</strong></p>','2025-07-02 05:50:08','2025-07-02 05:50:08'),(129,'image_rules','<h3><strong>Image Upload Rules &ndash; LexGroup Platform</strong></h3> <p><span style=\"font-weight: 400;\">Please follow these image upload rules carefully to uphold the highest standards across listings. High-quality visuals attract more attention and build trust with potential renters and buyers.</span></p> <h4><strong>1. Image Quality</strong></h4> <ul> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">All photos must be </span><strong>clear, bright, and professionally composed</strong><span style=\"font-weight: 400;\">.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Images should be taken in </span><strong>landscape (horizontal) mode</strong><span style=\"font-weight: 400;\">.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Minimum resolution:</strong><span style=\"font-weight: 400;\"> 332 x 200 pixels.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Avoid blurry, dark, or distorted images.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> </ul> <h4><strong>2. Professional Photography</strong></h4> <ul> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">We strongly encourage using </span><strong>a professional photographer</strong><span style=\"font-weight: 400;\">.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Listings with professional-quality photos rank higher and generate more inquiries.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Mobile phone images are accepted </span><strong>only if they meet quality standards</strong><span style=\"font-weight: 400;\">.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> </ul> <h4><strong>3. Cleanliness and Environment</strong></h4> <ul> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ensure all spaces are </span><strong>clean, organized, and clutter-free</strong><span style=\"font-weight: 400;\"> before taking photos.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Remove personal items (clothes, dishes, etc.) to present a </span><strong>neutral and welcoming space</strong><span style=\"font-weight: 400;\">.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Outdoor areas should be </span><strong>swept, trimmed, and free of trash or debris</strong><span style=\"font-weight: 400;\">.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">A clean environment in photos increases credibility and encourages bookings.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> </ul> <p><br /><br /><br /><br /></p> <h4><strong>4. Image Categories</strong></h4> <p><span style=\"font-weight: 400;\">Please upload photos in the following order:</span></p> <ul> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Exterior</strong><span style=\"font-weight: 400;\"> (front of property, entrance)</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Living Room</strong><strong><br /><br /></strong></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Kitchen</strong><strong><br /><br /></strong></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Bedrooms</strong><strong><br /><br /></strong></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Bathrooms</strong><strong><br /><br /></strong></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Balcony / View / Garden</strong><strong><br /><br /></strong></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Amenities</strong><span style=\"font-weight: 400;\"> (e.g., pool, gym, parking)</span><span style=\"font-weight: 400;\"><br /><br /></span></li> </ul> <h4><strong>5. Number of Photos</strong></h4> <ul> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Minimum: </span><strong>8 images</strong><strong><br /><br /></strong></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Recommended: </span><strong>16+ images</strong><span style=\"font-weight: 400;\"> for better listing visibility</span><span style=\"font-weight: 400;\"><br /><br /></span></li> </ul> <h4><strong>6. Authenticity</strong></h4> <ul> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Photos must show the </span><strong>actual property</strong><span style=\"font-weight: 400;\"> &mdash; no fake, staged, or misleading images.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use of stock or AI-generated imagery is strictly </span><strong>prohibited</strong><span style=\"font-weight: 400;\">.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> </ul> <h4><strong>7. File Format and Size</strong></h4> <ul> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Formats: </span><strong>JPEG (.jpg)</strong><span style=\"font-weight: 400;\"> or </span><strong>PNG (.png)</strong><strong><br /><br /></strong></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Max size: </span><strong>5MB per image</strong><strong><br /><br /></strong></li> </ul> <h4><strong>8. No Branding or Personal Info</strong></h4> <ul> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Do not upload photos with </span><strong>watermarks, logos, phone numbers, or text overlays</strong><span style=\"font-weight: 400;\">.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> </ul> <p><span style=\"font-weight: 400;\">&nbsp;</span><em><span style=\"font-weight: 400;\">Listings that do not comply with these guidelines may be suspended or removed.</span></em><em><span style=\"font-weight: 400;\"><br /></span></em><span style=\"font-weight: 400;\"> Need help? LexGroup can assist with arranging a professional photo session.</span></p>',NULL,NULL),(130,'image_rules_french','<h3><strong>R&egrave;gles de T&eacute;l&eacute;chargement d&rsquo;Images &ndash; Plateforme LexGroup</strong></h3> <p><span style=\"font-weight: 400;\">Pour garantir des annonces de haute qualit&eacute; et inspirer confiance aux clients, merci de respecter les r&egrave;gles suivantes lors du t&eacute;l&eacute;chargement de vos photos de propri&eacute;t&eacute;.</span></p> <h4><strong>1. Qualit&eacute; des Images</strong></h4> <ul> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Les photos doivent &ecirc;tre </span><strong>nettes, lumineuses et bien cadr&eacute;es</strong><span style=\"font-weight: 400;\">.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Les images doivent &ecirc;tre prises en </span><strong>mode paysage (horizontal)</strong><span style=\"font-weight: 400;\">.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>R&eacute;solution minimale :</strong><span style=\"font-weight: 400;\"> 332 x 200 pixels.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">&Eacute;vitez les photos floues, sombres ou d&eacute;form&eacute;es.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> </ul> <h4><strong>2. Photographie Professionnelle</strong></h4> <ul> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Nous recommandons fortement l&rsquo;utilisation d&rsquo;un </span><strong>photographe professionnel</strong><span style=\"font-weight: 400;\">.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Les annonces avec des photos professionnelles sont </span><strong>mieux class&eacute;es et attirent plus de clients</strong><span style=\"font-weight: 400;\">.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Les photos prises avec un t&eacute;l&eacute;phone sont accept&eacute;es </span><strong>uniquement si elles sont de tr&egrave;s bonne qualit&eacute;</strong><span style=\"font-weight: 400;\">.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> </ul> <h4><strong>3. Propret&eacute; et Environnement</strong></h4> <ul> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Les espaces doivent &ecirc;tre </span><strong>propres, bien rang&eacute;s et sans d&eacute;sordre</strong><span style=\"font-weight: 400;\"> avant de prendre les photos.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Enlevez les objets personnels (v&ecirc;tements, vaisselle, etc.) pour pr&eacute;senter un </span><strong>espace neutre et accueillant</strong><span style=\"font-weight: 400;\">.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Les ext&eacute;rieurs doivent &ecirc;tre </span><strong>propres, balay&eacute;s et sans d&eacute;chets</strong><span style=\"font-weight: 400;\">.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Une propri&eacute;t&eacute; propre sur les photos renforce la confiance et augmente les r&eacute;servations.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> </ul> <h3><br /><br /></h3> <h4><strong>4. Cat&eacute;gories d&rsquo;Images</strong></h4> <p><span style=\"font-weight: 400;\">Veuillez t&eacute;l&eacute;charger les photos dans l&rsquo;ordre suivant :</span></p> <ul> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Ext&eacute;rieur</strong><span style=\"font-weight: 400;\"> (fa&ccedil;ade, entr&eacute;e)</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Salon</strong><strong><br /><br /></strong></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Cuisine</strong><strong><br /><br /></strong></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Chambres</strong><strong><br /><br /></strong></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Salles de bains</strong><strong><br /><br /></strong></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Balcon / Vue / Jardin</strong><strong><br /><br /></strong></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Commodit&eacute;s</strong><span style=\"font-weight: 400;\"> (piscine, salle de sport, parking, etc.)</span><span style=\"font-weight: 400;\"><br /><br /></span></li> </ul> <h4><strong>5. Nombre de Photos</strong></h4> <ul> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Minimum: 8 images</strong><strong><br /><br /></strong></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Recommand&eacute; : 16 images ou plus</strong><span style=\"font-weight: 400;\"> pour une meilleure visibilit&eacute;</span><span style=\"font-weight: 400;\"><br /><br /></span></li> </ul> <h4><strong>6. Authenticit&eacute;</strong></h4> <ul> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Les photos doivent repr&eacute;senter </span><strong>r&eacute;ellement le bien mis en location/vente</strong><span style=\"font-weight: 400;\">.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">L&rsquo;usage d&rsquo;images g&eacute;n&eacute;riques, retouch&eacute;es ou g&eacute;n&eacute;r&eacute;es par IA est </span><strong>interdit</strong><span style=\"font-weight: 400;\">.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> </ul> <h4><strong>7. Format et Taille des Fichiers</strong></h4> <ul> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Formats accept&eacute;s : </span><strong>JPEG (.jpg)</strong><span style=\"font-weight: 400;\"> ou </span><strong>PNG (.png)</strong><strong><br /><br /></strong></li> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Taille maximale : </span><strong>5 Mo par image</strong><strong><br /><br /></strong></li> </ul> <h4><strong>8. Pas de Marquage ou Informations Personnelles</strong></h4> <ul> <li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">N&rsquo;int&eacute;grez pas de </span><strong>logos, filigranes, num&eacute;ros de t&eacute;l&eacute;phone ou textes</strong><span style=\"font-weight: 400;\"> dans vos photos.</span><span style=\"font-weight: 400;\"><br /><br /></span></li> </ul> <h3><em><span style=\"font-weight: 400;\">Les annonces qui ne respectent pas ces r&egrave;gles peuvent &ecirc;tre suspendues ou supprim&eacute;es.</span></em><em><span style=\"font-weight: 400;\"><br /></span></em><span style=\"font-weight: 400;\"> Besoin d&rsquo;aide ? LexGroup peut vous mettre en contact avec un photographe professionnel.</span></h3>',NULL,NULL),(131,'safety_rules','<h3>Safety Rules</h3> <ul> <li>Avoid sending any prepayments.</li> <li>Don’t visit any property alone; go with someone.</li> <li>Inspect the property thoroughly and make sure it meets your expectations.</li> <li>Check all the documents carefully and only pay if you\'re fully satisfied.</li> <li>Lex Group does not charge a fee for property inspections.</li> </ul>',NULL,NULL),(132,'safety_rules_french','<h3>Règles de sécurité</h3> <ul> <li>Évitez d’envoyer des paiements à l’avance.</li> <li>Ne visitez jamais une propriété seul(e) ; allez-y accompagné(e).</li> <li>Inspectez soigneusement la propriété et assurez-vous qu’elle vous convient.</li> <li>Vérifiez tous les documents attentivement et ne payez que si vous êtes entièrement satisfait(e).</li> <li>Lex Group ne facture aucun frais pour les visites de propriété.</li> </ul>',NULL,NULL),(133,'whatsapp_number','+237673496193','2025-07-07 11:07:11',NULL);

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('1','2','3','4') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '1 - only image, 2 - category, 3 - property, 4 - link',
  `image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'app_image',
  `web_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sequence` tinyint NOT NULL DEFAULT '0',
  `category_id` bigint DEFAULT '0',
  `propertys_id` bigint DEFAULT '0',
  `show_property_details` tinyint(1) NOT NULL DEFAULT '0',
  `default_data` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` VALUES (1,'1','1748930788.1833.png','1748930788.2137.png',NULL,0,0,0,0,1,'2025-01-31 09:52:06','2025-06-03 06:06:28'),(3,'2','1748930889.8445.png','1748930889.8603.png',NULL,0,1,NULL,0,0,'2025-03-17 13:07:08','2025-06-03 06:08:09'),(6,'1','1748930751.8575.png','1748930751.8581.png',NULL,0,NULL,NULL,0,0,'2025-06-03 06:05:51','2025-06-03 06:05:51');

--
-- Table structure for table `telescope_entries`
--

CREATE TABLE `telescope_entries` (
  `sequence` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `family_hash` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `should_display_on_index` tinyint(1) NOT NULL DEFAULT '1',
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`sequence`),
  UNIQUE KEY `telescope_entries_uuid_unique` (`uuid`),
  KEY `telescope_entries_batch_id_index` (`batch_id`),
  KEY `telescope_entries_family_hash_index` (`family_hash`),
  KEY `telescope_entries_created_at_index` (`created_at`),
  KEY `telescope_entries_type_should_display_on_index_index` (`type`,`should_display_on_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `telescope_entries`
--


--
-- Table structure for table `telescope_entries_tags`
--

CREATE TABLE `telescope_entries_tags` (
  `entry_uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tag` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`entry_uuid`,`tag`),
  KEY `telescope_entries_tags_tag_index` (`tag`),
  CONSTRAINT `telescope_entries_tags_entry_uuid_foreign` FOREIGN KEY (`entry_uuid`) REFERENCES `telescope_entries` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `telescope_entries_tags`
--


--
-- Table structure for table `telescope_monitoring`
--

CREATE TABLE `telescope_monitoring` (
  `tag` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`tag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `telescope_monitoring`
--


--
-- Table structure for table `user_interests`
--

CREATE TABLE `user_interests` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `category_ids` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `outdoor_facilitiy_ids` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price_range` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `property_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_interests`
--

INSERT INTO `user_interests` VALUES (1,12,'9','2','0,551348000','','0,1','2025-03-18 10:51:13','2025-03-18 10:51:13'),(2,7,'17','2','530158730.10571456,2499999999.0','','0,1','2025-03-24 11:14:13','2025-07-04 10:22:54'),(3,131,'1','3','2386.0,2499999999.0','','0,1','2025-05-02 13:08:41','2025-05-02 13:08:41'),(4,147,'2,14,17,16,15,1','1,3','2386.0,2499999999.0','','0,1','2025-05-06 11:04:32','2025-05-06 11:04:32'),(5,148,'2,14,17,16,15,1',NULL,'2386.0,2499999999.0','','0,1','2025-05-06 11:10:21','2025-05-06 11:10:21'),(6,152,'1',NULL,'234.0,2499999999.0','','0,1','2025-05-08 07:41:13','2025-06-19 11:22:20'),(7,157,'18',NULL,'234.0,2499999999.0','','1','2025-05-10 12:41:22','2025-05-10 12:41:22'),(9,136,'1',NULL,'0.0,2499999999.0','surat,gujarat,india','0,1','2025-06-19 11:01:41','2025-06-19 12:36:36'),(10,208,'1',NULL,'0.0,2499999999.0','','0,1','2025-06-19 11:23:58','2025-06-19 11:23:58'),(11,221,'17',NULL,'0.0,50000.0','','1','2025-07-11 12:18:43','2025-07-11 12:18:43');

--
-- Table structure for table `user_purchased_packages`
--

CREATE TABLE `user_purchased_packages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `modal_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `modal_id` bigint unsigned NOT NULL,
  `package_id` int NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `used_limit_for_property` int NOT NULL DEFAULT '0',
  `used_limit_for_advertisement` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `prop_status` tinyint(1) NOT NULL DEFAULT '1',
  `adv_status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `user_purchased_packages_modal_type_modal_id_index` (`modal_type`,`modal_id`)
) ENGINE=InnoDB AUTO_INCREMENT=203 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_purchased_packages`
--

INSERT INTO `user_purchased_packages` VALUES (19,'App\\Models\\Customer',11,1,'2025-04-01','2162-02-22',0,0,'2025-04-01 06:08:40','2025-04-01 06:08:40',1,1),(21,'App\\Models\\Customer',14,1,'2025-04-01','2162-02-22',0,0,'2025-04-01 06:29:04','2025-04-01 06:29:04',1,1),(22,'App\\Models\\Customer',7,1,'2025-04-01','2162-02-22',16,6,'2025-04-01 06:31:39','2025-07-16 12:14:48',1,1),(23,'App\\Models\\Customer',12,1,'2025-04-01','2162-02-22',0,0,'2025-04-01 06:31:39','2025-04-01 06:31:39',1,1),(24,'App\\Models\\Customer',37,1,'2025-04-07','2162-02-28',0,0,'2025-04-07 10:00:30','2025-04-07 10:00:30',1,1),(25,'App\\Models\\Customer',38,1,'2025-04-07','2162-02-28',0,0,'2025-04-07 10:04:19','2025-04-07 10:04:19',1,1),(27,'App\\Models\\Customer',40,1,'2025-04-08','2162-03-01',0,0,'2025-04-08 07:28:26','2025-04-08 07:28:26',1,1),(29,'App\\Models\\Customer',42,1,'2025-04-08','2162-03-01',0,0,'2025-04-08 14:38:13','2025-04-08 14:38:13',1,1),(30,'App\\Models\\Customer',43,1,'2025-04-08','2162-03-01',0,0,'2025-04-08 14:39:33','2025-04-08 14:39:33',1,1),(31,'App\\Models\\Customer',44,1,'2025-04-09','2162-03-02',0,0,'2025-04-09 11:08:56','2025-04-09 11:08:56',1,1),(32,'App\\Models\\Customer',45,1,'2025-04-09','2162-03-02',0,0,'2025-04-09 11:48:49','2025-04-09 11:48:49',1,1),(33,'App\\Models\\Customer',46,1,'2025-04-09','2162-03-02',0,0,'2025-04-09 11:51:42','2025-04-09 11:51:42',1,1),(35,'App\\Models\\Customer',48,1,'2025-04-09','2162-03-02',6,0,'2025-04-09 19:13:23','2025-07-10 09:30:14',1,1),(36,'App\\Models\\Customer',49,1,'2025-04-09','2162-03-02',1,0,'2025-04-09 20:47:17','2025-06-18 07:56:29',1,1),(37,'App\\Models\\Customer',50,1,'2025-04-21','2162-03-14',0,0,'2025-04-21 09:11:15','2025-04-21 09:11:15',1,1),(38,'App\\Models\\Customer',51,1,'2025-04-23','2162-03-16',0,0,'2025-04-23 12:25:44','2025-04-23 12:25:44',1,1),(39,'App\\Models\\Customer',52,1,'2025-04-23','2162-03-16',0,0,'2025-04-23 12:26:53','2025-04-23 12:26:53',1,1),(41,'App\\Models\\Customer',54,1,'2025-04-23','2162-03-16',1,0,'2025-04-23 15:13:41','2025-05-10 20:01:37',1,1),(42,'App\\Models\\Customer',55,1,'2025-04-23','2162-03-16',0,0,'2025-04-23 16:37:21','2025-04-23 16:37:21',1,1),(43,'App\\Models\\Customer',56,1,'2025-04-24','2162-03-17',0,0,'2025-04-24 06:33:04','2025-04-24 06:33:04',1,1),(44,'App\\Models\\Customer',57,1,'2025-04-24','2162-03-17',0,0,'2025-04-24 06:36:00','2025-04-24 06:36:00',1,1),(45,'App\\Models\\Customer',58,1,'2025-04-24','2162-03-17',0,0,'2025-04-24 10:22:23','2025-04-24 10:22:23',1,1),(46,'App\\Models\\Customer',59,1,'2025-04-24','2162-03-17',0,0,'2025-04-24 10:56:05','2025-04-24 10:56:05',1,1),(47,'App\\Models\\Customer',60,1,'2025-04-25','2162-03-18',0,0,'2025-04-25 05:30:04','2025-04-25 05:30:04',1,1),(58,'App\\Models\\Customer',71,1,'2025-04-25','2162-03-18',0,0,'2025-04-25 07:28:51','2025-04-25 07:28:51',1,1),(59,'App\\Models\\Customer',72,1,'2025-04-25','2162-03-18',0,0,'2025-04-25 09:08:44','2025-04-25 09:08:44',1,1),(60,'App\\Models\\Customer',73,1,'2025-04-25','2162-03-18',0,0,'2025-04-25 09:16:10','2025-04-25 09:16:10',1,1),(62,'App\\Models\\Customer',75,1,'2025-04-25','2162-03-18',0,0,'2025-04-25 09:54:07','2025-04-25 09:54:07',1,1),(63,'App\\Models\\Customer',76,1,'2025-04-25','2162-03-18',0,0,'2025-04-25 09:57:45','2025-04-25 09:57:45',1,1),(64,'App\\Models\\Customer',77,1,'2025-04-25','2162-03-18',0,0,'2025-04-25 19:53:53','2025-04-25 19:53:53',1,1),(65,'App\\Models\\Customer',78,1,'2025-04-26','2162-03-19',0,0,'2025-04-26 09:05:55','2025-04-26 09:05:55',1,1),(66,'App\\Models\\Customer',79,1,'2025-04-26','2162-03-19',0,0,'2025-04-26 13:14:56','2025-04-26 13:14:56',1,1),(67,'App\\Models\\Customer',80,1,'2025-04-26','2162-03-19',0,0,'2025-04-26 13:36:37','2025-04-26 13:36:37',1,1),(68,'App\\Models\\Customer',81,1,'2025-04-27','2162-03-20',0,0,'2025-04-27 02:41:57','2025-04-27 02:41:57',1,1),(69,'App\\Models\\Customer',82,1,'2025-04-27','2162-03-20',0,0,'2025-04-27 09:53:34','2025-04-27 09:53:34',1,1),(70,'App\\Models\\Customer',83,1,'2025-04-27','2162-03-20',0,0,'2025-04-27 16:12:14','2025-04-27 16:12:14',1,1),(71,'App\\Models\\Customer',84,1,'2025-04-27','2162-03-20',0,0,'2025-04-27 18:37:23','2025-04-27 18:37:23',1,1),(73,'App\\Models\\Customer',86,1,'2025-04-28','2162-03-21',0,0,'2025-04-28 07:06:11','2025-04-28 07:06:11',1,1),(75,'App\\Models\\Customer',88,1,'2025-04-28','2162-03-21',1,0,'2025-04-28 09:35:42','2025-05-06 10:51:49',1,1),(76,'App\\Models\\Customer',89,1,'2025-04-28','2162-03-21',0,0,'2025-04-28 13:22:25','2025-04-28 13:22:25',1,1),(77,'App\\Models\\Customer',90,1,'2025-04-28','2162-03-21',0,0,'2025-04-28 13:41:53','2025-04-28 13:41:53',1,1),(78,'App\\Models\\Customer',91,1,'2025-04-28','2162-03-21',0,0,'2025-04-28 15:38:25','2025-04-28 15:38:25',1,1),(79,'App\\Models\\Customer',92,1,'2025-04-28','2162-03-21',0,0,'2025-04-28 19:00:20','2025-04-28 19:00:20',1,1),(80,'App\\Models\\Customer',93,1,'2025-04-29','2162-03-22',0,0,'2025-04-29 03:50:24','2025-04-29 03:50:24',1,1),(81,'App\\Models\\Customer',94,1,'2025-04-29','2162-03-22',0,0,'2025-04-29 07:41:06','2025-04-29 07:41:06',1,1),(82,'App\\Models\\Customer',95,1,'2025-04-29','2162-03-22',0,0,'2025-04-29 09:38:14','2025-04-29 09:38:14',1,1),(83,'App\\Models\\Customer',96,1,'2025-04-29','2162-03-22',0,0,'2025-04-29 16:19:34','2025-04-29 16:19:34',1,1),(84,'App\\Models\\Customer',97,1,'2025-04-29','2162-03-22',0,0,'2025-04-29 17:02:50','2025-04-29 17:02:50',1,1),(85,'App\\Models\\Customer',98,1,'2025-04-30','2162-03-23',0,0,'2025-04-30 03:43:39','2025-04-30 03:43:39',1,1),(86,'App\\Models\\Customer',99,1,'2025-04-30','2162-03-23',3,0,'2025-04-30 08:20:53','2025-04-30 09:13:45',1,1),(87,'App\\Models\\Customer',100,1,'2025-04-30','2162-03-23',0,0,'2025-04-30 15:09:04','2025-04-30 15:09:04',1,1),(88,'App\\Models\\Customer',101,1,'2025-05-01','2162-03-24',1,0,'2025-05-01 06:17:06','2025-05-01 06:24:12',1,1),(99,'App\\Models\\Customer',112,1,'2025-05-02','2162-03-25',0,0,'2025-05-02 05:52:06','2025-05-02 05:52:06',1,1),(104,'App\\Models\\Customer',117,1,'2025-05-02','2162-03-25',0,0,'2025-05-02 09:17:24','2025-05-02 09:17:24',1,1),(105,'App\\Models\\Customer',119,1,'2025-05-02','2162-03-25',0,0,'2025-05-02 09:26:17','2025-05-02 09:26:17',1,1),(107,'App\\Models\\Customer',129,1,'2025-05-02','2162-03-25',0,0,'2025-05-02 11:57:14','2025-05-02 11:57:14',1,1),(108,'App\\Models\\Customer',130,1,'2025-05-02','2162-03-25',0,0,'2025-05-02 12:42:10','2025-05-02 12:42:10',1,1),(110,'App\\Models\\Customer',132,1,'2025-05-02','2162-03-25',0,0,'2025-05-02 17:43:07','2025-05-02 17:43:07',1,1),(111,'App\\Models\\Customer',133,1,'2025-05-02','2162-03-25',0,0,'2025-05-02 19:31:19','2025-05-02 19:31:19',1,1),(112,'App\\Models\\Customer',134,1,'2025-05-02','2162-03-25',0,0,'2025-05-02 21:13:19','2025-05-02 21:13:19',1,1),(113,'App\\Models\\Customer',135,1,'2025-05-02','2162-03-25',0,0,'2025-05-02 22:34:15','2025-05-02 22:34:15',1,1),(114,'App\\Models\\Customer',136,1,'2025-05-03','2162-03-26',1,0,'2025-05-03 04:13:43','2025-06-13 06:11:36',1,1),(115,'App\\Models\\Customer',137,1,'2025-05-03','2162-03-26',0,0,'2025-05-03 12:41:52','2025-05-03 12:41:52',1,1),(116,'App\\Models\\Customer',138,1,'2025-05-04','2162-03-27',0,0,'2025-05-04 10:38:12','2025-05-04 10:38:12',1,1),(117,'App\\Models\\Customer',139,1,'2025-05-04','2162-03-27',0,0,'2025-05-04 10:39:58','2025-05-04 10:39:58',1,1),(118,'App\\Models\\Customer',140,1,'2025-05-05','2162-03-28',0,0,'2025-05-05 12:35:06','2025-05-05 12:35:06',1,1),(119,'App\\Models\\Customer',141,1,'2025-05-05','2162-03-28',0,0,'2025-05-05 13:47:30','2025-05-05 13:47:30',1,1),(120,'App\\Models\\Customer',142,1,'2025-05-06','2162-03-29',0,0,'2025-05-06 03:01:31','2025-05-06 03:01:31',1,1),(121,'App\\Models\\Customer',143,1,'2025-05-06','2162-03-29',0,0,'2025-05-06 05:39:46','2025-05-06 05:39:46',1,1),(122,'App\\Models\\Customer',144,1,'2025-05-06','2162-03-29',0,0,'2025-05-06 07:24:30','2025-05-06 07:24:30',1,1),(123,'App\\Models\\Customer',145,1,'2025-05-06','2162-03-29',3,0,'2025-05-06 08:54:25','2025-05-24 10:20:43',1,1),(124,'App\\Models\\Customer',146,1,'2025-05-06','2162-03-29',0,0,'2025-05-06 09:59:30','2025-05-06 09:59:30',1,1),(125,'App\\Models\\Customer',147,1,'2025-05-06','2162-03-29',0,0,'2025-05-06 11:03:51','2025-05-06 11:03:51',1,1),(126,'App\\Models\\Customer',148,1,'2025-05-06','2162-03-29',0,0,'2025-05-06 11:10:09','2025-05-06 11:10:09',1,1),(127,'App\\Models\\Customer',149,1,'2025-05-07','2162-03-30',0,0,'2025-05-07 07:06:11','2025-05-07 07:06:11',1,1),(128,'App\\Models\\Customer',150,1,'2025-05-07','2162-03-30',0,0,'2025-05-07 07:26:47','2025-05-07 07:26:47',1,1),(129,'App\\Models\\Customer',151,1,'2025-05-07','2162-03-30',0,0,'2025-05-07 14:23:58','2025-05-07 14:23:58',1,1),(130,'App\\Models\\Customer',152,1,'2025-05-08','2162-03-31',0,0,'2025-05-08 07:40:46','2025-05-08 07:40:46',1,1),(131,'App\\Models\\Customer',153,1,'2025-05-08','2162-03-31',0,0,'2025-05-08 15:00:50','2025-05-08 15:00:50',1,1),(132,'App\\Models\\Customer',154,1,'2025-05-08','2162-03-31',0,0,'2025-05-08 15:22:02','2025-05-08 15:22:02',1,1),(133,'App\\Models\\Customer',155,1,'2025-05-09','2162-04-01',0,0,'2025-05-09 18:51:06','2025-05-09 18:51:06',1,1),(134,'App\\Models\\Customer',156,1,'2025-05-10','2162-04-02',0,0,'2025-05-10 02:19:03','2025-05-10 02:19:03',1,1),(135,'App\\Models\\Customer',157,1,'2025-05-10','2162-04-02',3,0,'2025-05-10 12:40:43','2025-05-22 19:18:07',1,1),(136,'App\\Models\\Customer',158,1,'2025-05-10','2162-04-02',0,0,'2025-05-10 22:14:42','2025-05-10 22:14:42',1,1),(137,'App\\Models\\Customer',159,1,'2025-05-12','2162-04-04',0,0,'2025-05-12 10:20:48','2025-05-12 10:20:48',1,1),(138,'App\\Models\\Customer',160,1,'2025-05-12','2162-04-04',0,0,'2025-05-12 15:31:20','2025-05-12 15:31:20',1,1),(139,'App\\Models\\Customer',161,1,'2025-05-14','2162-04-06',0,0,'2025-05-14 12:52:16','2025-05-14 12:52:16',1,1),(140,'App\\Models\\Customer',162,1,'2025-05-14','2162-04-06',0,0,'2025-05-14 18:37:11','2025-05-14 18:37:11',1,1),(141,'App\\Models\\Customer',163,1,'2025-05-15','2162-04-07',0,0,'2025-05-15 06:28:56','2025-05-15 06:28:56',1,1),(142,'App\\Models\\Customer',164,1,'2025-05-15','2162-04-07',0,0,'2025-05-15 16:58:24','2025-05-15 16:58:24',1,1),(143,'App\\Models\\Customer',165,1,'2025-05-16','2162-04-08',0,0,'2025-05-16 12:47:50','2025-05-16 12:47:50',1,1),(144,'App\\Models\\Customer',166,1,'2025-05-16','2162-04-08',4,0,'2025-05-16 16:07:56','2025-05-16 16:40:10',1,1),(145,'App\\Models\\Customer',167,1,'2025-05-16','2162-04-08',0,0,'2025-05-16 16:59:51','2025-05-16 16:59:51',1,1),(146,'App\\Models\\Customer',168,1,'2025-05-19','2162-04-11',0,0,'2025-05-19 10:03:03','2025-05-19 10:03:03',1,1),(147,'App\\Models\\Customer',169,1,'2025-05-19','2162-04-11',0,0,'2025-05-19 10:30:09','2025-05-19 10:30:09',1,1),(148,'App\\Models\\Customer',170,1,'2025-05-19','2162-04-11',0,0,'2025-05-19 10:39:50','2025-05-19 10:39:50',1,1),(149,'App\\Models\\Customer',171,1,'2025-05-20','2162-04-12',0,0,'2025-05-20 11:58:24','2025-05-20 11:58:24',1,1),(150,'App\\Models\\Customer',172,1,'2025-05-21','2162-04-13',0,0,'2025-05-21 10:41:05','2025-05-21 10:41:05',1,1),(151,'App\\Models\\Customer',173,1,'2025-05-22','2162-04-14',0,0,'2025-05-22 10:22:04','2025-05-22 10:22:04',1,1),(152,'App\\Models\\Customer',174,1,'2025-05-23','2162-04-15',0,0,'2025-05-23 12:14:01','2025-05-23 12:14:01',1,1),(153,'App\\Models\\Customer',175,1,'2025-05-23','2162-04-15',0,0,'2025-05-23 12:26:06','2025-05-23 12:26:06',1,1),(154,'App\\Models\\Customer',176,1,'2025-05-27','2162-04-19',1,0,'2025-05-27 10:56:54','2025-06-09 12:11:57',1,1),(155,'App\\Models\\Customer',177,1,'2025-05-28','2162-04-20',0,0,'2025-05-28 14:15:22','2025-05-28 14:15:22',1,1),(156,'App\\Models\\Customer',178,1,'2025-05-28','2162-04-20',2,0,'2025-05-28 16:24:24','2025-05-29 11:26:11',1,1),(157,'App\\Models\\Customer',179,1,'2025-05-29','2162-04-21',0,0,'2025-05-29 09:10:21','2025-05-29 09:10:21',1,1),(158,'App\\Models\\Customer',180,1,'2025-05-29','2162-04-21',0,0,'2025-05-29 16:51:16','2025-05-29 16:51:16',1,1),(159,'App\\Models\\Customer',181,1,'2025-05-30','2162-04-22',0,0,'2025-05-30 18:21:00','2025-05-30 18:21:00',1,1),(160,'App\\Models\\Customer',182,1,'2025-05-30','2162-04-22',0,0,'2025-05-30 18:37:40','2025-05-30 18:37:40',1,1),(161,'App\\Models\\Customer',183,1,'2025-05-30','2162-04-22',0,0,'2025-05-30 20:41:22','2025-05-30 20:41:22',1,1),(162,'App\\Models\\Customer',184,1,'2025-05-30','2162-04-22',0,0,'2025-05-30 22:57:09','2025-05-30 22:57:09',1,1),(163,'App\\Models\\Customer',185,1,'2025-05-31','2162-04-23',0,0,'2025-05-31 08:38:04','2025-05-31 08:38:04',1,1),(164,'App\\Models\\Customer',186,1,'2025-06-03','2162-04-26',0,0,'2025-06-03 08:22:50','2025-06-03 08:22:50',1,1),(165,'App\\Models\\Customer',187,1,'2025-06-04','2162-04-27',0,0,'2025-06-04 08:45:30','2025-06-04 08:45:30',1,1),(166,'App\\Models\\Customer',188,1,'2025-06-04','2162-04-27',4,0,'2025-06-04 11:58:05','2025-06-10 13:12:08',1,1),(167,'App\\Models\\Customer',189,1,'2025-06-05','2162-04-28',0,0,'2025-06-05 12:17:19','2025-06-05 12:17:19',1,1),(168,'App\\Models\\Customer',190,1,'2025-06-06','2162-04-29',0,0,'2025-06-06 09:06:45','2025-06-06 09:06:45',1,1),(169,'App\\Models\\Customer',191,1,'2025-06-07','2162-04-30',1,0,'2025-06-07 14:42:22','2025-06-08 19:30:12',1,1),(170,'App\\Models\\Customer',192,1,'2025-06-07','2162-04-30',0,0,'2025-06-07 15:24:36','2025-06-07 15:24:36',1,1),(171,'App\\Models\\Customer',193,1,'2025-06-07','2162-04-30',0,0,'2025-06-07 15:52:09','2025-06-07 15:52:09',1,1),(172,'App\\Models\\Customer',194,1,'2025-06-09','2162-05-02',0,0,'2025-06-09 15:31:45','2025-06-09 15:31:45',1,1),(173,'App\\Models\\Customer',195,1,'2025-06-10','2162-05-03',0,0,'2025-06-10 06:01:20','2025-06-10 06:01:20',1,1),(174,'App\\Models\\Customer',196,1,'2025-06-12','2162-05-05',0,0,'2025-06-12 15:11:19','2025-06-12 15:11:19',1,1),(175,'App\\Models\\Customer',197,1,'2025-06-14','2162-05-07',0,0,'2025-06-14 11:56:29','2025-06-14 11:56:29',1,1),(176,'App\\Models\\Customer',198,1,'2025-06-14','2162-05-07',0,0,'2025-06-14 11:58:33','2025-06-14 11:58:33',1,1),(177,'App\\Models\\Customer',199,1,'2025-06-16','2162-05-09',0,0,'2025-06-16 09:08:15','2025-06-16 09:08:15',1,1),(178,'App\\Models\\Customer',200,1,'2025-06-16','2162-05-09',0,0,'2025-06-16 10:21:58','2025-06-16 10:21:58',1,1),(179,'App\\Models\\Customer',201,1,'2025-06-16','2162-05-09',0,0,'2025-06-16 14:15:35','2025-06-16 14:15:35',1,1),(180,'App\\Models\\Customer',202,1,'2025-06-17','2162-05-10',0,0,'2025-06-17 08:38:39','2025-06-17 08:38:39',1,1),(181,'App\\Models\\Customer',203,1,'2025-06-17','2162-05-10',0,0,'2025-06-17 12:49:44','2025-06-17 12:49:44',1,1),(182,'App\\Models\\Customer',204,1,'2025-06-18','2162-05-11',0,0,'2025-06-18 11:54:29','2025-06-18 11:54:29',1,1),(183,'App\\Models\\Customer',205,1,'2025-06-18','2162-05-11',3,0,'2025-06-18 12:07:40','2025-06-19 06:25:16',1,1),(184,'App\\Models\\Customer',206,1,'2025-06-18','2162-05-11',1,0,'2025-06-18 14:49:06','2025-06-18 15:23:40',1,1),(185,'App\\Models\\Customer',207,1,'2025-06-19','2162-05-12',0,0,'2025-06-19 11:00:46','2025-06-19 11:00:46',1,1),(186,'App\\Models\\Customer',208,1,'2025-06-19','2162-05-12',0,0,'2025-06-19 11:22:47','2025-06-19 11:22:47',1,1),(187,'App\\Models\\Customer',209,1,'2025-06-19','2162-05-12',0,0,'2025-06-19 11:24:52','2025-06-19 11:24:52',1,1),(188,'App\\Models\\Customer',210,1,'2025-06-23','2162-05-16',0,0,'2025-06-23 14:50:32','2025-06-23 14:50:32',1,1),(189,'App\\Models\\Customer',211,1,'2025-06-26','2162-05-19',0,0,'2025-06-26 04:57:26','2025-06-26 04:57:26',1,1),(190,'App\\Models\\Customer',212,1,'2025-06-27','2162-05-20',0,0,'2025-06-27 14:26:44','2025-06-27 14:26:44',1,1),(191,'App\\Models\\Customer',213,1,'2025-06-28','2162-05-21',0,0,'2025-06-28 09:27:57','2025-06-28 09:27:57',1,1),(192,'App\\Models\\Customer',214,1,'2025-06-30','2162-05-23',3,0,'2025-06-30 12:22:31','2025-07-14 11:47:14',1,1),(193,'App\\Models\\Customer',215,1,'2025-07-02','2162-05-25',0,0,'2025-07-02 12:35:48','2025-07-02 12:35:48',1,1),(194,'App\\Models\\Customer',216,1,'2025-07-03','2162-05-26',0,0,'2025-07-03 13:08:31','2025-07-03 13:08:31',1,1),(195,'App\\Models\\Customer',217,1,'2025-07-08','2162-05-31',0,0,'2025-07-08 14:29:21','2025-07-08 14:29:21',1,1),(196,'App\\Models\\Customer',218,1,'2025-07-08','2162-05-31',0,0,'2025-07-08 17:03:44','2025-07-08 17:03:44',1,1),(197,'App\\Models\\Customer',219,1,'2025-07-10','2162-06-02',0,0,'2025-07-10 06:32:01','2025-07-10 06:32:01',1,1),(198,'App\\Models\\Customer',220,1,'2025-07-11','2162-06-03',0,0,'2025-07-11 12:09:20','2025-07-11 12:09:20',1,1),(199,'App\\Models\\Customer',221,1,'2025-07-11','2162-06-03',1,0,'2025-07-11 12:16:25','2025-07-14 08:24:45',1,1),(200,'App\\Models\\Customer',222,1,'2025-07-14','2162-06-06',0,0,'2025-07-14 08:59:43','2025-07-14 08:59:43',1,1),(201,'App\\Models\\Customer',223,1,'2025-07-14','2162-06-06',0,0,'2025-07-14 22:31:13','2025-07-14 22:31:13',1,1),(202,'App\\Models\\Customer',224,1,'2025-07-17','2162-06-09',0,0,'2025-07-17 08:09:32','2025-07-17 08:09:32',1,1);

--
-- Table structure for table `user_reports`
--

CREATE TABLE `user_reports` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `reason_id` int NOT NULL,
  `customer_id` bigint NOT NULL,
  `property_id` bigint NOT NULL,
  `other_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_reports`
--

INSERT INTO `user_reports` VALUES (1,0,7,17,'bad property','2025-03-21 10:57:09','2025-03-21 10:57:09'),(2,0,12,24,'Test','2025-03-26 05:53:25','2025-03-26 05:53:25');

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `profile` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `slug_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Slug of name',
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` tinyint NOT NULL COMMENT '0:Admin 1:Users',
  `permissions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL COMMENT '0:Inactive 1:Active',
  `fcm_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'SA',NULL,'admin','projects@moweb.com',NULL,'$2y$10$Btakp8nwYW6HSB5sANEtyevSmYwbbIhudi0swCdSLoCjZoWD42ht2',0,'',1,'cGz_g81_S66z2XkG-tnOoZ:APA91bHl3eVce3L6H-a-8Rd0fAJ6eEreb5oVFfMIXn_A6uxk1lptR_vgHfMPI0XxipbBL1Bes_4nP4Kbc5zO8aktnuE1Z2LXTiAMPd5eau6S6KwL5yL7ix0',NULL,NULL,'2025-06-10 17:40:56'),(2,'lexhouse-admin',NULL,'lexhouse-admin','info@lexgroup.live',NULL,'$2y$10$H6wMMCQXd3ay2yOqifK3u.Dn7M8mpHpYTNaXVX/Pyu8HH9z5NAvgK',1,'{\"dashboard\":{\"read\":\"on\"},\"facility\":{\"create\":\"on\",\"read\":\"on\",\"update\":\"on\",\"delete\":\"on\"},\"categories\":{\"create\":\"on\",\"read\":\"on\",\"update\":\"on\",\"delete\":\"on\"},\"near_by_places\":{\"create\":\"on\",\"read\":\"on\",\"update\":\"on\",\"delete\":\"on\"},\"customer\":{\"read\":\"on\",\"update\":\"on\",\"delete\":\"on\"},\"property\":{\"create\":\"on\",\"read\":\"on\",\"update\":\"on\",\"delete\":\"on\"},\"city_images\":{\"read\":\"on\",\"update\":\"on\",\"delete\":\"on\"},\"report_reason\":{\"create\":\"on\",\"read\":\"on\",\"update\":\"on\",\"delete\":\"on\"},\"user_reports\":{\"read\":\"on\"},\"users_inquiries\":{\"read\":\"on\"},\"chat\":{\"create\":\"on\",\"read\":\"on\"},\"slider\":{\"create\":\"on\",\"read\":\"on\",\"update\":\"on\",\"delete\":\"on\"},\"calculator\":{\"read\":\"on\"},\"faqs\":{\"create\":\"on\",\"read\":\"on\",\"update\":\"on\",\"delete\":\"on\"},\"users_accounts\":{\"create\":\"on\",\"read\":\"on\",\"update\":\"on\"},\"about_us\":{\"read\":\"on\",\"update\":\"on\"},\"privacy_policy\":{\"read\":\"on\",\"update\":\"on\"},\"terms_conditions\":{\"read\":\"on\",\"update\":\"on\"},\"language\":{\"create\":\"on\",\"read\":\"on\",\"update\":\"on\",\"delete\":\"on\"},\"app_settings\":{\"read\":\"on\",\"update\":\"on\"},\"web_settings\":{\"read\":\"on\",\"update\":\"on\"},\"firebase_settings\":{\"create\":\"on\",\"read\":\"on\"},\"notification_settings\":{\"create\":\"on\",\"read\":\"on\"},\"email_configurations\":{\"create\":\"on\",\"read\":\"on\"},\"email_templates\":{\"create\":\"on\",\"read\":\"on\"},\"notification\":{\"create\":\"on\",\"read\":\"on\",\"delete\":\"on\"}}',1,'',NULL,'2025-03-17 13:00:55','2025-03-24 12:40:25'),(5,'admin99',NULL,'admin99','rupal.gohel@moweb.com',NULL,'$2y$10$7exlXAsGC/LIz7/mWk0Hc.ZmOjKB6c3S0mI2glu3bgZNPsQrQhuYW',1,'{\"dashboard\":{\"read\":\"on\"},\"facility\":{\"create\":\"on\",\"read\":\"on\",\"update\":\"on\",\"delete\":\"on\"},\"categories\":{\"create\":\"on\",\"read\":\"on\",\"update\":\"on\",\"delete\":\"on\"}}',1,'',NULL,'2025-03-26 14:08:32','2025-03-26 14:12:26'),(6,'Ruth Ndome',NULL,'ruth-ndome','ngallecyrielle@gmail.com',NULL,'$2y$10$ezYtnmNJrdzUV/OxttR2TODhtEXVYbJBVpdcsLKxPaO/Si92bqAJi',1,'{\"dashboard\":{\"read\":\"on\"},\"facility\":{\"create\":\"on\",\"read\":\"on\",\"update\":\"on\"},\"categories\":{\"create\":\"on\",\"read\":\"on\",\"update\":\"on\"},\"near_by_places\":{\"create\":\"on\",\"read\":\"on\",\"update\":\"on\"},\"customer\":{\"read\":\"on\",\"update\":\"on\"},\"property\":{\"create\":\"on\",\"read\":\"on\",\"update\":\"on\"},\"city_images\":{\"read\":\"on\",\"update\":\"on\"},\"report_reason\":{\"create\":\"on\",\"read\":\"on\",\"update\":\"on\"},\"user_reports\":{\"read\":\"on\"},\"users_inquiries\":{\"read\":\"on\"},\"chat\":{\"create\":\"on\",\"read\":\"on\"},\"slider\":{\"create\":\"on\",\"read\":\"on\",\"update\":\"on\"},\"calculator\":{\"read\":\"on\"},\"about_us\":{\"read\":\"on\",\"update\":\"on\"},\"language\":{\"create\":\"on\"},\"email_templates\":{\"create\":\"on\",\"read\":\"on\"},\"notification\":{\"create\":\"on\",\"read\":\"on\"}}',1,'',NULL,'2025-06-03 00:08:04','2025-06-03 06:52:07'),(7,'Valery Tabi',NULL,'valery-tabi','Tabivalery@gmail.com',NULL,'$2y$10$Fn9BcihuYlLdBRDrjNr4uueJKqOR6rjPAHkYBUr7HaC91KLjq2ufi',1,'{\"dashboard\":{\"read\":\"on\"},\"facility\":{\"read\":\"on\"},\"categories\":{\"read\":\"on\"},\"near_by_places\":{\"read\":\"on\"},\"customer\":{\"read\":\"on\"},\"property\":{\"read\":\"on\"},\"city_images\":{\"read\":\"on\"},\"report_reason\":{\"read\":\"on\"},\"user_reports\":{\"read\":\"on\"},\"users_inquiries\":{\"read\":\"on\"},\"chat\":{\"read\":\"on\"},\"slider\":{\"read\":\"on\"},\"calculator\":{\"read\":\"on\"},\"faqs\":{\"read\":\"on\"},\"about_us\":{\"read\":\"on\"},\"privacy_policy\":{\"read\":\"on\"},\"terms_conditions\":{\"read\":\"on\"},\"language\":{\"read\":\"on\"},\"app_settings\":{\"read\":\"on\"},\"web_settings\":{\"read\":\"on\"},\"firebase_settings\":{\"read\":\"on\"},\"notification_settings\":{\"read\":\"on\"},\"email_configurations\":{\"read\":\"on\"},\"email_templates\":{\"read\":\"on\"},\"notification\":{\"read\":\"on\"}}',1,'',NULL,'2025-06-07 15:41:53','2025-06-07 15:43:13');

--
-- Table structure for table `usertokens`
--

CREATE TABLE `usertokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int NOT NULL,
  `fcm_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `api_token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `usertokens_fcm_id_unique` (`fcm_id`)
) ENGINE=InnoDB AUTO_INCREMENT=412 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `usertokens`
--

INSERT INTO `usertokens` VALUES (1,1,'cECVq07ktVTtNy-hvANbbc:APA91bE2VudCmTIyxszp37M2CAul7U2qnOoqTRm57H4ZPXmfxrDfLFmqV1N_7Q4S3BZRa57VHYU_NJM-3XhkXINv0cEyY_FQsJLZPmiiPHTCVyqK-qN7fKE','','2025-03-18 09:14:06','2025-03-18 09:14:06'),(31,40,'dwb9y84nl0YCpsLrrSee_l:APA91bH6oG_4elNUT3BU92pEdt7SBvqormrIU6L9siWwYaES34wlw1caCnKbte650QnXohsPAHWSkC7RRGIPvHJlDsi9vdyF0f53tUGlBYhjV9JGxt7Kkos','','2025-04-08 13:24:42','2025-04-08 13:24:42'),(33,40,'eRe1W0GMrUO7syYgRL1BcR:APA91bEKtG5FYj1aLQmMuw9YEYJ9I2Zu6vBo5uexH4ASc4sRkJ3BE1w0gwS7RFrkgvyoILnPg0fsIwsMee2tD4Qpfxwl_-pjK4iLfkOA3Ey9ZLJo4DrQxNk','','2025-04-08 13:40:27','2025-04-08 13:40:27'),(39,41,'d-zBcUNbSrO9Z4LTqB-C_o:APA91bH676kAipSXCU_pewe9UdXJ2426swmd5UA7nSLOcVcWisaBjYU2zhSfO5UONf_Iidz2MUki4YFXDlHroxiGKF6Er65wEPsVgIoDX4cTBNCl_G5BK9Q','','2025-04-08 14:20:40','2025-04-08 14:20:40'),(46,47,'c-to6YdPSxSZm5fzEj6SY6:APA91bFDh7sSpmQXmYR_R5SexYChtOVJq08kIKW_czwSHY2k5xTM-05dgbVdQFdemQWx9AKWd8qDG5e-WrJkO_4hsElgJZv1o6v1c0RZtNcoQISVgyt57tU','','2025-04-09 14:14:05','2025-04-09 14:14:05'),(50,49,'ezZVa6JPQc-ix-R3rQODT4:APA91bGmz_K4xcG8WRRFzX_uSNKCJZMe4YZDwPO6HJA8v3x4g8JqfExKv6P5iIxGtELDF_gdRo0B7OcBKmqixICEJNrvdxCZqgaYn7pMY_BQv3LOj-mSlr4','','2025-04-09 20:47:30','2025-04-09 20:47:30'),(70,45,'cqpVIbD9QAaI47mZIandG5:APA91bHRURgg3i6c8ZpTywQ-AvpDn_yR6VDCKLwFYM6J8BNW-ju4Czt4EVcQlolhgshl2HG2f3N1giTb7Yy7PdmyZJo_Ov_Ejo5DEzIRB6vGlcslCmsLWNA','','2025-04-23 03:09:03','2025-04-23 03:09:03'),(73,47,'dtuTtXhAc0qYl1oMiMjKML:APA91bFyan0qZ2WprLyAEbMcBr42gZqkEW_7DPQaRQHzvYZLmzTkbEmLOriz6Kcdu1wq2SMc66CgaHUP7HjMI-_Cxixt0uufSoBVsoKaiE2u_9ctcToCWeg','','2025-04-23 09:43:19','2025-04-23 09:43:19'),(88,41,'cgB0NHH1T0WvT8ur5wNX0G:APA91bHOyhoRGZpv6JXMGgx8H5pnmVIsBTKLEF7b9JFyq8u2yVRckgUy7IEaZwNyR58d5ods38fI-s_yRhaYQqkZqe7z49zYosYu3ulwIxG4-lMcv5Kq3iM','','2025-04-23 13:06:07','2025-04-23 13:06:07'),(89,41,'fkx4lDt4RuioGnmzXHPwFK:APA91bGZ5jaTnuL72d7yhy3-H0t6k9-2h7dfaVcP2ap-bmU4aagfSw0rxjHDAFWKiqAvnBkE9E2_akYwjGCTnSbI_oudhNLGdGnjBHWwpmX5p5FAUAuYJEM','','2025-04-23 13:11:08','2025-04-23 13:11:08'),(94,47,'czF1SqO2W09VoU_ybBnVb5:APA91bFhvgMMa8xB-C-_GsJKYArTwQMeovdQWZYC63Zi0EgY9GiPWG4gJjDDYvpqYwOriymVZLUGRFYc0fLrN0XOrRJpjwAzXydj5mfd2vllZRwdtIxIKaU','','2025-04-23 13:48:37','2025-04-23 13:48:37'),(97,55,'fOlj1jS5RE27pqIFsmMaIZ:APA91bECitS0FP5kytLf1uezd1oyv1Y1g4VvNp3tErl-iqAegT09eincehSfpzm6_568-YOn442BVykwewyEUNZN4ntjbv0kTBi_WdcrXhIoUbOS8GHI9mU','','2025-04-23 16:37:27','2025-04-23 16:37:27'),(98,57,'cLWXraw1rk9BjtaE8IgBES:APA91bE9vz5xOB0xTfgmgjN9KXa28GQ751MThe25BtveEZq4zy4xASkUextWWygqdoE5v5scQNxrkhjPyaiyr9CxmOnRQ-ojz6hCNhjVSgdg7HfXoG2lKt0','','2025-04-24 06:36:34','2025-04-24 06:36:34'),(99,49,'eXCQ4PPURcehK_EbQD0GDt:APA91bElq9NInx-oEIfTzHOzHp-y-e9vYnQ7ONCdwZWqopEQBBxz45InZ9Jba1vpTJf04hEB2di2vQ77-U6WFpovwyJIUaK8BmgDX4Pp3R8HvGnJ12tVyOU','','2025-04-24 08:38:15','2025-04-24 08:38:15'),(101,47,'ceZBEK9zlEMJqE92OA4geB:APA91bE0IF9irPbSKz2arsK_O_Rl5HUFQHN2HgY8MUDq09NAONvLLN4E7DWyLlLKdBdIMk3nktfW1xcRTUMY0Tp6-sPOopMMIuPWpOaAn5oqYfWiZi4L6lg','','2025-04-25 05:16:22','2025-04-25 05:16:22'),(103,47,'dMO3P1XM-kD2lQv7kwePQd:APA91bFTRc9eE2Lt-5eQrz9IznkxGVF5enYRAwylw4ODGTfgwUNe3KE2nAtHuqnjMzWfVVJEzZxRxjwGJi4YYhtGKNRSy04d8BoxI5oigRyu3NXmuduS4A8','','2025-04-25 05:22:02','2025-04-25 05:22:02'),(105,61,'dx7VNW1Rl0vArX787VobuD:APA91bE1aQ7RHeLgi_JZD266wxHaiAZRvibxks-vftDn6MBHqkfUQ0pzK40D6hmCfiZSBp6gGHG7ELqlLouUGiadYLUKz6NCEyIFSNrFFRBz2nRTukmuzZg','','2025-04-25 05:41:54','2025-04-25 05:41:54'),(114,73,'fWvD__1xQjeCHtlaWeq5-c:APA91bELKFNgUZ6qGipzuloEWmfIAh8Qvj2rekpBx5G1mJ4zn0vlc9IIcaugYM-vs-zJ4jkWKLGy9UvblLHDMoT8DtZP9dUqNv81esCe2nJy8rN6CVLOjBI','','2025-04-25 09:16:37','2025-04-25 09:16:37'),(115,71,'eplVMrXbQ08bu6cpxyUNFE:APA91bFZewP4LCAkfJ5NVx1O0cH4TbzbeRgwQPxrZnEkXrEQi5m90S_rtXP66ftVmIvVUJYMVLmXXsd0AYau40yVVQ5RSe68TO4mOnyNujkVARcTIeNuG7Q','','2025-04-25 09:31:47','2025-04-25 09:31:47'),(120,78,'cyfW1r5tTcy9A6KhozdA7Z:APA91bERAPn-ZZomNZQPSy0BXdE6K8P2Y6jx68O6lcJPn25KYCcdVHvhuAPxKROWlUvHGN9R-g0SNkut9oKpSgCuupqq1Q-s2d_K63GFS8_LrMQLrWNNGfs','','2025-04-26 09:07:03','2025-04-26 09:07:03'),(121,79,'e4htCg4GS0uRvkkjMFJfDK:APA91bFD_llJH4Gsz3J3UGA8DfCwMpblC948dUv6XRP7WHP8u0O-UJGUIN0fvHz3RYj8GtpwnDAMbaB6U4epm9t8bc-NhRUSt4W4VPK35UyddedyL0FtUxg','','2025-04-26 13:15:06','2025-04-26 13:15:06'),(122,80,'fNu3SmUOQ6Sv5X61MGXoQf:APA91bGhuFv4hfG-BpFpE06qTrXmn68pi-ASMN9n4BL8cjX-XWZZC1uA-X5K66PUAspwzOFpU2QReYXIkyZWSdKOnNNeno8ragg543pROIKNI_DXasyDUss','','2025-04-26 13:36:46','2025-04-26 13:36:46'),(123,82,'fU-xg3V7SSupsRbBAsscU1:APA91bHowpO-xtQTGjiGbvXDw_d2T_-yonUfCMMkIm3F4WY0yYVO_cpceRRAYQPVgNd9OZtrNP2_PDu-BDRBNKJOBWyXUwGs9XqNLEvysG_hsuK2RGyPnpg','','2025-04-27 09:57:13','2025-04-27 09:57:13'),(124,83,'d25xP8pQTpGLaLjemmqI-d:APA91bF9SDBC6A7wytrpE7-UZx-rnh0BHSnPkHbPln7YW1aghDEfzgkwX8n6ZWZgTrGesuLiW23m5v_gROnHkB9DD64L1v9v4MZs-R8PuPoKKf5E1Dscb-w','','2025-04-27 16:12:24','2025-04-27 16:12:24'),(126,86,'dVEoybMoRiqphz7xwTR9Hj:APA91bG2gTUGVQr1b_3AN4JS1ZBMnUq4fZ8vNfNFglxqZycY7FTmaDQXBTvDECEMy4CuSdMj2zXXVXG2wKOa0sfRRQM_5KI8_Nl1GXIPIAiHhMvblJsjnkg','','2025-04-28 07:05:54','2025-04-28 07:06:17'),(127,88,'flAYdCneSAab2Koif_HDAD:APA91bHs--v0HE9OT_PSCxg876ZFYdYR5RKVfa6uFjZTzZhvDuEst8dqkIf9DtFLLNN1mkNJG3YQryDEc2tVr6arJBeD6hSWmDU21Ay-fsUSK8NhYAKl7Zg','','2025-04-28 09:36:00','2025-04-28 09:36:00'),(128,91,'fe8IsqunTPq6-bYUQ8dg0_:APA91bFCH_Za-ugHqyAIflLiSZI9ecSl18lPUMtVgoZzUczEgFEFnki_T26Snq6e33pUoJqWIJmCNsmzY6ackx0Q71L88CLB6rxLv7HDGHMXIwPwQ51SSwU','','2025-04-28 15:38:27','2025-04-28 15:38:27'),(129,92,'f0jsyoB7Ru-N7bJs1yL-YT:APA91bFw0x1Hx_sN5xwou_fURe_C0P8IRcINceK2_gKhgmIZlQHvFhRFkxqPYHoNnUKvCjCjhHb1A3-zdPSKgWvkiVxhfcVlVHt8puE338mrd5mRG7NDXTo','','2025-04-28 19:00:22','2025-04-28 19:00:22'),(130,93,'c7XartMVRIGGCGaYup__PZ:APA91bEXBpmftiBdMmqFtJmBiDBu-uh2l4rE9AUULKO2TvnewdDosYXYP0wdAQwf-7wPPcI67z81t9d02Hs2u6QdT8pJjptXqcqO78-YgMqrHLr89ZJsHFY','','2025-04-29 03:53:39','2025-04-29 03:53:39'),(132,94,'csOQHSS7mkffri0-XGSgi_:APA91bEQo0LjJbuYFgCMF99NXt9vKB3vjwwNoL9AfdGUQjmaflSV2g5bwQ-kiJ6ayRiH0Oyit9HAtB_1KV6l06xDhFy4iEPhGslpTuXFRYeFa7N8z7HE3xI','','2025-04-29 07:41:07','2025-04-29 07:41:07'),(133,95,'doWqB3IAQGGztBxCAg9Heb:APA91bEewHKbiif1s4kYgNbmw31IKHY6qiQ0pliuwqkSOFWedneAwaNsYm2klUVGIc7_mXOZCVzU1-EAeb-dinGjMzfmNh4B0ezaUNcfwVhd8zs7ztP7Yas','','2025-04-29 09:43:18','2025-04-29 09:43:18'),(134,96,'cgKXQOO2Q62QJtycYyYB1N:APA91bGpYgfSOJ83tgtp4UAynt_NPIy94qc1GY9knWUxm02YD4gneX0QLdHuPy_a5t8MNXvtoO9-6rCji7xrQnMOhauYgnS2zme4IX-4fP0fXLhVTQ9-FcY','','2025-04-29 16:19:36','2025-04-29 16:19:36'),(135,97,'edMS22wjTHWpzEvcz3IfWD:APA91bG6iyvN2t9FKQysZBVUCsncLwetIS_ljcMbRtU4Xe782bVRCHK8iTl8DmYAeS3tPr9gEyFPUEWZl9KvltJAvN3mlkyGKgbFCbpIMVI6KiBIJ-vHLZA','','2025-04-29 17:02:52','2025-04-29 17:02:52'),(137,87,'ei4837toSFiUjnUT-DNk9X:APA91bFTzA87uA3Rpw_1X1Y1sPfl-y5lZbuui8s5nE2GAn6jVxqTYSXdoen0Fm8dHGLGUX9Bws0r663zYy3dpwIxaB0n7wJ5ic1dvdukZVPZfByYkGjH8Ss','','2025-04-30 03:51:35','2025-04-30 03:51:35'),(141,99,'fUuyjjkJTyuU_Rsr8C7_CE:APA91bFzfzdGdX0lS4GvMhYtLR2fEKdSmZRoTv14gc6PwdX6tAaAklv8NU_wbcYGFrXUI3kTRmNwBuaqjwbH7eUOBWPcBd_VfT6YnK1eIutfO_ToVDAU7VE','','2025-04-30 08:20:57','2025-04-30 08:20:57'),(143,87,'dAB7Gex8RQmo9_NVPibImc:APA91bHO_meKDaGrwt1FVDZ9zdcXnLHBhlux6mbqOuRBEugQqLsoXGGK63C1qm9VC04PxLwTwFaOwBEs0drZrCZNmhyzeZoHUMCDtw7dKI2xElH2HWohX9w','','2025-04-30 13:26:33','2025-04-30 13:26:33'),(144,100,'cvvtWITnC0L1id6Jb0fsMH:APA91bGBnvCgG6EVWQhTCSeMmBN41cwniNg_2dcM5h_raZQliP7g9n70UT7sSrtSqF4RFpEtuebACesxw3NN96I7vj3-kAo5ihKifAEWXtG3AUqllz2DKl4','','2025-04-30 15:09:07','2025-04-30 15:09:07'),(150,104,'eXLyGEJ8I0_cvn--XrDXD6:APA91bFmoB_5IoMijRoWbhf2iUToYMNgysN7YMxVd3bDy-8qp6hnzbeWPHB9dlJHwbIY9ncC1H3vo260nm6_qDz3kBipyu0W2ogPyfNHOPPHv6UhzHuh0kA','','2025-05-01 13:16:17','2025-05-01 13:21:00'),(153,108,'f92140Fv3kjkiRTDgOMUw7:APA91bHjCSiCZLboXqfMLTDiqP0M75iTB3aXzKVzCiPbhQyQ-ZBh21ylgFI3liHDfrZcAU-fKOozaS_-6wMdrhVPz5N-ueGEWIWvN-sVHxqDkP3Hskg8qXc','','2025-05-01 14:00:08','2025-05-01 14:19:20'),(154,108,'dz8LM88RKkQuhpmC8_7XdW:APA91bHTmPo7AqyrJqhVmpUqHgQ__GfdYGjK5G-H-wHCGVyzpeQrhw3N5XO4Z28U7VwHXpNHbFO3KX8ztkiXUJMHHSyKFMgX6Fk2VO_p8ElSz-dIcQLHHF0','','2025-05-01 14:23:30','2025-05-01 14:23:30'),(155,109,'erebJlDWukMrkW7CUuvMwq:APA91bGlR_9Ry3_gP7LX9jdkhavBwmg3e0zMEXK1ea9wh03o54ARxt1YyX2nO9clW1uGExpVK4IgaIOt1CQlINCl8g-am3zRoKnhIVbo8QpdYMpzLCD_Qek','','2025-05-01 14:26:31','2025-05-01 14:26:31'),(158,110,'eQDLU_9EiEB9uvlcZpoCgH:APA91bF_Iml0cDe84ahwMO58IvJXz1E5hBORUer5b9Cf_Uqtg8YimjevrcI30Si70nbKc4ii6ZoeEj6RZTaEVZHCF2-1jbjKZzpLJW_XB9Xttc6vz_zX_U0','','2025-05-02 05:44:58','2025-05-02 05:44:58'),(171,114,'ddyVChdj_k8RmRqF8Fmj5_:APA91bGAMbTKXHFKxTBZddSJzJ9MZSAt7uivX88rpR_torbHQgxQ-QZEMeQoPszab2mpJByeO1AqqEl592G_bc64MS4YGLIExRLTuo657woMIQIo86v1Mg4','','2025-05-02 09:05:01','2025-05-02 09:07:58'),(173,116,'fcT7kGLv-ktxn7Vak3RmSD:APA91bGryE08nHUG5bjs2LCyZNuPQa-HUlvC-gfpKi3KRO0LVw_cXIVHPQXwxqV5UCfO-3Ym86v6n3hIYrwstOFd24Pz63d6WTw7tzJXQQYc2g2PmhZIimw','','2025-05-02 09:14:21','2025-05-02 09:14:21'),(179,128,'cIyD9Ix0HUNjmOVS9pRgiQ:APA91bH3ScMYwhktwsjqj9aKjn1eSaUecmDyrw_IXneKcuy17YhByBxYlJWp1xuYFPedgtHo0Ix3koLsXuvV920DNBlwuHUhkyOR5uWcCEq4mqOPdG9Tehk','','2025-05-02 11:51:56','2025-05-02 11:51:56'),(180,129,'dGYdACzA10ZbhLJLfSqXTa:APA91bGr6jC6pkMPc1B1If-d3lLaA2JUdjR66BEO_b2RzZ10En0FMsCTbMGdqQiZHDtW-kE_oJndpAOTI7plqbZYNt_u-zj7bdb41sfindqowAnYycIzKOs','','2025-05-02 11:57:16','2025-05-02 11:57:16'),(181,129,'d9M8r9jBE0aSt7IuwbZLyX:APA91bFf-kgwaGS3UdaHOSMdWGCZBJtMuEI32IE80roIUeO68FAVmrtmVBKLw0sM1KEuvP_xMbehJbtZX9eQ9U1imylNzbUaIfwEItit_vz-0LAoVJY7_T8','','2025-05-02 12:02:55','2025-05-02 12:02:55'),(197,131,'ct4RfXr7FkEsl5vXJ-9ixx:APA91bGiDk8j8l4kLoTj0eFXNSETs3e5eWAkhksylvtVOE_wS2fZM2CV9PPKhwFLwb8dLVAFPy6ukUmS4sH3kJdaD1JoTMkKg2qspucw4c38a_k5uMQWS6w','','2025-05-02 14:07:30','2025-05-02 14:07:30'),(198,132,'eYVZJoSaRmitba-so9hNMp:APA91bHg9AQ7z1WkY3ak4nwUyYEVP52fX9kQX4gDvDPMF6nbrTaa8YwGuQRQlkuKuiZYrN8nyHeqflyksrLX4cdbnkHnShcUCxUBUXoIwhCDy2cROqvifnE','','2025-05-02 17:43:10','2025-05-02 17:43:10'),(199,133,'cuzY3b0fRGyJOla-rb9V86:APA91bGNpTqhtkr6DfUTpr6MCSFQSAwnkBfpW4jjFXBF1kZuPTnq7l6jMauuT5sbCu5GdIOEHHCGXqU3Gws8yeZ2GhTIVkfxdcKa56372lyBW2oZofYj18g','','2025-05-02 19:31:21','2025-05-02 19:31:21'),(200,134,'c8jwyC6RTIq0p9y0qkUxr-:APA91bGNBGGuJ2P4Hl7MwOgy5E9stbMw5Eb2eB_XRPSR43vNgsaNASoYQZVSsYDFNfDr1A3bHZH36P3z6DVMp1hFbbccLxcL9TKv5x5YP_sc_83nnNeUQ1c','','2025-05-02 21:13:21','2025-05-02 21:13:21'),(201,135,'eAuWikoMTqa0RO7d-1mESG:APA91bHk1DpPjGHE6Aw2epcSXCSiJcO1CZ6sWFUC199-H2k6bh2H2_yeLjf7onUnQngZHiXsL70cIJt6cKdynLmx_nAbl-n-FVVeps23ZAxwo9hPyz7TI-Q','','2025-05-02 22:37:26','2025-05-02 22:37:26'),(202,136,'dAvgG7AZTdWRitK5F1ggTy:APA91bEM-7j9XY4_pEAiMCrCK4Z0lucbm8zQetGh7GfKIzwgbewPEK3WmZGS14ffcGLuN2sa9FuAzje-J82JpU1nILdkICh20pzhVumvkv9ZbZ4X5FvsjR8','','2025-05-03 04:13:21','2025-05-03 04:13:45'),(203,137,'duI10JkfxEvZmCOQJnUc1F:APA91bGCPg3gWCUBcFreukC8VX5rFsokg6Q-reH8TceNoHiqubKUMX22ehRgGgD1bJQsN7JcIjqcMfdZDMUo5ET7i5AXulTkxTolKdxR6n1UCoRYG2G6TaU','','2025-05-03 12:41:54','2025-05-03 12:41:54'),(204,138,'fyG4JLgZnkvXiJSehHyOK4:APA91bHIzFBF3PCnAZJuzNuqyUU2z_Bve0PCM5rBhI5Q3SOGUmFy7hYfJJaXnElW58uHTgCanhp5C9VPdG7f_oVmR24ElLnc3V5dnkQShGinJr09DTGANCk','','2025-05-04 10:38:14','2025-05-04 10:38:14'),(205,139,'ec4eJVnaYUPKqfyWDQWPOe:APA91bH6yLkNkVTCmxmf9ZITM_bp_NyayBaCMN5VlsH9hVIiFqNN-C5G6Z4T900pnW_xD67mZBHKEZP3XO65CxRUVGB5Lk-T4o1aEVvfbxWqQYiAN6KgvHE','','2025-05-04 10:39:59','2025-05-04 10:39:59'),(207,136,'c4w13ukqG0Xbp3d1OKxTU-:APA91bGq29k1-bmvGJOPgW7VaJsXZNYtt_n3GABXYFaqNoRKDwe7zZ2SnMWtpW6RJszvCTSuCRg2D-bkCcqAAHxAj5CBvrPwMlhQxwzYrYbdzsrVvQJv51Q','','2025-05-05 11:28:21','2025-05-05 11:28:21'),(210,140,'dse0i4jKIkCAlFp0S3_vOE:APA91bHjJRZP8lcHTsk8B6DYvdAPwfgP4mSjmdrXzINyY1hPjQQS81oiqrZ3aE7LwPNAPKDJ-sC3K6wPZtKDFpPiaT1QYqzhoqHrD38dOBJD8SzINzZ8O3I','','2025-05-05 12:47:58','2025-05-05 12:47:58'),(214,142,'ev6VHMWWNkAHsFcxD67XFD:APA91bFn2MBcZmIdm6JUleQEQj3UnDlJNjFKPrKXCCKstY7cl82sjtemYNYbY2qyoASVQj2spwIBrV3tJh7BnZgdXWlovBB85IEG4zYUPsp9dWWo5KOg1NY','','2025-05-06 03:01:34','2025-05-06 03:01:34'),(215,89,'dAI3UMNSTqClvbjp5Cl0vc:APA91bEJjWfETzK2pMz4flPiwRb7GxQL-61NzY9Uvg0rjhKi6xazfqQF0YS8SVQw99_3WRJn7v8G9IMEVF-zoxTwmP2kqPQqgU4s4VrzrvAWctZKH3-g3h4','','2025-05-06 05:22:51','2025-05-06 05:22:51'),(216,143,'eopeBFx4Ek44rsnS4jZ0ah:APA91bGgbewRMfjvo4wSXjVivZCQclYzcEazzAzJDOxfDD3tdEUCKKpdLqfb_oAQJ1UJe6dTsFB7z-0R948Y6zMS2VCa88UZ2npgMO8j-ENE_9fp32lsXSI','','2025-05-06 05:39:48','2025-05-06 05:39:48'),(218,144,'e6rMdONbSUWtYm6bbN7SvK:APA91bEkh5HDz9tC-yvX5A334j2SSvf8OV5MICKGznAHabdHXiErLs45rzwDbTwUV_tVflL8ID3OwgQMJ1RegSYavbfJC8Fueos5O6KNqXWJEpJTVxhVxSg','','2025-05-06 07:24:32','2025-05-06 07:24:32'),(222,148,'c6KQGxcaT0yP5JSithAe4g:APA91bEnRq7UzVh-dXHZND--ND_Iyf81x-T-wvjhsGETVIvGUWwzuStrgPeKRCeMEE402nixwn5BucECICQL2PTyWXvia5bVlG5bgVJE10gEGaODyUujdjo','','2025-05-06 11:10:11','2025-05-06 11:10:11'),(224,7,'fwjVZf6GSEygkrG3yqtxMQ:APA91bEvTxb61FpklTkw7dB0Om5gO1YnIQcbtcsUJWv-QarEibmPXapzRB--cCqH36z0FT9tYnHn8Sv4FeFkbN3RRu3QohAi5RnLhyV5ANY0LciFFhOAAVI','','2025-05-06 21:05:15','2025-05-06 21:05:15'),(227,151,'e8tXR_y_SFuXPo9x2Z0g23:APA91bHZoL3ELqTed7YJCANAoo3ZihpswFCq8SBZxvNUXJlZX1zwqDGutaIdjvqPMgqKuNgZADntBoRY4nDK1D1s4aA-EL-72wINmHPoj8rh50kHl5ivUBc','','2025-05-07 14:24:03','2025-05-07 14:24:03'),(228,54,'cRUVhT-DAE7lusAMQ1Wmaw:APA91bE0SgaVgcDPl_6fMATf6uusCUd_dVvNgyH3RLE2e71nbk73ISd5cQPJVhCHv8QHexX3rMxknP1SUu-HczWfS-Z_QW_CiGZLzGzAnKWgAU3X2PEQ7JU','','2025-05-08 07:27:18','2025-05-08 07:27:18'),(230,153,'cAYc5TQgSP-5NVdXiIdel3:APA91bE1-Pa1L9oyuizH_IE6MYwja_e2GbNBdrToDvBKlrCUF-vluELjwxdjspxEJfbnmAHpCV5ylghYYVmu0NQ0Ydv8CkPKoclzbFEfn6MsEYHBsSPTs_M','','2025-05-08 15:00:53','2025-05-08 15:00:53'),(231,154,'fkGbfWGaR2iYmvrT-OQxSd:APA91bE83gJvw5CUwMLt1rSvXtURYbPvbUREFpIEDvt1UqkPXxVzUp-XhOOE15BzeUfCiJBt19nr1H29ezrsYd0sp3rjl4dCsM6OKL776RDnC2qIOPlqUCY','','2025-05-08 15:22:04','2025-05-08 15:22:04'),(232,155,'ccOnjgBfQg-MwuXsnzRQXd:APA91bHai1XrblT-mQt-govYZy2PYfbA1I8HqTb4Sj6JisnFpcwxU2efaIcJX2qauQritdpo62k1B2lFE70vhJIgtazBv-xBolntNiKaKQpakCJh_ay8yJ8','','2025-05-09 18:51:09','2025-05-09 18:51:09'),(233,156,'dPTtzWyNckMZgUG0d7dDRj:APA91bFt-RVzYQKAA4oCRR-4mq_jcmWkSqh47aBKz7ppmCrxKQpWcvkmGCAMIqM22BjtOqD-nLS9buBLligZHIJR0OJbjoMjwwDRb-rlkq6IYIFzuqcg170','','2025-05-10 02:19:05','2025-05-10 02:19:05'),(234,157,'deRtHrEaRTiXnveZMVbgY5:APA91bENk7deQ6kTaccPbScub3C_bnb4gVJDcu6xT8nLNpsGN2snIIJwOLxjP6vKF4b5-sWRxy83sJ-pXsQ7-ccQ7FWyRIt3PjOpoD8ixb3No0P_fPHb8Vw','','2025-05-10 12:40:46','2025-05-10 12:40:46'),(235,158,'c2zxMDWf0EE0pyYa45X-QH:APA91bFdNyPMdfFhnE6utiqDZk1KN8QoXI0pFqjI4zmZNrusaZp0CWb4nDJFa11QwYIdg2C7qzrYsulqLl48O8oCLpbBd9FV7H7SPU07U4iO7hVmHG-0Pbc','','2025-05-10 22:14:45','2025-05-10 22:14:45'),(236,145,'fIdAxnVfT-q9WEBHu1jCN_:APA91bFKvIwidkWaPIPIAVz_cFVLOwikNrhXIAC2RpGEntZkigtG9Sqbx4cxPcDJ9sIKgnf5gitOfD0UNUmm4qfIMGha5AEVdzgGN1avvsDFmcPjX6qPV0g','','2025-05-12 14:54:09','2025-05-12 14:54:09'),(237,160,'cwvSUI5vSIO3X3R4cQFNNo:APA91bGWHxGpatcT1zJi4nhW6vdTmUaIO-OcF5E1JU35pe48iPWZFVueCpjxzqXn68R4fYo6VVaENa8uFlFkE1tQPjo6DnH9Js5zADNPxxmIT5uHwlc4coQ','','2025-05-12 15:31:22','2025-05-12 15:31:22'),(238,54,'ebrWw99j1EQDgkhRWMBUdE:APA91bGeJKO8_dNXKuqddQYuYlXVvcXHKRHH2bq-S7w1rGIdDjXync_3yhnoCyOIXChYzJGC72Go-jks2HS8lFNh-A2xI8sEZN7oaRZxDPrScPysQfs4YmM','','2025-05-14 02:15:20','2025-05-14 02:15:20'),(239,162,'dTpQS4ONQ7-3gsaBF3CGpI:APA91bEHQdSC2h5sK-c0eaJSI-OJ9MotMrFSF66w7t4bfhbPnju6IshQfKCNTc46mfXwKzbcsTERGMieA1cwxxvd41Vyf4L1RHWBbjgzv4EwpmuULCYPSeI','','2025-05-14 18:48:23','2025-05-14 18:48:23'),(240,164,'f_rKEsKaSviSvUPQut-Kf6:APA91bFQTczVYOfJFypzR8HOtKRGomqV8eevJunZUipMPw6feFrF-ZdQyACPa76bQjbaxT0Evpg75nLq0cMpfkiVSooUqJ8BnTw94TOA3M5puEAWmgEV-gU','','2025-05-15 16:58:26','2025-05-15 16:58:26'),(243,166,'cIiP5aqzTk2wE3A9uukwCb:APA91bEll79vLBZ41tj1sztGd4fIPJrpTs8mhbbm429qoyGX3hmikE-afBX_AvCIQ2aCWPDqGSqLetTRBTGxbQSETkHpwYTfI93DL7f8LNVujolLMGk-baI','','2025-05-16 16:07:58','2025-05-16 16:07:58'),(244,167,'dRHlQglHHUMAmkUKJFwB-I:APA91bFyCigwFeRxf0tt6Ck4_Bz6aBaJI-B2OWLnrQtCVHtkRuqxRxbnc3B4xcA1Vj92PfvpuwIhw_DeQz78_W4u8uRSn9h4Ig5kK9wrTzHtu-qbEiPiCbo','','2025-05-16 16:59:54','2025-05-16 16:59:54'),(248,173,'cOJ41lPLSH2wOfxexOW_7H:APA91bGLwKdmBL7p2Ckr1s39LK8HyR0g853w0RkTeKHKo4BCjJhY0OiCH1D4OQ1Tcct3P3aeRicSnEAlSSF906EqQ9Mol3ZbXtpjwtVgc_F8xW7l6qJVQiM','','2025-05-22 10:23:24','2025-05-22 10:23:24'),(249,174,'cvZ8lhyqSyqbGS4x300mgL:APA91bHyiOXVISCUk8uerlAm0Psb2pAiucNiJoUiR_w4GfajBCTdQ92nPKpc6_lkFiwO8B3f2qcSVDUZ41xGVABil5WhZelXNB78Xczf9T4Swcmu7BAejjs','','2025-05-23 12:14:04','2025-05-23 12:14:04'),(250,175,'e5R5VLnVRA-nLN_QFadjlw:APA91bG_-r-MKj7Bg7FO4LGX6dJp1YCzQLJvdwccjvupRgSKmkSwXrYYLf-p6WU6xcWrjdVdCUdQOhUwVfQEg59s1FCDQcqYkXhaZ2xJX7aQzb-_DL6Pnw8','','2025-05-23 12:26:08','2025-05-23 12:26:08'),(255,176,'c_KZHYHlt0PQlujgPH64XF:APA91bFEV7O7_-mXfATtKF_GLtHFfvpsF9tvzketgp4pCMpqoHQQbFMsb3yUMlbSqQiJakxst1Uue78Fbn0P00l2VMEynFPA_hYrXJ9vWtRENvQ0InThHgg','','2025-05-27 11:00:04','2025-05-27 11:00:04'),(256,177,'c6xQbHpnTz6Q_WfnKdfvR9:APA91bG3uIvgxON0B1QOhwyYGb10tXFTi90hoohDfFOe1xEauXYSnNKdhJ0-fd_Bu7iQw-pAcXbaggpyfkA3rDO42Z86hCvjH-N3oQCDNbR-ZxUY_iuRnFc','','2025-05-28 14:16:26','2025-05-28 14:16:26'),(258,178,'dC3QBIApTM20u-_z5RBg9O:APA91bG75dCXVyHocJSJkqtMt8MYz5_3NHHFtUudTxkx5RwyIKIAyRIPJOE9Pge891A3QtoWAKV0xDTEi7LFT4AfsKIrAwqr_RjKyMJr_m0Fkge5rKNCD-g','','2025-05-28 16:39:30','2025-05-28 16:39:30'),(261,7,'eZCxfyJmeU5FgPT9RjlMza:APA91bFIBe7QO4ZMoahY9RWtElKuPQsEFCryAHoKuRNOunvXiYYdOuFLePLdiDTJqANokyTtOO_N2O6WssCorX92KNFRSNk7EC88NEq5PDXgbCF5FboTVys','','2025-05-29 14:08:52','2025-05-29 14:08:52'),(265,7,'c_4E6S9-ME1bvWnU44LMDr:APA91bHZ4lP4GA-h21D3Ks03Qu2r8C6hP6sTJiFRj12Gv9YO_IGoLgH0g7qAZb-srytXuHq2WxPjdwouTyZQwLf_e3v875eQAIf_0Qy3aqstdFJGliUoYRE','','2025-05-30 06:30:40','2025-05-30 06:30:40'),(268,182,'ejUSSTWjQxqVT_AqPHDXUb:APA91bHxAjSiWdE6rXg4vQeuvArKdL2L2n7rDAnqt6VO2dpOcAm_PZjn3R_VUgoBZISZDGZYHTXSZUaQAw6m_ADN-LJkLA3LF4nY6RI2RsCj-TRYQELi99g','','2025-05-30 18:39:14','2025-05-30 18:39:14'),(269,183,'ft6PLa86S9KVkL7y4Uo-ZK:APA91bHR7kwk-u1eW62aLcWc6EC2lbK8Og7vjY3aGs4vBumoKWpimlWN4lYDho1SUsiV-6NqS69Vu2cRz9ypsmKPUkxL-OvUuDYChUymGXEVcuhBE3G1bPs','','2025-05-30 20:41:24','2025-05-30 20:41:24'),(270,184,'fhqwW_eFokmbpLFTfev8Na:APA91bHg2kYHH1XxKHswxvCjT6wRbcJnoS8ftJhTPMBv0h8tn91tiUevY4PYBYfxGfpVSUokCRAkUeqdS5CKD5Eefm58cb-SxUaJUDuAJm8Hdk7ebweqZCQ','','2025-05-30 22:57:11','2025-05-30 22:57:11'),(271,185,'eY3M9UCDfE-MrKAA7dH36u:APA91bGXBT0FZ2VAz8CsCKuW9o5T0IYte6G7X9pkp2Hb0EEan8H51zxlnhkd5-2eCPfBFpy7PTUn9wTkJ3DxySd702K5hCyzjjALhyitMLXGahhGn-Sbmk0','','2025-05-31 08:38:06','2025-05-31 08:38:06'),(273,186,'dRo5jxbnYUQYlL8f4JOajr:APA91bGTv88_yRjjV-JJHJ37xMFG0PBiaWc6PZQVUgVhr4IpSrin1eoaqdSlav5-vhB1fQCZBwM7ZzsRWKk9wNi_e_-lJ1AS9tOkCLyhCZiH183dpjfeFDQ','','2025-06-03 08:22:51','2025-06-03 08:22:51'),(275,7,'d39BNgQCAUQDoRINXEp2kM:APA91bHf_1n9_moMul5RlYO_9UGeWalTXPpZg8dXtSxnp3AFXYKNwFjTR9d-IVg6jBG1N7VIsWLMKmt2KJFX35h30TARHeZgfbuzYw5en0X6dpywCBittyI','','2025-06-03 20:09:29','2025-06-03 20:09:29'),(276,7,'ezEU7B1ojEwNl6n7yKgkNd:APA91bFMrT90QKL2ZCzkVrM6uq6gpezuXck9xtmRUkp04Gwt0Q5G01qss8oS74Fxf2cx6Q1NLlg9Mh9usgrAqxk3Ypjzo5Pws0YOwJvMfuz6pVS1HeeeL5Y','','2025-06-04 06:18:54','2025-06-04 06:18:54'),(277,7,'dGJtGu_nZU_9sc3cHz-TIg:APA91bHzas9q3UtmumxwXFVjRaD9Q4GtzPVT-pIldgOV0CWS8_puW17_kxJgQnSXgsPhprwXyUzrsnnMZ5aUcAQDiZ6vfK2hLNCfSnd5zhgpG1NdE3SP_Gk','','2025-06-04 06:28:53','2025-06-04 06:28:53'),(278,188,'c_rRx-vITKOulRd5rttfcX:APA91bEbfpOyftDFU981z25fzXDNh8HjH2VkKHRiVK9MBPWLdXIRyq1yhXyR6sLk4e4_QYgBi0QxnssJxZX4D6IiJL5yQ5NNqNx9pX_yPKid8wnAjbRRb08','','2025-06-04 12:01:45','2025-06-04 12:01:45'),(279,7,'ci9AMDSHNEB0ip5dlOJK-l:APA91bEjVUcWeG-Mh20khCcRlwLSWYcygnpdpglzKm9kFzFwxYEQfaO0zDX_nu_dLwig5ygDpmY4F_VvZoK77slcHoRMFJHctQIqq1O3jA8OYU1j6WX1jVU','','2025-06-04 13:49:32','2025-06-04 13:49:32'),(280,7,'dqTXxuztDk-rvaa8r_E2Fc:APA91bGlNTG6a5xa3WTIr9q28w0NujuR5dJfcElkN8UzUup5bZhERxWQztSwEFmvCxhfxXIDCPeTWQAcbKnuhJazMBOiOTLFADwNIF7kFjgSkeaZOsJl0Yw','','2025-06-04 13:50:44','2025-06-04 13:50:44'),(281,7,'fm3NUjXoQUgOgSUsBBXOCU:APA91bFQitZzijWrhn0E_IQoDcFvigZtcmpgf9MCIwoqs5FH2a0dCWx6HzDKKioR0oi_aO3CKBAByldDyhOByxLsxIzUKqixTXzlBUmQBAKRkdXtic5AQlo','','2025-06-04 13:52:47','2025-06-04 13:52:47'),(282,7,'cnkPpOH0XUgZvWLY2vDkf8:APA91bH0GbfSSGX_LjqqT0W0yCUrini6dGCWAVTbPxWdfbQOcrM6hrBobNOf3iBhxz5PWT2tZK08yGtkXxMm85Dn3h11FubyNl7owo4xXqCTVyFG9gHf-FA','','2025-06-05 06:04:50','2025-06-05 06:04:50'),(283,7,'d0yCBsa_8EfbvRhd13Yvq7:APA91bFlUN-NBbGW4ETGVFd1wmaP3GYSaPjLYh1nMfh4S4LmUBjoogGc6DVRSRWC1DFspUOeSUKryD_A6PklLfUH2NQ6uWR7ng6R4ujTR8H9xfN9u3evDIM','','2025-06-05 06:20:45','2025-06-05 06:20:45'),(284,7,'fhfIPEsd7knvr0yCHLNAke:APA91bG7JjMHVWsUSYkioA3WWdSEEL3zX_af_XF0yLyQk0Yvdg0hU399X6V5af4K7YetAvXMYtQLPz9SKWZkyCH2wlAJO6PAVQWjnDvrH6Qgr9wHNQtFS8o','','2025-06-05 06:24:49','2025-06-05 06:24:49'),(285,189,'cc14Y1NFR4CSAzYu-VODWy:APA91bEz_af-K6sYlbkP-h5zif6QdbusBeR4rc5b4JrVhQqQKCpt2fTYGclPaYcVjtc6Z5e0yoDZJ-FrmnUOR7fuDhqYGIxSBUoTHxXGoKL42XdKc36hIhA','','2025-06-05 12:17:22','2025-06-05 12:17:22'),(286,190,'cYdhfM_KBEW9gbcXo36pBQ:APA91bGE2Kp17hN-zCH8f3_e8wbMHRdZJQxWzZxtzUfgDTzjPHRLyWv1fquKE3bPTPDdLuojjldmsdeYYAospCPLBVCQWNwG_vAQ8DuLhqnlNDIbssu8PN0','','2025-06-06 09:06:47','2025-06-06 09:06:47'),(287,7,'euYfHLeaTSOjDotfCb0V7f:APA91bHC1-Kkk5RM8xQdIPisSnWQqF6XnfNsWCZUgNYmQiW-H-51fBfQSBWB8WUkEmKv3LlOukU4-wdKF6xdFolES23TVJStJzp0oFDCjTdZHMXjMbWSe6k','','2025-06-07 06:18:42','2025-06-07 06:18:42'),(288,193,'chMusUMMjEHcljU-s-bbcT:APA91bHyjoK7l0KKNFZ-vNxtFb2F2wJ_MrX5elAv-vEwfd1OITKa3a-ZVItwABdGpwshDlvNfVCOuC2V991Z1VzQ43yV-WUchIgr2CC7IO6FRfQADx6RzEs','','2025-06-07 15:52:10','2025-06-07 15:52:10'),(289,191,'fXoufmd0Q_2pFvOcMgoX_2:APA91bG5AOFCEkjYtbnPAJRlqRO4xRLYdAITEohMxfAwHsCWkcvoIl_MTNbm9JidASfD19PnKY-fjolbmd7QgpFp9-t8AB95g6IcxLkq1iGzIjGHSLglrIc','','2025-06-07 15:59:28','2025-06-07 15:59:28'),(290,194,'d0GtoKG-QR-TwtGGlP9Jc9:APA91bEOTrrD-8ICqobwbSu0JfGS7abvDOhyYBmM7tSBZGctE5czOINUsmlgA2ZbxaZmk8DEDhQd-Cy41jNjNov--qWQsGkAThibuL22MPyHuzHiLZwuSfs','','2025-06-09 15:31:48','2025-06-09 15:31:48'),(291,195,'fyfJgimORyeuA4byEUMp2p:APA91bGXdey0WZxkXeM1Ii8-agG4t51zjedVKymAbcmvJ5AuyZQWsWvT3FME4HGzk3WlGuHJte6jOkkucl3NkbVDmgFyS4qClvPbImbHwNXQyEnaKJw9-cE','','2025-06-10 06:02:03','2025-06-10 06:02:03'),(294,136,'cYHvESZ5UETDv3NrXuA-H0:APA91bFjmwdmsCzh8kfceICTEsecJ5WY_uxXfoBN9Qg2OgsxvoRp7uDx_JyAnyTtcd1UOR-5yR73yM70nml_cATkix9jMGzVYg8ZW8NJf_8YUeZ76B4Y2O8','','2025-06-12 05:50:37','2025-06-12 05:50:37'),(298,7,'eMMz_kG3-0BjhyrrTBa3gO:APA91bFvNKd-iF_QRNKhvQdndq1Fcdxg41maPRu3-1bsKX2cDMvKjymo14DRWgkZqrlgCUPz1CgtmXoVmyLUX8SkqdYRTcHfzXwTPgv0MI93VXQX3KFH9l8','','2025-06-13 05:50:18','2025-06-13 05:50:18'),(299,136,'cRu31S6E8E12rXxlGYLjzd:APA91bFRW8ATpPEbZinS75caKcp6kmJnTOGNZtJKErJakQHmYHUUwtGg9irtN1oQa7-69yx_ttNc3tCMnDGGLo0hMI3PW8oAY0DBu_jb5F-WhwCxu8wHAUo','','2025-06-13 05:52:31','2025-06-13 05:52:31'),(300,7,'ctcV9lfYjk1tsO9V7rFCoT:APA91bGr7u0X2gFqdQiwYTnpwpg5CupDYvifbOXTKT1SguNAMLNpjrp40y7RD0fyqTsDhYg4T8XaQinw482vKvZDlJvhBUY_Mc7TU3eWIbdFXMDQiMTm0jE','','2025-06-13 06:53:13','2025-06-13 06:53:13'),(301,198,'fRxsRTN_SUWqypkAoXI2v4:APA91bH8C3VJvG_DBrqFM76FDgU76bky8MfGWYh0b1Y-UZUIrAyGImBhzznhXpT3aVMHcjKb3_bnDV9TPjTndnY7DnYbAaL1asAV4KsfwOkhwivDxHSVazU','','2025-06-14 11:58:36','2025-06-14 11:58:36'),(303,201,'ew2bxRfYRmepAYZ34eWEW_:APA91bE2fyM6uWWx_fA3CsNInQrbIxn8ShSJan7_pihHwscXDqqIv6NFBv9Y4WmMOIX7R62uYD-KM5r9XD4xglONhU42ExQIDccwdz0WSERMNDbef4xCa5E','','2025-06-16 14:15:36','2025-06-16 14:15:36'),(304,7,'ePXYoADjDUNpkseAR9F67w:APA91bHN7uY4JtoOFaKG8m7TZx-OhwxzRdq-KmMHJ68GdeUKFfPEOI-pV4VrSbpapPjrPa6PFmcBUTpq26YTKbRQC395TkC-sDbH_8P_11pI84cKmClGTv4','','2025-06-17 09:12:44','2025-06-17 09:12:44'),(305,7,'etceTvuyAEZImb85VY3q9T:APA91bGaws7B5gc1RDf7NCf4B7m_2-BnGMsusWlu8LA84lOhUg4DJ5hPFknMEApMvtuq3gz_vG113Fn9j_Umo9kRHcW_EY_HfjaoO4VbsSPAcupz1tGN3Ec','','2025-06-17 09:20:45','2025-06-17 09:20:45'),(306,7,'cxB_d4aKI0-PqZ0PD2UldX:APA91bHqw-1h8tlc7EiSa6dXZyWR74OOvXMJREYGvgeEPuujBwJpvG_3fG3S2D-wLjS024VI4QRP7tlelrWWTDcRHqt2ctb2Fq8T6QuliEaZFEQxuPryY54','','2025-06-18 06:08:54','2025-06-18 06:08:54'),(307,7,'eGi7kJTAQUmireJhVAHVaH:APA91bFxWIXnfyzz_TvebMUGCqX2UB7kDbB5NiBhnc59k0VD8mIUifNoN0UNcR5tOf-IHISUmg3Mpg1dyHpnpob2zJm3uJKbkzl_iJ-h-jKi8iexNMEbM8I','','2025-06-18 07:12:44','2025-06-18 07:12:44'),(308,7,'fn8AQsAGMEcAig6pSb8YoU:APA91bEPVgY8NsfBlNCt8QyjRPOO9bgKWhG9qTfpJjtzLAxVlbb4NClrL0NXxLWmGjEF4svkWOy78Y2pof6SUzKpqjoM1Y3XJ9QLd-s2_zJN086MCrLxp8Q','','2025-06-18 08:48:27','2025-06-18 08:48:27'),(310,205,'er_hy68p1UsYk3yrgNz5LN:APA91bEWuawTrRkS6VK9GYO-LjDe3YQQnGAx_mUE_N3hPkK5HI7AWV2vbKEJTbp7BA95ON9Mx1eSGVDTBS9w-8anLQ1lR3G5ha8VGqeOJfEVOEZwYtsPnSI','','2025-06-18 12:14:06','2025-06-18 12:14:06'),(312,7,'d4D68wSV5ksNnhkDkcpLVr:APA91bEtf9M5QZkU6Tiqols-EapR5mCSob7_4_nDa-Nu5446Eaka8PWGss6gcmr73-0IYxjBIJxvF1ZFfqWDupDEWHSFg8Z3nu9ABvJ9J8FV7RYV3h1kbvk','','2025-06-18 12:26:37','2025-06-18 12:26:37'),(314,7,'f-uqxX0ipUEjmOsNMmBbo7:APA91bGSJCdSoc3-sYB1MYNSRRVqSdMxYB51MELI6-DytNG6ZaZTFVZBICKffh3IEUigMUv0_a_eXkr_6Cy5aXiJ5kHHetUvTMsQvmthm8VEOU4BdPVaZfU','','2025-06-19 05:23:38','2025-06-19 05:23:38'),(315,7,'f87FP5Qbg0u3ileLW7XHJx:APA91bGczh3A4RSUQeWk8aZ45O-0Pnx7PopOcpVH1WZD7FxpuWzQLmCdK4bfAFWjsBVDYmIKm8WzAXlXfK0mJq_QgLL74fvlJk8wBBAUyN8Lg8z0ol1289g','','2025-06-19 07:01:24','2025-06-19 07:01:24'),(321,208,'d4YCnRIHSJm2rpuymWbFqB:APA91bE_jWSPJygWtcW2h6EWsxOe1IJiUPtFNQzf3b0yIxZ8LxV-_Tcz6Uv2Pn5HXz4jrzKXiozi9bXDkKd1lfv_BUtbczvBXnCvZRFgKxelWP5lI3Jfbik','','2025-06-19 11:22:50','2025-06-19 11:22:50'),(337,7,'fdpZObqo40VOjXjw2uPMWJ:APA91bFGFZqqAdHpZPtEyNrdgTeMEQbB_2Wjs8cXbI33cEfYp2nPQ-9zOIZDn0WchB77tc7veScOiqE65vq5iXvSQ6zvBEb_0xDX6mTYF-gePRCnEJ-lbc8','','2025-06-19 12:37:53','2025-06-19 12:37:53'),(338,136,'dki2QjR8SfKV5wcUSCEdW_:APA91bES2Ym3taMxo2phLcooCS3x9U0A6_ZxZmuBhX-GBFgYm-pJYOqWBfZtVD77hTS7cbZlzfVXHeJma9jhp7hOGpvTCPxzi25odMf0BDTzVxu2dCc0oDY','','2025-06-19 12:45:46','2025-06-19 12:45:46'),(342,206,'dQcLCT9IJEeZtbA73B5tmo:APA91bGkwv-uaORrkoNx0odNyo73vPcVltSNFjzzdkzpqRpqpO1yUpLMN4yUsmoLi9mmKNHgIzKQMOJBEpmzCMc_cDtiGpz9oQ4NpGW1neEtc2XkVFiNlgw','','2025-06-21 15:36:26','2025-06-21 15:36:26'),(345,210,'dDbatZBAQI2cIMm7S0IMBY:APA91bHH9vFP_gwg5Kq4GaKMyDlDkjOVLwT3MFd2Es-qf9UMd0l3l0sMZZrZyljdbVLSpKT31QAa9-YtX4yMJOaEAilBLOwAvSLt0WndmtAnphJntOSOQLE','','2025-06-23 14:52:00','2025-06-23 14:52:00'),(347,212,'d7FlwJ81SnWwNVmDVRL6YA:APA91bFRrlc6sa6lirboGEM-bVWOMWWZDD4ufy84KIngTP1QbVbtjZrwipnFkQexlDi5rOROaT3Vu5mnkcHdweakt92Vpzh8j0YMgS5nROltyuciJAJdXKw','','2025-06-27 14:26:46','2025-06-27 14:26:46'),(348,213,'emEcmOy6ekXSnEtsxOJwLa:APA91bF-v_83OSeD5f1rlqCj7lCrALM2MFkkllgjEGELKr3TPebhRDqQ5qL1wRdE0F6DxOvssBUgV5XTVCoO5RHvKlbmx7doNKBx1BFm4VviTYTDrhWwnDo','','2025-06-28 09:28:46','2025-06-28 09:28:46'),(352,214,'f7dJetatHE1rhGRxyEYb4o:APA91bGUzMrvS60BkbhxcidwgZcRklL1LD6UIc6eXcunvYL6EjbYvJE3llTDGXgNhGDAtCpOIw42yQSAp-P7douYTK1SFQ2v9UsNwKl9fw43AkKFY0vsE0M','','2025-07-01 11:04:04','2025-07-01 11:04:04'),(354,170,'e799u4YeQ3uhxarQo_HL11:APA91bFDkzguhgUUWJ25qc_HfRsbkj303fpaH2amqnygMhPY6CDiOKnOqIsalq3BPnxP_518AGimV0Q2mTm7G4TqxKA85zi9VRKjHiWegwgBji3l0pWnffo','','2025-07-02 08:21:04','2025-07-02 08:21:04'),(358,215,'fWAt_EWLOUnLhDkXp_gQb8:APA91bGFl6F1aZ23UzZV-8nCw5iFbkgTKyJcBIryi9Xp0SIP_08ye2lNY5BRUvCvxDhL6elnW9SECBQuXODCW3Y2F4bv2c4W2XPA1x2G2EhhFaGT5xiY_W0','','2025-07-02 12:40:57','2025-07-02 12:40:57'),(362,7,'fvNqhUzUS-6OKTdp3Ww_HZ:APA91bHuIvBFGc3uZxgyOh39spNYxwOGSWbqRcdAMnzweII9TAkVJFgcSYQbn7HPfbBXitJUv11WQL4gFbShCdVUrKMHjPYCYwwG2wes98V2HKYO-oBKPvk','','2025-07-03 11:29:36','2025-07-03 11:29:36'),(363,7,'cP-HciKnQk66V7Zh3xquU3:APA91bEAz-mp7BfXwHKdgrB71uQNpRSQE_ZBrSj51B2tuRpK_Z9n1msENmEOculsVMvS4wpUzm6HfToJ7GPw7hbpvA3kyBSBSMR5GUQ1W7CE0WC0JpElPeI','','2025-07-03 12:49:58','2025-07-03 12:49:58'),(366,216,'cJAhXAh7QH2uCgJbzfMA4U:APA91bF0bBe2fa5mb_dHX5bGjOrIKurge-LpC-S7VT_qo95Mk0lPQEBzITwc09LHgP_X3zUI9BoIC_ircyMBVGGcB35WHUNY1uNMENGwMPh5zQilFO_nMNs','','2025-07-03 13:09:52','2025-07-03 13:09:52'),(368,7,'ezEyWWbVRnSQS0du0dI3jB:APA91bFKtYJe7gTGOgZaYktIFhnDsbuFMu0ckWg3wUPWm-U8yxmCJlBaftOubmsyakfRnEfeKz_iqKObgqfDfflpZ0rilqMoyB_oVJIqF7y4Gge1TYOFXhc','','2025-07-04 06:54:35','2025-07-04 06:54:35'),(369,48,'eV33bgpHTTKLcadedSiH2k:APA91bGRsHOzJb9u62-WfAK6lBPRYH4lZAdsompIerJvHWilpqmZymknMVtzx3Mj088dC8HuO-xs1tyQLxKVHfICtJlZw2Uadp38Up4-VC3I7-w-JpPbqvk','','2025-07-07 05:30:14','2025-07-07 05:30:14'),(379,216,'fWp08M96SqS3u2mPzyPd0u:APA91bFr68wWidh1BlWf0fO4_nIAbtHkIwvp1FmFUZebCZRPHszLjgJO14gQIhU8CiHvj-bGeN6-8YO3pYaW4csbpvDi0XTivrCQTKC3o1o6cfvKlRR-u0c','','2025-07-07 13:29:05','2025-07-07 13:29:05'),(380,216,'djexOcnoTymkhXKrdKPXfE:APA91bH6ATneTv7w-5eOADBJiLTDSm_kWJZ-nAVy9jfKypbfvB2yeTIm0ecSuaav2XxEOlfrJkNXTtBdz4uxKw4-LiwcIAJGUnBHvY0mMTiRc_junNrF9tQ','','2025-07-07 13:34:33','2025-07-07 13:34:33'),(383,216,'c2kHqAuF90mdq4rxeQu2mx:APA91bH9i8Fv4CHK59ZVYB5ZnTup1qoNgDZDrvwmIVGp_yvUUnBlDzHykkPjyAMe1dsWaS-LN07h_Oj0m7fOvE_KZqrM2Cl7j_RJFQTiSpJ98vo_iVRT0GE','','2025-07-07 13:58:59','2025-07-07 13:58:59'),(384,216,'cgmLXEIFR4KQTQk336vvXn:APA91bE8biTBJkVDjtdjj-t4KNZTK9-yr6xP_YdCG0YH4iOZOtjH3SP9niXmthLX6QNPJ1jtiB9ckI1UlDlfzoNQTgi-5z_2RBnBfmBQpbBXBGWCuYXlQf8','','2025-07-07 14:08:00','2025-07-07 14:08:00'),(386,216,'cQT4Q9WaSJi3yCvN2efrsg:APA91bHsWwKUeTc4rx_Ro4MIYq_LikwF9okUI7x5O4OoYxjo6t4oN_iJh8hkNp4UBHHGqj-fPspakNFTO9ncGeLyW7enxMBWKTAZR12TcA7xm9nGcuTUQQM','','2025-07-08 11:18:20','2025-07-08 11:18:20'),(387,217,'f9b-YyNBWEj_qEqD3y3__D:APA91bF7rZ6H9KMvANFRylIxA63rhtMVQynyD0R99tPESqMbtGnxTcVoeIqu8IVo9dmdTbWaB2QpqLQzuhlPiY0z_nVLQhClIPuZ-rmBktwYLsbArEP3UI8','','2025-07-08 14:29:31','2025-07-08 14:29:31'),(388,7,'ei3fW0gI-UBriVw34YlaH0:APA91bH85Xc7eVzB-xTJvLALqoHzodek-gQyLRlXdgiclgaeXzt7t1tFdxBH3cjPdqEk7PW5PdkCMDTVStGR6HqqHcq-0D_Bh9IFEPGQbhtOf18qMPI8mtA','','2025-07-09 04:23:06','2025-07-09 04:23:06'),(389,221,'fHXfEA09RxG83ZcWw3zRHD:APA91bE0_xIVHb9M1Fcn56yvbP_DKoMqkJSycKun4fnKvTWWJZ76CJxrX7xLC7clK_doue57h9K6yDojlSCE6vxA1nGYJPdXSBNX6g5zWEyWjcUSZAFhXvE','','2025-07-11 12:16:28','2025-07-11 12:16:28'),(390,222,'dyvXv_RETb2dJ7JvpQZuCd:APA91bEN6KWa8AJ39XYZF_EShBt927W-bjifOTqYn-Wuu78qqps9BuroIehlucNAgx3_IZCSGYLgXNeQuSLOPvR7uvlqkbFY4breCiEnGxTvsCSsyUrhVkM','','2025-07-14 09:02:57','2025-07-14 09:02:57'),(392,219,'dhBflahoTTCf3uvN7JquHa:APA91bHNUuSprJZ0pnTsKnOXx4OKlR30yzq1hhjo8iCJVFwJr4p-E0mVa7r1tXgrQ5MMc0fmETOMQOfVPyHMbl6PjEkYGH5hha8C-LKP1-URaxCNV0c0iy4','','2025-07-15 21:07:17','2025-07-15 21:07:17'),(393,224,'d2Sn0YO7CUX1hG0_ptFuv0:APA91bHLtYx1dGzeS7Zziw4zVTjdRmV8i7O3fOEPnUyoV9Gp-2u3okFimQo8I0NdrjJfKffmyWzoS1QBYaHB5OgZbufXJBByu_DXfBbOQDwAVLsllpTTLNw','','2025-07-17 08:09:34','2025-07-17 08:09:34'),(394,7,'dbYrInkdjkfCrT8zz0KffU:APA91bHvksjP6OXJGUggJpMmOQdkYi2BFg1-7O8V0tKU2gQQ1-gzXgHVGWG_qDVKXshUBl4aydBlNzrmu8V808YfLipObnH53lVrkkn0Mjwp-HHidpoNSko','','2025-07-18 06:46:42','2025-07-18 06:46:42'),(402,7,'cJzkDcNXFUBmrBz6y6m1-R:APA91bH4CJHh69aGDN_pa9N0ElMbUyFHKJvgWn8WhjkipYQgBMHpfjnmf1oXmbQhTQj3HFWgvjJzblDjzd7azbFnJVUaoeJaF7oUMaPyC53y5y8wSDJaBZg','','2025-07-18 09:04:50','2025-07-18 09:04:50'),(406,7,'cOb2IRa6R4e5tkHGiIzH01:APA91bFuRYuukVQbuVCzvMuwvE0V7gfC31Ysd4-dwYHdZqDD-0wpyAlVtzQ_-2xcvDe_qaw4li8C2xBJ1OFKkf24d1OAQf6oyTi_1R_HYvlZ02dY4qwB9uk','','2025-07-18 09:55:10','2025-07-18 09:55:10'),(409,7,'dGgiayTJrUh4oN8cvg1q4a:APA91bFyR5pfIuUXPN0A17SE6rbpZ_40lYQC4-OD2n-OP_OWsI3LM2R1QLgOYo4S0wlo7HnhaiPQME8388N18lzZ3CkktqqFBOTgfh3OS8tgciHF29goFgE','','2025-07-18 10:32:49','2025-07-18 10:32:49'),(410,7,'dBVLZXulXkMpsgVDVW_bJq:APA91bG1ug0gR7szKPCoM6q1wu1Qg4AtzN6hxSeBDdrJ7hUl_ghSzGuaV9DfRPHhKZDXJgptsCDanljl4kpUhuYCeUG5lOTwvjPIv8NbIP4qCywhOEMDCgQ','','2025-07-18 10:39:08','2025-07-18 10:39:08');

--
-- Table structure for table `verify_customer_form_values`
--

CREATE TABLE `verify_customer_form_values` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `verify_customer_form_id` bigint unsigned NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `verify_customer_form_values_verify_customer_form_id_foreign` (`verify_customer_form_id`),
  CONSTRAINT `verify_customer_form_values_verify_customer_form_id_foreign` FOREIGN KEY (`verify_customer_form_id`) REFERENCES `verify_customer_forms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `verify_customer_form_values`
--

INSERT INTO `verify_customer_form_values` VALUES (4,7,'Male','2025-02-05 08:49:50','2025-02-05 08:49:50',NULL),(5,7,'Female','2025-02-05 08:49:50','2025-02-05 08:49:50',NULL),(6,7,'Other','2025-02-05 08:49:50','2025-02-05 08:49:50',NULL),(28,2,'Full Time','2025-02-19 06:36:33','2025-02-19 06:36:33',NULL),(29,2,'Part Time','2025-02-19 06:36:33','2025-02-19 06:36:33',NULL),(39,13,'car','2025-02-20 06:55:29','2025-02-20 06:55:29',NULL),(40,13,'bike','2025-02-20 06:55:29','2025-02-20 06:55:29',NULL),(41,13,'bicycle','2025-02-20 06:55:29','2025-02-20 06:55:29',NULL),(65,12,'medical','2025-03-03 06:38:41','2025-03-03 06:38:41',NULL),(66,12,'solar','2025-03-03 06:38:41','2025-03-03 06:38:41',NULL),(67,14,'Baroda','2025-03-03 06:39:03','2025-03-03 06:39:03',NULL),(68,14,'Ahmedabad','2025-03-03 06:39:03','2025-03-03 06:39:03',NULL),(69,14,'Surat','2025-03-03 06:39:03','2025-03-03 06:39:03',NULL),(70,14,'Bombay','2025-03-03 06:39:03','2025-03-03 06:39:03',NULL);

--
-- Table structure for table `verify_customer_forms`
--

CREATE TABLE `verify_customer_forms` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `field_type` enum('text','number','radio','checkbox','dropdown','textarea','file') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rank` int DEFAULT NULL,
  `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `verify_customer_forms`
--

INSERT INTO `verify_customer_forms` VALUES (2,'Job Type','radio',NULL,'active','2025-02-04 05:49:40','2025-02-19 06:36:33',NULL),(3,'Business Name','text',NULL,'active','2025-02-05 06:44:02','2025-02-05 06:44:02',NULL),(4,'Business Name','text',NULL,'active','2025-02-05 06:44:18','2025-02-05 06:44:18',NULL),(5,'GST Number','text',NULL,'active','2025-02-05 08:48:36','2025-02-05 08:48:36',NULL),(6,'GST Number','text',NULL,'active','2025-02-05 08:48:52','2025-02-19 06:36:25',NULL),(7,'Gender','dropdown',NULL,'active','2025-02-05 08:49:50','2025-02-05 08:49:50',NULL),(10,'Demo','text',NULL,'active','2025-02-19 06:21:47','2025-02-20 05:25:57',NULL),(11,'Bird list','text',NULL,'active','2025-02-20 06:47:20','2025-02-20 10:41:48',NULL),(12,'company list','radio',NULL,'active','2025-02-20 06:54:50','2025-03-03 06:38:41',NULL),(13,'vehicle list','checkbox',NULL,'active','2025-02-20 06:55:29','2025-02-20 06:55:29',NULL),(14,'city name list','checkbox',NULL,'active','2025-02-20 06:56:13','2025-03-03 06:39:03',NULL);

--
-- Table structure for table `verify_customer_values`
--

CREATE TABLE `verify_customer_values` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `verify_customer_id` bigint unsigned NOT NULL,
  `verify_customer_form_id` bigint unsigned NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_id` (`verify_customer_id`,`verify_customer_form_id`),
  KEY `verify_customer_values_verify_customer_form_id_foreign` (`verify_customer_form_id`),
  CONSTRAINT `verify_customer_values_verify_customer_form_id_foreign` FOREIGN KEY (`verify_customer_form_id`) REFERENCES `verify_customer_forms` (`id`) ON DELETE CASCADE,
  CONSTRAINT `verify_customer_values_verify_customer_id_foreign` FOREIGN KEY (`verify_customer_id`) REFERENCES `verify_customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `verify_customer_values`
--


--
-- Table structure for table `verify_customers`
--

CREATE TABLE `verify_customers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `status` enum('failed','success','pending') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `verify_customers_user_id_foreign` (`user_id`),
  CONSTRAINT `verify_customers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `verify_customers`
--



