-- Dumping data for table `basic_settings`
--

INSERT INTO `basic_settings` (`id`, `language_id`, `favicon`, `logo`, `website_title`, `base_color`, `secondary_base_color`, `support_email`, `support_phone`, `breadcrumb`, `footer_logo`, `footer_text`, `newsletter_text`, `copyright_text`, `hero_bg`, `hero_section_title`, `hero_section_bold_text`, `hero_section_text`, `hero_section_button_text`, `hero_section_button_url`, `hero_section_video_link`, `intro_bg`, `intro_section_title`, `intro_section_text`, `intro_section_button_text`, `intro_section_button_url`, `intro_section_video_link`, `service_section_title`, `service_section_subtitle`, `approach_title`, `approach_subtitle`, `approach_button_text`, `approach_button_url`, `cta_bg`, `cta_section_text`, `cta_section_button_text`, `cta_section_button_url`, `portfolio_section_title`, `portfolio_section_text`, `team_bg`, `team_section_title`, `team_section_subtitle`, `contact_form_title`, `contact_form_subtitle`, `quote_title`, `quote_subtitle`, `tawk_to_script`, `google_analytics_script`, `is_recaptcha`, `google_recaptcha_site_key`, `google_recaptcha_secret_key`, `is_tawkto`, `is_disqus`, `disqus_script`, `is_analytics`, `maintainance_mode`, `maintainance_text`, `is_appzi`, `appzi_script`, `is_addthis`, `addthis_script`, `service_title`, `service_subtitle`, `portfolio_title`, `portfolio_subtitle`, `testimonial_title`, `testimonial_subtitle`, `blog_section_title`, `blog_section_subtitle`, `faq_title`, `faq_subtitle`, `blog_title`, `blog_subtitle`, `service_details_title`, `portfolio_details_title`, `blog_details_title`, `gallery_title`, `gallery_subtitle`, `team_title`, `team_subtitle`, `contact_title`, `contact_subtitle`, `error_title`, `error_subtitle`, `is_quote`, `home_version`, `ips`, `event_title`, `event_subtitle`, `event_details_title`, `cause_title`, `cause_subtitle`, `cause_details_title`, `feature_section`, `intro_section`, `service_section`, `approach_section`, `statistics_section`, `portfolio_section`, `testimonial_section`, `team_section`, `news_section`, `call_to_action_section`, `partner_section`, `top_footer_section`, `copyright_section`) VALUES
(142, 169, '610eecacdfc0a.png', '610eb9e00ab43.png', 'Magic Information Technology Solutions (Oman)', '00AEEF', '002B5F', 'magicitsom@gmail.com', '+96894989890', '60518e00a7049.jpg', '610ecb501ceae.png', 'Magic IT Solutions is a full-fledged and independent software and design service located in the Sultanate of Oman, targeting both local and international companies. Magic IT Solutions focuses on cutting edge web solutions, high performance web hosting, and e-marketing services. Our passionate and talented team members are experienced in everything in the digital industry.', 'Subscribe to get the  Latest News, Offer and connect With Us.', 0x3c703e436f7079726967687420c2a920323032312e20416c6c20726967687473207265736572766564206279266e6273703b4d414749434954533c2f703e, '6111713ae7479.svg', 'Financial Planning For Life', 'Quality Service Happy customers', 'Trusted to help guide entrepreneurs make better financial decisions.', 'Learn More', '#', 'https://www.youtube.com/watch?v=2FmmsRBWgiA', '6111a5df6f4be.png', 'Who we are', 'We provide services for electronic solutions, software and distinctive designs.', 'more', 'http://magicits.co/About-Us', 'https://www.youtube.com/watch?v=Q2RlxUfKu3c', 'Our Services', 'We work with you to achieve your goals', 'our way for work', 'explain everything you want and start planning together', 'start with us', 'https://magicits.co/contact', '6066a597791b6.jpg', 'Contact us for help with your business.', 'Contact Us', 'https://magictis.xyz/contact', 'Our latest projects', 'A fresh approach to financial services for entrepreneurs', '6062dea7439b1.jpg', 'Expert Team', 'Meet our expert finlance executive team', 'Contact us', 'Need information fill form and send us', 'Request A  Service', 'Have a project ? Send us a quote', '<!--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/5e7477c08d24fc226588d638/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-->', '<!-- Global site tag (gtag.js) - Google Analytics -->\r\n<script async src=\"https://www.googletagmanager.com/gtag/js?id=UA-137437974-2\"></script>\r\n<script>\r\n  window.dataLayer = window.dataLayer || [];\r\n  function gtag(){dataLayer.push(arguments);}\r\n  gtag(\'js\', new Date());\r\n\r\n  gtag(\'config\', \'UA-137437974-2\');\r\n</script>', 0, '6Lf9jOQUAAAAABJKj_nQBNvji7wh4DdOZIPAdRKk', '6Lf9jOQUAAAAALO4C5pC7O_HHw0Z1BuYCU_FA606', 0, 1, '<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>', 1, 0, 'We are upgrading our site. We will come back soon. \r\nPlease stay with us.\r\nThank you.', 0, '<!-- Appzi: Capture Insightful Feedback -->\r\n<script async src=\"https://w.appzi.io/bootstrap/bundle.js?token=LyCxj\"></script>\r\n<!-- End Appzi -->', 0, '<!-- Go to www.addthis.com/dashboard to customize your tools -->\r\n<script type=\"text/javascript\" src=\"//s7.addthis.com/js/300/addthis_widget.js#pubid=ra-5db876f049b4480b\"></script>', 'Services We Provide', 'We work with you to achieve your goals.', 'Portfolios', 'Have a look at our all projects', 'Testimonial', 'What people say about finlance planning', 'Latest news', 'Have a look at the finlance latest News', 'F.A.Q', 'Frequestly Asked Questions', 'Latest Blog', 'From the latest news and blog', 'Service Details', 'Portfolio Details', 'Blog Details', 'Our Gallery', 'Take a look at our captured moments', 'Team Members', 'Meet our team members', 'Contact Us', 'Need information? contact us', '404 Not Found', 'Oops! Looks like you\'re lost', 1, 'slider', NULL, 'Events', 'Join Our Events & Conferences', 'Event Details', 'Causes', 'Donate Us to Grow Together', 'Cause Details', 1, 1, 1, 1, 0, 1, 0, 0, 0, 1, 1, 1, 1),
(146, 173, '610eecace7f19.png', '610eb9e019022.png', 'Magic Information Technology Solutions (Oman)', '00AEEF', '002B5F', 'magicitsom@gmail.com', '96894989890+', '60518e00b635d.jpg', '610ed1a5b973f.png', 'ماجيك لحلول تقنية المعلومات هي خدمة كاملة ومستقلة للبرمجيات والتصميمات تقع في سلطنة عمان وتستهدف الشركات المحلية والدولية على حد سواء. تركز ماجيك لحلول تقنية المعلومات على حلول الويب المتطورة ، واستضافة المواقع عالية الأداء ، وخدمات التسويق الإلكتروني. يتمتع أعضاء فريقنا المتحمسون والموهوبون بالخبرة في كل شيء في الصناعة الرقمية. من تصميم المواقع الإلكترونية وتطويرها إلى استضافة الويب وتكوينات الخادم وحتى التسويق عبر الإنترنت وتحويل حركة المرور إلى المبيعات – نحن مؤهلون في جميع الأقسام.', 'اشترك في  القائمة البريدية ليصلك كل جديد من ، عرض وأخبار  .', 0x3c646976207374796c653d22746578742d616c69676e3a2072696768743b223ed8add982d988d98220d8a7d984d8b7d8a8d8b920d988d8a7d984d986d8b4d8b120c2a920d9a2d9a0d9a2d9a12e20d8acd985d98ad8b920d8a7d984d8add982d988d98220d985d8add981d988d8b8d8a920d984d8b4d8b1d983d8a9266e6273703bd985d8a7d8acd98ad983266e6273703b266e6273703bd984d8add984d988d98420d8aad982d986d98ad8a920d8a7d984d985d8b9d984d988d985d8a7d8aa3c2f6469763e, '61116fc5855fc.svg', 'حقق ما تريد من MAGIC', 'خدمة عملاء سعداء', 'أنت أفضل من يستطيع انشاء المشروع الخاص بك وماجيك أفضل من يمكنه مساعدتك لا تتردد.', 'طلب خدمة', 'https://magicits.co/quote', 'https://www.youtube.com/watch?v=2FmmsRBWgiA', '6111a600bb02a.png', 'من نحن', 'نقدم خدمات للحلول الالكترونية والبرمجيات والتصاميم المميزة', 'المزيد', 'https://magicits.co/%D9%85%D9%86-%D9%86%D8%AD%D9%86', 'https://www.youtube.com/watch?v=Q2RlxUfKu3c', 'خدماتنا', 'نحن نعمل معك لتحقيق أهدافك', 'عملنا', 'يمكنك شرح كل ما تريد ونبدأ التخطيط معا', 'أبدأ معنا', 'https://magicits.co/contact', '5e765bda9345f.jpg', 'اتصل بنا للمساعدة في اعمالك.', 'اتصل بنا', 'https://magictis.xyz/contact', 'أحدث مشاريعنا', 'نهج جديد للخدمات المالية لأصحاب المشاريع', '606179e0edafd.jpg', 'فريق الخبراء', 'تلبية لدينا فريق الخبراء المالي finlance', 'اتصل بنا', 'تحتاج معلومات يجب ملء النموذج والإرسال إلينا', 'لطلب الخدمة', 'لديك مشروع؟ أرسل لنا طلب الخدمة', '<!--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/5e7477c08d24fc226588d638/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-->', '<!-- Global site tag (gtag.js) - Google Analytics -->\r\n<script async src=\"https://www.googletagmanager.com/gtag/js?id=UA-137437974-2\"></script>\r\n<script>\r\n  window.dataLayer = window.dataLayer || [];\r\n  function gtag(){dataLayer.push(arguments);}\r\n  gtag(\'js\', new Date());\r\n\r\n  gtag(\'config\', \'UA-137437974-2\');\r\n</script>', 0, '6Lf9jOQUAAAAABJKj_nQBNvji7wh4DdOZIPAdRKk', '6Lf9jOQUAAAAALO4C5pC7O_HHw0Z1BuYCU_FA606', 0, 1, '<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>', 1, 0, 'We are upgrading our site. We will come back soon. \r\nPlease stay with us.\r\nThank you.', 0, '<!-- Appzi: Capture Insightful Feedback -->\r\n<script async src=\"https://w.appzi.io/bootstrap/bundle.js?token=LyCxj\"></script>\r\n<!-- End Appzi -->', 0, '<!-- Go to www.addthis.com/dashboard to customize your tools -->\r\n<script type=\"text/javascript\" src=\"//s7.addthis.com/js/300/addthis_widget.js#pubid=ra-5db876f049b4480b\"></script>', 'الخدمات التي نقدمها', 'نحن نعمل معك لتحقيق أهدافك', 'البروفايل', 'مشاريعنا', 'شهادة', 'ما يقوله الناس عن التخطيط المالي', 'أحدث الأخبار', 'إلقاء نظرة على finlance آخر الأخبار', 'التعليمات', 'الأسئلة المتداولة', 'أحدث مدونة', 'من آخر الأخبار والمدونة', 'تفاصيل الخدمة', 'تفاصيل المحفظة', 'تفاصيل المدونة', 'معرضنا', 'نلقي نظرة على لحظاتنا الملتقطة', 'أعضاء الفريق', 'قابل أعضاء فريقنا', 'اتصل بنا', 'بحاجة الى معلومات؟ اتصل بنا', '404 غير موجود', 'وجه الفتاة! يبدو أنك فقدت', 1, 'slider', NULL, 'الأحداث', 'انضم إلى أحداثنا ومؤتمراتنا', 'تفاصيل الحدث', 'الأسباب', 'تبرع بنا لننمو معا', 'تفاصيل السبب', 1, 1, 1, 1, 0, 1, 0, 0, 0, 1, 1, 1, 1);

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

--
-- Table structure for table `basic_settings_extended`
--

CREATE TABLE `basic_settings_extended` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) DEFAULT NULL,
  `pricing_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pricing_subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cookie_alert_status` tinyint(4) NOT NULL DEFAULT '1',
  `cookie_alert_text` blob,
  `cookie_alert_button_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_mail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `career_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `career_subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `event_calendar_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `event_calendar_subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rss_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rss_subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rss_details_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `default_language_direction` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ltr' COMMENT 'ltr / rtl',
  `home_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `home_meta_description` text COLLATE utf8mb4_unicode_ci,
  `services_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `services_meta_description` text COLLATE utf8mb4_unicode_ci,
  `packages_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `packages_meta_description` text COLLATE utf8mb4_unicode_ci,
  `portfolios_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `portfolios_meta_description` text COLLATE utf8mb4_unicode_ci,
  `team_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `team_meta_description` text COLLATE utf8mb4_unicode_ci,
  `career_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `career_meta_description` text COLLATE utf8mb4_unicode_ci,
  `calendar_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `calendar_meta_description` text COLLATE utf8mb4_unicode_ci,
  `gallery_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `gallery_meta_description` text COLLATE utf8mb4_unicode_ci,
  `faq_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `faq_meta_description` text COLLATE utf8mb4_unicode_ci,
  `blogs_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `blogs_meta_description` text COLLATE utf8mb4_unicode_ci,
  `rss_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `rss_meta_description` text COLLATE utf8mb4_unicode_ci,
  `contact_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `contact_meta_description` text COLLATE utf8mb4_unicode_ci,
  `quote_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `quote_meta_description` text COLLATE utf8mb4_unicode_ci,
  `is_facebook_pexel` tinyint(4) NOT NULL DEFAULT '0',
  `facebook_pexel_script` text COLLATE utf8mb4_unicode_ci,
  `theme_version` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT 'default_service_category',
  `hero_overlay_color` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hero_overlay_opacity` decimal(8,2) DEFAULT NULL,
  `statistics_overlay_color` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `statistics_overlay_opacity` decimal(8,2) DEFAULT NULL,
  `team_overlay_color` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `team_overlay_opacity` decimal(8,2) DEFAULT NULL,
  `cta_overlay_color` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cta_overlay_opacity` decimal(8,2) DEFAULT NULL,
  `intro_overlay_color` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `intro_overlay_opacity` decimal(8,2) DEFAULT NULL,
  `pricing_overlay_color` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pricing_overlay_opacity` decimal(8,2) DEFAULT NULL,
  `breadcrumb_overlay_color` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `breadcrumb_overlay_opacity` decimal(8,2) DEFAULT NULL,
  `from_mail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_smtp` tinyint(4) NOT NULL DEFAULT '0',
  `smtp_host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smtp_port` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `encryption` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smtp_username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smtp_password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hero_section_title_font_size` int(11) DEFAULT NULL,
  `hero_section_bold_text_font_size` int(11) DEFAULT NULL,
  `hero_section_bold_text_color` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hero_section_text_font_size` int(11) DEFAULT NULL,
  `hero_section_button_text_font_size` int(11) DEFAULT NULL,
  `statistics_bg` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `package_background` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_details_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cart_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cart_subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checkout_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checkout_subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `intro_bg2` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `popular_tags` text COLLATE utf8mb4_unicode_ci,
  `open_hour` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `about_title` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `about_year` int(11) NOT NULL DEFAULT '0',
  `about_bold_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `about_summary` text COLLATE utf8mb4_unicode_ci,
  `about_signature` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `about_phone` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `about_main_image` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `about_side_image1` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `about_side_image2` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `about_section` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0 - deactive, 1 - active',
  `menu_section` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0 - deactive, 1 - active',
  `special_offer_section` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0 - deactive, 1 - active',
  `instagram_section` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0 - deactive, 1 - active',
  `map_section` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0 - deactive, 1 - active',
  `products_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `products_meta_description` text COLLATE utf8mb4_unicode_ci,
  `cart_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `cart_meta_description` text COLLATE utf8mb4_unicode_ci,
  `checkout_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `checkout_meta_description` text COLLATE utf8mb4_unicode_ci,
  `login_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `login_meta_description` text COLLATE utf8mb4_unicode_ci,
  `register_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `register_meta_description` text COLLATE utf8mb4_unicode_ci,
  `forgot_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `forgot_meta_description` text COLLATE utf8mb4_unicode_ci,
  `events_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `events_meta_description` text COLLATE utf8mb4_unicode_ci,
  `causes_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `causes_meta_description` text COLLATE utf8mb4_unicode_ci,
  `pricing_section` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - active, 0 - deactive'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `basic_settings_extended`
--

