-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `paradox`
--

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

--
-- Table structure for table `about_sections`
--

CREATE TABLE `about_sections` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `sub_title` varchar(255) DEFAULT NULL,
  `client_text` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `btn_name` varchar(255) DEFAULT NULL,
  `btn_url` varchar(255) DEFAULT NULL,
  `years_of_expricence` 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;

--
-- Dumping data for table `about_sections`
--

INSERT INTO `about_sections` (`id`, `language_id`, `title`, `sub_title`, `client_text`, `description`, `btn_name`, `btn_url`, `years_of_expricence`, `created_at`, `updated_at`) VALUES
(1, 20, 'About Us', 'Shaping the future of living and investment.', '5 k+ Active Client’s', '<p>Paradox Real Estate—a modern, luxury-driven real estate firm that seamlessly blends timeless elegance with personalized service. Based in the heart of Dubai, we are here to redefine your property journey, whether you’re searching for a simple rental apartment or a stunning luxury villa.</p>\r\n<p> </p>\r\n<p>As a seasoned business owner with 15+ years of experience in the UAE across diverse industries, our Founder has built a reputation of trust and transparency, expertise, and exceptional customer service.  With the deep understanding of the local market and a passion for creating meaningful connections, we ensure every client receives a tailored experience that exceeds expectations.</p>', 'About Us', 'https://example.com', NULL, '2023-12-09 23:08:36', '2025-10-10 14:24:21'),
(2, 25, 'معلومات عنا', 'نوفّر لك وجهتك المفضلة دائمًا', '5 آلاف+ عميل نشط', '<p>ن ينتقد شخص ما أراد أن يشعر بالسعادة التي لا تشوبها عواقب أليمةلا يوجد منفذ إضافي. عصر ن ينتقد شخص ما أراد أن يشعر بالسعادة التي لا تشوبها عواقب أليمة يستخدم معرف الحمية الغذائية والنقل في.</p>\r\n<p><br>رضا العميل بنسبة 100%</p>\r\n<p>نحن دائما نشعر بالقلق إزاء لدينا<br>المشروع والعميل</p>\r\n<p><br>رضا العميل بنسبة 100%</p>\r\n<p>نحن دائما نشعر بالقلق إزاء لدينا<br>المشروع والعميل</p>', 'معلومات عنا', 'https://example.com', 2, '2024-03-27 00:10:45', '2024-06-14 07:42:05');

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

--
-- Table structure for table `admin_infos`
--

