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

START TRANSACTION;



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

--
-- Table structure for table `areas`
--

CREATE TABLE `areas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `area_name` varchar(255) NOT NULL,
  `post_code` varchar(255) 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 `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `blog_image` varchar(255) DEFAULT NULL,
  `blog_image_driver` varchar(255) DEFAULT NULL,
  `breadcrumb_status` varchar(255) DEFAULT NULL,
  `breadcrumb_image` varchar(255) DEFAULT NULL,
  `breadcrumb_image_driver` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `page_title` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `meta_image` varchar(255) DEFAULT NULL,
  `meta_image_driver` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `blogs` (`id`, `slug`, `category_id`, `blog_image`, `blog_image_driver`, `breadcrumb_status`, `breadcrumb_image`, `breadcrumb_image_driver`, `status`, `page_title`, `meta_title`, `meta_keywords`, `meta_description`, `meta_image`, `meta_image_driver`, `created_at`, `updated_at`) VALUES
(1, 'desire-to-invest-in-gold-market-at-an-all-time-low', 3, '/2eXi6x06DqPzqXcBlRZh0K8AqmwgHg.webp', 'local', '1', '/cUiKUSSr8BQc2cLaEywPjXndPCAvLj.jpg', 'local', 1, 'Blog Details', 'Blog Details', '[\"Blog Details\"]', 'Blog Details', 'pageSeo/btzx5jpreMVG4lRJNlDoEjMHJLZ4MM.webp', 'local', '2025-01-23 19:02:51', '2025-01-23 19:02:51'),
(2, 'investing-in-the-transition-to-a-low-carbon-economy', 2, '/rgT1Y7fX41ce4KpJQ3iPI2zuipoyLk.webp', 'local', '1', '/0kz7XHDwwScNqdmV2NUdNjzgTZZSQh.jpg', 'local', 1, 'Blog Details', 'Blog Details', '[\"Blog Details\"]', 'Blog Details', 'pageSeo/ZuZMQrrjqRZcB6QkI3RyZfmy3sK9Wi.webp', 'local', '2025-01-19 04:58:30', '2025-01-19 04:58:30'),
(3, 'weekly-market-commentary-at-an-all-time-low', 2, '/gnyiZMeRv82lHkVBAMO7MC05nEGkAd.webp', 'local', '1', '/SmvHQiEc32IwZaUXL2mzFROG6BvoPU.jpg', 'local', 1, 'Blog Details', 'Blog Details', '[\"Blog Details\"]', 'Blog Details', 'pageSeo/6RTENlEjlUmm5jUI1ngBjTiavXY6tR.webp', 'local', '2025-01-03 10:32:09', '2025-01-03 10:32:09');

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

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

CREATE TABLE `blog_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `slug` varchar(100) 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 `blog_categories`
--

INSERT INTO `blog_categories` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES
(1, 'Business', 'business', '2025-01-28 00:43:43', '2025-01-28 00:43:43'),
(2, 'Investment', 'investment', '2025-01-27 21:34:35', '2025-01-27 21:34:35'),
(3, 'Gold Markets', 'gold-markets', '2025-01-16 10:23:37', '2025-01-16 10:23:37'),
(4, 'Asset', 'asset', '2025-01-18 23:59:08', '2025-01-18 23:59:08');

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

--
-- Table structure for table `blog_details`
--

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

INSERT INTO `blog_details` (`id`, `blog_id`, `language_id`, `title`, `description`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'Desire to Invest in Gold Market at an All-Time Low', '<p style=\"font-size:18px;\">Investing can seem daunting, especially for beginners. With so many options available, it’s easy to feel overwhelmed. However, understanding the basics of investing is the first step toward building long-term wealth. In this guide, we’ll break down the key concepts and provide practical tips to get you started on your investment journey.</p><p style=\"font-size:18px;\">Historically, gold has averaged annual returns of approximately 7-8% over the long term. While past performance is not indicative of future results, many investors consider gold a reliable component of a diversified investment portfolio.</p><p style=\"font-size:18px;\"><span style=\"color:rgb(68,68,68);\">Investing in gold can be a smart way to diversify your portfolio and safeguard your wealth. With our dedicated gold investment platform, you have all the tools you need to make informed decisions and grow your investments. Start your journey into gold investing today! Gold Investa</span></p><p style=\"font-size:18px;\"><span style=\"color:rgb(68,68,68);\"><br></span></p><p style=\"font-size:18px;\"><span style=\"color:rgb(68,68,68);\">In times of economic uncertainty, gold has long been considered a safe haven for investors. Whether you’re a seasoned investor or just starting out, understanding the benefits of gold investment can help diversify your portfolio and protect your wealth. In this blog post, we’ll explore the advantages of investing in gold and how our platform can make it easier for you to enter this precious market.</span><span style=\"color:rgb(68,68,68);\"></span></p>', '2025-01-24 00:24:00', '2025-01-24 00:24:00'),
(2, 2, 1, 'Investing in the transition to a low-carbon economy', '<p style=\"font-size:18px;\">Investing can seem daunting, especially for beginners. With so many options available, it’s easy to feel overwhelmed. However, understanding the basics of investing is the first step toward building long-term wealth. In this guide, we’ll break down the key concepts and provide practical tips to get you started on your investment journey.</p><p style=\"font-size:18px;\">Historically, gold has averaged annual returns of approximately 7-8% over the long term. While past performance is not indicative of future results, many investors consider gold a reliable component of a diversified investment portfolio.</p><p style=\"font-size:18px;\"><br></p><p style=\"font-size:18px;\"><span style=\"color:rgb(68,68,68);\">nvesting in gold can be a smart way to diversify your portfolio and safeguard your wealth. With our dedicated gold investment platform, you have all the tools you need to make informed decisions and grow your investments. Start your journey into gold investing today! Gold Investa.</span></p>', '2025-01-07 10:40:54', '2025-01-07 10:40:54'),
(3, 3, 1, 'Weekly market commentary at an All-Time Low', '<p style=\"font-size:18px;\">Investing can seem daunting, especially for beginners. With so many options available, it’s easy to feel overwhelmed. However, understanding the basics of investing is the first step toward building long-term wealth. In this guide, we’ll break down the key concepts and provide practical tips to get you started on your investment journey.</p><p style=\"font-size:18px;\">Historically, gold has averaged annual returns of approximately 7-8% over the long term. While past performance is not indicative of future results, many investors consider gold a reliable component of a diversified investment portfolio.</p><p style=\"font-size:18px;\"><span style=\"color:rgb(68,68,68);\">Investing in gold can be a smart way to diversify your portfolio and safeguard your wealth. With our dedicated gold investment platform, you have all the tools you need to make informed decisions and grow your investments. Start your journey into gold investing today! Gold Investa.</span></p>', '2025-01-27 12:03:13', '2025-01-27 12:03:13');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL 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 `contents`
--

CREATE TABLE `contents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `media` text 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 `contents`
--

INSERT INTO `contents` (`id`, `name`, `type`, `media`, `created_at`, `updated_at`) VALUES
(1, 'banner_section', 'single', '{\"image\":{\"path\":\"contents\\/KT6LWTl5jlzll9ABCQffLFJidzEXiy.webp\",\"driver\":\"local\"},\"powered_by\":{\"path\":\"contents\\/bsIrPhUvK154gpNr5DA0y1lmRWXJTK.webp\",\"driver\":\"local\"},\"background_image\":{\"path\":\"contents\\/MMxnabHFIVY2wReI3gNmqF7RKfLEPm.webp\",\"driver\":\"local\"},\"invest_card_image\":{\"path\":\"contents\\/oJBNZgHOfQqEVoYAShyfSAcUDYbnvJ.webp\",\"driver\":\"local\"},\"button_url\":\"https:\\/\\/bullion.bugfinder.app\\/\",\"number_of_ratings\":\"4.5\",\"client_image_1\":{\"path\":\"contents\\/JU1x1rsHAF5VeO4bPGng6fkoVyRVUE.webp\",\"driver\":\"local\"},\"client_image_2\":{\"path\":\"contents\\/NsXGlRR0mAT6qEH5DDmxsFLlPKhJud.webp\",\"driver\":\"local\"},\"client_image_3\":{\"path\":\"contents\\/jlx8y85QopzhOrGim67joalGzkAkzY.webp\",\"driver\":\"local\"},\"rotate_image\":{\"path\":\"contents\\/Nw4Au3ZgrieugnRtf3K7OqDl9CJrcu.webp\",\"driver\":\"local\"}}', '2025-01-21 12:37:28', '2025-02-05 05:17:02'),
(2, 'banner_section', 'multiple', '{\"brand\":{\"path\":\"contents\\/N7rbIoIcwbUkLjzF80qMqub9OZcZT9.webp\",\"driver\":\"local\"}}', '2025-01-27 02:12:54', '2025-01-27 02:12:54'),
(3, 'banner_section', 'multiple', '{\"brand\":{\"path\":\"contents\\/4rrkMJz8lQMenE1MJL4KvRMjjEYMc2.webp\",\"driver\":\"local\"}}', '2025-01-22 15:21:38', '2025-01-22 15:21:38'),
(4, 'banner_section', 'multiple', '{\"brand\":{\"path\":\"contents\\/ETIcdUdcE0aZrwvNFYfwv1EUXL9Z5g.webp\",\"driver\":\"local\"}}', '2025-01-24 14:42:16', '2025-01-24 14:42:16'),
(5, 'banner_section', 'multiple', '{\"brand\":{\"path\":\"contents\\/dLrqU5HrSWadgBFSKJpRae5jVy30qO.webp\",\"driver\":\"local\"}}', '2025-01-13 18:50:01', '2025-01-13 18:50:01'),
(6, 'banner_section', 'multiple', '{\"brand\":{\"path\":\"contents\\/tLu9L14GJJYF6FEDloX7r5FtEbOe27.webp\",\"driver\":\"local\"}}', '2025-01-21 07:03:25', '2025-01-21 07:03:25'),
(7, 'banner_section', 'multiple', '{\"brand\":{\"path\":\"contents\\/tNQUOuCMewNDhCC7OYFB7gWT70adiY.webp\",\"driver\":\"local\"}}', '2025-01-11 10:50:45', '2025-01-11 10:50:45'),
(8, 'footer_section', 'single', NULL, '2025-01-18 14:32:36', '2025-01-18 14:32:36'),
(9, 'footer_section', 'multiple', '{\"link\":\"https:\\/\\/www.facebook.com\\/\",\"icon\":\"fa-brands fa-facebook-f\"}', '2025-01-12 08:00:29', '2025-01-12 08:00:29'),
(10, 'footer_section', 'multiple', '{\"link\":\"https:\\/\\/x.com\\/\",\"icon\":\"icon-twiter\"}', '2025-01-16 23:07:09', '2025-01-16 23:07:09'),
(11, 'footer_section', 'multiple', '{\"link\":\"https:\\/\\/www.instagram.com\\/\",\"icon\":\"fa-brands fa-instagram\"}', '2025-01-25 22:26:05', '2025-01-25 22:26:05'),
(12, 'footer_section', 'multiple', '{\"link\":\"https:\\/\\/www.linkedin.com\\/\",\"icon\":\"fa-brands fa-linkedin-in\"}', '2025-01-13 23:30:20', '2025-01-13 23:30:20'),
(13, 'about_section', 'single', '{\"optional_link\":\"https:\\/\\/bullion.bugfinder.app\\/\",\"about_image_1\":{\"path\":\"contents\\/4vTKMCDynDZLCmQ7YP8lXmc5hAJ8ji.webp\",\"driver\":\"local\"},\"about_image_2\":{\"path\":\"contents\\/Ptpajfp9uek2IZw8lbpIj6lKnxZbFm.webp\",\"driver\":\"local\"}}', '2025-01-04 03:32:41', '2025-01-29 04:09:25'),
(14, 'about_section', 'multiple', '{\"icon\":\"fa-light fa-wallet\"}', '2025-01-12 11:48:07', '2025-01-12 11:48:07'),
(15, 'about_section', 'multiple', '{\"icon\":\"fa-thin fa-house-person-leave\"}', '2025-01-20 04:01:04', '2025-01-20 04:01:04'),
(16, 'why_choose_us_section', 'single', NULL, '2025-01-16 21:14:27', '2025-01-16 21:14:27'),
(17, 'why_choose_us_section', 'multiple', '{\"image\":{\"path\":\"contents\\/ENEs0dPdDqBUUkUs5fgcctyM8HJxXx.webp\",\"driver\":\"local\"}}', '2025-01-27 23:12:27', '2025-01-27 23:12:27'),
(18, 'why_choose_us_section', 'multiple', '{\"image\":{\"path\":\"contents\\/SMy4LfeegcTXv4WLJKbUpwi8OlB11z.webp\",\"driver\":\"local\"}}', '2025-01-21 21:13:55', '2025-01-21 21:13:55'),
(19, 'why_choose_us_section', 'multiple', '{\"image\":{\"path\":\"contents\\/trL6tDDKYb3chWzmpwGbgVBnGiiwN0.webp\",\"driver\":\"local\"}}', '2025-01-15 06:56:15', '2025-01-15 06:56:15'),
(20, 'why_choose_us_section', 'multiple', '{\"image\":{\"path\":\"contents\\/yAkUHGEKCuIDVgUAsq9CRtTNFthVZW.webp\",\"driver\":\"local\"}}', '2025-01-15 08:08:29', '2025-01-15 08:08:29'),
(21, 'investment_process_section', 'single', '{\"image\":{\"path\":\"contents\\/RkQK49xMlQaQEKu4sTYLum3JWMei7u.webp\",\"driver\":\"local\"}}', '2025-01-10 13:30:31', '2025-01-10 13:30:31'),
(22, 'investment_process_section', 'multiple', '{\"image\":{\"path\":\"contents\\/kqoUNNWcm8sX6VG5PsHaJyZM68WUYQ.webp\",\"driver\":\"local\"}}', '2025-01-16 20:02:25', '2025-01-16 20:02:25'),
(23, 'investment_process_section', 'multiple', '{\"image\":{\"path\":\"contents\\/QUUdG4CxrLvbyyFzunb4jrDln55hmv.webp\",\"driver\":\"local\"}}', '2025-01-01 07:49:52', '2025-01-01 07:49:52'),
(24, 'investment_process_section', 'multiple', '{\"image\":{\"path\":\"contents\\/w0ZOMluYiqdvZTS5wlI6ha5YJl42SP.webp\",\"driver\":\"local\"}}', '2025-01-20 20:11:32', '2025-01-20 20:11:32'),
(25, 'investment_process_section', 'multiple', '{\"image\":{\"path\":\"contents\\/RBvz3WRNTz4IEHaLk2Znbpd2K6g9B4.webp\",\"driver\":\"local\"}}', '2025-01-05 19:02:53', '2025-01-05 19:02:53'),
(26, 'pricing_section', 'single', NULL, '2025-01-06 22:19:28', '2025-01-06 22:19:28'),
(27, 'counter_section', 'multiple', '{\"count\":\"50\"}', '2025-01-25 17:13:14', '2025-01-25 17:13:14'),
(28, 'counter_section', 'multiple', '{\"count\":\"20\"}', '2025-01-14 08:31:17', '2025-01-14 08:31:17'),
(29, 'counter_section', 'multiple', '{\"count\":\"92\"}', '2025-01-17 07:20:09', '2025-01-17 07:20:09'),
(30, 'counter_section', 'multiple', '{\"count\":\"2\"}', '2025-01-27 09:35:41', '2025-01-27 09:35:41'),
(31, 'calculation_section', 'single', '{\"banner_button_link\":\"https:\\/\\/bullion.bugfinder.app\\/\",\"banner_image\":{\"path\":\"contents\\/rPPJOQzjEWtWjRj7zIc9OeW76UgDve.webp\",\"driver\":\"local\"}}', '2025-01-12 06:26:51', '2025-01-29 04:10:24'),
(32, 'calculation_section', 'multiple', NULL, '2025-01-20 10:31:28', '2025-01-20 10:31:28'),
(33, 'calculation_section', 'multiple', NULL, '2025-01-11 01:18:35', '2025-01-11 01:18:35'),
(34, 'calculation_section', 'multiple', NULL, '2025-01-20 02:34:33', '2025-01-20 02:34:33'),
(35, 'testimonial_section', 'single', NULL, '2025-01-19 23:11:07', '2025-01-19 23:11:07'),
(36, 'testimonial_section', 'multiple', '{\"image\":{\"path\":\"contents\\/HznUtOvhtfwGSHQvevrISB6A4GPRjz.webp\",\"driver\":\"local\"},\"rating\":\"4\"}', '2025-01-13 08:49:06', '2025-01-13 08:49:06'),
(37, 'testimonial_section', 'multiple', '{\"image\":{\"path\":\"contents\\/VRTAf9vEV1BMcPvKzwgSGzgcEkvKEF.webp\",\"driver\":\"local\"},\"rating\":\"4.5\"}', '2025-01-17 15:36:03', '2025-01-17 15:36:03'),
(38, 'blog_section', 'single', '{\"button_url\":\"https:\\/\\/bullion.bugfinder.app\\/\"}', '2025-01-08 12:21:16', '2025-01-29 04:11:00'),
(39, 'faq_section', 'single', NULL, '2025-01-27 23:22:38', '2025-01-27 23:22:38'),
(40, 'faq_section', 'multiple', NULL, '2025-01-22 10:22:32', '2025-01-22 10:22:32'),
(41, 'faq_section', 'multiple', NULL, '2025-01-08 08:29:02', '2025-01-08 08:29:02'),
(42, 'faq_section', 'multiple', NULL, '2025-01-21 23:36:28', '2025-01-21 23:36:28'),
(43, 'faq_section', 'multiple', NULL, '2025-01-22 22:25:40', '2025-01-22 22:25:40'),
(44, 'faq_section', 'multiple', NULL, '2025-01-10 16:09:30', '2025-01-10 16:09:30'),
(45, 'contact_section', 'single', '{\"image\":{\"path\":\"contents\\/kRe8952rfx9Wv5eR0KmxztFcr55uv8.webp\",\"driver\":\"local\"},\"background_image\":{\"path\":\"contents\\/FzSIqtoXuq2VGFlQ8cpNYeO9u6S4Rj.webp\",\"driver\":\"local\"},\"location_url\":\"https:\\/\\/www.google.com\\/maps\\/embed?pb=!1m18!1m12!1m3!1d3794.7464974489885!2d-76.78954868894601!3d17.990527382932257!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x8edb3f99153ffd73%3A0x1a47c174dfaee316!2sManhattan%20Rd%2C%20Kingston%2C%20Jamaica!5e0!3m2!1sen!2sbd!4v1726729158163!5m2!1sen!2sbd\"}', '2025-01-01 09:24:17', '2025-02-01 23:50:01'),
(46, 'login_section', 'single', '{\"image\":{\"path\":\"contents\\/G5CcwhFu4xMABD69l5lS1qFdRuWIle.webp\",\"driver\":\"local\"},\"button_url\":\"https:\\/\\/bullion.bugfinder.app\\/\"}', '2025-01-27 05:11:18', '2025-01-29 04:06:16'),
(47, 'register_section', 'single', '{\"image\":{\"path\":\"contents\\/F0crOQIe4hvuy1Y2zWqeCbsTGdVywi.webp\",\"driver\":\"local\"},\"button_url\":\"https:\\/\\/bullion.bugfinder.app\\/\"}', '2025-01-22 12:52:51', '2025-01-29 04:06:32'),
(48, 'banner_section_two', 'single', '{\"image\":{\"path\":\"contents\\/yOn61r7HhViwO6tnkIrBbdUu9Dsv1N.webp\",\"driver\":\"local\"},\"button_url\":\"https:\\/\\/bullion.bugfinder.app\\/\",\"video_url\":\"https:\\/\\/www.youtube.com\\/watch?v=668nUCeBHyY\"}', '2025-01-27 01:06:22', '2025-01-29 04:09:16'),
(49, 'banner_section_two', 'multiple', '{\"reviewer\":{\"path\":\"contents\\/P1ii7vOc5Uyd4rs8HrX8YmhoRuK0NS.webp\",\"driver\":\"local\"}}', '2025-01-08 23:03:06', '2025-01-08 23:03:06'),
(50, 'banner_section_two', 'multiple', '{\"reviewer\":{\"path\":\"contents\\/8iV1hrhlmqEMpO3Yc8tsRMLog1ZwsO.webp\",\"driver\":\"local\"}}', '2025-01-14 06:05:12', '2025-01-14 06:05:12'),
(51, 'banner_section_two', 'multiple', '{\"reviewer\":{\"path\":\"contents\\/WR8GcTM4KFRFO92jHpjxw6OBxBn3PL.webp\",\"driver\":\"local\"}}', '2025-01-26 21:07:22', '2025-01-26 21:07:22'),
(52, 'why_choose_us_section_two', 'single', NULL, '2025-01-14 06:47:11', '2025-01-14 06:47:11'),
(53, 'why_choose_us_section_two', 'multiple', '{\"image\":{\"path\":\"contents\\/34uKSru2hgnEVW4Sl5Bb8gW6fYxZSl.webp\",\"driver\":\"local\"}}', '2025-01-18 02:07:44', '2025-01-18 02:07:44'),
(54, 'why_choose_us_section_two', 'multiple', '{\"image\":{\"path\":\"contents\\/kdqWgBcHgRUKWCoQCWXVIvSw8GXN58.webp\",\"driver\":\"local\"}}', '2025-01-16 13:54:35', '2025-01-16 13:54:35'),
(55, 'why_choose_us_section_two', 'multiple', '{\"image\":{\"path\":\"contents\\/t03XfJaisj6oyetLt7gOE0jo701TiU.webp\",\"driver\":\"local\"}}', '2025-01-11 15:20:16', '2025-01-11 15:20:16'),
(56, 'why_choose_us_section_two', 'multiple', '{\"image\":{\"path\":\"contents\\/p3MRJpImQsQ1n6LyHLfuLghEHRfGrm.webp\",\"driver\":\"local\"}}', '2025-01-04 10:09:05', '2025-01-04 10:09:05'),
(57, 'about_section_two', 'single', '{\"button_url\":\"https:\\/\\/bullion.bugfinder.app\\/\",\"banner_image\":{\"path\":\"contents\\/GfKFkc0rUPuLwLrKZY98kzaBaOY1wc.webp\",\"driver\":\"local\"},\"banner_icon\":{\"path\":\"contents\\/o28WsPTCQDU088Q8Hq2KkVWtTl4fV7.webp\",\"driver\":\"local\"}}', '2025-01-03 14:49:50', '2025-01-29 04:09:31'),
(58, 'about_section_two', 'multiple', '{\"icon\":\"fa-light fa-wallet\"}', '2025-01-02 15:37:02', '2025-01-02 15:37:02'),
(59, 'about_section_two', 'multiple', '{\"icon\":\"fa-thin fa-house-person-leave\"}', '2025-01-09 20:40:49', '2025-01-09 20:40:49'),
(60, 'counter_section_two', 'single', NULL, '2025-01-21 16:34:06', '2025-01-21 16:34:06'),
(61, 'counter_section_two', 'multiple', '{\"count\":\"50\"}', '2025-01-04 09:37:29', '2025-01-04 09:37:29'),
(62, 'counter_section_two', 'multiple', '{\"count\":\"20\"}', '2025-01-01 06:38:24', '2025-01-01 06:38:24'),
(63, 'counter_section_two', 'multiple', '{\"count\":\"92\"}', '2025-01-06 14:11:31', '2025-01-06 14:11:31'),
(64, 'counter_section_two', 'multiple', '{\"count\":\"2\"}', '2025-01-25 12:33:49', '2025-01-25 12:33:49'),
(65, 'pricing_section_two', 'single', NULL, '2025-01-12 17:17:50', '2025-01-12 17:17:50'),
(66, 'product_section', 'single', '{\"banner_button_link\":\"https:\\/\\/bullion.bugfinder.app\\/\",\"banner_image\":{\"path\":\"contents\\/CAz3pzydobBneaZmith6PAZU8JxjvD.webp\",\"driver\":\"local\"}}', '2025-01-12 21:29:06', '2025-01-29 04:10:48'),
(67, 'investment_process_section_two', 'single', NULL, '2025-01-06 11:11:13', '2025-01-06 11:11:13'),
(68, 'investment_process_section_two', 'multiple', NULL, '2025-01-20 11:14:55', '2025-01-20 11:14:55'),
(69, 'investment_process_section_two', 'multiple', NULL, '2025-01-06 12:50:38', '2025-01-06 12:50:38'),
(70, 'investment_process_section_two', 'multiple', NULL, '2025-01-12 06:08:08', '2025-01-12 06:08:08'),
(71, 'investment_process_section_two', 'multiple', NULL, '2025-01-02 14:45:41', '2025-01-02 14:45:41'),
(72, 'testimonial_section_two', 'single', NULL, '2025-01-02 00:38:20', '2025-01-02 00:38:20'),
(73, 'testimonial_section_two', 'multiple', '{\"image\":{\"path\":\"contents\\/j6bkPYRDkLURHWkQMFwrmEMlktBPdR.webp\",\"driver\":\"local\"},\"rating\":\"4.5\"}', '2025-01-21 21:00:38', '2025-01-21 21:00:38'),
(74, 'testimonial_section_two', 'multiple', '{\"image\":{\"path\":\"contents\\/iXGs0Q5o1B2vEAntr3sKyqLRrIBzx7.webp\",\"driver\":\"local\"},\"rating\":\"5\"}', '2025-01-05 13:30:33', '2025-01-05 13:30:33'),
(75, 'testimonial_section_two', 'multiple', '{\"image\":{\"path\":\"contents\\/B8CIVcYOgdybmwOmuODhsxD7e6esQG.webp\",\"driver\":\"local\"},\"rating\":\"5\"}', '2025-01-25 18:45:08', '2025-01-25 18:45:08'),
(76, 'blog_section_two', 'single', NULL, '2025-01-20 00:44:00', '2025-01-20 00:44:00'),
(77, 'cookie_policy', 'multiple', NULL, '2025-01-13 14:59:17', '2025-01-13 14:59:17'),
(78, 'cookie_policy', 'multiple', NULL, '2025-01-11 21:55:24', '2025-01-11 21:55:24'),
(79, 'cookie_policy', 'multiple', NULL, '2025-01-25 12:03:02', '2025-01-25 12:03:02'),
(80, 'cookie_policy', 'multiple', NULL, '2025-01-24 08:49:52', '2025-01-24 08:49:52'),
(81, 'cookie_policy', 'multiple', NULL, '2025-01-08 15:33:51', '2025-01-08 15:33:51'),
(82, 'cookie_policy', 'multiple', NULL, '2025-01-19 02:36:41', '2025-01-19 02:36:41'),
(83, 'cookie_policy', 'multiple', NULL, '2025-01-13 15:02:39', '2025-01-13 15:02:39'),
(84, 'cookie_policy', 'multiple', NULL, '2025-01-24 09:22:24', '2025-01-24 09:22:24'),
(85, 'terms_condition', 'multiple', NULL, '2025-01-04 13:46:43', '2025-01-04 13:46:43'),
(86, 'terms_condition', 'multiple', NULL, '2025-01-09 19:54:29', '2025-01-09 19:54:29'),
(87, 'terms_condition', 'multiple', NULL, '2025-01-04 16:05:22', '2025-01-04 16:05:22'),
(88, 'terms_condition', 'multiple', NULL, '2025-01-26 08:23:33', '2025-01-26 08:23:33'),
(89, 'terms_condition', 'multiple', NULL, '2025-01-12 06:47:18', '2025-01-12 06:47:18'),
(90, 'terms_condition', 'multiple', NULL, '2025-01-24 06:08:56', '2025-01-24 06:08:56'),
(91, 'terms_condition', 'multiple', NULL, '2025-01-03 06:39:48', '2025-01-03 06:39:48'),
(92, 'terms_condition', 'multiple', NULL, '2025-01-19 21:37:59', '2025-01-19 21:37:59'),
(93, 'privacy_policy', 'multiple', NULL, '2025-01-17 21:53:41', '2025-01-17 21:53:41'),
(94, 'privacy_policy', 'multiple', NULL, '2025-01-09 13:49:25', '2025-01-09 13:49:25'),
(95, 'privacy_policy', 'multiple', NULL, '2025-01-22 02:32:57', '2025-01-22 02:32:57'),
(96, 'privacy_policy', 'multiple', NULL, '2025-01-23 21:41:58', '2025-01-23 21:41:58'),
(97, 'privacy_policy', 'multiple', NULL, '2025-01-03 09:32:40', '2025-01-03 09:32:40'),
(98, 'privacy_policy', 'multiple', NULL, '2025-01-04 04:25:02', '2025-01-04 04:25:02'),
(99, 'privacy_policy', 'multiple', NULL, '2025-01-22 08:42:05', '2025-01-22 08:42:05'),
(100, 'privacy_policy', 'multiple', NULL, '2025-01-15 23:40:14', '2025-01-15 23:40:14'),
(101, 'pwa_popup', 'single', '{\"icon_image\":{\"path\":\"contents\\/862euvDXDMcA2KlWYFUBSb37M2YIbl.webp\",\"driver\":\"local\"}}', '2025-01-08 05:18:55', '2025-01-29 06:20:33'),
(102, 'pwa_popup', 'multiple', NULL, '2025-01-17 17:23:18', '2025-01-17 17:23:18'),
(107, 'pwa_popup', 'multiple', '{\"carousel_image\":{\"path\":\"contents\\/4U6wFnbzvzKTQJwGmaVdtIftaWRwkq.webp\",\"driver\":\"local\"}}', '2025-01-29 04:04:37', '2025-01-29 04:04:37'),
(108, 'pwa_popup', 'multiple', '{\"carousel_image\":{\"path\":\"contents\\/jndwhWm8QnCf6qIH1abCFykBmFZrN5.webp\",\"driver\":\"local\"}}', '2025-01-29 04:04:42', '2025-01-29 04:04:42'),
(109, 'pwa_popup', 'multiple', '{\"carousel_image\":{\"path\":\"contents\\/iLPYUrul1esDdiWKzf95sI3RKo0QXq.webp\",\"driver\":\"local\"}}', '2025-01-29 04:04:46', '2025-01-29 04:04:46'),
(110, 'pwa_popup', 'multiple', '{\"carousel_image\":{\"path\":\"contents\\/5okSNADXCceHPM6idO9ZTGfVzJRmdh.webp\",\"driver\":\"local\"}}', '2025-01-29 04:04:49', '2025-01-29 04:04:49');

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