INSERT INTO `basic_settings_extended` (`id`, `language_id`, `pricing_title`, `pricing_subtitle`, `cookie_alert_status`, `cookie_alert_text`, `cookie_alert_button_text`, `to_mail`, `career_title`, `career_subtitle`, `event_calendar_title`, `event_calendar_subtitle`, `rss_title`, `rss_subtitle`, `rss_details_title`, `default_language_direction`, `home_meta_keywords`, `home_meta_description`, `services_meta_keywords`, `services_meta_description`, `packages_meta_keywords`, `packages_meta_description`, `portfolios_meta_keywords`, `portfolios_meta_description`, `team_meta_keywords`, `team_meta_description`, `career_meta_keywords`, `career_meta_description`, `calendar_meta_keywords`, `calendar_meta_description`, `gallery_meta_keywords`, `gallery_meta_description`, `faq_meta_keywords`, `faq_meta_description`, `blogs_meta_keywords`, `blogs_meta_description`, `rss_meta_keywords`, `rss_meta_description`, `contact_meta_keywords`, `contact_meta_description`, `quote_meta_keywords`, `quote_meta_description`, `is_facebook_pexel`, `facebook_pexel_script`, `theme_version`, `hero_overlay_color`, `hero_overlay_opacity`, `statistics_overlay_color`, `statistics_overlay_opacity`, `team_overlay_color`, `team_overlay_opacity`, `cta_overlay_color`, `cta_overlay_opacity`, `intro_overlay_color`, `intro_overlay_opacity`, `pricing_overlay_color`, `pricing_overlay_opacity`, `breadcrumb_overlay_color`, `breadcrumb_overlay_opacity`, `from_mail`, `from_name`, `is_smtp`, `smtp_host`, `smtp_port`, `encryption`, `smtp_username`, `smtp_password`, `hero_section_title_font_size`, `hero_section_bold_text_font_size`, `hero_section_bold_text_color`, `hero_section_text_font_size`, `hero_section_button_text_font_size`, `statistics_bg`, `package_background`, `product_title`, `product_subtitle`, `product_details_title`, `cart_title`, `cart_subtitle`, `checkout_title`, `checkout_subtitle`, `intro_bg2`, `popular_tags`, `open_hour`, `about_title`, `about_year`, `about_bold_text`, `about_summary`, `about_signature`, `about_phone`, `about_main_image`, `about_side_image1`, `about_side_image2`, `about_section`, `menu_section`, `special_offer_section`, `instagram_section`, `map_section`, `products_meta_keywords`, `products_meta_description`, `cart_meta_keywords`, `cart_meta_description`, `checkout_meta_keywords`, `checkout_meta_description`, `login_meta_keywords`, `login_meta_description`, `register_meta_keywords`, `register_meta_description`, `forgot_meta_keywords`, `forgot_meta_description`, `events_meta_keywords`, `events_meta_description`, `causes_meta_keywords`, `causes_meta_description`, `pricing_section`) VALUES
(140, 169, 'Packages', 'Choose a package which suits you best', 1, 0x3c703e3c7370616e20636c6173733d22636f6f6b69652d636f6e73656e745f5f6d65737361676522207374796c653d226d617267696e3a203070783b2070616464696e673a203070783b20626f726465723a203070783b20766572746963616c2d616c69676e3a20626173656c696e653b20666f6e742d66616d696c793a20506f7070696e732c2073616e732d73657269663b20666f6e742d73697a653a20313670783b223e3c7370616e20636c6173733d22636f6f6b69652d636f6e73656e745f5f6d65737361676522207374796c653d226d617267696e3a203070783b2070616464696e673a203070783b20626f726465723a203070783b20766572746963616c2d616c69676e3a20626173656c696e653b223e596f757220657870657269656e6365206f6e207468697320736974652077696c6c20626520696d70726f76656420627920616c6c6f77696e6720636f6f6b6965732e3c2f7370616e3e3c2f7370616e3e3c7370616e20636c6173733d22636f6f6b69652d636f6e73656e745f5f6d65737361676522207374796c653d226d617267696e3a203070783b2070616464696e673a203070783b20626f726465723a203070783b20766572746963616c2d616c69676e3a20626173656c696e653b20666f6e742d66616d696c793a20506f7070696e732c2073616e732d73657269663b20666f6e742d73697a653a20313670783b223e3c7370616e20636c6173733d22636f6f6b69652d636f6e73656e745f5f6d65737361676522207374796c653d226d617267696e3a203070783b2070616464696e673a203070783b20626f726465723a203070783b20766572746963616c2d616c69676e3a20626173656c696e653b223e3c62723e3c2f7370616e3e3c2f7370616e3e3c2f703e3c6469763e3c7370616e20636c6173733d22636f6f6b69652d636f6e73656e745f5f6d65737361676522207374796c653d226d617267696e3a203070783b2070616464696e673a203070783b20626f726465723a203070783b20766572746963616c2d616c69676e3a20626173656c696e653b20636f6c6f723a20726762283235352c203235352c20323535293b20666f6e742d66616d696c793a20506f7070696e732c2073616e732d73657269663b20666f6e742d73697a653a20313670783b206261636b67726f756e642d636f6c6f723a207267622833382c2034312c203536293b223e3c7370616e20636c6173733d22636f6f6b69652d636f6e73656e745f5f6d65737361676522207374796c653d226d617267696e3a203070783b2070616464696e673a203070783b20626f726465723a203070783b20766572746963616c2d616c69676e3a20626173656c696e653b223e3c62723e3c2f7370616e3e3c2f7370616e3e3c2f6469763e, 'Allow Cookies', 'pratik.anwar@gmail.com', 'Career', 'Join our team, improve your skills', 'Events in Calendar', 'Take a quick look at our schedules', 'RSS Feeds', 'Stay Updated about World News', 'Blog Details', 'ltr', 'Magic,Magic Information Technology Solutions,Magic ITS', 'Magic Information Technology Solutions', 'web,design,web design,web development', 'Magic Information Technology Solutions,\r\nweb design, \r\nweb development,', NULL, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', NULL, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 'lorem,ipsum', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 'lorem,ipsum', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 'event,calendar', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 'lorem,ipsum', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 'lorem', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 'lorem, dolor', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 'rss,abc,independent', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 'lorem', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 'ipsum', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 0, '<!-- Facebook Pixel Code -->\r\n<script>\r\n!function(f,b,e,v,n,t,s)\r\n{if(f.fbq)return;n=f.fbq=function(){n.callMethod?\r\nn.callMethod.apply(n,arguments):n.queue.push(arguments)};\r\nif(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version=\'2.0\';\r\nn.queue=[];t=b.createElement(e);t.async=!0;\r\nt.src=v;s=b.getElementsByTagName(e)[0];\r\ns.parentNode.insertBefore(t,s)}(window, document,\'script\',\r\n\'https://connect.facebook.net/en_US/fbevents.js\');\r\nfbq(\'init\', \'2723323421236702\');\r\nfbq(\'track\', \'PageView\');\r\n</script>\r\n<noscript><img height=\"1\" width=\"1\" style=\"display:none\"\r\nsrc=\"https://www.facebook.com/tr?id=2723323421236702&ev=PageView&noscript=1\"\r\n/></noscript>\r\n<!-- End Facebook Pixel Code -->', 'default', '0056B0', '0.60', '0A3041', '0.90', '0A3041', '0.80', '0A3041', '0.70', '13287E', '0.50', '09090B', '0.65', '002B5F', '0.90', 'admin@kreativdev.com', 'PlusAgency', 1, 'mail.kreativdev.com', '2525', 'TLS', 'admin@kreativdev.com', 'ZAOP!~rSk~gb', 24, 76, 'FFFFFF', 60, 14, '6111ad2a99508.png', '604ed4c139312.jpg', 'Products', 'Choose from our amazing products', 'Product Details', 'Cart', 'Manage your cart', 'Checkout', 'Pay & Purchase your desired items', '606457e160659.png', 'a,b,c,d', 'Sat - Sun 07.00 AM to 10.00 PM', 'Our Story', 25, 'Years Since We Provide Organic Food & Vegetables For Golbal Agency', 'Aenean sed nibh a magna posuere tempor. Nunc faucibus pellentesque nunc in aliquet. Donec congue, nunc vel tempor congue, enim sapien lobortis ipsum, in volutpat.', NULL, '515-708-9386', '5ec62a616c333.png', '5ec62afdd77b5.jpg', '5ec62b301b568.jpg', 1, 1, 1, 1, 1, 'products,page', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', 'cart,page', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', 'checkout,page', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', 'login,page', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', 'register,page', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', 'forgot,password,page', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', NULL, NULL, NULL, NULL, 0),
(144, 173, 'حزم لدينا', 'اختيار الحزمة التي تناسبك', 1, 0x3c7370616e20636c6173733d22636f6f6b69652d636f6e73656e745f5f6d65737361676522207374796c653d226d617267696e3a203070783b2070616464696e673a203070783b20626f726465723a203070783b20766572746963616c2d616c69676e3a20626173656c696e653b20666f6e742d66616d696c793a20506f7070696e732c2073616e732d73657269663b20666f6e742d73697a653a20313670783b206261636b67726f756e642d636f6c6f723a20726762283235352c203235352c20323535293b223ed8b3d98ad8aad98520d8aad8add8b3d98ad98620d8aad8acd8b1d8a8d8aad98320d981d98a20d987d8b0d8a720d8a7d984d985d988d982d8b920d985d98620d8aed984d8a7d98420d8a7d984d8b3d985d8a7d8ad20d8a8d985d984d981d8a7d8aa20d8aad8b9d8b1d98ad98120d8a7d984d8a7d8b1d8aad8a8d8a7d8b72e3c2f7370616e3e, 'السماح للكوكيز', 'pratik.anwar@gmail.com', 'مسار مهني مسار وظيفي', 'انضم لفريقنا ، حسّن مهاراتك', 'الأحداث في التقويم', 'ألق نظرة سريعة على جداولنا', 'خلاصات RSS', 'تحديث البقاء حول أخبار العالم', 'تفاصيل المدونة', 'ltr', 'ماجيك لحلول تقنية المعلومات ( سلطنة عمان),ماجيك', 'ماجيك لحلول تقنية المعلومات ( سلطنة عمان)', 'حلول تقنية المعلومات', 'ماجيك لحلول تقنية المعلومات ( سلطنة عمان)', 'هناك ,حقيقة', 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز', 'هناك ,حقيقة', 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز', 'هناك ,حقيقة', 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز', 'هناك ,حقيقة', 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز', NULL, 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز', 'هناك ,حقيقة', 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز', 'هناك ,حقيقة', 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز', 'هناك ,حقيقة', 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز', NULL, NULL, 'هناك ,حقيقة', 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز', 'هناك ,حقيقة', 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز', 0, '<!-- Facebook Pixel Code -->\r\n<script>\r\n!function(f,b,e,v,n,t,s)\r\n{if(f.fbq)return;n=f.fbq=function(){n.callMethod?\r\nn.callMethod.apply(n,arguments):n.queue.push(arguments)};\r\nif(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version=\'2.0\';\r\nn.queue=[];t=b.createElement(e);t.async=!0;\r\nt.src=v;s=b.getElementsByTagName(e)[0];\r\ns.parentNode.insertBefore(t,s)}(window, document,\'script\',\r\n\'https://connect.facebook.net/en_US/fbevents.js\');\r\nfbq(\'init\', \'2723323421236702\');\r\nfbq(\'track\', \'PageView\');\r\n</script>\r\n<noscript><img height=\"1\" width=\"1\" style=\"display:none\"\r\nsrc=\"https://www.facebook.com/tr?id=2723323421236702&ev=PageView&noscript=1\"\r\n/></noscript>\r\n<!-- End Facebook Pixel Code -->', 'default', '0056B0', '0.60', '0A3041', '0.90', '0A3041', '0.80', '0A3041', '0.70', '13287E', '0.50', '09090B', '0.65', '002B5F', '0.90', 'admin@kreativdev.com', 'PlusAgency', 1, 'mail.kreativdev.com', '2525', 'TLS', 'admin@kreativdev.com', 'ZAOP!~rSk~gb', 24, 76, 'FFFFFF', 60, 14, '6111a88742741.png', '5ea9c7e0a561a.jpg', 'منتجات', 'اختر من منتجاتنا المدهشة', 'تفاصيل المنتج', 'عربة التسوق', 'إدارة سلة التسوق الخاصة بك', 'الدفع', 'ادفع واشترِ العناصر التي تريدها', '6076b80478f1c.jpg', 'هناك حقيقة مثبتة منذ زمن', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);

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

--
-- Table structure for table `basic_settings_extra`
--

CREATE TABLE `basic_settings_extra` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT '1',
  `is_shop` tinyint(4) NOT NULL DEFAULT '1',
  `is_ticket` tinyint(4) NOT NULL DEFAULT '1',
  `is_user_panel` tinyint(4) NOT NULL DEFAULT '1',
  `base_currency_symbol` blob,
  `base_currency_symbol_position` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'left',
  `base_currency_text` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `base_currency_text_position` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'right',
  `base_currency_rate` decimal(8,2) NOT NULL DEFAULT '0.00',
  `tax` decimal(8,2) NOT NULL DEFAULT '0.00',
  `is_facebook_login` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - Active, 0 - Deactive',
  `facebook_app_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook_app_secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_google_login` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - Active, 0 - Deactive',
  `google_client_id` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `google_client_secret` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_guest_checkout` tinyint(4) NOT NULL DEFAULT '1',
  `product_rating_system` tinyint(4) NOT NULL DEFAULT '1',
  `package_guest_checkout` tinyint(4) NOT NULL DEFAULT '1',
  `timezone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `recurring_billing` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - active, 0 - deactive',
  `expiration_reminder` int(11) DEFAULT NULL COMMENT 'number of days of reminder before subscription expiration',
  `preloader_status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0 - deactive, 1 - active',
  `preloader` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `course_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `course_subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `course_details_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_course` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - activate all pages related to courses, 0 - deactivate all pages related to courses',
  `knowledgebase_title` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `knowledgebase_subtitle` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `knowledgebase_details_title` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `donation_guest_checkout` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - active, 0 - deactive',
  `is_donation` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - active, 0 - deactive',
  `is_event` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - active, 0 - deactive',
  `event_guest_checkout` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - active, 0 - deactive',
  `service_category` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - active, 0 - deactive',
  `catalog_mode` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1 - active, 2 - deactive',
  `is_course_rating` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0 - deactive, 1 - active',
  `push_notification_icon` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_addresses` text COLLATE utf8mb4_unicode_ci,
  `contact_numbers` text COLLATE utf8mb4_unicode_ci,
  `contact_mails` text COLLATE utf8mb4_unicode_ci,
  `latitude` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `map_zoom` int(11) NOT NULL DEFAULT '15',
  `home_page_pagebuilder` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - enabled, 0 - disabled',
  `custom_page_pagebuilder` tinyint(4) NOT NULL DEFAULT '1' COMMENT '0 - disabled, 1 - enabled',
  `is_whatsapp` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - enable, 0 - disable',
  `whatsapp_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `whatsapp_header_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Chat with us on WhatsApp!',
  `whatsapp_popup_message` text COLLATE utf8mb4_unicode_ci,
  `whatsapp_popup` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - enable, 0 - disable',
  `client_feedback_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_feedback_subtitle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `faq_category_status` tinyint(3) UNSIGNED NOT NULL,
  `gallery_category_status` tinyint(3) UNSIGNED NOT NULL,
  `package_category_status` tinyint(3) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `basic_settings_extra`
--

INSERT INTO `basic_settings_extra` (`id`, `language_id`, `is_shop`, `is_ticket`, `is_user_panel`, `base_currency_symbol`, `base_currency_symbol_position`, `base_currency_text`, `base_currency_text_position`, `base_currency_rate`, `tax`, `is_facebook_login`, `facebook_app_id`, `facebook_app_secret`, `is_google_login`, `google_client_id`, `google_client_secret`, `product_guest_checkout`, `product_rating_system`, `package_guest_checkout`, `timezone`, `recurring_billing`, `expiration_reminder`, `preloader_status`, `preloader`, `course_title`, `course_subtitle`, `course_details_title`, `is_course`, `knowledgebase_title`, `knowledgebase_subtitle`, `knowledgebase_details_title`, `donation_guest_checkout`, `is_donation`, `is_event`, `event_guest_checkout`, `service_category`, `catalog_mode`, `is_course_rating`, `push_notification_icon`, `contact_addresses`, `contact_numbers`, `contact_mails`, `latitude`, `longitude`, `map_zoom`, `home_page_pagebuilder`, `custom_page_pagebuilder`, `is_whatsapp`, `whatsapp_number`, `whatsapp_header_title`, `whatsapp_popup_message`, `whatsapp_popup`, `client_feedback_title`, `client_feedback_subtitle`, `faq_category_status`, `gallery_category_status`, `package_category_status`) VALUES
(1, 169, 0, 1, 1, 0x24, 'left', 'USD', 'right', '1.00', '5.00', 0, '211657824026859', '72e2d5c729f4116ae69b37544efcf588', 0, '81856165251-i0o8lgjghadindghpk0bnr9qb6hrqo5r.apps.googleusercontent.com', 'otutovHmfl4eFj8WZVq0sYNz', 0, 0, 0, 'Europe/Andorra', 1, 3, 0, '604da366b8e8e.gif', 'Courses', 'Choose From Our Amazing Courses', 'Course Details', 1, 'Knowledgebase', 'Find Answers Before Asking', 'Knowledgebase Details', 0, 1, 1, 1, 1, 0, 1, '605ac7a0f0810.png', 'Oman - Muscat', '+96894989890', 'magicitsom@gmail.com', '23.5880', '58.3829', 12, 0, 1, 1, '+96894989890', 'Welcome to Magic I T S', 'Admin can also disable WhatsApp Chat\r\n& enable Tawk.to chat\r\n(Admin can set any message here)', 1, 'Client Feedback', 'Feel Free to Leave us Some Suggestions', 1, 1, 1),
(4, 173, 0, 1, 1, 0x24, 'left', 'USD', 'right', '1.00', '5.00', 0, '211657824026859', '72e2d5c729f4116ae69b37544efcf588', 0, '81856165251-i0o8lgjghadindghpk0bnr9qb6hrqo5r.apps.googleusercontent.com', 'otutovHmfl4eFj8WZVq0sYNz', 0, 0, 0, 'Europe/Andorra', 1, 3, 0, '604da366b8e8e.gif', 'الدورات', 'اختر من بين دوراتنا المذهلة', 'تفاصيل الدورة', 1, 'قاعدة المعرفة', 'ابحث عن الإجابات قبل السؤال', 'تفاصيل قاعدة المعرفة', 0, 1, 1, 1, 1, 0, 1, '605ac7a113dfc.png', 'عمان - مسقط', '96894989890+', 'magicitsom@gmail.com', '23.5880', '58.3829', 12, 0, 1, 1, '+96894989890', 'Welcome to Magic I T S', 'Admin can also disable WhatsApp Chat\r\n& enable Tawk.to chat\r\n(Admin can set any message here)', 1, 'ملاحظات العملاء', 'لا تتردد في ترك بعض الاقتراحات لنا', 1, 1, 1);

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

--
-- 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,
  `slug` 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`, `slug`, `status`, `serial_number`) VALUES
(27, 169, 'Travel', 'Travel', 1, 1),
(28, 169, 'Lifestyle', 'Lifestyle', 1, 2),
(29, 169, 'Design', 'Design', 1, 3),
(30, 169, 'Technology', 'Technology', 1, 4),
(31, 169, 'Business', 'Business', 1, 5),
(37, 173, 'السفر', 'السفر', 1, 1),
(38, 173, 'لايف ستايل', 'لايف-ستايل', 1, 2),
(39, 173, 'التصميم', 'التصميم', 1, 3),
(40, 173, 'تقنية', 'تقنية', 1, 4),
(41, 173, 'اعمال', 'اعمال', 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,
  `sidebar` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - enabled, 0 - disabled',
  `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`, `sidebar`, `meta_keywords`, `meta_description`, `serial_number`, `created_at`, `updated_at`) VALUES
(41, 169, 27, 'Lorem ipsum dolor sit amet, elit.', 'Lorem-ipsum-dolor-sit-amet,-elit.', '1576945635.jpg', 0x[encoded data, 5660 characters], 1, 'Travel', NULL, 1, '2019-12-21 22:27:39', '2020-08-12 08:55:34'),
(42, 169, 28, 'Invest $5000 for secure your policy', 'Invest-$5000-for-secure-your-policy', '1576945678.jpg', 0x[encoded data, 4806 characters], 1, 'lifestyle,business', NULL, 2, '2019-12-21 22:28:28', '2020-10-28 03:44:52'),
(43, 169, 30, 'Flexible shipping are increasing day by day gradually', 'flexible-shipping-are-increasing-day-by-day-gradually', '1576945722.jpg', 0x[encoded data, 5040 characters], 1, 'technology,tech,app', NULL, 3, '2019-12-21 22:29:07', '2020-02-11 00:09:57'),
(44, 169, 28, 'Survival Strategies to Ensure Business', 'survival-strategies-to-ensure-business', '1576945761.jpg', 0x[encoded data, 5040 characters], 1, 'business,corporate', NULL, 4, '2019-12-21 22:29:50', '2020-02-11 00:09:57'),
(45, 169, 30, 'More than 3k company join this year in tech industry', 'more-than-3k-company-join-this-year-in-tech-industry', '1576945801.jpg', 0x[encoded data, 5040 characters], 1, 'tech industry,technology', NULL, 5, '2019-12-21 22:30:31', '2020-02-11 00:09:57'),
(46, 169, 31, 'Winning Philosophy For The Business', 'Winning-Philosophy-For-The-Business', '1576945846.jpg', 0x[encoded data, 5040 characters], 1, 'business,corporate,agency', NULL, 6, '2019-12-21 22:31:19', '2020-02-13 01:25:41'),
(53, 173, 37, 'أبجد هوز دولور الاعتصام ، النخبة.', 'أبجد-هوز-دولور-الاعتصام-،-النخبة.', '1577899673.jpg', 0x[encoded data, 7996 characters], 1, NULL, NULL, 1, '2020-01-01 23:29:32', '2020-02-11 00:10:54'),
(54, 173, 38, 'استثمر 5000 دولار لتأمين سياستك', 'استثمر-5000-دولار-لتأمين-سياستك', '1577899931.jpg', 0x[encoded data, 7972 characters], 1, NULL, NULL, 2, '2020-01-01 23:32:14', '2020-02-11 00:10:54');
INSERT INTO `blogs` (`id`, `language_id`, `bcategory_id`, `title`, `slug`, `main_image`, `content`, `sidebar`, `meta_keywords`, `meta_description`, `serial_number`, `created_at`, `updated_at`) VALUES
(55, 173, 40, 'الشحن المرن تزداد يوما بعد يوم تدريجيا', 'الشحن-المرن-تزداد-يوما-بعد-يوم-تدريجيا', '1577899957.jpg', 0x[encoded data, 8024 characters], 1, NULL, NULL, 3, '2020-01-01 23:33:11', '2020-02-11 00:10:54'),
(56, 173, 38, 'استراتيجيات البقاء على قيد الحياة لضمان الأعمال', 'استراتيجيات-البقاء-على-قيد-الحياة-لضمان-الأعمال', '1577900021.jpg', 0x[encoded data, 8024 characters], 1, NULL, NULL, 4, '2020-01-01 23:34:11', '2020-02-11 00:10:54'),
(57, 173, 40, 'أكثر من 3 آلاف شركة تنضم هذا العام في صناعة التكنولوجيا', 'أكثر-من-3-آلاف-شركة-تنضم-هذا-العام-في-صناعة-التكنولوجيا', '1577900069.jpg', 0x[encoded data, 8024 characters], 1, NULL, NULL, 5, '2020-01-01 23:34:58', '2020-02-11 00:10:54'),
(58, 173, 41, 'فلسفة الفوز لرجال الأعمال', 'فلسفة-الفوز-لرجال-الأعمال', '1577900128.jpg', 0x[encoded data, 8024 characters], 1, NULL, NULL, 6, '2020-01-01 23:35:55', '2020-02-11 00:10:54');

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

--
-- Table structure for table `budgets`
--

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

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

--
-- Table structure for table `calendar_events`
--

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

--
-- Dumping data for table `calendar_events`
--

INSERT INTO `calendar_events` (`id`, `language_id`, `title`, `start_date`, `end_date`, `created_at`, `updated_at`) VALUES
(11, 169, 'Annual Tour', '03/30/2020 06:00 PM', '04/06/2020 06:50 PM', '2020-03-03 07:39:23', '2020-03-22 09:31:04'),
(12, 169, 'Meeting', '04/15/2020 08:17 AM', '04/15/2020 09:42 PM', '2020-03-03 07:41:12', '2020-03-22 09:29:52'),
(13, NULL, 'Picninc', '04/15/2020 12:00 PM', '04/15/2020 09:00 PM', '2020-03-22 09:32:32', '2020-03-22 09:32:32'),
(14, 169, 'Picnic', '04/22/2020 12:00 PM', '04/22/2020 06:59 PM', '2020-03-22 09:33:45', '2020-03-22 09:34:11'),
(15, 169, 'Covid-19', '03/12/2020 04:00 PM', '03/12/2020 09:59 PM', '2020-03-22 09:35:49', '2020-03-22 09:36:53'),
(16, 169, 'Fifa Tournament', '04/08/2020 12:00 AM', '04/11/2020 11:59 PM', '2020-03-22 09:37:25', '2020-03-22 09:37:25'),
(17, 169, 'Table Tennis Tournament', '01/05/2021 12:00 AM', '02/24/2021 11:59 PM', '2020-03-22 09:38:15', '2021-01-14 05:11:06'),
(24, 173, 'جولة سنوية', '03/30/2020 12:00 AM', '04/06/2020 11:59 PM', '2020-03-22 09:44:11', '2020-03-22 09:44:11'),
(25, 173, 'لقاء', '04/15/2020 04:00 AM', '04/15/2020 09:59 PM', '2020-03-22 09:44:42', '2020-03-22 09:44:42'),
(26, 173, 'النزهة', '04/22/2020 12:00 PM', '04/22/2020 06:59 PM', '2020-03-22 09:45:20', '2020-03-22 09:45:20'),
(27, 173, 'كوفيد -19', '03/12/2020 04:00 AM', '03/12/2020 06:59 PM', '2020-03-22 09:56:10', '2020-03-22 09:56:10'),
(28, 173, 'بطولة الفيفا', '04/08/2020 12:00 AM', '04/11/2020 11:59 PM', '2020-03-22 09:56:32', '2020-03-22 09:56:32'),
(29, 173, 'بطولة تنس الطاولة', '05/13/2020 12:00 AM', '05/18/2020 11:59 PM', '2020-03-22 09:56:55', '2020-03-22 09:56:55');

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

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

CREATE TABLE `conversations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `ticket_id` int(11) DEFAULT NULL,
  `reply` text COLLATE utf8mb4_unicode_ci,
  `file` 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 `conversations`
--

INSERT INTO `conversations` (`id`, `user_id`, `ticket_id`, `reply`, `file`, `created_at`, `updated_at`) VALUES
(32, NULL, 19, '<p>Plese share your server details</p>', '60865a84f1494.zip', '2021-04-26 02:15:32', '2021-04-26 02:15:32'),
(33, 26, 19, '<p>Here it is:</p><p>sdd</p><p>sdhvv</p>', NULL, '2021-04-26 02:16:04', '2021-04-26 02:16:04'),
(34, NULL, 19, '<p>Your issue is solved now.</p><p>Please check</p>', NULL, '2021-04-26 02:16:25', '2021-04-26 02:16:25'),
(35, 26, 19, '<p>Thank you so much</p>', NULL, '2021-04-26 02:16:38', '2021-04-26 02:16:38'),
(36, NULL, 17, '<p>Your issue is solved now.</p><p>Thanks.</p>', NULL, '2021-04-26 02:17:17', '2021-04-26 02:17:17');

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

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

CREATE TABLE `coupons` (
  `id` bigint(20) UNSIGNED 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,
  `value` decimal(11,2) DEFAULT NULL,
  `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 NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `coupons` (`id`, `name`, `code`, `type`, `value`, `start_date`, `end_date`, `minimum_spend`, `created_at`, `updated_at`) VALUES
(4, 'Happy50', 'Happy50', 'percentage', '50.00', '04/12/2021', '12/16/2022', '150.00', '2021-04-23 06:51:54', '2021-04-23 06:51:54');

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

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) NOT NULL,
  `course_category_id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_price` int(11) DEFAULT NULL,
  `previous_price` int(11) DEFAULT NULL,
  `summary` text COLLATE utf8mb4_unicode_ci,
  `course_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `overview` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `instructor_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `instructor_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `instructor_occupation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `instructor_details` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `instructor_facebook` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instructor_instagram` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instructor_twitter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instructor_linkedin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `duration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_featured` tinyint(4) NOT NULL DEFAULT '0',
  `average_rating` double(8,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `courses`
--

INSERT INTO `courses` (`id`, `language_id`, `course_category_id`, `title`, `slug`, `current_price`, `previous_price`, `summary`, `course_image`, `video_link`, `overview`, `instructor_image`, `instructor_name`, `instructor_occupation`, `instructor_details`, `instructor_facebook`, `instructor_instagram`, `instructor_twitter`, `instructor_linkedin`, `created_at`, `updated_at`, `duration`, `is_featured`, `average_rating`) VALUES
(7, 169, 2, '2021 Complete Python Bootcamp From Zero to Hero in Python200', '2021-Complete-Python-Bootcamp-From-Zero-to-Hero-in-Python200', 11, 199, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', '1613816516.jpg', 'https://www.youtube.com/watch?v=MFh0Fd7BsjE', '<p></p><div style=\"margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; text-align: left; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"></div><p></p><div style=\"text-align: justify; line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span></div>', '1613816486.png', 'John Doe', 'Web Developer', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://twitter.com/home', 'https://www.linkedin.com/', '2021-02-19 10:26:51', '2021-04-27 06:12:46', '10h 15m', 1, NULL),
(8, 169, 1, 'The Web Developer Bootcamp 202211', 'The-Web-Developer-Bootcamp-202211', 19, 150, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', '1613818198.jpg', 'https://www.youtube.com/watch?v=MFh0Fd7BsjE', '<p></p><div style=\"margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; text-align: left; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"></div><p></p><div style=\"text-align: justify; line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span></div>', '1613818221.png', 'John Doe', 'Web Developer', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://twitter.com/home', 'https://www.linkedin.com/', '2021-02-19 10:26:51', '2021-04-27 06:12:46', '8h 05m', 1, NULL),
(9, 169, 3, 'An Entire MBA in 1 Course:Award Winning Business School Prof22', 'An-Entire-MBA-in-1-Course:Award-Winning-Business-School-Prof22', 14, 99, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', '1613818312.jpg', 'https://www.youtube.com/watch?v=MFh0Fd7BsjE', '<p></p><div style=\"margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; text-align: left; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"></div><p></p><div style=\"text-align: justify; line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span></div>', '1613818348.png', 'John Doe', 'Entrepreneur', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://twitter.com/home', 'https://www.linkedin.com/', '2021-02-19 10:26:51', '2021-04-27 06:12:46', '5h 55m', 1, NULL),
(10, 169, 2, '2021 Complete Python Bootcamp From Zero to Hero in Python33', '2021-Complete-Python-Bootcamp-From-Zero-to-Hero-in-Python33', 11, 199, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', '1613816516.jpg', 'https://www.youtube.com/watch?v=MFh0Fd7BsjE', '<p><div style=\"margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; text-align: left; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"></div></p><div style=\"text-align: justify; line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span></div>', '1613816486.png', 'John Doe', 'Web Developer', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://twitter.com/home', 'https://www.linkedin.com/', '2021-02-19 10:26:51', '2021-04-27 06:12:46', '10h 15m', 1, 5.00),
(11, 169, 1, 'The Web Developer Bootcamp 202144', 'The-Web-Developer-Bootcamp-202144', 19, 150, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', '1613818198.jpg', 'https://www.youtube.com/watch?v=MFh0Fd7BsjE', '<p></p><div style=\"margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; text-align: left; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"></div><p></p><div style=\"text-align: justify; line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span></div>', '1613818221.png', 'John Doe', 'Web Developer', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://twitter.com/home', 'https://www.linkedin.com/', '2021-02-19 10:26:51', '2021-04-27 06:12:46', '8h 05m', 1, 4.50),
(12, 169, 3, 'An Entire MBA in 1 Course:Award Winning Business School Prof155', 'An-Entire-MBA-in-1-Course:Award-Winning-Business-School-Prof155', 14, 99, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', '1613818312.jpg', 'https://www.youtube.com/watch?v=MFh0Fd7BsjE', '<p></p><div style=\"margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; text-align: left; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"></div><p></p><div style=\"text-align: justify; line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span></div>', '1613818348.png', 'John Doe', 'Entrepreneur', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://twitter.com/home', 'https://www.linkedin.com/', '2021-02-19 10:26:51', '2021-04-27 06:12:46', '5h 55m', 1, 5.00),
(25, 173, 14, '2021 معسكر بايثون الكامل من الصفر إلى البطل في بايثون1818', '2021-معسكر-بايثون-الكامل-من-الصفر-إلى-البطل-في-بايثون1818', 11, 199, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', '1613816516.jpg', 'https://www.youtube.com/watch?v=MFh0Fd7BsjE', '<p><div style=\"margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; text-align: left; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"></div></p><div style=\"text-align: justify; line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span></div>', '1613816486.png', 'John Doe', 'Web Developer', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://twitter.com/home', 'https://www.linkedin.com/', '2021-02-19 10:26:51', '2021-04-27 06:12:46', '10h 15m', 1, NULL),
(26, 173, 13, 'معسكر مطور الويب Bootcamp 20211919', 'معسكر-مطور-الويب-bootcamp-20211919', 19, 150, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', '1613818198.jpg', 'https://www.youtube.com/watch?v=MFh0Fd7BsjE', '<p></p><div style=\"margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; text-align: left; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"></div><p></p><div style=\"text-align: justify; line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span></div>', '1613818221.png', 'John Doe', 'Web Developer', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://twitter.com/home', 'https://www.linkedin.com/', '2021-02-19 10:26:51', '2021-04-27 06:12:46', '8h 05m', 1, NULL),
(27, 173, 15, 'ماجستير إدارة أعمال كامل في دورة واحدة: حائز على جائزة كلية إدارة الأعمال - الأستاذ2020', 'ماجستير-إدارة-أعمال-كامل-في-دورة-واحدة-حائز-على-جائزة-كلية-إدارة-الأعمال-الأستاذ2020', 14, 99, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', '1613818312.jpg', 'https://www.youtube.com/watch?v=MFh0Fd7BsjE', '<p></p><div style=\"margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; text-align: left; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"></div><p></p><div style=\"text-align: justify; line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span></div>', '1613818348.png', 'John Doe', 'Entrepreneur', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://twitter.com/home', 'https://www.linkedin.com/', '2021-02-19 10:26:51', '2021-04-27 06:12:46', '5h 55m', 1, NULL),
(28, 173, 14, '2021 معسكر بايثون الكامل من الصفر إلى البطل في بايثون2121', '2021-معسكر-بايثون-الكامل-من-الصفر-إلى-البطل-في-بايثون2121', 11, 199, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', '1613816516.jpg', 'https://www.youtube.com/watch?v=MFh0Fd7BsjE', '<p><div style=\"margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; text-align: left; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"></div></p><div style=\"text-align: justify; line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span></div>', '1613816486.png', 'John Doe', 'Web Developer', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://twitter.com/home', 'https://www.linkedin.com/', '2021-02-19 10:26:51', '2021-04-27 06:12:46', '10h 15m', 1, NULL),
(29, 173, 13, 'معسكر مطور الويب Bootcamp 20212222', 'معسكر-مطور-الويب-bootcamp-20212222', 19, 150, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', '1613818198.jpg', 'https://www.youtube.com/watch?v=MFh0Fd7BsjE', '<p></p><div style=\"margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; text-align: left; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"></div><p></p><div style=\"text-align: justify; line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span></div>', '1613818221.png', 'John Doe', 'Web Developer', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://twitter.com/home', 'https://www.linkedin.com/', '2021-02-19 10:26:51', '2021-04-27 06:12:46', '8h 05m', 1, NULL),
(30, 173, 15, 'ماجستير إدارة أعمال كامل في دورة واحدة: حائز على جائزة كلية إدارة الأعمال - الأستاذ2323', 'ماجستير-إدارة-أعمال-كامل-في-دورة-واحدة-حائز-على-جائزة-كلية-إدارة-الأعمال-الأستاذ2323', 14, 99, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', '1613818312.jpg', 'https://www.youtube.com/watch?v=MFh0Fd7BsjE', '<p></p><div style=\"margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; text-align: left; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"></div><p></p><div style=\"text-align: justify; line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span></div>', '1613818348.png', 'John Doe', 'Entrepreneur', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://twitter.com/home', 'https://www.linkedin.com/', '2021-02-19 10:26:51', '2021-04-27 06:12:46', '5h 55m', 1, NULL);

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

--
-- Table structure for table `course_categories`
--

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

--
-- Dumping data for table `course_categories`
--

INSERT INTO `course_categories` (`id`, `language_id`, `name`, `status`, `serial_number`, `created_at`, `updated_at`) VALUES
(1, 169, 'IT & Software', 1, 1, '2021-01-29 23:12:34', '2021-02-20 05:14:22'),
(2, 169, 'Development', 1, 2, '2021-01-29 23:12:49', '2021-02-20 05:14:53'),
(3, 169, 'Business', 1, 3, '2021-01-29 23:13:06', '2021-02-20 05:15:12'),
(7, 170, 'TI e software', 1, 1, '2021-01-29 23:12:34', '2021-02-20 05:14:22'),
(8, 170, 'Desenvolvimento', 1, 2, '2021-01-29 23:12:49', '2021-02-20 05:14:53'),
(9, 170, 'O negócio', 1, 3, '2021-01-29 23:13:06', '2021-02-20 05:15:12'),
(10, 171, 'BT ve Yazılım', 1, 1, '2021-01-29 23:12:34', '2021-02-20 05:14:22'),
(11, 171, 'Geliştirme', 1, 2, '2021-01-29 23:12:49', '2021-02-20 05:14:53'),
(12, 171, 'İş', 1, 3, '2021-01-29 23:13:06', '2021-02-20 05:15:12'),
(13, 173, 'تكنولوجيا المعلومات والبرمجيات', 1, 1, '2021-01-29 23:12:34', '2021-02-20 05:14:22'),
(14, 173, 'تطوير', 1, 2, '2021-01-29 23:12:49', '2021-02-20 05:14:53'),
(15, 173, 'اعمال', 1, 3, '2021-01-29 23:13:06', '2021-02-20 05:15:12');

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

--
-- Table structure for table `course_purchases`
--

CREATE TABLE `course_purchases` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `order_number` 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,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `course_id` int(11) DEFAULT NULL,
  `currency_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_price` int(11) DEFAULT NULL,
  `previous_price` int(11) DEFAULT NULL,
  `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `invoice` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `receipt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gateway_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'online'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `course_purchases`
--

INSERT INTO `course_purchases` (`id`, `user_id`, `order_number`, `first_name`, `last_name`, `email`, `course_id`, `currency_code`, `current_price`, `previous_price`, `payment_method`, `payment_status`, `created_at`, `updated_at`, `invoice`, `receipt`, `gateway_type`) VALUES
(40, 26, '2401619416547', 'John', 'Doe', 'user@gmail.com', 7, 'USD', 11, 199, 'mollie', 'Completed', '2021-04-26 01:55:47', '2021-04-26 01:55:58', '2401619416547.pdf', NULL, 'online'),
(41, 26, '4191619416663', 'John', 'Doe', 'user@gmail.com', 9, 'USD', 14, 99, 'paypal', 'Completed', '2021-04-26 01:57:43', '2021-04-26 01:57:48', '4191619416663.pdf', NULL, 'online');

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

--
-- Table structure for table `course_reviews`
--

CREATE TABLE `course_reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `rating` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `donations`
--