CREATE TABLE `admin_infos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `admin_id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zipcode` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `details` varchar(255) 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 `admin_infos`
--

INSERT INTO `admin_infos` (`id`, `admin_id`, `language_id`, `first_name`, `last_name`, `country`, `city`, `state`, `zipcode`, `address`, `details`, `created_at`, `updated_at`) VALUES
(1, 1, 20, 'Alex', 'Daddario', 'USA', 'Demra, Dhaka.', 'Texas', NULL, NULL, NULL, '2024-02-05 04:31:07', '2024-06-12 06:16:00'),
(2, 1, 24, 'Abu', 'Farhan', 'Bangladesh', 'Demra, Dhaka.', 'Dhaka', '1361', '11/64 Dogair Bazar', 'asdf', '2024-02-05 04:31:07', '2024-02-05 04:32:40'),
(3, 1, 25, 'أليكس', 'داداريو', 'الولايات المتحدة الأمريكية', NULL, 'تكساس', NULL, NULL, NULL, '2024-06-12 06:16:00', '2024-06-12 06:16:00');

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

--
-- Table structure for table `advertisements`
--

CREATE TABLE `advertisements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ad_type` varchar(255) NOT NULL,
  `resolution_type` smallint(5) UNSIGNED NOT NULL COMMENT '1 => 300 x 250, 2 => 300 x 600, 3 => 728 x 90',
  `image` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `slot` varchar(50) DEFAULT NULL,
  `views` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `advertisements`
--

INSERT INTO `advertisements` (`id`, `ad_type`, `resolution_type`, `image`, `url`, `slot`, `views`, `created_at`, `updated_at`) VALUES
(8, 'banner', 2, '65bf704fb05c6.png', 'http://example.com/', NULL, 0, '2021-08-15 22:45:21', '2024-02-04 05:09:03'),
(9, 'banner', 1, '65bf6fee56fbd.png', 'http://example.com/', NULL, 0, '2021-08-15 23:12:31', '2024-02-04 05:07:26'),
(10, 'banner', 1, '65bf7005b181d.png', 'http://example.com/', NULL, 2, '2021-08-15 23:13:44', '2024-02-04 05:07:49'),
(11, 'banner', 2, '65bf703742894.png', 'http://example.com/', NULL, 2, '2021-08-15 23:15:14', '2024-02-04 05:08:39'),
(12, 'banner', 1, '65bf5a21d896f.png', 'http://example.com/', NULL, 1, '2021-08-15 23:16:41', '2024-02-04 03:34:25'),
(13, 'banner', 3, '65bf707d02fb5.png', 'http://example.com/', NULL, 1, '2021-08-17 04:52:09', '2024-02-04 05:09:49');

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

--
-- Table structure for table `agent_infos`
--

CREATE TABLE `agent_infos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `agent_id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `zip_code` 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;

--
-- Dumping data for table `agent_infos`
--

INSERT INTO `agent_infos` (`id`, `agent_id`, `language_id`, `first_name`, `last_name`, `country`, `state`, `city`, `address`, `details`, `zip_code`, `created_at`, `updated_at`) VALUES
(30, 19, 20, 'Brock', 'Drury', 'USA', 'Miami', 'Homestead', 'Main Street Homestead, FL 34030', 'Drury has been living in Miami and selling Real Estate for the past 28 years. She specializes in Key Biscayne, Brickell, and Sunny Isles. She is in the top half of the top 1% of Real Estate agents nationwide. As a multi-million dollar Top Producer and Diamond level Member, she is a reliable and loyal agent who cares about her clientele. She puts their needs above anything, allowing her to form close, personal relationships, and eventually good friendships, with the people she works with. Because she has been living in Miami for 27 years, she has witnessed the city grow and expand into the incredible Metropolitan city it has become today. She is an expert, and extremely knowledgeable on all things Real Estate. Additionally, she is fluent in Spanish, English and Portuguese, allowing her to work with a broad range of people.', NULL, '2024-06-12 06:29:31', '2024-06-13 11:27:12'),
(31, 19, 25, 'بروك', 'دروري', 'الولايات المتحدة الأمريكية', 'ميامي', 'هومستيد', 'مين ستريت هومستيد، فلوريدا 43030', 'يعيش دروري في ميامي ويبيع العقارات منذ 28 عامًا. وهي متخصصة في بريكل وصني آيلز. إنها ضمن النصف العلوي من أفضل 1% من وكلاء العقارات على مستوى البلاد. بصفتها منتجة رائدة تبلغ قيمتها ملايين الدولارات وعضوة على مستوى الماس، فهي وكيلة موثوقة ومخلصة تهتم بعملائها. إنها تضع احتياجاتهم فوق أي شيء، مما يسمح لها بتكوين علاقات شخصية وثيقة، وفي النهاية صداقات جيدة، مع الأشخاص الذين تعمل معهم. ولأنها تعيش في ميامي منذ 27 عامًا، فقد شهدت نمو المدينة وتوسعها لتصبح المدينة الحضرية المذهلة التي أصبحت عليها اليوم. إنها خبيرة وذو معرفة كبيرة بكل ما يتعلق بالعقارات. بالإضافة إلى ذلك، فهي تتحدث الإسبانية والإنجليزية والبرتغالية بطلاقة، مما يسمح لها بالعمل مع مجموعة واسعة من الأشخاص.', NULL, '2024-06-12 06:29:31', '2024-06-13 11:27:12'),
(32, 20, 20, 'Cooper', 'icolle', 'USA', 'Miami', 'Homestead', 'Main Street  Homestead, FL 33030', 'Turn-key Unit!! Upgraded 1 BED + 1.5 BATHS at the legendary Seacoast Condo built by iconic architect Morris Lapidus. Partial ocean views. Features brand new double glass impact hurricane windows and doors, porcelain floors, marble bathrooms. Large walking closet. 1 parking included. Situated in the heart of Miami Beach on \"Millionaires Row\" Seacoast Condo has 4 acres of vast grounds featuring one majestic fountain lobby, a 6,000 SQFT state of the art gym, pristine gardens and tikki bar area, lounge chairs & umbrellas service at the beach and two new barbecues cabanas. There is a grocery market at the lobby area and an events ballroom. Private boat dock marinas. Min 30-day rentals. Equal Housing Opportunity.', NULL, '2024-06-12 06:30:52', '2024-06-13 11:33:19'),
(33, 20, 25, 'كوبر', 'كلية', 'الولايات المتحدة الأمريكية', 'ميامي', 'هومستيد', 'مين ستريت هومستيد، فلوريدا', 'وحدة تسليم المفتاح!! ترقية غرفة نوم واحدة + 1.5 حمام في شقة Seacoast Condo الأسطورية التي بناها المهندس المعماري الشهير موريس لابيدوس. إطلالات جزئية على المحيط. تتميز بنوافذ وأبواب زجاجية مزدوجة جديدة تمامًا مقاومة للإعصار وأرضيات بورسلين وحمامات رخامية. خزانة مشي كبيرة. 1 موقف سيارات متضمن. يقع في قلب ميامي بيتش في شارع المليونيرات، ويحتوي على 4 أفدنة من الأراضي الشاسعة التي تضم ردهة نافورة مهيبة وصالة ألعاب رياضية حديثة بمساحة 6000 قدم مربع وحدائق نقية ومنطقة بار تيكي وخدمة كراسي الاستلقاء والمظلات على الشاطئ. واثنين من كابانات الشواء الجديدة يوجد سوق بقالة في منطقة الردهة وقاعة حفلات خاصة لإيجار القوارب لمدة 30 يومًا.', NULL, '2024-06-12 06:30:52', '2024-06-13 11:33:19'),
(34, 21, 20, 'Alex', 'Rendall', 'USA', NULL, NULL, 'Miami, FL', 'Alex Rendall  is a highly experienced, multilingual real estate professional specializing in global luxury markets spanning residential and commercial acquisitions. An avid seller and investor, Bozana knows the ins and outs of the business and works fiercely to negotiate the best outcome no matter which side you’re on.\r\n\r\nHer keen eye for global and domestic business deals has taken her all over—from Dubrovnik, Croatia to Toronto, Canada to Beverly Hills, California to Miami, Florida where she continues to influence the luxury real estate market. With residences around the world and successful businesses in several of the country’s largest affluent sectors, Bozana is uniquely positioned to shepherd clients in high-yielding investments.\r\n\r\nAs CEO of Creative Forces - Bozana connects with high-net-worth individuals and luxury brands around the globe. She works tirelessly to generate new business and seek out exciting opportunities for clients. From organizing engaging sales events to participating in luxury showcases to tapping into her vast client base, Bozana’s active role in the community translates to unequivocal success for every person she engages with.\r\n\r\nIn her spare time, Bozana enjoys traveling the world, immersing herself in different cultures, and meeting new people. She’s involved in the arts and has been instrumental in the development of prominent cultural districts, where she also owns a Landmark Hotel and a thriving private bar and restaurant. She takes a no-nonsense approach to life and business, valuing honesty and integrity above all.\r\n\r\nYou can trust Bozana to remain transparent and committed to selling your property at the highest value or finding you the home of your dreams at the right price. With decades of experience and unparalleled expertise in residential and commercial real estate, Bozana is the solution-driven advocate you want on your side.', NULL, '2024-06-12 06:39:11', '2024-06-13 10:33:25'),
(35, 21, 25, 'أليكس', 'ريندال', 'الولايات المتحدة الأمريكية', NULL, NULL, 'ميامي، FL', 'يتمتع Alex Rendall بخبرة عالية ومتخصص في مجال العقارات ومتعدد اللغات ومتخصص في الأسواق العالمية الفاخرة التي تشمل عمليات الاستحواذ السكنية والتجارية. بصفته بائعًا ومستثمرًا متحمسًا، يعرف بوزانا خصوصيات وعموميات العمل ويعمل بجهد للتفاوض على أفضل النتائج بغض النظر عن الجانب الذي تقف فيه.\r\n\r\nلقد أخذتها نظرتها الثاقبة للصفقات التجارية العالمية والمحلية في كل مكان - من دوبروفنيك، كرواتيا إلى تورونتو، كندا إلى بيفرلي هيلز، كاليفورنيا إلى ميامي، فلوريدا حيث تواصل التأثير على سوق العقارات الفاخرة. مع وجود مساكن في جميع أنحاء العالم وشركات ناجحة في العديد من أكبر القطاعات الغنية في البلاد، تتمتع بوزانا بموقع فريد لرعاية العملاء في الاستثمارات ذات العائد المرتفع.\r\n\r\nبصفته الرئيس التنفيذي لشركة Creative Forces - يتواصل بوزانا مع الأفراد ذوي الثروات العالية والعلامات التجارية الفاخرة في جميع أنحاء العالم. إنها تعمل بلا كلل لتوليد أعمال جديدة والبحث عن فرص مثيرة للعملاء. من تنظيم أحداث المبيعات الجذابة إلى المشاركة في المعارض الفاخرة إلى الاستفادة من قاعدة عملائها الواسعة، يُترجم دور بوزانا النشط في المجتمع إلى نجاح لا لبس فيه لكل شخص تتعامل معه.\r\n\r\nتستمتع بوزانا في أوقات فراغها بالسفر حول العالم والانغماس في ثقافات مختلفة والتعرف على أشخاص جدد. لقد انخرطت في الفنون وكان لها دور فعال في تطوير المناطق الثقافية البارزة، حيث تمتلك أيضًا فندق لاندمارك وبارًا خاصًا ومطعمًا مزدهرًا. إنها تتبع نهجًا لا معنى له في الحياة والعمل، وتقدر الصدق والنزاهة قبل كل شيء.\r\n\r\nيمكنك الوثوق في لتظل شفافة وملتزمة ببيع الممتلكات الخاصة بك بأعلى قيمة أو العثور على منزل أحلامك بالسعر المناسب. مع عقود من الخبرة والخبرة التي لا مثيل لها في مجال العقارات السكنية والتجارية، يعد هو المدافع المبني على الحلول الذي تريده إلى جانبك.', NULL, '2024-06-12 06:39:11', '2024-06-13 10:33:25'),
(36, 22, 20, 'Brayden', 'Isaacson', 'USA', 'Texas', 'San Antonio', '123 Alamo Plaza San Antonio, TX 78205', 'Brayden Isaacson was born in Colombia and moved to the United States in 2001 at the age of 20, in pursuit of a better future. He initially took a job working at a cafeteria in a Miami hotel. Noticing construction taking off in 2002 he looked for a way into the real estate industry and found work with investors who were purchasing, remodeling, and selling single family homes in the Tampa Bay area.\r\n\r\nMiguel immediately fell in love with the business, and quickly learned from the investors who became mentors to him. They saw his potential and within a short time he was managing over 150 properties in Tampa Bay, Orlando, and Jacksonville, Florida while becoming a Residential Real Estate Appraiser until opening his own practice.\r\n\r\nSoon after became very interested in helping families achieve their home dreams and goals for what he became a Sales Associate and then a Top Producer Broker achieving the highest sales award over four consecutive years during his time at Weichert, Realtors - Best Beach. He is now ranked the #1 agent in sales for Century 21 KoRes and a member of Masters Emerald an elite group of high producing professionals for Century 21 in the country.\r\n\r\nMiguel’s top skills include Spanish/English fluent, quality negotiation skills MCNE (Master Certified Negotiation Expert) finding value in complex properties and hands on team ready to resolve and cater the most complex transaction or client’s need.\r\n\r\nIn his free time Miguel enjoys spending time with his family, traveling, little league, practicing CrossFit, soccer and triathlons.', NULL, '2024-06-12 06:41:39', '2024-06-13 12:15:59'),
(37, 22, 25, 'Brayden', 'Isaacson', 'الولايات المتحدة الأمريكية', 'تكساس', 'سان أنطونيو', '123 ألامو بلازا، سان أنطونيو، تكساس 78205', 'ولد أوسكار إيدي في كولومبيا وانتقل إلى الولايات المتحدة في عام 2001 عن عمر 20 عامًا، سعيًا وراء مستقبل أفضل. تولى في البداية وظيفة العمل في كافتيريا في أحد فنادق ميامي. لاحظ انطلاق أعمال البناء في عام 2002، فبحث عن طريقة للدخول في صناعة العقارات ووجد عملاً مع المستثمرين الذين كانوا يشترون ويعيدون تصميم وبيع منازل الأسرة الواحدة في منطقة خليج تامبا.\r\n\r\nوقع ميغيل على الفور في حب هذا العمل، وسرعان ما تعلم من المستثمرين الذين أصبحوا مرشدين له. لقد رأوا إمكاناته وفي غضون وقت قصير كان يدير أكثر من 150 عقارًا في خليج تامبا وأورلاندو وجاكسونفيل بولاية فلوريدا بينما أصبح مثمنًا للعقارات السكنية حتى افتتاح عيادته الخاصة.\r\n\r\nوبعد فترة وجيزة أصبح مهتمًا جدًا بمساعدة العائلات على تحقيق أحلامهم وأهدافهم المنزلية حيث أصبح مساعد مبيعات ثم وسيطًا من أفضل المنتجين محققًا أعلى جائزة مبيعات على مدار أربع سنوات متتالية خلال فترة وجوده.\r\n\r\nتشمل مهارات ميغيل العليا التحدث باللغة الإسبانية/الإنجليزية بطلاقة، ومهارات تفاوض عالية الجودة، وخبير تفاوض معتمد رئيسي يجد القيمة في العقارات المعقدة وفريق عمل جاهز لحل وتلبية المعاملات الأكثر تعقيدًا أو احتياجات العميل.\r\n\r\nفي أوقات فراغه، يستمتع ميغيل بقضاء الوقت مع عائلته، والسفر، وممارسة الدوري الصغير، وممارسة رياضة الكروس فيت، وكرة القدم، والسباقات الثلاثية.', NULL, '2024-06-12 06:41:39', '2024-06-13 12:15:59'),
(38, 23, 20, 'Blake', 'Nerli', 'USA', 'Texas', 'San Antonio', '123 Alamo Plaza San Antonio, TX 78205', 'Blake was born in Colombia and moved to the United States in 2001 at the age of 20, in pursuit of a better future. He initially took a job working at a cafeteria in a Miami hotel. Noticing construction taking off in 2002 he looked for a way into the real estate industry and found work with investors who were purchasing, remodeling, and selling single family homes in the Tampa Bay area.\r\n\r\nMiguel immediately fell in love with the business, and quickly learned from the investors who became mentors to him. They saw his potential and within a short time he was managing over 150 properties in Tampa Bay, Orlando, and Jacksonville, Florida while becoming a Residential Real Estate Appraiser until opening his own practice.\r\n\r\nSoon after became very interested in helping families achieve their home dreams and goals for what he became a Sales Associate and then a Top Producer Broker achieving the highest sales award over four consecutive years during his time at Weichert, Realtors - Best Beach. He is now ranked the #1 agent in sales for Century 21 KoRes and a member of Masters Emerald an elite group of high producing professionals for Century 21 in the country.\r\n\r\nMiguel’s top skills include Spanish/English fluent, quality negotiation skills MCNE (Master Certified Negotiation Expert) finding value in complex properties and hands on team ready to resolve and cater the most complex transaction or client’s need.\r\n\r\nIn his free time Miguel enjoys spending time with his family, traveling, little league, practicing CrossFit, soccer and triathlons.', NULL, '2024-06-12 06:45:32', '2024-06-13 11:59:37'),
(39, 23, 25, 'Blake', 'Nerli', 'الولايات المتحدة الأمريكية', 'تكساس', 'سان أنطونيو', '123 ألامو بلازا\r\nسان أنطونيو، تكساس 78205', 'ولد أوسكار إيدي في كولومبيا وانتقل إلى الولايات المتحدة في عام 2001 عن عمر 20 عامًا، سعيًا وراء مستقبل أفضل. تولى في البداية وظيفة العمل في كافتيريا في أحد فنادق ميامي. لاحظ انطلاق أعمال البناء في عام 2002، فبحث عن طريقة للدخول في صناعة العقارات ووجد عملاً مع المستثمرين الذين كانوا يشترون ويعيدون تصميم وبيع منازل الأسرة الواحدة في منطقة خليج تامبا.\r\n\r\nوقع ميغيل على الفور في حب هذا العمل، وسرعان ما تعلم من المستثمرين الذين أصبحوا مرشدين له. لقد رأوا إمكاناته وفي غضون وقت قصير كان يدير أكثر من 150 عقارًا في خليج تامبا وأورلاندو وجاكسونفيل بولاية فلوريدا بينما أصبح مثمنًا للعقارات السكنية حتى افتتاح عيادته الخاصة.\r\n\r\nوبعد فترة وجيزة أصبح مهتمًا جدًا بمساعدة العائلات على تحقيق أحلامهم وأهدافهم المنزلية حيث أصبح مساعد مبيعات ثم وسيطًا من أفضل المنتجين محققًا أعلى جائزة مبيعات على مدار أربع سنوات متتالية خلال فترة وجوده.\r\n\r\nتشمل مهارات ميغيل العليا التحدث باللغة الإسبانية/الإنجليزية بطلاقة، ومهارات تفاوض عالية الجودة، وخبير تفاوض معتمد رئيسي يجد القيمة في العقارات المعقدة وفريق عمل جاهز لحل وتلبية المعاملات الأكثر تعقيدًا أو احتياجات العميل.\r\n\r\nفي أوقات فراغه، يستمتع ميغيل بقضاء الوقت مع عائلته، والسفر، وممارسة الدوري الصغير، وممارسة رياضة الكروس فيت، وكرة القدم، والسباقات الثلاثية.', NULL, '2024-06-12 06:45:32', '2024-06-13 11:59:37'),
(40, 24, 20, 'Cameron', 'Schmella', 'USA', 'Miami', 'Homestead', 'Key Biscayne, FL', 'Meet Schmella , one of the most accomplished Realtors affiliated with Douglas Elliman, a dominant force in the global real estate market, and the number one firm in the Miami area. With an impressive 30-year track record in South Florida real estate, Teddy proudly holds a position as one of the top commercial agents, and is among the top 8% of the 7,000+ Douglas Elliman agents as of 2022.\r\n\r\nAs a Miami native, Teddy brings an intimate understanding of the local market. Over the past three decades, Teddy has established a robust network of clients that includes buyers, sellers, investors, and many high-net-worth individuals, making him a trusted figure in the ever-evolving South Florida real estate landscape.\r\n\r\nTeddy\'s expertise extends to facilitating successful transactions with hundreds of families, successful investors, and top business professionals in the lively Miami Beach area. His commitment to excellence and wealth of experience ensures a seamless process for every client, no matter what the needs.\r\n\r\nWhether you\'re contemplating a purchase, sale, or investment, Teddy invites you to explore the difference the right representation can make.\r\n\r\nReach out today and let Teddy Fernandez guide you in transforming your real estate aspirations into reality.', NULL, '2024-06-12 06:56:44', '2024-06-13 11:48:31'),
(41, 24, 25, 'Cameron', 'Schmella', 'الولايات المتحدة الأمريكية', 'ميامي', 'هومستيد', 'كي بيسكين، فلوريدا', 'تعرف على Schmella، أحد أفضل السماسرة التابعين لـ Douglas Elliman، القوة المهيمنة في سوق العقارات العالمية، والشركة الأولى في منطقة ميامي. بفضل سجل حافل يمتد على مدار 30 عامًا في العقارات في جنوب فلوريدا، يفخر تيدي بمكانته كواحد من أفضل الوكلاء التجاريين، وهو من بين أفضل 8% من وكلاء دوجلاس إليمان الذين يزيد عددهم عن 7000 وكيل اعتبارًا من عام 2022.\r\n\r\nبصفته أحد مواطني ميامي، يتمتع تيدي بفهم عميق للسوق المحلية. على مدى العقود الثلاثة الماضية، أنشأ تيدي شبكة قوية من العملاء تشمل المشترين والبائعين والمستثمرين والعديد من الأفراد ذوي الثروات العالية، مما جعله شخصية موثوقة في المشهد العقاري المتطور باستمرار في جنوب فلوريدا.\r\n\r\nتمتد خبرة تيدي إلى تسهيل المعاملات الناجحة مع مئات العائلات والمستثمرين الناجحين وكبار محترفي الأعمال في منطقة ميامي بيتش النابضة بالحياة. ويضمن التزامه بالتميز وخبرته الوفيرة عملية سلسة لكل عميل، بغض النظر عن احتياجاته.\r\n\r\nسواء كنت تفكر في الشراء أو البيع أو الاستثمار، يدعوك تيدي لاستكشاف الفرق الذي يمكن أن يحدثه التمثيل الصحيح.\r\n\r\nتواصل معنا اليوم ودع تيدي فرنانديز يرشدك في تحويل تطلعاتك العقارية إلى واقع.', NULL, '2024-06-12 06:56:44', '2024-06-13 11:48:31'),
(42, 25, 20, 'Jamie', 'Boag', 'USA', 'Texas', 'San Antonio', '123 Alamo Plaza\r\nSan Antonio, TX 78205', 'Jamie Boag was born in Colombia and moved to the United States in 2001 at the age of 20, in pursuit of a better future. He initially took a job working at a cafeteria in a Miami hotel. Noticing construction taking off in 2002 he looked for a way into the real estate industry and found work with investors who were purchasing, remodeling, and selling single family homes in the Tampa Bay area.\r\n\r\nMiguel immediately fell in love with the business, and quickly learned from the investors who became mentors to him. They saw his potential and within a short time he was managing over 150 properties in Tampa Bay, Orlando, and Jacksonville, Florida while becoming a Residential Real Estate Appraiser until opening his own practice.\r\n\r\nSoon after became very interested in helping families achieve their home dreams and goals for what he became a Sales Associate and then a Top Producer Broker achieving the highest sales award over four consecutive years during his time at Weichert, Realtors - Best Beach. He is now ranked the #1 agent in sales for Century 21 KoRes and a member of Masters Emerald an elite group of high producing professionals for Century 21 in the country.\r\n\r\nMiguel’s top skills include Spanish/English fluent, quality negotiation skills MCNE (Master Certified Negotiation Expert) finding value in complex properties and hands on team ready to resolve and cater the most complex transaction or client’s need.\r\n\r\nIn his free time Miguel enjoys spending time with his family, traveling, little league, practicing CrossFit, soccer and triathlons.', NULL, '2024-06-12 07:16:06', '2024-06-13 12:09:05'),
(43, 25, 25, 'Jamie', 'Boag', 'الولايات المتحدة الأمريكية', 'تكساس', 'تكساس', '123 ألامو بلازا\r\nسان أنطونيو، تكساس 78205', 'ولد أوسكار إيدي في كولومبيا وانتقل إلى الولايات المتحدة في عام 2001 عن عمر 20 عامًا، سعيًا وراء مستقبل أفضل. تولى في البداية وظيفة العمل في كافتيريا في أحد فنادق ميامي. لاحظ انطلاق أعمال البناء في عام 2002، فبحث عن طريقة للدخول في صناعة العقارات ووجد عملاً مع المستثمرين الذين كانوا يشترون ويعيدون تصميم وبيع منازل الأسرة الواحدة في منطقة خليج تامبا.\r\n\r\nوقع ميغيل على الفور في حب هذا العمل، وسرعان ما تعلم من المستثمرين الذين أصبحوا مرشدين له. لقد رأوا إمكاناته وفي غضون وقت قصير كان يدير أكثر من 150 عقارًا في خليج تامبا وأورلاندو وجاكسونفيل بولاية فلوريدا بينما أصبح مثمنًا للعقارات السكنية حتى افتتاح عيادته الخاصة.\r\n\r\nبعد فترة وجيزة أصبح مهتمًا جدًا بمساعدة العائلات على تحقيق أحلامهم وأهدافهم المنزلية حيث أصبح مساعد مبيعات ثم وسيطًا من أفضل المنتجين محققًا أعلى جائزة مبيعات على مدار أربع سنوات متتالية خلال فترة وجوده في Weichert، Realtors - Best Beach. لقد تم تصنيفه الآن كوكيل رقم 1 في المبيعات لشركة Century 21 KoRes وعضو في Masters Emerald، وهي مجموعة نخبة من المحترفين ذوي الإنتاج العالي لشركة Century 21 في البلاد.\r\n\r\nتشمل مهارات ميغيل العليا إتقان اللغة الإسبانية/الإنجليزية ومهارات التفاوض عالية الجودة MCNE (خبير تفاوض رئيسي معتمد) حيث يجد القيمة في العقارات المعقدة ويعمل على فريق جاهز لحل وتلبية المعاملات الأكثر تعقيدًا أو احتياجات العميل.\r\n\r\nفي أوقات فراغه، يستمتع ميغيل بقضاء الوقت مع عائلته، والسفر، وممارسة الدوري الصغير، وممارسة رياضة الكروس فيت، وكرة القدم، والسباقات الثلاثية.', NULL, '2024-06-12 07:16:06', '2024-06-13 12:09:05'),
(44, 26, 20, 'Jaxon', 'Stieglitz', 'Canada', NULL, NULL, 'Plantation, FL', 'Stieglitz is a South Florida real estate agent, Host of the American Dream TV show which also aires on HGTV, multilingual public speaker and a former regional property manager support who managed 22 million dollars in real estate assets from 2010-2019. As a real estate consultant with an outstanding expertise, in depth training and knowledge about all aspects in fields such as property management, real estate investing, rehabilitation of properties, buying, flipping and selling; with assertive real estate sales skills enhanced by top of the line marketing abilities, and fluency in 3 different languages (English, Spanish and Portuguese), Mia’s excellent negotiation skills guide every buyer and seller through Real Estate obstacles leading them happily to the closing table.\r\n\r\nSELLERS\r\n\r\nWhen working with Mia, you can expect her and her team to negotiate top dollar for your property to help you achieve your goals and objectives while selling your home in the least amount of time due to the exceptional service, a world-class marketing plan and the cutting edge technology that are provided to you and your family. Each member of our listing staff is trained to make the process easy from start to finish. Once you meet with Mia, you will feel confident that you are pricing your property at a competitive price and that you will be updated throughout the entire transaction. Our goal is for you to feel comfortable that we are on your team and that it is a WIN-WIN situation for all parties involved.', NULL, '2024-06-13 09:58:59', '2024-06-13 10:31:18'),
(45, 26, 25, 'Jaxon', 'Stieglitz', 'كندا', NULL, NULL, 'بلانتيشن، فلوريدا', 'Stieglitz هو وكيل عقارات في جنوب فلوريدا، ومضيف برنامج American Dream TV والذي يتم بثه أيضًا على HGTV، ومتحدث عام متعدد اللغات ومدير عقارات إقليمي سابق أدار 22 مليون دولار من الأصول العقارية من 2010-2019. كمستشار عقاري يتمتع بخبرة متميزة وتدريب متعمق ومعرفة بجميع الجوانب في مجالات مثل إدارة الممتلكات والاستثمار العقاري وإعادة تأهيل العقارات والشراء والتقليب والبيع؛ بفضل مهارات مبيعات العقارات الحازمة المعززة بقدرات تسويقية عالية المستوى، والطلاقة في 3 لغات مختلفة (الإنجليزية والإسبانية والبرتغالية)، فإن مهارات التفاوض الممتازة التي تتمتع بها ميا ترشد كل مشتري وبائع عبر العقبات العقارية التي تقودهم بسعادة إلى طاولة الإغلاق.\r\n\r\nالبائعين\r\n\r\nعند العمل مع Mia، يمكنك أن تتوقع منها وفريقها التفاوض على أعلى سعر لعقارك لمساعدتك في تحقيق أهدافك وغاياتك أثناء بيع منزلك في أقل قدر من الوقت بفضل الخدمة الاستثنائية وخطة تسويق عالمية المستوى و التكنولوجيا المتطورة التي يتم توفيرها لك ولعائلتك. يتم تدريب كل عضو في طاقم القائمة لدينا لجعل العملية سهلة من البداية إلى النهاية. بمجرد مقابلتك مع Mia، ستشعر بالثقة أنك تقوم بتسعير الممتلكات الخاصة بك بسعر تنافسي وسيتم تحديثك طوال المعاملة بأكملها. هدفنا هو أن تشعر بالراحة لوجودنا في فريقك وأن هذا وضع مربح للجانبين لجميع الأطراف المعنية.', NULL, '2024-06-13 09:58:59', '2024-06-13 10:31:18'),
(46, 27, 20, 'Morten M.', 'Nørgaard', 'USA', NULL, NULL, 'Miami, FL', 'Morten M. Nørgaard is an expert on the culture, lifestyle, and overall market in Southeast Florida. She represents buyers, sellers, and investors in residential real estate throughout Miami-Dade and Broward Counties, with a focus on luxury homes and condominiums in Miami, Brickell, Miami Springs, Miami Beach, North Miami Beach, and Coral Gables.\r\nArelis’s foundation as an agent is centered on human connection and hard work. She takes the time to get to know her clients, understand their goals, and guide them through the process with as little friction as possible. Real estate has been her passion for the last 16 years, and she is proud to share her vetted network of resources and services to elevate the buying and selling experience as a full-service concierge. Matched with her warm energy and extroverted personality, Arelis has developed friendships with clients that have lasted a lifetime; it’s her promise to be a support post-transaction for everyone she has the pleasure of working with.\r\nAlong with the Compass technology and service offering, including data and analytics software, Compass Concierge, and the Compass Bridge Loan Service, Arelis is backed by industry-leading tools and services that widen the scope of what an agent can typically accomplish for clients, further enhancing the experience of working with her. She utilizes Compass’s contemporary, high-tech marketing tools and materials to generate more awareness, better price points, and faster transactions than ever before, with a single-platform interface that centralizes every aspect of the real estate journey. It’s a win-win.\r\nOriginally from Puerto Rico, Arelis moved to the Sunshine State in 2000 and has called Miami home ever since. Fluent in both English and Spanish, she is hyper-connected with the vibrant culture of the city and looks forward to sharing it with prospective clients. She graduated in 2012 from Miami-Dade College with an Associate’s Degree in Arts with a major in Dietetics. She also completed one year of MDC Culinary School. In her free time, she enjoys cooking, working out, traveling, and laying out at the beach.', NULL, '2024-06-13 10:00:51', '2024-06-13 10:52:16'),
(47, 27, 25, 'مورتن م.', 'نورجارد', 'الولايات المتحدة الأمريكية', NULL, NULL, 'ميامي،', 'نورجارد هو خبير في الثقافة وأسلوب الحياة والسوق بشكل عام في جنوب شرق فلوريدا. وهي تمثل المشترين والبائعين والمستثمرين في العقارات السكنية في جميع أنحاء مقاطعتي ميامي ديد وبروارد، مع التركيز على المنازل والوحدات السكنية الفاخرة في ميامي، وبريكل، وميامي سبرينغز، وميامي بيتش، وشمال ميامي بيتش، وكورال جابلز.\r\nيتمحور أساس Arelis كوكيل حول التواصل البشري والعمل الجاد. إنها تأخذ الوقت الكافي للتعرف على عملائها وفهم أهدافهم وتوجيههم خلال العملية بأقل قدر ممكن من الاحتكاك. لقد كانت العقارات شغفها على مدار الستة عشر عامًا الماضية، وهي فخورة بمشاركة شبكتها من الموارد والخدمات التي تم فحصها للارتقاء بتجربة البيع والشراء باعتبارها خدمة كونسيرج متكاملة الخدمات. نظرًا لطاقتها الدافئة وشخصيتها المنفتحة، طورت Arelis صداقات مع العملاء استمرت مدى الحياة؛ إنه وعدها بأن تكون بمثابة دعم ما بعد المعاملة لكل شخص تسعد بالعمل معه.\r\nإلى جانب عرض التكنولوجيا والخدمات من Compass، بما في ذلك برامج البيانات والتحليلات، و، وخدمة ، فإن مدعومة بأدوات وخدمات رائدة في الصناعة تعمل على توسيع نطاق ما يمكن للوكيل تحقيقه عادةً للعملاء، بالإضافة إلى ذلك تعزيز تجربة العمل معها. إنها تستخدم أدوات ومواد تسويقية معاصرة وعالية التقنية من لتوليد المزيد من الوعي ونقاط أسعار أفضل ومعاملات أسرع من أي وقت مضى، من خلال واجهة منصة واحدة تركز كل جانب من جوانب الرحلة العقارية. إنه فوز مربح للجانبين.\r\nانتقل أريليس، في الأصل من بورتوريكو، إلى ولاية صن شاين في عام 2000 واتخذ من ميامي موطنًا له منذ ذلك الحين. وهي تتحدث اللغتين الإنجليزية والإسبانية بطلاقة، وهي على اتصال وثيق بثقافة المدينة النابضة بالحياة وتتطلع إلى مشاركتها مع العملاء المحتملين. تخرجت في عام 2012 من كلية ميامي ديد بدرجة الزمالة في الآداب مع تخصص في علم التغذية. أكملت أيضًا عامًا واحدًا في مدرسة MDC للطهي. تستمتع في أوقات فراغها بالطهي وممارسة التمارين والسفر والاستلقاء على الشاطئ.', NULL, '2024-06-13 10:00:51', '2024-06-13 10:52:16');

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

--
-- Table structure for table `amenities`
--

CREATE TABLE `amenities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `serial_number` 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;

