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

START TRANSACTION;



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

--
-- Table structure for table `crypto_withdrawal`
--

CREATE TABLE `crypto_withdrawal` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `tranx_id` int(11) NOT NULL,
  `email` text NOT NULL,
  `amount` text NOT NULL,
  `coin` text NOT NULL,
  `address` text NOT NULL,
  `status` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `crypto_withdrawal`
--

INSERT INTO `crypto_withdrawal` (`id`, `client_id`, `tranx_id`, `email`, `amount`, `coin`, `address`, `status`, `created_at`) VALUES
(118, 293, 826987, 'michelle.durham0724@gmail.com', '8760.00', 'BTC', '0x63d4265d248721b066A5834Fbbb135Db89b0945b', 'pending', '2024-10-21 20:08:30'),
(119, 282, 863599, 'ottodalton6@gmail.com', '400', 'BTC', '1AJKXdvFv7BeEGqf2x9zQRcSiWcbooPadW', 'completed', '2024-11-27 17:13:23'),
(120, 282, 149317, 'ottodalton6@gmail.com', '500', 'BTC', '1AJKXdvFv7BeEGqf2x9zQRcSiWcbooPadW', 'completed', '2024-11-27 17:18:15'),
(121, 280, 498698, 'islanddapperentertainment@gmail.com', '4,500,000', 'ETH', '0x8698b59CACC00486f920e18278f3628bcEC3784e', 'completed', '2024-11-27 17:46:08'),
(122, 295, 694223, 'samialsadig14@gmail.com', '12,000', 'BTC', '0x3956E95Cb303338185E088bC8C7bfE778D2B6103', 'completed', '2024-12-04 18:30:22'),
(123, 295, 686593, 'samialsadig14@gmail.com', '12,000', 'BTC', '0x3956E95Cb303338185E088bC8C7bfE778D2B6103', 'pending', '2024-12-04 18:33:32'),
(124, 308, 353685, 'asifpgckasur@gmail.com', '250', 'ETH', '0x19F767B023fd5C4Ed666C9D17e60611daD6252A2', 'completed', '2025-01-03 18:40:32'),
(125, 309, 239125, 'jitendra4sap@gmail.com', '150', 'USDT', '0x01D438dD12F06FB5758ef347cF22397D607aA998', 'completed', '2025-01-06 15:54:27'),
(126, 317, 396636, 'zabi252@gmail.com', '9000', 'ETH', '0x015bB35492a8D4650a82FE40bA8922C56ae613Ba', 'pending', '2025-01-30 14:02:25'),
(127, 317, 709390, 'zabi252@gmail.com', '9000', 'ETH', '0x015bB35492a8D4650a82FE40bA8922C56ae613Ba', 'completed', '2025-01-30 14:03:15'),
(128, 317, 732982, 'zabi252@gmail.com', '1500', 'ETH', '0x98e362b5544b92456431C03dBd6f0125B3aa5756', 'completed', '2025-01-31 13:45:06'),
(129, 321, 995252, 'bahaduralichishti26@gmail.com', '192', 'BTC', 'DCByyTfkyxHhjB9Poq4qiDWZVZJ3AYGm1F', 'failed', '2025-02-03 10:36:32'),
(130, 321, 990897, 'bahaduralichishti26@gmail.com', '102', 'USDT', '0x237898c7a14f90926bbf7d190c62ed11601bc7f7', 'completed', '2025-02-03 16:29:24'),
(131, 321, 885340, 'bahaduralichishti26@gmail.com', '90', 'USDT', 'DCByyTfkyxHhjB9Poq4qiDWZVZJ3AYGm1F', 'pending', '2025-02-04 09:34:48'),
(132, 321, 866625, 'bahaduralichishti26@gmail.com', '90', 'USDT', 'DCByyTfkyxHhjB9Poq4qiDWZVZJ3AYGm1F', 'pending', '2025-02-04 10:09:23'),
(133, 321, 81744, 'bahaduralichishti26@gmail.com', '50', 'USDT', 'DCByyTfkyxHhjB9Poq4qiDWZVZJ3AYGm1F', 'pending', '2025-02-04 10:10:54');

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

--
-- Table structure for table `history`
--

CREATE TABLE `history` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `tranx_id` text NOT NULL,
  `email` text NOT NULL,
  `type` text NOT NULL,
  `amount` text NOT NULL,
  `coin` text NOT NULL,
  `address` text NOT NULL,
  `status` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `history`
--