CREATE TABLE `donations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `goal_amount` double NOT NULL,
  `min_amount` double NOT NULL,
  `custom_amount` longtext COLLATE utf8mb4_unicode_ci,
  `meta_tags` longtext COLLATE utf8mb4_unicode_ci,
  `meta_description` longtext COLLATE utf8mb4_unicode_ci,
  `image` longtext COLLATE utf8mb4_unicode_ci,
  `lang_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `donations`
--

INSERT INTO `donations` (`id`, `title`, `slug`, `content`, `goal_amount`, `min_amount`, `custom_amount`, `meta_tags`, `meta_description`, `image`, `lang_id`, `created_at`, `updated_at`) VALUES
(11, 'Child Education', 'Contrary-to-popular-belief,-Lorem-Ipsum', '<div style=\"text-align: justify; line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span></div>', 100000, 500, '500,2000,3000', 'mqta1,meta2', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obsc', '1613805616.jpg', 169, '2021-02-03 18:24:38', '2021-02-19 20:32:36'),
(13, 'Medical Equipments', 'Medical-Equipments', '<p style=\"line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span><br></p>', 50000, 50, '50,500,2000', 'meta1,meta2', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s', '1613806543.jpg', 169, '2021-02-19 20:36:45', '2021-02-19 20:36:45'),
(14, 'Foods', 'Foods', '<p style=\"line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span><br></p>', 500000, 50, '50,1000,2000', 'meta1,meta2', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s', '1613806624.jpg', 169, '2021-02-19 20:38:11', '2021-02-19 20:38:11'),
(15, 'Child Education', 'Contrary-to-popular-belief,-Lorem-Ipsum', '<div style=\"text-align: justify; line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span></div>', 100000, 500, '500,2000,3000', 'mqta1,meta2', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obsc', '1613805616.jpg', 169, '2021-02-03 18:24:38', '2021-02-19 20:32:36'),
(16, 'Medical Equipments', 'Medical-Equipments', '<p style=\"line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span><br></p>', 50000, 50, '50,500,2000', 'meta1,meta2', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s', '1613806543.jpg', 169, '2021-02-19 20:36:45', '2021-02-19 20:36:45'),
(17, 'Foods', 'Foods', '<p style=\"line-height: 1.6;\"><span style=\"font-size: 14px;\"><font color=\"#636363\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</font></span><br></p>', 500000, 50, '50,1000,2000', 'meta1,meta2', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s', '1613806624.jpg', 169, '2021-02-19 20:38:11', '2021-02-19 20:38:11'),
(33, 'تربية الطفل', 'تربية-الطفل', 'خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بحث عن أحد أكثر الأماكن غموضًا', 100000, 500, '500,2000,3000', 'mqta1,meta2', 'خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بحث عن أحد أكثر الأماكن غموضًا', '1613805616.jpg', 173, '2021-02-03 18:24:38', '2021-02-19 20:32:36'),
(34, 'معدات طبيه', 'معدات-طبيه', 'خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بحث عن أحد أكثر الأماكن غموضًا', 50000, 50, '50,500,2000', 'meta1,meta2', 'خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بحث عن أحد أكثر الأماكن غموضًا', '1613806543.jpg', 173, '2021-02-19 20:36:45', '2021-02-19 20:36:45'),
(35, 'أغذية', 'أغذية', 'خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بحث عن أحد أكثر الأماكن غموضًا', 500000, 50, '50,1000,2000', 'meta1,meta2', 'خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بحث عن أحد أكثر الأماكن غموضًا', '1613806624.jpg', 173, '2021-02-19 20:38:11', '2021-02-19 20:38:11'),
(36, 'تربية الطفل', 'تربية-الطفل', 'خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بحث عن أحد أكثر الأماكن غموضًا', 100000, 500, '500,2000,3000', 'mqta1,meta2', 'خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بحث عن أحد أكثر الأماكن غموضًا', '1613805616.jpg', 173, '2021-02-03 18:24:38', '2021-02-19 20:32:36'),
(37, 'معدات طبيه', 'معدات-طبيه', 'خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بحث عن أحد أكثر الأماكن غموضًا', 50000, 50, '50,500,2000', 'meta1,meta2', 'خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بحث عن أحد أكثر الأماكن غموضًا', '1613806543.jpg', 173, '2021-02-19 20:36:45', '2021-02-19 20:36:45'),
(38, 'أغذية', 'أغذية', 'خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بحث عن أحد أكثر الأماكن غموضًا', 500000, 50, '50,1000,2000', 'meta1,meta2', 'خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بحث عن أحد أكثر الأماكن غموضًا', '1613806624.jpg', 173, '2021-02-19 20:38:11', '2021-02-19 20:38:11');

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

--
-- Table structure for table `donation_details`
--

CREATE TABLE `donation_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'anonymous',
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'anonymous',
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'xxxxxxxxxxxx',
  `amount` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT 'USD Converted Amount',
  `currency` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'right',
  `currency_symbol` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_symbol_position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'left',
  `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `receipt` longtext COLLATE utf8mb4_unicode_ci,
  `transaction_details` longtext COLLATE utf8mb4_unicode_ci,
  `bex_details` longtext COLLATE utf8mb4_unicode_ci,
  `donation_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `donation_details`
--

INSERT INTO `donation_details` (`id`, `user_id`, `name`, `email`, `phone`, `amount`, `currency`, `currency_position`, `currency_symbol`, `currency_symbol_position`, `payment_method`, `transaction_id`, `status`, `receipt`, `transaction_details`, `bex_details`, `donation_id`, `created_at`, `updated_at`) VALUES
(52, 26, 'John', 'user@gmail.com', '2723724', '2000.00', 'USD', 'right', '$', 'left', 'Mollie Payment', '6083d59b6b990', 'Success', NULL, '{\"resource\":\"payment\",\"id\":\"tr_BqeABc6mSu\",\"mode\":\"test\",\"amount\":{\"value\":\"2000.00\",\"currency\":\"USD\"},\"settlementAmount\":{\"value\":\"1603.68\",\"currency\":\"EUR\"},\"amountRefunded\":{\"value\":\"0.00\",\"currency\":\"USD\"},\"amountRemaining\":{\"value\":\"2000.00\",\"currency\":\"USD\"},\"amountChargedBack\":null,\"description\":\"Making a donation\",\"method\":\"creditcard\",\"status\":\"paid\",\"createdAt\":\"2021-04-24T08:23:47+00:00\",\"paidAt\":\"2021-04-24T08:23:56+00:00\",\"canceledAt\":null,\"expiresAt\":null,\"failedAt\":null,\"dueDate\":null,\"billingEmail\":null,\"profileId\":\"pfl_wWVQgHa2jS\",\"sequenceType\":\"oneoff\",\"redirectUrl\":\"http:\\/\\/localhost\\/plusagency\\/plusagency-3.1\\/cause\\/mollie\\/success\",\"webhookUrl\":null,\"mandateId\":null,\"subscriptionId\":null,\"orderId\":null,\"settlementId\":null,\"locale\":null,\"metadata\":null,\"details\":{\"cardNumber\":\"6787\",\"cardHolder\":\"T. TEST\",\"cardAudience\":\"consumer\",\"cardLabel\":\"Mastercard\",\"cardCountryCode\":\"NL\",\"cardSecurity\":\"normal\",\"feeRegion\":\"other\"},\"restrictPaymentMethodsToCountry\":null,\"_links\":{\"self\":{\"href\":\"https:\\/\\/api.mollie.com\\/v2\\/payments\\/tr_BqeABc6mSu\",\"type\":\"application\\/hal+json\"},\"dashboard\":{\"href\":\"https:\\/\\/www.mollie.com\\/dashboard\\/org_6529881\\/payments\\/tr_BqeABc6mSu\",\"type\":\"text\\/html\"},\"changePaymentState\":{\"href\":\"https:\\/\\/www.mollie.com\\/paymentscreen\\/testmode\\/?method=creditcard&token=2.3xssql\",\"type\":\"text\\/html\"},\"documentation\":{\"href\":\"https:\\/\\/docs.mollie.com\\/reference\\/v2\\/payments-api\\/get-payment\",\"type\":\"text\\/html\"}},\"_embedded\":null,\"isCancelable\":null,\"amountCaptured\":null,\"applicationFee\":null,\"authorizedAt\":null,\"expiredAt\":null,\"customerId\":null,\"countryCode\":\"BD\"}', '{\"id\":1,\"language_id\":169,\"is_shop\":1,\"is_ticket\":1,\"is_user_panel\":1,\"base_currency_symbol\":\"$\",\"base_currency_symbol_position\":\"left\",\"base_currency_text\":\"USD\",\"base_currency_text_position\":\"right\",\"base_currency_rate\":\"1.00\",\"tax\":\"5.00\",\"is_facebook_login\":1,\"facebook_app_id\":\"211657824026859\",\"facebook_app_secret\":\"72e2d5c729f4116ae69b37544efcf588\",\"is_google_login\":1,\"google_client_id\":\"81856165251-i0o8lgjghadindghpk0bnr9qb6hrqo5r.apps.googleusercontent.com\",\"google_client_secret\":\"otutovHmfl4eFj8WZVq0sYNz\",\"product_guest_checkout\":1,\"product_rating_system\":1,\"package_guest_checkout\":0,\"timezone\":\"Europe\\/Andorra\",\"recurring_billing\":1,\"expiration_reminder\":3,\"preloader_status\":0,\"preloader\":\"604da366b8e8e.gif\",\"course_title\":\"Courses\",\"course_subtitle\":\"Choose From Our Amazing Courses\",\"course_details_title\":\"Course Details\",\"is_course\":1,\"knowledgebase_title\":\"Knowledgebase\",\"knowledgebase_subtitle\":\"Find Answers Before Asking\",\"knowledgebase_details_title\":\"Knowledgebase Details\",\"donation_guest_checkout\":1,\"is_donation\":1,\"is_event\":1,\"event_guest_checkout\":1,\"service_category\":1,\"catalog_mode\":0,\"is_course_rating\":1,\"push_notification_icon\":\"605ac7a0f0810.png\",\"contact_addresses\":\"House - 44, Road - 03, Sector - 11, Uttara, Dhaka\\r\\nDhanmondi, Dhaka\\r\\nMohammadpur, Dhaka\",\"contact_numbers\":\"+123 366 892, +991 2336 255, +064 26 622 62\",\"contact_mails\":\"contact@example.com,inquiry@example.com, questions@example.com\",\"latitude\":\"23.8754443686446\",\"longitude\":\"90.39318192382245\",\"map_zoom\":16,\"home_page_pagebuilder\":1,\"custom_page_pagebuilder\":1,\"is_whatsapp\":1,\"whatsapp_number\":\"+12025550147\",\"whatsapp_header_title\":\"Welcome to PlusAgency\",\"whatsapp_popup_message\":\"Admin can also disable WhatsApp Chat\\r\\n& enable Tawk.to chat\\r\\n(Admin can set any message here)\",\"whatsapp_popup\":1,\"client_feedback_title\":\"\",\"client_feedback_subtitle\":\"\",\"faq_category_status\":1,\"gallery_category_status\":1,\"package_category_status\":1}', 11, '2021-04-24 04:23:55', '2021-04-24 04:23:55'),
(53, 26, 'John', 'user@gmail.com', '2723724', '2000.00', 'USD', 'right', '$', 'left', 'Paypal', '6083d5d4c7750', 'Success', NULL, '{\n    \"id\": \"PAYID-MCB5LOA3JE287111D712901G\",\n    \"intent\": \"sale\",\n    \"state\": \"approved\",\n    \"cart\": \"6B693534AL263593X\",\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\": \"2000.00\",\n                \"currency\": \"USD\",\n                \"details\": {\n                    \"subtotal\": \"2000.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\": \"Making a donation Via Paypal\",\n            \"item_list\": {\n                \"items\": [\n                    {\n                        \"name\": \"Making a donation\",\n                        \"price\": \"2000.00\",\n                        \"currency\": \"USD\",\n                        \"tax\": \"0.00\",\n                        \"quantity\": 1\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\": \"94U82531WM0371848\",\n                        \"state\": \"completed\",\n                        \"amount\": {\n                            \"total\": \"2000.00\",\n                            \"currency\": \"USD\",\n                            \"details\": {\n                                \"subtotal\": \"2000.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\": \"58.30\",\n                            \"currency\": \"USD\"\n                        },\n                        \"parent_payment\": \"PAYID-MCB5LOA3JE287111D712901G\",\n                        \"create_time\": \"2021-04-24T08:24:53Z\",\n                        \"update_time\": \"2021-04-24T08:24:53Z\",\n                        \"links\": [\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/sale/94U82531WM0371848\",\n                                \"rel\": \"self\",\n                                \"method\": \"GET\"\n                            },\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/sale/94U82531WM0371848/refund\",\n                                \"rel\": \"refund\",\n                                \"method\": \"POST\"\n                            },\n                            {\n                                \"href\": \"https://api.sandbox.paypal.com/v1/payments/payment/PAYID-MCB5LOA3JE287111D712901G\",\n                                \"rel\": \"parent_payment\",\n                                \"method\": \"GET\"\n                            }\n                        ]\n                    }\n                }\n            ]\n        }\n    ],\n    \"redirect_urls\": {\n        \"return_url\": \"http://localhost/plusagency/plusagency-3.1/cause/paypal/payment/success?paymentId=PAYID-MCB5LOA3JE287111D712901G\",\n        \"cancel_url\": \"http://localhost/plusagency/plusagency-3.1/cause/paypal/payment/cancel\"\n    },\n    \"create_time\": \"2021-04-24T08:24:24Z\",\n    \"update_time\": \"2021-04-24T08:24:53Z\",\n    \"links\": [\n        {\n            \"href\": \"https://api.sandbox.paypal.com/v1/payments/payment/PAYID-MCB5LOA3JE287111D712901G\",\n            \"rel\": \"self\",\n            \"method\": \"GET\"\n        }\n    ],\n    \"failed_transactions\": []\n}', '{\"id\":1,\"language_id\":169,\"is_shop\":1,\"is_ticket\":1,\"is_user_panel\":1,\"base_currency_symbol\":\"$\",\"base_currency_symbol_position\":\"left\",\"base_currency_text\":\"USD\",\"base_currency_text_position\":\"right\",\"base_currency_rate\":\"1.00\",\"tax\":\"5.00\",\"is_facebook_login\":1,\"facebook_app_id\":\"211657824026859\",\"facebook_app_secret\":\"72e2d5c729f4116ae69b37544efcf588\",\"is_google_login\":1,\"google_client_id\":\"81856165251-i0o8lgjghadindghpk0bnr9qb6hrqo5r.apps.googleusercontent.com\",\"google_client_secret\":\"otutovHmfl4eFj8WZVq0sYNz\",\"product_guest_checkout\":1,\"product_rating_system\":1,\"package_guest_checkout\":0,\"timezone\":\"Europe\\/Andorra\",\"recurring_billing\":1,\"expiration_reminder\":3,\"preloader_status\":0,\"preloader\":\"604da366b8e8e.gif\",\"course_title\":\"Courses\",\"course_subtitle\":\"Choose From Our Amazing Courses\",\"course_details_title\":\"Course Details\",\"is_course\":1,\"knowledgebase_title\":\"Knowledgebase\",\"knowledgebase_subtitle\":\"Find Answers Before Asking\",\"knowledgebase_details_title\":\"Knowledgebase Details\",\"donation_guest_checkout\":1,\"is_donation\":1,\"is_event\":1,\"event_guest_checkout\":1,\"service_category\":1,\"catalog_mode\":0,\"is_course_rating\":1,\"push_notification_icon\":\"605ac7a0f0810.png\",\"contact_addresses\":\"House - 44, Road - 03, Sector - 11, Uttara, Dhaka\\r\\nDhanmondi, Dhaka\\r\\nMohammadpur, Dhaka\",\"contact_numbers\":\"+123 366 892, +991 2336 255, +064 26 622 62\",\"contact_mails\":\"contact@example.com,inquiry@example.com, questions@example.com\",\"latitude\":\"23.8754443686446\",\"longitude\":\"90.39318192382245\",\"map_zoom\":16,\"home_page_pagebuilder\":1,\"custom_page_pagebuilder\":1,\"is_whatsapp\":1,\"whatsapp_number\":\"+12025550147\",\"whatsapp_header_title\":\"Welcome to PlusAgency\",\"whatsapp_popup_message\":\"Admin can also disable WhatsApp Chat\\r\\n& enable Tawk.to chat\\r\\n(Admin can set any message here)\",\"whatsapp_popup\":1,\"client_feedback_title\":\"\",\"client_feedback_subtitle\":\"\",\"faq_category_status\":1,\"gallery_category_status\":1,\"package_category_status\":1}', 13, '2021-04-24 04:24:52', '2021-04-24 04:24:52'),
(54, 26, 'John', 'user@gmail.com', '2723724', '50.00', 'USD', 'right', '$', 'left', 'Stripe', '6083d5faa5f86', 'Success', NULL, '{\"id\":\"ch_1IjgnwJlIV5dN9n7EYv7u5FE\",\"object\":\"charge\",\"amount\":5000,\"amount_captured\":5000,\"amount_refunded\":0,\"application\":null,\"application_fee\":null,\"application_fee_amount\":null,\"balance_transaction\":\"txn_1IjgnwJlIV5dN9n7SkYvwVPg\",\"billing_details\":{\"address\":{\"city\":null,\"country\":null,\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":null,\"name\":null,\"phone\":null},\"calculated_statement_descriptor\":\"Stripe\",\"captured\":true,\"created\":1619252732,\"currency\":\"usd\",\"customer\":null,\"description\":\"Your donation make someone day awesome\",\"destination\":null,\"dispute\":null,\"disputed\":false,\"failure_code\":null,\"failure_message\":null,\"fraud_details\":[],\"invoice\":null,\"livemode\":false,\"metadata\":[],\"on_behalf_of\":null,\"order\":null,\"outcome\":{\"network_status\":\"approved_by_network\",\"reason\":null,\"risk_level\":\"normal\",\"risk_score\":8,\"seller_message\":\"Payment complete.\",\"type\":\"authorized\"},\"paid\":true,\"payment_intent\":null,\"payment_method\":\"card_1IjgnvJlIV5dN9n7IszwgqCR\",\"payment_method_details\":{\"card\":{\"brand\":\"visa\",\"checks\":{\"address_line1_check\":null,\"address_postal_code_check\":null,\"cvc_check\":\"pass\"},\"country\":\"US\",\"exp_month\":12,\"exp_year\":2023,\"fingerprint\":\"WXDgVUSzrY61Nnm6\",\"funding\":\"credit\",\"installments\":null,\"last4\":\"4242\",\"network\":\"visa\",\"three_d_secure\":null,\"wallet\":null},\"type\":\"card\"},\"receipt_email\":null,\"receipt_number\":null,\"receipt_url\":\"https:\\/\\/pay.stripe.com\\/receipts\\/acct_1Azeo3JlIV5dN9n7\\/ch_1IjgnwJlIV5dN9n7EYv7u5FE\\/rcpt_JMPdPBUUIzEyJDzeu4sS8a0xwG9X6mX\",\"refunded\":false,\"refunds\":{\"object\":\"list\",\"data\":[],\"has_more\":false,\"total_count\":0,\"url\":\"\\/v1\\/charges\\/ch_1IjgnwJlIV5dN9n7EYv7u5FE\\/refunds\"},\"review\":null,\"shipping\":null,\"source\":{\"id\":\"card_1IjgnvJlIV5dN9n7IszwgqCR\",\"object\":\"card\",\"address_city\":null,\"address_country\":null,\"address_line1\":null,\"address_line1_check\":null,\"address_line2\":null,\"address_state\":null,\"address_zip\":null,\"address_zip_check\":null,\"brand\":\"Visa\",\"country\":\"US\",\"customer\":null,\"cvc_check\":\"pass\",\"dynamic_last4\":null,\"exp_month\":12,\"exp_year\":2023,\"fingerprint\":\"WXDgVUSzrY61Nnm6\",\"funding\":\"credit\",\"last4\":\"4242\",\"metadata\":[],\"name\":null,\"tokenization_method\":null},\"source_transfer\":null,\"statement_descriptor\":null,\"statement_descriptor_suffix\":null,\"status\":\"succeeded\",\"transfer_data\":null,\"transfer_group\":null}', '{\"id\":1,\"language_id\":169,\"is_shop\":1,\"is_ticket\":1,\"is_user_panel\":1,\"base_currency_symbol\":\"$\",\"base_currency_symbol_position\":\"left\",\"base_currency_text\":\"USD\",\"base_currency_text_position\":\"right\",\"base_currency_rate\":\"1.00\",\"tax\":\"5.00\",\"is_facebook_login\":1,\"facebook_app_id\":\"211657824026859\",\"facebook_app_secret\":\"72e2d5c729f4116ae69b37544efcf588\",\"is_google_login\":1,\"google_client_id\":\"81856165251-i0o8lgjghadindghpk0bnr9qb6hrqo5r.apps.googleusercontent.com\",\"google_client_secret\":\"otutovHmfl4eFj8WZVq0sYNz\",\"product_guest_checkout\":1,\"product_rating_system\":1,\"package_guest_checkout\":0,\"timezone\":\"Europe\\/Andorra\",\"recurring_billing\":1,\"expiration_reminder\":3,\"preloader_status\":0,\"preloader\":\"604da366b8e8e.gif\",\"course_title\":\"Courses\",\"course_subtitle\":\"Choose From Our Amazing Courses\",\"course_details_title\":\"Course Details\",\"is_course\":1,\"knowledgebase_title\":\"Knowledgebase\",\"knowledgebase_subtitle\":\"Find Answers Before Asking\",\"knowledgebase_details_title\":\"Knowledgebase Details\",\"donation_guest_checkout\":1,\"is_donation\":1,\"is_event\":1,\"event_guest_checkout\":1,\"service_category\":1,\"catalog_mode\":0,\"is_course_rating\":1,\"push_notification_icon\":\"605ac7a0f0810.png\",\"contact_addresses\":\"House - 44, Road - 03, Sector - 11, Uttara, Dhaka\\r\\nDhanmondi, Dhaka\\r\\nMohammadpur, Dhaka\",\"contact_numbers\":\"+123 366 892, +991 2336 255, +064 26 622 62\",\"contact_mails\":\"contact@example.com,inquiry@example.com, questions@example.com\",\"latitude\":\"23.8754443686446\",\"longitude\":\"90.39318192382245\",\"map_zoom\":16,\"home_page_pagebuilder\":1,\"custom_page_pagebuilder\":1,\"is_whatsapp\":1,\"whatsapp_number\":\"+12025550147\",\"whatsapp_header_title\":\"Welcome to PlusAgency\",\"whatsapp_popup_message\":\"Admin can also disable WhatsApp Chat\\r\\n& enable Tawk.to chat\\r\\n(Admin can set any message here)\",\"whatsapp_popup\":1,\"client_feedback_title\":\"\",\"client_feedback_subtitle\":\"\",\"faq_category_status\":1,\"gallery_category_status\":1,\"package_category_status\":1}', 13, '2021-04-24 04:25:30', '2021-04-24 04:25:30'),
(55, 26, 'John', 'user@gmail.com', '2723724', '500.00', 'USD', 'right', '$', 'left', 'Mollie Payment', '6083d77ca1a2f', 'Success', NULL, '{\"resource\":\"payment\",\"id\":\"tr_52gw3useaj\",\"mode\":\"test\",\"amount\":{\"value\":\"500.00\",\"currency\":\"USD\"},\"settlementAmount\":{\"value\":\"400.92\",\"currency\":\"EUR\"},\"amountRefunded\":{\"value\":\"0.00\",\"currency\":\"USD\"},\"amountRemaining\":{\"value\":\"500.00\",\"currency\":\"USD\"},\"amountChargedBack\":null,\"description\":\"Making a donation\",\"method\":\"creditcard\",\"status\":\"paid\",\"createdAt\":\"2021-04-24T08:31:50+00:00\",\"paidAt\":\"2021-04-24T08:31:57+00:00\",\"canceledAt\":null,\"expiresAt\":null,\"failedAt\":null,\"dueDate\":null,\"billingEmail\":null,\"profileId\":\"pfl_wWVQgHa2jS\",\"sequenceType\":\"oneoff\",\"redirectUrl\":\"http:\\/\\/localhost\\/plusagency\\/plusagency-3.1\\/cause\\/mollie\\/success\",\"webhookUrl\":null,\"mandateId\":null,\"subscriptionId\":null,\"orderId\":null,\"settlementId\":null,\"locale\":null,\"metadata\":null,\"details\":{\"cardNumber\":\"6787\",\"cardHolder\":\"T. TEST\",\"cardAudience\":\"consumer\",\"cardLabel\":\"Mastercard\",\"cardCountryCode\":\"NL\",\"cardSecurity\":\"normal\",\"feeRegion\":\"other\"},\"restrictPaymentMethodsToCountry\":null,\"_links\":{\"self\":{\"href\":\"https:\\/\\/api.mollie.com\\/v2\\/payments\\/tr_52gw3useaj\",\"type\":\"application\\/hal+json\"},\"dashboard\":{\"href\":\"https:\\/\\/www.mollie.com\\/dashboard\\/org_6529881\\/payments\\/tr_52gw3useaj\",\"type\":\"text\\/html\"},\"changePaymentState\":{\"href\":\"https:\\/\\/www.mollie.com\\/paymentscreen\\/testmode\\/?method=creditcard&token=2.z45c6r\",\"type\":\"text\\/html\"},\"documentation\":{\"href\":\"https:\\/\\/docs.mollie.com\\/reference\\/v2\\/payments-api\\/get-payment\",\"type\":\"text\\/html\"}},\"_embedded\":null,\"isCancelable\":null,\"amountCaptured\":null,\"applicationFee\":null,\"authorizedAt\":null,\"expiredAt\":null,\"customerId\":null,\"countryCode\":\"BD\"}', '{\"id\":1,\"language_id\":169,\"is_shop\":1,\"is_ticket\":1,\"is_user_panel\":1,\"base_currency_symbol\":\"$\",\"base_currency_symbol_position\":\"left\",\"base_currency_text\":\"USD\",\"base_currency_text_position\":\"right\",\"base_currency_rate\":\"1.00\",\"tax\":\"5.00\",\"is_facebook_login\":1,\"facebook_app_id\":\"211657824026859\",\"facebook_app_secret\":\"72e2d5c729f4116ae69b37544efcf588\",\"is_google_login\":1,\"google_client_id\":\"81856165251-i0o8lgjghadindghpk0bnr9qb6hrqo5r.apps.googleusercontent.com\",\"google_client_secret\":\"otutovHmfl4eFj8WZVq0sYNz\",\"product_guest_checkout\":1,\"product_rating_system\":1,\"package_guest_checkout\":0,\"timezone\":\"Europe\\/Andorra\",\"recurring_billing\":1,\"expiration_reminder\":3,\"preloader_status\":0,\"preloader\":\"604da366b8e8e.gif\",\"course_title\":\"Courses\",\"course_subtitle\":\"Choose From Our Amazing Courses\",\"course_details_title\":\"Course Details\",\"is_course\":1,\"knowledgebase_title\":\"Knowledgebase\",\"knowledgebase_subtitle\":\"Find Answers Before Asking\",\"knowledgebase_details_title\":\"Knowledgebase Details\",\"donation_guest_checkout\":1,\"is_donation\":1,\"is_event\":1,\"event_guest_checkout\":1,\"service_category\":1,\"catalog_mode\":0,\"is_course_rating\":1,\"push_notification_icon\":\"605ac7a0f0810.png\",\"contact_addresses\":\"House - 44, Road - 03, Sector - 11, Uttara, Dhaka\\r\\nDhanmondi, Dhaka\\r\\nMohammadpur, Dhaka\",\"contact_numbers\":\"+123 366 892, +991 2336 255, +064 26 622 62\",\"contact_mails\":\"contact@example.com,inquiry@example.com, questions@example.com\",\"latitude\":\"23.8754443686446\",\"longitude\":\"90.39318192382245\",\"map_zoom\":16,\"home_page_pagebuilder\":1,\"custom_page_pagebuilder\":1,\"is_whatsapp\":1,\"whatsapp_number\":\"+12025550147\",\"whatsapp_header_title\":\"Welcome to PlusAgency\",\"whatsapp_popup_message\":\"Admin can also disable WhatsApp Chat\\r\\n& enable Tawk.to chat\\r\\n(Admin can set any message here)\",\"whatsapp_popup\":1,\"client_feedback_title\":\"\",\"client_feedback_subtitle\":\"\",\"faq_category_status\":1,\"gallery_category_status\":1,\"package_category_status\":1}', 13, '2021-04-24 04:31:56', '2021-04-24 04:31:56'),
(56, 26, 'anonymous', 'anoymous', 'anoymous', '50.00', 'USD', 'right', '$', 'left', 'Stripe', '6083d82442221', 'Success', NULL, '{\"id\":\"ch_1IjgwrJlIV5dN9n7UHtV7bSo\",\"object\":\"charge\",\"amount\":5000,\"amount_captured\":5000,\"amount_refunded\":0,\"application\":null,\"application_fee\":null,\"application_fee_amount\":null,\"balance_transaction\":\"txn_1IjgwrJlIV5dN9n7dtL04Vpj\",\"billing_details\":{\"address\":{\"city\":null,\"country\":null,\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":null,\"name\":null,\"phone\":null},\"calculated_statement_descriptor\":\"Stripe\",\"captured\":true,\"created\":1619253285,\"currency\":\"usd\",\"customer\":null,\"description\":\"Your donation make someone day awesome\",\"destination\":null,\"dispute\":null,\"disputed\":false,\"failure_code\":null,\"failure_message\":null,\"fraud_details\":[],\"invoice\":null,\"livemode\":false,\"metadata\":[],\"on_behalf_of\":null,\"order\":null,\"outcome\":{\"network_status\":\"approved_by_network\",\"reason\":null,\"risk_level\":\"normal\",\"risk_score\":10,\"seller_message\":\"Payment complete.\",\"type\":\"authorized\"},\"paid\":true,\"payment_intent\":null,\"payment_method\":\"card_1IjgwqJlIV5dN9n7GIqTlSY1\",\"payment_method_details\":{\"card\":{\"brand\":\"visa\",\"checks\":{\"address_line1_check\":null,\"address_postal_code_check\":null,\"cvc_check\":\"pass\"},\"country\":\"US\",\"exp_month\":12,\"exp_year\":2023,\"fingerprint\":\"WXDgVUSzrY61Nnm6\",\"funding\":\"credit\",\"installments\":null,\"last4\":\"4242\",\"network\":\"visa\",\"three_d_secure\":null,\"wallet\":null},\"type\":\"card\"},\"receipt_email\":null,\"receipt_number\":null,\"receipt_url\":\"https:\\/\\/pay.stripe.com\\/receipts\\/acct_1Azeo3JlIV5dN9n7\\/ch_1IjgwrJlIV5dN9n7UHtV7bSo\\/rcpt_JMPmOwznj43j8btiY37xcFSvgV2xSuT\",\"refunded\":false,\"refunds\":{\"object\":\"list\",\"data\":[],\"has_more\":false,\"total_count\":0,\"url\":\"\\/v1\\/charges\\/ch_1IjgwrJlIV5dN9n7UHtV7bSo\\/refunds\"},\"review\":null,\"shipping\":null,\"source\":{\"id\":\"card_1IjgwqJlIV5dN9n7GIqTlSY1\",\"object\":\"card\",\"address_city\":null,\"address_country\":null,\"address_line1\":null,\"address_line1_check\":null,\"address_line2\":null,\"address_state\":null,\"address_zip\":null,\"address_zip_check\":null,\"brand\":\"Visa\",\"country\":\"US\",\"customer\":null,\"cvc_check\":\"pass\",\"dynamic_last4\":null,\"exp_month\":12,\"exp_year\":2023,\"fingerprint\":\"WXDgVUSzrY61Nnm6\",\"funding\":\"credit\",\"last4\":\"4242\",\"metadata\":[],\"name\":null,\"tokenization_method\":null},\"source_transfer\":null,\"statement_descriptor\":null,\"statement_descriptor_suffix\":null,\"status\":\"succeeded\",\"transfer_data\":null,\"transfer_group\":null}', '{\"id\":1,\"language_id\":169,\"is_shop\":1,\"is_ticket\":1,\"is_user_panel\":1,\"base_currency_symbol\":\"$\",\"base_currency_symbol_position\":\"left\",\"base_currency_text\":\"USD\",\"base_currency_text_position\":\"right\",\"base_currency_rate\":\"1.00\",\"tax\":\"5.00\",\"is_facebook_login\":1,\"facebook_app_id\":\"211657824026859\",\"facebook_app_secret\":\"72e2d5c729f4116ae69b37544efcf588\",\"is_google_login\":1,\"google_client_id\":\"81856165251-i0o8lgjghadindghpk0bnr9qb6hrqo5r.apps.googleusercontent.com\",\"google_client_secret\":\"otutovHmfl4eFj8WZVq0sYNz\",\"product_guest_checkout\":1,\"product_rating_system\":1,\"package_guest_checkout\":0,\"timezone\":\"Europe\\/Andorra\",\"recurring_billing\":1,\"expiration_reminder\":3,\"preloader_status\":0,\"preloader\":\"604da366b8e8e.gif\",\"course_title\":\"Courses\",\"course_subtitle\":\"Choose From Our Amazing Courses\",\"course_details_title\":\"Course Details\",\"is_course\":1,\"knowledgebase_title\":\"Knowledgebase\",\"knowledgebase_subtitle\":\"Find Answers Before Asking\",\"knowledgebase_details_title\":\"Knowledgebase Details\",\"donation_guest_checkout\":1,\"is_donation\":1,\"is_event\":1,\"event_guest_checkout\":1,\"service_category\":1,\"catalog_mode\":0,\"is_course_rating\":1,\"push_notification_icon\":\"605ac7a0f0810.png\",\"contact_addresses\":\"House - 44, Road - 03, Sector - 11, Uttara, Dhaka\\r\\nDhanmondi, Dhaka\\r\\nMohammadpur, Dhaka\",\"contact_numbers\":\"+123 366 892, +991 2336 255, +064 26 622 62\",\"contact_mails\":\"contact@example.com,inquiry@example.com, questions@example.com\",\"latitude\":\"23.8754443686446\",\"longitude\":\"90.39318192382245\",\"map_zoom\":16,\"home_page_pagebuilder\":1,\"custom_page_pagebuilder\":1,\"is_whatsapp\":1,\"whatsapp_number\":\"+12025550147\",\"whatsapp_header_title\":\"Welcome to PlusAgency\",\"whatsapp_popup_message\":\"Admin can also disable WhatsApp Chat\\r\\n& enable Tawk.to chat\\r\\n(Admin can set any message here)\",\"whatsapp_popup\":1,\"client_feedback_title\":\"\",\"client_feedback_subtitle\":\"\",\"faq_category_status\":1,\"gallery_category_status\":1,\"package_category_status\":1}', 13, '2021-04-24 04:34:44', '2021-04-24 04:34:44'),
(57, 26, 'John', 'user@gmail.com', '2723724', '50.00', 'USD', 'right', '$', 'left', 'Stripe', '6083d8448d278', 'Success', NULL, '{\"id\":\"ch_1IjgxNJlIV5dN9n7XQGWTgQT\",\"object\":\"charge\",\"amount\":5000,\"amount_captured\":5000,\"amount_refunded\":0,\"application\":null,\"application_fee\":null,\"application_fee_amount\":null,\"balance_transaction\":\"txn_1IjgxOJlIV5dN9n7PF0YFydr\",\"billing_details\":{\"address\":{\"city\":null,\"country\":null,\"line1\":null,\"line2\":null,\"postal_code\":null,\"state\":null},\"email\":null,\"name\":null,\"phone\":null},\"calculated_statement_descriptor\":\"Stripe\",\"captured\":true,\"created\":1619253317,\"currency\":\"usd\",\"customer\":null,\"description\":\"Your donation make someone day awesome\",\"destination\":null,\"dispute\":null,\"disputed\":false,\"failure_code\":null,\"failure_message\":null,\"fraud_details\":[],\"invoice\":null,\"livemode\":false,\"metadata\":[],\"on_behalf_of\":null,\"order\":null,\"outcome\":{\"network_status\":\"approved_by_network\",\"reason\":null,\"risk_level\":\"normal\",\"risk_score\":45,\"seller_message\":\"Payment complete.\",\"type\":\"authorized\"},\"paid\":true,\"payment_intent\":null,\"payment_method\":\"card_1IjgxNJlIV5dN9n7frEaYhnL\",\"payment_method_details\":{\"card\":{\"brand\":\"visa\",\"checks\":{\"address_line1_check\":null,\"address_postal_code_check\":null,\"cvc_check\":\"pass\"},\"country\":\"US\",\"exp_month\":12,\"exp_year\":2023,\"fingerprint\":\"WXDgVUSzrY61Nnm6\",\"funding\":\"credit\",\"installments\":null,\"last4\":\"4242\",\"network\":\"visa\",\"three_d_secure\":null,\"wallet\":null},\"type\":\"card\"},\"receipt_email\":null,\"receipt_number\":null,\"receipt_url\":\"https:\\/\\/pay.stripe.com\\/receipts\\/acct_1Azeo3JlIV5dN9n7\\/ch_1IjgxNJlIV5dN9n7XQGWTgQT\\/rcpt_JMPmEoBe0V9L549tgPB1oIFNnGOzQ04\",\"refunded\":false,\"refunds\":{\"object\":\"list\",\"data\":[],\"has_more\":false,\"total_count\":0,\"url\":\"\\/v1\\/charges\\/ch_1IjgxNJlIV5dN9n7XQGWTgQT\\/refunds\"},\"review\":null,\"shipping\":null,\"source\":{\"id\":\"card_1IjgxNJlIV5dN9n7frEaYhnL\",\"object\":\"card\",\"address_city\":null,\"address_country\":null,\"address_line1\":null,\"address_line1_check\":null,\"address_line2\":null,\"address_state\":null,\"address_zip\":null,\"address_zip_check\":null,\"brand\":\"Visa\",\"country\":\"US\",\"customer\":null,\"cvc_check\":\"pass\",\"dynamic_last4\":null,\"exp_month\":12,\"exp_year\":2023,\"fingerprint\":\"WXDgVUSzrY61Nnm6\",\"funding\":\"credit\",\"last4\":\"4242\",\"metadata\":[],\"name\":null,\"tokenization_method\":null},\"source_transfer\":null,\"statement_descriptor\":null,\"statement_descriptor_suffix\":null,\"status\":\"succeeded\",\"transfer_data\":null,\"transfer_group\":null}', '{\"id\":1,\"language_id\":169,\"is_shop\":1,\"is_ticket\":1,\"is_user_panel\":1,\"base_currency_symbol\":\"$\",\"base_currency_symbol_position\":\"left\",\"base_currency_text\":\"USD\",\"base_currency_text_position\":\"right\",\"base_currency_rate\":\"1.00\",\"tax\":\"5.00\",\"is_facebook_login\":1,\"facebook_app_id\":\"211657824026859\",\"facebook_app_secret\":\"72e2d5c729f4116ae69b37544efcf588\",\"is_google_login\":1,\"google_client_id\":\"81856165251-i0o8lgjghadindghpk0bnr9qb6hrqo5r.apps.googleusercontent.com\",\"google_client_secret\":\"otutovHmfl4eFj8WZVq0sYNz\",\"product_guest_checkout\":1,\"product_rating_system\":1,\"package_guest_checkout\":0,\"timezone\":\"Europe\\/Andorra\",\"recurring_billing\":1,\"expiration_reminder\":3,\"preloader_status\":0,\"preloader\":\"604da366b8e8e.gif\",\"course_title\":\"Courses\",\"course_subtitle\":\"Choose From Our Amazing Courses\",\"course_details_title\":\"Course Details\",\"is_course\":1,\"knowledgebase_title\":\"Knowledgebase\",\"knowledgebase_subtitle\":\"Find Answers Before Asking\",\"knowledgebase_details_title\":\"Knowledgebase Details\",\"donation_guest_checkout\":1,\"is_donation\":1,\"is_event\":1,\"event_guest_checkout\":1,\"service_category\":1,\"catalog_mode\":0,\"is_course_rating\":1,\"push_notification_icon\":\"605ac7a0f0810.png\",\"contact_addresses\":\"House - 44, Road - 03, Sector - 11, Uttara, Dhaka\\r\\nDhanmondi, Dhaka\\r\\nMohammadpur, Dhaka\",\"contact_numbers\":\"+123 366 892, +991 2336 255, +064 26 622 62\",\"contact_mails\":\"contact@example.com,inquiry@example.com, questions@example.com\",\"latitude\":\"23.8754443686446\",\"longitude\":\"90.39318192382245\",\"map_zoom\":16,\"home_page_pagebuilder\":1,\"custom_page_pagebuilder\":1,\"is_whatsapp\":1,\"whatsapp_number\":\"+12025550147\",\"whatsapp_header_title\":\"Welcome to PlusAgency\",\"whatsapp_popup_message\":\"Admin can also disable WhatsApp Chat\\r\\n& enable Tawk.to chat\\r\\n(Admin can set any message here)\",\"whatsapp_popup\":1,\"client_feedback_title\":\"\",\"client_feedback_subtitle\":\"\",\"faq_category_status\":1,\"gallery_category_status\":1,\"package_category_status\":1}', 13, '2021-04-24 04:35:16', '2021-04-24 04:35:16');

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

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

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

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

INSERT INTO `email_templates` (`id`, `email_type`, `email_subject`, `email_body`) VALUES
(1, 'email_verification', 'Verify Your Email', '<p style=\"line-height: 1.6;\">Hello<b> {customer_username}</b>,</p><p style=\"line-height: 1.6;\"><br></p><p style=\"line-height: 1.6;\">Welcome to&nbsp;<span style=\"font-size: medium;\"><b>{website_title}</b>.</span><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>'),
(2, 'product_order', 'Order has been placed', '<p style=\"line-height: 1.6;\">Hello {customer_name},</p><p style=\"line-height: 1.6;\"><br>Your order has been placed successfully. We have attached an invoice in this mail.<br>Order Number: #{order_number}</p><p><br>Please click on the below link to see your order details.<br>{order_link}</p><p><br></p><p>Best Regards,<br>{website_title}</p>'),
(3, 'package_subscription', 'Package Subscription Successful', '<p style=\"line-height: 2;\">Hello {customer_name},</p><p style=\"line-height: 1;\">You have successfully subscribed to <b>{package_name} </b>package.</p><p style=\"line-height: 1;\"><b>Activation Date:</b> {activation_date}</p><p style=\"line-height: 1;\"><b>Expire Date:</b> {expire_date}</p><p style=\"line-height: 2;\">We have also attached an invoice with this email.</p><p style=\"line-height: 1.2;\">Best Regards,</p><p style=\"line-height: 1.2;\">{website_title}</p>'),
(4, 'package_order', 'Package Ordered Successfully', '<p style=\"line-height: 3;\">Hello {customer_name},</p><p style=\"line-height: 1.6;\">You have placed order for {package_name}.&nbsp;<br>Order Number: #{order_number}</p><p>{order_link}</p><p>We have also attached an invoice with this mail.</p><p><br></p><p>Best Regards,<br>{website_title}</p>'),
(5, 'course_enroll', 'Enrolled Course Successfully', '<p style=\"line-height: 1.6;\">Hello {customer_name},</p><p style=\"line-height: 1.6;\"><br>You have enrolled successfully to <b>{course_name}</b> course.<br>Order Number: #{order_number}</p><p><br>Please click on the below link to see your order details.<br>{order_link}</p><p><br></p><p>Best Regards,<br>{website_title}</p>'),
(6, 'donation', 'Donated Successfully', '<p style=\"line-height: 1.6;\">Hello,</p><p style=\"line-height: 1.6;\"><br>You have donated successfully for <b>{cause_name}</b></p><p style=\"line-height: 1.6;\">We have also attached an invoice with this mail.</p><p><br></p><p>Best Regards,<br>{website_title}</p>'),
(7, 'event_ticket', 'Ticket Booked Successfully', '<p style=\"line-height: 1.6;\">Hello {customer_name},</p><p style=\"line-height: 1.6;\"><br>Your order has been placed successfully. We have attached the ticket with this mail.</p><p style=\"line-height: 1.6;\"><b>Event Name: {event_name}</b><br>Ticket ID: #{ticket_id}</p><p><br>Please click on the below link to see your order details.<br>{order_link}</p><p><br></p><p>Best Regards,<br>{website_title}</p>'),
(8, 'subscription_expiry_reminder', 'Your Subscription is about to Expire', '<p>Hello {customer_name},<br><br>Your subscription is about to expire.<br>You have only <strong>{remaining_days} days</strong> remaining.<br>Please extend your current package / change to new one.<br><strong>Current Package:</strong> {current_package_name}<br><strong>Expire Date: </strong>{expire_date}<br><br>Best Regards,</p><p>{website_title}</p>'),
(9, 'subscription_expired', 'Your Subscription is expired', '<p>Hello {customer_name},<br><br>Your subscription is expired<br>Please purchase a package to continue the subscription.</p><p>{packages_link}<br><strong>Expired Package:</strong> {expired_package}<br><strong>Expire Date: </strong>{expire_date}<br><br>Best Regards,</p><p>{website_title}</p>');

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `cost` double NOT NULL,
  `available_tickets` int(11) NOT NULL,
  `organizer` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `organizer_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organizer_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organizer_website` text COLLATE utf8mb4_unicode_ci,
  `venue` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `venue_location` longtext COLLATE utf8mb4_unicode_ci,
  `venue_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_tags` longtext COLLATE utf8mb4_unicode_ci,
  `meta_description` longtext COLLATE utf8mb4_unicode_ci,
  `image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `video` longtext COLLATE utf8mb4_unicode_ci,
  `lang_id` bigint(20) UNSIGNED NOT NULL,
  `cat_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`id`, `title`, `slug`, `content`, `date`, `time`, `cost`, `available_tickets`, `organizer`, `organizer_email`, `organizer_phone`, `organizer_website`, `venue`, `venue_location`, `venue_phone`, `meta_tags`, `meta_description`, `image`, `video`, `lang_id`, `cat_id`, `created_at`, `updated_at`) VALUES
(8, 'The BOPSers 16th Annual Black History Month Event', 'The-BOPSers-16th-Annual-Black-History-Month-Event', '<p style=\"line-height: 1.6;\"><span style=\"font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; text-align: justify;\"><font color=\"#636363\">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</font></span><br></p>', '2024-03-27', '12:15:00', 45, 100000, 'Demo Organizer', 'organize@gmail.com', '236237237', 'http://example.com/', 'California', 'California, USA', '3478348233', 'Event,California', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making', '[\"603098e2edb8e.jpg\",\"603098e32f2a4.jpg\",\"6030a370be32f.jpg\",\"6030a37118b3f.jpg\",\"6030a38abf552.jpg\"]', 'event-601e3309793e5.mp4', 169, 10, '2021-02-05 13:11:46', '2021-02-19 12:58:11'),
(24, 'Virtual Royall House and Slave Quarters Tour: Premiere and Discussion', 'Virtual-Royall-House-and-Slave-Quarters-Tour:-Premiere-and-Discussion', '<p style=\"line-height: 1.6;\"><span style=\"font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; text-align: justify;\"><font color=\"#636363\">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</font></span><br></p>', '2024-03-27', '12:15:00', 40, 100000, 'Demo Organizer', 'organize@gmail.com', '236237237', 'http://example.com/', 'California', 'California, USA', '3478348233', 'Event,California', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making', '[\"603098e32f2a4.jpg\",\"603098e2edb8e.jpg\",\"6030a370be32f.jpg\",\"6030a37118b3f.jpg\",\"6030a38abf552.jpg\"]', 'event-601e3309793e5.mp4', 169, 10, '2021-02-05 13:11:46', '2021-02-19 12:57:16'),
(25, 'Joy & Connection - with Chude Jideonwo', 'Joy-&-Connection---with-Chude-Jideonwo', '<p style=\"line-height: 1.6;\"><span style=\"font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; text-align: justify;\"><font color=\"#636363\">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</font></span><br></p>', '2024-03-27', '12:15:00', 30, 100000, 'Demo Organizer', 'organize@gmail.com', '236237237', 'http://example.com/', 'California', 'California, USA', '3478348233', 'Event,California', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making', '[\"6030a370be32f.jpg\",\"603098e2edb8e.jpg\",\"603098e32f2a4.jpg\",\"6030a37118b3f.jpg\",\"6030a38abf552.jpg\"]', 'event-601e3309793e5.mp4', 169, 9, '2021-02-05 13:11:46', '2021-02-19 12:56:27'),
(26, 'Virtual Event: Los Angeles A Cappella Festival 2021', 'Virtual-Event:-Los-Angeles-A-Cappella-Festival-2021', '<p style=\"line-height: 1.6;\"><span style=\"font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; text-align: justify;\"><font color=\"#636363\">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</font></span><br></p>', '2024-03-27', '12:15:00', 50, 99994, 'Demo Organizer', 'organize@gmail.com', '236237237', 'http://example.com/', 'California', 'California, USA', '3478348233', 'Event,California', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making', '[\"6030a38abf552.jpg\",\"603098e2edb8e.jpg\",\"603098e32f2a4.jpg\",\"6030a370be32f.jpg\",\"6030a37118b3f.jpg\"]', 'event-601e3309793e5.mp4', 169, 7, '2021-02-05 13:11:46', '2021-04-26 01:51:07'),
(31, 'The BOPSers 16th Annual Black History Month Event', 'The-BOPSers-16th-Annual-Black-History-Month-Event', '<p style=\"line-height: 1.6;\"><span style=\"font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; text-align: justify;\"><font color=\"#636363\">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</font></span><br></p>', '2024-03-27', '12:15:00', 45, 99998, 'Demo Organizer', 'organize@gmail.com', '236237237', 'http://example.com/', 'California', 'California, USA', '3478348233', 'Event,California', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making', '[\"603098e2edb8e.jpg\",\"603098e32f2a4.jpg\",\"6030a370be32f.jpg\",\"6030a37118b3f.jpg\",\"6030a38abf552.jpg\"]', 'event-601e3309793e5.mp4', 169, 10, '2021-02-05 13:11:46', '2021-02-19 14:10:25'),
(32, 'Virtual Royall House and Slave Quarters Tour: Premiere and Discussion', 'Virtual-Royall-House-and-Slave-Quarters-Tour:-Premiere-and-Discussion', '<p style=\"line-height: 1.6;\"><span style=\"font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; text-align: justify;\"><font color=\"#636363\">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</font></span><br></p>', '2024-03-27', '12:15:00', 40, 100000, 'Demo Organizer', 'organize@gmail.com', '236237237', 'http://example.com/', 'California', 'California, USA', '3478348233', 'Event,California', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making', '[\"603098e32f2a4.jpg\",\"603098e2edb8e.jpg\",\"6030a370be32f.jpg\",\"6030a37118b3f.jpg\",\"6030a38abf552.jpg\"]', 'event-601e3309793e5.mp4', 169, 10, '2021-02-05 13:11:46', '2021-02-19 12:57:16'),
(33, 'Joy & Connection - with Chude Jideonwo', 'Joy-&-Connection---with-Chude-Jideonwo', '<p style=\"line-height: 1.6;\"><span style=\"font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; text-align: justify;\"><font color=\"#636363\">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</font></span><br></p>', '2024-03-27', '12:15:00', 30, 99994, 'Demo Organizer', 'organize@gmail.com', '236237237', 'http://example.com/', 'California', 'California, USA', '3478348233', 'Event,California', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making', '[\"6030a370be32f.jpg\",\"603098e2edb8e.jpg\",\"603098e32f2a4.jpg\",\"6030a37118b3f.jpg\",\"6030a38abf552.jpg\"]', 'event-601e3309793e5.mp4', 169, 9, '2021-02-05 13:11:46', '2021-02-19 14:09:42'),
(34, 'Virtual Event: Los Angeles A Cappella Festival 2021', 'Virtual-Event:-Los-Angeles-A-Cappella-Festival-2021', '<p style=\"line-height: 1.6;\"><span style=\"font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; text-align: justify;\"><font color=\"#636363\">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</font></span><br></p>', '2024-03-27', '12:15:00', 50, 99998, 'Demo Organizer', 'organize@gmail.com', '236237237', 'http://example.com/', 'California', 'California, USA', '3478348233', 'Event,California', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making', '[\"6030a38abf552.jpg\",\"603098e2edb8e.jpg\",\"603098e32f2a4.jpg\",\"6030a370be32f.jpg\",\"6030a37118b3f.jpg\"]', 'event-601e3309793e5.mp4', 169, 7, '2021-02-05 13:11:46', '2021-03-21 00:12:52'),
(51, 'حدث BOPSers السنوي السادس عشر لشهر التاريخ الأسود', 'حدث-bopsers-السنوي-السادس-عشر-لشهر-التاريخ-الأسود', '<p style = \"line-height: 1.6؛\"> <span style = \"font-family: & quot؛ Open Sans & quot ؛، Arial، sans-serif؛ font-size: 14px؛ text-align: justify؛\"> <font color = \"# 636363\"> خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. قام ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بالبحث عن واحدة من أكثر الكلمات اللاتينية غموضًا ، consectetur ، من مقطع لوريم إيبسوم ، وتصفح اقتباسات الكلمة في الأدب الكلاسيكي ، اكتشف المصدر الذي لا شك فيه. يأتي لوريم إيبسوم من القسمين 1.10.32 و 1.10.33 من \"de Finibus Bonorum et Malorum\" (أقصى الخير والشر) بقلم شيشرون ، وكُتب عام 45 قبل الميلاد. هذا الكتاب عبارة عن أطروحة حول نظرية الأخلاق ، وقد حظيت بشعبية كبيرة خلال عصر النهضة. السطر الأول من Lorem Ipsum ، \"Lorem ipsum dolor sit amet ..\" ، يأتي من سطر في القسم 1.10.32. </font> </span> <br> </p>', '2024-03-27', '12:15:00', 45, 100000, 'Demo Organizer', 'organize@gmail.com', '236237237', 'http://example.com/', 'California', 'California, USA', '3478348233', 'Event,California', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making', '[\"603098e2edb8e.jpg\",\"603098e32f2a4.jpg\",\"6030a370be32f.jpg\",\"6030a37118b3f.jpg\",\"6030a38abf552.jpg\"]', 'event-601e3309793e5.mp4', 173, 19, '2021-02-05 13:11:46', '2021-02-19 12:58:11'),
(52, 'جولة في Virtual Royall House و Slave Quarters: العرض الأول والمناقش', 'جولة-في-virtual-royall-house-و-slave-quarters-العرض-الأول-والمناقش', '<p style = \"line-height: 1.6؛\"> <span style = \"font-family: & quot؛ Open Sans & quot ؛، Arial، sans-serif؛ font-size: 14px؛ text-align: justify؛\"> <font color = \"# 636363\"> خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. قام ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بالبحث عن واحدة من أكثر الكلمات اللاتينية غموضًا ، consectetur ، من مقطع لوريم إيبسوم ، وتصفح اقتباسات الكلمة في الأدب الكلاسيكي ، اكتشف المصدر الذي لا شك فيه. يأتي لوريم إيبسوم من القسمين 1.10.32 و 1.10.33 من \"de Finibus Bonorum et Malorum\" (أقصى الخير والشر) بقلم شيشرون ، وكُتب عام 45 قبل الميلاد. هذا الكتاب عبارة عن أطروحة حول نظرية الأخلاق ، وقد حظيت بشعبية كبيرة خلال عصر النهضة. السطر الأول من Lorem Ipsum ، \"Lorem ipsum dolor sit amet ..\" ، يأتي من سطر في القسم 1.10.32. </font> </span> <br> </p>', '2024-03-27', '12:15:00', 40, 100000, 'Demo Organizer', 'organize@gmail.com', '236237237', 'http://example.com/', 'California', 'California, USA', '3478348233', 'Event,California', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making', '[\"603098e32f2a4.jpg\",\"603098e2edb8e.jpg\",\"6030a370be32f.jpg\",\"6030a37118b3f.jpg\",\"6030a38abf552.jpg\"]', 'event-601e3309793e5.mp4', 173, 19, '2021-02-05 13:11:46', '2021-02-19 12:57:16'),
(53, 'الفرح والاتصال - مع Chude Jideonwo', 'الفرح-والاتصال-مع-chude-jideonwo', '<p style = \"line-height: 1.6؛\"> <span style = \"font-family: & quot؛ Open Sans & quot ؛، Arial، sans-serif؛ font-size: 14px؛ text-align: justify؛\"> <font color = \"# 636363\"> خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. قام ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بالبحث عن واحدة من أكثر الكلمات اللاتينية غموضًا ، consectetur ، من مقطع لوريم إيبسوم ، وتصفح اقتباسات الكلمة في الأدب الكلاسيكي ، اكتشف المصدر الذي لا شك فيه. يأتي لوريم إيبسوم من القسمين 1.10.32 و 1.10.33 من \"de Finibus Bonorum et Malorum\" (أقصى الخير والشر) بقلم شيشرون ، وكُتب عام 45 قبل الميلاد. هذا الكتاب عبارة عن أطروحة حول نظرية الأخلاق ، وقد حظيت بشعبية كبيرة خلال عصر النهضة. السطر الأول من Lorem Ipsum ، \"Lorem ipsum dolor sit amet ..\" ، يأتي من سطر في القسم 1.10.32. </font> </span> <br> </p>', '2024-03-27', '12:15:00', 30, 100000, 'Demo Organizer', 'organize@gmail.com', '236237237', 'http://example.com/', 'California', 'California, USA', '3478348233', 'Event,California', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making', '[\"6030a370be32f.jpg\",\"603098e2edb8e.jpg\",\"603098e32f2a4.jpg\",\"6030a37118b3f.jpg\",\"6030a38abf552.jpg\"]', 'event-601e3309793e5.mp4', 173, 18, '2021-02-05 13:11:46', '2021-02-19 12:56:27'),
(54, 'حدث افتراضي: مهرجان لوس أنجلوس A Cappella 2021', 'حدث-افتراضي-مهرجان-لوس-أنجلوس-a-cappella-2021', '<p style = \"line-height: 1.6؛\"> <span style = \"font-family: & quot؛ Open Sans & quot ؛، Arial، sans-serif؛ font-size: 14px؛ text-align: justify؛\"> <font color = \"# 636363\"> خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. قام ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بالبحث عن واحدة من أكثر الكلمات اللاتينية غموضًا ، consectetur ، من مقطع لوريم إيبسوم ، وتصفح اقتباسات الكلمة في الأدب الكلاسيكي ، اكتشف المصدر الذي لا شك فيه. يأتي لوريم إيبسوم من القسمين 1.10.32 و 1.10.33 من \"de Finibus Bonorum et Malorum\" (أقصى الخير والشر) بقلم شيشرون ، وكُتب عام 45 قبل الميلاد. هذا الكتاب عبارة عن أطروحة حول نظرية الأخلاق ، وقد حظيت بشعبية كبيرة خلال عصر النهضة. السطر الأول من Lorem Ipsum ، \"Lorem ipsum dolor sit amet ..\" ، يأتي من سطر في القسم 1.10.32. </font> </span> <br> </p>', '2024-03-27', '12:15:00', 50, 100000, 'Demo Organizer', 'organize@gmail.com', '236237237', 'http://example.com/', 'California', 'California, USA', '3478348233', 'Event,California', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making', '[\"6030a38abf552.jpg\",\"603098e2edb8e.jpg\",\"603098e32f2a4.jpg\",\"6030a370be32f.jpg\",\"6030a37118b3f.jpg\"]', 'event-601e3309793e5.mp4', 173, 17, '2021-02-05 13:11:46', '2021-02-19 12:52:13'),
(55, 'حدث BOPSers السنوي السادس عشر لشهر التاريخ الأسود', 'حدث-bopsers-السنوي-السادس-عشر-لشهر-التاريخ-الأسود', '<p style = \"line-height: 1.6؛\"> <span style = \"font-family: & quot؛ Open Sans & quot ؛، Arial، sans-serif؛ font-size: 14px؛ text-align: justify؛\"> <font color = \"# 636363\"> خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. قام ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بالبحث عن واحدة من أكثر الكلمات اللاتينية غموضًا ، consectetur ، من مقطع لوريم إيبسوم ، وتصفح اقتباسات الكلمة في الأدب الكلاسيكي ، اكتشف المصدر الذي لا شك فيه. يأتي لوريم إيبسوم من القسمين 1.10.32 و 1.10.33 من \"de Finibus Bonorum et Malorum\" (أقصى الخير والشر) بقلم شيشرون ، وكُتب عام 45 قبل الميلاد. هذا الكتاب عبارة عن أطروحة حول نظرية الأخلاق ، وقد حظيت بشعبية كبيرة خلال عصر النهضة. السطر الأول من Lorem Ipsum ، \"Lorem ipsum dolor sit amet ..\" ، يأتي من سطر في القسم 1.10.32. </font> </span> <br> </p>', '2024-03-27', '12:15:00', 45, 100000, 'Demo Organizer', 'organize@gmail.com', '236237237', 'http://example.com/', 'California', 'California, USA', '3478348233', 'Event,California', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making', '[\"603098e2edb8e.jpg\",\"603098e32f2a4.jpg\",\"6030a370be32f.jpg\",\"6030a37118b3f.jpg\",\"6030a38abf552.jpg\"]', 'event-601e3309793e5.mp4', 173, 19, '2021-02-05 13:11:46', '2021-02-19 12:58:11'),
(56, 'جولة في Virtual Royall House و Slave Quarters: العرض الأول والمناقش', 'جولة-في-virtual-royall-house-و-slave-quarters-العرض-الأول-والمناقش', '<p style = \"line-height: 1.6؛\"> <span style = \"font-family: & quot؛ Open Sans & quot ؛، Arial، sans-serif؛ font-size: 14px؛ text-align: justify؛\"> <font color = \"# 636363\"> خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. قام ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بالبحث عن واحدة من أكثر الكلمات اللاتينية غموضًا ، consectetur ، من مقطع لوريم إيبسوم ، وتصفح اقتباسات الكلمة في الأدب الكلاسيكي ، اكتشف المصدر الذي لا شك فيه. يأتي لوريم إيبسوم من القسمين 1.10.32 و 1.10.33 من \"de Finibus Bonorum et Malorum\" (أقصى الخير والشر) بقلم شيشرون ، وكُتب عام 45 قبل الميلاد. هذا الكتاب عبارة عن أطروحة حول نظرية الأخلاق ، وقد حظيت بشعبية كبيرة خلال عصر النهضة. السطر الأول من Lorem Ipsum ، \"Lorem ipsum dolor sit amet ..\" ، يأتي من سطر في القسم 1.10.32. </font> </span> <br> </p>', '2024-03-27', '12:15:00', 40, 100000, 'Demo Organizer', 'organize@gmail.com', '236237237', 'http://example.com/', 'California', 'California, USA', '3478348233', 'Event,California', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making', '[\"603098e32f2a4.jpg\",\"603098e2edb8e.jpg\",\"6030a370be32f.jpg\",\"6030a37118b3f.jpg\",\"6030a38abf552.jpg\"]', 'event-601e3309793e5.mp4', 173, 19, '2021-02-05 13:11:46', '2021-02-19 12:57:16'),
(57, 'الفرح والاتصال - مع Chude Jideonwo', 'الفرح-والاتصال-مع-chude-jideonwo', '<p style = \"line-height: 1.6؛\"> <span style = \"font-family: & quot؛ Open Sans & quot ؛، Arial، sans-serif؛ font-size: 14px؛ text-align: justify؛\"> <font color = \"# 636363\"> خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. قام ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بالبحث عن واحدة من أكثر الكلمات اللاتينية غموضًا ، consectetur ، من مقطع لوريم إيبسوم ، وتصفح اقتباسات الكلمة في الأدب الكلاسيكي ، اكتشف المصدر الذي لا شك فيه. يأتي لوريم إيبسوم من القسمين 1.10.32 و 1.10.33 من \"de Finibus Bonorum et Malorum\" (أقصى الخير والشر) بقلم شيشرون ، وكُتب عام 45 قبل الميلاد. هذا الكتاب عبارة عن أطروحة حول نظرية الأخلاق ، وقد حظيت بشعبية كبيرة خلال عصر النهضة. السطر الأول من Lorem Ipsum ، \"Lorem ipsum dolor sit amet ..\" ، يأتي من سطر في القسم 1.10.32. </font> </span> <br> </p>', '2024-03-27', '12:15:00', 30, 100000, 'Demo Organizer', 'organize@gmail.com', '236237237', 'http://example.com/', 'California', 'California, USA', '3478348233', 'Event,California', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making', '[\"6030a370be32f.jpg\",\"603098e2edb8e.jpg\",\"603098e32f2a4.jpg\",\"6030a37118b3f.jpg\",\"6030a38abf552.jpg\"]', 'event-601e3309793e5.mp4', 173, 18, '2021-02-05 13:11:46', '2021-02-19 12:56:27'),
(58, 'حدث افتراضي: مهرجان لوس أنجلوس A Cappella 2021', 'حدث-افتراضي-مهرجان-لوس-أنجلوس-a-cappella-2021', '<p style = \"line-height: 1.6؛\"> <span style = \"font-family: & quot؛ Open Sans & quot ؛، Arial، sans-serif؛ font-size: 14px؛ text-align: justify؛\"> <font color = \"# 636363\"> خلافًا للاعتقاد الشائع ، فإن Lorem Ipsum ليس مجرد نص عشوائي. لها جذور في قطعة من الأدب اللاتيني الكلاسيكي من 45 قبل الميلاد ، مما يجعلها أكثر من 2000 عام. قام ريتشارد مكلينتوك ، أستاذ اللغة اللاتينية في كلية هامبدن سيدني في فيرجينيا ، بالبحث عن واحدة من أكثر الكلمات اللاتينية غموضًا ، consectetur ، من مقطع لوريم إيبسوم ، وتصفح اقتباسات الكلمة في الأدب الكلاسيكي ، اكتشف المصدر الذي لا شك فيه. يأتي لوريم إيبسوم من القسمين 1.10.32 و 1.10.33 من \"de Finibus Bonorum et Malorum\" (أقصى الخير والشر) بقلم شيشرون ، وكُتب عام 45 قبل الميلاد. هذا الكتاب عبارة عن أطروحة حول نظرية الأخلاق ، وقد حظيت بشعبية كبيرة خلال عصر النهضة. السطر الأول من Lorem Ipsum ، \"Lorem ipsum dolor sit amet ..\" ، يأتي من سطر في القسم 1.10.32. </font> </span> <br> </p>', '2024-03-27', '12:15:00', 50, 100000, 'Demo Organizer', 'organize@gmail.com', '236237237', 'http://example.com/', 'California', 'California, USA', '3478348233', 'Event,California', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making', '[\"6030a38abf552.jpg\",\"603098e2edb8e.jpg\",\"603098e32f2a4.jpg\",\"6030a370be32f.jpg\",\"6030a37118b3f.jpg\"]', 'event-601e3309793e5.mp4', 173, 17, '2021-02-05 13:11:46', '2021-02-19 12:52:13'),
(61, 'Joy & Connection - with Chude Jideonwou', 'Joy-&-Connection---with-Chude-Jideonwou', '<p>zdmd</p>', '2021-03-13', '21:59:00', 33, 18, 'Organizer Name', NULL, NULL, NULL, 'California', NULL, NULL, NULL, NULL, '[\"605d70e69e0f0.jpg\",\"605d70e6a4e25.jpg\",\"605d70e6a8875.jpg\"]', 'http://localhost/plusagency/plusagency-3.1/core/storage/app/public/files/shares/videos/Earth.mp4', 169, 9, '2021-03-16 09:55:38', '2021-04-16 05:09:35');

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

--
-- Table structure for table `event_categories`
--

CREATE TABLE `event_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `lang_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_categories`
--

INSERT INTO `event_categories` (`id`, `name`, `slug`, `status`, `lang_id`, `created_at`, `updated_at`) VALUES
(7, 'Concert', 'Concert', '1', 169, '2021-02-05 16:57:35', '2021-02-19 19:09:21'),
(9, 'Conference', 'Conference', '1', 169, '2021-02-05 19:10:56', '2021-02-05 19:10:56'),
(10, 'Seminar', 'Seminar', '1', 169, '2021-02-19 18:31:24', '2021-02-19 18:31:24'),
(17, 'حفلة موسيقية', 'حفلة-موسيقية', '1', 173, '2021-02-05 16:57:35', '2021-02-19 19:09:21'),
(18, 'مؤتمر', 'مؤتمر', '1', 173, '2021-02-05 19:10:56', '2021-02-05 19:10:56'),
(19, 'ندوة', 'ندوة', '1', 173, '2021-02-19 18:31:24', '2021-02-19 18:31:24');

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

--
-- Table structure for table `event_details`
--

CREATE TABLE `event_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'anonymous',
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'anonymous',
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'xxxxxxxxxxxx',
  `amount` double NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `currency` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_symbol` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `receipt` longtext COLLATE utf8mb4_unicode_ci,
  `invoice` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_details` longtext COLLATE utf8mb4_unicode_ci,
  `bex_details` longtext COLLATE utf8mb4_unicode_ci,
  `event_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_details`
--

INSERT INTO `event_details` (`id`, `user_id`, `name`, `email`, `phone`, `amount`, `quantity`, `currency`, `currency_symbol`, `payment_method`, `transaction_id`, `status`, `receipt`, `invoice`, `transaction_details`, `bex_details`, `event_id`, `created_at`, `updated_at`) VALUES
(58, 26, 'Tom', 'user@gmail.com', '47347348', 100, 2, 'USD', '$', 'Mollie Payment', '607d4dc0b3196', 'Success', NULL, 'Event#607d4dc0b3196.pdf', '{\"resource\":\"payment\",\"id\":\"tr_8JTkNPjg9g\",\"mode\":\"test\",\"amount\":{\"value\":\"100.00\",\"currency\":\"USD\"},\"settlementAmount\":{\"value\":\"80.68\",\"currency\":\"EUR\"},\"amountRefunded\":{\"value\":\"0.00\",\"currency\":\"USD\"},\"amountRemaining\":{\"value\":\"100.00\",\"currency\":\"USD\"},\"amountChargedBack\":null,\"description\":\"You are purchasing an event ticket\",\"method\":\"creditcard\",\"status\":\"paid\",\"createdAt\":\"2021-04-19T09:30:31+00:00\",\"paidAt\":\"2021-04-19T09:30:39+00:00\",\"canceledAt\":null,\"expiresAt\":null,\"failedAt\":null,\"dueDate\":null,\"billingEmail\":null,\"profileId\":\"pfl_wWVQgHa2jS\",\"sequenceType\":\"oneoff\",\"redirectUrl\":\"http:\\/\\/localhost\\/plusagency\\/plusagency-3.1\\/cause\\/mollie\\/success\",\"webhookUrl\":null,\"mandateId\":null,\"subscriptionId\":null,\"orderId\":null,\"settlementId\":null,\"locale\":null,\"metadata\":null,\"details\":{\"cardNumber\":\"6787\",\"cardHolder\":\"T. TEST\",\"cardAudience\":\"consumer\",\"cardLabel\":\"Mastercard\",\"cardCountryCode\":\"NL\",\"cardSecurity\":\"normal\",\"feeRegion\":\"other\"},\"restrictPaymentMethodsToCountry\":null,\"_links\":{\"self\":{\"href\":\"https:\\/\\/api.mollie.com\\/v2\\/payments\\/tr_8JTkNPjg9g\",\"type\":\"application\\/hal+json\"},\"dashboard\":{\"href\":\"https:\\/\\/www.mollie.com\\/dashboard\\/org_6529881\\/payments\\/tr_8JTkNPjg9g\",\"type\":\"text\\/html\"},\"changePaymentState\":{\"href\":\"https:\\/\\/www.mollie.com\\/paymentscreen\\/testmode\\/?method=creditcard&token=2.ldmfs4\",\"type\":\"text\\/html\"},\"documentation\":{\"href\":\"https:\\/\\/docs.mollie.com\\/reference\\/v2\\/payments-api\\/get-payment\",\"type\":\"text\\/html\"}},\"_embedded\":null,\"isCancelable\":null,\"amountCaptured\":null,\"applicationFee\":null,\"authorizedAt\":null,\"expiredAt\":null,\"customerId\":null,\"countryCode\":\"BD\"}', '{\"id\":1,\"language_id\":169,\"is_shop\":1,\"is_ticket\":1,\"is_user_panel\":1,\"base_currency_symbol\":\"$\",\"base_currency_symbol_position\":\"left\",\"base_currency_text\":\"USD\",\"base_currency_text_position\":\"right\",\"base_currency_rate\":\"1.00\",\"tax\":\"5.00\",\"is_facebook_login\":1,\"facebook_app_id\":\"211657824026859\",\"facebook_app_secret\":\"72e2d5c729f4116ae69b37544efcf588\",\"is_google_login\":1,\"google_client_id\":\"81856165251-i0o8lgjghadindghpk0bnr9qb6hrqo5r.apps.googleusercontent.com\",\"google_client_secret\":\"otutovHmfl4eFj8WZVq0sYNz\",\"product_guest_checkout\":1,\"product_rating_system\":1,\"package_guest_checkout\":0,\"timezone\":\"Europe\\/Andorra\",\"recurring_billing\":1,\"expiration_reminder\":3,\"preloader_status\":0,\"preloader\":\"604da366b8e8e.gif\",\"course_title\":\"Courses\",\"course_subtitle\":\"Choose From Our Amazing Courses\",\"course_details_title\":\"Course Details\",\"is_course\":1,\"knowledgebase_title\":\"Knowledgebase\",\"knowledgebase_subtitle\":\"Find Answers Before Asking\",\"knowledgebase_details_title\":\"Knowledgebase Details\",\"donation_guest_checkout\":1,\"is_donation\":1,\"is_event\":1,\"event_guest_checkout\":1,\"service_category\":1,\"catalog_mode\":0,\"is_course_rating\":1,\"push_notification_icon\":\"605ac7a0f0810.png\",\"contact_addresses\":\"House - 44, Road - 03, Sector - 11, Uttara, Dhaka\\r\\nDhanmondi, Dhaka\\r\\nMohammadpur, Dhaka\",\"contact_numbers\":\"+123 366 892, +991 2336 255, +064 26 622 62\",\"contact_mails\":\"contact@example.com,inquiry@example.com, questions@example.com\",\"latitude\":\"23.8754443686446\",\"longitude\":\"90.39318192382245\",\"map_zoom\":16,\"home_page_pagebuilder\":0,\"custom_page_pagebuilder\":1,\"is_whatsapp\":1,\"whatsapp_number\":\"+12025550147\",\"whatsapp_header_title\":\"Welcome to PlusAgency\",\"whatsapp_popup_message\":\"Admin can also disable WhatsApp Chat\\r\\n& enable Tawk.to chat\\r\\n(Admin can set any message here)\",\"whatsapp_popup\":1}', 26, '2021-04-19 05:30:40', '2021-04-19 05:30:40'),
(59, 26, 'John', 'user@gmail.com', '2723724', 100, 2, 'USD', '$', 'Mollie Payment', '608654cbec3eb', 'Success', NULL, 'Event#608654cbec3eb.pdf', '{\"resource\":\"payment\",\"id\":\"tr_uWMaxVzADK\",\"mode\":\"test\",\"amount\":{\"value\":\"100.00\",\"currency\":\"USD\"},\"settlementAmount\":{\"value\":\"80.11\",\"currency\":\"EUR\"},\"amountRefunded\":{\"value\":\"0.00\",\"currency\":\"USD\"},\"amountRemaining\":{\"value\":\"100.00\",\"currency\":\"USD\"},\"amountChargedBack\":null,\"description\":\"You are purchasing an event ticket\",\"method\":\"creditcard\",\"status\":\"paid\",\"createdAt\":\"2021-04-26T05:50:42+00:00\",\"paidAt\":\"2021-04-26T05:51:06+00:00\",\"canceledAt\":null,\"expiresAt\":null,\"failedAt\":null,\"dueDate\":null,\"billingEmail\":null,\"profileId\":\"pfl_wWVQgHa2jS\",\"sequenceType\":\"oneoff\",\"redirectUrl\":\"http:\\/\\/localhost\\/plusagency\\/plusagency-3.1\\/cause\\/mollie\\/success\",\"webhookUrl\":null,\"mandateId\":null,\"subscriptionId\":null,\"orderId\":null,\"settlementId\":null,\"locale\":null,\"metadata\":null,\"details\":{\"cardNumber\":\"6787\",\"cardHolder\":\"T. TEST\",\"cardAudience\":\"consumer\",\"cardLabel\":\"Mastercard\",\"cardCountryCode\":\"NL\",\"cardSecurity\":\"normal\",\"feeRegion\":\"other\"},\"restrictPaymentMethodsToCountry\":null,\"_links\":{\"self\":{\"href\":\"https:\\/\\/api.mollie.com\\/v2\\/payments\\/tr_uWMaxVzADK\",\"type\":\"application\\/hal+json\"},\"dashboard\":{\"href\":\"https:\\/\\/www.mollie.com\\/dashboard\\/org_6529881\\/payments\\/tr_uWMaxVzADK\",\"type\":\"text\\/html\"},\"changePaymentState\":{\"href\":\"https:\\/\\/www.mollie.com\\/paymentscreen\\/testmode\\/?method=creditcard&token=2.jbt2w1\",\"type\":\"text\\/html\"},\"documentation\":{\"href\":\"https:\\/\\/docs.mollie.com\\/reference\\/v2\\/payments-api\\/get-payment\",\"type\":\"text\\/html\"}},\"_embedded\":null,\"isCancelable\":null,\"amountCaptured\":null,\"applicationFee\":null,\"authorizedAt\":null,\"expiredAt\":null,\"customerId\":null,\"countryCode\":\"BD\"}', '{\"id\":1,\"language_id\":169,\"is_shop\":1,\"is_ticket\":1,\"is_user_panel\":1,\"base_currency_symbol\":\"$\",\"base_currency_symbol_position\":\"left\",\"base_currency_text\":\"USD\",\"base_currency_text_position\":\"right\",\"base_currency_rate\":\"1.00\",\"tax\":\"5.00\",\"is_facebook_login\":1,\"facebook_app_id\":\"211657824026859\",\"facebook_app_secret\":\"72e2d5c729f4116ae69b37544efcf588\",\"is_google_login\":1,\"google_client_id\":\"81856165251-i0o8lgjghadindghpk0bnr9qb6hrqo5r.apps.googleusercontent.com\",\"google_client_secret\":\"otutovHmfl4eFj8WZVq0sYNz\",\"product_guest_checkout\":1,\"product_rating_system\":1,\"package_guest_checkout\":0,\"timezone\":\"Europe\\/Andorra\",\"recurring_billing\":1,\"expiration_reminder\":3,\"preloader_status\":0,\"preloader\":\"604da366b8e8e.gif\",\"course_title\":\"Courses\",\"course_subtitle\":\"Choose From Our Amazing Courses\",\"course_details_title\":\"Course Details\",\"is_course\":1,\"knowledgebase_title\":\"Knowledgebase\",\"knowledgebase_subtitle\":\"Find Answers Before Asking\",\"knowledgebase_details_title\":\"Knowledgebase Details\",\"donation_guest_checkout\":1,\"is_donation\":1,\"is_event\":1,\"event_guest_checkout\":1,\"service_category\":1,\"catalog_mode\":0,\"is_course_rating\":1,\"push_notification_icon\":\"605ac7a0f0810.png\",\"contact_addresses\":\"House - 44, Road - 03, Sector - 11, Uttara, Dhaka\\r\\nDhanmondi, Dhaka\\r\\nMohammadpur, Dhaka\",\"contact_numbers\":\"+123 366 892, +991 2336 255, +064 26 622 62\",\"contact_mails\":\"contact@example.com,inquiry@example.com, questions@example.com\",\"latitude\":\"23.8754443686446\",\"longitude\":\"90.39318192382245\",\"map_zoom\":16,\"home_page_pagebuilder\":0,\"custom_page_pagebuilder\":1,\"is_whatsapp\":1,\"whatsapp_number\":\"+12025550147\",\"whatsapp_header_title\":\"Welcome to PlusAgency\",\"whatsapp_popup_message\":\"Admin can also disable WhatsApp Chat\\r\\n& enable Tawk.to chat\\r\\n(Admin can set any message here)\",\"whatsapp_popup\":1,\"client_feedback_title\":\"\",\"client_feedback_subtitle\":\"\",\"faq_category_status\":1,\"gallery_category_status\":1,\"package_category_status\":1}', 26, '2021-04-26 01:51:07', '2021-04-26 01:51:08');

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

--
-- 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',
  `category_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `faqs` (`id`, `language_id`, `question`, `answer`, `serial_number`, `category_id`) VALUES
(20, 169, 'Who is Magic and what is the purpose of its establishment?', 'The company offers a full range of services for technical solutions, software and designs, so the company seeks to find high-quality technical solutions, develop e-shopping services, and provide technical solutions services in accordance with applicable laws, regulations, and specifications to satisfy the customer.', 1, 10),
(21, 169, 'What is a web page?', 'It is the material that can be viewed in the display area of Internet browsers (computer screen). In terms of content, you must maintain a balance between animation, images and text to get the right message across to your customers. This ensures that the site is easy to use and that the site is easily searchable by search engines as well. We provide you with examples of sites that you think are close to what you are trying to achieve, making it easy for us to understand what you want.', 2, 11),
(22, 169, 'How many pages do I need?', 'This depends on the amount of content you have to introduce visitors to your business and the rest of the pages depend on the quality of your business and the design you aim to achieve.', 3, 12),
(23, 169, 'How long does my website design process take?', 'The duration of the project implementation for clients in general depends on the size and design of the site. If you have a specific date to implement the project, we will work to deliver the project as soon as possible. Note that this depends on the client waiting for the content of the site to be sent.', 4, 10),
(24, 169, 'Will my website be compatible with search engine standards?', 'By choosing the package that includes this, the site will be created and designed taking into account the criteria of search engines, and your website will be re-evaluated from time to time to ensure that the site keeps pace with changes in the rules in search engines.', 5, 11),
(25, 169, 'Will I need a database on my site?', 'This depends on the amount of information you want to display on your website. If you have many services, it may be useful to incorporate a database into your website design.', 6, 12),
(26, 169, 'Can I change and update the content of my website?', 'You can access and control your site from anywhere, as the content management system will allow you to update the content of the site immediately and as frequently as you wish.', 7, 10),
(27, 169, 'What are the hosting companies and does my site need this service?', 'Web hosting companies on the Internet are the company that provides you with the space that can upload the content of your site in addition to providing services to connect your website to the Internet, and we can provide this service for a reasonable fee.', 8, 11),
(28, 169, 'Is it possible to get an email with my site?', 'Yes, you can be provided with an email for use. We can also provide email forwarding services as well, so that you can access your email from anywhere in the world.', 9, 12),
(29, 169, 'Do you redesign websites?', 'Yes. We can redesign your website while maintaining the overall style of the website or completely redesign and change the style. We can also redesign the site and allow you to take advantage of the latest technology.', 10, 10),
(50, 173, 'من هي شركة  ماجيك و ما الهدف من تأسيسها؟', 'تقدم الشركة مجموعة متكاملة من الخدمات للحلول التقنيه والبرمجيات والتصاميم لذلك تسعى الشركة لإيجاد حلول تقنية عالية الجودة وتطوير خدمات التسوق الالكتروني وتقديم خدمات حلول تقنية بما يتوافق مع القوانين المطبقة والأنظمة والمواصفات لارضاء العميل .', 1, 19),
(51, 173, 'ما هي الصفحة الالكترونيه؟', 'هي تلك المادة القابلة للمشاهده في منطقة العرض في برامج تصفح الإنترنت (شاشة الكمبيوتر). من حيث المحتوى، يجب الحفاظ على التوازن بين الرسوم المتحركة والصور والنص لإيصال الرسالة الصحيحة لعملائك. وهذا يضمن سهولة اسخدام الموقع و سهولة البحث عن الموقع من قبل محركات البحث أيضا.و نزودك بأمثلة لمواقع تعتقد أنها قريبة إلى ما تحاول تحقيقه، يجعل من السهل بالنسبة لنا أن نفهم ما تريد.', 2, 20),
(52, 173, 'ما عدد الصفحات التي أحتاجها ؟', 'يعتمد هذا على حجم المحتوى لديك لتعريف الزائرين بأعمالك و ما تبقى من صفحات تعتمد على نوعية أعمالك والتصميم الذي تهدف لتحقيقه.', 3, 21),
(53, 173, 'ما هي المدة الزمنية التي تستغرقها  عملية تصميم الموقع الالكتروني الخاص بي؟', 'تعتمد المدة الزمنية لتنفيذ المشروع للعملاء بشكل عام على حسب حجم الموقع وتصميمه. إذا كان لديك موعد معين لتنفيذ المشروع، فسوف نعمل على تسليم المشروع في أسرع وقت. علما بأن هذا يعتمد على انتظار العميل لإرسال محتوى الموقع .', 4, 19),
(54, 173, 'هل  سيكون موقعي الالكتروني متوافق مع معايير محرك البحث؟', 'من خلال اختيار  الباقة المتضمنة لهذا الأمر سيتم إنشاء و تصميم الموقع آخذين بعين الاعتبار معايير محركات البحث و يتم إعادة تقييم موقعك الإلكتروني من وقت إلى آخر للتأكد من مواكبة الموقع لتغيرات القواعد في محركات لبحث.', 5, 20),
(55, 173, 'هل سأكون بحاجة الى قاعدة بيانات على موقعي ؟', 'يعتمد هذا على كمية المعلومات التي ترغب في عرضها على موقعك الإلكتروني. فإذا كانت لديك العديد من الخدمات، قد يكون من المفيد أن يتم دمج قاعدة بيانات في تصميم الموقع الإلكتروني.', 6, 21),
(56, 173, 'هل استطيع تغيير و تحديث المحتوى الخاص بموقعي الالكتروني ؟', 'يمكنك الوصول و التحكم بموقعك من أي مكان ، حيث سيتيح لك نظام إدارة المحتوى بتحديث محتوى الموقع على الفور وبشكل متكرر كما ترغب.', 7, 19),
(57, 173, 'ما هي شركات الاستضافة و هل يحتاج موقعي لهذه الخدمة؟', 'شركات استضافة المواقع على الإنترنت هي الشركة التي توفر لك المساحة التي تستطيع رفع المحتوى الخاص بموقعك بالإضافة إلى تقديم خدمات ربط موقعك الإلكتروني بشبكة الانترنت و يمكننا توفير هذه الخدمه مقابل رسوم معقوله.', 8, 20),
(58, 173, 'هل بالامكان الحصول على بريد الكتروني مع الموقع الخاص بي؟', 'نعم يمكن تزويدكم ببريد إلكتروني للاستخدام . كما يمكننا توفير خدمات إعادة توجيه البريد الإلكتروني أيضا، لكي تتمكن من الوصول إلى بريدك الإلكتروني من أي مكان في العالم .', 9, 21),
(59, 173, 'هل تقومون بإعادة تصميم المواقع؟', 'نعم. يمكننا إعادة تصميم موقعك الإلكتروني مع المحافظة على النمط العام للموقع أو إعادة التصميم وتغيير النمط بشكل كامل. كما يمكننا إعادة تصميم الموقع وإتاحة الفرصة لك للاستفادة من أحدث التقنيات.', 10, 19);

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

--
-- Table structure for table `faq_categories`
--

CREATE TABLE `faq_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL,
  `serial_number` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faq_categories`
--

INSERT INTO `faq_categories` (`id`, `language_id`, `name`, `status`, `serial_number`, `created_at`, `updated_at`) VALUES
(10, 169, 'Technical Questions', 1, 1, '2021-04-26 03:09:04', '2021-04-26 03:09:04'),
(11, 169, 'Consultancy', 1, 2, '2021-04-26 03:09:24', '2021-04-26 03:09:24'),
(12, 169, 'Projects', 1, 3, '2021-04-26 03:09:45', '2021-04-26 03:09:45'),
(19, 173, 'أسئلة فنية', 1, 1, '2021-04-26 03:09:04', '2021-04-26 03:09:04'),
(20, 173, 'الاستشارات', 1, 2, '2021-04-26 03:09:24', '2021-04-26 03:09:24'),
(21, 173, 'المشاريع', 1, 3, '2021-04-26 03:09:45', '2021-04-26 03:09:45');

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

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

CREATE TABLE `features` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT '0',
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `serial_number` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `features` (`id`, `language_id`, `icon`, `image`, `title`, `color`, `serial_number`) VALUES
(22, 169, 'fas fa-mobile', '1590007661.png', 'Mobile apps', '002B5F', 2),
(23, 169, 'fas fa-cart-arrow-down', '1590007700.png', 'Marketing', '004981', 3),
(29, 173, 'fab fa-dev', NULL, 'تطوير مواقع ويب', '004981', 1),
(30, 173, 'fas fa-mobile', NULL, 'تطوير تطبيقات موبايل', '002B5F', 2),
(31, 173, 'fas fa-cart-arrow-down', NULL, 'تسويق إلكتروني', '004981', 3),
(32, 173, 'fas fa-suitcase', NULL, 'إستشارات', '002B5F', 4),
(35, 169, 'fas fa-suitcase', '1590007871.png', 'Consultation', '002B5F', 4),
(44, 169, 'fab fa-dev', '1590007616.png', 'Web Development', '004981', 1);

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

--
-- Table structure for table `feedbacks`
--

CREATE TABLE `feedbacks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rating` mediumint(8) UNSIGNED NOT NULL,
  `feedback` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `galleries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT '0',
  `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,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `galleries` (`id`, `language_id`, `title`, `image`, `serial_number`, `created_at`, `updated_at`, `category_id`) VALUES
(33, 169, 'Consulting', '1576941584.jpg', 1, '2019-12-22 03:19:50', '2021-04-26 03:05:47', 6),
(34, 169, 'Meeting going on', '1576941605.jpg', 2, '2019-12-22 03:20:06', '2021-04-26 03:05:47', 7),
(35, 169, 'Relaxing Environment', '1576941613.jpg', 3, '2019-12-22 03:20:20', '2021-04-26 03:05:47', 8),
(36, 169, 'Friendly Office Envirnment', '1576941630.jpg', 4, '2019-12-22 03:23:26', '2021-04-26 03:05:47', 6),
(37, 169, 'Happy Employees', '1576941815.jpg', 5, '2019-12-22 03:23:41', '2021-04-26 03:05:47', 7),
(38, 169, 'Discussion', '1576941833.jpg', 6, '2019-12-22 03:23:58', '2021-04-26 03:05:47', 8),
(39, 169, 'Group Discussion', '1576941850.jpg', 7, '2019-12-22 03:24:15', '2021-04-26 03:05:47', 6),
(40, 169, 'Happy Clients', '1576941864.jpg', 8, '2019-12-22 03:24:29', '2021-04-26 03:05:47', 7),
(41, 169, 'Project Planning', '1576941880.jpg', 9, '2019-12-22 03:24:46', '2021-04-26 03:05:47', 8),
(42, 169, 'Dedicatation & Passion', '1576941894.jpg', 10, '2019-12-22 03:25:04', '2021-04-26 03:05:47', 6),
(43, 169, 'Happy Customers', '1576941932.jpg', 11, '2019-12-22 03:25:33', '2021-04-26 03:05:47', 7),
(44, 169, 'Working as a team', '1576941943.jpg', 12, '2019-12-22 03:25:52', '2021-04-26 03:05:47', 8),
(45, 169, 'Work station setup', '1576941960.jpg', 13, '2019-12-22 03:26:05', '2021-04-26 03:05:47', 6),
(59, 173, 'مستشار', '1577893772.jpg', 1, '2020-01-02 03:49:47', '2021-04-26 03:05:47', 15),
(60, 173, 'اجتماع يحدث', '1577893839.jpg', 2, '2020-01-02 03:50:40', '2021-04-26 03:05:47', 16),
(61, 173, 'بيئة مريحة', '1577893855.jpg', 3, '2020-01-02 03:51:05', '2021-04-26 03:05:47', 17),
(62, 173, 'بيئة مكتب ودية', '1577893893.jpg', 4, '2020-01-02 03:51:43', '2021-04-26 03:05:47', 15),
(63, 173, 'الموظفين سعداء', '1577893941.jpg', 5, '2020-01-02 03:52:30', '2021-04-26 03:05:47', 16),
(64, 173, 'نقاش', '1577893966.jpg', 6, '2020-01-02 03:52:56', '2021-04-26 03:05:47', 17),
(65, 173, 'مناقشة جماعية', '1577893999.jpg', 7, '2020-01-02 03:53:29', '2021-04-26 03:05:47', 15),
(66, 173, 'عملاء سعداء', '1577894026.jpg', 8, '2020-01-02 03:53:56', '2021-04-26 03:05:47', 16),
(68, 173, 'تخطيط المشروع', '1577894093.jpg', 9, '2020-01-02 03:55:01', '2021-04-26 03:05:47', 17),
(69, 173, 'التفاني والعاطفة', '1577895304.jpg', 10, '2020-01-02 04:15:15', '2021-04-26 03:05:47', 15),
(70, 173, 'الزبائن سعداء', '1577895444.jpg', 11, '2020-01-02 04:17:34', '2021-04-26 03:05:47', 16),
(71, 173, 'العمل كفريق واحد', '1577895472.jpg', 12, '2020-01-02 04:18:03', '2021-04-26 03:05:47', 17),
(72, 173, 'إعداد محطة العمل', '1577895503.jpg', 13, '2020-01-02 04:18:36', '2021-04-26 03:05:47', 15);

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

--
