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

START TRANSACTION;



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

--
-- Table structure for table `deposit`
--

CREATE TABLE `deposit` (
  `id` int(11) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `method` varchar(255) NOT NULL,
  `plan` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `userId` int(11) NOT NULL,
  `deposit_image` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'PENDING',
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `deposit`
--

INSERT INTO `deposit` (`id`, `amount`, `method`, `plan`, `email`, `userId`, `deposit_image`, `status`, `date`) VALUES
(76, '500', 'Tether TRC20', 'Starter Plan', 'user@mail.com', 13, '', 'PENDING', '01-06-2024 09:39:14pm'),
(77, '10000', 'Bitcoin', 'Ultimate Plan', 'user@mail.com', 13, '', 'PENDING', '01-06-2024 09:39:43pm'),
(78, '2500', 'Bitcoin', 'VIP Plan', 'user@mail.com', 13, '', 'PENDING', '01-06-2024 09:40:11pm'),
(79, '500', 'Bitcoin', 'Starter Plan', 'user@mail.com', 13, '', 'PENDING', '02-06-2024 05:37:32pm'),
(80, '500', 'Tether ERC20', 'Starter Plan', 'user@mail.com', 13, '', 'COMPLETED', '02-06-2024 05:55:42pm'),
(83, '10000', 'Tether ERC20', 'Ultimate Plan', 'user@mail.com', 23, '', 'PENDING', '15-06-2024 12:34:06pm'),
(84, '10000', 'Bitcoin', 'Ultimate Plan', 'user@mail.com', 23, '', 'PENDING', '15-06-2024 12:34:51pm'),
(85, '500', 'Bitcoin', 'Starter Plan', 'user@mail.com', 23, '', 'PENDING', '15-06-2024 12:36:55pm'),
(86, '500', 'Bitcoin', 'Starter Plan', 'user@mail.com', 23, '', 'PENDING', '15-06-2024 12:37:13pm'),
(87, '10000', 'Bitcoin', 'Ultimate Plan', 'user@mail.com', 23, '', 'PENDING', '15-06-2024 01:02:58pm'),
(88, '500', 'Bitcoin', 'Starter Plan', 'user@mail.com', 23, '', 'PENDING', '15-06-2024 01:06:08pm'),
(90, '10000', 'Bitcoin', 'Ultimate Plan', 'user@mail.com', 23, '666d91a3a89d7.png', 'COMPLETED', '15-06-2024 03:05:39pm'),
(93, '10000', 'Ethereum', 'Ultimate Plan', 'sofolast@gmail.com', 34, '66740624961ee.png', 'COMPLETED', '2024-06-20 10:36:20'),
(94, '10000', 'Bitcoin', 'Ultimate Plan', 'sofolast@gmail.com', 34, '6674176441ff0.png', 'COMPLETED', '2024-06-20 11:49:56'),
(95, '500', 'Litecoin', 'Starter Plan', 'user@mail.com', 23, '66742abc3ba8c.png', 'COMPLETED', '2024-06-20 13:12:28'),
(96, '1000', 'Bitcoin', 'Starter Plan', 'user@mail.com', 23, '6674331892bb4.png', 'COMPLETED', '2024-06-20 13:48:08'),
(97, '700', 'Bitcoin', 'Starter Plan', 'user@mail.com', 23, '6674346773ccd.png', 'COMPLETED', '2024-06-20 13:53:43'),
(98, '100000', 'Litecoin', 'Ultimate Plan', 'user@mail.com', 23, '667434d8e906e.png', 'COMPLETED', '2024-06-20 13:55:36'),
(99, '1000000000', 'Ethereum', 'Ultimate Plan', 'sofolast@gmail.com', 34, '6674367e48e5f.png', 'COMPLETED', '2024-06-20 14:02:38'),
(100, '100000', 'Bitcoin', 'Ultimate Plan', 'fred200512128@gmail.com', 39, '6674487c19879.png', 'COMPLETED', '2024-06-20 15:19:24'),
(101, '10000', 'Bitcoin', 'Ultimate Plan', 'sofolast@gmail.com', 34, '66759f389d85b.png', 'COMPLETED', '2024-06-21 15:41:44'),
(102, '100000', 'Bitcoin', 'Ultimate Plan', 'sofolast@gmail.com', 34, '6676936f5c136.png', 'COMPLETED', '2024-06-22 09:03:43'),
(103, '10000', 'Litecoin', 'Ultimate Plan', 'sofolast@gmail.com', 34, '66769a84d7fe4.png', 'COMPLETED', '2024-06-22 09:33:56'),
(104, '10000', 'Litecoin', 'Ultimate Plan', 'sofolast@gmail.com', 34, '6678049d61469.png', 'COMPLETED', '2024-06-23 11:18:53'),
(105, '10000', 'Bitcoin', 'Ultimate Plan', 'sofolast@gmail.com', 34, '6679d44bca057.png', 'COMPLETED', '2024-06-24 20:17:15'),
(106, '10000', 'Litecoin', 'Ultimate Plan', 'sofolast@gmail.com', 34, '667a62f3d0f0f.png', 'COMPLETED', '2024-06-25 06:25:55'),
(107, '10000', 'Litecoin', 'Ultimate Plan', 'sofolast@gmail.com', 34, '667a65ff8f4e4.png', 'COMPLETED', '2024-06-25 06:38:55'),
(108, '10000', 'Litecoin', 'Ultimate Plan', 'sofolast@gmail.com', 34, '6682508be8488.png', 'COMPLETED', '2024-07-01 06:45:31'),
(109, '10000', 'Ethereum', 'Ultimate Plan', 'user@mail.com', 23, '66883fbfc2947.png', 'COMPLETED', '2024-07-05 18:47:27');

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

--
-- Table structure for table `plans`
--

CREATE TABLE `plans` (
  `id` int(11) NOT NULL,
  `pname` varchar(255) NOT NULL,
  `increase` double NOT NULL,
  `duration` int(11) NOT NULL,
  `min_amt` varchar(255) NOT NULL,
  `max_amt` varchar(255) NOT NULL,
  `principal_return` enum('Yes','No','','') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `plans` (`id`, `pname`, `increase`, `duration`, `min_amt`, `max_amt`, `principal_return`) VALUES
(1, 'Starter Plan', 4, 9, '500', '1000', 'Yes'),
(4, 'VVIP Plan', 3, 2, '5000', '10000', 'Yes'),
(5, 'Ultimate Plan', 7, 1, '10000', '10000000000', 'Yes'),
(6, 'Premium  Plan', 5, 7, '2000', '5000', 'Yes');

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

--
-- Table structure for table `transfer_history`
--

CREATE TABLE `transfer_history` (
  `id` int(11) NOT NULL,
  `userId` varchar(255) NOT NULL,
  `transaction_id` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `user_account_number` varchar(255) NOT NULL,
  `user_bank_name` varchar(255) NOT NULL,
  `user_account_name` varchar(255) NOT NULL,
  `rec_account_number` varchar(255) NOT NULL,
  `rec_bank_name` varchar(255) NOT NULL,
  `rec_account_name` varchar(255) NOT NULL,
  `bank_country` varchar(255) DEFAULT NULL,
  `routine_number` varchar(255) DEFAULT NULL,
  `details` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'Processing',
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transfer_history`
--

INSERT INTO `transfer_history` (`id`, `userId`, `transaction_id`, `email`, `amount`, `type`, `user_account_number`, `user_bank_name`, `user_account_name`, `rec_account_number`, `rec_bank_name`, `rec_account_name`, `bank_country`, `routine_number`, `details`, `status`, `date`) VALUES
(71, '23', '0644378', 'user@mail.com', '60', 'International Transfer', '2147483647', 'invest wise', 'user test', '21474836474345353', 'pay trust', 'mike owen', 'Aruba', NULL, NULL, 'Processing', '14-06-2024 01:27:22pm'),
(72, '23', '0644378', 'user@mail.com', '60', 'Wire Transfer', '2147483647', 'invest wise', 'user test', '21474836474345353', 'pay trust', 'mike owen', 'Aruba', NULL, NULL, 'Declined', '14-06-2024 01:27:22pm'),
(73, '23', '0633673', 'user@mail.com', '10', 'International Transfer', '2147483647', 'invest wise', 'user test', '22352352364', 'invest wise', 'mike owen', 'Andorra', NULL, NULL, 'Processing', '14-06-2024 02:50:16pm'),
(74, '23', '', 'user@mail.com', '10', 'International Transfer', '2147483647', 'invest wise', 'user test', '22352352364', 'invest wise', 'mike owen', 'Andorra', NULL, NULL, 'Processing', '14-06-2024 02:50:16pm'),
(75, '23', '', 'user@mail.com', '10', 'International Transfer', '2147483647', 'invest wise', 'user test', '22352352364', 'invest wise', 'mike owen', 'Andorra', NULL, NULL, 'Processing', '14-06-2024 02:50:16pm'),
(76, '23', '0633673', 'user@mail.com', '10', 'International Transfer', '2147483647', 'invest wise', 'user test', '22352352364', 'invest wise', 'mike owen', 'Andorra', NULL, NULL, 'Processing', '14-06-2024 02:50:16pm'),
(77, '23', '0633673', 'user@mail.com', '10', 'International Transfer', '2147483647', 'invest wise', 'user test', '22352352364', 'invest wise', 'mike owen', 'Andorra', NULL, NULL, 'Processing', '14-06-2024 02:50:16pm'),
(78, '23', '0633673', 'user@mail.com', '10', 'International Transfer', '2147483647', 'invest wise', 'user test', '22352352364', 'invest wise', 'mike owen', 'Andorra', NULL, NULL, 'Processing', '14-06-2024 02:50:16pm'),
(79, '23', '0633673', 'user@mail.com', '10', 'International Transfer', '2147483647', 'invest wise', 'user test', '22352352364', 'invest wise', 'mike owen', 'Andorra', NULL, NULL, 'Processing', '14-06-2024 02:50:16pm'),
(80, '23', '0685485', 'user@mail.com', '20', 'International Transfer', '2147483647', 'invest wise', 'user test', '21474836474345353', 'pay trust', 'mike smith', 'Ghana', NULL, NULL, 'Processing', '14-06-2024 02:57:44pm'),
(81, '23', '0697408', 'user@mail.com', '60', 'Wire Transfer', '2147483647', 'invest wise', 'user test', '21474836478', 'pay trust', 'mike smith', 'Aruba', NULL, NULL, 'Processing', '14-06-2024 03:19:51pm'),
(82, '23', '0604515', 'user@mail.com', '60', 'International Transfer', '2147483647', 'invest wise', 'user test', '21474836478', 'pay trust', 'owen smith', 'Bahamas', NULL, NULL, 'Processing', '14-06-2024 03:21:18pm'),
(83, '23', '0668990', 'user@mail.com', '3', 'International Transfer', '2147483647', 'invest wise', 'user test', '634634636346', 'invest', 'mike smith', 'Bahrain', NULL, NULL, 'Processing', '14-06-2024 03:22:12pm'),
(84, '23', '0616819', 'user@mail.com', '100', 'Wire Transfer', '2147483647', 'invest wise', 'user test', '21474836478s', 'invest wise', 'owen smith', 'Bahamas', NULL, NULL, 'Processing', '14-06-2024 03:24:55pm'),
(85, '23', '061769723', 'user@mail.com', '60', 'Local Transfer', '2147483647', 'invest wise', 'user test', '21474836474534534', 'pay trust', 'owen smith', NULL, NULL, 'cvbcvbc', 'Processing', '14-06-2024 03:31:43pm'),
(86, '23', '060025331', 'user@mail.com', '60', 'Local Transfer', '2147483647', 'invest wise', 'user test', '21474836474345353', 'pay trust', 'owen smith', NULL, NULL, 'fdg', 'Processing', '14-06-2024 03:33:00pm'),
(87, '23', '068745125', 'user@mail.com', '1000', 'Local Transfer', '2147483647', 'invest wise', 'user test', '21474836474345353', 'invest wise', 'owen smith', NULL, NULL, 'scds', 'Processing', '14-06-2024 03:33:45pm'),
(88, '23', '063517012', 'user@mail.com', '1000', 'Local Transfer', '2147483647', 'invest wise', 'user test', '21474836474345353', 'invest wise', 'mike owen', NULL, NULL, 'dfsfs', 'Processing', '14-06-2024 03:34:39pm'),
(89, '23', '0661481', 'user@mail.com', '1000', 'Local Transfer', '2147483647', 'invest wise', 'user test', '2147483647', 'invest wise', 'mike smith', NULL, NULL, '', 'Processing', '14-06-2024 03:35:53pm'),
(90, '23', '0694196', 'user@mail.com', '10', 'Local Transfer', '2147483647', 'invest wise', 'user test', '24235346', 'invest wise', 'mike', NULL, NULL, '', 'Processing', '17-06-2024 01:00:34pm'),
(91, '23', '0661206', 'user@mail.com', '100000', 'Local Transfer', '2147483647', 'invest wise', 'user test', '3454366', 'invest wise', 'mike', NULL, NULL, '', 'Processing', '17-06-2024 01:12:41pm'),
(92, '23', '0656195', 'user@mail.com', '1000', 'Local Transfer', '2147483647', 'invest wise', 'user test', '2534543', 'invest wise', 'mike', NULL, NULL, '', 'Processing', '17-06-2024 01:49:19pm'),
(93, '23', '063003578', 'user@mail.com', '10', 'Local Transfer', '2147483647', 'invest wise', 'user test', '324235235235232352322523232', 'sdfsaf', 'fdgdfdfgddf', NULL, NULL, 'dfgdfgd', 'Processing', '19-06-2024 08:46:19am'),
(94, '23', '063003578', 'user@mail.com', '10', 'Local Transfer', '2147483647', 'invest wise', 'user test', '324235235235232352322523232', 'sdfsaf', 'fdgdfdfgddf', NULL, NULL, 'dfgdfgd', 'Processing', '19-06-2024 08:46:19am'),
(95, '23', '063003578', 'user@mail.com', '10', 'Local Transfer', '2147483647', 'invest wise', 'user test', '324235235235232352322523232', 'sdfsaf', 'fdgdfdfgddf', NULL, NULL, 'dfgdfgd', 'Completed', '19-06-2024 08:46:19am'),
(101, '34', '0685671', 'sofolast@gmail.com', '100', 'Wire Transfer', '2147483647', 'invest wise', 'mike smith', '2147483647435', 'pay trust', 'user', 'Australia', NULL, NULL, 'Processing', '20-06-2024 10:57:53am'),
(102, '34', '0634449', 'sofolast@gmail.com', '100', 'Credit', '1234242532553', 'my new bank', 'jack smith', '2147483647', 'invest wise', 'mike smith', 'Dominican Republic', NULL, 'for your payment', 'COMPLETED', '2024-06-20T14:24'),
(103, '23', '06576', 'user@mail.com', '500', 'Local Transfer', '1234567890', 'invest wise', 'user test', '2147483647', 'invest wise', 'DFDSFSFFSDFSDF', NULL, NULL, '', 'Processing', '20-06-2024 01:43:39pm'),
(104, '34', '06796', 'sofolast@gmail.com', '10000', 'Local Transfer', '2147483647', 'invest wise', 'mike smith', '1234567890', 'invest wise', 'user test', NULL, NULL, '', 'Processing', '23-06-2024 04:48:46pm'),
(105, '34', '06886', 'sofolast@gmail.com', '1000', 'Local Transfer', '2147483647', 'invest wise', 'mike smith', '1234567890', 'invest wise', 'user test', NULL, NULL, '', 'Processing', '23-06-2024 04:54:33pm'),
(106, '34', '06877', 'sofolast@gmail.com', '100000', 'Local Transfer', '2147483647', 'invest wise', 'mike smith', '1234567890', 'invest wise', 'user test', NULL, NULL, '', 'Processing', '23-06-2024 05:30:39pm'),
(107, '34', '06159', 'sofolast@gmail.com', '1000000', 'Local Transfer', '2147483647', 'invest wise', 'mike smith', '1234567890', 'invest wise', 'user test', NULL, NULL, '', 'Processing', '23-06-2024 05:38:16pm'),
(108, '34', '06407', 'sofolast@gmail.com', '10000', 'Local Transfer', '2147483647', 'invest wise', 'mike smith', '1234567890', 'invest wise', 'user test', NULL, NULL, '', 'Processing', '23-06-2024 05:41:17pm'),
(109, '23', '071559648', 'user@mail.com', '600', 'Local Transfer', '1234567890', 'invest wise', 'user test', '989887876777', 'dre', 'des', NULL, NULL, 'derr', 'Processing', '05-07-2024 07:06:15pm'),
(110, '23', '0739591', 'user@mail.com', '70', 'Wire Transfer', '1234567890', 'invest wise', 'user test', '9898887776', 'dre', 'des', 'Antigua and Barbuda', NULL, NULL, 'Processing', '05-07-2024 07:06:58pm'),
(111, '23', '07589', 'user@mail.com', '1000', 'Local Transfer', '1234567890', 'invest wise', 'user test', '23070289615', 'invest wise', 'Emeka Ene', NULL, NULL, '', 'Completed', '05-07-2024 07:20:15pm'),
(112, '40', '0749821', 'gseun129@gmail.com', '4500', 'domestic Transfer', '23070289615', 'Desmond BB', 'Emeka Ene', '23070289615', 'invest wise', 'Emeka Ene', NULL, NULL, 'Credited Today', 'Processing', '2024-07-05T00:00'),
(113, '23', '07171', 'user@mail.com', '500', 'Local Transfer', '1234567890', 'invest wise', 'user test', '23070289615', 'invest wise', 'Emeka Ene', NULL, NULL, '', 'Processing', '07-07-2024 12:36:24am'),
(114, '34', '07051', 'sofolast@gmail.com', '1000', 'Local Transfer', '2147483647', 'invest wise', 'mike smith', '23065918070', 'invest wise', 'mark james', NULL, NULL, '', 'Processing', '07-07-2024 04:23:48pm'),
(115, '34', '07058', 'sofolast@gmail.com', '2000', 'Local Transfer', '2147483647', 'invest wise', 'mike smith', '23065918070', 'invest wise', 'mark james', NULL, NULL, '', 'Processing', '07-07-2024 04:25:57pm'),
(116, '', '07933', 'sofolast@gmail.com', '1000', 'Internal Transfer', '2147483647', 'invest wise', 'mike smith', '23065918070', 'invest wise', 'mike smith', NULL, NULL, '', 'Processing', '07-07-2024 05:48:13pm'),
(117, '34', '07076', 'sofolast@gmail.com', '1000', 'Local Transfer', '2147483647', 'invest wise', 'mike smith', '23065918070', 'invest wise', 'mike smith', NULL, NULL, '', 'Processing', '07-07-2024 05:55:09pm'),
(118, '34', '07088', 'sofolast@gmail.com', '1000', 'Local Transfer', '2147483647', 'invest wise', 'mike smith', '23065918070', 'invest wise', 'mike smith', NULL, NULL, '', 'Processing', '07-07-2024 05:59:40pm'),
(119, '34', '07086', 'sofolast@gmail.com', '1000', 'Local Transfer', '2147483647', 'invest wise', 'mike smith', '23065918070', 'invest wise', 'mike smith', NULL, NULL, '', 'Processing', '07-07-2024 06:01:05pm'),
(120, '34', '07800', 'sofolast@gmail.com', '10000', 'Local Transfer', '2147483647', 'invest wise', 'mike smith', '23065918070', 'invest wise', 'mike smith', NULL, NULL, '', 'Processing', '07-07-2024 06:13:06pm'),
(121, '34', '07804', 'sofolast@gmail.com', '1000', 'Local Transfer', '2147483647', 'invest wise', 'mike smith', '23065918070', 'invest wise', 'mike smith', NULL, NULL, '', 'Processing', '07-07-2024 06:21:34pm'),
(122, '34', '07571', 'sofolast@gmail.com', '2000', 'Local Transfer', '2147483647', 'invest wise', 'mike smith', '23065918070', 'invest wise', 'mike smith', NULL, NULL, '', 'Processing', '07-07-2024 06:27:10pm'),
(123, '34', '07821', 'sofolast@gmail.com', '200', 'Local Transfer', '2147483647', 'invest wise', 'mike smith', '23067850721', 'invest wise', 'osaze', NULL, NULL, '', 'Processing', '07-07-2024 06:30:47pm'),
(124, '34', '07746', 'sofolast@gmail.com', '300', 'Local Transfer', '2147483647', 'invest wise', 'mike smith', '23067850721', 'invest wise', 'osaze', NULL, NULL, '', 'Processing', '07-07-2024 06:34:50pm'),
(125, '34', '07408', 'sofolast@gmail.com', '500', 'Internal Transfer', '23067850721', 'invest wise', 'mike smith', '23067850721', 'invest wise', 'osaze', NULL, NULL, NULL, 'Processing', '07-07-2024 06:38:50pm'),
(126, '23', '072053366', 'user@mail.com', '500', 'Local Transfer', '1234567890', 'invest wise', 'user test', '676799949494', 'Hdhd', 'VVV', NULL, NULL, 'Shhshshs', 'Processing', '08-07-2024 09:05:16am');

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

--
-- Table structure for table `users_investment`
--

CREATE TABLE `users_investment` (
  `id` int(11) NOT NULL,
  `userId` varchar(255) NOT NULL,
  `planId` varchar(255) NOT NULL,
  `invest_amt` varchar(255) NOT NULL,
  `plan_name` varchar(255) NOT NULL,
  `increase` varchar(255) NOT NULL,
  `duration` varchar(255) NOT NULL,
  `total_profit` varchar(255) NOT NULL,
  `start_date` varchar(255) NOT NULL,
  `end_date` varchar(255) NOT NULL,
  `status` enum('1','0') NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users_investment`
--

INSERT INTO `users_investment` (`id`, `userId`, `planId`, `invest_amt`, `plan_name`, `increase`, `duration`, `total_profit`, `start_date`, `end_date`, `status`, `date`) VALUES
(54, '13', 'Starter Plan', '500', 'Starter Plan', '3', '9', '15', '02-06-2024 17:57:15', '11-06-2024 17:57:15', '0', '2024-06-19 18:59:58'),
(55, '23', 'Starter Plan', '600', 'Starter Plan', '3', '9', '18', '10-06-2024 08:42:24', '19-06-2024 08:42:24', '0', '2024-06-19 18:59:58'),
(57, '23', 'Starter Plan', '600', 'Starter Plan', '3', '9', '18', '10-06-2024 11:14:44', '19-06-2024 11:14:44', '0', '2024-06-19 18:59:59'),
(58, '23', 'Ultimate Plan', '10000', 'Ultimate Plan', '7', '1', '700', '15-06-2024 15:10:52', '16-06-2024 15:10:52', '0', '2024-06-19 18:59:59'),
(59, '33', 'Ultimate Plan', '10000', 'Ultimate Plan', '7', '1', '700', '19-06-2024 19:44:58', '20-06-2024 19:44:58', '0', '2024-06-21 15:40:29'),
(60, '34', 'Ultimate Plan', '10000', 'Ultimate Plan', '7', '1', '700', '20-06-2024 10:36:57', '21-06-2024 10:36:57', '0', '2024-06-21 15:40:31'),
(61, '34', 'Ultimate Plan', '10000', 'Ultimate Plan', '7', '1', '700', '20-06-2024 11:50:17', '20-06-2024 14:36:17', '', '2024-06-20 13:35:26'),
(62, '23', 'Starter Plan', '500', 'Starter Plan', '3', '9', '15', '20-06-2024 13:13:23', '29-06-2024 13:13:23', '1', '2024-06-20 13:13:24'),
(63, '23', 'Starter Plan', '1000', 'Starter Plan', '3', '9', '30', '20-06-2024 13:48:20', '29-06-2024 13:48:20', '', '2024-06-20 14:05:13'),
(64, '23', 'Starter Plan', '700', 'Starter Plan', '3', '9', '21', '2024-06-20 13:54:03', '2024-06-29 13:54:03', '1', '2024-06-20 13:54:04'),
(65, '23', 'Ultimate Plan', '100000', 'Ultimate Plan', '7', '1', '7000', '2024-06-20 13:55:49', '2024-06-21 13:55:49', '0', '2024-06-21 15:40:32'),
(66, '34', 'Ultimate Plan', '1000000000', 'Ultimate Plan', '7', '1', '70000000', '2024-06-20 14:03:33', '2024-06-21 14:03:33', '0', '2024-06-21 15:40:32'),
(67, '39', 'Ultimate Plan', '100000', 'Ultimate Plan', '7', '1', '7000', '2024-06-20 15:19:55', '2024-06-21 15:19:55', '0', '2024-06-21 15:40:39'),
(68, '34', 'Ultimate Plan', '100000', 'Ultimate Plan', '7', '1', '7000', '2024-06-21 10:29:56', '2024-06-22 10:29:56', '', '2024-06-22 09:36:14'),
(70, '34', 'Ultimate Plan', '10000', 'Ultimate Plan', '7', '1', '700', '2024-06-23 11:20:03', '2024-06-24 11:20:03', '', '2024-06-24 20:16:42'),
(71, '34', 'Ultimate Plan', '10000', 'Ultimate Plan', '7', '1', '700', '2024-06-24 20:18:18', '2024-06-25 20:18:18', '1', '2024-06-24 20:18:18'),
(72, '34', 'Ultimate Plan', '10000', 'Ultimate Plan', '7', '1', '700', '2024-06-24 06:40:53', '2024-06-25 06:40:53', '0', '2024-06-25 06:40:48'),
(73, '34', 'Ultimate Plan', '10000', 'Ultimate Plan', '7', '1', '700', '2024-06-25 06:39:09', '2024-06-26 06:39:09', '1', '2024-06-25 06:39:09'),
(74, '34', 'Ultimate Plan', '10000', 'Ultimate Plan', '7', '1', '700', '2024-07-01 06:45:47', '2024-07-02 06:45:47', '1', '2024-07-01 06:45:47'),
(75, '23', 'Ultimate Plan', '10000', 'Ultimate Plan', '7', '1', '700', '2024-07-05 18:56:58', '2024-07-06 18:56:58', '1', '2024-07-05 18:56:58');

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

--
-- Table structure for table `verification`
--

CREATE TABLE `verification` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL DEFAULT 'pending',
  `photoid` varchar(255) NOT NULL,
  `utilitybill` varchar(255) NOT NULL,
  `businesslicense` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `verification`
--

INSERT INTO `verification` (`id`, `username`, `email`, `photoid`, `utilitybill`, `businesslicense`, `status`, `date`) VALUES
(23, 'aize', 'usertest@gmail.com', 'computer-4795762_1280.jpg', 'office-620822_1280.jpg', 'software-developer-6521720_1280.jpg', 'approved', '05-03-2024 04:21:26pm'),
(34, 'users', 'user@gmail.com', '65eaf75a5dda8.jpg', '65eaf75a5ddae.jpeg', '65eaf75a5ddaf.jpg', 'approved', '08-03-2024 12:32:42pm'),
(35, 'aize', 'funds12095@gmail.com', '65f1eafee6846.jpg', '65f1eafee6848.jpg', '65f1eafee6849.jpg', 'approved', '13-03-2024 06:05:50pm');

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

--
-- Table structure for table `wallets`
--

CREATE TABLE `wallets` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wallets`
--

INSERT INTO `wallets` (`id`, `name`, `address`) VALUES
(1, 'Bitcoin', 'btc1234456677474'),
(2, 'Ethereum', 'eth12342343'),
(3, 'Litecoin', 'ltc14234325'),
(4, 'Tether TRC20', 'trc_201342353'),
(5, 'Tether ERC20', 'erc_2025353454');

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

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

CREATE TABLE `withdrawals` (
  `id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `method` varchar(255) NOT NULL,
  `cryptoaddresss` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'PENDING',
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `withdrawals` (`id`, `email`, `amount`, `method`, `cryptoaddresss`, `status`, `date`) VALUES
(16, 'user@mail.com', '10', 'Bitcoin', 'eetretert', 'PENDING', '17-06-2024 11:15:35am'),
(17, 'user@mail.com', '10', 'Bitcoin', 'eetretert', 'PENDING', '17-06-2024 11:16:56am'),
(18, 'user@mail.com', '850', 'Bitcoin', '23534e4t45653', 'PENDING', '17-06-2024 11:22:42am'),
(19, 'user@mail.com', '6', 'Ethereum', 'ret4t5', 'PENDING', '17-06-2024 11:24:08am'),
(20, 'user@mail.com', '10', 'Bitcoin', '34634', 'PENDING', '17-06-2024 11:25:29am'),
(21, 'user@mail.com', '50', 'Litecoin', '2141221', 'COMPLETED', '20-06-2024 02:10:02pm'),
(22, 'user@mail.com', '5000', 'Ethereum', '1GM7bhkTvDKYCUz99ZUF5QGSVRiiwJV1EH', 'PENDING', '07-07-2024 12:32:41am');

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `withdrawals`
--
ALTER TABLE `withdrawals`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
COMMIT;

