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

START TRANSACTION;



--
-- Database: `eorder_1.0_demo`
--

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

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

CREATE TABLE `admins` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_id` int(11) DEFAULT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0 - deactive, 1 - active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `token` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `admins` (`id`, `role_id`, `username`, `email`, `first_name`, `last_name`, `image`, `password`, `status`, `created_at`, `updated_at`, `token`) VALUES
(1, NULL, 'admin', 'duxusidex@mailinator.com', 'Justin', 'Langer', '5f6c395833e14.jpg', '$2y$10$1FJBRGpBFqs6bPtfcx.WKeNvX1n8fbPW/QLz8IiemvWqjzVQWmW7u', 1, NULL, '2024-01-29 14:49:07', 'noqvhqCitQmzv56XiwNYbwdx5mURP5admin'),
(13, 8, 'manager', 'juqor@eample.com', 'Mr', 'Karim', '8483094a8215e666783bd33c2668d3b673b0e125.jpg', '$2y$10$D5aaKaYCy4ROaiUN/Txsqu4CI9VyOE0UypDgBs04QalNQTDGaSUKW', 1, '2024-01-21 16:41:13', '2024-01-29 14:48:46', NULL);

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

--
-- Table structure for table `backups`
--

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

--
-- Dumping data for table `backups`
--

INSERT INTO `backups` (`id`, `filename`, `created_at`, `updated_at`) VALUES
(3, '2022-04-24-121935-dump-superv.sql', '2022-04-24 06:19:35', '2022-04-24 06:19:35');

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

--
-- Table structure for table `basic_extendeds`
--

CREATE TABLE `basic_extendeds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) DEFAULT NULL,
  `cookie_alert_status` tinyint(4) NOT NULL DEFAULT '1',
  `cookie_alert_text` blob,
  `cookie_alert_button_text` varchar(255) DEFAULT NULL,
  `to_mail` varchar(255) DEFAULT NULL,
  `default_language_direction` varchar(20) NOT NULL DEFAULT 'ltr' COMMENT 'ltr / rtl',
  `from_mail` varchar(255) DEFAULT NULL,
  `testimonial_img` varchar(255) DEFAULT NULL,
  `from_name` varchar(255) DEFAULT NULL,
  `is_smtp` tinyint(4) NOT NULL DEFAULT '0',
  `smtp_host` varchar(255) DEFAULT NULL,
  `smtp_port` varchar(30) DEFAULT NULL,
  `encryption` varchar(30) DEFAULT NULL,
  `smtp_username` varchar(255) DEFAULT NULL,
  `smtp_password` varchar(255) DEFAULT NULL,
  `base_currency_symbol` blob,
  `base_currency_symbol_position` varchar(10) NOT NULL DEFAULT 'left',
  `base_currency_text` varchar(100) DEFAULT NULL,
  `base_currency_text_position` varchar(10) NOT NULL DEFAULT 'right',
  `base_currency_rate` decimal(8,2) NOT NULL DEFAULT '0.00',
  `hero_section_title` varchar(255) DEFAULT NULL,
  `hero_section_text` varchar(255) DEFAULT NULL,
  `hero_section_button_text` varchar(30) DEFAULT NULL,
  `hero_section_button_url` text,
  `hero_section_video_url` text,
  `hero_img` varchar(50) DEFAULT NULL,
  `timezone` text,
  `contact_addresses` text,
  `contact_numbers` text,
  `contact_mails` text,
  `is_whatsapp` tinyint(4) NOT NULL DEFAULT '1',
  `whatsapp_number` varchar(50) DEFAULT NULL,
  `whatsapp_header_title` varchar(255) DEFAULT NULL,
  `whatsapp_popup_message` text,
  `whatsapp_popup` tinyint(4) NOT NULL DEFAULT '1',
  `domain_request_success_message` varchar(255) DEFAULT NULL,
  `cname_record_section_title` varchar(255) DEFAULT NULL,
  `cname_record_section_text` text,
  `package_features` text,
  `expiration_reminder` int(11) NOT NULL DEFAULT '3',
  `max_video_size` decimal(11,2) NOT NULL DEFAULT '20.00',
  `max_file_size` decimal(11,2) NOT NULL DEFAULT '10.00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `basic_extendeds`
--

INSERT INTO `basic_extendeds` (`id`, `language_id`, `cookie_alert_status`, `cookie_alert_text`, `cookie_alert_button_text`, `to_mail`, `default_language_direction`, `from_mail`, `testimonial_img`, `from_name`, `is_smtp`, `smtp_host`, `smtp_port`, `encryption`, `smtp_username`, `smtp_password`, `base_currency_symbol`, `base_currency_symbol_position`, `base_currency_text`, `base_currency_text_position`, `base_currency_rate`, `hero_section_title`, `hero_section_text`, `hero_section_button_text`, `hero_section_button_url`, `hero_section_video_url`, `hero_img`, `timezone`, `contact_addresses`, `contact_numbers`, `contact_mails`, `is_whatsapp`, `whatsapp_number`, `whatsapp_header_title`, `whatsapp_popup_message`, `whatsapp_popup`, `domain_request_success_message`, `cname_record_section_title`, `cname_record_section_text`, `package_features`, `expiration_reminder`, `max_video_size`, `max_file_size`) VALUES
(147, 176, 1, 0x596f757220657870657269656e6365206f6e207468697320736974652077696c6c20626520696d70726f76656420627920616c6c6f77696e6720636f6f6b6965732e, 'Allow Cookies', 'pratik.anwar@gmail.com', 'ltr', 'test@kreativdev.com', 'b19dfe727e15f5f06b7fe2accb10a62b7ea183cc.png', 'Supervsasso', 1, 'nl1-sr12.supercp.com', '587', 'TLS', 'test@kreativdev.com', 'xh=wf[%(GD!{', 0x24, 'left', 'USD', 'right', '1.00', 'Our Platform, Your Success', 'Build Your Own Restaurant Website', 'Explore Plans', '/pricing', 'https://www.youtube.com/watch?v=ufda7QD-EcM', '3765afe7ef38875c4ee8d409e2dcd62216f66582.png', 'America/Shiprock', 'California, USA\r\nLondon, United Kingdom\r\nMelbourne, Australia', '+8434197502,+2350575099,+23576039607', 'contact@example.com,support@example.com,query@example.com', 1, NULL, NULL, NULL, 1, 'We have received your custom domain request. Please allow us 2 business days to connect the domain with our server.', 'Read Before Sending Custom Domain Request', '<ul><li><font color=\"#575962\"><span style=\"font-weight:600;\"> Before sending request for your custom domain, You need to add a CNAME record (given in below table) in your custom domain from your domain registrar account (like - namecheap, godaddy etc...).</span></font></li><li><font color=\"#575962\"><span style=\"font-weight:600;\"> CNAME record is needed to point your custom domain to our domain ( profilo.xyz ), so that our website can show your portfolio on your domain</span></font></li><li><font color=\"#575962\"><span style=\"font-weight:600;\"> Different domain registrar (like - godaddy, namecheap etc...) has different interface for adding CNAME record. If you cannot find the place to add CNAME record in your domain registrar account, then please contact your domain registrar support, they will show you the place to add CNAME record for your custom domain</span></font></li></ul>', '[\"Custom Domain\",\"Subdomain\",\"POS\",\"Coupon\",\"Live Orders\",\"Whatsapp Order & Notification\",\"QR Menu\",\"Table Reservation\",\"Table QR Builder\",\"Call Waiter\",\"Staffs\",\"Blog\",\"Custom Page\",\"Online Order\",\"On Table\",\"Pick Up\",\"Home Delivery\",\"Postal Code Based Delivery Charge\",\"PWA Installability\"]', 4, '40.00', '5.00'),
(148, 177, 1, 0xd8b3d98ad8aad98520d8aad8add8b3d98ad98620d8aad8acd8b1d8a8d8aad98320d8b9d984d98920d987d8b0d8a720d8a7d984d985d988d982d8b920d985d98620d8aed984d8a7d98420d8a7d984d8b3d985d8a7d8ad20d8a8d985d984d981d8a7d8aa20d8aad8b9d8b1d98ad98120d8a7d984d8a7d8b1d8aad8a8d8a7d8b7, 'السماح للكوكيز', 'pratik.anwar@gmail.com', 'ltr', 'test@kreativdev.com', 'b19dfe727e15f5f06b7fe2accb10a62b7ea183cc.png', 'Supervsasso', 1, 'nl1-sr12.supercp.com', '587', 'TLS', 'test@kreativdev.com', 'xh=wf[%(GD!{', 0x24, 'left', 'USD', 'right', '1.00', 'منصتنا ، نجاحك', 'إنشاء موقع الدورة التدريبية الخاصة بك', 'اكتشف الخطط', '/pricing', 'https://www.youtube.com/watch?v=ufda7QD-EcM', '0dc89160f6d4b855a1909fddb05f579654a8dafb.png', 'America/Shiprock', 'منزل - 44 ، طريق - 03 ، قطاع - 11 ، أوتارا ، دكا\r\nدهانوندي ، دكا\r\nمحمدبور ، دكا', '237237237,72372332,+8967936437', 'contact@example.com,support@example.com,query@example.com', 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, '[\"Custom Domain\",\"Subdomain\",\"POS\",\"Coupon\",\"Live Orders\",\"Whatsapp Order & Notification\",\"QR Menu\",\"Table Reservation\",\"Table QR Builder\",\"Call Waiter\",\"Staffs\",\"Blog\",\"Custom Page\",\"Online Order\",\"On Table\",\"Pick Up\",\"Home Delivery\",\"Postal Code Based Delivery Charge\",\"PWA Installability\"]', 3, '40.00', '5.00');

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

--
-- Table structure for table `basic_settings`
--