--
-- Table structure for table `content_details`
--

CREATE TABLE `content_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `content_id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `description` longtext 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 `content_details`
--

INSERT INTO `content_details` (`id`, `content_id`, `language_id`, `description`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '{\"title\":\"Invest in Gold Grow Your Future Finances Most\",\"description\":\"Invest and vault precious metals in multiple Plans. Rest easy knowing your wealth is secure and outside of traditional banking systems. Offers a high-end solution enabling individuals.\",\"button\":\"Get Started\",\"heading\":\"Powered By\"}', '2025-01-06 06:11:28', '2025-01-06 06:11:28'),
(2, 2, 1, NULL, '2025-01-02 13:16:30', '2025-01-02 13:16:30'),
(3, 3, 1, NULL, '2025-01-09 07:58:08', '2025-01-09 07:58:08'),
(4, 4, 1, NULL, '2025-01-09 11:28:05', '2025-01-09 11:28:05'),
(5, 5, 1, NULL, '2025-01-20 11:58:26', '2025-01-20 11:58:26'),
(6, 6, 1, NULL, '2025-01-06 02:48:22', '2025-01-06 02:48:22'),
(7, 7, 1, NULL, '2025-01-26 05:34:55', '2025-01-26 05:34:55'),
(8, 8, 1, '{\"short_description\":\"The personal portfolio category includes website or physical displays\",\"phone\":\"+011 2562 3642\",\"address\":\"115205 North Kierland New York ,USA\",\"email\":\"goldinvesta@plc.com\",\"newsletter_title\":\"Subscribe Our Newsletter\",\"newsletter_description\":\"As a global investment manager and fiduciary to our clients, our purpose to build\"}', '2025-01-26 19:01:05', '2025-01-26 19:01:05'),
(9, 9, 1, NULL, '2025-01-10 12:08:55', '2025-01-10 12:08:55'),
(10, 10, 1, NULL, '2025-01-23 03:16:15', '2025-01-23 03:16:15'),
(11, 11, 1, NULL, '2025-01-22 19:08:23', '2025-01-22 19:08:23'),
(12, 12, 1, NULL, '2025-01-27 13:34:26', '2025-01-27 13:34:26'),
(13, 13, 1, '{\"title\":\"About Us\",\"sub_title\":\"Gold Investment Made Profitable Business\",\"description\":\"Buy, resell, and vault precious metals in multiple locations. Rest easy knowing your wealth is secure and outside the system. As global demand for gold continues to rise driven by factors such as  inflation and geopolitical uncertainty, investing in precious metals can be a powerful way to diversify and protect wealth.\",\"optional_link_text\":\"New System Update and featured\"}', '2025-01-05 15:07:42', '2025-01-05 15:07:42'),
(14, 14, 1, '{\"title\":\"Choose your currency\",\"short_description\":\"Manage your financial assets by Investing on Gold with secure Platform and Get profit after a limited time on running high price with additional facilities.\"}', '2025-01-10 23:52:33', '2025-01-10 23:52:33'),
(15, 15, 1, '{\"title\":\"Industry-leading pricing\",\"short_description\":\"A well-balanced investment portfolio typically includes a range of asset types\\u2014stocks, bonds, real estate, and precious metals.\"}', '2025-01-10 22:01:58', '2025-01-10 22:01:58'),
(16, 16, 1, '{\"title\":\"why choose us?\",\"sub_title\":\"We Are The Best For Gold Investment !\"}', '2025-01-08 21:37:07', '2025-02-05 01:07:40'),
(17, 17, 1, '{\"title\":\"The Complexity of Simplicity\",\"short_description\":\"Manage your financial assets by Investing on Gold with secure Platform and Get profit after a limited time on running high price with additional facilities.\"}', '2025-01-14 07:23:09', '2025-01-14 07:23:09'),
(18, 18, 1, '{\"title\":\"Gold Investment Service\",\"short_description\":\"Manage your financial assets by Investing on Gold with secure Platform and Get profit after a limited time on running high price with additional facilities.\"}', '2025-01-23 01:24:38', '2025-01-23 01:24:38'),
(19, 19, 1, '{\"title\":\"100% Security Based On Gold\",\"short_description\":\"Manage your financial assets by Investing on Gold with secure Platform and Get profit after a limited time on running high price with additional facilities.\"}', '2025-01-27 04:10:15', '2025-01-27 04:10:15'),
(20, 20, 1, '{\"title\":\"Easily Profit Withdraw\",\"short_description\":\"Manage your financial assets by Investing on Gold with secure Platform and Get profit after a limited time on running high price with additional facilities.\"}', '2025-01-02 23:26:24', '2025-01-02 23:26:24'),
(21, 21, 1, '{\"title\":\"investment process\",\"sub_title\":\"How To Invest your Money\",\"description\":\"Manage your financial assets by Investing on Gold with secure Platform and Get profit after a limited time on running high price.\"}', '2025-01-24 18:04:15', '2025-02-05 01:08:26'),
(22, 22, 1, '{\"title\":\"Select The Project\",\"short_description\":\"Create a client account by filling in the online form .Before you can place your first order, you must verify your profile by providing the supporting documents.\"}', '2025-01-21 05:44:25', '2025-01-21 05:44:25'),
(23, 23, 1, '{\"title\":\"Deposit To Account\",\"short_description\":\"Create a client account by filling in the online form .Before you can place your first order, you must verify your profile by providing the supporting documents.\"}', '2025-01-05 08:42:57', '2025-01-05 08:42:57'),
(24, 24, 1, '{\"title\":\"Buy Gold Package\",\"short_description\":\"Create a client account by filling in the online form .Before you can place your first order, you must verify your profile by providing the supporting documents.\"}', '2025-01-10 00:21:57', '2025-01-10 00:21:57'),
(25, 25, 1, '{\"title\":\"Withdraw Money\",\"short_description\":\"Create a client account by filling in the online form .Before you can place your first order, you must verify your profile by providing the supporting documents.\"}', '2025-01-01 01:20:43', '2025-01-01 01:20:43'),
(26, 26, 1, '{\"title\":\"Best pricing\",\"sub_title\":\"Smart Pricing For Gold Investment\"}', '2025-01-06 05:57:15', '2025-02-05 01:09:06'),
(27, 27, 1, '{\"countable_item_name\":\"Total Investors\",\"prefix\":\"K+\"}', '2025-01-16 17:05:54', '2025-01-16 17:05:54'),
(28, 28, 1, '{\"countable_item_name\":\"Total Asset Raised\",\"prefix\":\"M+\"}', '2025-01-06 21:51:28', '2025-01-06 21:51:28'),
(29, 29, 1, '{\"countable_item_name\":\"Retention Rate\",\"prefix\":\"%\"}', '2025-01-03 09:12:21', '2025-01-03 09:12:21'),
(30, 30, 1, '{\"countable_item_name\":\"Successful Projects\",\"prefix\":\"K+\"}', '2025-01-26 22:19:37', '2025-01-26 22:19:37'),
(31, 31, 1, '{\"title\":\"Shop anytime\",\"sub_title\":\"Our Best Sellable Product\",\"short_description\":\"Manage your financial assets by Investing on Gold with secure Platform and Get profit after a limited time on running high price with additional facilities.\",\"banner_title\":\"Shiny and Luxurious Golden Ring\",\"banner_description\":\"Buy and vault precious metals in multiple locations. Rest easy knowing your wealth is secure and outside\",\"banner_button_name\":\"Shop Now\",\"calculator_title\":\"Pay Price Calculator\",\"calculator_short_description\":\"Estimate the price for your gold with our price calculator\"}', '2025-01-11 06:59:50', '2025-02-05 01:12:00'),
(32, 32, 1, '{\"feature\":\"Best prices guaranteed\"}', '2025-01-17 23:23:06', '2025-01-17 23:23:06'),
(33, 33, 1, '{\"feature\":\"No Hidden Fee\"}', '2025-01-06 01:27:31', '2025-01-06 01:27:31'),
(34, 34, 1, '{\"feature\":\"Same day Payment\"}', '2025-01-18 14:27:03', '2025-01-18 14:27:03'),
(35, 35, 1, '{\"title\":\"Investors Reviews\",\"sub_title\":\"The Impact of Our Collaborative Efforts\"}', '2025-01-12 14:42:27', '2025-01-12 14:42:27'),
(36, 36, 1, '{\"name\":\"Henry Tullius\",\"position\":\"Business Developer at PUMA\",\"review\":\"<p>I had a great experience with Goldinvesta. Their customer service team was incredibly helpful, guiding me through the process of setting up my gold IRA. They took the time to explain everything, which I really appreciated. The only downside was the higher fees compared to other companies, but I feel like the support made it worth it.<\\/p>\"}', '2025-01-11 03:22:39', '2025-01-11 03:22:39'),
(37, 37, 1, '{\"name\":\"Henry Tullius\",\"position\":\"Business Developer at PUMA\",\"review\":\"<p>I had a great experience with Goldinvesta. Their customer service team was incredibly helpful, guiding me through the process of setting up my gold IRA. They took the time to explain everything, which I really appreciated. The only downside was the higher fees compared to other companies, but I feel like the support made it worth it.<\\/p>\"}', '2025-01-01 09:45:47', '2025-01-01 09:45:47'),
(38, 38, 1, '{\"title\":\"Our coure value\",\"sub_title\":\"Gold Investment Made Profitable Business\",\"button_name\":\"View All\"}', '2025-01-15 10:55:53', '2025-02-05 01:12:37'),
(39, 39, 1, '{\"title\":\"FAQs\",\"sub_title\":\"Frequently asked questions\"}', '2025-01-12 18:32:52', '2025-01-12 18:32:52'),
(40, 40, 1, '{\"question\":\"Is The Free Version Really Free?\",\"answer\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,248,245);\\\">Right now, every time you\\u2019ve got something new to share, you have to go to every single one of your channels to change the link in each of your bios. It\\u2019s time-consuming and complicated \\u2013 making it so much harder to keep everything up to date.<\\/span><\\/p>\"}', '2025-01-27 12:41:23', '2025-01-27 12:41:23'),
(41, 41, 1, '{\"question\":\"Why do I need a link in bio tool?\",\"answer\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,248,245);\\\">Right now, every time you\\u2019ve got something new to share, you have to go to every single one of your channels to change the link in each of your bios. It\\u2019s time-consuming and complicated \\u2013 making it so much harder to keep everything up to date.<\\/span><\\/p>\"}', '2025-01-12 01:50:43', '2025-01-12 01:50:43'),
(42, 42, 1, '{\"question\":\"Is The Free Version Really Free?\",\"answer\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,248,245);\\\">Right now, every time you\\u2019ve got something new to share, you have to go to every single one of your channels to change the link in each of your bios. It\\u2019s time-consuming and complicated \\u2013 making it so much harder to keep everything up to date.<\\/span><\\/p>\"}', '2025-01-22 00:26:57', '2025-01-22 00:26:57'),
(43, 43, 1, '{\"question\":\"How can I drive more traffic to and through Linkstory?\",\"answer\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,248,245);\\\">Right now, every time you\\u2019ve got something new to share, you have to go to every single one of your channels to change the link in each of your bios. It\\u2019s time-consuming and complicated \\u2013 making it so much harder to keep everything up to date.<\\/span><\\/p>\"}', '2025-01-14 14:51:56', '2025-01-14 14:51:56'),
(44, 44, 1, '{\"question\":\"What payment method do you accept?\",\"answer\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,248,245);\\\">Right now, every time you\\u2019ve got something new to share, you have to go to every single one of your channels to change the link in each of your bios. It\\u2019s time-consuming and complicated \\u2013 making it so much harder to keep everything up to date.<\\/span><\\/p>\"}', '2025-01-20 20:53:07', '2025-01-20 20:53:07'),
(45, 45, 1, '{\"title\":\"Contact Us\",\"sub_title\":\"Get In Touch\",\"email\":\"example@gmail.com\",\"phone\":\"+880 123 (4567) 890\",\"location\":\"122\\/B New market, USA\",\"support\":\"24\\/7 Support\"}', '2025-01-12 11:10:24', '2025-01-12 11:10:24'),
(46, 46, 1, '{\"title\":\"Welcome back\",\"sub_title\":\"Sign in Account\",\"button_name\":\"Back To Website\"}', '2025-01-22 18:01:09', '2025-01-22 18:01:09'),
(47, 47, 1, '{\"title\":\"Welcome\",\"sub_title\":\"Create Account\",\"button_name\":\"Back To Website\"}', '2025-01-18 01:45:11', '2025-01-18 01:45:11'),
(48, 48, 1, '{\"title\":\"Best Investments for Lasting Growth With Gold\",\"short_description\":\"Invest and vault precious metals in multiple Plans. Rest easy knowing your wealth is secure and outside of traditional banking systems. Offers a high-end solution enabling individuals.\",\"button\":\"Get Started\",\"video_title\":\"Investment Growth\",\"review_title\":\"Delightful Investors\",\"review_text\":\"4.8 (16.5k Reviews)\"}', '2025-01-27 14:49:05', '2025-01-27 14:49:05'),
(49, 49, 1, NULL, '2025-01-14 02:18:17', '2025-01-14 02:18:17'),
(50, 50, 1, NULL, '2025-01-22 04:01:41', '2025-01-22 04:01:41'),
(51, 51, 1, NULL, '2025-01-18 10:27:51', '2025-01-18 10:27:51'),
(52, 52, 1, '{\"title\":\"why choose us?\",\"sub_title\":\"The Best For Gold Investment !\"}', '2025-01-25 15:59:09', '2025-02-05 01:07:16'),
(53, 53, 1, '{\"title\":\"The Complexity of Simplicity\",\"short_description\":\"Manage your financial assets by Investing on Gold with secure Platform and Get profit after a limited time on running high price with additional facilities.\"}', '2025-01-12 03:38:01', '2025-01-12 03:38:01'),
(54, 54, 1, '{\"title\":\"Gold Investment Service\",\"short_description\":\"Manage your financial assets by Investing on Gold with secure Platform and Get profit after a limited time on running high price with additional facilities.\"}', '2025-01-16 19:50:35', '2025-01-16 19:50:35'),
(55, 55, 1, '{\"title\":\"100% Security Based On Gold\",\"short_description\":\"Manage your financial assets by Investing on Gold with secure Platform and Get profit after a limited time on running high price with additional facilities.\"}', '2025-01-13 23:14:51', '2025-01-13 23:14:51'),
(56, 56, 1, '{\"title\":\"Easily Profit Withdraw\",\"short_description\":\"Manage your financial assets by Investing on Gold with secure Platform and Get profit after a limited time on running high price with additional facilities.\"}', '2024-12-31 21:49:32', '2024-12-31 21:49:32'),
(57, 57, 1, '{\"title\":\"About Us\",\"sub_title\":\"Commitment to Integrity and Excellence.\",\"description\":\"Buy, resell and vault precious metals in multiple locations. Rest easy knowing your wealth is secure and outside.\",\"button\":\"Learn More\",\"banner_title_1\":\"10+\",\"banner_sub_title_1\":\"Years of Experience\",\"banner_title_2\":\"Average Annual Return\",\"banner_sub_title_2\":\"95%\"}', '2025-01-22 07:00:55', '2025-01-22 07:00:55'),
(58, 58, 1, '{\"title\":\"Choose your currency\",\"short_description\":\"Manage your financial assets by Investing on Gold with secure Platform and Get profit after a limited time on running high price with additional facilities.\"}', '2025-01-19 20:23:38', '2025-01-19 20:23:38'),
(59, 59, 1, '{\"title\":\"Industry-leading pricing\",\"short_description\":\"A well-balanced investment portfolio typically includes a range of asset types\\u2014stocks, bonds, real estate, and precious metals.\"}', '2025-01-17 08:27:19', '2025-01-17 08:27:19'),
(60, 60, 1, '{\"title\":\"Best performence\",\"sub_title\":\"We put safety at our business\"}', '2025-01-20 07:08:56', '2025-02-05 03:55:30'),
(61, 61, 1, '{\"countable_item_name\":\"Total Investors\",\"prefix\":\"K+\"}', '2025-01-11 22:58:02', '2025-01-11 22:58:02'),
(62, 62, 1, '{\"countable_item_name\":\"Total Asset Raised\",\"prefix\":\"M+\"}', '2025-01-08 20:37:27', '2025-01-08 20:37:27'),
(63, 63, 1, '{\"countable_item_name\":\"Retention Rate\",\"prefix\":\"%\"}', '2025-01-19 14:57:30', '2025-01-19 14:57:30'),
(64, 64, 1, '{\"countable_item_name\":\"Successful Projects\",\"prefix\":\"K+\"}', '2025-01-19 07:19:36', '2025-01-19 07:19:36'),
(65, 65, 1, '{\"title\":\"Best pricing\",\"sub_title\":\"Select The Best Pricing Plan Your Need\"}', '2025-01-19 05:26:25', '2025-02-05 01:09:11'),
(66, 66, 1, '{\"title\":\"SHOP ANYTIME\",\"sub_title\":\"Our Best Sellable Product\",\"short_description\":\"Manage your financial assets by Investing on Gold with secure Platform and Get profit after a limited time on running high price with additional facilities.\",\"banner_title\":\"Shiny and Luxurious Golden Ring\",\"banner_description\":\"Buy and vault precious metals in multiple locations. Rest easy knowing your wealth is secure and outside\",\"banner_button_name\":\"Shop Now\"}', '2025-01-08 17:09:56', '2025-01-08 17:09:56'),
(67, 67, 1, '{\"title\":\"STEP BY STEP\",\"sub_title\":\"How To Invest your Money Easily\"}', '2025-01-04 10:26:33', '2025-01-04 10:26:33'),
(68, 68, 1, '{\"title\":\"Select The Project\",\"short_description\":\"Create a client account by filling in the online form .Before you can place your first order, you must verify your profile by providing the supporting documents.\"}', '2025-01-15 00:47:55', '2025-01-15 00:47:55'),
(69, 69, 1, '{\"title\":\"Deposit To Account\",\"short_description\":\"Create a client account by filling in the online form .Before you can place your first order, you must verify your profile by providing the supporting documents.\"}', '2025-01-01 10:04:14', '2025-01-01 10:04:14'),
(70, 70, 1, '{\"title\":\"Buy Gold Package\",\"short_description\":\"Create a client account by filling in the online form .Before you can place your first order, you must verify your profile by providing the supporting documents.\"}', '2025-01-08 04:29:53', '2025-01-08 04:29:53'),
(71, 71, 1, '{\"title\":\"Withdraw Money\",\"short_description\":\"Create a client account by filling in the online form .Before you can place your first order, you must verify your profile by providing the supporting documents.\"}', '2025-01-24 03:19:31', '2025-01-24 03:19:31'),
(72, 72, 1, '{\"title\":\"Step by step\",\"sub_title\":\"What Our Clients Say About Us\",\"short_description\":\"Financial assets by Investing on Gold with secure Platform and Get profit after a limited time on running high price with additional facilities.\"}', '2025-01-17 20:20:36', '2025-02-05 03:59:45'),
(73, 73, 1, '{\"name\":\"Adam Lane\",\"position\":\"CEO,PUMA Fashion\",\"review\":\"<p>I am extremely satisfied with my experience at Goldinvesta. Their team of experts provided invaluable insights and tailored strategies that align with my financial goals. I appreciate their commitment to transparency and ongoing support throughout the investment process.<\\/p>\"}', '2025-01-02 17:43:42', '2025-01-02 17:43:42'),
(74, 74, 1, '{\"name\":\"Adam Lane\",\"position\":\"CEO,PUMA Fashion\",\"review\":\"<p>I am extremely satisfied with my experience at Goldinvesta. Their team of experts provided invaluable insights and tailored strategies that align with my financial goals. I appreciate their commitment to transparency and ongoing support throughout the investment process.<\\/p>\"}', '2025-01-14 10:29:31', '2025-01-14 10:29:31'),
(75, 75, 1, '{\"name\":\"Adam Lane\",\"position\":\"CEO,PUMA Fashion\",\"review\":\"<p>I am extremely satisfied with my experience at Goldinvesta. Their team of experts provided invaluable insights and tailored strategies that align with my financial goals. I appreciate their commitment to transparency and ongoing support throughout the investment process.<\\/p>\"}', '2025-01-13 11:20:23', '2025-01-13 11:20:23'),
(76, 76, 1, '{\"title\":\"Blogs &amp; news\",\"sub_title\":\"Latest Blog And News Update\"}', '2025-01-01 15:38:21', '2025-02-05 01:12:53'),
(77, 77, 1, '{\"heading\":\"Acceptance of Terms\",\"description\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,250,250);\\\">By accessing or using the GoldInvest platform, you agree to comply with and be bound by these Terms of Service. If you do not agree, you may not use the services provided.<\\/span><\\/p>\"}', '2025-01-20 21:14:29', '2025-01-20 21:14:29'),
(78, 78, 1, '{\"heading\":\"Eligibility\",\"description\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,250,250);\\\">You must be at least 18 years old and have the legal capacity to enter into contracts to use our platform. By creating an account, you represent and warrant that you meet these eligibility requirements.<\\/span><\\/p>\"}', '2025-01-09 12:55:42', '2025-01-09 12:55:42'),
(79, 79, 1, '{\"heading\":\"Account Creation and Maintenance\",\"description\":\"<p style=\\\"font-size:18px;background-color:rgb(250,250,250);\\\">To invest through GoldInvest, you must create an account. You agree to:<\\/p><div class=\\\"terms-content-list mt_20\\\" style=\\\"font-size:16px;color:rgb(33,37,41);font-family:\'system-ui\', \'-apple-system\', \'Segoe UI\', Roboto, \'Helvetica Neue\', \'Noto Sans\', \'Liberation Sans\', Arial, sans-serif, \'Apple Color Emoji\', \'Segoe UI Emoji\', \'Segoe UI Symbol\', \'Noto Color Emoji\';background-color:rgb(250,250,250);\\\"><ul><li>Provide accurate, current, and complete information during the registration process.<\\/li><li>Maintain the security of your password and account.<\\/li><li>Notify us immediately of any unauthorized use of your account or any other breach of security.<\\/li><li>Be responsible for all activities that occur under your account<\\/li><\\/ul><\\/div>\"}', '2025-01-03 08:25:57', '2025-01-03 08:25:57'),
(80, 80, 1, '{\"heading\":\"Investment Risks\",\"description\":\"<p style=\\\"font-size:18px;background-color:rgb(250,250,250);\\\">Investing in gold and other commodities involves risks, including but not limited to:<\\/p><div class=\\\"terms-content-list mt_20\\\" style=\\\"font-size:16px;color:rgb(33,37,41);font-family:\'system-ui\', \'-apple-system\', \'Segoe UI\', Roboto, \'Helvetica Neue\', \'Noto Sans\', \'Liberation Sans\', Arial, sans-serif, \'Apple Color Emoji\', \'Segoe UI Emoji\', \'Segoe UI Symbol\', \'Noto Color Emoji\';background-color:rgb(250,250,250);\\\"><ul><li><span class=\\\"fa-light fa-check\\\" style=\\\"font-size:14px;\\\"><\\/span>\\u00a0The price of gold can fluctuate significantly.<\\/li><li><span class=\\\"fa-light fa-check\\\" style=\\\"font-size:14px;\\\"><\\/span>\\u00a0You may not be able to sell your investments at desired prices.<\\/li><li><span class=\\\"fa-light fa-check\\\" style=\\\"font-size:14px;\\\"><\\/span>\\u00a0Changes in laws and regulations may affect your investments.<\\/li><\\/ul><\\/div><p style=\\\"font-size:18px;background-color:rgb(250,250,250);\\\">GoldInvest does not provide financial advice. We recommend consulting with a financial advisor before making investment decisions.<\\/p>\"}', '2025-01-12 12:35:53', '2025-01-12 12:35:53'),
(81, 81, 1, '{\"heading\":\"Privacy Policy\",\"description\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,250,250);\\\">Your privacy is important to us. Our Privacy Policy details how we collect, use, and protect your personal information. By using our services, you consent to our data practices as described in the Privacy Policy.<\\/span><\\/p>\"}', '2025-01-04 19:13:50', '2025-01-04 19:13:50'),
(82, 82, 1, '{\"heading\":\"Limitation of Liability\",\"description\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,250,250);\\\">GoldInvest and its affiliates shall not be liable for any indirect, incidental, special, consequential, or punitive damages arising from your use of the platform. Our total liability to you for any claims arising out of or relating to these terms is limited to the amount you paid to us in the twelve months preceding the event giving rise to the claim.<\\/span><\\/p>\"}', '2025-01-19 00:50:56', '2025-01-19 00:50:56'),
(83, 83, 1, '{\"heading\":\"Termination\",\"description\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,250,250);\\\">We reserve the right to suspend or terminate your account at our discretion, without notice, for any conduct that we believe violates these terms or is harmful to other users or the platform.<\\/span><\\/p>\"}', '2025-01-21 11:50:29', '2025-01-21 11:50:29'),
(84, 84, 1, '{\"heading\":\"Contact Information\",\"description\":\"<p style=\\\"font-size:18px;background-color:rgb(250,250,250);\\\">If you have any questions about these Terms of Service, please contact us at<\\/p><p><a href=\\\"mailto:example@gmail.com\\\">Email: example@gmail.com<\\/a><\\/p>\"}', '2025-01-21 14:56:54', '2025-01-21 14:56:54'),
(85, 85, 1, '{\"heading\":\"Acceptance of Terms\",\"description\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,250,250);\\\">By accessing or using the GoldInvest platform, you agree to comply with and be bound by these Terms of Service. If you do not agree, you may not use the services provided.<\\/span><\\/p>\"}', '2025-01-18 16:59:43', '2025-01-18 16:59:43'),
(86, 86, 1, '{\"heading\":\"Eligibility\",\"description\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,250,250);\\\">You must be at least 18 years old and have the legal capacity to enter into contracts to use our platform. By creating an account, you represent and warrant that you meet these eligibility requirements.<\\/span><\\/p>\"}', '2025-01-09 13:22:37', '2025-01-09 13:22:37'),
(87, 87, 1, '{\"heading\":\"Account Creation and Maintenance\",\"description\":\"<p style=\\\"font-size:18px;background-color:rgb(250,250,250);\\\">To invest through GoldInvest, you must create an account. You agree to:<\\/p><div class=\\\"terms-content-list mt_20\\\" style=\\\"font-size:16px;color:rgb(33,37,41);font-family:\'system-ui\', \'-apple-system\', \'Segoe UI\', Roboto, \'Helvetica Neue\', \'Noto Sans\', \'Liberation Sans\', Arial, sans-serif, \'Apple Color Emoji\', \'Segoe UI Emoji\', \'Segoe UI Symbol\', \'Noto Color Emoji\';background-color:rgb(250,250,250);\\\"><ul><li>Provide accurate, current, and complete information during the registration process.<\\/li><li>Maintain the security of your password and account.<\\/li><li>Notify us immediately of any unauthorized use of your account or any other breach of security.<\\/li><li>Be responsible for all activities that occur under your account<\\/li><\\/ul><\\/div>\"}', '2025-01-23 10:21:10', '2025-01-23 10:21:10'),
(88, 88, 1, '{\"heading\":\"Investment Risks\",\"description\":\"<p style=\\\"font-size:18px;background-color:rgb(250,250,250);\\\">Investing in gold and other commodities involves risks, including but not limited to:<\\/p><div class=\\\"terms-content-list mt_20\\\" style=\\\"font-size:16px;color:rgb(33,37,41);font-family:\'system-ui\', \'-apple-system\', \'Segoe UI\', Roboto, \'Helvetica Neue\', \'Noto Sans\', \'Liberation Sans\', Arial, sans-serif, \'Apple Color Emoji\', \'Segoe UI Emoji\', \'Segoe UI Symbol\', \'Noto Color Emoji\';background-color:rgb(250,250,250);\\\"><ul><li><span class=\\\"fa-light fa-check\\\" style=\\\"font-size:14px;\\\"><\\/span>\\u00a0The price of gold can fluctuate significantly.<\\/li><li><span class=\\\"fa-light fa-check\\\" style=\\\"font-size:14px;\\\"><\\/span>\\u00a0You may not be able to sell your investments at desired prices.<\\/li><li><span class=\\\"fa-light fa-check\\\" style=\\\"font-size:14px;\\\"><\\/span>\\u00a0Changes in laws and regulations may affect your investments.<\\/li><\\/ul><\\/div><p style=\\\"font-size:18px;background-color:rgb(250,250,250);\\\">GoldInvest does not provide financial advice. We recommend consulting with a financial advisor before making investment decisions.<\\/p>\"}', '2025-01-10 12:22:41', '2025-01-10 12:22:41'),
(89, 89, 1, '{\"heading\":\"Privacy Policy\",\"description\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,250,250);\\\">Your privacy is important to us. Our Privacy Policy details how we collect, use, and protect your personal information. By using our services, you consent to our data practices as described in the Privacy Policy.<\\/span><\\/p>\"}', '2025-01-13 19:32:55', '2025-01-13 19:32:55'),
(90, 90, 1, '{\"heading\":\"Limitation of Liability\",\"description\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,250,250);\\\">GoldInvest and its affiliates shall not be liable for any indirect, incidental, special, consequential, or punitive damages arising from your use of the platform. Our total liability to you for any claims arising out of or relating to these terms is limited to the amount you paid to us in the twelve months preceding the event giving rise to the claim.<\\/span><\\/p>\"}', '2025-01-17 00:33:24', '2025-01-17 00:33:24'),
(91, 91, 1, '{\"heading\":\"Termination\",\"description\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,250,250);\\\">We reserve the right to suspend or terminate your account at our discretion, without notice, for any conduct that we believe violates these terms or is harmful to other users or the platform.<\\/span><\\/p>\"}', '2025-01-21 15:56:09', '2025-01-21 15:56:09'),
(92, 92, 1, '{\"heading\":\"Contact Information\",\"description\":\"<p style=\\\"font-size:18px;background-color:rgb(250,250,250);\\\">If you have any questions about these Terms of Service, please contact us at<\\/p><p><a href=\\\"mailto:example@gmail.com\\\">Email: example@gmail.com<\\/a><\\/p>\"}', '2025-01-25 09:10:29', '2025-01-25 09:10:29'),
(93, 93, 1, '{\"heading\":\"Acceptance of Terms\",\"description\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,250,250);\\\">By accessing or using the GoldInvest platform, you agree to comply with and be bound by these Terms of Service. If you do not agree, you may not use the services provided.<\\/span><\\/p>\"}', '2025-01-02 00:35:20', '2025-01-02 00:35:20'),
(94, 94, 1, '{\"heading\":\"Eligibility\",\"description\":\"<span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,250,250);\\\">You must be at least 18 years old and have the legal capacity to enter into contracts to use our platform. By creating an account, you represent and warrant that you meet these eligibility requirements.<\\/span>\"}', '2025-01-13 11:20:39', '2025-01-13 11:20:39'),
(95, 95, 1, '{\"heading\":\"Account Creation and Maintenance\",\"description\":\"<p style=\\\"font-size:18px;background-color:rgb(250,250,250);\\\">To invest through GoldInvest, you must create an account. You agree to:<\\/p><div class=\\\"terms-content-list mt_20\\\" style=\\\"font-size:16px;color:rgb(33,37,41);font-family:\'system-ui\', \'-apple-system\', \'Segoe UI\', Roboto, \'Helvetica Neue\', \'Noto Sans\', \'Liberation Sans\', Arial, sans-serif, \'Apple Color Emoji\', \'Segoe UI Emoji\', \'Segoe UI Symbol\', \'Noto Color Emoji\';background-color:rgb(250,250,250);\\\"><ul><li>Provide accurate, current, and complete information during the registration process.<\\/li><li>Maintain the security of your password and account.<\\/li><li>Notify us immediately of any unauthorized use of your account or any other breach of security.<\\/li><li>Be responsible for all activities that occur under your account<\\/li><\\/ul><\\/div>\"}', '2025-01-14 07:02:21', '2025-01-14 07:02:21'),
(96, 96, 1, '{\"heading\":\"Investment Risks\",\"description\":\"<p style=\\\"font-size:18px;background-color:rgb(250,250,250);\\\">Investing in gold and other commodities involves risks, including but not limited to:<\\/p><div class=\\\"terms-content-list mt_20\\\" style=\\\"font-size:16px;color:rgb(33,37,41);font-family:\'system-ui\', \'-apple-system\', \'Segoe UI\', Roboto, \'Helvetica Neue\', \'Noto Sans\', \'Liberation Sans\', Arial, sans-serif, \'Apple Color Emoji\', \'Segoe UI Emoji\', \'Segoe UI Symbol\', \'Noto Color Emoji\';background-color:rgb(250,250,250);\\\"><ul><li><span class=\\\"fa-light fa-check\\\" style=\\\"font-size:14px;\\\"><\\/span>\\u00a0The price of gold can fluctuate significantly.<\\/li><li><span class=\\\"fa-light fa-check\\\" style=\\\"font-size:14px;\\\"><\\/span>\\u00a0You may not be able to sell your investments at desired prices.<\\/li><li><span class=\\\"fa-light fa-check\\\" style=\\\"font-size:14px;\\\"><\\/span>\\u00a0Changes in laws and regulations may affect your investments.<\\/li><\\/ul><\\/div><p style=\\\"font-size:18px;background-color:rgb(250,250,250);\\\">GoldInvest does not provide financial advice. We recommend consulting with a financial advisor before making investment decisions.<\\/p>\"}', '2025-01-01 08:11:43', '2025-01-01 08:11:43'),
(97, 97, 1, '{\"heading\":\"Privacy Policy\",\"description\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,250,250);\\\">Your privacy is important to us. Our Privacy Policy details how we collect, use, and protect your personal information. By using our services, you consent to our data practices as described in the Privacy Policy.<\\/span><\\/p>\"}', '2025-01-26 18:43:43', '2025-01-26 18:43:43'),
(98, 98, 1, '{\"heading\":\"Limitation of Liability\",\"description\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,250,250);\\\">GoldInvest and its affiliates shall not be liable for any indirect, incidental, special, consequential, or punitive damages arising from your use of the platform. Our total liability to you for any claims arising out of or relating to these terms is limited to the amount you paid to us in the twelve months preceding the event giving rise to the claim.<\\/span><\\/p>\"}', '2025-01-21 10:38:06', '2025-01-21 10:38:06'),
(99, 99, 1, '{\"heading\":\"Termination\",\"description\":\"<p><span style=\\\"color:rgb(68,68,68);font-size:18px;background-color:rgb(250,250,250);\\\">We reserve the right to suspend or terminate your account at our discretion, without notice, for any conduct that we believe violates these terms or is harmful to other users or the platform.<\\/span><\\/p>\"}', '2024-12-31 20:13:19', '2024-12-31 20:13:19'),
(100, 100, 1, '{\"heading\":\"Contact Information\",\"description\":\"<p style=\\\"font-size:18px;background-color:rgb(250,250,250);\\\">If you have any questions about these Terms of Service, please contact us at<\\/p><p><a href=\\\"mailto:example@gmail.com\\\">Email: example@gmail.com<\\/a><\\/p>\"}', '2025-01-02 17:00:36', '2025-01-02 17:00:36'),
(101, 101, 1, '{\"title\":\"PWA\",\"short_description\":\"Install Progressive Web Application\",\"description\":\"This site has app functionality. Install it on your device for extensive experience and easy access.\"}', '2025-01-18 07:38:54', '2025-01-18 07:38:54'),
(211, 107, 1, NULL, '2025-01-29 04:04:38', '2025-01-29 04:04:38'),
(212, 108, 1, NULL, '2025-01-29 04:04:42', '2025-01-29 04:04:42'),
(213, 109, 1, NULL, '2025-01-29 04:04:46', '2025-01-29 04:04:46'),
(214, 110, 1, NULL, '2025-01-29 04:04:49', '2025-01-29 04:04:49');

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

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

