-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Nov 09, 2021 at 09:52 AM
-- Server version: 10.3.31-MariaDB-log-cll-lve
-- PHP Version: 7.3.28

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `univdoyv_coin`
--

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

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

CREATE TABLE `admins` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `firstName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dashboard_style` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'dark',
  `remember_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acnt_type_active` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `admins` (`id`, `firstName`, `lastName`, `email`, `email_verified_at`, `password`, `phone`, `dashboard_style`, `remember_token`, `acnt_type_active`, `status`, `type`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'assistance', 'super@happ.com', NULL, '$2y$10$DD2x5QqEARQhc9YA3G2PG.0V9rchuxgGgSO/WDgsobCnOO2ukz2z6', '+10404418365', 'dark', NULL, 'active', 'active', 'Super Admin', '2021-03-10 12:55:53', '2021-11-05 14:03:30'),
(2, 'Admin', 'test', 'admin@happ.com', NULL, '$2y$10$ly8phqbtzKvYoeT.axkZdu98ckXBnmEKmzVogLLy90a.8ROKV0eze', '99494948', 'Dark', NULL, 'active', NULL, 'Admin', '2021-03-11 13:05:41', '2021-03-11 14:21:28'),
(3, 'WEB', 'SLOT', 'admin@gmail.com', NULL, '$2y$10$nv0nF6kqJNXMcK4fN.X5mu0pAUb15p7Q5KQr1NVLG9xPkBmkgpW.q', '76765386538638', 'dark', NULL, 'active', 'active', 'Super Admin', '2021-10-27 13:09:15', '2021-10-27 13:09:15');

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

--
-- Table structure for table `agents`
--

CREATE TABLE `agents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_refered` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `total_activated` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `earnings` varchar(255) COLLATE utf8mb4_unicode_ci 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 `agents`
--

INSERT INTO `agents` (`id`, `agent`, `total_refered`, `total_activated`, `earnings`, `created_at`, `updated_at`) VALUES
(1, '26', '10', '0', '0', '2021-10-28 00:15:08', '2021-10-28 00:15:08');

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

--
-- Table structure for table `assets`
--

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

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

--
-- Table structure for table `contents`
--

