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

START TRANSACTION;



--
-- Database: `ncodedkc_wa3usdin`
--

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

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `balance` varchar(191) NOT NULL,
  `amount` double 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 `accounts`
--

INSERT INTO `accounts` (`id`, `user_id`, `balance`, `amount`, `created_at`, `updated_at`) VALUES
(1, 10, 'main_wallet', 700, '2025-07-22 10:29:46', '2025-08-02 03:32:15');

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

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

CREATE TABLE `email_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `subject` varchar(191) DEFAULT NULL,
  `greeting` varchar(191) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `group` varchar(191) NOT NULL,
  `recipient` varchar(191) DEFAULT NULL,
  `addresses` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`addresses`)),
  `params` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`params`)),
  `shortcut` text DEFAULT NULL,
  `status` varchar(191) 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 `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED 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 `iv_actions`
--

CREATE TABLE `iv_actions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `action` varchar(191) NOT NULL,
  `action_by` bigint(20) NOT NULL,
  `action_at` varchar(191) NOT NULL,
  `type` varchar(191) NOT NULL,
  `type_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `iv_actions`
--

INSERT INTO `iv_actions` (`id`, `action`, `action_by`, `action_at`, `type`, `type_id`) VALUES
(1, 'order', 10, '2025-08-02 09:02:15', 'invest', 1);

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

--
-- Table structure for table `iv_invests`
--

CREATE TABLE `iv_invests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ivx` varchar(191) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `amount` double NOT NULL,
  `profit` double NOT NULL,
  `total` double NOT NULL,
  `received` double NOT NULL,
  `currency` varchar(191) NOT NULL,
  `rate` varchar(191) NOT NULL,
  `term` varchar(191) NOT NULL,
  `term_count` int(11) NOT NULL,
  `term_total` int(11) NOT NULL,
  `term_calc` varchar(191) NOT NULL,
  `term_start` datetime DEFAULT NULL,
  `term_end` datetime DEFAULT NULL,
  `reference` bigint(20) NOT NULL,
  `scheme` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`scheme`)),
  `scheme_id` bigint(20) UNSIGNED DEFAULT NULL,
  `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`meta`)),
  `desc` text DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `note` text DEFAULT NULL,
  `status` varchar(191) 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 `iv_invests`
--

INSERT INTO `iv_invests` (`id`, `ivx`, `user_id`, `amount`, `profit`, `total`, `received`, `currency`, `rate`, `term`, `term_count`, `term_total`, `term_calc`, `term_start`, `term_end`, `reference`, `scheme`, `scheme_id`, `meta`, `desc`, `remarks`, `note`, `status`, `created_at`, `updated_at`) VALUES
(1, '82350001', 10, 100, 42, 142, 0, 'USD', '0.25 (P)', '7 Days', 0, 168, 'hourly', '2025-08-02 09:02:10', '2025-08-09 09:03:15', 0, '{\"name\":\"Mercury\",\"short\":\"MC\",\"amount\":\"100\",\"maximum\":\"0\",\"is_fixed\":\"1\",\"term\":\"7\",\"term_type\":\"days\",\"rate\":\"0.25\",\"rate_type\":\"percent\",\"calc_period\":\"hourly\",\"days_only\":\"0\",\"capital\":\"0\",\"payout\":\"term_basis\",\"status\":\"active\",\"is_locked\":null,\"type\":null,\"deleted_at\":null}', 4, '{\"source\":\"main_wallet\",\"fees\":0,\"exchange\":0}', 'Mercury - Hourly 0.25% for 7 Days', NULL, NULL, 'pending', '2025-08-02 03:32:15', '2025-08-02 03:32:15');

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

--
-- Table structure for table `iv_ledgers`
--

CREATE TABLE `iv_ledgers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ivx` varchar(191) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `type` varchar(191) NOT NULL,
  `calc` varchar(191) NOT NULL,
  `amount` double NOT NULL,
  `fees` double NOT NULL,
  `total` double NOT NULL,
  `currency` varchar(191) NOT NULL,
  `desc` text DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `note` text DEFAULT NULL,
  `invest_id` bigint(20) NOT NULL,
  `tnx_id` bigint(20) NOT NULL,
  `reference` bigint(20) NOT NULL,
  `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`meta`)),
  `source` varchar(191) DEFAULT NULL,
  `dest` varchar(191) 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 `iv_profits`
--

CREATE TABLE `iv_profits` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `invest_id` bigint(20) NOT NULL,
  `amount` double NOT NULL,
  `capital` double NOT NULL,
  `invested` double NOT NULL,
  `currency` varchar(191) NOT NULL,
  `rate` double NOT NULL,
  `type` varchar(191) NOT NULL,
  `term_no` int(11) NOT NULL,
  `payout` bigint(20) DEFAULT NULL,
  `calc_at` datetime 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 `iv_schemes`
--

CREATE TABLE `iv_schemes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `short` varchar(191) DEFAULT NULL,
  `desc` text DEFAULT NULL,
  `amount` double NOT NULL,
  `maximum` double DEFAULT NULL,
  `is_fixed` tinyint(1) NOT NULL DEFAULT 0,
  `term` int(11) NOT NULL,
  `term_type` varchar(191) NOT NULL,
  `rate` double(8,2) NOT NULL,
  `rate_type` varchar(191) NOT NULL,
  `calc_period` varchar(191) NOT NULL,
  `days_only` tinyint(1) NOT NULL,
  `capital` tinyint(1) NOT NULL,
  `payout` varchar(191) NOT NULL,
  `status` varchar(191) NOT NULL,
  `is_locked` tinyint(1) DEFAULT NULL,
  `featured` tinyint(1) NOT NULL,
  `type` varchar(191) DEFAULT NULL,
  `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;

--
-- Dumping data for table `iv_schemes`
--