CREATE TABLE `basic_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) DEFAULT NULL,
  `favicon` varchar(50) DEFAULT NULL,
  `logo` varchar(50) DEFAULT NULL,
  `preloader_status` tinyint(4) NOT NULL DEFAULT '1',
  `preloader` varchar(50) DEFAULT NULL,
  `website_title` varchar(255) DEFAULT NULL,
  `base_color` varchar(30) DEFAULT NULL,
  `base_color2` varchar(30) DEFAULT NULL,
  `breadcrumb` varchar(50) DEFAULT NULL,
  `footer_logo` varchar(50) DEFAULT NULL,
  `footer_text` varchar(255) DEFAULT NULL,
  `newsletter_text` varchar(255) DEFAULT NULL,
  `copyright_text` blob,
  `intro_subtitle` varchar(50) DEFAULT NULL,
  `intro_title` varchar(50) DEFAULT NULL,
  `intro_text` text,
  `intro_main_image` varchar(191) DEFAULT NULL,
  `contact_form_title` varchar(255) DEFAULT NULL,
  `contact_text` varchar(255) DEFAULT NULL,
  `contact_info_title` varchar(191) DEFAULT NULL,
  `tawk_to_script` text,
  `is_recaptcha` tinyint(4) NOT NULL DEFAULT '0',
  `google_recaptcha_site_key` varchar(255) DEFAULT NULL,
  `google_recaptcha_secret_key` varchar(255) DEFAULT NULL,
  `is_tawkto` tinyint(4) NOT NULL DEFAULT '1',
  `tawkto_property_id` varchar(255) DEFAULT NULL,
  `tawkto_chat_link` varchar(255) DEFAULT NULL,
  `is_disqus` tinyint(4) NOT NULL DEFAULT '1',
  `is_user_disqus` tinyint(4) NOT NULL DEFAULT '1',
  `disqus_shortname` varchar(255) DEFAULT NULL,
  `disqus_script` text,
  `maintainance_mode` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1 - active, 0 - deactive',
  `maintainance_text` text,
  `maintenance_img` varchar(50) DEFAULT NULL,
  `maintenance_status` tinyint(4) NOT NULL DEFAULT '0',
  `secret_path` varchar(255) DEFAULT NULL,
  `home_section` tinyint(4) NOT NULL DEFAULT '1',
  `process_section` tinyint(4) NOT NULL DEFAULT '1',
  `featured_users_section` tinyint(4) NOT NULL DEFAULT '1',
  `pricing_section` tinyint(4) NOT NULL DEFAULT '1',
  `partners_section` tinyint(4) NOT NULL DEFAULT '1',
  `partner_title` varchar(255) DEFAULT NULL,
  `partner_subtitle` varchar(255) DEFAULT NULL,
  `intro_section` tinyint(4) NOT NULL DEFAULT '1',
  `intro_section_button_text` varchar(255) DEFAULT NULL,
  `intro_section_button_url` varchar(255) DEFAULT NULL,
  `intro_section_video_url` varchar(255) DEFAULT NULL,
  `testimonial_section` tinyint(4) NOT NULL DEFAULT '1',
  `feature_title` varchar(255) DEFAULT NULL,
  `work_process_title` varchar(255) DEFAULT NULL,
  `preview_templates_title` varchar(255) DEFAULT NULL,
  `preview_templates_subtitle` varchar(255) DEFAULT NULL,
  `featured_users_title` varchar(255) DEFAULT NULL,
  `featured_users_subtitle` varchar(255) DEFAULT NULL,
  `pricing_title` varchar(255) DEFAULT NULL,
  `pricing_subtitle` varchar(255) DEFAULT NULL,
  `testimonial_title` varchar(255) DEFAULT NULL,
  `testimonial_subtitle` varchar(255) DEFAULT NULL,
  `news_section` tinyint(4) NOT NULL DEFAULT '1',
  `template_section` tinyint(4) NOT NULL DEFAULT '1',
  `top_footer_section` tinyint(4) NOT NULL DEFAULT '1',
  `copyright_section` tinyint(4) NOT NULL DEFAULT '1',
  `blog_title` varchar(255) DEFAULT NULL,
  `blog_subtitle` varchar(255) DEFAULT NULL,
  `useful_links_title` varchar(50) DEFAULT NULL,
  `newsletter_title` varchar(50) DEFAULT NULL,
  `newsletter_subtitle` varchar(255) DEFAULT NULL,
  `is_whatsapp` tinyint(4) NOT NULL DEFAULT '1',
  `whatsapp_number` varchar(50) DEFAULT NULL,
  `whatsapp_header_title` varchar(255) DEFAULT NULL,
  `whatsapp_popup_message` text,
  `whatsapp_popup` tinyint(4) NOT NULL DEFAULT '1',
  `aws_access_key_id` varchar(255) DEFAULT NULL,
  `aws_secret_access_key` varchar(255) DEFAULT NULL,
  `aws_default_region` varchar(255) DEFAULT NULL,
  `aws_bucket` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `basic_settings`
--

INSERT INTO `basic_settings` (`id`, `language_id`, `favicon`, `logo`, `preloader_status`, `preloader`, `website_title`, `base_color`, `base_color2`, `breadcrumb`, `footer_logo`, `footer_text`, `newsletter_text`, `copyright_text`, `intro_subtitle`, `intro_title`, `intro_text`, `intro_main_image`, `contact_form_title`, `contact_text`, `contact_info_title`, `tawk_to_script`, `is_recaptcha`, `google_recaptcha_site_key`, `google_recaptcha_secret_key`, `is_tawkto`, `tawkto_property_id`, `tawkto_chat_link`, `is_disqus`, `is_user_disqus`, `disqus_shortname`, `disqus_script`, `maintainance_mode`, `maintainance_text`, `maintenance_img`, `maintenance_status`, `secret_path`, `home_section`, `process_section`, `featured_users_section`, `pricing_section`, `partners_section`, `partner_title`, `partner_subtitle`, `intro_section`, `intro_section_button_text`, `intro_section_button_url`, `intro_section_video_url`, `testimonial_section`, `feature_title`, `work_process_title`, `preview_templates_title`, `preview_templates_subtitle`, `featured_users_title`, `featured_users_subtitle`, `pricing_title`, `pricing_subtitle`, `testimonial_title`, `testimonial_subtitle`, `news_section`, `template_section`, `top_footer_section`, `copyright_section`, `blog_title`, `blog_subtitle`, `useful_links_title`, `newsletter_title`, `newsletter_subtitle`, `is_whatsapp`, `whatsapp_number`, `whatsapp_header_title`, `whatsapp_popup_message`, `whatsapp_popup`, `aws_access_key_id`, `aws_secret_access_key`, `aws_default_region`, `aws_bucket`) VALUES
(153, 176, 'b55defa7a38b66c98a655f890f6cd03aee2e05c9.png', '5abc08fb0f15ce2db52db532c5bcb16dea5f7601.png', 1, 'ae96227adb52366132cb13baa6eeae0e88ae50b8.gif', 'Eorder', 'FF6742', 'FF4B2B', 'e7daf03a5c751c5fac894b491ce0e851c323289f.jpg', '6b8adba3a1a952306e44e86bf9342c5c1d4870a4.png', 'Eorder: Elevate dining. Multitenant hub for diverse flavors, seamless orders from top-tier restaurants. Subscribe for a unique culinary journey', 'Subscribe to gate Latest News, Offer and connect With Us.', 0x3c703e436f7079726967687420c2a920323032342e20416c6c2072696768747320726573657276656420627920654f726465722e3c2f703e, 'About Us', 'Why Choose Our Restaurant Platform', 'Discover Eorder—your culinary companion for diverse flavors and top-tier restaurants. From gourmet to casual, explore menus, place orders, and enjoy a seamless dining hub. \n\nElevate your gastronomic journey with the simplicity of Eorder, where indulgence is just a click away.', '62b2b131e6f12.png', 'Leave Reply', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum.', 'Contact Info', '<!--Start of Tawk.to Script-->\r\n<script type=\"text/javascript\">\r\nvar Tawk_API=Tawk_API||{}, Tawk_LoadStart=new Date();\r\n(function(){\r\nvar s1=document.createElement(\"script\"),s0=document.getElementsByTagName(\"script\")[0];\r\ns1.async=true;\r\ns1.src=\'https://embed.tawk.to/5f5e445f4704467e89ee918d/default\';\r\ns1.charset=\'UTF-8\';\r\ns1.setAttribute(\'crossorigin\',\'*\');\r\ns0.parentNode.insertBefore(s1,s0);\r\n})();\r\n</script>\r\n<!--End of Tawk.to Script-->', 1, '6LcOdFkpAAAAAETEI0CkavnbX8m8VLjj6YdU0yk3', '6LcOdFkpAAAAAKTyr4Jmx1zej7ych3ITX10MVwy3', 0, '60b886bbde99a4282a1b22a3', 'https://tawk.to/chat/62d688ec7b967b11799a42ee/1g8b0do1h', 1, 1, 'plusagency-2-5', '<script>\r\n\r\n/**\r\n*  RECOMMENDED CONFIGURATION VARIABLES: EDIT AND UNCOMMENT THE SECTION BELOW TO INSERT DYNAMIC VALUES FROM YOUR PLATFORM OR CMS.\r\n*  LEARN WHY DEFINING THESE VARIABLES IS IMPORTANT: https://disqus.com/admin/universalcode/#configuration-variables*/\r\n/*\r\nvar disqus_config = function () {\r\nthis.page.url = PAGE_URL;  // Replace PAGE_URL with your page\'s canonical URL variable\r\nthis.page.identifier = PAGE_IDENTIFIER; // Replace PAGE_IDENTIFIER with your page\'s unique identifier variable\r\n};\r\n*/\r\n(function() { // DON\'T EDIT BELOW THIS LINE\r\nvar d = document, s = d.createElement(\'script\');\r\ns.src = \'https://plusagency.disqus.com/embed.js\';\r\ns.setAttribute(\'data-timestamp\', +new Date());\r\n(d.head || d.body).appendChild(s);\r\n})();\r\n</script>', 0, 'We are upgrading our site. We will come back soon. \r\nPlease stay with us.\r\nThank you....', '781b8e46f747e01ed91e520c8eb85dfcf84d46be.png', 0, NULL, 1, 1, 1, 1, 1, 'Our Partners', 'Take a Look at Our Amazing Partners', 1, 'Know More', 'about_us', 'https://www.youtube.com/watch?v=ufda7QD-EcM&t', 1, 'Features', 'How Eorder Works', 'Creative & User Friendly Design', 'See Our Restaurant Template', 'Our Featured Users', 'Take a Look at The Featured Users', 'Explore Attractive Pricing Features', 'Choose Your Plan', 'Our Happy Clients', 'What Our Clients Say', 1, 1, 1, 1, 'Blog', 'Latest Blog Posts', 'Useful Links', 'Newsletter', 'Get latest updates first', 0, '2367327069', 'Hi, There!', 'How can I help you?\r\ngreat', 0, 'AKIA42IHPRGEG42AS4G5', 'kLgOufX8W1tV3egeMINCqJyU7Qps57a/gRaNFQ/n', 'us-east-1', 'suppervsasso'),
(154, 177, 'b55defa7a38b66c98a655f890f6cd03aee2e05c9.png', '5abc08fb0f15ce2db52db532c5bcb16dea5f7601.png', 1, 'ae96227adb52366132cb13baa6eeae0e88ae50b8.gif', 'Eorder', 'FF6742', 'FF4B2B', 'e7daf03a5c751c5fac894b491ce0e851c323289f.jpg', 'a5f1030b1212f85c0c1db38ef1607d47eabad80a.png', 'نحن شركة متعددة الأطراف فائزة بشكل كبير. نحن نؤمن بالجودة والمعايير التي نأخذها بعين الاعتبار.', 'Subscribe to gate Latest News, Offer and connect With Us.', 0x3c703ed8acd985d98ad8b920d8a7d984d8add982d988d98220d985d8add981d988d8b8d8a920c2a920323032343c2f703e, 'قصتنا', 'لدينا 20 عاما من الخبرة العملية في مقهى.', 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها. ولذلك يتم استخدام', '6195e994095b0.png', 'اترك الرد', 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل', 'معلومات الاتصال', '<!--Start of Tawk.to Script-->\r\n<script type=\"text/javascript\">\r\nvar Tawk_API=Tawk_API||{}, Tawk_LoadStart=new Date();\r\n(function(){\r\nvar s1=document.createElement(\"script\"),s0=document.getElementsByTagName(\"script\")[0];\r\ns1.async=true;\r\ns1.src=\'https://embed.tawk.to/5f5e445f4704467e89ee918d/default\';\r\ns1.charset=\'UTF-8\';\r\ns1.setAttribute(\'crossorigin\',\'*\');\r\ns0.parentNode.insertBefore(s1,s0);\r\n})();\r\n</script>\r\n<!--End of Tawk.to Script-->', 1, '6LcOdFkpAAAAAETEI0CkavnbX8m8VLjj6YdU0yk3', '6LcOdFkpAAAAAKTyr4Jmx1zej7ych3ITX10MVwy3', 0, '60b886bbde99a4282a1b22a3', 'https://tawk.to/chat/62d688ec7b967b11799a42ee/1g8b0do1h', 1, 1, 'plusagency-2-5', '<script>\r\n\r\n/**\r\n*  RECOMMENDED CONFIGURATION VARIABLES: EDIT AND UNCOMMENT THE SECTION BELOW TO INSERT DYNAMIC VALUES FROM YOUR PLATFORM OR CMS.\r\n*  LEARN WHY DEFINING THESE VARIABLES IS IMPORTANT: https://disqus.com/admin/universalcode/#configuration-variables*/\r\n/*\r\nvar disqus_config = function () {\r\nthis.page.url = PAGE_URL;  // Replace PAGE_URL with your page\'s canonical URL variable\r\nthis.page.identifier = PAGE_IDENTIFIER; // Replace PAGE_IDENTIFIER with your page\'s unique identifier variable\r\n};\r\n*/\r\n(function() { // DON\'T EDIT BELOW THIS LINE\r\nvar d = document, s = d.createElement(\'script\');\r\ns.src = \'https://plusagency.disqus.com/embed.js\';\r\ns.setAttribute(\'data-timestamp\', +new Date());\r\n(d.head || d.body).appendChild(s);\r\n})();\r\n</script>', 0, 'We are upgrading our site. We will come back soon. \r\nPlease stay with us.\r\nThank you....', '781b8e46f747e01ed91e520c8eb85dfcf84d46be.png', 0, NULL, 1, 1, 1, 1, 1, 'لقد أثبت لنا إنجازنا العظيم!', 'لقد أكملنا أكثر من +500 مشروع برضا كلينت', 1, 'الفقرات في الصفحة التي', 'about_us', 'https://www.youtube.com/watch?v=ufda7QD-EcM&t', 1, 'متميز', 'آلية العمل', 'تصميم إبداعي وسهل الاستخدام', 'انظر نموذج التعليم الخاص بنا', 'مستخدم مميز', 'مستخدم مميز', 'التسعير', 'التسعير', 'شهادة', 'شهادة', 1, 1, 1, 1, 'المدونات', 'أحدث مدوناتنا', 'روابط مفيدة', 'النشرة الإخبارية', 'احصل على آخر التحديثات أولاً', 0, '2367327069', 'Hi, There!', 'How can I help you?\r\ngreat', 0, 'AKIA42IHPRGEG42AS4G5', 'kLgOufX8W1tV3egeMINCqJyU7Qps57a/gRaNFQ/n', 'us-east-1', 'suppervsasso');

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

--
-- Table structure for table `bcategories`
--

CREATE TABLE `bcategories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `serial_number` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bcategories`
--

INSERT INTO `bcategories` (`id`, `language_id`, `name`, `status`, `serial_number`) VALUES
(1, 176, 'Cooking', 1, 1),
(3, 176, 'Foods', 1, 2),
(4, 176, 'Burgers', 1, 3),
(5, 176, 'Fun & Jamming', 1, 4),
(6, 176, 'Recipes', 1, 5),
(7, 177, 'طبخ', 1, 1),
(8, 177, 'أغذية', 1, 2),
(9, 177, 'برجر', 1, 3),
(10, 177, 'المرح والتشويش', 1, 4),
(11, 177, 'وصفات', 1, 5);

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

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

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT '0',
  `bcategory_id` int(11) DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` blob,
  `tags` text COLLATE utf8mb4_unicode_ci,
  `meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `meta_description` text COLLATE utf8mb4_unicode_ci,
  `serial_number` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `blogs` (`id`, `language_id`, `bcategory_id`, `title`, `slug`, `main_image`, `content`, `tags`, `meta_keywords`, `meta_description`, `serial_number`, `created_at`, `updated_at`) VALUES
(66, 176, 1, 'Fusce convallis enim non magna Duis lacus dignissim.', 'Fusce-convallis-enim-non-magna-Duis-lacus-dignissim.', '431b138c2992e27b2ff5b0f843c51cf1d806973e.png', 0x3c703e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e3c2f703e, NULL, NULL, NULL, 1, '2020-08-29 03:47:49', '2024-01-20 23:00:06'),
(67, 176, 3, 'Non magna pharetra facilisis. lacus nulla dignissim.', 'Non-magna-pharetra-facilisis.-lacus-nulla-dignissim.', '394832e1e3bf55d0456c2a7a74430106af76bfc9.png', 0x3c703e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e3c2f703e, NULL, NULL, NULL, 2, '2020-08-29 03:50:37', '2024-01-20 23:16:53'),
(68, 176, 6, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor', 'Lorem-ipsum-dolor-sit-amet,-consectetur-adipiscing-elit,-sed-do-eiusmod-tempor', '03ed827469d0e3688fbc96f6223468e9c3fe0372.png', 0x3c703e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e3c2f703e, NULL, NULL, NULL, 3, '2020-08-29 03:51:34', '2024-01-20 22:44:35'),
(69, 176, 3, 'Fusce convallis enim non magna Duis lacus dignissim.', 'Fusce-convallis-enim-non-magna-Duis-lacus-dignissim.', 'a876ea5d6bb81e8c7f97476140694f76530dc6e1.png', 0x3c703e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e3c2f703e, NULL, NULL, NULL, 4, '2020-08-29 03:52:49', '2024-01-20 22:45:08'),
(70, 176, 1, 'Top 10 Most Popular E-commerce Website Template for Shopping', 'Top-10-Most-Popular-E-commerce-Website-Template-for-Shopping', '2121f447abc4ee04ae0ea0b20c7e9ba1a3ebf6f3.jpg', 0x69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e, NULL, NULL, NULL, 5, '2020-08-29 03:53:57', '2022-12-15 07:13:49'),
(71, 176, 5, 'Fusce convallis enim non magna Duis lacus dignissim.', 'Fusce-convallis-enim-non-magna-Duis-lacus-dignissim.', 'f2ba17caed8fffded57784e3c725cdce811be9b3.png', 0x3c703e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e3c2f703e, NULL, NULL, NULL, 6, '2020-08-29 03:54:35', '2024-01-20 22:57:37'),
(72, 176, 3, 'Non magna pharetra facilisis. lacus nulla dignissim.', 'Non-magna-pharetra-facilisis.-lacus-nulla-dignissim.', '09b95a916648c481eb752f6fe64c681edda224c1.png', 0x3c703e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e3c2f703e, NULL, NULL, NULL, 7, '2020-08-29 03:55:28', '2024-01-20 22:58:19'),
(73, 176, 3, 'Non magna pharetra facilisis. lacus nulla dignissim.', 'Non-magna-pharetra-facilisis.-lacus-nulla-dignissim.', 'bde9fc813dfa54105170b58b78710c8c27eaad53.png', 0x3c703e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e3c2f703e, NULL, NULL, NULL, 8, '2020-08-29 03:56:02', '2024-01-20 22:58:50'),
(74, 176, 1, 'Fusce convallis enim non magna Duis lacus dignissim.', 'Fusce-convallis-enim-non-magna-Duis-lacus-dignissim.', '6f15ad0fb8d24ba4ba38aba05676351dc189f7b9.png', 0x3c703e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e3c2f703e, NULL, NULL, NULL, 9, '2020-08-29 03:56:47', '2024-01-28 20:00:36'),
(75, 177, 7, 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز', 'هناك-حقيقة-مثبتة-منذ-زمن-طويل-وهي-أن-المحتوى-المقروء-لصفحة-ما-سيلهي-القارئ-عن-التركيز', 'a28ddbe2af3c4b17305a7f74e754c003f52fef48.png', 0x[encoded data, 5016 characters], NULL, NULL, NULL, 1, '2020-08-30 01:45:16', '2024-01-20 23:13:24'),
(76, 177, 8, 'المحتوى) ويُستخدم في صناعات المطابع ودور النشر. كان لوريم إيبسوم ولايزال المعيار للنص', 'المحتوى)-ويُستخدم-في-صناعات-المطابع-ودور-النشر.-كان-لوريم-إيبسوم-ولايزال-المعيار-للنص', '636bcf00af13471bf116a431d8e93380a1b5880f.png', 0x[encoded data, 5016 characters], NULL, NULL, NULL, 2, '2020-08-30 01:46:06', '2024-01-20 23:18:29'),
(77, 177, 11, 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز', 'هناك-حقيقة-مثبتة-منذ-زمن-طويل-وهي-أن-المحتوى-المقروء-لصفحة-ما-سيلهي-القارئ-عن-التركيز', '51194bdd5f3bc2ab156a3710fdb2aed641603832.png', 0x[encoded data, 5016 characters], NULL, NULL, NULL, 3, '2020-08-30 01:46:52', '2024-01-20 23:16:30'),
(78, 177, 8, 'لوريم إيبسوم(Lorem Ipsum) هو ببساطة نص شكلي (بمعنى أن الغاية هي الشكل وليس', 'لوريم-إيبسوم(Lorem-Ipsum)-هو-ببساطة-نص-شكلي-(بمعنى-أن-الغاية-هي-الشكل-وليس', '2fca126aeb088440178c6c2f86207b1d512c63d0.png', 0x[encoded data, 5016 characters], NULL, NULL, NULL, 4, '2020-08-30 01:47:51', '2024-01-20 23:16:09');
INSERT INTO `blogs` (`id`, `language_id`, `bcategory_id`, `title`, `slug`, `main_image`, `content`, `tags`, `meta_keywords`, `meta_description`, `serial_number`, `created_at`, `updated_at`) VALUES
(79, 177, 7, 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز', 'هناك-حقيقة-مثبتة-منذ-زمن-طويل-وهي-أن-المحتوى-المقروء-لصفحة-ما-سيلهي-القارئ-عن-التركيز', '4d4a2bbecacd4a19e6638e52296c5602017911c6.png', 0x[encoded data, 5016 characters], NULL, NULL, NULL, 5, '2020-08-30 01:48:56', '2024-01-20 23:15:50'),
(80, 177, 10, 'المحتوى) ويُستخدم في صناعات المطابع ودور النشر. كان لوريم إيبسوم ولايزال المعيار للنص', 'المحتوى)-ويُستخدم-في-صناعات-المطابع-ودور-النشر.-كان-لوريم-إيبسوم-ولايزال-المعيار-للنص', 'a35c821b455b8dc2fc34f49631d1823bfe448d70.png', 0x[encoded data, 5016 characters], NULL, NULL, NULL, 6, '2020-08-30 01:49:44', '2024-01-20 23:14:46'),
(81, 177, 8, 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز', 'هناك-حقيقة-مثبتة-منذ-زمن-طويل-وهي-أن-المحتوى-المقروء-لصفحة-ما-سيلهي-القارئ-عن-التركيز', 'bb1fda65c38e023f14f786e9710795ea96d066b1.png', 0x[encoded data, 5016 characters], NULL, NULL, NULL, 7, '2020-08-30 01:50:32', '2024-01-20 23:14:24'),
(82, 177, 8, 'المحتوى) ويُستخدم في صناعات المطابع ودور النشر. كان لوريم إيبسوم ولايزال المعيار للنص', 'المحتوى)-ويُستخدم-في-صناعات-المطابع-ودور-النشر.-كان-لوريم-إيبسوم-ولايزال-المعيار-للنص', 'd95e99bc271495aee5875f2811df05ccaaacf849.png', 0x[encoded data, 5016 characters], NULL, NULL, NULL, 8, '2020-08-30 01:51:11', '2024-01-20 23:14:04'),
(83, 177, 7, 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز', 'هناك-حقيقة-مثبتة-منذ-زمن-طويل-وهي-أن-المحتوى-المقروء-لصفحة-ما-سيلهي-القارئ-عن-التركيز', '9a18262f7c498bbf3895a063f302b967eb47dee2.png', 0x[encoded data, 5016 characters], NULL, NULL, NULL, 9, '2020-08-30 01:51:48', '2024-01-20 23:13:42');

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

--
-- Table structure for table `bottomlinks`
--

CREATE TABLE `bottomlinks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bottomlinks`
--

INSERT INTO `bottomlinks` (`id`, `language_id`, `user_id`, `name`, `url`, `created_at`, `updated_at`) VALUES
(5, 61, 2, 'Privacy Policy', '/fastifo/privacy-policy', NULL, NULL),
(6, 61, 2, 'Terms & Conditions', '/fastifo/terms-&-conditions', NULL, NULL),
(8, 62, 2, 'سياسة الخصوصية', '/fastifo/البنود-و-الظروف', NULL, NULL),
(9, 62, 2, 'البنود و الظروف', '/fastifo/سياسة-الخصوصية', NULL, NULL),
(10, 67, 6, 'Privacy Policy', '/tastify/privacy-policy', NULL, NULL),
(11, 67, 6, 'Terms & Conditions', '/tastify/terms-&-conditions', NULL, NULL),
(12, 68, 7, 'Privacy Policy', '/flavora/privacy-policy', NULL, NULL),
(13, 68, 7, 'Terms & Conditions', '/flavora/terms-&-conditions', NULL, NULL);

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

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `fname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_fname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_lname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_fname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_lname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `verification_link` text COLLATE utf8mb4_unicode_ci,
  `email_verified` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `pass_token` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `provider` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_country_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_country_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`id`, `user_id`, `fname`, `lname`, `photo`, `username`, `email`, `password`, `number`, `city`, `state`, `address`, `country`, `remember_token`, `billing_fname`, `billing_lname`, `billing_photo`, `billing_username`, `billing_email`, `billing_number`, `billing_city`, `billing_state`, `billing_address`, `billing_country`, `shipping_fname`, `shipping_lname`, `shipping_username`, `shipping_email`, `shipping_number`, `shipping_city`, `shipping_state`, `shipping_address`, `shipping_country`, `status`, `verification_link`, `email_verified`, `pass_token`, `created_at`, `updated_at`, `provider`, `provider_id`, `billing_country_code`, `shipping_country_code`) VALUES