CREATE TABLE `contents` (
  `id` int(255) NOT NULL,
  `ref_key` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `contents`
--

INSERT INTO `contents` (`id`, `ref_key`, `title`, `description`, `created_at`, `updated_at`) VALUES
(5, 'SMsJr1', 'TESTIMONIALS', 'Don\'t take our word for it, here\'s what some of our clients have to say about us', '2020-08-22 11:13:00', '2021-10-27 05:51:53'),
(6, 'toe3Ew', 'Reliability', 'Being industry leader we provide our clients with extra solidity. We are doing more than anyone else to satisfy needs of our clients.', '2020-08-22 11:29:36', '2021-10-27 05:51:34'),
(7, 'jJwh78', 'We process withdrawal request Promptly', 'Put your investing ideas into action with a full range of investments. Enjoy real benefits and rewards on Online Trade.', '2020-08-22 11:30:22', '2021-10-27 05:50:51'),
(8, 'SLxaB2', 'Invest in the future', 'Put your investing ideas into action with a full range of investments.Enjoy real benefits and rewards on Online Trade.', '2020-08-22 11:30:55', '2020-08-22 11:30:55'),
(9, 'BkP8pH', 'Trade on the Go', 'Trading on the go has be simplified and easy to go', '2020-08-22 11:31:38', '2021-10-27 05:50:00'),
(10, 'W6gTBN', 'Buy,sell,trade,invest has been simplified', 'Everybody can become a trader with our easiest to use trading platform. ExpertOption is available on all modern platforms: Web, Windows, MacOS, iPhone, iPad and Android.', '2020-08-22 11:31:55', '2021-10-27 05:49:42'),
(11, 'anvs8c', 'About', 'We at Universal Crypto Mining, have been working continuously to transform the traditional smart trading industry, in order to open the financial markets to everyone,  we are your no1 cryptocurrency investment portfolio management system', '2020-08-22 11:32:29', '2021-10-27 09:25:06'),
(12, 'epJ4LI', 'we Innovate', 'We innovate because we are leaders. Our work leverages our personal, distinctive knowledge and creativity.', '2020-08-22 11:33:32', '2021-10-27 05:48:57'),
(13, '5hbB6X', 'LINCENSE CERTIFIED', 'we are fully Licensed and Certified to carry out trading activities.', '2020-08-22 11:33:55', '2021-10-27 05:48:38'),
(14, 'Zrhm3I', 'WE ARE PROFESSIONAL', 'we are Professional forex traders and trading experts, and we Aim at giving you the best advice on trading.', '2020-08-22 11:34:11', '2021-10-27 05:48:13'),
(15, 'yTKhlt', 'SAVINGS AND INVESTMENT', 'we offers Financial Planning and Advice, Retirement Plans, Wealth Management Services.', '2020-08-22 11:34:26', '2021-10-27 05:47:53'),
(16, 'u0Ervr', 'OUR SERVICES', 'Why you should Choose us', '2020-08-22 11:34:56', '2020-08-22 11:34:56'),
(17, 'Dwu6Bv', 'STABLE AND PROFITABLE', 'we have the most profitable design of a stock market trading system. will quickly give you a system that is profitable and stable into the future', '2020-08-22 11:35:22', '2021-10-27 05:47:18'),
(18, 'eMo1d2', 'INSTANT AND SECURE WITHDRAWALS', 'We provide fastest trading using cutting-edge technologies. No delays in order executions and lags in user interface.', '2020-08-22 11:35:42', '2021-10-27 05:46:57'),
(19, 'kEJPm3', 'REFERRALS PROGRAM', 'Earn cash by referring users to us through our referral affiliate program. We empower everyone with the best charts, trading tools', '2020-08-22 11:35:59', '2021-10-27 05:46:12'),
(20, 'bBSnFV', 'MULTI CURRENCY SUPPORT', 'Multi-currency support means you can pay using the currency they are already comfortable using.', '2020-08-22 11:36:17', '2021-10-27 05:45:50'),
(21, 'DUK9pc', '24/7 CUSTOMER SUPPORT', 'Feel the Support\r\nWe will answer all your questions 24/7. We speak your language.', '2020-08-22 11:36:31', '2021-10-27 05:45:29'),
(22, 'VaeiMW', 'ULTIMATE SECURITY', 'Verified by Visa and MasterCard\r\nAll data is encrypted with strongest cryptographic algorithms', '2020-08-22 11:36:49', '2021-10-27 05:45:03'),
(23, 'vr6Xw0', 'OUR INVESTMENT PLAN', 'Choose how you want to invest with us', '2020-08-22 11:37:43', '2020-08-22 11:37:43'),
(25, 'OtEicb', 'LATEST TRANSACTIONS', 'Our goal is to simplify investing so that anyone can be an investor. With this in mind, we hand-pick the investments we offer on our platform.', '2020-08-22 11:38:06', '2021-10-27 05:44:19'),
(26, 'OLZt1I', 'FREQUENTLY ASKED QUESTIONS', 'Our goal is to simplify investing so that anyone can be an investor. With this in mind, we hand-pick the investments we offer on our platforms.', '2020-08-22 11:38:56', '2021-10-27 05:44:00'),
(27, 'U7zpEj', 'WE ACCEPT', 'we accept', '2020-08-22 11:39:43', '2020-08-22 11:39:43'),
(29, '9sNF7G', 'CONTACT US', 'Send us a message and we\'ll respond as soon as possible', '2020-08-22 11:40:06', '2021-10-27 05:43:33'),
(30, '52GPRA', 'ADDRESS', '89460 Raynor Gardens Auxier, KY 41602', '2020-08-22 11:40:19', '2021-10-27 05:43:11'),
(31, '0EXbji', 'PHONE NUMBER', '+1.704.689.0728', '2020-08-22 11:40:36', '2021-10-27 05:42:47'),
(32, 'HLgyaQ', 'EMAIL', 'support@coin.universalcryptomining.com', '2020-08-22 11:41:14', '2021-10-27 09:25:43'),
(33, 'ETsdbc', 'Website Description in Footer', 'Trading and investing involves significant level of risk and is not suitable and/or appropriate for all clients. Please make sure you carefully consider your investment objectives, level of experience and risk appetite before buying or selling. Buying or selling entails financial risks and could result in a partial or complete loss of your funds, therefore, you should not invest funds you cannot afford to lose. You should be aware of and fully understand all the risks associated with trading and investing, and seek advice from an independent financial advisor if you have any doubts. You are granted limited non-exclusive rights to use the IP contained in this site for personal, non-commercial, non-transferable use only in relation to the services offered on the site.', '2020-08-22 11:42:05', '2021-10-27 05:42:02'),
(35, 'dePBnV', 'Do you guys pay on weekends', 'No we dont pay on weekends \r\nonly working days.', '2021-10-27 05:40:03', '2021-10-27 05:40:03');

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

--
-- Table structure for table `cp_transactions`
--

CREATE TABLE `cp_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `txn_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Item_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount_paid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_plan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_tele_id` int(11) DEFAULT NULL,
  `amount1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cp_p_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cp_pv_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cp_m_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cp_ipn_secret` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cp_debug_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cp_transactions`
--

INSERT INTO `cp_transactions` (`id`, `txn_id`, `item_name`, `Item_number`, `amount_paid`, `user_plan`, `user_id`, `user_tele_id`, `amount1`, `amount2`, `currency1`, `currency2`, `status`, `status_text`, `type`, `cp_p_key`, `cp_pv_key`, `cp_m_id`, `cp_ipn_secret`, `cp_debug_email`, `created_at`, `updated_at`) VALUES
(1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'jdjjjkdkd', 'kkdhdjjdjjkd', 'Victory ID', 'dhhdhd', 'support@onlintrade.com', '2021-03-11 12:46:45', '2021-03-15 12:54:07');

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

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

CREATE TABLE `deposits` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `txn_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user` int(11) DEFAULT NULL,
  `uname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_mode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan` int(11) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `proof` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `deposits`
--

INSERT INTO `deposits` (`id`, `txn_id`, `user`, `uname`, `amount`, `payment_mode`, `plan`, `status`, `proof`, `created_at`, `updated_at`) VALUES
(1, NULL, 23, NULL, '500', 'Bitcoin', NULL, 'Processed', 'CtgwWAallthing.jpg1635325259', '2021-10-27 13:01:04', '2021-10-27 13:12:06'),
(2, NULL, 23, NULL, '300', 'Express Deposit', NULL, 'Processed', NULL, '2021-10-27 15:48:58', '2021-10-27 15:48:58'),
(3, NULL, 26, NULL, '100', 'Express Deposit', NULL, 'Processed', NULL, '2021-10-27 17:44:25', '2021-10-27 17:44:25'),
(4, NULL, 26, NULL, '1000', 'Express Deposit', NULL, 'Processed', NULL, '2021-10-27 17:46:01', '2021-10-27 17:46:01'),
(5, NULL, 26, NULL, '10', 'Bank transfer', 2, 'Processed', '87nv6Ylogo.png1635356877', '2021-10-27 21:47:58', '2021-10-27 22:04:50'),
(6, NULL, 26, NULL, '100', 'Bitcoin', 2, 'Processed', NULL, '2021-10-27 23:58:43', '2021-10-28 01:14:20'),
(7, NULL, 29, NULL, '500', 'Bitcoin', NULL, 'Processed', NULL, '2021-10-28 01:24:09', '2021-10-28 01:35:16'),
(8, NULL, 30, NULL, '1000', 'Bank transfer', NULL, 'Processed', NULL, '2021-10-28 10:57:39', '2021-10-28 10:58:12'),
(9, NULL, 31, NULL, '1000', 'Bitcoin', NULL, 'Processed', NULL, '2021-10-28 15:35:20', '2021-10-28 15:36:08'),
(10, NULL, 35, NULL, '500', 'Bitcoin', NULL, 'Processed', 'ZYxdLPScreenshot_20211104-101838.jpg1636105930', '2021-11-05 13:52:10', '2021-11-05 13:52:31'),
(11, NULL, 36, NULL, '1000', 'Bitcoin', NULL, 'Pending', 'MM4czPScreenshot_20211101-092020.jpg1636109547', '2021-11-05 14:52:27', '2021-11-05 14:52:27');

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

--
-- Table structure for table `failed_jobs`
--

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

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

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

CREATE TABLE `faqs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ref_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `question` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `answer` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `faqs` (`id`, `ref_key`, `question`, `answer`, `created_at`, `updated_at`) VALUES
(1, '8yZ6FC', 'How Can I Change My E-Mail Address Or Password?', 'Log into your  account and click on the \"Account Information\". You can change your e-mail address and password there.', '2021-03-11 14:31:42', '2021-10-27 13:32:26'),
(2, '9oXReW', 'What If I Can\'t Log Into My Account Because I Forgot My Password?', 'click forgot password, type your username or e-mail and you\'ll receive your account information.', '2021-10-27 09:40:28', '2021-10-27 13:34:49'),
(3, 'SuIQBA', 'After I Make A Withdrawal Request, When Will The Funds Be Available On My Ecurrency Account?', 'Funds are usually available within 1 business hours.', '2021-10-27 13:30:44', '2021-10-27 13:35:17'),
(4, 'izK64r', 'How Can I Check My Account Balances?', 'You can access the account information 24 hours, seven days a week over the Internet.', '2021-10-27 13:35:47', '2021-10-27 13:35:47'),
(5, 'VaceBL', 'REFER US TO YOUR FRIENDS', 'You don’t need an active deposit to take advantage of our referral program. As long as you are a registered member, you only need to use your personal affiliate link from your member’s area and share it with your friends. You will get rewarded as soon as they join and make their first deposit!', '2021-10-27 13:36:25', '2021-10-27 13:36:25'),
(6, 'k9ygr6', 'REQUEST WITHDRAWALS FROM US', 'It only takes a few seconds to initiate your withdrawal process. All the withdrawals are manual due to fund security and paid within 24 hours.', '2021-10-27 13:36:53', '2021-10-27 13:36:53'),
(7, '51kq7X', 'WATCH YOUR CAPITAL GROW IN YOUR ACCOUNT', 'After you have made a deposit, there is nothing else to do except watch your earnings grow in your account. This can be fun, because it means you can be anywhere you want to be in the world, and your capital will still be growing in your account, even without you doing anything!', '2021-10-27 13:37:26', '2021-10-27 13:37:26'),
(8, 'I3n6rT', 'MAKE YOUR FIRST DEPOSIT IN YOUR ACCOUNT', 'To start growing your capital, you need to make a deposit. You can do this from the deposit section of your account. There are 8 various investment plans depending on the amount of your deposit. The minimum deposit amount is 20 USD, and you are allowed to make as many deposits as you want. However, every deposit is treated as a separate investment.', '2021-10-27 13:38:03', '2021-10-27 13:38:03'),
(9, 'Wr5rSJ', 'LOGIN TO  MEMBER’S AREA', 'Once you’ve opened an account, the next thing would be to familiarize yourself with how different sections of your account works. To start, go to the login page and enter your registration username and chosen password. After you are logged in, you can explore your account and get a feel of how everything works, such as making deposits, requesting withdrawals, etc.', '2021-10-27 13:38:28', '2021-10-27 13:38:28'),
(10, '4Nfp7Y', 'OPEN YOUR  ACCOUNT', 'To open an account, simply click on the “Register New Account” button on the main page. The next page is the registration form that you need to fill out. This shouldn’t take more than a few minutes. Once you’ve done that, you’ll receive an email confirmation from us, and you’re done. You are now an official member of our site!', '2021-10-27 13:39:15', '2021-10-27 13:39:15');

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

--
-- Table structure for table `images`
--

CREATE TABLE `images` (
  `id` int(255) NOT NULL,
  `ref_key` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `img_path` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `images`
--

INSERT INTO `images` (`id`, `ref_key`, `title`, `description`, `img_path`, `created_at`, `updated_at`) VALUES
(3, '57VnOE', 'Slider1', 'This is carosel 1', 'AaHyG739defaad-3384-42b1-a767-ebdd5cde73e9.jpg1635326624', '2020-08-23 12:08:38', '2021-10-27 09:23:44'),
(4, 'dC6ZaA', 'Slider2', 'This is slider 2', '939fKnhIduBXguy.jfif16351744951635314565', '2020-08-23 12:09:00', '2021-10-27 06:02:45'),
(5, '9kHash', 'Slider3', 'This is slider 3', '3XGMQmYCQasxfc2ad3e3909fada069eb880d0e1f1660.jpg16351743651635314531', '2020-08-23 12:09:16', '2021-10-27 06:02:11'),
(6, 'CcW52g', 'Slider4', 'This is Slider 4', 'KS6oRuQFc0XZ974270c09436eb9b308d2caee3fe03be.jpg16351742801635314503', '2020-08-23 12:09:38', '2021-10-27 06:01:43'),
(7, '96i7xH', 'Slider5', 'This is slider 5', 'hTIpy9nHKnAeChristina-Huang-12.jpg16351744281635314471', '2020-08-23 12:09:55', '2021-10-27 06:01:11'),
(8, 'DPd1Kn', 'Testimonial 1', 'Testimonial 1', 'JAtgyUmy4zOpmmn.jpg16346006781635314436', '2020-08-23 12:24:52', '2021-10-27 06:00:36'),
(9, 'ZqCgDz', 'Testimonial 2', 'Testimonial 2', 'inAd2tfLptQor23.jpeg16346005871635314395', '2020-08-23 12:25:07', '2021-10-27 05:59:55'),
(10, 'zNNAgD', 'Testimonial 3', 'Testimonial 3', 'atTJNafkLa2pbitcoin-5675758_1280-e1610871166803.png16346006241635314373', '2020-08-23 12:25:22', '2021-10-27 05:59:33'),
(11, '2v0Ut5', 'Testimonial 4', 'Testimonial 4', 'm1Nfy3b4Qprcbti001.jpeg16346005401635314347', '2020-08-23 12:25:37', '2021-10-27 05:59:07'),
(12, '4Rp9Wz', 'Testimonial 5', 'Testimonial 5', 'yBsauH48Ozz1bitcoin-bounce-1.jpg16346006581635314326', '2020-08-23 12:25:54', '2021-10-27 05:58:46'),
(13, 'tXf1Zz', 'Testimonial 1', 'Testimonial 1', 'Yau02z0vPnEYzzz3.jpeg16351743891635314307', '2020-08-25 14:52:57', '2021-10-27 05:58:27');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2014_10_12_200000_add_two_factor_columns_to_users_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(6, '2021_03_09_142220_create_sessions_table', 1),
(7, '2021_03_10_082445_create_admins_table', 2),
(8, '2021_03_10_082519_create_agents_table', 2),
(9, '2021_03_10_082715_create_assets_table', 2),
(10, '2021_03_10_082817_create_contents_table', 2),
(11, '2021_03_10_083110_create_cp_transactions_table', 2),
(12, '2021_03_10_083324_create_deposits_table', 2),
(13, '2021_03_10_083400_create_faqs_table', 2),
(14, '2021_03_10_083510_create_images_table', 2),
(15, '2021_03_10_083557_create_mt4_details_table', 2),
(16, '2021_03_10_083627_create_notifications_table', 2),
(17, '2021_03_10_083824_create_plans_table', 2),
(18, '2021_03_10_083850_create_settings_table', 2),
(19, '2021_03_10_083936_create_testimonies_table', 2),
(20, '2021_03_10_084009_create_tp__transactions_table', 2),
(21, '2021_03_10_084031_create_upgrades_table', 2),
(22, '2021_03_10_084120_create_userlogs_table', 2),
(23, '2021_03_10_084140_create_user_plans_table', 2),
(24, '2021_03_10_084235_create_wdmethods_table', 2),
(25, '2021_03_10_084300_create_withdrawals_table', 2);

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

--
-- Table structure for table `mt4_details`
--

CREATE TABLE `mt4_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` int(11) DEFAULT NULL,
  `mt4_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mt4_password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `leverage` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `server` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `options` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime 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 `notifications`
--

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

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `user_id`, `message`, `created_at`, `updated_at`) VALUES
(2, 9, 'This is a new mail Victory, kindly apprehiend', '2021-03-12 12:38:30', '2021-03-12 12:38:30');

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

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

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

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

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

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_used_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 `plans`
--