--
-- Dumping data for table `amenities`
--

INSERT INTO `amenities` (`id`, `icon`, `status`, `serial_number`, `created_at`, `updated_at`) VALUES
(10, 'fas fa-parking', 1, 1, '2024-03-23 23:12:16', '2024-03-23 23:12:16'),
(11, 'fas fa-swimming-pool', 1, 2, '2024-06-10 06:21:30', '2024-06-10 06:21:30'),
(12, 'fas fa-dumbbell', 1, 3, '2024-06-10 06:22:06', '2024-06-10 06:22:06'),
(13, 'fas fa-shield-alt', 1, 4, '2024-06-10 06:22:57', '2024-06-10 06:22:57'),
(14, 'fas fa-wind', 1, 5, '2024-06-10 06:25:16', '2024-06-10 06:25:16'),
(15, 'fas fa-bolt', 1, 6, '2024-06-10 06:27:42', '2024-06-10 06:27:42'),
(16, 'fas fa-mosque', 1, 7, '2024-06-10 10:32:05', '2024-06-10 10:32:05');

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

--
-- Table structure for table `amenity_contents`
--

CREATE TABLE `amenity_contents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `amenity_id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) 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 `amenity_contents`
--

INSERT INTO `amenity_contents` (`id`, `amenity_id`, `language_id`, `name`, `created_at`, `updated_at`) VALUES
(20, 10, 20, 'Parking', '2024-03-23 23:12:16', '2024-03-23 23:12:16'),
(22, 11, 20, 'Swimming pool', '2024-06-10 06:21:30', '2024-06-10 06:21:30'),
(23, 11, 25, 'حمام السباحة', '2024-06-10 06:21:30', '2024-06-10 06:21:30'),
(24, 12, 20, 'Gym', '2024-06-10 06:22:06', '2024-06-10 06:22:06'),
(25, 12, 25, 'نادي رياضي', '2024-06-10 06:22:06', '2024-06-10 06:22:06'),
(26, 13, 20, 'Security', '2024-06-10 06:22:57', '2024-06-10 06:22:57'),
(27, 13, 25, 'حماية', '2024-06-10 06:22:57', '2024-06-10 06:22:57'),
(28, 14, 20, 'Air conditioning', '2024-06-10 06:25:16', '2024-06-10 06:25:16'),
(29, 14, 25, 'تكيف', '2024-06-10 06:25:16', '2024-06-10 06:25:16'),
(30, 15, 20, 'Backup Electricity', '2024-06-10 06:27:42', '2024-06-10 06:27:42'),
(31, 15, 25, 'الكهرباء الاحتياطية', '2024-06-10 06:27:42', '2024-06-10 06:27:42'),
(32, 16, 20, 'Mosque', '2024-06-10 10:32:05', '2024-06-10 10:32:05'),
(33, 16, 25, 'مسجد', '2024-06-10 10:32:05', '2024-06-10 10:32:05');

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

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

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) NOT NULL,
  `serial_number` mediumint(8) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `image`, `serial_number`, `created_at`, `updated_at`, `status`) VALUES
(21, '666aa4324c1ff.png', 1, '2023-08-19 00:54:31', '2024-06-13 07:48:02', 1),
(22, '666aa43ee1a5e.png', 2, '2023-08-19 00:58:19', '2024-06-13 07:48:14', 1),
(23, '666aa420dd756.png', 3, '2023-08-19 01:03:34', '2024-06-13 07:47:44', 1),
(24, '666aa411815d3.png', 4, '2023-08-19 01:05:56', '2024-06-13 07:47:29', 1),
(25, '666aa3ff8caec.png', 5, '2023-08-19 01:11:12', '2024-06-13 07:47:11', 1),
(26, '666aa3e7f1d36.png', 6, '2023-08-19 01:17:26', '2024-06-13 07:46:47', 1),
(28, '666aa4d0b281d.png', 7, '2024-06-13 07:50:40', '2024-06-13 07:51:16', 0);

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

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

CREATE TABLE `blog_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL,
  `serial_number` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `blog_categories`
--

INSERT INTO `blog_categories` (`id`, `language_id`, `name`, `slug`, `status`, `serial_number`, `created_at`, `updated_at`) VALUES
(42, 20, 'Buying Guides', 'buying-guides', 1, 1, '2023-08-19 00:45:17', '2023-08-19 00:45:17'),
(43, 20, 'Legal and Financial Advice', 'legal-and-financial-advice', 1, 2, '2023-08-19 00:45:38', '2024-06-13 06:48:28'),
(44, 20, 'Renting and Leasing', 'renting-and-leasing', 1, 3, '2023-08-19 00:45:51', '2024-06-13 06:48:04'),
(45, 20, 'Market Trends and Analysis', 'market-trends-and-analysis', 1, 4, '2023-08-19 00:46:06', '2024-06-13 06:47:27'),
(52, 25, 'اتجاهات السوق والتحليل', 'اتجاهات-السوق-والتحليل', 1, 4, '2024-06-14 09:16:56', '2024-06-14 09:16:56'),
(53, 25, 'التأجير والتأجير', 'التأجير-والتأجير', 1, 3, '2024-06-14 09:17:24', '2024-06-14 09:17:24'),
(54, 25, 'المشورة القانونية والمالية', 'المشورة-القانونية-والمالية', 1, 2, '2024-06-14 09:17:53', '2024-06-14 09:17:53'),
(55, 25, 'أدلة الشراء', 'أدلة-الشراء', 1, 1, '2024-06-14 09:18:19', '2024-06-14 09:18:19');

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

--
-- Table structure for table `blog_informations`
--

CREATE TABLE `blog_informations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `blog_category_id` bigint(20) UNSIGNED NOT NULL,
  `blog_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `author` varchar(255) NOT NULL,
  `content` blob NOT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `blog_informations`
--

INSERT INTO `blog_informations` (`id`, `language_id`, `blog_category_id`, `blog_id`, `title`, `slug`, `author`, `content`, `meta_keywords`, `meta_description`, `created_at`, `updated_at`) VALUES
(37, 20, 42, 21, 'Navigating Mortgage Options: Fixed vs. Adjustable Rates Explained', 'navigating-mortgage-options:-fixed-vs-adjustable-rates-explained', 'John Due', 0x[encoded data, 8852 characters], NULL, NULL, '2023-08-19 00:54:31', '2024-06-13 06:51:25'),
(39, 20, 42, 22, 'First-Time Homebuyers’ Guide: 10 Essential Tips for Success', 'first-time-homebuyers’-guide:-10-essential-tips-for-success', 'John Due', 0x[encoded data, 7962 characters], NULL, NULL, '2023-08-19 00:58:19', '2024-06-13 06:50:32'),
(41, 20, 43, 23, 'Legal Pitfalls to Avoid in Real Estate Transactions', 'legal-pitfalls-to-avoid-in-real-estate-transactions', 'Alexandra', 0x[encoded data, 6000 characters], NULL, NULL, '2023-08-19 01:03:34', '2024-06-13 06:53:20'),
(43, 20, 43, 24, 'How to Choose the Right Homeowners Insurance Policy', 'how-to-choose-the-right-homeowners-insurance-policy', 'Alison', 0x[encoded data, 5002 characters], NULL, NULL, '2023-08-19 01:05:56', '2024-06-13 06:52:31'),
(45, 20, 44, 25, 'How to Handle Tenant Issues: A Guide for Landlords', 'how-to-handle-tenant-issues:-a-guide-for-landlords', 'Andrea', 0x[encoded data, 7506 characters], NULL, NULL, '2023-08-19 01:11:12', '2024-06-13 06:54:22'),
(47, 20, 45, 26, 'How Economic Changes Are Impacting the Housing Market', 'how-economic-changes-are-impacting-the-housing-market', 'Kylie', 0x[encoded data, 7280 characters], 'Blog', NULL, '2023-08-19 01:17:26', '2024-06-13 07:41:47');
INSERT INTO `blog_informations` (`id`, `language_id`, `blog_category_id`, `blog_id`, `title`, `slug`, `author`, `content`, `meta_keywords`, `meta_description`, `created_at`, `updated_at`) VALUES
(49, 25, 52, 26, 'كيف تؤثر التغيرات الاقتصادية على سوق الإسكان', 'كيف-تؤثر-التغيرات-الاقتصادية-على-سوق-الإسكان', 'كايلي', 0x[encoded data, 10596 characters], NULL, NULL, '2024-05-08 04:45:37', '2024-06-14 09:19:47'),
(52, 25, 55, 22, '\"دليل مشتري المنازل لأول مرة: 10 نصائح أساسية للنجاح', 'دليل-مشتري-المنازل-لأول-مرة:-10-نصائح-أساسية-للنجاح', 'جون ديو', 0x[encoded data, 11256 characters], NULL, NULL, '2024-06-13 06:50:32', '2024-06-14 09:25:53'),
(53, 25, 55, 21, '\"التنقل بين خيارات الرهن العقاري: شرح الأسعار الثابتة مقابل المعدلات القابلة للتعديل', 'التنقل-بين-خيارات-الرهن-العقاري:-شرح-الأسعار-الثابتة-مقابل-المعدلات-القابلة-للتعديل', 'جون ديو', 0x[encoded data, 11256 characters], NULL, NULL, '2024-06-13 06:51:25', '2024-06-14 09:29:32'),
(54, 25, 54, 24, 'كيفية اختيار بوليصة التأمين المناسبة لأصحاب المنازل', 'كيفية-اختيار-بوليصة-التأمين-المناسبة-لأصحاب-المنازل', 'أليسون', 0x[encoded data, 7462 characters], NULL, NULL, '2024-06-13 06:52:31', '2024-06-14 09:22:51');
INSERT INTO `blog_informations` (`id`, `language_id`, `blog_category_id`, `blog_id`, `title`, `slug`, `author`, `content`, `meta_keywords`, `meta_description`, `created_at`, `updated_at`) VALUES
(55, 25, 54, 23, 'المخاطر القانونية التي يجب تجنبها في المعاملات العقارية', 'المخاطر-القانونية-التي-يجب-تجنبها-في-المعاملات-العقارية', 'الكسندرا', 0x[encoded data, 9308 characters], NULL, NULL, '2024-06-13 06:53:20', '2024-06-14 09:24:08'),
(56, 25, 53, 25, 'كيفية التعامل مع قضايا المستأجر: دليل لأصحاب العقارات', 'كيفية-التعامل-مع-قضايا-المستأجر:-دليل-لأصحاب-العقارات', 'أندريا', 0x[encoded data, 11318 characters], NULL, NULL, '2024-06-13 06:54:22', '2024-06-14 09:22:07'),
(57, 20, 44, 28, 'Understanding Lease Agreements: What Every Tenant Should Know', 'understanding-lease-agreements:-what-every-tenant-should-know', 'Farhan', 0x[encoded data, 5168 characters], NULL, NULL, '2024-06-13 07:50:40', '2024-06-13 07:50:40'),
(58, 25, 53, 28, 'فهم اتفاقيات الإيجار: ما يجب أن يعرفه كل مستأجر', 'فهم-اتفاقيات-الإيجار:-ما-يجب-أن-يعرفه-كل-مستأجر', 'فرحان', 0x[encoded data, 6338 characters], NULL, NULL, '2024-06-13 07:50:40', '2024-06-14 09:30:33');

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

--
-- Table structure for table `blog_sections`
--

CREATE TABLE `blog_sections` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `blog_sections`
--

INSERT INTO `blog_sections` (`id`, `language_id`, `subtitle`, `title`, `created_at`, `updated_at`) VALUES
(5, 20, 'Blogs', 'Read our latest blogs', '2023-08-19 00:44:01', '2023-08-28 03:06:18'),
(6, 21, 'المدونات', 'اقرأ أحدث مدوناتنا', '2023-08-28 03:06:59', '2023-08-28 03:06:59');

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

--
-- Table structure for table `brand_sections`
--

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

--
-- Dumping data for table `brand_sections`
--

INSERT INTO `brand_sections` (`id`, `image`, `created_at`, `updated_at`, `url`) VALUES
(7, '68e960417cda0.png', '2025-10-10 11:20:56', '2025-10-10 18:36:33', NULL),
(8, '68e961b0996fc.png', '2025-10-10 11:21:02', '2025-10-10 18:42:40', NULL),
(9, '68e961aa0d665.png', '2025-10-10 11:21:07', '2025-10-10 18:42:34', NULL),
(10, '68e961a4090e1.png', '2025-10-10 11:21:13', '2025-10-10 18:42:28', NULL),
(11, '68e9619c9fff7.png', '2025-10-10 11:21:18', '2025-10-10 18:42:20', NULL),
(12, '68e96193c3303.png', '2025-10-10 11:21:25', '2025-10-10 18:42:11', NULL),
(13, '68e9618af0b94.png', '2025-10-10 11:21:30', '2025-10-10 18:42:02', NULL),
(14, '68e96181efc8f.png', '2025-10-10 11:21:38', '2025-10-10 18:41:53', NULL),
(15, '68e9617955217.png', '2025-10-10 11:21:46', '2025-10-10 18:41:45', NULL);

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

--
-- Table structure for table `call_to_action_sections`
--

CREATE TABLE `call_to_action_sections` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `video_url` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `call_to_action_sections`
--

INSERT INTO `call_to_action_sections` (`id`, `language_id`, `subtitle`, `title`, `text`, `video_url`, `created_at`, `updated_at`) VALUES
(4, 20, 'How To Submit Your Property Request', 'Video Tutorial', 'Curabitur non nulla sit amet nisl tempus convallis lectus. Nulla porttitor accumsan tincidunt.', 'https://www.youtube.com/watch?v=mrpiPK8_up0', '2023-08-28 02:47:29', '2024-06-14 08:09:22'),
(6, 25, 'كيفية تقديم طلب الممتلكات الخاصة بك', 'فيديو تعليمي', 'في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي', 'https://www.youtube.com/watch?v=mrpiPK8_up0', '2024-06-14 08:09:49', '2024-06-14 08:09:49');

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

--
-- Table structure for table `category_sections`
--

CREATE TABLE `category_sections` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `category_sections`
--

INSERT INTO `category_sections` (`id`, `language_id`, `title`, `subtitle`, `created_at`, `updated_at`) VALUES
(3, '20', 'Categories', NULL, '2023-08-19 00:11:48', '2025-10-10 11:08:16'),
(5, '25', 'فئات', 'استكشاف الفئات', '2024-03-27 00:10:33', '2024-06-14 07:19:55');

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

--
-- Table structure for table `city_sections`
--

CREATE TABLE `city_sections` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) 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 `city_sections`
--

INSERT INTO `city_sections` (`id`, `language_id`, `title`, `subtitle`, `created_at`, `updated_at`) VALUES
(1, 20, 'Our Cities', 'Explore The City', '2023-12-11 06:00:02', '2024-05-14 03:57:39'),
(2, 25, 'مدننا', 'استكشاف المدينة', '2024-06-14 07:35:12', '2024-06-14 07:35:12');

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

--
-- Table structure for table `conversations`
--

CREATE TABLE `conversations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `type` tinyint(4) DEFAULT NULL COMMENT '1=user, 2=admin, 3=vendor',
  `support_ticket_id` int(11) DEFAULT NULL,
  `reply` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `cookie_alerts`
--

CREATE TABLE `cookie_alerts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `cookie_alert_status` tinyint(3) UNSIGNED NOT NULL,
  `cookie_alert_btn_text` varchar(255) NOT NULL,
  `cookie_alert_text` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cookie_alerts`
--

INSERT INTO `cookie_alerts` (`id`, `language_id`, `cookie_alert_status`, `cookie_alert_btn_text`, `cookie_alert_text`, `created_at`, `updated_at`) VALUES
(3, 20, 1, 'I Agree', 'We use cookies to give you the best online experience.\r\nBy continuing to browse the site you are agreeing to our use of cookies.', '2023-08-29 02:35:44', '2023-08-29 02:37:13');

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

--
-- Table structure for table `counter_informations`
--

