芝麻web文件管理V1.00

编辑当前文件:/home/lekhnath/silverray.com.au/database/backup/fresh_database.sql

-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 02, 2025 at 12:38 PM
-- Server version: 10.4.22-MariaDB
-- PHP Version: 8.1.2

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `topland_test`
--

-- --------------------------------------------------------

--
-- Table structure for table `about_us`
--

CREATE TABLE `about_us` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `about_us`
--

INSERT INTO `about_us` (`id`, `image`, `created_at`, `updated_at`) VALUES
(1, 'uploads/website-images/wsus-img-2024-12-31-05-16-10-8297.webp', '2024-08-26 00:03:10', '2024-12-30 23:16:10');

-- --------------------------------------------------------

--
-- Table structure for table `about_us_translations`
--

CREATE TABLE `about_us_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `about_us_id` int(11) NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `about_us` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `service` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `history` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `about_us_translations`
--

INSERT INTO `about_us_translations` (`id`, `about_us_id`, `lang_code`, `about_us`, `service`, `history`, `created_at`, `updated_at`) VALUES
(1, 1, 'en', '', '', '', '2024-08-26 00:03:10', '2025-01-02 05:37:25');

-- --------------------------------------------------------

--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_super_admin` tinyint(1) NOT NULL DEFAULT 0,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `admin_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `forget_password_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`id`, `name`, `user_name`, `email`, `image`, `password`, `is_super_admin`, `status`, `admin_type`, `remember_token`, `created_at`, `updated_at`, `forget_password_token`) VALUES
(1, 'John Doe', 'john_doe_700713', 'admin@gmail.com', 'uploads/website-images/admin.webp', '$2y$12$rMju9zxiFKuDvSQyV178ReWT0cYMx3B75.LfAbBfdOBOiMuOQ4C5m', 1, 'active', 'super_admin', 'uOjd5izfR3syYLWfj8L5C2iMcJzOMHvvziLnrQWlPDcyGnIu3i5HvCliOKK4', '2024-08-19 05:54:35', '2024-12-23 22:52:13', 'VExT0Quot7pksIus1TiyrzOgP46hhzQUDfCUEupvSiMwz1mUruFBLunRgDPqTnWXXNVaxbE4p6r9fwWCjesJsZavtlWNLVBOo1db'),
(3, 'James Robert', 'james_robert_397057', 'admin2@gmail.com', NULL, '$2y$12$35uGGgkhz/TEk9mUpPqinul4Nc80hunyBHDFPl0LACZUtLJ26H2Ce', 0, 'active', 'admin', NULL, '2024-12-08 02:27:48', '2024-12-08 02:47:03', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `aminities`
--

CREATE TABLE `aminities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `aminity_translations`
--

CREATE TABLE `aminity_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `aminity_id` int(11) NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `background_images`
--

CREATE TABLE `background_images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `home1_top_property` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `home1_testimonial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `home2_testimonial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `home3_testimonial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `home1_footer` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `home2_footer` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `home3_footer` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `service_background_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `background_images`
--

INSERT INTO `background_images` (`id`, `home1_top_property`, `agent`, `home1_testimonial`, `home2_testimonial`, `home3_testimonial`, `home1_footer`, `home2_footer`, `home3_footer`, `service_background_image`, `created_at`, `updated_at`) VALUES
(1, 'uploads/website-images/wsus-img-2024-08-15-08-24-38-6875.webp', 'uploads/website-images/wsus-img-2024-08-15-08-24-38-4626.webp', 'uploads/website-images/wsus-img-2024-08-15-08-24-38-5937.webp', NULL, 'uploads/website-images/wsus-img-2024-08-15-08-24-38-5305.webp', 'uploads/website-images/wsus-img-2024-08-15-08-24-38-8585.webp', 'uploads/website-images/wsus-img-2024-08-15-08-24-38-4094.webp', 'uploads/website-images/wsus-img-2024-08-15-08-24-38-9236.webp', 'uploads/website-images/wsus-img-2024-12-31-05-18-47-5125.webp', '2024-08-19 05:54:43', '2024-12-30 23:18:47');

-- --------------------------------------------------------

--
-- Table structure for table `banned_histories`
--

CREATE TABLE `banned_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reasone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `basic_payments`
--

CREATE TABLE `basic_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `basic_payments`
--

INSERT INTO `basic_payments` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'stripe_key', 'pk_test_33mdngCLuLsmECXOe8mbde9f00pZGT4uu9', '2024-08-19 05:54:31', '2024-12-30 22:14:34'),
(2, 'stripe_secret', 'sk_test_MroTZzRZRv2KJ9Hmaro73SE800UOR90Q9u', '2024-08-19 05:54:31', '2024-12-30 22:14:34'),
(3, 'stripe_currency_id', '1', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(4, 'stripe_status', 'active', '2024-08-19 05:54:31', '2024-12-30 22:14:34'),
(5, 'stripe_charge', '0', '2024-08-19 05:54:31', '2024-12-30 22:14:34'),
(6, 'stripe_image', 'uploads/website-images/stripe.webp', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(7, 'paypal_app_id', 'APP-80W284485P519543T', '2024-08-19 05:54:31', '2024-12-30 22:14:26'),
(8, 'paypal_client_id', 'AWlV5x8Lhj9BRF8-TnawXtbNs-zt69mMVXME1BGJUIoDdrAYz8QIeeTBQp0sc2nIL9E529KJZys32Ipy', '2024-08-19 05:54:31', '2024-12-30 22:14:26'),
(9, 'paypal_secret_key', 'EEvn1J_oIC6alxb-FoF4t8buKwy4uEWHJ4_Jd_wolaSPRMzFHe6GrMrliZAtawDDuE-WKkCKpWGiz0Yn', '2024-08-19 05:54:31', '2024-12-30 22:14:26'),
(10, 'paypal_account_mode', 'sandbox', '2024-08-19 05:54:31', '2024-12-30 22:14:26'),
(11, 'paypal_currency_id', '1', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(12, 'paypal_charge', '0', '2024-08-19 05:54:31', '2024-12-30 22:14:26'),
(13, 'paypal_status', 'active', '2024-08-19 05:54:31', '2024-12-30 22:14:26'),
(14, 'paypal_image', 'uploads/website-images/paypal.webp', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(15, 'bank_information', 'Bank Name = Your bank name\r\nAccount Number =  Your bank account number\r\nRouting Number = Your bank routing number\r\nBranch = Your bank branch name\r\nTransaction = Your bank transaction', '2024-08-19 05:54:31', '2024-12-30 22:14:18'),
(16, 'bank_status', 'active', '2024-08-19 05:54:31', '2024-12-30 22:14:18'),
(17, 'bank_image', 'uploads/website-images/bank-pay.webp', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(18, 'bank_charge', '0', '2024-08-19 05:54:31', '2024-12-30 22:14:18'),
(19, 'bank_currency_id', '1', '2024-08-19 05:54:31', '2024-08-19 05:54:31');

-- --------------------------------------------------------

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `admin_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `blog_category_id` bigint(20) UNSIGNED NOT NULL,
  `slug` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `views` bigint(20) NOT NULL DEFAULT 0,
  `show_homepage` tinyint(1) NOT NULL DEFAULT 0,
  `is_popular` tinyint(1) NOT NULL DEFAULT 0,
  `tags` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `blog_categories`
--

CREATE TABLE `blog_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `parent_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `blog_category_translations`
--

CREATE TABLE `blog_category_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `blog_category_id` bigint(20) UNSIGNED NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `blog_comments`
--

CREATE TABLE `blog_comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `blog_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `blog_translations`
--

CREATE TABLE `blog_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `blog_id` bigint(20) UNSIGNED NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `seo_title` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `careers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `salary_range` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deadline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `career_requests`
--

CREATE TABLE `career_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `career_id` int(11) NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cv` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `career_translations`
--

CREATE TABLE `career_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `career_id` int(11) NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_nature` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `office_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `cities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `country_state_id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `configurations`
--

CREATE TABLE `configurations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `config` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `configurations`
--

INSERT INTO `configurations` (`id`, `config`, `value`, `created_at`, `updated_at`) VALUES
(1, 'setup_complete', '0', '2024-08-19 05:54:36', '2024-09-02 23:57:22'),
(2, 'setup_stage', '1', '2024-08-19 05:54:36', '2024-09-02 23:57:22');

-- --------------------------------------------------------

--
-- Table structure for table `contact_information`
--

CREATE TABLE `contact_information` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `topbar_phone` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `topbar_email` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footer_phone` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footer_email` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_information`
--

INSERT INTO `contact_information` (`id`, `topbar_phone`, `topbar_email`, `footer_phone`, `footer_email`, `created_at`, `updated_at`) VALUES
(1, '111-233-1273', 'info23@website.com', '111-233-1273', 'example@gmail.com', '2024-08-19 05:54:43', '2024-08-19 05:54:43');

-- --------------------------------------------------------

--
-- Table structure for table `contact_information_translations`
--

CREATE TABLE `contact_information_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `contact_information_id` int(11) NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `footer_address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_information_translations`
--

INSERT INTO `contact_information_translations` (`id`, `contact_information_id`, `lang_code`, `footer_address`, `created_at`, `updated_at`) VALUES
(1, 1, 'en', 'San Francisco City Hall, San Francisco, CA', '2024-08-19 05:54:43', '2024-08-19 05:54:43');

-- --------------------------------------------------------

--
-- Table structure for table `contact_messages`
--

CREATE TABLE `contact_messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `contact_us_pages`
--

CREATE TABLE `contact_us_pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `phones` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `emails` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `map_embed_code` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_us_pages`
--

INSERT INTO `contact_us_pages` (`id`, `phones`, `emails`, `map_embed_code`, `created_at`, `updated_at`) VALUES
(1, '(347) 430-9510', 'support@websolutionus.com', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3153.459102763315!2d-122.42181662524695!3d37.779279211902285!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x808580997aeae663%3A0xb2706dff83574f4a!2sSan%20Francisco%20City%20Hall!5e0!3m2!1sen!2sbd!4v1723962124400!5m2!1sen!2sbd\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"no-referrer-when-downgrade\"></iframe>', '2024-08-19 05:54:43', '2024-08-19 05:54:43');

-- --------------------------------------------------------

--
-- Table structure for table `contact_us_page_translations`
--

CREATE TABLE `contact_us_page_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `contact_us_id` int(11) NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_us_page_translations`
--

INSERT INTO `contact_us_page_translations` (`id`, `contact_us_id`, `lang_code`, `address`, `created_at`, `updated_at`) VALUES
(1, 1, 'en', '95 South Park Avenue, New York, USA', '2024-08-19 05:54:43', '2024-08-19 05:54:43');

-- --------------------------------------------------------

--
-- Table structure for table `counters`
--

CREATE TABLE `counters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `counters`
--

INSERT INTO `counters` (`id`, `icon`, `qty`, `created_at`, `updated_at`) VALUES
(1, 'fas fa-building', '0', '2024-08-19 05:54:37', '2025-01-02 05:37:25'),
(2, 'fas fa-handshake', '0', '2024-08-19 05:54:37', '2025-01-02 05:37:25'),
(3, 'fas fa-home', '0', '2024-08-19 05:54:37', '2025-01-02 05:37:25'),
(4, 'fas fa-id-card', '0', '2024-08-19 05:54:37', '2025-01-02 05:37:25');

-- --------------------------------------------------------

--
-- Table structure for table `counter_translations`
--

CREATE TABLE `counter_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `counter_id` int(11) NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `counter_translations`
--

INSERT INTO `counter_translations` (`id`, `counter_id`, `lang_code`, `title`, `created_at`, `updated_at`) VALUES
(1, 1, 'en', 'Total Properties', '2024-08-19 05:54:37', '2024-08-26 05:43:38'),
(2, 2, 'en', 'Happy Clients', '2024-08-19 05:54:37', '2024-08-21 05:35:44'),
(3, 3, 'en', 'Successfull Orders', '2024-08-19 05:54:37', '2024-08-26 05:43:38'),
(4, 4, 'en', 'Our Teams', '2024-08-19 05:54:37', '2024-08-26 05:43:38');

-- --------------------------------------------------------

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

CREATE TABLE `countries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `country_states`
--

CREATE TABLE `country_states` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `country_id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customizeable_pages`
--

CREATE TABLE `customizeable_pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customizeable_pages`
--

INSERT INTO `customizeable_pages` (`id`, `title`, `slug`, `description`, `icon`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Home Page', 'homepage', NULL, NULL, 1, '2024-08-19 05:54:35', '2024-08-19 05:54:35');

-- --------------------------------------------------------

--
-- Table structure for table `customizeable_page_items`
--

CREATE TABLE `customizeable_page_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customizeable_page_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `component_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customizeable_page_items`
--

INSERT INTO `customizeable_page_items` (`id`, `customizeable_page_id`, `title`, `component_name`, `position`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'Home Page Item', 'component-1', 0, 1, '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(2, 1, 'Home Page Item 2', 'component-2', 1, 1, '2024-08-19 05:54:35', '2024-08-19 05:54:35');

-- --------------------------------------------------------

--
-- Table structure for table `custom_addons`
--

CREATE TABLE `custom_addons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `isPaid` tinyint(1) NOT NULL DEFAULT 1,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`author`)),
  `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`options`)),
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `version` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_update` date DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `custom_codes`
--

CREATE TABLE `custom_codes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `css` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `javascript` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `custom_pages`
--

CREATE TABLE `custom_pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('enable','disable') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'enable',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `custom_page_translations`
--

CREATE TABLE `custom_page_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `page_id` int(11) NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `page_name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `custom_paginations`
--

CREATE TABLE `custom_paginations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `section_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `item_qty` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `custom_paginations`
--

INSERT INTO `custom_paginations` (`id`, `section_name`, `item_qty`, `created_at`, `updated_at`) VALUES
(1, 'Blog List', 6, '2024-08-19 05:54:31', '2024-08-21 06:20:38'),
(2, 'Blog Comment', 10, '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(3, 'Language List', 10, '2024-08-19 05:54:31', '2024-09-01 22:56:42'),
(4, 'Property', 12, '2024-08-19 05:54:31', '2024-09-01 23:05:02'),
(5, 'Agent', 8, '2024-08-19 05:54:31', '2024-12-17 02:43:50'),
(6, 'Career', 6, '2024-09-02 05:18:20', '2024-09-01 23:22:29');

-- --------------------------------------------------------

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_templates`
--

INSERT INTO `email_templates` (`id`, `name`, `subject`, `message`, `created_at`, `updated_at`) VALUES
(1, 'password_reset', 'Password Reset', 'Dear {{user_name}},\n Do you want to reset your password? Please Click the following link and Reset Your Password.', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(2, 'contact_mail', 'Contact Email', 'Hello there,\n  Mr. {{name}} has sent a new message. you can see the message details below. \n Email: {{email}}\n Phone: {{phone}}\n Subject: {{subject}}\n Message: {{message}}', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(3, 'subscribe_notification', 'Subscribe Notification', 'Hi there, Congratulations! Your Subscription has been created successfully. Please Click the following link and Verified Your Subscription. If you will not approve this link, you can not get any newsletter from us.', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(4, 'social_login', 'Social Login', 'Hello {{user_name}},\n Welcome to {{app_name}}! Your account has been created successfully.\n Your password: {{password}}\n You can log in to your account at <a href=\"https://websolutionus.com\">https://websolutionus.com</a>\n Thank you for joining us.', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(5, 'user_verification', 'User Verification', 'Dear {{user_name}},\n Congratulations! Your account has been created successfully. Please click the following link to activate your account.', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(6, 'approved_refund', 'Refund Request Approval', 'Dear {{user_name}},\n We are happy to say that, we have send {{refund_amount}} USD to your provided bank information. ', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(7, 'new_refund', 'New Refund Request', 'Hello websolutionus, \n\n Mr. {{user_name}} has send a new refund request to you.', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(8, 'pending_wallet_payment', 'Wallet Payment Approval', 'Hello {{user_name}},\n We have received your wallet payment request. we find your payment to our bank account.\n Thanks & Regards', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(9, 'approved_withdraw', 'Withdraw Request Approval', 'Dear {{user_name}},\n We are happy to say that, we have send a withdraw amount to your provided bank information.\n Thanks & Regards\n WebSolutionUs', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(10, 'contact_mail_for_agent', 'Agent Contact Email', 'Hello there,\r\n Mr. {{name}} has sent a new message. you can see the message details below. \r\nEmail: {{email}}\r\nPhone: {{phone}}\r\nSubject: {{subject}}\r\nProperty Name: {{property}}\r\nMessage: {{message}}', '2024-12-07 22:51:56', '2024-12-07 23:02:08');

-- --------------------------------------------------------

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) 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()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `faqs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `faq_translations`
--

CREATE TABLE `faq_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `faq_id` bigint(20) UNSIGNED NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `question` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `answer` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES
(1, 'default', '{\"uuid\":\"6fe9baa6-7b8f-483b-87a9-db4d59e6239f\",\"displayName\":\"App\\\\Jobs\\\\GlobalMailJob\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\GlobalMailJob\",\"command\":\"O:22:\\\"App\\\\Jobs\\\\GlobalMailJob\\\":4:{s:36:\\\"\\u0000App\\\\Jobs\\\\GlobalMailJob\\u0000mail_address\\\";s:15:\\\"admin@gmail.com\\\";s:36:\\\"\\u0000App\\\\Jobs\\\\GlobalMailJob\\u0000mail_subject\\\";s:19:\\\"Agent Contact Email\\\";s:36:\\\"\\u0000App\\\\Jobs\\\\GlobalMailJob\\u0000mail_message\\\";s:298:\\\"Hello there,<\\/p>\\r\\n Mr. Ripon Chandra has sent a new message. you can see the message details below. <\\/p>\\r\\nEmail: riponchandra667@gmail.com<\\/p>\\r\\nPhone: 01745738766<\\/p>\\r\\nSubject: For Testing<\\/p>\\r\\nProperty Name: 2811 Battery Place Northwest<\\/p>\\r\\nMessage: For Testing<\\/p>\\\";s:28:\\\"\\u0000App\\\\Jobs\\\\GlobalMailJob\\u0000link\\\";a:0:{}}\"}}', 0, NULL, 1734851994, 1734851994);

-- --------------------------------------------------------

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

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `direction` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ltr',
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `is_default` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `languages` (`id`, `name`, `code`, `direction`, `status`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 'English', 'en', 'ltr', '1', '1', '2024-08-19 05:54:30', '2024-12-22 00:43:49');

-- --------------------------------------------------------

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

CREATE TABLE `menus` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `menus` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES
(1, 'Main Menu', 'main-menu', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(2, 'Footer Menu', 'footer-menu', '2024-08-19 05:54:35', '2024-08-19 05:54:35');

-- --------------------------------------------------------

--
-- Table structure for table `menu_items`
--

CREATE TABLE `menu_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `sort` int(11) NOT NULL DEFAULT 0,
  `menu_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_items`
--

INSERT INTO `menu_items` (`id`, `label`, `link`, `parent_id`, `sort`, `menu_id`, `created_at`, `updated_at`) VALUES
(1, 'Home', '/', 0, 1, 1, '2024-08-19 05:54:35', '2024-12-08 00:24:41'),
(5, 'About Us', '/about-us', 0, 2, 1, '2024-08-19 05:54:35', '2024-09-03 22:22:08'),
(6, 'Properties', '#', 0, 3, 1, '2024-08-19 05:54:35', '2024-09-03 22:22:08'),
(7, 'All Properties', '/properties?page_type=list_view', 6, 1, 1, '2024-08-19 05:54:35', '2024-09-01 06:06:20'),
(8, 'Featured Properties', '/properties?page_type=list_view&sorting_id=3', 6, 2, 1, '2024-08-19 05:54:35', '2024-09-01 06:06:20'),
(9, 'Top Properties', '/properties?page_type=list_view&sorting_id=4', 6, 3, 1, '2024-08-19 05:54:35', '2024-09-01 06:06:20'),
(10, 'Urgent Properties', '/properties?page_type=list_view&sorting_id=6', 6, 4, 1, '2024-08-19 05:54:35', '2024-09-01 06:06:20'),
(11, 'Agents', '/agents', 6, 5, 1, '2024-08-19 05:54:35', '2024-09-01 06:06:20'),
(12, 'Pricing', '/pricing-plan', 0, 4, 1, '2024-08-19 05:54:35', '2024-09-03 22:22:08'),
(13, 'Pages', '#', 0, 5, 1, '2024-08-19 05:54:35', '2024-09-03 22:22:08'),
(14, 'FAQ', '/faq', 13, 1, 1, '2024-08-19 05:54:35', '2024-09-01 06:06:20'),
(15, 'Privacy Policy', '/privacy-policy', 13, 4, 1, '2024-08-19 05:54:35', '2024-09-01 06:06:20'),
(16, 'Terms & Conditions', '/terms-and-conditions', 13, 5, 1, '2024-08-19 05:54:35', '2024-09-01 06:06:20'),
(17, 'Custom Page 1', '/page/custom-page-1', 13, 6, 1, '2024-08-19 05:54:35', '2024-09-01 06:06:20'),
(18, 'Custom Page 2', '/page/custom-page-2', 13, 7, 1, '2024-08-19 05:54:35', '2024-09-01 06:06:20'),
(19, 'Blog', '/blogs', 13, 3, 1, '2024-08-19 05:54:35', '2024-09-01 06:06:20'),
(20, 'Contact Us', '/contact-us', 0, 6, 1, '2024-08-19 05:54:35', '2024-09-03 22:22:08'),
(21, 'Short Links', '#', 0, 1, 2, '2024-08-19 05:54:35', '2024-08-21 01:49:02'),
(22, 'About Us', '/about-us', 21, 1, 2, '2024-08-19 05:54:35', '2024-08-21 01:26:38'),
(23, 'All Properties', '/properties?page_type=list_view', 21, 2, 2, '2024-08-19 05:54:35', '2024-12-05 05:32:39'),
(24, 'Blogs', '/blogs', 21, 3, 2, '2024-08-19 05:54:35', '2024-08-21 01:26:38'),
(25, 'Pricing', '/pricing-plan', 21, 4, 2, '2024-08-19 05:54:36', '2024-08-21 01:26:38'),
(26, 'Help Link', '#', 0, 2, 2, '2024-08-19 05:54:36', '2024-08-21 01:49:02'),
(27, 'Terms & Conditions', '/terms-and-conditions', 26, 1, 2, '2024-08-19 05:54:36', '2024-08-21 01:26:38'),
(28, 'Privacy Policy', '/privacy-policy', 26, 2, 2, '2024-08-19 05:54:36', '2024-08-21 01:26:38'),
(29, 'FAQ', '/faq', 26, 3, 2, '2024-08-19 05:54:36', '2024-08-21 01:26:38'),
(30, 'Contact Us', '/contact-us', 26, 4, 2, '2024-08-19 05:54:36', '2024-12-05 05:27:39'),
(33, 'Career', '/career', 13, 2, 1, '2024-09-01 06:05:44', '2024-09-01 06:06:20');

-- --------------------------------------------------------

--
-- Table structure for table `menu_item_translations`
--

CREATE TABLE `menu_item_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `menu_item_id` bigint(20) UNSIGNED NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_item_translations`
--

INSERT INTO `menu_item_translations` (`id`, `menu_item_id`, `lang_code`, `label`, `created_at`, `updated_at`) VALUES
(1, 1, 'en', 'Home', '2024-08-19 05:54:35', '2024-12-08 00:24:41'),
(5, 5, 'en', 'About Us', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(6, 6, 'en', 'Properties', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(7, 7, 'en', 'All Properties', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(8, 8, 'en', 'Featured Properties', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(9, 9, 'en', 'Top Properties', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(10, 10, 'en', 'Urgent Properties', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(11, 11, 'en', 'Agents', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(12, 12, 'en', 'Pricing', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(13, 13, 'en', 'Pages', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(14, 14, 'en', 'FAQ', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(15, 15, 'en', 'Privacy Policy', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(16, 16, 'en', 'Terms & Conditions', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(17, 17, 'en', 'Custom Page 1', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(18, 18, 'en', 'Custom Page 2', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(19, 19, 'en', 'Blog', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(20, 20, 'en', 'Contact Us', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(21, 21, 'en', 'Short Links', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(22, 22, 'en', 'About Us', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(23, 23, 'en', 'All Properties', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(24, 24, 'en', 'Blogs', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(25, 25, 'en', 'Pricing', '2024-08-19 05:54:36', '2024-08-19 05:54:36'),
(26, 26, 'en', 'Help Link', '2024-08-19 05:54:36', '2024-08-19 05:54:36'),
(27, 27, 'en', 'Terms & Conditions', '2024-08-19 05:54:36', '2024-08-19 05:54:36'),
(28, 28, 'en', 'Privacy Policy', '2024-08-19 05:54:36', '2024-08-19 05:54:36'),
(29, 29, 'en', 'FAQ', '2024-08-19 05:54:36', '2024-08-19 05:54:36'),
(30, 30, 'en', 'Contact Us', '2024-08-19 05:54:36', '2024-08-19 05:54:36'),
(97, 33, 'en', 'Career', '2024-09-01 06:05:44', '2024-09-01 06:05:44');

-- --------------------------------------------------------

--
-- Table structure for table `menu_translations`
--

CREATE TABLE `menu_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `menu_id` bigint(20) UNSIGNED NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_translations`
--

INSERT INTO `menu_translations` (`id`, `menu_id`, `lang_code`, `name`, `created_at`, `updated_at`) VALUES
(1, 1, 'en', 'Main Menu', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(2, 2, 'en', 'Footer Menu', '2024-08-19 05:54:35', '2024-08-19 05:54:35');

-- --------------------------------------------------------

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sender_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `seen` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2023_11_05_045432_create_admins_table', 1),
(6, '2023_11_05_114814_create_languages_table', 1),
(7, '2023_11_06_043247_create_settings_table', 1),
(8, '2023_11_06_054251_create_seo_settings_table', 1),
(9, '2023_11_06_094842_create_custom_paginations_table', 1),
(10, '2023_11_06_115856_create_email_templates_table', 1),
(11, '2023_11_07_051924_create_multi_currencies_table', 1),
(12, '2023_11_07_103108_create_basic_payments_table', 1),
(13, '2023_11_07_104315_create_blog_categories_table', 1),
(14, '2023_11_07_104328_create_blog_category_translations_table', 1),
(15, '2023_11_07_104336_create_blogs_table', 1),
(16, '2023_11_07_104343_create_blog_translations_table', 1),
(17, '2023_11_07_104546_create_blog_comments_table', 1),
(18, '2023_11_09_035236_create_payment_gateways_table', 1),
(19, '2023_11_09_100621_create_jobs_table', 1),
(20, '2023_11_12_052417_create_subscription_plans_table', 1),
(21, '2023_11_12_064847_create_subscription_histories_table', 1),
(22, '2023_11_16_035458_add_user_info_to_users', 1),
(23, '2023_11_16_061508_add_forget_info_to_users', 1),
(24, '2023_11_16_063639_add_phone_to_users', 1),
(25, '2023_11_18_091357_create_page_item_components_table', 1),
(26, '2023_11_19_055229_add_image_to_users', 1),
(27, '2023_11_19_064341_create_banned_histories_table', 1),
(28, '2023_11_19_091457_create_customizeable_pages_table', 1),
(29, '2023_11_19_091504_create_customizeable_page_items_table', 1),
(30, '2023_11_21_043030_create_news_letters_table', 1),
(31, '2023_11_21_094702_create_contact_messages_table', 1),
(32, '2023_11_22_090504_create_messages_table', 1),
(33, '2023_11_22_105539_create_permission_tables', 1),
(34, '2023_11_29_104658_create_testimonials_table', 1),
(35, '2023_11_29_104704_create_testimonial_translations_table', 1),
(36, '2023_11_30_044838_create_faqs_table', 1),
(37, '2023_11_30_044844_create_faq_translations_table', 1),
(38, '2023_11_30_095404_add_wallet_balance_to_users', 1),
(39, '2023_12_05_090256_create_our_teams_table', 1),
(40, '2023_12_10_061124_create_counters_table', 1),
(41, '2023_12_10_061138_create_counter_translations_table', 1),
(42, '2024_01_01_054644_create_socialite_credentials_table', 1),
(43, '2024_01_03_092007_create_custom_codes_table', 1),
(44, '2024_01_15_110328_create_privacy_policies_table', 1),
(45, '2024_01_15_110446_create_privacy_policy_translations_table', 1),
(46, '2024_01_15_121535_create_terms_and_conditions_table', 1),
(47, '2024_01_15_121639_create_terms_and_condition_translations_table', 1),
(48, '2024_02_04_103504_create_custom_pages_table', 1),
(49, '2024_02_04_103615_create_custom_page_translations_table', 1),
(50, '2024_02_10_060044_create_configurations_table', 1),
(51, '2024_02_28_064128_add_forgot_info_to_admins', 1),
(52, '2024_03_28_095206_create_custom_addons_table', 1),
(53, '2024_03_28_095207_create_menus_wp_table', 1),
(54, '2024_03_28_095208_create_menu_translations_table', 1),
(55, '2024_03_28_095209_create_menu_items_wp_table', 1),
(56, '2024_03_28_095210_create_menu_item_translations_table', 1),
(57, '2024_05_26_065953_create_social_links_table', 1),
(60, '2024_07_24_104814_create_services_table', 1),
(61, '2024_07_24_104915_create_service_translations_table', 1),
(70, '2024_07_26_034029_create_aminities_table', 1),
(71, '2024_07_26_034114_create_aminity_translations_table', 1),
(72, '2024_07_26_045840_create_nearest_locations_table', 1),
(73, '2024_07_26_045922_create_nearest_location_translations_table', 1),
(74, '2024_07_26_060526_create_property_types_table', 1),
(75, '2024_07_26_060645_create_property_type_translations_table', 1),
(76, '2024_07_26_081134_create_property_purposes_table', 1),
(77, '2024_07_26_081203_create_property_purpose_translations_table', 1),
(78, '2024_07_26_102853_create_countries_table', 1),
(79, '2024_07_26_112038_create_country_states_table', 1),
(80, '2024_07_26_120049_create_cities_table', 1),
(81, '2024_07_27_051058_create_properties_table', 1),
(82, '2024_07_27_051118_create_property_translations_table', 1),
(83, '2024_07_27_104545_create_property_aminities_table', 1),
(84, '2024_07_27_113808_create_property_images_table', 1),
(85, '2024_07_27_121140_create_property_nearest_locations_table', 1),
(86, '2024_07_29_040526_create_section_controls_table', 1),
(87, '2024_07_29_065631_create_contact_us_pages_table', 1),
(88, '2024_07_29_065659_create_contact_us_page_translations_table', 1),
(89, '2024_07_29_075730_create_contact_information_table', 1),
(90, '2024_07_29_075751_create_contact_information_translations_table', 1),
(91, '2024_07_29_113528_create_background_images_table', 1),
(92, '2024_08_03_123359_create_wish_lists_table', 1),
(93, '2024_08_04_033508_create_property_reviews_table', 1),
(94, '2024_08_25_112321_create_sliders_table', 2),
(95, '2024_08_25_112421_create_slider_translations_table', 2),
(96, '2024_07_25_041652_create_about_us_table', 3),
(97, '2024_07_25_041743_create_about_us_translations_table', 4),
(98, '2024_08_29_093756_create_careers_table', 5),
(99, '2024_08_29_093943_create_career_translations_table', 5),
(101, '2024_08_29_094821_create_career_requests_table', 6);

-- --------------------------------------------------------

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\Admin', 1),
(2, 'App\\Models\\Admin', 3);

-- --------------------------------------------------------

--
-- Table structure for table `multi_currencies`
--

CREATE TABLE `multi_currencies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `currency_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_default` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_rate` decimal(8,2) NOT NULL,
  `currency_position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'before_price',
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `multi_currencies`
--

INSERT INTO `multi_currencies` (`id`, `currency_name`, `country_code`, `currency_code`, `currency_icon`, `is_default`, `currency_rate`, `currency_position`, `status`, `created_at`, `updated_at`) VALUES
(1, '$-USD', 'US', 'USD', '$', 'yes', '1.00', 'before_price', 'active', '2024-08-19 05:54:30', '2024-12-08 01:14:19'),
(2, '₦-Naira', 'NG', 'NGN', '₦', 'no', '417.35', 'before_price', 'active', '2024-08-19 05:54:30', '2024-12-25 22:07:18'),
(3, '₹-Rupee', 'IN', 'INR', '₹', 'no', '74.66', 'before_price', 'active', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(4, '₱-Peso', 'PH', 'PHP', '₱', 'no', '55.07', 'before_price', 'active', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(5, '$-CAD', 'CA', 'CAD', '$', 'no', '1.27', 'before_price', 'active', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(6, '৳-Taka', 'BD', 'BDT', '৳', 'no', '80.00', 'before_price', 'active', '2024-08-19 05:54:30', '2024-12-08 01:14:19');

-- --------------------------------------------------------

--
-- Table structure for table `nearest_locations`
--

CREATE TABLE `nearest_locations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `nearest_location_translations`
--

CREATE TABLE `nearest_location_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `location_id` int(11) NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `news_letters`
--

CREATE TABLE `news_letters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'not_verified',
  `verify_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `our_teams`
--

CREATE TABLE `our_teams` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `designation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linkedin` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instagram` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `page_item_components`
--

CREATE TABLE `page_item_components` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `page_item_components`
--

INSERT INTO `page_item_components` (`id`, `name`, `file`, `created_at`, `updated_at`) VALUES
(1, 'Home Page Item', 'component-1', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(2, 'Home Page Item 2', 'component-2', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(3, 'Home Page Item 3', 'component-3', '2024-08-19 05:54:35', '2024-08-19 05:54:35');

-- --------------------------------------------------------

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

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

-- --------------------------------------------------------

--
-- Table structure for table `payment_gateways`
--

CREATE TABLE `payment_gateways` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_gateways`
--

INSERT INTO `payment_gateways` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'razorpay_key', 'rzp_test_cvrsy43xvBZfDT', '2024-08-19 05:54:31', '2024-12-30 22:14:10'),
(2, 'razorpay_secret', 'c9AmI4C5vOfSWmZehhlns5df', '2024-08-19 05:54:31', '2024-12-30 22:14:10'),
(3, 'razorpay_name', 'WebSolutionUs', '2024-08-19 05:54:31', '2024-12-30 22:14:10'),
(4, 'razorpay_description', 'This is test payment window', '2024-08-19 05:54:31', '2024-12-30 22:14:10'),
(5, 'razorpay_charge', '0', '2024-08-19 05:54:31', '2024-12-30 22:14:10'),
(6, 'razorpay_theme_color', '#6d0ce4', '2024-08-19 05:54:31', '2024-12-30 22:14:10'),
(7, 'razorpay_status', 'active', '2024-08-19 05:54:31', '2024-12-30 22:14:10'),
(8, 'razorpay_currency_id', '3', '2024-08-19 05:54:31', '2024-12-30 22:14:10'),
(9, 'razorpay_image', 'uploads/website-images/razorpay.webp', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(10, 'flutterwave_public_key', 'FLWPUBK_TEST-6199046fedfadb3304d3726662040bf9-X', '2024-08-19 05:54:31', '2024-12-30 22:14:01'),
(11, 'flutterwave_secret_key', 'FLWSECK_TEST-44d4064c7b4e7d3a278a8b8e206b465b-X', '2024-08-19 05:54:31', '2024-12-30 22:14:01'),
(12, 'flutterwave_app_name', 'WebSolutionUs', '2024-08-19 05:54:31', '2024-12-30 22:14:01'),
(13, 'flutterwave_charge', '0', '2024-08-19 05:54:31', '2024-12-30 22:14:01'),
(14, 'flutterwave_currency_id', '2', '2024-08-19 05:54:31', '2024-12-30 22:14:01'),
(15, 'flutterwave_status', 'active', '2024-08-19 05:54:31', '2024-12-30 22:14:01'),
(16, 'flutterwave_image', 'uploads/website-images/flutterwave.webp', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(17, 'paystack_public_key', 'pk_test_057dfe5dee14eaf9c3b4573df1e3760c02c06e38', '2024-08-19 05:54:31', '2024-12-30 22:13:52'),
(18, 'paystack_secret_key', 'sk_test_77cb93329abbdc18104466e694c9f720a7d69c97', '2024-08-19 05:54:31', '2024-12-30 22:13:52'),
(19, 'paystack_status', 'active', '2024-08-19 05:54:31', '2024-12-30 22:13:52'),
(20, 'paystack_charge', '0', '2024-08-19 05:54:31', '2024-12-30 22:13:52'),
(21, 'paystack_image', 'uploads/website-images/paystack.webp', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(22, 'paystack_currency_id', '2', '2024-08-19 05:54:31', '2024-12-30 22:13:52'),
(23, 'mollie_key', 'test_4VDJypzqbsjjHpCJyx3vwjVuurqj3R', '2024-08-19 05:54:31', '2024-12-30 22:13:44'),
(24, 'mollie_charge', '0', '2024-08-19 05:54:31', '2024-12-30 22:13:44'),
(25, 'mollie_image', 'uploads/website-images/mollie.webp', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(26, 'mollie_status', 'active', '2024-08-19 05:54:31', '2024-12-30 22:13:44'),
(27, 'mollie_currency_id', '5', '2024-08-19 05:54:31', '2024-12-30 22:13:44'),
(28, 'instamojo_account_mode', 'sandbox', '2024-08-19 05:54:31', '2024-12-30 22:13:36'),
(29, 'instamojo_api_key', 'test_ffc6f0ad486d6ae0ba9ca2f46da', '2024-08-19 05:54:31', '2024-12-30 22:13:36'),
(30, 'instamojo_auth_token', 'test_ded356ba75e1aaa80bdd8f438d7', '2024-08-19 05:54:31', '2024-12-30 22:13:36'),
(31, 'instamojo_charge', '0', '2024-08-19 05:54:31', '2024-12-30 22:13:35'),
(32, 'instamojo_image', 'uploads/website-images/instamojo.webp', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(33, 'instamojo_currency_id', '3', '2024-08-19 05:54:31', '2024-12-30 22:13:35'),
(34, 'instamojo_status', 'active', '2024-08-19 05:54:31', '2024-12-30 22:13:36'),
(35, 'sslcommerz_store_id', 'test669499013b632', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(36, 'sslcommerz_store_password', 'test669499013b632@ssl', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(37, 'sslcommerz_image', 'uploads/website-images/sslcommerz.webp', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(38, 'sslcommerz_test_mode', '1', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(39, 'sslcommerz_localhost', '1', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(40, 'sslcommerz_status', 'inactive', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(41, 'crypto_sandbox', '1', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(42, 'crypto_api_key', 'WzrKM5s3vzWKj4wDGrz6uJzG81Hdf35pe7ov7Wyv', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(43, 'crypto_image', 'uploads/website-images/crypto.webp', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(44, 'crypto_status', 'inactive', '2024-08-19 05:54:31', '2024-08-19 05:54:31');

-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `group_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `group_name`, `created_at`, `updated_at`) VALUES
(1, 'dashboard.view', 'admin', 'dashboard', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(2, 'admin.profile.view', 'admin', 'admin profile', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(3, 'admin.profile.edit', 'admin', 'admin profile', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(4, 'admin.profile.update', 'admin', 'admin profile', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(6, 'admin.view', 'admin', 'admin', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(7, 'admin.create', 'admin', 'admin', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(8, 'admin.store', 'admin', 'admin', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(9, 'admin.edit', 'admin', 'admin', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(10, 'admin.update', 'admin', 'admin', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(11, 'admin.delete', 'admin', 'admin', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(12, 'blog.category.view', 'admin', 'blog category', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(13, 'blog.category.create', 'admin', 'blog category', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(14, 'blog.category.translate', 'admin', 'blog category', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(15, 'blog.category.store', 'admin', 'blog category', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(16, 'blog.category.edit', 'admin', 'blog category', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(17, 'blog.category.update', 'admin', 'blog category', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(18, 'blog.category.delete', 'admin', 'blog category', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(19, 'blog.view', 'admin', 'blog', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(20, 'blog.create', 'admin', 'blog', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(21, 'blog.translate', 'admin', 'blog', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(22, 'blog.store', 'admin', 'blog', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(23, 'blog.edit', 'admin', 'blog', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(24, 'blog.update', 'admin', 'blog', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(25, 'blog.delete', 'admin', 'blog', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(26, 'blog.comment.view', 'admin', 'blog comment', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(27, 'blog.comment.update', 'admin', 'blog comment', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(28, 'blog.comment.delete', 'admin', 'blog comment', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(29, 'role.view', 'admin', 'role', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(30, 'role.create', 'admin', 'role', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(31, 'role.store', 'admin', 'role', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(32, 'role.assign', 'admin', 'role', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(33, 'role.edit', 'admin', 'role', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(34, 'role.update', 'admin', 'role', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(35, 'role.delete', 'admin', 'role', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(36, 'setting.view', 'admin', 'setting', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(37, 'setting.update', 'admin', 'setting', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(38, 'basic.payment.view', 'admin', 'basic payment', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(39, 'basic.payment.update', 'admin', 'basic payment', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(40, 'contect.message.view', 'admin', 'contect message', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(41, 'contect.message.delete', 'admin', 'contect message', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(42, 'currency.view', 'admin', 'currency', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(43, 'currency.create', 'admin', 'currency', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(44, 'currency.store', 'admin', 'currency', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(45, 'currency.edit', 'admin', 'currency', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(46, 'currency.update', 'admin', 'currency', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(47, 'currency.delete', 'admin', 'currency', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(48, 'customer.view', 'admin', 'customer', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(49, 'customer.bulk.mail', 'admin', 'customer', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(52, 'customer.edit', 'admin', 'customer', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(53, 'customer.update', 'admin', 'customer', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(54, 'customer.delete', 'admin', 'customer', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(55, 'language.view', 'admin', 'language', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(56, 'language.create', 'admin', 'language', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(57, 'language.store', 'admin', 'language', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(58, 'language.edit', 'admin', 'language', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(59, 'language.update', 'admin', 'language', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(60, 'language.delete', 'admin', 'language', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(61, 'language.translate', 'admin', 'language', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(62, 'language.single.translate', 'admin', 'language', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(63, 'menu.view', 'admin', 'menu builder', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(64, 'menu.create', 'admin', 'menu builder', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(65, 'menu.update', 'admin', 'menu builder', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(66, 'menu.delete', 'admin', 'menu builder', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(67, 'subscription.view', 'admin', 'subscription', '2024-08-19 05:54:32', '2024-08-19 05:54:32'),
(68, 'subscription.create', 'admin', 'subscription', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(69, 'subscription.store', 'admin', 'subscription', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(70, 'subscription.edit', 'admin', 'subscription', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(71, 'subscription.update', 'admin', 'subscription', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(72, 'subscription.delete', 'admin', 'subscription', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(75, 'social.link.management', 'admin', 'social link management', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(76, 'newsletter.view', 'admin', 'newsletter', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(77, 'newsletter.mail', 'admin', 'newsletter', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(78, 'newsletter.delete', 'admin', 'newsletter', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(79, 'testimonial.view', 'admin', 'testimonial', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(80, 'testimonial.create', 'admin', 'testimonial', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(81, 'testimonial.translate', 'admin', 'testimonial', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(82, 'testimonial.store', 'admin', 'testimonial', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(83, 'testimonial.edit', 'admin', 'testimonial', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(84, 'testimonial.update', 'admin', 'testimonial', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(85, 'testimonial.delete', 'admin', 'testimonial', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(86, 'faq.view', 'admin', 'faq', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(87, 'faq.create', 'admin', 'faq', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(88, 'faq.translate', 'admin', 'faq', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(89, 'faq.store', 'admin', 'faq', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(90, 'faq.edit', 'admin', 'faq', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(91, 'faq.update', 'admin', 'faq', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(92, 'faq.delete', 'admin', 'faq', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(93, 'property.amenity.view', 'admin', 'property amenity', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(94, 'property.amenity.create', 'admin', 'property amenity', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(95, 'property.amenity.translate', 'admin', 'property amenity', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(96, 'property.amenity.store', 'admin', 'property amenity', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(97, 'property.amenity.edit', 'admin', 'property amenity', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(98, 'property.amenity.update', 'admin', 'property amenity', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(99, 'property.amenity.delete', 'admin', 'property amenity', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(100, 'nearest.location.view', 'admin', 'nearest location', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(101, 'nearest.location.create', 'admin', 'nearest location', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(102, 'nearest.location.translate', 'admin', 'nearest location', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(103, 'nearest.location.store', 'admin', 'nearest location', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(104, 'nearest.location.edit', 'admin', 'nearest location', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(105, 'nearest.location.update', 'admin', 'nearest location', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(106, 'nearest.location.delete', 'admin', 'nearest location', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(107, 'property.type.view', 'admin', 'property type', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(108, 'property.type.create', 'admin', 'property type', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(109, 'property.type.translate', 'admin', 'property type', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(110, 'property.type.store', 'admin', 'property type', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(111, 'property.type.edit', 'admin', 'property type', '2024-08-19 05:54:33', '2024-08-19 05:54:33'),
(112, 'property.type.update', 'admin', 'property type', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(113, 'property.type.delete', 'admin', 'property type', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(114, 'location.view', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(115, 'country.view', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(116, 'country.create', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(117, 'country.store', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(118, 'country.edit', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(119, 'country.update', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(120, 'country.delete', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(121, 'state.view', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(122, 'state.create', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(123, 'state.store', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(124, 'state.edit', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(125, 'state.update', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(126, 'state.delete', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(127, 'city.view', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(128, 'city.create', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(129, 'city.store', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(130, 'city.edit', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(131, 'city.update', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(132, 'city.delete', 'admin', 'location', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(133, 'property.view', 'admin', 'property', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(134, 'property.create', 'admin', 'property', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(135, 'property.translate', 'admin', 'property', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(136, 'property.store', 'admin', 'property', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(137, 'property.edit', 'admin', 'property', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(138, 'property.update', 'admin', 'property', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(139, 'property.delete', 'admin', 'property', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(140, 'property.slider', 'admin', 'property', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(141, 'property.slider.upload', 'admin', 'property', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(142, 'property.slider.delete', 'admin', 'property', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(143, 'property.nearest.location', 'admin', 'property', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(144, 'property.nearest.location.upload', 'admin', 'property', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(145, 'property.nearest.location.delete', 'admin', 'property', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(146, 'contact.us.view', 'admin', 'Contact Us Page', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(147, 'contact.us.translate', 'admin', 'Contact Us Page', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(148, 'contact.us.update', 'admin', 'Contact Us Page', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(149, 'contact.information.view', 'admin', 'Contact Information', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(150, 'contact.information.translate', 'admin', 'Contact Information', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(151, 'contact.information.update', 'admin', 'Contact Information', '2024-08-19 05:54:34', '2024-08-19 05:54:34'),
(152, 'team.view', 'admin', 'Our Team', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(153, 'team.create', 'admin', 'Our Team', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(154, 'team.store', 'admin', 'Our Team', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(155, 'team.edit', 'admin', 'Our Team', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(156, 'team.update', 'admin', 'Our Team', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(157, 'team.delete', 'admin', 'Our Team', '2024-08-19 05:54:35', '2024-08-19 05:54:35'),
(166, 'service.create', 'admin', 'Service', '2024-08-19 05:54:36', '2024-08-19 05:54:36'),
(167, 'service.store', 'admin', 'Service', '2024-08-19 05:54:36', '2024-08-19 05:54:36'),
(168, 'service.view', 'admin', 'Service', '2024-08-19 05:54:36', '2024-08-19 05:54:36'),
(169, 'service.update', 'admin', 'Service', '2024-08-19 05:54:36', '2024-08-19 05:54:36'),
(170, 'service.edit', 'admin', 'Service', '2024-08-19 05:54:36', '2024-08-19 05:54:36'),
(171, 'service.delete', 'admin', 'Service', '2024-08-19 05:54:36', '2024-08-19 05:54:36'),
(172, 'service.translate', 'admin', 'Service', '2024-08-19 05:54:36', '2024-08-19 05:54:36'),
(173, 'counter.view', 'admin', 'counter', '2024-08-19 05:54:37', '2024-08-19 05:54:37'),
(174, 'counter.update', 'admin', 'counter', '2024-08-19 05:54:37', '2024-08-19 05:54:37'),
(175, 'counter.translate', 'admin', 'counter', '2024-08-19 05:54:37', '2024-08-19 05:54:37'),
(176, 'about.us.view', 'admin', 'About Us', '2024-08-19 05:54:37', '2024-08-19 05:54:37'),
(177, 'about.us.update', 'admin', 'About Us', '2024-08-19 05:54:37', '2024-08-19 05:54:37'),
(178, 'about.us.translate', 'admin', 'About Us', '2024-08-19 05:54:37', '2024-08-19 05:54:37'),
(188, 'terms.and.condition.view', 'admin', 'terms and condition', '2024-08-19 05:54:39', '2024-08-19 05:54:39'),
(189, 'terms.and.condition.update', 'admin', 'terms and condition', '2024-08-19 05:54:39', '2024-08-19 05:54:39'),
(190, 'terms.and.condition.translate', 'admin', 'terms and condition', '2024-08-19 05:54:40', '2024-08-19 05:54:40'),
(191, 'privacy.policy.view', 'admin', 'privacy policy', '2024-08-19 05:54:40', '2024-08-19 05:54:40'),
(192, 'privacy.policy.update', 'admin', 'privacy policy', '2024-08-19 05:54:40', '2024-08-19 05:54:40'),
(193, 'privacy.policy.translate', 'admin', 'privacy policy', '2024-08-19 05:54:41', '2024-08-19 05:54:41'),
(194, 'custom.page.view', 'admin', 'custom page', '2024-08-19 05:54:41', '2024-08-19 05:54:41'),
(195, 'custom.page.create', 'admin', 'custom page', '2024-08-19 05:54:42', '2024-08-19 05:54:42'),
(196, 'custom.page.store', 'admin', 'custom page', '2024-08-19 05:54:42', '2024-08-19 05:54:42'),
(197, 'custom.page.edit', 'admin', 'custom page', '2024-08-19 05:54:42', '2024-08-19 05:54:42'),
(198, 'custom.page.update', 'admin', 'custom page', '2024-08-19 05:54:42', '2024-08-19 05:54:42'),
(199, 'custom.page.delete', 'admin', 'custom page', '2024-08-19 05:54:42', '2024-08-19 05:54:42'),
(200, 'custom.page.status', 'admin', 'custom page', '2024-08-19 05:54:42', '2024-08-19 05:54:42'),
(201, 'custom.page.translate', 'admin', 'custom page', '2024-08-19 05:54:42', '2024-08-19 05:54:42'),
(202, 'slider.view', 'admin', 'Slider', '2024-08-25 22:37:11', '2024-08-25 22:37:11'),
(203, 'slider.create', 'admin', 'Slider', '2024-08-25 22:37:11', '2024-08-25 22:37:11'),
(204, 'slider.store', 'admin', 'Slider', '2024-08-25 22:37:11', '2024-08-25 22:37:11'),
(205, 'slider.edit', 'admin', 'Slider', '2024-08-25 22:37:11', '2024-08-25 22:37:11'),
(206, 'slider.update', 'admin', 'Slider', '2024-08-25 22:37:11', '2024-08-25 22:37:11'),
(207, 'slider.delete', 'admin', 'Slider', '2024-08-25 22:37:11', '2024-08-25 22:37:11'),
(208, 'slider.translate', 'admin', 'Slider', '2024-08-25 22:37:11', '2024-08-25 22:37:11'),
(209, 'career.view', 'admin', 'Career', '2024-08-29 04:08:28', '2024-08-29 04:08:28'),
(210, 'career.create', 'admin', 'Career', '2024-08-29 04:08:29', '2024-08-29 04:08:29'),
(211, 'career.store', 'admin', 'Career', '2024-08-29 04:08:29', '2024-08-29 04:08:29'),
(212, 'career.edit', 'admin', 'Career', '2024-08-29 04:08:29', '2024-08-29 04:08:29'),
(213, 'career.update', 'admin', 'Career', '2024-08-29 04:08:29', '2024-08-29 04:08:29'),
(214, 'career.delete', 'admin', 'Career', '2024-08-29 04:08:29', '2024-08-29 04:08:29'),
(215, 'career.translate', 'admin', 'Career', '2024-08-29 04:08:29', '2024-08-29 04:08:29'),
(216, 'career.request.view', 'admin', 'Career', '2024-08-29 04:08:29', '2024-08-29 04:08:29'),
(217, 'addon.view', 'admin', 'Addons', '2024-12-24 01:34:31', '2024-12-24 01:34:31'),
(218, 'addon.install', 'admin', 'Addons', '2024-12-24 01:34:31', '2024-12-24 01:34:31'),
(219, 'addon.update', 'admin', 'Addons', '2024-12-24 01:34:31', '2024-12-24 01:34:31'),
(220, 'addon.status.change', 'admin', 'Addons', '2024-12-24 01:34:31', '2024-12-24 01:34:31'),
(221, 'addon.remove', 'admin', 'Addons', '2024-12-24 01:34:31', '2024-12-24 01:34:31');

-- --------------------------------------------------------

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

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `privacy_policies`
--

CREATE TABLE `privacy_policies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `privacy_policies`
--

INSERT INTO `privacy_policies` (`id`, `created_at`, `updated_at`) VALUES
(1, '2024-08-19 05:54:40', '2024-08-19 05:54:40');

-- --------------------------------------------------------

--
-- Table structure for table `privacy_policy_translations`
--

CREATE TABLE `privacy_policy_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `privacy_policy_id` int(11) NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `privacy_policy` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `privacy_policy_translations`
--

INSERT INTO `privacy_policy_translations` (`id`, `privacy_policy_id`, `lang_code`, `privacy_policy`, `created_at`, `updated_at`) VALUES
(1, 1, 'en', '', '2024-08-19 05:54:40', '2025-01-02 05:37:25');

-- --------------------------------------------------------

--
-- Table structure for table `properties`
--

CREATE TABLE `properties` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_type` int(11) NOT NULL DEFAULT 1,
  `admin_id` int(11) NOT NULL DEFAULT 0,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `property_type_id` int(11) NOT NULL DEFAULT 0,
  `property_search_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city_id` int(11) NOT NULL DEFAULT 0,
  `listing_package_id` int(11) NOT NULL DEFAULT 0,
  `property_purpose_id` int(11) NOT NULL DEFAULT 0,
  `slug` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `views` int(11) NOT NULL DEFAULT 0,
  `phone` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `pdf_file` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thumbnail_image` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `banner_image` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_of_unit` int(11) DEFAULT NULL,
  `number_of_room` int(11) DEFAULT NULL,
  `number_of_bedroom` int(11) DEFAULT NULL,
  `number_of_bathroom` int(11) DEFAULT NULL,
  `number_of_floor` int(11) DEFAULT NULL,
  `number_of_kitchen` int(11) DEFAULT NULL,
  `number_of_parking` int(11) DEFAULT NULL,
  `area` double DEFAULT NULL,
  `price` double DEFAULT NULL,
  `period` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_link` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_featured` tinyint(4) NOT NULL DEFAULT 0,
  `verified` tinyint(4) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `seo_title` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_popular` tinyint(4) DEFAULT NULL,
  `google_map_embed_code` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `urgent_property` tinyint(4) NOT NULL DEFAULT 0,
  `top_property` tinyint(4) NOT NULL DEFAULT 0,
  `expired_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `property_aminities`
--

CREATE TABLE `property_aminities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `property_id` int(11) NOT NULL,
  `aminity_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `property_images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `property_id` int(11) NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `property_nearest_locations`
--

CREATE TABLE `property_nearest_locations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `property_id` int(11) NOT NULL,
  `nearest_place_id` int(11) NOT NULL,
  `distance` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `property_purposes`
--

CREATE TABLE `property_purposes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `purpose` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_purposes`
--

INSERT INTO `property_purposes` (`id`, `purpose`, `slug`, `status`, `created_at`, `updated_at`) VALUES
(1, 'For Sale', 'for-sale', 1, '2024-08-19 05:54:42', '2024-08-19 05:54:42'),
(2, 'For Rent', 'for-rent', 1, '2024-08-19 05:54:42', '2024-08-19 05:54:42');

-- --------------------------------------------------------

--
-- Table structure for table `property_purpose_translations`
--

CREATE TABLE `property_purpose_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `property_purpose_id` int(11) NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_purpose_translations`
--

INSERT INTO `property_purpose_translations` (`id`, `property_purpose_id`, `lang_code`, `title`, `created_at`, `updated_at`) VALUES
(1, 1, 'en', 'For Sale', '2024-08-19 05:54:42', '2024-08-19 05:54:42'),
(2, 2, 'en', 'For Rent', '2024-08-19 05:54:42', '2024-08-19 05:54:42');

-- --------------------------------------------------------

--
-- Table structure for table `property_reviews`
--

CREATE TABLE `property_reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `property_id` int(11) NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `service_rating` double DEFAULT NULL,
  `location_rating` double DEFAULT NULL,
  `money_rating` double DEFAULT NULL,
  `clean_rating` double DEFAULT NULL,
  `avarage_rating` double DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `property_translations`
--

CREATE TABLE `property_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `property_id` int(11) NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `property_types`
--

CREATE TABLE `property_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `show_home1` tinyint(1) NOT NULL DEFAULT 0,
  `show_home2` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `property_type_translations`
--

CREATE TABLE `property_type_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `property_type_id` int(11) NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 'admin', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(2, 'admin', 'admin', '2024-12-08 02:20:51', '2024-12-08 02:28:51');

-- --------------------------------------------------------

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1),
(1, 2),
(2, 1),
(2, 2),
(3, 1),
(3, 2),
(4, 1),
(4, 2),
(6, 1),
(6, 2),
(7, 1),
(7, 2),
(8, 1),
(8, 2),
(9, 1),
(9, 2),
(10, 1),
(10, 2),
(11, 1),
(11, 2),
(12, 1),
(12, 2),
(13, 1),
(13, 2),
(14, 1),
(14, 2),
(15, 1),
(15, 2),
(16, 1),
(16, 2),
(17, 1),
(17, 2),
(18, 1),
(18, 2),
(19, 1),
(19, 2),
(20, 1),
(20, 2),
(21, 1),
(21, 2),
(22, 1),
(22, 2),
(23, 1),
(23, 2),
(24, 1),
(24, 2),
(25, 1),
(25, 2),
(26, 1),
(26, 2),
(27, 1),
(27, 2),
(28, 1),
(28, 2),
(29, 1),
(29, 2),
(30, 1),
(30, 2),
(31, 1),
(31, 2),
(32, 1),
(32, 2),
(33, 1),
(33, 2),
(34, 1),
(34, 2),
(35, 1),
(35, 2),
(36, 1),
(36, 2),
(37, 1),
(37, 2),
(38, 1),
(38, 2),
(39, 1),
(39, 2),
(40, 1),
(40, 2),
(41, 1),
(41, 2),
(42, 1),
(42, 2),
(43, 1),
(43, 2),
(44, 1),
(44, 2),
(45, 1),
(45, 2),
(46, 1),
(46, 2),
(47, 1),
(47, 2),
(48, 1),
(48, 2),
(49, 1),
(49, 2),
(52, 1),
(52, 2),
(53, 1),
(53, 2),
(54, 1),
(54, 2),
(55, 1),
(55, 2),
(56, 1),
(56, 2),
(57, 1),
(57, 2),
(58, 1),
(58, 2),
(59, 1),
(59, 2),
(60, 1),
(60, 2),
(61, 1),
(61, 2),
(62, 1),
(62, 2),
(63, 1),
(63, 2),
(64, 1),
(64, 2),
(65, 1),
(65, 2),
(66, 1),
(66, 2),
(67, 1),
(67, 2),
(68, 1),
(68, 2),
(69, 1),
(69, 2),
(70, 1),
(70, 2),
(71, 1),
(71, 2),
(72, 1),
(72, 2),
(75, 1),
(75, 2),
(76, 1),
(76, 2),
(77, 1),
(77, 2),
(78, 1),
(78, 2),
(79, 1),
(79, 2),
(80, 1),
(80, 2),
(81, 1),
(81, 2),
(82, 1),
(82, 2),
(83, 1),
(83, 2),
(84, 1),
(84, 2),
(85, 1),
(85, 2),
(86, 1),
(86, 2),
(87, 1),
(87, 2),
(88, 1),
(88, 2),
(89, 1),
(89, 2),
(90, 1),
(90, 2),
(91, 1),
(91, 2),
(92, 1),
(92, 2),
(93, 1),
(93, 2),
(94, 1),
(94, 2),
(95, 1),
(95, 2),
(96, 1),
(96, 2),
(97, 1),
(97, 2),
(98, 1),
(98, 2),
(99, 1),
(99, 2),
(100, 1),
(100, 2),
(101, 1),
(101, 2),
(102, 1),
(102, 2),
(103, 1),
(103, 2),
(104, 1),
(104, 2),
(105, 1),
(105, 2),
(106, 1),
(106, 2),
(107, 1),
(107, 2),
(108, 1),
(108, 2),
(109, 1),
(109, 2),
(110, 1),
(110, 2),
(111, 1),
(111, 2),
(112, 1),
(112, 2),
(113, 1),
(113, 2),
(114, 1),
(114, 2),
(115, 1),
(115, 2),
(116, 1),
(116, 2),
(117, 1),
(117, 2),
(118, 1),
(118, 2),
(119, 1),
(119, 2),
(120, 1),
(120, 2),
(121, 1),
(121, 2),
(122, 1),
(122, 2),
(123, 1),
(123, 2),
(124, 1),
(124, 2),
(125, 1),
(125, 2),
(126, 1),
(126, 2),
(127, 1),
(127, 2),
(128, 1),
(128, 2),
(129, 1),
(129, 2),
(130, 1),
(130, 2),
(131, 1),
(131, 2),
(132, 1),
(132, 2),
(133, 1),
(133, 2),
(134, 1),
(134, 2),
(135, 1),
(135, 2),
(136, 1),
(136, 2),
(137, 1),
(137, 2),
(138, 1),
(138, 2),
(139, 1),
(139, 2),
(140, 1),
(140, 2),
(141, 1),
(141, 2),
(142, 1),
(142, 2),
(143, 1),
(143, 2),
(144, 1),
(144, 2),
(145, 1),
(145, 2),
(146, 1),
(146, 2),
(147, 1),
(147, 2),
(148, 1),
(148, 2),
(149, 1),
(149, 2),
(150, 1),
(150, 2),
(151, 1),
(151, 2),
(152, 1),
(152, 2),
(153, 1),
(153, 2),
(154, 1),
(154, 2),
(155, 1),
(155, 2),
(156, 1),
(156, 2),
(157, 1),
(157, 2),
(166, 1),
(166, 2),
(167, 1),
(167, 2),
(168, 1),
(168, 2),
(169, 1),
(169, 2),
(170, 1),
(170, 2),
(171, 1),
(171, 2),
(172, 1),
(172, 2),
(173, 1),
(173, 2),
(174, 1),
(174, 2),
(175, 1),
(175, 2),
(176, 1),
(176, 2),
(177, 1),
(177, 2),
(178, 1),
(178, 2),
(188, 1),
(188, 2),
(189, 1),
(189, 2),
(190, 1),
(190, 2),
(191, 1),
(191, 2),
(192, 1),
(192, 2),
(193, 1),
(193, 2),
(194, 1),
(194, 2),
(195, 1),
(195, 2),
(196, 1),
(196, 2),
(197, 1),
(197, 2),
(198, 1),
(198, 2),
(199, 1),
(199, 2),
(200, 1),
(200, 2),
(201, 1),
(201, 2),
(202, 1),
(202, 2),
(203, 1),
(203, 2),
(204, 1),
(204, 2),
(205, 1),
(205, 2),
(206, 1),
(206, 2),
(207, 1),
(207, 2),
(208, 1),
(208, 2),
(209, 1),
(209, 2),
(210, 1),
(210, 2),
(211, 1),
(211, 2),
(212, 1),
(212, 2),
(213, 1),
(213, 2),
(214, 1),
(214, 2),
(215, 1),
(215, 2),
(216, 1),
(216, 2),
(217, 1),
(217, 2),
(218, 1),
(218, 2),
(219, 1),
(219, 2),
(220, 1),
(220, 2),
(221, 1),
(221, 2);

-- --------------------------------------------------------

--
-- Table structure for table `section_controls`
--

CREATE TABLE `section_controls` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `page_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `section_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `qty` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `section_controls`
--

INSERT INTO `section_controls` (`id`, `page_name`, `section_name`, `title`, `status`, `qty`, `created_at`, `updated_at`) VALUES
(1, 'Home One', 'slider', 'Slider', 1, 0, '2024-08-19 05:54:42', '2024-12-05 02:25:38'),
(4, 'Home One', 'about_us', 'About Us', 1, 0, '2024-08-19 05:54:42', '2024-09-01 22:31:15'),
(5, 'Home One', 'urgent_property', 'Urgent Property', 1, 9, '2024-08-19 05:54:42', '2024-09-01 22:30:35'),
(11, 'Home One', 'top_property', 'Top Properties', 1, 6, '2024-08-19 05:54:43', '2024-09-01 22:31:15'),
(13, 'Home One', 'featured_property', 'Featured Properties', 1, 9, '2024-08-19 05:54:43', '2024-09-01 22:31:56'),
(14, 'Home One', 'agent', 'Agent', 1, 4, '2024-08-19 05:54:43', '2024-09-01 22:32:30'),
(15, 'Home One', 'service', 'Service', 1, 4, '2024-08-19 05:54:43', '2024-09-01 22:32:54'),
(16, 'Home One', 'blog', 'Blog', 1, 3, '2024-08-19 05:54:43', '2024-09-01 22:33:29'),
(17, 'Home One', 'testimonial', 'Testimonials', 1, 6, '2024-08-19 05:54:43', '2024-09-01 22:34:03'),
(18, 'Home One', 'our_team', 'Our Team', 1, 4, '2024-08-19 05:54:43', '2024-09-01 22:18:59');

-- --------------------------------------------------------

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

CREATE TABLE `seo_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `page_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `seo_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `seo_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `seo_settings` (`id`, `page_name`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES
(1, 'Home Page', 'Home || TopLand', 'Home || TopLand', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(2, 'About Page', 'About || TopLand', 'About || TopLand', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(3, 'Property Page', 'All Properties || TopLand', 'All Properties || TopLand', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(4, 'Pricing Plan', 'Pricing Plan || TopLand', 'Pricing Plan || TopLand', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(5, 'Agent Page', 'Agent Page || TopLand', 'Agent Page || TopLand', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(6, 'Blog Page', 'Blog Page || TopLand', 'Blog Page || TopLand', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(7, 'Contact us', 'Contact us || TopLand', 'Contact us || TopLand', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(8, 'FAQ Page', 'FAQ Page || TopLand', 'FAQ Page || TopLand', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(9, 'Career Page', 'Career Page || TopLand', 'Career Page || TopLand', '2024-09-01 05:46:46', '2024-09-01 05:46:46');

-- --------------------------------------------------------

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `service_translations`
--

CREATE TABLE `service_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `service_id` int(11) NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'app_name', 'Top Land', '2024-08-19 05:54:30', '2024-12-22 00:46:59'),
(2, 'version', '4.0.0', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(3, 'logo', 'uploads/website-images/wsus-img-2024-08-26-04-56-38-8915.webp', '2024-08-19 05:54:30', '2024-08-25 22:56:38'),
(4, 'timezone', 'Asia/Dhaka', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(5, 'date_format', 'Y-m-d', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(6, 'time_format', 'h:i A', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(7, 'favicon', 'uploads/website-images/wsus-img-2024-09-04-04-09-38-4404.webp', '2024-08-19 05:54:30', '2024-09-03 22:09:38'),
(8, 'cookie_status', 'inactive', '2024-08-19 05:54:30', '2024-12-30 05:13:02'),
(9, 'border', 'normal', '2024-08-19 05:54:30', '2024-12-30 05:13:02'),
(10, 'corners', 'none', '2024-08-19 05:54:30', '2024-12-30 05:13:02'),
(11, 'background_color', '#184dec', '2024-08-19 05:54:30', '2024-12-30 05:13:02'),
(12, 'text_color', '#fafafa', '2024-08-19 05:54:30', '2024-12-30 05:13:02'),
(13, 'border_color', '#0a58d6', '2024-08-19 05:54:30', '2024-12-30 05:13:02'),
(14, 'btn_bg_color', '#fffceb', '2024-08-19 05:54:30', '2024-12-30 05:13:02'),
(15, 'btn_text_color', '#222758', '2024-08-19 05:54:30', '2024-12-30 05:13:02'),
(16, 'link_text', 'More Info', '2024-08-19 05:54:30', '2024-12-30 05:13:02'),
(17, 'btn_text', 'Yes', '2024-08-19 05:54:30', '2024-12-30 05:13:02'),
(18, 'message', 'This website uses essential cookies to ensure its proper operation and tracking cookies to understand how you interact with it. The latter will be set only upon approval.', '2024-08-19 05:54:30', '2024-12-30 05:13:02'),
(19, 'copyright_text', 'Copyright 2024, Websolutionus. All Rights Reserved.', '2024-08-19 05:54:30', '2024-09-04 22:59:53'),
(20, 'recaptcha_site_key', '6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI', '2024-08-19 05:54:30', '2024-12-30 06:24:32'),
(21, 'recaptcha_secret_key', '6LeIxAcTAAAAAGG-vFI1TnRWxMZNFuojJ4WifJWe', '2024-08-19 05:54:30', '2024-12-30 06:24:32'),
(22, 'recaptcha_status', 'active', '2024-08-19 05:54:30', '2024-12-30 06:24:32'),
(23, 'tawk_status', 'inactive', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(24, 'tawk_chat_link', 'tawk_chat_link', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(25, 'googel_tag_status', 'inactive', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(26, 'googel_tag_id', 'google_tag_id', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(27, 'google_analytic_status', 'active', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(28, 'google_analytic_id', 'google_analytic_id', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(29, 'pixel_status', 'inactive', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(30, 'pixel_app_id', 'pixel_app_id', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(31, 'google_login_status', 'inactive', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(32, 'gmail_client_id', 'google_client_id', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(33, 'gmail_secret_id', 'google_secret_id', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(34, 'default_avatar', 'uploads/website-images/wsus-img-2024-08-15-09-10-53-5804.webp', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(35, 'breadcrumb_image', 'uploads/website-images/wsus-img-2024-09-04-04-13-22-6250.webp', '2024-08-19 05:54:30', '2024-09-03 22:13:22'),
(36, 'mail_host', 'sandbox.smtp.mailtrap.io', '2024-08-19 05:54:30', '2024-08-20 05:42:28'),
(37, 'mail_sender_email', 'sender@gmail.com', '2024-08-19 05:54:30', '2024-08-20 05:42:28'),
(38, 'mail_username', '31dbacba70c602', '2024-08-19 05:54:30', '2024-08-20 05:42:28'),
(39, 'mail_password', '08419842ed2c8a', '2024-08-19 05:54:30', '2024-08-20 05:42:28'),
(40, 'mail_port', '587', '2024-08-19 05:54:30', '2024-08-20 05:42:28'),
(41, 'mail_encryption', 'tls', '2024-08-19 05:54:30', '2024-08-20 05:42:28'),
(42, 'mail_sender_name', 'WebSolutionUs', '2024-08-19 05:54:30', '2024-08-20 05:42:28'),
(43, 'contact_message_receiver_mail', 'receiver@gmail.com', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(44, 'pusher_app_id', 'pusher_app_id', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(45, 'pusher_app_key', 'pusher_app_key', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(46, 'pusher_app_secret', 'pusher_app_secret', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(47, 'pusher_app_cluster', 'pusher_app_cluster', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(48, 'pusher_status', 'inactive', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(49, 'club_point_rate', '1', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(50, 'club_point_status', 'active', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(51, 'maintenance_mode', '0', '2024-08-19 05:54:30', '2024-12-31 01:47:55'),
(52, 'maintenance_image', 'uploads/website-images/maintenance.webp', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(53, 'maintenance_title', 'Website Under maintenance', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(54, 'maintenance_description', 'We are currently performing maintenance on our website to improve your experience. Please check back later.\n <a title=\"Websolutions\" href=\"https://websolutionus.com/\">Websolutions</a>', '2024-08-19 05:54:30', '2024-08-19 05:54:30'),
(55, 'last_update_date', '2024-03-12 12:00:00', '2024-08-19 05:54:30', '2024-09-02 23:56:52'),
(56, 'is_queable', 'inactive', '2024-08-19 05:54:31', '2024-12-23 03:39:14'),
(57, 'comments_auto_approved', 'inactive', '2024-08-19 05:54:31', '2024-09-04 00:40:58'),
(58, 'selected_theme', 'all_theme', '2024-08-19 05:54:31', '2024-12-22 00:46:59'),
(59, 'home1_footer_logo', 'uploads/website-images/wsus-img-2024-08-26-04-56-38-6377.webp', '2024-08-19 05:54:31', '2024-08-25 22:56:38'),
(60, 'home2_logo', 'uploads/website-images/wsus-img-2024-08-15-08-25-16-5550.webp', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(61, 'home3_logo', 'uploads/website-images/wsus-img-2024-08-15-08-25-16-2027.webp', '2024-08-19 05:54:31', '2024-08-19 05:54:31'),
(62, 'theme1_primary_color', '#f02c2d', '2024-08-19 05:54:31', '2024-12-05 01:41:29'),
(63, 'theme2_primary_color', '#0a547a', '2024-08-19 05:54:31', '2024-12-05 01:41:29'),
(64, 'theme3_primary_color', '#27ae60', '2024-08-19 05:54:31', '2024-12-05 01:41:29');

-- --------------------------------------------------------

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

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `serial` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `slider_translations`
--

CREATE TABLE `slider_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slider_id` int(11) NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `socialite_credentials`
--

CREATE TABLE `socialite_credentials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `provider_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `provider_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `access_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `refresh_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `social_links`
--

CREATE TABLE `social_links` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `subscription_histories`
--

CREATE TABLE `subscription_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `subscription_plan_id` int(11) NOT NULL,
  `plan_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `plan_price` double(8,2) NOT NULL,
  `expiration_date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'expired',
  `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_details` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payable_amount` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `gateway_charge` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `payable_with_charge` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `paid_amount` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `payable_currency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `transaction` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number_of_aminities` int(11) DEFAULT NULL,
  `number_of_nearest_place` int(11) DEFAULT NULL,
  `number_of_photo` int(11) DEFAULT NULL,
  `number_of_property` int(11) DEFAULT NULL,
  `number_of_feature_property` int(11) DEFAULT NULL,
  `number_of_top_property` int(11) DEFAULT NULL,
  `number_of_urgent_property` int(11) DEFAULT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `is_top` tinyint(1) NOT NULL DEFAULT 0,
  `is_urgent` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `subscription_plans`
--

CREATE TABLE `subscription_plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `plan_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `plan_price` decimal(8,2) NOT NULL,
  `expiration_date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `courses_limit` int(11) DEFAULT 0 COMMENT 'null = unlimited',
  `course_max_price` int(11) DEFAULT 0 COMMENT '0 = unlimited',
  `course_notification` tinyint(1) NOT NULL DEFAULT 0,
  `email_support` tinyint(1) NOT NULL DEFAULT 0,
  `phone_support` tinyint(1) NOT NULL DEFAULT 0,
  `forum_support` tinyint(1) NOT NULL DEFAULT 0,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `serial` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number_of_aminities` int(11) DEFAULT NULL,
  `number_of_nearest_place` int(11) DEFAULT NULL,
  `number_of_photo` int(11) DEFAULT NULL,
  `number_of_property` int(11) DEFAULT NULL,
  `number_of_feature_property` int(11) DEFAULT NULL,
  `number_of_top_property` int(11) DEFAULT NULL,
  `number_of_urgent_property` int(11) DEFAULT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `is_top` tinyint(1) NOT NULL DEFAULT 0,
  `is_urgent` tinyint(1) NOT NULL DEFAULT 0,
  `is_popular` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `terms_and_conditions`
--

CREATE TABLE `terms_and_conditions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `terms_and_conditions`
--

INSERT INTO `terms_and_conditions` (`id`, `created_at`, `updated_at`) VALUES
(1, '2024-08-19 05:54:39', '2024-08-19 05:54:39');

-- --------------------------------------------------------

--
-- Table structure for table `terms_and_condition_translations`
--

CREATE TABLE `terms_and_condition_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `terms_and_condition_id` int(11) NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `terms_and_condition` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `terms_and_condition_translations`
--

INSERT INTO `terms_and_condition_translations` (`id`, `terms_and_condition_id`, `lang_code`, `terms_and_condition`, `created_at`, `updated_at`) VALUES
(1, 1, 'en', '', '2024-08-19 05:54:39', '2025-01-02 05:37:25');

-- --------------------------------------------------------

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `testimonial_translations`
--

CREATE TABLE `testimonial_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `testimonial_id` bigint(20) UNSIGNED NOT NULL,
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `designation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linkedin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `whatsapp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon_one` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link_one` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon_two` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link_two` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon_three` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link_three` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon_four` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link_four` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `about` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city_id` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `is_banned` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `verification_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `forget_password_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wallet_balance` decimal(8,2) NOT NULL DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `wish_lists`
--

CREATE TABLE `wish_lists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `property_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `about_us`
--
ALTER TABLE `about_us`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `about_us_translations`
--
ALTER TABLE `about_us_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admins_email_unique` (`email`);

--
-- Indexes for table `aminities`
--
ALTER TABLE `aminities`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `aminity_translations`
--
ALTER TABLE `aminity_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `background_images`
--
ALTER TABLE `background_images`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `banned_histories`
--
ALTER TABLE `banned_histories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `basic_payments`
--
ALTER TABLE `basic_payments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blog_categories`
--
ALTER TABLE `blog_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blog_category_translations`
--
ALTER TABLE `blog_category_translations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `blog_category_translations_blog_category_id_foreign` (`blog_category_id`);

--
-- Indexes for table `blog_comments`
--
ALTER TABLE `blog_comments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blog_translations`
--
ALTER TABLE `blog_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `careers`
--
ALTER TABLE `careers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `career_requests`
--
ALTER TABLE `career_requests`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `career_translations`
--
ALTER TABLE `career_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `configurations`
--
ALTER TABLE `configurations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contact_information`
--
ALTER TABLE `contact_information`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contact_information_translations`
--
ALTER TABLE `contact_information_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contact_messages`
--
ALTER TABLE `contact_messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contact_us_pages`
--
ALTER TABLE `contact_us_pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contact_us_page_translations`
--
ALTER TABLE `contact_us_page_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `counters`
--
ALTER TABLE `counters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `counter_translations`
--
ALTER TABLE `counter_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `country_states`
--
ALTER TABLE `country_states`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customizeable_pages`
--
ALTER TABLE `customizeable_pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `customizeable_pages_slug_unique` (`slug`);

--
-- Indexes for table `customizeable_page_items`
--
ALTER TABLE `customizeable_page_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `custom_addons`
--
ALTER TABLE `custom_addons`
  ADD PRIMARY KEY (`id`),
  ADD KEY `custom_addons_name_index` (`name`),
  ADD KEY `idx_custom_addons_status` (`status`);

--
-- Indexes for table `custom_codes`
--
ALTER TABLE `custom_codes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `custom_pages`
--
ALTER TABLE `custom_pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `custom_page_translations`
--
ALTER TABLE `custom_page_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `custom_paginations`
--
ALTER TABLE `custom_paginations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `email_templates`
--
ALTER TABLE `email_templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `faqs`
--
ALTER TABLE `faqs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `faq_translations`
--
ALTER TABLE `faq_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `languages_name_unique` (`name`),
  ADD UNIQUE KEY `languages_code_unique` (`code`);

--
-- Indexes for table `menus`
--
ALTER TABLE `menus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `menu_items`
--
ALTER TABLE `menu_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `menu_items_menu_id_foreign` (`menu_id`);

--
-- Indexes for table `menu_item_translations`
--
ALTER TABLE `menu_item_translations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `menu_item_translations_menu_item_id_foreign` (`menu_item_id`);

--
-- Indexes for table `menu_translations`
--
ALTER TABLE `menu_translations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `menu_translations_menu_id_foreign` (`menu_id`);

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `multi_currencies`
--
ALTER TABLE `multi_currencies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `nearest_locations`
--
ALTER TABLE `nearest_locations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `nearest_location_translations`
--
ALTER TABLE `nearest_location_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `news_letters`
--
ALTER TABLE `news_letters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `our_teams`
--
ALTER TABLE `our_teams`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `page_item_components`
--
ALTER TABLE `page_item_components`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `payment_gateways`
--
ALTER TABLE `payment_gateways`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `privacy_policies`
--
ALTER TABLE `privacy_policies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `privacy_policy_translations`
--
ALTER TABLE `privacy_policy_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `properties`
--
ALTER TABLE `properties`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `property_aminities`
--
ALTER TABLE `property_aminities`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `property_images`
--
ALTER TABLE `property_images`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `property_nearest_locations`
--
ALTER TABLE `property_nearest_locations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `property_purposes`
--
ALTER TABLE `property_purposes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `property_purpose_translations`
--
ALTER TABLE `property_purpose_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `property_reviews`
--
ALTER TABLE `property_reviews`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `property_translations`
--
ALTER TABLE `property_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `property_types`
--
ALTER TABLE `property_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `property_type_translations`
--
ALTER TABLE `property_type_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `section_controls`
--
ALTER TABLE `section_controls`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `seo_settings`
--
ALTER TABLE `seo_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `service_translations`
--
ALTER TABLE `service_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sliders`
--
ALTER TABLE `sliders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `slider_translations`
--
ALTER TABLE `slider_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `socialite_credentials`
--
ALTER TABLE `socialite_credentials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `social_links`
--
ALTER TABLE `social_links`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `subscription_histories`
--
ALTER TABLE `subscription_histories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `subscription_histories_uuid_unique` (`uuid`);

--
-- Indexes for table `subscription_plans`
--
ALTER TABLE `subscription_plans`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `terms_and_conditions`
--
ALTER TABLE `terms_and_conditions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `terms_and_condition_translations`
--
ALTER TABLE `terms_and_condition_translations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `testimonial_translations`
--
ALTER TABLE `testimonial_translations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `testimonial_translations_lang_code_index` (`lang_code`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Indexes for table `wish_lists`
--
ALTER TABLE `wish_lists`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `about_us`
--
ALTER TABLE `about_us`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `about_us_translations`
--
ALTER TABLE `about_us_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `aminities`
--
ALTER TABLE `aminities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `aminity_translations`
--
ALTER TABLE `aminity_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `background_images`
--
ALTER TABLE `background_images`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `banned_histories`
--
ALTER TABLE `banned_histories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `basic_payments`
--
ALTER TABLE `basic_payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blog_categories`
--
ALTER TABLE `blog_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `blog_category_translations`
--
ALTER TABLE `blog_category_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blog_comments`
--
ALTER TABLE `blog_comments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blog_translations`
--
ALTER TABLE `blog_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `careers`
--
ALTER TABLE `careers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `career_requests`
--
ALTER TABLE `career_requests`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `career_translations`
--
ALTER TABLE `career_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cities`
--
ALTER TABLE `cities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `configurations`
--
ALTER TABLE `configurations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `contact_information`
--
ALTER TABLE `contact_information`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `contact_information_translations`
--
ALTER TABLE `contact_information_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `contact_messages`
--
ALTER TABLE `contact_messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contact_us_pages`
--
ALTER TABLE `contact_us_pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `contact_us_page_translations`
--
ALTER TABLE `contact_us_page_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `counters`
--
ALTER TABLE `counters`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `counter_translations`
--
ALTER TABLE `counter_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `country_states`
--
ALTER TABLE `country_states`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customizeable_pages`
--
ALTER TABLE `customizeable_pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `customizeable_page_items`
--
ALTER TABLE `customizeable_page_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `custom_addons`
--
ALTER TABLE `custom_addons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `custom_codes`
--
ALTER TABLE `custom_codes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `custom_pages`
--
ALTER TABLE `custom_pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `custom_page_translations`
--
ALTER TABLE `custom_page_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `custom_paginations`
--
ALTER TABLE `custom_paginations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `email_templates`
--
ALTER TABLE `email_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `faq_translations`
--
ALTER TABLE `faq_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `menu_items`
--
ALTER TABLE `menu_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `menu_item_translations`
--
ALTER TABLE `menu_item_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=106;

--
-- AUTO_INCREMENT for table `menu_translations`
--
ALTER TABLE `menu_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=102;

--
-- AUTO_INCREMENT for table `multi_currencies`
--
ALTER TABLE `multi_currencies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `nearest_locations`
--
ALTER TABLE `nearest_locations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `nearest_location_translations`
--
ALTER TABLE `nearest_location_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `news_letters`
--
ALTER TABLE `news_letters`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `our_teams`
--
ALTER TABLE `our_teams`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `page_item_components`
--
ALTER TABLE `page_item_components`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `payment_gateways`
--
ALTER TABLE `payment_gateways`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=222;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `privacy_policies`
--
ALTER TABLE `privacy_policies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `privacy_policy_translations`
--
ALTER TABLE `privacy_policy_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `properties`
--
ALTER TABLE `properties`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `property_aminities`
--
ALTER TABLE `property_aminities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `property_images`
--
ALTER TABLE `property_images`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `property_nearest_locations`
--
ALTER TABLE `property_nearest_locations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `property_purposes`
--
ALTER TABLE `property_purposes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `property_purpose_translations`
--
ALTER TABLE `property_purpose_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `property_reviews`
--
ALTER TABLE `property_reviews`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `property_translations`
--
ALTER TABLE `property_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `property_types`
--
ALTER TABLE `property_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `property_type_translations`
--
ALTER TABLE `property_type_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `section_controls`
--
ALTER TABLE `section_controls`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `seo_settings`
--
ALTER TABLE `seo_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `service_translations`
--
ALTER TABLE `service_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `slider_translations`
--
ALTER TABLE `slider_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `socialite_credentials`
--
ALTER TABLE `socialite_credentials`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `social_links`
--
ALTER TABLE `social_links`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subscription_histories`
--
ALTER TABLE `subscription_histories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subscription_plans`
--
ALTER TABLE `subscription_plans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `terms_and_conditions`
--
ALTER TABLE `terms_and_conditions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `terms_and_condition_translations`
--
ALTER TABLE `terms_and_condition_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `testimonial_translations`
--
ALTER TABLE `testimonial_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wish_lists`
--
ALTER TABLE `wish_lists`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `blog_category_translations`
--
ALTER TABLE `blog_category_translations`
  ADD CONSTRAINT `blog_category_translations_blog_category_id_foreign` FOREIGN KEY (`blog_category_id`) REFERENCES `blog_categories` (`id`);

--
-- Constraints for table `menu_items`
--
ALTER TABLE `menu_items`
  ADD CONSTRAINT `menu_items_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `menu_item_translations`
--
ALTER TABLE `menu_item_translations`
  ADD CONSTRAINT `menu_item_translations_menu_item_id_foreign` FOREIGN KEY (`menu_item_id`) REFERENCES `menu_items` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `menu_translations`
--
ALTER TABLE `menu_translations`
  ADD CONSTRAINT `menu_translations_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;