-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `question` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `serial_number` mediumint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `faqs` (`id`, `language_id`, `question`, `answer`, `serial_number`, `created_at`, `updated_at`) VALUES
(5, 8, 'How Donec Poseur Velit Fauci bus Auctor?', 'It is a long-established fact that reader and distracted this is readable content of a page when looking at its layout the point of using labored Ipsum is that it has a Morea normal the most finish distribution text of the printing and typesetting has been the industry.', 1, '2021-06-26 00:35:52', '2021-12-01 04:03:16'),
(6, 8, 'How Frequently Auctor Quam Vitae Fermtum?', 'It is a long established fact that reader and distracted this is readabale content of a page when looking at its layoi The point of usineg laiorem Ipsum is that it has a morea normal the most finish distribution text of the printing and typesetting has been the industry.', 2, '2021-06-26 00:38:14', '2021-06-26 00:38:14'),
(7, 8, 'How Frequently should I See A trainer?', 'It is a long established fact that reader and distracted this is readabale content of a page when looking at its layoi The point of usineg laiorem Ipsum is that it has a morea normal the most finish distribution text of the printing and typesetting has been the industry.', 3, '2021-06-26 00:39:02', '2021-06-26 00:39:02'),
(10, 9, 'في سحقت هيروشيما البريطاني يتم, غريمه باحتلال الأيديولوجية،', 'حشد الثقيل المنتصر ثم, أسر قررت تم. وغير تصفح الحزب واستمر, مشروط الساحلية هذا ان. أما معركة لبلجيكا، من, الألوف الثقيلة الإنجليزية أسر ٣٠. ٣٠ دار أمام أحدث, أما بحشد الهادي الدولارات ما, هو الحزب الصفحة محاولات قبل. وبحلول الخنادق الأوروبية، ان غير, وليرتفع برلين، انه, انتباه الوزراء البولندي تم تلك.', 1, '2021-08-29 06:57:35', '2021-08-29 06:57:35'),
(14, 9, 'نتيجة لظروف ما قد تكمن السعاده فيما نتحمله', 'هنالك العديد من الأنواع المتوفرة لنصوص لوريم إيبسوم، ولكن الغالبية تم تعديلها بشكل ما عبر إدخال بعض النوادر أو الكلمات العشوائية إلى النص. إن كنت تريد أن تستخدم نص لوريم إيبسوم ما، عليك أن تتحقق أولاً أن ليس هناك أي كلمات أو عبارات محرجة أو غير لائقة مخبأة في هذا النص. بينما تعمل جميع مولّدات نصوص لوريم إيبسوم على الإنترنت على إعادة تكرار مقاطع من نص لوريم إيبسوم نفسه عدة مرات بما تتطلبه الحاجة، يقوم مولّدنا هذا باستخدام كلمات من قاموس يحوي على أكثر من 200 كلمة لا تينية، مضاف إليها مجموعة من الجمل النموذجية، لتكوين نص لوريم إيبسوم ذو شكل منطقي قريب إلى النص الحقيقي. وبالتالي يكون النص الناتح خالي من التكرار، أو أي كلمات أو عبارات غير لائقة أو ما شابه. وهذا ما يجعله أول مولّد نص لوريم إيبسوم حقيقي على الإنترنت.', 2, '2021-12-01 04:04:11', '2021-12-01 04:04:11'),
(15, 9, 'للمصممين نص لوريم ايبسوم بالعربي عربي انجليزي', 'وعند موافقه العميل المبدئيه على التصميم يتم ازالة هذا النص من التصميم ويتم وضع النصوص النهائية المطلوبة للتصميم ويقول البعض ان وضع النصوص التجريبية بالتصميم قد تشغل المشاهد عن وضع الكثير من الملاحظات او الانتقادات للتصميم الاساسي.\r\n\r\nوخلافاَ للاعتقاد السائد فإن لوريم إيبسوم ليس نصاَ عشوائياً، بل إن له جذور في الأدب اللاتيني الكلاسيكي منذ العام 45 قبل الميلاد. من كتاب \"حول أقاصي الخير والشر\"', 3, '2021-12-01 04:05:29', '2021-12-01 04:05:29');

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

--
-- Table structure for table `features`
--

CREATE TABLE `features` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `features`
--

INSERT INTO `features` (`id`, `language_id`, `icon`, `title`, `text`, `created_at`, `updated_at`) VALUES
(4, 9, 'fas fa-hammer', 'خدمة الدقة', 'الجزء القياسي من لوريم إيبسوم المستخدم منذ القرن الخامس عشر مستنسخ أدناه للمهتمين.', '2021-12-09 06:49:52', '2022-08-01 03:34:41'),
(5, 9, 'fas fa-cannabis', 'السرعة والأمان', 'الجزء القياسي من لوريم إيبسوم المستخدم منذ القرن الخامس عشر مستنسخ أدناه للمهتمين.', '2021-12-09 06:51:31', '2022-08-01 03:35:04'),
(6, 9, 'far fa-money-bill-alt', 'التأثير الاقتصادي', 'الجزء القياسي من لوريم إيبسوم المستخدم منذ القرن الخامس عشر مستنسخ أدناه للمهتمين.', '2021-12-09 06:52:20', '2022-08-01 03:35:17'),
(7, 8, 'fas fa-hammer', 'Precision Service', 'The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested.', '2022-03-06 00:31:30', '2022-08-01 03:33:01'),
(8, 8, 'fas fa-cannabis', 'Fast & Safety', 'The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested.', '2022-03-06 00:32:18', '2022-08-01 03:33:21'),
(9, 8, 'far fa-money-bill-alt', 'Economically Effect', 'The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested.', '2022-03-06 00:33:11', '2022-08-01 03:33:40');

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

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

CREATE TABLE `feature_sections` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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`, `subtitle`, `title`, `text`, `created_at`, `updated_at`) VALUES
(1, 9, 'ميزات رائعة', 'أحدث الميزات المثيرة لدينا', 'الجزء القياسي من لوريم إيبسوم المستخدم منذ القرن الخامس عشر مستنسخ أدناه للمهتمين.', '2021-12-09 05:11:21', '2022-08-01 03:34:15'),
(2, 8, 'Awesome Features', 'Our Latest & Exciting Features', 'The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested.', '2022-03-06 00:30:42', '2022-08-01 03:32:22');

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

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

CREATE TABLE `footer_contents` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `about_company` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `copyright_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 `footer_contents`
--