CREATE TABLE `counter_informations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `icon` varchar(255) NOT NULL,
  `amount` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `counter_informations`
--

INSERT INTO `counter_informations` (`id`, `language_id`, `icon`, `amount`, `title`, `created_at`, `updated_at`) VALUES
(7, 20, 'fal fa-users', 100, 'There are many variations of Lorem Ipsum available, but the majority.', '2023-08-19 00:40:34', '2023-12-08 23:24:27'),
(8, 20, 'fal fa-handshake', 250, 'There are many variations of Lorem Ipsum available, but the majority.', '2023-08-19 00:41:05', '2023-12-08 23:24:19'),
(9, 20, 'fal fa-city', 30, 'There are many variations of Lorem Ipsum available, but the majority.', '2023-08-19 00:41:28', '2023-12-08 23:24:13'),
(10, 20, 'fal fa-hand-holding-usd', 14, 'There are many variations of Lorem Ipsum available, but the majority.', '2023-08-19 00:41:52', '2023-12-08 23:23:43'),
(15, 25, 'fal fa-hand-holding-usd', 14, 'هناك العديد من الأشكال المتوفرة لنص لوريم إيبسوم، لكن الأغلبية هي.', '2024-06-14 07:22:20', '2024-06-14 07:22:20'),
(16, 25, 'fal fa-city', 30, 'هناك العديد من الأشكال المتوفرة لنص لوريم إيبسوم، لكن الأغلبية هي.', '2024-06-14 07:22:57', '2024-06-14 07:22:57'),
(17, 25, 'fal fa-handshake', 250, 'هناك العديد من الأشكال المتوفرة لنص لوريم إيبسوم، لكن الأغلبية هي.', '2024-06-14 07:23:15', '2024-06-14 07:23:15'),
(18, 25, 'fal fa-users', 100, 'هناك العديد من الأشكال المتوفرة لنص لوريم إيبسوم، لكن الأغلبية هي.', '2024-06-14 07:23:31', '2024-06-14 07:23:31');

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

--
-- Table structure for table `counter_sections`
--

CREATE TABLE `counter_sections` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `counter_sections`
--

INSERT INTO `counter_sections` (`id`, `language_id`, `title`, `subtitle`, `created_at`, `updated_at`) VALUES
(3, 20, 'Why Did You Choose Our Property Listing Services?', 'If you’re in the market for a new Property, you have probably done your fair share of research to Property services. You know what kind of Property you want, what features you need? We are here to help you at any time.', '2023-08-19 00:38:24', '2023-08-19 03:44:23');

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

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

CREATE TABLE `faqs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `question` varchar(255) NOT NULL,
  `answer` text NOT NULL,
  `serial_number` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `faqs` (`id`, `language_id`, `question`, `answer`, `serial_number`, `created_at`, `updated_at`) VALUES
(16, 20, 'How do I list my property on your website?', 'To list your property, simply create an account on our website, provide accurate vehicle information, upload high-quality photos, and set an appropriate price.', 1, '2023-08-19 02:29:36', '2024-06-14 06:29:46'),
(17, 20, 'Can I list multiple properties under one account?', 'Yes, you can list multiple properties and projects using a single account. Just follow the same listing process for each property and project.', 2, '2023-08-19 02:29:51', '2024-06-14 06:32:40'),
(18, 20, 'Is there a fee for listing my property on your platform?', 'We offer both free and premium listing options. Basic listings are free, while premium options may include enhanced visibility and additional features for a fee.', 3, '2023-08-19 02:30:06', '2024-06-14 06:33:13'),
(19, 20, 'What type of information should I include in my property listing?', 'It\'s important to provide detailed information such as the amenities, features, facilities, price, and area in sqft. The more details you provide, the better your chances of attracting potential buyers.', 4, '2023-08-19 02:30:22', '2024-06-14 06:35:28'),
(20, 20, 'How long will my property listing be active?', 'The duration of your property listing depends on the type of listing you choose. Free listings usually have a standard duration, while premium listings may have extended visibility periods.', 5, '2023-08-19 02:30:37', '2024-06-14 06:36:44'),
(21, 20, 'Can I edit my listing after it\'s live?', 'Yes, you can edit your listing at any time. Log in to your account, access your listing, and make the necessary changes to the details, price, or images.', 6, '2023-08-19 02:30:55', '2023-08-19 02:30:55'),
(22, 20, 'How do I communicate with potential buyers?', 'Interested buyers can contact you through the contact information you provide in your listing. We recommend using our secure messaging system to maintain privacy and security during negotiations.', 7, '2023-08-19 02:31:11', '2023-08-19 02:31:11'),
(23, 20, 'What happens if my property sells or rents through another platform?', 'If your property sells or rents through another platform, it\'s important to promptly remove or mark your listing as sold on our website to avoid any confusion for potential buyers.', 8, '2023-08-19 02:31:29', '2024-06-14 06:39:40'),
(24, 20, 'Are there any tips for taking appealing Property photos?', 'Absolutely! Clear, well-lit photos taken from various angles can significantly enhance your listing. Include shots of the interior, exterior, engine, and any special features.', 9, '2023-08-19 02:31:45', '2023-08-19 02:31:45'),
(25, 20, 'What safety measures are in place to prevent fraud?', 'We take fraud prevention seriously. We use various security measures and recommend dealing locally, verifying buyer information, and being cautious of unusual payment requestss.', 10, '2023-08-19 02:32:01', '2024-06-08 11:45:42'),
(37, 25, 'كيف أقوم بإدراج الممتلكات الخاصة بي على موقع الويب الخاص بك؟', 'لإدراج الممتلكات الخاصة بك، ما عليك سوى إنشاء حساب على موقعنا الإلكتروني، وتقديم معلومات دقيقة عن السيارة، وتحميل صور عالية الجودة، وتحديد السعر المناسب.', 1, '2024-06-14 06:30:39', '2024-06-14 06:30:39'),
(38, 25, 'هل يمكنني إدراج عقارات متعددة تحت حساب واحد؟', 'نعم، يمكنك إدراج عقارات ومشاريع متعددة باستخدام حساب واحد. ما عليك سوى اتباع نفس عملية الإدراج لكل عقار ومشروع.', 2, '2024-06-14 06:32:14', '2024-06-14 06:32:14'),
(39, 25, 'هل هناك رسوم لإدراج عقاري على منصتكم؟', 'نحن نقدم خيارات الإدراج المجانية والمميزة. القوائم الأساسية مجانية، بينما قد تتضمن الخيارات المميزة رؤية محسنة وميزات إضافية مقابل رسوم.', 3, '2024-06-14 06:33:28', '2024-06-14 06:33:28'),
(40, 25, 'ما نوع المعلومات التي يجب أن أدرجها في قائمة الممتلكات الخاصة بي؟', 'من المهم تقديم معلومات مفصلة مثل وسائل الراحة والميزات والمرافق والسعر والمساحة بالقدم المربع. كلما زادت التفاصيل التي تقدمها، زادت فرصك في جذب المشترين المحتملين.', 4, '2024-06-14 06:35:49', '2024-06-14 06:35:49'),
(41, 25, 'إلى متى ستكون قائمة الممتلكات الخاصة بي نشطة؟', 'تعتمد مدة قائمة الممتلكات الخاصة بك على نوع القائمة التي تختارها. عادةً ما تكون للبيانات المجانية مدة قياسية، في حين أن القوائم المميزة قد تكون لها فترات ظهور ممتدة.', 5, '2024-06-14 06:37:04', '2024-06-14 06:37:04'),
(42, 25, 'هل يمكنني تعديل قائمتي بعد نشرها؟', 'نعم، يمكنك تعديل قائمتك في أي وقت. قم بتسجيل الدخول إلى حسابك، والوصول إلى قائمتك، وإجراء التغييرات اللازمة على التفاصيل أو السعر أو الصور.', 6, '2024-06-14 06:37:57', '2024-06-14 06:37:57'),
(43, 25, 'كيف أتواصل مع المشترين المحتملين؟', 'يمكن للمشترين المهتمين الاتصال بك من خلال معلومات الاتصال التي تقدمها في قائمتك. نوصي باستخدام نظام المراسلة الآمن الخاص بنا للحفاظ على الخصوصية والأمان أثناء المفاوضات.', 7, '2024-06-14 06:38:48', '2024-06-14 06:38:48');

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

--
-- Table structure for table `featured_pricings`
--

CREATE TABLE `featured_pricings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `price` decimal(8,2) NOT NULL,
  `number_of_days` int(11) NOT NULL,
  `status` tinyint(4) 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 `featured_pricings`
--

INSERT INTO `featured_pricings` (`id`, `price`, `number_of_days`, `status`, `created_at`, `updated_at`) VALUES
(4, 50.00, 10, 1, '2024-03-25 02:21:14', '2024-06-11 05:48:33'),
(5, 80.00, 20, 1, '2024-06-11 05:48:02', '2024-06-11 05:48:02'),
(6, 100.00, 25, 1, '2024-06-11 05:48:16', '2024-06-11 05:48:16'),
(7, 120.00, 30, 1, '2024-06-11 05:48:50', '2024-06-11 05:55:09');

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

--
-- Table structure for table `featured_properties`
--

CREATE TABLE `featured_properties` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `featured_pricing_id` bigint(20) UNSIGNED NOT NULL,
  `property_id` bigint(20) UNSIGNED NOT NULL,
  `vendor_id` bigint(20) UNSIGNED NOT NULL,
  `transaction_id` varchar(255) DEFAULT NULL,
  `transaction_details` text DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `gateway_type` varchar(255) DEFAULT NULL,
  `payment_status` varchar(255) DEFAULT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `number_of_days` int(11) NOT NULL,
  `amount` decimal(8,2) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = pending, 1 = approved, 2= rejected',
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime 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 `featured_properties`
--

INSERT INTO `featured_properties` (`id`, `featured_pricing_id`, `property_id`, `vendor_id`, `transaction_id`, `transaction_details`, `payment_method`, `gateway_type`, `payment_status`, `attachment`, `number_of_days`, `amount`, `status`, `start_date`, `end_date`, `created_at`, `updated_at`) VALUES
(115, 4, 73, 0, 'a8904417', 'from admin', 'from admin', 'paypal', 'complete', NULL, 565, 50.00, 1, '2024-06-11 11:49:38', '2026-12-28 11:49:38', '2024-06-11 05:49:38', '2024-06-11 05:49:38'),
(116, 6, 74, 0, '7366c1a4', 'from admin', 'from admin', 'instamojo', 'complete', NULL, 420, 100.00, 1, '2024-06-11 11:49:52', '2025-08-05 11:49:52', '2024-06-11 05:49:52', '2024-06-11 05:49:52'),
(117, 6, 78, 0, 'aa36bc85', 'from admin', 'from admin', 'Citibank', 'complete', NULL, 500, 100.00, 1, '2024-06-11 11:55:31', '2026-08-24 11:55:31', '2024-06-11 05:55:31', '2024-06-11 05:55:31'),
(118, 6, 76, 0, '233951a4', 'from admin', 'from admin', 'instamojo', 'complete', NULL, 650, 100.00, 1, '2024-06-11 11:56:05', '2026-03-23 11:56:05', '2024-06-11 05:56:05', '2024-06-11 05:56:05'),
(119, 7, 68, 0, 'f5ec1abf', 'from admin', 'from admin', 'Bank of America', 'complete', NULL, 485, 120.00, 1, '2024-06-11 11:56:14', '2026-10-09 11:56:14', '2024-06-11 05:56:14', '2024-06-11 05:56:14');

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

--
-- Table structure for table `feature_sections`
--

CREATE TABLE `feature_sections` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) 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 `feature_sections`
--

INSERT INTO `feature_sections` (`id`, `language_id`, `title`, `created_at`, `updated_at`) VALUES
(3, 20, 'Off Plan', '2023-08-19 03:00:57', '2025-12-26 08:25:59'),
(5, 25, 'خصائص مميزة', '2024-06-14 07:35:34', '2024-06-14 07:35:34');

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

--
-- Table structure for table `footer_contents`
--

CREATE TABLE `footer_contents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `about_company` text DEFAULT NULL,
  `copyright_text` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `footer_contents`
--

INSERT INTO `footer_contents` (`id`, `language_id`, `about_company`, `copyright_text`, `created_at`, `updated_at`) VALUES
(5, 20, 'Welcome to Paradox Real Estate, where your property journey begins with a unique blend of professionalism, personalization, and passion.', '<p>Copyright ©2025. All Rights Reserved.</p>', '2023-08-19 23:40:53', '2025-10-10 11:42:31'),
(7, 25, 'في Estaty نقدم مجموعة واسعة من السيارات المستعملة عالية الجودة لتلبية احتياجات القيادة الخاصة بك وميزانيتك. مع سنوات من الخبرة في صناعة السيارات.', '<p>حقوق الطبع والنشر ©٢٠٢٣. كل الحقوق محفوظة.</p>', '2024-03-26 23:12:42', '2024-03-26 23:12:42');

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

--
-- Table structure for table `guests`
--

CREATE TABLE `guests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `endpoint` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `hero_statics`
--

CREATE TABLE `hero_statics` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `text` varchar(255) 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 `hero_statics`
--

INSERT INTO `hero_statics` (`id`, `language_id`, `title`, `text`, `created_at`, `updated_at`) VALUES
(1, 20, 'We’re Best Real Estate Agency', 'We are a leargest real estate agency for buying and selling your property with 100% confidently.', '2023-12-09 03:31:58', '2023-12-09 03:31:58'),
(2, 21, 'asdf', 'asdf', '2023-12-09 03:32:34', '2023-12-09 03:32:34'),
(3, 25, 'نحن أفضل وكالة عقارية', 'نحن أكبر وكالة عقارية لبيع وشراء الممتلكات الخاصة بك بثقة 100٪.', '2024-03-27 00:09:42', '2024-03-27 00:09:42');

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

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

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `code` char(255) NOT NULL,
  `direction` tinyint(4) NOT NULL,
  `is_default` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `languages` (`id`, `name`, `code`, `direction`, `is_default`, `created_at`, `updated_at`) VALUES
(20, 'English', 'en', 0, 1, '2023-08-17 03:19:12', '2023-08-17 03:19:17'),
(25, 'عربي', 'ar', 1, 0, '2024-03-26 02:23:59', '2024-03-26 02:27:48');

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

--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `vendor_id` bigint(20) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `charge` decimal(8,2) UNSIGNED DEFAULT 0.00,
  `serial_number` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` (`id`, `language_id`, `vendor_id`, `name`, `charge`, `serial_number`, `created_at`, `updated_at`) VALUES
(8, 8, NULL, 'Washington, California', 100.00, 1, '2022-01-31 03:06:15', '2022-01-31 03:06:15'),
(9, 8, NULL, 'Washington, D.C.', 150.00, 2, '2022-01-31 03:06:56', '2022-01-31 03:06:56'),
(10, 8, NULL, 'Georgetown, California', 200.00, 3, '2022-01-31 03:07:46', '2022-01-31 03:07:46'),
(11, 9, NULL, 'واشنطن ، كاليفورنيا', 100.00, 1, '2022-03-06 00:48:03', '2022-03-06 00:48:03'),
(12, 9, NULL, 'واشنطن العاصمة.', 150.00, 2, '2022-03-06 00:48:41', '2022-03-06 00:48:41'),
(13, 9, NULL, 'جورج تاون ، كاليفورنيا', 200.00, 3, '2022-03-06 00:49:02', '2022-03-06 00:49:25'),
(19, 8, 7, 'Shah Amanat International Airport', 11.00, 1, '2022-10-19 04:15:19', '2022-10-19 04:15:19'),
(21, 8, 7, 'Perfect Money', 0.00, 1, '2022-10-30 00:33:19', '2022-10-30 00:33:19');

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

--
-- Table structure for table `mail_templates`
--

