PNG  IHDR pHYs   OiCCPPhotoshop ICC profilexڝSgTS=BKKoR RB&*! J!QEEȠQ, !{kּ> H3Q5 B.@ $pd!s#~<<+"x M0B\t8K@zB@F&S`cbP-`'{[! eDh;VEX0fK9-0IWfH  0Q){`##xFW<+*x<$9E[-qWW.(I+6aa@.y24x6_-"bbϫp@t~,/;m%h^ uf@Wp~<5j>{-]cK'Xto(hw?G%fIq^D$.Tʳ?D*A, `6B$BB dr`)B(Ͱ*`/@4Qhp.U=pa( Aa!ڈbX#!H$ ɈQ"K5H1RT UH=r9\F;2G1Q= C7F dt1r=6Ыhڏ>C03l0.B8, c˱" VcϱwE 6wB aAHXLXNH $4 7 Q'"K&b21XH,#/{C7$C2'ITFnR#,4H#dk9, +ȅ3![ b@qS(RjJ4e2AURݨT5ZBRQ4u9̓IKhhitݕNWGw Ljg(gwLӋT071oUX**| J&*/Tު UUT^S}FU3S ԖUPSSg;goT?~YYLOCQ_ cx,!k u5&|v*=9C3J3WRf?qtN (~))4L1e\kXHQG6EYAJ'\'GgSSݧ M=:.kDwn^Loy}/TmG X $ <5qo</QC]@Caaᄑ.ȽJtq]zۯ6iܟ4)Y3sCQ? 0k߬~OCOg#/c/Wװwa>>r><72Y_7ȷOo_C#dz%gA[z|!?:eAAA!h쐭!ΑiP~aa~ 'W?pX15wCsDDDޛg1O9-J5*>.j<74?.fYXXIlK9.*6nl {/]py.,:@LN8A*%w% yg"/6шC\*NH*Mz쑼5y$3,幄'L Lݛ:v m2=:1qB!Mggfvˬen/kY- BTZ(*geWf͉9+̳ې7ᒶKW-X潬j9(xoʿܔĹdff-[n ڴ VE/(ۻCɾUUMfeI?m]Nmq#׹=TR+Gw- 6 U#pDy  :v{vg/jBFS[b[O>zG499?rCd&ˮ/~јѡ򗓿m|x31^VwwO| (hSЧc3- cHRMz%u0`:o_F@8N ' p @8N@8}' p '#@8N@8N pQ9p!i~}|6-ӪG` VP.@*j>[ K^<֐Z]@8N'KQ<Q(`s" 'hgpKB`R@Dqj '  'P$a ( `D$Na L?u80e J,K˷NI'0eݷ(NI'؀ 2ipIIKp`:O'`ʤxB8Ѥx Ѥx $ $P6 :vRNb 'p,>NB 'P]-->P T+*^h& p '‰a ‰ (ĵt#u33;Nt̵'ޯ; [3W ~]0KH1q@8]O2]3*̧7# *p>us p _6]/}-4|t'|Smx= DoʾM×M_8!)6lq':l7!|4} '\ne t!=hnLn (~Dn\+‰_4k)0e@OhZ`F `.m1} 'vp{F`ON7Srx 'D˸nV`><;yMx!IS钦OM)Ե٥x 'DSD6bS8!" ODz#R >S8!7ّxEh0m$MIPHi$IvS8IN$I p$O8I,sk&I)$IN$Hi$I^Ah.p$MIN$IR8I·N "IF9Ah0m$MIN$IR8IN$I 3jIU;kO$ɳN$+ q.x* tEXtComment

Viewing File: /home/u403625155/domains/crownstonemarkets.com/public_html/axostone_db.sql

-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jan 30, 2023 at 09:42 PM
-- Server version: 5.7.40-cll-lve
-- PHP Version: 7.4.33

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: `axostone_db`
--

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

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

CREATE TABLE `accounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `balance` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `profit` int(11) NOT NULL DEFAULT '0',
  `active` varchar(224) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `amount` double NOT NULL DEFAULT '0',
  `deposit_amount` int(11) DEFAULT NULL,
  `plan` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '2',
  `status` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration` text COLLATE utf8mb4_unicode_ci,
  `wallet` text COLLATE utf8mb4_unicode_ci,
  `created_at` text COLLATE utf8mb4_unicode_ci,
  `updated_at` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`id`, `user_id`, `balance`, `profit`, `active`, `amount`, `deposit_amount`, `plan`, `status`, `duration`, `wallet`, `created_at`, `updated_at`) VALUES
