--
-- Host: 127.0.0.1    Database: homzen
-- ------------------------------------------------------


--
-- Table structure for table `activations`
--

CREATE TABLE `activations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `code` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT '0',
  `completed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activations_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activations`
--

INSERT INTO `activations` VALUES (1,1,'o9WzWMv7MTVsRcrkRKaZxwSxloauLARf',1,'2025-02-24 18:30:35','2025-02-24 18:30:35','2025-02-24 18:30:35');

--
-- Table structure for table `admin_notifications`
--

CREATE TABLE `admin_notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `action_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `permission` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_notifications`
--


--
-- Table structure for table `ads`
--

CREATE TABLE `ads` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expired_at` datetime DEFAULT NULL,
  `location` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `key` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clicked` bigint NOT NULL DEFAULT '0',
  `order` int DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `open_in_new_tab` tinyint(1) NOT NULL DEFAULT '1',
  `tablet_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ads_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `google_adsense_slot_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ads_key_unique` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ads`
--


--
-- Table structure for table `ads_translations`
--

CREATE TABLE `ads_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ads_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`ads_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ads_translations`
--


--
-- Table structure for table `announcements`
--

CREATE TABLE `announcements` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `has_action` tinyint(1) NOT NULL DEFAULT '0',
  `action_label` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action_url` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action_open_new_tab` tinyint(1) NOT NULL DEFAULT '0',
  `dismissible` tinyint(1) NOT NULL DEFAULT '0',
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `announcements`
--

INSERT INTO `announcements` VALUES (1,'Announcement 1','Explore Our Exciting New Property Listings Now Available in Prime Locations!',0,NULL,NULL,0,1,'2025-02-25 01:30:51',NULL,1,'2025-02-24 18:30:51','2025-02-24 18:30:51'),(2,'Announcement 2','Join Us for Exclusive Open House Events This Weekend and Find Your Perfect Home!',0,NULL,NULL,0,1,'2025-02-25 01:30:51',NULL,1,'2025-02-24 18:30:51','2025-02-24 18:30:51'),(3,'Announcement 3','Take Advantage of Limited-Time Offers on Luxury Homes with Stunning Features!',0,NULL,NULL,0,1,'2025-02-25 01:30:51',NULL,1,'2025-02-24 18:30:51','2025-02-24 18:30:51'),(4,'Announcement 4','Discover Your Dream Home with Our Latest Listings and Personalized Services!',0,NULL,NULL,0,1,'2025-02-25 01:30:51',NULL,1,'2025-02-24 18:30:51','2025-02-24 18:30:51');

--
-- Table structure for table `announcements_translations`
--

CREATE TABLE `announcements_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `announcements_id` bigint unsigned NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `action_label` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`announcements_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `announcements_translations`
--


--
-- Table structure for table `audit_histories`
--

CREATE TABLE `audit_histories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `module` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `request` longtext COLLATE utf8mb4_unicode_ci,
  `action` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_user` bigint unsigned NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `reference_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `audit_histories_user_id_index` (`user_id`),
  KEY `audit_histories_module_index` (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit_histories`
--


--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache`
--


--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache_locks`
--


--
-- Table structure for table `careers`
--

CREATE TABLE `careers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `salary` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `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 `careers`
--

INSERT INTO `careers` VALUES (1,'Senior Full Stack Engineer, Creator Success Full Time','Macejkovicmouth, Honduras','$8,352','Constantly changing work patterns and norms, and the need for organizational resiliency','<h4 class=\"color-brand-1\">Responsibilities</h4>\n<p>Product knowledge: Deeply understand the technology and features of the product area to which you are assigned.</p>\n<p>Research: Provide human and business impact and insights for products.</p>\n<p>Deliverables: Create deliverables for your product area (for example competitive analyses, user flows, low fidelity wireframes, high fidelity mockups, prototypes, etc.) that solve real user problems through the user experience.</p>\n<p>Communication: Communicate the results of UX activities within your product area to the design team department, cross-functional partners within your product area, and other interested Superformula team members using clear language that simplifies complexity.</p>\n<h4 class=\"color-brand-1\">Requirements</h4>\n<ul>\n    <li>A portfolio demonstrating well thought through and polished end to end customer journeys</li>\n    <li>5+ years of industry experience in interactive design and / or visual design</li>\n    <li>Excellent interpersonal skills </li>\n    <li>Aware of trends in mobile, communications, and collaboration</li>\n    <li>Ability to create highly polished design prototypes, mockups, and other communication artifacts</li>\n    <li>The ability to scope and estimate efforts accurately and prioritize tasks and goals independently</li>\n    <li>History of impacting shipping products with your work</li>\n    <li>A Bachelor’s Degree in Design (or related field) or equivalent professional experience</li>\n    <li>Proficiency in a variety of design tools such as Figma, Photoshop, Illustrator, and Sketch</li>\n</ul>\n<h4 class=\"color-brand-1\">What\'s on Offer </h4>\n<ul>\n    <li>Annual bonus and holidays, social welfare, and health checks.</li>\n    <li>Training and attachment in Taiwan and other Greater China branches.</li>\n</ul>\n','published','2025-02-24 18:30:51','2025-02-24 18:30:51'),(2,'Data Science Specialist, Analytics Division','New Nedmouth, Falkland Islands (Malvinas)','$1,564','Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit laborum — semper quis lectus nulla','<h4 class=\"color-brand-1\">Responsibilities</h4>\n<p>Product knowledge: Deeply understand the technology and features of the product area to which you are assigned.</p>\n<p>Research: Provide human and business impact and insights for products.</p>\n<p>Deliverables: Create deliverables for your product area (for example competitive analyses, user flows, low fidelity wireframes, high fidelity mockups, prototypes, etc.) that solve real user problems through the user experience.</p>\n<p>Communication: Communicate the results of UX activities within your product area to the design team department, cross-functional partners within your product area, and other interested Superformula team members using clear language that simplifies complexity.</p>\n<h4 class=\"color-brand-1\">Requirements</h4>\n<ul>\n    <li>A portfolio demonstrating well thought through and polished end to end customer journeys</li>\n    <li>5+ years of industry experience in interactive design and / or visual design</li>\n    <li>Excellent interpersonal skills </li>\n    <li>Aware of trends in mobile, communications, and collaboration</li>\n    <li>Ability to create highly polished design prototypes, mockups, and other communication artifacts</li>\n    <li>The ability to scope and estimate efforts accurately and prioritize tasks and goals independently</li>\n    <li>History of impacting shipping products with your work</li>\n    <li>A Bachelor’s Degree in Design (or related field) or equivalent professional experience</li>\n    <li>Proficiency in a variety of design tools such as Figma, Photoshop, Illustrator, and Sketch</li>\n</ul>\n<h4 class=\"color-brand-1\">What\'s on Offer </h4>\n<ul>\n    <li>Annual bonus and holidays, social welfare, and health checks.</li>\n    <li>Training and attachment in Taiwan and other Greater China branches.</li>\n</ul>\n','published','2025-02-24 18:30:51','2025-02-24 18:30:51'),(3,'Product Marketing Manager, Growth Team','Agnesbury, Chad','$4,713','Crafting compelling marketing strategies to drive user acquisition and retention','<h4 class=\"color-brand-1\">Responsibilities</h4>\n<p>Product knowledge: Deeply understand the technology and features of the product area to which you are assigned.</p>\n<p>Research: Provide human and business impact and insights for products.</p>\n<p>Deliverables: Create deliverables for your product area (for example competitive analyses, user flows, low fidelity wireframes, high fidelity mockups, prototypes, etc.) that solve real user problems through the user experience.</p>\n<p>Communication: Communicate the results of UX activities within your product area to the design team department, cross-functional partners within your product area, and other interested Superformula team members using clear language that simplifies complexity.</p>\n<h4 class=\"color-brand-1\">Requirements</h4>\n<ul>\n    <li>A portfolio demonstrating well thought through and polished end to end customer journeys</li>\n    <li>5+ years of industry experience in interactive design and / or visual design</li>\n    <li>Excellent interpersonal skills </li>\n    <li>Aware of trends in mobile, communications, and collaboration</li>\n    <li>Ability to create highly polished design prototypes, mockups, and other communication artifacts</li>\n    <li>The ability to scope and estimate efforts accurately and prioritize tasks and goals independently</li>\n    <li>History of impacting shipping products with your work</li>\n    <li>A Bachelor’s Degree in Design (or related field) or equivalent professional experience</li>\n    <li>Proficiency in a variety of design tools such as Figma, Photoshop, Illustrator, and Sketch</li>\n</ul>\n<h4 class=\"color-brand-1\">What\'s on Offer </h4>\n<ul>\n    <li>Annual bonus and holidays, social welfare, and health checks.</li>\n    <li>Training and attachment in Taiwan and other Greater China branches.</li>\n</ul>\n','published','2025-02-24 18:30:51','2025-02-24 18:30:51'),(4,'UX/UI Designer, User Experience Team','Port Maxie, Bangladesh','$8,850','Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','<h4 class=\"color-brand-1\">Responsibilities</h4>\n<p>Product knowledge: Deeply understand the technology and features of the product area to which you are assigned.</p>\n<p>Research: Provide human and business impact and insights for products.</p>\n<p>Deliverables: Create deliverables for your product area (for example competitive analyses, user flows, low fidelity wireframes, high fidelity mockups, prototypes, etc.) that solve real user problems through the user experience.</p>\n<p>Communication: Communicate the results of UX activities within your product area to the design team department, cross-functional partners within your product area, and other interested Superformula team members using clear language that simplifies complexity.</p>\n<h4 class=\"color-brand-1\">Requirements</h4>\n<ul>\n    <li>A portfolio demonstrating well thought through and polished end to end customer journeys</li>\n    <li>5+ years of industry experience in interactive design and / or visual design</li>\n    <li>Excellent interpersonal skills </li>\n    <li>Aware of trends in mobile, communications, and collaboration</li>\n    <li>Ability to create highly polished design prototypes, mockups, and other communication artifacts</li>\n    <li>The ability to scope and estimate efforts accurately and prioritize tasks and goals independently</li>\n    <li>History of impacting shipping products with your work</li>\n    <li>A Bachelor’s Degree in Design (or related field) or equivalent professional experience</li>\n    <li>Proficiency in a variety of design tools such as Figma, Photoshop, Illustrator, and Sketch</li>\n</ul>\n<h4 class=\"color-brand-1\">What\'s on Offer </h4>\n<ul>\n    <li>Annual bonus and holidays, social welfare, and health checks.</li>\n    <li>Training and attachment in Taiwan and other Greater China branches.</li>\n</ul>\n','published','2025-02-24 18:30:51','2025-02-24 18:30:51'),(5,'Operations Manager, Supply Chain Division','East Aurorebury, Cape Verde','$9,799','Ensuring smooth and efficient supply chain operations for timely product delivery','<h4 class=\"color-brand-1\">Responsibilities</h4>\n<p>Product knowledge: Deeply understand the technology and features of the product area to which you are assigned.</p>\n<p>Research: Provide human and business impact and insights for products.</p>\n<p>Deliverables: Create deliverables for your product area (for example competitive analyses, user flows, low fidelity wireframes, high fidelity mockups, prototypes, etc.) that solve real user problems through the user experience.</p>\n<p>Communication: Communicate the results of UX activities within your product area to the design team department, cross-functional partners within your product area, and other interested Superformula team members using clear language that simplifies complexity.</p>\n<h4 class=\"color-brand-1\">Requirements</h4>\n<ul>\n    <li>A portfolio demonstrating well thought through and polished end to end customer journeys</li>\n    <li>5+ years of industry experience in interactive design and / or visual design</li>\n    <li>Excellent interpersonal skills </li>\n    <li>Aware of trends in mobile, communications, and collaboration</li>\n    <li>Ability to create highly polished design prototypes, mockups, and other communication artifacts</li>\n    <li>The ability to scope and estimate efforts accurately and prioritize tasks and goals independently</li>\n    <li>History of impacting shipping products with your work</li>\n    <li>A Bachelor’s Degree in Design (or related field) or equivalent professional experience</li>\n    <li>Proficiency in a variety of design tools such as Figma, Photoshop, Illustrator, and Sketch</li>\n</ul>\n<h4 class=\"color-brand-1\">What\'s on Offer </h4>\n<ul>\n    <li>Annual bonus and holidays, social welfare, and health checks.</li>\n    <li>Training and attachment in Taiwan and other Greater China branches.</li>\n</ul>\n','published','2025-02-24 18:30:51','2025-02-24 18:30:51'),(6,'Financial Analyst, Investment Group','South Adolfoland, Christmas Island','$8,599','Analyzing market trends and investment opportunities for optimal financial outcomes','<h4 class=\"color-brand-1\">Responsibilities</h4>\n<p>Product knowledge: Deeply understand the technology and features of the product area to which you are assigned.</p>\n<p>Research: Provide human and business impact and insights for products.</p>\n<p>Deliverables: Create deliverables for your product area (for example competitive analyses, user flows, low fidelity wireframes, high fidelity mockups, prototypes, etc.) that solve real user problems through the user experience.</p>\n<p>Communication: Communicate the results of UX activities within your product area to the design team department, cross-functional partners within your product area, and other interested Superformula team members using clear language that simplifies complexity.</p>\n<h4 class=\"color-brand-1\">Requirements</h4>\n<ul>\n    <li>A portfolio demonstrating well thought through and polished end to end customer journeys</li>\n    <li>5+ years of industry experience in interactive design and / or visual design</li>\n    <li>Excellent interpersonal skills </li>\n    <li>Aware of trends in mobile, communications, and collaboration</li>\n    <li>Ability to create highly polished design prototypes, mockups, and other communication artifacts</li>\n    <li>The ability to scope and estimate efforts accurately and prioritize tasks and goals independently</li>\n    <li>History of impacting shipping products with your work</li>\n    <li>A Bachelor’s Degree in Design (or related field) or equivalent professional experience</li>\n    <li>Proficiency in a variety of design tools such as Figma, Photoshop, Illustrator, and Sketch</li>\n</ul>\n<h4 class=\"color-brand-1\">What\'s on Offer </h4>\n<ul>\n    <li>Annual bonus and holidays, social welfare, and health checks.</li>\n    <li>Training and attachment in Taiwan and other Greater China branches.</li>\n</ul>\n','published','2025-02-24 18:30:51','2025-02-24 18:30:51');

--
-- Table structure for table `careers_translations`
--

CREATE TABLE `careers_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `careers_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `salary` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`careers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `careers_translations`
--


--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` bigint unsigned NOT NULL DEFAULT '0',
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `author_id` bigint unsigned DEFAULT NULL,
  `author_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Botble\\ACL\\Models\\User',
  `icon` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int unsigned NOT NULL DEFAULT '0',
  `is_featured` tinyint NOT NULL DEFAULT '0',
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `categories_parent_id_index` (`parent_id`),
  KEY `categories_status_index` (`status`),
  KEY `categories_created_at_index` (`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1,'Buying a Home',0,'Vero temporibus possimus corrupti. Fugiat voluptatem pariatur mollitia autem ea dolore est. Autem non nisi minima laudantium. Commodi amet eos molestiae corporis cupiditate unde.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,0,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(2,'Selling a Home',0,'Suscipit fugit illo expedita et. Deserunt voluptatum aut repellendus aliquam in.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(3,'Market Trends',0,'Totam fugit est esse illum minima quisquam laudantium. Ut dolor harum ut commodi itaque quidem. Maiores illo eum tenetur. Molestiae laudantium quis possimus atque.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(4,'Home Improvement',0,'Sapiente quis sunt esse placeat et soluta veniam quasi. Vel itaque assumenda ipsa rerum voluptas dolorum. Maiores iste enim voluptas optio.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(5,'Real Estate Investing',0,'Molestias fugit in quos excepturi in saepe. Nihil nemo quos quia deserunt a quod. Eum et consequatur fuga.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(6,'Neighborhood Guides',0,'Velit autem mollitia inventore autem ut. Et magnam accusamus non laboriosam dicta qui. Itaque odit sunt minima voluptatem. Distinctio quisquam porro doloremque temporibus iure et.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2025-02-24 18:30:44','2025-02-24 18:30:44');

--
-- Table structure for table `categories_translations`
--

CREATE TABLE `categories_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `categories_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`categories_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories_translations`
--


--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state_id` bigint unsigned DEFAULT NULL,
  `country_id` bigint unsigned DEFAULT NULL,
  `record_id` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `zip_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cities_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` VALUES (1,'Paris','paris',1,1,NULL,0,'locations/1.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(2,'London','london',2,2,NULL,0,'locations/4.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(3,'New York City','new-york-city',3,3,NULL,0,'locations/5.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(4,'Amsterdam','amsterdam',4,4,NULL,0,'locations/1.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(5,'Copenhagen','copenhagen',5,5,NULL,0,'locations/2.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(6,'Munich','munich',6,6,NULL,0,'locations/4.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(7,'Tokyo','tokyo',7,7,NULL,0,'locations/2.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(8,'Toronto','toronto',8,8,NULL,0,'locations/5.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(9,'Sydney','sydney',9,9,NULL,0,'locations/5.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(10,'Milan','milan',10,10,NULL,0,'locations/4.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(11,'Los Angeles','los-angeles',11,3,NULL,0,'locations/1.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(12,'Berlin','berlin',12,6,NULL,0,'locations/2.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(13,'Osaka','osaka',13,7,NULL,0,'locations/5.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(14,'Vancouver','vancouver',14,8,NULL,0,'locations/3.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(15,'Melbourne','melbourne',15,9,NULL,0,'locations/1.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(16,'Rome','rome',16,10,NULL,0,'locations/2.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(17,'Marseille','marseille',17,1,NULL,0,'locations/3.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(18,'Liverpool','liverpool',18,2,NULL,0,'locations/5.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(19,'Chicago','chicago',19,3,NULL,0,'locations/3.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(20,'Rotterdam','rotterdam',20,4,NULL,0,'locations/5.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(21,'Aarhus','aarhus',21,5,NULL,0,'locations/3.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(22,'Frankfurt','frankfurt',22,6,NULL,0,'locations/1.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(23,'Kyoto','kyoto',23,7,NULL,0,'locations/2.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(24,'Montreal','montreal',24,8,NULL,0,'locations/1.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(25,'Brisbane','brisbane',25,9,NULL,0,'locations/5.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(26,'Naples','naples',26,10,NULL,0,'locations/2.jpg',0,'published','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL);

--
-- Table structure for table `cities_translations`
--

CREATE TABLE `cities_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cities_id` bigint unsigned NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`cities_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities_translations`
--


--
-- Table structure for table `contact_custom_field_options`
--

CREATE TABLE `contact_custom_field_options` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `custom_field_id` bigint unsigned NOT NULL,
  `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL DEFAULT '999',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_custom_field_options`
--


--
-- Table structure for table `contact_custom_field_options_translations`
--

CREATE TABLE `contact_custom_field_options_translations` (
  `contact_custom_field_options_id` bigint unsigned NOT NULL,
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`contact_custom_field_options_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_custom_field_options_translations`
--


--
-- Table structure for table `contact_custom_fields`
--

CREATE TABLE `contact_custom_fields` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `placeholder` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int NOT NULL DEFAULT '999',
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_custom_fields`
--


--
-- Table structure for table `contact_custom_fields_translations`
--

CREATE TABLE `contact_custom_fields_translations` (
  `contact_custom_fields_id` bigint unsigned NOT NULL,
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `placeholder` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`contact_custom_fields_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_custom_fields_translations`
--


--
-- Table structure for table `contact_replies`
--

CREATE TABLE `contact_replies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_replies`
--


--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_fields` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unread',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contacts`
--


--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nationality` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1,'France','French',0,NULL,0,'published',NULL,NULL,'FRA'),(2,'England','English',0,NULL,0,'published',NULL,NULL,'UK'),(3,'USA','Americans',0,NULL,0,'published',NULL,NULL,'US'),(4,'Holland','Dutch',0,NULL,0,'published',NULL,NULL,'HL'),(5,'Denmark','Danish',0,NULL,0,'published',NULL,NULL,'DN'),(6,'Germany','German',0,NULL,0,'published',NULL,NULL,'DE'),(7,'Japan','Japanese',0,NULL,0,'published',NULL,NULL,'JP'),(8,'Canada','Canadian',0,NULL,0,'published',NULL,NULL,'CA'),(9,'Australia','Australian',0,NULL,0,'published',NULL,NULL,'AU'),(10,'Italy','Italian',0,NULL,0,'published',NULL,NULL,'IT');

--
-- Table structure for table `countries_translations`
--

CREATE TABLE `countries_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `countries_id` bigint unsigned NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nationality` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`countries_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries_translations`
--


--
-- Table structure for table `dashboard_widget_settings`
--

CREATE TABLE `dashboard_widget_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `settings` text COLLATE utf8mb4_unicode_ci,
  `user_id` bigint unsigned NOT NULL,
  `widget_id` bigint unsigned NOT NULL,
  `order` tinyint unsigned NOT NULL DEFAULT '0',
  `status` tinyint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dashboard_widget_settings_user_id_index` (`user_id`),
  KEY `dashboard_widget_settings_widget_id_index` (`widget_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dashboard_widget_settings`
--


--
-- Table structure for table `dashboard_widgets`
--

CREATE TABLE `dashboard_widgets` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dashboard_widgets`
--


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `faq_categories`
--

CREATE TABLE `faq_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faq_categories`
--

INSERT INTO `faq_categories` VALUES (1,'Buying',0,'published','2025-02-24 18:30:34','2025-02-24 18:30:34',NULL),(2,'Selling',1,'published','2025-02-24 18:30:34','2025-02-24 18:30:34',NULL),(3,'Renting',2,'published','2025-02-24 18:30:34','2025-02-24 18:30:34',NULL),(4,'Financing',3,'published','2025-02-24 18:30:34','2025-02-24 18:30:34',NULL);

--
-- Table structure for table `faq_categories_translations`
--

CREATE TABLE `faq_categories_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `faq_categories_id` bigint unsigned NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`faq_categories_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faq_categories_translations`
--


--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `question` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` bigint unsigned NOT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` VALUES (1,'What steps are involved in buying a home?','The home buying process involves several steps including getting pre-approved for a mortgage, finding a real estate agent, searching for homes, making an offer, getting a home inspection, and closing the deal.',1,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(2,'How do I determine my budget for buying a home?','To determine your budget, consider your income, debts, and savings. It is also important to get pre-approved for a mortgage to understand how much you can borrow.',1,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(3,'What is the process of selling a home?','Selling a home involves preparing your home for sale, setting a competitive price, marketing the property, showing the home to potential buyers, negotiating offers, and closing the sale.',1,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(4,'How can I increase the value of my home before selling?','You can increase your home\'s value by making necessary repairs, updating outdated features, improving curb appeal, and ensuring the home is clean and well-maintained.',1,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(5,'What should I look for in a rental property?','When looking for a rental property, consider factors such as location, rent price, amenities, lease terms, and the condition of the property. It\'s also important to understand your rights as a tenant.',1,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(6,'How do I improve my credit score for a mortgage?','To improve your credit score, pay your bills on time, reduce your debt, avoid opening new credit accounts, and check your credit report for errors.',1,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(7,'What steps are involved in buying a home?','The home buying process involves several steps including getting pre-approved for a mortgage, finding a real estate agent, searching for homes, making an offer, getting a home inspection, and closing the deal.',2,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(8,'What is the process of selling a home?','Selling a home involves preparing your home for sale, setting a competitive price, marketing the property, showing the home to potential buyers, negotiating offers, and closing the sale.',2,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(9,'How can I increase the value of my home before selling?','You can increase your home\'s value by making necessary repairs, updating outdated features, improving curb appeal, and ensuring the home is clean and well-maintained.',2,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(10,'What are the benefits of renting versus buying?','Renting offers flexibility and fewer maintenance responsibilities, while buying can provide long-term financial benefits and the freedom to customize your home. The decision depends on your financial situation, lifestyle, and future plans.',2,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(11,'What types of financing options are available for homebuyers?','Common financing options include fixed-rate mortgages, adjustable-rate mortgages, FHA loans, VA loans, and USDA loans. Each has its own requirements and benefits.',2,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(12,'How do I improve my credit score for a mortgage?','To improve your credit score, pay your bills on time, reduce your debt, avoid opening new credit accounts, and check your credit report for errors.',2,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(13,'How do I determine my budget for buying a home?','To determine your budget, consider your income, debts, and savings. It is also important to get pre-approved for a mortgage to understand how much you can borrow.',3,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(14,'What is the process of selling a home?','Selling a home involves preparing your home for sale, setting a competitive price, marketing the property, showing the home to potential buyers, negotiating offers, and closing the sale.',3,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(15,'How can I increase the value of my home before selling?','You can increase your home\'s value by making necessary repairs, updating outdated features, improving curb appeal, and ensuring the home is clean and well-maintained.',3,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(16,'What are the benefits of renting versus buying?','Renting offers flexibility and fewer maintenance responsibilities, while buying can provide long-term financial benefits and the freedom to customize your home. The decision depends on your financial situation, lifestyle, and future plans.',3,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(17,'What types of financing options are available for homebuyers?','Common financing options include fixed-rate mortgages, adjustable-rate mortgages, FHA loans, VA loans, and USDA loans. Each has its own requirements and benefits.',3,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(18,'How do I improve my credit score for a mortgage?','To improve your credit score, pay your bills on time, reduce your debt, avoid opening new credit accounts, and check your credit report for errors.',3,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(19,'What steps are involved in buying a home?','The home buying process involves several steps including getting pre-approved for a mortgage, finding a real estate agent, searching for homes, making an offer, getting a home inspection, and closing the deal.',4,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(20,'What is the process of selling a home?','Selling a home involves preparing your home for sale, setting a competitive price, marketing the property, showing the home to potential buyers, negotiating offers, and closing the sale.',4,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(21,'How can I increase the value of my home before selling?','You can increase your home\'s value by making necessary repairs, updating outdated features, improving curb appeal, and ensuring the home is clean and well-maintained.',4,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(22,'What should I look for in a rental property?','When looking for a rental property, consider factors such as location, rent price, amenities, lease terms, and the condition of the property. It\'s also important to understand your rights as a tenant.',4,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(23,'What types of financing options are available for homebuyers?','Common financing options include fixed-rate mortgages, adjustable-rate mortgages, FHA loans, VA loans, and USDA loans. Each has its own requirements and benefits.',4,'published','2025-02-24 18:30:34','2025-02-24 18:30:34'),(24,'How do I improve my credit score for a mortgage?','To improve your credit score, pay your bills on time, reduce your debt, avoid opening new credit accounts, and check your credit report for errors.',4,'published','2025-02-24 18:30:34','2025-02-24 18:30:34');

--
-- Table structure for table `faqs_translations`
--

CREATE TABLE `faqs_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `faqs_id` bigint unsigned NOT NULL,
  `question` text COLLATE utf8mb4_unicode_ci,
  `answer` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`faqs_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs_translations`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `language_meta`
--

CREATE TABLE `language_meta` (
  `lang_meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `lang_meta_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lang_meta_origin` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `reference_type` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`lang_meta_id`),
  KEY `language_meta_reference_id_index` (`reference_id`),
  KEY `meta_code_index` (`lang_meta_code`),
  KEY `meta_origin_index` (`lang_meta_origin`),
  KEY `meta_reference_type_index` (`reference_type`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `language_meta`
--

INSERT INTO `language_meta` VALUES (1,'en_US','27aabd20f785861a52207bd19119fa1b',1,'Botble\\Menu\\Models\\MenuLocation'),(2,'en_US','398ef6c288966341c4ed31c079173af1',1,'Botble\\Menu\\Models\\Menu');

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `lang_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `lang_name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang_locale` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang_flag` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lang_is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `lang_order` int NOT NULL DEFAULT '0',
  `lang_is_rtl` tinyint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`lang_id`),
  KEY `lang_locale_index` (`lang_locale`),
  KEY `lang_code_index` (`lang_code`),
  KEY `lang_is_default_index` (`lang_is_default`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES (1,'English','en','en_US','us',1,0,0);

--
-- Table structure for table `media_files`
--

CREATE TABLE `media_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `folder_id` bigint unsigned NOT NULL DEFAULT '0',
  `mime_type` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` int NOT NULL,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `visibility` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'public',
  PRIMARY KEY (`id`),
  KEY `media_files_user_id_index` (`user_id`),
  KEY `media_files_index` (`folder_id`,`user_id`,`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_files`
--

INSERT INTO `media_files` VALUES (1,0,'1','1',1,'image/jpeg',6977,'locations/1.jpg','[]','2025-02-24 18:30:34','2025-02-24 18:30:34',NULL,'public'),(2,0,'10','10',1,'image/jpeg',6977,'locations/10.jpg','[]','2025-02-24 18:30:34','2025-02-24 18:30:34',NULL,'public'),(3,0,'11','11',1,'image/jpeg',6977,'locations/11.jpg','[]','2025-02-24 18:30:34','2025-02-24 18:30:34',NULL,'public'),(4,0,'2','2',1,'image/jpeg',6977,'locations/2.jpg','[]','2025-02-24 18:30:34','2025-02-24 18:30:34',NULL,'public'),(5,0,'3','3',1,'image/jpeg',6977,'locations/3.jpg','[]','2025-02-24 18:30:34','2025-02-24 18:30:34',NULL,'public'),(6,0,'4','4',1,'image/jpeg',6977,'locations/4.jpg','[]','2025-02-24 18:30:34','2025-02-24 18:30:34',NULL,'public'),(7,0,'5','5',1,'image/jpeg',6977,'locations/5.jpg','[]','2025-02-24 18:30:34','2025-02-24 18:30:34',NULL,'public'),(8,0,'6','6',1,'image/jpeg',6977,'locations/6.jpg','[]','2025-02-24 18:30:34','2025-02-24 18:30:34',NULL,'public'),(9,0,'7','7',1,'image/jpeg',6977,'locations/7.jpg','[]','2025-02-24 18:30:34','2025-02-24 18:30:34',NULL,'public'),(10,0,'8','8',1,'image/jpeg',6977,'locations/8.jpg','[]','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL,'public'),(11,0,'9','9',1,'image/jpeg',6977,'locations/9.jpg','[]','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL,'public'),(12,0,'1','1',2,'image/jpeg',3916,'avatars/1.jpg','[]','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL,'public'),(13,0,'10','10',2,'image/jpeg',3916,'avatars/10.jpg','[]','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL,'public'),(14,0,'11','11',2,'image/jpeg',3916,'avatars/11.jpg','[]','2025-02-24 18:30:35','2025-02-24 18:30:35',NULL,'public'),(15,0,'2','2',2,'image/jpeg',3916,'avatars/2.jpg','[]','2025-02-24 18:30:36','2025-02-24 18:30:36',NULL,'public'),(16,0,'3','3',2,'image/jpeg',3916,'avatars/3.jpg','[]','2025-02-24 18:30:36','2025-02-24 18:30:36',NULL,'public'),(17,0,'4','4',2,'image/jpeg',3916,'avatars/4.jpg','[]','2025-02-24 18:30:36','2025-02-24 18:30:36',NULL,'public'),(18,0,'5','5',2,'image/jpeg',3916,'avatars/5.jpg','[]','2025-02-24 18:30:36','2025-02-24 18:30:36',NULL,'public'),(19,0,'6','6',2,'image/jpeg',3916,'avatars/6.jpg','[]','2025-02-24 18:30:36','2025-02-24 18:30:36',NULL,'public'),(20,0,'7','7',2,'image/jpeg',3916,'avatars/7.jpg','[]','2025-02-24 18:30:36','2025-02-24 18:30:36',NULL,'public'),(21,0,'8','8',2,'image/jpeg',3916,'avatars/8.jpg','[]','2025-02-24 18:30:36','2025-02-24 18:30:36',NULL,'public'),(22,0,'9','9',2,'image/jpeg',3916,'avatars/9.jpg','[]','2025-02-24 18:30:36','2025-02-24 18:30:36',NULL,'public'),(23,0,'1','1',3,'image/jpeg',9803,'properties/1.jpg','[]','2025-02-24 18:30:40','2025-02-24 18:30:40',NULL,'public'),(24,0,'10','10',3,'image/jpeg',9803,'properties/10.jpg','[]','2025-02-24 18:30:40','2025-02-24 18:30:40',NULL,'public'),(25,0,'11','11',3,'image/jpeg',9803,'properties/11.jpg','[]','2025-02-24 18:30:40','2025-02-24 18:30:40',NULL,'public'),(26,0,'12','12',3,'image/jpeg',9803,'properties/12.jpg','[]','2025-02-24 18:30:40','2025-02-24 18:30:40',NULL,'public'),(27,0,'13','13',3,'image/jpeg',9803,'properties/13.jpg','[]','2025-02-24 18:30:40','2025-02-24 18:30:40',NULL,'public'),(28,0,'2','2',3,'image/jpeg',9803,'properties/2.jpg','[]','2025-02-24 18:30:40','2025-02-24 18:30:40',NULL,'public'),(29,0,'3','3',3,'image/jpeg',9803,'properties/3.jpg','[]','2025-02-24 18:30:40','2025-02-24 18:30:40',NULL,'public'),(30,0,'4','4',3,'image/jpeg',9803,'properties/4.jpg','[]','2025-02-24 18:30:40','2025-02-24 18:30:40',NULL,'public'),(31,0,'5','5',3,'image/jpeg',9803,'properties/5.jpg','[]','2025-02-24 18:30:41','2025-02-24 18:30:41',NULL,'public'),(32,0,'6','6',3,'image/jpeg',9803,'properties/6.jpg','[]','2025-02-24 18:30:41','2025-02-24 18:30:41',NULL,'public'),(33,0,'7','7',3,'image/jpeg',9803,'properties/7.jpg','[]','2025-02-24 18:30:41','2025-02-24 18:30:41',NULL,'public'),(34,0,'8','8',3,'image/jpeg',9803,'properties/8.jpg','[]','2025-02-24 18:30:41','2025-02-24 18:30:41',NULL,'public'),(35,0,'9','9',3,'image/jpeg',9803,'properties/9.jpg','[]','2025-02-24 18:30:41','2025-02-24 18:30:41',NULL,'public'),(36,0,'floor','floor',3,'image/png',9803,'properties/floor.png','[]','2025-02-24 18:30:41','2025-02-24 18:30:41',NULL,'public'),(37,0,'1','1',4,'image/jpeg',9803,'posts/1.jpg','[]','2025-02-24 18:30:43','2025-02-24 18:30:43',NULL,'public'),(38,0,'10','10',4,'image/jpeg',9803,'posts/10.jpg','[]','2025-02-24 18:30:43','2025-02-24 18:30:43',NULL,'public'),(39,0,'2','2',4,'image/jpeg',9803,'posts/2.jpg','[]','2025-02-24 18:30:43','2025-02-24 18:30:43',NULL,'public'),(40,0,'3','3',4,'image/jpeg',9803,'posts/3.jpg','[]','2025-02-24 18:30:43','2025-02-24 18:30:43',NULL,'public'),(41,0,'4','4',4,'image/jpeg',9803,'posts/4.jpg','[]','2025-02-24 18:30:43','2025-02-24 18:30:43',NULL,'public'),(42,0,'5','5',4,'image/jpeg',9803,'posts/5.jpg','[]','2025-02-24 18:30:43','2025-02-24 18:30:43',NULL,'public'),(43,0,'6','6',4,'image/jpeg',9803,'posts/6.jpg','[]','2025-02-24 18:30:44','2025-02-24 18:30:44',NULL,'public'),(44,0,'7','7',4,'image/jpeg',9803,'posts/7.jpg','[]','2025-02-24 18:30:44','2025-02-24 18:30:44',NULL,'public'),(45,0,'8','8',4,'image/jpeg',9803,'posts/8.jpg','[]','2025-02-24 18:30:44','2025-02-24 18:30:44',NULL,'public'),(46,0,'9','9',4,'image/jpeg',9803,'posts/9.jpg','[]','2025-02-24 18:30:44','2025-02-24 18:30:44',NULL,'public'),(47,0,'md-1','md-1',4,'image/jpeg',9803,'posts/md-1.jpg','[]','2025-02-24 18:30:44','2025-02-24 18:30:44',NULL,'public'),(48,0,'md-2','md-2',4,'image/jpeg',9803,'posts/md-2.jpg','[]','2025-02-24 18:30:44','2025-02-24 18:30:44',NULL,'public'),(49,0,'about-us-contact','about-us-contact',5,'image/jpeg',19409,'pages/about-us-contact.jpg','[]','2025-02-24 18:30:45','2025-02-24 18:30:45',NULL,'public'),(50,0,'about-us-video','about-us-video',5,'image/jpeg',16191,'pages/about-us-video.jpg','[]','2025-02-24 18:30:45','2025-02-24 18:30:45',NULL,'public'),(51,0,'call-to-action','call-to-action',5,'image/png',9051,'pages/call-to-action.png','[]','2025-02-24 18:30:45','2025-02-24 18:30:45',NULL,'public'),(52,0,'house-service','house-service',5,'image/png',10923,'pages/house-service.png','[]','2025-02-24 18:30:45','2025-02-24 18:30:45',NULL,'public'),(53,0,'properties','properties',5,'image/png',16974,'pages/properties.png','[]','2025-02-24 18:30:45','2025-02-24 18:30:45',NULL,'public'),(54,0,'service-1','service-1',5,'image/png',21898,'pages/service-1.png','[]','2025-02-24 18:30:45','2025-02-24 18:30:45',NULL,'public'),(55,0,'service-2','service-2',5,'image/png',21279,'pages/service-2.png','[]','2025-02-24 18:30:46','2025-02-24 18:30:46',NULL,'public'),(56,0,'service-3','service-3',5,'image/png',23965,'pages/service-3.png','[]','2025-02-24 18:30:46','2025-02-24 18:30:46',NULL,'public'),(57,0,'service-4','service-4',5,'image/png',32050,'pages/service-4.png','[]','2025-02-24 18:30:46','2025-02-24 18:30:46',NULL,'public'),(58,0,'service-5','service-5',5,'image/png',25146,'pages/service-5.png','[]','2025-02-24 18:30:46','2025-02-24 18:30:46',NULL,'public'),(59,0,'service-6','service-6',5,'image/png',31763,'pages/service-6.png','[]','2025-02-24 18:30:46','2025-02-24 18:30:46',NULL,'public'),(60,0,'slider-1','slider-1',5,'image/jpeg',27445,'pages/slider-1.jpg','[]','2025-02-24 18:30:47','2025-02-24 18:30:47',NULL,'public'),(61,0,'slider-2','slider-2',5,'image/jpeg',23889,'pages/slider-2.jpg','[]','2025-02-24 18:30:47','2025-02-24 18:30:47',NULL,'public'),(62,0,'slider-3','slider-3',5,'image/jpeg',23889,'pages/slider-3.jpg','[]','2025-02-24 18:30:47','2025-02-24 18:30:47',NULL,'public'),(63,0,'slider-4','slider-4',5,'image/jpeg',23889,'pages/slider-4.jpg','[]','2025-02-24 18:30:47','2025-02-24 18:30:47',NULL,'public'),(64,0,'slider-5','slider-5',5,'image/jpeg',23889,'pages/slider-5.jpg','[]','2025-02-24 18:30:48','2025-02-24 18:30:48',NULL,'public'),(65,0,'slider-6','slider-6',5,'image/png',33637,'pages/slider-6.png','[]','2025-02-24 18:30:48','2025-02-24 18:30:48',NULL,'public'),(66,0,'slider-left','slider-left',5,'image/jpeg',11483,'pages/slider-left.jpg','[]','2025-02-24 18:30:48','2025-02-24 18:30:48',NULL,'public'),(67,0,'testimonial-banner','testimonial-banner',5,'image/png',13232,'pages/testimonial-banner.png','[]','2025-02-24 18:30:48','2025-02-24 18:30:48',NULL,'public'),(68,0,'asana','asana',6,'image/png',3510,'partners/asana.png','[]','2025-02-24 18:30:49','2025-02-24 18:30:49',NULL,'public'),(69,0,'github','github',6,'image/png',3510,'partners/github.png','[]','2025-02-24 18:30:49','2025-02-24 18:30:49',NULL,'public'),(70,0,'lhtech','lhtech',6,'image/png',3510,'partners/lhtech.png','[]','2025-02-24 18:30:49','2025-02-24 18:30:49',NULL,'public'),(71,0,'panadoxn','panadoxn',6,'image/png',3510,'partners/panadoxn.png','[]','2025-02-24 18:30:49','2025-02-24 18:30:49',NULL,'public'),(72,0,'shangxi','shangxi',6,'image/png',3510,'partners/shangxi.png','[]','2025-02-24 18:30:49','2025-02-24 18:30:49',NULL,'public'),(73,0,'tyaalpha','tyaalpha',6,'image/png',3510,'partners/tyaalpha.png','[]','2025-02-24 18:30:49','2025-02-24 18:30:49',NULL,'public'),(74,0,'vanfaba','vanfaba',6,'image/png',3510,'partners/vanfaba.png','[]','2025-02-24 18:30:49','2025-02-24 18:30:49',NULL,'public'),(75,0,'banner-footer','banner-footer',7,'image/png',92460,'general/banner-footer.png','[]','2025-02-24 18:30:49','2025-02-24 18:30:49',NULL,'public'),(76,0,'favicon','favicon',7,'image/png',1899,'general/favicon.png','[]','2025-02-24 18:30:50','2025-02-24 18:30:50',NULL,'public'),(77,0,'logo-light','logo-light',7,'image/png',4519,'general/logo-light.png','[]','2025-02-24 18:30:50','2025-02-24 18:30:50',NULL,'public'),(78,0,'logo','logo',7,'image/png',5451,'general/logo.png','[]','2025-02-24 18:30:50','2025-02-24 18:30:50',NULL,'public'),(79,0,'newsletter-image','newsletter-image',7,'image/jpeg',100774,'general/newsletter-image.jpg','[]','2025-02-24 18:30:50','2025-02-24 18:30:50',NULL,'public'),(80,0,'placeholder','placeholder',7,'image/png',12344,'general/placeholder.png','[]','2025-02-24 18:30:50','2025-02-24 18:30:50',NULL,'public');

--
-- Table structure for table `media_folders`
--

CREATE TABLE `media_folders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_folders_user_id_index` (`user_id`),
  KEY `media_folders_index` (`parent_id`,`user_id`,`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_folders`
--

INSERT INTO `media_folders` VALUES (1,0,'locations',NULL,'locations',0,'2025-02-24 18:30:34','2025-02-24 18:30:34',NULL),(2,0,'avatars',NULL,'avatars',0,'2025-02-24 18:30:35','2025-02-24 18:30:35',NULL),(3,0,'properties',NULL,'properties',0,'2025-02-24 18:30:40','2025-02-24 18:30:40',NULL),(4,0,'posts',NULL,'posts',0,'2025-02-24 18:30:43','2025-02-24 18:30:43',NULL),(5,0,'pages',NULL,'pages',0,'2025-02-24 18:30:45','2025-02-24 18:30:45',NULL),(6,0,'partners',NULL,'partners',0,'2025-02-24 18:30:49','2025-02-24 18:30:49',NULL),(7,0,'general',NULL,'general',0,'2025-02-24 18:30:49','2025-02-24 18:30:49',NULL);

--
-- Table structure for table `media_settings`
--

CREATE TABLE `media_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `media_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_settings`
--


--
-- Table structure for table `menu_locations`
--

CREATE TABLE `menu_locations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` bigint unsigned NOT NULL,
  `location` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `menu_locations_menu_id_created_at_index` (`menu_id`,`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_locations`
--

INSERT INTO `menu_locations` VALUES (1,1,'main-menu','2025-02-24 18:30:49','2025-02-24 18:30:49');

--
-- Table structure for table `menu_nodes`
--

CREATE TABLE `menu_nodes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` bigint unsigned NOT NULL,
  `parent_id` bigint unsigned NOT NULL DEFAULT '0',
  `reference_id` bigint unsigned DEFAULT NULL,
  `reference_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon_font` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` tinyint unsigned NOT NULL DEFAULT '0',
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `css_class` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self',
  `has_child` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `menu_nodes_menu_id_index` (`menu_id`),
  KEY `menu_nodes_parent_id_index` (`parent_id`),
  KEY `reference_id` (`reference_id`),
  KEY `reference_type` (`reference_type`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_nodes`
--

INSERT INTO `menu_nodes` VALUES (1,1,0,NULL,NULL,NULL,NULL,0,'Home',NULL,'_self',1,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(2,1,1,1,'Botble\\Page\\Models\\Page','/homepage-1',NULL,0,'Homepage 1',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(3,1,1,2,'Botble\\Page\\Models\\Page','/homepage-2',NULL,0,'Homepage 2',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(4,1,1,3,'Botble\\Page\\Models\\Page','/homepage-3',NULL,0,'Homepage 3',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(5,1,1,4,'Botble\\Page\\Models\\Page','/homepage-4',NULL,0,'Homepage 4',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(6,1,1,5,'Botble\\Page\\Models\\Page','/homepage-5',NULL,0,'Homepage 5',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(7,1,0,NULL,NULL,'/projects',NULL,0,'Projects',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(8,1,0,NULL,NULL,'/properties',NULL,0,'Properties',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(9,1,0,NULL,NULL,'#',NULL,0,'Pages',NULL,'_self',1,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(10,1,9,NULL,NULL,'/agents',NULL,0,'Agents',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(11,1,9,NULL,NULL,'/careers',NULL,0,'Careers',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(12,1,9,NULL,NULL,'/wishlist',NULL,0,'Wishlist',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(13,1,9,10,'Botble\\Page\\Models\\Page','/about-us',NULL,0,'About Us',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(14,1,9,8,'Botble\\Page\\Models\\Page','/our-services',NULL,0,'Our Services',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(15,1,9,11,'Botble\\Page\\Models\\Page','/pricing-plans',NULL,0,'Pricing',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(16,1,9,7,'Botble\\Page\\Models\\Page','/contact-us',NULL,0,'Contact Us',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(17,1,9,9,'Botble\\Page\\Models\\Page','/faqs',NULL,0,'FAQs',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(18,1,9,12,'Botble\\Page\\Models\\Page','/privacy-policy',NULL,0,'Privacy Policy',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(19,1,9,13,'Botble\\Page\\Models\\Page','/coming-soon',NULL,0,'Coming Soon',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(20,1,0,NULL,NULL,'#',NULL,0,'Blog',NULL,'_self',1,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(21,1,20,6,'Botble\\Page\\Models\\Page','/blog',NULL,0,'Blog List',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49'),(22,1,20,NULL,NULL,'/news/the-benefits-of-smart-home-technology',NULL,0,'Blog Detail',NULL,'_self',0,'2025-02-24 18:30:49','2025-02-24 18:30:49');

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `menus_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` VALUES (1,'Main menu','main-menu','published','2025-02-24 18:30:49','2025-02-24 18:30:49');

--
-- Table structure for table `meta_boxes`
--

CREATE TABLE `meta_boxes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `meta_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_value` text COLLATE utf8mb4_unicode_ci,
  `reference_id` bigint unsigned NOT NULL,
  `reference_type` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `meta_boxes_reference_id_index` (`reference_id`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `meta_boxes`
--

INSERT INTO `meta_boxes` VALUES (1,'icon','[\"ti ti-bell\"]',1,'Botble\\RealEstate\\Models\\Category','2025-02-24 18:30:35','2025-02-24 18:30:35'),(2,'icon','[\"ti ti-map\"]',2,'Botble\\RealEstate\\Models\\Category','2025-02-24 18:30:35','2025-02-24 18:30:35'),(3,'icon','[\"ti ti-shopping-cart\"]',3,'Botble\\RealEstate\\Models\\Category','2025-02-24 18:30:35','2025-02-24 18:30:35'),(4,'icon','[\"ti ti-chart-bar\"]',4,'Botble\\RealEstate\\Models\\Category','2025-02-24 18:30:35','2025-02-24 18:30:35'),(5,'icon','[\"ti ti-calendar\"]',5,'Botble\\RealEstate\\Models\\Category','2025-02-24 18:30:35','2025-02-24 18:30:35'),(6,'icon','[\"ti ti-mail\"]',6,'Botble\\RealEstate\\Models\\Category','2025-02-24 18:30:35','2025-02-24 18:30:35'),(7,'social_links','[[[{\"key\":\"name\",\"value\":\"Facebook\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-facebook\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.facebook.com\\/\"}],[{\"key\":\"name\",\"value\":\"Instagram\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-instagram\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.instagram.com\\/\"}],[{\"key\":\"name\",\"value\":\"Twitter\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-x\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.twitter.com\\/\"}],[{\"key\":\"name\",\"value\":\"YouTube\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-youtube\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.youtube.com\\/\"}]]]',1,'Botble\\RealEstate\\Models\\Account','2025-02-24 18:30:36','2025-02-24 18:30:36'),(8,'social_links','[[[{\"key\":\"name\",\"value\":\"Facebook\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-facebook\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.facebook.com\\/\"}],[{\"key\":\"name\",\"value\":\"Instagram\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-instagram\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.instagram.com\\/\"}],[{\"key\":\"name\",\"value\":\"Twitter\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-x\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.twitter.com\\/\"}],[{\"key\":\"name\",\"value\":\"YouTube\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-youtube\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.youtube.com\\/\"}]]]',2,'Botble\\RealEstate\\Models\\Account','2025-02-24 18:30:37','2025-02-24 18:30:37'),(9,'social_links','[[[{\"key\":\"name\",\"value\":\"Facebook\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-facebook\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.facebook.com\\/\"}],[{\"key\":\"name\",\"value\":\"Instagram\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-instagram\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.instagram.com\\/\"}],[{\"key\":\"name\",\"value\":\"Twitter\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-x\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.twitter.com\\/\"}],[{\"key\":\"name\",\"value\":\"YouTube\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-youtube\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.youtube.com\\/\"}]]]',3,'Botble\\RealEstate\\Models\\Account','2025-02-24 18:30:37','2025-02-24 18:30:37'),(10,'social_links','[[[{\"key\":\"name\",\"value\":\"Facebook\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-facebook\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.facebook.com\\/\"}],[{\"key\":\"name\",\"value\":\"Instagram\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-instagram\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.instagram.com\\/\"}],[{\"key\":\"name\",\"value\":\"Twitter\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-x\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.twitter.com\\/\"}],[{\"key\":\"name\",\"value\":\"YouTube\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-youtube\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.youtube.com\\/\"}]]]',4,'Botble\\RealEstate\\Models\\Account','2025-02-24 18:30:37','2025-02-24 18:30:37'),(11,'social_links','[[[{\"key\":\"name\",\"value\":\"Facebook\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-facebook\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.facebook.com\\/\"}],[{\"key\":\"name\",\"value\":\"Instagram\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-instagram\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.instagram.com\\/\"}],[{\"key\":\"name\",\"value\":\"Twitter\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-x\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.twitter.com\\/\"}],[{\"key\":\"name\",\"value\":\"YouTube\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-youtube\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.youtube.com\\/\"}]]]',5,'Botble\\RealEstate\\Models\\Account','2025-02-24 18:30:38','2025-02-24 18:30:38'),(12,'social_links','[[[{\"key\":\"name\",\"value\":\"Facebook\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-facebook\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.facebook.com\\/\"}],[{\"key\":\"name\",\"value\":\"Instagram\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-instagram\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.instagram.com\\/\"}],[{\"key\":\"name\",\"value\":\"Twitter\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-x\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.twitter.com\\/\"}],[{\"key\":\"name\",\"value\":\"YouTube\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-youtube\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.youtube.com\\/\"}]]]',6,'Botble\\RealEstate\\Models\\Account','2025-02-24 18:30:38','2025-02-24 18:30:38'),(13,'social_links','[[[{\"key\":\"name\",\"value\":\"Facebook\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-facebook\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.facebook.com\\/\"}],[{\"key\":\"name\",\"value\":\"Instagram\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-instagram\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.instagram.com\\/\"}],[{\"key\":\"name\",\"value\":\"Twitter\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-x\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.twitter.com\\/\"}],[{\"key\":\"name\",\"value\":\"YouTube\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-youtube\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.youtube.com\\/\"}]]]',7,'Botble\\RealEstate\\Models\\Account','2025-02-24 18:30:38','2025-02-24 18:30:38'),(14,'social_links','[[[{\"key\":\"name\",\"value\":\"Facebook\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-facebook\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.facebook.com\\/\"}],[{\"key\":\"name\",\"value\":\"Instagram\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-instagram\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.instagram.com\\/\"}],[{\"key\":\"name\",\"value\":\"Twitter\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-x\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.twitter.com\\/\"}],[{\"key\":\"name\",\"value\":\"YouTube\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-youtube\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.youtube.com\\/\"}]]]',8,'Botble\\RealEstate\\Models\\Account','2025-02-24 18:30:39','2025-02-24 18:30:39'),(15,'social_links','[[[{\"key\":\"name\",\"value\":\"Facebook\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-facebook\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.facebook.com\\/\"}],[{\"key\":\"name\",\"value\":\"Instagram\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-instagram\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.instagram.com\\/\"}],[{\"key\":\"name\",\"value\":\"Twitter\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-x\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.twitter.com\\/\"}],[{\"key\":\"name\",\"value\":\"YouTube\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-youtube\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.youtube.com\\/\"}]]]',9,'Botble\\RealEstate\\Models\\Account','2025-02-24 18:30:39','2025-02-24 18:30:39'),(16,'social_links','[[[{\"key\":\"name\",\"value\":\"Facebook\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-facebook\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.facebook.com\\/\"}],[{\"key\":\"name\",\"value\":\"Instagram\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-instagram\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.instagram.com\\/\"}],[{\"key\":\"name\",\"value\":\"Twitter\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-x\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.twitter.com\\/\"}],[{\"key\":\"name\",\"value\":\"YouTube\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-youtube\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.youtube.com\\/\"}]]]',10,'Botble\\RealEstate\\Models\\Account','2025-02-24 18:30:39','2025-02-24 18:30:39'),(17,'social_links','[[[{\"key\":\"name\",\"value\":\"Facebook\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-facebook\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.facebook.com\\/\"}],[{\"key\":\"name\",\"value\":\"Instagram\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-instagram\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.instagram.com\\/\"}],[{\"key\":\"name\",\"value\":\"Twitter\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-x\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.twitter.com\\/\"}],[{\"key\":\"name\",\"value\":\"YouTube\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-youtube\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.youtube.com\\/\"}]]]',11,'Botble\\RealEstate\\Models\\Account','2025-02-24 18:30:39','2025-02-24 18:30:39'),(18,'social_links','[[[{\"key\":\"name\",\"value\":\"Facebook\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-facebook\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.facebook.com\\/\"}],[{\"key\":\"name\",\"value\":\"Instagram\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-instagram\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.instagram.com\\/\"}],[{\"key\":\"name\",\"value\":\"Twitter\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-x\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.twitter.com\\/\"}],[{\"key\":\"name\",\"value\":\"YouTube\"},{\"key\":\"icon\",\"value\":\"ti ti-brand-youtube\"},{\"key\":\"url\",\"value\":\"https:\\/\\/www.youtube.com\\/\"}]]]',12,'Botble\\RealEstate\\Models\\Account','2025-02-24 18:30:40','2025-02-24 18:30:40'),(19,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',1,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(20,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',2,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(21,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',3,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(22,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',4,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(23,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',5,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(24,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',6,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(25,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',7,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(26,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',8,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(27,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',9,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(28,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',10,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(29,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',11,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(30,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',12,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(31,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',13,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(32,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',14,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(33,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',15,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(34,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',16,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(35,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',17,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(36,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',18,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(37,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',19,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(38,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',20,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(39,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',21,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(40,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',22,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(41,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',23,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(42,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',24,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(43,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',25,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(44,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',26,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(45,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',27,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(46,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',28,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(47,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',29,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(48,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',30,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(49,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',31,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(50,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',32,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(51,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',33,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(52,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',34,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(53,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',35,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(54,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',36,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(55,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',37,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(56,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',38,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(57,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',39,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(58,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',40,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(59,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',41,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(60,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',42,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(61,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',43,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(62,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',44,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(63,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',45,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(64,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',46,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(65,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',47,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:42','2025-02-24 18:30:42'),(66,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',48,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:43','2025-02-24 18:30:43'),(67,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',49,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:43','2025-02-24 18:30:43'),(68,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',50,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:43','2025-02-24 18:30:43'),(69,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',51,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:43','2025-02-24 18:30:43'),(70,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',52,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:43','2025-02-24 18:30:43'),(71,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',53,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:43','2025-02-24 18:30:43'),(72,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',54,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:43','2025-02-24 18:30:43'),(73,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',55,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:43','2025-02-24 18:30:43'),(74,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',56,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:43','2025-02-24 18:30:43'),(75,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',57,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:43','2025-02-24 18:30:43'),(76,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',58,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:43','2025-02-24 18:30:43'),(77,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',59,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:43','2025-02-24 18:30:43'),(78,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',60,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:43','2025-02-24 18:30:43'),(79,'video_url','[\"https:\\/\\/youtu.be\\/tRxGSHL8bI0?si=kbumCspOMG-kJvTT\"]',61,'Botble\\RealEstate\\Models\\Property','2025-02-24 18:30:43','2025-02-24 18:30:43'),(80,'breadcrumb','[\"no\"]',1,'Botble\\Page\\Models\\Page','2025-02-24 18:30:49','2025-02-24 18:30:49'),(81,'breadcrumb','[\"no\"]',2,'Botble\\Page\\Models\\Page','2025-02-24 18:30:49','2025-02-24 18:30:49'),(82,'breadcrumb','[\"no\"]',3,'Botble\\Page\\Models\\Page','2025-02-24 18:30:49','2025-02-24 18:30:49'),(83,'breadcrumb','[\"no\"]',5,'Botble\\Page\\Models\\Page','2025-02-24 18:30:49','2025-02-24 18:30:49'),(84,'breadcrumb','[\"yes\"]',6,'Botble\\Page\\Models\\Page','2025-02-24 18:30:49','2025-02-24 18:30:49'),(85,'breadcrumb','[\"yes\"]',7,'Botble\\Page\\Models\\Page','2025-02-24 18:30:49','2025-02-24 18:30:49'),(86,'breadcrumb','[\"yes\"]',8,'Botble\\Page\\Models\\Page','2025-02-24 18:30:49','2025-02-24 18:30:49'),(87,'breadcrumb','[\"yes\"]',9,'Botble\\Page\\Models\\Page','2025-02-24 18:30:49','2025-02-24 18:30:49'),(88,'breadcrumb','[\"yes\"]',10,'Botble\\Page\\Models\\Page','2025-02-24 18:30:49','2025-02-24 18:30:49'),(89,'breadcrumb','[\"yes\"]',11,'Botble\\Page\\Models\\Page','2025-02-24 18:30:49','2025-02-24 18:30:49'),(90,'breadcrumb','[\"yes\"]',12,'Botble\\Page\\Models\\Page','2025-02-24 18:30:49','2025-02-24 18:30:49'),(91,'breadcrumb','[\"no\"]',13,'Botble\\Page\\Models\\Page','2025-02-24 18:30:49','2025-02-24 18:30:49'),(92,'breadcrumb','[\"yes\"]',16,'Botble\\Page\\Models\\Page','2025-02-24 18:30:49','2025-02-24 18:30:49'),(93,'image','[\"general\\/job-details-thumb.png\"]',1,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51'),(94,'icon','[\"icons\\/icon1.png\"]',1,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51'),(95,'apply_url','[\"\\/contact\"]',1,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51'),(96,'image','[\"general\\/job-details-thumb.png\"]',2,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51'),(97,'icon','[\"icons\\/icon2.png\"]',2,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51'),(98,'apply_url','[\"\\/contact\"]',2,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51'),(99,'image','[\"general\\/job-details-thumb.png\"]',3,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51'),(100,'icon','[\"icons\\/icon3.png\"]',3,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51'),(101,'apply_url','[\"\\/contact\"]',3,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51'),(102,'image','[\"general\\/job-details-thumb.png\"]',4,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51'),(103,'icon','[\"icons\\/icon4.png\"]',4,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51'),(104,'apply_url','[\"\\/contact\"]',4,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51'),(105,'image','[\"general\\/job-details-thumb.png\"]',5,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51'),(106,'icon','[\"icons\\/icon5.png\"]',5,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51'),(107,'apply_url','[\"\\/contact\"]',5,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51'),(108,'image','[\"general\\/job-details-thumb.png\"]',6,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51'),(109,'icon','[\"icons\\/icon6.png\"]',6,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51'),(110,'apply_url','[\"\\/contact\"]',6,'ArchiElite\\Career\\Models\\Career','2025-02-24 18:30:51','2025-02-24 18:30:51');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'0001_01_01_000001_create_cache_table',1),(2,'2013_04_09_032329_create_base_tables',1),(3,'2013_04_09_062329_create_revisions_table',1),(4,'2014_10_12_000000_create_users_table',1),(5,'2014_10_12_100000_create_password_reset_tokens_table',1),(6,'2016_06_10_230148_create_acl_tables',1),(7,'2016_06_14_230857_create_menus_table',1),(8,'2016_06_28_221418_create_pages_table',1),(9,'2016_10_05_074239_create_setting_table',1),(10,'2016_11_28_032840_create_dashboard_widget_tables',1),(11,'2016_12_16_084601_create_widgets_table',1),(12,'2017_05_09_070343_create_media_tables',1),(13,'2017_11_03_070450_create_slug_table',1),(14,'2019_01_05_053554_create_jobs_table',1),(15,'2019_08_19_000000_create_failed_jobs_table',1),(16,'2019_12_14_000001_create_personal_access_tokens_table',1),(17,'2022_04_20_100851_add_index_to_media_table',1),(18,'2022_04_20_101046_add_index_to_menu_table',1),(19,'2022_07_10_034813_move_lang_folder_to_root',1),(20,'2022_08_04_051940_add_missing_column_expires_at',1),(21,'2022_09_01_000001_create_admin_notifications_tables',1),(22,'2022_10_14_024629_drop_column_is_featured',1),(23,'2022_11_18_063357_add_missing_timestamp_in_table_settings',1),(24,'2022_12_02_093615_update_slug_index_columns',1),(25,'2023_01_30_024431_add_alt_to_media_table',1),(26,'2023_02_16_042611_drop_table_password_resets',1),(27,'2023_04_23_005903_add_column_permissions_to_admin_notifications',1),(28,'2023_05_10_075124_drop_column_id_in_role_users_table',1),(29,'2023_08_21_090810_make_page_content_nullable',1),(30,'2023_09_14_021936_update_index_for_slugs_table',1),(31,'2023_12_07_095130_add_color_column_to_media_folders_table',1),(32,'2023_12_17_162208_make_sure_column_color_in_media_folders_nullable',1),(33,'2024_04_04_110758_update_value_column_in_user_meta_table',1),(34,'2024_05_12_091229_add_column_visibility_to_table_media_files',1),(35,'2024_07_03_162029_remove_plugin_team',1),(36,'2024_07_07_091316_fix_column_url_in_menu_nodes_table',1),(37,'2024_07_12_100000_change_random_hash_for_media',1),(38,'2024_09_30_024515_create_sessions_table',1),(39,'2020_11_18_150916_ads_create_ads_table',2),(40,'2021_12_02_035301_add_ads_translations_table',2),(41,'2023_04_17_062645_add_open_in_new_tab',2),(42,'2023_11_07_023805_add_tablet_mobile_image',2),(43,'2024_04_01_043317_add_google_adsense_slot_id_to_ads_table',2),(44,'2024_04_27_100730_improve_analytics_setting',3),(45,'2023_08_11_060908_create_announcements_table',4),(46,'2025_02_11_153025_add_action_label_to_announcement_translations',4),(47,'2015_06_29_025744_create_audit_history',5),(48,'2023_11_14_033417_change_request_column_in_table_audit_histories',5),(49,'2015_06_18_033822_create_blog_table',6),(50,'2021_02_16_092633_remove_default_value_for_author_type',6),(51,'2021_12_03_030600_create_blog_translations',6),(52,'2022_04_19_113923_add_index_to_table_posts',6),(53,'2023_08_29_074620_make_column_author_id_nullable',6),(54,'2024_07_30_091615_fix_order_column_in_categories_table',6),(55,'2025_01_06_033807_add_default_value_for_categories_author_type',6),(56,'2019_06_24_211801_create_career_table',7),(57,'2021_12_04_095357_create_careers_translations_table',7),(58,'2023_09_20_050420_add_missing_translation_column',7),(59,'2016_06_17_091537_create_contacts_table',8),(60,'2023_11_10_080225_migrate_contact_blacklist_email_domains_to_core',8),(61,'2024_03_20_080001_migrate_change_attribute_email_to_nullable_form_contacts_table',8),(62,'2024_03_25_000001_update_captcha_settings_for_contact',8),(63,'2024_04_19_063914_create_custom_fields_table',8),(64,'2018_07_09_221238_create_faq_table',9),(65,'2021_12_03_082134_create_faq_translations',9),(66,'2023_11_17_063408_add_description_column_to_faq_categories_table',9),(67,'2016_10_03_032336_create_languages_table',10),(68,'2023_09_14_022423_add_index_for_language_table',10),(69,'2021_10_25_021023_fix-priority-load-for-language-advanced',11),(70,'2021_12_03_075608_create_page_translations',11),(71,'2023_07_06_011444_create_slug_translations_table',11),(72,'2019_11_18_061011_create_country_table',12),(73,'2021_12_03_084118_create_location_translations',12),(74,'2021_12_03_094518_migrate_old_location_data',12),(75,'2021_12_10_034440_switch_plugin_location_to_use_language_advanced',12),(76,'2022_01_16_085908_improve_plugin_location',12),(77,'2022_08_04_052122_delete_location_backup_tables',12),(78,'2023_04_23_061847_increase_state_translations_abbreviation_column',12),(79,'2023_07_26_041451_add_more_columns_to_location_table',12),(80,'2023_07_27_041451_add_more_columns_to_location_translation_table',12),(81,'2023_08_15_073307_drop_unique_in_states_cities_translations',12),(82,'2023_10_21_065016_make_state_id_in_table_cities_nullable',12),(83,'2024_08_17_094600_add_image_into_countries',12),(84,'2025_01_08_093652_add_zip_code_to_cities',12),(85,'2017_10_24_154832_create_newsletter_table',13),(86,'2024_03_25_000001_update_captcha_settings_for_newsletter',13),(87,'2017_05_18_080441_create_payment_tables',14),(88,'2021_03_27_144913_add_customer_type_into_table_payments',14),(89,'2021_05_24_034720_make_column_currency_nullable',14),(90,'2021_08_09_161302_add_metadata_column_to_payments_table',14),(91,'2021_10_19_020859_update_metadata_field',14),(92,'2022_06_28_151901_activate_paypal_stripe_plugin',14),(93,'2022_07_07_153354_update_charge_id_in_table_payments',14),(94,'2024_07_04_083133_create_payment_logs_table',14),(95,'2018_06_22_032304_create_real_estate_table',15),(96,'2021_02_11_031126_update_price_column_in_projects_and_properties',15),(97,'2021_03_08_024049_add_lat_long_into_real_estate_tables',15),(98,'2021_06_10_091950_add_column_is_featured_to_table_re_accounts',15),(99,'2021_07_07_021757_update_table_account_activity_logs',15),(100,'2021_09_29_042758_create_re_categories_multilevel_table',15),(101,'2021_10_31_031254_add_company_to_accounts_table',15),(102,'2021_12_10_034807_create_real_estate_translation_tables',15),(103,'2021_12_18_081636_add_property_project_views_count',15),(104,'2022_05_04_033044_update_column_images_in_real_estate_tables',15),(105,'2022_07_02_081723_fix_expired_date_column',15),(106,'2022_08_01_090213_update_table_properties_and_projects',15),(107,'2023_01_31_023233_create_re_custom_fields_table',15),(108,'2023_02_06_000000_add_location_to_re_accounts_table',15),(109,'2023_02_06_024257_add_package_translations',15),(110,'2023_02_08_062457_add_custom_fields_translation_table',15),(111,'2023_02_15_024644_create_re_reviews_table',15),(112,'2023_02_20_072604_create_re_invoices_table',15),(113,'2023_02_20_081251_create_re_account_packages_table',15),(114,'2023_04_04_030709_add_unique_id_to_properties_and_projects_table',15),(115,'2023_04_14_164811_make_phone_and_email_in_table_re_consults_nullable',15),(116,'2023_05_09_062031_unique_reviews_table',15),(117,'2023_05_26_034353_fix_properties_projects_image',15),(118,'2023_05_27_004215_add_column_ip_into_table_re_consults',15),(119,'2023_07_25_034513_create_re_coupons_table',15),(120,'2023_07_25_034672_add_coupon_code_column_to_jb_invoices_table',15),(121,'2023_08_02_074208_change_square_column_to_float',15),(122,'2023_08_07_000001_add_is_public_profile_column_to_re_accounts_table',15),(123,'2023_08_09_004607_make_column_project_id_nullable',15),(124,'2023_09_11_084630_update_mandatory_fields_in_consult_form_table',15),(125,'2023_11_21_071820_add_missing_slug_for_agents',15),(126,'2024_01_11_084816_add_investor_translations_table',15),(127,'2024_01_31_022842_add_description_to_re_packages_table',15),(128,'2024_03_13_000001_drop_type_column_from_custom_field_translations_table',15),(129,'2024_04_23_124505_add_features_column_to_re_packages',15),(130,'2024_04_23_135106_add_columns_to_re_investors',15),(131,'2024_05_25_000001_update_captcha_settings_for_real_estate',15),(132,'2024_06_16_163428_make_investor_id_nullable',15),(133,'2024_06_20_103539_create_consult_custom_fields_table',15),(134,'2024_07_08_235824_fix_facilities_primary_key',15),(135,'2024_07_26_090340_add_private_notes_column_to_re_properties_projects_table',15),(136,'2024_08_09_075542_add_accounts_translations',15),(137,'2024_08_12_124528_add_approved_at_column_to_re_accounts_table',15),(138,'2024_08_31_074158_add_floor_plans_columns_to_re_properties_table',15),(139,'2024_09_04_130921_add_reject_reason_column_to_re_properties_table',15),(140,'2024_09_19_021436_make_email_in_accounts_table_nullable',15),(141,'2024_11_18_023706_add_floor_plan_to_table_re_properties_translations',15),(142,'2018_07_09_214610_create_testimonial_table',16),(143,'2021_12_03_083642_create_testimonials_translations',16),(144,'2016_10_07_193005_create_translations_table',17),(145,'2023_12_12_105220_drop_translations_table',17);

--
-- Table structure for table `newsletters`
--

CREATE TABLE `newsletters` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'subscribed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `newsletters`
--


--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `user_id` bigint unsigned DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `template` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pages_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES (1,'Homepage 1','[hero-banner style=\"1\" title=\"Find Your\" animation_text=\"Dream Home,Perfect Home,Real Estate\" description=\"We are a real estate agency that will help you find the best residence you dream of, let’s discuss for your dream house?\" background_image=\"pages/slider-1.jpg\" search_box_enabled=\"1\" projects_search_enabled=\"1\" default_search_type=\"project\"][/hero-banner]\n[properties style=\"2\" title=\"Recommended For You\" subtitle=\"Features Properties\" category_ids=\"1,2,3,4,5,6\" type=\"rent\" is_featured=\"\" limit=\"6\" button_label=\"View All Properties\" button_url=\"/properties\" enable_lazy_loading=\"yes\"][/properties]\n[location title=\"Our Location For You\" subtitle=\"Explore Cities\" type=\"city\" city_ids=\"1,2,3,4,5,6,7\" destination=\"property\" background_color=\"#f7f7f7\" enable_lazy_loading=\"yes\"][/location]\n[services style=\"1\" title=\"What We Do?\" subtitle=\"Our Services\" background_color=\"transparent\" services_quantity=\"3\" services_title_1=\"Buy A New Home\" services_description_1=\"Discover your dream home effortlessly. Explore diverse properties and expert guidance for a seamless buying experience.\" services_button_label_1=\"Learn More\" services_button_url_1=\"/\" services_icon_image_1=\"pages/service-1.png\" services_title_2=\"Rent A Home\" services_description_2=\"Discover your perfect rental effortlessly. Explore a diverse variety of listings tailored precisely to suit your unique lifestyle needs.\" services_button_label_2=\"Learn More\" services_button_url_2=\"/\" services_icon_image_2=\"pages/service-2.png\" services_title_3=\"Sell A Home\" services_description_3=\"Sell confidently with expert guidance and effective strategies, showcasing your property\'s best features for a successful sale.\" services_button_label_3=\"Learn More\" services_button_url_3=\"/\" services_icon_image_3=\"pages/service-3.png\" counters_quantity=\"4\" counters_label_1=\"SATISFIED CLIENTS\" counters_number_1=\"85\" counters_label_2=\"AWARDS RECEIVED\" counters_number_2=\"112\" counters_label_3=\"SUCCESSFUL TRANSACTIONS\" counters_number_3=\"32\" counters_label_4=\"MONTHLY TRAFFIC\" counters_number_4=\"66\" button_label=\"View All Services\" button_url=\"/\" enable_lazy_loading=\"yes\"][/services]\n[services style=\"1\" title=\"Why Choose Homzen\" subtitle=\"Our Benefit\" background_color=\"#f7f7f7\" services_quantity=\"3\" services_title_1=\"Proven Expertise\" services_description_1=\"Our seasoned team excels in real estate with years of successful market navigation, offering informed decisions and optimal results.\" services_icon_image_1=\"pages/service-1.png\" services_title_2=\"Customized Solutions\" services_description_2=\"We pride ourselves on crafting personalized strategies to match your unique goals, ensuring a seamless real estate journey.\" services_icon_image_2=\"pages/service-2.png\" services_title_3=\"Transparent Partnerships\" services_description_3=\"Transparency is key in our client relationships. We prioritize clear communication and ethical practices, fostering trust and reliability throughout.\" services_icon_image_3=\"pages/service-3.png\" counters_quantity=\"1\" centered_content=\"1\" enable_lazy_loading=\"yes\"][/services]\n[properties style=\"1\" title=\"Best Property Value\" subtitle=\"Top Properties\" is_featured=\"1\" limit=\"4\" button_label=\"View All\" button_url=\"/properties\" enable_lazy_loading=\"yes\"][/properties]\n[testimonials style=\"1\" title=\"What’s People Say’s\" subtitle=\"Top Properties\" description=\"Our seasoned team excels in real estate with years of successful market navigation, offering informed decisions and optimal results.\" testimonial_ids=\"1,2,3,4\" background_color=\"#f7f7f7\" enable_lazy_loading=\"yes\"][/testimonials]\n[agents style=\"1\" title=\"Meet Our Agents\" subtitle=\"Our Teams\" account_ids=\"1,2,3,4\" enable_lazy_loading=\"yes\"][/agents]\n[blog-posts style=\"1\" title=\"Helpful Homzen Guides\" subtitle=\"Latest News\" type=\"recent\" limit=\"3\" background_color=\"#f7f7f7\" enable_lazy_loading=\"yes\"][/blog-posts]\n[image-slider background_color=\"transparent\" quantity=\"7\" name_1=\"GitHub\" image_1=\"partners/github.png\" url_1=\"https://github.com\" open_in_new_tab_1=\"\" name_2=\"LH.Tech\" image_2=\"partners/lhtech.png\" url_2=\"https://lhtech.com.my\" open_in_new_tab_2=\"\" name_3=\"Panadoxn\" image_3=\"partners/panadoxn.png\" url_3=\"/\" open_in_new_tab_3=\"\" name_4=\"Shangxi\" image_4=\"partners/shangxi.png\" url_4=\"/\" open_in_new_tab_4=\"\" name_5=\"Tyaalpha\" image_5=\"partners/tyaalpha.png\" url_5=\"/\" open_in_new_tab_5=\"\" name_6=\"Vanfaba\" image_6=\"partners/vanfaba.png\" url_6=\"/\" open_in_new_tab_6=\"\" name_7=\"Asana\" image_7=\"partners/asana.png\" url_7=\"https://asana.com\" open_in_new_tab_7=\"\" enable_lazy_loading=\"yes\"][/image-slider]',1,NULL,'full-width',NULL,'published','2025-02-24 18:30:49','2025-02-24 18:30:49'),(2,'Homepage 2','[hero-banner style=\"2\" title=\"Find A Home That\" animation_text=\"Perfectly,Dream Home\" description=\"We are a real estate agency that will help you find the best residence you dream of.\" background_image=\"pages/slider-left.jpg\" slider_image_1=\"pages/slider-2.jpg\" slider_image_2=\"pages/slider-3.jpg\" slider_image_3=\"pages/slider-4.jpg\" slider_image_4=\"pages/slider-5.jpg\" search_box_enabled=\"1\" projects_search_enabled=\"1\" default_search_type=\"project\"][/hero-banner]\n[property-categories style=\"1\" title=\"Try Searching For\" subtitle=\"PROPERTY TYPE\" category_ids=\"1,2,3,4,5,6\" background_color=\"transparent\" button_label=\"View All\" button_url=\"/categories\" enable_lazy_loading=\"yes\"][/property-categories]\n[properties style=\"4\" title=\"Discover Homzen\'s Finest Properties For Your Dream Home\" subtitle=\"Featured Properties\" limit=\"8\" button_label=\"View All Properties\" button_url=\"/properties\" enable_lazy_loading=\"yes\"][/properties]\n[services style=\"3\" title=\"Discover What Sets Our Real Estate Expertise Apart\" subtitle=\"Why Choose Us\" description=\"At Homzen, our unwavering commitment lies in crafting unparalleled real estate journeys. Our seasoned professionals, armed with extensive market knowledge, walk alongside you through every phase of your property endeavor. We prioritize understanding your unique aspirations, tailoring our expertise to match your vision.\" checklist=\"Transparent Partnerships,Proven Expertise,Customized Solutions,Local Area Knowledge\" background_color=\"#f7f7f7\" services_quantity=\"3\" services_title_1=\"Buy A New Home\" services_description_1=\"Discover your dream home effortlessly. Explore diverse properties and expert guidance for a seamless buying experience.\" services_button_label_1=\"Learn More\" services_button_url_1=\"/\" services_icon_image_1=\"pages/service-1.png\" services_title_2=\"Rent A Home\" services_description_2=\"Discover your perfect rental effortlessly. Explore a diverse variety of listings tailored precisely to suit your unique lifestyle needs.\" services_button_label_2=\"Learn More\" services_button_url_2=\"/\" services_icon_image_2=\"pages/service-2.png\" services_title_3=\"Sell A Home\" services_description_3=\"Sell confidently with expert guidance and effective strategies, showcasing your property\'s best features for a successful sale.\" services_button_label_3=\"Learn More\" services_button_url_3=\"/\" services_icon_image_3=\"pages/service-3.png\" counters_quantity=\"1\" button_label=\"Contact Us\" button_url=\"/contact-us\" centered_content=\"\" enable_lazy_loading=\"yes\"][/services]\n[location style=\"2\" title=\"Our Location For You\" subtitle=\"Explore States\" type=\"state\" state_ids=\"1,2,3,4,5,6\" destination=\"property\" background_color=\"transparent\" enable_lazy_loading=\"yes\"][/location]\n[properties style=\"3\" title=\"Best Property Value\" subtitle=\"Top Properties\" is_featured=\"1\" limit=\"4\" button_label=\"View All\" button_url=\"/properties\" enable_lazy_loading=\"yes\" background_color=\"#f7f7f7\"][/properties]\n[agents style=\"1\" title=\"Meet Our Agents\" subtitle=\"Our Teams\" account_ids=\"1,2,3,4\" enable_lazy_loading=\"yes\"][/agents]\n[testimonials style=\"3\" title=\"What’s People Say’s\" subtitle=\"Our Testimonials\" description=\"Our seasoned team excels in real estate with years of successful market navigation, offering informed decisions and optimal results.\" testimonial_ids=\"1,2,3,4\" enable_lazy_loading=\"yes\"][/testimonials]\n[blog-posts style=\"1\" title=\"Helpful Homzen Guides\" subtitle=\"Latest News\" type=\"recent\" limit=\"3\" enable_lazy_loading=\"yes\"][/blog-posts]',1,NULL,'full-width',NULL,'published','2025-02-24 18:30:49','2025-02-24 18:30:49'),(3,'Homepage 3','[hero-banner style=\"3\" title=\"Indulge in Your\" animation_text=\"Sanctuary,Safe House\" description=\"Discover your private oasis at Homzen, where every corner, from the spacious garden to the relaxing pool, is crafted for your comfort and enjoyment.\" background_image=\"pages/slider-6.png\" search_box_enabled=\"1\" projects_search_enabled=\"1\" default_search_type=\"project\" button_label=\"Contact Us\" button_url=\"/contact\"][/hero-banner]\n[location style=\"3\" title=\"Properties By Cities\" subtitle=\"EXPLORE CITIES\" type=\"city\" city_ids=\"1,2,3,4,5,6,7,21,24\" destination=\"property\" background_color=\"#f7f7f7\" button_label=\"View All Properties\" button_url=\"/properties\" enable_lazy_loading=\"yes\"][/location]\n[properties style=\"2\" title=\"Recommended For You\" subtitle=\"Features Properties\" category_ids=\"1,2,3,4,5,6\" type=\"rent\" is_featured=\"\" limit=\"6\" button_label=\"View All Properties\" button_url=\"/properties\" enable_lazy_loading=\"yes\"][/properties]\n[property-categories style=\"2\" title=\"Try Searching For\" subtitle=\"PROPERTY TYPE\" category_ids=\"1,2,3,4,5,6\" background_color=\"#161e2d\" enable_lazy_loading=\"yes\"][/property-categories]\n[services style=\"2\" title=\"What We Do?\" subtitle=\"Our Services\" background_color=\"transparent\" services_quantity=\"3\" services_title_1=\"Buy A New Home\" services_description_1=\"Discover your dream home effortlessly. Explore diverse properties and expert guidance for a seamless buying experience.\" services_button_label_1=\"Learn More\" services_button_url_1=\"/\" services_icon_image_1=\"pages/service-1.png\" services_title_2=\"Rent A Home\" services_description_2=\"Discover your perfect rental effortlessly. Explore a diverse variety of listings tailored precisely to suit your unique lifestyle needs.\" services_button_label_2=\"Learn More\" services_button_url_2=\"/\" services_icon_image_2=\"pages/service-2.png\" services_title_3=\"Sell A Home\" services_description_3=\"Sell confidently with expert guidance and effective strategies, showcasing your property\'s best features for a successful sale.\" services_button_label_3=\"Learn More\" services_button_url_3=\"/\" services_icon_image_3=\"pages/service-3.png\" enable_lazy_loading=\"yes\"][/services]\n[testimonials style=\"4\" title=\"What’s People Say’s\" subtitle=\"Our Testimonials\" description=\"Our seasoned team excels in real estate with years of successful market navigation, offering informed decisions and optimal results.\" testimonial_ids=\"1,2,3,4\" background_color=\"#f7f7f7\" background_image=\"pages/testimonial-banner.png\" enable_lazy_loading=\"yes\"][/testimonials]\n[agents style=\"2\" title=\"Meet Our Agents\" subtitle=\"Our Teams\" account_ids=\"1,2,3,4\" background_color=\"#f7f7f7\" enable_lazy_loading=\"yes\"][/agents]\n[blog-posts style=\"2\" title=\"Helpful Homzen Guides\" subtitle=\"Latest News\" type=\"recent\" limit=\"4\" background_color=\"#f7f7f7\" enable_lazy_loading=\"yes\"][/blog-posts]',1,NULL,'full-width',NULL,'published','2025-02-24 18:30:49','2025-02-24 18:30:49'),(4,'Homepage 4','[hero-banner style=\"4\" search_box_enabled=\"1\" projects_search_enabled=\"1\" default_search_type=\"project\"][/hero-banner]\n[properties style=\"5\" title=\"Discover Homzen\'s Finest Properties For Your Dream Home\" subtitle=\"FEATURED PROPERTIES\" is_featured=\"1\" limit=\"6\" button_label=\"View All Properties\" button_url=\"/properties\" background_color=\"transparent\" enable_lazy_loading=\"yes\"][/properties]\n[services style=\"4\" title=\"Discover What Sets Our\" subtitle=\"WHAT WE DO\" description=\"At Homzen, our unwavering commitment lies in crafting unparalleled real estate journeys.\" background_color=\"transparent\" services_quantity=\"3\" services_title_1=\"Buy A New Home\" services_description_1=\"Explore diverse properties and expert guidance for a seamless buying experience.\" services_icon_1=\"ti ti-12-hours\" services_icon_image_1=\"pages/service-1.png\" services_button_label_1=\"Learn More\" services_button_url_1=\"/contact\" services_title_2=\"Rent A Home\" services_description_2=\"Explore a diverse variety of listings tailored precisely to suit your unique lifestyle needs.\" services_icon_image_2=\"pages/service-2.png\" services_button_label_2=\"Learn More\" services_button_url_2=\"/contact\" services_title_3=\"Buy A New Home\" services_description_3=\"Showcasing your property\'s best features for a successful sale.\" services_icon_image_3=\"pages/service-3.png\" services_button_label_3=\"Learn More\" services_button_url_3=\"/contact\" counters_quantity=\"1\" background_image=\"pages/house-service.png\" centered_content=\"\" enable_lazy_loading=\"yes\"][/services]\n[location title=\"Our Location For You\" subtitle=\"Explore Cities\" type=\"city\" city_ids=\"1,2,3,4,5,6\" destination=\"property\" background_color=\"#f7f7f7\" enable_lazy_loading=\"yes\"][/location]\n[agents style=\"1\" title=\"Meet Our Agents\" subtitle=\"OUR TEAMS\" account_ids=\"1,2,3\" background_color=\"transparent\" items_per_row=\"3\" enable_lazy_loading=\"yes\"][/agents]\n[properties style=\"6\" title=\"Recommended for you\" subtitle=\"TOP PROPERTIES\" is_featured=\"1\" limit=\"4\" background_image=\"pages/properties.png\" background_color=\"transparent\" enable_lazy_loading=\"yes\"][/properties]\n[testimonials style=\"2\" title=\"What’s People Say’s\" subtitle=\"OUR TESTIMONIALS\" testimonial_ids=\"1,2,3,4\" enable_lazy_loading=\"yes\"][/testimonials]\n[services style=\"5\" title=\"Why Choose Homzen\" subtitle=\"OUR BENIFIT\" description=\"Our seasoned team excels in real estate with years of successful market navigation, offering informed decisions and optimal results.\" background_color=\"transparent\" services_quantity=\"8\" services_title_1=\"Buy A New Home\" services_description_1=\"Explore diverse properties and expert guidance for a seamless buying experience.\" services_icon_1=\"ti ti-home\" services_title_2=\"Sell Your Property\" services_description_2=\"Get the best value with our professional selling strategies and market insights.\" services_icon_2=\"ti ti-currency-dollar\" services_title_3=\"Rent A Property\" services_description_3=\"Find the perfect rental property with our extensive listings and support.\" services_icon_3=\"ti ti-building\" services_title_4=\"Property Management\" services_description_4=\"Professional management services to keep your property in top condition.\" services_icon_4=\"ti ti-settings\" services_title_5=\"Real Estate Consulting\" services_description_5=\"Expert advice and insights to help you make informed real estate decisions.\" services_icon_5=\"ti ti-chart-bar\" services_title_6=\"Mortgage Services\" services_description_6=\"Find the best mortgage rates and options with our comprehensive services.\" services_icon_6=\"ti ti-credit-card\" services_title_7=\"Investment Properties\" services_description_7=\"Discover lucrative investment opportunities and maximize your returns.\" services_icon_7=\"ti ti-briefcase\" services_title_8=\"Relocation Services\" services_description_8=\"Smooth and hassle-free relocation services to help you move with ease.\" services_icon_8=\"ti ti-truck\" counters_quantity=\"1\" centered_content=\"\" enable_lazy_loading=\"yes\"][/services]\n[blog-posts style=\"1\" title=\"Helpful Homzen Guides\" subtitle=\"LATEST NEWS\" type=\"recent\" limit=\"3\" enable_lazy_loading=\"yes\"][/blog-posts]\n[call-to-action title=\"List Your Properties On Homzen, Join Us Now!\" subtitle=\"BECOME PARTNERS\" button_label=\"Become A Hosting\" button_url=\"/contact\" image=\"pages/call-to-action.png\" enable_lazy_loading=\"yes\"][/call-to-action]',1,NULL,'full-width',NULL,'published','2025-02-24 18:30:49','2025-02-24 18:30:49'),(5,'Homepage 5','[hero-banner style=\"5\" property_id=\"4\" search_box_enabled=\"1\" projects_search_enabled=\"1\" default_search_type=\"project\"][/hero-banner]\n[services style=\"2\" title=\"Why Choose Homzen\" subtitle=\"Our Benefit\" background_color=\"#f7f7f7\" services_quantity=\"3\" services_title_1=\"Buy A New Home\" services_description_1=\"Discover your dream home effortlessly. Explore diverse properties and expert guidance for a seamless buying experience.\" services_button_label_1=\"Learn More\" services_button_url_1=\"/\" services_icon_image_1=\"pages/service-1.png\" services_title_2=\"Rent A Home\" services_description_2=\"Discover your perfect rental effortlessly. Explore a diverse variety of listings tailored precisely to suit your unique lifestyle needs.\" services_button_label_2=\"Learn More\" services_button_url_2=\"/\" services_icon_image_2=\"pages/service-2.png\" services_title_3=\"Sell A Home\" services_description_3=\"Sell confidently with expert guidance and effective strategies, showcasing your property\'s best features for a successful sale.\" services_button_label_3=\"Learn More\" services_button_url_3=\"/\" services_icon_image_3=\"pages/service-3.png\" counters_quantity=\"1\" centered_content=\"1\" enable_lazy_loading=\"yes\"][/services]\n[properties style=\"4\" title=\"Discover Homzen\'s Finest Properties For Your Dream Home\" subtitle=\"FEATURED PROPERTIES\" is_featured=\"1\" limit=\"8\" button_label=\"View All Properties\" button_url=\"/properties\" background_color=\"transparent\" enable_lazy_loading=\"yes\"][/properties]\n[location style=\"4\" title=\"Our Location For You\" subtitle=\"EXPLORE CITIES\" type=\"city\" city_ids=\"1,3,5,6,11,23\" destination=\"property\" background_color=\"#f7f7f7\" enable_lazy_loading=\"yes\"][/location]\n[properties style=\"7\" title=\"Recommended For You\" subtitle=\"TOP PROPERTIES\" is_featured=\"1\" limit=\"4\" background_color=\"transparent\" enable_lazy_loading=\"yes\"][/properties]\n[services style=\"5\" title=\"Why Choose Homzen\" subtitle=\"OUR BENIFIT\" description=\"Our seasoned team excels in real estate with years of successful market navigation, offering informed decisions and optimal results.\" background_color=\"transparent\" services_quantity=\"8\" services_title_1=\"Buy A New Home\" services_description_1=\"Explore diverse properties and expert guidance for a seamless buying experience.\" services_icon_1=\"ti ti-home\" services_title_2=\"Sell Your Property\" services_description_2=\"Get the best value with our professional selling strategies and market insights.\" services_icon_2=\"ti ti-currency-dollar\" services_title_3=\"Rent A Property\" services_description_3=\"Find the perfect rental property with our extensive listings and support.\" services_icon_3=\"ti ti-building\" services_title_4=\"Property Management\" services_description_4=\"Professional management services to keep your property in top condition.\" services_icon_4=\"ti ti-settings\" services_title_5=\"Real Estate Consulting\" services_description_5=\"Expert advice and insights to help you make informed real estate decisions.\" services_icon_5=\"ti ti-chart-bar\" services_title_6=\"Mortgage Services\" services_description_6=\"Find the best mortgage rates and options with our comprehensive services.\" services_icon_6=\"ti ti-credit-card\" services_title_7=\"Investment Properties\" services_description_7=\"Discover lucrative investment opportunities and maximize your returns.\" services_icon_7=\"ti ti-briefcase\" services_title_8=\"Relocation Services\" services_description_8=\"Smooth and hassle-free relocation services to help you move with ease.\" services_icon_8=\"ti ti-truck\" counters_quantity=\"1\" centered_content=\"\" enable_lazy_loading=\"yes\"][/services]\n[agents style=\"2\" title=\"Meet Our Agents\" subtitle=\"OUR TEAMS\" account_ids=\"1,2,3,4\" background_color=\"transparent\" items_per_row=\"2\" enable_lazy_loading=\"yes\"][/agents]\n[testimonials style=\"1\" title=\"What’s People Say’s\" subtitle=\"TOP PROPERTIES\" description=\"Our seasoned team excels in real estate with years of successful market navigation, offering informed decisions and optimal results.\" testimonial_ids=\"1,2,3,4\" background_color=\"#f7f7f7\" enable_lazy_loading=\"yes\"][/testimonials]\n[blog-posts style=\"2\" title=\"The Most Recent Estate\" subtitle=\"LATEST NEWS\" type=\"recent\" limit=\"4\" enable_lazy_loading=\"yes\"][/blog-posts]',1,NULL,'full-width',NULL,'published','2025-02-24 18:30:49','2025-02-24 18:30:49'),(6,'Blog',NULL,1,NULL,NULL,NULL,'published','2025-02-24 18:30:49','2025-02-24 18:30:49'),(7,'Contact Us','[contact-form display_fields=\"phone,email,subject,address\" mandatory_fields=\"email\" style=\"1\" title=\"Drop Us A Line\" description=\"Feel free to connect with us through our online channels for updates, news, and more.\" show_information_box=\"1\" contact_title=\"Contact Us\" quantity=\"3\" label_1=\"Address:\" content_1=\"101 E 129th St, East Chicago, IN 46312 United States\" label_2=\"Information:\" content_2=\"1-333-345-6868 hi.themesflat@gmail.com\" label_3=\"Open time:\" content_3=\"Monday - Friday: 08:00 - 20:00 Saturday - Sunday: 10:00 - 18:00\" show_social_links=\"1\"][/contact-form]\n[google-map]101 E 129th St, East Chicago, IN 46312 United States[/google-map]',1,NULL,NULL,NULL,'published','2025-02-24 18:30:49','2025-02-24 18:30:49'),(8,'Our Services','[services style=\"2\" title=\"Why Choose Homzen\" subtitle=\"Our Benefit\" background_color=\"#ffffff\" services_quantity=\"3\" services_title_1=\"Buy A New Home\" services_description_1=\"Discover your dream home effortlessly. Explore diverse properties and expert guidance for a seamless buying experience.\" services_button_label_1=\"Learn More\" services_button_url_1=\"/\" services_icon_image_1=\"pages/service-1.png\" services_title_2=\"Rent A Home\" services_description_2=\"Discover your perfect rental effortlessly. Explore a diverse variety of listings tailored precisely to suit your unique lifestyle needs.\" services_button_label_2=\"Learn More\" services_button_url_2=\"/\" services_icon_image_2=\"pages/service-2.png\" services_title_3=\"Sell A Home\" services_description_3=\"Sell confidently with expert guidance and effective strategies, showcasing your property\'s best features for a successful sale.\" services_button_label_3=\"Learn More\" services_button_url_3=\"/\" services_icon_image_3=\"pages/service-3.png\" counters_quantity=\"1\" centered_content=\"1\" enable_lazy_loading=\"yes\"][/services]\n[testimonials style=\"1\" title=\"What’s People Say’s\" subtitle=\"Top Properties\" description=\"Our seasoned team excels in real estate with years of successful market navigation, offering informed decisions and optimal results.\" testimonial_ids=\"1,2,3,4\" background_color=\"#f7f7f7\" enable_lazy_loading=\"yes\"][/testimonials]\n[faqs title=\"Quick Answers To Questions\" subtitle=\"FAQs\" category_ids=\"1,2,3,4\" display_type=\"list\" limit=\"5\" expand_first_time=\"1\" enable_lazy_loading=\"yes\"][/faqs]\n[call-to-action title=\"List your Properties on Homzen, join Us Now!\" subtitle=\"Become Partners\" button_label=\"Become A Hosting\" button_url=\"/\" image=\"pages/call-to-action.png\" enable_lazy_loading=\"yes\"][/call-to-action]',1,NULL,'full-width',NULL,'published','2025-02-24 18:30:49','2025-02-24 18:30:49'),(9,'FAQs','[faqs category_ids=\"1,2,3\" display_type=\"group\" expand_first_time=\"1\" enable_lazy_loading=\"yes\"][/faqs]',1,NULL,NULL,NULL,'published','2025-02-24 18:30:49','2025-02-24 18:30:49'),(10,'About Us','[about-us title=\"Welcome To The &lt;br&gt; Homzen\" description=\"Welcome to Homzen, where we turn houses into homes and dreams into reality. At Homzen, we understand that a home is more than just a physical space; it\'s a place where memories are created, families grow, and life unfolds.\" button_label=\"Learn More\" button_url=\"/\" image=\"pages/about-us-video.jpg\" video_url=\"https://youtu.be/tRxGSHL8bI0\"][/about-us]\n[services style=\"3\" title=\"Discover What Sets Our Real Estate Expertise Apart\" subtitle=\"Why Choose Us\" description=\"At Homzen, our unwavering commitment lies in crafting unparalleled real estate journeys. Our seasoned professionals, armed with extensive market knowledge, walk alongside you through every phase of your property endeavor. We prioritize understanding your unique aspirations, tailoring our expertise to match your vision.\" checklist=\"Transparent Partnerships,Proven Expertise,Customized Solutions,Local Area Knowledge\" background_color=\"#f7f7f7\" services_quantity=\"3\" services_title_1=\"Buy A New Home\" services_description_1=\"Discover your dream home effortlessly. Explore diverse properties and expert guidance for a seamless buying experience.\" services_button_label_1=\"Learn More\" services_button_url_1=\"/\" services_icon_image_1=\"pages/service-1.png\" services_title_2=\"Rent A Home\" services_description_2=\"Discover your perfect rental effortlessly. Explore a diverse variety of listings tailored precisely to suit your unique lifestyle needs.\" services_button_label_2=\"Learn More\" services_button_url_2=\"/\" services_icon_image_2=\"pages/service-2.png\" services_title_3=\"Sell A Home\" services_description_3=\"Sell confidently with expert guidance and effective strategies, showcasing your property\'s best features for a successful sale.\" services_button_label_3=\"Learn More\" services_button_url_3=\"/\" services_icon_image_3=\"pages/service-3.png\" counters_quantity=\"1\" button_label=\"Contact Us\" button_url=\"/contact-us\" centered_content=\"\" enable_lazy_loading=\"yes\"][/services]\n[testimonials style=\"2\" title=\"What’s People Say’s\" subtitle=\"Top Properties\" testimonial_ids=\"1,2,3,4\" background_color=\"#f7f7f7\" enable_lazy_loading=\"yes\"][/testimonials]\n[image-slider background_color=\"transparent\" quantity=\"7\" name_1=\"GitHub\" image_1=\"partners/github.png\" url_1=\"https://github.com\" open_in_new_tab_1=\"\" name_2=\"LH.Tech\" image_2=\"partners/lhtech.png\" url_2=\"https://lhtech.com.my\" open_in_new_tab_2=\"\" name_3=\"Panadoxn\" image_3=\"partners/panadoxn.png\" url_3=\"/\" open_in_new_tab_3=\"\" name_4=\"Shangxi\" image_4=\"partners/shangxi.png\" url_4=\"/\" open_in_new_tab_4=\"\" name_5=\"Tyaalpha\" image_5=\"partners/tyaalpha.png\" url_5=\"/\" open_in_new_tab_5=\"\" name_6=\"Vanfaba\" image_6=\"partners/vanfaba.png\" url_6=\"/\" open_in_new_tab_6=\"\" name_7=\"Asana\" image_7=\"partners/asana.png\" url_7=\"https://asana.com\" open_in_new_tab_7=\"\" enable_lazy_loading=\"yes\"][/image-slider]\n[contact-form display_fields=\"phone,email,subject,address\" mandatory_fields=\"email\" style=\"2\" title=\"We\'re Always Eager To Hear From You!\" subtitle=\"Contact Us\" description=\"Sed ullamcorper nulla egestas at. Aenean eget tortor nec elit sagittis molestie. Pellentesque tempus massa in.r nulla egestas at. Aenean eget tortor nec elit sagittis mole\" background_image=\"pages/about-us-contact.jpg\"][/contact-form]\n[agents style=\"1\" title=\"Meet Our Agents\" subtitle=\"Our Teams\" account_ids=\"1,2,3,4\" items_per_row=\"4\" enable_lazy_loading=\"yes\"][/agents]\n[call-to-action title=\"List your Properties on Homzen, join Us Now!\" subtitle=\"Become Partners\" button_label=\"Become A Hosting\" button_url=\"/\" image=\"pages/call-to-action.png\" enable_lazy_loading=\"yes\"][/call-to-action]',1,NULL,'full-width',NULL,'published','2025-02-24 18:30:49','2025-02-24 18:30:49'),(11,'Pricing Plans','[pricing-plan title=\"Our Subscription\" subtitle=\"Pricing\" package_ids=\"1,2,3,4\" enable_lazy_loading=\"yes\"][/pricing-plan]\n[faqs title=\"Quick Answers To Questions\" subtitle=\"FAQs\" category_ids=\"1\" display_type=\"list\" limit=\"5\" expand_first_time=\"1\" enable_lazy_loading=\"yes\"][/faqs]',1,NULL,NULL,NULL,'published','2025-02-24 18:30:49','2025-02-24 18:30:49'),(12,'Privacy Policy','[content-tab title=\"Terms Of Use\" quantity=\"5\" title_1=\"Terms\" content_1=\"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer sed euismod justo, sit amet efficitur dui. Aliquam sodales vestibulum velit, eget sollicitudin quam. Donec non aliquam eros. Etiam sit amet lectus vel justo dignissim condimentum. In malesuada neque quis libero laoreet posuere. In consequat vitae ligula quis rutrum. Morbi dolor orci, maximus a pulvinar sed, bibendum ac lacus. Suspendisse in consectetur lorem. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Aliquam elementum, est sed interdum cursus, felis ex pharetra nisi, ut elementum tortor urna eu nulla. Donec rhoncus in purus quis blandit. Etiam eleifend metus at nunc ultricies facilisis. Morbi finibus tristique interdum. Nullam vel eleifend est, eu posuere risus. Vestibulum ligula ex, ullamcorper sit amet molestie\" title_2=\"Limitations\" content_2=\"Etiam eleifend metus at nunc ultricies facilisis. Morbi finibus tristique interdum. Nullam vel eleifend est, eu posuere risus. Vestibulum ligula ex, ullamcorper sit amet molestie a, finibus nec ex. Aliquam elementum, est sed interdum cursus, felis ex pharetra nisi, ut elementum tortor urna eu nulla. Donec rhoncus in purus quis blandit. Etiam eleifend metus at nunc ultricies facilisis. Nullam vel eleifend est, eu posuere risus. Vestibulum ligula ex, ullamcorper sit amet molestie a, finibus nec ex. Etiam eleifend metus at nunc ultricies facilisis. Morbi finibus tristique interdum. Nullam vel eleifend est, eu posuere risus. Vestibulum ligula ex, ullamcorper sit amet molestie\" title_3=\"Revisions and errata\" content_3=\"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer sed euismod justo, sit amet efficitur dui. Aliquam sodales vestibulum velit, eget sollicitudin quam. Donec non aliquam eros. Etiam sit amet lectus vel justo dignissim condimentum. In malesuada neque quis libero laoreet posuere. In consequat vitae ligula quis rutrum. Morbi dolor orci, maximus a pulvinar sed, bibendum ac lacus. Suspendisse in consectetur lorem. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Aliquam elementum, est sed interdum cursus, felis ex pharetra nisi, ut elementum tortor urna eu nulla. Donec rhoncus in purus quis Etiam eleifend metus at nunc ultricies facilisis. Morbi finibus tristique interdum. Nullam vel eleifend est, eu posuere risus. Vestibulum ligula ex, ullamcorper sit amet molestie a, finibus nec ex.\" title_4=\"Site terms of use modifications\" content_4=\"Etiam eleifend metus at nunc ultricies facilisis. Morbi finibus tristique interdum. Nullam vel eleifend est, eu posuere risus. Vestibulum ligula ex, ullamcorper sit amet molestie Aliquam elementum, est sed interdum cursus, felis ex pharetra nisi, ut elementum tortor urna eu nulla. Donec rhoncus in purus quis blandit. Etiam eleifend metus at nunc ultricies facilisis. Nullam vel eleifend est, eu posuere risus. Vestibulum ligula ex, ullamcorper sit amet molestie a, finibus nec ex. Etiam eleifend metus at nunc ultricies facilisis. Morbi finibus tristique interdum. Nullam vel eleifend est, eu posuere risus. Vestibulum ligula ex, ullamcorper sit amet molestie\" title_5=\"Risks\" content_5=\"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer sed euismod justo, sit amet efficitur dui. Aliquam sodales vestibulum velit, eget sollicitudin quam. Donec non aliquam eros. Etiam sit amet lectus vel justo dignissim condimentum. In malesuada neque quis libero laoreet posuere. In consequat vitae ligula quis rutrum. Morbi dolor orci, maximus a pulvinar sed, bibendum ac lacus. Suspendisse in consectetur lorem. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Aliquam elementum, est sed interdum cursus, felis ex pharetra nisi, ut elementum tortor urna eu nulla. Donec rhoncus in purus quis blandit. Etiam eleifend metus at nunc ultricies facilisis. Morbi finibus tristique interdum. Nullam vel eleifend est, eu posuere risus. Vestibulum ligula ex, ullamcorper sit amet molestie\" enable_lazy_loading=\"yes\"][/content-tab]',1,NULL,NULL,NULL,'published','2025-02-24 18:30:49','2025-02-24 18:30:49'),(13,'Coming Soon','[coming-soon title=\"Get Notified When We Launch\" countdown_time=\"2025-03-27 01:30:49\" address=\"58 Street Commercial Road Fratton, Australia\" hotline=\"+123456789\" business_hours=\"Mon – Sat: 8 am – 5 pm, Sunday: CLOSED\" show_social_links=\"1\" image=\"pages/properties.png\"][/coming-soon]',1,NULL,'no-layout',NULL,'published','2025-02-24 18:30:49','2025-02-24 18:30:49'),(14,'Properties','',1,NULL,'no-layout',NULL,'published','2025-02-24 18:30:49','2025-02-24 18:30:49'),(15,'Projects','',1,NULL,'no-layout',NULL,'published','2025-02-24 18:30:49','2025-02-24 18:30:49'),(16,'Cookie Policy','<h3>EU Cookie Consent</h3><p>To use this website we are using Cookies and collecting some Data. To be compliant with the EU GDPR we give you to choose if you allow us to use certain Cookies and to collect some Data.</p><h4>Essential Data</h4><p>The Essential Data is needed to run the Site you are visiting technically. You can not deactivate them.</p><p>- Session Cookie: PHP uses a Cookie to identify user sessions. Without this Cookie the Website is not working.</p><p>- XSRF-Token Cookie: Laravel automatically generates a CSRF \"token\" for each active user session managed by the application. This token is used to verify that the authenticated user is the one actually making the requests to the application.</p>',1,NULL,NULL,NULL,'published','2025-02-24 18:30:49','2025-02-24 18:30:49');

--
-- Table structure for table `pages_translations`
--

CREATE TABLE `pages_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pages_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`pages_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages_translations`
--


--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_reset_tokens`
--


--
-- Table structure for table `payment_logs`
--

CREATE TABLE `payment_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `payment_method` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `request` longtext COLLATE utf8mb4_unicode_ci,
  `response` longtext COLLATE utf8mb4_unicode_ci,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_logs`
--


--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `currency` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL DEFAULT '0',
  `charge_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_channel` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` decimal(15,2) unsigned NOT NULL,
  `order_id` bigint unsigned DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
  `payment_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'confirm',
  `customer_id` bigint unsigned DEFAULT NULL,
  `refunded_amount` decimal(15,2) unsigned DEFAULT NULL,
  `refund_note` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `customer_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `metadata` mediumtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payments`
--


--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--


--
-- Table structure for table `post_categories`
--

CREATE TABLE `post_categories` (
  `category_id` bigint unsigned NOT NULL,
  `post_id` bigint unsigned NOT NULL,
  KEY `post_categories_category_id_index` (`category_id`),
  KEY `post_categories_post_id_index` (`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `post_categories`
--

INSERT INTO `post_categories` VALUES (1,1),(5,1),(4,2),(1,2),(5,3),(6,4),(4,4),(3,5),(5,6),(2,6),(1,7),(6,7),(6,8),(3,8),(1,9),(4,9),(1,10),(4,10),(1,11),(4,11),(2,12),(3,12),(6,13),(2,14),(4,14),(2,15),(4,16),(2,16),(1,17),(2,18),(6,18);

--
-- Table structure for table `post_tags`
--

CREATE TABLE `post_tags` (
  `tag_id` bigint unsigned NOT NULL,
  `post_id` bigint unsigned NOT NULL,
  KEY `post_tags_tag_id_index` (`tag_id`),
  KEY `post_tags_post_id_index` (`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `post_tags`
--

INSERT INTO `post_tags` VALUES (7,1),(5,1),(8,2),(5,2),(7,2),(8,3),(7,3),(5,4),(4,4),(3,4),(5,5),(8,5),(4,5),(3,6),(1,6),(8,6),(3,7),(8,7),(7,8),(1,8),(8,8),(1,9),(7,9),(4,9),(1,10),(6,10),(7,11),(1,11),(7,12),(2,12),(5,12),(4,13),(2,13),(6,13),(2,14),(5,14),(6,14),(1,15),(2,15),(6,16),(3,16),(2,17),(4,17),(5,17),(2,18),(4,18);

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `author_id` bigint unsigned DEFAULT NULL,
  `author_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_featured` tinyint unsigned NOT NULL DEFAULT '0',
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `views` int unsigned NOT NULL DEFAULT '0',
  `format_type` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `posts_status_index` (`status`),
  KEY `posts_author_id_index` (`author_id`),
  KEY `posts_author_type_index` (`author_type`),
  KEY `posts_created_at_index` (`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` VALUES (1,'Top 10 Tips for First-time Home Buyers','IS that to be seen--everything seemed to follow, except a tiny golden key, and Alice\'s elbow was pressed hard against it, that attempt proved a failure. Alice heard it say to itself \'The Duchess!.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',1,'posts/4.jpg',1251,NULL,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(2,'How to Stage Your Home for a Quick Sale','Then she went on, \'and most things twinkled after that--only the March Hare. \'I didn\'t know it was very fond of beheading people here; the great hall, with the Queen,\' and she was quite a crowd of.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',0,'posts/7.jpg',2282,NULL,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(3,'Understanding the Current Real Estate Market Trends','King was the matter worse. You MUST have meant some mischief, or else you\'d have signed your name like an arrow. The Cat\'s head with great curiosity. \'It\'s a friend of mine--a Cheshire Cat,\' said.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',1,'posts/6.jpg',1558,NULL,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(4,'DIY Home Improvement Projects That Add Value','I--\' \'Oh, don\'t bother ME,\' said Alice in a moment. \'Let\'s go on in a minute. Alice began telling them her adventures from the time he had to run back into the court, she said to herself \'That\'s.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',1,'posts/8.jpg',253,NULL,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(5,'A Beginner’s Guide to Real Estate Investing','I to do?\' said Alice. \'Why, SHE,\' said the Hatter. He came in with the Gryphon. \'Turn a somersault in the prisoner\'s handwriting?\' asked another of the Rabbit\'s voice along--\'Catch him, you by the.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',0,'posts/10.jpg',565,NULL,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(6,'How to Choose the Right Neighborhood for Your Family','Alice coming. \'There\'s PLENTY of room!\' said Alice very meekly: \'I\'m growing.\' \'You\'ve no right to grow here,\' said the Pigeon; \'but I haven\'t had a vague sort of use in crying like that!\' By this.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',0,'posts/2.jpg',1537,NULL,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(7,'Luxury Homes: What to Look For','I\'m not used to it in a furious passion, and went to school every day--\' \'I\'VE been to her, though, as they used to call him Tortoise--\' \'Why did they draw?\' said Alice, in a low voice, to the part.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',1,'posts/7.jpg',2065,NULL,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(8,'Property Management: Best Practices for Landlords','VERY tired of being upset, and their slates and pencils had been of late much accustomed to usurpation and conquest. Edwin and Morcar, the earls of Mercia and Northumbria--\"\' \'Ugh!\' said the Mock.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',1,'posts/5.jpg',2079,NULL,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(9,'Renovation Ideas to Increase Your Home’s Value','Panther received knife and fork with a little three-legged table, all made a rush at the cook, and a crash of broken glass. \'What a curious dream!\' said Alice, in a very difficult question. However.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',0,'posts/4.jpg',638,NULL,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(10,'The Ultimate Guide to Buying a Vacation Home','I can\'t quite follow it as you are; secondly, because they\'re making such VERY short remarks, and she thought to herself. \'Of the mushroom,\' said the Queen. An invitation for the baby, and not to.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',1,'posts/3.jpg',392,NULL,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(11,'How to Successfully Sell Your Home in a Buyer’s Market','I was sent for.\' \'You ought to be no chance of getting up and saying, \'Thank you, sir, for your walk!\" \"Coming in a hurried nervous manner, smiling at everything that was said, and went by without.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',1,'posts/5.jpg',383,NULL,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(12,'Home Inspection: What to Expect and How to Prepare','Alice, \'I\'ve often seen a rabbit with either a waistcoat-pocket, or a worm. The question is, what did the archbishop find?\' The Mouse did not venture to say it out loud. \'Thinking again?\' the.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',1,'posts/9.jpg',1670,NULL,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(13,'Eco-friendly Home Improvements for Sustainable Living','Alice looked at it uneasily, shaking it every now and then; such as, that a red-hot poker will burn you if you please! \"William the Conqueror, whose cause was favoured by the officers of the trees.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',1,'posts/8.jpg',868,NULL,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(14,'How to Navigate the Mortgage Process','NOT marked \'poison,\' it is almost certain to disagree with you, sooner or later. However, this bottle was a very long silence, broken only by an occasional exclamation of \'Hjckrrh!\' from the.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',1,'posts/3.jpg',102,NULL,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(15,'Real Estate Market Analysis: What You Need to Know','And the Eaglet bent down its head down, and felt quite unhappy at the end.\' \'If you do. I\'ll set Dinah at you!\' There was a large mushroom growing near her, she began, rather timidly, saying to her.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',1,'posts/3.jpg',690,NULL,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(16,'Tips for Renting Out Your Property','Twinkle, twinkle--\"\' Here the Queen had never done such a capital one for catching mice--oh, I beg your acceptance of this elegant thimble\'; and, when it had come to the Dormouse, after thinking a.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',0,'posts/3.jpg',176,NULL,'2025-02-24 18:30:44','2025-02-24 18:30:44'),(17,'Understanding Property Taxes and How to Lower Them','Please, Ma\'am, is this New Zealand or Australia?\' (and she tried the effect of lying down with wonder at the window.\' \'THAT you won\'t\' thought Alice, \'and those twelve creatures,\' (she was so much.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',0,'posts/6.jpg',1944,NULL,'2025-02-24 18:30:45','2025-02-24 18:30:45'),(18,'The Benefits of Smart Home Technology','And here Alice began in a natural way again. \'I wonder what Latitude or Longitude either, but thought they were nice grand words to say.) Presently she began shrinking directly. As soon as look at.','<h5>Understanding Housing Stocks</h5>\n<p>\n    Housing stocks encompass companies involved in\n    various aspects of the real estate industry, including home builders, developers, and\n    related service providers. Factors influencing these stocks range from interest\n    rates and economic indicators to trends in home ownership rates.\n</p>\n<p>\n    Pay close attention to economic indicators such as\n    employment rates, GDP growth, and consumer confidence. A strong economy often\n    correlates with increased demand for housing, benefiting related stocks.\n</p>\n[content-quote message=\"Lower rates can boost home buying activity, benefiting housing stocks, while higher rates may have the opposite effect.\" author=\"Nelson Mandela\"][/content-quote]\n\n[content-image number_of_columns=\"col-2\" quantity=\"2\" image_1=\"posts/md-1.jpg\" image_2=\"posts/md-2.jpg\"][/content-image]\n\n<h5>Identify Emerging Trends</h5>\n<p>\n    Stay informed about emerging trends in the housing\n    market, such as the demand for sustainable homes, technological advancements, and\n    demographic shifts. Companies aligning with these trends may present attractive\n    investment opportunities.\n</p>\n<p>\n    Take a long-term investment approach if you believe in\n    the stability and growth potential of the housing sector. Look for companies with\n    solid fundamentals and a track record of success. For short-term traders, capitalize\n    on market fluctuations driven by economic reports, interest rate changes, or\n    industry-specific news. Keep a close eye on earnings reports and government housing\n    data releases.\n</p>\n\n<ul>\n    <li><strong>Affordability:</strong> Compared to larger apartments, 1BHK units are more budget-friendly, making them\n        ideal for individuals and young professionals.\n    </li>\n    <li><strong>Convenience:</strong> These apartments are easier to maintain and are perfect for those who prefer a minimalist\n        lifestyle.\n    </li>\n    <li><strong>Modern Amenities:</strong> Many 1BHK apartments in Dubai come with state-of-the-art facilities such as\n        gyms, swimming pools, and 24/7 security.\n    </li>\n</ul>\n','published',1,'Botble\\ACL\\Models\\User',0,'posts/7.jpg',2183,NULL,'2025-02-24 18:30:45','2025-02-24 18:30:45');

--
-- Table structure for table `posts_translations`
--

CREATE TABLE `posts_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `posts_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`posts_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `posts_translations`
--


--
-- Table structure for table `re_account_activity_logs`
--

CREATE TABLE `re_account_activity_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `action` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `reference_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(39) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `re_account_activity_logs_account_id_index` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_account_activity_logs`
--


--
-- Table structure for table `re_account_packages`
--

CREATE TABLE `re_account_packages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `account_id` bigint unsigned NOT NULL,
  `package_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_account_packages`
--


--
-- Table structure for table `re_account_password_resets`
--

CREATE TABLE `re_account_password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `re_account_password_resets_email_index` (`email`),
  KEY `re_account_password_resets_token_index` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_account_password_resets`
--


--
-- Table structure for table `re_accounts`
--

CREATE TABLE `re_accounts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `gender` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar_id` bigint unsigned DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `phone` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `credits` int unsigned DEFAULT NULL,
  `confirmed_at` datetime DEFAULT NULL,
  `email_verify_token` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `is_public_profile` tinyint(1) NOT NULL DEFAULT '0',
  `company` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` bigint unsigned DEFAULT NULL,
  `state_id` bigint unsigned DEFAULT NULL,
  `city_id` bigint unsigned DEFAULT NULL,
  `approved_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `re_accounts_email_unique` (`email`),
  UNIQUE KEY `re_accounts_username_unique` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_accounts`
--

INSERT INTO `re_accounts` VALUES (1,'Shanelle','Jerde','King said to herself \'It\'s.',NULL,'john.smith@botble.com','candelarioherman','$2y$12$PA7PIpTztmlrF288JP4rXumVi94y6pKqMksj20VEkUvlU82PmcC8m',12,'2018-08-15','+15622226394',10,'2025-02-25 01:30:36',NULL,NULL,'2025-02-24 18:30:36','2025-02-24 18:30:36',0,1,NULL,NULL,NULL,NULL,'2025-02-25 01:30:36'),(2,'Layne','Ebert','Allow me to him: She gave me.',NULL,'agent@botble.com','larissalegros','$2y$12$AowFLd91DcA0MvENPRlWE.WRWSFLsa3Q/rEmOaFNMASwkfzv84ik.',18,'1986-12-21','+13512253560',10,'2025-02-25 01:30:36',NULL,NULL,'2025-02-24 18:30:37','2025-02-24 18:30:37',0,1,NULL,NULL,NULL,NULL,'2025-02-25 01:30:36'),(3,'Geo','Jacobson','Dormouse. \'Fourteenth of.',NULL,'parisian.ashley@schaefer.info','geovanny28','$2y$12$IYkxSbtEt53hEDumGnNPVOd8f8UacOg0.RVJ.qOwj2Wu940hPZYVO',16,'2022-06-29','+13089441225',9,'2025-02-25 01:30:36',NULL,NULL,'2025-02-24 18:30:37','2025-02-24 18:30:37',1,1,NULL,NULL,NULL,NULL,'2025-02-25 01:30:36'),(4,'Camden','Douglas','I learn music.\' \'Ah! that.',NULL,'rosario.stoltenberg@hotmail.com','oconnellretta','$2y$12$5nl0lvrvGZLO5AIFW9CwPu1mOG/A7WZt3VLEXj3qh5jplj65Z/YZC',22,'2020-03-31','+18646151767',9,'2025-02-25 01:30:36',NULL,NULL,'2025-02-24 18:30:37','2025-02-24 18:30:37',1,1,NULL,NULL,NULL,NULL,'2025-02-25 01:30:36'),(5,'Enrique','Erdman','It was so full of the jury.',NULL,'rutherford.gretchen@hotmail.com','ubashirian','$2y$12$ox6F4FBgmRBY4kvm.gRqlOUowrqEe4igj1q2HMtzsIM43E1oGTnLG',12,'1973-10-04','+15748484402',4,'2025-02-25 01:30:36',NULL,NULL,'2025-02-24 18:30:38','2025-02-24 18:30:38',0,1,NULL,NULL,NULL,NULL,'2025-02-25 01:30:36'),(6,'Tremayne','Batz','Rabbit was no time she\'d.',NULL,'destiny83@stamm.com','charlie73','$2y$12$Uvz6PCBh5SDzmPWcmXbYYexDNJ6wDWz4DE.CeBRYmBcHEdfH5sU9.',18,'1995-07-09','+17854734510',9,'2025-02-25 01:30:36',NULL,NULL,'2025-02-24 18:30:38','2025-02-24 18:30:38',1,1,NULL,NULL,NULL,NULL,'2025-02-25 01:30:36'),(7,'Ardella','O\'Connell','Mock Turtle is.\' \'It\'s the.',NULL,'prohaska.rubie@hotmail.com','elyssacummerata','$2y$12$drwI2Q8dASaoTVtT2X2Hveu7Q5nfwgc36cUfoHQ8SL/NaaxanDy0C',12,'2024-11-26','+18085994764',1,'2025-02-25 01:30:36',NULL,NULL,'2025-02-24 18:30:38','2025-02-24 18:30:38',0,1,NULL,NULL,NULL,NULL,'2025-02-25 01:30:36'),(8,'Adelia','Hermann','And here poor Alice began in.',NULL,'reanna68@halvorson.com','devante41','$2y$12$/vsHHul3wrQsLPR1fheKduggvY.InE6boTLQTzqgYuixhSUMtdgpK',20,'2016-10-02','+19372404429',4,'2025-02-25 01:30:36',NULL,NULL,'2025-02-24 18:30:39','2025-02-24 18:30:39',0,1,NULL,NULL,NULL,NULL,'2025-02-25 01:30:36'),(9,'Wilmer','Johnston','Pigeon, raising its voice to.',NULL,'rmertz@weissnat.biz','alverta47','$2y$12$3fuivwMVhSwzjN0PJ8z/xOZIL68ZfaBTSf9W2quKt7zu8GtfHIQXi',12,'2020-12-01','+17024751710',1,'2025-02-25 01:30:36',NULL,NULL,'2025-02-24 18:30:39','2025-02-24 18:30:39',0,1,NULL,NULL,NULL,NULL,'2025-02-25 01:30:36'),(10,'Pascale','Zboncak','I will just explain to you.',NULL,'emard.johann@baumbach.com','toni04','$2y$12$WCnA8eBDb1LwN4HC5fufuOL2aRV7LleCejXkRvJgEq6PHl7THFMhy',14,'1982-01-09','+12768721787',7,'2025-02-25 01:30:36',NULL,NULL,'2025-02-24 18:30:39','2025-02-24 18:30:39',1,1,NULL,NULL,NULL,NULL,'2025-02-25 01:30:36'),(11,'Cheyenne','Watsica','KNOW IT TO BE TRUE--\" that\'s.',NULL,'metz.tate@nitzsche.biz','ogreenholt','$2y$12$qEUReOj3eVmGENyn.z.bVOpihzp8yZswtjgUN7qmCua4HxI4tYuwq',15,'2023-12-02','+16616516992',4,'2025-02-25 01:30:36',NULL,NULL,'2025-02-24 18:30:39','2025-02-24 18:30:39',0,1,NULL,NULL,NULL,NULL,'2025-02-25 01:30:36'),(12,'Sedrick','Conn','King said, for about the.',NULL,'kellen22@yahoo.com','davontehoppe','$2y$12$Bf6ucPUMiYDCXO1b64PUwe3VDc6MddSCxKdESq0lJiUmL8CA1iKfS',17,'1998-05-07','+19203286430',10,'2025-02-25 01:30:36',NULL,NULL,'2025-02-24 18:30:40','2025-02-24 18:30:40',0,1,NULL,NULL,NULL,NULL,'2025-02-25 01:30:36');

--
-- Table structure for table `re_accounts_translations`
--

CREATE TABLE `re_accounts_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `re_accounts_id` bigint unsigned NOT NULL,
  `first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`re_accounts_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_accounts_translations`
--


--
-- Table structure for table `re_categories`
--

CREATE TABLE `re_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `order` int unsigned NOT NULL DEFAULT '0',
  `is_default` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `parent_id` bigint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_categories`
--

INSERT INTO `re_categories` VALUES (1,'Apartment',NULL,'published',0,1,'2025-02-24 18:30:35','2025-02-24 18:30:35',0),(2,'Villa',NULL,'published',1,0,'2025-02-24 18:30:35','2025-02-24 18:30:35',0),(3,'Condo',NULL,'published',2,0,'2025-02-24 18:30:35','2025-02-24 18:30:35',0),(4,'House',NULL,'published',3,0,'2025-02-24 18:30:35','2025-02-24 18:30:35',0),(5,'Land',NULL,'published',4,0,'2025-02-24 18:30:35','2025-02-24 18:30:35',0),(6,'Commercial property',NULL,'published',5,0,'2025-02-24 18:30:35','2025-02-24 18:30:35',0);

--
-- Table structure for table `re_categories_translations`
--

CREATE TABLE `re_categories_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `re_categories_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`re_categories_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_categories_translations`
--


--
-- Table structure for table `re_consult_custom_field_options`
--

CREATE TABLE `re_consult_custom_field_options` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `custom_field_id` bigint unsigned NOT NULL,
  `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL DEFAULT '999',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_consult_custom_field_options`
--


--
-- Table structure for table `re_consult_custom_field_options_translations`
--

CREATE TABLE `re_consult_custom_field_options_translations` (
  `re_consult_custom_field_options_id` bigint unsigned NOT NULL,
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`re_consult_custom_field_options_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_consult_custom_field_options_translations`
--


--
-- Table structure for table `re_consult_custom_fields`
--

CREATE TABLE `re_consult_custom_fields` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `placeholder` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int NOT NULL DEFAULT '999',
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `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 `re_consult_custom_fields`
--

INSERT INTO `re_consult_custom_fields` VALUES (1,'date',0,'Schedule a Tour (optional)',NULL,999,'published','2025-02-24 18:30:51','2025-02-24 18:30:51');

--
-- Table structure for table `re_consult_custom_fields_translations`
--

CREATE TABLE `re_consult_custom_fields_translations` (
  `re_consult_custom_fields_id` bigint unsigned NOT NULL,
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `placeholder` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`re_consult_custom_fields_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_consult_custom_fields_translations`
--


--
-- Table structure for table `re_consults`
--

CREATE TABLE `re_consults` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `project_id` bigint unsigned DEFAULT NULL,
  `property_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(39) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `custom_fields` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unread',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_consults`
--


--
-- Table structure for table `re_coupons`
--

CREATE TABLE `re_coupons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` decimal(8,2) NOT NULL,
  `quantity` int DEFAULT NULL,
  `total_used` int unsigned NOT NULL DEFAULT '0',
  `expires_date` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `re_coupons_code_unique` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_coupons`
--


--
-- Table structure for table `re_currencies`
--

CREATE TABLE `re_currencies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `symbol` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_prefix_symbol` tinyint unsigned NOT NULL DEFAULT '0',
  `decimals` tinyint unsigned NOT NULL DEFAULT '0',
  `order` int unsigned NOT NULL DEFAULT '0',
  `is_default` tinyint NOT NULL DEFAULT '0',
  `exchange_rate` double NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_currencies`
--

INSERT INTO `re_currencies` VALUES (1,'USD','$',1,0,0,1,1,'2025-02-24 18:30:35','2025-02-24 18:30:35'),(2,'EUR','€',0,0,1,0,0.91,'2025-02-24 18:30:35','2025-02-24 18:30:35'),(3,'VND','₫',0,0,2,0,23717.5,'2025-02-24 18:30:35','2025-02-24 18:30:35');

--
-- Table structure for table `re_custom_field_options`
--

CREATE TABLE `re_custom_field_options` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `custom_field_id` bigint unsigned NOT NULL,
  `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL DEFAULT '999',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_custom_field_options`
--


--
-- Table structure for table `re_custom_field_options_translations`
--

CREATE TABLE `re_custom_field_options_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `re_custom_field_options_id` bigint unsigned NOT NULL,
  `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`re_custom_field_options_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_custom_field_options_translations`
--


--
-- Table structure for table `re_custom_field_values`
--

CREATE TABLE `re_custom_field_values` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `custom_field_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `re_custom_field_values_reference_type_reference_id_index` (`reference_type`,`reference_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_custom_field_values`
--


--
-- Table structure for table `re_custom_field_values_translations`
--

CREATE TABLE `re_custom_field_values_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `re_custom_field_values_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`re_custom_field_values_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_custom_field_values_translations`
--


--
-- Table structure for table `re_custom_fields`
--

CREATE TABLE `re_custom_fields` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL DEFAULT '999',
  `is_global` tinyint(1) NOT NULL DEFAULT '0',
  `authorable_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `authorable_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `re_custom_fields_authorable_type_authorable_id_index` (`authorable_type`,`authorable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_custom_fields`
--


--
-- Table structure for table `re_custom_fields_translations`
--

CREATE TABLE `re_custom_fields_translations` (
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `re_custom_fields_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`re_custom_fields_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_custom_fields_translations`
--


--
-- Table structure for table `re_facilities`
--

CREATE TABLE `re_facilities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `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 `re_facilities`
--

INSERT INTO `re_facilities` VALUES (1,'Hospital','ti ti-hospital','published',NULL,NULL),(2,'Super Market','ti ti-shopping-cart','published',NULL,NULL),(3,'School','ti ti-school','published',NULL,NULL),(4,'Entertainment','ti ti-movie','published',NULL,NULL),(5,'Pharmacy','ti ti-pill','published',NULL,NULL),(6,'Airport','ti ti-plane-departure','published',NULL,NULL),(7,'Railways','ti ti-train','published',NULL,NULL),(8,'Bus Stop','ti ti-bus','published',NULL,NULL),(9,'Beach','ti ti-beach','published',NULL,NULL),(10,'Mall','ti ti-shopping-cart','published',NULL,NULL),(11,'Bank','ti ti-building-bank','published',NULL,NULL);

--
-- Table structure for table `re_facilities_distances`
--

CREATE TABLE `re_facilities_distances` (
  `facility_id` bigint unsigned NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `reference_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `distance` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`facility_id`,`reference_id`,`reference_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `re_facilities_distances`
--

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

--