CREATE TABLE `mail_templates` (
  `id` int(11) NOT NULL,
  `mail_type` varchar(255) NOT NULL,
  `mail_subject` varchar(255) NOT NULL,
  `mail_body` blob DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `mail_templates`
--

INSERT INTO `mail_templates` (`id`, `mail_type`, `mail_subject`, `mail_body`) VALUES
(1, 'verify_email', 'Verify Your Email Address', 0x3c703e44656172203c7374726f6e673e7b757365726e616d657d3c2f7374726f6e673e2c3c2f703e0d0a3c703e5765206a757374206e65656420746f2076657269667920796f757220656d61696c2061646472657373206265666f726520796f752063616e2061636365737320746f20796f75722064617368626f6172642e3c2f703e0d0a3c703e56657269667920796f757220656d61696c20616464726573732c207b766572696669636174696f6e5f6c696e6b7d2e3c2f703e0d0a3c703e5468616e6b20796f752e3c62723e7b776562736974655f7469746c657d3c2f703e),
(2, 'reset_password', 'Recover Password of Your Account', 0x3c703e4869207b637573746f6d65725f6e616d657d2c3c2f703e3c703e576520686176652072656365697665642061207265717565737420746f20726573657420796f75722070617373776f72642e20496620796f7520646964206e6f74206d616b652074686520726571756573742c2069676e6f7265207468697320656d61696c2e204f74686572776973652c20796f752063616e20726573657420796f75722070617373776f7264207573696e67207468652062656c6f77206c696e6b2e3c2f703e3c703e7b70617373776f72645f72657365745f6c696e6b7d3c2f703e3c703e5468616e6b732c3c6272202f3e7b776562736974655f7469746c657d3c2f703e),
(5, 'package_purchase', 'You have purchased a package successfully', 0x3c703e4869207b757365726e616d657d2c3c6272202f3e3c6272202f3e54686973206973206120636f6e6669726d6174696f6e206d61696c2066726f6d2075733c2f703e0d0a3c703e3c7374726f6e673e3c7370616e207374796c653d22666f6e742d73697a653a313870783b223e4d656d6265727368697020496e666f726d6174696f6e3a3c2f7370616e3e3c2f7374726f6e673e3c6272202f3e3c7374726f6e673e5061636b616765205469746c653a3c2f7374726f6e673e207b7061636b6167655f7469746c657d3c6272202f3e3c7374726f6e673e5061636b6167652050726963653a3c2f7374726f6e673e207b7061636b6167655f70726963657d3c2f703e0d0a3c703e3c7374726f6e673e446973636f756e743a3c2f7374726f6e673e207b646973636f756e747d3c2f703e0d0a3c703e3c7370616e207374796c653d22666f6e742d7765696768743a3630303b223e546f74616c3a3c2f7370616e3ec2a07b746f74616c7d3c6272202f3e3c7374726f6e673e41637469766174696f6e20446174653a3c2f7374726f6e673e207b61637469766174696f6e5f646174657d3c6272202f3e3c7374726f6e673e45787069726520446174653a3c2f7374726f6e673e207b6578706972655f646174657d3c2f703e0d0a3c703ec2a03c2f703e0d0a3c703e5765206861766520617474616368656420616e20696e766f69636520776974682074686973206d61696c2e3c6272202f3e5468616e6b20796f7520666f7220796f75722070757263686173652e3c2f703e0d0a3c703e3c6272202f3e4265737420526567617264732c3c6272202f3e7b776562736974655f7469746c657d2e3c2f703e),
(8, 'membership_expiry_reminder', 'Your membership will be expired soon', 0x4869207b757365726e616d657d2c3c6272202f3e3c6272202f3e0d0a0d0a596f7572206d656d626572736869702077696c6c206265206578706972656420736f6f6e2e3c6272202f3e0d0a596f7572206d656d626572736869702069732076616c69642074696c6c203c7374726f6e673e7b6c6173745f6461795f6f665f6d656d626572736869707d3c2f7374726f6e673e3c6272202f3e0d0a506c6561736520636c69636b2068657265202d207b6c6f67696e5f6c696e6b7d20746f206c6f6720696e746f207468652064617368626f61726420746f2070757263686173652061206e6577207061636b616765202f20657874656e64207468652063757272656e74207061636b61676520746f20657874656e6420796f7572206d656d626572736869702e3c6272202f3e3c6272202f3e0d0a0d0a4265737420526567617264732c3c6272202f3e0d0a7b776562736974655f7469746c657d2e),
(9, 'membership_expired', 'Your membership is expired', 0x4869207b757365726e616d657d2c3c62723e3c62723e0d0a0d0a596f7572206d656d6265727368697020697320657870697265642e3c62723e0d0a506c6561736520636c69636b2068657265202d207b6c6f67696e5f6c696e6b7d20746f206c6f6720696e746f207468652064617368626f61726420746f2070757263686173652061206e6577207061636b616765202f20657874656e64207468652063757272656e74207061636b61676520746f20636f6e74696e756520746865206d656d626572736869702e3c62723e3c62723e0d0a0d0a4265737420526567617264732c3c62723e0d0a7b776562736974655f7469746c657d2e),
(10, 'package_purchase_membership_accepted', 'Your payment for purchase a package is accepted', 0x3c703e4869207b757365726e616d657d2c3c6272202f3e3c6272202f3e54686973206973206120636f6e6669726d6174696f6e206d61696c2066726f6d2075732e3c6272202f3e596f7572207061796d656e7420686173206265656e2061636365707465642e3c6272202f3e3c7374726f6e673e5061636b616765205469746c653a3c2f7374726f6e673e207b7061636b6167655f7469746c657d3c6272202f3e3c7374726f6e673e5061636b6167652050726963653a3c2f7374726f6e673e207b7061636b6167655f70726963657d3c6272202f3e3c7374726f6e673e41637469766174696f6e20446174653a3c2f7374726f6e673e207b61637469766174696f6e5f646174657d3c6272202f3e3c7374726f6e673e45787069726520446174653a3c2f7374726f6e673e207b6578706972655f646174657d3c2f703e0d0a3c703e4265737420526567617264732c3c6272202f3e7b776562736974655f7469746c657d2e3c2f703e),
(12, 'package_purchase_membership_rejected', 'Your payment for purchase a package is rejected', 0x3c703e4869207b757365726e616d657d2c3c6272202f3e3c6272202f3e57652061726520736f72727920746f20696e666f726d20796f75207468617420796f7572207061796d656e7420686173206265656e2072656a65637465643c6272202f3e3c7374726f6e673e5061636b616765205469746c653a3c2f7374726f6e673e207b7061636b6167655f7469746c657d3c6272202f3e3c7374726f6e673e5061636b6167652050726963653a3c2f7374726f6e673e207b7061636b6167655f70726963657d3c6272202f3e4265737420526567617264732c3c6272202f3e7b776562736974655f7469746c657d2e3c2f703e),
(14, 'admin_changed_current_package', 'Admin has changed your current package', 0x3c703e4869207b757365726e616d657d2c3c6272202f3e3c6272202f3e0d0a0d0a41646d696e20686173206368616e67656420796f75722063757272656e74207061636b616765203c623e287b7265706c616365645f7061636b6167657d293c2f623e3c2f703e0d0a3c703e3c623e4e6577205061636b61676520496e666f726d6174696f6e3a3c2f623e3c2f703e0d0a3c703e0d0a3c7374726f6e673e5061636b6167653a3c2f7374726f6e673e207b7061636b6167655f7469746c657d3c6272202f3e0d0a3c7374726f6e673e5061636b6167652050726963653a3c2f7374726f6e673e207b7061636b6167655f70726963657d3c6272202f3e0d0a3c7374726f6e673e41637469766174696f6e20446174653a3c2f7374726f6e673e207b61637469766174696f6e5f646174657d3c6272202f3e0d0a3c7374726f6e673e45787069726520446174653a3c2f7374726f6e673e207b6578706972655f646174657d3c2f703e3c703e3c6272202f3e3c2f703e3c703e5765206861766520617474616368656420616e20696e766f69636520776974682074686973206d61696c2e3c6272202f3e0d0a5468616e6b20796f7520666f7220796f75722070757263686173652e3c2f703e3c703e3c6272202f3e0d0a0d0a4265737420526567617264732c3c6272202f3e0d0a7b776562736974655f7469746c657d2e3c6272202f3e3c2f703e),
(15, 'admin_added_current_package', 'Admin has added current package for you', 0x3c703e4869207b757365726e616d657d2c3c6272202f3e3c6272202f3e0d0a0d0a41646d696e206861732061646465642063757272656e74207061636b61676520666f7220796f753c2f703e3c703e3c623e3c7370616e207374796c653d22666f6e742d73697a653a313870783b223e43757272656e74204d656d6265727368697020496e666f726d6174696f6e3a3c2f7370616e3e3c2f623e3c6272202f3e0d0a3c7374726f6e673e5061636b616765205469746c653a3c2f7374726f6e673e207b7061636b6167655f7469746c657d3c6272202f3e0d0a3c7374726f6e673e5061636b6167652050726963653a3c2f7374726f6e673e207b7061636b6167655f70726963657d3c6272202f3e0d0a3c7374726f6e673e41637469766174696f6e20446174653a3c2f7374726f6e673e207b61637469766174696f6e5f646174657d3c6272202f3e0d0a3c7374726f6e673e45787069726520446174653a3c2f7374726f6e673e207b6578706972655f646174657d3c2f703e3c703e3c6272202f3e3c2f703e3c703e5765206861766520617474616368656420616e20696e766f69636520776974682074686973206d61696c2e3c6272202f3e0d0a5468616e6b20796f7520666f7220796f75722070757263686173652e3c2f703e3c703e3c6272202f3e0d0a0d0a4265737420526567617264732c3c6272202f3e0d0a7b776562736974655f7469746c657d2e3c6272202f3e3c2f703e),
(16, 'admin_changed_next_package', 'Admin has changed your next package', 0x3c703e4869207b757365726e616d657d2c3c6272202f3e3c6272202f3e0d0a0d0a41646d696e20686173206368616e67656420796f7572206e657874207061636b616765203c623e287b7265706c616365645f7061636b6167657d293c2f623e3c2f703e3c703e3c623e3c7370616e207374796c653d22666f6e742d73697a653a313870783b223e4e657874204d656d6265727368697020496e666f726d6174696f6e3a3c2f7370616e3e3c2f623e3c6272202f3e0d0a3c7374726f6e673e5061636b616765205469746c653a3c2f7374726f6e673e207b7061636b6167655f7469746c657d3c6272202f3e0d0a3c7374726f6e673e5061636b6167652050726963653a3c2f7374726f6e673e207b7061636b6167655f70726963657d3c6272202f3e0d0a3c7374726f6e673e41637469766174696f6e20446174653a3c2f7374726f6e673e207b61637469766174696f6e5f646174657d3c6272202f3e0d0a3c7374726f6e673e45787069726520446174653a3c2f7374726f6e673e207b6578706972655f646174657d3c2f703e3c703e3c6272202f3e3c2f703e3c703e5765206861766520617474616368656420616e20696e766f69636520776974682074686973206d61696c2e3c6272202f3e0d0a5468616e6b20796f7520666f7220796f75722070757263686173652e3c2f703e3c703e3c6272202f3e0d0a0d0a4265737420526567617264732c3c6272202f3e0d0a7b776562736974655f7469746c657d2e3c6272202f3e3c2f703e),
(17, 'admin_added_next_package', 'Admin has added next package for you', 0x3c703e4869207b757365726e616d657d2c3c6272202f3e3c6272202f3e0d0a0d0a41646d696e20686173206164646564206e657874207061636b61676520666f7220796f753c2f703e3c703e3c623e3c7370616e207374796c653d22666f6e742d73697a653a313870783b223e4e657874204d656d6265727368697020496e666f726d6174696f6e3a3c2f7370616e3e3c2f623e3c6272202f3e0d0a3c7374726f6e673e5061636b616765205469746c653a3c2f7374726f6e673e207b7061636b6167655f7469746c657d3c6272202f3e0d0a3c7374726f6e673e5061636b6167652050726963653a3c2f7374726f6e673e207b7061636b6167655f70726963657d3c6272202f3e0d0a3c7374726f6e673e41637469766174696f6e20446174653a3c2f7374726f6e673e207b61637469766174696f6e5f646174657d3c6272202f3e0d0a3c7374726f6e673e45787069726520446174653a3c2f7374726f6e673e207b6578706972655f646174657d3c2f703e3c703e3c6272202f3e3c2f703e3c703e5765206861766520617474616368656420616e20696e766f69636520776974682074686973206d61696c2e3c6272202f3e0d0a5468616e6b20796f7520666f7220796f75722070757263686173652e3c2f703e3c703e3c6272202f3e0d0a0d0a4265737420526567617264732c3c6272202f3e0d0a7b776562736974655f7469746c657d2e3c6272202f3e3c2f703e),
(18, 'admin_removed_current_package', 'Admin has removed current package for you', 0x3c703e4869207b757365726e616d657d2c3c6272202f3e3c6272202f3e0d0a0d0a41646d696e206861732072656d6f7665642063757272656e74207061636b616765202d203c7374726f6e673e7b72656d6f7665645f7061636b6167655f7469746c657d3c2f7374726f6e673e3c62723e0d0a0d0a4265737420526567617264732c3c6272202f3e0d0a7b776562736974655f7469746c657d2e3c6272202f3e),
(19, 'admin_removed_next_package', 'Admin has removed next package for you', 0x3c703e4869207b757365726e616d657d2c3c6272202f3e3c6272202f3e0d0a0d0a41646d696e206861732072656d6f766564206e657874207061636b616765202d203c7374726f6e673e7b72656d6f7665645f7061636b6167655f7469746c657d3c2f7374726f6e673e3c62723e0d0a0d0a4265737420526567617264732c3c6272202f3e0d0a7b776562736974655f7469746c657d2e3c6272202f3e),
(26, 'featured_property', 'Your Property is now featured', 0x[encoded data, 4898 characters]),
(27, 'payment_accepted_for_featured_property_offline_gateway', 'Your payment for featured property is accepted', 0x3c703e4869207b757365726e616d657d2c3c6272202f3e3c6272202f3e54686973206973206120636f6e6669726d6174696f6e206d61696c2066726f6d2075732e3c6272202f3e596f7572207061796d656e7420686173206265656e2061636365707465642026616d703b207768656e20796f75722070726f70657274792069732066656174757265642c2077652077696c6c206e6f7469667920796f752e3c2f703e0d0a3c703e3c6272202f3e3c7374726f6e673e50726f7065727479205469746c653a3c2f7374726f6e673e207b70726f70657274795f7469746c657d3c6272202f3e3c7374726f6e673e46656174757265642050726963653a3c2f7374726f6e673e207b66656174757265645f70726963657d3c6272202f3e3c7374726f6e673e4e756d626572204f6620466561747572656420446179733a3c2f7374726f6e673e207b6e756d6265725f6f665f646179737d3c2f703e0d0a3c703e3c7374726f6e673e5061796d656e74204d6574686f643a3c2f7374726f6e673e207b7061796d656e745f6d6574686f647d3c2f703e0d0a3c703e4265737420526567617264732c3c6272202f3e7b776562736974655f7469746c657d2e3c2f703e),
(28, 'payment_rejected_for_feature_property_offline_gateway', 'Your payment for featured property is rejected', 0x3c703e4869207b757365726e616d657d2c3c6272202f3e3c6272202f3e57652061726520736f72727920746f20696e666f726d20796f75207468617420796f7572207061796d656e7420686173206265656e2072656a65637465642e3c2f703e0d0a3c703e3c7374726f6e673e50726f7065727479205469746c653a3c2f7374726f6e673e207b70726f70657274795f7469746c657d3c6272202f3e3c7374726f6e673e46656174757265642050726963653a3c2f7374726f6e673e207b66656174757265645f70726963657d3c2f703e0d0a3c703e3c7374726f6e673e4e756d626572204f6620466561747572656420446179733a3c2f7374726f6e673e207b6e756d6265725f6f665f646179737d3c2f703e0d0a3c703e3c7374726f6e673e5061796d656e74204d6574686f643a3c2f7374726f6e673e207b7061796d656e745f6d6574686f647d3c2f703e0d0a3c703ec2a03c2f703e0d0a3c703e3c6272202f3e4265737420526567617264732c3c6272202f3e7b776562736974655f7469746c657d2e3c2f703e),
(29, 'registered_agent', 'An agent account is registered', 0x3c703e4869207b757365726e616d657d2c3c6272202f3e3c6272202f3e54686973206973206120636f6e6669726d6174696f6e206d61696c2066726f6d2075732e3c6272202f3e5375636365737366756c6c79206372656174656420616e206167656e74206163636f756e7420666f7220796f753c6272202f3e706c6561736520766973697420746865207765627369746520616e64206c6f6720696e20746f20796f7572206163636f756e742e3c2f703e0d0a3c703e3c7374726f6e673e4c6f67696e2055726c3a203c2f7374726f6e673e7b6c6f67696e5f75726c7d3c6272202f3e3c7374726f6e673e557365726e616d653a3c2f7374726f6e673e207b757365726e616d657d3c6272202f3e3c7374726f6e673e50617373776f72643a3c2f7374726f6e673e207b70617373776f72647d3c6272202f3e3c6272202f3e3c2f703e0d0a3c703e4265737420526567617264732c3c6272202f3e7b776562736974655f7469746c657d2e3c2f703e),
(30, 'property_featured_request_rejected', 'Your Property featured request has been rejected', 0x[encoded data, 4568 characters]);

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

--
-- Table structure for table `memberships`
--

CREATE TABLE `memberships` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `price` double DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `currency_symbol` varchar(255) DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `transaction_id` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `is_trial` tinyint(4) NOT NULL DEFAULT 0,
  `trial_days` int(11) NOT NULL DEFAULT 0,
  `receipt` longtext DEFAULT NULL,
  `transaction_details` longtext DEFAULT NULL,
  `settings` longtext DEFAULT NULL,
  `package_id` bigint(20) DEFAULT NULL,
  `vendor_id` bigint(20) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `expire_date` date DEFAULT NULL,
  `modified` tinyint(4) DEFAULT NULL COMMENT '1 - modified by Admin, 0 - not modified by Admin',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `memberships`
--

INSERT INTO `memberships` (`id`, `price`, `currency`, `currency_symbol`, `payment_method`, `transaction_id`, `status`, `is_trial`, `trial_days`, `receipt`, `transaction_details`, `settings`, `package_id`, `vendor_id`, `start_date`, `expire_date`, `modified`, `created_at`, `updated_at`) VALUES
(27, 399.99, 'USD', '$', 'PayPal', 'cba679ff', 1, 0, 0, NULL, '{\n    \"id\": \"PAYID-MZUSMZI6CX16053R12502630\",\n    \"intent\": \"sale\",\n    \"state\": \"approved\",\n    \"cart\": \"1PS17182931761911\",\n    \"payer\": {\n        \"payment_method\": \"paypal\",\n        \"status\": \"VERIFIED\",\n        \"payer_info\": {\n            \"email\": \"megasoft.envato@example.com\",\n            \"first_name\": \"Samiul Alim\",\n            \"last_name\": \"Pratik\",\n            \"payer_id\": \"8C5NYJ7EZ7QSS\",\n            \"shipping_address\": {\n                \"recipient_name\": \"Samiul Alim Pratik\",\n                \"line1\": \"1 Main St\",\n                \"city\": \"San Jose\",\n                \"state\": \"CA\",\n                \"postal_code\": \"95131\",\n                \"country_code\": \"US\"\n            },\n            \"country_code\": \"US\"\n        }\n    },\n    \"transactions\": [\n        {\n            \"amount\": {\n                \"total\": \"399.99\",\n                \"currency\": \"USD\",\n                \"details\": {\n                    \"subtotal\": \"399.99\",\n                    \"shipping\": \"0.00\",\n                    \"insurance\": \"0.00\",\n                    \"handling_fee\": \"0.00\",\n                    \"shipping_discount\": \"0.00\",\n                    \"discount\": \"0.00\"\n                }\n            },\n            \"payee\": {\n                \"merchant_id\": \"BKNWZYE3MAUNU\",\n                \"email\": \"megasoft.envato-facilitator@example.com\"\n            },\n            \"description\": \"You are purchasing a package Via Paypal\",\n            \"item_list\": {\n                \"items\": [\n                    {\n                        \"name\": \"You are purchasing a package\",\n                        \"price\": \"399.99\",\n                        \"currency\": \"USD\",\n                        \"tax\": \"0.00\",\n                        \"quantity\": 1,\n                        \"image_url\": \"\"\n                    }\n                ],\n                \"shipping_address\": {\n                    \"recipient_name\": \"Samiul Alim Pratik\",\n                    \"line1\": \"1 Main St\",\n                    \"city\": \"San Jose\",\n                    \"state\": \"CA\",\n                    \"postal_code\": \"95131\",\n                    \"country_code\": \"US\"\n                }\n            },\n            \"related_resources\": [\n                {\n                    \"sale\": {\n                        \"id\": \"2W098769V69880940\",\n                        \"state\": \"completed\",\n                        \"amount\": {\n                            \"total\": \"399.99\",\n                            \"currency\": \"USD\",\n                            \"details\": {\n                                \"subtotal\": \"399.99\",\n                                \"shipping\": \"0.00\",\n                                \"insurance\": \"0.00\",\n                                \"handling_fee\": \"0.00\",\n                                \"shipping_discount\": \"0.00\",\n                                \"discount\": \"0.00\"\n                            }\n                        },\n                        \"payment_mode\": \"INSTANT_TRANSFER\",\n                        \"protection_eligibility\": \"ELIGIBLE\",\n                        \"protection_eligibility_type\": \"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE\",\n                        \"transaction_fee\": {\n                            \"value\": \"14.45\",\n                            \"currency\": \"USD\"\n                        },\n                        \"parent_payment\": \"PAYID-MZUSMZI6CX16053R12502630\",\n                        \"create_time\": \"2024-06-12T04:39:23Z\",\n                        \"update_time\": \"2024-06-12T04:39:23Z\",\n                        \"links\": [\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/sale/2W098769V69880940\",\n                                \"rel\": \"self\",\n                                \"method\": \"GET\"\n                            },\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/sale/2W098769V69880940/refund\",\n                                \"rel\": \"refund\",\n                                \"method\": \"POST\"\n                            },\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/payment/PAYID-MZUSMZI6CX16053R12502630\",\n                                \"rel\": \"parent_payment\",\n                                \"method\": \"GET\"\n                            }\n                        ]\n                    }\n                }\n            ]\n        }\n    ],\n    \"redirect_urls\": {\n        \"return_url\": \"http://realstate.test/vendor/membership/paypal/success?paymentId=PAYID-MZUSMZI6CX16053R12502630\",\n        \"cancel_url\": \"http://realstate.test/vendor/membership/paypal/cancel\"\n    },\n    \"create_time\": \"2024-06-12T04:39:00Z\",\n    \"update_time\": \"2024-06-12T04:39:23Z\",\n    \"links\": [\n        {\n            \"href\": \"https://api.sandbox.paypal.com/v1/payments/payment/PAYID-MZUSMZI6CX16053R12502630\",\n            \"rel\": \"self\",\n            \"method\": \"GET\"\n        }\n    ],\n    \"failed_transactions\": []\n}', '{\"id\":2,\"uniqid\":12345,\"favicon\":\"65127f2a23da3.png\",\"logo\":\"66669210543fd.png\",\"logo_two\":\"64ed7071b1844.png\",\"website_title\":\"Real Estate\",\"email_address\":\"realestate@example.com\",\"contact_number\":\"+8801865879521\",\"address\":\"13th Street 47 W ,New York, USA\",\"theme_version\":2,\"base_currency_symbol\":\"$\",\"base_currency_symbol_position\":\"left\",\"base_currency_text\":\"USD\",\"base_currency_text_position\":\"left\",\"base_currency_rate\":\"1.00\",\"primary_color\":\"F57F4B\",\"secondary_color\":\"255056\",\"smtp_status\":1,\"smtp_host\":\"smtp.gmail.com\",\"smtp_port\":587,\"encryption\":\"TLS\",\"smtp_username\":\"ranaahmed269205@example.com\",\"smtp_password\":\"uvan rtvs rzmk zqnp\",\"from_mail\":\"ranaahmed269205@example.com\",\"from_name\":\"Binary Brain\",\"to_mail\":\"estay@example.com\",\"breadcrumb\":\"6511175715121.jpg\",\"disqus_status\":0,\"disqus_short_name\":null,\"google_recaptcha_status\":0,\"google_recaptcha_site_key\":\"dfzgasdfg\",\"google_recaptcha_secret_key\":\"asdfgavsdfgvsd\",\"whatsapp_status\":0,\"whatsapp_number\":\"01868362878\",\"whatsapp_header_title\":\"Hi, there!\",\"whatsapp_popup_status\":1,\"whatsapp_popup_message\":\"If you have any issues, let us know.\",\"maintenance_img\":\"1632725312.png\",\"maintenance_status\":0,\"maintenance_msg\":\"We are upgrading our site. We will come back soon. \\r\\nPlease stay with us.\\r\\nThank you.\",\"bypass_token\":null,\"footer_logo\":\"66668fd8afd03.png\",\"footer_background_image\":\"6572f1d3ead31.png\",\"admin_theme_version\":\"light\",\"notification_image\":\"619b7d5e5e9df.png\",\"counter_section_image\":\"64e46e661cff4.png\",\"call_to_action_section_image\":\"6576af4f8ac2d.jpg\",\"testimonial_section_image\":\"6572e7c01c264.png\",\"category_section_background\":\"63c92601cb853.jpg\",\"google_adsense_publisher_id\":null,\"property_country_status\":1,\"property_state_status\":1,\"guest_checkout_status\":0,\"facebook_login_status\":1,\"facebook_app_id\":\"377957354064048\",\"facebook_app_secret\":\"c7ea8a036916500375fbd9a799b95c50\",\"google_login_status\":1,\"google_client_id\":\"951854288029-q77ihbshmmsm875po2na1ljvlejm7aji08.apps.googleusercontent.com\",\"google_client_secret\":\"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_zM\",\"tawkto_status\":0,\"tawkto_direct_chat_link\":\"https:\\/\\/tawk.to\\/chat\\/623891851ffac05b1d7fac3b\\/1fumfgsmj\",\"vendor_admin_approval\":1,\"vendor_email_verification\":1,\"admin_approval_notice\":\"Your account is deactive or pending now please contact with admin.\",\"expiration_reminder\":3,\"timezone\":\"Asia\\/Dhaka\",\"hero_section_video_url\":\"https:\\/\\/www.youtube.com\\/watch?v=9l6RywtDlKA\",\"hero_static_img\":\"6574372e0ad77.jpg\",\"contact_title\":\"Get Connected\",\"contact_subtile\":\"How Can We Help You?\",\"contact_details\":\"Lorem ipsum, dolor sit amet consectetur adipisicing elit. Maiores pariatur a ea similique quod dicta ipsa vel quidem repellendus, beatae nulla veniam, quaerat veritatis architecto. Aliquid doloremque nesciunt nobis, debitis, quas veniam.\\r\\n\\r\\nLorem ipsum, dolor sit amet consectetur adipisicing elit. Maiores a ea similique quod dicta ipsa vel quidem repellendus, beatae nulla veniam, quaerat.\",\"latitude\":\"23.8763296233045\",\"longitude\":\"90.47600702834376\",\"preloader_status\":1,\"preloader\":\"666170d789a3c.png\",\"about_section_video_link\":\"https:\\/\\/www.youtube.com\\/watch?v=F26FINYrof0\",\"about_section_image1\":\"657557b3c229e.jpg\",\"about_section_image2\":\"657557b3c2a25.jpg\",\"why_choose_us_section_img1\":\"65757ae71b9f0.jpg\",\"why_choose_us_section_img2\":\"65757ae71c078.jpg\",\"why_choose_us_section_video_link\":\"https:\\/\\/www.youtube.com\\/watch?v=ITUG13kdkQI\",\"subscribe_section_img\":\"6577e0ff3ab05.jpg\",\"updated_at\":\"2024-05-19T07:07:40.000000Z\",\"property_approval_status\":1,\"project_approval_status\":1}', 24, 35, '2024-06-12', '9999-12-31', NULL, '2024-06-12 04:39:24', '2024-06-12 04:39:24'),
(28, 399.99, 'USD', '$', 'PayPal', 'f359072f', 1, 0, 0, NULL, '{\n    \"id\": \"PAYID-MZUSW2Q8H470962M79893516\",\n    \"intent\": \"sale\",\n    \"state\": \"approved\",\n    \"cart\": \"0PU64647K75579407\",\n    \"payer\": {\n        \"payment_method\": \"paypal\",\n        \"status\": \"VERIFIED\",\n        \"payer_info\": {\n            \"email\": \"megasoft.envato@example.com\",\n            \"first_name\": \"Samiul Alim\",\n            \"last_name\": \"Pratik\",\n            \"payer_id\": \"8C5NYJ7EZ7QSS\",\n            \"shipping_address\": {\n                \"recipient_name\": \"Samiul Alim Pratik\",\n                \"line1\": \"1 Main St\",\n                \"city\": \"San Jose\",\n                \"state\": \"CA\",\n                \"postal_code\": \"95131\",\n                \"country_code\": \"US\"\n            },\n            \"country_code\": \"US\"\n        }\n    },\n    \"transactions\": [\n        {\n            \"amount\": {\n                \"total\": \"399.99\",\n                \"currency\": \"USD\",\n                \"details\": {\n                    \"subtotal\": \"399.99\",\n                    \"shipping\": \"0.00\",\n                    \"insurance\": \"0.00\",\n                    \"handling_fee\": \"0.00\",\n                    \"shipping_discount\": \"0.00\",\n                    \"discount\": \"0.00\"\n                }\n            },\n            \"payee\": {\n                \"merchant_id\": \"BKNWZYE3MAUNU\",\n                \"email\": \"megasoft.envato-facilitator@example.com\"\n            },\n            \"description\": \"You are purchasing a package Via Paypal\",\n            \"item_list\": {\n                \"items\": [\n                    {\n                        \"name\": \"You are purchasing a package\",\n                        \"price\": \"399.99\",\n                        \"currency\": \"USD\",\n                        \"tax\": \"0.00\",\n                        \"quantity\": 1,\n                        \"image_url\": \"\"\n                    }\n                ],\n                \"shipping_address\": {\n                    \"recipient_name\": \"Samiul Alim Pratik\",\n                    \"line1\": \"1 Main St\",\n                    \"city\": \"San Jose\",\n                    \"state\": \"CA\",\n                    \"postal_code\": \"95131\",\n                    \"country_code\": \"US\"\n                }\n            },\n            \"related_resources\": [\n                {\n                    \"sale\": {\n                        \"id\": \"0BN13476U9576604C\",\n                        \"state\": \"completed\",\n                        \"amount\": {\n                            \"total\": \"399.99\",\n                            \"currency\": \"USD\",\n                            \"details\": {\n                                \"subtotal\": \"399.99\",\n                                \"shipping\": \"0.00\",\n                                \"insurance\": \"0.00\",\n                                \"handling_fee\": \"0.00\",\n                                \"shipping_discount\": \"0.00\",\n                                \"discount\": \"0.00\"\n                            }\n                        },\n                        \"payment_mode\": \"INSTANT_TRANSFER\",\n                        \"protection_eligibility\": \"ELIGIBLE\",\n                        \"protection_eligibility_type\": \"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE\",\n                        \"transaction_fee\": {\n                            \"value\": \"14.45\",\n                            \"currency\": \"USD\"\n                        },\n                        \"parent_payment\": \"PAYID-MZUSW2Q8H470962M79893516\",\n                        \"create_time\": \"2024-06-12T05:00:46Z\",\n                        \"update_time\": \"2024-06-12T05:00:46Z\",\n                        \"links\": [\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/sale/0BN13476U9576604C\",\n                                \"rel\": \"self\",\n                                \"method\": \"GET\"\n                            },\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/sale/0BN13476U9576604C/refund\",\n                                \"rel\": \"refund\",\n                                \"method\": \"POST\"\n                            },\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/payment/PAYID-MZUSW2Q8H470962M79893516\",\n                                \"rel\": \"parent_payment\",\n                                \"method\": \"GET\"\n                            }\n                        ]\n                    }\n                }\n            ]\n        }\n    ],\n    \"redirect_urls\": {\n        \"return_url\": \"http://realstate.test/vendor/membership/paypal/success?paymentId=PAYID-MZUSW2Q8H470962M79893516\",\n        \"cancel_url\": \"http://realstate.test/vendor/membership/paypal/cancel\"\n    },\n    \"create_time\": \"2024-06-12T05:00:26Z\",\n    \"update_time\": \"2024-06-12T05:00:46Z\",\n    \"links\": [\n        {\n            \"href\": \"https://api.sandbox.paypal.com/v1/payments/payment/PAYID-MZUSW2Q8H470962M79893516\",\n            \"rel\": \"self\",\n            \"method\": \"GET\"\n        }\n    ],\n    \"failed_transactions\": []\n}', '{\"id\":2,\"uniqid\":12345,\"favicon\":\"65127f2a23da3.png\",\"logo\":\"66669210543fd.png\",\"logo_two\":\"64ed7071b1844.png\",\"website_title\":\"Real Estate\",\"email_address\":\"realestate@example.com\",\"contact_number\":\"+8801865879521\",\"address\":\"13th Street 47 W ,New York, USA\",\"theme_version\":2,\"base_currency_symbol\":\"$\",\"base_currency_symbol_position\":\"left\",\"base_currency_text\":\"USD\",\"base_currency_text_position\":\"left\",\"base_currency_rate\":\"1.00\",\"primary_color\":\"F57F4B\",\"secondary_color\":\"255056\",\"smtp_status\":1,\"smtp_host\":\"smtp.gmail.com\",\"smtp_port\":587,\"encryption\":\"TLS\",\"smtp_username\":\"ranaahmed269205@example.com\",\"smtp_password\":\"uvan rtvs rzmk zqnp\",\"from_mail\":\"ranaahmed@example.com\",\"from_name\":\"Binary Brain\",\"to_mail\":\"formmail@example.com\",\"breadcrumb\":\"6511175715121.jpg\",\"disqus_status\":0,\"disqus_short_name\":null,\"google_recaptcha_status\":0,\"google_recaptcha_site_key\":\"dfzgasdfg\",\"google_recaptcha_secret_key\":\"asdfgavsdfgvsd\",\"whatsapp_status\":0,\"whatsapp_number\":\"01868362878\",\"whatsapp_header_title\":\"Hi, there!\",\"whatsapp_popup_status\":1,\"whatsapp_popup_message\":\"If you have any issues, let us know.\",\"maintenance_img\":\"1632725312.png\",\"maintenance_status\":0,\"maintenance_msg\":\"We are upgrading our site. We will come back soon. \\r\\nPlease stay with us.\\r\\nThank you.\",\"bypass_token\":null,\"footer_logo\":\"66668fd8afd03.png\",\"footer_background_image\":\"6572f1d3ead31.png\",\"admin_theme_version\":\"light\",\"notification_image\":\"619b7d5e5e9df.png\",\"counter_section_image\":\"64e46e661cff4.png\",\"call_to_action_section_image\":\"6576af4f8ac2d.jpg\",\"testimonial_section_image\":\"6572e7c01c264.png\",\"category_section_background\":\"63c92601cb853.jpg\",\"google_adsense_publisher_id\":null,\"property_country_status\":1,\"property_state_status\":1,\"guest_checkout_status\":0,\"facebook_login_status\":1,\"facebook_app_id\":\"377957354064048\",\"facebook_app_secret\":\"c7ea8a036916500375fbd9a799b95c50\",\"google_login_status\":1,\"google_client_id\":\"951854288029-q77ihbshmmsm875po2na1ljvlejm7aji08.apps.googleusercontent.com\",\"google_client_secret\":\"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_zM\",\"tawkto_status\":0,\"tawkto_direct_chat_link\":\"https:\\/\\/tawk.to\\/chat\\/623891851ffac05b1d7fac3b\\/1fumfgsmj\",\"vendor_admin_approval\":1,\"vendor_email_verification\":1,\"admin_approval_notice\":\"Your account is deactive or pending now please contact with admin.\",\"expiration_reminder\":3,\"timezone\":\"Asia\\/Dhaka\",\"hero_section_video_url\":\"https:\\/\\/www.youtube.com\\/watch?v=9l6RywtDlKA\",\"hero_static_img\":\"6574372e0ad77.jpg\",\"contact_title\":\"Get Connected\",\"contact_subtile\":\"How Can We Help You?\",\"contact_details\":\"Lorem ipsum, dolor sit amet consectetur adipisicing elit. Maiores pariatur a ea similique quod dicta ipsa vel quidem repellendus, beatae nulla veniam, quaerat veritatis architecto. Aliquid doloremque nesciunt nobis, debitis, quas veniam.\\r\\n\\r\\nLorem ipsum, dolor sit amet consectetur adipisicing elit. Maiores a ea similique quod dicta ipsa vel quidem repellendus, beatae nulla veniam, quaerat.\",\"latitude\":\"23.8763296233045\",\"longitude\":\"90.47600702834376\",\"preloader_status\":1,\"preloader\":\"666170d789a3c.png\",\"about_section_video_link\":\"https:\\/\\/www.youtube.com\\/watch?v=F26FINYrof0\",\"about_section_image1\":\"657557b3c229e.jpg\",\"about_section_image2\":\"657557b3c2a25.jpg\",\"why_choose_us_section_img1\":\"65757ae71b9f0.jpg\",\"why_choose_us_section_img2\":\"65757ae71c078.jpg\",\"why_choose_us_section_video_link\":\"https:\\/\\/www.youtube.com\\/watch?v=ITUG13kdkQI\",\"subscribe_section_img\":\"6577e0ff3ab05.jpg\",\"updated_at\":\"2024-05-19T07:07:40.000000Z\",\"property_approval_status\":1,\"project_approval_status\":1}', 24, 36, '2024-06-12', '9999-12-31', NULL, '2024-06-12 05:00:47', '2024-06-12 05:00:47'),
(29, 399.99, 'USD', '$', 'PayPal', '56a78860', 1, 0, 0, NULL, '{\n    \"id\": \"PAYID-MZUSYGY6F992891B6669073T\",\n    \"intent\": \"sale\",\n    \"state\": \"approved\",\n    \"cart\": \"23S97572S3181814S\",\n    \"payer\": {\n        \"payment_method\": \"paypal\",\n        \"status\": \"VERIFIED\",\n        \"payer_info\": {\n            \"email\": \"megasoft.envato@example.com\",\n            \"first_name\": \"Samiul Alim\",\n            \"last_name\": \"Pratik\",\n            \"payer_id\": \"8C5NYJ7EZ7QSS\",\n            \"shipping_address\": {\n                \"recipient_name\": \"Samiul Alim Pratik\",\n                \"line1\": \"1 Main St\",\n                \"city\": \"San Jose\",\n                \"state\": \"CA\",\n                \"postal_code\": \"95131\",\n                \"country_code\": \"US\"\n            },\n            \"country_code\": \"US\"\n        }\n    },\n    \"transactions\": [\n        {\n            \"amount\": {\n                \"total\": \"399.99\",\n                \"currency\": \"USD\",\n                \"details\": {\n                    \"subtotal\": \"399.99\",\n                    \"shipping\": \"0.00\",\n                    \"insurance\": \"0.00\",\n                    \"handling_fee\": \"0.00\",\n                    \"shipping_discount\": \"0.00\",\n                    \"discount\": \"0.00\"\n                }\n            },\n            \"payee\": {\n                \"merchant_id\": \"BKNWZYE3MAUNU\",\n                \"email\": \"megasoft.envato-facilitator@example.com\"\n            },\n            \"description\": \"You are purchasing a package Via Paypal\",\n            \"item_list\": {\n                \"items\": [\n                    {\n                        \"name\": \"You are purchasing a package\",\n                        \"price\": \"399.99\",\n                        \"currency\": \"USD\",\n                        \"tax\": \"0.00\",\n                        \"quantity\": 1,\n                        \"image_url\": \"\"\n                    }\n                ],\n                \"shipping_address\": {\n                    \"recipient_name\": \"Samiul Alim Pratik\",\n                    \"line1\": \"1 Main St\",\n                    \"city\": \"San Jose\",\n                    \"state\": \"CA\",\n                    \"postal_code\": \"95131\",\n                    \"country_code\": \"US\"\n                }\n            },\n            \"related_resources\": [\n                {\n                    \"sale\": {\n                        \"id\": \"38M96968D5697045A\",\n                        \"state\": \"completed\",\n                        \"amount\": {\n                            \"total\": \"399.99\",\n                            \"currency\": \"USD\",\n                            \"details\": {\n                                \"subtotal\": \"399.99\",\n                                \"shipping\": \"0.00\",\n                                \"insurance\": \"0.00\",\n                                \"handling_fee\": \"0.00\",\n                                \"shipping_discount\": \"0.00\",\n                                \"discount\": \"0.00\"\n                            }\n                        },\n                        \"payment_mode\": \"INSTANT_TRANSFER\",\n                        \"protection_eligibility\": \"ELIGIBLE\",\n                        \"protection_eligibility_type\": \"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE\",\n                        \"transaction_fee\": {\n                            \"value\": \"14.45\",\n                            \"currency\": \"USD\"\n                        },\n                        \"parent_payment\": \"PAYID-MZUSYGY6F992891B6669073T\",\n                        \"create_time\": \"2024-06-12T05:03:34Z\",\n                        \"update_time\": \"2024-06-12T05:03:34Z\",\n                        \"links\": [\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/sale/38M96968D5697045A\",\n                                \"rel\": \"self\",\n                                \"method\": \"GET\"\n                            },\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/sale/38M96968D5697045A/refund\",\n                                \"rel\": \"refund\",\n                                \"method\": \"POST\"\n                            },\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/payment/PAYID-MZUSYGY6F992891B6669073T\",\n                                \"rel\": \"parent_payment\",\n                                \"method\": \"GET\"\n                            }\n                        ]\n                    }\n                }\n            ]\n        }\n    ],\n    \"redirect_urls\": {\n        \"return_url\": \"http://realstate.test/vendor/membership/paypal/success?paymentId=PAYID-MZUSYGY6F992891B6669073T\",\n        \"cancel_url\": \"http://realstate.test/vendor/membership/paypal/cancel\"\n    },\n    \"create_time\": \"2024-06-12T05:03:23Z\",\n    \"update_time\": \"2024-06-12T05:03:34Z\",\n    \"links\": [\n        {\n            \"href\": \"https://api.sandbox.paypal.com/v1/payments/payment/PAYID-MZUSYGY6F992891B6669073T\",\n            \"rel\": \"self\",\n            \"method\": \"GET\"\n        }\n    ],\n    \"failed_transactions\": []\n}', '{\"id\":2,\"uniqid\":12345,\"favicon\":\"65127f2a23da3.png\",\"logo\":\"66669210543fd.png\",\"logo_two\":\"64ed7071b1844.png\",\"website_title\":\"Real Estate\",\"email_address\":\"realestate@example.com\",\"contact_number\":\"+8801865879521\",\"address\":\"13th Street 47 W ,New York, USA\",\"theme_version\":2,\"base_currency_symbol\":\"$\",\"base_currency_symbol_position\":\"left\",\"base_currency_text\":\"USD\",\"base_currency_text_position\":\"left\",\"base_currency_rate\":\"1.00\",\"primary_color\":\"F57F4B\",\"secondary_color\":\"255056\",\"smtp_status\":1,\"smtp_host\":\"smtp.gmail.com\",\"smtp_port\":587,\"encryption\":\"TLS\",\"smtp_username\":\"ranaahmed269205@example.com\",\"smtp_password\":\"uvan rtvs rzmk zqnp\",\"from_mail\":\"ranaahmed269205@example.com\",\"from_name\":\"Binary Brain\",\"to_mail\":\"example@example.com\",\"breadcrumb\":\"6511175715121.jpg\",\"disqus_status\":0,\"disqus_short_name\":null,\"google_recaptcha_status\":0,\"google_recaptcha_site_key\":\"dfzgasdfg\",\"google_recaptcha_secret_key\":\"asdfgavsdfgvsd\",\"whatsapp_status\":0,\"whatsapp_number\":\"01868362878\",\"whatsapp_header_title\":\"Hi, there!\",\"whatsapp_popup_status\":1,\"whatsapp_popup_message\":\"If you have any issues, let us know.\",\"maintenance_img\":\"1632725312.png\",\"maintenance_status\":0,\"maintenance_msg\":\"We are upgrading our site. We will come back soon. \\r\\nPlease stay with us.\\r\\nThank you.\",\"bypass_token\":null,\"footer_logo\":\"66668fd8afd03.png\",\"footer_background_image\":\"6572f1d3ead31.png\",\"admin_theme_version\":\"light\",\"notification_image\":\"619b7d5e5e9df.png\",\"counter_section_image\":\"64e46e661cff4.png\",\"call_to_action_section_image\":\"6576af4f8ac2d.jpg\",\"testimonial_section_image\":\"6572e7c01c264.png\",\"category_section_background\":\"63c92601cb853.jpg\",\"google_adsense_publisher_id\":null,\"property_country_status\":1,\"property_state_status\":1,\"guest_checkout_status\":0,\"facebook_login_status\":1,\"facebook_app_id\":\"377957354064048\",\"facebook_app_secret\":\"c7ea8a036916500375fbd9a799b95c50\",\"google_login_status\":1,\"google_client_id\":\"951854288029-q77ihbshmmsm875po2na1ljvlejm7aji08.apps.googleusercontent.com\",\"google_client_secret\":\"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_zM\",\"tawkto_status\":0,\"tawkto_direct_chat_link\":\"https:\\/\\/tawk.to\\/chat\\/623891851ffac05b1d7fac3b\\/1fumfgsmj\",\"vendor_admin_approval\":1,\"vendor_email_verification\":1,\"admin_approval_notice\":\"Your account is deactive or pending now please contact with admin.\",\"expiration_reminder\":3,\"timezone\":\"Asia\\/Dhaka\",\"hero_section_video_url\":\"https:\\/\\/www.youtube.com\\/watch?v=9l6RywtDlKA\",\"hero_static_img\":\"6574372e0ad77.jpg\",\"contact_title\":\"Get Connected\",\"contact_subtile\":\"How Can We Help You?\",\"contact_details\":\"Lorem ipsum, dolor sit amet consectetur adipisicing elit. Maiores pariatur a ea similique quod dicta ipsa vel quidem repellendus, beatae nulla veniam, quaerat veritatis architecto. Aliquid doloremque nesciunt nobis, debitis, quas veniam.\\r\\n\\r\\nLorem ipsum, dolor sit amet consectetur adipisicing elit. Maiores a ea similique quod dicta ipsa vel quidem repellendus, beatae nulla veniam, quaerat.\",\"latitude\":\"23.8763296233045\",\"longitude\":\"90.47600702834376\",\"preloader_status\":1,\"preloader\":\"666170d789a3c.png\",\"about_section_video_link\":\"https:\\/\\/www.youtube.com\\/watch?v=F26FINYrof0\",\"about_section_image1\":\"657557b3c229e.jpg\",\"about_section_image2\":\"657557b3c2a25.jpg\",\"why_choose_us_section_img1\":\"65757ae71b9f0.jpg\",\"why_choose_us_section_img2\":\"65757ae71c078.jpg\",\"why_choose_us_section_video_link\":\"https:\\/\\/www.youtube.com\\/watch?v=ITUG13kdkQI\",\"subscribe_section_img\":\"6577e0ff3ab05.jpg\",\"updated_at\":\"2024-05-19T07:07:40.000000Z\",\"property_approval_status\":1,\"project_approval_status\":1}', 24, 37, '2024-06-12', '9999-12-31', NULL, '2024-06-12 05:03:35', '2024-06-12 05:03:35'),
(30, 399.99, 'USD', '$', 'PayPal', 'da1cbff7', 1, 0, 0, NULL, '{\n    \"id\": \"PAYID-MZUSZGY9GX91766XW367611W\",\n    \"intent\": \"sale\",\n    \"state\": \"approved\",\n    \"cart\": \"8M61108263672300S\",\n    \"payer\": {\n        \"payment_method\": \"paypal\",\n        \"status\": \"VERIFIED\",\n        \"payer_info\": {\n            \"email\": \"megasoft.envato@example.com\",\n            \"first_name\": \"Samiul Alim\",\n            \"last_name\": \"Pratik\",\n            \"payer_id\": \"8C5NYJ7EZ7QSS\",\n            \"shipping_address\": {\n                \"recipient_name\": \"Samiul Alim Pratik\",\n                \"line1\": \"1 Main St\",\n                \"city\": \"San Jose\",\n                \"state\": \"CA\",\n                \"postal_code\": \"95131\",\n                \"country_code\": \"US\"\n            },\n            \"country_code\": \"US\"\n        }\n    },\n    \"transactions\": [\n        {\n            \"amount\": {\n                \"total\": \"399.99\",\n                \"currency\": \"USD\",\n                \"details\": {\n                    \"subtotal\": \"399.99\",\n                    \"shipping\": \"0.00\",\n                    \"insurance\": \"0.00\",\n                    \"handling_fee\": \"0.00\",\n                    \"shipping_discount\": \"0.00\",\n                    \"discount\": \"0.00\"\n                }\n            },\n            \"payee\": {\n                \"merchant_id\": \"BKNWZYE3MAUNU\",\n                \"email\": \"megasoft.envato-facilitator@example.com\"\n            },\n            \"description\": \"You are purchasing a package Via Paypal\",\n            \"item_list\": {\n                \"items\": [\n                    {\n                        \"name\": \"You are purchasing a package\",\n                        \"price\": \"399.99\",\n                        \"currency\": \"USD\",\n                        \"tax\": \"0.00\",\n                        \"quantity\": 1,\n                        \"image_url\": \"\"\n                    }\n                ],\n                \"shipping_address\": {\n                    \"recipient_name\": \"Samiul Alim Pratik\",\n                    \"line1\": \"1 Main St\",\n                    \"city\": \"San Jose\",\n                    \"state\": \"CA\",\n                    \"postal_code\": \"95131\",\n                    \"country_code\": \"US\"\n                }\n            },\n            \"related_resources\": [\n                {\n                    \"sale\": {\n                        \"id\": \"0DL021456Y440794B\",\n                        \"state\": \"completed\",\n                        \"amount\": {\n                            \"total\": \"399.99\",\n                            \"currency\": \"USD\",\n                            \"details\": {\n                                \"subtotal\": \"399.99\",\n                                \"shipping\": \"0.00\",\n                                \"insurance\": \"0.00\",\n                                \"handling_fee\": \"0.00\",\n                                \"shipping_discount\": \"0.00\",\n                                \"discount\": \"0.00\"\n                            }\n                        },\n                        \"payment_mode\": \"INSTANT_TRANSFER\",\n                        \"protection_eligibility\": \"ELIGIBLE\",\n                        \"protection_eligibility_type\": \"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE\",\n                        \"transaction_fee\": {\n                            \"value\": \"14.45\",\n                            \"currency\": \"USD\"\n                        },\n                        \"parent_payment\": \"PAYID-MZUSZGY9GX91766XW367611W\",\n                        \"create_time\": \"2024-06-12T05:05:44Z\",\n                        \"update_time\": \"2024-06-12T05:05:44Z\",\n                        \"links\": [\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/sale/0DL021456Y440794B\",\n                                \"rel\": \"self\",\n                                \"method\": \"GET\"\n                            },\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/sale/0DL021456Y440794B/refund\",\n                                \"rel\": \"refund\",\n                                \"method\": \"POST\"\n                            },\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/payment/PAYID-MZUSZGY9GX91766XW367611W\",\n                                \"rel\": \"parent_payment\",\n                                \"method\": \"GET\"\n                            }\n                        ]\n                    }\n                }\n            ]\n        }\n    ],\n    \"redirect_urls\": {\n        \"return_url\": \"http://realstate.test/vendor/membership/paypal/success?paymentId=PAYID-MZUSZGY9GX91766XW367611W\",\n        \"cancel_url\": \"http://realstate.test/vendor/membership/paypal/cancel\"\n    },\n    \"create_time\": \"2024-06-12T05:05:31Z\",\n    \"update_time\": \"2024-06-12T05:05:44Z\",\n    \"links\": [\n        {\n            \"href\": \"https://api.sandbox.paypal.com/v1/payments/payment/PAYID-MZUSZGY9GX91766XW367611W\",\n            \"rel\": \"self\",\n            \"method\": \"GET\"\n        }\n    ],\n    \"failed_transactions\": []\n}', '{\"id\":2,\"uniqid\":12345,\"favicon\":\"65127f2a23da3.png\",\"logo\":\"66669210543fd.png\",\"logo_two\":\"64ed7071b1844.png\",\"website_title\":\"Real Estate\",\"email_address\":\"realestate@example.com\",\"contact_number\":\"+8801865879521\",\"address\":\"13th Street 47 W ,New York, USA\",\"theme_version\":2,\"base_currency_symbol\":\"$\",\"base_currency_symbol_position\":\"left\",\"base_currency_text\":\"USD\",\"base_currency_text_position\":\"left\",\"base_currency_rate\":\"1.00\",\"primary_color\":\"F57F4B\",\"secondary_color\":\"255056\",\"smtp_status\":1,\"smtp_host\":\"smtp.gmail.com\",\"smtp_port\":587,\"encryption\":\"TLS\",\"smtp_username\":\"ranaahmed269205@example.com\",\"smtp_password\":\"uvan rtvs rzmk zqnp\",\"from_mail\":\"ranaahmed269205@example.com\",\"from_name\":\"Binary Brain\",\"to_mail\":\"example@example.com\",\"breadcrumb\":\"6511175715121.jpg\",\"disqus_status\":0,\"disqus_short_name\":null,\"google_recaptcha_status\":0,\"google_recaptcha_site_key\":\"dfzgasdfg\",\"google_recaptcha_secret_key\":\"asdfgavsdfgvsd\",\"whatsapp_status\":0,\"whatsapp_number\":\"01868362878\",\"whatsapp_header_title\":\"Hi, there!\",\"whatsapp_popup_status\":1,\"whatsapp_popup_message\":\"If you have any issues, let us know.\",\"maintenance_img\":\"1632725312.png\",\"maintenance_status\":0,\"maintenance_msg\":\"We are upgrading our site. We will come back soon. \\r\\nPlease stay with us.\\r\\nThank you.\",\"bypass_token\":null,\"footer_logo\":\"66668fd8afd03.png\",\"footer_background_image\":\"6572f1d3ead31.png\",\"admin_theme_version\":\"light\",\"notification_image\":\"619b7d5e5e9df.png\",\"counter_section_image\":\"64e46e661cff4.png\",\"call_to_action_section_image\":\"6576af4f8ac2d.jpg\",\"testimonial_section_image\":\"6572e7c01c264.png\",\"category_section_background\":\"63c92601cb853.jpg\",\"google_adsense_publisher_id\":null,\"property_country_status\":1,\"property_state_status\":1,\"guest_checkout_status\":0,\"facebook_login_status\":1,\"facebook_app_id\":\"377957354064048\",\"facebook_app_secret\":\"c7ea8a036916500375fbd9a799b95c50\",\"google_login_status\":1,\"google_client_id\":\"951854288029-q77ihbshmmsm875po2na1ljvlejm7aji08.apps.googleusercontent.com\",\"google_client_secret\":\"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_zM\",\"tawkto_status\":0,\"tawkto_direct_chat_link\":\"https:\\/\\/tawk.to\\/chat\\/623891851ffac05b1d7fac3b\\/1fumfgsmj\",\"vendor_admin_approval\":1,\"vendor_email_verification\":1,\"admin_approval_notice\":\"Your account is deactive or pending now please contact with admin.\",\"expiration_reminder\":3,\"timezone\":\"Asia\\/Dhaka\",\"hero_section_video_url\":\"https:\\/\\/www.youtube.com\\/watch?v=9l6RywtDlKA\",\"hero_static_img\":\"6574372e0ad77.jpg\",\"contact_title\":\"Get Connected\",\"contact_subtile\":\"How Can We Help You?\",\"contact_details\":\"Lorem ipsum, dolor sit amet consectetur adipisicing elit. Maiores pariatur a ea similique quod dicta ipsa vel quidem repellendus, beatae nulla veniam, quaerat veritatis architecto. Aliquid doloremque nesciunt nobis, debitis, quas veniam.\\r\\n\\r\\nLorem ipsum, dolor sit amet consectetur adipisicing elit. Maiores a ea similique quod dicta ipsa vel quidem repellendus, beatae nulla veniam, quaerat.\",\"latitude\":\"23.8763296233045\",\"longitude\":\"90.47600702834376\",\"preloader_status\":1,\"preloader\":\"666170d789a3c.png\",\"about_section_video_link\":\"https:\\/\\/www.youtube.com\\/watch?v=F26FINYrof0\",\"about_section_image1\":\"657557b3c229e.jpg\",\"about_section_image2\":\"657557b3c2a25.jpg\",\"why_choose_us_section_img1\":\"65757ae71b9f0.jpg\",\"why_choose_us_section_img2\":\"65757ae71c078.jpg\",\"why_choose_us_section_video_link\":\"https:\\/\\/www.youtube.com\\/watch?v=ITUG13kdkQI\",\"subscribe_section_img\":\"6577e0ff3ab05.jpg\",\"updated_at\":\"2024-05-19T07:07:40.000000Z\",\"property_approval_status\":1,\"project_approval_status\":1}', 24, 38, '2024-06-12', '9999-12-31', NULL, '2024-06-12 05:05:44', '2024-06-12 05:05:44'),
(31, 399.99, 'USD', '$', 'PayPal', '72371457', 1, 0, 0, NULL, '{\n    \"id\": \"PAYID-MZUS6XQ8BM09050X2485602H\",\n    \"intent\": \"sale\",\n    \"state\": \"approved\",\n    \"cart\": \"0BJ12255SD818110E\",\n    \"payer\": {\n        \"payment_method\": \"paypal\",\n        \"status\": \"VERIFIED\",\n        \"payer_info\": {\n            \"email\": \"megasoft.envato@example.com\",\n            \"first_name\": \"Samiul Alim\",\n            \"last_name\": \"Pratik\",\n            \"payer_id\": \"8C5NYJ7EZ7QSS\",\n            \"shipping_address\": {\n                \"recipient_name\": \"Samiul Alim Pratik\",\n                \"line1\": \"1 Main St\",\n                \"city\": \"San Jose\",\n                \"state\": \"CA\",\n                \"postal_code\": \"95131\",\n                \"country_code\": \"US\"\n            },\n            \"country_code\": \"US\"\n        }\n    },\n    \"transactions\": [\n        {\n            \"amount\": {\n                \"total\": \"399.99\",\n                \"currency\": \"USD\",\n                \"details\": {\n                    \"subtotal\": \"399.99\",\n                    \"shipping\": \"0.00\",\n                    \"insurance\": \"0.00\",\n                    \"handling_fee\": \"0.00\",\n                    \"shipping_discount\": \"0.00\",\n                    \"discount\": \"0.00\"\n                }\n            },\n            \"payee\": {\n                \"merchant_id\": \"BKNWZYE3MAUNU\",\n                \"email\": \"megasoft.envato-facilitator@example.com\"\n            },\n            \"description\": \"You are purchasing a package Via Paypal\",\n            \"item_list\": {\n                \"items\": [\n                    {\n                        \"name\": \"You are purchasing a package\",\n                        \"price\": \"399.99\",\n                        \"currency\": \"USD\",\n                        \"tax\": \"0.00\",\n                        \"quantity\": 1,\n                        \"image_url\": \"\"\n                    }\n                ],\n                \"shipping_address\": {\n                    \"recipient_name\": \"Samiul Alim Pratik\",\n                    \"line1\": \"1 Main St\",\n                    \"city\": \"San Jose\",\n                    \"state\": \"CA\",\n                    \"postal_code\": \"95131\",\n                    \"country_code\": \"US\"\n                }\n            },\n            \"related_resources\": [\n                {\n                    \"sale\": {\n                        \"id\": \"3976913638690504F\",\n                        \"state\": \"completed\",\n                        \"amount\": {\n                            \"total\": \"399.99\",\n                            \"currency\": \"USD\",\n                            \"details\": {\n                                \"subtotal\": \"399.99\",\n                                \"shipping\": \"0.00\",\n                                \"insurance\": \"0.00\",\n                                \"handling_fee\": \"0.00\",\n                                \"shipping_discount\": \"0.00\",\n                                \"discount\": \"0.00\"\n                            }\n                        },\n                        \"payment_mode\": \"INSTANT_TRANSFER\",\n                        \"protection_eligibility\": \"ELIGIBLE\",\n                        \"protection_eligibility_type\": \"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE\",\n                        \"transaction_fee\": {\n                            \"value\": \"14.45\",\n                            \"currency\": \"USD\"\n                        },\n                        \"parent_payment\": \"PAYID-MZUS6XQ8BM09050X2485602H\",\n                        \"create_time\": \"2024-06-12T05:17:28Z\",\n                        \"update_time\": \"2024-06-12T05:17:28Z\",\n                        \"links\": [\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/sale/3976913638690504F\",\n                                \"rel\": \"self\",\n                                \"method\": \"GET\"\n                            },\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/sale/3976913638690504F/refund\",\n                                \"rel\": \"refund\",\n                                \"method\": \"POST\"\n                            },\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/payment/PAYID-MZUS6XQ8BM09050X2485602H\",\n                                \"rel\": \"parent_payment\",\n                                \"method\": \"GET\"\n                            }\n                        ]\n                    }\n                }\n            ]\n        }\n    ],\n    \"redirect_urls\": {\n        \"return_url\": \"http://realstate.test/vendor/membership/paypal/success?paymentId=PAYID-MZUS6XQ8BM09050X2485602H\",\n        \"cancel_url\": \"http://realstate.test/vendor/membership/paypal/cancel\"\n    },\n    \"create_time\": \"2024-06-12T05:17:18Z\",\n    \"update_time\": \"2024-06-12T05:17:28Z\",\n    \"links\": [\n        {\n            \"href\": \"https://api.sandbox.paypal.com/v1/payments/payment/PAYID-MZUS6XQ8BM09050X2485602H\",\n            \"rel\": \"self\",\n            \"method\": \"GET\"\n        }\n    ],\n    \"failed_transactions\": []\n}', '{\"id\":2,\"uniqid\":12345,\"favicon\":\"65127f2a23da3.png\",\"logo\":\"66669210543fd.png\",\"logo_two\":\"64ed7071b1844.png\",\"website_title\":\"Real Estate\",\"email_address\":\"realestate@example.com\",\"contact_number\":\"+8801865879521\",\"address\":\"13th Street 47 W ,New York, USA\",\"theme_version\":2,\"base_currency_symbol\":\"$\",\"base_currency_symbol_position\":\"left\",\"base_currency_text\":\"USD\",\"base_currency_text_position\":\"left\",\"base_currency_rate\":\"1.00\",\"primary_color\":\"F57F4B\",\"secondary_color\":\"255056\",\"smtp_status\":1,\"smtp_host\":\"smtp.gmail.com\",\"smtp_port\":587,\"encryption\":\"TLS\",\"smtp_username\":\"ranaahmed269205@example.com\",\"smtp_password\":\"uvan rtvs rzmk zqnp\",\"from_mail\":\"ranaahmed269205@example.com\",\"from_name\":\"Binary Brain\",\"to_mail\":\"example@example.com\",\"breadcrumb\":\"6511175715121.jpg\",\"disqus_status\":0,\"disqus_short_name\":null,\"google_recaptcha_status\":0,\"google_recaptcha_site_key\":\"dfzgasdfg\",\"google_recaptcha_secret_key\":\"asdfgavsdfgvsd\",\"whatsapp_status\":0,\"whatsapp_number\":\"01868362878\",\"whatsapp_header_title\":\"Hi, there!\",\"whatsapp_popup_status\":1,\"whatsapp_popup_message\":\"If you have any issues, let us know.\",\"maintenance_img\":\"1632725312.png\",\"maintenance_status\":0,\"maintenance_msg\":\"We are upgrading our site. We will come back soon. \\r\\nPlease stay with us.\\r\\nThank you.\",\"bypass_token\":null,\"footer_logo\":\"66668fd8afd03.png\",\"footer_background_image\":\"6572f1d3ead31.png\",\"admin_theme_version\":\"light\",\"notification_image\":\"619b7d5e5e9df.png\",\"counter_section_image\":\"64e46e661cff4.png\",\"call_to_action_section_image\":\"6576af4f8ac2d.jpg\",\"testimonial_section_image\":\"6572e7c01c264.png\",\"category_section_background\":\"63c92601cb853.jpg\",\"google_adsense_publisher_id\":null,\"property_country_status\":1,\"property_state_status\":1,\"guest_checkout_status\":0,\"facebook_login_status\":1,\"facebook_app_id\":\"377957354064048\",\"facebook_app_secret\":\"c7ea8a036916500375fbd9a799b95c50\",\"google_login_status\":1,\"google_client_id\":\"951854288029-q77ihbshmmsm875po2na1ljvlejm7aji08.apps.googleusercontent.com\",\"google_client_secret\":\"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_zM\",\"tawkto_status\":0,\"tawkto_direct_chat_link\":\"https:\\/\\/tawk.to\\/chat\\/623891851ffac05b1d7fac3b\\/1fumfgsmj\",\"vendor_admin_approval\":1,\"vendor_email_verification\":1,\"admin_approval_notice\":\"Your account is deactive or pending now please contact with admin.\",\"expiration_reminder\":3,\"timezone\":\"Asia\\/Dhaka\",\"hero_section_video_url\":\"https:\\/\\/www.youtube.com\\/watch?v=9l6RywtDlKA\",\"hero_static_img\":\"6574372e0ad77.jpg\",\"contact_title\":\"Get Connected\",\"contact_subtile\":\"How Can We Help You?\",\"contact_details\":\"Lorem ipsum, dolor sit amet consectetur adipisicing elit. Maiores pariatur a ea similique quod dicta ipsa vel quidem repellendus, beatae nulla veniam, quaerat veritatis architecto. Aliquid doloremque nesciunt nobis, debitis, quas veniam.\\r\\n\\r\\nLorem ipsum, dolor sit amet consectetur adipisicing elit. Maiores a ea similique quod dicta ipsa vel quidem repellendus, beatae nulla veniam, quaerat.\",\"latitude\":\"23.8763296233045\",\"longitude\":\"90.47600702834376\",\"preloader_status\":1,\"preloader\":\"666170d789a3c.png\",\"about_section_video_link\":\"https:\\/\\/www.youtube.com\\/watch?v=F26FINYrof0\",\"about_section_image1\":\"657557b3c229e.jpg\",\"about_section_image2\":\"657557b3c2a25.jpg\",\"why_choose_us_section_img1\":\"65757ae71b9f0.jpg\",\"why_choose_us_section_img2\":\"65757ae71c078.jpg\",\"why_choose_us_section_video_link\":\"https:\\/\\/www.youtube.com\\/watch?v=ITUG13kdkQI\",\"subscribe_section_img\":\"6577e0ff3ab05.jpg\",\"updated_at\":\"2024-05-19T07:07:40.000000Z\",\"property_approval_status\":1,\"project_approval_status\":1}', 24, 39, '2024-06-12', '9999-12-31', NULL, '2024-06-12 05:17:28', '2024-06-12 05:17:28');
INSERT INTO `memberships` (`id`, `price`, `currency`, `currency_symbol`, `payment_method`, `transaction_id`, `status`, `is_trial`, `trial_days`, `receipt`, `transaction_details`, `settings`, `package_id`, `vendor_id`, `start_date`, `expire_date`, `modified`, `created_at`, `updated_at`) VALUES
(32, 399.99, 'USD', '$', 'Citibank', 'd09bd2b7', 1, 0, 0, NULL, '\"offline\"', '{\"id\":2,\"uniqid\":12345,\"favicon\":\"65127f2a23da3.png\",\"logo\":\"66669210543fd.png\",\"logo_two\":\"64ed7071b1844.png\",\"website_title\":\"Real Estate\",\"email_address\":\"realestate@example.com\",\"contact_number\":\"+8801865879521\",\"address\":\"13th Street 47 W ,New York, USA\",\"theme_version\":2,\"base_currency_symbol\":\"$\",\"base_currency_symbol_position\":\"left\",\"base_currency_text\":\"USD\",\"base_currency_text_position\":\"left\",\"base_currency_rate\":\"1.00\",\"primary_color\":\"F57F4B\",\"secondary_color\":\"255056\",\"smtp_status\":1,\"smtp_host\":\"smtp.gmail.com\",\"smtp_port\":587,\"encryption\":\"TLS\",\"smtp_username\":\"ranaahmed269205@example.com\",\"smtp_password\":\"uvan rtvs rzmk zqnp\",\"from_mail\":\"ranaahmed269205@example.com\",\"from_name\":\"Binary Brain\",\"to_mail\":\"example@example.com\",\"breadcrumb\":\"6511175715121.jpg\",\"disqus_status\":0,\"disqus_short_name\":null,\"google_recaptcha_status\":0,\"google_recaptcha_site_key\":\"dfzgasdfg\",\"google_recaptcha_secret_key\":\"asdfgavsdfgvsd\",\"whatsapp_status\":0,\"whatsapp_number\":\"01868362878\",\"whatsapp_header_title\":\"Hi, there!\",\"whatsapp_popup_status\":1,\"whatsapp_popup_message\":\"If you have any issues, let us know.\",\"maintenance_img\":\"1632725312.png\",\"maintenance_status\":0,\"maintenance_msg\":\"We are upgrading our site. We will come back soon. \\r\\nPlease stay with us.\\r\\nThank you.\",\"bypass_token\":null,\"footer_logo\":\"66668fd8afd03.png\",\"footer_background_image\":\"6572f1d3ead31.png\",\"admin_theme_version\":\"light\",\"notification_image\":\"619b7d5e5e9df.png\",\"counter_section_image\":\"64e46e661cff4.png\",\"call_to_action_section_image\":\"6576af4f8ac2d.jpg\",\"testimonial_section_image\":\"6572e7c01c264.png\",\"category_section_background\":\"63c92601cb853.jpg\",\"google_adsense_publisher_id\":null,\"property_country_status\":1,\"property_state_status\":1,\"guest_checkout_status\":0,\"facebook_login_status\":1,\"facebook_app_id\":\"377957354064048\",\"facebook_app_secret\":\"c7ea8a036916500375fbd9a799b95c50\",\"google_login_status\":1,\"google_client_id\":\"951854288029-q77ihbshmmsm875po2na1ljvlejm7aji08.apps.googleusercontent.com\",\"google_client_secret\":\"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_zM\",\"tawkto_status\":0,\"tawkto_direct_chat_link\":\"https:\\/\\/tawk.to\\/chat\\/623891851ffac05b1d7fac3b\\/1fumfgsmj\",\"vendor_admin_approval\":1,\"vendor_email_verification\":1,\"admin_approval_notice\":\"Your account is deactive or pending now please contact with admin.\",\"expiration_reminder\":3,\"timezone\":\"Asia\\/Dhaka\",\"hero_section_video_url\":\"https:\\/\\/www.youtube.com\\/watch?v=9l6RywtDlKA\",\"hero_static_img\":\"6574372e0ad77.jpg\",\"contact_title\":\"Get Connected\",\"contact_subtile\":\"How Can We Help You?\",\"contact_details\":\"Lorem ipsum, dolor sit amet consectetur adipisicing elit. Maiores pariatur a ea similique quod dicta ipsa vel quidem repellendus, beatae nulla veniam, quaerat veritatis architecto. Aliquid doloremque nesciunt nobis, debitis, quas veniam.\\r\\n\\r\\nLorem ipsum, dolor sit amet consectetur adipisicing elit. Maiores a ea similique quod dicta ipsa vel quidem repellendus, beatae nulla veniam, quaerat.\",\"latitude\":\"23.8763296233045\",\"longitude\":\"90.47600702834376\",\"preloader_status\":1,\"preloader\":\"666170d789a3c.png\",\"about_section_video_link\":\"https:\\/\\/www.youtube.com\\/watch?v=F26FINYrof0\",\"about_section_image1\":\"657557b3c229e.jpg\",\"about_section_image2\":\"657557b3c2a25.jpg\",\"why_choose_us_section_img1\":\"65757ae71b9f0.jpg\",\"why_choose_us_section_img2\":\"65757ae71c078.jpg\",\"why_choose_us_section_video_link\":\"https:\\/\\/www.youtube.com\\/watch?v=ITUG13kdkQI\",\"subscribe_section_img\":\"6577e0ff3ab05.jpg\",\"updated_at\":\"2024-05-19T07:07:40.000000Z\",\"property_approval_status\":1,\"project_approval_status\":1}', 24, 40, '2024-06-12', '9999-12-31', NULL, '2024-06-12 05:23:49', '2024-06-12 05:24:05');

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

--
-- Table structure for table `menu_builders`
--

CREATE TABLE `menu_builders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `menus` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `menu_builders`
--

INSERT INTO `menu_builders` (`id`, `language_id`, `menus`, `created_at`, `updated_at`) VALUES
(7, 20, '[{\"text\":\"Home\",\"href\":\"/\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"custom\"},\r\n{\"text\":\"Community\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"projects\"},\r\n{\"text\":\"Off Plan\",\"href\":\"offplan/\",\"icon\":\"empty\",\"target\":\"_blank\",\"title\":\"\",\"type\":\"custom\"},{\"text\":\"Properties\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"properties\"},\r\n{\"text\":\"Blogs\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"blog\"},\r\n{\"text\":\"About Us\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"about-us\"},{\"text\":\"FAQ\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"faq\"},{\"text\":\"Contact\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"contact\"}]', '2023-08-17 03:19:12', '2025-11-27 11:56:50'),
(12, 25, '[{\"text\":\"بيت\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_blank\",\"title\":\"\",\"type\":\"custom\",\"children\":[{\"text\":\"المنزل واحد\",\"href\":\"\\?theme=one\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"custom\"},{\"text\":\"المنزل اثنين\",\"href\":\"\\?theme=two\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"custom\"},{\"text\":\"المنزل ثلاثة\",\"href\":\"\\?theme=three\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"custom\"}]},{\"text\":\"ملكيات\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"properties\"},{\"text\":\"المشاريع\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"projects\"},{\"text\":\"التسعير\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"pricing\"},{\"text\":\"الصفحات\",\"href\":\"#\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"custom\",\"children\":[{\"text\":\"معلومات عنا\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"about-us\"},{\"text\":\"الباعة\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"vendors\"},{\"text\":\"سياسة الخصوصية\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"سياسة-الخصوصية\"},{\"text\":\"الشروط والأحكام\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"الشروط-والأحكام\"},{\"text\":\"مدونة\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"blog\"},{\"text\":\"التعليمات\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"faq\"}]},{\"text\":\"اتصال\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"contact\"}]', '2024-03-26 02:23:59', '2024-06-14 06:21:18');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(89, '2024_02_05_072327_create_admin_infos_table', 1),
(90, '2024_04_30_102738_add_column_in_properties_table', 2),
(91, '2024_04_30_102956_add_column_in_projects_table', 2),
(92, '2024_04_30_103150_add_column_in_basic_settings_table', 3),
(93, '2024_05_05_120737_add_column_in_brand_sections', 4),
(94, '2024_05_06_115537_add_column_in_packages_table', 5),
(95, '2024_05_07_165109_add_column_in_blogs_table', 6),
(96, '2024_05_12_153537_modify_column_in_properties_table', 7),
(97, '2024_05_12_154228_modify_column_in_properties_table', 8),
(98, '2024_05_12_154739_modify_column_in_project_type_contents_table', 9);

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

--