INSERT INTO `history` (`id`, `client_id`, `tranx_id`, `email`, `type`, `amount`, `coin`, `address`, `status`, `created_at`) VALUES
(13827, 278, '336989', 'gregmills647@gmail.com', 'profit', '1000', 'USD', '', 'completed', '2024-10-06 12:49:39'),
(13831, 282, '77394', 'ottodalton6@gmail.com', 'profit', '20', 'USD', '', 'completed', '2024-10-08 12:12:49'),
(13833, 282, '694982', 'ottodalton6@gmail.com', 'bonus', '100', 'USD', '', 'completed', '2024-10-11 13:01:49'),
(13834, 280, '744545', 'islanddapperentertainment@gmail.com', 'profit', '450000', 'USD', '', 'completed', '2024-10-12 02:16:18'),
(13835, 280, '34165', 'islanddapperentertainment@gmail.com', 'profit', '300000', 'USD', '', 'completed', '2024-10-16 02:25:29'),
(13836, 293, '67486', 'michelle.durham0724@gmail.com', 'profit', '1000', 'USD', '', 'completed', '2024-10-21 00:17:47'),
(13837, 293, '430224', 'michelle.durham0724@gmail.com', 'profit', '600', 'USD', '', 'completed', '2024-10-21 08:09:37'),
(13838, 293, '571394', 'michelle.durham0724@gmail.com', 'profit', '400', 'USD', '', 'completed', '2024-10-21 08:36:48'),
(13839, 293, '360247', 'michelle.durham0724@gmail.com', 'profit', '500', 'USD', '', 'completed', '2024-10-21 09:01:10'),
(13840, 293, '704581', 'michelle.durham0724@gmail.com', 'profit', '600', 'USD', '', 'completed', '2024-10-21 11:03:29'),
(13841, 293, '333890', 'michelle.durham0724@gmail.com', 'profit', '800', 'USD', '', 'completed', '2024-10-21 11:59:50'),
(13842, 293, '515836', 'michelle.durham0724@gmail.com', 'profit', '690', 'USD', '', 'completed', '2024-10-21 13:10:35'),
(13843, 293, '129048', 'michelle.durham0724@gmail.com', 'profit', '1200', 'USD', '', 'completed', '2024-10-21 14:18:14'),
(13844, 293, '242680', 'michelle.durham0724@gmail.com', 'bonus', '560', 'USD', '', 'completed', '2024-10-21 14:18:29'),
(13845, 293, '571784', 'michelle.durham0724@gmail.com', 'profit', '1010', 'USD', '', 'completed', '2024-10-21 15:40:48'),
(13846, 293, '961572', 'michelle.durham0724@gmail.com', 'profit', '900', 'USD', '', 'completed', '2024-10-21 19:04:57'),
(13847, 293, '826987', 'michelle.durham0724@gmail.com', 'withdrawal', '8760.00', 'BTC', '0x63d4265d248721b066A5834Fbbb135Db89b0945b', 'pending', '2024-10-21 20:08:30'),
(13848, 295, '423560', 'samialsadig14@gmail.com', 'profit', '65', 'GBP', '', 'completed', '2024-10-26 12:20:58'),
(13849, 295, '151427', 'samialsadig14@gmail.com', 'profit', '85', 'GBP', '', 'completed', '2024-10-28 03:37:26'),
(13850, 295, '584021', 'samialsadig14@gmail.com', 'profit', '145', 'GBP', '', 'completed', '2024-10-29 17:08:24'),
(13851, 295, '309001', 'samialsadig14@gmail.com', 'bonus', '50', 'GBP', '', 'completed', '2024-11-08 09:55:54'),
(13852, 295, '110313', 'samialsadig14@gmail.com', 'profit', '150', 'GBP', '', 'completed', '2024-11-10 18:23:09'),
(13853, 295, '244655', 'samialsadig14@gmail.com', 'profit', '200', 'GBP', '', 'completed', '2024-11-10 21:09:13'),
(13854, 295, '912006', 'samialsadig14@gmail.com', 'profit', '135', 'GBP', '', 'completed', '2024-11-11 08:16:35'),
(13855, 295, '875154', 'samialsadig14@gmail.com', 'profit', '115', 'GBP', '', 'completed', '2024-11-11 14:41:49'),
(13856, 295, '184725', 'samialsadig14@gmail.com', 'profit', '200', 'GBP', '', 'completed', '2024-11-12 22:20:21'),
(13857, 295, '716115', 'samialsadig14@gmail.com', 'profit', '250', 'GBP', '', 'completed', '2024-11-13 06:40:54'),
(13858, 295, '793474', 'samialsadig14@gmail.com', 'profit', '250', 'GBP', '', 'completed', '2024-11-13 08:53:05'),
(13859, 295, '722379', 'samialsadig14@gmail.com', 'profit', '200', 'GBP', '', 'completed', '2024-11-13 14:11:05'),
(13860, 295, '333398', 'samialsadig14@gmail.com', 'profit', '100', 'GBP', '', 'completed', '2024-11-13 16:59:11'),
(13861, 295, '427217', 'samialsadig14@gmail.com', 'profit', '325', 'GBP', '', 'completed', '2024-11-14 12:18:45'),
(13862, 295, '972488', 'samialsadig14@gmail.com', 'profit', '325', 'GBP', '', 'completed', '2024-11-14 12:19:30'),
(13863, 295, '448652', 'samialsadig14@gmail.com', 'profit', '443', 'GBP', '', 'completed', '2024-11-14 19:34:37'),
(13864, 295, '323943', 'samialsadig14@gmail.com', 'profit', '443', 'GBP', '', 'completed', '2024-11-14 19:34:41'),
(13865, 295, '153174', 'samialsadig14@gmail.com', 'profit', '340', 'GBP', '', 'completed', '2024-11-14 21:15:51'),
(13866, 295, '437384', 'samialsadig14@gmail.com', 'profit', '324', 'GBP', '', 'completed', '2024-11-15 06:36:45'),
(13867, 295, '78937', 'samialsadig14@gmail.com', 'profit', '380', 'GBP', '', 'completed', '2024-11-15 07:44:19'),
(13868, 295, '750723', 'samialsadig14@gmail.com', 'profit', '323', 'GBP', '', 'completed', '2024-11-15 09:06:27'),
(13869, 295, '763011', 'samialsadig14@gmail.com', 'profit', '345', 'GBP', '', 'completed', '2024-11-15 12:52:37'),
(13870, 295, '679331', 'samialsadig14@gmail.com', 'profit', '345', 'GBP', '', 'completed', '2024-11-15 12:52:37'),
(13871, 295, '72926', 'samialsadig14@gmail.com', 'profit', '332', 'GBP', '', 'completed', '2024-11-15 16:40:30'),
(13872, 295, '374422', 'samialsadig14@gmail.com', 'profit', '323', 'GBP', '', 'completed', '2024-11-15 19:44:45'),
(13873, 295, '708725', 'samialsadig14@gmail.com', 'profit', '323', 'GBP', '', 'completed', '2024-11-15 19:44:46'),
(13874, 295, '963570', 'samialsadig14@gmail.com', 'deposit', '700', 'GBP', '', 'completed', '2024-11-22 22:06:49'),
(13875, 295, '642983', 'samialsadig14@gmail.com', 'deposit', '430', 'GBP', '', 'completed', '2024-11-22 22:07:11'),
(13876, 295, '760273', 'samialsadig14@gmail.com', 'profit', '457', 'GBP', '', 'completed', '2024-11-24 09:03:08'),
(13877, 295, '6802', 'samialsadig14@gmail.com', 'profit', '1050', 'GBP', '', 'completed', '2024-11-24 10:22:22'),
(13878, 295, '243029', 'samialsadig14@gmail.com', 'profit', '1600', 'GBP', '', 'completed', '2024-11-24 12:36:23'),
(13879, 295, '663526', 'samialsadig14@gmail.com', 'profit', '1250', 'GBP', '', 'completed', '2024-11-24 14:46:22'),
(13880, 295, '767207', 'samialsadig14@gmail.com', 'profit', '1050', 'GBP', '', 'completed', '2024-11-25 02:25:56'),
(13881, 295, '648235', 'samialsadig14@gmail.com', 'profit', '900', 'GBP', '', 'completed', '2024-11-25 22:13:50'),
(13882, 282, '863599', 'ottodalton6@gmail.com', 'withdrawal', '400', 'BTC', '1AJKXdvFv7BeEGqf2x9zQRcSiWcbooPadW', 'pending', '2024-11-27 17:13:23'),
(13883, 282, '149317', 'ottodalton6@gmail.com', 'withdrawal', '500', 'BTC', '1AJKXdvFv7BeEGqf2x9zQRcSiWcbooPadW', 'pending', '2024-11-27 17:18:15'),
(13884, 280, '498698', 'islanddapperentertainment@gmail.com', 'withdrawal', '4,500,000', 'ETH', '0x8698b59CACC00486f920e18278f3628bcEC3784e', 'pending', '2024-11-27 17:46:08'),
(13885, 295, '694223', 'samialsadig14@gmail.com', 'withdrawal', '12,000', 'BTC', '0x3956E95Cb303338185E088bC8C7bfE778D2B6103', 'pending', '2024-12-04 18:30:22'),
(13886, 295, '686593', 'samialsadig14@gmail.com', 'withdrawal', '12,000', 'BTC', '0x3956E95Cb303338185E088bC8C7bfE778D2B6103', 'pending', '2024-12-04 18:33:32'),
(13887, 300, '21888', 'A1harborough@gmail.com', 'deposit', '250', 'GBP', '', 'completed', '2024-12-09 20:41:26'),
(13888, 300, '997654', 'A1harborough@gmail.com', 'profit', '368', 'GBP', '', 'completed', '2024-12-09 21:13:47'),
(13889, 300, '172798', 'A1harborough@gmail.com', 'profit', '213', 'GBP', '', 'completed', '2024-12-09 23:07:37'),
(13890, 300, '877746', 'A1harborough@gmail.com', 'profit', '308', 'GBP', '', 'completed', '2024-12-10 06:10:25'),
(13891, 300, '881876', 'A1harborough@gmail.com', 'profit', '206', 'GBP', '', 'completed', '2024-12-10 11:47:13'),
(13892, 300, '34627', 'A1harborough@gmail.com', 'profit', '103', 'GBP', '', 'completed', '2024-12-10 21:55:49'),
(13893, 300, '441635', 'A1harborough@gmail.com', 'profit', '120', 'GBP', '', 'completed', '2024-12-11 07:01:33'),
(13894, 300, '585262', 'A1harborough@gmail.com', 'deposit', '105', 'GBP', '', 'completed', '2024-12-11 18:10:52'),
(13895, 300, '840586', 'A1harborough@gmail.com', 'profit', '765', 'GBP', '', 'completed', '2024-12-12 22:28:06'),
(13896, 295, '413903', 'samialsadig14@gmail.com', 'profit', '1000', 'GBP', '', 'completed', '2024-12-19 07:18:19'),
(13897, 308, '552823', 'asifpgckasur@gmail.com', 'deposit', '44', 'USD', '', 'completed', '2025-01-02 17:57:56'),
(13898, 308, '935528', 'asifpgckasur@gmail.com', 'deposit', '41', 'USD', '', 'completed', '2025-01-03 11:11:05'),
(13899, 308, '455327', 'asifpgckasur@gmail.com', 'deposit', '15', 'USD', '', 'completed', '2025-01-03 12:03:31'),
(13900, 308, '423370', 'asifpgckasur@gmail.com', 'profit', '70', 'USD', '', 'completed', '2025-01-03 13:00:05'),
(13901, 308, '186032', 'asifpgckasur@gmail.com', 'profit', '80', 'USD', '', 'completed', '2025-01-03 17:48:31'),
(13902, 308, '353685', 'asifpgckasur@gmail.com', 'withdrawal', '250', 'ETH', '0x19F767B023fd5C4Ed666C9D17e60611daD6252A2', 'pending', '2025-01-03 18:40:32'),
(13903, 309, '408774', 'jitendra4sap@gmail.com', 'deposit', '100', 'USD', '', 'completed', '2025-01-04 20:11:42'),
(13904, 309, '325508', 'jitendra4sap@gmail.com', 'profit', '60', 'USD', '', 'completed', '2025-01-04 21:57:55'),
(13905, 309, '661197', 'jitendra4sap@gmail.com', 'profit', '45', 'USD', '', 'completed', '2025-01-04 22:55:20'),
(13906, 309, '548154', 'jitendra4sap@gmail.com', 'profit', '41', 'USD', '', 'completed', '2025-01-05 05:29:29'),
(13907, 309, '864913', 'jitendra4sap@gmail.com', 'profit', '18', 'USD', '', 'completed', '2025-01-05 14:15:44'),
(13908, 309, '202548', 'jitendra4sap@gmail.com', 'deposit', '21', 'USD', '', 'completed', '2025-01-05 18:19:58'),
(13909, 310, '478757', 'jehanzebkhan3363@gmail.com', 'deposit', '102', 'EUR', '', 'completed', '2025-01-06 02:12:28'),
(13910, 310, '80398', 'jehanzebkhan3363@gmail.com', 'profit', '45', 'EUR', '', 'completed', '2025-01-06 07:14:59'),
(13911, 309, '816005', 'jitendra4sap@gmail.com', 'profit', '22', 'USD', '', 'completed', '2025-01-06 11:11:18'),
(13912, 310, '985462', 'jehanzebkhan3363@gmail.com', 'profit', '25', 'EUR', '', 'completed', '2025-01-06 14:34:08'),
(13913, 309, '239125', 'jitendra4sap@gmail.com', 'withdrawal', '150', 'USDT', '0x01D438dD12F06FB5758ef347cF22397D607aA998', 'pending', '2025-01-06 15:54:27'),
(13914, 309, '678911', 'jitendra4sap@gmail.com', 'deposit', '160', 'USD', '', 'completed', '2025-01-06 16:39:00'),
(13915, 309, '845685', 'jitendra4sap@gmail.com', 'profit', '54', 'USD', '', 'completed', '2025-01-06 18:54:34'),
(13916, 309, '389445', 'jitendra4sap@gmail.com', 'profit', '84', 'USD', '', 'completed', '2025-01-07 05:54:59'),
(13917, 310, '857472', 'jehanzebkhan3363@gmail.com', 'profit', '42', 'EUR', '', 'completed', '2025-01-07 07:49:42'),
(13918, 309, '220587', 'jitendra4sap@gmail.com', 'profit', '125', 'USD', '', 'completed', '2025-01-07 08:10:13'),
(13919, 309, '738710', 'jitendra4sap@gmail.com', 'profit', '125', 'USD', '', 'completed', '2025-01-07 08:10:17'),
(13920, 309, '783117', 'jitendra4sap@gmail.com', 'profit', '125', 'USD', '', 'completed', '2025-01-07 08:10:18'),
(13921, 309, '290120', 'jitendra4sap@gmail.com', 'profit', '125', 'USD', '', 'completed', '2025-01-07 08:10:22'),
(13922, 309, '948004', 'jitendra4sap@gmail.com', 'profit', '89', 'USD', '', 'completed', '2025-01-07 12:00:19'),
(13923, 309, '165029', 'jitendra4sap@gmail.com', 'deposit', '200', 'USD', '', 'completed', '2025-01-07 14:45:20'),
(13924, 309, '564485', 'jitendra4sap@gmail.com', 'profit', '102', 'USD', '', 'completed', '2025-01-07 15:24:03'),
(13925, 309, '232049', 'jitendra4sap@gmail.com', 'profit', '120', 'USD', '', 'completed', '2025-01-07 16:44:57'),
(13926, 309, '630433', 'jitendra4sap@gmail.com', 'profit', '105', 'USD', '', 'completed', '2025-01-07 19:16:22'),
(13927, 309, '983637', 'jitendra4sap@gmail.com', 'profit', '101', 'USD', '', 'completed', '2025-01-08 05:39:19'),
(13928, 309, '954530', 'jitendra4sap@gmail.com', 'profit', '64', 'USD', '', 'completed', '2025-01-08 12:25:23'),
(13929, 309, '342640', 'jitendra4sap@gmail.com', 'profit', '22', 'USD', '', 'completed', '2025-01-08 15:41:55'),
(13931, 314, '957658', '22ghulam92@gmail.com', 'deposit', '324', 'USD', '', 'completed', '2025-01-12 04:49:38'),
(13932, 314, '961852', '22ghulam92@gmail.com', 'profit', '93', 'USD', '', 'completed', '2025-01-12 05:16:43'),
(13933, 314, '947439', '22ghulam92@gmail.com', 'profit', '67', 'USD', '', 'completed', '2025-01-12 11:26:53'),
(13934, 314, '655670', '22ghulam92@gmail.com', 'profit', '67', 'USD', '', 'completed', '2025-01-12 12:46:12'),
(13935, 314, '634007', '22ghulam92@gmail.com', 'profit', '82', 'USD', '', 'completed', '2025-01-12 16:16:43'),
(13936, 314, '940015', '22ghulam92@gmail.com', 'profit', '62', 'USD', '', 'completed', '2025-01-12 20:15:29'),
(13937, 314, '960096', '22ghulam92@gmail.com', 'profit', '234', 'USD', '', 'completed', '2025-01-14 13:48:02'),
(13938, 314, '55365', '22ghulam92@gmail.com', 'profit', '120', 'USD', '', 'completed', '2025-01-14 17:42:30'),
(13939, 314, '277776', '22ghulam92@gmail.com', 'profit', '127', 'USD', '', 'completed', '2025-01-15 15:52:43'),
(13940, 314, '50268', '22ghulam92@gmail.com', 'profit', '127', 'USD', '', 'completed', '2025-01-15 15:52:47'),
(13941, 314, '399583', '22ghulam92@gmail.com', 'profit', '153', 'USD', '', 'completed', '2025-01-16 07:47:11'),
(13942, 314, '177216', '22ghulam92@gmail.com', 'profit', '256', 'USD', '', 'completed', '2025-01-18 13:28:11'),
(13943, 314, '430516', '22ghulam92@gmail.com', 'profit', '256', 'USD', '', 'completed', '2025-01-18 13:28:14'),
(13944, 314, '653910', '22ghulam92@gmail.com', 'profit', '237', 'USD', '', 'completed', '2025-01-19 16:50:08'),
(13945, 317, '418536', 'zabi252@gmail.com', 'deposit', '100', 'USD', '', 'completed', '2025-01-23 20:08:57'),
(13946, 317, '136732', 'zabi252@gmail.com', 'profit', '28', 'USD', '', 'completed', '2025-01-23 21:19:26'),
(13947, 317, '595612', 'zabi252@gmail.com', 'profit', '21', 'USD', '', 'completed', '2025-01-24 07:25:03'),
(13948, 317, '604035', 'zabi252@gmail.com', 'profit', '27', 'USD', '', 'completed', '2025-01-24 09:46:53'),
(13949, 317, '202899', 'zabi252@gmail.com', 'deposit', '250', 'USD', '', 'completed', '2025-01-24 11:29:47'),
(13950, 317, '646965', 'zabi252@gmail.com', 'bonus', '49', 'USD', '', 'completed', '2025-01-24 12:12:01'),
(13951, 317, '318922', 'zabi252@gmail.com', 'bonus', '49', 'USD', '', 'completed', '2025-01-24 12:12:05'),
(13952, 317, '292907', 'zabi252@gmail.com', 'profit', '69', 'USD', '', 'completed', '2025-01-24 12:27:32'),
(13953, 317, '921750', 'zabi252@gmail.com', 'deposit', '64', 'USD', '', 'completed', '2025-01-24 14:46:41'),
(13954, 317, '316745', 'zabi252@gmail.com', 'profit', '47', 'USD', '', 'completed', '2025-01-24 16:31:39'),
(13955, 317, '656886', 'zabi252@gmail.com', 'profit', '40', 'USD', '', 'completed', '2025-01-24 18:40:38'),
(13956, 317, '526050', 'zabi252@gmail.com', 'profit', '43', 'USD', '', 'completed', '2025-01-25 07:10:55'),
(13957, 317, '213324', 'zabi252@gmail.com', 'profit', '45', 'USD', '', 'completed', '2025-01-25 10:52:03'),
(13958, 317, '913485', 'zabi252@gmail.com', 'bonus', '76', 'USD', '', 'completed', '2025-01-25 16:49:43'),
(13959, 317, '299805', 'zabi252@gmail.com', 'profit', '78', 'USD', '', 'completed', '2025-01-25 19:14:10'),
(13960, 317, '580847', 'zabi252@gmail.com', 'profit', '69', 'USD', '', 'completed', '2025-01-25 20:15:56'),
(13961, 317, '269208', 'zabi252@gmail.com', 'profit', '72', 'USD', '', 'completed', '2025-01-25 22:38:32'),
(13962, 317, '242654', 'zabi252@gmail.com', 'profit', '74', 'USD', '', 'completed', '2025-01-26 02:03:56'),
(13963, 317, '746801', 'zabi252@gmail.com', 'profit', '75', 'USD', '', 'completed', '2025-01-26 07:34:30'),
(13964, 317, '441787', 'zabi252@gmail.com', 'profit', '83', 'USD', '', 'completed', '2025-01-26 09:18:27'),
(13965, 317, '246845', 'zabi252@gmail.com', 'profit', '89', 'USD', '', 'completed', '2025-01-26 10:32:06'),
(13966, 317, '462436', 'zabi252@gmail.com', 'profit', '94', 'USD', '', 'completed', '2025-01-26 13:38:31'),
(13967, 317, '223491', 'zabi252@gmail.com', 'bonus', '258', 'USD', '', 'completed', '2025-01-26 14:52:12'),
(13968, 317, '92758', 'zabi252@gmail.com', 'profit', '82', 'USD', '', 'completed', '2025-01-26 18:04:50'),
(13969, 317, '549386', 'zabi252@gmail.com', 'profit', '82', 'USD', '', 'completed', '2025-01-26 18:11:42'),
(13970, 317, '198077', 'zabi252@gmail.com', 'profit', '83', 'USD', '', 'completed', '2025-01-26 20:56:32'),
(13971, 317, '318475', 'zabi252@gmail.com', 'profit', '73', 'USD', '', 'completed', '2025-01-26 21:25:44'),
(13972, 317, '214989', 'zabi252@gmail.com', 'profit', '84', 'USD', '', 'completed', '2025-01-27 03:25:21'),
(13973, 317, '543205', 'zabi252@gmail.com', 'profit', '87', 'USD', '', 'completed', '2025-01-27 07:16:36'),
(13974, 317, '439504', 'zabi252@gmail.com', 'profit', '83', 'USD', '', 'completed', '2025-01-27 08:00:17'),
(13975, 317, '27911', 'zabi252@gmail.com', 'bonus', '158', 'USD', '', 'completed', '2025-01-27 09:27:26'),
(13976, 317, '931978', 'zabi252@gmail.com', 'deposit', '700', 'USD', '', 'completed', '2025-01-27 16:56:30'),
(13977, 317, '598387', 'zabi252@gmail.com', 'bonus', '7500', 'USD', '', 'completed', '2025-01-27 16:57:13'),
(13978, 317, '297469', 'zabi252@gmail.com', 'profit', '238', 'USD', '', 'completed', '2025-01-28 07:33:20'),
(13979, 317, '732060', 'zabi252@gmail.com', 'profit', '227', 'USD', '', 'completed', '2025-01-28 09:04:26'),
(13980, 317, '939654', 'zabi252@gmail.com', 'profit', '189', 'USD', '', 'completed', '2025-01-28 10:11:03'),
(13981, 317, '27164', 'zabi252@gmail.com', 'profit', '128', 'USD', '', 'completed', '2025-01-28 12:52:40'),
(13982, 317, '608409', 'zabi252@gmail.com', 'withdrawal', '9000', 'Dubai Islamic Bank', 'PK20DUIB0000000751469002', 'pending', '2025-01-28 14:59:06'),
(13983, 317, '620899', 'zabi252@gmail.com', 'withdrawal', '9000', 'Dubai Islamic Bank', 'PK20DUIB0000000751469002', 'pending', '2025-01-28 14:59:16'),
(13984, 317, '396636', 'zabi252@gmail.com', 'withdrawal', '9000', 'ETH', '0x015bB35492a8D4650a82FE40bA8922C56ae613Ba', 'pending', '2025-01-30 14:02:25'),
(13985, 317, '709390', 'zabi252@gmail.com', 'withdrawal', '9000', 'ETH', '0x015bB35492a8D4650a82FE40bA8922C56ae613Ba', 'pending', '2025-01-30 14:03:15'),
(13986, 317, '732982', 'zabi252@gmail.com', 'withdrawal', '1500', 'ETH', '0x98e362b5544b92456431C03dBd6f0125B3aa5756', 'pending', '2025-01-31 13:45:06'),
(13987, 321, '244999', 'bahaduralichishti26@gmail.com', 'deposit', '90', 'USD', '', 'completed', '2025-02-01 10:41:32'),
(13988, 321, '70411', 'bahaduralichishti26@gmail.com', 'profit', '19', 'USD', '', 'completed', '2025-02-01 12:43:22'),
(13992, 321, '622471', 'bahaduralichishti26@gmail.com', 'profit', '21', 'USD', '', 'completed', '2025-02-01 19:16:39'),
(13994, 321, '715328', 'bahaduralichishti26@gmail.com', 'profit', '24', 'USD', '', 'completed', '2025-02-02 06:34:07'),
(13997, 321, '20380', 'bahaduralichishti26@gmail.com', 'profit', '17', 'USD', '', 'completed', '2025-02-02 16:47:03'),
(14000, 321, '644024', 'bahaduralichishti26@gmail.com', 'profit', '21', 'USD', '', 'completed', '2025-02-03 09:01:45'),
(14001, 321, '995252', 'bahaduralichishti26@gmail.com', 'withdrawal', '192', 'BTC', 'DCByyTfkyxHhjB9Poq4qiDWZVZJ3AYGm1F', 'pending', '2025-02-03 10:36:32'),
(14002, 321, '990897', 'bahaduralichishti26@gmail.com', 'withdrawal', '102', 'USDT', '0x237898c7a14f90926bbf7d190c62ed11601bc7f7', 'pending', '2025-02-03 16:29:24'),
(14005, 321, '885340', 'bahaduralichishti26@gmail.com', 'withdrawal', '90', 'USDT', 'DCByyTfkyxHhjB9Poq4qiDWZVZJ3AYGm1F', 'pending', '2025-02-04 09:34:48'),
(14006, 321, '866625', 'bahaduralichishti26@gmail.com', 'withdrawal', '90', 'USDT', 'DCByyTfkyxHhjB9Poq4qiDWZVZJ3AYGm1F', 'pending', '2025-02-04 10:09:23'),
(14007, 321, '81744', 'bahaduralichishti26@gmail.com', 'withdrawal', '50', 'USDT', 'DCByyTfkyxHhjB9Poq4qiDWZVZJ3AYGm1F', 'pending', '2025-02-04 10:10:54'),
(14011, 324, '461670', 'ab9974446@gmail.com', 'deposit', '100', 'USD', '', 'completed', '2025-02-05 12:58:18'),
(14014, 325, '498808', 'sandeepnangewani11@gmail.com', 'deposit', '22', 'USD', '', 'completed', '2025-02-05 20:35:32'),
(14015, 325, '439519', 'sandeepnangewani11@gmail.com', 'deposit', '78', 'USD', '', 'completed', '2025-02-05 20:51:54'),
(14016, 325, '474517', 'sandeepnangewani11@gmail.com', 'profit', '19', 'USD', '', 'completed', '2025-02-06 06:06:55'),
(14018, 325, '699988', 'sandeepnangewani11@gmail.com', 'profit', '18', 'USD', '', 'completed', '2025-02-06 08:12:41'),
(14020, 326, '913475', 'midreesshad@gmail.com', 'deposit', '75', 'USD', '', 'completed', '2025-02-06 08:31:37'),
(14021, 325, '481782', 'sandeepnangewani11@gmail.com', 'deposit', '35', 'USD', '', 'completed', '2025-02-06 11:30:03'),
(14022, 325, '128757', 'sandeepnangewani11@gmail.com', 'deposit', '65', 'USD', '', 'completed', '2025-02-06 11:33:51'),
(14023, 325, '907608', 'sandeepnangewani11@gmail.com', 'profit', '27', 'USD', '', 'completed', '2025-02-06 12:22:33'),
(14025, 325, '60493', 'sandeepnangewani11@gmail.com', 'profit', '26', 'USD', '', 'completed', '2025-02-06 14:18:12'),
(14026, 325, '597695', 'sandeepnangewani11@gmail.com', 'deposit', '100', 'USD', '', 'completed', '2025-02-06 15:42:36'),
(14027, 325, '417013', 'sandeepnangewani11@gmail.com', 'profit', '31', 'USD', '', 'completed', '2025-02-06 16:03:33'),
(14029, 325, '967850', 'sandeepnangewani11@gmail.com', 'profit', '27', 'USD', '', 'completed', '2025-02-07 06:21:16'),
(14031, 325, '505860', 'sandeepnangewani11@gmail.com', 'deposit', '100', 'USD', '', 'completed', '2025-02-07 09:43:16'),
(14032, 325, '358504', 'sandeepnangewani11@gmail.com', 'deposit', '50', 'USD', '', 'completed', '2025-02-07 09:50:03'),
(14033, 325, '665514', 'sandeepnangewani11@gmail.com', 'profit', '45', 'USD', '', 'completed', '2025-02-07 10:29:06'),
(14034, 325, '145528', 'sandeepnangewani11@gmail.com', 'profit', '33', 'USD', '', 'completed', '2025-02-07 12:57:56'),
(14036, 325, '770623', 'sandeepnangewani11@gmail.com', 'profit', '37', 'USD', '', 'completed', '2025-02-07 16:22:26'),
(14037, 325, '19726', 'sandeepnangewani11@gmail.com', 'profit', '37', 'USD', '', 'completed', '2025-02-08 05:04:25'),
(14038, 328, '421476', 'deepgagandeepsingh90@gmail.com', 'deposit', '40', 'Select currency', '', 'completed', '2025-02-08 06:33:02'),
(14039, 328, '119879', 'deepgagandeepsingh90@gmail.com', 'deposit', '60', 'Select currency', '', 'completed', '2025-02-08 06:36:55'),
(14040, 328, '406339', 'deepgagandeepsingh90@gmail.com', 'profit', '17', 'Select currency', '', 'completed', '2025-02-08 07:34:55'),
(14041, 325, '112293', 'sandeepnangewani11@gmail.com', 'profit', '42', 'USD', '', 'completed', '2025-02-08 07:35:17'),
(14042, 328, '32237', 'deepgagandeepsingh90@gmail.com', 'profit', '19', 'Select currency', '', 'completed', '2025-02-08 08:46:15'),
(14043, 325, '454857', 'sandeepnangewani11@gmail.com', 'profit', '23', 'USD', '', 'completed', '2025-02-08 08:46:32'),
(14044, 325, '515114', 'sandeepnangewani11@gmail.com', 'profit', '30', 'USD', '', 'completed', '2025-02-08 10:13:01'),
(14045, 325, '622373', 'sandeepnangewani11@gmail.com', 'deposit', '500', 'USD', '', 'completed', '2025-02-08 12:02:54'),
(14046, 325, '62939', 'sandeepnangewani11@gmail.com', 'deposit', '500', 'USD', '', 'completed', '2025-02-08 12:14:45'),
(14047, 325, '195002', 'sandeepnangewani11@gmail.com', 'bonus', '280', 'USD', '', 'completed', '2025-02-08 12:15:44'),
(14048, 325, '534829', 'sandeepnangewani11@gmail.com', 'profit', '224', 'USD', '', 'completed', '2025-02-08 13:49:36'),
(14049, 328, '432204', 'deepgagandeepsingh90@gmail.com', 'profit', '17', 'Select currency', '', 'completed', '2025-02-08 13:49:52'),
(14050, 325, '344840', 'sandeepnangewani11@gmail.com', 'profit', '269', 'USD', '', 'completed', '2025-02-08 16:33:29'),
(14051, 325, '311617', 'sandeepnangewani11@gmail.com', 'profit', '273', 'USD', '', 'completed', '2025-02-09 00:23:44'),
(14052, 325, '78970', 'sandeepnangewani11@gmail.com', 'profit', '198', 'USD', '', 'completed', '2025-02-09 04:53:40'),
(14053, 328, '842997', 'deepgagandeepsingh90@gmail.com', 'profit', '16', 'Select currency', '', 'completed', '2025-02-09 04:54:04'),
(14054, 330, '969467', 'ksandhiya492@gmail.com', 'deposit', '48', 'USD', '', 'completed', '2025-02-09 10:16:53'),
(14055, 330, '576110', 'ksandhiya492@gmail.com', 'deposit', '263', 'USD', '', 'completed', '2025-02-09 10:25:51'),
(14056, 325, '45881', 'sandeepnangewani11@gmail.com', 'profit', '115', 'USD', '', 'completed', '2025-02-09 11:30:15'),
(14057, 328, '995771', 'deepgagandeepsingh90@gmail.com', 'profit', '16', 'Select currency', '', 'completed', '2025-02-09 11:42:08'),
(14058, 328, '923072', 'deepgagandeepsingh90@gmail.com', 'profit', '16', 'Select currency', '', 'completed', '2025-02-09 16:53:15'),
(14059, 325, '508386', 'sandeepnangewani11@gmail.com', 'profit', '210', 'USD', '', 'completed', '2025-02-10 07:14:20'),
(14060, 328, '263868', 'deepgagandeepsingh90@gmail.com', 'profit', '17', 'Select currency', '', 'completed', '2025-02-10 07:14:35'),
(14061, 325, '131692', 'sandeepnangewani11@gmail.com', 'profit', '189', 'USD', '', 'completed', '2025-02-10 09:45:24'),
(14062, 328, '492387', 'deepgagandeepsingh90@gmail.com', 'profit', '18', 'Select currency', '', 'completed', '2025-02-10 09:45:42'),
(14063, 325, '751499', 'sandeepnangewani11@gmail.com', 'profit', '153', 'USD', '', 'completed', '2025-02-10 14:31:44'),
(14064, 328, '627063', 'deepgagandeepsingh90@gmail.com', 'profit', '24', 'Select currency', '', 'completed', '2025-02-10 14:32:21'),
(14065, 325, '319903', 'sandeepnangewani11@gmail.com', 'profit', '187', 'USD', '', 'completed', '2025-02-11 07:00:55'),
(14066, 328, '87884', 'deepgagandeepsingh90@gmail.com', 'profit', '16', 'Select currency', '', 'completed', '2025-02-11 07:01:14'),
(14067, 330, '314605', 'ksandhiya492@gmail.com', 'profit', '29', 'USD', '', 'completed', '2025-02-11 10:55:25'),
(14068, 330, '184341', 'ksandhiya492@gmail.com', 'profit', '29', 'USD', '', 'completed', '2025-02-11 22:06:25'),
(14069, 325, '592226', 'sandeepnangewani11@gmail.com', 'profit', '156', 'USD', '', 'completed', '2025-02-11 23:15:08'),
(14070, 330, '773454', 'ksandhiya492@gmail.com', 'profit', '15', 'USD', '', 'completed', '2025-02-12 07:33:41'),
(14071, 330, '475163', 'ksandhiya492@gmail.com', 'deposit', '30', 'USD', '', 'completed', '2025-02-12 08:41:08'),
(14072, 330, '147499', 'ksandhiya492@gmail.com', 'profit', '29', 'USD', '', 'completed', '2025-02-13 06:40:27'),
(14073, 330, '229151', 'ksandhiya492@gmail.com', 'deposit', '24', 'USD', '', 'completed', '2025-02-13 09:29:44'),
(14074, 325, '962202', 'sandeepnangewani11@gmail.com', 'profit', '154', 'USD', '', 'completed', '2025-02-13 12:33:51'),
(14075, 330, '869275', 'ksandhiya492@gmail.com', 'profit', '32', 'USD', '', 'completed', '2025-02-13 14:58:49'),
(14076, 330, '668372', 'ksandhiya492@gmail.com', 'deposit', '30', 'USD', '', 'completed', '2025-02-13 19:25:36'),
(14077, 330, '109332', 'ksandhiya492@gmail.com', 'profit', '33', 'USD', '', 'completed', '2025-02-14 16:29:51'),
(14078, 325, '713658', 'sandeepnangewani11@gmail.com', 'profit', '135', 'USD', '', 'completed', '2025-02-14 18:06:42'),
(14079, 330, '869081', 'ksandhiya492@gmail.com', 'profit', '37', 'USD', '', 'completed', '2025-02-15 06:26:46'),
(14080, 330, '109420', 'ksandhiya492@gmail.com', 'profit', '28', 'USD', '', 'completed', '2025-02-16 07:09:08'),
(14081, 325, '970831', 'sandeepnangewani11@gmail.com', 'profit', '152', 'USD', '', 'completed', '2025-02-16 10:16:00');

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