CREATE TABLE `coupons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `coupon_code` varchar(255) NOT NULL,
  `minimum_order_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `maximum_order` int(10) UNSIGNED DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `discount` decimal(10,2) DEFAULT NULL,
  `discount_type` enum('Fixed','Percent') NOT NULL DEFAULT 'Percent',
  `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`, `coupon_code`, `minimum_order_price`, `maximum_order`, `start_date`, `end_date`, `discount`, `discount_type`, `created_at`, `updated_at`) VALUES
(1, 'MJMG9TWJKF', 250.00, 5, '2024-12-10', '2025-10-18', 10.00, 'Percent', '2025-01-06 10:05:01', '2025-01-06 10:05:01');

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

--
-- Table structure for table `coupon_applicable_products`
--

CREATE TABLE `coupon_applicable_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `coupon_id` bigint(20) UNSIGNED NOT NULL,
  `product_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;

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

--
-- Table structure for table `deposits`
--

CREATE TABLE `deposits` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `depositable_id` int(11) DEFAULT NULL,
  `depositable_type` varchar(255) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_method_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_method_currency` varchar(255) DEFAULT NULL,
  `amount` decimal(18,8) NOT NULL DEFAULT 0.00000000 COMMENT 'in base currency',
  `percentage_charge` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `fixed_charge` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `base_currency_charge` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `payable_amount` decimal(18,8) NOT NULL DEFAULT 0.00000000 COMMENT 'Amount payed',
  `payable_amount_in_base_currency` decimal(18,8) NOT NULL DEFAULT 0.00000000 COMMENT 'Amount payed in base currency',
  `btc_amount` decimal(18,8) DEFAULT NULL,
  `btc_wallet` varchar(255) DEFAULT NULL,
  `payment_id` varchar(255) DEFAULT NULL,
  `information` text DEFAULT NULL,
  `trx_id` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=pending, 1=success, 2=request, 3=rejected',
  `note` text 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 `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `file_storages`