INSERT INTO `iv_schemes` (`id`, `name`, `slug`, `short`, `desc`, `amount`, `maximum`, `is_fixed`, `term`, `term_type`, `rate`, `rate_type`, `calc_period`, `days_only`, `capital`, `payout`, `status`, `is_locked`, `featured`, `type`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Standard Plan', 'standard-plan', 'ST', 'Entry level of investment & earn money.', 10, 500, 0, 21, 'days', 1.10, 'percent', 'daily', 0, 0, 'term_basis', 'active', NULL, 0, NULL, NULL, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(2, 'Premium Plan', 'premium-plan', 'PM', 'Medium level of investment & earn money.', 100, 1500, 0, 1, 'months', 1.50, 'percent', 'daily', 0, 0, 'term_basis', 'active', NULL, 0, NULL, NULL, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(3, 'Professional Plan', 'professional-plan', 'PN', 'Exclusive level of investment & earn money.', 500, 2500, 0, 50, 'days', 2.50, 'percent', 'daily', 0, 0, 'term_basis', 'active', NULL, 0, NULL, NULL, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(4, 'Mercury', 'mercury', 'MC', 'Investment for long term & earn money.', 100, 0, 1, 7, 'days', 0.25, 'percent', 'hourly', 0, 0, 'term_basis', 'active', NULL, 1, NULL, NULL, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(5, 'Venus', 'venus', 'VN', 'Investment for long term & earn money.', 250, 0, 1, 1, 'months', 5.00, 'percent', 'daily', 0, 0, 'term_basis', 'active', NULL, 1, NULL, NULL, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(6, 'Jupiter', 'jupiter', 'JP', 'Investment for long term & earn money.', 500, 0, 1, 3, 'months', 20.00, 'percent', 'weekly', 0, 0, 'term_basis', 'active', NULL, 1, NULL, NULL, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(7, 'Silver Plan', 'silver-plan', 'SV', 'Investment for long term & earn money.', 100, 0, 1, 7, 'days', 0.25, 'percent', 'hourly', 0, 0, 'term_basis', 'inactive', NULL, 0, NULL, NULL, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(8, 'Dimond Plan', 'dimond-plan', 'DM', 'Investment for long term & earn money.', 250, 0, 1, 1, 'months', 5.00, 'percent', 'daily', 0, 0, 'term_basis', 'inactive', NULL, 0, NULL, NULL, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(9, 'Platinum Plan', 'platinum-plan', 'JP', 'Investment for long term & earn money.', 500, 0, 1, 3, 'months', 20.00, 'percent', 'weekly', 0, 0, 'term_basis', 'inactive', NULL, 0, NULL, NULL, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(10, 'Investment Plan X1', 'investment-plan-x1', 'X1', 'Invest your money and & earn.', 10, 500, 0, 7, 'days', 1.10, 'percent', 'daily', 0, 0, 'term_basis', 'inactive', NULL, 0, NULL, NULL, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(11, 'Investment Plan X2', 'investment-plan-x2', 'X2', 'Invest your money and & earn.', 10, 500, 0, 7, 'days', 1.10, 'percent', 'daily', 0, 0, 'term_basis', 'inactive', NULL, 0, NULL, NULL, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(12, 'Investment Plan X3', 'investment-plan-x3', 'X3', 'Invest your money and & earn.', 10, 500, 0, 7, 'days', 1.10, 'percent', 'daily', 0, 0, 'term_basis', 'inactive', NULL, 0, NULL, NULL, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(13, 'Investment Plan X4', 'investment-plan-x4', 'X4', 'Invest your money and & earn.', 10, 500, 0, 7, 'days', 1.10, 'percent', 'daily', 0, 0, 'term_basis', 'inactive', NULL, 0, NULL, NULL, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(14, 'Investment Plan X5', 'investment-plan-x5', 'X5', 'Invest your money and & earn.', 10, 500, 0, 7, 'days', 1.10, 'percent', 'daily', 0, 0, 'term_basis', 'inactive', NULL, 0, NULL, NULL, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(15, 'Investment Plan X6', 'investment-plan-x6', 'X6', 'Invest your money and & earn.', 10, 500, 0, 7, 'days', 1.10, 'percent', 'daily', 0, 0, 'term_basis', 'inactive', NULL, 0, NULL, NULL, '2025-07-22 05:20:37', '2025-07-22 05:20:37');

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

--
-- Table structure for table `iv_scheme_metas`
--

CREATE TABLE `iv_scheme_metas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `scheme_id` bigint(20) NOT NULL,
  `key` varchar(191) NOT NULL,
  `value` varchar(191) 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 `kyc_applicants`
--

CREATE TABLE `kyc_applicants` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `reference` varchar(191) NOT NULL,
  `status` varchar(191) 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 `kyc_applicants`
--

INSERT INTO `kyc_applicants` (`id`, `user_id`, `reference`, `status`, `created_at`, `updated_at`) VALUES
(1, 10, '21276001', 'verified', '2025-07-22 07:47:56', '2025-07-22 08:25:30');

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

--
-- Table structure for table `kyc_sessions`
--

CREATE TABLE `kyc_sessions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `session` varchar(191) NOT NULL,
  `status` varchar(191) NOT NULL,
  `method` varchar(191) DEFAULT NULL,
  `profile` longtext DEFAULT NULL,
  `docs` longtext DEFAULT NULL,
  `note` text DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `revised` longtext DEFAULT NULL,
  `checked_by` text DEFAULT NULL,
  `checked_at` datetime 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 `kyc_sessions`
--

INSERT INTO `kyc_sessions` (`id`, `user_id`, `session`, `status`, `method`, `profile`, `docs`, `note`, `remarks`, `revised`, `checked_by`, `checked_at`, `created_at`, `updated_at`) VALUES
(1, 10, 'd973fb9d-53190276-0001', 'reject', 'manual', '{\"name\":\"dharun\",\"phone\":\"9123456789\",\"dob\":\"09\\/07\\/1999\",\"gender\":null,\"nationality\":\"India\",\"address_line_1\":null,\"address_line_2\":null,\"city\":null,\"state\":null,\"zip\":null,\"country\":\"India\"}', '{\"main\":\"pp\",\"proof\":[\"bs\"]}', NULL, NULL, NULL, '{\"id\":1,\"name\":\"dharunMods\"}', '2025-07-22 13:51:02', '2025-07-22 08:08:34', '2025-07-22 08:21:02'),
(2, 10, 'd973fb9d-53192282-0002', 'approve', 'manual', '{\"name\":\"dharun\",\"phone\":\"9123456789\",\"dob\":\"09\\/07\\/1999\",\"gender\":null,\"nationality\":null,\"address_line_1\":null,\"address_line_2\":null,\"city\":null,\"state\":null,\"zip\":null,\"country\":\"India\"}', '{\"main\":\"pp\",\"proof\":[\"bs\"]}', NULL, NULL, NULL, '{\"id\":1,\"name\":\"dharunMods\"}', '2025-07-22 13:55:30', '2025-07-22 08:24:44', '2025-07-22 08:25:30');

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

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

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `code` varchar(191) NOT NULL,
  `label` varchar(191) DEFAULT NULL,
  `short` varchar(191) DEFAULT NULL,
  `translations` longtext DEFAULT NULL,
  `rtl` enum('1','0') NOT NULL DEFAULT '0',
  `status` enum('1','0') 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 `languages`
--

INSERT INTO `languages` (`id`, `name`, `code`, `label`, `short`, `translations`, `rtl`, `status`, `created_at`, `updated_at`) VALUES
(1, 'English', 'en', 'English', 'ENG', NULL, '', '1', '2025-07-22 05:20:36', '2025-07-22 05:20:36');

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

--
-- Table structure for table `ledgers`
--

CREATE TABLE `ledgers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `transaction_id` bigint(20) UNSIGNED NOT NULL,
  `account_id` bigint(20) UNSIGNED NOT NULL,
  `debit` double DEFAULT NULL,
  `credit` double DEFAULT NULL,
  `balance` double NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ledgers`
--

INSERT INTO `ledgers` (`id`, `transaction_id`, `account_id`, `debit`, `credit`, `balance`, `created_at`) VALUES
(1, 1, 1, NULL, 1000, 1000, '2025-07-22 10:29:46'),
(2, 2, 1, 100, NULL, 900, '2025-07-22 10:45:53'),
(3, 3, 1, 100, NULL, 800, '2025-07-22 11:38:57');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) 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, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(2, '2021_01_04_000000_create_users_table', 1),
(3, '2021_02_17_000000_create_failed_jobs_table', 1),
(4, '2021_04_12_101006_create_verify_tokens_table', 1),
(5, '2021_04_12_101023_create_user_metas_table', 1),
(6, '2021_04_12_101046_create_user_accounts_table', 1),
(7, '2021_04_12_101502_create_user_activities_table', 1),
(8, '2021_04_12_102056_create_referrals_table', 1),
(9, '2021_04_12_102084_create_referral_codes_table', 1),
(10, '2021_04_15_120264_create_settings_table', 1),
(11, '2021_04_15_120392_create_pages_table', 1),
(12, '2021_04_15_120416_create_email_templates_table', 1),
(13, '2021_04_15_120574_create_payment_methods_table', 1),
(14, '2021_04_15_120683_create_withdraw_methods_table', 1),
(15, '2021_04_15_132940_create_accounts_table', 1),
(16, '2021_04_19_132965_create_transactions_table', 1),
(17, '2021_04_19_132996_create_ledgers_table', 1),
(18, '2021_04_19_135150_add_iv_schemes_table', 1),
(19, '2021_04_19_135158_add_iv_scheme_metas_table', 1),
(20, '2021_04_19_135235_add_iv_invests_table', 1),
(21, '2021_04_19_135364_add_iv_ledgers_table', 1),
(22, '2021_04_19_135389_add_iv_profits_table', 1),
(23, '2021_04_19_135458_add_iv_actions_table', 1),
(24, '2021_06_04_162627_create_languages_table', 1),
(25, '2021_08_07_074811_add_scheme_column_in_iv_invest', 1),
(26, '2021_08_07_144326_add_is_locked_column_in_iv_schemes', 1),
(27, '2021_11_19_154153_add_max_column_in_methods', 1),
(28, '2021_11_19_154464_add_pid_column_in_pages', 1),
(29, '2022_03_04_060117_add_deleted_at_column_in_iv_schemes', 1),
(30, '2022_04_11_074140_create_user_groups_table', 1),
(31, '2022_04_11_101807_create_user_group_term_table', 1),
(32, '2022_08_08_063204_add_type_column_in_iv_schemes', 1),
(33, '2023_02_18_123157_create_user_temp_metas_table', 1),
(34, '2024_04_18_065319_add_expires_at_to_personal_access_tokens_table', 1),
(35, '2021_12_03_045644_create_kyc_applicants_table', 2),
(36, '2021_12_03_045734_create_kyc_sessions_table', 2),
(37, '2021_12_03_045953_create_kyc_docs_table', 2);

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

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

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `slug` varchar(191) NOT NULL,
  `menu_name` varchar(191) NOT NULL,
  `menu_link` text DEFAULT NULL,
  `title` varchar(191) DEFAULT NULL,
  `subtitle` varchar(191) DEFAULT NULL,
  `seo` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`seo`)),
  `content` longtext DEFAULT NULL,
  `lang` varchar(191) NOT NULL DEFAULT 'en',
  `status` varchar(191) NOT NULL,
  `pid` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `public` tinyint(1) NOT NULL DEFAULT 1,
  `params` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`params`)),
  `trash` 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 `pages`
--