--
-- Table structure for table `message`
--

CREATE TABLE `message` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `tranx_id` text NOT NULL,
  `email` text NOT NULL,
  `amount` text NOT NULL,
  `coin` text NOT NULL,
  `status` text NOT NULL,
  `proof` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `user_kyc`
--

CREATE TABLE `user_kyc` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `email` text NOT NULL,
  `fullname` text NOT NULL,
  `dob` date NOT NULL,
  `address` text NOT NULL,
  `phone` text NOT NULL,
  `gov_id_type` text NOT NULL,
  `gov_id_file` text NOT NULL,
  `proof_address_file` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_kyc`
--

INSERT INTO `user_kyc` (`id`, `client_id`, `email`, `fullname`, `dob`, `address`, `phone`, `gov_id_type`, `gov_id_file`, `proof_address_file`, `created_at`) VALUES
(66, 288, 'abubakarbhatti1997@gmail.com', 'Yasinbhatti ', '1997-12-25', 'Faisalabad', ' 0550480805', 'national_id', 'kyc/670ee8db41422_172903027052976422410324634820.jpg', 'kyc/670ee8db41423_17290303014184583412037356207233.jpg', '2024-10-15 22:12:43'),
(67, 295, 'samialsadig14@gmail.com', 'Anwar Haroon Alsadig ', '1985-01-01', '20 Anglesey street ', ' ‪+44 7865 174278‬', 'passport', 'kyc/6737b05f842d7_IMG_7143.jpeg', 'kyc/6737b05f842d9_IMG_7146.jpeg', '2024-11-15 20:34:39'),
(68, 295, 'samialsadig14@gmail.com', 'Anwar Alsadig', '1985-01-01', '20 Anglesey Street ', ' ‪+44 7865 174278‬', 'passport', 'kyc/6738edd8416f0_IMG_7142.jpeg', 'kyc/6738edd8416f1_IMG_7146.jpeg', '2024-11-16 19:09:12'),
(69, 282, 'ottodalton6@gmail.com', 'Ikp', '1996-11-05', 'Bnjsjs', ' 82993', 'drivers_license', 'kyc/677a79be30360_IMG_2430.png', 'kyc/677a79be30361_IMG_2429.png', '2025-01-05 12:23:26'),
(70, 312, 'mzsexyvirgo89@gmail.com', 'Jennifer Denise McCoy', '1971-09-04', '3870 Brumbaugh Blvd', ' 3137388371', 'drivers_license', 'kyc/678452cb3e396_IMG_20241209_220504523.jpg', 'kyc/678452cb3e398_IMG_20241209_220504523.jpg', '2025-01-12 23:39:55'),
(71, 317, 'zabi252@gmail.com', 'Zohaib Mansoor', '1988-01-25', 'POB jaurah kernana Teh Kharian Distt Gujrat', ' 00923001522665', 'national_id', 'kyc/6797bd5801730_IMG_1849.png', 'kyc/6797bd5801732_IMG_1848.png', '2025-01-27 17:07:36'),
(72, 322, 'ahtashammehmood@yahoo.com', 'Ahtasham Mehmood', '1982-09-05', 'Near slaughter house town kahuta tehsil kahuta district Rawalpindi punjab Pakistan ', ' 00923235891772', 'national_id', 'kyc/679e2732b1e79_IMG_20241128_141015.jpg', 'kyc/679e2732b1e7b_Screenshot_2025-02-01-18-48-46-868_com.google.android.apps.maps.jpg', '2025-02-01 13:52:50'),
(73, 326, 'midreesshad@gmail.com', 'Idrees Khan', '1999-08-04', 'Lane no 2 cant villa multan', ' 03178797838', 'national_id', 'kyc/67a46cdc0d1ac_Screenshot_20250206-130241_Gallery.jpg', 'kyc/67a46cdc0d1ae_Idrees Local (1).jpg', '2025-02-06 08:03:40');

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

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

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

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

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

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

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

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

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

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