--

CREATE TABLE `file_storages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `logo` text DEFAULT NULL,
  `driver` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1 => active, 0 => inactive',
  `parameters` text 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 `file_storages`
--

INSERT INTO `file_storages` (`id`, `code`, `name`, `logo`, `driver`, `status`, `parameters`, `created_at`, `updated_at`) VALUES
(1, 's3', 'Amazon S3', 'driver/GJrBdvIxtnEprk0kHylgzNh6LcGcfOUcA205IIK5.png', 'local', 0, '{\"access_key_id\":\"xys6\",\"secret_access_key\":\"xys\",\"default_region\":\"xys5\",\"bucket\":\"xys6\",\"url\":\"xysds\"}', '2025-01-24 01:31:26', '2025-01-24 01:31:26'),
(2, 'sftp', 'SFTP', 'driver/q8E08YsobyRZGOLHHeKGhwysWsi25F186EbaNNRx.png', 'local', 0, '{\"sftp_username\":\"xys6\",\"sftp_password\":\"xys\"}', '2025-01-04 17:14:48', '2025-01-04 17:14:48'),
(3, 'do', 'Digitalocean Spaces', 'driver/iA8q685PBCnOAkmctLXZWhyqSoh7cJMOewpW4S8r.png', 'local', 0, '{\"spaces_key\":\"hj\",\"spaces_secret\":\"vh\",\"spaces_endpoint\":\"jk\",\"spaces_region\":\"sfo2\",\"spaces_bucket\":\"assets-coral\"}', '2025-01-10 18:50:57', '2025-01-10 18:50:57'),
(4, 'ftp', 'FTP', 'driver/wIwEOAJ45KgVGw0PL80WNfcbosB4IuUlxStfeHCX.png', 'local', 0, '{\"ftp_host\":\"xys6\",\"ftp_username\":\"xys\",\"ftp_password\":\"xys6\"}', '2025-01-15 05:49:39', '2025-01-15 05:49:39'),
(5, 'local', 'Local Storage', '', NULL, 1, NULL, '2025-01-24 20:39:46', '2025-01-24 20:39:46');

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

--
-- Table structure for table `fire_base_tokens`
--

CREATE TABLE `fire_base_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_id` int(11) DEFAULT NULL,
  `tokenable_type` varchar(255) DEFAULT NULL,
  `token` text 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 `funds`
--

CREATE TABLE `funds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `gateway_id` bigint(20) UNSIGNED DEFAULT NULL,
  `fundable_id` int(11) DEFAULT NULL,
  `fundable_type` varchar(91) DEFAULT NULL,
  `gateway_currency` varchar(191) DEFAULT NULL,
  `amount` decimal(18,8) DEFAULT 0.00000000,
  `charge` decimal(18,8) DEFAULT 0.00000000,
  `percentage_charge` decimal(18,8) DEFAULT 0.00000000,
  `fixed_charge` decimal(18,8) DEFAULT 0.00000000,
  `final_amount` decimal(18,8) DEFAULT 0.00000000,
  `payable_amount_base_currency` decimal(18,8) DEFAULT 0.00000000,
  `btc_amount` decimal(18,8) DEFAULT 0.00000000,
  `btc_wallet` varchar(191) DEFAULT NULL,
  `transaction` varchar(50) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1=> Complete, 2=> Pending, 3 => Cancel, 4=> failed	',
  `detail` text DEFAULT NULL,
  `feedback` text DEFAULT NULL,
  `validation_token` varchar(191) DEFAULT NULL,
  `referenceno` varchar(191) DEFAULT NULL,
  `reason` varchar(191) DEFAULT NULL,
  `information` text DEFAULT NULL,
  `api_response` text 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 `gateways`
--

CREATE TABLE `gateways` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `sort_by` int(11) NOT NULL DEFAULT 1,
  `image` varchar(191) DEFAULT NULL,
  `driver` varchar(20) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0: inactive, 1: active',
  `parameters` text DEFAULT NULL,
  `currencies` text DEFAULT NULL,
  `extra_parameters` text DEFAULT NULL,
  `supported_currency` varchar(255) DEFAULT NULL,
  `receivable_currencies` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `currency_type` tinyint(4) NOT NULL DEFAULT 1,
  `is_sandbox` tinyint(4) NOT NULL DEFAULT 0,
  `environment` enum('test','live') NOT NULL DEFAULT 'live',
  `is_manual` tinyint(4) DEFAULT 0,
  `note` text 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 `gateways`
--