INSERT INTO `footer_contents` (`id`, `language_id`, `about_company`, `copyright_text`, `created_at`, `updated_at`) VALUES
(3, 8, 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.', 'Copyright © 2022,  All Rights Reserved.', '2022-01-02 23:26:08', '2022-03-03 03:38:20'),
(4, 9, 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها.', 'حقوق الطبع والنشر © 2022 ، جميع الحقوق محفوظة.', '2022-03-06 01:00:32', '2022-03-06 01:00:32');

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

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

CREATE TABLE `guests` (
  `id` bigint UNSIGNED NOT NULL,
  `endpoint` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

INSERT INTO `languages` (`id`, `name`, `code`, `direction`, `is_default`, `created_at`, `updated_at`) VALUES
(8, 'English', 'en', 0, 1, '2021-05-31 05:58:22', '2022-08-01 00:57:24'),
(9, 'عربى', 'ar', 1, 0, '2021-05-31 05:59:16', '2022-08-10 05:34:59');

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

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

CREATE TABLE `locations` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `vendor_id` bigint DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `charge` decimal(8,2) UNSIGNED DEFAULT '0.00',
  `serial_number` mediumint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `locations` (`id`, `language_id`, `vendor_id`, `name`, `charge`, `serial_number`, `created_at`, `updated_at`) VALUES
(8, 8, 0, 'Washington, California', 100.00, 1, '2022-01-31 03:06:15', '2022-01-31 03:06:15'),
(9, 8, 0, 'Washington, D.C.', 150.00, 2, '2022-01-31 03:06:56', '2022-01-31 03:06:56'),
(10, 8, 0, 'Georgetown, California', 200.00, 3, '2022-01-31 03:07:46', '2022-01-31 03:07:46'),
(11, 9, 0, 'واشنطن ، كاليفورنيا', 100.00, 1, '2022-03-06 00:48:03', '2022-03-06 00:48:03'),
(12, 9, 0, 'واشنطن العاصمة.', 150.00, 2, '2022-03-06 00:48:41', '2022-03-06 00:48:41'),
(13, 9, 0, 'جورج تاون ، كاليفورنيا', 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'),
(22, 8, 22, 'Hazrat Shahjalal International Airpor', 10.00, 1, '2022-12-14 03:46:19', '2022-12-14 03:46:19'),
(23, 8, 22, 'Shah Amanat International Airport', 20.00, 2, '2022-12-14 03:46:57', '2022-12-14 03:46:57'),
(24, 8, 23, 'Jefferson City', 3.00, 1, '2022-12-18 06:05:12', '2023-01-01 04:02:47'),
(25, 8, 23, 'Kansas City', 5.00, 2, '2023-01-01 04:03:11', '2023-01-01 04:03:11'),
(26, 9, 23, 'جيفرسون سيتي', 3.00, 1, '2023-01-01 04:03:40', '2023-01-01 04:03:40'),
(27, 9, 23, 'مدينة كانساس', 5.00, 2, '2023-01-01 04:03:57', '2023-01-01 23:10:14'),
(28, 8, 25, 'Alexander City', 10.00, 1, '2023-01-01 23:11:34', '2023-01-01 23:11:34'),
(29, 9, 25, 'مدينة الكسندر', 10.00, 1, '2023-01-01 23:11:52', '2023-01-01 23:11:52'),
(30, 8, 25, 'Anchorage', 5.00, 2, '2023-01-01 23:12:22', '2023-01-01 23:12:22'),
(31, 9, 25, 'مرسى', 5.00, 2, '2023-01-01 23:12:41', '2023-01-01 23:12:41'),
(32, 8, 26, 'Washington, California', 20.00, 1, '2023-01-01 23:14:00', '2023-01-01 23:14:00'),
(33, 9, 26, 'واشنطن ، كاليفورنيا', 20.00, 1, '2023-01-01 23:14:19', '2023-01-01 23:14:19'),
(34, 8, 26, 'Washington, Georgia', 10.00, 2, '2023-01-01 23:14:43', '2023-01-01 23:14:43'),
(35, 9, 26, 'واشنطن ، جورجيا', 10.00, 2, '2023-01-01 23:14:57', '2023-01-01 23:14:57'),
(36, 8, 27, 'Franklin, Alabama', 5.00, 1, '2023-01-01 23:15:41', '2023-01-01 23:15:41'),
(37, 8, 27, 'Franklin, Arkansas', 15.00, 2, '2023-01-01 23:16:00', '2023-01-01 23:16:00'),
(38, 9, 27, 'فرانكلين ، ألاباما', 15.00, 1, '2023-01-01 23:16:31', '2023-01-01 23:16:31'),
(39, 9, 27, 'فرانكلين ، أركنساس', 15.00, 2, '2023-01-01 23:16:53', '2023-01-01 23:16:53');

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

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

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

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

INSERT INTO `mail_templates` (`id`, `mail_type`, `mail_subject`, `mail_body`) VALUES
(4, 'verify_email', 'Verify Your Email Address', 0x3c703e4869c2a07b757365726e616d657d2c3c2f703e3c703e5765206e65656420746f2076657269667920796f757220656d61696c2061646472657373206265666f726520796f752063616e2061636365737320796f75722064617368626f6172642e3c2f703e3c703e506c656173652076657269667920796f757220656d61696c2061646472657373206279207669736974696e6720746865206c696e6b2062656c6f773a203c6272202f3e7b766572696669636174696f6e5f6c696e6b7d2e3c2f703e3c703e5468616e6b20796f752e3c6272202f3e7b776562736974655f7469746c657d3c2f703e),
(5, 'reset_password', 'Recover Password of Your Account', 0x3c703e4869207b637573746f6d65725f6e616d657d2c3c2f703e3c703e576520686176652072656365697665642061207265717565737420746f20726573657420796f75722070617373776f72642e20496620796f7520646964206e6f74206d616b652074686520726571756573742c2069676e6f7265207468697320656d61696c2e204f74686572776973652c20796f752063616e20726573657420796f75722070617373776f7264207573696e67207468652062656c6f77206c696e6b2e3c2f703e3c703e7b70617373776f72645f72657365745f6c696e6b7d3c2f703e3c703e5468616e6b732c3c6272202f3e7b776562736974655f7469746c657d3c2f703e),
(9, 'product_order', 'Product Order Has Been Placed', 0x3c703e4869c2a07b637573746f6d65725f6e616d657d2c3c2f703e3c703e596f7572206f7264657220686173206265656e20706c61636564207375636365737366756c6c792e205765206861766520617474616368656420616e20696e766f69636520746f2074686973206d61696c2e3c6272202f3e4f72646572204e6f3a20237b6f726465725f6e756d6265727d2e20546865207472616e73616374696f6e2069642069733a207b7472616e73616374696f6e5f69647d2e3c2f703e3c703e7b6f726465725f6c696e6b7d3c6272202f3e3c2f703e3c703e4265737420726567617264732e3c6272202f3e7b776562736974655f7469746c657d3c2f703e),
(10, 'equipment_booking', 'Confirmation of Equipment Booking', 0x3c70207374796c653d22666f6e742d66616d696c793a4c61746f2c2073616e732d73657269663b666f6e742d73697a653a313470783b6c696e652d6865696768743a312e38323b636f6c6f723a72676228302c302c30293b666f6e742d7374796c653a6e6f726d616c3b666f6e742d7765696768743a3430303b746578742d616c69676e3a6c6566743b223e4869207b637573746f6d65725f6e616d657d2c3c2f703e3c70207374796c653d22666f6e742d66616d696c793a4c61746f2c2073616e732d73657269663b666f6e742d73697a653a313470783b6c696e652d6865696768743a312e38323b636f6c6f723a72676228302c302c30293b666f6e742d7374796c653a6e6f726d616c3b666f6e742d7765696768743a3430303b746578742d616c69676e3a6c6566743b223e5468697320656d61696c20697320746f20636f6e6669726d20796f757220626f6f6b696e6720237b626f6f6b696e675f6e756d6265727d206f6e207b626f6f6b696e675f646174657d20666f72c2a0207b65717569706d656e745f6e616d657d2e2054686520626f6f6b696e672073746172742064617465207368616c6c206265206f6e207b73746172745f646174657d20616e642074686520626f6f6b696e6720656e642064617465207368616c6c206265206f6e207b656e645f646174657d2e20546865207472616e73616374696f6e206964206973207b7472616e73616374696f6e5f69647d2e3c2f703e3c70207374796c653d22666f6e742d66616d696c793a4c61746f2c2073616e732d73657269663b666f6e742d73697a653a313470783b6c696e652d6865696768743a312e38323b636f6c6f723a72676228302c302c30293b666f6e742d7374796c653a6e6f726d616c3b666f6e742d7765696768743a3430303b746578742d616c69676e3a6c6566743b223e7b626f6f6b696e675f6c696e6b7d3c2f703e3c70207374796c653d22666f6e742d66616d696c793a4c61746f2c2073616e732d73657269663b666f6e742d73697a653a313470783b6c696e652d6865696768743a312e38323b636f6c6f723a72676228302c302c30293b666f6e742d7374796c653a6e6f726d616c3b666f6e742d7765696768743a3430303b746578742d616c69676e3a6c6566743b223e7b76656e646f725f64657461696c735f6c696e6b7d3c2f703e3c70207374796c653d22666f6e742d66616d696c793a4c61746f2c2073616e732d73657269663b666f6e742d73697a653a313470783b6c696e652d6865696768743a312e38323b636f6c6f723a72676228302c302c30293b666f6e742d7374796c653a6e6f726d616c3b666f6e742d7765696768743a3430303b746578742d616c69676e3a6c6566743b223e5765206861766520616c736f20617474616368656420616e20696e766f69636520746f2074686973206d61696c2e20496620796f75206861766520616e7920696e717569726965732c20706c6561736520646f6e277420686573697461746520746f20636f6e746163742075732e3c6272202f3e3c2f703e3c70207374796c653d22666f6e742d66616d696c793a4c61746f2c2073616e732d73657269663b666f6e742d73697a653a313470783b6c696e652d6865696768743a312e38323b636f6c6f723a72676228302c302c30293b666f6e742d7374796c653a6e6f726d616c3b666f6e742d7765696768743a3430303b746578742d616c69676e3a6c6566743b223e4265737420526567617264732e3c6272202f3e7b776562736974655f7469746c657d3c2f703e),
(11, 'withdraw_approve', 'Confirmation of Withdraw Approve', 0x3c70207374796c653d22666f6e742d66616d696c793a4c61746f2c2073616e732d73657269663b666f6e742d73697a653a313470783b6c696e652d6865696768743a312e38323b636f6c6f723a72676228302c302c30293b666f6e742d7374796c653a6e6f726d616c3b666f6e742d7765696768743a3430303b746578742d616c69676e3a6c6566743b223e4869207b76656e646f725f757365726e616d657d2c3c2f703e3c70207374796c653d22666f6e742d66616d696c793a4c61746f2c2073616e732d73657269663b666f6e742d73697a653a313470783b6c696e652d6865696768743a312e38323b636f6c6f723a72676228302c302c30293b666f6e742d7374796c653a6e6f726d616c3b666f6e742d7765696768743a3430303b746578742d616c69676e3a6c6566743b223e5468697320656d61696c20636f6e6669726d73207468617420796f7572207769746864726177616c2072657175657374c2a0207b77697468647261775f69647d20697320617070726f7665642ec2a03c2f703e3c70207374796c653d22666f6e742d66616d696c793a4c61746f2c2073616e732d73657269663b666f6e742d73697a653a313470783b6c696e652d6865696768743a312e38323b636f6c6f723a72676228302c302c30293b666f6e742d7374796c653a6e6f726d616c3b666f6e742d7765696768743a3430303b746578742d616c69676e3a6c6566743b223e596f75722063757272656e742062616c616e6365206973207b63757272656e745f62616c616e63657d2c20776974686472617720616d6f756e74207b77697468647261775f616d6f756e747d2c20636861726765203a207b6368617267657d2c70617961626c6520616d6f756e74207b70617961626c655f616d6f756e747d3c2f703e3c70207374796c653d22666f6e742d66616d696c793a4c61746f2c2073616e732d73657269663b666f6e742d73697a653a313470783b6c696e652d6865696768743a312e38323b636f6c6f723a72676228302c302c30293b666f6e742d7374796c653a6e6f726d616c3b666f6e742d7765696768743a3430303b746578742d616c69676e3a6c6566743b223e7769746864726177206d6574686f64203ac2a07b77697468647261775f6d6574686f647d2e20546865207472616e73616374696f6e206964206973207b7472616e73616374696f6e5f69647d2e3c2f703e3c70207374796c653d22666f6e742d66616d696c793a4c61746f2c2073616e732d73657269663b666f6e742d73697a653a313470783b6c696e652d6865696768743a312e38323b636f6c6f723a72676228302c302c30293b666f6e742d7374796c653a6e6f726d616c3b666f6e742d7765696768743a3430303b746578742d616c69676e3a6c6566743b223e3c6272202f3e3c2f703e3c70207374796c653d22666f6e742d66616d696c793a4c61746f2c2073616e732d73657269663b666f6e742d73697a653a313470783b6c696e652d6865696768743a312e38323b636f6c6f723a72676228302c302c30293b666f6e742d7374796c653a6e6f726d616c3b666f6e742d7765696768743a3430303b746578742d616c69676e3a6c6566743b223e4265737420526567617264732e3c6272202f3e7b776562736974655f7469746c657d3c2f703e),
(13, 'withdraw_rejected', 'Withdraw Request Rejected', 0x3c703e4869207b76656e646f725f757365726e616d657d2c3c2f703e3c703e5468697320656d61696c20636f6e6669726d73207468617420796f7572207769746864726177616c2072657175657374c2a0207b77697468647261775f69647d2069732072656a656374656420616e64207468652062616c616e636520616464656420746f20796f7572206163636f756e742ec2a03c2f703e3c703e596f75722063757272656e742062616c616e6365206973207b63757272656e745f62616c616e63657d3c2f703e3c703e3c6272202f3e3c2f703e3c703e4265737420526567617264732e3c6272202f3e7b776562736974655f7469746c657d3c2f703e),
(14, 'balance_add', 'Balance Add', 0x3c703e4869207b757365726e616d657d3c2f703e3c703e7b616d6f756e747d20616464656420746f20796f7572206163636f756e742e3c2f703e3c703e596f75722063757272656e742062616c616e6365206973207b63757272656e745f62616c616e63657d2ec2a03c2f703e3c703e546865207472616e73616374696f6e206964206973207b7472616e73616374696f6e5f69647d2e3c6272202f3e3c2f703e3c703e3c6272202f3e3c2f703e3c703e4265737420526567617264732e3c6272202f3e7b776562736974655f7469746c657d3c6272202f3e3c2f703e),
(15, 'balance_subtract', 'Balance Subtract', 0x3c703e4869207b757365726e616d657d3c2f703e3c703e7b616d6f756e747d2073756274726163742066726f6d20796f7572206163636f756e742e3c2f703e3c703e596f75722063757272656e742062616c616e6365206973207b63757272656e745f62616c616e63657d2e3c2f703e3c703e546865207472616e73616374696f6e206964206973207b7472616e73616374696f6e5f69647d2e3c6272202f3e3c2f703e3c703e3c6272202f3e3c2f703e3c703e4265737420526567617264732e3c6272202f3e7b776562736974655f7469746c657d3c2f703e);

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

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

CREATE TABLE `menu_builders` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `menus` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `menu_builders` (`id`, `language_id`, `menus`, `created_at`, `updated_at`) VALUES
(1, 9, '[{\"text\":\"الصفحة الرئيسية\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"home\"},{\"text\":\"ادوات\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"equipment\"},{\"text\":\"الباعة\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"vendor\"},{\"text\":\"محل\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"custom\",\"children\":[{\"text\":\"منتجات\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"products\"},{\"text\":\"عربة التسوق\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"cart\"}]},{\"text\":\"الصفحات\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"custom\",\"children\":[{\"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\"}]', '2021-11-18 04:50:31', '2022-12-22 03:38:06'),
(2, 8, '[{\"text\":\"Home\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"home\"},{\"text\":\"Equipment\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"equipment\"},{\"text\":\"Vendors\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"vendor\"},{\"text\":\"Shop\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"custom\",\"children\":[{\"text\":\"Products\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"products\"},{\"text\":\"Cart\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"cart\"}]},{\"text\":\"Pages\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"custom\",\"children\":[{\"text\":\"About Us\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"about-us\"},{\"text\":\"Terms & Conditions\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"terms-&-conditions\"}]},{\"text\":\"Blog\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"blog\"},{\"text\":\"FAQ\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"faq\"},{\"text\":\"Contact\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"contact\"}]', '2021-12-01 05:32:09', '2023-01-02 01:12:10');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2022_10_19_061720_create_commissions_table', 1),
(2, '2022_10_19_063819_create_earnings_table', 2),
(3, '2022_10_19_064056_create_transcations_table', 2),
(4, '2022_10_20_044719_create_withdraw_payment_methods_table', 3),
(5, '2022_10_20_044915_create_withdraw_method_inputs_table', 3),
(6, '2022_10_20_045157_create_withdraw_method_options_table', 3),
(7, '2022_10_20_045258_create_withdraws_table', 3),
(8, '2022_10_23_051050_create_vendor_reviews_table', 4),
(9, '2022_12_13_055404_create_vendor_infos_table', 5),
(10, '2024_01_09_101256_create_video_sections_table', 6),
(11, '2024_01_09_113357_add_video_section_status_to_sections', 7),
(12, '2024_01_09_122336_add_counter_section_title_to_basic_settings', 8),
(13, '2024_01_11_123343_add_testimonial_section_image_to_testimonial_sections', 9),
(14, '2024_01_11_125832_add_testimonial_section_image_2_to_testimonial_sections', 10),
(15, '2024_01_16_111543_create_equipment_category_sections_table', 11),
(16, '2024_01_17_062332_add_image_to_equipment_categories', 12),
(17, '2023_03_08_040425_add_security_deposit_amount_column_to_equipments_table', 13),
(18, '2023_03_08_044930_add_column_to_equipment_bookings_table', 13),
(19, '2023_03_08_061957_create_security_deposit_refunds_table', 13),
(20, '2023_06_06_063356_create_equipment_locations_table', 13),
(21, '2023_06_13_063302_add_commission_percentage_column_to_equipment_bookings_table', 13),
(22, '2023_06_13_105405_add_security_deposit_column_to_transcations_table', 13),
(23, '2021_02_01_030511_create_payment_invoices_table', 14),
(24, '2024_05_01_104208_add_conversation_id_to_product_orders_table', 15),
(25, '2024_05_02_105138_add_conversation_id_to_equipment_bookings_table', 16),
(26, '2024_05_05_071139_create_failed_jobs_table', 17),
(28, '2024_06_03_131654_add_is_featured_to_equipment_categories_table', 18),
(29, '2024_06_04_105606_add_featured_subtitle_title_to_equipment_sections_table', 19),
(31, '2024_06_04_110815_add_featured_equipment_section_status_to_sections_table', 20),
(32, '2024_07_06_130032_add_blog_section_image_to_blog_sections_table', 21);

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

--
-- Table structure for table `offline_gateways`
--

CREATE TABLE `offline_gateways` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `instructions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0 -> gateway is deactive, 1 -> gateway is active.',
  `has_attachment` tinyint(1) NOT NULL COMMENT '0 -> do not need attachment, 1 -> need attachment.',
  `serial_number` mediumint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `offline_gateways`
--

INSERT INTO `offline_gateways` (`id`, `name`, `short_description`, `instructions`, `status`, `has_attachment`, `serial_number`, `created_at`, `updated_at`) VALUES
(2, 'Citibank', 'A pioneer of both the credit card industry and automated teller machines, Citibank – formerly the City Bank of New York.', '<p><span style=\"color:rgb(51,51,51);font-family:\'proxima-nova\', sans-serif;font-size:16px;\">A pioneer of both the credit card industry and automated teller machines, </span><a href=\"https://smartasset.com/checking-account/Citibank-banking-review\">Citibank</a><span style=\"color:rgb(51,51,51);font-family:\'proxima-nova\', sans-serif;font-size:16px;\"> –\r\n formerly the City Bank of New York – was regarded as an East Coast \r\nequivalent to Wells Fargo during the 19th century.</span><br></p>', 1, 0, 1, '2021-07-16 22:41:59', '2022-01-23 00:11:01'),
(3, 'Bank of America', 'Bank of America has 4,265 branches in the country, only about 700 fewer than Chase. It started as a small institution serving immigrants in San Francisco.', '<p><span style=\"color:rgb(51,51,51);font-family:\'proxima-nova\', sans-serif;font-size:16px;\">With $1.8 trillion in consolidated assets, </span><a href=\"https://smartasset.com/checking-account/bank-of-america-review\">Bank of America</a><span style=\"color:rgb(51,51,51);font-family:\'proxima-nova\', sans-serif;font-size:16px;\"> is\r\n second on the list. Its headquarters in Charlotte, North Carolina, \r\nsinglehandedly makes that city one of the biggest financial centers in \r\nthe country.</span><br></p>', 1, 1, 2, '2021-07-16 22:43:19', '2021-07-16 22:43:19');

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

--
-- Table structure for table `online_gateways`
--

CREATE TABLE `online_gateways` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `keyword` varchar(255) NOT NULL,
  `information` mediumtext NOT NULL,
  `status` tinyint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `online_gateways`
--

INSERT INTO `online_gateways` (`id`, `name`, `keyword`, `information`, `status`) VALUES
(1, 'PayPal', 'paypal', '{\"sandbox_status\":\"1\",\"client_id\":\"AVYKFEw63FtDt9aeYOe9biyifNI56s2Hc2F1Us11hWoY5GMuegipJRQBfWLiIKNbwQ5tmqKSrQTU3zB3\",\"client_secret\":\"EJY0qOKliVg7wKsR3uPN7lngr9rL1N7q4WV0FulT1h4Fw3_e5Itv1mxSdbtSUwAaQoXQFgq-RLlk_sQu\"}', 1),
(2, 'Instamojo', 'instamojo', '{\"sandbox_status\":\"1\",\"key\":\"\",\"token\":\"\"}', 1),
(3, 'Paystack', 'paystack', '{\"key\":\"\"}', 1),
(4, 'Flutterwave', 'flutterwave', '{\"public_key\":\"\",\"secret_key\":\"\"}', 1),
(5, 'Razorpay', 'razorpay', '{\"key\":\"\",\"secret\":\"\"}', 1),
(6, 'MercadoPago', 'mercadopago', '{\"sandbox_status\":\"1\",\"token\":\"\"}', 1),
(7, 'Mollie', 'mollie', '{\"key\":\"\"}', 1),
(8, 'Stripe', 'stripe', '{\"key\":\"pk_test_UnU1Coi1p5qFGwtpjZMRMgJM\",\"secret\":\"sk_test_QQcg3vGsKRPlW6T3dXcNJsor\"}', 1),
(9, 'Paytm', 'paytm', '{\"environment\":\"local\",\"merchant_key\":\"\",\"merchant_mid\":\"\",\"merchant_website\":\"WEBSTAGING\",\"industry_type\":\"Retail\"}', 1),
(10, 'Midtrans', 'midtrans', '{\"mindtrans_test_mode\":\"1\",\"midtrans_status\":\"1\",\"merchant_id\":\"G772355092\",\"client_key\":\"SB-Mid-client-mTzEQYoEdXPtcifa\",\"midtrans_server_key\":\"SB-Mid-server-w4Ihfmt0iPijcKkEfa8X2e-9\"}', 1),
(11, 'Iyzico', 'iyzico', '{\"sandbox_status\":\"1\",\"api_key\":\"sandbox-nhwvNYFN8EdyUm0MXVon9u9wNt6HTKrl\",\"secret_key\":\"sandbox-nZ69wQYaUbxqKbOoHJmc9CjQZtgcSloC\"}', 1),
(12, 'Paytabs', 'paytabs', '{\"paytabs_status\":\"1\",\"profile_id\":\"125178\",\"server_key\":\"SKJ9LL6R92-J6NRR9LDNM-J9JHHMDHMR\",\"country\":\"global\",\"api_endpoint\":\"https:\\/\\/secure-global.paytabs.com\\/payment\\/request\"}', 1),
(13, 'Toyyibpay', 'toyyibpay', '{\"secret_key\":\"5zcr9cl4-3aak-8vzl-5ahm-6f1k6z1lvjw3\",\"category_code\":\"m1plpg99\",\"toyyibpay_sandbox_status\":\"1\"}', 1),
(14, 'Phonepe', 'phonepe', '{\"phonepe_merchant_id\":\"PGTESTPAYUAT\",\"salt_key\":\"099eb0cd-02cf-4e2a-8aca-3e6c6aff0399\",\"phonepe_sandbox_status\":\"1\",\"salt_index\":\"1\"}', 1),
(15, 'Yoco', 'yoco', '{\"yoco_secret_key\":\"sk_test_960bfde0VBrLlpK098e4ffeb53e1\"}', 1),
(16, 'Myfatoorah', 'myfatoorah', '{\"myfatoorah_status\":\"1\",\"token\":\"rLtt6JWvbUHDDhsZnfpAhpYk4dxYDQkbcPTyGaKp2TYqQgG7FGZ5Th_WD53Oq8Ebz6A53njUoo1w3pjU1D4vs_ZMqFiz_j0urb_BH9Oq9VZoKFoJEDAbRZepGcQanImyYrry7Kt6MnMdgfG5jn4HngWoRdKduNNyP4kzcp3mRv7x00ahkm9LAK7ZRieg7k1PDAnBIOG3EyVSJ5kK4WLMvYr7sCwHbHcu4A5WwelxYK0GMJy37bNAarSJDFQsJ2ZvJjvMDmfWwDVFEVe_5tOomfVNt6bOg9mexbGjMrnHBnKnZR1vQbBtQieDlQepzTZMuQrSuKn-t5XZM7V6fCW7oP-uXGX-sMOajeX65JOf6XVpk29DP6ro8WTAflCDANC193yof8-f5_EYY-3hXhJj7RBXmizDpneEQDSaSz5sFk0sV5qPcARJ9zGG73vuGFyenjPPmtDtXtpx35A-BVcOSBYVIWe9kndG3nclfefjKEuZ3m4jL9Gg1h2JBvmXSMYiZtp9MR5I6pvbvylU_PP5xJFSjVTIz7IQSjcVGO41npnwIxRXNRxFOdIUHn0tjQ-7LwvEcTXyPsHXcMD8WtgBh-wxR8aKX7WPSsT1O8d8reb2aR7K3rkV3K82K_0OgawImEpwSvp9MNKynEAJQS6ZHe_J_l77652xwPNxMRTMASk1ZsJL\",\"myfatoorah_sandbox_status\":\"1\"}', 1),
(17, 'Xendit', 'xendit', '{\"secret_api_key\":\"xnd_development_xJnvoJSaiPLhSzwB23Xmzu6Fcayjou9e8qpaoExzfj3UWfmM4GvaY1eBgzcABxyr\",\"public_key\":\"xnd_public_development_FfXOoIHbYLnWj1ZT8ZravVkxL2MzL8OXpXWZONwGMINTUAMFh8Wb0kitIz89X\",\"business_id\":\"64c1431a13d818dc4c53cadf\"}', 1),
(18, 'Perfect Money', 'perfect_money', '{\"perfect_money_wallet_id\":null}', 1);

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

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

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

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

INSERT INTO `pages` (`id`, `status`, `created_at`, `updated_at`) VALUES
(14, 1, '2021-10-18 02:33:45', '2021-10-18 02:33:45'),
(19, 1, '2022-07-30 05:33:25', '2022-07-30 05:33:25');

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

--
-- Table structure for table `page_contents`
--

CREATE TABLE `page_contents` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `page_id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` blob NOT NULL,
  `meta_keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `page_contents`
--

INSERT INTO `page_contents` (`id`, `language_id`, `page_id`, `title`, `slug`, `content`, `meta_keywords`, `meta_description`, `created_at`, `updated_at`) VALUES
(30, 9, 14, 'البنود و الظروف', 'البنود-و-الظروف', 0x3c70207374796c653d22746578742d616c69676e3a72696768743b223e3c666f6e7420636f6c6f723d2223363636363636223e3c7370616e207374796c653d22666f6e742d73697a653a313670783b223ed985d98620d986d8a7d8add98ad8a920d8a3d8aed8b1d98920d88c20d986d8b4d8acd8a820d8a8d8b3d8aed8b720d8b5d8a7d984d8ad20d988d986d983d8b1d98720d8a7d984d8b1d8acd8a7d98420d8a7d984d8b0d98ad98620d8aed8afd8b9d987d98520d8b3d8add8b120d985d8aad8b9d8a920d8a7d984d984d8add8b8d8a920d988d8a5d8add8a8d8a7d8b7d987d98520d88c20d988d8a3d8b9d985d8aad987d98520d8a7d984d8b1d8bad8a8d8a920d88c20d984d8afd8b1d8acd8a920d8a3d986d987d98520d984d8a720d98ad8b3d8aad8b7d98ad8b9d988d98620d8a7d984d8aad986d8a8d8a420d8a8d8a7d984d8a3d984d98520d988d8a7d984d985d8aad8a7d8b9d8a820d8a7d984d8aad98a20d8b3d8aad8aad8b1d8aad8a820d8b9d984d98920d8b0d984d98320d89b20d988d8a7d984d984d988d98520d8a7d984d985d8aad8b3d8a7d988d98a20d98ad982d8b920d8b9d984d98920d985d98620d98ad981d8b4d98420d981d98a20d8a3d8afd8a7d8a120d988d8a7d8acd8a8d98720d8a8d8b3d8a8d8a820d8b6d8b9d98120d8a7d984d8a5d8b1d8a7d8afd8a920d88c20d988d987d98820d986d981d8b320d8a7d984d982d988d98420d8a8d8a7d984d8a7d986d983d985d8a7d8b420d985d98620d8a7d984d983d8af20d988d8a7d984d8a3d984d9852e20d987d8b0d98720d8a7d984d8add8a7d984d8a7d8aa20d8a8d8b3d98ad8b7d8a920d984d984d8bad8a7d98ad8a920d988d8b3d987d984d8a920d8a7d984d8aad985d98ad98ad8b22e20d981d98a20d8b3d8a7d8b9d8a920d985d8acd8a7d986d98ad8a920d88c20d8b9d986d8afd985d8a720d8aad983d988d98620d982d8afd8b1d8aad986d8a720d8b9d984d98920d8a7d984d8a7d8aed8aad98ad8a7d8b120d8bad98ad8b120d985d982d98ad8afd8a920d988d8b9d986d8afd985d8a720d984d8a720d8b4d98ad8a120d98ad985d986d8b9d986d8a720d985d98620d8a7d984d982d98ad8a7d98520d8a8d985d8a720d986d981d8b6d984d98720d88c20d98ad8acd8a820d8a7d984d8aad8b1d8add98ad8a820d8a8d983d98420d985d8aad8b9d8a920d988d8aad8acd986d8a820d983d98420d8a3d984d9852e20d988d984d983d98620d981d98a20d8b8d8b1d988d98120d985d8b9d98ad986d8a920d988d8a8d8b3d8a8d8a820d8a7d8afd8b9d8a7d8a1d8a7d8aa20d8a7d984d988d8a7d8acd8a820d8a3d98820d8a7d984d8aad8b2d8a7d985d8a7d8aa20d8a7d984d8b9d985d98420d88c20d8b3d98ad8add8afd8ab20d981d98a20d983d8abd98ad8b120d985d98620d8a7d984d8a3d8add98ad8a7d98620d8a3d986d98720d98ad8acd8a820d986d8a8d8b020d8a7d984d985d984d8b0d8a7d8aa20d988d982d8a8d988d98420d8a7d984d8a5d8b2d8b9d8a7d8ac2e20d984d8b0d984d98320d98ad8aad985d8b3d98320d8a7d984d8b1d8acd98420d8a7d984d8add983d98ad98520d8afd8a7d8a6d985d98bd8a720d981d98a20d987d8b0d98720d8a7d984d8a3d985d988d8b120d8a8d985d8a8d8afd8a320d8a7d984d8a7d8aed8aad98ad8a7d8b120d987d8b0d8a73a20d981d987d98820d98ad8b1d981d8b620d8a7d984d985d984d8b0d8a7d8aa20d984d8aad8a3d985d98ad98620d985d984d8b0d8a7d8aa20d8a3d8b9d8b8d98520d8a3d8aed8b1d98920d88c20d988d8a5d984d8a720d981d8a5d986d98720d98ad8aad8add985d98420d8a7d984d8a2d984d8a7d98520d984d8aad8acd986d8a820d8a7d984d8a2d984d8a7d98520d8a7d984d8b3d98ad8a6d8a92e3c2f7370616e3e3c2f666f6e743e3c6272202f3e3c2f703e, NULL, NULL, '2021-10-18 02:33:45', '2022-03-06 05:12:50'),
(31, 8, 14, 'Terms & Conditions', 'terms-&-conditions', 0x[encoded data, 20404 characters], NULL, NULL, '2021-10-18 02:33:45', '2022-10-20 04:41:25'),
(41, 9, 19, 'معلومات عنا', 'معلومات-عنا', 0x3c70207374796c653d22746578742d616c69676e3a72696768743b636f6c6f723a7267622836362c36362c3636293b666f6e742d66616d696c793a7461686f6d612c2073616e732d73657269663b223e3c7370616e207374796c653d22636f6c6f723a726762283130322c3130322c313032293b666f6e742d66616d696c793a4c61746f2c2073616e732d73657269663b666f6e742d73697a653a313670783b223ed985d98620d986d8a7d8add98ad8a920d8a3d8aed8b1d98920d88c20d986d8b4d8acd8a820d8a8d8b3d8aed8b720d8b5d8a7d984d8ad20d988d986d983d8b1d98720d8a7d984d8b1d8acd8a7d98420d8a7d984d8b0d98ad98620d8aed8afd8b9d987d98520d8b3d8add8b120d985d8aad8b9d8a920d8a7d984d984d8add8b8d8a920d988d8a5d8add8a8d8a7d8b7d987d98520d88c20d988d8a3d8b9d985d8aad987d98520d8a7d984d8b1d8bad8a8d8a920d88c20d984d8afd8b1d8acd8a920d8a3d986d987d98520d984d8a720d98ad8b3d8aad8b7d98ad8b9d988d98620d8a7d984d8aad986d8a8d8a420d8a8d8a7d984d8a3d984d98520d988d8a7d984d985d8aad8a7d8b9d8a820d8a7d984d8aad98a20d8b3d8aad8aad8b1d8aad8a820d8b9d984d98920d8b0d984d98320d89b20d988d8a7d984d984d988d98520d8a7d984d985d8aad8b3d8a7d988d98a20d98ad982d8b920d8b9d984d98920d985d98620d98ad981d8b4d98420d981d98a20d8a3d8afd8a7d8a120d988d8a7d8acd8a8d98720d8a8d8b3d8a8d8a820d8b6d8b9d98120d8a7d984d8a5d8b1d8a7d8afd8a920d88c20d988d987d98820d986d981d8b320d8a7d984d982d988d98420d8a8d8a7d984d8a7d986d983d985d8a7d8b420d985d98620d8a7d984d983d8af20d988d8a7d984d8a3d984d9852e20d987d8b0d98720d8a7d984d8add8a7d984d8a7d8aa20d8a8d8b3d98ad8b7d8a920d984d984d8bad8a7d98ad8a920d988d8b3d987d984d8a920d8a7d984d8aad985d98ad98ad8b22e20d981d98a20d8b3d8a7d8b9d8a920d985d8acd8a7d986d98ad8a920d88c20d8b9d986d8afd985d8a720d8aad983d988d98620d982d8afd8b1d8aad986d8a720d8b9d984d98920d8a7d984d8a7d8aed8aad98ad8a7d8b120d8bad98ad8b120d985d982d98ad8afd8a920d988d8b9d986d8afd985d8a720d984d8a720d8b4d98ad8a120d98ad985d986d8b9d986d8a720d985d98620d8a7d984d982d98ad8a7d98520d8a8d985d8a720d986d981d8b6d984d98720d88c20d98ad8acd8a820d8a7d984d8aad8b1d8add98ad8a820d8a8d983d98420d985d8aad8b9d8a920d988d8aad8acd986d8a820d983d98420d8a3d984d9852e20d988d984d983d98620d981d98a20d8b8d8b1d988d98120d985d8b9d98ad986d8a920d988d8a8d8b3d8a8d8a820d8a7d8afd8b9d8a7d8a1d8a7d8aa20d8a7d984d988d8a7d8acd8a820d8a3d98820d8a7d984d8aad8b2d8a7d985d8a7d8aa20d8a7d984d8b9d985d98420d88c20d8b3d98ad8add8afd8ab20d981d98a20d983d8abd98ad8b120d985d98620d8a7d984d8a3d8add98ad8a7d98620d8a3d986d98720d98ad8acd8a820d986d8a8d8b020d8a7d984d985d984d8b0d8a7d8aa20d988d982d8a8d988d98420d8a7d984d8a5d8b2d8b9d8a7d8ac2e20d984d8b0d984d98320d98ad8aad985d8b3d98320d8a7d984d8b1d8acd98420d8a7d984d8add983d98ad98520d8afd8a7d8a6d985d98bd8a720d981d98a20d987d8b0d98720d8a7d984d8a3d985d988d8b120d8a8d985d8a8d8afd8a320d8a7d984d8a7d8aed8aad98ad8a7d8b120d987d8b0d8a73a20d981d987d98820d98ad8b1d981d8b620d8a7d984d985d984d8b0d8a7d8aa20d984d8aad8a3d985d98ad98620d985d984d8b0d8a7d8aa20d8a3d8b9d8b8d98520d8a3d8aed8b1d98920d88c20d988d8a5d984d8a720d981d8a5d986d98720d98ad8aad8add985d98420d8a7d984d8a2d984d8a7d98520d984d8aad8acd986d8a820d8a7d984d8a2d984d8a7d98520d8a7d984d8b3d98ad8a6d8a92e3c2f7370616e3e3c6272202f3e3c2f703e, NULL, NULL, '2022-07-30 05:33:25', '2022-08-02 00:55:09'),
(42, 8, 19, 'About Us', 'about-us', 0x3c703e3c7370616e207374796c653d22636f6c6f723a726762283130322c3130322c313032293b666f6e742d66616d696c793a526f626f746f3b666f6e742d73697a653a313670783b223e4f6e20746865206f746865722068616e642c2077652064656e6f756e63652077697468207269676874656f757320696e6469676e6174696f6e20616e64206469736c696b65206d656e2077686f2061726520736f2062656775696c656420616e642064656d6f72616c697a65642062792074686520636861726d73206f6620706c656173757265206f6620746865206d6f6d656e742c20736f20626c696e646564206279206465736972652c207468617420746865792063616e6e6f7420666f726573656520746865207061696e20616e642074726f75626c6520746861742061726520626f756e6420746f20656e7375653b20616e6420657175616c20626c616d652062656c6f6e677320746f2074686f73652077686f206661696c20696e2074686569722064757479207468726f756768207765616b6e657373206f662077696c6c2c207768696368206973207468652073616d6520617320736179696e67207468726f75676820736872696e6b696e672066726f6d20746f696c20616e64207061696e2e2054686573652063617365732061726520706572666563746c792073696d706c6520616e64206561737920746f2064697374696e67756973682e20496e2061206672656520686f75722c207768656e206f757220706f776572206f662063686f69636520697320756e7472616d6d656c656420616e64207768656e206e6f7468696e672070726576656e7473206f7572206265696e672061626c6520746f20646f2077686174207765206c696b6520626573742c20657665727920706c65617375726520697320746f2062652077656c636f6d656420616e64206576657279207061696e2061766f696465642e2042757420696e206365727461696e2063697263756d7374616e63657320616e64206f77696e6720746f2074686520636c61696d73206f662064757479206f7220746865206f626c69676174696f6e73206f6620627573696e6573732069742077696c6c206672657175656e746c79206f63637572207468617420706c65617375726573206861766520746f206265207265707564696174656420616e6420616e6e6f79616e6365732061636365707465642e205468652077697365206d616e207468657265666f726520616c7761797320686f6c647320696e207468657365206d61747465727320746f2074686973207072696e6369706c65206f662073656c656374696f6e3a2068652072656a6563747320706c6561737572657320746f20736563757265206f74686572206772656174657220706c656173757265732c206f7220656c736520686520656e6475726573207061696e7320746f2061766f696420776f727365207061696e732e3c2f7370616e3e3c6272202f3e3c2f703e, NULL, NULL, '2022-07-30 05:33:25', '2022-08-01 04:53:01');

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

--
-- Table structure for table `partners`
--

CREATE TABLE `partners` (
  `id` bigint UNSIGNED NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `serial_number` smallint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partners`
--

INSERT INTO `partners` (`id`, `image`, `url`, `serial_number`, `created_at`, `updated_at`) VALUES
(8, '61d17f5e76212.png', 'http://example.com/', 1, '2022-01-02 04:33:02', '2022-07-06 23:24:01'),
(9, '61d17f68437f9.png', 'http://example.com/', 2, '2022-01-02 04:33:12', '2022-07-06 23:21:13'),
(10, '61d17f724771f.png', 'http://example.com/', 3, '2022-01-02 04:33:22', '2022-07-06 23:24:33'),
(11, '61d17f8069bc7.png', 'http://example.com/', 4, '2022-01-02 04:33:36', '2022-07-06 23:25:11'),
(12, '61d17f8ba9ef8.png', 'http://example.com/', 5, '2022-01-02 04:33:47', '2022-07-06 23:19:30'),
(17, '61d17f68437f9.png', 'http://example.com/', 6, '2022-01-02 04:33:12', '2022-07-06 23:21:13');

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `id` bigint NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `payment_invoices`
--

CREATE TABLE `payment_invoices` (
  `id` bigint UNSIGNED NOT NULL,
  `order_id` bigint UNSIGNED NOT NULL,
  `client_id` bigint UNSIGNED NOT NULL,
  `InvoiceId` bigint UNSIGNED NOT NULL,
  `InvoiceStatus` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `InvoiceValue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Currency` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `InvoiceDisplayValue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `TransactionId` bigint UNSIGNED NOT NULL,
  `TransactionStatus` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `PaymentGateway` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `PaymentId` bigint UNSIGNED NOT NULL,
  `CardNumber` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `popups`
--

CREATE TABLE `popups` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `type` smallint UNSIGNED NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `background_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `background_color_opacity` decimal(3,2) UNSIGNED DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `button_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `delay` int UNSIGNED NOT NULL COMMENT 'value will be in milliseconds',
  `serial_number` mediumint UNSIGNED NOT NULL,
  `status` tinyint UNSIGNED NOT NULL DEFAULT '1' COMMENT '0 => deactive, 1 => active',
  `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 `popups`
--

INSERT INTO `popups` (`id`, `language_id`, `type`, `image`, `name`, `background_color`, `background_color_opacity`, `title`, `text`, `button_text`, `button_color`, `button_url`, `end_date`, `end_time`, `delay`, `serial_number`, `status`, `created_at`, `updated_at`) VALUES
(7, 8, 1, '63035116cdbb8.png', 'Super Sale', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1500, 1, 0, '2021-08-10 05:05:12', '2022-08-22 04:07:58'),
(8, 8, 2, '630353e579d10.png', 'Month End Sale', '000000', 0.70, 'ENJOY 10% OFF', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua.', 'Shop Now', '000000', 'http://example.com/', NULL, NULL, 2000, 2, 0, '2021-08-10 05:07:11', '2022-08-22 04:14:19'),
(10, 8, 3, '6303575ae73a2.png', 'Summer Sale', 'FF8C00', 0.85, 'Newsletter', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua.', 'Subscribe', 'FF8C00', NULL, NULL, NULL, 2000, 3, 0, '2021-08-11 05:42:11', '2022-08-22 04:17:27'),
(11, 8, 4, '630358d59cd94.png', 'Winter Offer', NULL, NULL, 'Get 10% off your first order', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt', 'Shop Now', 'FF8C00', 'http://example.com/', NULL, NULL, 1500, 4, 0, '2021-08-11 06:38:08', '2022-08-22 04:23:05'),
(12, 8, 5, '6303592c51003.png', 'Winter Sale', NULL, NULL, 'Get 10% off your first order', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt', 'Subscribe', 'F8960D', NULL, NULL, NULL, 2000, 5, 0, '2021-08-11 06:44:26', '2023-12-24 01:23:39'),
(13, 8, 6, '63035e25b0dce.png', 'New Arrivals Sale', NULL, NULL, 'Hurry, Sales Ends This Friday', 'This is your last chance to save 30%', 'Yes, I Want to Save 30%', 'F4A460', 'http://example.com/', '2024-07-25', '10:00:00', 2000, 6, 0, '2021-08-11 06:48:52', '2024-03-21 00:49:47'),
(14, 8, 7, '63035bac6f1e1.png', 'Flash Sale', 'CD853F', NULL, 'Hurry, Sale Ends This Friday', 'This is your last chance to save 30%', 'Yes, I Want to Save 30%', 'F4A460', 'http://example.com/', '2025-01-14', '12:00:00', 1500, 7, 0, '2021-08-11 07:15:16', '2024-03-21 00:49:44'),
(19, 9, 1, '61a6f917913f2.jpg', 'الجمعة السوداء', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1500, 1, 0, '2021-11-30 22:24:55', '2022-08-20 01:17:50');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint UNSIGNED NOT NULL,
  `vendor_id` bigint DEFAULT NULL,
  `product_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `featured_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slider_images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `input_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stock` int UNSIGNED DEFAULT NULL,
  `sku` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_price` decimal(8,2) UNSIGNED NOT NULL,
  `previous_price` decimal(8,2) UNSIGNED DEFAULT NULL,
  `average_rating` decimal(4,2) UNSIGNED DEFAULT '0.00',
  `is_featured` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `vendor_id`, `product_type`, `featured_image`, `slider_images`, `status`, `input_type`, `file`, `link`, `stock`, `sku`, `current_price`, `previous_price`, `average_rating`, `is_featured`, `created_at`, `updated_at`) VALUES
(21, NULL, 'physical', '62e1174b98d08.png', '[\"62e117448087c.png\",\"62e11744865b8.png\",\"62e11744b2c86.png\",\"62e11744b30a5.png\"]', 'show', NULL, NULL, NULL, 12, 'DRI-RED-987', 75.00, 120.00, 0.00, 'yes', '2022-01-09 02:37:18', '2022-08-29 01:32:29'),
(24, NULL, 'physical', '62e117999c388.png', '[\"62e117a89a6d3.png\",\"62e117a89d0bd.png\",\"62e117a8c6695.png\",\"62e117a8c6bf0.png\"]', 'show', NULL, NULL, NULL, 19, 'SAW-ORG-789', 300.00, 350.00, 0.00, 'yes', '2022-01-10 02:34:41', '2024-03-04 05:33:39'),
(25, NULL, 'physical', '62e118a917c6f.png', '[\"62e1184ee7aa6.png\",\"62e1184eeb4ef.png\",\"62e1184f2b0cb.png\",\"62e1184f2b1f5.png\"]', 'show', NULL, NULL, NULL, 5, 'GEN-YEL-678', 190.00, NULL, 5.00, 'yes', '2022-01-10 02:46:55', '2024-04-30 07:48:13'),
(29, NULL, 'physical', '62e11b00a9484.png', '[\"62e11a8d9b428.png\",\"62e11a8da0be6.png\",\"62e11a8dc52ad.png\",\"62e11a8dc97eb.png\"]', 'show', NULL, NULL, NULL, 23, 'SAW-RED-678', 45.00, NULL, 0.00, 'yes', '2022-07-27 05:01:20', '2024-03-04 05:33:39'),
(30, NULL, 'physical', '62e122deadfd4.png', '[\"62e1226f75348.png\",\"62e1226f75345.png\",\"62e1226f9db5f.png\",\"62e1226fa1737.png\"]', 'show', NULL, NULL, NULL, 16, 'GRI-BLU-567', 89.00, 129.00, 3.00, 'yes', '2022-07-27 05:34:54', '2024-03-05 07:18:51'),
(31, NULL, 'physical', '62e4d8f9a5dbe.png', '[\"62e4d852dd5c8.png\",\"62e4d852dd5eb.png\",\"62e4d8530e69f.png\",\"62e4d85311dcb.png\"]', 'show', NULL, NULL, NULL, 26, 'BOX-BLA-456', 79.00, NULL, 0.00, 'no', '2022-07-30 01:08:41', '2022-12-22 04:57:21'),
(32, NULL, 'physical', '62e4d9f8766f7.png', '[\"62e4d98bd1320.png\",\"62e4d98bd3661.png\",\"62e4d98c04329.png\",\"62e4d98c078ea.png\"]', 'show', NULL, NULL, NULL, 8, 'PLU-RED-345', 15.00, 20.00, 0.00, 'no', '2022-07-30 01:12:56', '2022-10-05 06:13:51'),
(33, NULL, 'physical', '62e4dac2ade7a.png', '[\"62e4da4fa88d2.png\",\"62e4da4fa9386.png\",\"62e4da4fd463d.png\",\"62e4da4fd47e6.png\"]', 'show', NULL, NULL, NULL, 28, 'MUL-ORA-345', 25.00, 29.00, 0.00, 'no', '2022-07-30 01:16:18', '2024-03-05 06:43:08'),
(34, NULL, 'physical', '62e4dbc8b0922.png', '[\"62e4db5eb2bbb.png\",\"62e4db5eb403c.png\",\"62e4db5ed9444.png\",\"62e4db5edcd14.png\"]', 'show', NULL, NULL, NULL, 13, 'POL-YEL-234', 150.00, 165.00, 0.00, 'no', '2022-07-30 01:20:40', '2022-12-22 04:16:18'),
(35, NULL, 'physical', '62e4dd175f0d5.png', '[\"62e4dc6fdf7e8.png\",\"62e4dc6fe2363.png\",\"62e4dc7013ad0.png\",\"62e4dc701962b.png\"]', 'show', NULL, NULL, NULL, 8, 'GEN-RED-123', 250.00, NULL, 4.00, 'no', '2022-07-30 01:26:15', '2024-05-11 08:36:09'),
(40, NULL, 'digital', '63036c1d345c5.png', '[\"6303656c0f0e5.png\",\"6303656c16c32.png\",\"6303656c34881.png\",\"6303656c3c723.png\"]', 'show', 'link', NULL, 'http://www.example.com/', NULL, NULL, 10.00, NULL, 0.00, 'no', '2022-08-22 05:19:23', '2022-08-22 05:44:29'),
(41, NULL, 'digital', '630464edbee87.png', '[\"63036cc7147dd.png\",\"63036cc717322.png\",\"63036cc73a2ac.png\",\"63036cc73c1d1.png\"]', 'show', 'link', NULL, 'http://www.example.com/', NULL, NULL, 15.00, 23.00, 0.00, 'no', '2022-08-22 05:49:18', '2022-08-22 23:26:05'),
(42, 7, 'digital', '634fc21dad782.jpg', '[\"634fc16a6edb2.jpg\",\"634fc19198513.jpg\"]', 'show', 'link', NULL, 'https://www.youtube.com/watch?v=S9uiof1H_Kg', NULL, NULL, 100.00, 120.00, 5.00, 'no', '2022-10-19 03:23:41', '2022-12-11 01:13:08');

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

--
-- Table structure for table `product_categories`
--

CREATE TABLE `product_categories` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint UNSIGNED NOT NULL,
  `serial_number` mediumint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_categories`
--

INSERT INTO `product_categories` (`id`, `language_id`, `name`, `slug`, `status`, `serial_number`, `created_at`, `updated_at`) VALUES
(27, 8, 'Cordless Tools', 'cordless-tools', 1, 1, '2022-01-05 23:32:06', '2022-08-27 23:40:53'),
(28, 8, 'Generator', 'generator', 1, 2, '2022-01-05 23:32:19', '2022-08-27 23:41:02'),
(30, 9, 'أدوات لاسلكية', 'أدوات-لاسلكية', 1, 1, '2022-01-05 23:34:56', '2022-08-27 23:41:28'),
(31, 9, 'مولد كهرباء', 'مولد-كهرباء', 1, 2, '2022-01-05 23:35:23', '2022-08-27 23:41:37'),
(34, 8, 'SAW', 'saw', 1, 3, '2022-01-10 01:24:32', '2022-08-27 23:41:05'),
(35, 9, 'منشار', 'منشار', 1, 3, '2022-01-10 01:25:26', '2022-08-27 23:41:40'),
(42, 8, 'Grinders & Polishers', 'grinders-&-polishers', 1, 4, '2022-07-27 05:32:22', '2022-08-27 23:41:07'),
(43, 9, 'المطاحن وأجهزة التلميع', 'المطاحن-وأجهزة-التلميع', 1, 4, '2022-07-27 05:32:43', '2022-08-27 23:41:44'),
(48, 8, 'Book', 'book', 1, 5, '2022-08-22 05:19:53', '2022-08-27 23:41:10'),
(49, 9, 'الكتاب', 'الكتاب', 1, 5, '2022-08-22 05:20:20', '2022-08-27 23:41:47');

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

--
-- Table structure for table `product_contents`
--

CREATE TABLE `product_contents` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `product_category_id` bigint UNSIGNED NOT NULL,
  `product_id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `summary` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 `product_contents`
--

INSERT INTO `product_contents` (`id`, `language_id`, `product_category_id`, `product_id`, `title`, `slug`, `summary`, `content`, `meta_keywords`, `meta_description`, `created_at`, `updated_at`) VALUES
(41, 9, 30, 21, 'آلة الحفر', 'آلة-الحفر', 'علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .', '<div style=\"text-align:justify;\"><font>لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</font></div>', NULL, NULL, '2022-01-09 02:37:18', '2022-08-01 04:34:23'),
(42, 8, 27, 21, 'Drill Machine', 'drill-machine', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>', NULL, NULL, '2022-01-09 02:37:18', '2022-08-01 04:34:23'),
(45, 9, 35, 24, 'المنشار', 'المنشار', 'علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .', '<span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br />', NULL, NULL, '2022-01-10 02:34:41', '2022-08-01 04:36:19'),
(46, 8, 34, 24, 'Chainsaw', 'chainsaw', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', '<span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br />', NULL, NULL, '2022-01-10 02:34:41', '2022-08-01 04:36:19'),
(47, 9, 31, 25, 'مولد كهرباء', 'مولد-كهرباء', 'علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .', '<div style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.<br /></div>', NULL, NULL, '2022-01-10 02:46:56', '2022-08-01 04:36:55'),
(48, 8, 28, 25, 'Generator', 'generator', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', '<span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br />', NULL, NULL, '2022-01-10 02:46:56', '2022-08-01 04:36:55'),
(55, 9, 35, 29, 'منشار دائري', 'منشار-دائري', 'علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .', '<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>', NULL, NULL, '2022-07-27 05:01:20', '2022-08-01 04:37:48'),
(56, 8, 34, 29, 'Circular saw', 'circular-saw', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>', NULL, NULL, '2022-07-27 05:01:20', '2022-08-01 04:37:48'),
(57, 9, 43, 30, 'آلة طحن', 'آلة-طحن', 'علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .', '<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>', NULL, NULL, '2022-07-27 05:34:55', '2022-08-01 04:39:09'),
(58, 8, 42, 30, 'Grinding Machine', 'grinding-machine', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>', NULL, NULL, '2022-07-27 05:34:55', '2022-08-01 04:39:09'),
(59, 9, 30, 31, 'كل ذلك في صندوق أدوات واحد', 'كل-ذلك-في-صندوق-أدوات-واحد', 'علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .', '<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>', NULL, NULL, '2022-07-30 01:08:41', '2022-08-01 04:40:14'),
(60, 8, 27, 31, 'All in One Tool Box', 'all-in-one-tool-box', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>', NULL, NULL, '2022-07-30 01:08:41', '2022-08-01 04:40:14'),
(61, 9, 30, 32, 'كاتنج بلس', 'كاتنج-بلس', 'علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .', '<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>', NULL, NULL, '2022-07-30 01:12:56', '2022-08-01 04:41:20'),
(62, 8, 27, 32, 'Cutting Plus', 'cutting-plus', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>', NULL, NULL, '2022-07-30 01:12:56', '2022-08-01 04:41:20'),
(63, 9, 30, 33, 'جهاز رقمي متعدد', 'جهاز-رقمي-متعدد', 'علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .', '<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>', NULL, NULL, '2022-07-30 01:16:18', '2022-08-01 04:42:13'),
(64, 8, 27, 33, 'Digital Multimeter', 'digital-multimeter', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>', NULL, NULL, '2022-07-30 01:16:18', '2022-08-01 04:42:13'),
(65, 9, 43, 34, 'غسالة بوش AQT 37-13 Plus 1700 وات للمنزل والسيارة', 'غسالة-بوش-aqt-37-13-plus-1700-وات-للمنزل-والسيارة', 'علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .', '<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>', NULL, NULL, '2022-07-30 01:20:40', '2022-08-01 04:43:01'),
(66, 8, 42, 34, 'Bosch AQT 37-13 Plus 1700-Watt Home and Car Washer', 'bosch-aqt-37-13-plus-1700-watt-home-and-car-washer', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>', NULL, NULL, '2022-07-30 01:20:40', '2022-08-01 04:43:01'),
(67, 9, 31, 35, 'ماكينة لحام SEALEY Professional Mighty MIG', 'ماكينة-لحام-sealey-professional-mighty-mig', 'علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .', '<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>', NULL, NULL, '2022-07-30 01:26:15', '2022-08-01 04:43:54'),
(68, 8, 28, 35, 'SEALEY Professional Mighty MIG Welder', 'sealey-professional-mighty-mig-welder', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>', NULL, NULL, '2022-07-30 01:26:15', '2022-08-01 04:43:54'),
(77, 8, 48, 40, 'Manual Guide', 'manual-guide', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>', NULL, NULL, '2022-08-22 05:19:24', '2022-08-22 05:21:10'),
(78, 9, 49, 40, 'دليل اليدوي', 'دليل-اليدوي', 'علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .', '<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>', NULL, NULL, '2022-08-22 05:19:24', '2022-08-22 05:21:10'),
(79, 8, 48, 41, 'User Manual Book', 'user-manual-book', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', '<p><span style=\"font-family:\'Open Sans\', Arial, sans-serif;text-align:justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span><br /></p>', NULL, NULL, '2022-08-22 05:49:18', '2022-08-22 05:49:18'),
(80, 9, 49, 41, 'كتاب دليل المستخدم', 'كتاب-دليل-المستخدم', 'علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .', '<p><span style=\"text-align:justify;\">لكن لا بد أن أوضح لك أن كل هذه الأفكار المغلوطة حول استنكار  النشوة وتمجيد الألم نشأت بالفعل، وسأعرض لك التفاصيل لتكتشف حقيقة وأساس تلك السعادة البشرية، فلا أحد يرفض أو يكره أو يتجنب الشعور بالسعادة، ولكن بفضل هؤلاء الأشخاص الذين لا يدركون بأن السعادة لا بد أن نستشعرها بصورة أكثر عقلانية ومنطقية فيعرضهم هذا لمواجهة الظروف الأليمة، وأكرر بأنه لا يوجد من يرغب في الحب ونيل المنال ويتلذذ بالآلام، الألم هو الألم ولكن نتيجة لظروف ما قد تكمن السعاده فيما نتحمله من كد وأسي.</span><br /></p>', NULL, NULL, '2022-08-22 05:49:18', '2022-08-22 05:49:18'),
(81, 8, 27, 42, 'EOS R7 (Body)', 'eos-r7-(body)', 'EOS R7 (Body)EOS R7 (Body)EOS R7 (R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)', '<p>EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)<br /></p>', 'dsfs', 'dfsdfssdfsdfsdfsdf', '2022-10-19 03:23:42', '2022-10-19 03:23:42'),
(82, 9, 35, 42, 'EOS R7 (Body)', 'eos-r7-(body)', 'EOS R7 (Body)EOS R7 (Body)EOS R7 (R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)', '<p>EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)EOS R7 (Body)<br /></p>', 'dsfs', 'dfsdfssdfsdfsdfsdf', '2022-10-19 03:23:42', '2022-10-19 03:23:42');

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

--
-- Table structure for table `product_coupons`
--

CREATE TABLE `product_coupons` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` decimal(8,2) UNSIGNED NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `minimum_spend` decimal(8,2) UNSIGNED 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 `product_coupons`
--

INSERT INTO `product_coupons` (`id`, `name`, `code`, `type`, `value`, `start_date`, `end_date`, `minimum_spend`, `created_at`, `updated_at`) VALUES
(7, 'Sell30', 'Sell30', 'fixed', 30.00, '2022-07-01', '2022-08-31', NULL, '2022-01-05 22:25:33', '2022-08-27 06:04:39'),
(8, 'WinterSell', 'WinterSell', 'percentage', 25.00, '2022-07-19', '2022-10-20', 50.00, '2022-01-05 22:27:46', '2022-08-28 05:56:20'),
(9, 'FridaySell', 'FridaySell', 'fixed', 20.00, '2021-12-25', '2021-12-31', NULL, '2022-01-05 22:29:40', '2022-01-05 22:29:40');

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

--
-- Table structure for table `product_orders`
--

CREATE TABLE `product_orders` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `order_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_first_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_last_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_contact_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_first_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_last_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_contact_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` decimal(8,2) UNSIGNED NOT NULL,
  `discount` decimal(8,2) UNSIGNED DEFAULT NULL,
  `product_shipping_charge_id` bigint UNSIGNED DEFAULT NULL,
  `shipping_cost` decimal(8,2) UNSIGNED DEFAULT NULL,
  `tax` decimal(8,2) UNSIGNED NOT NULL,
  `grand_total` decimal(8,2) UNSIGNED NOT NULL,
  `currency_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_text_position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_symbol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_symbol_position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `gateway_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `conversation_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_orders`
--

INSERT INTO `product_orders` (`id`, `user_id`, `order_number`, `billing_first_name`, `billing_last_name`, `billing_email`, `billing_contact_number`, `billing_address`, `billing_city`, `billing_state`, `billing_country`, `shipping_first_name`, `shipping_last_name`, `shipping_email`, `shipping_contact_number`, `shipping_address`, `shipping_city`, `shipping_state`, `shipping_country`, `total`, `discount`, `product_shipping_charge_id`, `shipping_cost`, `tax`, `grand_total`, `currency_text`, `currency_text_position`, `currency_symbol`, `currency_symbol_position`, `payment_method`, `gateway_type`, `payment_status`, `order_status`, `attachment`, `invoice`, `created_at`, `updated_at`, `conversation_id`) VALUES
(56, 25, '6645f7d024876', '5QhV9W6bMB', 'LgMgdbwQlg', 'faltusone@gmail.com', '3963304663', 'sYmML6b8sd', 'hnrRygLiNV', 'RmUpQDW95H', 'xx6lySr2sT', 'faltu', 'sone', 'cadene3194@etopys.com', '03772527153', 'aErcia8ngs', 'L1syr6LRem', '545', 'Bangladesh', 15.00, 0.00, NULL, NULL, 0.75, 15.75, 'TRY', 'left', '$', 'left', 'Iyzico', 'online', 'completed', 'pending', NULL, '6645f7d024876.pdf', '2024-05-16 06:10:56', '2024-05-16 06:26:16', '99996645f798e8c263.90864725'),
(57, 25, '664ad0c4e6fc4', '5QhV9W6bMB', 'LgMgdbwQlg', 'faltusone@gmail.com', '3963304663', 'sYmML6b8sd', 'hnrRygLiNV', 'RmUpQDW95H', 'xx6lySr2sT', 'Spartan', 'Sara', 'faltusone@gmail.com', '05403356730', 'CewpQ8MdjP', 'yaSy1lGL0O', '545', 'Bangladesh', 100.00, 0.00, NULL, NULL, 5.00, 105.00, 'IDR', 'left', '$', 'left', 'Midtrans', 'online', 'completed', 'pending', NULL, '664ad0c4e6fc4.pdf', '2024-05-19 22:25:40', '2024-05-19 22:25:54', NULL);

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

--
-- Table structure for table `product_purchase_items`
--

CREATE TABLE `product_purchase_items` (
  `id` bigint UNSIGNED NOT NULL,
  `product_order_id` bigint UNSIGNED NOT NULL,
  `product_id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` int UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_purchase_items`
--

INSERT INTO `product_purchase_items` (`id`, `product_order_id`, `product_id`, `title`, `quantity`, `created_at`, `updated_at`) VALUES
(65, 56, 41, 'User Manual Book', 1, '2024-05-16 06:10:56', '2024-05-16 06:10:56'),
(66, 57, 42, 'EOS R7 (Body)', 1, '2024-05-19 22:25:40', '2024-05-19 22:25:40');

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

--
-- Table structure for table `product_reviews`
--

CREATE TABLE `product_reviews` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `product_id` bigint UNSIGNED NOT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `rating` smallint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_reviews`
--

INSERT INTO `product_reviews` (`id`, `user_id`, `product_id`, `comment`, `rating`, `created_at`, `updated_at`) VALUES
(9, 15, 25, '.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn.equipement-sidebar-info .booking-form .pricing-body .price-option span.span-btn', 5, '2022-07-28 04:02:57', '2022-07-28 04:02:57'),
(10, 15, 30, 'The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', 3, '2022-07-30 05:48:05', '2022-07-30 05:48:05'),
(11, 15, 35, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.', 4, '2022-07-30 05:51:04', '2022-07-30 05:51:04');

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

--
-- Table structure for table `product_sections`
--

CREATE TABLE `product_sections` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 `product_sections`
--

INSERT INTO `product_sections` (`id`, `language_id`, `subtitle`, `title`, `text`, `created_at`, `updated_at`) VALUES
(2, 8, 'Featured Products', 'Best Quality Product', 'Amet minim mollit non deserunt ullamco est sit aliqua dolor do amet sint. Velit officia consequat duis enim velit mollit.', '2022-02-28 04:27:50', '2022-07-30 04:54:33'),
(3, 9, 'أفضل منتج عالي الجودة', 'منتجات مميزة', 'تبرع: إن كنت تستخدم هذا الموقع بشكل دائم وترغب في مساعدته، أرجو التبرع ولو بمبلغ بسيط للمساعدة في دفع أجور استضافة الموقع وأجور نقل البيانات. لا يوجد حد أدنى للتبرع، سنكون ممتنين لأي مبلغ', '2022-03-06 00:36:22', '2022-03-06 00:36:22');

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

--
-- Table structure for table `product_shipping_charges`
--

CREATE TABLE `product_shipping_charges` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_charge` decimal(8,2) UNSIGNED NOT NULL,
  `serial_number` smallint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_shipping_charges`
--

INSERT INTO `product_shipping_charges` (`id`, `language_id`, `title`, `short_text`, `shipping_charge`, `serial_number`, `created_at`, `updated_at`) VALUES
(5, 8, 'Free Shipping', 'Shipment will be within 10-15 Days.', 0.00, 1, '2021-07-04 00:31:50', '2021-07-19 01:33:50'),
(6, 8, 'Standard Shipping', 'Shipment will be within 5-10 Day.', 5.00, 2, '2021-07-04 00:32:40', '2021-07-04 00:32:40'),
(7, 8, '2-Day Shipping', 'Shipment will be within 2 Days.', 10.00, 3, '2021-07-04 00:33:24', '2021-07-04 00:33:24'),
(8, 8, 'Same Day Shipping', 'Shipment will be within 1 Day.', 20.00, 4, '2021-07-04 00:34:09', '2021-07-04 00:34:09'),
(9, 9, 'الشحن مجانا', 'ستكون الشحنة في غضون 10-15 يومًا.', 0.00, 1, '2021-08-29 06:09:43', '2021-08-29 06:09:43'),
(10, 9, 'شحن قياسي', 'سيتم الشحن في غضون 5-10 يوم.', 5.00, 2, '2021-08-29 06:11:01', '2021-08-29 06:11:01'),
(11, 9, 'شحن لمدة يومين', 'ستكون الشحنة في غضون يومين.', 10.00, 3, '2021-08-29 06:12:14', '2021-08-29 06:12:14'),
(12, 9, 'نفس الشحن يوم', 'ستكون الشحنة في غضون يوم واحد.', 20.00, 4, '2021-08-29 06:13:30', '2021-08-29 06:13:30');

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

--
-- Table structure for table `push_subscriptions`
--

CREATE TABLE `push_subscriptions` (
  `id` bigint UNSIGNED NOT NULL,
  `subscribable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subscribable_id` bigint UNSIGNED NOT NULL,
  `endpoint` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `public_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `auth_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_encoding` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `quick_links`
--

CREATE TABLE `quick_links` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `serial_number` smallint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quick_links`
--

INSERT INTO `quick_links` (`id`, `language_id`, `title`, `url`, `serial_number`, `created_at`, `updated_at`) VALUES
(3, 8, 'Privacy & Policy', 'http://example.com/', 1, '2021-06-22 22:52:38', '2021-12-01 04:14:35'),
(4, 8, 'About Me', 'http://example.com/', 2, '2021-06-22 22:53:09', '2021-12-01 04:14:55'),
(5, 8, 'Contact', 'http://example.com/', 3, '2021-06-22 22:53:27', '2021-12-01 04:15:26'),
(6, 9, 'سياسة خاصة', 'http://example.com/', 1, '2021-08-29 07:04:05', '2021-12-01 04:16:18'),
(7, 9, 'عني', 'http://example.com/', 2, '2021-08-29 07:06:32', '2021-12-01 04:16:34'),
(8, 9, 'اتصل', 'http://example.com/', 3, '2021-08-29 07:08:21', '2021-12-01 04:16:52');

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

--
-- Table structure for table `role_permissions`
--

CREATE TABLE `role_permissions` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `permissions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 `role_permissions`
--

INSERT INTO `role_permissions` (`id`, `name`, `permissions`, `created_at`, `updated_at`) VALUES
(4, 'Admin', '[\"Language Management\",\"Basic Settings\",\"Home Page\",\"Instructors\",\"Course Management\",\"Course Enrolments\",\"FAQ Management\",\"Footer\"]', '2021-08-06 22:42:38', '2021-11-24 23:20:08'),
(6, 'Moderator', '[\"Basic Settings\",\"Home Page\",\"Course Enrolments\",\"Blog Management\",\"FAQ Management\",\"Advertisements\",\"Footer\"]', '2021-08-07 22:14:34', '2021-11-24 22:15:07'),
(14, 'Supervisor', 'null', '2021-11-24 22:48:53', '2022-02-26 05:23:44');

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

--
-- Table structure for table `sections`
--

CREATE TABLE `sections` (
  `id` bigint UNSIGNED NOT NULL,
  `about_section_status` tinyint UNSIGNED NOT NULL DEFAULT '1',
  `work_process_section_status` tinyint UNSIGNED NOT NULL DEFAULT '1',
  `feature_section_status` tinyint UNSIGNED NOT NULL DEFAULT '1',
  `counter_section_status` tinyint UNSIGNED NOT NULL DEFAULT '1',
  `equipment_section_status` tinyint UNSIGNED NOT NULL DEFAULT '1',
  `featured_equipment_section_status` bigint DEFAULT '1',
  `testimonial_section_status` tinyint UNSIGNED NOT NULL DEFAULT '1',
  `product_section_status` tinyint UNSIGNED NOT NULL DEFAULT '1',
  `call_to_action_section_status` tinyint UNSIGNED NOT NULL DEFAULT '1',
  `blog_section_status` tinyint UNSIGNED NOT NULL DEFAULT '1',
  `partner_section_status` tinyint UNSIGNED NOT NULL DEFAULT '1',
  `subscribe_section_status` tinyint UNSIGNED NOT NULL DEFAULT '1',
  `footer_section_status` tinyint UNSIGNED NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `video_section_status` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sections`
--

INSERT INTO `sections` (`id`, `about_section_status`, `work_process_section_status`, `feature_section_status`, `counter_section_status`, `equipment_section_status`, `featured_equipment_section_status`, `testimonial_section_status`, `product_section_status`, `call_to_action_section_status`, `blog_section_status`, `partner_section_status`, `subscribe_section_status`, `footer_section_status`, `created_at`, `updated_at`, `video_section_status`) VALUES
(2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, '2024-06-04 05:16:42', 1);

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

--
-- Table structure for table `security_deposit_refunds`
--

CREATE TABLE `security_deposit_refunds` (
  `id` bigint UNSIGNED NOT NULL,
  `booking_id` bigint DEFAULT NULL,
  `refund_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `partial_amount` double(8,2) DEFAULT '0.00',
  `status` int DEFAULT '0' COMMENT '0=pending, 1=aggree, raise dispute',
  `refund_status` int DEFAULT '0' COMMENT '0=pending, 1=refunded',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `sliders` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `background_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 `sliders`
--

INSERT INTO `sliders` (`id`, `language_id`, `background_image`, `title`, `text`, `created_at`, `updated_at`) VALUES
(4, 9, '66857e305c035.png', 'أفضل معدات البناء', 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها.', '2022-01-03 05:32:11', '2024-07-03 10:37:04'),
(5, 9, '66857e2a527ca.png', 'أفضل معدات البناء', 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها.', '2022-01-03 05:32:33', '2024-07-03 10:36:58'),
(7, 8, '63b1793774949.png', 'Best Construction Equipment', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.', '2022-03-06 00:16:33', '2023-01-01 06:14:47'),
(8, 8, '63b1793e1f09d.png', 'Best Harvesting Equipment', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.', '2022-03-06 00:17:21', '2024-03-21 01:13:22');

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

--
-- Table structure for table `social_medias`
--

CREATE TABLE `social_medias` (
  `id` bigint UNSIGNED NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `serial_number` mediumint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `social_medias`
--

INSERT INTO `social_medias` (`id`, `icon`, `url`, `serial_number`, `created_at`, `updated_at`) VALUES
(36, 'fab fa-facebook-f', 'http://example.com/', 1, '2021-11-20 03:01:42', '2021-11-20 03:01:42'),
(37, 'fab fa-twitter', 'http://example.com/', 3, '2021-11-20 03:03:22', '2021-11-20 03:03:22'),
(38, 'fab fa-linkedin-in', 'http://example.com/', 2, '2021-11-20 03:04:29', '2021-11-20 03:04:29');

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

--
-- Table structure for table `static_sections`
--

CREATE TABLE `static_sections` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `button_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `static_sections`
--

INSERT INTO `static_sections` (`id`, `language_id`, `title`, `text`, `button_name`, `button_url`, `created_at`, `updated_at`) VALUES
(3, 9, 'أفضل معدات البناء', 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها.', 'يكتشف', 'http://example.com/', '2022-02-28 00:24:35', '2022-08-01 03:22:23'),
(4, 8, 'Best Construction Equipment', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.', 'Discover', 'http://example.com/', '2022-03-06 00:18:59', '2022-08-01 03:21:48');

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

--
-- Table structure for table `subscribers`
--

CREATE TABLE `subscribers` (
  `id` bigint UNSIGNED NOT NULL,
  `email_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscribers`
--

INSERT INTO `subscribers` (`id`, `email_id`, `created_at`, `updated_at`) VALUES
(1, 'locani4368@bikedid.com', '2023-12-28 03:28:11', '2023-12-28 03:28:11'),
(2, 'faltusone@gmail.com', '2024-03-21 01:25:13', '2024-03-21 01:25:13');

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

--
-- Table structure for table `support_tickets`
--

CREATE TABLE `support_tickets` (
  `id` bigint UNSIGNED NOT NULL,
  `vendor_id` int NOT NULL,
  `admin_id` int DEFAULT NULL,
  `ticket_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `attachment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-pending, 2-open, 3-closed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `last_message` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `support_tickets`
--

INSERT INTO `support_tickets` (`id`, `vendor_id`, `admin_id`, `ticket_number`, `email`, `subject`, `description`, `attachment`, `status`, `created_at`, `updated_at`, `last_message`) VALUES
(10, 23, NULL, '63b2b7b85c63b', 'megasoft.envato@gmail.com', 'Payment Rejected', 'Lorem Ipsum dummy text', '63b2b7b85bb56.zip', 1, '2023-01-02 04:53:44', '2023-01-02 04:53:44', NULL);

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

--
-- Table structure for table `support_ticket_statuses`
--

CREATE TABLE `support_ticket_statuses` (
  `id` bigint UNSIGNED NOT NULL,
  `support_ticket_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `support_ticket_statuses`
--

INSERT INTO `support_ticket_statuses` (`id`, `support_ticket_status`, `created_at`, `updated_at`) VALUES
(1, 'active', '2022-06-25 03:52:18', '2022-11-01 05:22:50');

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

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

CREATE TABLE `testimonials` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `occupation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `language_id`, `image`, `name`, `occupation`, `comment`, `created_at`, `updated_at`) VALUES
(5, 9, '65fc0e49c0c3d.jpg', 'توماس زينكس', 'رجل اعمال', 'علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .', '2022-01-01 23:18:57', '2024-03-21 04:39:05'),
(6, 9, '65fc0e3ddf034.png', 'فلان الفلاني', 'باني', 'علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .', '2022-01-01 23:19:58', '2024-03-21 04:38:53'),
(7, 9, '65fc0e299e2bb.png', 'اشلي هيرت', 'عامل', 'علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .', '2022-01-01 23:20:11', '2024-03-21 04:38:33'),
(13, 8, '62e7a1af39822.jpg', 'Tomas Zinks', 'Businessman', 'Duis leo. Sed fringilla mauris sit amibh. Donec sodales sagittis magna. Sed consequat goos services.', '2022-03-06 01:45:48', '2022-08-01 03:49:35'),
(14, 8, '62249ae91459e.png', 'John Doe', 'Builder', 'Duis leo. Sed fringilla mauris sit amibh. Donec sodales sagittis magna. Sed consequat goos services.', '2022-03-06 01:46:33', '2022-08-01 03:50:04'),
(15, 8, '62249adfe34e9.png', 'Ashley Hurt', 'Worker', 'Duis leo. Sed fringilla mauris sit amibh. Donec sodales sagittis magna. Sed consequat goos services.', '2022-03-06 01:47:07', '2022-08-01 03:50:32'),
(16, 9, '65fc0e1d3ef63.jpg', 'البظر المصب', 'عميل التأجير', 'علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .', '2022-07-27 00:51:54', '2024-03-21 04:38:21'),
(17, 9, '65fc0e0e6a9f3.jpg', 'دونالد جيمس', 'عميل التأجير', 'علي الجانب الآخر نشجب ونستنكر هؤلاء الرجال المفتونون بنشوة اللحظة الهائمون في رغباتهم فلا يدركون ما يعقبها من الألم والأسي المحتم، واللوم كذلك يشمل هؤلاء الذين أخفقوا في واجباتهم نتيجة لضعف إرادتهم فيتساوي مع هؤلاء الذين يتجنبون وينأون عن تحمل الكدح والألم .', '2022-07-27 00:52:18', '2024-03-21 04:38:06'),
(18, 8, '62e7a20e31e53.jpg', 'Mohona Clitar', 'Rental Customer', 'Duis leo. Sed fringilla mauris sit amibh. Donec sodales sagittis magna. Sed consequat goos services.', '2022-08-01 03:51:10', '2022-08-01 03:51:10'),
(19, 8, '62e7a22bd2e29.jpg', 'Donald James', 'Rental Customer', 'Duis leo. Sed fringilla mauris sit amibh. Donec sodales sagittis magna. Sed consequat goos services.', '2022-08-01 03:51:39', '2022-08-01 03:51:39');

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

--
-- Table structure for table `testimonial_sections`
--

CREATE TABLE `testimonial_sections` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `testimonial_section_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `testimonial_section_image_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonial_sections`
--

INSERT INTO `testimonial_sections` (`id`, `language_id`, `subtitle`, `title`, `created_at`, `updated_at`, `testimonial_section_image`, `testimonial_section_image_2`) VALUES
(2, 8, 'Client Feedback', 'What Client Say About Us', '2021-12-30 03:54:24', '2024-01-11 07:59:07', '659ff25b0ed57.png', '659ff42b26eae.png'),
(3, 9, 'ملاحظات العملاء', 'ماذا يقول العميل عنا', '2022-03-06 00:35:29', '2024-03-21 04:32:33', '65fc0cc127314.png', '65f2e6f2608a5.png');

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

--
-- Table structure for table `transcations`
--

CREATE TABLE `transcations` (
  `id` bigint UNSIGNED NOT NULL,
  `transcation_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `booking_id` bigint DEFAULT NULL,
  `transcation_type` int DEFAULT NULL COMMENT '1=Equipment Booking, 2=Withdraw, 3=  balance add, 4 = balance subtract 5 = product order',
  `user_id` bigint DEFAULT NULL,
  `vendor_id` bigint DEFAULT NULL,
  `payment_status` int NOT NULL DEFAULT '0',
  `payment_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `grand_total` double(8,2) DEFAULT NULL,
  `shipping_charge` double(8,2) DEFAULT '0.00',
  `commission` double(8,2) DEFAULT '0.00',
  `tax` double(8,2) DEFAULT '0.00',
  `pre_balance` float(8,2) DEFAULT '0.00',
  `after_balance` float(8,2) DEFAULT '0.00',
  `gateway_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_symbol_position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `security_deposit` double(8,2) DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transcations`
--

INSERT INTO `transcations` (`id`, `transcation_id`, `booking_id`, `transcation_type`, `user_id`, `vendor_id`, `payment_status`, `payment_method`, `grand_total`, `shipping_charge`, `commission`, `tax`, `pre_balance`, `after_balance`, `gateway_type`, `currency_symbol`, `currency_symbol_position`, `created_at`, `updated_at`, `security_deposit`) VALUES
(1, '1672636924', 308, 1, 23, 26, 1, 'PayPal', 335.00, 20.00, 35.00, 35.00, 0.00, 335.00, 'online', '$', 'left', '2023-01-01 23:22:04', '2023-01-01 23:22:04', 0.00),
(2, '1672636976', 309, 1, 23, 25, 1, 'PayPal', 280.00, 10.00, 30.00, 30.00, 0.00, 280.00, 'online', '$', 'left', '2023-01-01 23:22:56', '2023-01-01 23:22:56', 0.00),
(3, '1672637030', 310, 1, 23, 23, 1, 'PayPal', 132.30, NULL, 14.70, 14.70, 0.00, 132.30, 'online', '$', 'left', '2023-01-01 23:23:50', '2023-01-01 23:23:50', 0.00),
(4, '1672637079', 311, 1, 23, 23, 1, 'PayPal', 220.50, NULL, 24.50, 24.50, 132.30, 352.80, 'online', '$', 'left', '2023-01-01 23:24:39', '2023-01-01 23:24:39', 0.00),
(5, '1672637145', 312, 1, 23, 23, 1, 'PayPal', 228.00, 3.00, 25.00, 25.00, 352.80, 580.80, 'online', '$', 'left', '2023-01-01 23:25:45', '2023-01-01 23:25:45', 0.00),
(6, '1672637609', 313, 1, 23, 23, 1, 'PayPal', 135.30, 3.00, 14.70, 14.70, 580.80, 716.10, 'online', '$', 'left', '2023-01-01 23:33:29', '2023-01-01 23:33:29', 0.00),
(7, '1672639997', 315, 1, 23, 23, 1, 'Bank of America', 1350.00, NULL, 150.00, 150.00, 716.10, 2066.10, 'offline', '$', 'left', '2023-01-02 00:13:17', '2023-01-02 00:13:17', 0.00),
(8, '1672640749', 316, 1, 15, 26, 1, 'PayPal', 344.00, 20.00, 36.00, 36.00, 335.00, 679.00, 'online', '$', 'left', '2023-01-02 00:25:49', '2023-01-02 00:25:49', 0.00),
(9, '1672640849', 317, 1, 15, 25, 1, 'PayPal', 360.00, NULL, 40.00, 40.00, 280.00, 640.00, 'online', '$', 'left', '2023-01-02 00:27:29', '2023-01-02 00:27:29', 0.00),
(10, '1672640955', 318, 1, 15, 23, 1, 'PayPal', 220.50, NULL, 24.50, 24.50, 2066.10, 2286.60, 'online', '$', 'left', '2023-01-02 00:29:15', '2023-01-02 00:29:15', 0.00),
(11, '1707750048', 1, 5, NULL, NULL, 1, 'online', 15.75, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-12 09:00:48', '2024-02-12 09:00:48', 0.00),
(12, '1707750224', 2, 5, NULL, NULL, 1, 'online', 131.25, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-12 09:03:44', '2024-02-12 09:03:44', 0.00),
(13, '1707753755', 3, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-12 10:02:35', '2024-02-12 10:02:35', 0.00),
(14, '1707754548', 4, 5, NULL, NULL, 1, 'online', 15.75, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-12 10:15:48', '2024-02-12 10:15:48', 0.00),
(15, '1707908648', 5, 5, NULL, NULL, 1, 'online', 383.25, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-14 05:04:08', '2024-02-14 05:04:08', 0.00),
(16, '1707992095', 6, 5, NULL, NULL, 1, 'online', 120.75, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-15 04:14:55', '2024-02-15 04:14:55', 0.00),
(17, '1707992098', 7, 5, NULL, NULL, 1, 'online', 120.75, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-15 04:14:58', '2024-02-15 04:14:58', 0.00),
(18, '1707995974', 8, 5, NULL, NULL, 1, 'online', 26.25, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-15 05:19:34', '2024-02-15 05:19:34', 0.00),
(19, '1708001562', 9, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-15 06:52:42', '2024-02-15 06:52:42', 0.00),
(20, '1708174849', 10, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-17 07:00:49', '2024-02-17 07:00:49', 0.00),
(21, '1708341789', 11, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-19 05:23:09', '2024-02-19 05:23:09', 0.00),
(22, '1708350751', 12, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-19 07:52:31', '2024-02-19 07:52:31', 0.00),
(23, '1708350938', 13, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-19 07:55:38', '2024-02-19 07:55:38', 0.00),
(24, '1708430679', 14, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-20 06:04:39', '2024-02-20 06:04:39', 0.00),
(25, '1708432501', 15, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-20 06:35:01', '2024-02-20 06:35:01', 0.00),
(26, '1708433130', 16, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-20 06:45:30', '2024-02-20 06:45:30', 0.00),
(27, '1708433130', 17, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-20 06:45:30', '2024-02-20 06:45:30', 0.00),
(28, '1708613875', 321, 1, NULL, 26, 1, 'Midtrans', 162.00, NULL, 18.00, 18.00, 679.00, 841.00, 'online', '$', 'left', '2024-02-22 08:57:55', '2024-02-22 08:57:55', 0.00),
(29, '1708615369', 322, 1, NULL, 26, 1, 'Midtrans', 162.00, NULL, 18.00, 18.00, 841.00, 1003.00, 'online', '$', 'left', '2024-02-22 09:22:49', '2024-02-22 09:22:49', 0.00),
(30, '1708615743', 323, 1, NULL, 26, 1, 'PhonePe', 162.00, NULL, 18.00, 18.00, 1003.00, 1165.00, 'online', '$', 'left', '2024-02-22 09:29:03', '2024-02-22 09:29:03', 0.00),
(31, '1708616018', 324, 1, NULL, 26, 1, 'Toyyibpay', 162.00, NULL, 18.00, 18.00, 1165.00, 1327.00, 'online', '$', 'left', '2024-02-22 09:33:38', '2024-02-22 09:33:38', 0.00),
(32, '1708616207', 325, 1, NULL, 26, 1, 'Paytabs', 162.00, NULL, 18.00, 18.00, 1327.00, 1489.00, 'online', '$', 'left', '2024-02-22 09:36:47', '2024-02-22 09:36:47', 0.00),
(33, '1709112508', 18, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-28 03:28:28', '2024-02-28 03:28:28', 0.00),
(34, '1709114805', 326, 1, 25, 26, 1, 'Myfatoorah', 162.00, NULL, 18.00, 18.00, 1489.00, 1651.00, 'online', '$', 'left', '2024-02-28 04:06:45', '2024-02-28 04:06:45', 0.00),
(35, '1709120201', 19, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-28 05:36:41', '2024-02-28 05:36:41', 0.00),
(36, '1709120311', 20, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-28 05:38:31', '2024-02-28 05:38:31', 0.00),
(37, '1709121771', 21, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-28 06:02:51', '2024-02-28 06:02:51', 0.00),
(38, '1709121971', 22, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-28 06:06:11', '2024-02-28 06:06:11', 0.00),
(39, '1709124147', 23, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-28 06:42:27', '2024-02-28 06:42:27', 0.00),
(40, '1709124264', 24, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-28 06:44:24', '2024-02-28 06:44:24', 0.00),
(41, '1709124988', 25, 5, NULL, NULL, 1, 'online', 210.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-28 06:56:28', '2024-02-28 06:56:28', 0.00),
(42, '1709208640', 26, 5, NULL, NULL, 1, 'online', 630.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-29 06:10:40', '2024-02-29 06:10:40', 0.00),
(43, '1709208661', 27, 5, NULL, NULL, 1, 'online', 630.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-29 06:11:01', '2024-02-29 06:11:01', 0.00),
(44, '1709208772', 28, 5, NULL, NULL, 1, 'online', 630.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-29 06:12:52', '2024-02-29 06:12:52', 0.00),
(45, '1709208773', 29, 5, NULL, NULL, 1, 'online', 630.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-29 06:12:53', '2024-02-29 06:12:53', 0.00),
(46, '1709208783', 30, 5, NULL, NULL, 1, 'online', 630.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-29 06:13:03', '2024-02-29 06:13:03', 0.00),
(47, '1709208953', 32, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-29 06:15:53', '2024-02-29 06:15:53', 0.00),
(48, '1709208974', 33, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-29 06:16:14', '2024-02-29 06:16:14', 0.00),
(49, '1709209018', 34, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-29 06:16:58', '2024-02-29 06:16:58', 0.00),
(50, '1709211010', 327, 1, 25, 26, 1, 'Xendit', 162.00, NULL, 18.00, 18.00, 1651.00, 1813.00, 'online', '$', 'left', '2024-02-29 06:50:10', '2024-02-29 06:50:10', 0.00),
(51, '1709211030', 328, 1, 25, 26, 1, 'Xendit', 162.00, NULL, 18.00, 18.00, 1813.00, 1975.00, 'online', '$', 'left', '2024-02-29 06:50:30', '2024-02-29 06:50:30', 0.00),
(52, '1709213873', 35, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-29 07:37:53', '2024-02-29 07:37:53', 0.00),
(53, '1709213874', 36, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-02-29 07:37:54', '2024-02-29 07:37:54', 0.00),
(54, '1709214007', 329, 1, 25, 26, 1, 'Xendit', 162.00, NULL, 18.00, 18.00, 1975.00, 2137.00, 'online', '$', 'left', '2024-02-29 07:40:07', '2024-02-29 07:40:07', 0.00),
(55, '1709642769', 39, 5, NULL, NULL, 1, 'Citibank', 36.75, 0.00, 0.00, 0.00, NULL, NULL, 'offline', '$', 'left', '2024-03-05 06:46:09', '2024-03-05 06:46:09', 0.00),
(56, '1709643451', 40, 5, NULL, NULL, 1, 'Citibank', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'offline', '$', 'left', '2024-03-05 06:57:31', '2024-03-05 06:57:31', 0.00),
(57, '1709643732', 41, 5, NULL, NULL, 1, 'Citibank', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'offline', '$', 'left', '2024-03-05 07:02:12', '2024-03-05 07:02:12', 0.00),
(58, '1709644025', 42, 5, NULL, NULL, 1, 'Citibank', 15.75, 0.00, 0.00, 0.00, NULL, NULL, 'offline', '$', 'left', '2024-03-05 07:07:05', '2024-03-05 07:07:05', 0.00),
(59, '1709644198', 43, 5, NULL, NULL, 1, 'Citibank', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'offline', '$', 'left', '2024-03-05 07:09:58', '2024-03-05 07:09:58', 0.00),
(60, '1709644743', 44, 5, NULL, NULL, 1, 'Citibank', 93.45, 0.00, 0.00, 0.00, NULL, NULL, 'offline', '$', 'left', '2024-03-05 07:19:03', '2024-03-05 07:19:03', 0.00),
(61, '1709645028', 45, 5, NULL, NULL, 1, 'Citibank', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'offline', '$', 'left', '2024-03-05 07:23:48', '2024-03-05 07:23:48', 0.00),
(62, '1709645107', 46, 5, NULL, NULL, 1, 'Citibank', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'offline', '$', 'left', '2024-03-05 07:25:07', '2024-03-05 07:25:07', 0.00),
(63, '1710141863', 48, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-03-11 01:24:23', '2024-03-11 01:24:23', 0.00),
(64, '1710143261', 49, 5, NULL, NULL, 1, 'online', 15.75, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-03-11 01:47:41', '2024-03-11 01:47:41', 0.00),
(65, '1714478927', 332, 1, NULL, 26, 1, 'Stripe', 243.00, NULL, 27.00, 27.00, 2137.00, 2380.00, 'online', '$', 'left', '2024-04-30 06:08:47', '2024-04-30 06:08:47', 0.00),
(66, '1714482893', 50, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-04-30 07:14:53', '2024-04-30 07:14:53', 0.00),
(67, '1714484156', 333, 1, 25, 26, 1, 'Stripe', 243.00, NULL, 27.00, 27.00, 2380.00, 2623.00, 'online', '$', 'left', '2024-04-30 07:35:56', '2024-04-30 07:35:56', 0.00),
(68, '1714484893', 51, 5, NULL, NULL, 1, 'online', 204.50, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-04-30 07:48:13', '2024-04-30 07:48:13', 0.00),
(69, '1714833415', 340, 1, NULL, 26, 1, 'Iyzico', 324.00, NULL, 36.00, 36.00, 2623.00, 2947.00, 'online', '$', 'left', '2024-05-04 08:36:55', '2024-05-04 08:36:55', 0.00),
(70, '1714833678', 341, 1, NULL, 26, 1, 'Iyzico', 324.00, NULL, 36.00, 36.00, 2947.00, 3271.00, 'online', '$', 'left', '2024-05-04 08:41:19', '2024-05-04 08:41:19', 0.00),
(71, '1714833780', 342, 1, NULL, 26, 1, 'Iyzico', 243.00, NULL, 27.00, 27.00, 3271.00, 3514.00, 'online', '$', 'left', '2024-05-04 08:43:00', '2024-05-04 08:43:00', 0.00),
(72, '1714834155', 343, 1, NULL, 26, 1, 'Iyzico', 243.00, NULL, 27.00, 27.00, 3514.00, 3757.00, 'online', '$', 'left', '2024-05-04 08:49:15', '2024-05-04 08:49:15', 0.00),
(73, '1714892347', 344, 1, NULL, 26, 1, 'Iyzico', 324.00, NULL, 36.00, 36.00, 3757.00, 4081.00, 'online', '$', 'left', '2024-05-05 00:59:07', '2024-05-05 00:59:07', 0.00),
(74, '1714893305', 345, 1, NULL, 26, 1, 'Iyzico', 324.00, NULL, 36.00, 36.00, 4081.00, 4405.00, 'online', '$', 'left', '2024-05-05 01:15:05', '2024-05-05 01:15:05', 0.00),
(75, '1714893771', 345, 1, NULL, 26, 1, 'Iyzico', 324.00, NULL, 36.00, 36.00, 4405.00, 4729.00, 'online', '$', 'left', '2024-05-05 01:22:51', '2024-05-05 01:22:51', 0.00),
(76, '1714893910', 345, 1, NULL, 26, 1, 'Iyzico', 324.00, NULL, 36.00, 36.00, 4729.00, 5053.00, 'online', '$', 'left', '2024-05-05 01:25:10', '2024-05-05 01:25:10', 0.00),
(77, '1714894318', 345, 1, NULL, 26, 1, 'Iyzico', 324.00, NULL, 36.00, 36.00, 5053.00, 5377.00, 'online', '$', 'left', '2024-05-05 01:31:58', '2024-05-05 01:31:58', 0.00),
(78, '1714895490', 346, 1, NULL, 26, 1, 'Iyzico', 243.00, NULL, 27.00, 27.00, 5377.00, 5620.00, 'online', '$', 'left', '2024-05-05 01:51:30', '2024-05-05 01:51:30', 0.00),
(79, '1714895590', 346, 1, NULL, 26, 1, 'Iyzico', 243.00, NULL, 27.00, 27.00, 5620.00, 5863.00, 'online', '$', 'left', '2024-05-05 01:53:10', '2024-05-05 01:53:10', 0.00),
(80, '1714895768', 346, 1, NULL, 26, 1, 'Iyzico', 243.00, NULL, 27.00, 27.00, 5863.00, 6106.00, 'online', '$', 'left', '2024-05-05 01:56:08', '2024-05-05 01:56:08', 0.00),
(81, '1714895814', 346, 1, NULL, 26, 1, 'Iyzico', 243.00, NULL, 27.00, 27.00, 6106.00, 6349.00, 'online', '$', 'left', '2024-05-05 01:56:54', '2024-05-05 01:56:54', 0.00),
(82, '1714895832', 346, 1, NULL, 26, 1, 'Iyzico', 243.00, NULL, 27.00, 27.00, 6349.00, 6592.00, 'online', '$', 'left', '2024-05-05 01:57:12', '2024-05-05 01:57:12', 0.00),
(83, '1714895852', 346, 1, NULL, 26, 1, 'Iyzico', 243.00, NULL, 27.00, 27.00, 6592.00, 6835.00, 'online', '$', 'left', '2024-05-05 01:57:32', '2024-05-05 01:57:32', 0.00),
(84, '1714896028', 346, 1, NULL, 26, 1, 'Iyzico', 243.00, NULL, 27.00, 27.00, 6835.00, 7078.00, 'online', '$', 'left', '2024-05-05 02:00:28', '2024-05-05 02:00:28', 0.00),
(85, '1714896475', 346, 1, NULL, 26, 1, 'Iyzico', 243.00, NULL, 27.00, 27.00, 7078.00, 7321.00, 'online', '$', 'left', '2024-05-05 02:07:55', '2024-05-05 02:07:55', 0.00),
(86, '1714896597', 346, 1, NULL, 26, 1, 'Iyzico', 243.00, NULL, 27.00, 27.00, 7321.00, 7564.00, 'online', '$', 'left', '2024-05-05 02:09:57', '2024-05-05 02:09:57', 0.00),
(87, '1714896627', 346, 1, NULL, 26, 1, 'Iyzico', 243.00, NULL, 27.00, 27.00, 7564.00, 7807.00, 'online', '$', 'left', '2024-05-05 02:10:28', '2024-05-05 02:10:28', 0.00),
(88, '1714896919', 346, 1, NULL, 26, 1, 'Iyzico', 243.00, NULL, 27.00, 27.00, 7807.00, 8050.00, 'online', '$', 'left', '2024-05-05 02:15:19', '2024-05-05 02:15:19', 0.00),
(89, '1714897065', 347, 1, NULL, 26, 1, 'Iyzico', 324.00, NULL, 36.00, 36.00, 8050.00, 8374.00, 'online', '$', 'left', '2024-05-05 02:17:45', '2024-05-05 02:17:45', 0.00),
(90, '1714904055', 52, 5, NULL, NULL, 1, 'online', 210.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-05-05 04:14:15', '2024-05-05 04:14:15', 0.00),
(91, '1714904357', 53, 5, NULL, NULL, 1, 'online', 315.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-05-05 04:19:17', '2024-05-05 04:19:17', 0.00),
(92, '1715430503', 348, 1, NULL, 26, 1, 'Stripe', 243.00, NULL, 27.00, 27.00, 8374.00, 8617.00, 'online', '$', 'left', '2024-05-11 06:28:23', '2024-05-11 06:28:23', 0.00),
(93, '1715430641', 349, 1, NULL, 26, 1, 'Stripe', 162.00, NULL, 18.00, 18.00, 8617.00, 8779.00, 'online', '$', 'left', '2024-05-11 06:30:41', '2024-05-11 06:30:41', 0.00),
(94, '1715430783', 54, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-05-11 06:33:03', '2024-05-11 06:33:03', 0.00),
(95, '1715438169', 55, 5, NULL, NULL, 1, 'online', 2205.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-05-11 08:36:09', '2024-05-11 08:36:09', 0.00),
(96, '1715440070', 350, 1, NULL, 26, 1, 'Stripe', 162.00, NULL, 18.00, 18.00, 8779.00, 8941.00, 'online', '$', 'left', '2024-05-11 09:07:50', '2024-05-11 09:07:50', 0.00),
(97, '1715692906', 354, 1, NULL, 26, 1, 'Midtrans', 162.00, NULL, 18.00, 18.00, 8941.00, 9103.00, 'online', '$', 'left', '2024-05-14 07:21:46', '2024-05-14 07:21:46', 0.00),
(98, '1715693172', 355, 1, NULL, 26, 1, 'Midtrans', 243.00, NULL, 27.00, 27.00, 9103.00, 9346.00, 'online', '$', 'left', '2024-05-14 07:26:12', '2024-05-14 07:26:12', 0.00),
(99, '1715696950', 356, 1, NULL, 26, 1, 'Midtrans', 243.00, NULL, 27.00, 27.00, 9346.00, 9589.00, 'online', '$', 'left', '2024-05-14 08:29:10', '2024-05-14 08:29:10', 0.00),
(100, '1715776641', 357, 1, NULL, 26, 1, 'Xendit', 243.00, NULL, 27.00, 27.00, 9589.00, 9832.00, 'online', '$', 'left', '2024-05-15 06:37:21', '2024-05-15 06:37:21', 0.00),
(101, '1715862371', 56, 5, NULL, NULL, 1, 'online', 15.75, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-05-16 06:26:11', '2024-05-16 06:26:11', 0.00),
(102, '1716049991', 358, 1, NULL, 26, 1, 'Yoco', 243.00, NULL, 27.00, 27.00, 9832.00, 10075.00, 'online', '$', 'left', '2024-05-18 10:33:11', '2024-05-18 10:33:11', 0.00),
(103, '1716049992', 359, 1, NULL, 26, 1, 'Yoco', 243.00, NULL, 27.00, 27.00, 10075.00, 10318.00, 'online', '$', 'left', '2024-05-18 10:33:12', '2024-05-18 10:33:12', 0.00),
(104, '1716050516', 360, 1, NULL, 26, 1, 'Yoco', 324.00, NULL, 36.00, 36.00, 10318.00, 10642.00, 'online', '$', 'left', '2024-05-18 10:41:56', '2024-05-18 10:41:56', 0.00),
(105, '1716051166', 361, 1, NULL, 26, 1, 'Iyzico', 243.00, NULL, 27.00, 27.00, 10642.00, 10885.00, 'online', '$', 'left', '2024-05-18 10:52:46', '2024-05-18 10:52:46', 0.00),
(106, '1716051417', 361, 1, NULL, 26, 1, 'Iyzico', 243.00, NULL, 27.00, 27.00, 10885.00, 11128.00, 'online', '$', 'left', '2024-05-18 10:56:57', '2024-05-18 10:56:57', 0.00),
(107, '1716126671', 366, 1, NULL, 26, 1, 'Midtrans', 324.00, NULL, 36.00, 36.00, 11128.00, 11452.00, 'online', '$', 'left', '2024-05-19 07:51:11', '2024-05-19 07:51:11', 0.00),
(108, '1716127388', 368, 1, NULL, 26, 1, 'Midtrans', 243.00, NULL, 27.00, 27.00, 11452.00, 11695.00, 'online', '$', 'left', '2024-05-19 08:03:08', '2024-05-19 08:03:08', 0.00),
(109, '1716128698', 368, 1, NULL, 26, 1, 'Midtrans', 243.00, NULL, 27.00, 27.00, 11695.00, 11938.00, 'online', '$', 'left', '2024-05-19 08:24:58', '2024-05-19 08:24:58', 0.00),
(110, '1716179043', 369, 1, NULL, 26, 1, 'Midtrans', 243.00, NULL, 27.00, 27.00, 11938.00, 12181.00, 'online', '$', 'left', '2024-05-19 22:24:03', '2024-05-19 22:24:03', 0.00),
(111, '1716179152', 57, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-05-19 22:25:52', '2024-05-19 22:25:52', 0.00),
(112, '1716179345', 57, 5, NULL, NULL, 1, 'online', 105.00, 0.00, 0.00, 0.00, NULL, NULL, 'online', '$', 'left', '2024-05-19 22:29:05', '2024-05-19 22:29:05', 0.00);

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

--
-- Table structure for table `vendor_infos`
--

CREATE TABLE `vendor_infos` (
  `id` bigint UNSIGNED NOT NULL,
  `vendor_id` bigint DEFAULT NULL,
  `language_id` bigint DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shop_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zip_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 `vendor_infos`
--

INSERT INTO `vendor_infos` (`id`, `vendor_id`, `language_id`, `name`, `shop_name`, `country`, `city`, `state`, `zip_code`, `address`, `details`, `created_at`, `updated_at`) VALUES
(10, 23, 8, 'Jhone Doe', 'Business Equipment Rentals', 'United States of America', 'Trenton', 'New Jersey', '2131', 'New Jersey,  United States of America', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Expedita incidunt quam cumque reiciendis autem. Nobis repellat officia, velit vel cupiditate ut quaerat fugiat, tempore consequatur reprehenderit quod, consectetur odit enim.', '2022-12-18 06:02:02', '2023-01-01 04:25:19'),
(11, 23, 9, 'فلان الفلاني', 'تأجير معدات الأعمال', 'الولايات المتحدة الأمريكية', 'ترينتون', 'نيو جيرسي', '2131', 'نيو جيرسي ، الولايات المتحدة الأمريكية', 'في الصفحة التي يقرأها. ولذلك يتم استخدام طريقة لوريم إيبسوم لأنها تعطي توزيعاَ طبيعياَ -إلى حد ما- للأحرف عوضاً عن استخدام \"هنا يوجد محتوى نصي، هنا يوجد محتوى نصي\" فتجعلها تبدو (أي الأحرف) وكأنها نص مقروء. العديد من برامح النشر المكتبي وبرامح تحرير صفحات الويب تستخدم لوريم إيبسوم بشكل إفتراضي كنموذج عن النص، وإذا قمت بإدخ', '2022-12-18 06:12:44', '2023-01-01 04:25:19'),
(14, 25, 8, 'Ray Sin', 'Copier Lease, Rental, Repair', 'United States', 'New York', NULL, '19387', 'New York, United States', 'Lorem Ipsum is dummied text of the printing and typesetting industry.\r\n Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s.', '2023-01-01 01:21:33', '2023-01-01 03:45:15'),
(15, 25, 9, 'راي سين', 'إيجار آلة تصوير ، إيجار ، إصلاح', 'الولايات المتحدة', 'نيويورك', NULL, '19387', 'نيويورك ، الولايات المتحدة', 'طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز \r\nعلى الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها. ولذلك ي', '2023-01-01 01:21:33', '2023-01-01 03:45:15'),
(16, 26, 8, 'Jack Aranda', 'CityWide  Solutions', 'United States', 'Los Angeles.', NULL, '76362', 'Los Angeles, United States', 'Lorem Ipsum is dummied text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s', '2023-01-01 01:26:10', '2023-01-01 03:44:16'),
(17, 26, 9, 'جاك أراندا', 'حلول سيتي وايد', 'الولايات المتحدة', 'لوس أنجلوس', NULL, '76362', 'لوس أنجلوس ، الولايات المتحدة', 'طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على ا\r\nلشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها. ولذلك ي', '2023-01-01 01:26:10', '2023-01-01 03:44:16'),
(18, 27, 8, 'Rita Book', 'EliteCrew', 'United States', 'Atlanta', 'North Carolina', '42907', 'Atlanta, United States', 'Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web', '2023-01-01 01:29:02', '2023-01-01 03:47:14'),
(19, 27, 9, 'كتاب ريتا', 'طاقم النخبة', 'الولايات المتحدة', 'أتلانتا', NULL, '42907', 'أتلانتا ، الولايات المتحدة', 'الغاية هي الشكل وليس المحتوى) ويُستخدم في صناعات المطابع ودور النشر. كان لوريم إيبسوم ولايزال\r\n المعيار للنص الشكلي منذ القرن الخامس عشر عندما قامت مطبعة مجهو', '2023-01-01 01:29:02', '2023-01-01 03:47:14'),
(20, 28, 8, 'Anita Bath', 'TopCrown', 'United States', 'New York City', NULL, '21737', 'New York City, United States', 'Lorem Ipsum is that it has a more-or-less normal distribution of letters, \r\nas opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web', '2023-01-01 01:34:31', '2023-01-01 03:49:38'),
(21, 28, 9, 'أنيتا باث', 'توب كرون', 'الولايات المتحدة', 'مدينة نيويورك', NULL, '21737', 'مدينة نيويورك ، الولايات المتحدة', 'ر إدخال بعض النوادر أو الكلمات العشوائية إلى النص. إن كنت تريد أن تستخدم نص لوريم إيبسوم ما، عليك أن تتحقق أولاً\r\n أن ليس هناك أي كلمات أو عبارات محرجة أو غير لائقة مخبأة في هذا النص. بينما تعمل جميع مولّدات نصوص لوري', '2023-01-01 01:34:31', '2023-01-01 03:49:38'),
(22, 29, 8, 'Dave Allippa', 'Soulberry Rental', 'United States of America', 'Charlotte', 'North Carolina', '58670', 'Charlotte, United States of America', 'Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here,\r\n content here\', making it look like readable English. Many desktop publishing packages and web', '2023-01-01 01:42:42', '2023-01-01 03:51:58'),
(23, 29, 9, 'ديف أليبا', 'تأجير سولبيري', 'الولايات المتحدة الأمريكية', 'شارلوت', 'شمال كارولينا', '58670', 'شارلوت ، الولايات المتحدة الأمريكية', 'عات المطابع ودور النشر. كان لوريم إيبسوم ولايزال المعيار للنص الشكلي منذ القرن الخامس عشر عندما قامت مطبعة \r\nمجهولة برص مجموعة من الأحرف بشكل عشوائي أخذتها من نص، لتكوّن كتيّب بمثابة دليل أو مرجع شكلي ل', '2023-01-01 01:46:49', '2023-01-01 03:51:58'),
(24, 30, 8, 'Clyde Stale', 'MainSquare', 'United States of America', 'Richmond', NULL, '35686', 'Richmond, United States of America', 'There are many variations of passages of Lorem Ipsum available,\r\n but the majority have suffered alteration in some form, by injected humor, \r\nor randomized words which don\'t look even slightly believable.', '2023-01-01 01:55:58', '2023-01-01 03:53:59'),
(25, 30, 9, 'كلايد ستيل', 'الميدان الرئيسي', 'الولايات المتحدة الأمريكية', 'ريتشموند', NULL, '35686', 'ريتشموند ، الولايات المتحدة الأمريكية', 'ا بشكل ما عبر إدخال بعض النوادر أو الكلمات العشوائية إلى النص. إن كنت تريد أن تستخدم نص لوريم إيبسوم ما، \r\nعليك أن تتحقق أولاً أن ليس هناك أي كلمات أو عبارات محرجة أو غير لائقة مخبأة في هذا النص. بينما تعمل جميع مولّدات نصوص لوريم إيبسوم على الإن', '2023-01-01 01:55:58', '2023-01-01 03:53:59'),
(26, 31, 8, 'Laura Norda', 'Urban Fresh Rental', 'United States of America', 'Olympia', NULL, '90455', 'Olympia, United States of America', 'consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theo', '2023-01-01 01:59:33', '2023-01-01 03:56:19'),
(27, 31, 9, 'لورا نوردا', 'تأجير المناطق الحضرية الطازجة', 'الولايات المتحدة الأمريكية', 'أولمبيا', NULL, '90455', 'أولمبيا ، الولايات المتحدة الأمريكية', 'ز على الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها. ولذلك يتم استخدام طريقة لوريم إيبسوم لأنها تعطي توزيعاَ طبيعياَ -إلى حد ما- للأحرف عوضاً عن استخدام \"هنا يوجد محتوى نصي، هنا يوجد محتوى نصي\" فتجعلها تبدو (أي الأحرف) وكأنها نص مقروء. العديد من برامح النشر المكتبي وبرامح تحرير صفحات الويب تستخدم', '2023-01-01 01:59:33', '2023-01-01 03:56:19'),
(28, 32, 8, 'Rose Bush', 'DreamFiesta', 'United States of America', 'Austin', NULL, '97344', 'Austin, United States of America', 'it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset', '2023-01-01 02:04:20', '2023-01-01 03:59:19'),
(29, 32, 9, 'روز بوش', 'دريمفيستا', 'الولايات المتحدة الأمريكية', 'أوستين', NULL, '97344', 'أوستن ، الولايات المتحدة الأمريكية', '(بمعنى أن الغاية هي الشكل وليس المحتوى) ويُستخدم في صناعات المطابع ودور النشر. كان لوريم إيبسوم ولايزال المعيار للنص الشكلي منذ القرن الخامس عشر عندما قامت مطبعة مجهولة برص مجموعة من الأحرف بشكل عشوائي أخذتها من نص، لتكوّن كتيّب بم', '2023-01-01 02:04:20', '2023-01-01 03:59:19'),
(31, 34, 8, 'lanopid', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-03-27 04:17:48', '2024-03-27 04:17:48');

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

--
-- Table structure for table `vendor_reviews`
--

CREATE TABLE `vendor_reviews` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint DEFAULT NULL,
  `vendor_id` bigint DEFAULT NULL,
  `rating` double(8,2) DEFAULT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 `vendor_reviews`
--

INSERT INTO `vendor_reviews` (`id`, `user_id`, `vendor_id`, `rating`, `comment`, `created_at`, `updated_at`) VALUES
(1, 16, 7, 3.00, 'fsdafaf', '2022-10-15 23:29:02', '2022-10-20 23:29:02'),
(2, 15, 7, 4.00, 'Drag, drop, and mix differentro parts to quickly build your landingp in a matter of minutes. Let us knowos your thoughts or', '2022-10-11 18:00:00', '2022-10-22 00:02:05');

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

--
-- Table structure for table `video_sections`
--

CREATE TABLE `video_sections` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `video_sections`
--

INSERT INTO `video_sections` (`id`, `language_id`, `title`, `subtitle`, `image`, `link`, `created_at`, `updated_at`) VALUES
(2, 8, 'WHO WE ARE', 'We Help You to Become a Great Photographer', '65fc11a5a5fc2.jpg', 'https://www.youtube.com/watch?v=fJVeZMoHO9E', '2021-10-06 23:56:46', '2024-07-04 07:24:06'),
(3, 9, 'من نحن', 'نحن نساعدك على أن تصبح مصورًا فوتوغرافيًا رائعًا', '65fc11b29ae7e.jpg', 'https://www.youtube.com/watch?v=lgm3puP3tMA', '2021-11-30 22:59:28', '2024-07-04 07:27:36');

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

--
-- Table structure for table `withdraws`
--

CREATE TABLE `withdraws` (
  `id` bigint UNSIGNED NOT NULL,
  `vendor_id` bigint DEFAULT NULL,
  `withdraw_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `method_id` int DEFAULT NULL,
  `amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payable_amount` float(8,2) NOT NULL DEFAULT '0.00',
  `total_charge` float(8,2) NOT NULL DEFAULT '0.00',
  `additional_reference` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `feilds` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `withdraw_method_inputs`
--

CREATE TABLE `withdraw_method_inputs` (
  `id` bigint UNSIGNED NOT NULL,
  `withdraw_payment_method_id` bigint DEFAULT NULL,
  `type` tinyint DEFAULT NULL COMMENT '1-text, 2-select, 3-checkbox, 4-textarea, 5-datepicker, 6-timepicker, 7-number',
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `placeholder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `required` tinyint NOT NULL DEFAULT '0' COMMENT '1-required, 0- optional',
  `order_number` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `withdraw_method_inputs`
--

INSERT INTO `withdraw_method_inputs` (`id`, `withdraw_payment_method_id`, `type`, `label`, `name`, `placeholder`, `required`, `order_number`, `created_at`, `updated_at`) VALUES
(1, 2, 1, 'Account No', 'Account_No', 'Enter Account Number', 1, 1, '2022-10-19 23:15:38', '2022-10-19 23:15:38'),
(2, 3, 1, 'Email', 'Email', 'Enter Perfect Money Email', 1, 1, '2022-10-31 23:48:02', '2022-10-31 23:48:02'),
(3, 4, 1, 'Email', 'Email', 'Enter Perfect Money Email', 1, 1, '2022-12-12 01:03:06', '2022-12-12 01:08:11');

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

--
-- Table structure for table `withdraw_method_options`
--

CREATE TABLE `withdraw_method_options` (
  `id` bigint UNSIGNED NOT NULL,
  `withdraw_method_input_id` bigint DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `withdraw_payment_methods`
--

CREATE TABLE `withdraw_payment_methods` (
  `id` bigint UNSIGNED NOT NULL,
  `min_limit` double(8,2) DEFAULT NULL,
  `max_limit` double(8,2) DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  `fixed_charge` float(8,2) DEFAULT '0.00',
  `percentage_charge` float(8,2) DEFAULT '0.00',
  `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 `withdraw_payment_methods`
--

INSERT INTO `withdraw_payment_methods` (`id`, `min_limit`, `max_limit`, `name`, `status`, `fixed_charge`, `percentage_charge`, `created_at`, `updated_at`) VALUES
(2, 50.00, 1000.00, 'Bkash', 1, 5.00, 10.00, '2022-10-19 23:15:16', '2022-10-31 23:02:10'),
(4, 212.00, 2212.00, 'Perfect Money', 1, 21.00, 12.00, '2022-12-12 00:59:39', '2022-12-12 00:59:39');

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

--
-- Table structure for table `work_processes`
--

CREATE TABLE `work_processes` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `serial_number` int UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `work_processes`
--

INSERT INTO `work_processes` (`id`, `language_id`, `icon`, `serial_number`, `title`, `created_at`, `updated_at`) VALUES
(3, 9, 'fas fa-search', 1, 'ابحث عن معداتك', '2021-12-09 02:06:57', '2022-08-01 03:30:00'),
(4, 9, 'fas fa-qrcode', 2, 'قارن اختيارك', '2021-12-09 02:09:04', '2022-08-01 03:30:13'),
(5, 9, 'fas fa-truck', 3, 'حجز المعدات', '2021-12-09 02:12:00', '2022-08-01 03:30:25'),
(6, 9, 'fas fa-chart-line', 4, 'ابدأ مشروعك', '2021-12-09 02:14:21', '2022-08-01 03:30:39'),
(7, 8, 'fas fa-search', 1, 'Search Your Equipment', '2022-03-06 00:26:48', '2022-08-01 03:27:33'),
(8, 8, 'fas fa-qrcode', 2, 'Compare Your Selection', '2022-03-06 00:27:58', '2022-08-01 03:27:49'),
(9, 8, 'fas fa-truck', 3, 'Reserve The Equipment', '2022-03-06 00:28:30', '2022-08-01 03:28:05'),
(10, 8, 'fas fa-chart-line', 4, 'Get Start Your Project', '2022-03-06 00:29:11', '2022-08-01 03:28:17');

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

--
-- Table structure for table `work_process_sections`
--

CREATE TABLE `work_process_sections` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` bigint UNSIGNED NOT NULL,
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 `work_process_sections`
--

INSERT INTO `work_process_sections` (`id`, `language_id`, `subtitle`, `title`, `text`, `created_at`, `updated_at`) VALUES
(1, 9, 'آلية العمل', 'احصل على إيجاراتك في 4 خطوات سهلة', 'إنها طرية للغاية ولا تترك أي ألم. يحب أن يعتني بأسرته. سوف تؤتي هذه العملية ثمارها.', '2021-12-08 23:03:46', '2022-08-01 03:29:44'),
(2, 8, 'Work Process', 'Get Your Rentals in Easy 4 Steps', 'Amet minim mollit non deserunt ullamco est sit aliqua dolor do amet sint. Velit officia consequat duis enim velit mollit. Exercitation veniam consequat sunt nostrud amet.', '2022-03-06 00:26:05', '2022-08-01 03:27:09');

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- Indexes for table `blog_informations`
--
ALTER TABLE `blog_informations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `blog_informations_language_id_foreign` (`language_id`),
  ADD KEY `blog_informations_blog_category_id_foreign` (`blog_category_id`),
  ADD KEY `blog_informations_blog_id_foreign` (`blog_id`);

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

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

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

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

--
-- Indexes for table `cookie_alerts`
--
ALTER TABLE `cookie_alerts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cookie_alerts_language_id_foreign` (`language_id`);

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

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

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

--
-- Indexes for table `equipment_bookings`
--
ALTER TABLE `equipment_bookings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `equipment_bookings_equipment_id_foreign` (`equipment_id`),
  ADD KEY `equipment_bookings_user_id_foreign` (`user_id`);

--
-- Indexes for table `equipment_categories`
--
ALTER TABLE `equipment_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `equipment_categories_language_id_foreign` (`language_id`);

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

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

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

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

--
-- Indexes for table `equipment_reviews`
--
ALTER TABLE `equipment_reviews`
  ADD PRIMARY KEY (`id`),
  ADD KEY `equipment_reviews_user_id_foreign` (`user_id`),
  ADD KEY `equipment_reviews_equipment_id_foreign` (`equipment_id`);

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

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

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

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

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

--
-- Indexes for table `footer_contents`
--
ALTER TABLE `footer_contents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `footer_texts_language_id_foreign` (`language_id`);

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `page_contents`
--
ALTER TABLE `page_contents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `page_contents_language_id_foreign` (`language_id`),
  ADD KEY `page_contents_page_id_foreign` (`page_id`);

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `password_resets_email_index` (`email`);

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

--
-- Indexes for table `popups`
--
ALTER TABLE `popups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `popups_language_id_foreign` (`language_id`);

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

--
-- Indexes for table `product_categories`
--
ALTER TABLE `product_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_categories_language_id_foreign` (`language_id`);

--
-- Indexes for table `product_contents`
--
ALTER TABLE `product_contents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_contents_language_id_foreign` (`language_id`),
  ADD KEY `product_contents_product_category_id_foreign` (`product_category_id`),
  ADD KEY `product_contents_product_id_foreign` (`product_id`);

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

--
-- Indexes for table `product_orders`
--
ALTER TABLE `product_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_orders_user_id_foreign` (`user_id`);

--
-- Indexes for table `product_purchase_items`
--
ALTER TABLE `product_purchase_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_purchase_items_product_order_id_foreign` (`product_order_id`),
  ADD KEY `product_purchase_items_product_id_foreign` (`product_id`);

--
-- Indexes for table `product_reviews`
--
ALTER TABLE `product_reviews`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_reviews_user_id_foreign` (`user_id`),
  ADD KEY `product_reviews_product_id_foreign` (`product_id`);

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

--
-- Indexes for table `product_shipping_charges`
--
ALTER TABLE `product_shipping_charges`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shipping_charges_language_id_foreign` (`language_id`);

--
-- Indexes for table `push_subscriptions`
--
ALTER TABLE `push_subscriptions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `push_subscriptions_endpoint_unique` (`endpoint`),
  ADD KEY `push_subscriptions_subscribable_type_subscribable_id_index` (`subscribable_type`,`subscribable_id`);

--
-- Indexes for table `quick_links`
--
ALTER TABLE `quick_links`
  ADD PRIMARY KEY (`id`),
  ADD KEY `quick_links_language_id_foreign` (`language_id`);

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

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

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

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

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

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

--
-- Indexes for table `subscribers`
--
ALTER TABLE `subscribers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `subscribers_email_id_unique` (`email_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `about_sections`
--
ALTER TABLE `about_sections`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `advertisements`
--
ALTER TABLE `advertisements`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `blog_categories`
--
ALTER TABLE `blog_categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT for table `blog_informations`
--
ALTER TABLE `blog_informations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `blog_sections`
--
ALTER TABLE `blog_sections`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `call_to_action_sections`
--
ALTER TABLE `call_to_action_sections`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `commissions`
--
ALTER TABLE `commissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `conversations`
--
ALTER TABLE `conversations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cookie_alerts`
--
ALTER TABLE `cookie_alerts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `counter_informations`
--
ALTER TABLE `counter_informations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `earnings`
--
ALTER TABLE `earnings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `equipments`
--
ALTER TABLE `equipments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `equipment_bookings`
--
ALTER TABLE `equipment_bookings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=370;

--
-- AUTO_INCREMENT for table `equipment_categories`
--
ALTER TABLE `equipment_categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

--
-- AUTO_INCREMENT for table `equipment_category_sections`
--
ALTER TABLE `equipment_category_sections`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `equipment_contents`
--
ALTER TABLE `equipment_contents`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;

--
-- AUTO_INCREMENT for table `equipment_coupons`
--
ALTER TABLE `equipment_coupons`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `equipment_locations`
--
ALTER TABLE `equipment_locations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `equipment_reviews`
--
ALTER TABLE `equipment_reviews`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `equipment_sections`
--
ALTER TABLE `equipment_sections`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `features`
--
ALTER TABLE `features`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `feature_sections`
--
ALTER TABLE `feature_sections`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `footer_contents`
--
ALTER TABLE `footer_contents`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `guests`
--
ALTER TABLE `guests`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `locations`
--
ALTER TABLE `locations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

--
-- AUTO_INCREMENT for table `mail_templates`
--
ALTER TABLE `mail_templates`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `menu_builders`
--
ALTER TABLE `menu_builders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `offline_gateways`
--
ALTER TABLE `offline_gateways`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `online_gateways`
--
ALTER TABLE `online_gateways`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

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

--
-- AUTO_INCREMENT for table `page_contents`
--
ALTER TABLE `page_contents`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `partners`
--
ALTER TABLE `partners`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `password_resets`
--
ALTER TABLE `password_resets`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment_invoices`
--
ALTER TABLE `payment_invoices`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `product_categories`
--
ALTER TABLE `product_categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;

--
-- AUTO_INCREMENT for table `product_contents`
--
ALTER TABLE `product_contents`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

--
-- AUTO_INCREMENT for table `product_coupons`
--
ALTER TABLE `product_coupons`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `product_orders`
--
ALTER TABLE `product_orders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;

--
-- AUTO_INCREMENT for table `product_purchase_items`
--
ALTER TABLE `product_purchase_items`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;

--
-- AUTO_INCREMENT for table `product_reviews`
--
ALTER TABLE `product_reviews`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `product_sections`
--
ALTER TABLE `product_sections`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `product_shipping_charges`
--
ALTER TABLE `product_shipping_charges`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `push_subscriptions`
--
ALTER TABLE `push_subscriptions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `quick_links`
--
ALTER TABLE `quick_links`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `role_permissions`
--
ALTER TABLE `role_permissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `sections`
--
ALTER TABLE `sections`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `security_deposit_refunds`
--
ALTER TABLE `security_deposit_refunds`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `social_medias`
--
ALTER TABLE `social_medias`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `static_sections`
--
ALTER TABLE `static_sections`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `support_tickets`
--
ALTER TABLE `support_tickets`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `support_ticket_statuses`
--
ALTER TABLE `support_ticket_statuses`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `testimonial_sections`
--
ALTER TABLE `testimonial_sections`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `transcations`
--
ALTER TABLE `transcations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=113;

--
-- AUTO_INCREMENT for table `vendor_infos`
--
ALTER TABLE `vendor_infos`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `vendor_reviews`
--
ALTER TABLE `vendor_reviews`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `video_sections`
--
ALTER TABLE `video_sections`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `withdraws`
--
ALTER TABLE `withdraws`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `withdraw_method_inputs`
--
ALTER TABLE `withdraw_method_inputs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `withdraw_method_options`
--
ALTER TABLE `withdraw_method_options`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `withdraw_payment_methods`
--
ALTER TABLE `withdraw_payment_methods`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `work_processes`
--
ALTER TABLE `work_processes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `work_process_sections`
--
ALTER TABLE `work_process_sections`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Constraints for table `blog_categories`
--
ALTER TABLE `blog_categories`
  ADD CONSTRAINT `blog_categories_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `blog_informations`
--
ALTER TABLE `blog_informations`
  ADD CONSTRAINT `blog_informations_blog_category_id_foreign` FOREIGN KEY (`blog_category_id`) REFERENCES `blog_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `blog_informations_blog_id_foreign` FOREIGN KEY (`blog_id`) REFERENCES `blogs` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `blog_informations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cookie_alerts`
--
ALTER TABLE `cookie_alerts`
  ADD CONSTRAINT `cookie_alerts_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `equipment_bookings`
--
ALTER TABLE `equipment_bookings`
  ADD CONSTRAINT `equipment_bookings_equipment_id_foreign` FOREIGN KEY (`equipment_id`) REFERENCES `equipments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `equipment_bookings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `equipment_categories`
--
ALTER TABLE `equipment_categories`
  ADD CONSTRAINT `equipment_categories_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `equipment_reviews`
--
ALTER TABLE `equipment_reviews`
  ADD CONSTRAINT `equipment_reviews_equipment_id_foreign` FOREIGN KEY (`equipment_id`) REFERENCES `equipments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `equipment_reviews_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `faqs`
--
ALTER TABLE `faqs`
  ADD CONSTRAINT `faqs_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `footer_contents`
--
ALTER TABLE `footer_contents`
  ADD CONSTRAINT `footer_texts_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `page_contents`
--
ALTER TABLE `page_contents`
  ADD CONSTRAINT `page_contents_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `page_contents_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `popups`
--
ALTER TABLE `popups`
  ADD CONSTRAINT `popups_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_categories`
--
ALTER TABLE `product_categories`
  ADD CONSTRAINT `product_categories_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_contents`
--
ALTER TABLE `product_contents`
  ADD CONSTRAINT `product_contents_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_contents_product_category_id_foreign` FOREIGN KEY (`product_category_id`) REFERENCES `product_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_contents_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_orders`
--
ALTER TABLE `product_orders`
  ADD CONSTRAINT `product_orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_purchase_items`
--
ALTER TABLE `product_purchase_items`
  ADD CONSTRAINT `product_purchase_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_purchase_items_product_order_id_foreign` FOREIGN KEY (`product_order_id`) REFERENCES `product_orders` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_reviews`
--
ALTER TABLE `product_reviews`
  ADD CONSTRAINT `product_reviews_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_reviews_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_shipping_charges`
--
ALTER TABLE `product_shipping_charges`
  ADD CONSTRAINT `shipping_charges_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `quick_links`
--
ALTER TABLE `quick_links`
  ADD CONSTRAINT `quick_links_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;
COMMIT;