(103, 121, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-November-17th', NULL),
(105, 123, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-November-17th', NULL),
(107, 125, '1675', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-November-17th', NULL),
(110, 128, '0', 0, 'yes', 0, NULL, '1', NULL, NULL, NULL, '2022-November-17th', NULL),
(112, 130, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-November-19th', NULL),
(113, 131, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-November-22nd', NULL),
(114, 132, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-November-22nd', NULL),
(118, 136, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-November-22nd', NULL),
(121, 139, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-November-27th', NULL),
(125, 143, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-November-29th', NULL),
(127, 145, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-December-12th', NULL),
(128, 146, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-December-14th', NULL),
(136, 154, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-December-19th', NULL),
(137, 155, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-December-19th', NULL),
(138, 156, '50', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-December-19th', NULL),
(139, 157, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-December-20th', NULL),
(141, 159, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-December-21st', NULL),
(144, 162, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-December-27th', NULL),
(148, 166, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2022-December-30th', NULL),
(149, 167, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-3rd', NULL),
(151, 169, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-6th', NULL),
(152, 170, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-8th', NULL),
(153, 171, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-8th', NULL),
(154, 172, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-10th', NULL),
(155, 173, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-11th', NULL),
(156, 174, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-11th', NULL),
(157, 175, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-12th', NULL),
(158, 176, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-14th', NULL),
(159, 177, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-15th', NULL),
(160, 178, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-16th', NULL),
(162, 180, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-17th', NULL),
(164, 182, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-18th', NULL),
(165, 183, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-21st', NULL),
(166, 184, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-23rd', NULL),
(168, 186, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-28th', NULL),
(171, 189, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-29th', NULL),
(172, 190, '0', 0, 'no', 0, NULL, '2', NULL, NULL, NULL, '2023-January-30th', NULL);

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

--
-- Table structure for table `bank_transfer`
--

CREATE TABLE `bank_transfer` (
  `id` int(11) NOT NULL,
  `bank_name` varchar(45) DEFAULT NULL,
  `bank_details` text,
  `account_details` text,
  `active` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bank_transfer`
--

INSERT INTO `bank_transfer` (`id`, `bank_name`, `bank_details`, `account_details`, `active`) VALUES
(1, 'WELLSFARGO', '<p><br></p><p>063107513</p>', '<p><br></p><p>1495362194</p>', 'No');

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

--
-- Table structure for table `bos`
--

CREATE TABLE `bos` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `rate` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `bots`
--

CREATE TABLE `bots` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `rate` int(11) NOT NULL,
  `price` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bots`
--

INSERT INTO `bots` (`id`, `name`, `rate`, `price`) VALUES
(1, 'Apexbot', 10, '4000'),
(2, 'Gunbot', 25, '14000'),
(3, 'zenbot', 50, '35000');

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

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

CREATE TABLE `email_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `greeting` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `group` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `recipient` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `addresses` text COLLATE utf8mb4_unicode_ci,
  `params` text COLLATE utf8mb4_unicode_ci,
  `shortcut` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `email_templates` (`id`, `name`, `slug`, `subject`, `greeting`, `content`, `group`, `recipient`, `addresses`, `params`, `shortcut`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Investment Order Placed', 'investment-placed-customer', 'Invest on [[plan_name]] ([[order_id]])', 'Hello [[user_name]],', 'Thank you! You have invested the amount of [[invest_amount]] on \'[[plan_name]]\'. Your investment details are shown below for your reference:\n[[invest_details]] \n\nYour investment plan will start as soon as we have review and confirmed. \n\nFeel free to contact us if you have any questions.', 'investments', 'customer', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_time]], [[plan_name]], [[invest_amount]], [[invest_details]]', 'active', '2021-07-24 21:06:50', '2021-07-24 21:06:50'),
(2, 'Investment Order Placed', 'investment-placed-admin', 'Investment Plan ([[order_id]]) Purchased', 'Hello Admin,', 'A new investment plan purchased by [[order_by]]. The investment details as follows: \n[[invest_details]] \n\nCustomer Details:\n[[user_detail]] \n\nThis is an automatic email confirmation, please check full order details in dashboard.\n\nThank You.', 'investments', 'admin', NULL, '{\"regards\":\"off\"}', '[[user_detail]], [[order_id]], [[order_by]], [[plan_name]], [[order_time]], [[invest_amount]], [[invest_details]]', 'active', '2021-07-24 21:06:50', '2021-07-24 21:06:50'),
(3, 'Investment Order Approved', 'investment-approved-customer', 'Investment plan ([[order_id]]) just started!', 'Dear [[user_name]],', 'Congratulations! Your investment plan ([[order_id]]) approved and successfully started. \nYour investment details are shown below for your reference:\n[[invest_details]]\n\nIf you have any question, you can contact us at [[site_email]].', 'investments', 'customer', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_time]], [[plan_name]], [[invest_amount]], [[invest_details]]', 'active', '2021-07-24 21:06:50', '2021-07-24 21:06:50'),
(4, 'Investment Order Approved', 'investment-approved-admin', 'Investment plan ([[order_id]]) just started!', 'Dear Admin,', 'The investment order ([[order_id]]) has been approved and started. The investment details as follows: \n[[invest_details]] \n\nPS. Do not reply to this email.\nThank you.', 'investments', 'admin', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_time]], [[plan_name]], [[invest_amount]], [[invest_details]]', 'inactive', '2021-07-24 21:06:50', '2021-07-24 21:06:50'),
(5, 'Investment Cancelled by User', 'investment-cancel-user-customer', 'Investment plan ([[order_id]]) has been cancelled!', 'Dear [[user_name]],', 'You have cancelled your investment plan ([[order_id]]). The amount returned to your account balance. \n\nIf you want to invest again, please feel free to login into your account and choose a plan once again.\n\n\nIf you have any question, you can contact us at [[site_email]].', 'investments', 'customer', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_time]], [[plan_name]], [[invest_amount]], [[invest_details]]', 'active', '2021-07-24 21:06:50', '2021-07-24 21:06:50'),
(6, 'Investment Cancelled by User', 'investment-cancel-user-admin', 'Investment plan ([[order_id]]) successfully cancelled!', 'Dear Admin,', 'The recent investment plan ([[order_id]]) has been cancelled by [[order_by]]. The invested amount returned to user\'s account balance. \n\n\nThis is an automatic email confirmation, no further action is needed.\n\nPS. Do not reply to this email.\nThank you.', 'investments', 'admin', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_time]], [[plan_name]], [[invest_amount]], [[invest_details]]', 'active', '2021-07-24 21:06:50', '2021-07-24 21:06:50'),
(7, 'Investment Cancelled by Admin', 'investment-cancel-customer', 'Investment plan ([[order_id]]) has been cancelled!', 'Dear [[user_name]],', 'Your recent investment plan ([[order_id]]) has been cancelled. The invested amount returned to your account balance. \n\nIf you want to invest again, please feel free to login into your account and choose a plan once again.\n\n\nIf you have any question, you can contact us at [[site_email]].', 'investments', 'customer', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_time]], [[plan_name]], [[invest_amount]], [[invest_details]]', 'inactive', '2021-07-24 21:06:50', '2021-07-24 21:06:50'),
(8, 'Investment Cancelled by Admin', 'investment-cancel-admin', 'Investment plan ([[order_id]]) successfully cancelled!', 'Dear Admin,', 'The investment order ([[order_id]]) has been cancelled. The invested amount returned to user\'s account balance. \n\nPS. Do not reply to this email.\nThank you.', 'investments', 'admin', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_time]], [[plan_name]], [[invest_amount]], [[invest_details]]', 'inactive', '2021-07-24 21:06:50', '2021-07-24 21:06:50'),
(9, 'Investment Cancellation by Admin', 'investment-cancellation-customer', 'Investment Cancellation ([[order_id]])', 'Dear [[user_name]],', 'We are sorry to inform you that we\'ve cancelled your investment plan of ([[plan_name]]). We have settlement your investment account balance. Please login into your account and check your account balance.\n\n\nIf you have any question about cancellation, please feel free to contact us.\n\nPS. Do not reply to this email.\nThank you.', 'investments', 'customer', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_time]], [[plan_name]], [[invest_amount]], [[invest_details]]', 'active', '2021-07-24 21:06:50', '2021-07-24 21:06:50'),
(10, 'Investment Cancellation by Admin', 'investment-cancellation-admin', 'Investment Cancellation ([[order_id]])', 'Dear [[user_name]],', 'The investment plan of ([[plan_name]] - [[order_id]]) has been cancelled. User account balance adjusted with invested amount.\n\nPS. Do not reply to this email.\nThank you.', 'investments', 'admin', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_time]], [[plan_name]], [[invest_amount]], [[invest_details]]', 'inactive', '2021-07-24 21:06:51', '2021-07-24 21:06:51'),
(11, 'Email Confirmation', 'users-confirm-email', 'Verify Your Email Address - [[site_name]]', 'Welcome [[user_name]]!', 'Thank you for registering on our platform. You\'re almost ready to start.\n\nSimply click the button below to confirm your email address and active your account.', 'authentication', 'customer', NULL, '{\"regards\":\"on\"}', '', 'active', '2021-07-24 21:06:51', '2021-07-24 21:06:51'),
(12, 'Welcome Email', 'users-welcome-email', 'Welcome to [[site_name]]', 'Hi [[user_name]],', 'Thanks for joining our platform! \n\nAs a member of our platform, you can mange your account, buy or sell cryptocurrency. \n\nFind out more about in - [[site_url]]', 'authentication', 'customer', NULL, '{\"regards\":\"on\"}', '', 'active', '2021-07-24 21:06:51', '2021-07-24 21:06:51'),
(13, 'Password Reset by User', 'users-reset-password', 'Password Reset Request on [[site_name]]', 'Hi [[user_name]],', '<strong>You told us you forgot your password.</strong> \n\nIf you really forgot, click the below button to reset your password. \n\nIf you did not make reset request, then you can just ignore this email; your password will not change.', 'authentication', 'customer', NULL, '{\"regards\":\"on\"}', '', 'active', '2021-07-24 21:06:51', '2021-07-24 21:06:51'),
(14, 'Password Changed Successfully', 'users-change-password-success', 'Your Password Has Been Changed', 'Hi [[user_name]],', 'This email is to confirm that your account password has been successfully changed. If you did not request a password change, please contact us immediately.', 'authentication', 'customer', NULL, '{\"regards\":\"on\"}', '', 'active', '2021-07-24 21:06:51', '2021-07-24 21:06:51'),
(15, 'Email Changed by User', 'users-change-email', 'Verify Your New Email Address - [[site_name]]', 'Hi [[user_name]],', '<strong>There was a request to change your email address.</strong> \n\nIf you really want to change your email, simply click the button below to confirm your new email address. \n\nIf you did not make this change, then you can just ignore this email; your email will not change.', 'authentication', 'customer', NULL, '{\"regards\":\"on\"}', '', 'active', '2021-07-24 21:06:51', '2021-07-24 21:06:51'),
(16, 'Email Changed Successfully', 'users-change-email-success', 'Email Address Has Been Changed', 'Hi [[user_name]],', 'This email is to confirm that your account email address has been successfully changed. Now you can login at [[site_url]] with your new email address. If you did not make this change, please contact us immediately.', 'authentication', 'customer', NULL, '{\"regards\":\"on\"}', '', 'active', '2021-07-24 21:06:51', '2021-07-24 21:06:51'),
(17, 'Unusual Login Email', 'users-unusual-login', 'Unusual Login Attempt on [[site_name]]', 'Hi [[user_name]],', 'We noticed you\'re having trouble logging into your account. There was few unsuccessful login attempt on your account. If this wasn\'t you, let us know.', 'authentication', 'customer', NULL, '{\"regards\":\"on\"}', '', 'active', '2021-07-24 21:06:51', '2021-07-24 21:06:51'),
(18, 'Password Reset by Admin', 'users-admin-reset-password', 'Your Password is reseted on [[site_name]]', 'Hi [[user_name]],', 'We have reset your login password as per your requested via support. Now you can login at [[site_url]] with new password as below.', 'authentication', 'customer', NULL, '{\"regards\":\"on\"}', '', 'active', '2021-07-24 21:06:51', '2021-07-24 21:06:51'),
(19, 'Welcome Email', 'user-registration-admin', 'Welcome to [[site_name]]', 'Hi [[user_name]],', 'You are receiving this email because you have registered on our site.', 'authentication', 'customer', NULL, '{\"regards\":\"on\"}', '', 'active', '2021-07-24 21:06:51', '2021-07-24 21:06:51'),
(20, 'Deposit Order Placed', 'deposit-placed-customer', 'New Deposit #[[order_id]]', 'Hello [[user_name]],', 'Your deposit order has been placed and is now being waiting for payment. Your deposit details are shown below for your reference:\n[[order_details]]\n[[payment_information]]\n\nYour funds will add into your account as soon as we have confirmed the payment. \n\nFeel free to contact us if you have any questions.', 'deposits', 'customer', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[order_details]], [[payment_method]], [[payment_information]]', 'active', '2021-07-24 21:06:51', '2021-07-24 21:06:51'),
(21, 'Deposit Order Placed', 'deposit-placed-admin', 'New Deposit #[[order_id]] by [[order_by]]', 'Hello Admin,', 'You have received an deposit order from [[order_by]]. The deposit order is as follows: \n[[order_details]] \n\nCustomer Details:\n[[user_detail]] \n\nThis is an automatic email confirmation, please check full order details in dashboard.\n\nThank You.', 'deposits', 'admin', NULL, '{\"regards\":\"off\"}', '[[user_detail]], [[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[order_details]], [[payment_method]]', 'active', '2021-07-24 21:06:51', '2021-07-24 21:06:51'),
(22, 'Deposit Cancelled by User', 'deposit-cancel-user-customer', 'Deposit has been cancelled!', 'Dear [[user_name]],', 'Your recent deposit (#[[order_id]]) has been cancelled. \n\nIf you want to deposit funds into your again, please feel free to login into your account and add funds once again.\n\n\nIf you have any question, you can contact us at [[site_email]].', 'deposits', 'customer', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[order_details]], [[payment_method]]', 'active', '2021-07-24 21:06:52', '2021-07-24 21:06:52'),
(23, 'Deposit Cancelled by User', 'deposit-cancel-user-admin', 'Deposit #[[order_id]] has been cancelled', 'Dear Admin,', 'The recent deposit order (#[[order_id]]) has been cancelled by [[order_by]]. \n\n\nThis is an automatic email confirmation, no need any action for further.\n\nPS. Do not reply to this email.\nThank you.', 'deposits', 'admin', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[order_details]], [[payment_method]]', 'active', '2021-07-24 21:06:52', '2021-07-24 21:06:52'),
(24, 'Deposit Cancelled by Gateway', 'deposit-cancel-gateway-customer', 'Payment Rejected - Deposit #[[order_id]]', 'Dear [[user_name]],', 'The deposit (#[[order_id]]) has been canceled, however the payment was not successful and [[payment_method]] rejected or cancelled the payment.\n\n\nIf you have any question, you can contact us at [[site_email]].\n\nPS. Do not reply to this email.\nThank you.', 'deposits', 'customer', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[order_details]], [[payment_method]]', 'active', '2021-07-24 21:06:52', '2021-07-24 21:06:52'),
(25, 'Deposit Cancelled by Gateway', 'deposit-cancel-gateway-admin', 'Deposit #[[order_id]] has been cancelled', 'Dear Admin,', 'The recent deposit order (#[[order_id]]) has been cancelled by [[payment_method]], however the payment was not made. \n\n\nThis is an automatic email confirmation, no need any action for further.\n\nPS. Do not reply to this email.\nThank you.', 'deposits', 'admin', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[order_details]], [[payment_method]]', 'active', '2021-07-24 21:06:52', '2021-07-24 21:06:52'),
(26, 'Deposit Rejected by Admin', 'deposit-reject-customer', 'Cancelled Deposit #[[order_id]]', 'Dear [[user_name]],', 'The deposit (#[[order_id]]) has been cancelled, however we have not received your payment of [[order_amount]] (via [[payment_method]]).\n\n\nIf you have any question, you can contact us at [[site_email]].\n\nPS. Do not reply to this email.\nThank you.', 'deposits', 'customer', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]] , [[order_time]], [[order_details]], [[payment_method]]', 'active', '2021-07-24 21:06:52', '2021-07-24 21:06:52'),
(27, 'Deposit Rejected by Admin', 'deposit-reject-admin', 'Deposit #[[order_id]] has been cancelled', 'Dear Admin,', 'The deposit order (#[[order_id]]) has been cancelled. \n\nPS. Do not reply to this email.\nThank you.', 'deposits', 'admin', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[order_details]], [[payment_method]]', 'inactive', '2021-07-24 21:06:52', '2021-07-24 21:06:52'),
(28, 'Deposit Order Approved', 'deposit-approved-customer', 'Deposit successfully processed!', 'Dear [[user_name]],', 'Your deposit of [[order_amount]] has been successfully approved. \nThis email confirms that funds have been added to your account.\n\nIf you have any question, you can contact us at [[site_email]].', 'deposits', 'customer', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[order_details]], [[payment_method]]', 'active', '2021-07-24 21:06:52', '2021-07-24 21:06:52'),
(29, 'Deposit Order Approved', 'deposit-approved-admin', 'Deposit Successfull - Order #[[order_id]]', 'Dear Admin,', 'The deposit order (#[[order_id]]) has been approved and funds of [[order_amount]] added into user account. \n\nPS. Do not reply to this email.\nThank you.', 'deposits', 'admin', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[order_details]], [[payment_method]]', 'inactive', '2021-07-24 21:06:52', '2021-07-24 21:06:52'),
(30, 'Deposit Success by Gateway', 'deposit-success-gateway-customer', 'Deposit successfully processed!', 'Dear [[user_name]],', 'Your deposit of [[order_amount]] has been successfully. \nThis email confirms that funds have been added to your account.\n\nIf you have any question, you can contact us at [[site_email]].', 'deposits', 'customer', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[order_details]], [[payment_method]]', 'active', '2021-07-24 21:06:52', '2021-07-24 21:06:52'),
(31, 'Deposit Success by Gateway', 'deposit-success-gateway-admin', 'Deposit Successfull - Order #[[order_id]]', 'Dear Admin,', 'You just received a payment of [[order_amount]] for deposit order (#[[order_id]]) via [[payment_method]]. \n\nPS. Do not reply to this email.\nThank you.', 'deposits', 'admin', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[order_details]], [[payment_method]]', 'active', '2021-07-24 21:06:53', '2021-07-24 21:06:53'),
(32, 'Deposit Refund by Admin', 'deposit-refund-customer', 'Your deposit (#[[order_id]]) has been refunded!', 'Hello [[user_name]],', 'We have refunded your funds and re-adjusted your account balance. Please find below your refund and original deposit details. \n\nPS. Do not reply to this email.\nThank you.', 'deposits', 'customer', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[order_details]], [[payment_method]], [[refund_details]]', 'active', '2021-07-24 21:06:53', '2021-07-24 21:06:53'),
(33, 'Deposit Refund by Admin', 'deposit-refund-admin', 'Refunded Deposit #[[order_id]]', 'Hello Admin,', 'The deposit order (#[[order_id]]) refunded successfully. The user account balance adjusted with refund amount of [[order_amount]]. \n\nPS. Do not reply to this email.\nThank you.', 'deposits', 'admin', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[order_details]], [[payment_method]], [[refund_details]]', 'inactive', '2021-07-24 21:06:53', '2021-07-24 21:06:53'),
(34, 'Withdraw Request', 'withdraw-request-customer', 'Your Withdraw Request Has Been Received', 'Hello [[user_name]],', 'We received your request to withdraw funds from [[site_name]]. The funds will be deposited in your provided account and should be processed with 24-72 hours. You will be notified by email when we have completed your withdraw.\n\nWithdrawal Details:\n[[withdraw_details]]\n\nNote: If you did not make this withdraw request, please contact us immediately before its authorized by our team.\n\nIf you have any questions, please feel free to contact us.\n', 'withdrawal', 'customer', NULL, '{\"regards\":\"on\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[payment_method]], [[withdraw_to]], [[withdraw_details]]', 'active', '2021-07-24 21:06:53', '2021-07-24 21:06:53'),
(35, 'Withdraw Request', 'withdraw-request-admin', 'Withdraw Request from [[user_name]]', 'Hello Admin,', 'A user ([[user_name]] - [[user_email]]) requested to withdraw funds. Please review the withdraw request as soon as possible.\n[[withdraw_details]]\n\nPlease login into account and take necessary steps for withdraw.\n\n\nPS. Do not reply to this email.\nThank you.\n', 'withdrawal', 'admin', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[payment_method]], [[withdraw_to]], [[withdraw_details]]', 'active', '2021-07-24 21:06:53', '2021-07-24 21:06:53'),
(36, 'Withdraw Cancel Request', 'withdraw-cancel-user-customer', 'Withdraw Has Been Cancelled!', 'Hello [[user_name]],', 'Your recent withdraw request (#[[order_id]]) has been cancelled. The funds returned to your account balance.\n\nIf you want to withdraw funds into your account again, please feel free to login into your account and withdraw once again.\n\nIf you have any questions, please feel free to contact us.\n', 'withdrawal', 'customer', NULL, '{\"regards\":\"on\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[payment_method]], [[withdraw_to]], [[withdraw_details]]', 'active', '2021-07-24 21:06:53', '2021-07-24 21:06:53'),
(37, 'Withdraw Cancel Request', 'withdraw-cancel-user-admin', 'Cancelled Withdraw Request by [[user_name]]', 'Hello Admin,', 'The recent withdraw request (#[[order_id]]) has been cancelled by user ([[user_name]] - [[user_email]]). \nYou do not need to take any further action.\n\n\nPS. Do not reply to this email.\nThank you.\n', 'withdrawal', 'admin', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[payment_method]], [[withdraw_to]], [[withdraw_details]]', 'active', '2021-07-24 21:06:53', '2021-07-24 21:06:53'),
(38, 'Withdraw Order Confirmed', 'withdraw-confirmed-customer', 'Withdrawal Successfully Confirmed!', 'Dear [[user_name]],', 'Your withdraw request of [[order_amount]] has been successfully confirmed. \nThis email confirms that your desired amount will deposited in your account ([[withdraw_to]]) within few hours.\n\nIf you have any question, you can contact us at [[site_email]].', 'withdrawal', 'customer', NULL, '{\"regards\":\"on\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[payment_method]], [[withdraw_to]], [[withdraw_details]]', 'active', '2021-07-24 21:06:54', '2021-07-24 21:06:54'),
(39, 'Withdraw Order Confirmed', 'withdraw-confirmed-admin', 'Withdraw Request #[[order_id]] Has Been Confirmed', 'Hello Admin,', 'The withdraw request (#[[order_id]]) has been confirmed and notified to user ([[user_name]] - [[user_email]]). Withdraw amount of [[order_amount]] need to be processed for this user.\n\nPS. Do not reply to this email.\nThank you.', 'withdrawal', 'admin', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[payment_method]], [[withdraw_to]], [[withdraw_details]]', 'inactive', '2021-07-24 21:06:54', '2021-07-24 21:06:54'),
(40, 'Withdraw Processed Request', 'withdraw-success-customer', 'Your Withdraw Request Has Been Completed', 'Hello [[user_name]],', '<strong>Congratulations!</strong>\n\nYour withdraw request (#[[order_id]]) has been successfully processed and a total amount of <strong>[[order_all_amount]]</strong> has been withdrawn from your account. Your funds transferred into your account as below. \n\nPayment Deposited: \n<strong>[[withdraw_to]]</strong> ([[payment_method]]).\n\nWithdraw Reference: \n[[withdraw_reference]]\n[[withdraw_note]]\n\nIf you have not received funds into your account yet, please feel free to contact us.\n', 'withdrawal', 'customer', NULL, '{\"regards\":\"on\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[payment_method]], [[withdraw_to]], [[withdraw_details]], [[withdraw_reference]], [[withdraw_note]]', 'active', '2021-07-24 21:06:54', '2021-07-24 21:06:54'),
(41, 'Withdraw Processed Request', 'withdraw-success-admin', 'Withdraw Request #[[order_id]] Has Been Processed', 'Hello Admin,', 'The withdraw request (#[[order_id]]) has been processed and notified to user ([[user_name]] - [[user_email]]). \n\nWithdraw Details:\n[[withdraw_details]] \n\nWithdraw Reference:\n[[withdraw_reference]] \n[[withdraw_note]]\n\nPS. Do not reply to this email.\nThank you.', 'withdrawal', 'admin', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[payment_method]], [[withdraw_to]], [[withdraw_details]], [[withdraw_reference]], [[withdraw_note]]', 'inactive', '2021-07-24 21:06:54', '2021-07-24 21:06:54'),
(42, 'Withdraw Rejected by Admin', 'withdraw-reject-customer', 'Withdraw Request Has Been Rejected', 'Hello [[user_name]],', 'We have received your request (#[[order_id]]) to withdraw funds. We would like to inform you that we have cancelled this request and the funds ([[order_all_amount]]) returned to your account balance.\n\nWithdraw request has been rejected for following reason -\n[[withdraw_note]]\n\nIf you have any questions, please feel free to contact us.', 'withdrawal', 'customer', NULL, '{\"regards\":\"on\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[payment_method]], [[withdraw_to]], [[withdraw_details]], [[withdraw_note]]', 'active', '2021-07-24 21:06:54', '2021-07-24 21:06:54'),
(43, 'Withdraw Rejected by Admin', 'withdraw-reject-admin', 'Withdraw Request Has Been Rejected', 'Hello [[user_name]],', 'The withdraw request (#[[order_id]]) has been rejected. The amount of [[order_all_amount]] has been adjusted to user account balance and notified to user ([[user_name]] - [[user_email]]). \n\nRejection Note: \n[[withdraw_note]]\n\nPS. Do not reply to this email.\nThank you.', 'withdrawal', 'admin', NULL, '{\"regards\":\"off\"}', '[[order_id]], [[order_by]], [[order_amount]], [[order_all_amount]], [[order_time]], [[payment_method]], [[withdraw_to]], [[withdraw_details]], [[withdraw_note]]', 'inactive', '2021-07-24 21:06:54', '2021-07-24 21:06:54');

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

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

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

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

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

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

CREATE TABLE `iv_invests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ivx` varchar(191) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `term` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `term_count` int(11) NOT NULL,
  `term_total` int(11) NOT NULL,
  `term_calc` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `term_start` datetime DEFAULT NULL,
  `term_end` datetime DEFAULT NULL,
  `reference` bigint(20) NOT NULL,
  `scheme` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta` text COLLATE utf8mb4_unicode_ci,
  `desc` text COLLATE utf8mb4_unicode_ci,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `note` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `iv_ledgers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ivx` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `calc` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double NOT NULL,
  `fees` double NOT NULL,
  `total` double NOT NULL,
  `currency` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `desc` text COLLATE utf8mb4_unicode_ci,
  `remarks` text COLLATE utf8mb4_unicode_ci,
  `note` text COLLATE utf8mb4_unicode_ci,
  `invest_id` bigint(20) NOT NULL,
  `tnx_id` bigint(20) NOT NULL,
  `reference` bigint(20) NOT NULL,
  `meta` text COLLATE utf8mb4_unicode_ci,
  `source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dest` varchar(191) 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 `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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` double NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `returns` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `ROI` text COLLATE utf8mb4_unicode_ci,
  `duration` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'days',
  `days` int(11) NOT NULL,
  `amount` double NOT NULL,
  `max_amount` int(11) NOT NULL,
  `term` int(11) NOT NULL,
  `active` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes',
  `rate` double(8,2) DEFAULT NULL,
  `ref` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `iv_schemes` (`id`, `name`, `slug`, `returns`, `ROI`, `duration`, `days`, `amount`, `max_amount`, `term`, `active`, `rate`, `ref`) VALUES
(2, 'Basic Plan', 'bronze-Plan', '0', '6', 'months', 30, 550, 999, 1, 'yes', 1.50, 3),
(3, 'Silver Plan', 'Silver Plan', '0', '8', 'months', 30, 1000, 4999, 1, 'yes', 2.50, 5),
(4, 'Gold Plan', 'Gold Plan', '0', '12', 'months', 30, 4000, 9999, 1, 'yes', 0.25, 8),
(24, 'Platinum Plan', 'platinum-plan', '0', '16', 'months', 30, 10000, 2000000, 1, 'yes', NULL, 10),
(27, 'Ruby-plan', 'Ruby-plan', '0', '20', 'days', 1, 20000, 49999, 1, 'yes', NULL, 0),
(28, 'Diamond plan', 'Diamond-plan', '0', '35', 'days', 1, 50000, 1000000, 1, 'yes', NULL, 0),
(29, 'Saphire plan', 'saphire-plan', '0', '45', 'days', 1, 35000, 9999, 1, 'yes', NULL, 0);

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

--
-- 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(191) 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 `languages`
--

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `translations` longtext COLLATE utf8mb4_unicode_ci,
  `rtl` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci 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', '2021-07-24 21:06:27', '2021-07-24 21:06:27');

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

--
-- 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 DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `login_histories`
--

CREATE TABLE `login_histories` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `device` varchar(225) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) 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, '2021_01_04_000000_create_users_table', 1),
(2, '2021_02_17_000000_create_failed_jobs_table', 1),
(3, '2021_04_12_101006_create_verify_tokens_table', 1),
(4, '2021_04_12_101023_create_user_metas_table', 1),
(5, '2021_04_12_101046_create_user_accounts_table', 1),
(6, '2021_04_12_101502_create_user_activities_table', 1),
(7, '2021_04_12_102056_create_referrals_table', 1),
(8, '2021_04_12_102084_create_referral_codes_table', 1),
(9, '2021_04_15_120264_create_settings_table', 1),
(10, '2021_04_15_120392_create_pages_table', 1),
(11, '2021_04_15_120416_create_email_templates_table', 1),
(12, '2021_04_15_120574_create_payment_methods_table', 1),
(13, '2021_04_15_120683_create_withdraw_methods_table', 1),
(14, '2021_04_15_132940_create_accounts_table', 1),
(15, '2021_04_19_132965_create_transactions_table', 1),
(16, '2021_04_19_132996_create_ledgers_table', 1),
(17, '2021_04_19_135150_add_iv_schemes_table', 1),
(18, '2021_04_19_135158_add_iv_scheme_metas_table', 1),
(19, '2021_04_19_135235_add_iv_invests_table', 1),
(20, '2021_04_19_135364_add_iv_ledgers_table', 1),
(21, '2021_04_19_135389_add_iv_profits_table', 1),
(22, '2021_04_19_135458_add_iv_actions_table', 1),
(23, '2021_06_04_162627_create_languages_table', 1);

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

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

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `menu_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `menu_link` text COLLATE utf8mb4_unicode_ci,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtitle` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo` text COLLATE utf8mb4_unicode_ci,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `public` tinyint(1) NOT NULL DEFAULT '1',
  `params` text COLLATE utf8mb4_unicode_ci,
  `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`, `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', 1, NULL, 0, '2021-07-24 21:06:46', '2021-07-24 21:06:46'),
(2, 'Our Fees', 'fees', 'Fees', NULL, 'Our Fees', NULL, NULL, NULL, 'en', 'inactive', 1, NULL, 0, '2021-07-24 21:06:46', '2021-07-24 21:06:46'),
(3, 'Referral', 'referral', 'Referral', NULL, 'My Referral', NULL, NULL, NULL, 'en', 'inactive', 1, NULL, 0, '2021-07-24 21:06:46', '2021-07-24 21:06:46'),
(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', 1, NULL, 0, '2021-07-24 21:06:46', '2021-07-24 21:06:46'),
(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', 1, NULL, 0, '2021-07-24 21:06:47', '2021-07-24 21:06:47'),
(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', 1, NULL, 0, '2021-07-24 21:06:47', '2021-07-24 21:06:47'),
(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', 1, NULL, 0, '2021-07-24 21:06:48', '2021-07-24 21:06:48');

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

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

CREATE TABLE `payment_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `wallet_address` text COLLATE utf8mb4_unicode_ci,
  `network` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `qr_image` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `slug`, `name`, `image`, `wallet_address`, `network`, `qr_image`, `active`) VALUES
(4, 'BTC', 'Bitcoin', 'bitcoin.svg', 'bc1q4ncec3dca944tgk795c2fe96jncqzmkkpwzzya', 'no', 'Your_Bitcoin_QR_Code.png', 'yes'),
(7, 'ETH', 'Ethereum', 'ethereum.png', '0x17AD084112514B943039308508A5A0917b66f74A', 'no', 'Dogecoin_QR_code.png', 'yes'),
(15, 'BNB', 'Binance coin (BNB)', 'bnb.png', 'no address specified', 'no', '', 'no'),
(16, 'USDT', 'USDT', '', '0x17AD084112514B943039308508A5A0917b66f74A', 'yes', '', 'yes');

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

--
-- Table structure for table `portifolios`
--

CREATE TABLE `portifolios` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `type` varchar(20) NOT NULL DEFAULT 'portfolio',
  `user_id` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `balance` int(11) NOT NULL DEFAULT '0',
  `profit` int(11) NOT NULL DEFAULT '0',
  `ticker` varchar(50) NOT NULL,
  `rate` varchar(45) NOT NULL,
  `status` varchar(45) NOT NULL DEFAULT 'null',
  `bot` int(11) NOT NULL DEFAULT '0',
  `save_pro` varchar(10) NOT NULL,
  `min_withdraw` varchar(255) DEFAULT NULL,
  `date` varchar(225) NOT NULL,
  `unix_time` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `portifolios`
--

INSERT INTO `portifolios` (`id`, `name`, `description`, `type`, `user_id`, `amount`, `balance`, `profit`, `ticker`, `rate`, `status`, `bot`, `save_pro`, `min_withdraw`, `date`, `unix_time`) VALUES
(59, 'My wallet', 'New portfolio created', 'wallet', 119, 5000, 8, 0, 'BTC-USD', '3', 'null', 0, 'no', NULL, 'Saturday 30th of July 2022', '1659217522'),
(60, 'Vic okeke', 'New portfolio created', 'portfolio', 119, 5000, 32, 0, 'BTC-USD', '3', 'null', 0, 'no', NULL, 'Saturday 30th of July 2022', '1659217522'),
(61, 'Wallet', 'Original portfolio', 'wallet', 121, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Thursday 17th of November 2022', '1668696600'),
(62, 'Wallet', 'Original portfolio', 'wallet', 123, 0, 200, 85500, 'BTC-USD', '', 'active', 0, 'no', NULL, 'Thursday 17th of November 2022', '1668782994'),
(63, 'Wallet', 'Original portfolio', 'wallet', 125, 0, 1675, 5051, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Thursday 17th of November 2022', '1668704721'),
(64, 'Wallet', 'Original portfolio', 'wallet', 130, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Saturday 19th of November 2022', '1668870277'),
(65, 'Wallet', 'Original portfolio', 'wallet', 131, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Tuesday 22nd of November 2022', '1669076443'),
(66, 'Wallet', 'Original portfolio', 'wallet', 132, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Tuesday 22nd of November 2022', '1669100940'),
(67, 'Wallet', 'Original portfolio', 'wallet', 136, 0, 650, 10608, 'BTC-USD', '', 'active', 0, 'no', NULL, 'Tuesday 22nd of November 2022', '1670620905'),
(68, 'Wallet', 'Original portfolio', 'wallet', 136, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Tuesday 22nd of November 2022', '1669140952'),
(69, 'Wallet', 'Original portfolio', 'wallet', 136, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Tuesday 22nd of November 2022', '1669140953'),
(70, 'Wallet', 'Original portfolio', 'wallet', 136, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Tuesday 22nd of November 2022', '1669140963'),
(71, 'Wallet', 'Original portfolio', 'wallet', 136, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Tuesday 22nd of November 2022', '1669140977'),
(72, 'Wallet', 'Original portfolio', 'wallet', 139, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Sunday 27th of November 2022', '1669581361'),
(73, 'Wallet', 'Original portfolio', 'wallet', 143, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Tuesday 29th of November 2022', '1669715543'),
(74, 'Wallet', 'Original portfolio', 'wallet', 143, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Tuesday 29th of November 2022', '1669715546'),
(75, 'Wallet', 'Original portfolio', 'wallet', 143, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Tuesday 29th of November 2022', '1669715552'),
(76, 'Wallet', 'Original portfolio', 'wallet', 145, 0, 60, 0, 'BTC-USD', '', 'active', 0, 'no', NULL, 'Sunday 11th of December 2022', '1673607096'),
(77, 'Wallet', 'Original portfolio', 'wallet', 145, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Monday 12th of December 2022', '1670873602'),
(78, 'Wallet', 'Original portfolio', 'wallet', 145, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Monday 12th of December 2022', '1670873606'),
(79, 'mr tiktok', 'New portfolio created', 'portfolio', 145, 300, 2, 3760, 'BTC-USD', '2', 'active', 0, 'no', NULL, 'Wednesday 14th of December 2022', '1673610633'),
(80, 'Wallet', 'Original portfolio', 'wallet', 146, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Wednesday 14th of December 2022', '1671052023'),
(81, 'Wallet', 'Original portfolio', 'wallet', 154, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Monday 19th of December 2022', '1671457429'),
(82, 'Wallet', 'Original portfolio', 'wallet', 155, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Monday 19th of December 2022', '1671464978'),
(83, 'Wallet', 'Original portfolio', 'wallet', 156, 0, 100, 0, 'BTC-USD', '', 'active', 0, 'no', NULL, 'Monday 19th of December 2022', '1671524457'),
(84, 'Wallet', 'Original portfolio', 'wallet', 156, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Monday 19th of December 2022', '1671490460'),
(85, 'Wallet', 'Original portfolio', 'wallet', 157, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Tuesday 20th of December 2022', '1671567766'),
(86, 'Wallet', 'Original portfolio', 'wallet', 159, 0, 2266, 0, 'BTC-USD', '', 'active', 0, 'no', NULL, 'Wednesday 21st of December 2022', '1673110223'),
(88, 'Wallet', 'Original portfolio', 'wallet', 162, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Tuesday 27th of December 2022', '1672181915'),
(89, 'Wallet', 'Original portfolio', 'wallet', 167, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Thursday 5th of January 2023', '1672920327'),
(90, 'Wallet', 'Original portfolio', 'wallet', 169, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Friday 6th of January 2023', '1673022458'),
(91, 'Wallet', 'Original portfolio', 'wallet', 170, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Sunday 8th of January 2023', '1673137356'),
(92, 'Bronet', 'New portfolio created', 'portfolio', 170, 300, 0, 0, 'BTC-USD', '2', 'null', 0, 'no', NULL, 'Sunday 8th of January 2023', '1673138638'),
(93, 'Bronet', 'New portfolio created', 'portfolio', 170, 300, 0, 0, 'BTC-USD', '2', 'null', 0, 'no', NULL, 'Sunday 8th of January 2023', '1673138645'),
(94, 'Wallet', 'Original portfolio', 'wallet', 171, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Sunday 8th of January 2023', '1673173105'),
(95, 'Wallet', 'Original portfolio', 'wallet', 172, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Tuesday 10th of January 2023', '1673389756'),
(96, 'Wallet', 'Original portfolio', 'wallet', 173, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Wednesday 11th of January 2023', '1673418712'),
(97, 'Wallet', 'Original portfolio', 'wallet', 174, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Wednesday 11th of January 2023', '1673428237'),
(98, 'Wallet', 'Original portfolio', 'wallet', 174, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Wednesday 11th of January 2023', '1673428253'),
(99, 'Wallet', 'Original portfolio', 'wallet', 175, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Thursday 12th of January 2023', '1673555820'),
(100, 'Wallet', 'Original portfolio', 'wallet', 176, 0, 3300, 14578, 'BTC-USD', '', 'active', 0, 'no', NULL, 'Saturday 14th of January 2023', '1673731731'),
(101, 'Wallet', 'Original portfolio', 'wallet', 177, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Sunday 15th of January 2023', '1673802420'),
(102, 'Wallet', 'Original portfolio', 'wallet', 178, 0, 682, 3100, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Monday 16th of January 2023', '1673893305'),
(103, 'Wallet', 'Original portfolio', 'wallet', 180, 0, 3228, 15800, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Tuesday 17th of January 2023', '1673978288'),
(106, 'Fr', 'New portfolio created', 'portfolio', 180, 589, 347, 0, 'BTC-USD', '2', 'null', 0, 'no', NULL, 'Tuesday 17th of January 2023', '1673985629'),
(108, 'Wallet', 'Original portfolio', 'wallet', 182, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Wednesday 18th of January 2023', '1674070189'),
(109, 'Tt', 'New portfolio created', 'portfolio', 178, 2700, 682, 750, 'BTC-USD', '2', 'null', 0, 'no', NULL, 'Saturday 21st of January 2023', '1674321952'),
(110, 'Wallet', 'Original portfolio', 'wallet', 183, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Sunday 22nd of January 2023', '1674407892'),
(111, 'Wallet', 'Original portfolio', 'wallet', 184, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Monday 23rd of January 2023', '1674487388'),
(116, '1', 'New portfolio created', 'portfolio', 159, 2000, 2000, 156, 'BTC-USD', '3', 'null', 0, 'no', NULL, 'Thursday 26th of January 2023', '1674745041'),
(117, 'Wallet', 'Original portfolio', 'wallet', 186, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Saturday 28th of January 2023', '1674910176'),
(118, 'Wallet', 'Original portfolio', 'wallet', 189, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Sunday 29th of January 2023', '1675026207'),
(119, 'Wallet', 'Original portfolio', 'wallet', 190, 0, 0, 0, 'BTC-USD', '', 'null', 0, 'no', NULL, 'Monday 30th of January 2023', '1675050257');

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

--
-- 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` varchar(225) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `referrals`
--

INSERT INTO `referrals` (`id`, `user_id`, `refer_by`, `join_at`, `meta`) VALUES
(4, 119, 0, '2022-June-30th', '');

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

--
-- 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desc` varchar(191) 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 `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) 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', 'Axostone', '2022-11-16 18:17:34'),
(2, 'site_email', 'support@axostone.com', '2022-11-16 18:17:46'),
(3, 'site_phone', '+1 (908) 845-5378', '2022-03-09 10:49:53'),
(4, 'site_disclaimer', '', '2021-07-24 21:06:29'),
(5, 'site_merchandise', NULL, '2021-07-24 21:06:29'),
(6, 'main_website', '', '2021-07-24 21:06:29'),
(7, 'front_page_enable', 'yes', '2021-07-24 21:06:29'),
(8, 'front_page_extra', 'on', '2021-07-24 21:06:29'),
(9, 'front_page_title', 'Welcome', '2021-07-24 21:06:29'),
(10, 'invest_page_enable', 'yes', '2021-07-24 21:06:29'),
(11, 'time_zone', 'Asia/Dhaka', '2021-07-24 21:06:29'),
(12, 'date_format', 'd M, Y', '2021-07-24 21:06:29'),
(13, 'time_format', 'h:i A', '2021-07-24 21:06:30'),
(14, 'decimal_fiat_display', '2', '2021-07-24 21:06:30'),
(15, 'decimal_crypto_display', '4', '2021-07-24 21:06:30'),
(16, 'decimal_fiat_calc', '2', '2021-07-24 21:06:30'),
(17, 'decimal_crypto_calc', '6', '2021-07-24 21:06:31'),
(18, 'signup_allow', 'enable', '2021-07-24 21:06:31'),
(19, 'email_verification', 'on', '2021-07-24 21:06:31'),
(20, 'batch_update', '120', '2021-07-24 21:06:31'),
(21, 'maintenance_mode', 'off', '2021-07-24 21:06:31'),
(22, 'maintenance_notice', 'We are upgrading our system. Please check after 30 minutes.', '2021-07-24 21:06:31'),
(23, 'mail_from_name', 'Investorm', '2021-07-24 21:06:31'),
(24, 'mail_from_email', 'noreply@yourdomain.com', '2021-07-24 21:06:31'),
(25, 'mail_global_footer', 'Best Regard, \nTeam of [[site_name]]', '2021-07-24 21:06:31'),
(26, 'mail_driver', 'mail', '2021-07-24 21:06:31'),
(27, 'mail_smtp_host', 'mail.yourdomain.com', '2021-07-24 21:06:32'),
(28, 'mail_smtp_port', '587', '2021-07-24 21:06:32'),
(29, 'mail_smtp_secure', 'tls', '2021-07-24 21:06:32'),
(30, 'mail_smtp_user', '', '2021-07-24 21:06:32'),
(31, 'mail_smtp_password', '', '2021-07-24 21:06:32'),
(32, 'mail_recipient', '', '2021-07-24 21:06:32'),
(33, 'mail_recipient_alter', '', '2021-07-24 21:06:32'),
(34, 'youtube_link', '', '2021-07-24 21:06:33'),
(35, 'linkedin_link', '', '2021-07-24 21:06:33'),
(36, 'twitter_link', '', '2021-07-24 21:06:33'),
(37, 'facebook_link', '', '2021-07-24 21:06:33'),
(38, 'medium_link', '', '2021-07-24 21:06:33'),
(39, 'telegram_link', '', '2021-07-24 21:06:33'),
(40, 'github_link', '', '2021-07-24 21:06:33'),
(41, 'pinterest_link', '', '2021-07-24 21:06:33'),
(42, 'app_acquire', '', '2021-07-24 21:06:34'),
(43, 'exratesapi_access_key', '', '2021-07-24 21:06:34'),
(44, 'recaptcha_site_key', '', '2021-07-24 21:06:34'),
(45, 'recaptcha_secret_key', '', '2021-07-24 21:06:34'),
(46, 'custom_stylesheet', 'off', '2021-07-24 21:06:34'),
(47, 'header_code', '', '2021-07-24 21:06:34'),
(48, 'footer_code', '', '2021-07-24 21:06:34'),
(49, 'main_nav', '[1,4,5]', '2021-07-24 22:06:47'),
(50, 'main_menu', '[]', '2021-07-24 21:06:34'),
(51, 'footer_menu', '[4,6,7]', '2021-07-24 22:06:48'),
(52, 'page_terms', '6', '2021-07-24 22:06:48'),
(53, 'page_privacy', '7', '2021-07-24 22:06:48'),
(54, 'page_fee_deposit', '', '2021-07-24 21:06:35'),
(55, 'page_fee_withdraw', '', '2021-07-24 21:06:35'),
(56, 'page_contact', '5', '2021-07-24 22:06:47'),
(57, 'page_contact_form', 'on', '2021-07-24 21:06:36'),
(58, 'ui_page_skin', 'dark', '2021-07-24 21:06:37'),
(59, 'ui_auth_skin', 'dark', '2021-07-24 21:06:37'),
(60, 'ui_auth_layout', 'default', '2021-07-24 21:06:37'),
(61, 'ui_theme_mode', 'light', '2021-07-24 21:06:37'),
(62, 'ui_theme_skin', 'default', '2021-07-24 21:06:37'),
(63, 'ui_sidebar_user', 'white', '2021-07-24 21:06:37'),
(64, 'ui_sidebar_admin', 'darker', '2021-07-24 21:06:37'),
(65, 'ui_theme_mode_admin', 'light', '2021-07-24 21:06:38'),
(66, 'ui_theme_skin_admin', 'default', '2021-07-24 21:06:38'),
(67, 'payout_batch', NULL, '2021-07-24 21:06:38'),
(68, 'signup_bonus_allow', 'no', '2021-07-24 21:06:38'),
(69, 'signup_bonus_amount', '0', '2021-07-24 21:06:38'),
(70, 'deposit_bonus_allow', 'no', '2021-07-24 21:06:38'),
(71, 'deposit_bonus_amount', '0', '2021-07-24 21:06:38'),
(72, 'deposit_bonus_type', 'fixed', '2021-07-24 21:06:38'),
(73, 'referral_system', 'no', '2021-07-24 21:06:38'),
(74, 'referral_invite_title', 'Refer Us & Earn', '2021-07-24 21:06:38'),
(75, 'referral_invite_text', 'Use the below link to invite your friends.', '2021-07-24 21:06:38'),
(76, 'referral_signup_user', 'no', '2021-07-24 21:06:39'),
(77, 'referral_signup_user_bonus', '0', '2021-07-24 21:06:39'),
(78, 'referral_signup_user_reward', 'no', '2021-07-24 21:06:39'),
(79, 'referral_deposit_user', 'no', '2021-07-24 21:06:39'),
(80, 'referral_deposit_user_bonus', '0', '2021-07-24 21:06:39'),
(81, 'referral_deposit_user_type', 'percent', '2021-07-24 21:06:39'),
(82, 'referral_signup_referer', 'no', '2021-07-24 21:06:39'),
(83, 'referral_signup_referer_bonus', '0', '2021-07-24 21:06:39'),
(84, 'referral_deposit_referer', 'no', '2021-07-24 21:06:40'),
(85, 'referral_deposit_referer_bonus', '0', '2021-07-24 21:06:40'),
(86, 'referral_deposit_referer_type', 'percent', '2021-07-24 21:06:40'),
(87, 'alert_wd_account', 'on', '2021-07-24 21:06:40'),
(88, 'alert_profile_basic', 'on', '2021-07-24 21:06:40'),
(89, 'header_notice_show', 'no', '2021-07-24 21:06:40'),
(90, 'header_notice_title', '', '2021-07-24 21:06:40'),
(91, 'header_notice_text', '', '2021-07-24 21:06:41'),
(92, 'header_notice_link', '', '2021-07-24 21:06:41'),
(93, 'system_service', NULL, '2021-07-24 21:06:41'),
(94, 'deposit_service', 'l1', '2021-07-24 21:06:41'),
(95, 'deposit_limit_request', '0', '2021-07-24 21:06:41'),
(96, 'deposit_cancel_timeout', 'yes', '2021-07-24 21:06:41'),
(97, 'deposit_fiat_minimum', '1', '2021-07-24 21:06:41'),
(98, 'deposit_crypto_minimum', '0', '2021-07-24 21:06:42'),
(99, 'deposit_fiat_maximum', '0', '2021-07-24 21:06:42'),
(100, 'deposit_crypto_maximum', '0', '2021-07-24 21:06:42'),
(101, 'deposit_disable_request', 'no', '2021-07-24 21:06:42'),
(102, 'deposit_disable_title', 'Temporarily unavailable!', '2021-07-24 21:06:42'),
(103, 'deposit_disable_notice', 'Sorry, we are upgrading our deposit system. Please check after sometimes. We apologize for any inconvenience.', '2021-07-24 21:06:42'),
(104, 'payout_check', NULL, '2021-07-24 21:06:42'),
(105, 'withdraw_service', 'l1', '2021-07-24 21:06:42'),
(106, 'withdraw_limit_request', '0', '2021-07-24 21:06:42'),
(107, 'withdraw_cancel_timeout', 'yes', '2021-07-24 21:06:42'),
(108, 'withdraw_fiat_minimum', '10', '2021-07-24 21:06:43'),
(109, 'withdraw_fiat_maximum', '0', '2021-07-24 21:06:43'),
(110, 'withdraw_crypto_minimum', '0', '2021-07-24 21:06:43'),
(111, 'withdraw_crypto_maximum', '0', '2021-07-24 21:06:43'),
(112, 'withdraw_disable_request', 'no', '2021-07-24 21:06:43'),
(113, 'withdraw_disable_title', 'Temporarily unavailable!', '2021-07-24 21:06:43'),
(114, 'withdraw_disable_notice', 'Sorry, we are upgrading our withdrawal system. Please check after sometimes. We apologize for any inconvenience.', '2021-07-24 21:06:43'),
(115, 'app_queue', '0', '2021-07-24 21:06:43'),
(116, 'base_currency', 'USD', '2021-07-24 21:06:43'),
(117, 'alter_currency', 'GBP', '2021-07-24 21:06:43'),
(118, 'supported_currency', '{\"USD\":\"on\",\"EUR\":\"on\",\"GBP\":\"on\",\"CAD\":\"on\",\"BTC\":\"on\",\"ETH\":\"on\",\"LTC\":\"on\",\"BNB\":\"on\"}', '2021-07-24 21:06:43'),
(119, 'fiat_rounded', 'up', '2021-07-24 21:06:43'),
(120, 'crypto_rounded', 'none', '2021-07-24 21:06:43'),
(121, 'exchange_method', 'automatic', '2021-07-24 21:06:44'),
(122, 'exchange_auto_update', '30', '2021-07-24 21:06:44'),
(123, 'exchange_last_update', '1627164388', '2021-07-24 21:06:44'),
(124, 'manual_exchange_rate', '{\"USD\":0,\"EUR\":0,\"GBP\":0,\"CAD\":0,\"BTC\":0,\"ETH\":0,\"LTC\":0,\"BNB\":0}', '2021-07-24 21:06:44'),
(125, 'health_checker', '0', '2021-07-24 21:06:44'),
(126, 'top_iv_plan_x0', '3', '2021-07-24 22:06:49'),
(127, 'top_iv_plan_x1', '1', '2021-07-24 22:06:49'),
(128, 'top_iv_plan_x2', '2', '2021-07-24 22:06:49'),
(129, 'iv_plan_order', 'featured', '2021-07-24 21:06:45'),
(130, 'iv_show_plans', 'default', '2021-07-24 21:06:45'),
(131, 'iv_plan_desc_show', 'no', '2021-07-24 21:06:45'),
(132, 'iv_plan_total_percent', 'yes', '2021-07-24 21:06:45'),
(133, 'iv_plan_pg_heading', 'Investment Plans', '2021-07-24 21:06:45'),
(134, 'iv_plan_pg_title', 'Choose your favourite plan and start earning now.', '2021-07-24 21:06:45'),
(135, 'iv_plan_pg_text', 'Here is our several investment plans. You can invest daily, weekly or monthly and get higher returns in your investment.', '2021-07-24 21:06:45'),
(136, 'iv_launched_date', '07/24/2021', '2021-07-24 21:06:45'),
(137, 'iv_cancel_timeout', '15', '2021-07-24 21:06:45'),
(138, 'iv_admin_confirmtion', 'yes', '2021-07-24 21:06:45'),
(139, 'iv_disable_purchase', 'no', '2021-07-24 21:06:45'),
(140, 'iv_disable_title', 'Temporarily unavailable!', '2021-07-24 21:06:45'),
(141, 'iv_disable_notice', '', '2021-07-24 21:06:45'),
(142, 'iv_profit_payout', 'everytime', '2021-07-24 21:06:46'),
(143, 'iv_profit_payout_amount', '100', '2021-07-24 21:06:46'),
(144, 'iv_plan_fx_currencies', '[]', '2021-07-24 21:06:46'),
(145, 'iv_weekend_days', '[]', '2021-07-24 21:06:46'),
(146, 'language_default_public', 'en', '2021-07-24 21:06:56'),
(147, 'language_default_system', 'en', '2021-07-24 21:06:56'),
(148, 'language_show_as', 'default', '2021-07-24 21:06:56'),
(149, 'language_switcher', 'off', '2021-07-24 21:06:57'),
(150, 'application_rcv', '2110110', '2021-07-24 21:06:57');

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

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

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `folio_id` int(11) NOT NULL,
  `amount` double NOT NULL DEFAULT '0',
  `type` varchar(225) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'approved',
  `currency` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `unix_time` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `days_left` int(11) DEFAULT NULL,
  `is_bot` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `transactions` (`id`, `user_id`, `folio_id`, `amount`, `type`, `status`, `currency`, `date`, `unix_time`, `days_left`, `is_bot`) VALUES
(122, 119, 0, 1000, 'deposit', 'pending', '4', 'Friday 4th of November 2022', '1667596121', NULL, 'no'),
(123, 119, 0, 1000, 'deposit', 'pending', '4', 'Friday 4th of November 2022', '1667596178', NULL, 'no'),
(124, 119, 0, 1000, 'deposit', 'pending', '4', 'Friday 4th of November 2022', '1667596300', NULL, 'no'),
(125, 119, 0, 2000, 'deposit', 'pending', '4', 'Friday 4th of November 2022', '1667596317', NULL, 'no'),
(126, 119, 0, 1000, 'deposit', 'pending', '4', 'Friday 4th of November 2022', '1667596422', NULL, 'no'),
(127, 119, 59, 1000, 'deposit', 'pending', '4', 'Friday 4th of November 2022', '1667596524', NULL, 'no'),
(128, 119, 0, 10, 'deposit', 'pending', 'USD', 'Friday 4th of November 2022', '1667599137', NULL, 'no'),
(129, 119, 0, 10, 'deposit', 'pending', 'USD', 'Friday 4th of November 2022', '1667599181', NULL, 'no'),
(130, 119, 60, 10, 'deposit', 'pending', 'USD', 'Friday 4th of November 2022', '1667599223', NULL, 'no'),
(131, 119, 60, 10, 'deposit', 'pending', 'USD', 'Friday 4th of November 2022', '1667599325', NULL, 'no'),
(132, 119, 60, 10, 'deposit', 'pending', 'USD', 'Friday 4th of November 2022', '1667599538', NULL, 'no'),
(133, 119, 60, 2, 'deposit', 'pending', 'USD', 'Friday 4th of November 2022', '1667599887', NULL, 'no'),
(134, 121, 61, 5000, 'deposit', 'pending', 'bank', 'Thursday 17th of November 2022', '1668696656', NULL, 'no'),
(135, 121, 61, 5000, 'deposit', 'pending', '4', 'Thursday 17th of November 2022', '1668697003', NULL, 'no'),
(136, 121, 61, 5000, 'deposit', 'pending', '4', 'Thursday 17th of November 2022', '1668697151', NULL, 'no'),
(137, 121, 61, 5000, 'deposit', 'pending', '4', 'Thursday 17th of November 2022', '1668698459', NULL, 'no'),
(141, 123, 62, 250, 'deposit', 'approved', '4', 'Friday 18th of November 2022', '1668779972', NULL, 'no'),
(142, 131, 65, 80, 'deposit', 'pending', '16', 'Tuesday 22nd of November 2022', '1669121459', NULL, 'no'),
(143, 131, 65, 80, 'deposit', 'pending', '4', 'Tuesday 22nd of November 2022', '1669121533', NULL, 'no'),
(144, 139, 72, 0, 'deposit', 'pending', '4', 'Sunday 27th of November 2022', '1669583423', NULL, 'no'),
(154, 145, 79, 140, 'deposit', 'pending', 'USD', 'Wednesday 14th of December 2022', '1671015748', NULL, 'no'),
(160, 145, 76, 153, 'deposit', 'approved', '4', 'Wednesday 14th of December 2022', '1671023861', NULL, 'no'),
(163, 145, 79, 153, 'deposit', 'pending', 'USD', 'Wednesday 14th of December 2022', '1671026888', NULL, 'no'),
(164, 145, 76, 6, 'deposit', 'pending', '4', 'Wednesday 14th of December 2022', '1671027582', NULL, 'no'),
(165, 145, 76, 9, 'deposit', 'pending', '4', 'Wednesday 14th of December 2022', '1671027614', NULL, 'no'),
(166, 145, 76, 9, 'deposit', 'approved', '4', 'Wednesday 14th of December 2022', '1671027620', NULL, 'no'),
(171, 146, 80, 100, 'deposit', 'pending', '4', 'Wednesday 14th of December 2022', '1671052658', NULL, 'no'),
(172, 146, 80, 100, 'deposit', 'pending', '4', 'Wednesday 14th of December 2022', '1671052661', NULL, 'no'),
(173, 156, 83, 100, 'deposit', 'pending', '4', 'Monday 19th of December 2022', '1671492891', NULL, 'no'),
(174, 156, 83, 300, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671517132', NULL, 'no'),
(175, 156, 83, 300, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671517135', NULL, 'no'),
(176, 156, 83, 300, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671517139', NULL, 'no'),
(177, 156, 83, 300, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671517140', NULL, 'no'),
(178, 156, 83, 300, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671517142', NULL, 'no'),
(179, 156, 83, 300, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671517144', NULL, 'no'),
(180, 156, 83, 300, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671517151', NULL, 'no'),
(181, 156, 83, 300, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671517165', NULL, 'no'),
(182, 156, 83, 300, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671517167', NULL, 'no'),
(183, 156, 83, 300, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671517173', NULL, 'no'),
(184, 156, 83, 300, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671517184', NULL, 'no'),
(185, 156, 83, 300, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671517187', NULL, 'no'),
(186, 156, 83, 300, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671518722', NULL, 'no'),
(187, 156, 83, 300, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671518731', NULL, 'no'),
(188, 156, 83, 300, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671518751', NULL, 'no'),
(189, 156, 83, 100, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671521168', NULL, 'no'),
(190, 156, 83, 100, 'deposit', 'approved', '4', 'Tuesday 20th of December 2022', '1671521175', NULL, 'no'),
(191, 156, 83, 100, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671522373', NULL, 'no'),
(192, 156, 83, 100, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671522379', NULL, 'no'),
(193, 156, 83, 100, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671522750', NULL, 'no'),
(194, 156, 83, 100, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671522754', NULL, 'no'),
(196, 145, 76, 2, 'deposit', 'pending', '4', 'Tuesday 20th of December 2022', '1671566493', NULL, 'no'),
(197, 159, 86, 50, 'deposit', 'approved', '4', 'Wednesday 21st of December 2022', '1671629421', NULL, 'no'),
(198, 159, 86, 70, 'deposit', 'pending', '7', 'Wednesday 21st of December 2022', '1671633257', NULL, 'no'),
(204, 159, 86, 110, 'deposit', 'approved', '16', 'Wednesday 21st of December 2022', '1671658382', NULL, 'no'),
(205, 159, 86, 70, 'deposit', 'approved', '4', 'Wednesday 21st of December 2022', '1671659808', NULL, 'no'),
(206, 156, 83, 100, 'deposit', 'pending', '4', 'Saturday 24th of December 2022', '1671879452', NULL, 'no'),
(209, 145, 79, 2, 'deposit', 'pending', 'USD', 'Wednesday 28th of December 2022', '1672258746', NULL, 'no'),
(211, 145, 76, 9, 'deposit', 'pending', '7', 'Thursday 29th of December 2022', '1672332241', NULL, 'no'),
(212, 145, 76, 4, 'deposit', 'approved', '4', 'Thursday 29th of December 2022', '1672346779', NULL, 'no'),
(214, 159, 86, 250, 'deposit', 'approved', '16', 'Thursday 5th of January 2023', '1672935197', NULL, 'no'),
(215, 169, 90, 300, 'deposit', 'pending', '4', 'Friday 6th of January 2023', '1673026833', NULL, 'no'),
(228, 145, 76, 200, 'deposit', 'approved', '4', 'Tuesday 10th of January 2023', '1673352105', NULL, 'no'),
(229, 145, 76, 100, 'deposit', 'approved', '4', 'Tuesday 10th of January 2023', '1673355786', NULL, 'no'),
(238, 159, 86, 570, 'deposit', 'approved', '16', 'Saturday 14th of January 2023', '1673731892', NULL, 'no'),
(239, 176, 100, 1000, 'deposit', 'approved', '4', 'Saturday 14th of January 2023', '1673733569', NULL, 'no'),
(240, 145, 76, 233, 'deposit', 'pending', '4', 'Monday 16th of January 2023', '1673860225', NULL, 'no'),
(241, 176, 100, 10, 'deposit', 'pending', '4', 'Monday 16th of January 2023', '1673861178', NULL, 'no'),
(242, 176, 100, 1000, 'deposit', 'pending', '4', 'Monday 16th of January 2023', '1673885839', NULL, 'no'),
(243, 178, 102, 359, 'deposit', 'approved', '4', 'Monday 16th of January 2023', '1673894321', NULL, 'no'),
(245, 178, 102, 350, 'deposit', 'approved', '4', 'Tuesday 17th of January 2023', '1673982283', NULL, 'no'),
(247, 178, 102, 4000, 'deposit', 'pending', '4', 'Tuesday 17th of January 2023', '1673985635', NULL, 'yes'),
(248, 180, 106, 347, 'deposit', 'pending', 'USD', 'Tuesday 17th of January 2023', '1673985688', NULL, 'no'),
(249, 178, 102, 4000, 'deposit', 'pending', '4', 'Tuesday 17th of January 2023', '1673985738', NULL, 'yes'),
(250, 178, 109, 682, 'deposit', 'pending', 'USD', 'Sunday 22nd of January 2023', '1674384271', NULL, 'no'),
(251, 173, 96, 100, 'deposit', 'pending', '16', 'Friday 27th of January 2023', '1674790904', NULL, 'no'),
(252, 173, 96, 100, 'deposit', 'pending', '16', 'Friday 27th of January 2023', '1674790931', NULL, 'no'),
(253, 173, 96, 100, 'deposit', 'pending', '16', 'Friday 27th of January 2023', '1674790949', NULL, 'no');

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `username` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customerId` int(11) DEFAULT NULL,
  `city` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT 'No address specified',
  `zip_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'subscriber',
  `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `activated` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'false',
  `image_src` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT 'images/avatar/11.png',
  `organisation` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_message` varchar(225) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Welcome to Axostone',
  `salary` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_login` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `refer` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ref_bonus` int(11) NOT NULL DEFAULT '0',
  `otp` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `ip_address` varchar(224) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kyc` text COLLATE utf8mb4_unicode_ci,
  `activate` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'false',
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `email_preferences` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'true',
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `username`, `name`, `email`, `customerId`, `city`, `address`, `zip_code`, `phone`, `password`, `role`, `status`, `activated`, `image_src`, `organisation`, `position`, `custom_message`, `salary`, `last_login`, `refer`, `ref_bonus`, `otp`, `ip_address`, `kyc`, `activate`, `remember_token`, `created_at`, `email_preferences`, `deleted_at`) VALUES
(9, 'Axostone', 'Okeke', 'support@axostone.com', 0, '', 'No address specified', '', '234.8118552122', '$2y$10$e1caG7xCt4FacPz0l9ucN.H8x8SKw495qXbMV975TgYhFsIcKlEoS', 'admin', 'verified', 'true', 'css/images/profile%20pic.png', '', NULL, 'Welcome to Alphaminingtrade', NULL, 'Tuesday 21st of June 2022 08:47:52 PM', NULL, 0, 'MnOuw9a6', '197.211.58.187', NULL, 'false', NULL, NULL, '1', NULL),
(121, 'Okri ', 'Kenneth ', 'denomosed97@gmail.com', 21551270, 'Delta state ', 'Chairman ', '330103', '09015623529', '$2y$10$DCQdQgg5ImFbOWVKVkQCreHcjiuISHTNX./e85zJiPE/i0Mg1Lm9G', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Self employed', 'Manager ', 'Welcome to Axostone', '$10,000 - $99,000', 'Tuesday 22nd of November 2022 12:44:26 PM', '', 0, '875188', '105.112.155.175', NULL, 'false', NULL, NULL, 'true', NULL),
(123, 'chiron ', 'chiron jeanpierre', 'tiktoman2@gmail.com', 20635008, '', 'France', '', '0688357258', '$2y$10$vp/fRK34mQRVAeBN5cE8c.nOZZ0ossWAawrMWnXy2lgG7IQNJu2g.', 'subscriber', 'verified', 'true', 'images/avatar/11.png', '', 'Hj', 'Welcome to Axostone', '$10,000 - $99,000', 'Tuesday 22nd of November 2022 07:30:58 AM', '', 0, '320506', '105.112.61.36', 'images/avatar/20221112_151520.jpg', 'false', NULL, NULL, 'true', NULL),
(125, 'Daniel', 'Feliciano', 'daniskyfit1@gmail.com', 51416957, 'Vevey', 'La tou de peilz', '1814', '+41766237912', '$2y$10$yKEmfTVNaKjW05nUCZmyEu5cvIXmjkeTM8rV/FLJjeGlDJzOGsBA.', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Employed', 'Employed', 'Welcome to Axostone', '$10,000 - $99,000', 'Friday 18th of November 2022 11:32:39 AM', '', 0, '354177', '213.55.221.124', NULL, 'false', NULL, NULL, 'true', NULL),
(128, 'Chiron', 'Jean', 'ed8940ar@wanadoo.fr', NULL, NULL, 'No address specified', NULL, '0688357258', '$2y$10$HX/vIuphrhsRUphXUhxEi.E2XRyDmGeHlb8O.oHsXgu9vBLLxGbEm', 'subscriber', 'verified', 'false', 'images/avatar/11.png', NULL, NULL, 'Welcome to Axostone', NULL, NULL, NULL, 0, 'IjZCl3HV', NULL, NULL, 'false', NULL, NULL, 'true', NULL),
(130, 'Z', 'New', 'ononyetainn@gmail.com', 97700238, 'Us', 'G13', '437', '07053648835', '$2y$10$lAMbOOhkHICXKytcog3jXuim1cUuBcAx75vIV4x1il3GTW/EtNGai', 'subscriber', 'verified', 'true', 'images/avatar/vidma_recorder_25102022_142929.jpg', '', 'Gm', 'Welcome to Axostone', '$10,000 - $99,000', 'Monday 21st of November 2022 03:35:31 PM', '', 0, '205135', '197.210.78.53', 'images/avatar/IMG-20221117-WA0012.jpg', 'false', NULL, NULL, 'true', NULL),
(131, 'MARTÍN77', 'Juan Carlos Martín ajanel ', 'Veronicasilviamartin@gmail.com', 46557602, 'Guatemala ', 'Guatemala ', '01018', '(502)59205671', '$2y$10$Th2nugrxzvc1EL9ERQ2aneUHlGFWtiHYd3deW4cU9XElUQdghYeBO', 'subscriber', 'verified', 'true', 'images/avatar/11.png', 'Employed', 'Encuadernador ', 'Welcome to Axostone', '$10,000 - $99,000', 'Sunday 18th of December 2022 06:26:09 PM', '', 0, '340478', '190.56.50.36', 'images/avatar/IMG_20221120_104235.jpg', 'false', NULL, NULL, 'true', NULL),
(132, 'Stevoo', 'Abednigo Stephen ', 'casperdrex@gmail.com', 73015160, 'Udu', 'Igbiki', '330103', '09094863487', '$2y$10$hqjg5pfjtLCVH0PD11V.vuD9mUYNGashdZRJhPYIllDptI0EOGLZi', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Employed', 'CEO', 'Welcome to Axostone', '$100,000 - $499,000', NULL, '', 0, '259850', '105.112.168.255', NULL, 'false', NULL, NULL, 'true', NULL),
(136, 'Kessbecky', 'Kesiena becky', 'kessyluv79@gmail.com', 65486888, 'Nigeria ', 'NO1 atumah close ', 'Kess', '09127030622', '$2y$10$lpPOcYCT/zkLRKwzvybkWuU5Ur0Bq4uvqSZlbZYWQ68HK5KZT/B9e', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Employed', 'Secretary ', 'Welcome to Axostone', '$10,000 - $99,000', 'Thursday 5th of January 2023 12:38:28 PM', '', 0, 'd4NcpSK1', '197.211.61.57', NULL, 'false', NULL, NULL, 'true', NULL),
(139, 'sabsand', 'auger sandra', 'sandraauger31@gmail.com', 65616005, 'québec', '117 rue de la renaissance , sainte-sophie,québec,canada', 'J5J0J8', '450 276 7577', '$2y$10$g/B.n.AbOtq3E.UcDr4.BOOdXrbQ7kgYZtJ1g1kZtg.XxHMUDgzjO', 'subscriber', 'verified', 'true', 'images/avatar/11.png', 'Retired', 'maison', 'Welcome to Axostone', '$10,000 - $99,000', NULL, '', 0, '007443', '38.129.42.53', 'images/avatar/permis sandra trop gros.pdf', 'false', NULL, NULL, 'true', NULL),
(143, 'loriehu', 'Lorie', 'lorie.hu@hotmail.com', 87520927, 'france', '4 allée frédéric mistral ', '95350', '0781797047', '$2y$10$WQIrYWEoDoVhlbqoHwly9ep3610TDXhS6q1BFU9halp.78iE0k9xu', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Employed', 'engineer', 'Welcome to Axostone', '$10,000 - $99,000', NULL, '', 0, '725823', '77.204.197.232', NULL, 'false', NULL, NULL, 'true', NULL),
(145, 'Mr', 'Ibourk rachid ', 'ibourkrachid@hotmail.fr', 50359509, 'libercourt ', 'Residence Émilie Zola appart 3 batA ', '62820', '0761569255', '$2y$10$9OqQUsn2R286HBMmJK9xDeDyBzkQJP5oimbkpBDT.1wokUcTvT2aq', 'subscriber', 'verified', 'true', 'images/avatar/11.png', '', 'Chauffeur routier ', 'Welcome to Axostone', '$10,000 - $99,000', 'Saturday 28th of January 2023 07:45:22 PM', '', 0, '593352', '81.65.105.105', 'images/avatar/CIN rachid 1.pdf', 'false', NULL, NULL, '1', NULL),
(146, 'Joker2000', 'gestime Peterson', 'petergestime9@gmail.com', 43841056, 'port-au-prince', 'lambi 3', 'HT6120', '50936978096', '$2y$10$8PQAhsQbmc.0Quf6PC4iEeJV6uxE7XayXathoXfB22vyn8Ragc3vK', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Self employed', 'Directeur', 'Welcome to Axostone', '$10,000 - $99,000', NULL, '', 0, '338229', '200.113.234.169', NULL, 'false', NULL, NULL, 'true', NULL),
(154, 'ThiamBabacar', 'THIAM Babacar', 'babthm2408@gmail.com', 94039328, 'DAKAR', 'FANN RESIDENCE', '11000', '+221772454862', '$2y$10$N6Ofz2kLdzEWq2KekVRRLuzj6s5ui10gJPfSTsJuXwykwMBSmRa.a', 'subscriber', 'verified', 'true', 'images/avatar/11.png', 'Self employed', 'TELEVENDEUR', 'Welcome to Axostone', '$10,000 - $99,000', NULL, '', 0, '417855', '41.82.173.7', 'images/avatar/WhatsApp Image 2022-12-19 à 14.18.35.jpg', 'false', NULL, NULL, 'true', NULL),
(155, 'Vic3', 'Vic Hdudhsb Okeke', 'vicokeke.me@gmail.com', 0, 'san francisco', '333 fermont street', '941059', '08118552122', '$2y$10$3iWFOLKn65Jd52aR2o259eV.F7D3qIjplh4CzBUuuJSGA3kCB.yRe', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Retired', 'Manager', 'Welcome to Axostone', '$10,000 - $99,000', NULL, '', 0, '128623', '197.211.59.125', NULL, 'false', NULL, NULL, 'true', NULL),
(156, 'Ali', 'Ahamada ali', 'bazena976@gmail.com', 0, 'Entrepreneurs ', '32 rue Emiliano zapata ', '976564', '0693850467', '$2y$10$BW59niz1hkk.Im4ma1KQ3eVM8wm8RYfziKOXepixXh5yP6jCixpPi', 'subscriber', 'verified', 'true', 'images/avatar/11.png', 'Self employed', 'Travailleur indépendant ', 'Welcome to Axostone', '$500,000 and above', 'Friday 27th of January 2023 02:47:18 PM', '', 0, '976564', '77.143.42.121', 'images/avatar/Document PDF 3.pdf', 'false', NULL, NULL, 'true', NULL),
(157, 'QG boy', 'Djibery DIAWARA ', 'djiberydiawara@gmail.com', 0, 'Mali', 'Bamako', '1234', '97595733', '$2y$10$Cd/iSnYR9jZ8ffMMcyp7/.PMAaU5e95uRWBRcif2BLt8jMDy0bwQO', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Unemployed', 'Sell', 'Welcome to Axostone', '$10,000 - $99,000', 'Wednesday 21st of December 2022 07:06:25 PM', '', 0, '030670', '217.64.103.73', NULL, 'false', NULL, NULL, 'true', NULL),
(159, 'franck', 'teissier', 'teissierfranck.tsr@gmail.com', 0, 'Rognac', '15 impasse IV Montaigne', '13340', '+33624911117', '$2y$10$aambTRUwrAn9R7dFYp.55ef9m2EUo/RqpKoPIQzcEvuiEVwubDfCi', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Self employed', 'travailleur independant', 'Welcome to Axostone', '$10,000 - $99,000', 'Monday 30th of January 2023 07:30:36 PM', '', 0, '177914', '176.142.101.150', NULL, 'false', NULL, NULL, 'true', NULL),
(162, 'Jossua', 'Punuataahitua ', 'Jossua.punu@gmail.com', 0, 'Dijon', '30 bd maréchal joffre - Deflandre - GD5 n251', '21000', '0786167065', '$2y$10$DolcRCj5EHfWWVoSU/bLueeGMspKrE5XXsvcQRxS/lFGvq4jilXXu', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Employed', 'Trader', 'Welcome to Axostone', '$10,000 - $99,000', 'Tuesday 27th of December 2022 10:57:54 PM', '', 0, '329407', '176.144.119.124', NULL, 'false', NULL, NULL, 'true', NULL),
(166, NULL, NULL, 'bobowijaldi@gmail.com', 0, NULL, 'No address specified', NULL, NULL, '$2y$10$GRdx8.sr9YwCavww5ubCHeklitNAiVks486SIk8RlJ/1bP9WqCjJW', 'subscriber', 'verified', 'false', 'images/avatar/11.png', NULL, NULL, 'Welcome to Axostone', NULL, 'Friday 30th of December 2022 08:03:07 PM', '', 0, '774506', '188.27.146.198', NULL, 'false', NULL, NULL, 'true', NULL),
(167, 'Williams ', 'Gaspard Williams', 'williamsgaspard7@gmail.com', 0, 'Lubumbashi', '993129', '99312', '+243976764889', '$2y$10$8syGNNRagbIOs0zFtv8N8OucKUWhE7KxJuU4USrpA46lAMrZTbmlG', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Self employed', 'Independent ', 'Welcome to Axostone', '$10,000 - $99,000', 'Thursday 5th of January 2023 11:59:45 AM', '', 0, '336498', '45.221.7.12', NULL, 'false', NULL, NULL, 'true', NULL),
(169, 'Michael ', 'Gourouvin michael ', 'munee10@outlook.com', 0, 'St denis ', '32 allée des cotonniers ', '97400', '0692018012', '$2y$10$DszwAdGD9xPGzlECZRtbSOu1Bv34H7FpZcqjAes.hX/sN5ZRbVrti', 'subscriber', 'verified', 'true', 'images/avatar/11.png', 'Unemployed', 'Chômeur ', 'Welcome to Axostone', '$10,000 - $99,000', 'Friday 6th of January 2023 05:34:35 PM', '', 0, '634724', '154.67.133.90', 'images/avatar/1673022615424484852694987501854.jpg', 'false', NULL, NULL, 'true', NULL),
(170, 'XvirtualBlood', 'aurelien', 'xvirtualblood@gmail.com', 0, 'audincthun', '69 Rue Principale, Audincthun', '62560', '0622270366', '$2y$10$/XspN54G8NS1Px8JAmWP4e0WShggiCOb7o5yfzGWuzisVAyXBXR.K', 'subscriber', 'verified', 'true', 'images/avatar/11.png', 'Employed', 'mecano', 'Welcome to Axostone', '$10,000 - $99,000', 'Sunday 8th of January 2023 12:42:59 AM', '', 0, '618873', '82.65.13.81', 'images/avatar/received_557591485906481.jpg', 'false', NULL, NULL, 'true', NULL),
(171, 'Y', 'H', 'williamstexjack2003@gmail.com', 0, 'Th', 'Gh', '5778', '5880808688', '$2y$10$0GebZ5zeffZlkIY.Up10beE0jAKaIWr55Y7mH.VIwjuafShGvoCMK', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Self employed', 'Fgv', 'Welcome to Axostone', '$500,000 and above', 'Tuesday 24th of January 2023 09:04:20 PM', '', 0, '653697', '197.210.54.71', NULL, 'false', NULL, NULL, 'true', NULL),
(172, 'ConstantinS ', 'Silviu Constantin ', 'constantin.gmbh@icloud.com', 0, 'Susten ', 'Brückenmattenstrasse 3', '3952', '041784031938', '$2y$10$askRmr4jBOY.A9wTy8dpduP8YDTRFP5H27BViSpE7FgDD8z.a/Xpa', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Employed', 'Employés ', 'Welcome to Axostone', '$10,000 - $99,000', NULL, '', 0, '416284', '62.167.78.204', NULL, 'false', NULL, NULL, 'true', NULL),
(173, 'KekkoStyle', 'francescoarboleo', 'francescoarboleo100@gmail.com', 0, 'Barletta ', 'Boggiano ', '76122', '3208477056', '$2y$10$yeUtKll.A6ztWCzWNKZ9Ae/s.Oj4.1FqDjk6yfC8vbkZv9tODNEHi', 'subscriber', 'verified', 'true', 'images/avatar/11.png', 'Unemployed', 'Diploma ', 'Welcome to Axostone', '$10,000 - $99,000', 'Friday 27th of January 2023 03:37:28 AM', '', 0, '127406', '95.74.207.125', 'images/avatar/inbound542025350021864333.jpg', 'false', NULL, NULL, 'true', NULL),
(174, 'Sylla18', 'Sylla Mamadou', 'S.mamadou0001@gmail.com', 0, 'Abidjan', '00225Abidjan', '22500225', '0789601757', '$2y$10$GUNaJJppDZVRYdT65f8K5ugYfE5.bUrNgM3Ksc6KJMFmkYaAfwhvG', 'subscriber', 'verified', 'true', 'images/avatar/11.png', 'Unemployed', 'sans emploi', 'Welcome to Axostone', '$500,000 and above', 'Wednesday 11th of January 2023 01:50:53 PM', '', 0, '112308', '160.154.233.90', 'images/avatar/WhatsApp Image 2023-01-11 at 10.23.20 (1).jpeg', 'false', NULL, NULL, 'true', NULL),
(175, 'Gid10', 'Akakpo folly Gildas ', 'gidasfollyakakpo@gmail.com', 0, 'Lomé togo', 'Lomé ', '228', '0022891288802', '$2y$10$QGXiZ/kThgFjpIfhzv5/AO9l6V8tzQaolhIOyQc//ThIOQfxTD1LW', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Self employed', 'Revendeur', 'Welcome to Axostone', '$10,000 - $99,000', 'Friday 13th of January 2023 07:57:27 AM', '', 0, '131988', '156.38.89.71', NULL, 'false', NULL, NULL, 'true', NULL),
(176, 'Gianluca390', 'Chiavetta gianluca', 'degianlu27@hotmail.it', 0, 'Pescara', 'Strada Vertonica', '65013', '3203907221', '$2y$10$wWPz6qVsT2ROa165wbECwudKf24cqIzp/LWYNIxQP94A60r6zeoXK', 'subscriber', 'verified', 'true', 'images/avatar/11.png', '', 'Operaio', 'Welcome to Axostone', '$500,000 and above', 'Thursday 26th of January 2023 07:25:46 PM', '', 0, '488964', '146.241.64.193', 'images/avatar/2022-11-01.jpg', 'false', NULL, NULL, 'true', NULL),
(177, 'Ndrelalaj ', 'Christian', 'christian04gool@libero.it', 0, 'Crevalcore', 'Christian02gool@icloud.com', '40014', '3475546905', '$2y$10$kkL8ZK.ciktTix/b8jsni.mr6FIBrNsNNIgym2eBZnjo1ps6GzI5y', 'subscriber', 'verified', 'true', 'images/avatar/11.png', 'Employed', 'Investitore', 'Welcome to Axostone', '$10,000 - $99,000', 'Monday 16th of January 2023 10:04:03 AM', '', 0, '589706', '5.90.254.12', 'images/avatar/image.jpg', 'false', NULL, NULL, 'true', NULL),
(178, 'Spartan733', 'Balmain Jérémy ', 'bmwman73@hotmail.fr', 0, 'SÉRÉZIN DU RHÔNE ', '6b allée des charmilles ', '69360', '0666675738', '$2y$10$T.AvtarOJRQOyc.EW2FZ2OVh8PtaxuSCe.jhO7ZYsVQwOD9tGnD5O', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Employed', 'Chargé d’affaires ', 'Welcome to Axostone', '$10,000 - $99,000', 'Sunday 29th of January 2023 07:53:50 PM', '', 0, 'kJdQcrZE', '88.166.102.56', NULL, 'false', NULL, NULL, '1', NULL),
(180, 'Tores', 'Sam', 'bearcrypto66@gmail.com', 0, 'Uk', 'Uk', '560469', '06883572', '$2y$10$Yab92HmYPvWxhxnJlNtudOehgPw9LlOLb6AaSPuHcP5Yke1M5Fqmy', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Retired', 'Boss', 'Welcome to Axostone', '$10,000 - $99,000', 'Saturday 21st of January 2023 05:04:45 PM', '', 0, '537771', '105.112.166.222', NULL, 'false', NULL, NULL, 'true', NULL),
(182, 'Theo 34', 'Regus Theo', 'regustheo@gmail.com', 0, 'Moldova ', 'Strata copiilor', '7326', '758959375', '$2y$10$fgU5s.FhpIqUA4DZU94i3.MBXAfGeFfIHbbKwnw32s6HWV18/EUDW', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Employed', 'Windows maker ', 'Welcome to Axostone', '$10,000 - $99,000', 'Wednesday 18th of January 2023 07:23:52 PM', '', 0, '688227', '185.237.103.30', NULL, 'false', NULL, NULL, 'true', NULL),
(183, 'LeStef', 'Stephane Bourguignon', 'bourguignon.stephane1@gmail.com', 0, 'Cergy', '3 A les touleuses mauves ', '95000', '0783280718', '$2y$10$KTBrRXusyiPSYp3OYaXOQOvgmRxwfj0D5dnPtdhjNNbPFNq.P6ZPK', 'subscriber', 'verified', 'true', 'images/avatar/11.png', 'Employed', 'GESTIONNAIRE DE PAIE', 'Welcome to Axostone', '$10,000 - $99,000', 'Monday 23rd of January 2023 09:39:56 PM', '', 0, '668276', '62.35.113.233', 'images/avatar/3F014F79-8AAA-4FD7-B3E5-8D047C426000.jpeg', 'false', NULL, NULL, 'true', NULL),
(184, 'Pragmagolf', 'De la Poëze Charles ', 'charlesdelapoeze2@gmail.com', 0, 'Villiers sur orge', '7 bis rue des allouettes', '91700', '0624265895', '$2y$10$QrzyDK20yhU1yvuhNeGXOudJBhXTjo2nqhBns9mYEbB3EL.ZoUyQO', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Self employed', 'Coach de golf ', 'Welcome to Axostone', '$10,000 - $99,000', 'Monday 23rd of January 2023 03:22:13 PM', '', 0, 'TwYOzabe', '45.15.61.81', NULL, 'false', NULL, NULL, 'true', NULL),
(186, 'Zelephgg', 'Gatsinzi claudien ', 'gatsinzi.08@gmail.com', 0, 'Dunkerque', '15 Avenue Kléber\r\n1', '59240', '0623261540', '$2y$10$v/ZNbBpiGfeQTFkREQVAhe.9EU4SVk3gK3AB/e4a4qOKj3lCZNNsS', 'subscriber', 'verified', 'pending', 'images/avatar/11.png', 'Employed', 'Chauffeur ', 'Welcome to Axostone', '$10,000 - $99,000', 'Saturday 28th of January 2023 01:02:58 PM', '', 0, '813344', '77.130.124.167', 'images/avatar/20211030_220341.jpg', 'false', NULL, NULL, 'true', NULL),
(189, 'Azaty228', 'EDOUARD ', 'J.edouard228@gmail.com', 0, 'Sainte Luce', 'Quartier Délivry', '97228', '0696936808', '$2y$10$jzUU0iEnlhRavisyu/xydueuBlLEdRACRl.gN1scBRfIERVqFH0.2', 'subscriber', 'verified', 'false', 'images/avatar/11.png', '', 'Mécanicien ', 'Welcome to Axostone', '$10,000 - $99,000', 'Sunday 29th of January 2023 09:07:33 PM', '', 0, '014346', '92.144.196.131', NULL, 'false', NULL, NULL, 'true', NULL),
(190, 'JR', 'Junnior Daniel', 'junniordaniel2@gmail.com', 0, 'México ', 'No se', 'No se', '7442401389', '$2y$10$MaXK/P6vVxmo5MfQ3oca1.ETVK1T1riO8ZjQnzYEzX5IEzjn4S/.S', 'subscriber', 'verified', 'false', 'images/avatar/11.png', 'Employed', 'Junnior Daniel', 'Welcome to Axostone', '$10,000 - $99,000', 'Monday 30th of January 2023 03:43:09 AM', '', 0, '850926', '189.143.225.96', NULL, 'false', NULL, NULL, 'true', 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `config` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `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;

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

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

CREATE TABLE `user_activities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `transaction_id` int(11) NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `portifolio_name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'null',
  `date` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `user_activities` (`id`, `user_id`, `transaction_id`, `description`, `portifolio_name`, `amount`, `status`, `date`) VALUES
(122, 119, 0, 'New portfolio created', 'Vic okeke', '5000', 'null', 'Saturday 30th of July 2022'),
(123, 119, 122, 'new deposit of $1000', '', '1000', 'null', 'Friday 4th of November 2022'),
(124, 119, 123, 'new deposit of $1000', '', '1000', 'null', 'Friday 4th of November 2022'),
(125, 119, 124, 'new deposit of $1000', '', '1000', 'null', 'Friday 4th of November 2022'),
(126, 119, 125, 'new deposit of $2000', '', '2000', 'null', 'Friday 4th of November 2022'),
(127, 119, 126, 'new deposit of $1000', '', '1000', 'null', 'Friday 4th of November 2022'),
(128, 119, 127, 'new deposit of $1000', 'My wallet', '1000', 'null', 'Friday 4th of November 2022'),
(129, 119, 128, 'new deposit of $10', '', '10', 'null', 'Friday 4th of November 2022'),
(130, 119, 129, 'new deposit of $10', '', '10', 'null', 'Friday 4th of November 2022'),
(131, 119, 130, 'new deposit of $10', 'Vic okeke', '10', 'null', 'Friday 4th of November 2022'),
(132, 119, 131, 'new deposit of $10', 'Vic okeke', '10', 'null', 'Friday 4th of November 2022'),
(133, 119, 132, 'new deposit of $10', 'Vic okeke', '10', 'null', 'Friday 4th of November 2022'),
(134, 119, 133, 'new deposit of $2', 'Vic okeke', '2', 'null', 'Friday 4th of November 2022'),
(135, 121, 134, 'new deposit of $5000', 'Wallet', '5000', 'null', 'Thursday 17th of November 2022'),
(136, 121, 135, 'new deposit of $5000', 'Wallet', '5000', 'null', 'Thursday 17th of November 2022'),
(137, 121, 136, 'new deposit of $5000', 'Wallet', '5000', 'null', 'Thursday 17th of November 2022'),
(138, 121, 137, 'new deposit of $5000', 'Wallet', '5000', 'null', 'Thursday 17th of November 2022'),
(142, 123, 141, 'new deposit of $199', 'Wallet', '250', 'null', 'Friday 18th of November 2022'),
(143, 131, 142, 'new deposit of $80', 'Wallet', '80', 'null', 'Tuesday 22nd of November 2022'),
(144, 131, 143, 'new deposit of $80', 'Wallet', '80', 'null', 'Tuesday 22nd of November 2022'),
(145, 139, 144, 'new deposit of $0', 'Wallet', '0', 'null', 'Sunday 27th of November 2022'),
(155, 145, 154, 'new deposit of $140', 'mr tiktok', '140', 'null', 'Wednesday 14th of December 2022'),
(161, 145, 160, 'new deposit of $153', 'Wallet', '153', 'null', 'Wednesday 14th of December 2022'),
(164, 145, 163, 'new deposit of $153', 'mr tiktok', '153', 'null', 'Wednesday 14th of December 2022'),
(165, 145, 164, 'new deposit of $6.00', 'Wallet', '6.00', 'null', 'Wednesday 14th of December 2022'),
(166, 145, 165, 'new deposit of $9', 'Wallet', '9', 'null', 'Wednesday 14th of December 2022'),
(167, 145, 166, 'new deposit of $9', 'Wallet', '9', 'null', 'Wednesday 14th of December 2022'),
(172, 146, 171, 'new deposit of $100', 'Wallet', '100', 'null', 'Wednesday 14th of December 2022'),
(173, 146, 172, 'new deposit of $100', 'Wallet', '100', 'null', 'Wednesday 14th of December 2022'),
(174, 156, 173, 'new deposit of $100', 'Wallet', '100', 'null', 'Monday 19th of December 2022'),
(175, 156, 174, 'new deposit of $300', 'Wallet', '300', 'null', 'Tuesday 20th of December 2022'),
(176, 156, 175, 'new deposit of $300', 'Wallet', '300', 'null', 'Tuesday 20th of December 2022'),
(177, 156, 176, 'new deposit of $300', 'Wallet', '300', 'null', 'Tuesday 20th of December 2022'),
(178, 156, 177, 'new deposit of $300', 'Wallet', '300', 'null', 'Tuesday 20th of December 2022'),
(179, 156, 178, 'new deposit of $300', 'Wallet', '300', 'null', 'Tuesday 20th of December 2022'),
(180, 156, 179, 'new deposit of $300', 'Wallet', '300', 'null', 'Tuesday 20th of December 2022'),
(181, 156, 180, 'new deposit of $300', 'Wallet', '300', 'null', 'Tuesday 20th of December 2022'),
(182, 156, 181, 'new deposit of $300', 'Wallet', '300', 'null', 'Tuesday 20th of December 2022'),
(183, 156, 182, 'new deposit of $300', 'Wallet', '300', 'null', 'Tuesday 20th of December 2022'),
(184, 156, 183, 'new deposit of $300', 'Wallet', '300', 'null', 'Tuesday 20th of December 2022'),
(185, 156, 184, 'new deposit of $300', 'Wallet', '300', 'null', 'Tuesday 20th of December 2022'),
(186, 156, 185, 'new deposit of $300', 'Wallet', '300', 'null', 'Tuesday 20th of December 2022'),
(187, 156, 186, 'new deposit of $300', 'Wallet', '300', 'null', 'Tuesday 20th of December 2022'),
(188, 156, 187, 'new deposit of $300', 'Wallet', '300', 'null', 'Tuesday 20th of December 2022'),
(189, 156, 188, 'new deposit of $300', 'Wallet', '300', 'null', 'Tuesday 20th of December 2022'),
(190, 156, 189, 'new deposit of $100', 'Wallet', '100', 'null', 'Tuesday 20th of December 2022'),
(191, 156, 190, 'new deposit of $100', 'Wallet', '100', 'null', 'Tuesday 20th of December 2022'),
(192, 156, 191, 'new deposit of $100', 'Wallet', '100', 'null', 'Tuesday 20th of December 2022'),
(193, 156, 192, 'new deposit of $100', 'Wallet', '100', 'null', 'Tuesday 20th of December 2022'),
(194, 156, 193, 'new deposit of $100', 'Wallet', '100', 'null', 'Tuesday 20th of December 2022'),
(195, 156, 194, 'new deposit of $100', 'Wallet', '100', 'null', 'Tuesday 20th of December 2022'),
(197, 145, 196, 'new deposit of $2', 'Wallet', '2', 'null', 'Tuesday 20th of December 2022'),
(198, 159, 197, 'new deposit of $50', 'Wallet', '50', 'null', 'Wednesday 21st of December 2022'),
(199, 159, 198, 'new deposit of $70', 'Wallet', '70', 'null', 'Wednesday 21st of December 2022'),
(205, 159, 204, 'new deposit of $110', 'Wallet', '110', 'null', 'Wednesday 21st of December 2022'),
(206, 159, 205, 'new deposit of $70', 'Wallet', '70', 'null', 'Wednesday 21st of December 2022'),
(207, 156, 206, 'new deposit of $100', 'Wallet', '100', 'null', 'Saturday 24th of December 2022'),
(210, 145, 209, 'new deposit of $2', 'mr tiktok', '2', 'null', 'Wednesday 28th of December 2022'),
(212, 145, 211, 'new deposit of $9', 'Wallet', '9', 'null', 'Thursday 29th of December 2022'),
(213, 145, 212, 'new deposit of $4', 'Wallet', '4', 'null', 'Thursday 29th of December 2022'),
(215, 159, 214, 'new deposit of $250', 'Wallet', '250', 'null', 'Thursday 5th of January 2023'),
(216, 169, 215, 'new deposit of $300', 'Wallet', '300', 'null', 'Friday 6th of January 2023'),
(229, 145, 228, 'new deposit of $200', 'Wallet', '200', 'null', 'Tuesday 10th of January 2023'),
(230, 145, 229, 'new deposit of $100', 'Wallet', '100', 'null', 'Tuesday 10th of January 2023'),
(239, 159, 238, 'new deposit of $570', 'Wallet', '570', 'null', 'Saturday 14th of January 2023'),
(240, 176, 239, 'new deposit of $1000', 'Wallet', '1000', 'null', 'Saturday 14th of January 2023'),
(241, 145, 240, 'new deposit of $233', 'Wallet', '233', 'null', 'Monday 16th of January 2023'),
(242, 176, 241, 'new deposit of $10.00', 'Wallet', '10.00', 'null', 'Monday 16th of January 2023'),
(243, 176, 242, 'new deposit of $1000', 'Wallet', '1000', 'null', 'Monday 16th of January 2023'),
(244, 178, 243, 'new deposit of $359', 'Wallet', '359', 'null', 'Monday 16th of January 2023'),
(246, 178, 245, 'new deposit of $350', 'Wallet', '350', 'null', 'Tuesday 17th of January 2023'),
(248, 178, 247, 'Apexbot purchase', 'Wallet', '4000', 'null', 'Tuesday 17th of January 2023'),
(249, 180, 248, 'new deposit of $347', 'Fr', '347', 'null', 'Tuesday 17th of January 2023'),
(250, 178, 249, 'Apexbot purchase', 'Wallet', '4000', 'null', 'Tuesday 17th of January 2023'),
(251, 178, 250, 'new deposit of $550', 'portfeuil spartan', '550', 'null', 'Tuesday 17th of January 2023'),
(252, 178, 251, 'new deposit of $132', 'portfeuil spartan', '132', 'null', 'Tuesday 17th of January 2023'),
(253, 178, 250, 'new deposit of $550', 'Jb', '550', 'null', 'Wednesday 18th of January 2023'),
(254, 178, 251, 'new deposit of $132', 'Jb', '132', 'null', 'Wednesday 18th of January 2023'),
(255, 178, 250, 'new deposit of $682', 'Tt', '682', 'null', 'Sunday 22nd of January 2023'),
(256, 173, 251, 'new deposit of $100', 'Wallet', '100', 'null', 'Friday 27th of January 2023'),
(257, 173, 252, 'new deposit of $100', 'Wallet', '100', 'null', 'Friday 27th of January 2023'),
(258, 173, 253, 'new deposit of $100', 'Wallet', '100', 'null', 'Friday 27th of January 2023');

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

--
-- 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_value` varchar(191) 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 `verify_tokens`
--

CREATE TABLE `verify_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `verify` 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 `withdraw_methods`
--

CREATE TABLE `withdraw_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `desc` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `min_amount` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `config` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `fees` text COLLATE utf8mb4_unicode_ci,
  `currencies` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `countries` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `bots`
--
ALTER TABLE `bots`
  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 `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 `login_histories`
--
ALTER TABLE `login_histories`
  ADD PRIMARY KEY (`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 `portifolios`
--
ALTER TABLE `portifolios`
  ADD PRIMARY KEY (`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 KEY `transactions_user_id_index` (`user_id`);

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

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

--
-- Indexes for table `verify_tokens`
--
ALTER TABLE `verify_tokens`
  ADD PRIMARY KEY (`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=173;

--
-- AUTO_INCREMENT for table `bank_transfer`
--
ALTER TABLE `bank_transfer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `bos`
--
ALTER TABLE `bos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bots`
--
ALTER TABLE `bots`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

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

--
-- 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=30;

--
-- 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 `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 for table `login_histories`
--
ALTER TABLE `login_histories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- 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=17;

--
-- AUTO_INCREMENT for table `portifolios`
--
ALTER TABLE `portifolios`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=120;

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `withdraw_methods`
--
ALTER TABLE `withdraw_methods`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
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 */;
Back to Directory=ceiIENDB`