INSERT INTO `pages` (`id`, `name`, `slug`, `menu_name`, `menu_link`, `title`, `subtitle`, `seo`, `content`, `lang`, `status`, `pid`, `public`, `params`, `trash`, `created_at`, `updated_at`) VALUES
(1, 'About Us', 'about-us', 'About', NULL, 'About the platform', NULL, NULL, '<h4>About the Company</h4>\n<p><strong>[[site_name]]</strong> work in the field of financing promising developments on cryptocurrency market and with blockchain technology. According to experts, blockchain technologies currently have great opportunity. Lots of business ideas related to blockchain technologies become more successful and every day by day it bring high profits to their creators.</p>\n<p>We track and analyze most business ideas. It allows us to get high profits. For our investor do not need to research independently in which project it is more profitable. So our investor can invest their capital and then receive an interest on the profit.</p>\n<h4>Investment</h4>\n<p>We invest in projects at an early stage, in particular, it can be business ideas, investing in startups at various stages of their development, ICO (Initial Coin Offering), IEO (Initial Exchange Offering).</p>', 'en', 'active', 0, 1, NULL, 0, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(2, 'Our Fees', 'fees', 'Fees', NULL, 'Our Fees', NULL, NULL, NULL, 'en', 'inactive', 0, 1, NULL, 0, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(3, 'Referral', 'referral', 'Referral', NULL, 'My Referral', NULL, NULL, NULL, 'en', 'inactive', 0, 1, NULL, 0, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(4, 'Frequently Asked Questions', 'faqs', 'FAQs', NULL, 'Frequently Asked Questions', NULL, NULL, '<h4>How can we help you?</h4>\n<p>Do You have any questions? We strongly recommend that you start searching for the necessary information in the FAQ section.</p>\n<h5>What is [[site_name]] company?</h5>\n<p>[[site_name]] platform is an international investment company. The activity of our company is aimed at the cryptocurrency trading, forex, stocks and providing investment services worldwide.</p>\n<h5>How to create an account?</h5>\n<p>The registration process on the website is quite simple. You need to fill out the fields of the registration form, which include full name, email address and password.</p>\n<h5>Which payment methods do you accept?</h5>\n<p>At the moment we work with PayPal, Wire Transfer, Bitcoin, Ethereum, Litecoin, Binance Coin.</p>\n<h5>I want to reinvest the funds received, is it possible?</h5>\n<p>Of course. You have the right to reinvesting your profits again and again.</p>', 'en', 'active', 0, 1, NULL, 0, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(5, 'Contact Us', 'contact-us', 'Contact', NULL, 'Contact Us', NULL, NULL, '<h4>Get In Touch</h4>\n<p>If you need advice or have any question in mind or technical assistance, do not hesitate to contact our specialists.</p>\n<p><strong>Email Address:</strong> [[site_email]]</p>', 'en', 'active', 0, 1, NULL, 0, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(6, 'Terms and Condition', 'terms-and-condition', 'Terms and Condition', NULL, 'Terms and Condition', NULL, NULL, '<h4>Terms and condition</h4>\n<p>Welcome to [[site_name]]!</p>\n<p>These terms and conditions outline the rules and regulations for the use of [[site_name]]\'s Website.</p>\n<p>By accessing this website we assume you accept these terms and conditions. Do not continue to use [[site_name]] if you do not agree to take all of the terms and conditions stated on this page.</p>\n<p>If you have additional questions or require more information, do not hesitate to contact us through email at [[site_email]].</p>', 'en', 'active', 0, 1, NULL, 0, '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(7, 'Privacy Policy', 'privacy-policy', 'Privacy Policy', NULL, 'Privacy Policy', NULL, NULL, '<h4>Privacy Policy for [[site_name]].</h4>\n<p>At <strong>[[site_name]]</strong>, one of our main priorities is the privacy of our visitors. This Privacy Policy document contains types of information that is collected and recorded by <strong>[[site_name]]</strong> and how we use it.</p>\n<p>If you have additional questions or require more information about our Privacy Policy, do not hesitate to contact us through email at [[site_email]].</p>', 'en', 'active', 0, 1, NULL, 0, '2025-07-22 05:20:37', '2025-07-22 05:20:37');

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

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `desc` varchar(191) NOT NULL,
  `min_amount` varchar(191) DEFAULT NULL,
  `max_amount` varchar(191) DEFAULT NULL,
  `config` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`config`)),
  `fees` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`fees`)),
  `currencies` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`currencies`)),
  `countries` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`countries`)),
  `status` varchar(191) 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 `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `slug`, `name`, `desc`, `min_amount`, `max_amount`, `config`, `fees`, `currencies`, `countries`, `status`, `created_at`, `updated_at`) VALUES
(1, 'paypal', 'Paypal', 'Pay securely with your PayPal account.', '5', '1000', '{\"api\":{\"client_id\":\"dsfdfdsf\",\"client_secret\":\"dfdsf\",\"account\":\"sdfdsf\",\"sandbox\":\"inactive\"},\"meta\":{\"title\":\"dfdff\",\"min\":\"0\",\"max\":\"0\"},\"currencies\":{\"USD\":{\"min\":\"1\",\"max\":\"200\"},\"EUR\":{\"min\":\"0\",\"max\":\"0\"},\"GBP\":{\"min\":\"0\",\"max\":\"0\"},\"CAD\":{\"min\":\"0\",\"max\":\"0\"},\"AUD\":{\"min\":\"0\",\"max\":\"0\"},\"RUB\":{\"min\":\"0\",\"max\":\"0\"},\"BRL\":{\"min\":\"0\",\"max\":\"0\"},\"MXN\":{\"min\":\"0\",\"max\":\"0\"}}}', '{\"flat\":0,\"percent\":0}', '[\"USD\"]', '[]', 'active', '2025-07-22 05:20:37', '2025-07-22 05:34:57'),
(2, 'bank-transfer', 'Bank Transfer', 'Make payment directly into our bank account.', '100', NULL, '[]', '{\"flat\":0,\"percent\":0}', '[\"USD\"]', '[]', 'inactive', '2025-07-22 05:20:37', '2025-07-22 05:20:37'),
(3, 'crypto-wallet', 'Crypto Wallet', 'Send your payment direct to our wallet.', '0.1', '1000', '{\"meta\":{\"title\":\"rgfdgfdgfd\",\"fiat\":\"USD\",\"timeout\":\"0\",\"qr\":\"show\"},\"wallet\":{\"BTC\":{\"address\":\"xxxxxxxxxxxxxxxxxxxxxxxx\",\"wnote\":\"efsfffg\",\"min\":\"1\",\"max\":\"1000\",\"ref\":\"no\",\"network\":\"default\"},\"ETH\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\",\"limit\":null,\"price\":null,\"network\":\"default\"},\"LTC\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\",\"network\":\"default\"},\"BCH\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\",\"network\":\"default\"},\"BNB\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\",\"network\":\"default\"},\"ADA\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\"},\"XRP\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\"},\"USDC\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\",\"network\":\"default\"},\"USDT\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\",\"network\":\"default\"},\"TRX\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\",\"network\":\"default\"}}}', '{\"flat\":0,\"percent\":0}', '[\"BTC\"]', '[]', 'active', '2025-07-22 05:20:37', '2025-07-22 05:36:30'),
(4, 'coinpayments', 'CoinPayments', 'Pay securely with CoinPayments payment gateway.', '1', '1000', '{\"api\":{\"public_key\":\"xxxxxxxxxxxx\",\"private_key\":\"xxxxxxxxxxxxxx\",\"merchant_id\":\"xxxxxxxxxxx\",\"ipn_secret\":\"xxxxxxxxxxx\",\"account\":\"xxxx\",\"sandbox\":\"active\"},\"meta\":{\"min\":\"0.1\",\"max\":\"2\"},\"currencies\":{\"BTC\":{\"min\":\"0.1\",\"max\":\"2\"},\"ETH\":{\"min\":\"0\",\"max\":\"0\"},\"LTC\":{\"min\":\"0\",\"max\":\"0\"},\"BCH\":{\"min\":\"0\",\"max\":\"0\"},\"BNB\":{\"min\":\"0\",\"max\":\"0\"},\"USDC\":{\"min\":\"0\",\"max\":\"0\"},\"USDT\":{\"min\":\"0\",\"max\":\"0\"},\"TRX\":{\"min\":\"0\",\"max\":\"0\"}}}', NULL, '[\"BTC\"]', '[]', 'active', '2025-07-22 13:31:37', '2025-07-22 13:34:49'),
(5, 'flutterwave', 'Flutterwave', 'Pay securely with Flutterwave payment gateway.', '10', '1000', '{\"api\":{\"live\":{\"public_key\":\"xxxxxxxxxxx\",\"secret_key\":\"xxxxxxxx\",\"webhook_hash\":\"xxxxxxxxx\"},\"test\":{\"public_key\":\"xxxxxxxxxx\",\"secret_key\":\"xxxxxxxxxxxxx\",\"webhook_hash\":\"xxxxxxxxxxxx\"},\"account\":\"xxxxxxxxxxxx\",\"test_mode\":\"active\"},\"meta\":{\"min\":\"0\",\"max\":\"0\"},\"currencies\":{\"USD\":{\"min\":\"10\",\"max\":\"1000\"},\"EUR\":{\"min\":\"0\",\"max\":\"0\"},\"GBP\":{\"min\":\"0\",\"max\":\"0\"},\"CAD\":{\"min\":\"0\",\"max\":\"0\"},\"BRL\":{\"min\":\"0\",\"max\":\"0\"},\"NGN\":{\"min\":\"0\",\"max\":\"0\"},\"TZS\":{\"min\":\"0\",\"max\":\"0\"},\"MXN\":{\"min\":\"0\",\"max\":\"0\"},\"GHS\":{\"min\":\"0\",\"max\":\"0\"},\"KES\":{\"min\":\"0\",\"max\":\"0\"}}}', NULL, '[\"USD\"]', '[]', 'active', '2025-07-23 01:04:57', '2025-07-23 01:05:10'),
(6, 'coinbase', 'Coinbase', 'Pay securely with Coinbase payment gateway.', '10', '1000', '{\"api\":{\"key\":\"xxxxxxxxxx\",\"webhook\":\"xxxxxxxxxxxx\",\"account\":\"xxxxxxxxxxxx\"},\"meta\":{\"min\":\"0\",\"max\":\"0\"},\"currencies\":{\"BTC\":{\"min\":\"0.1\",\"max\":\"1\"},\"ETH\":{\"min\":\"0\",\"max\":\"0\"},\"LTC\":{\"min\":\"0\",\"max\":\"0\"},\"BCH\":{\"min\":\"0\",\"max\":\"0\"},\"USDC\":{\"min\":\"0\",\"max\":\"0\"}}}', NULL, '[\"BTC\"]', '[]', 'active', '2025-07-23 01:18:03', '2025-07-23 01:18:28');

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

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

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(191) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_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,
  `user_id` bigint(20) NOT NULL,
  `refer_by` bigint(20) NOT NULL,
  `join_at` datetime NOT NULL,
  `meta` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `referral_codes`
--

CREATE TABLE `referral_codes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `code` varchar(191) NOT NULL,
  `type` varchar(191) NOT NULL DEFAULT '0',
  `label` varchar(191) DEFAULT NULL,
  `desc` varchar(191) 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 `referral_codes`
--

INSERT INTO `referral_codes` (`id`, `user_id`, `code`, `type`, `label`, `desc`, `created_at`, `updated_at`) VALUES
(1, 10, 'bb99ca2e', '0', NULL, NULL, '2025-07-22 07:47:23', '2025-07-22 07:47:23'),
(2, 14, '961c7f34', '0', NULL, NULL, '2025-08-01 15:22:14', '2025-08-01 15:22:14');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(191) NOT NULL,
  `value` text DEFAULT NULL,
  `created_at` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `key`, `value`, `created_at`) VALUES