INSERT INTO `gateways` (`id`, `code`, `name`, `sort_by`, `image`, `driver`, `status`, `parameters`, `currencies`, `extra_parameters`, `supported_currency`, `receivable_currencies`, `description`, `currency_type`, `is_sandbox`, `environment`, `is_manual`, `note`, `created_at`, `updated_at`) VALUES
(1, 'paypal', 'Paypal', 7, 'gateway/cCmKX4VMzHorJkQ9omsZdOLIZLXA56.webp', 'local', 0, '{\"cleint_id\":\"\",\"secret\":\"\"}', '{\"0\":{\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"HKD\":\"HKD\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"ILS\":\"ILS\",\"JPY\":\"JPY\",\"MYR\":\"MYR\",\"MXN\":\"MXN\",\"TWD\":\"TWD\",\"NZD\":\"NZD\",\"NOK\":\"NOK\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"GBP\":\"GBP\",\"RUB\":\"RUB\",\"SGD\":\"SGD\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"THB\":\"THB\",\"USD\":\"USD\"}}', NULL, '[\"USD\"]', '[{\"name\":\"USD\",\"currency_symbol\":\"USD\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"1\",\"max_limit\":\"10000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 1, 'live', NULL, NULL, '2025-01-13 03:53:18', '2025-01-29 07:28:21'),
(2, 'stripe', 'Stripe ', 1, 'gateway/Fpn6DbOj8Kh0qEqmDcqzPLaYetzHdU.webp', 'local', 0, '{\"secret_key\":\"\",\"publishable_key\":\"\"}', '{\"0\":{\"USD\":\"USD\",\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"INR\":\"INR\",\"JPY\":\"JPY\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"PLN\":\"PLN\",\"SEK\":\"SEK\",\"SGD\":\"SGD\"}}', NULL, '[\"USD\",\"GBP\"]', '[{\"name\":\"USD\",\"currency_symbol\":\"USD\",\"conversion_rate\":\"1\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0.5\",\"fixed_charge\":\"0.5\"},{\"name\":\"GBP\",\"currency_symbol\":\"GBP\",\"conversion_rate\":\"0.80\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 1, 'live', NULL, NULL, '2025-01-18 15:44:06', '2025-01-29 07:28:21'),
(3, 'skrill', 'Skrill', 3, 'gateway/sFW8RqOtyTiIo8369MLJFmMsfHtYHX.webp', 'local', 0, '{\"pay_to_email\":\"\",\"secret_key\":\"\"}', '{\"0\":{\"AED\":\"AED\",\"AUD\":\"AUD\",\"BGN\":\"BGN\",\"BHD\":\"BHD\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"HRK\":\"HRK\",\"HUF\":\"HUF\",\"ILS\":\"ILS\",\"INR\":\"INR\",\"ISK\":\"ISK\",\"JOD\":\"JOD\",\"JPY\":\"JPY\",\"KRW\":\"KRW\",\"KWD\":\"KWD\",\"MAD\":\"MAD\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"OMR\":\"OMR\",\"PLN\":\"PLN\",\"QAR\":\"QAR\",\"RON\":\"RON\",\"RSD\":\"RSD\",\"SAR\":\"SAR\",\"SEK\":\"SEK\",\"SGD\":\"SGD\",\"THB\":\"THB\",\"TND\":\"TND\",\"TRY\":\"TRY\",\"TWD\":\"TWD\",\"USD\":\"USD\",\"ZAR\":\"ZAR\",\"COP\":\"COP\"}}', NULL, '[\"AUD\",\"USD\"]', '[{\"name\":\"AUD\",\"currency_symbol\":\"AUD\",\"conversion_rate\":\"0.014\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"},{\"name\":\"USD\",\"currency_symbol\":\"USD\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"1\",\"max_limit\":\"15000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, NULL, '2025-01-01 20:51:39', '2025-01-29 07:28:21'),
(4, 'perfectmoney', 'Perfect Money', 6, 'gateway/B1uwuCo5fk4FVyBSm8yxErDtezvo9R.webp', 'local', 0, '{\"passphrase\":\"\",\"payee_account\":\"\"}', '{\"0\":{\"USD\":\"USD\",\"EUR\":\"EUR\"}}', NULL, '[\"USD\",\"EUR\"]', '[{\"name\":\"USD\",\"currency_symbol\":\"USD\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0.5\",\"fixed_charge\":\"0\"},{\"name\":\"EUR\",\"currency_symbol\":\"EUR\",\"conversion_rate\":\"0.0083\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, NULL, '2025-01-23 19:46:33', '2025-01-29 07:28:21'),
(5, 'paytm', 'PayTM', 23, 'gateway/9OxY8ZDv4JGt3MS7zPEquDtQ9b1vWU.webp', 'local', 0, '{\"MID\":\"\",\"merchant_key\":\"\",\"WEBSITE\":\"\",\"INDUSTRY_TYPE_ID\":\"\",\"CHANNEL_ID\":\"\",\"environment_url\":\"\",\"process_transaction_url\":\"\"}', '{\"0\":{\"AUD\":\"AUD\",\"ARS\":\"ARS\",\"BDT\":\"BDT\",\"BRL\":\"BRL\",\"BGN\":\"BGN\",\"CAD\":\"CAD\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"COP\":\"COP\",\"HRK\":\"HRK\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EGP\":\"EGP\",\"EUR\":\"EUR\",\"GEL\":\"GEL\",\"GHS\":\"GHS\",\"HKD\":\"HKD\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"IDR\":\"IDR\",\"ILS\":\"ILS\",\"JPY\":\"JPY\",\"KES\":\"KES\",\"MYR\":\"MYR\",\"MXN\":\"MXN\",\"MAD\":\"MAD\",\"NPR\":\"NPR\",\"NZD\":\"NZD\",\"NGN\":\"NGN\",\"NOK\":\"NOK\",\"PKR\":\"PKR\",\"PEN\":\"PEN\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"RON\":\"RON\",\"RUB\":\"RUB\",\"SGD\":\"SGD\",\"ZAR\":\"ZAR\",\"KRW\":\"KRW\",\"LKR\":\"LKR\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"THB\":\"THB\",\"TRY\":\"TRY\",\"UGX\":\"UGX\",\"UAH\":\"UAH\",\"AED\":\"AED\",\"GBP\":\"GBP\",\"USD\":\"USD\",\"VND\":\"VND\",\"XOF\":\"XOF\"}}', NULL, '[\"AUD\",\"CAD\"]', '[{\"name\":\"AUD\",\"currency_symbol\":\"AUD\",\"conversion_rate\":\"0.014\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"CAD\",\"currency_symbol\":\"CAD\",\"conversion_rate\":\"0.012\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0.5\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 1, 'live', NULL, NULL, '2025-01-24 14:41:53', '2025-01-29 07:28:21'),
(6, 'payeer', 'Payeer', 17, 'gateway/7HTCjJpFcRmHqM1kJSpaRuTA0MzNqG.webp', 'local', 0, '{\"merchant_id\":\"\",\"secret_key\":\"\"}', '{\"0\":{\"USD\":\"USD\",\"EUR\":\"EUR\",\"RUB\":\"RUB\"}}', '{\"status\":\"ipn\"}', '[\"USD\",\"RUB\"]', '[{\"name\":\"USD\",\"currency_symbol\":\"USD\",\"conversion_rate\":\"1\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"RUB\",\"currency_symbol\":\"RUD\",\"conversion_rate\":\"0.81\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0.5\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, NULL, '2025-01-23 22:45:12', '2025-01-29 07:28:21'),
(7, 'paystack', 'PayStack', 3, 'gateway/Km8ogMTUmpEdjbHRvLma7enfvafO3N.webp', 'local', 0, '{\"public_key\":\"\",\"secret_key\":\"\"}', '{\"0\":{\"USD\":\"USD\",\"NGN\":\"NGN\"}}', '{\"callback\":\"ipn\",\"webhook\":\"ipn\"}\r\n', '[\"USD\",\"NGN\"]', '[{\"name\":\"USD\",\"currency_symbol\":\"USD\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"NGN\",\"currency_symbol\":\"NGN\",\"conversion_rate\":\"7.40\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0.5\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, NULL, '2025-01-10 00:25:04', '2025-01-29 07:28:21'),
(8, 'voguepay', 'VoguePay', 34, 'gateway/x6HOsziQhmuJ7iu46zMKdBEewDSesm.webp', 'local', 0, '{\"merchant_id\":\"\"}', '{\"0\":{\"NGN\":\"NGN\",\"USD\":\"USD\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"ZAR\":\"ZAR\",\"JPY\":\"JPY\",\"INR\":\"INR\",\"AUD\":\"AUD\",\"CAD\":\"CAD\",\"NZD\":\"NZD\",\"NOK\":\"NOK\",\"PLN\":\"PLN\"}}\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', NULL, '[\"NGN\",\"EUR\"]', '[{\"name\":\"NGN\",\"currency_symbol\":\"NGN\",\"conversion_rate\":\"7.40\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"EUR\",\"currency_symbol\":\"EUR\",\"conversion_rate\":\"0.0083\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0.5\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, NULL, '2025-01-09 15:47:13', '2025-01-29 07:28:21'),
(9, 'flutterwave', 'Flutterwave', 4, 'gateway/SUpub5TEkx7MOcetX340zn7LGSH0Sa.webp', 'local', 0, '{\"public_key\":\"\",\"secret_key\":\"\",\"encryption_key\":\"\"}', '{\"0\":{\"KES\":\"KES\",\"GHS\":\"GHS\",\"NGN\":\"NGN\",\"USD\":\"USD\",\"GBP\":\"GBP\",\"EUR\":\"EUR\",\"UGX\":\"UGX\",\"TZS\":\"TZS\"}}', NULL, '[\"GHS\",\"NGN\",\"USD\"]', '[{\"name\":\"GHS\",\"currency_symbol\":\"GHS\",\"conversion_rate\":\"0.11\",\"min_limit\":\"1\",\"max_limit\":\"50000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"NGN\",\"currency_symbol\":\"NGN\",\"conversion_rate\":\"7.40\",\"min_limit\":\"1\",\"max_limit\":\"50000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"USD\",\"currency_symbol\":\"USD\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"1\",\"max_limit\":\"10000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'test', NULL, NULL, '2025-01-16 18:15:13', '2025-01-29 07:28:21'),
(10, 'razorpay', 'RazorPay', 2, 'gateway/HvTfH2WAQtw0pcN4ZzssUT5l86FMCZ.webp', 'local', 0, '{\"key_id\":\"\",\"key_secret\":\"\"}', '{\"0\":{\"INR\":\"INR\"}}', NULL, '[\"INR\"]', '[{\"name\":\"INR\",\"currency_symbol\":\"INR\",\"conversion_rate\":\"0.76\",\"min_limit\":\"1\",\"max_limit\":\"10000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, NULL, '2025-01-16 14:19:14', '2025-01-29 07:28:21'),
(11, 'instamojo', 'instamojo', 13, 'gateway/rwXQ1P62ePQcvJBIUZRkHMumLbWF73.webp', 'local', 0, '{\"api_key\":\"\",\"auth_token\":\"\",\"salt\":\"\"}', '{\"0\":{\"INR\":\"INR\"}}', NULL, '[\"INR\"]', '[{\"name\":\"INR\",\"currency_symbol\":\"INR\",\"conversion_rate\":\"0.76\",\"min_limit\":\"1\",\"max_limit\":\"10000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, NULL, '2025-01-15 23:15:22', '2025-01-29 07:28:21'),
(12, 'mollie', 'Mollie', 27, 'gateway/S83QZxmVtxCkvl8OGWFGgChxmUcQhc.webp', 'local', 0, '{\"api_key\":\"\"}', '{\"0\":{\"AED\":\"AED\",\"AUD\":\"AUD\",\"BGN\":\"BGN\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"HRK\":\"HRK\",\"HUF\":\"HUF\",\"ILS\":\"ILS\",\"ISK\":\"ISK\",\"JPY\":\"JPY\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"RON\":\"RON\",\"RUB\":\"RUB\",\"SEK\":\"SEK\",\"SGD\":\"SGD\",\"THB\":\"THB\",\"TWD\":\"TWD\",\"USD\":\"USD\",\"ZAR\":\"ZAR\"}}', NULL, '[\"AUD\",\"BRL\"]', '[{\"name\":\"AUD\",\"currency_symbol\":\"AUD\",\"conversion_rate\":\"0.014\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"BRL\",\"currency_symbol\":\"BRL\",\"conversion_rate\":\"0.045\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, NULL, '2025-01-09 07:42:36', '2025-01-29 07:28:21'),
(13, 'twocheckout', '2checkout', 11, 'gateway/bmAgQ5rUbx2rktlaztA89GEQCKYTxJ.webp', 'local', 0, '{\"merchant_code\":\"\",\"secret_key\":\"\"}', '{\"0\":{\"AFN\":\"AFN\",\"ALL\":\"ALL\",\"DZD\":\"DZD\",\"ARS\":\"ARS\",\"AUD\":\"AUD\",\"AZN\":\"AZN\",\"BSD\":\"BSD\",\"BDT\":\"BDT\",\"BBD\":\"BBD\",\"BZD\":\"BZD\",\"BMD\":\"BMD\",\"BOB\":\"BOB\",\"BWP\":\"BWP\",\"BRL\":\"BRL\",\"GBP\":\"GBP\",\"BND\":\"BND\",\"BGN\":\"BGN\",\"CAD\":\"CAD\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"COP\":\"COP\",\"CRC\":\"CRC\",\"HRK\":\"HRK\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"DOP\":\"DOP\",\"XCD\":\"XCD\",\"EGP\":\"EGP\",\"EUR\":\"EUR\",\"FJD\":\"FJD\",\"GTQ\":\"GTQ\",\"HKD\":\"HKD\",\"HNL\":\"HNL\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"IDR\":\"IDR\",\"ILS\":\"ILS\",\"JMD\":\"JMD\",\"JPY\":\"JPY\",\"KZT\":\"KZT\",\"KES\":\"KES\",\"LAK\":\"LAK\",\"MMK\":\"MMK\",\"LBP\":\"LBP\",\"LRD\":\"LRD\",\"MOP\":\"MOP\",\"MYR\":\"MYR\",\"MVR\":\"MVR\",\"MRO\":\"MRO\",\"MUR\":\"MUR\",\"MXN\":\"MXN\",\"MAD\":\"MAD\",\"NPR\":\"NPR\",\"TWD\":\"TWD\",\"NZD\":\"NZD\",\"NIO\":\"NIO\",\"NOK\":\"NOK\",\"PKR\":\"PKR\",\"PGK\":\"PGK\",\"PEN\":\"PEN\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"QAR\":\"QAR\",\"RON\":\"RON\",\"RUB\":\"RUB\",\"WST\":\"WST\",\"SAR\":\"SAR\",\"SCR\":\"SCR\",\"SGD\":\"SGD\",\"SBD\":\"SBD\",\"ZAR\":\"ZAR\",\"KRW\":\"KRW\",\"LKR\":\"LKR\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"SYP\":\"SYP\",\"THB\":\"THB\",\"TOP\":\"TOP\",\"TTD\":\"TTD\",\"TRY\":\"TRY\",\"UAH\":\"UAH\",\"AED\":\"AED\",\"USD\":\"USD\",\"VUV\":\"VUV\",\"VND\":\"VND\",\"XOF\":\"XOF\",\"YER\":\"YER\"}}', '{\"approved_url\":\"ipn\"}', '[\"AFN\",\"ARS\"]', '[{\"name\":\"AFN\",\"currency_symbol\":\"AFN\",\"conversion_rate\":\"0.63\",\"min_limit\":\"1\",\"max_limit\":\"10000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"ARS\",\"currency_symbol\":\"ARS\",\"conversion_rate\":\"3.24\",\"min_limit\":\"1\",\"max_limit\":\"10000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, NULL, '2025-01-17 17:33:10', '2025-01-29 07:28:21'),
(14, 'authorizenet', 'Authorize.Net', 7, 'gateway/kY6uyYr0nPgU0SyM69Yy4ei7aAowCu.webp', 'local', 0, '{\"login_id\":\"\",\"current_transaction_key\":\"\"}', '{\"0\":{\"AUD\":\"AUD\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"NOK\":\"NOK\",\"NZD\":\"NZD\",\"PLN\":\"PLN\",\"SEK\":\"SEK\",\"USD\":\"USD\"}}', NULL, '[\"AUD\",\"CAD\"]', '[{\"name\":\"AUD\",\"currency_symbol\":\"AUD\",\"conversion_rate\":\"0.014\",\"min_limit\":\"1\",\"max_limit\":\"10000\",\"percentage_charge\":\"0.5\",\"fixed_charge\":\"0\"},{\"name\":\"CAD\",\"currency_symbol\":\"CAD\",\"conversion_rate\":\"0.012\",\"min_limit\":\"1\",\"max_limit\":\"10000\",\"percentage_charge\":\"0.5\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 1, 'test', NULL, NULL, '2025-01-11 14:15:27', '2025-01-29 07:28:21'),
(16, 'payumoney', 'PayUmoney', 28, 'gateway/TjSy1hfABIV2RzIRECRJcwmN04sGEh.webp', 'local', 0, '{\"merchant_key\":\"\",\"salt\":\"\"}', '{\"0\":{\"INR\":\"INR\"}}', NULL, '[\"INR\"]', '[{\"name\":\"INR\",\"currency_symbol\":\"INR\",\"conversion_rate\":\"0.76\",\"min_limit\":\"1\",\"max_limit\":\"10000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 1, 'test', NULL, NULL, '2025-01-25 13:30:11', '2025-01-29 07:28:21'),
(17, 'mercadopago', 'Mercado Pago', 18, 'gateway/2UlZWhhkfVSWQepk1uBKecw4FrepZx.webp', 'local', 0, '{\"access_token\":\"\"}', '{\"0\":{\"ARS\":\"ARS\",\"BOB\":\"BOB\",\"BRL\":\"BRL\",\"CLF\":\"CLF\",\"CLP\":\"CLP\",\"COP\":\"COP\",\"CRC\":\"CRC\",\"CUC\":\"CUC\",\"CUP\":\"CUP\",\"DOP\":\"DOP\",\"EUR\":\"EUR\",\"GTQ\":\"GTQ\",\"HNL\":\"HNL\",\"MXN\":\"MXN\",\"NIO\":\"NIO\",\"PAB\":\"PAB\",\"PEN\":\"PEN\",\"PYG\":\"PYG\",\"USD\":\"USD\",\"UYU\":\"UYU\",\"VEF\":\"VEF\",\"VES\":\"VES\"}}', NULL, '[\"ARS\"]', '[{\"name\":\"ARS\",\"currency_symbol\":\"ARS\",\"conversion_rate\":\"3.24\",\"min_limit\":\"1\",\"max_limit\":\"10000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, NULL, '2025-01-12 04:28:44', '2025-01-29 07:28:21'),
(18, 'coingate', 'Coingate', 19, 'gateway/uxKFypl7GtiL0YnJhshsLKyGzf2YKt.webp', 'local', 0, '{\"api_key\":\"\"}', '{\"0\":{\"USD\":\"USD\",\"EUR\":\"EUR\"}}', NULL, '[\"USD\",\"EUR\"]', '[{\"name\":\"USD\",\"currency_symbol\":\"USD\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"EUR\",\"currency_symbol\":\"EUR\",\"conversion_rate\":\"0.0083\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 1, 'test', NULL, NULL, '2025-01-11 07:21:57', '2025-01-29 07:28:21'),
(19, 'coinbasecommerce', 'Coinbase Commerce', 16, 'gateway/POaHQGEUctnNpM9YgAvIIwq0R9aXnw.webp', 'local', 0, '{\"api_key\":\"\",\"secret\":\"\"}', '{\"0\":{\"AED\":\"AED\",\"AFN\":\"AFN\",\"ALL\":\"ALL\",\"AMD\":\"AMD\",\"ANG\":\"ANG\",\"AOA\":\"AOA\",\"ARS\":\"ARS\",\"AUD\":\"AUD\",\"AWG\":\"AWG\",\"AZN\":\"AZN\",\"BAM\":\"BAM\",\"BBD\":\"BBD\",\"BDT\":\"BDT\",\"BGN\":\"BGN\",\"BHD\":\"BHD\",\"BIF\":\"BIF\",\"BMD\":\"BMD\",\"BND\":\"BND\",\"BOB\":\"BOB\",\"BRL\":\"BRL\",\"BSD\":\"BSD\",\"BTN\":\"BTN\",\"BWP\":\"BWP\",\"BYN\":\"BYN\",\"BZD\":\"BZD\",\"CAD\":\"CAD\",\"CDF\":\"CDF\",\"CHF\":\"CHF\",\"CLF\":\"CLF\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"COP\":\"COP\",\"CRC\":\"CRC\",\"CUC\":\"CUC\",\"CUP\":\"CUP\",\"CVE\":\"CVE\",\"CZK\":\"CZK\",\"DJF\":\"DJF\",\"DKK\":\"DKK\",\"DOP\":\"DOP\",\"DZD\":\"DZD\",\"EGP\":\"EGP\",\"ERN\":\"ERN\",\"ETB\":\"ETB\",\"EUR\":\"EUR\",\"FJD\":\"FJD\",\"FKP\":\"FKP\",\"GBP\":\"GBP\",\"GEL\":\"GEL\",\"GGP\":\"GGP\",\"GHS\":\"GHS\",\"GIP\":\"GIP\",\"GMD\":\"GMD\",\"GNF\":\"GNF\",\"GTQ\":\"GTQ\",\"GYD\":\"GYD\",\"HKD\":\"HKD\",\"HNL\":\"HNL\",\"HRK\":\"HRK\",\"HTG\":\"HTG\",\"HUF\":\"HUF\",\"IDR\":\"IDR\",\"ILS\":\"ILS\",\"IMP\":\"IMP\",\"INR\":\"INR\",\"IQD\":\"IQD\",\"IRR\":\"IRR\",\"ISK\":\"ISK\",\"JEP\":\"JEP\",\"JMD\":\"JMD\",\"JOD\":\"JOD\",\"JPY\":\"JPY\",\"KES\":\"KES\",\"KGS\":\"KGS\",\"KHR\":\"KHR\",\"KMF\":\"KMF\",\"KPW\":\"KPW\",\"KRW\":\"KRW\",\"KWD\":\"KWD\",\"KYD\":\"KYD\",\"KZT\":\"KZT\",\"LAK\":\"LAK\",\"LBP\":\"LBP\",\"LKR\":\"LKR\",\"LRD\":\"LRD\",\"LSL\":\"LSL\",\"LYD\":\"LYD\",\"MAD\":\"MAD\",\"MDL\":\"MDL\",\"MGA\":\"MGA\",\"MKD\":\"MKD\",\"MMK\":\"MMK\",\"MNT\":\"MNT\",\"MOP\":\"MOP\",\"MRO\":\"MRO\",\"MUR\":\"MUR\",\"MVR\":\"MVR\",\"MWK\":\"MWK\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"MZN\":\"MZN\",\"NAD\":\"NAD\",\"NGN\":\"NGN\",\"NIO\":\"NIO\",\"NOK\":\"NOK\",\"NPR\":\"NPR\",\"NZD\":\"NZD\",\"OMR\":\"OMR\",\"PAB\":\"PAB\",\"PEN\":\"PEN\",\"PGK\":\"PGK\",\"PHP\":\"PHP\",\"PKR\":\"PKR\",\"PLN\":\"PLN\",\"PYG\":\"PYG\",\"QAR\":\"QAR\",\"RON\":\"RON\",\"RSD\":\"RSD\",\"RUB\":\"RUB\",\"RWF\":\"RWF\",\"SAR\":\"SAR\",\"SBD\":\"SBD\",\"SCR\":\"SCR\",\"SDG\":\"SDG\",\"SEK\":\"SEK\",\"SGD\":\"SGD\",\"SHP\":\"SHP\",\"SLL\":\"SLL\",\"SOS\":\"SOS\",\"SRD\":\"SRD\",\"SSP\":\"SSP\",\"STD\":\"STD\",\"SVC\":\"SVC\",\"SYP\":\"SYP\",\"SZL\":\"SZL\",\"THB\":\"THB\",\"TJS\":\"TJS\",\"TMT\":\"TMT\",\"TND\":\"TND\",\"TOP\":\"TOP\",\"TRY\":\"TRY\",\"TTD\":\"TTD\",\"TWD\":\"TWD\",\"TZS\":\"TZS\",\"UAH\":\"UAH\",\"UGX\":\"UGX\",\"USD\":\"USD\",\"UYU\":\"UYU\",\"UZS\":\"UZS\",\"VEF\":\"VEF\",\"VND\":\"VND\",\"VUV\":\"VUV\",\"WST\":\"WST\",\"XAF\":\"XAF\",\"XAG\":\"XAG\",\"XAU\":\"XAU\",\"XCD\":\"XCD\",\"XDR\":\"XDR\",\"XOF\":\"XOF\",\"XPD\":\"XPD\",\"XPF\":\"XPF\",\"XPT\":\"XPT\",\"YER\":\"YER\",\"ZAR\":\"ZAR\",\"ZMW\":\"ZMW\",\"ZWL\":\"ZWL\"}}', '{\"webhook\":\"ipn\"}', '[\"AED\",\"ALL\"]', '[{\"name\":\"AED\",\"currency_symbol\":\"AED\",\"conversion_rate\":\"0.033\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"ALL\",\"currency_symbol\":\"ALL\",\"conversion_rate\":\"0.85\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, NULL, '2025-01-01 01:08:05', '2025-01-29 07:28:21'),
(20, 'monnify', 'Monnify', 20, 'gateway/N9ZZ4F4YeYM4m78gZW0Gnm8HTu037v.webp', 'local', 0, '{\"api_key\":\"\",\"secret_key\":\"\",\"contract_code\":\"\"}', '{\"0\":{\"NGN\":\"NGN\"}}', NULL, '[\"NGN\"]', '[{\"name\":\"NGN\",\"currency_symbol\":\"NGN\",\"conversion_rate\":\"7.40\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, NULL, '2025-01-24 15:17:46', '2025-01-29 07:28:21'),
(22, 'coinpayments', 'CoinPayments', 21, 'gateway/truY5ILTjTIFunGBf7Hn5vcWSxYw6Q.webp', 'local', 0, '{\"merchant_id\":\"\",\"private_key\":\"\",\"public_key\":\"\"}', '{\"0\":{\"USD\":\"USD\",\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CHF\":\"CHF\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"GBP\":\"GBP\",\"HKD\":\"HKD\",\"INR\":\"INR\",\"ISK\":\"ISK\",\"JPY\":\"JPY\",\"KRW\":\"KRW\",\"NZD\":\"NZD\",\"PLN\":\"PLN\",\"RUB\":\"RUB\",\"SEK\":\"SEK\",\"SGD\":\"SGD\",\"THB\":\"THB\",\"TWD\":\"TWD\"},\"1\":{\"BTC\":\"Bitcoin\",\"BTC.LN\":\"Bitcoin (Lightning Network)\",\"LTC\":\"Litecoin\",\"CPS\":\"CPS Coin\",\"VLX\":\"Velas\",\"APL\":\"Apollo\",\"AYA\":\"Aryacoin\",\"BAD\":\"Badcoin\",\"BCD\":\"Bitcoin Diamond\",\"BCH\":\"Bitcoin Cash\",\"BCN\":\"Bytecoin\",\"BEAM\":\"BEAM\",\"BITB\":\"Bean Cash\",\"BLK\":\"BlackCoin\",\"BSV\":\"Bitcoin SV\",\"BTAD\":\"Bitcoin Adult\",\"BTG\":\"Bitcoin Gold\",\"BTT\":\"BitTorrent\",\"CLOAK\":\"CloakCoin\",\"CLUB\":\"ClubCoin\",\"CRW\":\"Crown\",\"CRYP\":\"CrypticCoin\",\"CRYT\":\"CryTrExCoin\",\"CURE\":\"CureCoin\",\"DASH\":\"DASH\",\"DCR\":\"Decred\",\"DEV\":\"DeviantCoin\",\"DGB\":\"DigiByte\",\"DOGE\":\"Dogecoin\",\"EBST\":\"eBoost\",\"EOS\":\"EOS\",\"ETC\":\"Ether Classic\",\"ETH\":\"Ethereum\",\"ETN\":\"Electroneum\",\"EUNO\":\"EUNO\",\"EXP\":\"EXP\",\"Expanse\":\"Expanse\",\"FLASH\":\"FLASH\",\"GAME\":\"GameCredits\",\"GLC\":\"Goldcoin\",\"GRS\":\"Groestlcoin\",\"KMD\":\"Komodo\",\"LOKI\":\"LOKI\",\"LSK\":\"LSK\",\"MAID\":\"MaidSafeCoin\",\"MUE\":\"MonetaryUnit\",\"NAV\":\"NAV Coin\",\"NEO\":\"NEO\",\"NMC\":\"Namecoin\",\"NVST\":\"NVO Token\",\"NXT\":\"NXT\",\"OMNI\":\"OMNI\",\"PINK\":\"PinkCoin\",\"PIVX\":\"PIVX\",\"POT\":\"PotCoin\",\"PPC\":\"Peercoin\",\"PROC\":\"ProCurrency\",\"PURA\":\"PURA\",\"QTUM\":\"QTUM\",\"RES\":\"Resistance\",\"RVN\":\"Ravencoin\",\"RVR\":\"RevolutionVR\",\"SBD\":\"Steem Dollars\",\"SMART\":\"SmartCash\",\"SOXAX\":\"SOXAX\",\"STEEM\":\"STEEM\",\"STRAT\":\"STRAT\",\"SYS\":\"Syscoin\",\"TPAY\":\"TokenPay\",\"TRIGGERS\":\"Triggers\",\"TRX\":\" TRON\",\"UBQ\":\"Ubiq\",\"UNIT\":\"UniversalCurrency\",\"USDT\":\"Tether USD (Omni Layer)\",\"VTC\":\"Vertcoin\",\"WAVES\":\"Waves\",\"XCP\":\"Counterparty\",\"XEM\":\"NEM\",\"XMR\":\"Monero\",\"XSN\":\"Stakenet\",\"XSR\":\"SucreCoin\",\"XVG\":\"VERGE\",\"XZC\":\"ZCoin\",\"ZEC\":\"ZCash\",\"ZEN\":\"Horizen\"}}', '{\"callback\":\"ipn\"}', '[\"USD\",\"AUD\"]', '[{\"name\":\"USD\",\"currency_symbol\":\"USD\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"1\",\"max_limit\":\"100000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"AUD\",\"currency_symbol\":\"AUD\",\"conversion_rate\":\"0.014\",\"min_limit\":\"1\",\"max_limit\":\"10000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, NULL, '2025-01-09 22:04:00', '2025-01-29 07:28:21'),
(23, 'blockchain', 'Blockchain', 24, 'gateway/20zn8YG4VPgOUSBQHvj0GeKMHwL4ZY.webp', 'local', 0, '{\"api_key\":\"\",\"xpub_code\":\"\"}', '{\"1\":{\"BTC\":\"BTC\"}}', NULL, '[\"BTC\"]', '[{\"name\":\"BTC\",\"currency_symbol\":\"BTC\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"50\",\"max_limit\":\"500000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 0, 0, 'live', NULL, NULL, '2025-01-02 00:35:51', '2025-01-29 07:28:21'),
(25, 'cashmaal', 'cashmaal', 25, 'gateway/7Y3IZE7VY61XHwNxRzrgWVFZx8zUu0.webp', 'local', 0, '{\"web_id\":\"\",\"ipn_key\":\"\"}', '{\"0\":{\"PKR\":\"PKR\",\"USD\":\"USD\"}}', '{\"ipn_url\":\"ipn\"}', '[\"PKR\",\"USD\"]', '[{\"name\":\"PKR\",\"currency_symbol\":\"PKR\",\"conversion_rate\":\"2.56\",\"min_limit\":\"1\",\"max_limit\":\"10000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"USD\",\"currency_symbol\":\"USD\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"1\",\"max_limit\":\"10000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, NULL, '2025-01-18 01:12:49', '2025-01-29 07:28:21'),
(26, 'midtrans', 'Midtrans', 2, 'gateway/7fRFCClfGcMefCb35AVzgnEJevUi37.webp', 'local', 0, '{\"client_key\":\"\",\"server_key\":\"\"}', '{\"0\":{\"IDR\":\"IDR\"}}', '{\"payment_notification_url\":\"ipn\", \"finish redirect_url\":\"ipn\", \"unfinish redirect_url\":\"failed\",\"error redirect_url\":\"failed\"}', '[\"IDR\"]', '[{\"name\":\"IDR\",\"currency_symbol\":\"IDR\",\"conversion_rate\":\"141.38\",\"min_limit\":\"1\",\"max_limit\":\"50000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'test', NULL, '', '2025-01-24 04:09:32', '2025-01-29 07:28:21'),
(27, 'peachpayments', 'peachpayments', 35, 'gateway/4aJggeZFR2SBLYMw9DewRUOByPaRez.webp', 'local', 0, '{\"Authorization_Bearer\":\"\",\"Entity_ID\":\"\",\"Recur_Channel\":\"\"}', '{\"0\":{\"AED\":\"AED\",\"AFA\":\"AFA\",\"AMD\":\"AMD\",\"ANG\":\"ANG\",\"AOA\":\"AOA\",\"ARS\":\"ARS\",\"AUD\":\"AUD\",\"AWG\":\"AWG\",\"AZM\":\"AZM\",\"BAM\":\"BAM\",\"BBD\":\"BBD\",\"BDT\":\"BDT\",\"BGN\":\"BGN\",\"BHD\":\"BHD\",\"BIF\":\"BIF\",\"BMD\":\"BMD\",\"BND\":\"BND\",\"BOB\":\"BOB\",\"BRL\":\"BRL\",\"BSD\":\"BSD\",\"BTN\":\"BTN\",\"BWP\":\"BWP\",\"BYR\":\"BYR\",\"BZD\":\"BZD\",\"CAD\":\"CAD\",\"CDF\":\"CDF\",\"CHF\":\"CHF\",\"CLP\":\"CLP\",\"CNY\":\"CNY\",\"COP\":\"COP\",\"CRC\":\"CRC\",\"CUP\":\"CUP\",\"CVE\":\"CVE\",\"CYP\":\"CYP\",\"CZK\":\"CZK\",\"DJF\":\"DJF\",\"DKK\":\"DKK\",\"DOP\":\"DOP\",\"DZD\":\"DZD\",\"EEK\":\"EEK\",\"EGP\":\"EGP\",\"ERN\":\"ERN\",\"ETB\":\"ETB\",\"EUR\":\"EUR\",\"FJD\":\"FJD\",\"FKP\":\"FKP\",\"GBP\":\"GBP\",\"GEL\":\"GEL\",\"GGP\":\"GGP\",\"GHC\":\"GHC\",\"GIP\":\"GIP\",\"GMD\":\"GMD\",\"GNF\":\"GNF\",\"GTQ\":\"GTQ\",\"GYD\":\"GYD\",\"HKD\":\"HKD\",\"HNL\":\"HNL\",\"HRK\":\"HRK\",\"HTG\":\"HTG\",\"HUF\":\"HUF\",\"IDR\":\"IDR\",\"ILS\":\"ILS\",\"IMP\":\"IMP\",\"INR\":\"INR\",\"IQD\":\"IQD\",\"IRR\":\"IRR\",\"ISK\":\"ISK\",\"JEP\":\"JEP\",\"JMD\":\"JMD\",\"JOD\":\"JOD\",\"JPY\":\"JPY\",\"KES\":\"KES\",\"KGS\":\"KGS\",\"KHR\":\"KHR\",\"KMF\":\"KMF\",\"KPW\":\"KPW\",\"KRW\":\"KRW\",\"KWD\":\"KWD\",\"KYD\":\"KYD\",\"KZT\":\"KZT\",\"LAK\":\"LAK\",\"LBP\":\"LBP\",\"LKR\":\"LKR\",\"LRD\":\"LRD\",\"LSL\":\"LSL\",\"LTL\":\"LTL\",\"LVL\":\"LVL\",\"LYD\":\"LYD\",\"MAD\":\"MAD\",\"MDL\":\"MDL\",\"MGA\":\"MGA\",\"MKD\":\"MKD\",\"MMK\":\"MMK\",\"MNT\":\"MNT\",\"MOP\":\"MOP\",\"MRO\":\"MRO\",\"MTL\":\"MTL\",\"MUR\":\"MUR\",\"MVR\":\"MVR\",\"MWK\":\"MWK\",\"MXN\":\"MXN\",\"MYR\":\"MYR\",\"MZM\":\"MZM\",\"NAD\":\"NAD\",\"NGN\":\"NGN\",\"NIO\":\"NIO\",\"NOK\":\"NOK\",\"NPR\":\"NPR\",\"NZD\":\"NZD\",\"OMR\":\"OMR\",\"PAB\":\"PAB\",\"PEN\":\"PEN\",\"PGK\":\"PGK\",\"PHP\":\"PHP\",\"PKR\":\"PKR\",\"PLN\":\"PLN\",\"PTS\":\"PTS\",\"PYG\":\"PYG\",\"QAR\":\"QAR\",\"RON\":\"RON\",\"RUB\":\"RUB\",\"RWF\":\"RWF\",\"SAR\":\"SAR\",\"SBD\":\"SBD\",\"SCR\":\"SCR\",\"SDD\":\"SDD\",\"SEK\":\"SEK\",\"SGD\":\"SGD\",\"SHP\":\"SHP\",\"SIT\":\"SIT\",\"SKK\":\"SKK\",\"SLL\":\"SLL\",\"SOS\":\"SOS\",\"SPL\":\"SPL\",\"SRD\":\"SRD\",\"STD\":\"STD\",\"SVC\":\"SVC\",\"SYP\":\"SYP\",\"SZL\":\"SZL\",\"THB\":\"THB\",\"TJS\":\"TJS\",\"TMM\":\"TMM\",\"TND\":\"TND\",\"TOP\":\"TOP\",\"TRL\":\"TRL\",\"TRY\":\"TRY\",\"TTD\":\"TTD\",\"TVD\":\"TVD\",\"TWD\":\"TWD\",\"TZS\":\"TZS\",\"UAH\":\"UAH\",\"UGX\":\"UGX\",\"USD\":\"USD\",\"UYU\":\"UYU\",\"UZS\":\"UZS\",\"VEF\":\"VEF\",\"VND\":\"VND\",\"VUV\":\"VUV\",\"WST\":\"WST\",\"XAF\":\"XAF\",\"XAG\":\"XAG\",\"XAU\":\"XAU\",\"XCD\":\"XCD\",\"XDR\":\"XDR\",\"XOF\":\"XOF\",\"XPD\":\"XPD\",\"XPF\":\"XPF\",\"XPT\":\"XPT\",\"YER\":\"YER\",\"ZAR\":\"ZAR\",\"ZMK\":\"ZMK\",\"ZWD\":\"ZWD\"}}', NULL, '[\"CAD\",\"AED\"]', '[{\"name\":\"CAD\",\"currency_symbol\":\"CAD\",\"conversion_rate\":\"0.012\",\"min_limit\":\"1\",\"max_limit\":\"10000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"AED\",\"currency_symbol\":\"AED\",\"conversion_rate\":\"0.033\",\"min_limit\":\"1\",\"max_limit\":\"10000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 1, 'live', NULL, '', '2025-01-22 08:25:48', '2025-01-29 07:28:21'),
(28, 'nowpayments', 'Nowpayments', 26, 'gateway/Z5wvvbRZN7nZUC6GgPTqMyf1lM2WBf.webp', 'local', 0, '{\"api_key\":\"\"}', '{\"1\":{\"BTG\":\"BTG\",\"ETH\":\"ETH\",\"XMR\":\"XMR\",\"ZEC\":\"ZEC\",\"XVG\":\"XVG\",\"ADA\":\"ADA\",\"LTC\":\"LTC\",\"BCH\":\"BCH\",\"QTUM\":\"QTUM\",\"DASH\":\"DASH\",\"XLM\":\"XLM\",\"XRP\":\"XRP\",\"XEM\":\"XEM\",\"DGB\":\"DGB\",\"LSK\":\"LSK\",\"DOGE\":\"DOGE\",\"TRX\":\"TRX\",\"KMD\":\"KMD\",\"REP\":\"REP\",\"BAT\":\"BAT\",\"ARK\":\"ARK\",\"WAVES\":\"WAVES\",\"BNB\":\"BNB\",\"XZC\":\"XZC\",\"NANO\":\"NANO\",\"TUSD\":\"TUSD\",\"VET\":\"VET\",\"ZEN\":\"ZEN\",\"GRS\":\"GRS\",\"FUN\":\"FUN\",\"NEO\":\"NEO\",\"GAS\":\"GAS\",\"PAX\":\"PAX\",\"USDC\":\"USDC\",\"ONT\":\"ONT\",\"XTZ\":\"XTZ\",\"LINK\":\"LINK\",\"RVN\":\"RVN\",\"BNBMAINNET\":\"BNBMAINNET\",\"ZIL\":\"ZIL\",\"BCD\":\"BCD\",\"USDTERC20\":\"USDTERC20\",\"CRO\":\"CRO\",\"DAI\":\"DAI\",\"HT\":\"HT\",\"WABI\":\"WABI\",\"BUSD\":\"BUSD\",\"ALGO\":\"ALGO\",\"USDTTRC20\":\"USDTTRC20\",\"GT\":\"GT\",\"STPT\":\"STPT\",\"AVA\":\"AVA\",\"SXP\":\"SXP\",\"UNI\":\"UNI\",\"OKB\":\"OKB\",\"BTC\":\"BTC\"}}', '{\"cron\":\"ipn\"}', '[\"ETH\",\"XEM\"]', '[{\"name\":\"ETH\",\"currency_symbol\":\"XEM\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"10\",\"max_limit\":\"500000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"},{\"name\":\"XEM\",\"currency_symbol\":\"ETH\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"10\",\"max_limit\":\"500000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 0, 1, 'live', NULL, '', '2025-01-13 05:13:20', '2025-01-29 07:28:21'),
(29, 'khalti', 'Khalti Payment', 29, 'gateway/x4BeAPBkYuM494NvWfAkrxTfk1tbUt.webp', 'local', 0, '{\"secret_key\":\"\",\"public_key\":\"\"}', '{\"0\":{\"NPR\":\"NPR\"}}', NULL, '[\"NPR\"]', '[{\"name\":\"NPR\",\"currency_symbol\":\"NPR\",\"conversion_rate\":\"1.21\",\"min_limit\":\"1\",\"max_limit\":\"50000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, '', '2025-01-13 14:27:13', '2025-01-29 07:28:21'),
(30, 'swagger', 'MAGUA PAY', 22, 'gateway/j8bFL5e5LOn6YkquKQiy6com8w1uj2.webp', 'local', 0, '{\"MAGUA_PAY_ACCOUNT\":\"\",\"MerchantKey\":\"\",\"Secret\":\"\"}', '{\"0\":{\"EUR\":\"EUR\"}}', NULL, '[\"EUR\"]', '[{\"name\":\"EUR\",\"currency_symbol\":\"EUR\",\"conversion_rate\":\"0.0083\",\"min_limit\":\"1\",\"max_limit\":\"50000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, '', '2024-12-31 18:04:15', '2025-01-29 07:28:21'),
(31, 'freekassa', 'Free kassa', 36, 'gateway/VqJR12ZLuhmisIpUbpm6p2OCqm4hHC.webp', 'local', 0, '{\"merchant_id\":\"\",\"merchant_key\":\"\",\"secret_word\":\"\",\"secret_word2\":\"\"}', '{\"0\":{\"RUB\":\"RUB\",\"USD\":\"USD\",\"EUR\":\"EUR\",\"UAH\":\"UAH\",\"KZT\":\"KZT\"}}', '{\"ipn_url\":\"ipn\"}', '[\"RUB\",\"USD\"]', '[{\"name\":\"RUB\",\"currency_symbol\":\"RUB\",\"conversion_rate\":\"0.81\",\"min_limit\":\"1\",\"max_limit\":\"15000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"USD\",\"currency_symbol\":\"USD\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"1\",\"max_limit\":\"50000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, '', '2025-01-11 08:23:33', '2025-01-29 07:28:21'),
(32, 'konnect', 'Konnect', 30, 'gateway/DIWitJin1UBjkwTLrSPcstnUDGmTz3.webp', 'local', 0, '{\"api_key\":\"\",\"receiver_wallet_Id\":\"\"}', '{\"0\":{\"TND\":\"TND\",\"EUR\":\"EUR\",\"USD\":\"USD\"}}', '{\"webhook\":\"ipn\"}', '[\"USD\",\"TND\",\"EUR\"]', '[{\"name\":\"USD\",\"currency_symbol\":\"USD\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"1\",\"max_limit\":\"15000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"TND\",\"currency_symbol\":\"TND\",\"conversion_rate\":\"0.028\",\"min_limit\":\"1\",\"max_limit\":\"20000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"},{\"name\":\"EUR\",\"currency_symbol\":\"EUR\",\"conversion_rate\":\"0.0083\",\"min_limit\":\"1\",\"max_limit\":\"60000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 1, 'live', NULL, '', '2025-01-03 09:37:20', '2025-01-29 07:28:21'),
(33, 'mypay', 'Mypay Np', 32, 'gateway/kkBeSnA5MFdlLrrSOpF3dJp1JwMxIB.webp', 'local', 0, '{\"merchant_username\":\"\",\"merchant_api_password\":\"\",\"merchant_id\":\"\",\"api_key\":\"\"}', '{\"0\":{\"NPR\":\"NPR\"}}', NULL, '[\"NPR\"]', '[{\"name\":\"NPR\",\"currency_symbol\":\"NPR\",\"conversion_rate\":\"1.21\",\"min_limit\":\"1\",\"max_limit\":\"15000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 1, 'live', NULL, '', '2025-01-09 23:54:54', '2025-01-29 07:28:21'),
(35, 'imepay', 'IME PAY', 9, 'gateway/YuBFrsBWuxf17sqB6z8y039xgdxyat.webp', 'local', 0, '{\"MerchantModule\":\"\",\"MerchantCode\":\"\",\"username\":\"\",\"password\":\"\"}', '{\"0\":{\"NPR\":\"NPR\"}}', NULL, '[\"NPR\"]', '[{\"name\":\"NPR\",\"currency_symbol\":\"NPR\",\"conversion_rate\":\"1.21\",\"min_limit\":\"10\",\"max_limit\":\"15000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"1.5\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, '', '2025-01-15 18:50:23', '2025-01-29 07:28:21'),
(36, 'cashonexHosted', 'Cashonex Hosted', 14, 'gateway/GAcL1CamWpPaeDGaD6aSInqXknXK50.webp', 'local', 0, '{\"idempotency_key\":\"\",\"salt\":\"\"}', '{\"0\":{\"USD\":\"USD\"}}', NULL, '[\"USD\"]', '[{\"name\":\"USD\",\"currency_symbol\":\"USD\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"1\",\"max_limit\":\"15000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, NULL, '2025-01-05 05:58:07', '2025-01-29 07:28:21'),
(37, 'cashonex', 'cashonex', 31, 'gateway/rbbey8zLDMKdNPftwRdOSY79eVEGLi.webp', 'local', 0, '{\"idempotency_key\":\"\",\"salt\":\"\"}', '{\"0\":{\"USD\":\"USD\"}}', NULL, '[\"USD\"]', '[{\"name\":\"USD\",\"currency_symbol\":\"USD\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"1\",\"max_limit\":\"15000\",\"percentage_charge\":\"0.0\",\"fixed_charge\":\"0.5\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, NULL, '2025-01-23 21:24:39', '2025-01-29 07:28:21'),
(38, 'binance', 'Binance', 8, 'gateway/bZ7w2koAzATHG9gp8k6JzRhhusXTpH.webp', 'local', 0, '{\"mercent_api_key\":\"\",\"mercent_secret\":\"\"}', '{\"1\":{\"ADA\":\"ADA\",\"ATOM\":\"ATOM\",\"AVA\":\"AVA\",\"BCH\":\"BCH\",\"BNB\":\"BNB\",\"BTC\":\"BTC\",\"BUSD\":\"BUSD\",\"CTSI\":\"CTSI\",\"DASH\":\"DASH\",\"DOGE\":\"DOGE\",\"DOT\":\"DOT\",\"EGLD\":\"EGLD\",\"EOS\":\"EOS\",\"ETC\":\"ETC\",\"ETH\":\"ETH\",\"FIL\":\"FIL\",\"FRONT\":\"FRONT\",\"FTM\":\"FTM\",\"GRS\":\"GRS\",\"HBAR\":\"HBAR\",\"IOTX\":\"IOTX\",\"LINK\":\"LINK\",\"LTC\":\"LTC\",\"MANA\":\"MANA\",\"MATIC\":\"MATIC\",\"NEO\":\"NEO\",\"OM\":\"OM\",\"ONE\":\"ONE\",\"PAX\":\"PAX\",\"QTUM\":\"QTUM\",\"STRAX\":\"STRAX\",\"SXP\":\"SXP\",\"TRX\":\"TRX\",\"TUSD\":\"TUSD\",\"UNI\":\"UNI\",\"USDC\":\"USDC\",\"USDT\":\"USDT\",\"WRX\":\"WRX\",\"XLM\":\"XLM\",\"XMR\":\"XMR\",\"XRP\":\"XRP\",\"XTZ\":\"XTZ\",\"XVS\":\"XVS\",\"ZEC\":\"ZEC\",\"ZIL\":\"ZIL\"}}', NULL, '[\"BTC\"]', '[{\"name\":\"BTC\",\"currency_symbol\":\"BTC\",\"conversion_rate\":\"0.000027\",\"min_limit\":\"1\",\"max_limit\":\"5\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 0, 0, 'live', NULL, NULL, '2025-01-20 13:50:52', '2025-01-29 07:28:21'),
(39, 'cinetpay', 'CinetPay ', 37, 'gateway/9WCd4Kn4EvlDX8y4V3bEV7eazCTlla.webp', 'local', 0, '{\"apiKey\":\"\",\"site_id\":\"\"}', '{\"0\":{\"XOF\":\"XOF\",\"XAF\":\"XAF\",\"CDF\":\"CDF\",\"GNF\":\"GNF\",\"USD\":\"USD\"}}', 'NULL', '[\"XOF\"]', '[{\"name\":\"XOF\",\"currency_symbol\":\"XOF\",\"conversion_rate\":\"5.45\",\"min_limit\":\"1\",\"max_limit\":\"50000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'test', NULL, NULL, '2025-01-08 13:28:48', '2025-01-29 07:28:21'),
(1000, 'bank-transfer', 'Bank Transfer', 1, 'gateway/A2zYpiPKpPWcByCCys7mpnCugQEHvv.webp', 'local', 1, '{\"AccountNumber\":{\"field_name\":\"AccountNumber\",\"field_label\":\"Account Number\",\"type\":\"text\",\"validation\":\"required\"},\"BeneficiaryName\":{\"field_name\":\"BeneficiaryName\",\"field_label\":\"Beneficiary Name\",\"type\":\"text\",\"validation\":\"required\"},\"NID\":{\"field_name\":\"NID\",\"field_label\":\"NID\",\"type\":\"file\",\"validation\":\"required\"},\"Address\":{\"field_name\":\"Address\",\"field_label\":\"Address\",\"type\":\"text\",\"validation\":\"required\"}}', NULL, NULL, '[\"USD\",\"EUR\"]', '[{\"currency\":\"USD\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"1\",\"max_limit\":\"1000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"currency\":\"EUR\",\"conversion_rate\":\"0.0086\",\"min_limit\":\"1\",\"max_limit\":\"1000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 'Send form your payment gateway. your bank may charge you a cash advance fee.', 1, 0, 'live', NULL, 'Send form your payment gateway. your bank may charge you a cash advance fee.Send form your payment gateway. your bank may charge you a cash advance fee.Send form your payment gateway. your bank may charge you a cash advance fee.Send form your payment gateway. your bank may charge you a cash advance fee.Send form your payment gateway. your bank may charge you a cash advance fee.', '2025-01-15 10:30:13', '2025-01-15 10:30:13');

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

--
-- Table structure for table `investment_plans`
--

CREATE TABLE `investment_plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `plan_name` varchar(50) DEFAULT NULL,
  `short_description` varchar(255) DEFAULT NULL,
  `plan_price` decimal(10,2) DEFAULT NULL,
  `plan_period` int(11) DEFAULT NULL,
  `plan_period_type` varchar(10) DEFAULT NULL,
  `min_invest` decimal(10,2) DEFAULT NULL,
  `max_invest` decimal(10,2) DEFAULT NULL,
  `return_typ_has_lifetime` tinyint(4) NOT NULL DEFAULT 0,
  `amount_has_fixed` tinyint(4) NOT NULL DEFAULT 0,
  `return_period` int(11) DEFAULT NULL,
  `return_period_type` varchar(10) DEFAULT NULL,
  `unlimited_period` tinyint(4) NOT NULL DEFAULT 0,
  `number_of_profit_return` int(11) DEFAULT NULL,
  `profit` decimal(10,2) DEFAULT NULL,
  `profit_type` varchar(10) DEFAULT NULL,
  `capital_back` tinyint(4) NOT NULL DEFAULT 0,
  `maturity` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `soft_delete` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `invest_histories`
--

CREATE TABLE `invest_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `plan_id` bigint(20) UNSIGNED NOT NULL,
  `invest_amount` decimal(11,2) NOT NULL,
  `profit` decimal(11,2) NOT NULL,
  `number_of_return` int(11) NOT NULL,
  `is_life_time` tinyint(1) NOT NULL,
  `return_period` int(11) NOT NULL,
  `return_period_type` varchar(255) NOT NULL,
  `next_return` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `capital_back` tinyint(1) NOT NULL,
  `plan_expiry_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `plan_period_is_lifetime` tinyint(1) NOT NULL DEFAULT 0,
  `last_profit` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `total_return` int(11) NOT NULL,
  `trx` varchar(255) 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 `in_app_notifications`
--

CREATE TABLE `in_app_notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `in_app_notificationable_id` int(11) DEFAULT NULL,
  `in_app_notificationable_type` varchar(255) DEFAULT NULL,
  `description` text 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 `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `karats`
--

CREATE TABLE `karats` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `karat` decimal(8,2) NOT NULL,
  `price` decimal(8,2) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `karats`
--

INSERT INTO `karats` (`id`, `karat`, `price`, `status`, `created_at`, `updated_at`) VALUES
(1, 24.00, 85.00, 1, '2025-01-24 12:39:14', '2025-01-24 12:39:14'),
(2, 23.00, 80.00, 1, '2025-01-10 02:42:40', '2025-01-10 02:42:40'),
(3, 22.00, 75.00, 1, '2025-01-17 01:28:24', '2025-01-17 01:28:24'),
(4, 21.00, 70.00, 1, '2025-01-11 06:32:35', '2025-01-11 06:32:35'),
(5, 20.00, 60.00, 1, '2025-01-18 11:00:12', '2025-01-18 11:00:12');

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

--
-- Table structure for table `kycs`
--

CREATE TABLE `kycs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `input_form` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1 => Active, 0 => Inactive',
  `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 `kycs`
--

INSERT INTO `kycs` (`id`, `name`, `slug`, `input_form`, `status`, `created_at`, `updated_at`) VALUES
(12, 'NID Vefication', 'nid-vefication', '{\"FullName\":{\"field_name\":\"FullName\",\"field_label\":\"Full Name\",\"type\":\"text\",\"validation\":\"required\"},\"NIDNumber\":{\"field_name\":\"NIDNumber\",\"field_label\":\"NID Number\",\"type\":\"text\",\"validation\":\"required\"},\"DateOfBirth\":{\"field_name\":\"DateOfBirth\",\"field_label\":\"Date Of Birth\",\"type\":\"date\",\"validation\":\"required\"},\"NID\":{\"field_name\":\"NID\",\"field_label\":\"NID\",\"type\":\"file\",\"validation\":\"required\"}}', 0, '2025-01-24 06:16:47', '2025-01-24 06:16:47'),
(13, 'Address Verification', 'address-verification', '{\"Name\":{\"field_name\":\"Name\",\"field_label\":\"Name\",\"type\":\"text\",\"validation\":\"required\"},\"PermanentAddress\":{\"field_name\":\"PermanentAddress\",\"field_label\":\"Permanent Address\",\"type\":\"text\",\"validation\":\"required\"}}', 0, '2025-01-11 08:05:32', '2025-01-11 08:05:32'),
(14, 'Passport Verification', 'passport-verification', '{\"Name\":{\"field_name\":\"Name\",\"field_label\":\"Name\",\"type\":\"text\",\"validation\":\"required\"},\"PN\":{\"field_name\":\"PN\",\"field_label\":\"PN\",\"type\":\"text\",\"validation\":\"required\"}}', 0, '2025-01-02 17:46:38', '2025-01-02 17:46:38');

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

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

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `short_name` varchar(255) DEFAULT NULL,
  `flag` varchar(255) DEFAULT NULL,
  `flag_driver` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0 => Inactive, 1 => Active',
  `rtl` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 => Inactive, 1 => Active',
  `default_status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `languages` (`id`, `name`, `short_name`, `flag`, `flag_driver`, `status`, `rtl`, `default_status`, `created_at`, `updated_at`) VALUES
(1, 'English', 'en', 'language/Tffwh41UiRo9GqB9P9OHiWP7R5lujb.avif', 'local', 1, 0, 1, '2025-01-12 19:26:53', '2025-01-12 19:26:53');

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

--
-- Table structure for table `maintenance_modes`
--

CREATE TABLE `maintenance_modes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `heading` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `image_driver` varchar(255) 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 `maintenance_modes`
--

INSERT INTO `maintenance_modes` (`id`, `heading`, `description`, `image`, `image_driver`, `created_at`, `updated_at`) VALUES
(1, 'The website under maintenance!', '<p>We are currently undergoing scheduled maintenance to improve our services and enhance your user experience. During this time, our website/system will be temporarily unavailable.\r\n</p><p><br></p><p>\r\nWe apologize for any inconvenience this may cause and appreciate your patience. Please rest assured that we are working diligently to complete the maintenance as quickly as possible.</p>', 'maintenanceMode/3jXAnm42OZuYy3kVDcHKUjW3gyiG8eSo96rlgg19.png', 'local', '2025-01-19 22:39:40', '2025-01-19 22:39:40');

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

--
-- Table structure for table `manage_menus`
--

CREATE TABLE `manage_menus` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `menu_section` varchar(255) NOT NULL,
  `menu_items` varchar(255) 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 `manage_menus`
--

INSERT INTO `manage_menus` (`id`, `menu_section`, `menu_items`, `created_at`, `updated_at`) VALUES
(3, 'header', '[\"home\",\"pricing\",\"Shop\",\"about\",\"Blog\",\"contact\"]', '2025-01-03 02:03:11', '2025-02-01 01:27:00'),
(4, 'footer', '{\"useful_link\":[\"blog\",\"contact\",\"about\"],\"support_link\":[\"privacy policy\",\"terms &amp; condition\",\"cookie &amp; policy\"]}', '2025-01-06 09:01:59', '2025-02-01 01:27:27');

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

--
-- Table structure for table `manual_sms_configs`
--

CREATE TABLE `manual_sms_configs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `action_method` varchar(255) DEFAULT NULL,
  `action_url` varchar(255) DEFAULT NULL,
  `header_data` text DEFAULT NULL,
  `param_data` text DEFAULT NULL,
  `form_data` text 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 `manual_sms_configs`
--

INSERT INTO `manual_sms_configs` (`id`, `action_method`, `action_url`, `header_data`, `param_data`, `form_data`, `created_at`, `updated_at`) VALUES
(1, 'POST', 'https://rest.nexmo.com/sms/json', '{\"Content-Type\":\"application\\/x-www-form-urlencoded\"}', NULL, '{\"from\":\"Rownak\",\"text\":\"[[message]]\",\"to\":\"[[receiver]]\",\"api_key\":\"930cc608\",\"api_secret\":\"2pijsaMOUw5YKOK5\"}', '2025-01-13 07:05:20', '2025-01-13 07:05:20');

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

--
-- Table structure for table `materials`
--

CREATE TABLE `materials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `material` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `materials`
--

INSERT INTO `materials` (`id`, `material`, `status`, `created_at`, `updated_at`) VALUES
(2, 'Gold', 1, '2025-01-16 05:59:11', '2025-01-16 05:59:11'),
(3, 'Silver', 0, '2025-01-24 20:09:10', '2025-01-24 20:09:10'),
(4, 'Dimond', 1, '2025-01-02 16:33:40', '2025-01-02 16:33:40'),
(5, 'City Gold', 0, '2025-01-03 15:37:06', '2025-01-03 15:37:06'),
(6, 'White Gold', 0, '2025-01-13 14:35:46', '2025-01-13 14:35:46'),
(7, 'Yellow Gold', 0, '2025-01-07 08:56:44', '2025-01-07 08:56:44'),
(8, 'Rose Gold', 1, '2025-01-10 13:13:55', '2025-01-10 13:13:55'),
(9, 'Platinum', 1, '2025-01-04 05:18:19', '2025-01-04 05:18:19'),
(10, 'Palladium', 0, '2025-01-24 05:51:33', '2025-01-24 05:51:33'),
(11, 'Titanium', 0, '2025-01-19 09:44:59', '2025-01-19 09:44:59'),
(12, 'Rhodium-plated metals', 0, '2025-01-18 02:16:52', '2025-01-18 02:16:52'),
(13, 'Ruby', 0, '2025-01-08 21:35:59', '2025-01-08 21:35:59'),
(14, 'Sapphire', 0, '2025-01-20 06:04:11', '2025-01-20 06:04:11'),
(15, 'Emerald', 0, '2025-01-21 21:56:45', '2025-01-21 21:56:45');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2014_10_12_100000_create_password_resets_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(6, '2023_06_07_064911_create_admins_table', 1),
(7, '2023_06_10_061241_create_basic_controls_table', 1),
(8, '2023_06_10_123329_create_file_storages_table', 1),
(9, '2023_06_17_085447_create_languages_table', 1),
(10, '2023_06_20_080624_create_support_tickets_table', 1),
(11, '2023_06_20_080731_create_support_ticket_messages_table', 1),
(12, '2023_06_20_080833_create_support_ticket_attachments_table', 1),
(13, '2023_06_20_212143_create_fire_base_tokens_table', 1),
(14, '2023_06_21_124322_create_in_app_notifications_table', 1),
(15, '2023_06_22_084256_create_gateways_table', 1),
(16, '2023_07_15_162549_create_kycs_table', 1),
(17, '2023_07_17_094844_create_pages_table', 1),
(18, '2023_07_17_101515_create_manage_menus_table', 1),
(19, '2023_08_20_140757_create_contents_table', 1),
(20, '2023_08_20_140808_create_content_details_table', 1),
(21, '2023_09_07_151706_create_user_logins_table', 1),
(22, '2023_09_09_105217_create_transactions_table', 1),
(23, '2023_09_09_105353_create_funds_table', 1),
(24, '2023_09_19_131540_create_deposits_table', 1),
(25, '2023_09_20_093121_create_payouts_table', 1),
(26, '2023_10_02_162152_create_page_details_table', 1),
(27, '2023_10_04_102054_create_maintenance_modes_table', 1),
(28, '2023_10_05_145420_create_notification_templates_table', 1),
(29, '2023_10_19_140559_create_manual_sms_configs_table', 1),
(30, '2023_10_19_161530_create_jobs_table', 1),
(31, '2023_12_10_085818_create_blog_categories_table', 1),
(32, '2023_12_10_094858_create_blogs_table', 1),
(33, '2023_12_10_094925_create_blog_details_table', 1),
(34, '2024_08_28_105346_create_user_kycs_table', 1),
(35, '2024_08_28_110406_create_payout_methods_table', 1),
(36, '2024_08_28_113721_create_razorpay_contacts_table', 1),
(37, '2024_12_09_113447_create_investment_plans_table', 2),
(38, '2024_12_09_113915_create_invest_histories_table', 2),
(49, '2024_12_09_122746_create_categories_table', 3),
(50, '2024_12_09_123208_create_sub_categories_table', 3),
(51, '2024_12_09_123306_create_products_table', 3),
(52, '2024_12_09_123802_create_product_details_table', 3),
(53, '2024_12_09_124531_create_product_images_table', 3),
(54, '2024_12_10_045240_create_karats_table', 3),
(55, '2024_12_10_045252_create_materials_table', 3),
(56, '2024_12_10_103534_create_ratings_table', 4),
(57, '2024_12_10_103706_create_rating_comments_table', 4),
(58, '2024_12_10_103914_create_wish_lists_table', 4),
(59, '2024_12_10_124411_create_coupons_table', 5),
(60, '2024_12_10_124714_create_coupon_applicable_products_table', 5),
(61, '2024_12_10_125222_create_areas_table', 6),
(62, '2024_12_10_125255_create_shipping_charges_table', 6),
(63, '2024_12_10_125826_create_orders_table', 6),
(64, '2024_12_10_130111_create_rankings_table', 6),
(65, '2024_12_10_131045_add_new_column_to_basic_controls_table', 6),
(66, '2024_12_10_134857_create_referral_bonuses_table', 7),
(67, '2024_12_10_135213_create_referrals_table', 8),
(68, '2024_12_10_142135_add_new_column_to_users_table', 9),
(69, '2024_12_14_074704_add_new_column_to_investment_plans', 10),
(70, '2024_12_14_074737_add_new_column_to_karats', 11),
(71, '2024_12_17_084907_create_order_items_table', 12),
(72, '2024_12_18_075909_add_new_column_to_products_table', 13),
(73, '2024_12_21_155225_create_notification_permissions_table', 14),
(74, '2024_12_28_073354_create_subscribers_table', 15),
(75, '2024_12_28_164400_create_withdrawal_days_table', 16),
(76, '2025_01_28_064057_add_new_column_to_users_table', 17);

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

--
-- Table structure for table `notification_permissions`
--

CREATE TABLE `notification_permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `notifyable_id` bigint(20) UNSIGNED DEFAULT NULL,
  `notifyable_type` varchar(255) DEFAULT NULL,
  `template_email_key` text DEFAULT NULL,
  `template_sms_key` text DEFAULT NULL,
  `template_in_app_key` text DEFAULT NULL,
  `template_push_key` text 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 `notification_templates`
--

CREATE TABLE `notification_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email_from` varchar(255) DEFAULT NULL,
  `template_key` varchar(255) DEFAULT NULL,
  `subject` text DEFAULT NULL,
  `short_keys` text DEFAULT NULL,
  `email` text DEFAULT NULL,
  `sms` text DEFAULT NULL,
  `in_app` text DEFAULT NULL,
  `push` text DEFAULT NULL,
  `status` text DEFAULT NULL COMMENT '	mail = 0(inactive), mail = 1(active), sms = 0(inactive), sms = 1(active), in_app = 0(inactive), in_app = 1(active), push = 0(inactive), push = 1(active)',
  `notify_for` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 => user, 1 => admin',
  `lang_code` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `gateway_id` bigint(20) UNSIGNED DEFAULT NULL,
  `order_number` varchar(60) DEFAULT NULL,
  `first_name` varchar(60) DEFAULT NULL,
  `last_name` varchar(60) DEFAULT NULL,
  `email` varchar(60) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `city` varchar(60) DEFAULT NULL,
  `state` varchar(60) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `address` varchar(60) DEFAULT NULL,
  `area_id` bigint(20) UNSIGNED DEFAULT NULL,
  `additional_information` text DEFAULT NULL,
  `coupon_code` varchar(60) DEFAULT NULL,
  `discount` decimal(10,2) DEFAULT NULL,
  `payment_status` tinyint(1) NOT NULL DEFAULT 0,
  `order_status` tinyint(4) NOT NULL DEFAULT 0,
  `subtotal` decimal(10,2) DEFAULT NULL,
  `delivery_charge` decimal(10,2) DEFAULT NULL,
  `vat` decimal(10,2) DEFAULT NULL,
  `working_cost` decimal(10,2) NOT NULL DEFAULT 0.00,
  `total` decimal(10,2) DEFAULT NULL,
  `due` decimal(10,2) NOT NULL DEFAULT 0.00,
  `transaction_id` varchar(60) 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 `order_items`
--

CREATE TABLE `order_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `price` decimal(8,2) NOT NULL DEFAULT 0.00,
  `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 `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `template_name` varchar(191) DEFAULT NULL,
  `custom_link` varchar(255) DEFAULT NULL,
  `page_title` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keywords` text DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `og_description` text DEFAULT NULL,
  `meta_robots` varchar(255) DEFAULT NULL,
  `meta_image` varchar(255) DEFAULT NULL,
  `meta_image_driver` varchar(50) DEFAULT NULL,
  `breadcrumb_image` varchar(255) DEFAULT NULL,
  `breadcrumb_image_driver` varchar(50) DEFAULT NULL,
  `breadcrumb_status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0 => inactive, 1 => active',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0 => unpublish, 1 => publish',
  `type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 => admin create, 1 => developer create, 2 => create for menus',
  `is_breadcrumb_img` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

--
-- Table structure for table `page_details`
--

CREATE TABLE `page_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `page_id` bigint(20) UNSIGNED DEFAULT NULL,
  `language_id` int(10) UNSIGNED DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `sections` text 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 `password_resets`
--

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

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

--
-- Table structure for table `password_reset_tokens`
--

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

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

--
-- Table structure for table `payouts`
--

CREATE TABLE `payouts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payout_method_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payout_currency_code` varchar(255) DEFAULT NULL,
  `amount` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `charge` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `net_amount` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `amount_in_base_currency` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `charge_in_base_currency` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `net_amount_in_base_currency` decimal(18,8) NOT NULL DEFAULT 0.00000000,
  `response_id` varchar(255) DEFAULT NULL,
  `last_error` varchar(255) DEFAULT NULL,
  `information` text DEFAULT NULL,
  `meta_field` varchar(255) DEFAULT NULL,
  `feedback` text DEFAULT NULL,
  `trx_id` varchar(50) DEFAULT NULL,
  `balance_type` varchar(20) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `payout_methods`
--

CREATE TABLE `payout_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `bank_name` text DEFAULT NULL COMMENT 'automatic payment for bank name',
  `banks` text DEFAULT NULL COMMENT 'admin bank permission',
  `parameters` text DEFAULT NULL COMMENT 'api parameters',
  `extra_parameters` text DEFAULT NULL,
  `inputForm` text DEFAULT NULL,
  `currency_lists` text DEFAULT NULL,
  `supported_currency` text DEFAULT NULL,
  `payout_currencies` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 = active, 0 = inactive',
  `is_automatic` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 = not active, 1 = active',
  `is_sandbox` tinyint(1) DEFAULT 0,
  `environment` enum('test','live') NOT NULL DEFAULT 'live',
  `confirm_payout` tinyint(1) NOT NULL DEFAULT 1,
  `is_auto_update` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'currency rate auto update',
  `currency_type` tinyint(1) NOT NULL DEFAULT 1,
  `logo` varchar(255) DEFAULT NULL,
  `driver` varchar(20) 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 `payout_methods`
--

INSERT INTO `payout_methods` (`id`, `name`, `code`, `description`, `bank_name`, `banks`, `parameters`, `extra_parameters`, `inputForm`, `currency_lists`, `supported_currency`, `payout_currencies`, `is_active`, `is_automatic`, `is_sandbox`, `environment`, `confirm_payout`, `is_auto_update`, `currency_type`, `logo`, `driver`, `created_at`, `updated_at`) VALUES
(2, 'Bank Transfer', 'paypal-manual', 'Payment will receive within 9 hours', NULL, NULL, '[]', NULL, '{\"account_name\":{\"field_name\":\"account_name\",\"field_label\":\"Account Name\",\"type\":\"text\",\"validation\":\"required\"},\"account_details\":{\"field_name\":\"account_details\",\"field_label\":\"Account Details\",\"type\":\"textarea\",\"validation\":\"required\"},\"n_i_d\":{\"field_name\":\"n_i_d\",\"field_label\":\"NID\",\"type\":\"file\",\"validation\":\"required\"}}', NULL, '[\"EUR\",\"CAD\"]', '[{\"currency_symbol\":\"EUR\",\"conversion_rate\":\"0.96\",\"min_limit\":\"1\",\"max_limit\":\"10000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"currency_symbol\":\"CAD\",\"conversion_rate\":\"1.44\",\"min_limit\":\"1\",\"max_limit\":\"10000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 1, 0, 0, 'test', 1, 0, 1, 'payoutMethod/ak6zVFBh2VA9vLBwxKOZad8rklp79E4lO4P8aTji.png', 'local', '2025-01-07 05:12:12', '2025-01-07 05:12:12'),
(3, 'Bank', 'bank', 'Payment will receive within 8 days', NULL, NULL, '[]', NULL, '{\"d\":{\"field_name\":\"d\",\"field_label\":\"d\",\"type\":\"text\",\"validation\":\"required\"},\"f\":{\"field_name\":\"f\",\"field_label\":\"f\",\"type\":\"text\",\"validation\":\"required\"}}', NULL, '[\"HUR\"]', '[{\"currency_symbol\":\"HUR\",\"conversion_rate\":\"100\",\"min_limit\":\"1\",\"max_limit\":\"1000\",\"percentage_charge\":\"1.2\",\"fixed_charge\":\"2\"}]', 0, 0, 0, 'test', 1, 0, 1, NULL, 'local', '2025-01-12 00:32:57', '2025-01-12 00:32:57'),
(9, 'Flutterwave', 'flutterwave', 'Payment will receive within 1 days', '{\"0\":{\"NGN BANK\":\"NGN BANK\",\"NGN DOM\":\"NGN DOM\",\"GHS BANK\":\"GHS BANK\",\"KES BANK\":\"KES BANK\",\"ZAR BANK\":\"ZAR BANK\",\"INTL EUR & GBP\":\"INTL EUR & GBP\",\"INTL USD\":\"INTL USD\",\"INTL OTHERS\":\"INTL OTHERS\",\"FRANCOPGONE\":\"FRANCOPGONE\",\"XAF/XOF MOMO\":\"XAF/XOF MOMO\",\"mPesa\":\"mPesa\",\"Rwanda Momo\":\"Rwanda Momo\",\"Uganda Momo\":\"Uganda Momo\",\"Zambia Momo\":\"Zambia Momo\",\"Barter\":\"Barter\",\"FLW\":\"FLW\"}}', '[\"NGN BANK\",\"NGN DOM\",\"GHS BANK\"]', '{\"Public_Key\":\"\",\"Secret_Key\":\"\",\"Encryption_Key\":\"\"}', NULL, '[]', '{\"USD\":\"USD\",\"KES\":\"KES\",\"GHS\":\"GHS\",\"NGN\":\"NGN\",\"GBP\":\"GBP\",\"EUR\":\"EUR\",\"UGX\":\"UGX\",\"TZS\":\"TZS\"}', '[\"USD\",\"KES\",\"NGN\"]', '[{\"name\":\"USD\",\"currency_symbol\":\"KES\",\"conversion_rate\":\"1.38\",\"min_limit\":\"10\",\"max_limit\":\"15000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"KES\",\"currency_symbol\":\"USD\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"10\",\"max_limit\":\"10000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"NGN\",\"currency_symbol\":\"AUD\",\"conversion_rate\":\"0.014\",\"min_limit\":\"10\",\"max_limit\":\"100000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 0, 1, 0, 'test', 1, 0, 1, 'payoutMethod/3ZHEVOuAMEKXfG2oeGesEkMEXua0isCJPDFbn6Ix.jpg', 'local', '2025-01-24 03:30:23', '2025-01-29 07:29:05'),
(10, 'Razorpay', 'razorpay', 'Payment will receive within 1 days', '', NULL, '{\"account_number\":\"\",\"Key_Id\":\"\",\"Key_Secret\":\"\"}', '{\"webhook\":\"payout\"}', '[]', '{\"INR\":\"INR\"}', '[\"INR\"]', '[{\"name\":\"INR\",\"currency_symbol\":\"INR\",\"conversion_rate\":\"0.76\",\"min_limit\":\"10\",\"max_limit\":\"15000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 0, 1, 0, 'test', 1, 0, 1, 'payoutMethod/KzWb68n0qIkz998tUDeiTj5T45idCJ7Vsz5rVr6O.jpg', 'local', '2025-01-12 09:09:32', '2025-01-29 07:29:05'),
(11, 'Paystack', 'paystack', 'Payment will receive within 1 days', '', NULL, '{\"Public_key\":\"\",\"Secret_key\":\"\"}', '{\"webhook\":\"payout\"}', '[]', '{\"NGN\":\"NGN\",\"GHS\":\"GHS\",\"ZAR\":\"ZAR\"}', '[\"NGN\",\"GHS\",\"ZAR\"]', '[{\"name\":\"NGN\",\"currency_symbol\":\"NGN\",\"conversion_rate\":\"7.40\",\"min_limit\":\"50\",\"max_limit\":\"50000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"GHS\",\"currency_symbol\":\"GHS\",\"conversion_rate\":\"0.11\",\"min_limit\":\"50\",\"max_limit\":\"50000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"ZAR\",\"currency_symbol\":\"ZAR\",\"conversion_rate\":\"0.17\",\"min_limit\":\"50\",\"max_limit\":\"50000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 0, 1, 0, 'test', 1, 1, 1, 'payoutMethod/R171DPtw6jtQL7tvf9NR2gtnwhMTRpFlW51aPjKP.png', 'local', '2025-01-22 13:57:11', '2025-01-29 07:29:05'),
(12, 'Coinbase', 'coinbase', 'Payment will receive within 1 days', '', NULL, '{\"API_Key\":\"\",\"API_Secret\":\"\",\"Api_Passphrase\":\"\"}', '{\"webhook\":\"payout\"}', '{\"crypto_address\":{\"field_name\":\"crypto_address\",\"field_label\":\"Crypto Address\",\"type\":\"text\",\"validation\":\"required\"}}', '{\"BNB\":\"BNB\",\"BTC\":\"BTC\",\"XRP\":\"XRP\",\"ETH\":\"ETH\",\"ETH2\":\"ETH2\",\"USDT\":\"USDT\",\"BCH\":\"BCH\",\"LTC\":\"LTC\",\"XMR\":\"XMR\",\"TON\":\"TON\"}', '[\"BNB\"]', '[{\"name\":\"BNB\",\"currency_symbol\":\"BNB\",\"conversion_rate\":\"0.068\",\"min_limit\":\"1000\",\"max_limit\":\"1000000\",\"percentage_charge\":\"0.5\",\"fixed_charge\":\"0.5\"}]', 0, 1, 0, 'test', 1, 0, 1, 'payoutMethod/moST8wELN5rooqTg1jO5KBeKPrpOn2be3FNeUziY.png', 'local', '2025-01-05 09:46:43', '2025-01-29 07:29:05'),
(14, 'Perfect Money', 'perfectmoney', 'Payment will receive within 1 days', '', NULL, '{\"Passphrase\":\"\",\"Account_ID\":\"\",\"Payer_Account\":\"\"}', '', '[]', '{\"USD\":\"USD\",\"EUR\":\"EUR\"}', '[\"USD\",\"EUR\"]', '[{\"name\":\"USD\",\"currency_symbol\":\"USD\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"1\",\"max_limit\":\"15000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"},{\"name\":\"EUR\",\"currency_symbol\":\"EUR\",\"conversion_rate\":\"0.0081\",\"min_limit\":\"1\",\"max_limit\":\"15000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0.5\"}]', 0, 1, 0, 'test', 1, 1, 1, 'payoutMethod/Y7nhbYHjmNnKXDFPQfCBbmGpHvrjH6L8clZXrLrX.jpg', 'local', '2025-01-23 19:08:16', '2025-01-29 07:29:05'),
(15, 'Paypal', 'paypal', 'Payment will receive within 1 days', '', NULL, '{\"cleint_id\":\"\",\"secret\":\"\"}', '{\"webhook\":\"payout\"}', '[]', '{\"AUD\":\"AUD\",\"BRL\":\"BRL\",\"CAD\":\"CAD\",\"CZK\":\"CZK\",\"DKK\":\"DKK\",\"EUR\":\"EUR\",\"HKD\":\"HKD\",\"HUF\":\"HUF\",\"INR\":\"INR\",\"ILS\":\"ILS\",\"JPY\":\"JPY\",\"MYR\":\"MYR\",\"MXN\":\"MXN\",\"TWD\":\"TWD\",\"NZD\":\"NZD\",\"NOK\":\"NOK\",\"PHP\":\"PHP\",\"PLN\":\"PLN\",\"GBP\":\"GBP\",\"RUB\":\"RUB\",\"SGD\":\"SGD\",\"SEK\":\"SEK\",\"CHF\":\"CHF\",\"THB\":\"THB\",\"USD\":\"USD\"}', '[\"EUR\",\"USD\"]', '[{\"name\":\"EUR\",\"currency_symbol\":\"EUR\",\"conversion_rate\":\"0.0081\",\"min_limit\":\"1\",\"max_limit\":\"1000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"},{\"name\":\"USD\",\"currency_symbol\":\"USD\",\"conversion_rate\":\"0.0091\",\"min_limit\":\"1\",\"max_limit\":\"1000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"}]', 0, 1, 1, 'test', 1, 0, 1, 'payoutMethod/UZ9Ask4ycKIT1XML896p035iDb1f3wGm5HebFALO.png', 'local', '2025-01-03 20:41:59', '2025-01-29 07:29:05'),
(16, 'Binance', 'binance', 'Payment will receive within 1 days', '', NULL, '{\"API_Key\":\"\",\"KEY_Secret\":\"\"}', '', '[]', '{\"BNB\":\"BNB\",\"BTC\":\"BTC\",\"XRP\":\"XRP\",\"ETH\":\"ETH\",\"ETH2\":\"ETH2\",\"USDT\":\"USDT\",\"BCH\":\"BCH\",\"LTC\":\"LTC\",\"XMR\":\"XMR\",\"TON\":\"TON\"}', '[\"BNB\"]', '[{\"name\":\"BNB\",\"currency_symbol\":\"BNB\",\"conversion_rate\":\"0.0043\",\"min_limit\":\"10\",\"max_limit\":\"1000\",\"percentage_charge\":\"0\",\"fixed_charge\":\"0\"}]', 0, 1, 1, 'test', 1, 0, 1, 'payoutMethod/X6ZKvtR4xcxlSnHKS8FZQuTmOQy270hOyPeUbmSh.png', 'local', '2025-01-11 02:22:23', '2025-01-29 07:29:05');

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL 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 `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `subcategory_id` bigint(20) UNSIGNED NOT NULL,
  `karat_id` bigint(20) UNSIGNED DEFAULT NULL,
  `material_id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `price` decimal(11,2) DEFAULT NULL,
  `compare_price` decimal(11,2) DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL DEFAULT 1,
  `quantity` decimal(10,2) NOT NULL DEFAULT 0.00,
  `karat` decimal(8,2) DEFAULT NULL,
  `material` varchar(255) DEFAULT NULL,
  `thumbnail_image` varchar(255) DEFAULT NULL,
  `driver` varchar(50) DEFAULT NULL,
  `page_title` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `meta_description` longtext DEFAULT NULL,
  `og_description` text DEFAULT NULL,
  `meta_robots` text DEFAULT NULL,
  `meta_image` varchar(255) DEFAULT NULL,
  `meta_image_Driver` varchar(255) DEFAULT NULL,
  `breadcrumb_image` varchar(255) DEFAULT NULL,
  `breadcrumb_image_driver` varchar(255) DEFAULT NULL,
  `breadcrumb_image_status` tinyint(1) NOT NULL DEFAULT 1,
  `status` enum('Available','Stock Out') NOT NULL DEFAULT 'Available',
  `deleted_at` timestamp NULL 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 `product_details`
--

CREATE TABLE `product_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `short_description` text DEFAULT NULL,
  `description` longtext 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 `product_images`
--

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

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

--
-- Table structure for table `rankings`
--

CREATE TABLE `rankings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `rank_name` varchar(50) DEFAULT NULL,
  `rank_lavel` varchar(50) DEFAULT NULL,
  `rank_lavel_unq` varchar(20) DEFAULT NULL,
  `min_invest` decimal(8,2) DEFAULT NULL,
  `min_deposit` decimal(8,2) DEFAULT NULL,
  `min_earning` decimal(8,2) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `rank_icon` text DEFAULT NULL,
  `driver` varchar(255) DEFAULT NULL,
  `sort_by` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rankings`
--

INSERT INTO `rankings` (`id`, `rank_name`, `rank_lavel`, `rank_lavel_unq`, `min_invest`, `min_deposit`, `min_earning`, `description`, `rank_icon`, `driver`, `sort_by`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Hyip Member', 'Level 1', 'Lavel1', 20.00, 50.00, 5.00, 'By signing up to the account', '/bGZdeIcVu7zTLigCOUGs9F0hjFRps3.webp', 'local', 1, 1, '2025-01-03 04:10:09', '2025-01-03 04:10:09'),
(2, 'Hyip Leader', 'Level 2', 'Lavel2', 50.00, 100.00, 15.00, 'By earning $15 from the site', '/MEG1m4bahH9rtmJ6dLKdFgF3lDuURT.webp', 'local', 2, 1, '2025-01-16 23:35:10', '2025-01-16 23:35:10'),
(3, 'Hyip Captain', 'Level 3', 'Lavel3', 80.00, 120.00, 25.00, 'By earning $25 from the site', '/17CByyK4K3Xy3FAjhGkbhSww9Q0RPT.webp', 'local', 3, 1, '2025-01-12 01:19:58', '2025-01-12 01:19:58'),
(4, 'Hyip Victor', 'Level 4', 'Lavel4', 100.00, 200.00, 50.00, 'By earning $50 from the site', '/nCEvxKdmx1XccyTpmdn3ATRTifvMIC.webp', 'local', 4, 1, '2025-01-17 00:04:15', '2025-01-17 00:04:15');

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

--
-- Table structure for table `ratings`
--

CREATE TABLE `ratings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `rating` varchar(255) 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 `rating_comments`
--

CREATE TABLE `rating_comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `rating_id` bigint(20) UNSIGNED NOT NULL,
  `comment` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) 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 `razorpay_contacts`
--

CREATE TABLE `razorpay_contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `contact_id` varchar(255) DEFAULT NULL,
  `entity` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `referrals`
--

CREATE TABLE `referrals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `commission_type` varchar(255) NOT NULL,
  `level` int(11) NOT NULL,
  `commission` decimal(8,2) NOT NULL,
  `amount_type` varchar(255) 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 `referral_bonuses`
--

CREATE TABLE `referral_bonuses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `from_user_id` bigint(20) UNSIGNED NOT NULL,
  `to_user_id` bigint(20) UNSIGNED NOT NULL,
  `level` int(11) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `commission_type` varchar(255) DEFAULT NULL,
  `trx_id` varchar(255) DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `shipping_charges` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `area_id` bigint(20) UNSIGNED NOT NULL,
  `order_from` varchar(255) NOT NULL,
  `order_to` varchar(255) DEFAULT NULL,
  `delivery_charge` decimal(10,2) 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 `subscribers`
--

CREATE TABLE `subscribers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(255) 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 `sub_categories`
--

CREATE TABLE `sub_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `support_tickets`
--

CREATE TABLE `support_tickets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ticket` varchar(255) DEFAULT NULL,
  `subject` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 => Open, 1 => Answered, 2 => Replied, 3 => Closed	',
  `last_reply` timestamp NULL 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 `support_ticket_attachments`
--

CREATE TABLE `support_ticket_attachments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `support_ticket_message_id` int(11) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `driver` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `support_ticket_messages`
--

CREATE TABLE `support_ticket_messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `support_ticket_id` bigint(20) UNSIGNED DEFAULT NULL,
  `admin_id` bigint(20) UNSIGNED DEFAULT NULL,
  `message` text 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 `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `transactional_id` int(11) DEFAULT NULL,
  `transactional_type` varchar(255) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` double DEFAULT 0,
  `balance` double DEFAULT 0,
  `wallet_type` varchar(15) NOT NULL DEFAULT 'wallet',
  `amount_in_base` double DEFAULT 0,
  `charge` decimal(11,2) DEFAULT 0.00,
  `trx_type` varchar(255) DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `trx_id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `firstname` varchar(255) DEFAULT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `referral_id` int(11) DEFAULT NULL,
  `language_id` int(11) DEFAULT NULL,
  `rank_id` bigint(20) UNSIGNED NOT NULL,
  `last_level` varchar(50) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `country_code` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `phone_code` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `balance` decimal(11,2) DEFAULT NULL,
  `profit_balance` decimal(10,2) NOT NULL,
  `total_invest` decimal(10,2) NOT NULL,
  `total_profit` decimal(10,2) NOT NULL,
  `total_deposit` decimal(10,2) NOT NULL,
  `total_commission` decimal(10,2) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `image_driver` varchar(50) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `zip_code` varchar(255) DEFAULT NULL COMMENT 'Zip Or Postal Code',
  `address_one` text DEFAULT NULL,
  `address_two` text DEFAULT NULL,
  `provider` varchar(191) DEFAULT NULL,
  `provider_id` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `identity_verify` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 => Not Applied, 1=> Applied, 2=> Approved, 3 => Rejected	',
  `address_verify` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 => Not Applied, 1=> Applied, 2=> Approved, 3 => Rejected',
  `two_fa` tinyint(1) NOT NULL DEFAULT 0,
  `two_fa_verify` tinyint(1) NOT NULL DEFAULT 1,
  `two_fa_code` varchar(255) DEFAULT NULL,
  `email_verification` tinyint(1) NOT NULL DEFAULT 1,
  `sms_verification` tinyint(1) NOT NULL DEFAULT 1,
  `verify_code` varchar(255) DEFAULT NULL,
  `sent_at` datetime DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `last_seen` datetime DEFAULT NULL,
  `time_zone` varchar(255) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `github_id` varchar(255) DEFAULT NULL,
  `google_id` varchar(255) DEFAULT NULL,
  `facebook_id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_kycs`
--

CREATE TABLE `user_kycs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `kyc_id` bigint(20) UNSIGNED DEFAULT NULL,
  `kyc_type` varchar(255) DEFAULT NULL,
  `kyc_info` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=>pending , 1=> verified, 2=>rejected',
  `reason` text DEFAULT NULL COMMENT 'rejected reason',
  `approved_at` timestamp NULL 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 `user_logins`
--

CREATE TABLE `user_logins` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `longitude` varchar(255) DEFAULT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `country_code` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `ip_address` varchar(255) DEFAULT NULL,
  `browser` varchar(255) DEFAULT NULL,
  `os` varchar(255) DEFAULT NULL,
  `get_device` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `wish_lists`
--

CREATE TABLE `wish_lists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `product_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;

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

--
-- Table structure for table `withdrawal_days`
--

CREATE TABLE `withdrawal_days` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `monday` tinyint(1) NOT NULL DEFAULT 0,
  `tuesday` tinyint(1) NOT NULL DEFAULT 0,
  `wednesday` tinyint(1) NOT NULL DEFAULT 0,
  `thursday` tinyint(1) NOT NULL DEFAULT 0,
  `friday` tinyint(1) NOT NULL DEFAULT 0,
  `saturday` tinyint(1) NOT NULL DEFAULT 0,
  `sunday` tinyint(1) 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 `withdrawal_days`
--

INSERT INTO `withdrawal_days` (`id`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`, `created_at`, `updated_at`) VALUES
(1, 1, 0, 0, 0, 0, 0, 1, '2024-12-31 20:30:40', '2024-12-31 20:30:40');

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

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

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

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

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

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

--
-- Indexes for table `content_details`
--
ALTER TABLE `content_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `content_details_content_id_index` (`content_id`),
  ADD KEY `content_details_language_id_index` (`language_id`);

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `coupons_coupon_code_unique` (`coupon_code`);

--
-- Indexes for table `coupon_applicable_products`
--
ALTER TABLE `coupon_applicable_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `coupon_applicable_products_coupon_id_foreign` (`coupon_id`),
  ADD KEY `coupon_applicable_products_product_id_foreign` (`product_id`);

--
-- Indexes for table `deposits`
--
ALTER TABLE `deposits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deposits_user_id_index` (`user_id`),
  ADD KEY `deposits_payment_method_id_index` (`payment_method_id`);

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

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

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

--
-- Indexes for table `funds`
--
ALTER TABLE `funds`
  ADD PRIMARY KEY (`id`),
  ADD KEY `funds_user_id_index` (`user_id`),
  ADD KEY `funds_gateway_id_index` (`gateway_id`);

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

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

--
-- Indexes for table `invest_histories`
--
ALTER TABLE `invest_histories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invest_histories_user_id_foreign` (`user_id`),
  ADD KEY `invest_histories_plan_id_foreign` (`plan_id`);

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orders_user_id_foreign` (`user_id`),
  ADD KEY `orders_area_id_foreign` (`area_id`);

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_items_order_id_foreign` (`order_id`),
  ADD KEY `order_items_product_id_foreign` (`product_id`);

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

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

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

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `payouts`
--
ALTER TABLE `payouts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payouts_user_id_index` (`user_id`),
  ADD KEY `payouts_payout_method_id_index` (`payout_method_id`);

--
-- Indexes for table `payout_methods`
--
ALTER TABLE `payout_methods`
  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 `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_category_id_foreign` (`category_id`),
  ADD KEY `products_subcategory_id_foreign` (`subcategory_id`);

--
-- Indexes for table `product_details`
--
ALTER TABLE `product_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_details_product_id_foreign` (`product_id`),
  ADD KEY `product_details_language_id_foreign` (`language_id`);

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

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

--
-- Indexes for table `ratings`
--
ALTER TABLE `ratings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ratings_product_id_foreign` (`product_id`);

--
-- Indexes for table `rating_comments`
--
ALTER TABLE `rating_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rating_comments_rating_id_foreign` (`rating_id`);

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

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

--
-- Indexes for table `referral_bonuses`
--
ALTER TABLE `referral_bonuses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `referral_bonuses_from_user_id_foreign` (`from_user_id`),
  ADD KEY `referral_bonuses_to_user_id_foreign` (`to_user_id`);

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

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

--
-- Indexes for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sub_categories_category_id_foreign` (`category_id`);

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

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

--
-- Indexes for table `support_ticket_messages`
--
ALTER TABLE `support_ticket_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `support_ticket_messages_support_ticket_id_index` (`support_ticket_id`),
  ADD KEY `support_ticket_messages_admin_id_index` (`admin_id`);

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Indexes for table `user_kycs`
--
ALTER TABLE `user_kycs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_kycs_user_id_index` (`user_id`),
  ADD KEY `user_kycs_kyc_id_index` (`kyc_id`);

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

--
-- Indexes for table `wish_lists`
--
ALTER TABLE `wish_lists`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wish_lists_user_id_foreign` (`user_id`),
  ADD KEY `wish_lists_product_id_foreign` (`product_id`);

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

--
-- AUTO_INCREMENT for table `areas`
--
ALTER TABLE `areas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `blog_categories`
--
ALTER TABLE `blog_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `blog_details`
--
ALTER TABLE `blog_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contents`
--
ALTER TABLE `contents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=111;

--
-- AUTO_INCREMENT for table `content_details`
--
ALTER TABLE `content_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=215;

--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `coupon_applicable_products`
--
ALTER TABLE `coupon_applicable_products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deposits`
--
ALTER TABLE `deposits`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `file_storages`
--
ALTER TABLE `file_storages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `fire_base_tokens`
--
ALTER TABLE `fire_base_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `funds`
--
ALTER TABLE `funds`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `gateways`
--
ALTER TABLE `gateways`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1001;

--
-- AUTO_INCREMENT for table `investment_plans`
--
ALTER TABLE `investment_plans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invest_histories`
--
ALTER TABLE `invest_histories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `in_app_notifications`
--
ALTER TABLE `in_app_notifications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `karats`
--
ALTER TABLE `karats`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `kycs`
--
ALTER TABLE `kycs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `maintenance_modes`
--
ALTER TABLE `maintenance_modes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `manage_menus`
--
ALTER TABLE `manage_menus`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `manual_sms_configs`
--
ALTER TABLE `manual_sms_configs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `materials`
--
ALTER TABLE `materials`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;

--
-- AUTO_INCREMENT for table `notification_permissions`
--
ALTER TABLE `notification_permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notification_templates`
--
ALTER TABLE `notification_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `order_items`
--
ALTER TABLE `order_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `page_details`
--
ALTER TABLE `page_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;

--
-- AUTO_INCREMENT for table `payouts`
--
ALTER TABLE `payouts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payout_methods`
--
ALTER TABLE `payout_methods`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_details`
--
ALTER TABLE `product_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_images`
--
ALTER TABLE `product_images`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rankings`
--
ALTER TABLE `rankings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `ratings`
--
ALTER TABLE `ratings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rating_comments`
--
ALTER TABLE `rating_comments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `razorpay_contacts`
--
ALTER TABLE `razorpay_contacts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `referrals`
--
ALTER TABLE `referrals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `referral_bonuses`
--
ALTER TABLE `referral_bonuses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `shipping_charges`
--
ALTER TABLE `shipping_charges`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sub_categories`
--
ALTER TABLE `sub_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `support_tickets`
--
ALTER TABLE `support_tickets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `support_ticket_attachments`
--
ALTER TABLE `support_ticket_attachments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `support_ticket_messages`
--
ALTER TABLE `support_ticket_messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_kycs`
--
ALTER TABLE `user_kycs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_logins`
--
ALTER TABLE `user_logins`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wish_lists`
--
ALTER TABLE `wish_lists`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `withdrawal_days`
--
ALTER TABLE `withdrawal_days`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `coupon_applicable_products`
--
ALTER TABLE `coupon_applicable_products`
  ADD CONSTRAINT `coupon_applicable_products_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `coupon_applicable_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `invest_histories`
--
ALTER TABLE `invest_histories`
  ADD CONSTRAINT `invest_histories_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `investment_plans` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `invest_histories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `order_items`
--
ALTER TABLE `order_items`
  ADD CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`),
  ADD CONSTRAINT `order_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);
COMMIT;

