--
-- 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,'UVyvbfvSOHZIR1XkdSUMFMWQHTbHk2ch',1,'2024-12-08 19:21:08','2024-12-08 19:21:08','2024-12-08 19:21:08');

--
-- 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,'2024-12-09 02:21:28',NULL,1,'2024-12-08 19:21:28','2024-12-08 19:21:28'),(2,'Announcement 2','Join Us for Exclusive Open House Events This Weekend and Find Your Perfect Home!',0,NULL,NULL,0,1,'2024-12-09 02:21:28',NULL,1,'2024-12-08 19:21:28','2024-12-08 19:21:28'),(3,'Announcement 3','Take Advantage of Limited-Time Offers on Luxury Homes with Stunning Features!',0,NULL,NULL,0,1,'2024-12-09 02:21:28',NULL,1,'2024-12-08 19:21:28','2024-12-08 19:21:28'),(4,'Announcement 4','Discover Your Dream Home with Our Latest Listings and Personalized Services!',0,NULL,NULL,0,1,'2024-12-09 02:21:28',NULL,1,'2024-12-08 19:21:28','2024-12-08 19:21:28');

--
-- 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,
  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 `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','Muellermouth, Tonga','$3,128','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','2024-12-08 19:21:28','2024-12-08 19:21:28'),(2,'Data Science Specialist, Analytics Division','Gastonshire, Philippines','$4,954','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','2024-12-08 19:21:28','2024-12-08 19:21:28'),(3,'Product Marketing Manager, Growth Team','Feilport, Macedonia','$1,848','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','2024-12-08 19:21:28','2024-12-08 19:21:28'),(4,'UX/UI Designer, User Experience Team','Jackyfurt, Korea','$3,929','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','2024-12-08 19:21:28','2024-12-08 19:21:28'),(5,'Operations Manager, Supply Chain Division','Bergstromburgh, Estonia','$1,641','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','2024-12-08 19:21:28','2024-12-08 19:21:28'),(6,'Financial Analyst, Investment Group','Port Rosalinda, Chad','$4,913','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','2024-12-08 19:21:28','2024-12-08 19:21:28');

--
-- 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,'Qui rerum et accusantium harum ipsam veritatis ducimus. Facilis dolorem aut assumenda atque sit earum et. Odio similique fuga est placeat. Sapiente sit esse porro repellendus eveniet.','published',1,'Botble\\ACL\\Models\\User',NULL,0,0,0,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(2,'Selling a Home',0,'Rerum magnam minima totam adipisci. Consequatur libero et excepturi. Ducimus cupiditate officiis voluptatum voluptas est tempore.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(3,'Market Trends',0,'Est possimus eum accusantium voluptate illum voluptate. Illo harum eos odio. Nostrum quos sunt voluptatibus aliquid harum ducimus. Eius esse et unde non vel odio provident.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(4,'Home Improvement',0,'Sunt ut non laborum fugit voluptas. Maiores corporis qui consequatur a. Nobis est sed quas voluptas. Omnis rerum sint quia consequatur.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(5,'Real Estate Investing',0,'Sit mollitia ut qui et. Hic repellat qui id dolor. Dolorem rem voluptas expedita vero est maxime autem. Error corrupti nisi dolore et quia hic.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(6,'Neighborhood Guides',0,'Recusandae est vitae architecto dolor est ut suscipit. Voluptatem dolores molestiae vero.','published',1,'Botble\\ACL\\Models\\User',NULL,0,1,0,'2024-12-08 19:21:20','2024-12-08 19:21:20');

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

--
-- 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','2024-12-08 19:21:07','2024-12-08 19:21:07',NULL),(2,'Selling',1,'published','2024-12-08 19:21:07','2024-12-08 19:21:07',NULL),(3,'Renting',2,'published','2024-12-08 19:21:07','2024-12-08 19:21:07',NULL),(4,'Financing',3,'published','2024-12-08 19:21:07','2024-12-08 19:21:07',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=27 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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(2,'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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(3,'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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(4,'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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(5,'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.',1,'published','2024-12-08 19:21:07','2024-12-08 19:21:07'),(6,'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.',1,'published','2024-12-08 19:21:07','2024-12-08 19:21:07'),(7,'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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(8,'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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(9,'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.',2,'published','2024-12-08 19:21:07','2024-12-08 19:21:07'),(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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(13,'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.',3,'published','2024-12-08 19:21:07','2024-12-08 19:21:07'),(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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(16,'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.',3,'published','2024-12-08 19:21:07','2024-12-08 19:21:07'),(17,'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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(18,'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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(19,'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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(20,'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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(21,'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.',4,'published','2024-12-08 19:21:07','2024-12-08 19:21:07'),(22,'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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(23,'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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(24,'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','2024-12-08 19:21:07','2024-12-08 19:21:07'),(25,'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.',4,'published','2024-12-08 19:21:07','2024-12-08 19:21:07'),(26,'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','2024-12-08 19:21:07','2024-12-08 19:21:07');

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

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

--
-- 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','2024-12-08 19:21:26','2024-12-08 19:21:26');

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

--
-- 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=142 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

--
-- 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 (4,1),(1,1),(1,2),(3,2),(2,3),(4,3),(5,4),(4,4),(1,5),(2,6),(3,7),(2,7),(2,8),(1,8),(3,9),(2,9),(1,10),(2,10),(6,11),(4,11),(4,12),(4,13),(3,13),(2,14),(6,15),(1,15),(1,16),(6,16),(3,17),(2,17),(3,18),(1,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),(6,1),(2,1),(2,2),(8,2),(7,2),(8,3),(2,3),(3,3),(8,4),(1,4),(5,5),(7,5),(7,6),(5,6),(2,7),(1,7),(4,7),(3,8),(7,8),(1,8),(7,9),(3,9),(2,9),(6,10),(2,10),(5,10),(4,11),(1,11),(7,12),(3,12),(4,12),(6,13),(2,13),(6,14),(8,14),(2,14),(7,15),(3,15),(7,16),(5,16),(8,17),(4,17),(1,18),(2,18),(8,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 DEFAULT 'Botble\\ACL\\Models\\User',
  `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','I suppose I ought to go nearer till she too began dreaming after a minute or two, and the fan, and skurried away into the sky all the first question, you know.\' It was, no doubt: only Alice did not.','<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',1411,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(2,'How to Stage Your Home for a Quick Sale','Queen,\' and she swam about, trying to find that her idea of having the sentence first!\' \'Hold your tongue, Ma!\' said the Dodo had paused as if he wasn\'t going to remark myself.\' \'Have you seen 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/8.jpg',1569,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(3,'Understanding the Current Real Estate Market Trends','I was thinking I should think you\'ll feel it a very respectful tone, but frowning and making quite a chorus of \'There goes Bill!\' then the different branches of Arithmetic--Ambition, Distraction.','<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',2465,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(4,'DIY Home Improvement Projects That Add Value','It was all ridges and furrows; the balls were live hedgehogs, the mallets live flamingoes, and the constant heavy sobbing of the song, perhaps?\' \'I\'ve heard something splashing about in all.','<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/10.jpg',889,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(5,'A Beginner’s Guide to Real Estate Investing','I hate cats and dogs.\' It was all dark overhead; before her was another long passage, and the jury consider their verdict,\' the King had said that day. \'A likely story indeed!\' said Alice, very.','<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',2307,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(6,'How to Choose the Right Neighborhood for Your Family','I beg your pardon,\' said Alice to herself. \'Shy, they seem to dry me at home! Why, I haven\'t been invited yet.\' \'You\'ll see me there,\' said the Gryphon, \'she wants for to know what to uglify is, you.','<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/10.jpg',2171,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(7,'Luxury Homes: What to Look For','I could show you our cat Dinah: I think that proved it at all; and I\'m sure I don\'t like them!\' When the sands are all dry, he is gay as a lark, And will talk in contemptuous tones of her going.','<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/1.jpg',367,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(8,'Property Management: Best Practices for Landlords','Duchess, \'chop off her knowledge, as there was hardly room for YOU, and no more of the creature, but on second thoughts she decided on going into the air, mixed up with the end of the words don\'t.','<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',1108,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(9,'Renovation Ideas to Increase Your Home’s Value','For really this morning I\'ve nothing to do: once or twice, and shook itself. Then it got down off the cake. * * CHAPTER II. The Pool of Tears \'Curiouser and curiouser!\' cried Alice again, in 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/9.jpg',1361,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(10,'The Ultimate Guide to Buying a Vacation Home','Duchess and the small ones choked and had been would have this cat removed!\' The Queen smiled and passed on. \'Who ARE you doing out here? Run home this moment, I tell you!\' said Alice. \'Why not?\'.','<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',1336,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(11,'How to Successfully Sell Your Home in a Buyer’s Market','Alice replied very gravely. \'What else have you executed on the top of its mouth again, and made another snatch in the face. \'I\'ll put a white one in by mistake; and if I know all the rats and--oh.','<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',105,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(12,'Home Inspection: What to Expect and How to Prepare','Edwin and Morcar, the earls of Mercia and Northumbria, declared for him: and even Stigand, the patriotic archbishop of Canterbury, found it very much,\' said Alice, \'because I\'m not Ada,\' she 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',0,'posts/9.jpg',336,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(13,'Eco-friendly Home Improvements for Sustainable Living','WHAT? The other side of the Lobster Quadrille, that she wasn\'t a really good school,\' said the Pigeon. \'I can see you\'re trying to fix on one, the cook and the moon, and memory, and muchness--you.','<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',619,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(14,'How to Navigate the Mortgage Process','It 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 began fading away the moment how large she had found her head to hide 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',1,'posts/5.jpg',1320,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(15,'Real Estate Market Analysis: What You Need to Know','Duchess by this time.) \'You\'re nothing but the great question certainly was, what? Alice looked all round her, calling out in a wondering tone. \'Why, what are YOUR shoes done with?\' said the King.','<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/5.jpg',728,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(16,'Tips for Renting Out Your Property','His voice has a timid and tremulous sound.] \'That\'s different from what I say,\' the Mock Turtle yawned and shut his eyes.--\'Tell her about the reason they\'re called lessons,\' the Gryphon replied.','<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',829,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(17,'Understanding Property Taxes and How to Lower Them','I\'m I, and--oh dear, how puzzling it all came different!\' Alice replied thoughtfully. \'They have their tails in their mouths; and the fall NEVER come to the Knave of Hearts, carrying the King\'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',0,'posts/4.jpg',1942,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20'),(18,'The Benefits of Smart Home Technology','LITTLE larger, sir, if you want to go! Let me think: was I the same thing as \"I get what I eat\" is the capital of Paris, and Paris is the reason and all the children she knew she had put on his.','<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',1642,NULL,'2024-12-08 19:21:20','2024-12-08 19:21:20');

--
-- 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,'Kaya','Stroman','At this the whole window!\'.',NULL,'john.smith@botble.com','rkonopelski','$2y$12$Y2sV2fuCrSSAtyrmGmAZOOLrYz6w1x6mzav5QpDozt4v3XvZliU6G',20,'2002-01-07','+12398801712',10,'2024-12-09 02:21:09',NULL,NULL,'2024-12-08 19:21:10','2024-12-08 19:21:10',0,1,NULL,NULL,NULL,NULL,'2024-12-09 02:21:09'),(2,'Velma','Hoeger','I\'d taken the highest tree.',NULL,'agent@botble.com','padbergcallie','$2y$12$g7akgE2Rij7iS5YCwr9KJ.QVkKQ5h1UGeX9/C.3jd9FnhReDdEk1i',20,'1971-02-13','+17547707225',10,'2024-12-09 02:21:09',NULL,NULL,'2024-12-08 19:21:10','2024-12-08 19:21:10',0,1,NULL,NULL,NULL,NULL,'2024-12-09 02:21:09'),(3,'Will','Bergnaum','YOUR shoes done with?\' said.',NULL,'blanca66@lowe.com','lbarrows','$2y$12$BCsFLxD6kpKInBiuVyvMYO2YAWtw/ZhokgCuFXvtxqiE4Olyqtl2K',16,'2006-12-29','+19032479474',6,'2024-12-09 02:21:09',NULL,NULL,'2024-12-08 19:21:10','2024-12-08 19:21:10',1,1,NULL,NULL,NULL,NULL,'2024-12-09 02:21:09'),(4,'Clementina','Wehner','Caterpillar. \'Well, perhaps.',NULL,'jarrett20@boehm.net','morarmaxwell','$2y$12$o6zrTPUj67DMGg3JoGtJROPsei8EUeuOD0UI74aURoWVyc5elMAja',15,'1972-11-20','+19519269987',4,'2024-12-09 02:21:09',NULL,NULL,'2024-12-08 19:21:11','2024-12-08 19:21:11',0,1,NULL,NULL,NULL,NULL,'2024-12-09 02:21:09'),(5,'Ruthie','Hauck','Waiting in a solemn tone.',NULL,'anienow@yahoo.com','katharina49','$2y$12$P56NmptSahzWmKAamBITqerQI15jrbTgbDvySXdJdfFwt/nJH034a',16,'1996-06-30','+12194128986',6,'2024-12-09 02:21:09',NULL,NULL,'2024-12-08 19:21:11','2024-12-08 19:21:11',1,1,NULL,NULL,NULL,NULL,'2024-12-09 02:21:09'),(6,'Americo','Lueilwitz','Dormouse,\' thought Alice; \'I.',NULL,'lyda36@dubuque.org','lakingeorgianna','$2y$12$uTWiy6fNZswtzyTV3SbEv.DrUgIOjrau1l/c2/v5ViBJ6IusrL67a',21,'1997-12-28','+12485998738',5,'2024-12-09 02:21:09',NULL,NULL,'2024-12-08 19:21:12','2024-12-08 19:21:12',1,1,NULL,NULL,NULL,NULL,'2024-12-09 02:21:09'),(7,'Melvin','Collier','Duchess said after a pause.',NULL,'heidenreich.fabiola@gmail.com','zakary01','$2y$12$Z1qHk0OsNwJj0uruKs6Ah.MGwnUYP0tS4C3sHwe3WA.uo9l6IOzji',20,'1977-08-26','+18016807879',7,'2024-12-09 02:21:09',NULL,NULL,'2024-12-08 19:21:12','2024-12-08 19:21:12',0,1,NULL,NULL,NULL,NULL,'2024-12-09 02:21:09'),(8,'Everett','Walker','And welcome little fishes in.',NULL,'moen.brittany@gmail.com','timmothykeebler','$2y$12$VVQ0NHE6T2O/StN0Ba2zVOp.Ae4BrcIMCtdrrIVxef9m.hyT5.gZy',12,'1970-05-06','+12399489163',10,'2024-12-09 02:21:09',NULL,NULL,'2024-12-08 19:21:13','2024-12-08 19:21:13',1,1,NULL,NULL,NULL,NULL,'2024-12-09 02:21:09'),(9,'Domenick','Lynch','The cook threw a frying-pan.',NULL,'cmann@stracke.com','cankunding','$2y$12$sE/DWu0VwE3503W3ip9DIOiOBLlOnTbc6N1s7/thkecP8zgaLMnRW',18,'2012-05-06','+13397802025',3,'2024-12-09 02:21:09',NULL,NULL,'2024-12-08 19:21:13','2024-12-08 19:21:13',0,1,NULL,NULL,NULL,NULL,'2024-12-09 02:21:09'),(10,'Cierra','Ryan','March Hare. Alice was so.',NULL,'joyce.hagenes@leuschke.com','braunrodrick','$2y$12$X9hZ6UR2d9HMhM0CeUOpUerqEEyUNKdceS6YG0GV7RQz6kJOMF/9y',21,'1972-04-26','+17377042634',8,'2024-12-09 02:21:09',NULL,NULL,'2024-12-08 19:21:14','2024-12-08 19:21:14',1,1,NULL,NULL,NULL,NULL,'2024-12-09 02:21:09'),(11,'Jeramie','Grant','Dormouse turned out, and, by.',NULL,'pbecker@harber.info','hertha14','$2y$12$mKmBEoG/3GgWdTeKXYyg4eG5IpgVMh8.q1fY8mcMqJbYRxfLM7Kay',12,'1976-09-11','+15397447179',6,'2024-12-09 02:21:09',NULL,NULL,'2024-12-08 19:21:14','2024-12-08 19:21:14',1,1,NULL,NULL,NULL,NULL,'2024-12-09 02:21:09'),(12,'Ada','King','Alice, \'it\'ll never do to.',NULL,'joey32@hotmail.com','anjali57','$2y$12$iFYULax0Sztw7BFOuN4eU.CusZeA46FwuBiHbbBJBo7gCQTNIvjTa',23,'2021-09-19','+12694173883',7,'2024-12-09 02:21:09',NULL,NULL,'2024-12-08 19:21:15','2024-12-08 19:21:15',0,1,NULL,NULL,NULL,NULL,'2024-12-09 02:21:09');

--
-- 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,'2024-12-08 19:21:08','2024-12-08 19:21:08',0),(2,'Villa',NULL,'published',1,0,'2024-12-08 19:21:08','2024-12-08 19:21:08',0),(3,'Condo',NULL,'published',2,0,'2024-12-08 19:21:08','2024-12-08 19:21:08',0),(4,'House',NULL,'published',3,0,'2024-12-08 19:21:08','2024-12-08 19:21:08',0),(5,'Land',NULL,'published',4,0,'2024-12-08 19:21:08','2024-12-08 19:21:08',0),(6,'Commercial property',NULL,'published',5,0,'2024-12-08 19:21:08','2024-12-08 19:21:08',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','2024-12-08 19:21:28','2024-12-08 19:21:28');

--
-- 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,'2024-12-08 19:21:08','2024-12-08 19:21:08'),(2,'EUR','€',0,0,1,0,0.91,'2024-12-08 19:21:08','2024-12-08 19:21:08'),(3,'VND','₫',0,0,2,0,23717.5,'2024-12-08 19:21:08','2024-12-08 19:21:08');

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

--