(1, 2, 'Allen', 'Sid', NULL, 'allen', 'veha@mailinator.com', '$2a$12$y.7QzXrgWFSMVCQecP9k3uaXIlKcltuDVLkvpIX8Odf5HBacqRTx2', '(765) 289-2361', 'Muncie', 'Iowa', '1717 N Wheeling Ave, Muncie, United States', 'United States', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'Yes', NULL, '2024-01-19 19:20:18', '2024-01-22 08:03:13', NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'percentage, fixed',
  `value` decimal(11,2) DEFAULT NULL,
  `packages` text COLLATE utf8mb4_unicode_ci,
  `start_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `minimum_spend` decimal(11,2) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `coupons`
--

INSERT INTO `coupons` (`id`, `name`, `code`, `type`, `value`, `packages`, `start_date`, `end_date`, `minimum_spend`, `created_at`, `updated_at`) VALUES
(2, 'KHABO60', 'KHABO60', 'fixed', '60.00', NULL, '12/24/2020', '12/30/2020', '180.00', '2020-12-23 02:23:36', '2020-12-23 02:23:36'),
(3, 'Victory Day', 'BIJOY16', 'percentage', '16.00', NULL, '12/16/2020', '01/07/2021', '10.00', '2020-12-23 02:32:55', '2020-12-24 04:54:59'),
(4, 'Special', 'Special14', 'percentage', '14.00', NULL, '12/29/2020', '01/09/2021', '400.00', '2020-12-23 03:54:07', '2020-12-24 08:54:42'),
(5, 'Cricket', '123', 'percentage', '5.00', '[\"39\",\"40\"]', '12/03/2023', '12/28/2023', '100.00', '2023-12-04 10:36:24', '2023-12-04 10:42:52');

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text 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 `customers`
--

INSERT INTO `customers` (`id`, `user_id`, `name`, `email`, `phone`, `address`, `created_at`, `updated_at`) VALUES
(6, 2, 'Henry', 'hixutotos@mailinator.com', '0123654789', NULL, '2024-01-20 22:24:09', '2024-01-30 13:15:22'),
(7, 2, 'Piterson', 'wygun@mailinator.com', '78945612301', NULL, '2024-01-20 22:25:33', '2024-01-30 13:15:10');

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

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

CREATE TABLE `email_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email_type` varchar(100) DEFAULT NULL,
  `email_subject` text,
  `email_body` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `email_templates` (`id`, `email_type`, `email_subject`, `email_body`) VALUES
(2, 'email_verification', 'Verify Your Email', '<p style=\"line-height: 1.6;\">Hello<b> {customer_name}</b>,</p><p style=\"line-height: 1.6;\"><br>Please click the link below to verify your email.</p><p>{verification_link}</p><p><br></p><p>Best Regards,</p><p>{website_title}</p>'),
(12, 'custom_domain_connected', 'Custom Domain is Connected with Our Server', 'Hi {username},<br><br>\n\nThanks for your custom domain request.<br>\nYour requested domain {requested_domain} has been connected to your server.<br>\nPlease <strong>clear your browser cache</strong> & visit {requested_domain} to see your portfolio website.<br>\n\nYour current domain: {requested_domain}.<br>\nYour previous domain: {previous_domain}.<br><br>\n\nBest Regards,<br>\n{website_title}.<br>'),
(13, 'custom_domain_rejected', 'Custom Domain Request is Rejected', 'Hi {username},<br><br>\r\n\r\nThanks for your custom domain request.<br>\r\nUnfortunately, we have rejected your custom domain request<br>\r\n\r\nYour requested domain: {requested_domain}.<br>\r\nYour current domain: {current_domain}.<br><br>\r\n\r\nBest Regards,<br>\r\n{website_title}.<br>'),
(16, 'registration_with_premium_package', 'You have registered successfully', '<p>Hi {username},<br /><br />\n\nThis is a confirmation mail from us</p><p><b><span style=\"font-size:18px;\">Membership Information:</span></b><br /><strong>Package Title:</strong> {package_title}<br /><strong>Package Price:</strong> {package_price}</p><p><b>Discount:</b> {discount}</p><p><span style=\"font-weight:600;\">Total:</span> {total}<br /><strong>Activation Date:</strong> {activation_date}<br /><strong>Expire Date:</strong> {expire_date}</p><p><br /></p><p>We have attached an invoice with this mail.<br />\nThank you for your purchase.</p><p><br />\n\nBest Regards,<br />\n{website_title}.<br /></p>'),
(17, 'registration_with_trial_package', 'You have registered successfully', 'Hi {username},<br /><br />\r\n\r\nThis is a confirmation mail from us.<br />\r\nYou have purchased a trial package<br /><br />\r\n\r\n<h4>Membership Information:</h4>\r\n<strong>Package Title:</strong> {package_title}<br />\r\n<strong>Package Price:</strong> {package_price}<br />\r\n<strong>Activation Date:</strong> {activation_date}<br />\r\n<strong>Expire Date:</strong> {expire_date}<br /><br />\r\n\r\nWe have attached an invoice in this mail<br />\r\nThank you for your purchase.<br /><br />\r\n\r\nBest Regards,<br />\r\n{website_title}.<br />'),
(18, 'registration_with_free_package', 'You have registered successfully', 'Hi {username},<br /><br />\r\n\r\nThis is a confirmation mail from us.<br />\r\nYou have purchased a free package<br /><br />\r\n\r\n<h4>Membership Information:</h4>\r\n<strong>Package Title:</strong> {package_title}<br />\r\n<strong>Package Price:</strong> {package_price}<br />\r\n<strong>Activation Date:</strong> {activation_date}<br />\r\n<strong>Expire Date:</strong> {expire_date}<br /><br />\r\n\r\nWe have attached an invoice in this mail<br />\r\nThank you for your purchase.<br /><br />\r\n\r\nBest Regards,<br />\r\n{website_title}.<br />'),
(19, 'membership_expiry_reminder', 'Your membership will be expired soon', 'Hi {username},<br /><br />\r\n\r\nYour membership will be expired soon.<br />\r\nYour membership is valid till <strong>{last_day_of_membership}</strong><br />\r\nPlease click here - {login_link} to log into the dashboard to purchase a new package / extend the current package to extend your membership.<br /><br />\r\n\r\nBest Regards,<br />\r\n{website_title}.'),
(20, 'membership_expired', 'Your membership is expired', 'Hi {username},<br><br>\r\n\r\nYour membership is expired.<br>\r\nPlease click here - {login_link} to log into the dashboard to purchase a new package / extend the current package to continue the membership.<br><br>\r\n\r\nBest Regards,<br>\r\n{website_title}.'),
(21, 'membership_extend', 'Your membership is extended', '<p>Hi {username},<br /><br />\n\nThis is a confirmation mail from us.<br />\nYou have extended your membership.<br />\n\n<strong>Package Title:</strong> {package_title}<br />\n<strong>Package Price:</strong> {package_price}<br />\n<strong>Activation Date:</strong> {activation_date}<br />\n<strong>Expire Date:</strong> {expire_date}</p><p><br /></p><p>We have attached an invoice with this mail.<br />\nThank you for your purchase.</p><p><br />\n\nBest Regards,<br />\n{website_title}.<br /></p>'),
(22, 'payment_accepted_for_membership_extension_offline_gateway', 'Your payment for membership extension is accepted', '<p>Hi {username},<br /><br />\r\n\r\nThis is a confirmation mail from us.<br />\r\nYour payment has been accepted & your membership is extended.<br />\r\n\r\n<strong>Package Title:</strong> {package_title}<br />\r\n<strong>Package Price:</strong> {package_price}<br />\r\n<strong>Activation Date:</strong> {activation_date}<br />\r\n<strong>Expire Date:</strong> {expire_date}</p><p><br /></p><p>We have attached an invoice with this mail.<br />\r\nThank you for your purchase.</p><p><br />\r\n\r\nBest Regards,<br />\r\n{website_title}.<br /></p>'),
(23, 'payment_accepted_for_registration_offline_gateway', 'Your payment for registration is approved', '<p>Hi {username},<br /><br />\r\n\r\nThis is a confirmation mail from us.<br />\r\nYour payment has been accepted & now you can login to your user dashboard to build your portfolio website.<br />\r\n\r\n<strong>Package Title:</strong> {package_title}<br />\r\n<strong>Package Price:</strong> {package_price}<br />\r\n<strong>Activation Date:</strong> {activation_date}<br />\r\n<strong>Expire Date:</strong> {expire_date}</p><p><br /></p><p>We have attached an invoice with this mail.<br />\r\nThank you for your purchase.</p><p><br />\r\n\r\nBest Regards,<br />\r\n{website_title}.<br /></p>'),
(24, 'payment_rejected_for_membership_extension_offline_gateway', 'Your payment for membership extension is rejected', '<p>Hi {username},<br /><br />\r\n\r\nWe are sorry to inform you that your payment has been rejected<br />\r\n\r\n<strong>Package Title:</strong> {package_title}<br />\r\n<strong>Package Price:</strong> {package_price}<br />\r\n\r\nBest Regards,<br />\r\n{website_title}.<br /></p>'),
(25, 'payment_rejected_for_registration_offline_gateway', 'Your payment for registration is rejected', '<p>Hi {username},<br /><br />\r\n\r\nWe are sorry to inform you that your payment has been rejected<br>\r\n\r\n<strong>Package Title:</strong> {package_title}<br />\r\n<strong>Package Price:</strong> {package_price}<br />\r\n\r\nBest Regards,<br />\r\n{website_title}.<br /></p>'),
(26, 'admin_changed_current_package', 'Admin has changed your current package', '<p>Hi {username},<br /><br />\r\n\r\nAdmin has changed your current package <b>({replaced_package})</b></p>\r\n<p><b>New Package Information:</b></p>\r\n<p>\r\n<strong>Package:</strong> {package_title}<br />\r\n<strong>Package Price:</strong> {package_price}<br />\r\n<strong>Activation Date:</strong> {activation_date}<br />\r\n<strong>Expire Date:</strong> {expire_date}</p><p><br /></p><p>We have attached an invoice with this mail.<br />\r\nThank you for your purchase.</p><p><br />\r\n\r\nBest Regards,<br />\r\n{website_title}.<br /></p>'),
(27, 'admin_added_current_package', 'Admin has added current package for you', '<p>Hi {username},<br /><br />\r\n\r\nAdmin has added current package for you</p><p><b><span style=\"font-size:18px;\">Current Membership Information:</span></b><br />\r\n<strong>Package Title:</strong> {package_title}<br />\r\n<strong>Package Price:</strong> {package_price}<br />\r\n<strong>Activation Date:</strong> {activation_date}<br />\r\n<strong>Expire Date:</strong> {expire_date}</p><p><br /></p><p>We have attached an invoice with this mail.<br />\r\nThank you for your purchase.</p><p><br />\r\n\r\nBest Regards,<br />\r\n{website_title}.<br /></p>'),
(28, 'admin_changed_next_package', 'Admin has changed your next package', '<p>Hi {username},<br /><br />\r\n\r\nAdmin has changed your next package <b>({replaced_package})</b></p><p><b><span style=\"font-size:18px;\">Next Membership Information:</span></b><br />\r\n<strong>Package Title:</strong> {package_title}<br />\r\n<strong>Package Price:</strong> {package_price}<br />\r\n<strong>Activation Date:</strong> {activation_date}<br />\r\n<strong>Expire Date:</strong> {expire_date}</p><p><br /></p><p>We have attached an invoice with this mail.<br />\r\nThank you for your purchase.</p><p><br />\r\n\r\nBest Regards,<br />\r\n{website_title}.<br /></p>'),
(29, 'admin_added_next_package', 'Admin has added next package for you', '<p>Hi {username},<br /><br />\r\n\r\nAdmin has added next package for you</p><p><b><span style=\"font-size:18px;\">Next Membership Information:</span></b><br />\r\n<strong>Package Title:</strong> {package_title}<br />\r\n<strong>Package Price:</strong> {package_price}<br />\r\n<strong>Activation Date:</strong> {activation_date}<br />\r\n<strong>Expire Date:</strong> {expire_date}</p><p><br /></p><p>We have attached an invoice with this mail.<br />\r\nThank you for your purchase.</p><p><br />\r\n\r\nBest Regards,<br />\r\n{website_title}.<br /></p>'),
(30, 'admin_removed_current_package', 'Admin has removed current package for you', '<p>Hi {username},<br /><br />\r\n\r\nAdmin has removed current package - <strong>{removed_package_title}</strong><br>\r\n\r\nBest Regards,<br />\r\n{website_title}.<br />'),
(31, 'admin_removed_next_package', 'Admin has removed next package for you', '<p>Hi {username},<br /><br />\r\n\r\nAdmin has removed next package - <strong>{removed_package_title}</strong><br>\r\n\r\nBest Regards,<br />\r\n{website_title}.<br />');

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

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

CREATE TABLE `faqs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT '0',
  `question` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `answer` text COLLATE utf8mb4_unicode_ci,
  `serial_number` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `faqs` (`id`, `language_id`, `question`, `answer`, `serial_number`) VALUES
(20, 176, 'Why this app is so awesome', 'Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod.', 1),
(21, 176, 'Why this app is so awesome', 'Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod.', 2),
(22, 176, 'Why this app is so awesome', 'Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod.', 3),
(23, 176, 'Why this app is so awesome', 'Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod.', 4),
(24, 176, 'Why this app is so awesome', 'Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod.', 5),
(25, 176, 'Why this app is so awesome', 'Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod.', 6),
(26, 176, 'Why this app is so awesome', 'Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod.', 7),
(27, 176, 'Why this app is so awesome', 'Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod.', 8),
(28, 176, 'Why this app is so awesome', 'Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod.', 9),
(29, 176, 'Why this app is so awesome', 'Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod.', 10),
(50, 177, 'لماذا هذا التطبيق رائع جدا', 'الرسوم المتحركة pariatur كليشيه reprehenderit ، enim eiusmod حياة عالية accusamus تيري ريتشاردسون الإعلانية الحبار. 3 الذئب القمر officia aute ، غير cupidatat غداء دولر لوح التزلج. شاحنة الغذاء الكينوا nesciunt labum eiusmod.', 1),
(51, 177, 'لماذا هذا التطبيق رائع جدا', 'الرسوم المتحركة pariatur كليشيه reprehenderit ، enim eiusmod حياة عالية accusamus تيري ريتشاردسون الإعلانية الحبار. 3 الذئب القمر officia aute ، غير cupidatat غداء دولر لوح التزلج. شاحنة الغذاء الكينوا nesciunt labum eiusmod.', 2),
(52, 177, 'لماذا هذا التطبيق رائع جدا', 'الرسوم المتحركة pariatur كليشيه reprehenderit ، enim eiusmod حياة عالية accusamus تيري ريتشاردسون الإعلانية الحبار. 3 الذئب القمر officia aute ، غير cupidatat غداء دولر لوح التزلج. شاحنة الغذاء الكينوا nesciunt labum eiusmod.', 3),
(53, 177, 'لماذا هذا التطبيق رائع جدا', 'الرسوم المتحركة pariatur كليشيه reprehenderit ، enim eiusmod حياة عالية accusamus تيري ريتشاردسون الإعلانية الحبار. 3 الذئب القمر officia aute ، غير cupidatat غداء دولر لوح التزلج. شاحنة الغذاء الكينوا nesciunt labum eiusmod.', 4),
(54, 177, 'لماذا هذا التطبيق رائع جدا', 'الرسوم المتحركة pariatur كليشيه reprehenderit ، enim eiusmod حياة عالية accusamus تيري ريتشاردسون الإعلانية الحبار. 3 الذئب القمر officia aute ، غير cupidatat غداء دولر لوح التزلج. شاحنة الغذاء الكينوا nesciunt labum eiusmod.', 5),
(55, 177, 'لماذا هذا التطبيق رائع جدا', 'الرسوم المتحركة pariatur كليشيه reprehenderit ، enim eiusmod حياة عالية accusamus تيري ريتشاردسون الإعلانية الحبار. 3 الذئب القمر officia aute ، غير cupidatat غداء دولر لوح التزلج. شاحنة الغذاء الكينوا nesciunt labum eiusmod.', 6),
(56, 177, 'لماذا هذا التطبيق رائع جدا', 'الرسوم المتحركة pariatur كليشيه reprehenderit ، enim eiusmod حياة عالية accusamus تيري ريتشاردسون الإعلانية الحبار. 3 الذئب القمر officia aute ، غير cupidatat غداء دولر لوح التزلج. شاحنة الغذاء الكينوا nesciunt labum eiusmod.', 7),
(57, 177, 'لماذا هذا التطبيق رائع جدا', 'الرسوم المتحركة pariatur كليشيه reprehenderit ، enim eiusmod حياة عالية accusamus تيري ريتشاردسون الإعلانية الحبار. 3 الذئب القمر officia aute ، غير cupidatat غداء دولر لوح التزلج. شاحنة الغذاء الكينوا nesciunt labum eiusmod.', 8),
(58, 177, 'لماذا هذا التطبيق رائع جدا', 'الرسوم المتحركة pariatur كليشيه reprehenderit ، enim eiusmod حياة عالية accusamus تيري ريتشاردسون الإعلانية الحبار. 3 الذئب القمر officia aute ، غير cupidatat غداء دولر لوح التزلج. شاحنة الغذاء الكينوا nesciunt labum eiusmod.', 9),
(59, 177, 'لماذا هذا التطبيق رائع جدا', 'الرسوم المتحركة pariatur كليشيه reprehenderit ، enim eiusmod حياة عالية accusamus تيري ريتشاردسون الإعلانية الحبار. 3 الذئب القمر officia aute ، غير cupidatat غداء دولر لوح التزلج. شاحنة الغذاء الكينوا nesciunt labum eiusmod.', 10);

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

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

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

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

INSERT INTO `features` (`id`, `language_id`, `image`, `title`, `text`, `serial_number`, `created_at`, `updated_at`) VALUES
(37, 176, '27a7a4cd27a70e5b2acc32ede1961d91662f6664.png', 'Realtime order', 'Instantly track orders, live updates', 1, NULL, NULL),
(38, 176, 'a28705da033bb0862d29b9268260a81a71f0c6fd.png', 'QR Builder', 'Create instant QR codes with QR Builder', 2, NULL, NULL),
(42, 176, '556c9ff8ee69a073139243df4ddde63c5916e409.png', 'Whatsapp notification', 'New messages Stay connected on WhatsApp', 3, NULL, NULL),
(43, 176, '63b4c2334f3d16cb546e7c05e7139ac057b79790.png', 'POS', 'Efficient POS system for seamless transactions', 4, NULL, NULL),
(50, 176, '2d346bf317e87d685ccf0e3f37939432b8515d8b.png', 'Progressive Web App', 'Fast, reliable, and engaging', 5, NULL, NULL),
(51, 176, 'de45d4cfc04ddf427fdb4db32a674a16ed0ef6b2.png', 'Amazon AWS s3', 'Secure, scalable, and reliable storage', 6, NULL, NULL),
(52, 177, '186eac72f43bfd5adedbd68b4dce6e90bf4b5731.png', 'أغذية صحية', 'تتبع الطلبات على الفور، والتحديثات الحية', 1, NULL, NULL),
(53, 177, '8aade47e5116415bc8c5609156d9efea7612f56e.png', 'الأصناف الطازجة', 'الطازجة الطازجة الطازجة الطازجة الطازجة', 2, NULL, NULL),
(54, 177, 'bbb535aa35719d83de0339af1e436addc8287b2f.png', 'إشعار واتس اب', 'رسائل جديدة ابق على اتصال على', 3, NULL, NULL),
(55, 177, 'e6d44b4559ea40ae435fe2221ed02e088bfe364a.png', 'جبن حلو', 'نظام نقاط البيع الفعال لإجراء معاملات سلسة', 4, NULL, NULL),
(56, 177, '303af305df65bc64aa6770bedf6eca8bf43706e7.png', 'أفضل بيتزا', 'سريع وموثوق وجذاب', 5, NULL, NULL),
(57, 177, 'c3e61ff804aa8a56a117def551a08e87e5208c7d.png', 'وجبات خفيفة ساخنة', 'تخزين آمن وقابل للتطوير وموثوق', 6, NULL, NULL);

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

--
-- Table structure for table `galleries`
--

CREATE TABLE `galleries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `serial_number` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `galleries`
--

INSERT INTO `galleries` (`id`, `language_id`, `user_id`, `title`, `image`, `serial_number`, `created_at`, `updated_at`) VALUES
(8, 61, 2, 'Tomatoes', 'd6e0ec39a8731c0b6a9c6793acad13923dd826dc.jpg', 7, '2024-01-19 19:32:11', '2024-01-19 19:32:11'),
(9, 61, 2, 'Wine Glasses', '555c8f82b8509be10d400945824a83f7fc373800.jpg', 6, '2024-01-19 19:32:35', '2024-01-19 19:32:35'),
(10, 61, 2, 'Black Burger', '1c7d153050c9f001d55dea66989510e3d14b76b3.jpg', 5, '2024-01-19 19:33:00', '2024-01-19 19:33:00'),
(11, 61, 2, 'Cutting Vegetables', '637cdd0767717e99884baf1ec083599b20b43b98.jpg', 4, '2024-01-19 19:33:55', '2024-01-19 19:33:55'),
(12, 61, 2, 'Blackberry', 'b9e80247b8c2d06dd6b4cfc67a4811de69922c39.jpg', 3, '2024-01-19 19:34:16', '2024-01-19 19:34:16'),
(13, 61, 2, 'Chef Cooking', '147cae2b8dbfa798dabf9cc024c66a5cfc4069e4.jpg', 2, '2024-01-19 19:34:56', '2024-01-19 19:34:56'),
(14, 61, 2, 'Boti Kabab', 'eb2f0f84096b98aa33922e839868874498b973d3.jpg', 1, '2024-01-19 19:35:10', '2024-01-19 19:35:10'),
(15, 62, 2, 'طماطم', '0a1888fe996f97844f12cafc229302fc380890c7.jpg', 7, '2024-01-19 19:35:35', '2024-01-19 19:35:35'),
(16, 62, 2, 'كؤوس النبيذ', '3759ee3744576d4b96fd66f6500ddd9fe839bd6d.jpg', 6, '2024-01-19 19:35:55', '2024-01-19 19:35:55'),
(17, 62, 2, 'بلاك برجر', '179137426f971803401938592b36005ba0e99e78.jpg', 5, '2024-01-19 19:36:17', '2024-01-19 19:36:17'),
(18, 62, 2, 'تقطيع الخضار', '06adc4e81a3b5a388ac1add8646a88f9a41b61a3.jpg', 4, '2024-01-19 19:36:42', '2024-01-19 19:36:42'),
(19, 62, 2, 'بلاك بيري', '17069858541213c1c43c3cdf9d501b48bb54c003.jpg', 3, '2024-01-19 19:36:59', '2024-01-19 19:36:59'),
(20, 62, 2, 'طاه الطبخ', '13bd14d3ae9989e0ec158b014cdfd127093a2ac8.jpg', 2, '2024-01-19 19:37:18', '2024-01-19 19:37:18'),
(21, 62, 2, 'بوتي كباب', '9760e5e265a043d249c0519178c1aca753c7149f.jpg', 1, '2024-01-19 19:39:05', '2024-01-19 19:39:05');

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

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

CREATE TABLE `guests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `endpoint` 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 `jcategories`
--

CREATE TABLE `jcategories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `serial_number` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jcategories`
--

INSERT INTO `jcategories` (`id`, `language_id`, `user_id`, `name`, `status`, `serial_number`, `created_at`, `updated_at`) VALUES
(3, 61, 2, 'Andriod Developer', 1, 5, '2024-01-19 19:22:13', '2024-01-19 19:22:13'),
(4, 61, 2, 'IOS Developer', 1, 4, '2024-01-19 19:22:27', '2024-01-19 19:22:27'),
(5, 61, 2, 'Team Leader', 1, 3, '2024-01-19 19:22:46', '2024-01-19 19:22:46'),
(6, 61, 2, 'Web Designer', 1, 2, '2024-01-19 19:23:03', '2024-01-19 19:23:03'),
(7, 61, 2, 'Web Developer', 1, 1, '2024-01-19 19:23:27', '2024-01-19 19:23:27'),
(8, 62, 2, 'الروبوت المطور', 1, 5, '2024-01-19 19:41:39', '2024-01-19 19:41:39'),
(9, 62, 2, 'مطورIOS', 1, 4, '2024-01-19 19:42:28', '2024-01-19 19:42:28'),
(10, 62, 2, 'رئيس الفريق', 1, 3, '2024-01-19 19:42:38', '2024-01-19 19:42:38'),
(11, 62, 2, 'مصمم الويب', 1, 2, '2024-01-19 19:42:55', '2024-01-19 19:42:55'),
(12, 62, 2, 'مطور ويب', 1, 1, '2024-01-19 19:43:06', '2024-01-19 19:43:06');

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

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

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `jcategory_id` int(11) DEFAULT NULL,
  `language_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vacancy` int(11) DEFAULT NULL,
  `deadline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `experience` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_responsibilities` blob,
  `employment_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `educational_requirements` blob,
  `experience_requirements` blob,
  `additional_requirements` blob,
  `job_location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `salary` blob,
  `benefits` blob,
  `read_before_apply` blob,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `serial_number` int(11) NOT NULL DEFAULT '0',
  `meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `meta_description` text 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 `jobs`
--

INSERT INTO `jobs` (`id`, `jcategory_id`, `language_id`, `user_id`, `title`, `slug`, `vacancy`, `deadline`, `experience`, `job_responsibilities`, `employment_status`, `educational_requirements`, `experience_requirements`, `additional_requirements`, `job_location`, `salary`, `benefits`, `read_before_apply`, `email`, `serial_number`, `meta_keywords`, `meta_description`, `created_at`, `updated_at`) VALUES
(3, 5, 61, 2, 'Agriculture Market Systems Leader', 'Agriculture-Market-Systems-Leader', 4, '02/14/2024', '4', 0x3c703e596f75206861766520746f20626520657870657269656e6365642077697468205549206672616d65776f726b7320696e2067656e6572616c3b207765206c6f76652074686520416e67756c617220616e6420416e67756c6172206d6174657269616c2e3c62723e596f75206861766520746f20626520657870657269656e63656420696e206275696c64696e672053696e676c652050616765204170706c69636174696f6e732028535041292026616d703b20696e746567726174696e672057656220285265737429204150492e3c62723e57656c6c20766572736564207769746820416e67756c6172206d6f64756c6573206f7220796f752068617665206372656174656420637573746f6d20616e642077656220636f6d706f6e656e747320627920796f757273656c662e3c62723e596f75206d75737420686176652070726163746963616c20657870657269656e6365206f6e204e6f64652e6a732c20547970655363726970742c207765627061636b20616e64205468697264207061727479206c6962726172792e3c62723e596f75206861766520616e20696e2d646570746820756e6465727374616e64696e67206f662063726f73732062726f7773657220636f6d7061746962696c69747920616e6420796f7520646f206e6f7420637265617465206275677320666f72207375636820726561736f6e732e3c62723e596f752061726520706978656c2d7065726665637420696e2064657369676e20636f6e76657273696f6e7320616e6420796f75207468696e6b206f66206d6f62696c652d666972737420696d706c656d656e746174696f6e732e3c62723e596f752073686f756c642068617665206b6e6f776c65646765206f66204353532070726570726f636573736f72732c204d6564696120717565726965732c20496d61676520636f6d7072657373696f6e20616e6420626520676f6f64207769746820646562756767696e672e3c2f703e, 'Full-time', 0x3c703e596f75206861766520746f20626520657870657269656e6365642077697468205549206672616d65776f726b7320696e2067656e6572616c3b207765206c6f76652074686520416e67756c617220616e6420416e67756c6172206d6174657269616c2e3c62723e596f75206861766520746f20626520657870657269656e63656420696e206275696c64696e672053696e676c652050616765204170706c69636174696f6e732028535041292026616d703b20696e746567726174696e672057656220285265737429204150492e3c62723e57656c6c20766572736564207769746820416e67756c6172206d6f64756c6573206f7220796f752068617665206372656174656420637573746f6d20616e642077656220636f6d706f6e656e747320627920796f757273656c662e3c2f703e, 0x3c703e596f75206861766520746f20626520657870657269656e6365642077697468205549206672616d65776f726b7320696e2067656e6572616c3b207765206c6f76652074686520416e67756c617220616e6420416e67756c6172206d6174657269616c2e3c62723e596f75206861766520746f20626520657870657269656e63656420696e206275696c64696e672053696e676c652050616765204170706c69636174696f6e732028535041292026616d703b20696e746567726174696e672057656220285265737429204150492e3c62723e57656c6c20766572736564207769746820416e67756c6172206d6f64756c6573206f7220796f752068617665206372656174656420637573746f6d20616e642077656220636f6d706f6e656e747320627920796f757273656c662e3c62723e596f752073686f756c642068617665206b6e6f776c65646765206f66204353532070726570726f636573736f72732c204d6564696120717565726965732c20496d61676520636f6d7072657373696f6e20616e6420626520676f6f64207769746820646562756767696e672e3c2f703e, 0x3c703e596f75206861766520616e20696e2d646570746820756e6465727374616e64696e67206f662063726f73732062726f7773657220636f6d7061746962696c69747920616e6420796f7520646f206e6f7420637265617465206275677320666f72207375636820726561736f6e732e3c62723e596f752061726520706978656c2d7065726665637420696e2064657369676e20636f6e76657273696f6e7320616e6420796f75207468696e6b206f66206d6f62696c652d666972737420696d706c656d656e746174696f6e732e3c62723e596f752073686f756c642068617665206b6e6f776c65646765206f66204353532070726570726f636573736f72732c204d6564696120717565726965732c20496d61676520636f6d7072657373696f6e20616e6420626520676f6f64207769746820646562756767696e672e3c2f703e, 'California, USA', 0x3c703e2431303030202d2024313530303c2f703e, 0x3c703e596f75206861766520616e20696e2d646570746820756e6465727374616e64696e67206f662063726f73732062726f7773657220636f6d7061746962696c69747920616e6420796f7520646f206e6f7420637265617465206275677320666f72207375636820726561736f6e732e3c62723e596f752061726520706978656c2d7065726665637420696e2064657369676e20636f6e76657273696f6e7320616e6420796f75207468696e6b206f66206d6f62696c652d666972737420696d706c656d656e746174696f6e732e3c62723e596f752073686f756c642068617665206b6e6f776c65646765206f66204353532070726570726f636573736f72732c204d6564696120717565726965732c20496d61676520636f6d7072657373696f6e20616e6420626520676f6f64207769746820646562756767696e672e3c2f703e, NULL, 'drop_your_cv@plusagency.com', 4, NULL, NULL, '2024-01-19 19:25:45', '2024-01-19 19:25:45'),
(4, 6, 61, 2, 'Front End Software Engineer', 'Front-End-Software-Engineer', 5, '01/26/2024', '2 to 5 year(s)', 0x3c703e596f75206861766520746f20626520657870657269656e6365642077697468205549206672616d65776f726b7320696e2067656e6572616c3b207765206c6f76652074686520416e67756c617220616e6420416e67756c6172206d6174657269616c2e3c62723e596f75206861766520746f20626520657870657269656e63656420696e206275696c64696e672053696e676c652050616765204170706c69636174696f6e732028535041292026616d703b20696e746567726174696e672057656220285265737429204150492e3c62723e57656c6c20766572736564207769746820416e67756c6172206d6f64756c6573206f7220796f752068617665206372656174656420637573746f6d20616e642077656220636f6d706f6e656e747320627920796f757273656c662e3c62723e596f75206d75737420686176652070726163746963616c20657870657269656e6365206f6e204e6f64652e6a732c20547970655363726970742c207765627061636b20616e64205468697264207061727479206c6962726172792e3c62723e596f75206861766520616e20696e2d646570746820756e6465727374616e64696e67206f662063726f73732062726f7773657220636f6d7061746962696c69747920616e6420796f7520646f206e6f7420637265617465206275677320666f72207375636820726561736f6e732e3c62723e596f752061726520706978656c2d7065726665637420696e2064657369676e20636f6e76657273696f6e7320616e6420796f75207468696e6b206f66206d6f62696c652d666972737420696d706c656d656e746174696f6e732e3c62723e596f752073686f756c642068617665206b6e6f776c65646765206f66204353532070726570726f636573736f72732c204d6564696120717565726965732c20496d61676520636f6d7072657373696f6e20616e6420626520676f6f64207769746820646562756767696e672e3c2f703e, 'Full-time', 0x3c703e596f75206d75737420686176652070726163746963616c20657870657269656e6365206f6e204e6f64652e6a732c20547970655363726970742c207765627061636b20616e64205468697264207061727479206c6962726172792e3c62723e596f75206861766520616e20696e2d646570746820756e6465727374616e64696e67206f662063726f73732062726f7773657220636f6d7061746962696c69747920616e6420796f7520646f206e6f7420637265617465206275677320666f72207375636820726561736f6e732e3c62723e596f752061726520706978656c2d7065726665637420696e2064657369676e20636f6e76657273696f6e7320616e6420796f75207468696e6b206f66206d6f62696c652d666972737420696d706c656d656e746174696f6e732e3c62723e596f752073686f756c642068617665206b6e6f776c65646765206f66204353532070726570726f636573736f72732c204d6564696120717565726965732c20496d61676520636f6d7072657373696f6e20616e6420626520676f6f64207769746820646562756767696e672e3c2f703e, 0x3c703e3120746f20332079656172733c2f703e, 0x3c703e596f75206861766520746f20626520657870657269656e6365642077697468205549206672616d65776f726b7320696e2067656e6572616c3b207765206c6f76652074686520416e67756c617220616e6420416e67756c6172206d6174657269616c2e3c62723e596f75206861766520746f20626520657870657269656e63656420696e206275696c64696e672053696e676c652050616765204170706c69636174696f6e732028535041292026616d703b20696e746567726174696e672057656220285265737429204150492e3c62723e57656c6c20766572736564207769746820416e67756c6172206d6f64756c6573206f7220796f752068617665206372656174656420637573746f6d20616e642077656220636f6d706f6e656e747320627920796f757273656c662e3c62723e596f75206d75737420686176652070726163746963616c20657870657269656e6365206f6e204e6f64652e6a732c20547970655363726970742c207765627061636b20616e64205468697264207061727479206c6962726172792e3c2f703e, 'Paris, France', 0x3c703e4e65676f746961626c653c2f703e, 0x3c703e596f75206861766520746f20626520657870657269656e6365642077697468205549206672616d65776f726b7320696e2067656e6572616c3b207765206c6f76652074686520416e67756c617220616e6420416e67756c6172206d6174657269616c2e3c62723e596f75206861766520746f20626520657870657269656e63656420696e206275696c64696e672053696e676c652050616765204170706c69636174696f6e732028535041292026616d703b20696e746567726174696e672057656220285265737429204150492e3c62723e57656c6c20766572736564207769746820416e67756c6172206d6f64756c6573206f7220796f752068617665206372656174656420637573746f6d20616e642077656220636f6d706f6e656e747320627920796f757273656c662e3c62723e596f75206d75737420686176652070726163746963616c20657870657269656e6365206f6e204e6f64652e6a732c20547970655363726970742c207765627061636b20616e64205468697264207061727479206c6962726172792e3c62723e596f752073686f756c642068617665206b6e6f776c65646765206f66204353532070726570726f636573736f72732c204d6564696120717565726965732c20496d61676520636f6d7072657373696f6e20616e6420626520676f6f64207769746820646562756767696e672e3c2f703e, NULL, 'drop_your_cv@plusagency.com', 3, NULL, NULL, '2024-01-19 19:27:32', '2024-01-19 19:27:32'),
(5, 7, 61, 2, 'PHP Developer - Laravel, Codeigniter', 'PHP-Developer---Laravel,-Codeigniter', 2, '01/31/2024', '2 to 3 year(s)', 0x3c703e596f75206861766520746f20626520657870657269656e6365642077697468205549206672616d65776f726b7320696e2067656e6572616c3b207765206c6f76652074686520416e67756c617220616e6420416e67756c6172206d6174657269616c2e3c62723e596f75206861766520746f20626520657870657269656e63656420696e206275696c64696e672053696e676c652050616765204170706c69636174696f6e732028535041292026616d703b20696e746567726174696e672057656220285265737429204150492e3c62723e57656c6c20766572736564207769746820416e67756c6172206d6f64756c6573206f7220796f752068617665206372656174656420637573746f6d20616e642077656220636f6d706f6e656e747320627920796f757273656c662e3c62723e596f75206d75737420686176652070726163746963616c20657870657269656e6365206f6e204e6f64652e6a732c20547970655363726970742c207765627061636b20616e64205468697264207061727479206c6962726172792e3c62723e596f75206861766520616e20696e2d646570746820756e6465727374616e64696e67206f662063726f73732062726f7773657220636f6d7061746962696c69747920616e6420796f7520646f206e6f7420637265617465206275677320666f72207375636820726561736f6e732e3c62723e596f752061726520706978656c2d7065726665637420696e2064657369676e20636f6e76657273696f6e7320616e6420796f75207468696e6b206f66206d6f62696c652d666972737420696d706c656d656e746174696f6e732e3c62723e596f752073686f756c642068617665206b6e6f776c65646765206f66204353532070726570726f636573736f72732c204d6564696120717565726965732c20496d61676520636f6d7072657373696f6e20616e6420626520676f6f64207769746820646562756767696e672e3c2f703e, 'Full-time', 0x3c703e596f75206861766520746f20626520657870657269656e6365642077697468205549206672616d65776f726b7320696e2067656e6572616c3b207765206c6f76652074686520416e67756c617220616e6420416e67756c6172206d6174657269616c2e3c62723e596f75206861766520746f20626520657870657269656e63656420696e206275696c64696e672053696e676c652050616765204170706c69636174696f6e732028535041292026616d703b20696e746567726174696e672057656220285265737429204150492e3c62723e57656c6c20766572736564207769746820416e67756c6172206d6f64756c6573206f7220796f752068617665206372656174656420637573746f6d20616e642077656220636f6d706f6e656e747320627920796f757273656c662e3c2f703e, 0x3c703e596f75206861766520746f20626520657870657269656e6365642077697468205549206672616d65776f726b7320696e2067656e6572616c3b207765206c6f76652074686520416e67756c617220616e6420416e67756c6172206d6174657269616c2e3c62723e596f75206861766520746f20626520657870657269656e63656420696e206275696c64696e672053696e676c652050616765204170706c69636174696f6e732028535041292026616d703b20696e746567726174696e672057656220285265737429204150492e3c62723e57656c6c20766572736564207769746820416e67756c6172206d6f64756c6573206f7220796f752068617665206372656174656420637573746f6d20616e642077656220636f6d706f6e656e747320627920796f757273656c662e3c62723e596f75206d75737420686176652070726163746963616c20657870657269656e6365206f6e204e6f64652e6a732c20547970655363726970742c207765627061636b20616e64205468697264207061727479206c6962726172792e3c62723e596f752073686f756c642068617665206b6e6f776c65646765206f66204353532070726570726f636573736f72732c204d6564696120717565726965732c20496d61676520636f6d7072657373696f6e20616e6420626520676f6f64207769746820646562756767696e672e3c2f703e, 0x3c703e596f75206d75737420686176652070726163746963616c20657870657269656e6365206f6e204e6f64652e6a732c20547970655363726970742c207765627061636b20616e64205468697264207061727479206c6962726172792e3c62723e596f75206861766520616e20696e2d646570746820756e6465727374616e64696e67206f662063726f73732062726f7773657220636f6d7061746962696c69747920616e6420796f7520646f206e6f7420637265617465206275677320666f72207375636820726561736f6e732e3c62723e596f752061726520706978656c2d7065726665637420696e2064657369676e20636f6e76657273696f6e7320616e6420796f75207468696e6b206f66206d6f62696c652d666972737420696d706c656d656e746174696f6e732e3c62723e596f752073686f756c642068617665206b6e6f776c65646765206f66204353532070726570726f636573736f72732c204d6564696120717565726965732c20496d61676520636f6d7072657373696f6e20616e6420626520676f6f64207769746820646562756767696e672e3c2f703e, 'California, USA', 0x3c703e2431303030202d2024313530303c2f703e, 0x3c703e57656c6c20766572736564207769746820416e67756c6172206d6f64756c6573206f7220796f752068617665206372656174656420637573746f6d20616e642077656220636f6d706f6e656e747320627920796f757273656c662e3c62723e596f75206d75737420686176652070726163746963616c20657870657269656e6365206f6e204e6f64652e6a732c20547970655363726970742c207765627061636b20616e64205468697264207061727479206c6962726172792e3c62723e596f75206861766520616e20696e2d646570746820756e6465727374616e64696e67206f662063726f73732062726f7773657220636f6d7061746962696c69747920616e6420796f7520646f206e6f7420637265617465206275677320666f72207375636820726561736f6e732e3c62723e596f752061726520706978656c2d7065726665637420696e2064657369676e20636f6e76657273696f6e7320616e6420796f75207468696e6b206f66206d6f62696c652d666972737420696d706c656d656e746174696f6e732e3c62723e596f752073686f756c642068617665206b6e6f776c65646765206f66204353532070726570726f636573736f72732c204d6564696120717565726965732c20496d61676520636f6d7072657373696f6e20616e6420626520676f6f64207769746820646562756767696e672e3c2f703e, 0x3c703e3c7370616e207374796c653d22636f6c6f723a20236666336233303b223e2a50686f746f67726170683c2f7370616e3e266e6273703b6d75737420626520656e636c6f73656420776974682074686520726573756d652e3c2f703e, 'drop_your_cv@plusagency.com', 2, NULL, NULL, '2024-01-19 19:29:20', '2024-01-19 19:29:20'),
(6, 7, 61, 2, 'Web Developer', 'Web-Developer', 3, '01/31/2024', '3 to 4 year(s)', 0x3c703e596f75206861766520746f20626520657870657269656e6365642077697468205549206672616d65776f726b7320696e2067656e6572616c3b207765206c6f76652074686520416e67756c617220616e6420416e67756c6172206d6174657269616c2e3c62723e596f75206861766520746f20626520657870657269656e63656420696e206275696c64696e672053696e676c652050616765204170706c69636174696f6e732028535041292026616d703b20696e746567726174696e672057656220285265737429204150492e3c62723e57656c6c20766572736564207769746820416e67756c6172206d6f64756c6573206f7220796f752068617665206372656174656420637573746f6d20616e642077656220636f6d706f6e656e747320627920796f757273656c662e3c62723e596f75206d75737420686176652070726163746963616c20657870657269656e6365206f6e204e6f64652e6a732c20547970655363726970742c207765627061636b20616e64205468697264207061727479206c6962726172792e3c62723e596f75206861766520616e20696e2d646570746820756e6465727374616e64696e67206f662063726f73732062726f7773657220636f6d7061746962696c69747920616e6420796f7520646f206e6f7420637265617465206275677320666f72207375636820726561736f6e732e3c62723e596f752061726520706978656c2d7065726665637420696e2064657369676e20636f6e76657273696f6e7320616e6420796f75207468696e6b206f66206d6f62696c652d666972737420696d706c656d656e746174696f6e732e3c62723e596f752073686f756c642068617665206b6e6f776c65646765206f66204353532070726570726f636573736f72732c204d6564696120717565726965732c20496d61676520636f6d7072657373696f6e20616e6420626520676f6f64207769746820646562756767696e672e3c2f703e, 'Full-time', 0x3c703e596f75206861766520746f20626520657870657269656e6365642077697468205549206672616d65776f726b7320696e2067656e6572616c3b207765206c6f76652074686520416e67756c617220616e6420416e67756c6172206d6174657269616c2e3c62723e596f75206861766520746f20626520657870657269656e63656420696e206275696c64696e672053696e676c652050616765204170706c69636174696f6e732028535041292026616d703b20696e746567726174696e672057656220285265737429204150492e3c62723e57656c6c20766572736564207769746820416e67756c6172206d6f64756c6573206f7220796f752068617665206372656174656420637573746f6d20616e642077656220636f6d706f6e656e747320627920796f757273656c662e3c2f703e, 0x3c703e596f75206861766520746f20626520657870657269656e6365642077697468205549206672616d65776f726b7320696e2067656e6572616c3b207765206c6f76652074686520416e67756c617220616e6420416e67756c6172206d6174657269616c2e3c62723e596f75206861766520746f20626520657870657269656e63656420696e206275696c64696e672053696e676c652050616765204170706c69636174696f6e732028535041292026616d703b20696e746567726174696e672057656220285265737429204150492e3c62723e57656c6c20766572736564207769746820416e67756c6172206d6f64756c6573206f7220796f752068617665206372656174656420637573746f6d20616e642077656220636f6d706f6e656e747320627920796f757273656c662e3c62723e596f752073686f756c642068617665206b6e6f776c65646765206f66204353532070726570726f636573736f72732c204d6564696120717565726965732c20496d61676520636f6d7072657373696f6e20616e6420626520676f6f64207769746820646562756767696e672e3c2f703e, 0x3c703e596f75206861766520616e20696e2d646570746820756e6465727374616e64696e67206f662063726f73732062726f7773657220636f6d7061746962696c69747920616e6420796f7520646f206e6f7420637265617465206275677320666f72207375636820726561736f6e732e3c62723e596f752061726520706978656c2d7065726665637420696e2064657369676e20636f6e76657273696f6e7320616e6420796f75207468696e6b206f66206d6f62696c652d666972737420696d706c656d656e746174696f6e732e3c62723e596f752073686f756c642068617665206b6e6f776c65646765206f66204353532070726570726f636573736f72732c204d6564696120717565726965732c20496d61676520636f6d7072657373696f6e20616e6420626520676f6f64207769746820646562756767696e672e3c2f703e, 'Remote Job', 0x3c703e24323030303c2f703e, 0x3c703e596f75206861766520616e20696e2d646570746820756e6465727374616e64696e67206f662063726f73732062726f7773657220636f6d7061746962696c69747920616e6420796f7520646f206e6f7420637265617465206275677320666f72207375636820726561736f6e732e3c62723e596f752061726520706978656c2d7065726665637420696e2064657369676e20636f6e76657273696f6e7320616e6420796f75207468696e6b206f66206d6f62696c652d666972737420696d706c656d656e746174696f6e732e3c62723e596f752073686f756c642068617665206b6e6f776c65646765206f66204353532070726570726f636573736f72732c204d6564696120717565726965732c20496d61676520636f6d7072657373696f6e20616e6420626520676f6f64207769746820646562756767696e672e3c2f703e, NULL, 'drop_your_cv@plusagency.com', 1, NULL, NULL, '2024-01-19 19:40:59', '2024-01-19 19:40:59'),
(7, 10, 62, 2, 'زعيم نظم السوق الزراعية', 'زعيم-نظم-السوق-الزراعية', 4, '01/31/2024', 'على الأقل 7 سنوات', 0x3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d985d8aad985d8b1d8b3d98bd8a720d981d98a20d8a3d8b7d8b120d8b9d985d98420d988d8a7d8acd987d8a920d8a7d984d985d8b3d8aad8aed8afd98520d8a8d8b4d983d98420d8b9d8a7d98520d89b20d986d8add98620d986d8add8a820d8a7d984d8b2d8a7d988d98a20d988d8a7d984d985d988d8a7d8af20d8a7d984d8b2d8a7d988d98a2e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d984d8afd98ad98320d8aed8a8d8b1d8a920d981d98a20d8a5d986d8b4d8a7d8a120d8aad8b7d8a8d98ad982d8a7d8aa20d8b5d981d8add8a920d988d8a7d8add8afd8a920285350412920d988d8afd985d8ac20d988d8a7d8acd987d8a920d8a8d8b1d985d8acd8a920d8aad8b7d8a8d98ad982d8a7d8aa20d8a7d984d988d98ad8a82028d8a7d984d8b1d8a7d8add8a9292e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed8b6d984d98ad8b9d8a720d981d98a20d988d8add8afd8a7d8aa20d8a7d984d8b2d8a7d988d98a20d8a3d98820d982d985d8aa20d8a8d8a5d986d8b4d8a7d8a120d985d983d988d986d8a7d8aa20d985d8aed8b5d8b5d8a920d988d8b4d8a8d983d8a920d8a7d984d8a5d986d8aad8b1d986d8aa20d985d98620d982d8a8d98420d986d981d8b3d9832e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d98ad983d988d98620d984d8afd98ad98320d8aed8a8d8b1d8a920d8b9d985d984d98ad8a920d981d98a204e6f64652e6a7320d988205479706553637269707420d988207765627061636b20d988d985d983d8aad8a8d8a920d8a7d984d8b7d8b1d98120d8a7d984d8abd8a7d984d8ab2e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed984d8afd98ad98320d981d987d98520d985d8aad8b9d985d98220d984d984d8aad988d8a7d981d98220d8b9d8a8d8b120d8a7d984d985d8b3d8aad8b9d8b1d8b620d988d984d98520d8aad982d98520d8a8d8a5d986d8b4d8a7d8a120d8a3d8aed8b7d8a7d8a120d984d987d8b0d98720d8a7d984d8a3d8b3d8a8d8a7d8a82e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed8a3d986d8aa20d985d8abd8a7d984d98a20d984d984d8a8d98ad983d8b3d98420d981d98a20d8aad8add988d98ad984d8a7d8aa20d8a7d984d8aad8b5d985d98ad98520d988d8aad981d983d8b120d981d98a20d8aad8b7d8a8d98ad982d8a7d8aa20d8a7d984d985d8add985d988d98420d8a7d984d8a3d988d984d9892e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d984d8afd98ad98320d985d8b9d8b1d981d8a920d8a8d985d8b9d8a7d984d8acd8a7d8aa2043535320d8a7d984d8a3d988d984d98ad8a920d988d8a7d8b3d8aad8b9d984d8a7d985d8a7d8aa20d8a7d984d988d8b3d8a7d8a6d8b720d988d8b6d8bad8b720d8a7d984d8b5d988d8b120d988d8aad983d988d98620d8acd98ad8afd98bd8a720d981d98a20d8aad8b5d8add98ad8ad20d8a7d984d8a3d8aed8b7d8a7d8a12e3c2f7370616e3e3c2f6469763e, 'وقت كامل', 0x3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d985d8aad985d8b1d8b3d98bd8a720d981d98a20d8a3d8b7d8b120d8b9d985d98420d988d8a7d8acd987d8a920d8a7d984d985d8b3d8aad8aed8afd98520d8a8d8b4d983d98420d8b9d8a7d98520d89b20d986d8add98620d986d8add8a820d8a7d984d8b2d8a7d988d98a20d988d8a7d984d985d988d8a7d8af20d8a7d984d8b2d8a7d988d98a2e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d984d8afd98ad98320d8aed8a8d8b1d8a920d981d98a20d8a5d986d8b4d8a7d8a120d8aad8b7d8a8d98ad982d8a7d8aa20d8b5d981d8add8a920d988d8a7d8add8afd8a920285350412920d988d8afd985d8ac20d988d8a7d8acd987d8a920d8a8d8b1d985d8acd8a920d8aad8b7d8a8d98ad982d8a7d8aa20d8a7d984d988d98ad8a82028d8a7d984d8b1d8a7d8add8a9292e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed8b6d984d98ad8b9d8a720d981d98a20d988d8add8afd8a7d8aa20d8a7d984d8b2d8a7d988d98a20d8a3d98820d982d985d8aa20d8a8d8a5d986d8b4d8a7d8a120d985d983d988d986d8a7d8aa20d985d8aed8b5d8b5d8a920d988d8b4d8a8d983d8a920d8a7d984d8a5d986d8aad8b1d986d8aa20d985d98620d982d8a8d98420d986d9813c2f7370616e3e3c2f6469763e, 0x3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d985d8aad985d8b1d8b3d98bd8a720d981d98a20d8a3d8b7d8b120d8b9d985d98420d988d8a7d8acd987d8a920d8a7d984d985d8b3d8aad8aed8afd98520d8a8d8b4d983d98420d8b9d8a7d98520d89b20d986d8add98620d986d8add8a820d8a7d984d8b2d8a7d988d98a20d988d8a7d984d985d988d8a7d8af20d8a7d984d8b2d8a7d988d98a2e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d984d8afd98ad98320d8aed8a8d8b1d8a920d981d98a20d8a5d986d8b4d8a7d8a120d8aad8b7d8a8d98ad982d8a7d8aa20d8b5d981d8add8a920d988d8a7d8add8afd8a920285350412920d988d8afd985d8ac20d988d8a7d8acd987d8a920d8a8d8b1d985d8acd8a920d8aad8b7d8a8d98ad982d8a7d8aa20d8a7d984d988d98ad8a82028d8a7d984d8b1d8a7d8add8a9292e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed8b6d984d98ad8b9d8a720d981d98a20d988d8add8afd8a7d8aa20d8a7d984d8b2d8a7d988d98a20d8a3d98820d982d985d8aa20d8a8d8a5d986d8b4d8a7d8a120d985d983d988d986d8a7d8aa20d985d8aed8b5d8b5d8a920d988d8b4d8a8d983d8a920d8a7d984d8a5d986d8aad8b1d986d8aa20d985d98620d982d8a8d98420d986d981d8b3d9832e3c2f7370616e3e3c2f6469763e, 0x3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d985d8aad985d8b1d8b3d98bd8a720d981d98a20d8a3d8b7d8b120d8b9d985d98420d988d8a7d8acd987d8a920d8a7d984d985d8b3d8aad8aed8afd98520d8a8d8b4d983d98420d8b9d8a7d98520d89b20d986d8add98620d986d8add8a820d8a7d984d8b2d8a7d988d98a20d988d8a7d984d985d988d8a7d8af20d8a7d984d8b2d8a7d988d98a2e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d984d8afd98ad98320d8aed8a8d8b1d8a920d981d98a20d8a5d986d8b4d8a7d8a120d8aad8b7d8a8d98ad982d8a7d8aa20d8b5d981d8add8a920d988d8a7d8add8afd8a920285350412920d988d8afd985d8ac20d988d8a7d8acd987d8a920d8a8d8b1d985d8acd8a920d8aad8b7d8a8d98ad982d8a7d8aa20d8a7d984d988d98ad8a82028d8a7d984d8b1d8a7d8add8a9292e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed8b6d984d98ad8b9d8a720d981d98a20d988d8add8afd8a7d8aa20d8a7d984d8b2d8a7d988d98a20d8a3d98820d982d985d8aa20d8a8d8a5d986d8b4d8a7d8a120d985d983d988d986d8a7d8aa20d985d8aed8b5d8b5d8a920d988d8b4d8a8d983d8a920d8a7d984d8a5d986d8aad8b1d986d8aa20d985d98620d982d8a8d98420d986d981d8b3d9832e3c2f7370616e3e3c2f6469763e, 'كاليفورنيا، الولايات المتحدة الأمريكية', 0x3c70206469723d2272746c223e3130303020d8afd988d984d8a7d8b1202d203135303020d8afd988d984d8a7d8b13c2f703e, 0x3c6469763e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d985d8aad985d8b1d8b3d98bd8a720d981d98a20d8a3d8b7d8b120d8b9d985d98420d988d8a7d8acd987d8a920d8a7d984d985d8b3d8aad8aed8afd98520d8a8d8b4d983d98420d8b9d8a7d98520d89b20d986d8add98620d986d8add8a820d8a7d984d8b2d8a7d988d98a20d988d8a7d984d985d988d8a7d8af20d8a7d984d8b2d8a7d988d98a2e3c2f7370616e3e3c2f6469763e0d0a3c6469763e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d984d8afd98ad98320d8aed8a8d8b1d8a920d981d98a20d8a5d986d8b4d8a7d8a120d8aad8b7d8a8d98ad982d8a7d8aa20d8b5d981d8add8a920d988d8a7d8add8afd8a920285350412920d988d8afd985d8ac20d988d8a7d8acd987d8a920d8a8d8b1d985d8acd8a920d8aad8b7d8a8d98ad982d8a7d8aa20d8a7d984d988d98ad8a82028d8a7d984d8b1d8a7d8add8a9292e3c2f7370616e3e3c2f6469763e0d0a3c6469763e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed8b6d984d98ad8b9d8a720d981d98a20d988d8add8afd8a7d8aa20d8a7d984d8b2d8a7d988d98a20d8a3d98820d982d985d8aa20d8a8d8a5d986d8b4d8a7d8a120d985d983d988d986d8a7d8aa20d985d8aed8b5d8b5d8a920d988d8b4d8a8d983d8a920d8a7d984d8a5d986d8aad8b1d986d8aa20d985d98620d982d8a8d98420d986d981d8b3d9832e3c2f7370616e3e3c2f6469763e, NULL, 'drop_your_cv@plusagency.com', 1, NULL, NULL, '2024-01-19 20:01:05', '2024-01-19 20:01:05'),
(8, 11, 62, 2, 'مهندس برمجيات الواجهة الأمامية', 'مهندس-برمجيات-الواجهة-الأمامية', 5, '01/31/2024', '2 إلى 5 سنوات', 0x3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d985d8aad985d8b1d8b3d98bd8a720d981d98a20d8a3d8b7d8b120d8b9d985d98420d988d8a7d8acd987d8a920d8a7d984d985d8b3d8aad8aed8afd98520d8a8d8b4d983d98420d8b9d8a7d98520d89b20d986d8add98620d986d8add8a820d8a7d984d8b2d8a7d988d98a20d988d8a7d984d985d988d8a7d8af20d8a7d984d8b2d8a7d988d98a2e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d984d8afd98ad98320d8aed8a8d8b1d8a920d981d98a20d8a5d986d8b4d8a7d8a120d8aad8b7d8a8d98ad982d8a7d8aa20d8b5d981d8add8a920d988d8a7d8add8afd8a920285350412920d988d8afd985d8ac20d988d8a7d8acd987d8a920d8a8d8b1d985d8acd8a920d8aad8b7d8a8d98ad982d8a7d8aa20d8a7d984d988d98ad8a82028d8a7d984d8b1d8a7d8add8a9292e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed8b6d984d98ad8b9d8a720d981d98a20d988d8add8afd8a7d8aa20d8a7d984d8b2d8a7d988d98a20d8a3d98820d982d985d8aa20d8a8d8a5d986d8b4d8a7d8a120d985d983d988d986d8a7d8aa20d985d8aed8b5d8b5d8a920d988d8b4d8a8d983d8a920d8a7d984d8a5d986d8aad8b1d986d8aa20d985d98620d982d8a8d98420d986d981d8b3d9832e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d98ad983d988d98620d984d8afd98ad98320d8aed8a8d8b1d8a920d8b9d985d984d98ad8a920d981d98a204e6f64652e6a7320d988205479706553637269707420d988207765627061636b20d988d985d983d8aad8a8d8a920d8a7d984d8b7d8b1d98120d8a7d984d8abd8a7d984d8ab2e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed984d8afd98ad98320d981d987d98520d985d8aad8b9d985d98220d984d984d8aad988d8a7d981d98220d8b9d8a8d8b120d8a7d984d985d8b3d8aad8b9d8b1d8b620d988d984d98520d8aad982d98520d8a8d8a5d986d8b4d8a7d8a120d8a3d8aed8b7d8a7d8a120d984d987d8b0d98720d8a7d984d8a3d8b3d8a8d8a7d8a82e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed8a3d986d8aa20d985d8abd8a7d984d98a20d984d984d8a8d98ad983d8b3d98420d981d98a20d8aad8add988d98ad984d8a7d8aa20d8a7d984d8aad8b5d985d98ad98520d988d8aad981d983d8b120d981d98a20d8aad8b7d8a8d98ad982d8a7d8aa20d8a7d984d985d8add985d988d98420d8a7d984d8a3d988d984d9892e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d984d8afd98ad98320d985d8b9d8b1d981d8a920d8a8d985d8b9d8a7d984d8acd8a7d8aa2043535320d8a7d984d8a3d988d984d98ad8a920d988d8a7d8b3d8aad8b9d984d8a7d985d8a7d8aa20d8a7d984d988d8b3d8a7d8a6d8b720d988d8b6d8bad8b720d8a7d984d8b5d988d8b120d988d8aad983d988d98620d8acd98ad8afd98bd8a720d981d98a20d8aad8b5d8add98ad8ad20d8a7d984d8a3d8aed8b7d8a7d8a12e3c2f7370616e3e3c2f6469763e, 'وقت كامل', 0x3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d985d8aad985d8b1d8b3d98bd8a720d981d98a20d8a3d8b7d8b120d8b9d985d98420d988d8a7d8acd987d8a920d8a7d984d985d8b3d8aad8aed8afd98520d8a8d8b4d983d98420d8b9d8a7d98520d89b20d986d8add98620d986d8add8a820d8a7d984d8b2d8a7d988d98a20d988d8a7d984d985d988d8a7d8af20d8a7d984d8b2d8a7d988d98a2e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d984d8afd98ad98320d8aed8a8d8b1d8a920d981d98a20d8a5d986d8b4d8a7d8a120d8aad8b7d8a8d98ad982d8a7d8aa20d8b5d981d8add8a920d988d8a7d8add8afd8a920285350412920d988d8afd985d8ac20d988d8a7d8acd987d8a920d8a8d8b1d985d8acd8a920d8aad8b7d8a8d98ad982d8a7d8aa20d8a7d984d988d98ad8a82028d8a7d984d8b1d8a7d8add8a9292e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed8b6d984d98ad8b9d8a720d981d98a20d988d8add8afd8a7d8aa20d8a7d984d8b2d8a7d988d98a20d8a3d98820d982d985d8aa20d8a8d8a5d986d8b4d8a7d8a120d985d983d988d986d8a7d8aa20d985d8aed8b5d8b5d8a920d988d8b4d8a8d983d8a920d8a7d984d8a5d986d8aad8b1d986d8aa20d985d98620d982d8a8d98420d986d981d8b3d9832e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e266e6273703b3c2f6469763e, 0x3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d985d8aad985d8b1d8b3d98bd8a720d981d98a20d8a3d8b7d8b120d8b9d985d98420d988d8a7d8acd987d8a920d8a7d984d985d8b3d8aad8aed8afd98520d8a8d8b4d983d98420d8b9d8a7d98520d89b20d986d8add98620d986d8add8a820d8a7d984d8b2d8a7d988d98a20d988d8a7d984d985d988d8a7d8af20d8a7d984d8b2d8a7d988d98a2e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d984d8afd98ad98320d8aed8a8d8b1d8a920d981d98a20d8a5d986d8b4d8a7d8a120d8aad8b7d8a8d98ad982d8a7d8aa20d8b5d981d8add8a920d988d8a7d8add8afd8a920285350412920d988d8afd985d8ac20d988d8a7d8acd987d8a920d8a8d8b1d985d8acd8a920d8aad8b7d8a8d98ad982d8a7d8aa20d8a7d984d988d98ad8a82028d8a7d984d8b1d8a7d8add8a9292e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed8b6d984d98ad8b9d8a720d981d98a20d988d8add8afd8a7d8aa20d8a7d984d8b2d8a7d988d98a20d8a3d98820d982d985d8aa20d8a8d8a5d986d8b4d8a7d8a120d985d983d988d986d8a7d8aa20d985d8aed8b5d8b5d8a920d988d8b4d8a8d983d8a920d8a7d984d8a5d986d8aad8b1d986d8aa20d985d98620d982d8a8d98420d986d981d8b3d9832e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e266e6273703b3c2f6469763e, 0x3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d985d8aad985d8b1d8b3d98bd8a720d981d98a20d8a3d8b7d8b120d8b9d985d98420d988d8a7d8acd987d8a920d8a7d984d985d8b3d8aad8aed8afd98520d8a8d8b4d983d98420d8b9d8a7d98520d89b20d986d8add98620d986d8add8a820d8a7d984d8b2d8a7d988d98a20d988d8a7d984d985d988d8a7d8af20d8a7d984d8b2d8a7d988d98a2e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d984d8afd98ad98320d8aed8a8d8b1d8a920d981d98a20d8a5d986d8b4d8a7d8a120d8aad8b7d8a8d98ad982d8a7d8aa20d8b5d981d8add8a920d988d8a7d8add8afd8a920285350412920d988d8afd985d8ac20d988d8a7d8acd987d8a920d8a8d8b1d985d8acd8a920d8aad8b7d8a8d98ad982d8a7d8aa20d8a7d984d988d98ad8a82028d8a7d984d8b1d8a7d8add8a9292e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed8b6d984d98ad8b9d8a720d981d98a20d988d8add8afd8a7d8aa20d8a7d984d8b2d8a7d988d98a20d8a3d98820d982d985d8aa20d8a8d8a5d986d8b4d8a7d8a120d985d983d988d986d8a7d8aa20d985d8aed8b5d8b5d8a920d988d8b4d8a8d983d8a920d8a7d984d8a5d986d8aad8b1d986d8aa20d985d98620d982d8a8d98420d986d981d8b3d9832e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e266e6273703b3c2f6469763e, 'باريس، فرنسا', 0x3c70206469723d2272746c223e3120d8a5d984d989203320d8b3d986d988d8a7d8aa3c2f703e, 0x3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d985d8aad985d8b1d8b3d98bd8a720d981d98a20d8a3d8b7d8b120d8b9d985d98420d988d8a7d8acd987d8a920d8a7d984d985d8b3d8aad8aed8afd98520d8a8d8b4d983d98420d8b9d8a7d98520d89b20d986d8add98620d986d8add8a820d8a7d984d8b2d8a7d988d98a20d988d8a7d984d985d988d8a7d8af20d8a7d984d8b2d8a7d988d98a2e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed98ad8acd8a820d8a3d98620d8aad983d988d98620d984d8afd98ad98320d8aed8a8d8b1d8a920d981d98a20d8a5d986d8b4d8a7d8a120d8aad8b7d8a8d98ad982d8a7d8aa20d8b5d981d8add8a920d988d8a7d8add8afd8a920285350412920d988d8afd985d8ac20d988d8a7d8acd987d8a920d8a8d8b1d985d8acd8a920d8aad8b7d8a8d98ad982d8a7d8aa20d8a7d984d988d98ad8a82028d8a7d984d8b1d8a7d8add8a9292e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e3c7370616e207374796c653d22666f6e742d73697a653a206c617267653b223ed8b6d984d98ad8b9d8a720d981d98a20d988d8add8afd8a7d8aa20d8a7d984d8b2d8a7d988d98a20d8a3d98820d982d985d8aa20d8a8d8a5d986d8b4d8a7d8a120d985d983d988d986d8a7d8aa20d985d8aed8b5d8b5d8a920d988d8b4d8a8d983d8a920d8a7d984d8a5d986d8aad8b1d986d8aa20d985d98620d982d8a8d98420d986d981d8b3d9832e3c2f7370616e3e3c2f6469763e0d0a3c646976206469723d2272746c223e266e6273703b3c2f6469763e, NULL, 'drop_your_cv@plusagency.com', 2, NULL, NULL, '2024-01-19 20:06:44', '2024-01-19 20:06:44');

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

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

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint(4) NOT NULL DEFAULT '1',
  `rtl` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 - LTR, 1- RTL',
  `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`, `is_default`, `rtl`, `created_at`, `updated_at`) VALUES
(176, 'English', 'en', 1, 0, '2020-08-07 04:43:05', '2020-12-31 09:22:02'),
(177, 'عربى', 'ar', 0, 1, '2020-08-07 04:51:17', '2020-12-31 09:22:02');

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

--
-- Table structure for table `members`
--

CREATE TABLE `members` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rank` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instagram` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linkedin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `feature` tinyint(4) 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 `members`
--

INSERT INTO `members` (`id`, `language_id`, `user_id`, `name`, `rank`, `image`, `twitter`, `facebook`, `instagram`, `linkedin`, `feature`, `created_at`, `updated_at`) VALUES
(2, 61, 2, 'Andress Pirlo', 'Manager, Eorder', '65429ae8a6f7f4edef0f40cfcb4063709d834220.jpg', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 1, NULL, NULL),
(3, 61, 2, 'Brent Hewitt', 'Silas Walters', '5b48ae6356d10f31386eb0efbd4f9900e31416ea.jpg', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 1, NULL, NULL),
(4, 61, 2, 'Liberty Workman', 'Victor Sharpe', 'f9ac277ef55b10f5a94e1671947bac3c7792d484.jpg', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 1, NULL, NULL),
(5, 61, 2, 'Amelia Whitaker', 'Perry Shepherd', '9b13990e31a35b6611b26d06a56844bf407a42ec.jpg', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 1, NULL, NULL),
(6, 61, 2, 'Kimberly Guthrie', 'Quemby Obrien', 'ac6b88ca2ec6022618c0809204adfeee4961bb7d.jpg', 'https://twitter.com/', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://www.instagram.com/', 1, NULL, NULL),
(7, 61, 2, 'Alisa Steele', 'Bryar Pickett', 'e6a2967bf2de1dbf373a7174c79782e486cd8fbc.jpg', 'https://twitter.com/', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://www.instagram.com/', 1, NULL, NULL),
(8, 62, 2, 'سيلينا غوميز', 'الرئيس التنفيذي والمؤسس', '73e0170c4a5faf35016e026f46e1db682ee94672.jpg', 'https://twitter.com/', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://www.instagram.com/', 1, NULL, NULL),
(9, 62, 2, 'أندريس بيرلو', 'مدير ، مشرف', 'a90e950ac43c017103033cb7e7ca72ede9326955.jpg', 'https://twitter.com/', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://www.instagram.com/', 1, NULL, NULL),
(10, 62, 2, 'كريستينا جريمي', 'رئيس الطباخين', '1ea34c48e9ce84b3b7f2378f60ae9085dd3fb9c0.jpg', 'https://twitter.com/', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://www.instagram.com/', 1, NULL, NULL),
(11, 68, 7, 'Andress Pirlo', 'Manager, Eorder', '65942a784d61611e1052ad6f5354892795ecde6e.png', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 1, NULL, NULL),
(12, 68, 7, 'Brent Hewitt', 'Silas Walters', '35e56d5ec4c767e52dfdffaf014c6488e264eb56.png', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 1, NULL, NULL),
(13, 68, 7, 'Liberty Workman', 'Victor Sharpe', '7031f428ee00f27ba5499cf6b5e105fbbcff4b99.png', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 1, NULL, NULL),
(14, 68, 7, 'Amelia Whitaker', 'Perry Shepherd', '9b13990e31a35b6611b26d06a56844bf407a42ec.jpg', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 1, NULL, NULL),
(15, 68, 7, 'Kimberly Guthrie', 'Quemby Obrien', 'ac6b88ca2ec6022618c0809204adfeee4961bb7d.jpg', 'https://twitter.com/', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://www.instagram.com/', 1, NULL, NULL),
(16, 68, 7, 'Alisa Steele', 'Bryar Pickett', 'e6a2967bf2de1dbf373a7174c79782e486cd8fbc.jpg', 'https://twitter.com/', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://www.instagram.com/', 1, NULL, NULL),
(17, 67, 6, 'Andress Pirlo', 'Manager, Eorder', 'da751710e5ae4721571a5dca6838ac504885154f.png', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 1, NULL, NULL),
(18, 67, 6, 'Brent Hewitt', 'Silas Walters', '77242f6d9b92a32609abd3e37be889b5f9bca52c.png', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 1, NULL, NULL),
(19, 67, 6, 'Liberty Workman', 'Victor Sharpe', '8cd6eca526267c69117c6015a02d8b79d0280e08.png', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 1, NULL, NULL),
(20, 67, 6, 'Amelia Whitaker', 'Perry Shepherd', '9b13990e31a35b6611b26d06a56844bf407a42ec.jpg', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 'https://www.facebook.com/', 1, NULL, NULL),
(21, 67, 6, 'Kimberly Guthrie', 'Quemby Obrien', 'ac6b88ca2ec6022618c0809204adfeee4961bb7d.jpg', 'https://twitter.com/', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://www.instagram.com/', 1, NULL, NULL),
(22, 67, 6, 'Alisa Steele', 'Bryar Pickett', 'e6a2967bf2de1dbf373a7174c79782e486cd8fbc.jpg', 'https://twitter.com/', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://www.instagram.com/', 1, NULL, NULL);

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

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

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

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

INSERT INTO `memberships` (`id`, `package_price`, `discount`, `coupon_code`, `price`, `currency`, `currency_symbol`, `payment_method`, `transaction_id`, `status`, `is_trial`, `trial_days`, `receipt`, `transaction_details`, `settings`, `package_id`, `user_id`, `start_date`, `expire_date`, `created_at`, `updated_at`, `modified`) VALUES
(96, 99, 0, NULL, 99, 'USD', '$', 'Paypal', 'd1868971', 1, 0, 0, NULL, '{\n    \"id\": \"PAYID-MWTXGLY3C717927X93069238\",\n    \"intent\": \"sale\",\n    \"state\": \"approved\",\n    \"cart\": \"03C78465D6667320X\",\n    \"payer\": {\n        \"payment_method\": \"paypal\",\n        \"status\": \"VERIFIED\",\n        \"payer_info\": {\n            \"email\": \"megasoft.envato@gmail.com\",\n            \"first_name\": \"Samiul Alim\",\n            \"last_name\": \"Pratik\",\n            \"payer_id\": \"8C5NYJ7EZ7QSS\",\n            \"shipping_address\": {\n                \"recipient_name\": \"Samiul Alim Pratik\",\n                \"line1\": \"1 Main St\",\n                \"city\": \"San Jose\",\n                \"state\": \"CA\",\n                \"postal_code\": \"95131\",\n                \"country_code\": \"US\"\n            },\n            \"country_code\": \"US\"\n        }\n    },\n    \"transactions\": [\n        {\n            \"amount\": {\n                \"total\": \"99.00\",\n                \"currency\": \"USD\",\n                \"details\": {\n                    \"subtotal\": \"99.00\",\n                    \"shipping\": \"0.00\",\n                    \"insurance\": \"0.00\",\n                    \"handling_fee\": \"0.00\",\n                    \"shipping_discount\": \"0.00\",\n                    \"discount\": \"0.00\"\n                }\n            },\n            \"payee\": {\n                \"merchant_id\": \"BKNWZYE3MAUNU\",\n                \"email\": \"megasoft.envato-facilitator@gmail.com\"\n            },\n            \"description\": \"You are purchasing a membership Via Paypal\",\n            \"item_list\": {\n                \"items\": [\n                    {\n                        \"name\": \"You are purchasing a membership\",\n                        \"price\": \"99.00\",\n                        \"currency\": \"USD\",\n                        \"tax\": \"0.00\",\n                        \"quantity\": 1,\n                        \"image_url\": \"\"\n                    }\n                ],\n                \"shipping_address\": {\n                    \"recipient_name\": \"Samiul Alim Pratik\",\n                    \"line1\": \"1 Main St\",\n                    \"city\": \"San Jose\",\n                    \"state\": \"CA\",\n                    \"postal_code\": \"95131\",\n                    \"country_code\": \"US\"\n                }\n            },\n            \"related_resources\": [\n                {\n                    \"sale\": {\n                        \"id\": \"1BL29614B70130201\",\n                        \"state\": \"completed\",\n                        \"amount\": {\n                            \"total\": \"99.00\",\n                            \"currency\": \"USD\",\n                            \"details\": {\n                                \"subtotal\": \"99.00\",\n                                \"shipping\": \"0.00\",\n                                \"insurance\": \"0.00\",\n                                \"handling_fee\": \"0.00\",\n                                \"shipping_discount\": \"0.00\",\n                                \"discount\": \"0.00\"\n                            }\n                        },\n                        \"payment_mode\": \"INSTANT_TRANSFER\",\n                        \"protection_eligibility\": \"ELIGIBLE\",\n                        \"protection_eligibility_type\": \"ITEM_NOT_RECEIVED_ELIGIBLE,UNAUTHORIZED_PAYMENT_ELIGIBLE\",\n                        \"transaction_fee\": {\n                            \"value\": \"3.95\",\n                            \"currency\": \"USD\"\n                        },\n                        \"parent_payment\": \"PAYID-MWTXGLY3C717927X93069238\",\n                        \"create_time\": \"2024-01-17T06:27:11Z\",\n                        \"update_time\": \"2024-01-17T06:27:11Z\",\n                        \"links\": [\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/sale/1BL29614B70130201\",\n                                \"rel\": \"self\",\n                                \"method\": \"GET\"\n                            },\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/sale/1BL29614B70130201/refund\",\n                                \"rel\": \"refund\",\n                                \"method\": \"POST\"\n                            },\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/payment/PAYID-MWTXGLY3C717927X93069238\",\n                                \"rel\": \"parent_payment\",\n                                \"method\": \"GET\"\n                            }\n                        ]\n                    }\n                }\n            ]\n        }\n    ],\n    \"redirect_urls\": {\n        \"return_url\": \"https://supervsasso.test/membership/paypal/success?paymentId=PAYID-MWTXGLY3C717927X93069238\",\n        \"cancel_url\": \"https://supervsasso.test/membership/paypal/cancel\"\n    },\n    \"create_time\": \"2024-01-17T06:26:55Z\",\n    \"update_time\": \"2024-01-17T06:27:11Z\",\n    \"links\": [\n        {\n            \"href\": \"https://api.sandbox.paypal.com/v1/payments/payment/PAYID-MWTXGLY3C717927X93069238\",\n            \"rel\": \"self\",\n            \"method\": \"GET\"\n        }\n    ],\n    \"failed_transactions\": []\n}', '{\"id\":147,\"language_id\":176,\"cookie_alert_status\":1,\"cookie_alert_text\":\"Your experience on this site will be improved by allowing cookies.\",\"cookie_alert_button_text\":\"Allow Cookies\",\"to_mail\":\"pratik.anwar@gmail.com\",\"default_language_direction\":\"ltr\",\"from_mail\":\"geniustest11@gmail.com\",\"testimonial_img\":\"b19dfe727e15f5f06b7fe2accb10a62b7ea183cc.png\",\"from_name\":\"Supervsasso\",\"is_smtp\":1,\"smtp_host\":\"smtp.gmail.com\",\"smtp_port\":\"587\",\"encryption\":\"TLS\",\"smtp_username\":\"geniustest11@gmail.com\",\"smtp_password\":\"jvpdiafcjhrznkbm\",\"base_currency_symbol\":\"$\",\"base_currency_symbol_position\":\"left\",\"base_currency_text\":\"USD\",\"base_currency_text_position\":\"right\",\"base_currency_rate\":\"1.00\",\"hero_section_title\":\"Our Platform, Your Success\",\"hero_section_text\":\"Build Your Own Restaurant Website\",\"hero_section_button_text\":\"Explore Plans\",\"hero_section_button_url\":\"https:\\/\\/supervsasso.test\\/pricing\",\"hero_section_video_url\":\"https:\\/\\/www.youtube.com\\/watch?v=6stlCkUDG_s\",\"hero_img\":\"3765afe7ef38875c4ee8d409e2dcd62216f66582.png\",\"timezone\":\"America\\/Shiprock\",\"contact_addresses\":\"California, USA\\r\\nLondon, United Kingdom\\r\\nMelbourne, Australia\",\"contact_numbers\":\"+8434197502,+2350575099,+23576039607\",\"contact_mails\":\"contact@example.com,support@example.com,query@example.com\",\"is_whatsapp\":1,\"whatsapp_number\":null,\"whatsapp_header_title\":null,\"whatsapp_popup_message\":null,\"whatsapp_popup\":1,\"domain_request_success_message\":\"We have received your custom domain request. Please allow us 2 business days to connect the domain with our server.\",\"cname_record_section_title\":\"Read Before Sending Custom Domain Request\",\"cname_record_section_text\":\"<ul><li><font color=\\\"#575962\\\"><span style=\\\"font-weight:600;\\\">\\u00a0Before sending request for your custom domain, You need to add a CNAME record (given in below table) in your custom domain from your domain registrar account (like - namecheap, godaddy etc...).<\\/span><\\/font><\\/li><li><font color=\\\"#575962\\\"><span style=\\\"font-weight:600;\\\">\\u00a0CNAME record is needed to point your custom domain to our domain ( profilo.xyz ), so that our website can show your portfolio on your domain<\\/span><\\/font><\\/li><li><font color=\\\"#575962\\\"><span style=\\\"font-weight:600;\\\">\\u00a0Different domain registrar (like - godaddy, namecheap etc...) has different interface for adding CNAME record. If you cannot find the place to add CNAME record in your domain registrar account, then please contact your domain registrar support, they will show you the place to add CNAME record for your custom domain<\\/span><\\/font><\\/li><\\/ul>\",\"package_features\":\"[\\\"Custom Domain\\\",\\\"Subdomain\\\",\\\"POS\\\",\\\"Coupon\\\",\\\"Live Orders\\\",\\\"Whatsapp Order & Notification\\\",\\\"QR Menu\\\",\\\"Table Reservation\\\",\\\"Table QR Builder\\\",\\\"Call Waiter\\\",\\\"Staffs\\\",\\\"Blog\\\",\\\"Custom Page\\\",\\\"Online Order\\\",\\\"On Table\\\",\\\"Pick Up\\\",\\\"Home Delivery\\\",\\\"Postal Code Based Delivery Charge\\\",\\\"PWA Installability\\\"]\",\"expiration_reminder\":4,\"max_video_size\":\"40.00\",\"max_file_size\":\"5.00\"}', 45, 2, '2024-01-16', '2025-01-16', '2024-01-16 17:27:13', '2024-01-16 17:27:13', 0),
(100, 1499, 0, NULL, 1499, 'USD', '$', 'Stripe', '253096ce', 1, 0, 0, NULL, '{\"id\":\"ch_3OayQQJlIV5dN9n71rFr0fVn\",\"object\":\"charge\",\"amount\":149900,\"amount_captured\":149900,\"amount_refunded\":0,\"application\":null,\"application_fee\":null,\"application_fee_amount\":null,\"balance_transaction\":\"txn_3OayQQJlIV5dN9n71RaIveCJ\",\"billing_details\":{\"address\":{\"city\":null,\"country\":null,\"line1\":null,\"line2\":null,\"postal_code\":\"12345\",\"state\":null},\"email\":null,\"name\":null,\"phone\":null},\"calculated_statement_descriptor\":\"Stripe\",\"captured\":true,\"created\":1705833530,\"currency\":\"usd\",\"customer\":null,\"description\":\"You are purchasing a membership\",\"destination\":null,\"dispute\":null,\"disputed\":false,\"failure_balance_transaction\":null,\"failure_code\":null,\"failure_message\":null,\"fraud_details\":[],\"invoice\":null,\"livemode\":false,\"metadata\":{\"customer_name\":\"satecujad\"},\"on_behalf_of\":null,\"order\":null,\"outcome\":{\"network_status\":\"approved_by_network\",\"reason\":null,\"risk_level\":\"normal\",\"risk_score\":14,\"seller_message\":\"Payment complete.\",\"type\":\"authorized\"},\"paid\":true,\"payment_intent\":null,\"payment_method\":\"card_1OayQPJlIV5dN9n7BUXxfVfO\",\"payment_method_details\":{\"card\":{\"amount_authorized\":149900,\"brand\":\"visa\",\"checks\":{\"address_line1_check\":null,\"address_postal_code_check\":\"pass\",\"cvc_check\":\"pass\"},\"country\":\"US\",\"exp_month\":12,\"exp_year\":2032,\"extended_authorization\":{\"status\":\"disabled\"},\"fingerprint\":\"WXDgVUSzrY61Nnm6\",\"funding\":\"credit\",\"incremental_authorization\":{\"status\":\"unavailable\"},\"installments\":null,\"last4\":\"4242\",\"mandate\":null,\"multicapture\":{\"status\":\"unavailable\"},\"network\":\"visa\",\"network_token\":{\"used\":false},\"overcapture\":{\"maximum_amount_capturable\":149900,\"status\":\"unavailable\"},\"three_d_secure\":null,\"wallet\":null},\"type\":\"card\"},\"receipt_email\":\"xuvohy@mailinator.com\",\"receipt_number\":null,\"receipt_url\":\"https:\\/\\/pay.stripe.com\\/receipts\\/payment\\/CAcaFwoVYWNjdF8xQXplbzNKbElWNWROOW43KLros60GMgY6JTt8OTM6LBayq9xRRDzTMq97EVvHXWO44Vs6zjM2IA_WlAT-Tn1i3R2Jz6HshuFo_VA6\",\"refunded\":false,\"refunds\":{\"object\":\"list\",\"data\":[],\"has_more\":false,\"total_count\":0,\"url\":\"\\/v1\\/charges\\/ch_3OayQQJlIV5dN9n71rFr0fVn\\/refunds\"},\"review\":null,\"shipping\":null,\"source\":{\"id\":\"card_1OayQPJlIV5dN9n7BUXxfVfO\",\"object\":\"card\",\"address_city\":null,\"address_country\":null,\"address_line1\":null,\"address_line1_check\":null,\"address_line2\":null,\"address_state\":null,\"address_zip\":\"12345\",\"address_zip_check\":\"pass\",\"brand\":\"Visa\",\"country\":\"US\",\"customer\":null,\"cvc_check\":\"pass\",\"dynamic_last4\":null,\"exp_month\":12,\"exp_year\":2032,\"fingerprint\":\"WXDgVUSzrY61Nnm6\",\"funding\":\"credit\",\"last4\":\"4242\",\"metadata\":[],\"name\":null,\"tokenization_method\":null,\"wallet\":null},\"source_transfer\":null,\"statement_descriptor\":null,\"statement_descriptor_suffix\":null,\"status\":\"succeeded\",\"transfer_data\":null,\"transfer_group\":null}', '{\"id\":147,\"language_id\":176,\"cookie_alert_status\":1,\"cookie_alert_text\":\"Your experience on this site will be improved by allowing cookies.\",\"cookie_alert_button_text\":\"Allow Cookies\",\"to_mail\":\"pratik.anwar@gmail.com\",\"default_language_direction\":\"ltr\",\"from_mail\":\"test@kreativdev.com\",\"testimonial_img\":\"b19dfe727e15f5f06b7fe2accb10a62b7ea183cc.png\",\"from_name\":\"Supervsasso\",\"is_smtp\":1,\"smtp_host\":\"nl1-sr12.supercp.com\",\"smtp_port\":\"587\",\"encryption\":\"TLS\",\"smtp_username\":\"test@kreativdev.com\",\"smtp_password\":\"xh=wf[%(GD!{\",\"base_currency_symbol\":\"$\",\"base_currency_symbol_position\":\"left\",\"base_currency_text\":\"USD\",\"base_currency_text_position\":\"right\",\"base_currency_rate\":\"1.00\",\"hero_section_title\":\"Our Platform, Your Success\",\"hero_section_text\":\"Build Your Own Restaurant Website\",\"hero_section_button_text\":\"Explore Plans\",\"hero_section_button_url\":\"https:\\/\\/supervsasso.test\\/pricing\",\"hero_section_video_url\":\"https:\\/\\/www.youtube.com\\/watch?v=6stlCkUDG_s\",\"hero_img\":\"3765afe7ef38875c4ee8d409e2dcd62216f66582.png\",\"timezone\":\"America\\/Shiprock\",\"contact_addresses\":\"California, USA\\r\\nLondon, United Kingdom\\r\\nMelbourne, Australia\",\"contact_numbers\":\"+8434197502,+2350575099,+23576039607\",\"contact_mails\":\"contact@example.com,support@example.com,query@example.com\",\"is_whatsapp\":1,\"whatsapp_number\":null,\"whatsapp_header_title\":null,\"whatsapp_popup_message\":null,\"whatsapp_popup\":1,\"domain_request_success_message\":\"We have received your custom domain request. Please allow us 2 business days to connect the domain with our server.\",\"cname_record_section_title\":\"Read Before Sending Custom Domain Request\",\"cname_record_section_text\":\"<ul><li><font color=\\\"#575962\\\"><span style=\\\"font-weight:600;\\\">\\u00a0Before sending request for your custom domain, You need to add a CNAME record (given in below table) in your custom domain from your domain registrar account (like - namecheap, godaddy etc...).<\\/span><\\/font><\\/li><li><font color=\\\"#575962\\\"><span style=\\\"font-weight:600;\\\">\\u00a0CNAME record is needed to point your custom domain to our domain ( profilo.xyz ), so that our website can show your portfolio on your domain<\\/span><\\/font><\\/li><li><font color=\\\"#575962\\\"><span style=\\\"font-weight:600;\\\">\\u00a0Different domain registrar (like - godaddy, namecheap etc...) has different interface for adding CNAME record. If you cannot find the place to add CNAME record in your domain registrar account, then please contact your domain registrar support, they will show you the place to add CNAME record for your custom domain<\\/span><\\/font><\\/li><\\/ul>\",\"package_features\":\"[\\\"Custom Domain\\\",\\\"Subdomain\\\",\\\"POS\\\",\\\"Coupon\\\",\\\"Live Orders\\\",\\\"Whatsapp Order & Notification\\\",\\\"QR Menu\\\",\\\"Table Reservation\\\",\\\"Table QR Builder\\\",\\\"Call Waiter\\\",\\\"Staffs\\\",\\\"Blog\\\",\\\"Custom Page\\\",\\\"Online Order\\\",\\\"On Table\\\",\\\"Pick Up\\\",\\\"Home Delivery\\\",\\\"Postal Code Based Delivery Charge\\\",\\\"PWA Installability\\\"]\",\"expiration_reminder\":4,\"max_video_size\":\"40.00\",\"max_file_size\":\"5.00\"}', 50, 6, '2024-01-21', '9999-12-31', '2024-01-20 21:38:51', '2024-01-20 21:38:51', 0),
(101, 49, 0, NULL, 49, 'USD', '$', 'Authorize.net', '80013155386', 1, 0, 0, NULL, NULL, '{\"id\":147,\"language_id\":176,\"cookie_alert_status\":1,\"cookie_alert_text\":\"Your experience on this site will be improved by allowing cookies.\",\"cookie_alert_button_text\":\"Allow Cookies\",\"to_mail\":\"pratik.anwar@gmail.com\",\"default_language_direction\":\"ltr\",\"from_mail\":\"test@kreativdev.com\",\"testimonial_img\":\"b19dfe727e15f5f06b7fe2accb10a62b7ea183cc.png\",\"from_name\":\"Supervsasso\",\"is_smtp\":1,\"smtp_host\":\"nl1-sr12.supercp.com\",\"smtp_port\":\"587\",\"encryption\":\"TLS\",\"smtp_username\":\"test@kreativdev.com\",\"smtp_password\":\"xh=wf[%(GD!{\",\"base_currency_symbol\":\"$\",\"base_currency_symbol_position\":\"left\",\"base_currency_text\":\"USD\",\"base_currency_text_position\":\"right\",\"base_currency_rate\":\"1.00\",\"hero_section_title\":\"Our Platform, Your Success\",\"hero_section_text\":\"Build Your Own Restaurant Website\",\"hero_section_button_text\":\"Explore Plans\",\"hero_section_button_url\":\"https:\\/\\/supervsasso.test\\/pricing\",\"hero_section_video_url\":\"https:\\/\\/www.youtube.com\\/watch?v=6stlCkUDG_s\",\"hero_img\":\"3765afe7ef38875c4ee8d409e2dcd62216f66582.png\",\"timezone\":\"America\\/Shiprock\",\"contact_addresses\":\"California, USA\\r\\nLondon, United Kingdom\\r\\nMelbourne, Australia\",\"contact_numbers\":\"+8434197502,+2350575099,+23576039607\",\"contact_mails\":\"contact@example.com,support@example.com,query@example.com\",\"is_whatsapp\":1,\"whatsapp_number\":null,\"whatsapp_header_title\":null,\"whatsapp_popup_message\":null,\"whatsapp_popup\":1,\"domain_request_success_message\":\"We have received your custom domain request. Please allow us 2 business days to connect the domain with our server.\",\"cname_record_section_title\":\"Read Before Sending Custom Domain Request\",\"cname_record_section_text\":\"<ul><li><font color=\\\"#575962\\\"><span style=\\\"font-weight:600;\\\">\\u00a0Before sending request for your custom domain, You need to add a CNAME record (given in below table) in your custom domain from your domain registrar account (like - namecheap, godaddy etc...).<\\/span><\\/font><\\/li><li><font color=\\\"#575962\\\"><span style=\\\"font-weight:600;\\\">\\u00a0CNAME record is needed to point your custom domain to our domain ( profilo.xyz ), so that our website can show your portfolio on your domain<\\/span><\\/font><\\/li><li><font color=\\\"#575962\\\"><span style=\\\"font-weight:600;\\\">\\u00a0Different domain registrar (like - godaddy, namecheap etc...) has different interface for adding CNAME record. If you cannot find the place to add CNAME record in your domain registrar account, then please contact your domain registrar support, they will show you the place to add CNAME record for your custom domain<\\/span><\\/font><\\/li><\\/ul>\",\"package_features\":\"[\\\"Custom Domain\\\",\\\"Subdomain\\\",\\\"POS\\\",\\\"Coupon\\\",\\\"Live Orders\\\",\\\"Whatsapp Order & Notification\\\",\\\"QR Menu\\\",\\\"Table Reservation\\\",\\\"Table QR Builder\\\",\\\"Call Waiter\\\",\\\"Staffs\\\",\\\"Blog\\\",\\\"Custom Page\\\",\\\"Online Order\\\",\\\"On Table\\\",\\\"Pick Up\\\",\\\"Home Delivery\\\",\\\"Postal Code Based Delivery Charge\\\",\\\"PWA Installability\\\"]\",\"expiration_reminder\":4,\"max_video_size\":\"40.00\",\"max_file_size\":\"5.00\"}', 44, 7, '2024-01-21', '2025-01-21', '2024-01-20 21:44:03', '2024-01-20 21:44:03', 0);

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

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

CREATE TABLE `menus` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) DEFAULT NULL,
  `menus` text 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 `menus`
--

INSERT INTO `menus` (`id`, `language_id`, `menus`, `created_at`, `updated_at`) VALUES
(154, 177, '[{\"type\":\"home\",\"text\":\"بيت\",\"href\":\"\",\"target\":\"_self\"},{\"type\":\"listings\",\"text\":\"القوائم\",\"href\":\"\",\"target\":\"_self\"},{\"type\":\"pricing\",\"text\":\"التسعير\",\"href\":\"\",\"target\":\"_self\"},{\"type\":\"blog\",\"text\":\"مدونة\",\"href\":\"\",\"target\":\"_self\"},{\"type\":\"custom\",\"text\":\"الصفحات\",\"href\":\"\",\"target\":\"_self\",\"children\":[{\"type\":\"about_us\",\"text\":\"معلومات عنا\",\"href\":\"\",\"target\":\"_self\"},{\"type\":\"9\",\"text\":\"سياسة الخصوصية\",\"href\":\"\",\"target\":\"_self\"},{\"type\":\"10\",\"text\":\"البنود و الظروف\",\"href\":\"\",\"target\":\"_self\"}]},{\"type\":\"faq\",\"text\":\"التعليمات\",\"href\":\"\",\"target\":\"_self\"},{\"type\":\"contact\",\"text\":\"اتصال\",\"href\":\"\",\"target\":\"_self\"}]', '2024-01-29 18:18:59', '2024-01-29 18:18:59'),
(155, 176, '[{\"text\":\"Home\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"home\"},{\"text\":\"Listings\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"listings\"},{\"text\":\"Pricing\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"pricing\"},{\"text\":\"Pages\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"custom\",\"children\":[{\"text\":\"About Us\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"about_us\"},{\"text\":\"Privacy Policy\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"4\"},{\"text\":\"Terms & Conditions\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"3\"}]},{\"text\":\"Blog\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"blog\"},{\"text\":\"Contact\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"contact\"},{\"text\":\"FAQ\",\"href\":\"\",\"icon\":\"empty\",\"target\":\"_self\",\"title\":\"\",\"type\":\"faq\"}]', '2024-02-06 04:38:11', '2024-02-06 04:38:11');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2021_04_10_155226_add_pos_to_serving_methods', 1),
(5, '2021_04_10_161129_create_pos_payment_methods', 2),
(6, '2021_04_11_075502_create_customers_table', 3),
(7, '2021_04_11_151305_create_tables_table', 4),
(8, '2021_04_16_175547_add_qr_image_to_tables', 5),
(10, '2021_04_16_184950_add_qr_cols_to_table', 6),
(11, '2021_05_06_172702_add_image_to_tables', 7),
(12, '2021_05_06_182658_add_image_size_to_tables', 8),
(13, '2021_05_07_141846_change_defailt_image_size', 9),
(14, '2021_05_07_165729_drop_background_color_from_tables', 10),
(15, '2021_05_07_170622_add_image_position_cols_to_tables', 11),
(17, '2021_05_08_104914_add_type_and_text_cols_to_tables', 12),
(18, '2021_05_08_113457_add_default_value_to_text_color_in_tables', 13),
(19, '2021_05_08_174437_add_default_value_to_text_size_in_tables', 14),
(20, '2021_05_08_194033_add_qr_image_cols_to_basic_extendeds', 15),
(21, '2021_05_10_155349_add_gateway_type_to_product_orders', 16),
(24, '2021_05_11_180827_add_token_no_in_basic_settings', 17),
(25, '2021_05_11_181941_add_token_no_after_order_number_in_product_orders', 17),
(28, '2021_05_13_083313_create_postal_codes_table', 18),
(29, '2021_05_13_101831_add_postal_code_to_basic_settings', 19),
(32, '2021_05_16_105019_add_postal_code_to_product_orders', 20),
(33, '2021_05_18_130916_add_call_waiter_status_to_basic_settings', 21),
(34, '2021_05_18_194729_add_contact_infos_to_basic_settings', 22),
(36, '2021_05_19_081335_create_popups_table', 23),
(37, '2021_05_19_122217_drop_announcement_cols_from_basic_settings', 24),
(38, '2021_05_19_125220_drop_parent_link_col_from_basic_settings', 25),
(40, '2021_05_19_125534_add_whatsapp_chat_cols_to_basic_settings', 26),
(41, '2021_05_20_120604_add_order_close_cols_to_basic_extendeds', 27),
(42, '2022_03_13_165621_create_psub_categories_table', 28),
(43, '2022_03_13_180650_add_subcategory_id_to_products_table', 28),
(44, '2022_03_17_131144_add_free_delivery_amount_to_postal_codes', 29),
(45, '2022_03_17_194525_add_free_delivery_amount_to_shipping_charges', 30),
(46, '2022_04_18_133021_create_basic_extras', 31),
(49, '2022_04_19_155032_add_country_code_to_users_table', 32),
(51, '2022_04_21_120742_add_country_code_in_product_orders', 33),
(52, '2022_04_23_124847_add_whatsapp_order_notification_based_on_serving_methods', 34),
(53, '2022_04_23_144354_add_twilio_credentials_in_basic_extras', 35),
(54, '2022_05_25_195401_add_is_feature_in_psub_categories', 36),
(55, '2023_09_18_160526_add_token_to_admins', 37),
(56, '2023_09_18_160606_add_pass_token_to_users', 37);

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

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

CREATE TABLE `offline_gateways` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_description` text COLLATE utf8mb4_unicode_ci,
  `instructions` blob,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `serial_number` int(11) NOT NULL DEFAULT '0',
  `is_receipt` tinyint(4) NOT NULL DEFAULT '1',
  `receipt` varchar(100) 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 `offline_gateways`
--

INSERT INTO `offline_gateways` (`id`, `name`, `short_description`, `instructions`, `status`, `serial_number`, `is_receipt`, `receipt`, `created_at`, `updated_at`) VALUES
(1, 'Offline Gateway 1', 'Please send your payment to the following account.\r\nBank Name: Lorem Ipsum.\r\nBeneficiary Name: John Doe.\r\nAccount Number/IBAN: 12345678', 0x3c70207374796c653d226c696e652d6865696768743a20312e383b223e3c666f6e7420666163653d2243697263756c61725374642d426f6f6b2c20417269616c2c2073616e732d7365726966223e43686173652042616e6b2069732074686520636f6e73756d65722062616e6b696e67206469766973696f6e206f66204a504d6f7267616e2043686173652e20556e6c696b652069747320636f6d70657469746f72732c2043686173652069732074616b696e6720737465707320746f20657870616e6420697473206272616e6368206e6574776f726b20696e206b6579206d61726b6574732e205468652062616e6b2063757272656e746c7920686173206e6561726c7920352c303030206272616e6368657320616e642031362c3030302041544d732e204163636f7264696e6720746f207468652062616e6b2c206e6561726c792068616c66206f662074686520636f756e747279e280997320686f757365686f6c64732061726520436861736520637573746f6d6572732e3c2f666f6e743e3c62723e3c2f703e, 1, 1, 1, NULL, '2020-09-17 01:06:39', '2021-01-01 02:12:12'),
(2, 'Offline Gateway 2', 'Please send your payment to the following account.\r\nBank Name: Lorem Ipsum.\r\nBeneficiary Name: John Doe.\r\nAccount Number/IBAN: 12345678', 0x3c70207374796c653d226c696e652d6865696768743a20312e383b223e3c7370616e207374796c653d22666f6e742d66616d696c793a2043697263756c61725374642d426f6f6b2c20417269616c2c2073616e732d73657269663b20666f6e742d73697a653a20313470783b223e42616e6b206f6620416d6572696361207365727665732061626f7574203636206d696c6c696f6e20636f6e73756d65727320616e6420736d616c6c20627573696e65737320636c69656e747320776f726c64776964652e204c696b65206d616e79206f662074686520626967676573742062616e6b732c2042616e6b206f6620416d6572696361206973206b6e6f776e20666f7220697473206469676974616c20696e6e6f766174696f6e2e20497420686173206d6f7265207468616e203337206d696c6c696f6e206469676974616c20636c69656e747320616e6420697320657870657269656e63696e67207375636365737320616674657220696e74726f647563696e6720697473207669727475616c20617373697374616e742c2045726963612c20746861742061737369737473206163636f756e7420686f6c64657273207769746820766172696f7573207461736b733c2f7370616e3e3c62723e3c2f703e, 1, 2, 0, NULL, '2020-09-17 01:07:37', '2021-01-01 02:12:22');

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

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `qty` int(11) NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `variations` text COLLATE utf8mb4_unicode_ci,
  `addons` text COLLATE utf8mb4_unicode_ci,
  `variations_price` decimal(11,2) NOT NULL DEFAULT '0.00',
  `addons_price` decimal(11,2) NOT NULL,
  `product_price` decimal(11,2) NOT NULL,
  `total` decimal(11,2) 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 `order_items`
--

INSERT INTO `order_items` (`id`, `product_order_id`, `product_id`, `user_id`, `customer_id`, `title`, `qty`, `image`, `variations`, `addons`, `variations_price`, `addons_price`, `product_price`, `total`, `created_at`, `updated_at`) VALUES
(166, 5, 10, 2, 1, 'Lemon Juice', 1, 'de82e42128000619361619083be97a346c663155.jpg', '{\"Size\":{\"name\":\"Large\",\"price\":2}}', '\"\"', '2.00', '0.00', '5.00', '7.00', '2024-01-21 08:01:00', NULL),
(167, 5, 8, 2, 1, 'Set Menu - 5', 1, 'd346e36fdc744b60b2b6964a96a573da569bba11.jpg', '\"\"', '\"\"', '0.00', '0.00', '8.00', '8.00', '2024-01-21 08:01:00', NULL),
(168, 6, 9, 2, 1, 'Orange Juice', 1, '96fc4d053ee20c69c10f5e339575c5bb9abc1b70.jpg', '[]', '[{\"name\":\"Ice\",\"price\":\"0.00\"},{\"name\":\"Sugar\",\"price\":\"1.00\"}]', '0.00', '1.00', '2.00', '3.00', '2024-01-21 08:21:26', NULL),
(169, 6, 5, 2, 1, 'Strawberry Creamed Donut', 1, '9288fff7df0c6cef89d4a3bc6d8d7c4cba25b534.jpg', '\"\"', '\"\"', '0.00', '0.00', '3.00', '3.00', '2024-01-21 08:21:26', NULL),
(170, 6, 4, 2, 1, 'Regular Donut', 1, '369bd81ba7bedc224eb89b29aa6ab3a53e0d7fcd.jpg', '\"\"', '\"\"', '0.00', '0.00', '4.00', '4.00', '2024-01-21 08:21:26', NULL),
(171, 7, 6, 2, 1, 'Milk Shakes', 1, 'c227ef62b12d1bf4f0c53ac26420a60051c8dfb3.jpg', '\"\"', '\"\"', '0.00', '0.00', '4.00', '4.00', '2024-01-21 08:24:12', NULL),
(172, 7, 4, 2, 1, 'Regular Donut', 1, '369bd81ba7bedc224eb89b29aa6ab3a53e0d7fcd.jpg', '\"\"', '\"\"', '0.00', '0.00', '4.00', '4.00', '2024-01-21 08:24:12', NULL),
(173, 7, 2, 2, 1, 'Grilled Chicken Burger', 1, '156cb73246e09754b355615fd39f59b571db1487.jpg', '{\"Spice Level\":{\"name\":\"Mild\",\"price\":1},\"Size\":{\"name\":\"Large\",\"price\":2}}', '[{\"name\":\"Cheesee\",\"price\":\"1.00\"},{\"name\":\"BBQ Sauce\",\"price\":\"1.00\"},{\"name\":\"Patty\",\"price\":\"2.00\"}]', '3.00', '4.00', '6.00', '13.00', '2024-01-21 08:24:12', NULL),
(174, 8, 4, 2, 1, 'Regular Donut', 1, '369bd81ba7bedc224eb89b29aa6ab3a53e0d7fcd.jpg', '\"\"', '\"\"', '0.00', '0.00', '4.00', '4.00', '2024-01-21 08:35:58', NULL),
(175, 8, 6, 2, 1, 'Milk Shakes', 1, 'c227ef62b12d1bf4f0c53ac26420a60051c8dfb3.jpg', '\"\"', '\"\"', '0.00', '0.00', '4.00', '4.00', '2024-01-21 08:35:58', NULL),
(176, 9, 10, 2, 1, 'Lemon Juice', 1, 'de82e42128000619361619083be97a346c663155.jpg', '{\"Size\":{\"name\":\"Regular\",\"price\":1}}', '\"\"', '1.00', '0.00', '5.00', '6.00', '2024-01-21 09:06:39', NULL),
(177, 9, 9, 2, 1, 'Orange Juice', 1, '96fc4d053ee20c69c10f5e339575c5bb9abc1b70.jpg', '[]', '[{\"name\":\"Ice\",\"price\":\"0.00\"},{\"name\":\"Sugar\",\"price\":\"1.00\"}]', '0.00', '1.00', '2.00', '3.00', '2024-01-21 09:06:39', NULL),
(180, 11, 6, 2, NULL, 'Milk Shakes', 1, 'c227ef62b12d1bf4f0c53ac26420a60051c8dfb3.jpg', '\"\"', '\"\"', '0.00', '0.00', '4.00', '4.00', '2024-01-20 22:24:09', NULL),
(181, 11, 9, 2, NULL, 'Orange Juice', 1, '96fc4d053ee20c69c10f5e339575c5bb9abc1b70.jpg', '[]', '[{\"name\":\"Ice\",\"price\":\"0.00\"}]', '0.00', '0.00', '2.00', '2.00', '2024-01-20 22:24:09', NULL),
(182, 12, 8, 2, NULL, 'Set Menu - 5', 1, 'd346e36fdc744b60b2b6964a96a573da569bba11.jpg', '\"\"', '\"\"', '0.00', '0.00', '8.00', '8.00', '2024-01-20 22:25:33', NULL),
(183, 12, 1, 2, NULL, 'Set Menu - 7', 1, 'e48163cb7f7aad127422bb1a51027441507e3972.jpg', '{\"Size\":{\"name\":\"Big\",\"price\":2}}', '\"\"', '2.00', '0.00', '10.00', '12.00', '2024-01-20 22:25:33', NULL);

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

--
-- Table structure for table `order_times`
--

CREATE TABLE `order_times` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `day` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_time` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_time` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_times`
--

INSERT INTO `order_times` (`id`, `user_id`, `day`, `start_time`, `end_time`) VALUES
(400, 2, 'monday', '8:00 AM', '9:00 PM'),
(401, 2, 'tuesday', '10:00 AM', '10:30 PM'),
(402, 2, 'wednesday', '12:00 AM', '11:30 PM'),
(403, 2, 'thursday', '8:00 AM', '7:00 PM'),
(404, 2, 'friday', '9:00 AM', '6:00 PM'),
(405, 2, 'saturday', '11:00 AM', '9:30 PM'),
(406, 2, 'sunday', '7:00 AM', '5:00 PM'),
(428, 6, 'monday', NULL, NULL),
(429, 6, 'tuesday', NULL, NULL),
(430, 6, 'wednesday', NULL, NULL),
(431, 6, 'thursday', NULL, NULL),
(432, 6, 'friday', NULL, NULL),
(433, 6, 'saturday', NULL, NULL),
(434, 6, 'sunday', NULL, NULL),
(435, 7, 'monday', NULL, NULL),
(436, 7, 'tuesday', NULL, NULL),
(437, 7, 'wednesday', NULL, NULL),
(438, 7, 'thursday', NULL, NULL),
(439, 7, 'friday', NULL, NULL),
(440, 7, 'saturday', NULL, NULL),
(441, 7, 'sunday', NULL, NULL);

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

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `price` double NOT NULL DEFAULT '0',
  `term` varchar(255) DEFAULT NULL,
  `featured` enum('0','1') NOT NULL DEFAULT '0',
  `is_trial` enum('0','1') NOT NULL DEFAULT '0',
  `trial_days` int(11) DEFAULT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1',
  `recommended` enum('0','1') NOT NULL DEFAULT '0',
  `icon` varchar(255) DEFAULT NULL,
  `storage_limit` int(11) DEFAULT '999999',
  `staff_limit` int(11) DEFAULT '999999',
  `order_limit` int(11) NOT NULL DEFAULT '999999',
  `categories_limit` int(11) DEFAULT '999999',
  `subcategories_limit` int(11) DEFAULT '999999',
  `items_limit` int(11) DEFAULT '999999',
  `table_reservation_limit` int(11) DEFAULT '999999',
  `language_limit` float DEFAULT '999999',
  `features` text,
  `meta_keywords` longtext,
  `meta_description` longtext,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` (`id`, `title`, `slug`, `price`, `term`, `featured`, `is_trial`, `trial_days`, `status`, `recommended`, `icon`, `storage_limit`, `staff_limit`, `order_limit`, `categories_limit`, `subcategories_limit`, `items_limit`, `table_reservation_limit`, `language_limit`, `features`, `meta_keywords`, `meta_description`, `created_at`, `updated_at`) VALUES
(43, 'Basic', 'Basic', 29, 'month', '1', '1', 15, '1', '0', 'fas fa-battery-empty', 1020, 999999, 999999, 10, 10, 20, 999999, 5, '[\"Storage Limit\"]', NULL, NULL, '2024-01-16 15:31:11', '2024-01-28 17:45:54'),
(44, 'Standard', 'Standard', 49, 'month', '1', '1', 15, '1', '1', 'fas fa-battery-half', 2500, 10, 100, 30, 30, 150, 100, 10, '[\"Subdomain\",\"POS\",\"Coupon\",\"Storage Limit\",\"Live Orders\",\"Whatsapp Order & Notification\",\"QR Menu\",\"Table Reservation\",\"Table QR Builder\",\"Call Waiter\",\"Staffs\",\"Blog\",\"Custom Page\",\"Online Order\",\"On Table\",\"Pick Up\",\"Home Delivery\",\"Postal Code Based Delivery Charge\",\"PWA Installability\"]', NULL, NULL, '2024-01-16 15:34:33', '2024-01-28 17:53:46'),
(45, 'Business', 'Business', 99, 'month', '1', '1', 15, '1', '0', 'fas fa-battery-full', 999999, 999999, 999999, 999999, 999999, 999999, 999999, 999999, '[\"Custom Domain\",\"Subdomain\",\"POS\",\"Coupon\",\"Storage Limit\",\"Live Orders\",\"Whatsapp Order & Notification\",\"QR Menu\",\"Table Reservation\",\"Table QR Builder\",\"Call Waiter\",\"Staffs\",\"Blog\",\"Custom Page\",\"Online Order\",\"On Table\",\"Pick Up\",\"Home Delivery\",\"Postal Code Based Delivery Charge\",\"PWA Installability\"]', NULL, NULL, '2024-01-16 15:40:47', '2024-01-28 17:54:37'),
(46, 'Basic', 'Basic', 299, 'year', '1', '1', 15, '1', '0', 'fas fa-battery-empty', 1020, 999999, 999999, 10, 10, 20, 999999, 5, '[\"Storage Limit\"]', NULL, NULL, '2024-01-16 15:45:52', '2024-01-28 17:56:05'),
(47, 'Standard', 'Standard', 499, 'year', '1', '1', 15, '1', '1', 'fas fa-battery-half', 2500, 10, 100, 30, 30, 150, 100, 10, '[\"Subdomain\",\"POS\",\"Coupon\",\"Storage Limit\",\"Live Orders\",\"Whatsapp Order & Notification\",\"QR Menu\",\"Table Reservation\",\"Table QR Builder\",\"Call Waiter\",\"Staffs\",\"Blog\",\"Custom Page\",\"Online Order\",\"On Table\",\"Pick Up\",\"Home Delivery\",\"Postal Code Based Delivery Charge\",\"PWA Installability\"]', NULL, NULL, '2024-01-16 15:48:37', '2024-01-28 17:58:36'),
(48, 'Business', 'Business', 999, 'year', '1', '1', 15, '1', '0', 'fas fa-battery-full', 999999, 999999, 999999, 999999, 999999, 999999, 999999, 999999, '[\"Custom Domain\",\"Subdomain\",\"POS\",\"Coupon\",\"Amazon AWS s3\",\"Live Orders\",\"Whatsapp Order & Notification\",\"QR Menu\",\"Table Reservation\",\"Table QR Builder\",\"Call Waiter\",\"Staffs\",\"Blog\",\"Custom Page\",\"Online Order\",\"On Table\",\"Pick Up\",\"Home Delivery\",\"Postal Code Based Delivery Charge\",\"PWA Installability\"]', NULL, NULL, '2024-01-16 15:51:36', '2024-01-28 17:41:58'),
(49, 'Basic', 'Basic', 0, 'lifetime', '1', '1', 15, '1', '0', 'fas fa-battery-full', 1020, 999999, 999999, 10, 10, 20, 999999, 5, '[\"Storage Limit\"]', NULL, NULL, '2024-01-16 15:54:26', '2024-01-28 18:00:15'),
(50, 'Standard', 'Standard', 1499, 'lifetime', '1', '1', 15, '1', '1', 'fas fa-battery-full', 2500, 10, 100, 30, 30, 150, 100, 10, '[\"Subdomain\",\"POS\",\"Coupon\",\"Storage Limit\",\"Live Orders\",\"Whatsapp Order & Notification\",\"QR Menu\",\"Table Reservation\",\"Table QR Builder\",\"Call Waiter\",\"Staffs\",\"Blog\",\"Custom Page\",\"Online Order\",\"On Table\",\"Pick Up\",\"Home Delivery\",\"Postal Code Based Delivery Charge\",\"PWA Installability\"]', NULL, NULL, '2024-01-16 15:58:17', '2024-01-28 18:00:51'),
(51, 'Business', 'Business', 2999, 'lifetime', '1', '1', 15, '1', '0', 'fas fa-battery-full', 999999, 999999, 999999, 999999, 999999, 999999, 999999, 999999, '[\"Custom Domain\",\"Subdomain\",\"POS\",\"Coupon\",\"Amazon AWS s3\",\"Live Orders\",\"Whatsapp Order & Notification\",\"QR Menu\",\"Table Reservation\",\"Table QR Builder\",\"Call Waiter\",\"Staffs\",\"Blog\",\"Custom Page\",\"Online Order\",\"On Table\",\"Pick Up\",\"Home Delivery\",\"Postal Code Based Delivery Charge\",\"PWA Installability\"]', NULL, NULL, '2024-01-16 16:07:05', '2024-01-28 17:32:33');

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

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

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `body` blob,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `serial_number` int(11) NOT NULL DEFAULT '0',
  `meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `meta_description` text 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 `pages`
--

INSERT INTO `pages` (`id`, `language_id`, `name`, `title`, `subtitle`, `slug`, `body`, `status`, `serial_number`, `meta_keywords`, `meta_description`, `created_at`, `updated_at`) VALUES
(3, 176, 'Terms & Conditions', 'Terms & Conditions', 'Terms & Conditions', 'terms-&-conditions', 0x[encoded data, 5102 characters], 1, 2, NULL, NULL, '2020-08-21 04:06:16', '2024-01-29 14:13:11'),
(4, 176, 'Privacy Policy', 'Privacy Policy', 'Privacy Policy', 'privacy-policy', 0x[encoded data, 10768 characters], 1, 3, NULL, NULL, '2020-08-21 04:06:16', '2024-01-29 14:13:02'),
(9, 177, 'سياسة الخصوصية', 'سياسة الخصوصية', NULL, 'سياسة-الخصوصية', 0x[encoded data, 10768 characters], 1, 0, NULL, NULL, '2024-01-29 18:16:33', '2024-01-29 18:16:33'),
(10, 177, 'البنود و الظروف', 'البنود و الظروف', NULL, 'البنود-و-الظروف', 0x[encoded data, 5102 characters], 1, 0, NULL, NULL, '2024-01-29 18:17:12', '2024-01-29 18:17:12');

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

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

CREATE TABLE `partners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `serial_number` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `partners` (`id`, `language_id`, `image`, `url`, `serial_number`, `created_at`, `updated_at`) VALUES
(1, 176, 'fbb202d3560182f7b98d4becc1aede873b42e93b.png', 'https://www.example.com/', 1, NULL, NULL),
(2, 176, 'dffafdc83578824d0e6cefa74ab9fb8d437e094f.png', 'https://www.example.com/', 2, NULL, NULL),
(3, 176, '7a221033f6011dc26aa0bb04daa0a2dde352e61c.png', 'https://www.example.com/', 3, NULL, NULL),
(4, 176, 'c11de403e1cbe44e47047c76459c41d2975818b1.png', 'https://www.example.com/', 4, NULL, NULL),
(5, 177, 'a688e6dd1610a00b5fc39dc154bfe84cdfd80475.png', 'https://www.example.com/', 1, NULL, NULL),
(6, 177, '190867fb753b407545496665ca07dbf93d69a3bd.png', 'https://www.example.com/', 2, NULL, NULL),
(7, 177, '3c08abe177524050136f6883f9fd9ab545a7b0c6.png', 'https://www.example.com/', 3, NULL, NULL),
(8, 177, '812621bbe04bb0b3a163552f85566f7e58a46297.png', 'https://www.example.com/', 4, NULL, NULL);

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

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

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

--
-- Dumping data for table `password_resets`
--

INSERT INTO `password_resets` (`email`, `token`, `created_at`) VALUES
('imranyeasin75@gmail.com', '$2y$10$z/D6rNrJYGxTr82pjS9bk.asOCeNNL13WwO9K/1ADpxSFCkJ.lZDS', '2023-06-08 05:35:13');

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

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

CREATE TABLE `payment_gateways` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `details` text,
  `name` varchar(100) DEFAULT NULL,
  `type` varchar(20) NOT NULL DEFAULT 'manual',
  `information` mediumtext,
  `keyword` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `payment_gateways` (`id`, `subtitle`, `title`, `details`, `name`, `type`, `information`, `keyword`, `status`) VALUES
(6, NULL, NULL, NULL, 'Flutterwave', 'automatic', '{\"public_key\":\"FLWPUBK_TEST-a34940f2f87746abbdd8c117caee81cf-X\",\"secret_key\":\"FLWSECK_TEST-1cb427c96e0b1e6772a04504be3638bd-X\",\"text\":\"Pay via your Flutterwave account.\"}', 'flutterwave', 1),
(9, NULL, NULL, NULL, 'Razorpay', 'automatic', '{\"key\":\"rzp_test_fV9dM9URYbqjm7\",\"secret\":\"nickxZ1du2ojPYVVRTDif2Xr\",\"text\":\"Pay via your Razorpay account.\"}', 'razorpay', 1),
(11, NULL, NULL, NULL, 'Paytm', 'automatic', '{\"environment\":\"local\",\"merchant\":\"tkogux49985047638244\",\"secret\":\"LhNGUUKE9xCQ9xY8\",\"website\":\"WEBSTAGING\",\"industry\":\"Retail\",\"text\":\"Pay via your paytm account.\"}', 'paytm', 1),
(12, NULL, NULL, NULL, 'Paystack', 'automatic', '{\"key\":\"sk_test_4ac9f2c43514e3cc08ab68f922201549ebda1bfd\",\"email\":null,\"text\":\"Pay via your Paystack account.\"}', 'paystack', 1),
(13, NULL, NULL, NULL, 'Instamojo', 'automatic', '{\"key\":\"test_172371aa837ae5cad6047dc3052\",\"token\":\"test_4ac5a785e25fc596b67dbc5c267\",\"sandbox_check\":\"1\",\"text\":\"Pay via your Instamojo account.\"}', 'instamojo', 1),
(14, NULL, NULL, NULL, 'Stripe', 'automatic', '{\"key\":\"pk_test_UnU1Coi1p5qFGwtpjZMRMgJM\",\"secret\":\"sk_test_QQcg3vGsKRPlW6T3dXcNJsor\",\"text\":\"Pay via your Credit account.\"}', 'stripe', 1),
(15, NULL, NULL, NULL, 'Paypal', 'automatic', '{\"client_id\":\"AVYKFEw63FtDt9aeYOe9biyifNI56s2Hc2F1Us11hWoY5GMuegipJRQBfWLiIKNbwQ5tmqKSrQTU3zB3\",\"client_secret\":\"EJY0qOKliVg7wKsR3uPN7lngr9rL1N7q4WV0FulT1h4Fw3_e5Itv1mxSdbtSUwAaQoXQFgq-RLlk_sQu\",\"sandbox_check\":\"1\",\"text\":\"Pay via your PayPal account.\"}', 'paypal', 1),
(17, NULL, NULL, NULL, 'Mollie Payment', 'automatic', '{\"key\":\"test_m6BAuk4mJ7asBP52AtCWn3WjpK4Tv3\",\"text\":\"Pay via your Mollie Payment account.\"}', 'mollie', 1),
(19, NULL, NULL, NULL, 'Mercado Pago', 'automatic', '{\"token\":\"TEST-705032440135962-041006-ad2e021853f22338fe1a4db9f64d1491-421886156\",\"sandbox_check\":\"1\",\"text\":\"Pay via your Mercado Pago account.\"}', 'mercadopago', 1),
(20, NULL, NULL, NULL, 'Authorize.net', 'automatic', '{\"login_id\":\"3Ca5hYQ6h\",\"transaction_key\":\"8bt8Kr5gPZ3ZE23C\",\"public_key\":\"7m38JBnNjStNFq58BA6Wrr852ahtT533cGKavWwu6Fge28RDc5wC7wTL8Vsb35B3\",\"sandbox_check\":\"1\",\"text\":\"Pay via your Authorize.net account.\"}', 'authorize.net', 1);

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

--
-- Table structure for table `pcategories`
--

CREATE TABLE `pcategories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `is_feature` int(11) DEFAULT NULL,
  `tax` decimal(11,2) NOT NULL DEFAULT '0.00',
  `indx` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pcategories`
--

INSERT INTO `pcategories` (`id`, `language_id`, `user_id`, `name`, `slug`, `image`, `status`, `is_feature`, `tax`, `indx`, `created_at`, `updated_at`) VALUES
(46, 61, 2, 'Beverage', 'Beverage', '83ca1a7909340201c296e01e4b8f8b34c26316f8.png', 1, 1, '0.00', '65a78712d6861', '2024-01-16 18:51:46', '2024-01-16 18:51:56'),
(47, 62, 2, 'مشروب', 'مشروب', '83ca1a7909340201c296e01e4b8f8b34c26316f8.png', 1, 1, '0.00', '65a78712d6861', '2024-01-16 18:51:46', '2024-01-16 18:51:56'),
(48, 61, 2, 'Dessert', 'Dessert', '3298f3f0a513fe3cdce42db4c11d30f7ea110960.png', 1, 1, '0.00', '65a7873a6e385', '2024-01-16 18:52:26', '2024-01-16 18:52:28'),
(49, 62, 2, 'الحلوى', 'الحلوى', '3298f3f0a513fe3cdce42db4c11d30f7ea110960.png', 1, 1, '0.00', '65a7873a6e385', '2024-01-16 18:52:26', '2024-01-16 18:52:28'),
(50, 61, 2, 'Burger', 'Burger', '7c5183d4672d4c6ba4691c929db3726a72cdad05.png', 1, 1, '0.00', '65a78754ceafb', '2024-01-16 18:52:52', '2024-01-31 17:56:08'),
(51, 62, 2, 'برجر', 'برجر', '7c5183d4672d4c6ba4691c929db3726a72cdad05.png', 1, 1, '0.00', '65a78754ceafb', '2024-01-16 18:52:52', '2024-01-31 17:56:08'),
(52, 61, 2, 'Set Menu', 'Set-Menu', '631ee0c97acce34d8331d1b8da562713028264a8.png', 1, 1, '0.00', '65a787713e662', '2024-01-16 18:53:21', '2024-01-31 17:55:46'),
(53, 62, 2, 'قائمة الضبط', 'قائمة-الضبط', '631ee0c97acce34d8331d1b8da562713028264a8.png', 1, 1, '0.00', '65a787713e662', '2024-01-16 18:53:21', '2024-01-31 17:55:46'),
(54, 67, 6, 'Beverage', 'Beverage', '83ca1a7909340201c296e01e4b8f8b34c26316f8.png', 1, 1, '0.00', '65bb4590a1ae9', '2024-01-16 18:51:46', '2024-01-16 18:51:56'),
(56, 67, 6, 'Dessert', 'Dessert', '3298f3f0a513fe3cdce42db4c11d30f7ea110960.png', 1, 1, '0.00', '65bb45bc789ff', '2024-01-16 18:52:26', '2024-01-16 18:52:28'),
(62, 68, 7, 'Beverage', 'Beverage', '83ca1a7909340201c296e01e4b8f8b34c26316f8.png', 1, 1, '0.00', '65bb45cad4782', '2024-01-16 18:51:46', '2024-01-16 18:51:56'),
(63, 68, 7, 'Dessert', 'Dessert', '3298f3f0a513fe3cdce42db4c11d30f7ea110960.png', 1, 1, '0.00', '65bb45d8ea167', '2024-01-16 18:52:26', '2024-01-16 18:52:28');

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

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

CREATE TABLE `popups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `background_image` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `background_color` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `background_opacity` decimal(8,2) NOT NULL DEFAULT '1.00',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` text COLLATE utf8mb4_unicode_ci,
  `button_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_url` text COLLATE utf8mb4_unicode_ci,
  `button_color` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delay` int(11) NOT NULL DEFAULT '1000' COMMENT 'in milisconds',
  `serial_number` int(11) NOT NULL DEFAULT '0',
  `type` tinyint(4) NOT NULL DEFAULT '1',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - active, 0 - deactive',
  `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`, `name`, `image`, `background_image`, `background_color`, `background_opacity`, `title`, `text`, `button_text`, `button_url`, `button_color`, `end_date`, `end_time`, `delay`, `serial_number`, `type`, `status`, `created_at`, `updated_at`) VALUES
(33, 177, 'Black Friday', '606d41536fa81.jpg', NULL, NULL, '1.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1500, 1, 1, 0, '2021-04-06 19:21:23', '2021-04-07 22:06:58'),
(34, 177, 'Monthend Sale', NULL, '606d41d50dd28.jpg', '451D53', '0.80', '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', 'http://example.com/', '451D53', NULL, NULL, 2000, 2, 2, 0, '2021-04-06 19:23:33', '2021-04-07 22:06:21'),
(35, 177, 'Summer Sale', NULL, '606d42e66ee81.jpg', 'FF2865', '0.70', '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', NULL, 'FF2865', NULL, NULL, 2000, 3, 3, 0, '2021-04-06 19:28:06', '2021-04-07 22:06:18'),
(36, 177, 'Winter Offer', '606d43711d16a.jpg', NULL, NULL, '1.00', 'Get 10% off your first order', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt', 'Shop Now', 'http://example.com/', 'FF2865', NULL, NULL, 1500, 4, 4, 0, '2021-04-06 19:30:25', '2021-04-25 04:18:04'),
(37, 177, 'Winter Sale', '606d43dfad35b.jpg', NULL, NULL, '1.00', 'Get 10% off your first order', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt', 'Subscribe', NULL, 'F8960D', NULL, NULL, 2000, 6, 5, 0, '2021-04-06 19:32:15', '2021-04-07 22:06:09'),
(38, 177, 'New Arrivals Saleu', NULL, '606d55f99176d.jpg', NULL, '1.00', 'Hurry, Sale Ends This Friday', 'This is your last chance to save 30%', 'Yes,I Want to Save 30%', 'http://example.com/', '29A19C', '03/14/2022', '3:00 AM', 1500, 7, 6, 0, '2021-04-06 19:34:08', '2021-05-23 01:00:12'),
(39, 177, 'Flash Sale', '606d5691a51bf.jpg', NULL, '930077', '1.00', 'Hurry, Sale Ends This Friday', 'This is your last chance to save 30%', 'Yes,I Want to Save 30%', 'http://example.com/', 'FA00CA', '04/09/2022', '10:00 AM', 1500, 8, 7, 0, '2021-04-06 19:36:04', '2021-04-07 22:06:03'),
(42, 176, 'Popup', NULL, '3ccd0ef03842cc5b184e26384219733a22e3eb93.png', '451D53', '0.80', 'Many desktop publishing', 't has a more-or-less normal distribution of letters, as opposed to using', 'Submit', NULL, '451D53', NULL, NULL, 2000, 1, 3, 0, '2023-12-04 22:59:09', '2024-01-29 17:44:04'),
(43, 176, 'Hello', NULL, '997b8ab9fcef69b1ad6f16ee7a84216aab8d3912.png', '451D53', '0.50', 'Packages and web page editors now', 't has a more-or-less normal distribution of letters, as opposed to using', 'show more', '/pricing', '451D53', NULL, NULL, 2000, 2, 2, 0, '2024-01-29 14:37:28', '2024-01-29 17:44:12');

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

--
-- Table structure for table `postal_codes`
--

CREATE TABLE `postal_codes` (
  `id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `postcode` varchar(50) NOT NULL,
  `charge` decimal(11,2) NOT NULL DEFAULT '0.00',
  `free_delivery_amount` decimal(11,2) DEFAULT NULL,
  `serial_number` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `postal_codes`
--

INSERT INTO `postal_codes` (`id`, `language_id`, `user_id`, `title`, `postcode`, `charge`, `free_delivery_amount`, `serial_number`, `created_at`, `updated_at`) VALUES
(3, 61, 2, 'Bynum', '36253', '2.00', '30.00', 1, '2024-01-17 17:36:57', '2024-01-17 17:36:57'),
(4, 61, 2, 'Williamsburg', '23185', '2.50', NULL, 4, '2024-01-17 17:37:23', '2024-01-17 17:37:23'),
(5, 61, 2, 'Washington', '20036', '0.00', NULL, 3, '2024-01-17 17:37:48', '2024-01-17 17:37:48'),
(6, 61, 2, 'Scarsdale', '10583', '1.00', NULL, 5, '2024-01-17 17:38:12', '2024-01-17 17:38:12');

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

--
-- Table structure for table `pos_payment_methods`
--

CREATE TABLE `pos_payment_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL COMMENT '1 - active, 0 - deactive',
  `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 `pos_payment_methods`
--

INSERT INTO `pos_payment_methods` (`id`, `user_id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(2, 2, 'On Cash', 1, '2024-01-20 22:19:00', '2024-01-20 22:19:00'),
(3, 2, 'Paypal', 1, '2024-01-20 22:19:13', '2024-01-20 22:19:13');

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

--
-- Table structure for table `processes`
--