(1, 'site_name', 'Investorm', '2025-07-22 05:20:36'),
(2, 'site_email', 'mail@domain.in', '2025-07-22 05:20:36'),
(3, 'site_copyright', ':Sitename &copy; :year. All Rights Reserved.', '2025-07-22 05:20:36'),
(4, 'site_disclaimer', '', '2025-07-22 05:20:36'),
(5, 'site_merchandise', '{\"purchase_code\":\"dharunmods-Youtube-Channel-xxxxxxxxx\",\"name\":\"dharunmods-Youtube-Channel\",\"email\":\"d3@d3.in\"}', '2025-07-22 05:20:36'),
(6, 'main_website', '', '2025-07-22 05:20:36'),
(7, 'front_page_enable', 'yes', '2025-07-22 05:20:36'),
(8, 'front_page_extra', 'on', '2025-07-22 05:20:36'),
(9, 'front_page_title', 'Welcome', '2025-07-22 05:20:36'),
(10, 'invest_page_enable', 'yes', '2025-07-22 05:20:36'),
(11, 'time_zone', 'Asia/Dhaka', '2025-07-22 05:20:36'),
(12, 'date_format', 'd M, Y', '2025-07-22 05:20:36'),
(13, 'time_format', 'h:i A', '2025-07-22 05:20:36'),
(14, 'decimal_fiat_display', '2', '2025-07-22 05:20:36'),
(15, 'decimal_crypto_display', '4', '2025-07-22 05:20:36'),
(16, 'decimal_fiat_calc', '2', '2025-07-22 05:20:36'),
(17, 'decimal_crypto_calc', '6', '2025-07-22 05:20:36'),
(18, 'signup_allow', 'enable', '2025-07-22 05:20:36'),
(19, 'email_verification', 'on', '2025-07-22 05:20:36'),
(20, 'batch_update', '120', '2025-07-22 05:20:36'),
(21, 'maintenance_mode', 'off', '2025-07-22 05:20:36'),
(22, 'maintenance_notice', 'We are upgrading our system. Please check after 30 minutes.', '2025-07-22 05:20:36'),
(23, 'mail_from_name', 'Investorm', '2025-07-22 05:20:36'),
(24, 'mail_from_email', 'null', '2025-07-22 05:20:36'),
(25, 'mail_global_footer', 'Best Regard, \r\nTeam of [[site_name]]', '2025-07-22 05:20:36'),
(26, 'mail_driver', 'smtp', '2025-07-22 05:20:36'),
(27, 'mail_smtp_host', 'null', '2025-07-22 05:20:36'),
(28, 'mail_smtp_port', '465', '2025-07-22 05:20:36'),
(29, 'mail_smtp_secure', 'tls', '2025-07-22 05:20:36'),
(30, 'mail_smtp_user', 'null', '2025-07-22 05:20:36'),
(31, 'mail_smtp_password', 'null', '2025-07-22 05:20:36'),
(32, 'mail_recipient', 'mail@domain.in', '2025-07-22 05:20:36'),
(33, 'mail_recipient_alter', '', '2025-07-22 05:20:36'),
(34, 'youtube_link', '', '2025-07-22 05:20:36'),
(35, 'linkedin_link', '', '2025-07-22 05:20:36'),
(36, 'twitter_link', '', '2025-07-22 05:20:36'),
(37, 'facebook_link', '', '2025-07-22 05:20:37'),
(38, 'medium_link', '', '2025-07-22 05:20:37'),
(39, 'telegram_link', '', '2025-07-22 05:20:37'),
(40, 'github_link', '', '2025-07-22 05:20:37'),
(41, 'pinterest_link', '', '2025-07-22 05:20:37'),
(42, 'app_acquire', '{\"app\":\"Investorm\",\"secret\":\"a12245678999ca31eeb35046fc66c014\",\"cipher\":\"fc66c014\",\"key\":\"245678\",\"update\":\"2537354402\"}', '2025-07-22 05:20:37'),
(43, 'exratesapi_access_key', '4c3453bb308c3ba237b01776f4cdb185', '2025-07-22 05:20:37'),
(44, 'recaptcha_site_key', '', '2025-07-22 05:20:37'),
(45, 'recaptcha_secret_key', '', '2025-07-22 05:20:37'),
(46, 'custom_stylesheet', 'off', '2025-07-22 05:20:37'),
(47, 'header_code', '', '2025-07-22 05:20:37'),
(48, 'footer_code', '', '2025-07-22 05:20:37'),
(49, 'main_nav', '[1,4,5]', '2025-07-22 05:20:37'),
(50, 'main_menu', '[]', '2025-07-22 05:20:37'),
(51, 'footer_menu', '[4,6,7]', '2025-07-22 05:20:37'),
(52, 'page_terms', '6', '2025-07-22 05:20:37'),
(53, 'page_privacy', '7', '2025-07-22 05:20:37'),
(54, 'page_fee_deposit', '', '2025-07-22 05:20:37'),
(55, 'page_fee_withdraw', '', '2025-07-22 05:20:37'),
(56, 'page_contact', '5', '2025-07-22 05:20:37'),
(57, 'page_contact_form', 'on', '2025-07-22 05:20:37'),
(58, 'ui_page_skin', 'dark', '2025-07-22 05:20:37'),
(59, 'ui_auth_skin', 'dark', '2025-07-22 05:20:37'),
(60, 'ui_auth_layout', 'default', '2025-07-22 05:20:37'),
(61, 'ui_theme_mode', 'light', '2025-07-22 05:20:37'),
(62, 'ui_theme_skin', 'default', '2025-07-22 05:20:37'),
(63, 'ui_sidebar_user', 'white', '2025-07-22 05:20:37'),
(64, 'ui_sidebar_admin', 'darker', '2025-07-22 05:20:37'),
(65, 'ui_theme_mode_admin', 'light', '2025-07-22 05:20:37'),
(66, 'ui_theme_skin_admin', 'default', '2025-07-22 05:20:37'),
(67, 'payout_batch', 'a12245678999ca31eeb35046fc66c014', '2025-07-22 05:20:37'),
(68, 'signup_bonus_allow', 'no', '2025-07-22 05:20:37'),
(69, 'signup_bonus_amount', '0', '2025-07-22 05:20:37'),
(70, 'deposit_bonus_allow', 'no', '2025-07-22 05:20:37'),
(71, 'deposit_bonus_amount', '0', '2025-07-22 05:20:37'),
(72, 'deposit_bonus_type', 'fixed', '2025-07-22 05:20:37'),
(73, 'referral_system', 'yes', '2025-07-22 05:20:37'),
(74, 'referral_invite_title', 'Refer Us & Earn', '2025-07-22 05:20:37'),
(75, 'referral_invite_text', 'Use the below link to invite your friends.', '2025-07-22 05:20:37'),
(76, 'referral_signup_user', 'no', '2025-07-22 05:20:37'),
(77, 'referral_signup_user_bonus', '0', '2025-07-22 05:20:37'),
(78, 'referral_signup_user_reward', 'no', '2025-07-22 05:20:37'),
(79, 'referral_deposit_user', 'no', '2025-07-22 05:20:37'),
(80, 'referral_deposit_user_bonus', '0', '2025-07-22 05:20:37'),
(81, 'referral_deposit_user_type', 'percent', '2025-07-22 05:20:37'),
(82, 'referral_signup_referer', 'no', '2025-07-22 05:20:37'),
(83, 'referral_signup_referer_bonus', '0', '2025-07-22 05:20:37'),
(84, 'referral_deposit_referer', 'no', '2025-07-22 05:20:37'),
(85, 'referral_deposit_referer_bonus', '0', '2025-07-22 05:20:37'),
(86, 'referral_deposit_referer_type', 'percent', '2025-07-22 05:20:37'),
(87, 'alert_wd_account', 'on', '2025-07-22 05:20:37'),
(88, 'alert_profile_basic', 'on', '2025-07-22 05:20:37'),
(89, 'header_notice_show', 'no', '2025-07-22 05:20:37'),
(90, 'header_notice_title', '', '2025-07-22 05:20:37'),
(91, 'header_notice_text', '', '2025-07-22 05:20:37'),
(92, 'header_notice_link', '', '2025-07-22 05:20:37'),
(93, 'system_service', 'P6WXU1CUF5245678', '2025-07-22 05:20:37'),
(94, 'api_service', 'yes', '2025-07-22 05:20:37'),
(95, 'deposit_service', '886aa012', '2025-07-22 05:20:37'),
(96, 'deposit_limit_request', '0', '2025-07-22 05:20:37'),
(97, 'deposit_cancel_timeout', 'yes', '2025-07-22 05:20:37'),
(98, 'deposit_fiat_minimum', '0', '2025-07-22 05:20:37'),
(99, 'deposit_crypto_minimum', '0', '2025-07-22 05:20:37'),
(100, 'deposit_fiat_maximum', '3000', '2025-07-22 05:20:37'),
(101, 'deposit_crypto_maximum', '3000', '2025-07-22 05:20:37'),
(102, 'deposit_disable_request', 'no', '2025-07-22 05:20:37'),
(103, 'deposit_disable_title', 'Temporarily unavailable!', '2025-07-22 05:20:37'),
(104, 'deposit_disable_notice', 'Sorry, we are upgrading our deposit system. Please check after sometimes. We apologize for any inconvenience.', '2025-07-22 05:20:37'),
(105, 'payout_check', '2537354402', '2025-07-22 05:20:37'),
(106, 'withdraw_service', '886aa012', '2025-07-22 05:20:37'),
(107, 'withdraw_limit_request', '0', '2025-07-22 05:20:37'),
(108, 'withdraw_cancel_timeout', 'yes', '2025-07-22 05:20:37'),
(109, 'withdraw_fiat_minimum', '10', '2025-07-22 05:20:37'),
(110, 'withdraw_fiat_maximum', '1000', '2025-07-22 05:20:37'),
(111, 'withdraw_crypto_minimum', '10', '2025-07-22 05:20:37'),
(112, 'withdraw_crypto_maximum', '1000', '2025-07-22 05:20:37'),
(113, 'withdraw_disable_request', 'no', '2025-07-22 05:20:37'),
(114, 'withdraw_disable_title', 'Temporarily unavailable!', '2025-07-22 05:20:37'),
(115, 'withdraw_disable_notice', 'Sorry, we are upgrading our withdrawal system. Please check after sometimes. We apologize for any inconvenience.', '2025-07-22 05:20:37'),
(116, 'app_queue', '0', '2025-07-22 05:20:37'),
(117, 'base_currency', 'USD', '2025-07-22 05:20:37'),
(118, 'alter_currency', 'INR', '2025-07-22 05:20:37'),
(119, 'supported_currency', '{\"USD\":\"on\",\"EUR\":\"on\",\"GBP\":\"on\",\"CAD\":\"on\",\"INR\":\"on\",\"BTC\":\"on\",\"ETH\":\"on\",\"LTC\":\"on\",\"BNB\":\"on\"}', '2025-07-22 05:20:37'),
(120, 'fiat_rounded', 'up', '2025-07-22 05:20:37'),
(121, 'crypto_rounded', 'up', '2025-07-22 05:20:37'),
(122, 'exchange_method', 'automatic', '2025-07-22 05:20:37'),
(123, 'exchange_auto_update', '60', '2025-07-22 05:20:37'),
(124, 'exchange_last_update', '1754128238', '2025-07-22 05:20:37'),
(125, 'manual_exchange_rate', '{\"USD\":\"1\",\"EUR\":\"0\",\"GBP\":\"0\",\"CAD\":\"0\",\"INR\":\"1\",\"BTC\":\"0.0000084\",\"ETH\":\"0\",\"LTC\":\"0\",\"BNB\":\"0\"}', '2025-07-22 05:20:37'),
(126, 'health_checker', '0', '2025-07-22 05:20:37'),
(127, 'top_iv_plan_x0', '3', '2025-07-22 05:20:37'),
(128, 'top_iv_plan_x1', '1', '2025-07-22 05:20:37'),
(129, 'top_iv_plan_x2', '2', '2025-07-22 05:20:37'),
(130, 'iv_plan_order', 'featured', '2025-07-22 05:20:37'),
(131, 'iv_show_plans', 'default', '2025-07-22 05:20:37'),
(132, 'iv_plan_desc_show', 'no', '2025-07-22 05:20:37'),
(133, 'iv_plan_total_percent', 'yes', '2025-07-22 05:20:37'),
(134, 'iv_plan_pg_heading', 'Investment Plans', '2025-07-22 05:20:37'),
(135, 'iv_plan_pg_title', 'Choose your favourite plan and start earning now.', '2025-07-22 05:20:37'),
(136, 'iv_plan_pg_text', 'Here is our several investment plans. You can invest daily, weekly or monthly and get higher returns in your investment.', '2025-07-22 05:20:37'),
(137, 'iv_launched_date', '07/22/2025', '2025-07-22 05:20:37'),
(138, 'iv_cancel_timeout', '15', '2025-07-22 05:20:37'),
(139, 'iv_admin_confirmtion', 'yes', '2025-07-22 05:20:37'),
(140, 'iv_disable_purchase', 'no', '2025-07-22 05:20:37'),
(141, 'iv_disable_title', 'Temporarily unavailable!', '2025-07-22 05:20:37'),
(142, 'iv_disable_notice', '', '2025-07-22 05:20:37'),
(143, 'iv_profit_payout', 'everytime', '2025-07-22 05:20:37'),
(144, 'iv_profit_payout_amount', '100', '2025-07-22 05:20:37'),
(145, 'iv_plan_fx_currencies', '[]', '2025-07-22 05:20:37'),
(146, 'iv_weekend_days', '[]', '2025-07-22 05:20:37'),
(147, 'language_default_public', 'en', '2025-07-22 05:20:37'),
(148, 'language_default_system', 'en', '2025-07-22 05:20:37'),
(149, 'language_show_as', 'default', '2025-07-22 05:20:37'),
(150, 'language_switcher', 'off', '2025-07-22 05:20:37'),
(151, 'social_auth', 'off', '2025-07-22 05:20:37'),
(152, 'gdpr_enable', 'no', '2025-07-22 05:20:37'),
(153, 'cookie_consent_text', 'This website uses cookies. By continuing to use this website, you agree to their use. For details, please check our [[privacy]].', '2025-07-22 05:20:37'),
(154, 'referral_show_referred_users', 'no', '2025-07-22 05:20:37'),
(155, 'referral_user_table_opts', '[\"earning\",\"compact\"]', '2025-07-22 05:20:37'),
(156, 'referral_invite_redirect', 'register', '2025-07-22 05:20:37'),
(157, 'cookie_banner_position', 'bbox-left', '2025-07-22 05:20:37'),
(158, 'cookie_banner_background', 'light', '2025-07-22 05:20:37'),
(159, 'seo_description', '', '2025-07-22 05:20:37'),
(160, 'login_seo_title', '', '2025-07-22 05:20:37'),
(161, 'registration_seo_title', '', '2025-07-22 05:20:37'),
(162, 'og_title', '', '2025-07-22 05:20:37'),
(163, 'og_description', '', '2025-07-22 05:20:37'),
(164, 'header_notice_date', '', '2025-07-22 05:20:37'),
(165, 'deposit_amount_base', 'yes', '2025-07-22 05:20:37'),
(166, 'rates_ticker_display', 'no', '2025-07-22 05:20:37'),
(167, 'rates_ticker_from', 'base', '2025-07-22 05:20:37'),
(168, 'rates_ticker_fx', 'only', '2025-07-22 05:20:37'),
(169, 'iv_plan_capital_show', 'yes', '2025-07-22 05:20:37'),
(170, 'iv_plan_payout_show', 'no', '2025-07-22 05:20:37'),
(171, 'iv_plan_terms_show', 'no', '2025-07-22 05:20:37'),
(172, 'tnx_list_show', 'no', '2025-07-22 05:20:37'),
(173, 'tnx_list_heading', 'Latest Transactions', '2025-07-22 05:20:37'),
(174, 'tnx_list_text', 'Here is latest transaction that our investor deposits and withdrawals.', '2025-07-22 05:20:37'),
(175, 'tnx_deposit_title', 'Deposit', '2025-07-22 05:20:37'),
(176, 'tnx_withdraw_title', 'Withdraw', '2025-07-22 05:20:37'),
(177, 'tnx_list_show_dp', 'yes', '2025-07-22 05:20:37'),
(178, 'tnx_list_show_wd', 'yes', '2025-07-22 05:20:37'),
(179, 'tnx_deposit_items', '5', '2025-07-22 05:20:37'),
(180, 'tnx_withdraw_items', '5', '2025-07-22 05:20:37'),
(181, 'application_rcv', '2501152', '2025-07-22 05:20:37'),
(182, 'update_installed', '1753186886', '2025-07-22 05:20:37'),
(183, 'installed_apps', '1753181443', '2025-07-22 05:20:43'),
(184, 'baseurl_apps', 'wa.3usd.in/', '2025-07-22 05:20:47'),
(185, 'system_super_admin', '1', '2025-07-22 05:27:47'),
(186, 'quick_setup_done', '1753192236', '2025-07-22 05:28:48'),
(187, 'cache_version', '1753891052', '2025-07-22 05:30:08'),
(188, 'payout_locked_profit', NULL, '2025-07-22 05:30:08'),
(189, 'payout_locked_plan', NULL, '2025-07-22 05:30:08'),
(190, 'kyc_feature_enable', 'yes', '2025-07-22 07:11:39'),
(191, 'kyc_verification', 'yes', '2025-07-22 07:11:39'),
(192, 'kyc_verified', '{\"deposit\":\"on\"}', '2025-07-22 07:11:39'),
(193, 'kyc_profile_locked', 'yes', '2025-07-22 07:11:39'),
(194, 'kyc_profile_complete', 'yes', '2025-07-22 07:11:39'),
(195, 'kyc_disable_request', 'no', '2025-07-22 07:11:39'),
(196, 'kyc_disable_title', 'Temporarily unavailable!', '2025-07-22 07:11:39'),
(197, 'kyc_disable_notice', 'hello world dk', '2025-07-22 07:11:39'),
(198, 'kyc_preview_quick', 'yes', '2025-07-22 07:11:39'),
(199, 'kyc_fields', '{\"profile\":{\"name\":{\"show\":\"yes\",\"req\":\"yes\"},\"dob\":{\"show\":\"yes\",\"req\":\"yes\"},\"nationality\":{\"show\":\"yes\"},\"country\":{\"show\":\"yes\",\"req\":\"yes\"},\"address\":{\"show\":\"yes\"}}}', '2025-07-22 07:11:39'),
(200, 'kyc_docs', '{\"main\":{\"pp\":\"on\",\"nid\":\"on\"},\"alter\":{\"bs\":\"on\"}}', '2025-07-22 07:11:39'),
(201, 'kyc_doc_country', 'yes', '2025-07-22 07:11:39'),
(202, 'kyc_doc_selfie', 'yes', '2025-07-22 07:11:39'),
(203, 'mod_kyc_update', '20211026', '2025-07-22 07:11:39'),
(204, 'exratesapi_error_msg', '', '2025-07-22 07:15:22'),
(205, 'signup_form_fields', '{\"profile_phone\":{\"show\":\"no\",\"req\":\"no\"},\"profile_dob\":{\"show\":\"no\",\"req\":\"no\"},\"profile_country\":{\"show\":\"no\",\"req\":\"no\"}}', '2025-07-22 07:38:13'),
(206, 'referral_show_info', 'invite', '2025-07-22 07:38:13'),
(207, 'mail_mailgun_domain', '', '2025-07-22 07:41:07'),
(208, 'mail_mailgun_api_key', '', '2025-07-22 07:41:07'),
(209, 'mail_mailgun_api_base_url', 'api.mailgun.net', '2025-07-22 07:41:07'),
(210, 'mail_postmark_api_token', '', '2025-07-22 07:41:07'),
(211, 'mail_aws_access_key_id', '', '2025-07-22 07:41:07'),
(212, 'mail_aws_secret_access_key', '', '2025-07-22 07:41:07'),
(213, 'mail_aws_default_region', '', '2025-07-22 07:41:07'),
(214, 'mail_sendgrid_api_key', '', '2025-07-22 07:41:07'),
(215, 'transfer_feature_enable', 'yes', '2025-07-22 12:58:08'),
(216, 'transfer_minimum_amount', '10', '2025-07-22 12:58:08'),
(217, 'transfer_maximum_amount', '5000', '2025-07-22 12:58:08'),
(218, 'transfer_disable_request', 'no', '2025-07-22 12:58:08'),
(219, 'transfer_disable_title', 'Temporarily unavailable!', '2025-07-22 12:58:08'),
(220, 'transfer_disable_notice', 'Sorry, right now you can not send funds to your friends. Please contact us if you have any question.', '2025-07-22 12:58:08'),
(221, 'mod_p2pfund_update', '2110100', '2025-07-22 12:58:08'),
(222, 'tawk_api_key', '', '2025-07-23 01:35:06'),
(223, 'recaptcha_score', '6', '2025-07-23 01:35:06'),
(224, 'automatic_exchange_rate', '{\"EUR\":1,\"GBP\":0.874884,\"CAD\":1.599849,\"INR\":101.058329,\"BTC\":1.0183695e-5}', '2025-07-23 02:02:42');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tnx` varchar(191) NOT NULL,
  `type` varchar(191) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `account_to` bigint(20) DEFAULT NULL,
  `account_from` bigint(20) DEFAULT NULL,
  `calc` varchar(191) NOT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `fees` double NOT NULL DEFAULT 0,
  `currency` varchar(191) NOT NULL,
  `total` double NOT NULL DEFAULT 0,
  `tnx_amount` double NOT NULL DEFAULT 0,
  `tnx_fees` double NOT NULL DEFAULT 0,
  `tnx_total` double NOT NULL DEFAULT 0,
  `tnx_currency` varchar(191) NOT NULL,
  `tnx_method` varchar(191) DEFAULT NULL,
  `exchange` double NOT NULL DEFAULT 0,
  `status` varchar(191) NOT NULL,
  `refund` bigint(20) DEFAULT 0,
  `pay_from` varchar(191) DEFAULT NULL,
  `pay_to` varchar(191) DEFAULT NULL,
  `reference` varchar(191) DEFAULT NULL,
  `description` text NOT NULL,
  `remarks` text DEFAULT NULL,
  `note` text DEFAULT NULL,
  `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`meta`)),
  `confirmed_at` datetime DEFAULT NULL,
  `confirmed_by` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`confirmed_by`)),
  `completed_at` datetime DEFAULT NULL,
  `completed_by` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`completed_by`)),
  `created_by` bigint(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `tnx`, `type`, `user_id`, `account_to`, `account_from`, `calc`, `amount`, `fees`, `currency`, `total`, `tnx_amount`, `tnx_fees`, `tnx_total`, `tnx_currency`, `tnx_method`, `exchange`, `status`, `refund`, `pay_from`, `pay_to`, `reference`, `description`, `remarks`, `note`, `meta`, `confirmed_at`, `confirmed_by`, `completed_at`, `completed_by`, `created_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '59059986', 'deposit', 10, 1, NULL, 'credit', 1000, 0, 'USD', 1000, 1000, 0, 1000, 'USD', 'manual', 1, 'completed', 0, NULL, '', NULL, 'Credited Balance', '', NULL, '{\"calc\":\"credit\",\"base_amount\":\"1000\",\"amount\":\"1000\",\"method\":\"manual\"}', NULL, NULL, '2025-07-22 15:59:46', '{\"id\":1,\"name\":\"dharunMods\"}', 1, '2025-07-22 10:29:46', '2025-07-22 10:29:46', NULL),
(2, '34590696', 'withdraw', 10, NULL, 1, 'debit', 100, 0, 'USD', 100, 0.00084, 0, 0.00084, 'BTC', 'wd-crypto-wallet', 0.0000084, 'completed', 0, 'dfgfdgg', NULL, 'fgfgfdg', 'Withdraw via Bitcoin Wallet', 'fdgfdhg', NULL, '{\"method\":\"wd-crypto-wallet\",\"amount\":\"0.00084\",\"total\":0.00084,\"base_amount\":\"100\",\"base_total\":100,\"pay_meta\":{\"method\":\"Crypto Wallet\",\"label\":\"AC-0010-1843\",\"payment\":null,\"currency\":\"BTC\"},\"unote\":\"\",\"account\":null,\"fees\":{\"total\":0},\"admin_added\":1}', '2025-07-22 16:14:44', '{\"id\":1,\"name\":\"dharunMods\"}', '2025-07-22 16:15:53', '{\"id\":1,\"name\":\"dharunMods\"}', 10, '2025-07-22 10:41:36', '2025-07-22 10:45:53', NULL),
(3, '64511192', 'withdraw', 10, NULL, 1, 'debit', 100, 0, 'USD', 100, 0.00084, 0, 0.00084, 'BTC', 'wd-crypto-wallet', 0.0000084, 'completed', 0, 'etrgfdgfg', NULL, 'ertret', 'Withdraw via Bitcoin Wallet', 'fgbfghtuiokyuikuyt', NULL, '{\"method\":\"wd-crypto-wallet\",\"amount\":\"0.00084\",\"total\":0.00084,\"base_amount\":\"100\",\"base_total\":100,\"pay_meta\":{\"method\":\"Crypto Wallet\",\"label\":\"AC-0010-1843\",\"payment\":null,\"currency\":\"BTC\"},\"unote\":\"\",\"account\":null,\"fees\":{\"total\":0},\"admin_added\":1}', '2025-07-22 17:08:32', '{\"id\":1,\"name\":\"dharunMods\"}', '2025-07-22 17:08:57', '{\"id\":1,\"name\":\"dharunMods\"}', 10, '2025-07-22 10:49:52', '2025-07-22 11:38:57', NULL),
(4, '54791881', 'deposit', 10, 1, NULL, 'credit', 98196.19, 0, 'USD', 98196.19, 1, 0, 1, 'BTC', 'crypto-wallet', 0.000010183695, 'cancelled', 0, NULL, 'xxxxxxxxxxxxxxxxxxxxxxxx', NULL, 'Deposit via rgfdgfdgfd', NULL, NULL, '{\"method\":\"crypto-wallet\",\"amount\":1,\"fees\":{\"total\":0},\"total\":\"1\",\"base_amount\":98196.19,\"base_total\":\"98196.19\",\"pay_meta\":{\"address\":\"xxxxxxxxxxxxxxxxxxxxxxxx\",\"wnote\":\"efsfffg\",\"ref\":\"no\",\"network\":\"default\",\"timeout\":\"0\"}}', NULL, NULL, NULL, NULL, 10, '2025-08-02 02:34:41', '2025-08-02 02:34:47', NULL),
(5, '69095504', 'deposit', 10, 1, NULL, 'credit', 98196.19, 0, 'USD', 98196.19, 1, 0, 1, 'BTC', 'crypto-wallet', 0.000010183695, 'pending', 0, NULL, 'xxxxxxxxxxxxxxxxxxxxxxxx', NULL, 'Deposit via rgfdgfdgfd', NULL, NULL, '{\"method\":\"crypto-wallet\",\"amount\":1,\"fees\":{\"total\":0},\"total\":\"1\",\"base_amount\":98196.19,\"base_total\":\"98196.19\",\"pay_meta\":{\"address\":\"xxxxxxxxxxxxxxxxxxxxxxxx\",\"wnote\":\"efsfffg\",\"ref\":\"no\",\"network\":\"default\",\"timeout\":\"0\"}}', NULL, NULL, NULL, NULL, 10, '2025-08-02 03:35:04', '2025-08-02 03:35:04', NULL);

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

--
-- Table structure for table `user_accounts`
--

CREATE TABLE `user_accounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `config` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`config`)),
  `last_used` datetime DEFAULT NULL,
  `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;

--
-- Dumping data for table `user_accounts`
--

INSERT INTO `user_accounts` (`id`, `user_id`, `slug`, `name`, `config`, `last_used`, `deleted_at`, `created_at`, `updated_at`) VALUES
(2, 10, 'wd-crypto-wallet', 'AC-0010-5801', '{\"currency\":\"ETH\",\"wallet\":\"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx\"}', NULL, NULL, '2025-07-22 10:57:06', '2025-07-22 10:57:06');

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

--
-- Table structure for table `user_activities`
--

CREATE TABLE `user_activities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `session` datetime NOT NULL,
  `ip` varchar(45) NOT NULL,
  `meta` text NOT NULL,
  `browser` varchar(191) NOT NULL,
  `device` varchar(191) NOT NULL,
  `platform` varchar(191) NOT NULL,
  `version` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_activities`
--

INSERT INTO `user_activities` (`id`, `user_id`, `session`, `ip`, `meta`, `browser`, `device`, `platform`, `version`) VALUES
(1, 1, '2025-07-22 10:57:54', '223.178.83.62', 'User Logged in', 'Chrome', 'WebKit', 'Windows', '{\"browser\":\"138.0.0.0\",\"platform\":\"10.0\"}'),
(4, 1, '2025-07-22 16:54:24', '102.90.102.117', 'User Logged in', 'Chrome', 'WebKit', 'AndroidOS', '{\"browser\":\"138.0.0.0\",\"platform\":\"10\"}'),
(6, 1, '2025-07-23 06:26:09', '223.178.83.62', 'User Logged in', 'Chrome', 'WebKit', 'Windows', '{\"browser\":\"138.0.0.0\",\"platform\":\"10.0\"}'),
(9, 1, '2025-07-30 14:47:41', '223.178.81.251', 'User Logged in', 'Chrome', 'WebKit', 'Windows', '{\"browser\":\"138.0.0.0\",\"platform\":\"10.0\"}'),
(10, 14, '2025-07-30 15:39:56', '102.88.115.216', 'User Logged in', 'Chrome', 'WebKit', 'AndroidOS', '{\"browser\":\"138.0.0.0\",\"platform\":\"10\"}'),
(12, 10, '2025-08-02 07:44:04', '223.178.86.94', 'User Logged in', 'Chrome', 'WebKit', 'Windows', '{\"browser\":\"138.0.0.0\",\"platform\":\"10.0\"}');

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

--
-- Table structure for table `user_groups`
--

CREATE TABLE `user_groups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `label` varchar(191) NOT NULL,
  `desc` text DEFAULT NULL,
  `color` varchar(191) NOT NULL,
  `status` varchar(191) 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 `user_group_term`