CREATE TABLE `plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `min_price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `max_price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `minr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `maxr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gift` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expected_return` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `increment_interval` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `increment_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `increment_amount` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expiration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plans`
--

INSERT INTO `plans` (`id`, `name`, `price`, `min_price`, `max_price`, `minr`, `maxr`, `gift`, `expected_return`, `type`, `increment_interval`, `increment_type`, `increment_amount`, `expiration`, `created_at`, `updated_at`) VALUES
(1, 'Starter', '500', '200', '1000', '60', '70', '100', NULL, 'Main', 'Hourly', 'Percentage', '5', 'One week', '2021-03-11 11:10:23', '2021-10-27 10:07:41'),
(2, 'Standard', '1000', '500', '2000', '70%', '80%', '200', NULL, 'Main', 'Daily', 'Percentage', '10', 'One week', '2021-10-27 10:09:17', '2021-10-27 10:09:17'),
(3, 'Premium', '5000', '5000', '10000', '100', '200', '1000', NULL, 'Main', 'Weekly', 'Percentage', '50', 'One week', '2021-10-27 10:10:52', '2021-10-27 10:10:52');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payload` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('DaUmiUvlVekHssjsGpz8prl4ZFjt7JEe4XbNQ3Mu', NULL, '197.210.78.232', 'WhatsApp/2.21.16.20 A', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUmdTMzdSVUM4djhCeFhhcEdxYkpLMFZhT2N0clhvNDFweExXdFBCNiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTU6Imh0dHBzOi8vY29pbi51bml2ZXJzYWxjcnlwdG9taW5pbmcuY29tL2FkbWlubG9naW4vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1636442310),
('eZXk3VIzsN9YuzOttAS19cL0iRZkWQ7d5VvU7xnY', NULL, '105.112.108.70', 'WhatsApp/2.21.17.24 A', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWmp1TEtGSGpVM2NXTWhhQ0V6bDZzanVhQWh6NXdoWGt2aGZMRDg2QiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTU6Imh0dHBzOi8vY29pbi51bml2ZXJzYWxjcnlwdG9taW5pbmcuY29tL2FkbWlubG9naW4vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1636370942),
('JqvgGsmZyhOUIMxN11VSJwGuBnUNw8k7vHEVULQ8', NULL, '105.112.41.97', 'WhatsApp/2.21.17.24 A', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieHZxR25EQ1RrQVhkSFdqeHhJcnZCdVZuNlZlbXdHQkp4dUxkd3MxaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTU6Imh0dHBzOi8vY29pbi51bml2ZXJzYWxjcnlwdG9taW5pbmcuY29tL2FkbWlubG9naW4vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1636286604),
('JT9HZMxLVOyM2vg7lZIUanhLNTIlV7nC19dTnB73', NULL, '197.149.127.196', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.82 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiSFltcnJGeThnbkRuakVOdUtzdFpJWTNzSko1ZUd1ZVVKNGdVcXFDcyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoxODk6Imh0dHBzOi8vY29pbi51bml2ZXJzYWxjcnlwdG9taW5pbmcuY29tL2VtYWlsL3ZlcmlmeS8zOC83MTRlNTA3Yjk3NzMwNTRlODMwZDYzNTMwYjEzN2M5Yzc5M2UwYzZiP2V4cGlyZXM9MTYzNjMyNTU0OSZzaWduYXR1cmU9YWVlNTIzODY1MGQxNWRjZDdlMDE0ZDlkMTk4ODUzNDQ2NjUyZTRiYTQwYTg4ZTc0YjEyMWQ4MTVlYWJlMzA1MSI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjQ0OiJodHRwczovL2NvaW4udW5pdmVyc2FsY3J5cHRvbWluaW5nLmNvbS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1636322890),
('K80680RYcjZ7sYFZ1sW84DcJWxPeZiwVOequybdq', NULL, '129.205.112.50', 'Mozilla/5.0 (Windows NT 6.3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.69 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRXhncGFrQmd4S0U2ZHFXRHhTTFFrQ3puNzZTbmJTVlhDcTBqcWFUdSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDQ6Imh0dHBzOi8vY29pbi51bml2ZXJzYWxjcnlwdG9taW5pbmcuY29tL2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1636351103),
('kp9nkS5ipgAN3FH3XC793LynWP0oEpRxAsgodQO7', 38, '129.205.113.30', 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.1 Mobile/15E148 Safari/604.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoicUJ1U2FGY0ZwdzNvdWY4WTRrN2FmYm95cmRjc3pQRlZpR1VpS3R3WiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDQ6Imh0dHBzOi8vY29pbi51bml2ZXJzYWxjcnlwdG9taW5pbmcuY29tL2xvZ2luIjt9czo4OiJnZXRBbm91YyI7czo0OiJ0cnVlIjtzOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTozODt9', 1636322020),
('kwTxGDenzNdNtq8meQN2eIuzCn2wog35Tu8ac32G', 37, '102.89.0.19', 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_5_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.1.2 Mobile/15E148 Safari/604.1', 'YTo3OntzOjY6Il90b2tlbiI7czo0MDoiY25STVdNOXhYa09JRnJCVk92cDZhWHVEVTJCUmNTUGptOHdlMTJFMCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDg6Imh0dHBzOi8vY29pbi51bml2ZXJzYWxjcnlwdG9taW5pbmcuY29tL2Rhc2hib2FyZCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjM3O3M6MTc6InBhc3N3b3JkX2hhc2hfd2ViIjtzOjYwOiIkMnkkMTAkRC53SnZXb3VaLlNEQXEzYkM2ZnNLZWdPelpETFZqOWl4UWxGenEzVUFiWDRuM2xGc1YuSC4iO3M6MzoidXJsIjthOjE6e3M6ODoiaW50ZW5kZWQiO3M6NDg6Imh0dHBzOi8vY29pbi51bml2ZXJzYWxjcnlwdG9taW5pbmcuY29tL2Rhc2hib2FyZCI7fXM6MjE6InBhc3N3b3JkX2hhc2hfc2FuY3R1bSI7czo2MDoiJDJ5JDEwJEQud0p2V291Wi5TREFxM2JDNmZzS2VnT3paRExWajlpeFFsRnpxM1VBYlg0bjNsRnNWLkguIjt9', 1636287993),
('pohSNUqzO1IUqDLFyYEsVqO8hC40TsGURID2KAcH', NULL, '102.91.4.233', 'Mozilla/5.0 (Linux; Android 11; Infinix X689C) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVXRWaWpSb1djUkVKeGtGd3NsUjNQZGZsTXowaWs5d3BpYTgwR1RXdiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTU6Imh0dHBzOi8vY29pbi51bml2ZXJzYWxjcnlwdG9taW5pbmcuY29tL2FkbWlubG9naW4vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1636441153),
('tMFNNAgSl0PBVbbUTI2HhA6d5XHtvp58IAOday5A', NULL, '197.210.65.174', 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_5_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.1.2 Mobile/15E148 Safari/604.1', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoibmcydTd4RHNOc2NyWVFZWEJ6UDl5aUx3NVptTE5JTHI4a1dmbTBHNiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0ODoiaHR0cHM6Ly9jb2luLnVuaXZlcnNhbGNyeXB0b21pbmluZy5jb20vZGFzaGJvYXJkIjt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDQ6Imh0dHBzOi8vY29pbi51bml2ZXJzYWxjcnlwdG9taW5pbmcuY29tL2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1636344036),
('UBiXVUDPwvrb6a7hRFKGi3qJEN3UvzlUol6h7X3I', 37, '197.210.8.152', 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_5_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.1.2 Mobile/15E148 Safari/604.1', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoicUlBazlEOFplS0hZMlNQZVFyd1FBN2JRS1hIYzB3aDF5UWxxc3FWNSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDg6Imh0dHBzOi8vY29pbi51bml2ZXJzYWxjcnlwdG9taW5pbmcuY29tL2Rhc2hib2FyZCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjM3O3M6MTc6InBhc3N3b3JkX2hhc2hfd2ViIjtzOjYwOiIkMnkkMTAkRC53SnZXb3VaLlNEQXEzYkM2ZnNLZWdPelpETFZqOWl4UWxGenEzVUFiWDRuM2xGc1YuSC4iO3M6MjE6InBhc3N3b3JkX2hhc2hfc2FuY3R1bSI7czo2MDoiJDJ5JDEwJEQud0p2V291Wi5TREFxM2JDNmZzS2VnT3paRExWajlpeFFsRnpxM1VBYlg0bjNsRnNWLkguIjt9', 1636322547),
('UrpxE2oYcnjFvXXVPi2B6eRdRSFT2Bwn3VWrjpjv', 37, '102.89.1.113', 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_5_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.1.2 Mobile/15E148 Safari/604.1', 'YTo3OntzOjY6Il90b2tlbiI7czo0MDoicWlYbGI1aFRLcUIxTFl5V2o5dWNFSUdpblFBOEVrZHI2dUg0MklBbCI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjQ4OiJodHRwczovL2NvaW4udW5pdmVyc2FsY3J5cHRvbWluaW5nLmNvbS9kYXNoYm9hcmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTozNztzOjE3OiJwYXNzd29yZF9oYXNoX3dlYiI7czo2MDoiJDJ5JDEwJEQud0p2V291Wi5TREFxM2JDNmZzS2VnT3paRExWajlpeFFsRnpxM1VBYlg0bjNsRnNWLkguIjtzOjIxOiJwYXNzd29yZF9oYXNoX3NhbmN0dW0iO3M6NjA6IiQyeSQxMCRELndKdldvdVouU0RBcTNiQzZmc0tlZ096WkRMVmo5aXhRbEZ6cTNVQWJYNG4zbEZzVi5ILiI7fQ==', 1636287308),
('V0vAhXcAIYQ5rkVTBHSOdRTy1FxcSXfPiLeTVGcR', 38, '129.205.113.30', 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/95.0.4638.50 Mobile/15E148 Safari/604.1', 'YTo3OntzOjY6Il90b2tlbiI7czo0MDoiQkI5Rm54aFVmZ0ZFenZSU3I5eUFCYVU1T0JZdUR4TVZ4ekxxRnZtUyI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjQ4OiJodHRwczovL2NvaW4udW5pdmVyc2FsY3J5cHRvbWluaW5nLmNvbS9kYXNoYm9hcmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTozODtzOjE3OiJwYXNzd29yZF9oYXNoX3dlYiI7czo2MDoiJDJ5JDEwJEthQVEzckVtMnR5N3lvLjlVeXo2cXVvU1htQ1RrV0QwY2VnVUFmV1VaSzRHMjJ3NEVNYktDIjtzOjIxOiJwYXNzd29yZF9oYXNoX3NhbmN0dW0iO3M6NjA6IiQyeSQxMCRLYUFRM3JFbTJ0eTd5by45VXl6NnF1b1NYbUNUa1dEMGNlZ1VBZldVWks0RzIydzRFTWJLQyI7fQ==', 1636323062),
('VUHglHqDyDdhKbt208l3j9T15A8QpWgBxKrU694P', NULL, '197.210.76.30', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiaDlrSGhVMHc1MTBCRmxPN1VsRzV1S0k4S3pudVc4ZVp1Mm01RFdqdCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjQ6Imh0dHBzOi8vY29pbi51bml2ZXJzYWxjcnlwdG9taW5pbmcuY29tL2FkbWluL2Rhc2hib2FyZC9mcm9udHBhZ2UiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUyOiJsb2dpbl9hZG1pbl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7fQ==', 1636216389),
('XIRYaLJ7KjLEKMADYAbqqYMTl3jYJfNLpDuVXHES', NULL, '197.210.64.156', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:94.0) Gecko/20100101 Firefox/94.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicnFhU2FuVXNzckF6bVZkSHNuaEc1MWkxeTI1VGNLNHEzNUFyUDd2NyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTU6Imh0dHBzOi8vY29pbi51bml2ZXJzYWxjcnlwdG9taW5pbmcuY29tL2FkbWlubG9naW4vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1636469407),
('ZEPpd93ux9RpEZ6xir11RXrM5zYiGdJRsx9Wb6A2', NULL, '129.205.113.21', 'Mozilla/5.0 (Linux; Android 10; TECNO KD7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibnZvSk9TMEZIR3NqMDBQSGk0czFhczFZNVBhTWVmSlBrVWZHNmNBcCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTU6Imh0dHBzOi8vY29pbi51bml2ZXJzYWxjcnlwdG9taW5pbmcuY29tL2FkbWlubG9naW4vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1636373888),
('zZQ0PVHgYkOJxgdbEBC6EdUQiOkRy9C8rw5K1L5j', 39, '129.205.113.30', 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.1 Mobile/15E148 Safari/604.1', 'YTo3OntzOjY6Il90b2tlbiI7czo0MDoiTnA2RXBEbjhwdUN1cnhpRXpwd2xFTjhTaEZLRkxadlJzYlpFMUJocSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTE6Imh0dHBzOi8vY29pbi51bml2ZXJzYWxjcnlwdG9taW5pbmcuY29tL3ZlcmlmeS1lbWFpbCI7fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjM5O3M6MTc6InBhc3N3b3JkX2hhc2hfd2ViIjtzOjYwOiIkMnkkMTAkUmJtcEViTmxiZkJYaDUvYUJhNVhZLkZQell6QlNZU29HczhFS2tzVHI4dGhheDRMbkFXL3EiO3M6MzoidXJsIjthOjE6e3M6ODoiaW50ZW5kZWQiO3M6NDg6Imh0dHBzOi8vY29pbi51bml2ZXJzYWxjcnlwdG9taW5pbmcuY29tL2Rhc2hib2FyZCI7fXM6MjE6InBhc3N3b3JkX2hhc2hfc2FuY3R1bSI7czo2MDoiJDJ5JDEwJFJibXBFYk5sYmZCWGg1L2FCYTVYWS5GUHpZekJTWVNvR3M4RUtrc1RyOHRoYXg0TG5BVy9xIjt9', 1636322346);

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

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

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `site_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `s_currency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eth_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `btc_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ltc_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_mode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `s_s_k` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `s_p_k` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pp_cs` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pp_ci` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keywords` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `favicon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trade_mode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `google_translate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weekend_trade` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referral_commission` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referral_commission1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referral_commission2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referral_commission3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referral_commission4` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referral_commission5` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signup_bonus` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `files_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tawk_to` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enable_2fa` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `enable_kyc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `enable_with` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enable_verification` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'true',
  `withdrawal_option` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'auto',
  `dashboard_option` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_preference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enable_annoc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `commission_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `commission_fee` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `monthlyfee` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quarterlyfee` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `yearlyfee` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `newupdate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` (`id`, `site_name`, `description`, `currency`, `s_currency`, `bank_name`, `account_name`, `account_number`, `eth_address`, `btc_address`, `ltc_address`, `payment_mode`, `location`, `s_s_k`, `s_p_k`, `pp_cs`, `pp_ci`, `keywords`, `site_title`, `site_address`, `logo`, `favicon`, `trade_mode`, `google_translate`, `weekend_trade`, `contact_email`, `referral_commission`, `referral_commission1`, `referral_commission2`, `referral_commission3`, `referral_commission4`, `referral_commission5`, `signup_bonus`, `files_key`, `tawk_to`, `enable_2fa`, `enable_kyc`, `enable_with`, `enable_verification`, `withdrawal_option`, `dashboard_option`, `site_preference`, `enable_annoc`, `commission_type`, `commission_fee`, `monthlyfee`, `quarterlyfee`, `yearlyfee`, `newupdate`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'Universal Crypto Mining', 'We are online Universal Crypto Mining', '$', 'USD', 'International BNK', 'Admin account c', '99388383', 'sdjkbhfff', 'bc1qk8akz9kpjejk7yslgq3k2234026puu9x5musm2', 'gckycluycluycluylutyutckutcxk11', '2', 'Email', 'sk_test_4eC39HqLyjWDarjtT1zdp7dc', 'pk_test_TYooMQauvdEDq54NiTphI7jx', 'jijdjkdkdk', 'iidjdjdj', 'online trade, forex, cfd,', 'Welcome to Universal Crypto Mining', 'https://coin.universalcryptomining.com/', 'EBXjzfbtc.png1635313055', 'EBXjzfbtc.png1635313055', 'on', 'on', 'true', 'osemwengiekennedy@gmail.com', '40', '30', '20', '10', '5', '1', '0', 'OT_viXHf', 'tawk to code', 'no', 'no', 'false', 'false', 'manual', 'dark', 'Web dashboard only', 'on', NULL, NULL, '5', '10', '15', 'Welcome to Universal Crypto Mining, Your Login was Successful.', NULL, NULL, '2021-10-28 01:46:09');

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

--
-- Table structure for table `testimonies`
--

CREATE TABLE `testimonies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ref_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `what_is_said` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonies`
--

INSERT INTO `testimonies` (`id`, `ref_key`, `position`, `name`, `what_is_said`, `picture`, `created_at`, `updated_at`) VALUES
(2, 'mZVhqO', 'Principal', 'Sarah Ona', 'I love this platform, they are real and trust worthy', 'upload-testimonial-1.jpg1617292794', '2021-04-01 15:00:56', '2021-10-27 09:41:20');

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

--
-- Table structure for table `tp__transactions`
--

CREATE TABLE `tp__transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `plan` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user` int(11) DEFAULT NULL,
  `amount` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tp__transactions`
--

INSERT INTO `tp__transactions` (`id`, `plan`, `user`, `amount`, `type`, `created_at`, `updated_at`) VALUES
(1, 'Starter', 9, '50', 'Plan purchase', '2021-03-11 11:29:46', '2021-03-11 11:29:46'),
(2, 'Credit', 13, '100', 'Deposit', '2021-03-11 13:53:32', '2021-03-11 13:53:32'),
(3, 'Credit', 9, '10', 'Deposit', '2021-03-11 13:53:57', '2021-03-11 13:53:57'),
(4, 'Credit', 9, '10', 'Ref_Bonus', '2021-03-11 13:55:43', '2021-03-11 13:55:43'),
(5, 'Starter', 9, '20', 'ROI', '2021-03-11 14:03:06', '2021-03-11 14:03:06'),
(6, 'Credit', 9, '50', 'Deposit', '2021-03-12 13:34:08', '2021-03-12 13:34:08'),
(7, 'Credit', 18, '100', 'Deposit', '2021-03-19 12:58:10', '2021-03-19 12:58:10'),
(8, 'Credit', 19, '100', 'Deposit', '2021-03-22 09:33:39', '2021-03-22 09:33:39'),
(9, 'Starter', 19, '50', 'Plan purchase', '2021-03-22 09:34:27', '2021-03-22 09:34:27'),
(10, 'Credit', 23, '300', 'Deposit', '2021-10-27 15:48:58', '2021-10-27 15:48:58'),
(11, 'Credit reversal', 23, '100', 'Bonus', '2021-10-27 15:49:23', '2021-10-27 15:49:23'),
(12, 'Credit', 23, '500', 'Bonus', '2021-10-27 15:52:10', '2021-10-27 15:52:10'),
(13, 'Credit reversal', 26, '10000', 'Deposit', '2021-10-27 17:25:21', '2021-10-27 17:25:21'),
(14, 'Credit reversal', 26, '10000', 'Profit', '2021-10-27 17:34:31', '2021-10-27 17:34:31'),
(15, 'Credit reversal', 26, '10000', 'Deposit', '2021-10-27 17:35:36', '2021-10-27 17:35:36'),
(16, 'Starter', 26, '10000', 'Bonus', '2021-10-27 17:41:06', '2021-10-27 17:41:06'),
(17, 'Credit', 26, '100', 'Deposit', '2021-10-27 17:44:25', '2021-10-27 17:44:25'),
(18, 'Credit', 26, '1000', 'Deposit', '2021-10-27 17:46:01', '2021-10-27 17:46:01'),
(19, 'Starter', 26, '200', 'Plan purchase', '2021-10-27 17:47:01', '2021-10-27 17:47:01'),
(20, 'Standard', 26, '600', 'Plan purchase', '2021-10-27 17:47:24', '2021-10-27 17:47:24'),
(21, 'Credit', 29, '2000', 'Profit', '2021-10-28 01:42:53', '2021-10-28 01:42:53'),
(22, 'Credit', 34, '1', 'Bonus', '2021-11-04 19:16:23', '2021-11-04 19:16:23'),
(23, 'Starter', 35, '200', 'Plan purchase', '2021-11-05 13:53:35', '2021-11-05 13:53:35'),
(24, 'Credit', 35, '100', 'Profit', '2021-11-05 13:54:50', '2021-11-05 13:54:50');

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

--
-- Table structure for table `upgrades`
--

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

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

--
-- Table structure for table `userlogs`
--

CREATE TABLE `userlogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user` int(11) DEFAULT NULL,
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `two_factor_secret` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `two_factor_recovery_codes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dashboard_style` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'dark',
  `bank_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acnt_type_active` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `btc_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eth_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ltc_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_plan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_bal` int(11) NOT NULL DEFAULT 0,
  `roi` int(11) NOT NULL DEFAULT 0,
  `bonus` int(11) NOT NULL DEFAULT 0,
  `ref_bonus` int(11) NOT NULL DEFAULT 0,
  `signup_bonus` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `auto_trade` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bonus_released` int(11) NOT NULL DEFAULT 0,
  `ref_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ref_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_card` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `passport` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_verify` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entered_at` datetime DEFAULT NULL,
  `activated_at` datetime DEFAULT NULL,
  `last_growth` datetime DEFAULT NULL,
  `status` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT 'active',
  `trade_mode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `act_session` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_team_id` bigint(20) UNSIGNED DEFAULT NULL,
  `profile_photo_path` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `two_factor_secret`, `two_factor_recovery_codes`, `dob`, `address`, `country`, `phone`, `dashboard_style`, `bank_name`, `account_name`, `account_number`, `acnt_type_active`, `btc_address`, `eth_address`, `ltc_address`, `plan`, `user_plan`, `account_bal`, `roi`, `bonus`, `ref_bonus`, `signup_bonus`, `auto_trade`, `bonus_released`, `ref_by`, `ref_link`, `id_card`, `passport`, `account_verify`, `entered_at`, `activated_at`, `last_growth`, `status`, `trade_mode`, `act_session`, `remember_token`, `current_team_id`, `profile_photo_path`, `created_at`, `updated_at`) VALUES
(19, 'Test User', 'test1234@happ.com', '2021-03-19 13:11:26', '$2y$10$0IGp/nq4pK.IrYc4KjID1uWyNUqGKKmlc6c7ScUy7a08eMYWHoPyS', NULL, NULL, '1998-06-18', 'Midreds', 'Nigeria', '8377373', 'dark', NULL, NULL, NULL, NULL, 'jhjdhhdhdhhdhd', NULL, NULL, '1', '2', 300, 0, 0, 0, 'received', NULL, 0, NULL, 'http://127.0.0.1:8000//ref/19', 'upload-2.jpg1617297783', 'upload-4.jpg1617297783', 'Under review', '2021-03-22 10:34:28', NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, '2021-03-19 13:10:29', '2021-04-02 22:53:09'),
(23, 'osemwengie kennedy', 'osemwengiekennedy@gmail.com', '2021-10-27 12:59:05', '$2y$10$HzrMjuIEx8Kc/x5lDmiKZ.MlN4rxI/isiB1TgkRMXVBWul2kQ9lda', NULL, NULL, NULL, NULL, 'Nigeria', '08055844233', 'dark', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1200, 0, 400, 0, 'received', NULL, 0, NULL, 'https://coin.universalcryptomining.com//ref/23', NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, '2021-10-27 12:58:25', '2021-10-27 15:52:10'),
(24, 'Faith Awolu', 'hillsofts@gmail.com', '2021-10-27 13:20:47', '$2y$10$900OayyBp2RSX2SlwvHH2usRtDe3tflBgt.CjKMwFLNj/mkdp18fi', NULL, NULL, NULL, NULL, 'Argentina', '+2348138652645', 'dark', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'received', NULL, 0, NULL, 'https://coin.universalcryptomining.com//ref/24', NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, '2021-10-27 13:20:03', '2021-10-27 13:20:47'),
(25, 'adam walter', 'webslotlimited@gmail.com', '2021-10-27 16:00:37', '$2y$10$vWtjXC3Oqd/c/YsfRoFZ/.HLFvYPxY8jb/HcKY..iqG3Kgux9bRUa', NULL, NULL, NULL, NULL, 'Nigeria', '08055844233', 'dark', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'received', NULL, 0, NULL, 'https://coin.universalcryptomining.com//ref/25', NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, '2021-10-27 15:58:25', '2021-10-27 16:00:38'),
(26, 'TUMWEBAZE ALEX', 'birungisafrah@gmail.com', '2021-10-27 17:17:56', '$2y$10$kZQDjj6cSgeHeY5rOfexlurDSxCKFeM9J4NA4KjTyUYCzE8urGEzO', NULL, NULL, NULL, NULL, 'Uganda', '0752195288', 'dark', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', '2', 410, 0, 0, 0, 'received', NULL, 0, NULL, 'https://coin.universalcryptomining.com//ref/26', NULL, NULL, NULL, '2021-10-27 13:47:24', NULL, NULL, 'active', 'on', NULL, NULL, NULL, NULL, '2021-10-27 17:14:48', '2021-10-28 01:14:20'),
(27, 'Nomal', 'chunglee34533@gmail.com', '2021-10-27 19:27:30', '$2y$10$0Ub6oXQQ1V9nmEujxBy1feKSBEl4Vjfss/.XDXccw8KkxmWGhaYsW', NULL, NULL, NULL, NULL, 'United States of America', '+17867663449', 'dark', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'received', NULL, 0, NULL, 'https://coin.universalcryptomining.com//ref/27', NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, '2021-10-27 19:26:55', '2021-10-27 19:27:30'),
(28, 'UPTON Jay', 'hampsonsara96@gmail.com', '2021-10-27 22:11:53', '$2y$10$puY.T6sok2it.SHZfJrKa.n3SBtoL5rzcgKvys2kjpcMWGVl0r5Da', NULL, NULL, NULL, NULL, 'United States of America', '7792580182', 'dark', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'received', NULL, 0, NULL, 'https://coin.universalcryptomining.com//ref/28', NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, '2021-10-27 22:09:30', '2021-10-27 22:12:02'),
(29, 'Jerry', 'jerrydc631@gmail.com', '2021-10-28 01:21:38', '$2y$10$yoosKdP8uD.mjRPdqdCs0e65W5YcoeOhdyUElWFbtAM49yKU5HQvy', NULL, NULL, NULL, NULL, 'Nigeria', '08162475755', 'dark', 'Uba', 'Jerrydc', '089627297282', NULL, 'You yhu jhhjjji', NULL, NULL, NULL, NULL, 500, 2000, 0, 0, 'received', NULL, 0, NULL, 'https://coin.universalcryptomining.com//ref/29', NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, '2021-10-28 01:20:12', '2021-10-28 01:54:58'),
(30, 'Max emm', 'maxemm6@gmail.com', '2021-10-28 10:50:06', '$2y$10$HXh5nLk/5WKTTPozRgCUe.dofw89sOkV4ddluuW7Wjr7VYbvaLqYu', NULL, NULL, NULL, NULL, 'Nigeria', '08158086285', 'dark', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1000, 0, 0, 0, 'received', NULL, 0, NULL, 'https://coin.universalcryptomining.com//ref/30', NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, '2021-10-28 10:44:13', '2021-10-28 10:58:12'),
(31, 'John sean', 'zhangwang7672@gmail.com', '2021-10-28 15:33:14', '$2y$10$KZjXAOel9voJoHxR.4Y0pe3hCPN1/X41uzOssO5VYtgf6Aus2P5x2', NULL, NULL, NULL, NULL, 'United States of America', '+1213657989', 'dark', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1000, 0, 0, 0, 'received', NULL, 0, NULL, 'https://coin.universalcryptomining.com//ref/31', NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, '2021-10-28 15:32:28', '2021-10-28 15:36:08'),
(32, 'skaff 2020', 'skaff2020@gmail.com', '2021-10-29 19:09:22', '$2y$10$CUvIx/wAkZFCydlajM9DFu6UuaUxt2/9yOxZOIxdzuO6dL3eKsNmy', NULL, NULL, NULL, NULL, 'United States of America', '+13322448868', 'dark', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'received', NULL, 0, NULL, 'https://coin.universalcryptomining.com//ref/32', NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, '2021-10-29 19:07:02', '2021-10-29 19:09:23'),
(33, 'Burteley', 'burtelelaurence@gmail.com', NULL, '$2y$10$2uFCIkPEWA9k42ttf1JMk.QEcbXHOsozt2c.gvpv6/SUJ2..3AfYe', NULL, NULL, NULL, NULL, 'Nigeria', '08159039671', 'dark', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL, NULL, 0, NULL, 'https://coin.universalcryptomining.com//ref/33', NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, '2021-10-30 01:42:31', '2021-11-01 11:46:55'),
(34, 'Marvellous obazuaye', 'marvellousobazuaye@gmail.com', '2021-11-02 22:56:05', '$2y$10$aESwB/k9ujAfpwzz8iAwO.HJQgNddm5Mt9ToOzKtHC8O534FeDp/C', NULL, NULL, NULL, NULL, 'Nigeria', '07049937414', 'dark', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 0, 'received', NULL, 0, NULL, 'https://coin.universalcryptomining.com//ref/34', NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, '2021-11-02 22:55:40', '2021-11-04 19:16:23'),
(35, 'EIGBEFO Gift', 'eigbefoi@gmail.com', '2021-11-05 13:50:17', '$2y$10$wewmQJVNo5fbuQMxxnaxj.6/suIhE8Fc8dT2rF7IPVpmVVN.OhhtS', NULL, NULL, NULL, NULL, 'Nigeria', '+2347032209808', 'dark', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '3', 400, 100, 0, 0, 'received', NULL, 0, NULL, 'https://coin.universalcryptomining.com//ref/35', NULL, NULL, NULL, '2021-11-05 09:53:35', NULL, NULL, 'active', 'on', NULL, NULL, NULL, NULL, '2021-11-05 13:49:12', '2021-11-05 14:33:49'),
(36, 'EIGBEFO Gift', 'gtbrave1@gmail.com', '2021-11-05 14:40:31', '$2y$10$GOWDvXtBjYJdHfXdd3BVguMYhXWoXkIRIoxtNyEXKfIYMFpYYX9.C', NULL, NULL, NULL, NULL, 'Nigeria', '07032209808', 'dark', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'received', NULL, 0, NULL, 'https://coin.universalcryptomining.com//ref/36', NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, '2021-11-05 14:40:09', '2021-11-05 14:40:32'),
(37, 'Ikponmwosa', 'iktg200@gmail.com', '2021-11-07 17:15:08', '$2y$10$D.wJvWouZ.SDAq3bC6fsKegOzZDLVj9ixQlFzq3UAbX4n3lFsV.H.', NULL, NULL, NULL, NULL, 'Nigeria', '07030291461', 'dark', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'received', NULL, 0, NULL, 'https://coin.universalcryptomining.com//ref/37', NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, '2021-11-07 17:13:40', '2021-11-07 17:15:08'),
(38, 'Osamu', 'erhaghewuosamu@gmail.com', '2021-11-08 03:09:11', '$2y$10$KaAQ3rEm2ty7yo.9Uyz6quoSXmCTkWD0cegUAfWUZK4G22w4EMbKC', NULL, NULL, NULL, NULL, 'United States of America', '00901736372', 'dark', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'received', NULL, 0, NULL, 'https://coin.universalcryptomining.com//ref/38', NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, '2021-11-08 02:52:29', '2021-11-08 03:09:11'),
(39, 'Osamu', 'erhaghewuosa@gmail.com', NULL, '$2y$10$RbmpEbNlbfBXh5/aBa5XY.FPzYzBSYSoGs8EKksTr8thax4LnAW/q', NULL, NULL, NULL, NULL, 'United States of America', '08133307374', 'dark', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 'received', NULL, 0, NULL, 'https://coin.universalcryptomining.com//ref/39', NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, NULL, NULL, NULL, NULL, '2021-11-08 02:59:00', '2021-11-08 03:02:27');

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

--
-- Table structure for table `user_plans`
--

CREATE TABLE `user_plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `plan` int(11) DEFAULT NULL,
  `user` int(11) DEFAULT NULL,
  `amount` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inv_duration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expire_date` datetime DEFAULT NULL,
  `activated_at` datetime DEFAULT NULL,
  `last_growth` 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 `user_plans`
--

INSERT INTO `user_plans` (`id`, `plan`, `user`, `amount`, `active`, `inv_duration`, `expire_date`, `activated_at`, `last_growth`, `created_at`, `updated_at`) VALUES
(1, 1, 26, '200', 'yes', 'One week', NULL, '2021-10-27 13:47:01', '2021-10-27 13:47:01', '2021-10-27 17:47:01', '2021-10-27 17:47:01'),
(2, 2, 26, '600', 'yes', 'One week', NULL, '2021-10-27 13:47:24', '2021-10-27 13:47:24', '2021-10-27 17:47:24', '2021-10-27 17:47:24'),
(3, 1, 35, '200', 'yes', 'One week', NULL, '2021-11-05 09:53:35', '2021-11-05 09:53:35', '2021-11-05 13:53:35', '2021-11-05 13:53:35');

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

--
-- Table structure for table `wdmethods`
--

CREATE TABLE `wdmethods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `minimum` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `maximum` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `charges_fixed` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `charges_percentage` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wdmethods`
--

INSERT INTO `wdmethods` (`id`, `name`, `minimum`, `maximum`, `charges_fixed`, `charges_percentage`, `duration`, `type`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Bitcoin', '50', '10000', '0', '2', 'Instant', 'withdrawal', 'enabled', '2021-03-11 11:53:32', '2021-10-27 13:19:24'),
(2, 'Ethereum', '10', '2100', '0', '0', 'Instant', 'withdrawal', 'enabled', '2021-03-22 10:36:03', '2021-03-22 10:36:03'),
(3, 'Litecoin', '100', '10000', '0', '0', 'Instant', 'withdrawal', 'enabled', '2021-03-22 10:36:33', '2021-03-22 10:36:33'),
(4, 'Bank transfer', '10', '2100', '0', '0', 'Instant', 'withdrawal', 'enabled', '2021-03-22 10:37:08', '2021-03-22 10:37:08');

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

--
-- Table structure for table `withdrawals`
--

CREATE TABLE `withdrawals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `txn_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user` int(11) DEFAULT NULL,
  `uname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_deduct` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_mode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `withdrawals`
--

INSERT INTO `withdrawals` (`id`, `txn_id`, `user`, `uname`, `amount`, `to_deduct`, `status`, `payment_mode`, `created_at`, `updated_at`) VALUES
(1, NULL, 29, NULL, '500', '500', 'Pending', 'Bank transfer', '2021-10-28 01:54:06', '2021-10-28 01:54:06'),
(2, NULL, 29, NULL, '1500', '1500', 'Processed', 'Bank transfer', '2021-10-28 01:55:03', '2021-10-28 01:55:35');

--
-- Indexes for dumped tables
--

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

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

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

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

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

--
-- Indexes for table `deposits`
--
ALTER TABLE `deposits`
  ADD PRIMARY KEY (`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 `faqs`
--
ALTER TABLE `faqs`
  ADD PRIMARY KEY (`id`);

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

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

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

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

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

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

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for table `contents`
--
ALTER TABLE `contents`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

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

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

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

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

--
-- AUTO_INCREMENT for table `images`
--
ALTER TABLE `images`
  MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `userlogs`
--
ALTER TABLE `userlogs`
  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=40;

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

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

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
