INSERT INTO `services` (`id`, `language_id`, `scategory_id`, `main_image`, `title`, `slug`, `content`, `summary`, `serial_number`, `meta_keywords`, `meta_description`, `feature`, `details_page_status`, `sidebar`) VALUES
(256, 173, 74, '1593839452.jpg', 'وورد البرنامج المساعد', 'وورد-البرنامج-المساعد', 0x[encoded data, 21232 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 23, NULL, NULL, 0, 1, 1),
(257, 173, 74, '1593839464.jpg', 'جافا سكريبت البرنامج المساعد', 'جافا-سكريبت-البرنامج-المساعد', 0x[encoded data, 21232 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 24, NULL, NULL, 0, 1, 1);
INSERT INTO `services` (`id`, `language_id`, `scategory_id`, `main_image`, `title`, `slug`, `content`, `summary`, `serial_number`, `meta_keywords`, `meta_description`, `feature`, `details_page_status`, `sidebar`) VALUES
(258, 173, 74, '1593839395.jpg', 'ملحقات كروم', 'ملحقات-كروم', 0x[encoded data, 21232 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 25, NULL, NULL, 0, 1, 1),
(259, 173, 74, '1593839417.jpg', 'PHP المساعد', 'PHP-المساعد', 0x[encoded data, 21232 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 26, NULL, NULL, 0, 1, 1);
INSERT INTO `services` (`id`, `language_id`, `scategory_id`, `main_image`, `title`, `slug`, `content`, `summary`, `serial_number`, `meta_keywords`, `meta_description`, `feature`, `details_page_status`, `sidebar`) VALUES
(260, 173, 75, '1593839426.jpg', 'جوجل Adword', 'جوجل-Adword', 0x[encoded data, 21232 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 27, NULL, NULL, 0, 1, 1),
(261, 173, 75, '1593839435.jpg', 'على الصفحة سيو', 'على-الصفحة-سيو', 0x[encoded data, 21232 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 28, NULL, NULL, 0, 1, 1);
INSERT INTO `services` (`id`, `language_id`, `scategory_id`, `main_image`, `title`, `slug`, `content`, `summary`, `serial_number`, `meta_keywords`, `meta_description`, `feature`, `details_page_status`, `sidebar`) VALUES
(262, 173, 75, '1593839452.jpg', 'خارج الصفحة سيو', 'خارج-الصفحة-سيو', 0x[encoded data, 21232 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 29, NULL, NULL, 0, 1, 1),
(263, 173, 75, '1593839464.jpg', 'التسويق الإجتماعي', 'التسويق-الإجتماعي', 0x[encoded data, 21232 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 30, NULL, NULL, 0, 1, 1);
INSERT INTO `services` (`id`, `language_id`, `scategory_id`, `main_image`, `title`, `slug`, `content`, `summary`, `serial_number`, `meta_keywords`, `meta_description`, `feature`, `details_page_status`, `sidebar`) VALUES
(264, 173, 76, '1593839395.jpg', 'تحرير صور المنتج', 'تحرير-صور-المنتج', 0x[encoded data, 21232 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 31, NULL, NULL, 0, 1, 1),
(265, 173, 76, '1593839417.jpg', 'صور المسكين', 'صور-المسكين', 0x[encoded data, 21232 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 32, NULL, NULL, 0, 1, 1);
INSERT INTO `services` (`id`, `language_id`, `scategory_id`, `main_image`, `title`, `slug`, `content`, `summary`, `serial_number`, `meta_keywords`, `meta_description`, `feature`, `details_page_status`, `sidebar`) VALUES
(266, 173, 76, '1593839426.jpg', 'مفصل الرقبة', 'مفصل-الرقبة', 0x[encoded data, 21232 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 33, NULL, NULL, 0, 1, 1),
(267, 173, 76, '1593839435.jpg', 'تعديل الصورة', 'تعديل-الصورة', 0x[encoded data, 21232 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 34, NULL, NULL, 0, 1, 1);
INSERT INTO `services` (`id`, `language_id`, `scategory_id`, `main_image`, `title`, `slug`, `content`, `summary`, `serial_number`, `meta_keywords`, `meta_description`, `feature`, `details_page_status`, `sidebar`) VALUES
(268, 173, 77, '1593839452.jpg', 'تصميم UX', 'تصميم-UX', 0x[encoded data, 21232 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 35, NULL, NULL, 0, 1, 1),
(269, 173, 77, '1593839464.jpg', 'تصميم المواقع', 'تصميم-المواقع', 0x[encoded data, 21232 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 36, NULL, NULL, 0, 1, 1);
INSERT INTO `services` (`id`, `language_id`, `scategory_id`, `main_image`, `title`, `slug`, `content`, `summary`, `serial_number`, `meta_keywords`, `meta_description`, `feature`, `details_page_status`, `sidebar`) VALUES
(270, 173, 77, '1593839395.jpg', 'تطوير الشبكة', 'تطوير-الشبكة', 0x[encoded data, 21232 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 37, NULL, NULL, 0, 1, 1),
(271, 173, 77, '1593839417.jpg', 'تسويق', 'تسويق', 0x[encoded data, 21232 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 38, NULL, NULL, 0, 1, 1);

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

--
-- Table structure for table `shipping_charges`
--

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

INSERT INTO `shipping_charges` (`id`, `title`, `language_id`, `text`, `days`, `charge`, `created_at`, `updated_at`) VALUES
(6, 'Same Day Shipping', 169, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', NULL, '10.00', '2021-04-23 06:15:15', '2021-04-23 06:15:15');

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

--
-- Table structure for table `sitemaps`
--

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

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

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

CREATE TABLE `sliders` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` int NOT NULL DEFAULT '0',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_font_size` int DEFAULT NULL,
  `bold_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bold_text_font_size` int DEFAULT NULL,
  `bold_text_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text_font_size` int DEFAULT NULL,
  `button_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_text_font_size` int DEFAULT NULL,
  `button_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `side_image` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `serial_number` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `another_button_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `another_button_text_font_size` int DEFAULT NULL,
  `another_button_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `language_id`, `title`, `title_font_size`, `bold_text`, `bold_text_font_size`, `bold_text_color`, `text`, `text_font_size`, `button_text`, `button_text_font_size`, `button_url`, `image`, `side_image`, `serial_number`, `created_at`, `updated_at`, `another_button_text`, `another_button_text_font_size`, `another_button_url`) VALUES
(10, 170, 'Planejamento financeiro para a vida', 24, NULL, NULL, NULL, 'Confiável para tomar melhores decisões financeiras.', 60, 'Saber mais', 14, 'https://megasoft.biz/plusagency/about-us/page', '1584811503.jpg', NULL, 1, '2019-12-20 03:26:31', '2020-03-21 23:25:03', NULL, NULL, NULL),
(11, 170, 'Planejamento financeiro para a vida', 24, NULL, NULL, NULL, 'Confiável para tomar melhores decisões financeiras.', 60, 'Saber mais', 14, 'https://megasoft.biz/plusagency/about-us/page', '1584811494.jpg', NULL, 2, '2019-12-20 03:27:07', '2020-03-21 23:24:54', NULL, NULL, NULL),
(12, 170, 'Planejamento financeiro para a vida', 24, NULL, NULL, NULL, 'Confiável para tomar melhores decisões financeiras.', 60, 'Saber mais', 14, 'https://megasoft.biz/plusagency/about-us/page', '1584811486.jpg', NULL, 3, '2019-12-20 03:27:59', '2020-03-21 23:24:46', NULL, NULL, NULL),
(16, 171, 'Planejamento financeiro para a vida', 24, NULL, NULL, NULL, 'Confiável para tomar melhores decisões financeiras.', 60, 'Saber mais', 14, 'https://megasoft.biz/plusagency/about-us/page', '1584811552.jpg', NULL, 1, '2019-12-22 05:08:44', '2020-03-21 23:25:52', NULL, NULL, NULL),
(17, 171, 'Planejamento financeiro para a vida', 24, NULL, NULL, NULL, 'Confiável para tomar melhores decisões financeiras.', 60, 'Saber mais', 14, 'https://megasoft.biz/plusagency/about-us/page', '1584811544.jpg', NULL, 2, '2019-12-22 05:09:13', '2020-03-21 23:25:44', NULL, NULL, NULL),
(18, 171, 'Planejamento financeiro para a vida', 24, NULL, NULL, NULL, 'Confiável para tomar melhores decisões financeiras.', 60, 'Saber mais', 14, 'https://megasoft.biz/plusagency/about-us/page', '1584811531.jpg', NULL, 3, '2019-12-22 05:09:43', '2020-03-21 23:25:31', NULL, NULL, NULL),
(19, 173, 'التخطيط المالي للحياة', 24, 'خدمة عملاء سعداء', 76, '3449FF', 'موثوق للمساعدة في توجيه رجال الأعمال لاتخاذ قرارات مالية أفضل.', 60, 'أعرف أكثر', 14, 'https://megasoft.biz/plusagency/about-us/page', '1584811600.jpg', NULL, 1, '2019-12-27 22:31:55', '2020-05-05 12:30:32', NULL, NULL, NULL),
(20, 173, 'التخطيط المالي للحياة', 24, NULL, NULL, NULL, 'موثوق للمساعدة في توجيه رجال الأعمال لاتخاذ قرارات مالية أفضل.', 60, 'أعرف أكثر', 14, 'https://megasoft.biz/plusagency/about-us/page', '1584811591.jpg', NULL, 2, '2019-12-27 22:33:01', '2020-03-21 23:26:31', NULL, NULL, NULL),
(21, 173, 'التخطيط المالي للحياة', 24, NULL, NULL, NULL, 'موثوق للمساعدة في توجيه رجال الأعمال لاتخاذ قرارات مالية أفضل.', 60, 'أعرف أكثر', 14, 'https://megasoft.biz/plusagency/about-us/page', '1584811579.jpg', NULL, 3, '2019-12-27 22:33:35', '2020-03-21 23:26:19', NULL, NULL, NULL),
(27, 169, 'Financial Planning For Life', 24, 'Be stronger!', 147, NULL, 'Trusted to help guide entrepreneurs make better financial decisions.', 60, 'Learn More', 14, 'https://en.wikipedia.org/wiki/Gym', '1593837706.jpg', NULL, 1, '2020-06-27 09:49:09', '2020-07-03 22:41:46', NULL, NULL, NULL),
(28, 169, 'Financial Planning For Life', 24, 'Be stronger!', 147, NULL, 'Trusted to help guide entrepreneurs make better financial decisions.', 60, 'Learn More', 14, 'https://en.wikipedia.org/wiki/Gym', '1593837715.jpg', NULL, 1, '2020-06-27 09:49:09', '2020-07-03 22:41:55', NULL, NULL, NULL),
(29, 169, 'Financial Planning For Life', 24, 'Be stronger!', 147, NULL, 'Trusted to help guide entrepreneurs make better financial decisions.', 60, 'Learn More', 14, 'https://en.wikipedia.org/wiki/Gym', '1593837721.jpg', NULL, 1, '2020-06-27 09:49:09', '2020-07-03 22:42:01', NULL, NULL, NULL);

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

--
-- Table structure for table `socials`
--

CREATE TABLE `socials` (
  `id` bigint UNSIGNED NOT NULL,
  `icon` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `serial_number` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `socials`
--

INSERT INTO `socials` (`id`, `icon`, `url`, `serial_number`) VALUES
(20, 'fab fa-facebook-f', 'https://www.facebook.com/', 1),
(21, 'fab fa-twitter', 'https://www.twitter.com/', 2),
(22, 'fab fa-dribbble', 'https://dribble.com/', 3),
(23, 'fab fa-linkedin-in', 'https://www.linkedin.com/', 4),
(24, 'fab fa-google-plus-g', 'https://www.google.com/', 5),
(25, 'fab fa-instagram iconpicker-component', 'https://www.instagram.com/', 6);

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

--
-- Table structure for table `statistics`
--

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

--
-- Dumping data for table `statistics`
--

INSERT INTO `statistics` (`id`, `language_id`, `title`, `quantity`, `icon`, `serial_number`, `created_at`, `updated_at`) VALUES
(13, 170, 'PROJETOS COMPLETOS', 1000, 'fas fa-laptop-code', 1, NULL, NULL),
(14, 170, 'CLIENTES FELIZES', 1200, 'far fa-smile-beam', 2, NULL, NULL),
(15, 170, 'PAÍSES', 120, 'far fa-flag', 3, NULL, NULL),
(16, 170, 'REVISÕES POSITIVAS', 450, 'far fa-thumbs-up', 4, NULL, NULL),
(17, 169, 'COMPLETED PROJECTS', 1000, 'fas fa-laptop-code', 1, NULL, NULL),
(18, 169, 'HAPPY CLIENTS', 1200, 'far fa-smile-beam', 2, NULL, NULL),
(19, 169, 'COUNTRIES', 120, 'far fa-flag', 3, NULL, NULL),
(21, 171, 'PROJETOS COMPLETOS', 1000, 'fas fa-laptop-code', 1, NULL, NULL),
(22, 171, 'CLIENTES FELIZES', 1200, 'far fa-smile-beam', 2, NULL, NULL),
(23, 171, 'PAÍSES', 120, 'far fa-flag', 3, NULL, NULL),
(24, 171, 'REVISÕES POSITIVAS', 450, 'far fa-thumbs-up', 4, NULL, NULL),
(25, 173, 'المشاريع المنجزة', 1000, 'fas fa-laptop-code', 1, NULL, NULL),
(26, 173, 'عملاء سعداء', 1200, 'far fa-smile-beam', 2, NULL, NULL),
(27, 173, 'بلدان', 120, 'far fa-flag', 3, NULL, NULL),
(28, 173, 'مراجعات إيجابية', 450, 'far fa-thumbs-up', 4, NULL, NULL),
(29, 169, 'POSITIVE REVIEWS', 450, 'far fa-thumbs-up', 4, NULL, NULL);

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

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

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

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

INSERT INTO `subscribers` (`id`, `email`) VALUES
(18, 'rakitic@gmail.com');

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

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` int DEFAULT NULL,
  `current_package_id` int DEFAULT NULL,
  `next_package_id` int DEFAULT NULL,
  `fields` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` tinyint NOT NULL DEFAULT '3' COMMENT '0 - expired, 1 - active, 2 - cancelled, 3 - payment incomplete',
  `expire_date` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `receipt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_payment_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `next_payment_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pending_package_id` int DEFAULT NULL,
  `pending_payment_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gateway_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'online',
  `invoice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--

INSERT INTO `subscriptions` (`id`, `user_id`, `current_package_id`, `next_package_id`, `fields`, `status`, `expire_date`, `created_at`, `updated_at`, `name`, `email`, `receipt`, `current_payment_method`, `next_payment_method`, `pending_package_id`, `pending_payment_method`, `gateway_type`, `invoice`) VALUES
(66, 26, 43, 7, '{\"contact_number\":{\"value\":\"5687888120\",\"type\":1},\"Country\":{\"value\":\"Australia\",\"type\":2},\"Document\":{\"value\":\"618a5c282ed20.zip\",\"type\":5},\"Options\":{\"value\":[\"Option 2\",\"Option 3\"],\"type\":3}}', 1, '2022-04-27 03:43:37', '2021-04-27 03:43:27', '2021-11-09 06:31:52', 'John', 'user@gmail.com', NULL, 'Mollie Payment', 'Paystack', NULL, NULL, 'online', 'qzkC1636457512.pdf');

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

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

CREATE TABLE `testimonials` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` int NOT NULL DEFAULT '0',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rank` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `serial_number` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `testimonials` (`id`, `language_id`, `image`, `comment`, `name`, `rank`, `serial_number`) VALUES
(10, 170, '1576864505.jpg', 'Eles fornecem soluções inovadoras com o melhor. tempor incididunt utla bore et dolor tempor incididunt.', 'Jonathon doe', 'Director, art media', 1),
(11, 170, '1576864532.jpg', 'Eles fornecem soluções inovadoras com o melhor. tempor incididunt utla bore et dolor tempor incididunt.', 'Jonathon doe', 'Director, art media', 2),
(12, 170, '1576864568.jpg', 'Eles fornecem soluções inovadoras com o melhor. tempor incididunt utla bore et dolor tempor incididunt.', 'Ben Stokes', 'CTO, Mastermind', 3),
(13, 169, '1576864505.jpg', 'They provide innovative solutions with the best. tempor incididunt utla bore et dolor tempor incididunt .', 'Jonathon doe', 'Director, art media', 1),
(14, 169, '1576864532.jpg', 'They provide innovative solutions with the best. tempor incididunt utla bore et dolor tempor incididunt .', 'Jonathon doe', 'Director, art media', 2),
(15, 169, '1576864568.jpg', 'They provide innovative solutions with the best. tempor incididunt utla bore et dolor tempor incididunt .', 'Ben Stokes', 'CTO, Mastermind', 3),
(16, 171, '1576864505.jpg', 'Eles fornecem soluções inovadoras com o melhor. tempor incididunt utla bore et dolor tempor incididunt.', 'Jonathon doe', 'Diretor, mídia artística', 1),
(17, 171, '1576864532.jpg', 'Eles fornecem soluções inovadoras com o melhor. tempor incididunt utla bore et dolor tempor incididunt.', 'Jonathon doe', 'Diretor, mídia artística', 2),
(18, 171, '1576864568.jpg', 'Eles fornecem soluções inovadoras com o melhor. tempor incididunt utla bore et dolor tempor incididunt.', 'Ben Stokes', 'CTO, Mastermind', 3),
(19, 173, '1576864505.jpg', 'أنها توفر حلول مبتكرة مع الأفضل. temid incididunt utla bore et dolor tempor incididunt.', 'جوناثون دو', 'مدير الإعلام الفني', 1),
(20, 173, '1576864532.jpg', 'أنها توفر حلول مبتكرة مع الأفضل. temid incididunt utla bore et dolor tempor incididunt.', 'جوناثون دو', 'مدير الإعلام الفني', 2),
(21, 173, '1576864568.jpg', 'أنها توفر حلول مبتكرة مع الأفضل. temid incididunt utla bore et dolor tempor incididunt.', 'بن ستوكس', 'CTO ، العقل المدبر', 3);

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

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` int DEFAULT NULL,
  `admin_id` int NOT NULL DEFAULT '1',
  `ticket_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `zip_file` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `last_message` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tickets`
--

INSERT INTO `tickets` (`id`, `user_id`, `admin_id`, `ticket_number`, `subject`, `message`, `zip_file`, `status`, `created_at`, `updated_at`, `last_message`) VALUES
(17, 26, 1, '8428830', 'Need help with Installation', '<p>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,</p>', '608659bb3ad9b.zip', 'close', '2021-04-26 02:12:11', '2021-04-26 02:17:22', '2021-04-26 02:12:11'),
(18, 26, 1, '9185019', '500 Error Occured', '<p>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.</p><p><br></p>', '608659f007477.zip', 'pending', '2021-04-26 02:13:04', '2021-04-26 02:13:04', '2021-04-26 02:13:04'),
(19, 26, 1, '5678607', 'User login not working', '<p>&nbsp;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.</p><p><br></p>', '60865a1a84aac.zip', 'open', '2021-04-26 02:13:46', '2021-04-26 02:16:38', '2021-04-26 02:16:38');

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

--
-- Table structure for table `timezones`
--

CREATE TABLE `timezones` (
  `id` bigint UNSIGNED NOT NULL,
  `country_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `timezone` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `gmt_offset` decimal(10,2) NOT NULL,
  `dst_offset` decimal(10,2) NOT NULL,
  `raw_offset` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `timezones`
--

INSERT INTO `timezones` (`id`, `country_code`, `timezone`, `gmt_offset`, `dst_offset`, `raw_offset`) VALUES
(1, 'AD', 'Europe/Andorra', '1.00', '2.00', '1.00'),
(2, 'AE', 'Asia/Dubai', '4.00', '4.00', '4.00'),
(3, 'AF', 'Asia/Kabul', '4.50', '4.50', '4.50'),
(4, 'AG', 'America/Antigua', '-4.00', '-4.00', '-4.00'),
(5, 'AI', 'America/Anguilla', '-4.00', '-4.00', '-4.00'),
(6, 'AL', 'Europe/Tirane', '1.00', '2.00', '1.00'),
(7, 'AM', 'Asia/Yerevan', '4.00', '4.00', '4.00'),
(8, 'AO', 'Africa/Luanda', '1.00', '1.00', '1.00'),
(9, 'AQ', 'Antarctica/Casey', '8.00', '8.00', '8.00'),
(10, 'AQ', 'Antarctica/Davis', '7.00', '7.00', '7.00'),
(11, 'AQ', 'Antarctica/DumontDUrville', '10.00', '10.00', '10.00'),
(12, 'AQ', 'Antarctica/Mawson', '5.00', '5.00', '5.00'),
(13, 'AQ', 'Antarctica/McMurdo', '13.00', '12.00', '12.00'),
(14, 'AQ', 'Antarctica/Palmer', '-3.00', '-4.00', '-4.00'),
(15, 'AQ', 'Antarctica/Rothera', '-3.00', '-3.00', '-3.00'),
(16, 'AQ', 'Antarctica/South_Pole', '13.00', '12.00', '12.00'),
(17, 'AQ', 'Antarctica/Syowa', '3.00', '3.00', '3.00'),
(18, 'AQ', 'Antarctica/Vostok', '6.00', '6.00', '6.00'),
(19, 'AR', 'America/Argentina/Buenos_Aires', '-3.00', '-3.00', '-3.00'),
(20, 'AR', 'America/Argentina/Catamarca', '-3.00', '-3.00', '-3.00'),
(21, 'AR', 'America/Argentina/Cordoba', '-3.00', '-3.00', '-3.00'),
(22, 'AR', 'America/Argentina/Jujuy', '-3.00', '-3.00', '-3.00'),
(23, 'AR', 'America/Argentina/La_Rioja', '-3.00', '-3.00', '-3.00'),
(24, 'AR', 'America/Argentina/Mendoza', '-3.00', '-3.00', '-3.00'),
(25, 'AR', 'America/Argentina/Rio_Gallegos', '-3.00', '-3.00', '-3.00'),
(26, 'AR', 'America/Argentina/Salta', '-3.00', '-3.00', '-3.00'),
(27, 'AR', 'America/Argentina/San_Juan', '-3.00', '-3.00', '-3.00'),
(28, 'AR', 'America/Argentina/San_Luis', '-3.00', '-3.00', '-3.00'),
(29, 'AR', 'America/Argentina/Tucuman', '-3.00', '-3.00', '-3.00'),
(30, 'AR', 'America/Argentina/Ushuaia', '-3.00', '-3.00', '-3.00'),
(31, 'AS', 'Pacific/Pago_Pago', '-11.00', '-11.00', '-11.00'),
(32, 'AT', 'Europe/Vienna', '1.00', '2.00', '1.00'),
(33, 'AU', 'Antarctica/Macquarie', '11.00', '11.00', '11.00'),
(34, 'AU', 'Australia/Adelaide', '10.50', '9.50', '9.50'),
(35, 'AU', 'Australia/Brisbane', '10.00', '10.00', '10.00'),
(36, 'AU', 'Australia/Broken_Hill', '10.50', '9.50', '9.50'),
(37, 'AU', 'Australia/Currie', '11.00', '10.00', '10.00'),
(38, 'AU', 'Australia/Darwin', '9.50', '9.50', '9.50'),
(39, 'AU', 'Australia/Eucla', '8.75', '8.75', '8.75'),
(40, 'AU', 'Australia/Hobart', '11.00', '10.00', '10.00'),
(41, 'AU', 'Australia/Lindeman', '10.00', '10.00', '10.00'),
(42, 'AU', 'Australia/Lord_Howe', '11.00', '10.50', '10.50'),
(43, 'AU', 'Australia/Melbourne', '11.00', '10.00', '10.00'),
(44, 'AU', 'Australia/Perth', '8.00', '8.00', '8.00'),
(45, 'AU', 'Australia/Sydney', '11.00', '10.00', '10.00'),
(46, 'AW', 'America/Aruba', '-4.00', '-4.00', '-4.00'),
(47, 'AX', 'Europe/Mariehamn', '2.00', '3.00', '2.00'),
(48, 'AZ', 'Asia/Baku', '4.00', '5.00', '4.00'),
(49, 'BA', 'Europe/Sarajevo', '1.00', '2.00', '1.00'),
(50, 'BB', 'America/Barbados', '-4.00', '-4.00', '-4.00'),
(51, 'BD', 'Asia/Dhaka', '6.00', '6.00', '6.00'),
(52, 'BE', 'Europe/Brussels', '1.00', '2.00', '1.00'),
(53, 'BF', 'Africa/Ouagadougou', '0.00', '0.00', '0.00'),
(54, 'BG', 'Europe/Sofia', '2.00', '3.00', '2.00'),
(55, 'BH', 'Asia/Bahrain', '3.00', '3.00', '3.00'),
(56, 'BI', 'Africa/Bujumbura', '2.00', '2.00', '2.00'),
(57, 'BJ', 'Africa/Porto-Novo', '1.00', '1.00', '1.00'),
(58, 'BL', 'America/St_Barthelemy', '-4.00', '-4.00', '-4.00'),
(59, 'BM', 'Atlantic/Bermuda', '-4.00', '-3.00', '-4.00'),
(60, 'BN', 'Asia/Brunei', '8.00', '8.00', '8.00'),
(61, 'BO', 'America/La_Paz', '-4.00', '-4.00', '-4.00'),
(62, 'BQ', 'America/Kralendijk', '-4.00', '-4.00', '-4.00'),
(63, 'BR', 'America/Araguaina', '-3.00', '-3.00', '-3.00'),
(64, 'BR', 'America/Bahia', '-3.00', '-3.00', '-3.00'),
(65, 'BR', 'America/Belem', '-3.00', '-3.00', '-3.00'),
(66, 'BR', 'America/Boa_Vista', '-4.00', '-4.00', '-4.00'),
(67, 'BR', 'America/Campo_Grande', '-3.00', '-4.00', '-4.00'),
(68, 'BR', 'America/Cuiaba', '-3.00', '-4.00', '-4.00'),
(69, 'BR', 'America/Eirunepe', '-5.00', '-5.00', '-5.00'),
(70, 'BR', 'America/Fortaleza', '-3.00', '-3.00', '-3.00'),
(71, 'BR', 'America/Maceio', '-3.00', '-3.00', '-3.00'),
(72, 'BR', 'America/Manaus', '-4.00', '-4.00', '-4.00'),
(73, 'BR', 'America/Noronha', '-2.00', '-2.00', '-2.00'),
(74, 'BR', 'America/Porto_Velho', '-4.00', '-4.00', '-4.00'),
(75, 'BR', 'America/Recife', '-3.00', '-3.00', '-3.00'),
(76, 'BR', 'America/Rio_Branco', '-5.00', '-5.00', '-5.00'),
(77, 'BR', 'America/Santarem', '-3.00', '-3.00', '-3.00'),
(78, 'BR', 'America/Sao_Paulo', '-2.00', '-3.00', '-3.00'),
(79, 'BS', 'America/Nassau', '-5.00', '-4.00', '-5.00'),
(80, 'BT', 'Asia/Thimphu', '6.00', '6.00', '6.00'),
(81, 'BW', 'Africa/Gaborone', '2.00', '2.00', '2.00'),
(82, 'BY', 'Europe/Minsk', '3.00', '3.00', '3.00'),
(83, 'BZ', 'America/Belize', '-6.00', '-6.00', '-6.00'),
(84, 'CA', 'America/Atikokan', '-5.00', '-5.00', '-5.00'),
(85, 'CA', 'America/Blanc-Sablon', '-4.00', '-4.00', '-4.00'),
(86, 'CA', 'America/Cambridge_Bay', '-7.00', '-6.00', '-7.00'),
(87, 'CA', 'America/Creston', '-7.00', '-7.00', '-7.00'),
(88, 'CA', 'America/Dawson', '-8.00', '-7.00', '-8.00'),
(89, 'CA', 'America/Dawson_Creek', '-7.00', '-7.00', '-7.00'),
(90, 'CA', 'America/Edmonton', '-7.00', '-6.00', '-7.00'),
(91, 'CA', 'America/Glace_Bay', '-4.00', '-3.00', '-4.00'),
(92, 'CA', 'America/Goose_Bay', '-4.00', '-3.00', '-4.00'),
(93, 'CA', 'America/Halifax', '-4.00', '-3.00', '-4.00'),
(94, 'CA', 'America/Inuvik', '-7.00', '-6.00', '-7.00'),
(95, 'CA', 'America/Iqaluit', '-5.00', '-4.00', '-5.00'),
(96, 'CA', 'America/Moncton', '-4.00', '-3.00', '-4.00'),
(97, 'CA', 'America/Montreal', '-5.00', '-4.00', '-5.00'),
(98, 'CA', 'America/Nipigon', '-5.00', '-4.00', '-5.00'),
(99, 'CA', 'America/Pangnirtung', '-5.00', '-4.00', '-5.00'),
(100, 'CA', 'America/Rainy_River', '-6.00', '-5.00', '-6.00'),
(101, 'CA', 'America/Rankin_Inlet', '-6.00', '-5.00', '-6.00'),
(102, 'CA', 'America/Regina', '-6.00', '-6.00', '-6.00'),
(103, 'CA', 'America/Resolute', '-6.00', '-5.00', '-6.00'),
(104, 'CA', 'America/St_Johns', '-3.50', '-2.50', '-3.50'),
(105, 'CA', 'America/Swift_Current', '-6.00', '-6.00', '-6.00'),
(106, 'CA', 'America/Thunder_Bay', '-5.00', '-4.00', '-5.00'),
(107, 'CA', 'America/Toronto', '-5.00', '-4.00', '-5.00'),
(108, 'CA', 'America/Vancouver', '-8.00', '-7.00', '-8.00'),
(109, 'CA', 'America/Whitehorse', '-8.00', '-7.00', '-8.00'),
(110, 'CA', 'America/Winnipeg', '-6.00', '-5.00', '-6.00'),
(111, 'CA', 'America/Yellowknife', '-7.00', '-6.00', '-7.00'),
(112, 'CC', 'Indian/Cocos', '6.50', '6.50', '6.50'),
(113, 'CD', 'Africa/Kinshasa', '1.00', '1.00', '1.00'),
(114, 'CD', 'Africa/Lubumbashi', '2.00', '2.00', '2.00'),
(115, 'CF', 'Africa/Bangui', '1.00', '1.00', '1.00'),
(116, 'CG', 'Africa/Brazzaville', '1.00', '1.00', '1.00'),
(117, 'CH', 'Europe/Zurich', '1.00', '2.00', '1.00'),
(118, 'CI', 'Africa/Abidjan', '0.00', '0.00', '0.00'),
(119, 'CK', 'Pacific/Rarotonga', '-10.00', '-10.00', '-10.00'),
(120, 'CL', 'America/Santiago', '-3.00', '-4.00', '-4.00'),
(121, 'CL', 'Pacific/Easter', '-5.00', '-6.00', '-6.00'),
(122, 'CM', 'Africa/Douala', '1.00', '1.00', '1.00'),
(123, 'CN', 'Asia/Chongqing', '8.00', '8.00', '8.00'),
(124, 'CN', 'Asia/Harbin', '8.00', '8.00', '8.00'),
(125, 'CN', 'Asia/Kashgar', '8.00', '8.00', '8.00'),
(126, 'CN', 'Asia/Shanghai', '8.00', '8.00', '8.00'),
(127, 'CN', 'Asia/Urumqi', '8.00', '8.00', '8.00'),
(128, 'CO', 'America/Bogota', '-5.00', '-5.00', '-5.00'),
(129, 'CR', 'America/Costa_Rica', '-6.00', '-6.00', '-6.00'),
(130, 'CU', 'America/Havana', '-5.00', '-4.00', '-5.00'),
(131, 'CV', 'Atlantic/Cape_Verde', '-1.00', '-1.00', '-1.00'),
(132, 'CW', 'America/Curacao', '-4.00', '-4.00', '-4.00'),
(133, 'CX', 'Indian/Christmas', '7.00', '7.00', '7.00'),
(134, 'CY', 'Asia/Nicosia', '2.00', '3.00', '2.00'),
(135, 'CZ', 'Europe/Prague', '1.00', '2.00', '1.00'),
(136, 'DE', 'Europe/Berlin', '1.00', '2.00', '1.00'),
(137, 'DE', 'Europe/Busingen', '1.00', '2.00', '1.00'),
(138, 'DJ', 'Africa/Djibouti', '3.00', '3.00', '3.00'),
(139, 'DK', 'Europe/Copenhagen', '1.00', '2.00', '1.00'),
(140, 'DM', 'America/Dominica', '-4.00', '-4.00', '-4.00'),
(141, 'DO', 'America/Santo_Domingo', '-4.00', '-4.00', '-4.00'),
(142, 'DZ', 'Africa/Algiers', '1.00', '1.00', '1.00'),
(143, 'EC', 'America/Guayaquil', '-5.00', '-5.00', '-5.00'),
(144, 'EC', 'Pacific/Galapagos', '-6.00', '-6.00', '-6.00'),
(145, 'EE', 'Europe/Tallinn', '2.00', '3.00', '2.00'),
(146, 'EG', 'Africa/Cairo', '2.00', '2.00', '2.00'),
(147, 'EH', 'Africa/El_Aaiun', '0.00', '0.00', '0.00'),
(148, 'ER', 'Africa/Asmara', '3.00', '3.00', '3.00'),
(149, 'ES', 'Africa/Ceuta', '1.00', '2.00', '1.00'),
(150, 'ES', 'Atlantic/Canary', '0.00', '1.00', '0.00'),
(151, 'ES', 'Europe/Madrid', '1.00', '2.00', '1.00'),
(152, 'ET', 'Africa/Addis_Ababa', '3.00', '3.00', '3.00'),
(153, 'FI', 'Europe/Helsinki', '2.00', '3.00', '2.00'),
(154, 'FJ', 'Pacific/Fiji', '13.00', '12.00', '12.00'),
(155, 'FK', 'Atlantic/Stanley', '-3.00', '-3.00', '-3.00'),
(156, 'FM', 'Pacific/Chuuk', '10.00', '10.00', '10.00'),
(157, 'FM', 'Pacific/Kosrae', '11.00', '11.00', '11.00'),
(158, 'FM', 'Pacific/Pohnpei', '11.00', '11.00', '11.00'),
(159, 'FO', 'Atlantic/Faroe', '0.00', '1.00', '0.00'),
(160, 'FR', 'Europe/Paris', '1.00', '2.00', '1.00'),
(161, 'GA', 'Africa/Libreville', '1.00', '1.00', '1.00'),
(162, 'GB', 'Europe/London', '0.00', '1.00', '0.00'),
(163, 'GD', 'America/Grenada', '-4.00', '-4.00', '-4.00'),
(164, 'GE', 'Asia/Tbilisi', '4.00', '4.00', '4.00'),
(165, 'GF', 'America/Cayenne', '-3.00', '-3.00', '-3.00'),
(166, 'GG', 'Europe/Guernsey', '0.00', '1.00', '0.00'),
(167, 'GH', 'Africa/Accra', '0.00', '0.00', '0.00'),
(168, 'GI', 'Europe/Gibraltar', '1.00', '2.00', '1.00'),
(169, 'GL', 'America/Danmarkshavn', '0.00', '0.00', '0.00'),
(170, 'GL', 'America/Godthab', '-3.00', '-2.00', '-3.00'),
(171, 'GL', 'America/Scoresbysund', '-1.00', '0.00', '-1.00'),
(172, 'GL', 'America/Thule', '-4.00', '-3.00', '-4.00'),
(173, 'GM', 'Africa/Banjul', '0.00', '0.00', '0.00'),
(174, 'GN', 'Africa/Conakry', '0.00', '0.00', '0.00'),
(175, 'GP', 'America/Guadeloupe', '-4.00', '-4.00', '-4.00'),
(176, 'GQ', 'Africa/Malabo', '1.00', '1.00', '1.00'),
(177, 'GR', 'Europe/Athens', '2.00', '3.00', '2.00'),
(178, 'GS', 'Atlantic/South_Georgia', '-2.00', '-2.00', '-2.00'),
(179, 'GT', 'America/Guatemala', '-6.00', '-6.00', '-6.00'),
(180, 'GU', 'Pacific/Guam', '10.00', '10.00', '10.00'),
(181, 'GW', 'Africa/Bissau', '0.00', '0.00', '0.00'),
(182, 'GY', 'America/Guyana', '-4.00', '-4.00', '-4.00'),
(183, 'HK', 'Asia/Hong_Kong', '8.00', '8.00', '8.00'),
(184, 'HN', 'America/Tegucigalpa', '-6.00', '-6.00', '-6.00'),
(185, 'HR', 'Europe/Zagreb', '1.00', '2.00', '1.00'),
(186, 'HT', 'America/Port-au-Prince', '-5.00', '-4.00', '-5.00'),
(187, 'HU', 'Europe/Budapest', '1.00', '2.00', '1.00'),
(188, 'ID', 'Asia/Jakarta', '7.00', '7.00', '7.00'),
(189, 'ID', 'Asia/Jayapura', '9.00', '9.00', '9.00'),
(190, 'ID', 'Asia/Makassar', '8.00', '8.00', '8.00'),
(191, 'ID', 'Asia/Pontianak', '7.00', '7.00', '7.00'),
(192, 'IE', 'Europe/Dublin', '0.00', '1.00', '0.00'),
(193, 'IL', 'Asia/Jerusalem', '2.00', '3.00', '2.00'),
(194, 'IM', 'Europe/Isle_of_Man', '0.00', '1.00', '0.00'),
(195, 'IN', 'Asia/Kolkata', '5.50', '5.50', '5.50'),
(196, 'IO', 'Indian/Chagos', '6.00', '6.00', '6.00'),
(197, 'IQ', 'Asia/Baghdad', '3.00', '3.00', '3.00'),
(198, 'IR', 'Asia/Tehran', '3.50', '4.50', '3.50'),
(199, 'IS', 'Atlantic/Reykjavik', '0.00', '0.00', '0.00'),
(200, 'IT', 'Europe/Rome', '1.00', '2.00', '1.00'),
(201, 'JE', 'Europe/Jersey', '0.00', '1.00', '0.00'),
(202, 'JM', 'America/Jamaica', '-5.00', '-5.00', '-5.00'),
(203, 'JO', 'Asia/Amman', '2.00', '3.00', '2.00'),
(204, 'JP', 'Asia/Tokyo', '9.00', '9.00', '9.00'),
(205, 'KE', 'Africa/Nairobi', '3.00', '3.00', '3.00'),
(206, 'KG', 'Asia/Bishkek', '6.00', '6.00', '6.00'),
(207, 'KH', 'Asia/Phnom_Penh', '7.00', '7.00', '7.00'),
(208, 'KI', 'Pacific/Enderbury', '13.00', '13.00', '13.00'),
(209, 'KI', 'Pacific/Kiritimati', '14.00', '14.00', '14.00'),
(210, 'KI', 'Pacific/Tarawa', '12.00', '12.00', '12.00'),
(211, 'KM', 'Indian/Comoro', '3.00', '3.00', '3.00'),
(212, 'KN', 'America/St_Kitts', '-4.00', '-4.00', '-4.00'),
(213, 'KP', 'Asia/Pyongyang', '9.00', '9.00', '9.00'),
(214, 'KR', 'Asia/Seoul', '9.00', '9.00', '9.00'),
(215, 'KW', 'Asia/Kuwait', '3.00', '3.00', '3.00'),
(216, 'KY', 'America/Cayman', '-5.00', '-5.00', '-5.00'),
(217, 'KZ', 'Asia/Almaty', '6.00', '6.00', '6.00'),
(218, 'KZ', 'Asia/Aqtau', '5.00', '5.00', '5.00'),
(219, 'KZ', 'Asia/Aqtobe', '5.00', '5.00', '5.00'),
(220, 'KZ', 'Asia/Oral', '5.00', '5.00', '5.00'),
(221, 'KZ', 'Asia/Qyzylorda', '6.00', '6.00', '6.00'),
(222, 'LA', 'Asia/Vientiane', '7.00', '7.00', '7.00'),
(223, 'LB', 'Asia/Beirut', '2.00', '3.00', '2.00'),
(224, 'LC', 'America/St_Lucia', '-4.00', '-4.00', '-4.00'),
(225, 'LI', 'Europe/Vaduz', '1.00', '2.00', '1.00'),
(226, 'LK', 'Asia/Colombo', '5.50', '5.50', '5.50'),
(227, 'LR', 'Africa/Monrovia', '0.00', '0.00', '0.00'),
(228, 'LS', 'Africa/Maseru', '2.00', '2.00', '2.00'),
(229, 'LT', 'Europe/Vilnius', '2.00', '3.00', '2.00'),
(230, 'LU', 'Europe/Luxembourg', '1.00', '2.00', '1.00'),
(231, 'LV', 'Europe/Riga', '2.00', '3.00', '2.00'),
(232, 'LY', 'Africa/Tripoli', '2.00', '2.00', '2.00'),
(233, 'MA', 'Africa/Casablanca', '0.00', '0.00', '0.00'),
(234, 'MC', 'Europe/Monaco', '1.00', '2.00', '1.00'),
(235, 'MD', 'Europe/Chisinau', '2.00', '3.00', '2.00'),
(236, 'ME', 'Europe/Podgorica', '1.00', '2.00', '1.00'),
(237, 'MF', 'America/Marigot', '-4.00', '-4.00', '-4.00'),
(238, 'MG', 'Indian/Antananarivo', '3.00', '3.00', '3.00'),
(239, 'MH', 'Pacific/Kwajalein', '12.00', '12.00', '12.00'),
(240, 'MH', 'Pacific/Majuro', '12.00', '12.00', '12.00'),
(241, 'MK', 'Europe/Skopje', '1.00', '2.00', '1.00'),
(242, 'ML', 'Africa/Bamako', '0.00', '0.00', '0.00'),
(243, 'MM', 'Asia/Rangoon', '6.50', '6.50', '6.50'),
(244, 'MN', 'Asia/Choibalsan', '8.00', '8.00', '8.00'),
(245, 'MN', 'Asia/Hovd', '7.00', '7.00', '7.00'),
(246, 'MN', 'Asia/Ulaanbaatar', '8.00', '8.00', '8.00'),
(247, 'MO', 'Asia/Macau', '8.00', '8.00', '8.00'),
(248, 'MP', 'Pacific/Saipan', '10.00', '10.00', '10.00'),
(249, 'MQ', 'America/Martinique', '-4.00', '-4.00', '-4.00'),
(250, 'MR', 'Africa/Nouakchott', '0.00', '0.00', '0.00'),
(251, 'MS', 'America/Montserrat', '-4.00', '-4.00', '-4.00'),
(252, 'MT', 'Europe/Malta', '1.00', '2.00', '1.00'),
(253, 'MU', 'Indian/Mauritius', '4.00', '4.00', '4.00'),
(254, 'MV', 'Indian/Maldives', '5.00', '5.00', '5.00'),
(255, 'MW', 'Africa/Blantyre', '2.00', '2.00', '2.00'),
(256, 'MX', 'America/Bahia_Banderas', '-6.00', '-5.00', '-6.00'),
(257, 'MX', 'America/Cancun', '-6.00', '-5.00', '-6.00'),
(258, 'MX', 'America/Chihuahua', '-7.00', '-6.00', '-7.00'),
(259, 'MX', 'America/Hermosillo', '-7.00', '-7.00', '-7.00'),
(260, 'MX', 'America/Matamoros', '-6.00', '-5.00', '-6.00'),
(261, 'MX', 'America/Mazatlan', '-7.00', '-6.00', '-7.00'),
(262, 'MX', 'America/Merida', '-6.00', '-5.00', '-6.00'),
(263, 'MX', 'America/Mexico_City', '-6.00', '-5.00', '-6.00'),
(264, 'MX', 'America/Monterrey', '-6.00', '-5.00', '-6.00'),
(265, 'MX', 'America/Ojinaga', '-7.00', '-6.00', '-7.00'),
(266, 'MX', 'America/Santa_Isabel', '-8.00', '-7.00', '-8.00'),
(267, 'MX', 'America/Tijuana', '-8.00', '-7.00', '-8.00'),
(268, 'MY', 'Asia/Kuala_Lumpur', '8.00', '8.00', '8.00'),
(269, 'MY', 'Asia/Kuching', '8.00', '8.00', '8.00'),
(270, 'MZ', 'Africa/Maputo', '2.00', '2.00', '2.00'),
(271, 'NA', 'Africa/Windhoek', '2.00', '1.00', '1.00'),
(272, 'NC', 'Pacific/Noumea', '11.00', '11.00', '11.00'),
(273, 'NE', 'Africa/Niamey', '1.00', '1.00', '1.00'),
(274, 'NF', 'Pacific/Norfolk', '11.50', '11.50', '11.50'),
(275, 'NG', 'Africa/Lagos', '1.00', '1.00', '1.00'),
(276, 'NI', 'America/Managua', '-6.00', '-6.00', '-6.00'),
(277, 'NL', 'Europe/Amsterdam', '1.00', '2.00', '1.00'),
(278, 'NO', 'Europe/Oslo', '1.00', '2.00', '1.00'),
(279, 'NP', 'Asia/Kathmandu', '5.75', '5.75', '5.75'),
(280, 'NR', 'Pacific/Nauru', '12.00', '12.00', '12.00'),
(281, 'NU', 'Pacific/Niue', '-11.00', '-11.00', '-11.00'),
(282, 'NZ', 'Pacific/Auckland', '13.00', '12.00', '12.00'),
(283, 'NZ', 'Pacific/Chatham', '13.75', '12.75', '12.75'),
(284, 'OM', 'Asia/Muscat', '4.00', '4.00', '4.00'),
(285, 'PA', 'America/Panama', '-5.00', '-5.00', '-5.00'),
(286, 'PE', 'America/Lima', '-5.00', '-5.00', '-5.00'),
(287, 'PF', 'Pacific/Gambier', '-9.00', '-9.00', '-9.00'),
(288, 'PF', 'Pacific/Marquesas', '-9.50', '-9.50', '-9.50'),
(289, 'PF', 'Pacific/Tahiti', '-10.00', '-10.00', '-10.00'),
(290, 'PG', 'Pacific/Port_Moresby', '10.00', '10.00', '10.00'),
(291, 'PH', 'Asia/Manila', '8.00', '8.00', '8.00'),
(292, 'PK', 'Asia/Karachi', '5.00', '5.00', '5.00'),
(293, 'PL', 'Europe/Warsaw', '1.00', '2.00', '1.00'),
(294, 'PM', 'America/Miquelon', '-3.00', '-2.00', '-3.00'),
(295, 'PN', 'Pacific/Pitcairn', '-8.00', '-8.00', '-8.00'),
(296, 'PR', 'America/Puerto_Rico', '-4.00', '-4.00', '-4.00'),
(297, 'PS', 'Asia/Gaza', '2.00', '3.00', '2.00'),
(298, 'PS', 'Asia/Hebron', '2.00', '3.00', '2.00'),
(299, 'PT', 'Atlantic/Azores', '-1.00', '0.00', '-1.00'),
(300, 'PT', 'Atlantic/Madeira', '0.00', '1.00', '0.00'),
(301, 'PT', 'Europe/Lisbon', '0.00', '1.00', '0.00'),
(302, 'PW', 'Pacific/Palau', '9.00', '9.00', '9.00'),
(303, 'PY', 'America/Asuncion', '-3.00', '-4.00', '-4.00'),
(304, 'QA', 'Asia/Qatar', '3.00', '3.00', '3.00'),
(305, 'RE', 'Indian/Reunion', '4.00', '4.00', '4.00'),
(306, 'RO', 'Europe/Bucharest', '2.00', '3.00', '2.00'),
(307, 'RS', 'Europe/Belgrade', '1.00', '2.00', '1.00'),
(308, 'RU', 'Asia/Anadyr', '12.00', '12.00', '12.00'),
(309, 'RU', 'Asia/Irkutsk', '9.00', '9.00', '9.00'),
(310, 'RU', 'Asia/Kamchatka', '12.00', '12.00', '12.00'),
(311, 'RU', 'Asia/Khandyga', '10.00', '10.00', '10.00'),
(312, 'RU', 'Asia/Krasnoyarsk', '8.00', '8.00', '8.00'),
(313, 'RU', 'Asia/Magadan', '12.00', '12.00', '12.00'),
(314, 'RU', 'Asia/Novokuznetsk', '7.00', '7.00', '7.00'),
(315, 'RU', 'Asia/Novosibirsk', '7.00', '7.00', '7.00'),
(316, 'RU', 'Asia/Omsk', '7.00', '7.00', '7.00'),
(317, 'RU', 'Asia/Sakhalin', '11.00', '11.00', '11.00'),
(318, 'RU', 'Asia/Ust-Nera', '11.00', '11.00', '11.00'),
(319, 'RU', 'Asia/Vladivostok', '11.00', '11.00', '11.00'),
(320, 'RU', 'Asia/Yakutsk', '10.00', '10.00', '10.00'),
(321, 'RU', 'Asia/Yekaterinburg', '6.00', '6.00', '6.00'),
(322, 'RU', 'Europe/Kaliningrad', '3.00', '3.00', '3.00'),
(323, 'RU', 'Europe/Moscow', '4.00', '4.00', '4.00'),
(324, 'RU', 'Europe/Samara', '4.00', '4.00', '4.00'),
(325, 'RU', 'Europe/Volgograd', '4.00', '4.00', '4.00'),
(326, 'RW', 'Africa/Kigali', '2.00', '2.00', '2.00'),
(327, 'SA', 'Asia/Riyadh', '3.00', '3.00', '3.00'),
(328, 'SB', 'Pacific/Guadalcanal', '11.00', '11.00', '11.00'),
(329, 'SC', 'Indian/Mahe', '4.00', '4.00', '4.00'),
(330, 'SD', 'Africa/Khartoum', '3.00', '3.00', '3.00'),
(331, 'SE', 'Europe/Stockholm', '1.00', '2.00', '1.00'),
(332, 'SG', 'Asia/Singapore', '8.00', '8.00', '8.00'),
(333, 'SH', 'Atlantic/St_Helena', '0.00', '0.00', '0.00'),
(334, 'SI', 'Europe/Ljubljana', '1.00', '2.00', '1.00'),
(335, 'SJ', 'Arctic/Longyearbyen', '1.00', '2.00', '1.00'),
(336, 'SK', 'Europe/Bratislava', '1.00', '2.00', '1.00'),
(337, 'SL', 'Africa/Freetown', '0.00', '0.00', '0.00'),
(338, 'SM', 'Europe/San_Marino', '1.00', '2.00', '1.00'),
(339, 'SN', 'Africa/Dakar', '0.00', '0.00', '0.00'),
(340, 'SO', 'Africa/Mogadishu', '3.00', '3.00', '3.00'),
(341, 'SR', 'America/Paramaribo', '-3.00', '-3.00', '-3.00'),
(342, 'SS', 'Africa/Juba', '3.00', '3.00', '3.00'),
(343, 'ST', 'Africa/Sao_Tome', '0.00', '0.00', '0.00'),
(344, 'SV', 'America/El_Salvador', '-6.00', '-6.00', '-6.00'),
(345, 'SX', 'America/Lower_Princes', '-4.00', '-4.00', '-4.00'),
(346, 'SY', 'Asia/Damascus', '2.00', '3.00', '2.00'),
(347, 'SZ', 'Africa/Mbabane', '2.00', '2.00', '2.00'),
(348, 'TC', 'America/Grand_Turk', '-5.00', '-4.00', '-5.00'),
(349, 'TD', 'Africa/Ndjamena', '1.00', '1.00', '1.00'),
(350, 'TF', 'Indian/Kerguelen', '5.00', '5.00', '5.00'),
(351, 'TG', 'Africa/Lome', '0.00', '0.00', '0.00'),
(352, 'TH', 'Asia/Bangkok', '7.00', '7.00', '7.00'),
(353, 'TJ', 'Asia/Dushanbe', '5.00', '5.00', '5.00'),
(354, 'TK', 'Pacific/Fakaofo', '13.00', '13.00', '13.00'),
(355, 'TL', 'Asia/Dili', '9.00', '9.00', '9.00'),
(356, 'TM', 'Asia/Ashgabat', '5.00', '5.00', '5.00'),
(357, 'TN', 'Africa/Tunis', '1.00', '1.00', '1.00'),
(358, 'TO', 'Pacific/Tongatapu', '13.00', '13.00', '13.00'),
(359, 'TR', 'Europe/Istanbul', '2.00', '3.00', '2.00'),
(360, 'TT', 'America/Port_of_Spain', '-4.00', '-4.00', '-4.00'),
(361, 'TV', 'Pacific/Funafuti', '12.00', '12.00', '12.00'),
(362, 'TW', 'Asia/Taipei', '8.00', '8.00', '8.00'),
(363, 'TZ', 'Africa/Dar_es_Salaam', '3.00', '3.00', '3.00'),
(364, 'UA', 'Europe/Kiev', '2.00', '3.00', '2.00'),
(365, 'UA', 'Europe/Simferopol', '2.00', '4.00', '4.00'),
(366, 'UA', 'Europe/Uzhgorod', '2.00', '3.00', '2.00'),
(367, 'UA', 'Europe/Zaporozhye', '2.00', '3.00', '2.00'),
(368, 'UG', 'Africa/Kampala', '3.00', '3.00', '3.00'),
(369, 'UM', 'Pacific/Johnston', '-10.00', '-10.00', '-10.00'),
(370, 'UM', 'Pacific/Midway', '-11.00', '-11.00', '-11.00'),
(371, 'UM', 'Pacific/Wake', '12.00', '12.00', '12.00'),
(372, 'US', 'America/Adak', '-10.00', '-9.00', '-10.00'),
(373, 'US', 'America/Anchorage', '-9.00', '-8.00', '-9.00'),
(374, 'US', 'America/Boise', '-7.00', '-6.00', '-7.00'),
(375, 'US', 'America/Chicago', '-6.00', '-5.00', '-6.00'),
(376, 'US', 'America/Denver', '-7.00', '-6.00', '-7.00'),
(377, 'US', 'America/Detroit', '-5.00', '-4.00', '-5.00'),
(378, 'US', 'America/Indiana/Indianapolis', '-5.00', '-4.00', '-5.00'),
(379, 'US', 'America/Indiana/Knox', '-6.00', '-5.00', '-6.00'),
(380, 'US', 'America/Indiana/Marengo', '-5.00', '-4.00', '-5.00'),
(381, 'US', 'America/Indiana/Petersburg', '-5.00', '-4.00', '-5.00'),
(382, 'US', 'America/Indiana/Tell_City', '-6.00', '-5.00', '-6.00'),
(383, 'US', 'America/Indiana/Vevay', '-5.00', '-4.00', '-5.00'),
(384, 'US', 'America/Indiana/Vincennes', '-5.00', '-4.00', '-5.00'),
(385, 'US', 'America/Indiana/Winamac', '-5.00', '-4.00', '-5.00'),
(386, 'US', 'America/Juneau', '-9.00', '-8.00', '-9.00'),
(387, 'US', 'America/Kentucky/Louisville', '-5.00', '-4.00', '-5.00'),
(388, 'US', 'America/Kentucky/Monticello', '-5.00', '-4.00', '-5.00'),
(389, 'US', 'America/Los_Angeles', '-8.00', '-7.00', '-8.00'),
(390, 'US', 'America/Menominee', '-6.00', '-5.00', '-6.00'),
(391, 'US', 'America/Metlakatla', '-8.00', '-8.00', '-8.00'),
(392, 'US', 'America/New_York', '-5.00', '-4.00', '-5.00'),
(393, 'US', 'America/Nome', '-9.00', '-8.00', '-9.00'),
(394, 'US', 'America/North_Dakota/Beulah', '-6.00', '-5.00', '-6.00'),
(395, 'US', 'America/North_Dakota/Center', '-6.00', '-5.00', '-6.00'),
(396, 'US', 'America/North_Dakota/New_Salem', '-6.00', '-5.00', '-6.00'),
(397, 'US', 'America/Phoenix', '-7.00', '-7.00', '-7.00'),
(398, 'US', 'America/Shiprock', '-7.00', '-6.00', '-7.00'),
(399, 'US', 'America/Sitka', '-9.00', '-8.00', '-9.00'),
(400, 'US', 'America/Yakutat', '-9.00', '-8.00', '-9.00'),
(401, 'US', 'Pacific/Honolulu', '-10.00', '-10.00', '-10.00'),
(402, 'UY', 'America/Montevideo', '-2.00', '-3.00', '-3.00'),
(403, 'UZ', 'Asia/Samarkand', '5.00', '5.00', '5.00'),
(404, 'UZ', 'Asia/Tashkent', '5.00', '5.00', '5.00'),
(405, 'VA', 'Europe/Vatican', '1.00', '2.00', '1.00'),
(406, 'VC', 'America/St_Vincent', '-4.00', '-4.00', '-4.00'),
(407, 'VE', 'America/Caracas', '-4.50', '-4.50', '-4.50'),
(408, 'VG', 'America/Tortola', '-4.00', '-4.00', '-4.00'),
(409, 'VI', 'America/St_Thomas', '-4.00', '-4.00', '-4.00'),
(410, 'VN', 'Asia/Ho_Chi_Minh', '7.00', '7.00', '7.00'),
(411, 'VU', 'Pacific/Efate', '11.00', '11.00', '11.00'),
(412, 'WF', 'Pacific/Wallis', '12.00', '12.00', '12.00'),
(413, 'WS', 'Pacific/Apia', '14.00', '13.00', '13.00'),
(414, 'YE', 'Asia/Aden', '3.00', '3.00', '3.00'),
(415, 'YT', 'Indian/Mayotte', '3.00', '3.00', '3.00'),
(416, 'ZA', 'Africa/Johannesburg', '2.00', '2.00', '2.00'),
(417, 'ZM', 'Africa/Lusaka', '2.00', '2.00', '2.00'),
(418, 'ZW', 'Africa/Harare', '2.00', '2.00', '2.00');

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

--
-- Table structure for table `ulinks`
--

CREATE TABLE `ulinks` (
  `id` bigint UNSIGNED NOT NULL,
  `language_id` int NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ulinks`
--

INSERT INTO `ulinks` (`id`, `language_id`, `name`, `url`) VALUES
(12, 170, 'Designer de Web', 'https://megasoft.biz/plusagency/services?category=9'),
(13, 170, 'Desenvolvimento web', 'https://megasoft.biz/plusagency/services?category=10'),
(14, 170, 'Design gráfico', 'https://megasoft.biz/plusagency/services?category=11'),
(15, 170, 'Aplicativos móveis', 'https://megasoft.biz/plusagency/services?category=12'),
(16, 170, 'Desenvolvimento de Plugins', 'https://megasoft.biz/plusagency/services?category=13'),
(17, 170, 'Marketing SEO', 'https://megasoft.biz/plusagency/services?category=14'),
(18, 169, 'Web Design', 'https://megasoft.biz/plusagency/services?category=9'),
(19, 169, 'Web Development', 'https://megasoft.biz/plusagency/services?category=10'),
(20, 169, 'Graphic Design', 'https://megasoft.biz/plusagency/services?category=11'),
(21, 169, 'Mobile Apps', 'https://megasoft.biz/plusagency/services?category=12'),
(22, 169, 'Plugin Development', 'https://megasoft.biz/plusagency/services?category=13'),
(23, 169, 'Marketing SEO', 'https://megasoft.biz/plusagency/services?category=14'),
(24, 171, 'Web Design', 'https://megasoft.biz/plusagency/services?category=9'),
(25, 171, 'Web Development', 'https://megasoft.biz/plusagency/services?category=10'),
(26, 171, 'Graphic Design', 'https://megasoft.biz/plusagency/services?category=11'),
(27, 171, 'Mobile Apps', 'https://megasoft.biz/plusagency/services?category=12'),
(28, 171, 'Plugin Development', 'https://megasoft.biz/plusagency/services?category=13'),
(29, 171, 'Marketing SEO', 'https://megasoft.biz/plusagency/services?category=14'),
(30, 173, 'تصميم المواقع', 'https://megasoft.biz/plusagency/services?category=9'),
(31, 173, 'تطوير الشبكة', 'https://megasoft.biz/plusagency/services?category=10'),
(32, 173, 'التصميم الجرافيكي', 'https://megasoft.biz/plusagency/services?category=11'),
(33, 173, 'تطبيقات الموبايل', 'https://megasoft.biz/plusagency/services?category=12'),
(34, 173, 'تطوير البرنامج المساعد', 'https://megasoft.biz/plusagency/services?category=13'),
(35, 173, 'كبار المسئولين الاقتصاديين والتسويق', 'https://megasoft.biz/plusagency/services?category=14');

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

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

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `fname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_fname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_lname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shpping_fname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shpping_lname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shpping_photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shpping_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shpping_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shpping_city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shpping_state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shpping_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shpping_country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0',
  `verification_link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `email_verified` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `provider` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `fname`, `lname`, `photo`, `username`, `email`, `password`, `number`, `city`, `state`, `address`, `country`, `remember_token`, `billing_fname`, `billing_lname`, `billing_photo`, `billing_email`, `billing_number`, `billing_city`, `billing_state`, `billing_address`, `billing_country`, `shpping_fname`, `shpping_lname`, `shpping_photo`, `shpping_email`, `shpping_number`, `shpping_city`, `shpping_state`, `shpping_address`, `shpping_country`, `created_at`, `updated_at`, `status`, `verification_link`, `email_verified`, `provider`, `provider_id`) VALUES
(26, 'John', 'Doe', '1619252606talha.jpg', 'user', 'user@gmail.com', '$2y$10$w8FlH.d8VJDM31R16dtsgeUgQXiGz4KqYxDfHOoAIeRdnKx36vxsK', '2723724', 'Melbourne', 'Melbourne', 'Melbourne, Austalia', 'Australia', NULL, 'John', 'Doe', NULL, 'geniustest11@gmail.com', '262332', 'Melbourne', 'Melbourne', 'Melbourne, Australia', 'Australia', 'John', 'Doe', NULL, 'geniustest11@gmail.com', '3636237', 'Melbourne', 'Melbourne', 'Melbourne, Australia', 'Australia', '2021-04-19 04:11:34', '2021-04-24 04:23:26', 1, '17f6f95b0054bae875c7e760134bf9d4', 'Yes', NULL, NULL),
(27, NULL, NULL, NULL, 'fahadahmadshemul', 'fahadahmadshemul@gmail.com', '$2y$10$yiTZDIWOnHd3L7DG52SVRe82Iyc2m0nliqoXf3xy6sN.7ZbFDqlIu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-09-16 05:32:57', '2023-09-16 05:33:33', 1, '95f8d88a332745cd2172a0382a5065cf', 'Yes', NULL, NULL);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `donations`
--
ALTER TABLE `donations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `donations_lang_id_foreign` (`lang_id`);

--
-- Indexes for table `donation_details`
--
ALTER TABLE `donation_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `donation_details_donation_id_foreign` (`donation_id`);

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

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `events_lang_id_foreign` (`lang_id`),
  ADD KEY `events_cat_id_foreign` (`cat_id`);

--
-- Indexes for table `event_categories`
--
ALTER TABLE `event_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `event_categories_lang_id_foreign` (`lang_id`);

--
-- Indexes for table `event_details`
--
ALTER TABLE `event_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `event_details_event_id_foreign` (`event_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=296;

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `donations`
--
ALTER TABLE `donations`
  ADD CONSTRAINT `donations_lang_id_foreign` FOREIGN KEY (`lang_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `donation_details`
--
ALTER TABLE `donation_details`
  ADD CONSTRAINT `donation_details_donation_id_foreign` FOREIGN KEY (`donation_id`) REFERENCES `donations` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `events`
--
ALTER TABLE `events`
  ADD CONSTRAINT `events_cat_id_foreign` FOREIGN KEY (`cat_id`) REFERENCES `event_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `events_lang_id_foreign` FOREIGN KEY (`lang_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `event_categories`
--
ALTER TABLE `event_categories`
  ADD CONSTRAINT `event_categories_lang_id_foreign` FOREIGN KEY (`lang_id`) REFERENCES `languages` (`id`);

--
-- Constraints for table `event_details`
--
ALTER TABLE `event_details`
  ADD CONSTRAINT `event_details_event_id_foreign` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE;

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

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

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

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

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

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