--

CREATE TABLE `user_group_term` (
  `user_id` bigint(20) NOT NULL,
  `group_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_metas`
--

CREATE TABLE `user_metas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `meta_key` varchar(191) NOT NULL,
  `meta_value` varchar(191) 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 `user_metas`
--

INSERT INTO `user_metas` (`id`, `user_id`, `meta_key`, `meta_value`, `created_at`, `updated_at`) VALUES
(1, 1, 'profile_display_name', 'dharunMods', '2025-07-22 05:27:47', '2025-07-22 05:27:47'),
(2, 1, 'profile_avatar_bg', 'blue', '2025-07-22 05:27:47', '2025-07-22 05:27:47'),
(3, 1, 'profile_display_full_name', 'on', '2025-07-22 05:27:47', '2025-07-22 05:27:47'),
(4, 1, 'setting_activity_log', 'on', '2025-07-22 05:27:47', '2025-07-22 05:27:47'),
(5, 1, 'setting_unusual_activity', 'on', '2025-07-22 05:27:47', '2025-07-22 05:27:47'),
(6, 1, 'registration_method', 'system', '2025-07-22 05:27:47', '2025-07-22 05:27:47'),
(7, 1, 'email_verified', '2025-07-22 10:57:47', '2025-07-22 05:27:47', '2025-07-22 05:27:47'),
(8, 1, 'email_verified_last', '2025-07-22 10:57:47', '2025-07-22 05:27:47', '2025-07-22 05:27:47'),
(9, 1, 'first_login_at', '2025-07-22 10:57:54', '2025-07-22 05:27:54', '2025-07-22 05:27:54'),
(48, 1, 'kyc_display', 'compact', '2025-07-22 07:03:53', '2025-07-22 07:03:53'),
(71, 10, 'profile_display_name', 'dharun', '2025-07-22 07:43:50', '2025-07-22 07:43:50'),
(72, 10, 'profile_avatar_bg', 'pink', '2025-07-22 07:43:50', '2025-07-22 07:43:50'),
(73, 10, 'profile_display_full_name', 'off', '2025-07-22 07:43:50', '2025-07-22 07:45:45'),
(74, 10, 'setting_activity_log', 'on', '2025-07-22 07:43:50', '2025-07-22 07:43:50'),
(75, 10, 'setting_unusual_activity', 'on', '2025-07-22 07:43:50', '2025-07-22 07:43:50'),
(76, 10, 'registration_method', 'direct', '2025-07-22 07:43:50', '2025-07-22 07:43:50'),
(77, 10, 'email_verified', '2025-07-22 13:13:50', '2025-07-22 07:43:50', '2025-07-22 07:43:50'),
(78, 10, 'email_verified_last', '2025-07-22 13:13:50', '2025-07-22 07:43:50', '2025-07-22 07:43:50'),
(79, 10, 'first_login_at', '2025-07-22 13:15:14', '2025-07-22 07:45:14', '2025-07-22 07:45:14'),
(80, 10, 'profile_phone', '9123456789', '2025-07-22 07:45:45', '2025-07-22 07:45:45'),
(81, 10, 'profile_dob', '09/07/1999', '2025-07-22 07:45:45', '2025-07-22 07:45:45'),
(82, 10, 'profile_country', 'India', '2025-07-22 07:45:45', '2025-07-22 07:45:45'),
(83, 10, 'kyc_verification', 'verified', '2025-07-22 08:08:34', '2025-07-22 08:25:29'),
(84, 10, 'kyc_verified_at', '2025-07-22 13:55:30', '2025-07-22 08:25:30', '2025-07-22 08:25:30'),
(85, 11, 'profile_display_name', 'user', '2025-07-30 09:19:30', '2025-07-30 09:19:30'),
(86, 11, 'profile_avatar_bg', 'info', '2025-07-30 09:19:30', '2025-07-30 09:19:30'),
(87, 11, 'profile_display_full_name', 'on', '2025-07-30 09:19:30', '2025-07-30 09:19:30'),
(88, 11, 'setting_activity_log', 'on', '2025-07-30 09:19:30', '2025-07-30 09:19:30'),
(89, 11, 'setting_unusual_activity', 'on', '2025-07-30 09:19:30', '2025-07-30 09:19:30'),
(90, 11, 'registration_method', 'email', '2025-07-30 09:19:30', '2025-07-30 09:19:30'),
(91, 11, 'email_verified', '2025-07-30 14:49:48', '2025-07-30 09:19:48', '2025-07-30 09:19:48'),
(92, 11, 'email_verified_last', '2025-07-30 14:49:48', '2025-07-30 09:19:48', '2025-07-30 09:19:48'),
(93, 12, 'profile_display_name', 'coder', '2025-07-30 09:56:03', '2025-07-30 09:56:03'),
(94, 12, 'profile_avatar_bg', 'primary', '2025-07-30 09:56:03', '2025-07-30 09:56:03'),
(95, 12, 'profile_display_full_name', 'on', '2025-07-30 09:56:03', '2025-07-30 09:56:03'),
(96, 12, 'setting_activity_log', 'on', '2025-07-30 09:56:03', '2025-07-30 09:56:03'),
(97, 12, 'setting_unusual_activity', 'on', '2025-07-30 09:56:03', '2025-07-30 09:56:03'),
(98, 12, 'registration_method', 'email', '2025-07-30 09:56:03', '2025-07-30 09:56:03'),
(99, 12, 'email_verified', '2025-07-30 15:26:33', '2025-07-30 09:56:33', '2025-07-30 09:56:33'),
(100, 12, 'email_verified_last', '2025-07-30 15:26:33', '2025-07-30 09:56:33', '2025-07-30 09:56:33'),
(101, 13, 'profile_display_name', 'coder', '2025-07-30 10:00:51', '2025-07-30 10:00:51'),
(102, 13, 'profile_avatar_bg', 'gray', '2025-07-30 10:00:51', '2025-07-30 10:00:51'),
(103, 13, 'profile_display_full_name', 'on', '2025-07-30 10:00:51', '2025-07-30 10:00:51'),
(104, 13, 'setting_activity_log', 'on', '2025-07-30 10:00:51', '2025-07-30 10:00:51'),
(105, 13, 'setting_unusual_activity', 'on', '2025-07-30 10:00:51', '2025-07-30 10:00:51'),
(106, 13, 'registration_method', 'email', '2025-07-30 10:00:51', '2025-07-30 10:00:51'),
(107, 13, 'email_verified', '2025-07-30 15:35:25', '2025-07-30 10:05:25', '2025-07-30 10:05:25'),
(108, 13, 'email_verified_last', '2025-07-30 15:35:25', '2025-07-30 10:05:25', '2025-07-30 10:05:25'),
(109, 14, 'profile_display_name', 'Emeka', '2025-07-30 10:09:06', '2025-07-30 10:09:06'),
(110, 14, 'profile_avatar_bg', 'teal', '2025-07-30 10:09:06', '2025-07-30 10:09:06'),
(111, 14, 'profile_display_full_name', 'on', '2025-07-30 10:09:06', '2025-07-30 10:09:06'),
(112, 14, 'setting_activity_log', 'on', '2025-07-30 10:09:06', '2025-07-30 10:09:06'),
(113, 14, 'setting_unusual_activity', 'on', '2025-07-30 10:09:06', '2025-07-30 10:09:06'),
(114, 14, 'registration_method', 'email', '2025-07-30 10:09:06', '2025-07-30 10:09:06'),
(115, 14, 'email_verified', '2025-07-30 15:39:39', '2025-07-30 10:09:39', '2025-07-30 10:09:39'),
(116, 14, 'email_verified_last', '2025-07-30 15:39:39', '2025-07-30 10:09:39', '2025-07-30 10:09:39'),
(117, 14, 'first_login_at', '2025-07-30 15:39:56', '2025-07-30 10:09:56', '2025-07-30 10:09:56'),
(118, 13, 'last_password_changed', '1753890401', '2025-07-30 10:16:41', '2025-07-30 10:16:41'),
(119, 13, 'last_password_changed', '1753890666', '2025-07-30 10:21:06', '2025-07-30 10:21:06'),
(120, 13, 'last_password_changed', '1753890914', '2025-07-30 10:25:14', '2025-07-30 10:25:14'),
(121, 13, 'last_password_changed', '1753891408', '2025-07-30 10:33:28', '2025-07-30 10:33:28'),
(122, 13, 'last_password_changed', '1753891667', '2025-07-30 10:37:47', '2025-07-30 10:37:47'),
(123, 13, 'last_password_changed', '1753891797', '2025-07-30 10:39:57', '2025-07-30 10:39:57'),
(124, 13, 'last_password_changed', '1753891935', '2025-07-30 10:42:15', '2025-07-30 10:42:15'),
(125, 13, 'last_password_changed', '1753892114', '2025-07-30 10:45:14', '2025-07-30 10:45:14'),
(126, 15, 'profile_display_name', 'democoder', '2025-07-30 10:49:38', '2025-07-30 10:49:38'),
(127, 15, 'profile_avatar_bg', 'info', '2025-07-30 10:49:38', '2025-07-30 10:49:38'),
(128, 15, 'profile_display_full_name', 'on', '2025-07-30 10:49:38', '2025-07-30 10:49:38'),
(129, 15, 'setting_activity_log', 'on', '2025-07-30 10:49:38', '2025-07-30 10:49:38'),
(130, 15, 'setting_unusual_activity', 'on', '2025-07-30 10:49:38', '2025-07-30 10:49:38'),
(131, 15, 'registration_method', 'email', '2025-07-30 10:49:38', '2025-07-30 10:49:38'),
(132, 15, 'email_verified', '2025-07-30 16:19:55', '2025-07-30 10:49:55', '2025-07-30 10:49:55'),
(133, 15, 'email_verified_last', '2025-07-30 16:19:55', '2025-07-30 10:49:55', '2025-07-30 10:49:55'),
(134, 15, 'last_password_changed', '1753892437', '2025-07-30 10:50:37', '2025-07-30 10:50:37');

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

--
-- Table structure for table `user_temp_metas`
--

CREATE TABLE `user_temp_metas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `meta_key` varchar(191) NOT NULL,
  `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`meta_value`)),
  `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 `user_temp_metas`
--

INSERT INTO `user_temp_metas` (`id`, `user_id`, `meta_key`, `meta_value`, `created_at`, `updated_at`) VALUES
(1, 10, 'wd_source', '\"main_wallet\"', '2025-07-22 10:30:00', '2025-07-22 10:30:00'),
(2, 10, 'withdraw_method', '{\"id\":3,\"slug\":\"wd-crypto-wallet\",\"name\":\"Crypto Wallet\",\"desc\":\"Withdraw your fund via crypto wallet\",\"min_amount\":\"0.1\",\"max_amount\":\"1\",\"config\":{\"wallet\":{\"BTC\":{\"min\":\"0.1\",\"max\":\"1\"},\"ETH\":{\"min\":\"0.10\",\"max\":\"1\"},\"LTC\":{\"min\":\"0\",\"max\":\"0\"},\"BCH\":{\"min\":\"0\",\"max\":\"0\"},\"BNB\":{\"min\":\"0\",\"max\":\"0\"},\"USDC\":{\"min\":\"0\",\"max\":\"0\"},\"USDT\":{\"min\":\"0\",\"max\":\"0\"},\"TRX\":{\"min\":\"0\",\"max\":\"0\"}},\"meta\":[]},\"fees\":null,\"currencies\":[\"BTC\",\"ETH\"],\"countries\":[],\"status\":\"active\",\"created_at\":\"2025-07-22T15:46:27.000000Z\",\"updated_at\":\"2025-07-22T15:47:57.000000Z\"}', '2025-07-22 10:30:00', '2025-07-22 10:30:00'),
(3, 10, 'wd_currencies_wd-crypto-wallet', '[\"BTC\",\"ETH\",\"USD\"]', '2025-07-22 10:30:00', '2025-07-22 10:30:00'),
(4, 10, 'wd_details', '{\"method\":\"wd-crypto-wallet\",\"method_name\":\"Bitcoin Wallet\",\"currency\":\"BTC\",\"currency_name\":\"Bitcoin\",\"amount\":\"0.00084\",\"amount_fees\":0,\"total\":0.00084,\"base_amount\":\"100\",\"base_fees\":0,\"base_total\":100,\"base_currency\":\"USD\",\"exchange_rate\":\"0.0000084\",\"pay_to\":null,\"pay_meta\":{\"method\":\"Crypto Wallet\",\"label\":\"AC-0010-1843\",\"payment\":null,\"currency\":\"BTC\"},\"unote\":\"\",\"source\":\"main_wallet\",\"account\":null,\"fx_rate\":\"0.0000084\",\"fx_currency\":\"BTC\",\"fees\":{\"total\":0}}', '2025-07-22 10:35:37', '2025-07-22 10:35:37'),
(5, 10, 'deposit_currencies_coinpayments', '[\"BTC\"]', '2025-07-22 13:32:08', '2025-07-22 13:32:08'),
(6, 10, 'deposit_currencies_crypto-wallet', '[\"BTC\"]', '2025-07-23 01:46:18', '2025-07-23 01:46:18'),
(7, 10, 'deposit_details', '{\"amount\":\"1\",\"currency\":\"BTC\",\"currency_name\":\"Bitcoin\",\"payment\":{\"address\":\"xxxxxxxxxxxxxxxxxxxxxxxx\",\"meta\":{\"address\":\"xxxxxxxxxxxxxxxxxxxxxxxx\",\"wnote\":\"efsfffg\",\"ref\":\"no\",\"network\":\"default\",\"timeout\":\"0\"},\"fiat\":\"USD\"},\"tranx\":{\"tnx\":\"69095504\",\"type\":\"deposit\",\"user_id\":10,\"account_to\":1,\"calc\":\"credit\",\"amount\":98196.19,\"fees\":0,\"total\":\"98196.19\",\"currency\":\"USD\",\"tnx_amount\":1,\"tnx_fees\":0,\"tnx_total\":\"1\",\"tnx_currency\":\"BTC\",\"tnx_method\":\"crypto-wallet\",\"exchange\":\"0.000010183695\",\"status\":\"none\",\"description\":\"Deposit via rgfdgfdgfd\",\"meta\":{\"method\":\"crypto-wallet\",\"amount\":1,\"fees\":{\"total\":0},\"total\":\"1\",\"base_amount\":98196.19,\"base_total\":\"98196.19\",\"pay_meta\":{\"address\":\"xxxxxxxxxxxxxxxxxxxxxxxx\",\"wnote\":\"efsfffg\",\"ref\":\"no\",\"network\":\"default\",\"timeout\":\"0\"}},\"pay_to\":\"xxxxxxxxxxxxxxxxxxxxxxxx\",\"created_by\":10,\"updated_at\":\"2025-08-02T09:05:04.000000Z\",\"created_at\":\"2025-08-02T09:05:04.000000Z\",\"id\":5},\"method\":{\"id\":3,\"slug\":\"crypto-wallet\",\"name\":\"Crypto Wallet\",\"desc\":\"Send your payment direct to our wallet.\",\"min_amount\":\"0.1\",\"max_amount\":\"1000\",\"config\":{\"meta\":{\"title\":\"rgfdgfdgfd\",\"fiat\":\"USD\",\"timeout\":\"0\",\"qr\":\"show\"},\"wallet\":{\"BTC\":{\"address\":\"xxxxxxxxxxxxxxxxxxxxxxxx\",\"wnote\":\"efsfffg\",\"min\":\"1\",\"max\":\"1000\",\"ref\":\"no\",\"network\":\"default\"},\"ETH\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\",\"limit\":null,\"price\":null,\"network\":\"default\"},\"LTC\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\",\"network\":\"default\"},\"BCH\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\",\"network\":\"default\"},\"BNB\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\",\"network\":\"default\"},\"ADA\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\"},\"XRP\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\"},\"USDC\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\",\"network\":\"default\"},\"USDT\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\",\"network\":\"default\"},\"TRX\":{\"address\":null,\"wnote\":null,\"min\":\"0\",\"max\":\"0\",\"ref\":\"no\",\"network\":\"default\"}}},\"fees\":{\"flat\":0,\"percent\":0},\"currencies\":[\"BTC\"],\"countries\":[],\"status\":\"active\",\"created_at\":\"2025-07-22T10:50:37.000000Z\",\"updated_at\":\"2025-07-22T11:06:30.000000Z\"},\"qrcode\":\"bitcoin:xxxxxxxxxxxxxxxxxxxxxxxx?amount=1.00\",\"flush\":true}', '2025-08-01 14:43:49', '2025-08-02 03:35:04'),
(9, 10, 'deposit_currencies_paypal', '[\"USD\"]', '2025-08-02 02:54:13', '2025-08-02 02:54:13'),
(10, 10, 'deposit_currencies_flutterwave', '[\"USD\"]', '2025-08-02 03:22:27', '2025-08-02 03:22:27');

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

--
-- Table structure for table `withdraw_methods`
--

CREATE TABLE `withdraw_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `desc` varchar(191) NOT NULL,
  `min_amount` varchar(191) DEFAULT NULL,
  `max_amount` varchar(191) DEFAULT NULL,
  `config` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`config`)),
  `fees` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`fees`)),
  `currencies` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`currencies`)),
  `countries` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`countries`)),
  `status` varchar(191) 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 `withdraw_methods`
--

INSERT INTO `withdraw_methods` (`id`, `slug`, `name`, `desc`, `min_amount`, `max_amount`, `config`, `fees`, `currencies`, `countries`, `status`, `created_at`, `updated_at`) VALUES
(2, 'wd-paypal', 'PayPal', 'Withdraw your fund through PayPal', '1', '100', '{\"meta\":{\"title\":null,\"currency\":\"USD\",\"min\":\"0\",\"max\":\"0\"},\"currencies\":{\"USD\":{\"min\":\"1\",\"max\":\"1000\"},\"EUR\":{\"min\":\"0\",\"max\":\"0\"},\"GBP\":{\"min\":\"0\",\"max\":\"0\"},\"CAD\":{\"min\":\"0\",\"max\":\"0\"},\"AUD\":{\"min\":\"0\",\"max\":\"0\"},\"RUB\":{\"min\":\"0\",\"max\":\"0\"},\"BRL\":{\"min\":\"0\",\"max\":\"0\"},\"MXN\":{\"min\":\"0\",\"max\":\"0\"}},\"api\":[]}', NULL, '[\"USD\"]', '[]', 'inactive', '2025-07-22 09:44:55', '2025-07-22 10:03:16');
--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `email_templates`
--
ALTER TABLE `email_templates`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email_templates_slug_unique` (`slug`);

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

--
-- Indexes for table `iv_actions`
--
ALTER TABLE `iv_actions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `iv_actions_type_id_index` (`type_id`);

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

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

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

--
-- Indexes for table `iv_schemes`
--
ALTER TABLE `iv_schemes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `iv_schemes_slug_unique` (`slug`);

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

--
-- Indexes for table `kyc_applicants`
--
ALTER TABLE `kyc_applicants`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `kyc_applicants_reference_unique` (`reference`),
  ADD KEY `kyc_applicants_user_id_index` (`user_id`);

--
-- Indexes for table `kyc_sessions`
--
ALTER TABLE `kyc_sessions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `kyc_sessions_session_unique` (`session`),
  ADD KEY `kyc_sessions_user_id_index` (`user_id`);

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `languages_code_unique` (`code`);

--
-- Indexes for table `ledgers`
--
ALTER TABLE `ledgers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `ledgers_transaction_id_unique` (`transaction_id`);

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

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pages_slug_unique` (`slug`);

--
-- Indexes for table `payment_methods`
--
ALTER TABLE `payment_methods`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `payment_methods_slug_unique` (`slug`);

--
-- 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 `referrals`
--
ALTER TABLE `referrals`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `referral_codes`
--
ALTER TABLE `referral_codes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `referral_codes_code_unique` (`code`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_key_unique` (`key`);

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

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

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

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

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

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

--
-- Indexes for table `withdraw_methods`
--
ALTER TABLE `withdraw_methods`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `withdraw_methods_slug_unique` (`slug`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- 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 `referrals`
--
ALTER TABLE `referrals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

