-- phpMyAdmin SQL Dump -- version 5.2.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Aug 07, 2026 at 08:55 PM -- Server version: 10.6.20-MariaDB-cll-lve -- PHP Version: 8.1.34 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 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: `fastline_matrix` -- -- -------------------------------------------------------- -- -- Table structure for table `admin_notifications` -- CREATE TABLE `admin_notifications` ( `id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `message` text NOT NULL, `is_active` tinyint(1) DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `admin_notifications` -- INSERT INTO `admin_notifications` (`id`, `user_id`, `message`, `is_active`, `created_at`) VALUES (1, 36, 'https://t.me/SwedCoinOfficial/1', 0, '2026-07-26 18:00:49'), (2, 36, 'Hello man', 1, '2026-07-26 23:34:45'), (3, 36, 'Rfffgt', 1, '2026-07-26 23:36:22'); -- -------------------------------------------------------- -- -- Table structure for table `crypto_wallets` -- CREATE TABLE `crypto_wallets` ( `id` int(11) NOT NULL, `currency` varchar(10) NOT NULL, `address` varchar(255) NOT NULL, `description` varchar(255) DEFAULT NULL, `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `crypto_wallets` -- INSERT INTO `crypto_wallets` (`id`, `currency`, `address`, `description`, `updated_at`) VALUES (1, 'USDT TRC20', 'TMsfL5WYDRyeor52WKoshTk1Ean4FMpXX2', 'USDT TRC20', '2026-07-26 17:56:29'), (2, 'USDT', '0x8Bee25d72EB2D465344d04d9DF23386bF79752E1', 'Usdt erc20', '2026-07-26 15:16:50'), (3, 'ETH', '0x8Bee25d72EB2D465344d04d9DF23386bF79752E1', 'Ethereum', '2026-07-26 15:16:32'), (5, 'BTC', 'bc1qkyt87v0at06n6yj9ny86n2q3ern066hnyez2qn', 'Bitcoin', '2026-07-26 15:16:07'), (7, 'SOL', 'F3RqEbcu1SzVYNYvqmzMTxnPCDpEEgtu4Ci2aMArxVBy', 'Solana', '2026-07-26 15:17:18'), (8, 'BNB', '0x8Bee25d72EB2D465344d04d9DF23386bF79752E1', 'binance', '2026-07-28 12:06:38'); -- -------------------------------------------------------- -- -- Table structure for table `deposits` -- CREATE TABLE `deposits` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `amount` decimal(15,2) NOT NULL, `method` varchar(50) NOT NULL, `wallet_id` int(11) DEFAULT NULL, `reference` varchar(100) DEFAULT NULL, `proof` varchar(255) DEFAULT NULL, `status` enum('pending','confirmed','rejected') DEFAULT 'pending', `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `deposits` -- INSERT INTO `deposits` (`id`, `user_id`, `amount`, `method`, `wallet_id`, `reference`, `proof`, `status`, `created_at`) VALUES (1, 46, 50000.00, 'admin_fund', NULL, 'It\'s me your sweetheart ', NULL, 'confirmed', '2026-07-24 18:36:49'), (42, 29, 1000.00, 'BTC', 5, '', 'uploads/deposit_proofs/9d41a834f1c8ea141387.jpeg', 'confirmed', '2026-03-20 10:41:49'), (43, 29, 1000.00, 'BTC', 5, '', 'uploads/deposit_proofs/53bb771c95915e206902.jpeg', 'confirmed', '2026-03-20 16:00:27'), (44, 29, 1000.00, 'USDT', 2, '', 'uploads/deposit_proofs/0b9b968557f024d7f810.jpeg', 'rejected', '2026-03-20 16:07:27'), (45, 29, 800.00, 'ETH', 3, '', 'uploads/deposit_proofs/cadb779af739971fda8c.jpeg', 'confirmed', '2026-03-20 16:13:02'), (46, 32, 200.00, 'USDT', 2, '', 'uploads/deposit_proofs/7c90f4cf33a93333859c.jpg', 'confirmed', '2026-03-22 22:56:48'), (47, 31, 5000.00, 'SOL', 7, '', 'uploads/deposit_proofs/dc1cabd011d5e1ac1350.jpg', 'confirmed', '2026-04-04 22:10:00'), (48, 33, 3000.00, 'SOL', 7, '', 'uploads/deposit_proofs/cf4f2f2536b02aac6e07.png', 'confirmed', '2026-04-12 00:33:32'), (49, 31, 5000.00, 'BNB', 6, '', 'uploads/deposit_proofs/7df59868cc11518e9d52.jpg', 'confirmed', '2026-04-12 06:09:03'), (50, 34, 2200.00, 'admin_fund', NULL, 'Rebranding Bonus ', NULL, 'confirmed', '2026-04-12 20:43:21'), (51, 31, 5000.00, 'USDT', 2, 'https://matrixglobalvault.com/app/user/invest.php', 'uploads/deposit_proofs/382904325f36093a5c28.png', 'confirmed', '2026-04-14 07:55:52'), (52, 35, 391370.00, 'BTC', 5, '119b8368fc24438de499e67207fb9ba87ec3a7985ab2ab2974ff13e7de944234', 'uploads/deposit_proofs/e6e2ea165fd362861f82.png', 'confirmed', '2026-04-17 21:20:11'), (53, 32, 550.00, 'BTC', 5, '', 'uploads/deposit_proofs/915889f6ff4041f29099.jpg', 'confirmed', '2026-04-20 22:06:58'), (54, 38, 337800.00, 'admin_fund', NULL, 'Swapnex.business funding ', NULL, 'confirmed', '2026-04-21 16:38:14'), (55, 44, 2000.00, 'BTC', 5, 'bc1q2jg0ayrfgst7njm7sfwxtpydzwjgneqpa9p4s5', 'uploads/deposit_proofs/4eca311dfdec951684ea.jpeg', 'confirmed', '2026-07-26 12:33:32'), (56, 41, 500.00, 'BNB', 6, 'Hkguyiiuiii99', 'uploads/deposit_proofs/b1b822e196bb9303c114.png', 'confirmed', '2026-07-26 12:34:15'), (57, 41, 100.00, 'BNB', 6, 'Yituffu', 'uploads/deposit_proofs/329d6f21be5de88c9a95.png', 'confirmed', '2026-07-26 13:28:24'), (58, 47, 500.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-07-30 07:42:30'), (59, 47, 500.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-07-30 07:42:31'), (60, 47, 239000.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-07-30 07:43:09'), (61, 47, 187000.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-07-30 07:45:25'), (62, 47, 1100.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-07-30 07:46:13'), (63, 68, 100.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-07-31 03:22:32'), (64, 68, 31700.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-07-31 08:58:36'), (65, 68, 3000.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-07-31 09:23:59'), (66, 80, 10960.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-07-31 10:23:25'), (67, 79, 10960.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-07-31 10:31:19'), (68, 81, 10500.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-07-31 11:35:12'), (69, 82, 5564.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-07-31 11:36:22'), (70, 46, 160.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-07-31 20:14:11'), (71, 93, 10500.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-01 09:44:35'), (72, 95, 10300.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-01 09:46:25'), (73, 96, 8555.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-01 09:47:18'), (74, 97, 10500.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-01 09:47:41'), (75, 97, 10500.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-01 09:48:07'), (76, 93, 10500.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-01 09:48:48'), (77, 98, 9250.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-01 09:49:41'), (78, 48, 16700.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-01 13:50:04'), (79, 70, 25430.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-01 13:51:23'), (80, 71, 15237.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-01 13:53:10'), (81, 92, 15031.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-01 13:54:11'), (82, 94, 9200.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-01 13:55:12'), (83, 104, 20872.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-03 23:32:12'), (84, 107, 22973.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-03 23:36:09'), (85, 65, 3728.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-04 00:03:22'), (86, 74, 42076.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-04 00:07:10'), (87, 87, 20040.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-04 00:08:24'), (88, 86, 15700.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-04 00:16:37'), (89, 109, 23720.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-04 01:43:17'), (90, 111, 18385.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-04 01:44:32'), (91, 113, 14800.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-04 02:00:13'), (92, 76, 155000.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-04 02:13:26'), (93, 91, 21000.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-04 02:14:59'), (94, 112, 193520.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-04 02:27:48'), (95, 110, 19850.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 02:16:57'), (96, 116, 15300.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 02:19:04'), (97, 117, 2300.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 02:19:44'), (98, 119, 3629.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 02:20:18'), (99, 120, 2980.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 02:20:45'), (100, 121, 1890.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 02:21:59'), (101, 118, 1900.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 02:22:32'), (102, 114, 3050.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 02:23:23'), (103, 122, 3550.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 02:23:47'), (104, 105, 85000.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 15:02:01'), (105, 129, 7890.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 15:03:16'), (106, 69, 8700.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 15:04:34'), (107, 73, 5300.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 15:05:46'), (108, 78, 58000.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 16:23:09'), (109, 123, 126780.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 16:24:22'), (110, 141, 21600.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 16:25:11'), (111, 142, 15200.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 16:25:53'), (112, 143, 9800.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 16:26:39'), (113, 84, 85000.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 16:34:08'), (114, 106, 3700.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-05 16:37:59'), (115, 152, 5500.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-06 12:28:49'), (116, 153, 3250.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-06 12:33:08'), (117, 115, 14580.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-06 12:41:16'), (118, 150, 6890.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-06 12:41:53'), (119, 134, 26000.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-06 12:43:18'), (120, 137, 13100.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-06 12:44:01'), (121, 135, 5100.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-06 12:44:42'), (122, 124, 8100.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-06 12:45:30'), (123, 149, 7900.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-06 12:46:16'), (124, 49, 5300.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-06 18:32:46'), (125, 144, 6800.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-07 13:22:53'), (126, 144, 1100.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-07 13:24:16'), (127, 83, 7900.00, 'admin_fund', NULL, '', NULL, 'confirmed', '2026-08-07 16:37:56'); -- -------------------------------------------------------- -- -- Table structure for table `investments` -- CREATE TABLE `investments` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `plan_id` int(11) NOT NULL, `amount` decimal(15,2) NOT NULL, `duration` int(11) NOT NULL COMMENT 'in days', `roi_percent` decimal(5,2) NOT NULL, `start_date` datetime DEFAULT NULL, `end_date` datetime DEFAULT NULL, `status` enum('active','completed','cancelled','pending') DEFAULT 'active', `roi_earned` decimal(15,2) DEFAULT 0.00 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `investments` -- INSERT INTO `investments` (`id`, `user_id`, `plan_id`, `amount`, `duration`, `roi_percent`, `start_date`, `end_date`, `status`, `roi_earned`) VALUES (1, 31, 7, 500.00, 1, 5.00, '2026-07-18 03:33:17', '2026-07-19 03:33:17', 'active', 0.00), (5, 22, 7, 200.00, 1, 5.00, '2026-01-12 18:11:10', '2026-01-13 09:11:10', 'completed', 10.00), (6, 26, 10, 3000.00, 3, 20.00, '2026-01-22 00:33:20', '2027-01-22 00:33:20', 'active', 600.00), (39, 29, 7, 100.00, 1, 5.00, '2026-03-20 10:43:41', '2026-03-21 10:43:41', 'completed', 0.00), (40, 29, 9, 100.00, 1, 15.00, '2026-03-23 07:20:56', '2026-03-24 07:20:56', 'active', 0.00), (41, 31, 7, 5000.00, 1, 5.00, '2026-04-11 16:02:30', '2026-04-12 16:02:30', 'active', 0.00), (42, 31, 8, 200.00, 1, 5.00, '2026-04-11 16:03:02', '2026-04-12 16:03:02', 'active', 0.00), (43, 34, 9, 100.00, 1, 15.00, '2026-04-13 03:28:10', '2026-04-14 03:28:10', 'active', 0.00), (44, 35, 17, 500.00, 1, 10.00, '2026-04-18 00:20:02', '2026-04-19 00:20:02', 'active', 0.00), (45, 44, 1, 200.00, 1, 10.00, '2026-07-26 12:38:59', '2026-07-27 12:38:59', 'active', 0.00), (46, 41, 1, 100.00, 1, 10.00, '2026-07-26 13:45:57', '2026-07-27 13:45:57', 'active', 0.00), (47, 46, 1, 160.00, 1, 10.00, '2026-08-01 13:18:25', '2026-08-02 13:18:25', 'active', 0.00), (48, 46, 23, 37000.00, 1, 40.00, '2026-08-01 13:35:03', '2026-08-02 13:35:03', 'active', 0.00), (49, 46, 23, 37000.00, 1, 40.00, '2026-08-01 19:19:45', '2026-08-02 19:19:45', 'pending', 0.00); -- -------------------------------------------------------- -- -- Table structure for table `loans` -- CREATE TABLE `loans` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `amount` decimal(15,2) NOT NULL, `interest_rate` decimal(5,2) NOT NULL, `duration_months` int(11) NOT NULL, `status` enum('pending','approved','rejected','repaid') DEFAULT 'pending', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `approved_at` timestamp NULL DEFAULT NULL, `repaid_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `loans` -- INSERT INTO `loans` (`id`, `user_id`, `amount`, `interest_rate`, `duration_months`, `status`, `created_at`, `approved_at`, `repaid_at`) VALUES (0, 29, 200.00, 5.00, 3, 'rejected', '2026-03-20 16:24:32', '2026-04-11 16:15:20', NULL), (0, 31, 1000.00, 5.00, 3, 'rejected', '2026-04-04 21:30:14', '2026-04-11 16:15:20', NULL), (0, 29, 5000.00, 5.00, 30, 'rejected', '2026-04-11 16:06:59', '2026-04-11 16:15:20', NULL), (0, 29, 500.00, 5.00, 3, 'rejected', '2026-04-11 16:21:33', NULL, NULL), (0, 29, 500.00, 5.00, 3, 'rejected', '2026-04-11 16:25:07', NULL, NULL), (0, 35, 500.00, 5.00, 3, 'rejected', '2026-04-18 00:49:31', NULL, NULL), (0, 38, 500.00, 5.00, 3, 'rejected', '2026-04-23 03:51:51', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `messages` -- CREATE TABLE `messages` ( `id` int(11) NOT NULL, `sender_id` int(11) DEFAULT NULL, `recipient_id` int(11) NOT NULL, `subject` varchar(255) NOT NULL, `message` text NOT NULL, `sent_at` timestamp NOT NULL DEFAULT current_timestamp(), `read_status` tinyint(1) DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `id` int(11) NOT NULL, `email` varchar(100) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `password_resets` -- INSERT INTO `password_resets` (`id`, `email`, `token`, `created_at`) VALUES (0, 'anthonyanthony8585@gmail.com', '919fd3e9a601cf12e56173269fe93b66d6273b3b97c3eb4e5de1f039e70c1a39', '2026-01-12 05:22:58'), (0, 'paulpete365@gmail.com', '83aa40e79055765d652950d08d6383055e07468e1462e73591b9eeef59cdf34b', '2026-01-12 15:18:10'), (0, 'sstrelle69@yahoo.com', '0ec349dda58f85b947427e4d15fe23b60c9cc60bcf40f8a329cb2bc96363a9b8', '2026-07-26 04:19:00'), (0, 'sstrelle69@yahoo.com', 'c52f8dfa28027462e7b9369ec45a23a09f7121a026bc97af0ad1f7e8b0b45939', '2026-07-26 04:19:13'), (0, 'cburg88@hotmail.com', '89e0dd82cfe6a1cc90e0d546535f10c7d62ef0bd89d18ab0265986223a172ad0', '2026-07-29 21:39:42'), (0, 'mjc777888999@gmail.com', 'f5e0b0adb591bc7a06c372437a01606f46eae06fdc31eee993320fc9e58774c9', '2026-07-30 07:46:03'), (0, 'delz810@gmail.com', 'bafe2256c68bf21b37f7238c58c2670721f32ccb22ad9e1efa729ead767785d1', '2026-08-04 17:36:09'), (0, 'ecraymundo@gmail.com', 'e90c36d0c625260076f9ee834e167f76dcdff05d679c62bf3e66829abc779b44', '2026-08-04 17:36:54'), (0, 'roblesjon58@gmail.com', '4ada1d760dce815e4e6f8ef02f467bf878c3a58f4fd52c240fa4744b6edf7afe', '2026-08-05 22:30:02'), (0, 'rosesallyfrancisco@yahoo.com', '97820440c9fe175ac387495cf338c82ad90a5ac068983d7793bc3ece13120f7c', '2026-08-06 19:14:07'), (0, 'rosesallyfrancisco@yahoo.com', '519b6059aea9219ec7de538b9ecccec1961b83e58c5edfef69f69a0f8c6a2c3b', '2026-08-06 19:15:07'); -- -------------------------------------------------------- -- -- Table structure for table `plans` -- CREATE TABLE `plans` ( `id` int(11) NOT NULL, `name` varchar(100) NOT NULL, `min_amount` decimal(15,2) NOT NULL, `max_amount` decimal(15,2) NOT NULL, `roi_percent` decimal(5,2) NOT NULL, `duration_value` int(11) NOT NULL DEFAULT 1, `duration_unit` enum('days','hours') NOT NULL DEFAULT 'days', `roi_interval` enum('end','daily','hourly') NOT NULL DEFAULT 'end', `duration_days` int(11) NOT NULL DEFAULT 0, `description` text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `plans` -- INSERT INTO `plans` (`id`, `name`, `min_amount`, `max_amount`, `roi_percent`, `duration_value`, `duration_unit`, `roi_interval`, `duration_days`, `description`) VALUES (1, 'SILVER PLAN', 100.00, 4999.00, 10.00, 24, 'hours', 'end', 0, '10% ROI After 24 Hours.'), (7, 'Apple Inc. (AAPL)', 500.00, 500000.00, 5.00, 30, 'days', 'daily', 1, '5% ROI paid daily.'), (8, 'Tesla Inc. (TSLA)', 500.00, 500000.00, 5.00, 30, 'days', 'end', 2, '5% ROI paid daily.'), (9, 'Crypto-related stocks', 500.00, 250000.00, 15.00, 20, 'days', 'daily', 2, '15% ROI paid daily.'), (14, 'Microsoft Corporation (MSFT)', 500.00, 200000.00, 10.00, 25, 'days', 'daily', 0, '10% ROI paid daily.'), (16, 'Meta Platforms (META)', 500.00, 250000.00, 5.00, 25, 'days', 'daily', 0, '5% ROI paid daily.'), (17, 'Amazon (AMZN)', 500.00, 5000000.00, 10.00, 35, 'days', 'daily', 0, '5% ROI paid daily.'), (20, 'Professional plan', 10000.00, 25000.00, 21.00, 7, 'days', 'end', 0, '21% ROI paid at end of 7 days.'), (21, 'Stake Holders plan', 20000.00, 999999999.00, 15.00, 30, 'days', 'end', 0, '15% ROI paid at end of 30 days.'), (22, 'Yearly plan', 5000.00, 999999999.00, 1.50, 24, 'days', 'daily', 0, '1.5% ROI paid at every end of 24 hours.'), (23, 'Gold plan', 26000.00, 999999999.00, 40.00, 5, 'days', 'end', 0, '40% ROI paid at end of 5 days.'); -- -------------------------------------------------------- -- -- Table structure for table `roi_settings` -- CREATE TABLE `roi_settings` ( `id` int(11) NOT NULL, `daily_roi` tinyint(1) DEFAULT 1, `roi_percentage` decimal(5,2) DEFAULT 0.50, `last_updated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `roi_settings` -- INSERT INTO `roi_settings` (`id`, `daily_roi`, `roi_percentage`, `last_updated`) VALUES (1, 1, 10.00, '2026-03-20 16:49:45'), (0, 1, 0.50, '2025-12-27 08:33:25'); -- -------------------------------------------------------- -- -- Table structure for table `settings_old` -- CREATE TABLE `settings_old` ( `id` int(11) NOT NULL, `key_name` varchar(50) NOT NULL, `value` text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `settings_old` -- INSERT INTO `settings_old` (`id`, `key_name`, `value`) VALUES (1, 'site_name', 'InvestPro'), (2, 'email_logo', 'assets/images/logo.png'), (3, 'from_email', 'noreply@investpro.com'), (0, 'site_name', 'InvestPro'), (0, 'email_logo', 'assets/images/logo.png'), (0, 'from_email', 'noreply@investpro.com'); -- -------------------------------------------------------- -- -- Table structure for table `signals` -- CREATE TABLE `signals` ( `id` int(11) NOT NULL, `trader_id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `asset` varchar(50) NOT NULL, `entry_price` decimal(15,8) NOT NULL, `target_price` decimal(15,8) NOT NULL, `stop_loss` decimal(15,8) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `subscriptions` -- CREATE TABLE `subscriptions` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `trader_id` int(11) NOT NULL, `amount` decimal(10,2) NOT NULL, `start_date` timestamp NOT NULL DEFAULT current_timestamp(), `end_date` timestamp NULL DEFAULT NULL, `status` enum('active','expired','cancelled') DEFAULT 'active' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `subscriptions` -- INSERT INTO `subscriptions` (`id`, `user_id`, `trader_id`, `amount`, `start_date`, `end_date`, `status`) VALUES (0, 46, 4, 15.00, '2026-07-29 20:37:42', '2026-08-28 18:37:42', 'active'), (3, 31, 4, 15.00, '2026-04-11 16:01:38', '2026-05-11 16:01:38', 'active'), (4, 35, 5, 129.00, '2026-04-18 00:21:38', '2026-05-18 00:21:38', 'active'), (5, 32, 4, 15.00, '2026-04-20 21:56:10', '2026-05-20 21:56:10', 'active'); -- -------------------------------------------------------- -- -- Table structure for table `traders` -- CREATE TABLE `traders` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `title` varchar(100) NOT NULL, `bio` text DEFAULT NULL, `avatar` varchar(255) DEFAULT NULL, `monthly_return` decimal(5,2) DEFAULT 0.00, `win_rate` decimal(5,2) DEFAULT 0.00, `subscribers` int(11) DEFAULT 0, `subscription_fee` decimal(10,2) DEFAULT 0.00, `is_verified` tinyint(1) DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `traders` -- INSERT INTO `traders` (`id`, `user_id`, `title`, `bio`, `avatar`, `monthly_return`, `win_rate`, `subscribers`, `subscription_fee`, `is_verified`, `created_at`) VALUES (4, 29, 'crypto', 'good trader', 'uploads/avatars/1f1143cb539d3a51a0e86d0e5ca3c919.jpg', 20.00, 100.00, 3, 15.00, 1, '2026-03-20 17:02:05'), (5, 36, 'Forex Pro', 'Results-driven Forex trader with a focus on steady and controlled account growth. Uses a proven strategy based on price action and market trends to identify high-probability trades. Emphasizes low drawdown, disciplined execution, and consistent performance over time.\r\nStrategy Style:\r\nTrend-following\r\nSwing + intraday entries\r\nLow drawdown focus\r\nStrict stop-loss always', 'uploads/avatars/43bec67c2f4a7987ac93bec5f9f01457.jpg', 9.70, 87.00, 1, 129.00, 1, '2026-04-17 23:44:31'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `full_name` varchar(100) DEFAULT NULL, `email` varchar(100) NOT NULL, `phone` varchar(20) DEFAULT NULL, `password` varchar(255) NOT NULL, `passphrase` varchar(32) DEFAULT NULL, `role` enum('user','admin') DEFAULT 'user', `status` enum('active','pending','suspended') DEFAULT 'active', `referral_code` varchar(50) DEFAULT NULL, `kyc_status` enum('pending','verified','rejected') DEFAULT 'pending', `kyc_document` varchar(255) DEFAULT NULL, `avatar` varchar(255) DEFAULT NULL, `balance` decimal(15,2) DEFAULT 0.00, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `username` varchar(25) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `full_name`, `email`, `phone`, `password`, `passphrase`, `role`, `status`, `referral_code`, `kyc_status`, `kyc_document`, `avatar`, `balance`, `created_at`, `updated_at`, `username`) VALUES (9, 'Matrixglobalvault', 'live@matrixglobalvault.com', 'COMING SOON', '$2y$10$V3M7S9k62n4RsY9L06v2yeMFPytykowM8px5FmYk/jZy430YVjTRi', '0a73934001b11126d98d6669e74d4ceb', 'admin', 'active', '31363302', 'verified', NULL, NULL, 0.00, '2026-01-12 05:21:01', '2026-07-27 20:41:25', ''), (31, 'Frederick', 'leoncentonze885@gmail.com', NULL, '$2y$10$DyDmMPo6BQKH5Soy16IL5ukUKdZDU0Z7vxpz4B8I9VKrtiDP3e44C', '1c2cdbfe70369b805c6c6d0850536066', 'user', 'active', '35978FED', 'verified', NULL, NULL, 14285.00, '2026-03-22 21:13:21', '2026-07-26 11:51:37', 'Future22'), (32, 'Beatrice', 'beatriceegli80127@gmail.com', NULL, '$2y$10$warwkhLQZCMuqb7o5DsSVumL5tDtoSFIOiEchNa3.pdp6mVpG2nF6', '6b279f67c88050e5b5ee45d1b54a505b', 'user', 'active', '3C953A82', 'rejected', NULL, NULL, 1285.00, '2026-03-22 22:54:07', '2026-07-03 09:10:54', 'Egli'), (33, 'benyt', 'elisabethtty14@gmail.com', NULL, '$2y$10$7k7uq7zBsWe7.m1Xwj9TDeQVsrusQuRhEGGf32RoBjGjO4Pn1scuO', 'd13efb83978759429c29016da9ba511d', 'user', 'active', '91F7B2DB', 'verified', NULL, NULL, 3000.00, '2026-04-12 00:27:07', '2026-07-03 09:10:54', 'benty44'), (34, 'skkk', 'konokkumar707@gmail.com', '01796836201', '$2y$10$Ud5tC.rR5mZxlJgkKnrDBefsBGzHnxb5NxdcwXp64RL6e7Lqci31m', '1e21e710c6dcd6ff17548e81276ad114', 'user', 'active', '6C532B0D', 'verified', NULL, 'uploads/avatars/34_1776080548.jpg', 2100.00, '2026-04-12 20:35:49', '2026-07-03 09:10:54', 'Skk75'), (35, 'Claus-Peter William Kröger', 'ivanov.tv45@rambler.ru', '', '$2y$10$kQdBcBnluulhfeyw4LD..O0IyoIzfJDUZf7lzSxTSfIXUnzm6N0ZS', '0471783a590b45ec42ccc5589addb39a', 'user', 'active', '5B5BADDD', 'verified', NULL, NULL, 1.00, '2026-04-17 20:55:34', '2026-08-04 05:12:49', 'Claue-Peter CEO'), (36, 'David Robinson', 'dbxjsjjs@gmail.com', NULL, '$2y$10$93lgw1NACbEnNBRjCb9RMeR7eiW.qVNmbwMUFPJb4UvUwTxEkOzp2', '5012f63d4995b55e5ebc0f51f5d3ca91', 'user', 'active', 'B09030CD', 'verified', NULL, NULL, 0.00, '2026-04-17 23:36:37', '2026-07-03 09:10:54', 'DavidR'), (37, 'Berramdane Djalil', 'seemesoon@duck.com', NULL, '$2y$10$tQsIvjLQJKK42TgJxWYEvuz3xZWylTlYzCXLbWpdCyMspYIyYBSXS', '0f07671db89851a8c22350beb2f4a70d', 'user', 'active', '3BD024A4', 'rejected', NULL, NULL, 0.00, '2026-04-21 03:18:25', '2026-07-03 09:10:54', 'seemesoon@duck.com'), (38, 'arafat rahman', 'arafat_cmc@hotmail.com', '+34645212452', '$2y$10$yd55OsYNla18nR5J1mkYvOVr2/J.s5STDLgVlIuMZVxpw4j3FjzHa', 'b920b43e6559e29675391e0b7d64155c', 'user', 'active', 'B59245D1', 'rejected', NULL, 'uploads/avatars/38_1776916241.jpeg', 1.00, '2026-04-21 16:34:59', '2026-08-04 05:13:11', 'arafat_cmc'), (39, 'Neto1', 'netopodence1@gmail.com', NULL, '$2y$10$GIdIILRu.f05XURUVh8ORuDs0lccJ5U8vdaO1VfQyyd1cMs7Cj6F2', NULL, 'user', 'active', '3D759301', 'rejected', NULL, NULL, 0.00, '2026-06-16 15:39:47', '2026-07-03 21:23:46', 'Neto1'), (40, 'Neto11', 'netopodence44@gmail.com', NULL, '$2y$10$cTz7g1Bi5kvishwXs0in6.rUeMVP52P8.zW4xRpPwqP6lTSENbooO', '9884c362011b3e965251a399dab0d513', 'user', 'active', 'F4B829B9', 'rejected', NULL, NULL, 0.00, '2026-06-16 15:40:55', '2026-07-03 21:23:31', 'Neto11'), (41, 'Adonis A. MacMillan', 'janileshinskys@hotmail.com', NULL, '$2y$10$kOOmz4XnaYWpM/KT2ONJluThCZ51u8vsqSUqXzEA1v1ilo9RfNFvG', '0943949c43e6bcf6974f68538b4d3611', 'user', 'active', '5F1B8280', 'verified', NULL, NULL, 500.00, '2026-07-02 11:14:27', '2026-08-01 13:34:53', 'Tty1'), (44, 'Mason', 'mason.tech00@gmail.com', NULL, '$2y$10$/Uo2EwvUVFrrH0HQuIOK6OsuOaHNDPxGZFjtb3KzZM9sj1.DuMzrC', '76142197d431a4c427caab27a9fb4554', 'user', 'active', 'C00248F4', 'verified', 'uploads/kyc/kyc_cdd1f23988e6f91aa655.jpeg', NULL, 1800.00, '2026-07-03 09:13:51', '2026-08-06 14:04:56', 'mason'), (45, 'ymansy', 'amoool44575@gmail.com', NULL, '$2y$10$tkP7vJD0QWsJu7KTGZVOru3uRaAsGYiSXLHiRmDygBRt7yjBy3Nxe', 'bebd09a7992e2da36a1e6de63ad16239', 'user', 'active', 'A735A810', 'rejected', NULL, NULL, 0.00, '2026-07-03 21:14:55', '2026-07-03 21:23:33', 'yman'), (46, 'Iliyana Ilieva', 'ileto.ilieva@gmail.com', '', '$2y$10$3F5SAqVhIAzYSUdG7C819O.X6.OywhoFQUg9AxgmaoONnuFYxUN82', 'a4c91d380fbc8619b2dd2a6d2467c6f4', 'user', 'active', '678F87A7', 'rejected', NULL, NULL, 10361.00, '2026-07-24 18:34:27', '2026-08-07 17:45:13', 'Ileto'), (47, 'Mary Jean Castillo', 'mjc777888999@gmail.com', '+18087770911', '$2y$10$c8VDsLixpqdMigVbr95RQu.pW.iTPH/ln.5t22lmeVyUoxYvSDfoG', '0c5e51c8f664e6f0a289e3ea1b93328b', 'user', 'active', '94C30F12', 'rejected', NULL, 'uploads/avatars/47_1785380620.jpg', 428100.00, '2026-07-25 21:05:28', '2026-08-06 01:19:42', 'MJ'), (48, 'Estrelita Pascua', 'sstrelle69@yahoo.com', '18088077703', '$2y$10$k.cW7QVVnI0xIt0evx7d5.w.MeABptP.hbfEivO2cLwb8RH818wky', '94e8aca17beef98080b1fcdaa9125849', 'user', 'active', '444495F3', 'rejected', NULL, 'uploads/avatars/48_1785390944.jpeg', 16700.00, '2026-07-26 04:17:45', '2026-08-07 09:26:26', 'Strelli1$'), (49, 'Catalina Bugarin', 'judybugarin23@gmail.com', NULL, '$2y$10$KsJDCMTAip0VVTNj3ORRuu.r2DhTtBiVbhafmq.xmgOizrs.i94Ha', '61bd9f175b90c6a3b470d9adfb3caef8', 'user', 'active', '71A59A1B', 'rejected', NULL, NULL, 5300.00, '2026-07-26 04:28:55', '2026-08-06 20:43:05', 'Judy1959'), (50, 'Lilia Remular', 'remularlili@gmail.com', NULL, '$2y$10$p92vkCx3.glo/iFlGYGlpeBuz7TYPRYYcnMV5oWRXnOURRa23bRlK', NULL, 'user', 'active', 'C9D2F26A', 'rejected', NULL, NULL, 0.00, '2026-07-26 04:36:54', '2026-07-31 02:58:04', 'Lilia1952'), (51, 'Lilia Remular', 'remularlili1952@icloud.com', NULL, '$2y$10$0pv7mRyR6G6pcgdA2pyOt.EVXORSUHjWfOGq/1oJYlfyagxalOlA2', '2cfb62b9a6ff933c4acfcff82e52d9cd', 'user', 'active', 'CA657FAD', 'rejected', NULL, NULL, 0.00, '2026-07-26 05:03:14', '2026-07-31 03:00:42', 'Lilia'), (61, 'Pascal', 'pascal.siegfried0@gmail.com', NULL, '$2y$10$8trFyLrEDezCpfX5/gJ6y.iNijA4Dnl0.u/9uBjHsDs7Yp2ZlNkrm', 'fd5969183468f787a7ccd639ed8a04a2', 'user', 'suspended', '5F5A3915', 'rejected', NULL, NULL, 0.00, '2026-07-26 21:10:04', '2026-07-31 02:45:50', 'Pascal'), (62, 'Lilibeth M Castro', 'Lcdomincel@yahoo.com', NULL, '$2y$10$3ruI6snfIlfrzU/wruHnWOOxWf8URiRa3pXT7I.hxFKoYHuO46Gh6', '6fef429da12677e84808742f363e7f66', 'user', 'active', 'EDB578C7', 'rejected', NULL, NULL, 0.00, '2026-07-27 03:04:44', '2026-08-01 05:09:29', 'Lilibeth'), (63, 'Christine Burg', 'cburg88@hotmail.com', NULL, '$2y$10$0LpHgiAsmR0XWPBIPwJoMO5fs8VCssKRG927l0wz06YWrzAP.jtdG', 'c0eb630765cdc91a4aa26bac9697c9db', 'user', 'active', 'EA6384BB', 'rejected', NULL, NULL, 0.00, '2026-07-28 01:59:41', '2026-08-05 23:14:51', 'Cb'), (64, 'Teoderica McDill', 'retsy2023@gmail.com', '+16192066188', '$2y$10$kQm3lM.pXrkJIHUbKm5IEewmWRlXkfGGYeQ.1d5uxViFHb1Sz6LD.', 'b829084688789a526d4b847b34d9e4e9', 'user', 'active', '7D27CCE0', 'rejected', NULL, NULL, 0.00, '2026-07-28 22:43:53', '2026-07-31 04:55:10', 'matrica26'), (65, 'Alma Adolph', 'Almaadolph2@gmail.com', '', '$2y$10$7IsMhB3ZO1nYXLd7xCejfOEDjjSeOw7CxAa1cA4dCXtdKEV9UxPJ2', '99b0e92d69bc146d74e51aec6f919f32', 'user', 'active', 'ACAC416D', 'verified', NULL, NULL, 3728.00, '2026-07-29 00:04:00', '2026-08-06 23:21:02', 'Aadolph'), (66, 'Sunday June Kenison', 'joyoustoday72@gmail.com', NULL, '$2y$10$sUUyMgJe3tAA1Sdr5WWPTOpImPyTzD9XqYhGWCJWOCR.8iHYRG32u', '20f3a1c1d8471bf4c14c31a0c6c0ea6f', 'user', 'active', '9D3FBF58', 'rejected', NULL, NULL, 0.00, '2026-07-30 00:16:52', '2026-08-05 07:24:39', 'Sunday'), (67, 'Michelle Jose', 'josemichelle416@gmail.com', NULL, '$2y$10$p3zM6IMnR0h/KmKFofztEe7Dq6TaGyqr2ZrB/dXurtxT2fnkpUes6', 'fbd661d4a9d64841978fdaeaade04d04', 'user', 'active', 'A3E29808', 'rejected', NULL, NULL, 0.00, '2026-07-30 02:57:45', '2026-08-06 10:03:55', 'Michelle Jose'), (68, 'Lyro Castillo', 'castillyro78@gmail.com', NULL, '$2y$10$IBEOSzIaMZjoP1Xaqbv7nOg06JwX5y8wHuYfhpFQh5IXeSp8F6NxG', '480d1525b3a78a018d30662474dcc50f', 'user', 'active', 'D0BE466E', 'rejected', NULL, NULL, 34800.00, '2026-07-30 04:06:05', '2026-08-02 12:31:29', 'Lyro'), (69, 'Arlene De Leon', 'deleonace889@gmail.com', NULL, '$2y$10$rEgJvU9jct5QrrIp7vLnM.aJxNySmgLxGEQGm4Z83h.YyoD.oBnyK', '9baeadbd8be99eceb8483693aa6276ff', 'user', 'active', '323A5CBB', 'rejected', NULL, NULL, 8700.00, '2026-07-30 04:29:26', '2026-08-05 15:04:34', 'Leen'), (70, 'Teresita Ariola', 'ariolateresita678@gmail.com', '8086365283', '$2y$10$fxp57LmVK6wy.0lD/Y0.d.2JeI4g0gL0t3zrvwhWwGKdOJiyJpoH.', 'd9d4a566ccfcf28d808324f71a4a8716', 'user', 'active', '6B52DDAB', 'rejected', NULL, NULL, 25430.00, '2026-07-30 05:59:02', '2026-08-06 04:27:43', 'Tessie1'), (71, 'Alvin Nakamura', 'starpinay1971@gmail.com', NULL, '$2y$10$Ybm.P1R3b04DnOZX7hkObOXGGbi.lF5gIemyFaombE5QhY88CG2d.', 'ac940eb99492ca794fa9f4fc18085216', 'user', 'active', 'E1FAE03C', 'rejected', NULL, NULL, 15237.00, '2026-07-30 06:19:34', '2026-08-01 16:37:59', 'Alvin1'), (72, 'Rodson De Leon', 'rodsondeleon1@gmail.com', NULL, '$2y$10$oLKnFHA0gMm4Fbn6rGd7tOU6uDMS7iNwCH661X4TUIev/x3lnr8oO', NULL, 'user', 'active', '4A6C81EF', 'rejected', NULL, NULL, 0.00, '2026-07-30 07:37:14', '2026-07-31 02:58:13', 'Rod'), (73, 'Rodson De Leon', 'rodeleon027@gmail.com', NULL, '$2y$10$COG70BPKNqNFZvPXNzPd2.eGpF1FCIn8WTKxWqRxN.zlYjubZwIY6', 'e4f3a6ca1ea5f64183b040eecf701ca4', 'user', 'active', '0C175BDD', 'rejected', NULL, NULL, 5300.00, '2026-07-30 07:41:33', '2026-08-05 15:05:46', 'Rodz'), (74, 'Romeo', 'Romyintano@yahoo.com', NULL, '$2y$10$X3sVrQHoQFa0qqVU3dO1oOV/oRUl0G0LnPzxS1SEEGrkxuvlVzbZ6', '29d0ae5327a7d399719d27d79006bfbc', 'user', 'active', '98124DA8', 'rejected', NULL, NULL, 42076.00, '2026-07-30 08:48:08', '2026-08-04 07:28:20', 'Rintano'), (75, 'Elma Bronu', 'Elmabruno@icloud.com', NULL, '$2y$10$kOodbDAAxqP30uZtr3uoqekzcGZF9r/gCYpex6N5ckq0jnRVUDaIy', NULL, 'user', 'active', 'F5DE0020', 'rejected', NULL, NULL, 0.00, '2026-07-30 08:54:35', '2026-07-31 02:57:57', 'Ebronu'), (76, 'May Jean Melchor', 'mjtmelchor@gmail.com', NULL, '$2y$10$roe1rgAvX8189RPreYA9n.Ac7T2Vi0KOXMA3Cc63Vg736FD9QjOde', '86a96db0eadc5fc4c7368b7ef29d9472', 'user', 'active', '5C505BB0', 'rejected', NULL, NULL, 155000.00, '2026-07-30 18:08:42', '2026-08-04 02:27:51', 'Mmelchor5'), (77, 'April Ritz', 'apeclipz@gmail.com', NULL, '$2y$10$a9oNq9opNhaxEPd2sETKxOokWHmO4pSz9RspgsRd4j3oSO5fjxl1m', '8d98b67ccfff1ab6134daf9961228a26', 'user', 'active', 'DF752714', 'rejected', NULL, NULL, 0.00, '2026-07-30 23:20:05', '2026-07-31 02:57:20', 'Apesauce'), (78, 'Neelam', 'sneelam027@gmail.com', NULL, '$2y$10$TkK9QrF/VOa91cbyQ8Ih1e3Mu/z8yKIVP.o6U/xz.nM5Y1Hpdj/Ye', '0298d299a0b229ea4bd2478a0c15b4c7', 'user', 'active', '0019310A', 'pending', NULL, NULL, 58000.00, '2026-07-31 04:00:35', '2026-08-05 16:23:09', 'Sharma'), (79, 'MaryLinda Castillo', 'marylindacastillo1214@gmail.com', NULL, '$2y$10$jQeynnGhEXEJkKDS4GWwIu9k2Zro2T4qrB/xKIYeBIM7plYI/89uG', '12ef81e0421784e491786133b43071bb', 'user', 'active', '0BFD5D4F', 'pending', NULL, NULL, 10960.00, '2026-07-31 10:06:47', '2026-08-02 00:07:53', 'MaryLinda'), (80, 'Peachie Castillo', 'castillopeachie6@gmail.com', '', '$2y$10$DFLAGiyIbYViewwlZeXpPefzQvEkyNQpgyhbUXP5CzI485IR/fI2u', '6ff9e277a18a2ddf7d2552f4d8102fa7', 'user', 'active', '6AE5D930', 'pending', NULL, NULL, 5980.00, '2026-07-31 10:20:31', '2026-08-02 00:08:41', 'Peachie'), (81, 'Prudencio Castillo', 'odencastillo1968@gmail.com', NULL, '$2y$10$WgurFQaXC8k/V1pmYFyVrO3bEAB6HSaqTRHa4qAQongm/YbZnmlxi', '68201eb9fd95ce1093071ef9c47f5a4d', 'user', 'active', '317D1DEE', 'pending', NULL, NULL, 10500.00, '2026-07-31 11:13:53', '2026-08-02 00:08:32', 'Oden Castillo'), (82, 'Myla Castillo', 'mylac8179@gmail.com', NULL, '$2y$10$3lDcIPX6UuR8NUAwrx194OEMQeE.1uL1waauGcrZgWZMsFRBur.Ii', 'c8fbecd67b6e6f707e08f454c97e65a0', 'user', 'active', '52176029', 'pending', NULL, NULL, 5564.00, '2026-07-31 11:27:35', '2026-08-02 00:06:31', 'Myla'), (83, 'Janice Pascua', 'jojanp1@gmail.com', '+1 415 578 8457', '$2y$10$KLBVOXSseC5EvRGpsBuLkO2mxsqdOECAfsKJdD.eUlLWmot12hOCe', '8d0e41351b549556425bbbdf8cb6a915', 'user', 'active', '3D40D456', 'pending', NULL, NULL, 7900.00, '2026-07-31 18:21:14', '2026-08-07 17:15:48', 'janicep12'), (84, 'Edna Marr', 'marr.mariaedna@gmail.com', '19254487148', '$2y$10$OZ250wboBZWhBxIqn8gdSeGBFl6KeHKU.fBd1T3tCbx3lXVfxOxla', '37a3cdc301b692600b4f475a91845bae', 'user', 'active', '6FC1F0CC', 'pending', NULL, NULL, 85000.00, '2026-07-31 18:28:29', '2026-08-07 15:33:42', 'ednamarr'), (85, 'Alma Adolph', 'aadolph81@icloud.com', NULL, '$2y$10$ydg7jy7FK/8xkLpo6eTj0eT4I1VhTBiQI85T8sDdbsgOnyJ.KzE.S', '1741c7bb6fab72a23b35ade8cb134591', 'user', 'active', '13178CFE', 'pending', NULL, NULL, 0.00, '2026-07-31 18:53:15', '2026-08-04 05:02:41', 'piano'), (86, 'Merlyn Botelho', 'Mbotelho65@gmail.com', NULL, '$2y$10$bCUuCZbVlMNfLiMLqxEd6.4gZTrhC4hXXkCFvb08cMVNHCFJW2b6i', '64924659df5011d62f94d594f9d15a9f', 'user', 'active', 'FFAC8C62', 'pending', NULL, NULL, 15700.00, '2026-07-31 19:31:18', '2026-08-05 06:31:26', 'Merjohn'), (87, 'John Botelho', 'Jbotelho59@gmail.com', NULL, '$2y$10$15rWXr51nBdlD.ybm1oLaOFj9XqgBPTYgQfl1mWfzj.dxH0p86P66', '1de348c0ffad00bb6c88b12e2ac46331', 'user', 'active', '64F7F214', 'pending', NULL, NULL, 20040.00, '2026-07-31 19:36:35', '2026-08-04 04:58:09', 'Jbotelho'), (88, 'Bella', 'bellaariota@yahoo.com', NULL, '$2y$10$S/UL2A6qDH3x96I9/22ij.UVINdVu9GScFWavg7KCCpHDydg3HJWC', '93c9ea3796de0a9e33742e535b4d0358', 'user', 'active', '1A603B61', 'pending', NULL, NULL, 0.00, '2026-07-31 20:16:02', '2026-08-02 07:23:48', 'Bella1115'), (89, 'Frank', 'ariotafrank@yahoo.com', NULL, '$2y$10$FLao8x2W402ah9SXbxB4PukVVn6QQN18I5MCIpbNKgqqIgf717Ha6', '7be49fa30886a72b2d116e560bc04de9', 'user', 'active', '86612410', 'pending', NULL, NULL, 0.00, '2026-07-31 20:31:04', '2026-07-31 20:32:27', 'Frank0720'), (90, 'Bhless', 'bhlessariota@gmail.com', NULL, '$2y$10$vT0LQzL6RFmWBF2PIwH5g.QT7UjSD8nHqxvIDscu3vS6K10vwFhmK', 'f98344efa994d721b6f1b2be4ee26174', 'user', 'active', '63243745', 'pending', NULL, NULL, 0.00, '2026-07-31 20:44:36', '2026-08-02 07:24:18', 'Bhless0218'), (91, 'Benjamin P Melchor', 'benmelchor@gmail.com', NULL, '$2y$10$wTNctNwQe1u9sCd1ehu0SOV2Ml/QJRGWTsA4awY8Lcwn7oAD4e2SC', '4eff5ae3032837ccec419c2c4dc28e44', 'user', 'active', '2D186D51', 'pending', NULL, NULL, 21000.00, '2026-07-31 23:23:24', '2026-08-04 02:29:00', 'Bpmelchor5'), (92, 'Mediatrix Matute Jaucian', 'Pestrelle47@yahoo.com', NULL, '$2y$10$ma2NUo6k1Ky63khvkp450O3i.DPSWwlCtFPPBV1UmP8jrjfafDS3W', '4947123ac73f1abc5406125584ca4bd6', 'user', 'active', 'C7B32D95', 'pending', NULL, NULL, 15031.00, '2026-08-01 04:44:20', '2026-08-04 20:11:26', 'Meddy1'), (93, 'Rejean Nasu', 'rj888corp@gmail.com', NULL, '$2y$10$SqZ9VQMtquKJ3ZZjO.Ov8.jP4bEfYkiMWy5IT1S.sJQjpI7xSVM9W', '63e3996d9da9906ed852f9663b86f4f9', 'user', 'active', '663F9A41', 'pending', NULL, NULL, 21000.00, '2026-08-01 07:29:12', '2026-08-01 09:48:48', 'Rejean'), (94, 'Pedro Rex Solano', 'pedro_rex22@yahoo.com', '', '$2y$10$Tbp4ksuYjtZ5I.TyasGLeuXypRYNOoLVE7dgj9/ZkCQAyU1KYy88q', 'c45bae67c87835691475666786879e36', 'user', 'active', 'EB09F343', 'pending', NULL, NULL, 15200.00, '2026-08-01 08:29:24', '2026-08-05 02:58:42', 'Rex'), (95, 'Matias Alejandro Zuniga Medina', 'mz888corp@gmail.com', NULL, '$2y$10$mCvo0K2JtYsAPTEOSZTaQuZBiXgT0kLoTd8br78bizlP8bsM4NfzG', '2124041e63590c081744dd4421d164fe', 'user', 'active', '066ADBCE', 'pending', NULL, NULL, 10300.00, '2026-08-01 08:38:18', '2026-08-02 00:07:27', 'Matias / matias1234'), (96, 'Rodolfo Efrain Zuniga Medina', 'rod.stifler08@gmail.com', NULL, '$2y$10$VyCSCKGWFQ.K3rKaJZ1ei.SNQtiaZyh6.CmDtTJxJqevRJVSKNL5y', '6fd4047c963149a6b6734bb918eec5d2', 'user', 'active', '19ED1A6C', 'pending', NULL, NULL, 8555.00, '2026-08-01 08:50:37', '2026-08-01 09:47:18', 'Rodolfo'), (97, 'Noel Peter Henry', 'nph888corp@gmail.com', NULL, '$2y$10$SdN0BoGfxtvIPRYixDOfqe7w3kQT/oia8glww/ieqXlE6AQ/3LqzK', '91e76cd9cd936491c9c604850856584b', 'user', 'active', 'FE637396', 'pending', NULL, NULL, 21000.00, '2026-08-01 08:54:51', '2026-08-02 00:05:07', 'Noel'), (98, 'Rollen Castillo', 'rollencastillo54@gmail.com', NULL, '$2y$10$aHcGGXU.U/Cf5WdRztMUVOaicA4uqrlBmDMPGunliFM5HOkRiudgy', '1fa77f5202fd3c684b3aefbf40fc9b2c', 'user', 'active', '5E6FDA86', 'pending', NULL, NULL, 9250.00, '2026-08-01 09:00:40', '2026-08-02 00:08:06', 'Rollen'), (99, 'Sherry Velaaco', 'sherry_velasco@yahoo.com.ph', NULL, '$2y$10$8NtvuIRfzHvtCW0liIqML.o3A6upfQHtRAzRuRJNFxMMkalVJForK', '00d97075295cf1329cad2b471dd0524b', 'user', 'active', '56DF4529', 'pending', NULL, NULL, 0.00, '2026-08-01 19:10:34', '2026-08-01 19:12:54', 'Sherry123488'), (100, 'Francis', 'metapod.808@gmail.com', NULL, '$2y$10$I.xcGjUY2ZJ.qKyjwGpddORc5B5GZj4SV3e2cGOyGNH0wLmezW8lG', NULL, 'user', 'active', 'D2C47E19', 'pending', NULL, NULL, 0.00, '2026-08-02 07:28:58', '2026-08-02 07:28:58', 'Aiko808'), (101, 'Jessabel', 'ariotajessabel808@gmail.com', NULL, '$2y$10$moa8uL5L6zIeOIibr8qFZu2onYNJ3njXWuOuelddCBgbI1ppxEiE2', NULL, 'user', 'active', '108AF43C', 'pending', NULL, NULL, 0.00, '2026-08-02 07:31:13', '2026-08-02 07:31:13', 'Jessabel808'), (102, 'Reynalda Amos', 'nelda.amos@yahoo.com', NULL, '$2y$10$Bs2/qO.X9sQejhgvEmo5vOX5WUhoWtWqw78z5xr8MRFrBCQ3bs/9y', '5ce82a220960ce25863584dbcacec956', 'user', 'active', '2C200D7C', 'pending', NULL, NULL, 0.00, '2026-08-02 20:27:04', '2026-08-02 21:03:43', 'Neldz1'), (103, 'Napoleon Amos', 'napamos@yahoo.com', NULL, '$2y$10$yEsuTAiTMLQ8WQ4Oafw5me3NI8QhM/Vd1.DGZU9i.tb7TBlV3A4Xi', '18f9d3b761d088406b9ac5c87947e9cd', 'user', 'active', 'D9A1DBC0', 'pending', NULL, NULL, 0.00, '2026-08-02 21:29:41', '2026-08-02 21:30:27', 'Napamos1'), (104, 'Caroline Nascimento', 'carolnclayt@aol.com', NULL, '$2y$10$zleTnwOIdWyHPGWUQGoMwe1PLJls5SFhQidzISZhL8ZlB8IDa/6Eu', 'aca4d9f728b7d8897296b303af10efdf', 'user', 'active', '1E5B0959', 'pending', NULL, NULL, 20872.00, '2026-08-03 05:49:49', '2026-08-03 23:38:56', 'Cnas808'), (105, 'Edna Marilou Dumayas', 'Marilou.dumayas@gmail.com', '', '$2y$10$ryH3gVmyHhzuBrSkhFkT3.9y.e5SIcKci9t04AFUGM3HhYxSNt6uG', 'd33a382b4e2263f3535641c20fd45d4d', 'user', 'active', '53D2A7C0', 'pending', NULL, NULL, 8500.00, '2026-08-03 07:31:58', '2026-08-05 23:48:20', 'Edna1'), (106, 'Antonio Bantillo', 'Tonibantillo@yahoo.com', NULL, '$2y$10$TeTlEZJqNFGbBcu2FBauyOXzKrBHST.zN1OuypKSAw4XrdIyU0Ioq', '3fd4bcdbb1c2d831849cc25aa2ed5ca2', 'user', 'active', 'CD6870DF', 'pending', NULL, NULL, 3700.00, '2026-08-03 08:38:04', '2026-08-05 22:43:10', 'Anton1'), (107, 'Chelsea Williams', 'tehane808@aol.com', NULL, '$2y$10$0MygHAfSwqUiTzw4tdb48OUNg4HnTWAx0YvcCxXcbCEd9JxfHzz0O', 'c826af8bcfeb3bf6885407ed72034d82', 'user', 'active', 'B92A1DD4', 'pending', NULL, NULL, 22973.00, '2026-08-03 08:43:30', '2026-08-03 23:38:16', 'Tehane808@aol.com'), (108, 'Capri Limbaga', 'kulani143@aol.com', NULL, '$2y$10$mQLmDygpN6jmXeAklWYMruEKhXEheLBhEMS5dqn9msG/Ljst9TI.O', '3b2c57161964c827ee13dcf039c85663', 'user', 'active', 'EC535ADE', 'pending', NULL, NULL, 0.00, '2026-08-03 08:48:12', '2026-08-03 09:38:29', 'Kulani808'), (109, 'Cierra Correa', 'cecnas@yahoo.com', NULL, '$2y$10$23nOMaRxl0Na1Ky95XU2ieDJTaa3JDoPfkzrEhAJTE9l9QVh/Z8yK', 'e22241f5bf8da147903ee38f1342fc95', 'user', 'active', '930D7C10', 'pending', NULL, NULL, 23720.00, '2026-08-03 20:37:04', '2026-08-04 01:43:17', 'CC808'), (110, 'Capri Limbaga', 'capri143@yahoo.com', NULL, '$2y$10$PwqoUMZ7DM5wsftKSi8WKOiImZlxuBjeoqVkRYqBWh9Lh.RM353TC', NULL, 'user', 'active', 'D4BE8A81', 'pending', NULL, NULL, 19850.00, '2026-08-03 23:29:59', '2026-08-05 02:16:57', 'Capri808'), (111, 'Capri Limbaga', 'kulani143@yahoo.com', NULL, '$2y$10$Ck0dFTAFf0vQq4B.umDc6.GZSxpfAGCARWXhCLFLID94mE4lLFAXu', 'e6b5560addc810be52d0e1854e4fad70', 'user', 'active', 'FB40975E', 'pending', NULL, NULL, 18385.00, '2026-08-03 23:35:32', '2026-08-04 01:44:32', 'Limbaga808'), (112, 'Ian Fernandez', 'ian@imfvisions.com', NULL, '$2y$10$wpFKXWKwNIXqnMzn8.5OeeFcjfKyYPa1TumMvVeTBxJ910xEf1fH2', '71fd4255544f9e2a6dece77cfa1ca866', 'user', 'active', 'F3FB5E5E', 'pending', NULL, NULL, 193520.00, '2026-08-04 00:29:34', '2026-08-04 02:29:26', 'Ian'), (113, 'Jolyn Cookman', 'Jolyncookman@gmail.com', NULL, '$2y$10$qv0cIOK.8Z5hHMtuoyAsweCcLjv3/y6pojF/Bi1HB5bCyr6ATuIZi', 'a804984fc3be77880fb52c9dcfa13e50', 'user', 'active', '1CFD6084', 'pending', NULL, NULL, 14800.00, '2026-08-04 01:36:09', '2026-08-04 04:24:48', 'Jcookman'), (114, 'Edward Williams', 'eddie8872@gmail.com', NULL, '$2y$10$IKkK7hw9FF2ofqsMJEVbDu1G42sKLe0suRFnvV7S0t7MmW1Qr8kdq', '5678f3e03ccc3944e32746a2804a3865', 'user', 'active', '6162E3DF', 'pending', NULL, NULL, 3050.00, '2026-08-04 02:27:54', '2026-08-05 02:23:23', 'Edward808'), (115, 'Rose Sally Francisco', 'rosesallyfrancisco@yahoo.com', NULL, '$2y$10$jIrVEfG8ccuWBLVjWCktkuDIx5f6F0yhX2nojxg6FJH/7/GZrDZem', '980a7fb6cbdf3fa684841ad3d73be4dc', 'user', 'active', 'C65C57D6', 'pending', NULL, NULL, 14580.00, '2026-08-04 02:30:53', '2026-08-06 19:28:23', 'Rfrancisco'), (116, 'Roger Hirai', 'rogerman33@aol.com', NULL, '$2y$10$Zbh7tUw5BOPSKCEUt8Dc1eX37suPlJBGDm6zf161A2mXw5K4W3vFi', NULL, 'user', 'active', '30EF5FB3', 'pending', NULL, NULL, 15300.00, '2026-08-04 02:36:54', '2026-08-05 02:19:04', 'Roger808'), (117, 'Farrah-Ann Hirai', 'gantejayla@gmail.com', NULL, '$2y$10$S/n4IfA58uqqoIo9n17cFOwoPmLsR.pRlFA9RbiGFu/FI/CzT74K2', 'f70e5c2958865a5d4f08bb4d4f9dc471', 'user', 'active', '336EE933', 'pending', NULL, NULL, 2300.00, '2026-08-04 02:39:55', '2026-08-05 02:19:44', 'Jayla808'), (118, 'James Fernandez', 'J52fernandez@gmail.com', NULL, '$2y$10$kYEXsvhNqb2HvCCcsSvgMOuBuZKYwTNgwEAe8GwQiC7KvCJlcb8bq', 'fc421510007431ec7ff324ef163e6d1d', 'user', 'active', '568015AD', 'pending', NULL, NULL, 1900.00, '2026-08-04 02:45:22', '2026-08-05 02:22:32', 'James808'), (119, 'Morris Kamealoha', 'kamealoha@hotmail.com', NULL, '$2y$10$0Zus2YaJ/PjRXTC3u5LAe.vvnAyxwIVX9UJp65U14vHKxBcdogID2', '396b80588e320b0655c45011983c6ad1', 'user', 'active', 'E3A3DA78', 'pending', NULL, NULL, 3629.00, '2026-08-04 02:55:35', '2026-08-05 02:20:18', 'Morris808'), (120, 'Veronica Kamealoha', 'vkamealoha@yahoo.com', NULL, '$2y$10$xmDDrA.5wADCqpVEXteVEOXV2v8PM8yFcCjEpKVXxJnBbgFj3Z8MC', '2c03ef3ae6784718ed0c29f6eed9a812', 'user', 'active', '4396896F', 'pending', NULL, NULL, 2980.00, '2026-08-04 02:59:42', '2026-08-05 02:20:45', 'Nica808'), (121, 'Georgenalyn Hewlen', 'georgenalynhewlen@yahoo.com', NULL, '$2y$10$R/w0xaHdG7JjdgQ7lK56pORTvlIGKaaNT/toQimG7NgcgP19zePtm', '4a4d695c88b3a8ae0d146eadf20fff68', 'user', 'active', 'AA387FE1', 'pending', NULL, NULL, 1890.00, '2026-08-04 03:04:15', '2026-08-05 02:21:59', 'Gina808'), (122, 'Adam Limbaga', 'caprilimbaga@aol.com', NULL, '$2y$10$yerbmSmacNAetLfL8.nYXu168EVqqw1LZoPCVkm3OCAgsC6w06fSC', '75ae619d5db8e92bef438880b6b5c45b', 'user', 'active', '9FFE0CFB', 'pending', NULL, NULL, 3550.00, '2026-08-04 04:14:25', '2026-08-05 02:23:47', 'Adam808'), (123, 'R. Kumar Sharma', 'ryansharma760@gmail.com', NULL, '$2y$10$w/1Ipxxk25dXwOZeibhX9e/t2VJyC8or6xHNkqln4ylenKJbP7jMW', 'b78fb86c45cb34d5a37d6df1699d62ef', 'user', 'active', 'F631E74A', 'pending', NULL, NULL, 126780.00, '2026-08-04 07:21:56', '2026-08-05 16:24:22', 'Kumar'), (124, 'Frecia D.Aludino', 'freciadomingoaludino@gmail.com', NULL, '$2y$10$SlBHpNR.RwUhHGOGm6ySYumB7.vEnyvEwwFvTy1EB./YYQ5mvGePi', '67da7fca85f185ce728c56c1e3d45147', 'user', 'active', 'B6C28347', 'pending', NULL, NULL, 8100.00, '2026-08-04 08:08:36', '2026-08-07 03:03:23', 'Ericia79'), (125, 'Isabel Marr', 'marrisabel15@gmail.com', NULL, '$2y$10$BIzBNH4ADGvGCj5.5M420.XS56s8wXJzXe95OAZPO3p5KGeGOW7fq', '64112d71cce245a5a05656ca00144c1b', 'user', 'active', '53970C93', 'pending', NULL, NULL, 0.00, '2026-08-04 08:32:15', '2026-08-05 03:25:25', 'Isabel1'), (126, 'Adhele Fantone', 'delz810@gmail.com', NULL, '$2y$10$gqVx6qWbrFcYlWYVdVJsBeZIZePKvNngMMnoHJeBRIbQs5F89yPaW', NULL, 'user', 'active', '829AF60B', 'pending', NULL, NULL, 0.00, '2026-08-04 08:37:04', '2026-08-04 08:37:04', 'Adhele1'), (127, 'Edwin Raymundo', 'ecraymundo@gmail.com', NULL, '$2y$10$RNFPDugFZ5rrRU8h4JR03u9.bMcjLhzH9XacmmJD.v/SqVeEXa0sG', 'd3833d11cfcf95a04f4502b9930aa6e5', 'user', 'active', 'B87BABC3', 'pending', NULL, NULL, 0.00, '2026-08-04 08:44:32', '2026-08-05 03:26:38', 'Edwin1'), (128, 'Kristina Fantone', 'kfantone@gmail.com', NULL, '$2y$10$jOMnQY4K4zCD7mU2O1L23uLqopffuIZbvTmd30XdnuMi7mDVAKVLi', '41f01077b6cca8704092e791da3c56d0', 'user', 'active', '2B02C160', 'pending', NULL, NULL, 0.00, '2026-08-04 08:47:18', '2026-08-05 03:25:51', 'Kristina1'), (129, 'JOSEPH PASCUA', 'josphp@gmail.com', '', '$2y$10$rk/qGo6ddZHR8yNcZiIteOWM/yxO4gWYGWoOOF40Jgr/z.ZF7cYbS', 'f419f0f97167d889a352691068aaadda', 'user', 'active', '08855A53', 'pending', NULL, NULL, 100.00, '2026-08-04 17:29:15', '2026-08-07 17:29:35', 'jojanp1@gmail.com'), (130, 'Kailyn Av', 'kailynav@gmail.com', '19163903153', '$2y$10$uWIjmlb4M2doYMWJj82HVO3jOla/2tFCQaez5qUyXpMhAUv6G7OHm', '379cab5e57bd0f68908cc91172b434eb', 'user', 'active', 'E6C100D1', 'pending', NULL, NULL, 0.00, '2026-08-04 19:10:13', '2026-08-05 04:35:26', 'Kailyn1'), (131, 'Flor', 'domingoflor478@gmail.com', NULL, '$2y$10$PsBuqjgwXVUX1sNnjm.1UOLxKMhN8rOH969LHNySFSC4aWBnlFJQ2', NULL, 'user', 'active', 'A4C207E0', 'pending', NULL, NULL, 0.00, '2026-08-04 19:30:50', '2026-08-04 19:30:50', 'Flor808'), (132, 'Criselda', 'criselda@gmail.com', NULL, '$2y$10$4SEwV2JOOiVRHPVghYvA6.2PBa9pDOyhVmTgTpeDMSbA0flCUW/Pm', NULL, 'user', 'active', '5D854389', 'pending', NULL, NULL, 0.00, '2026-08-04 19:32:50', '2026-08-04 19:32:50', 'Criselda808'), (133, 'Julieta', 'juliecariaga@gmail.com', NULL, '$2y$10$E1YuKSGwv1wBSRg.4w8i0.Ygn8j7VepiCVvwlb45ixxXNEssnu4fm', NULL, 'user', 'active', 'FBD090BE', 'pending', NULL, NULL, 0.00, '2026-08-04 19:59:57', '2026-08-04 19:59:57', 'Julieta808'), (134, 'Ma Cristina Raquiza', 'cristinaraquiza30@gmail.com', NULL, '$2y$10$NswuelYUApLqQkPkgLpLKufLpX8xpVBNjdNgunphX16TuLCFDbj9y', 'd3bf873077e9056044a260e3aed92b6b', 'user', 'active', '42DF1C47', 'pending', NULL, NULL, 26000.00, '2026-08-04 20:13:28', '2026-08-07 01:10:07', 'Mraquiza53!'), (135, 'Virgilio T. Raquiza', 'vraquiza08@gmail.com', NULL, '$2y$10$YsfEvjdROHluBOrOnEK86OOmOXi5pYI5GSkl23X95YEYrcTsttiiG', '1944d62fd7799ebeea2d02b9affe804d', 'user', 'active', '597F704F', 'pending', NULL, NULL, 5100.00, '2026-08-04 20:32:03', '2026-08-07 01:12:24', 'Vraquiza77!'), (136, 'Priscilla Salvador', 'priscillalcs@yahoo.com', NULL, '$2y$10$/Hcet1zU4Bwk8mOgs9.gYOD6jB/udbpQPdbVXE13oi5LUye.Ozidq', '2373c9625b41c936358e285f5693beb2', 'user', 'active', '96EBC713', 'pending', NULL, NULL, 0.00, '2026-08-04 23:19:40', '2026-08-04 23:21:01', 'Precy1'), (137, 'Ceejay raquiza', 'ceejay0308@icloud.com', NULL, '$2y$10$R33948gmBPr8od2lcRI1sebzcc0nvxDxtbCoNvFo2fgNkltQlDJkO', 'e9172b84c17198cd625657158eafc7ac', 'user', 'active', '6C8FF407', 'pending', NULL, NULL, 13100.00, '2026-08-05 02:07:57', '2026-08-07 01:14:10', 'cjraquiza13'), (138, 'Adhele Fantone', 'adhelefantone@gmail.com', '14088240406', '$2y$10$ec4SjEGy5rMa1OycpUtLee7t/aQcnYHCsiL0VJp4y/jChu.MGgnu.', '870a7ea9f938cf906ae6ddd62ce41110', 'user', 'active', '25C9B7E0', 'pending', NULL, NULL, 0.00, '2026-08-05 04:38:59', '2026-08-06 04:53:19', 'delz'), (139, 'Galya Konova', 'konova68@abv.bg', NULL, '$2y$10$.8so5wsEakJ6DUs9i8rP7uJS/mrqDDsvERSnee20m.Snte/cpDRnm', 'ae3d67f11013d11fb0f5a2097bca9216', 'user', 'active', '432E2E40', 'pending', NULL, NULL, 0.00, '2026-08-05 05:26:17', '2026-08-05 05:29:11', 'konova68'), (140, 'Monica Pinto', 'Mvp777@yahoo.com', NULL, '$2y$10$wFDWgCO6p/0Bl7M2jXPd9ujMUlNbjvwnW9uNIn2MoYgdgo2ZvIspO', '43e8949923739683283a0bb14a6d9616', 'user', 'active', '36CCA743', 'pending', NULL, NULL, 0.00, '2026-08-05 05:30:45', '2026-08-05 05:30:54', 'Mvp777@yahoo.com'), (141, 'Roger Heteroza', 'rogerheteroza8@gmail.com', '+639082521931', '$2y$10$/2RIcEyUJ8RM1rHAaq92G.oLVMaXbreh8vNTXyRpHxzc480Dzg5Va', 'b8cfecb0d8fdbe55dc8dc678e61879e3', 'user', 'active', 'E954EB1A', 'pending', NULL, NULL, 21600.00, '2026-08-05 09:39:37', '2026-08-07 04:52:15', 'Heteroza'), (142, 'Gertrudes Heteroza', 'gherjhing79@gmail.com', '+639062447986', '$2y$10$InToEj/RIniDqq5QSmKeA.S9S5QMBr6X8i9sl1IbL4bwbZVDrZW5m', 'c76c6a9bb92297f485ca2ebc02c9cd96', 'user', 'active', '67B34DDC', 'pending', NULL, NULL, 15200.00, '2026-08-05 09:54:24', '2026-08-05 22:34:39', 'Jing'), (143, 'Benigno Esguerra', 'benignoesquerra@gmail.com', '+639997836821', '$2y$10$8A2ef9dHAE6QKacy.TRtH.rUVKezLmYCc3JOwrZRaIZzoBYPJc3N.', '3368d1fec1168960848203639404bca0', 'user', 'active', '087D62E5', 'pending', NULL, NULL, 9800.00, '2026-08-05 10:00:06', '2026-08-07 08:54:01', 'Benigno'), (144, 'Mark', 'marktimothy.ambrose@yahoo.com', NULL, '$2y$10$.11jjNQmnMepErAUIjGUJeMS3oIXLcOfx0ngL7lh7bhGsMUkWloie', 'ad18a807380f16e5e3bf96534d66f315', 'user', 'active', '78272895', 'pending', NULL, NULL, 7900.00, '2026-08-05 10:08:36', '2026-08-07 13:39:44', 'MarkAmbrose'), (145, 'Haokila Correa', 'uiloakalola@aol.com', NULL, '$2y$10$yuxDXZsZLGqPWRibgqIEQ.KwHZwaT36qu4G4Dd3RFUTsWch.mFILq', 'f3050e7af5dba5b78c25fd36a8c5996c', 'user', 'active', 'A15A58F4', 'pending', NULL, NULL, 0.00, '2026-08-05 11:24:37', '2026-08-05 11:25:00', 'Uiloa808'), (146, 'Kupaa Correa', 'Kupaacorrea@gmail.com', NULL, '$2y$10$R0.dCqZmSSPWXihXNnsUtONIvF0zulvNvjP8zW4VstiDHq7tONuNy', '0294c2adb93c7a1db1904c7d1bb34a00', 'user', 'active', 'DB5ECE02', 'pending', NULL, NULL, 0.00, '2026-08-05 11:35:09', '2026-08-05 19:12:27', 'Kupaa808'), (147, 'Hezekiah Limbaga', 'sweetc808@gmail.com', NULL, '$2y$10$LzHpM7a/9ZynO8wj2ArBROWpE1BnQUByBGCDNcrCxjQcRynsu0Qxq', '8a380837fe7ae95ee86ef92630e85569', 'user', 'active', '8EAC222E', 'pending', NULL, NULL, 0.00, '2026-08-05 11:37:41', '2026-08-05 11:38:11', 'Hezekiah808'), (148, 'Eric Jacobson', 'ericjacobson780@gmail.com', NULL, '$2y$10$H0NfkRIy9TU5j9LAzMNXI.KSqXcrdSQKkzPu6grOXm68z4sqELGcK', NULL, 'user', 'active', '34D42A64', 'pending', NULL, NULL, 0.00, '2026-08-05 14:25:47', '2026-08-05 14:25:47', 'Jacobson'), (149, 'Eric Jacobson', 'martinpetee710@gmail.com', '', '$2y$10$tR0LPuOzhuDvlhqA1Rohwu2fTCBgdqA2YAoJxUAkATjlc4JcnAsee', '6047fca23660deaf6782f1668cbf9073', 'user', 'active', '2E72F534', 'pending', NULL, NULL, 1.00, '2026-08-05 14:32:27', '2026-08-07 13:26:16', 'Jacobson221'), (150, 'Roy Francisco', 'royf0377@gmail.com', NULL, '$2y$10$hZqxNMeZKFkPZy/Oii8YFOon6mAoK4e7BRjeRv9KKnvVTmLwsxLsK', '9a9c3253b385ec25a8620c0b53f5508e', 'user', 'active', '2ADEDA3E', 'pending', NULL, NULL, 6890.00, '2026-08-05 14:54:18', '2026-08-06 19:32:56', 'Rgfrancisco'), (151, 'Marites Keliikoa', 'Tkeliikoa@gmail.com', NULL, '$2y$10$gW6CJa6rEer8Ea1e210Udel0INHl6flusREac.oCczbAUtjgP.Any', '052a594bd8f2f55cb8b3f9786e217609', 'user', 'active', '69D387E3', 'pending', NULL, NULL, 0.00, '2026-08-05 19:05:07', '2026-08-05 19:05:27', 'Tes'), (152, 'Fulceda Matute Robles', 'fulcedarobles@gmail.com', NULL, '$2y$10$8T8RZcOXX4IzRAkwbqrEO.E3DWztQvj2S5ijtCjVUfDQHbX3l06fi', '99a7e1c9d4b94abd1639a65929e7d6e4', 'user', 'active', 'EFAC6983', 'pending', NULL, NULL, 5500.00, '2026-08-05 22:24:15', '2026-08-06 15:23:07', 'Fulceda1'), (153, 'Eligio Matute Robles Jr', 'roblesjon58@gmail.com', NULL, '$2y$10$w9HKg82Tubr1RxLt9RmO7OAlsgXDWUzHgK4njJ47BczqY5jdC.IJC', 'ebf6a04e86dd8a02d65d68c9d8931175', 'user', 'active', 'EE5E80C7', 'pending', NULL, NULL, 3250.00, '2026-08-05 22:28:16', '2026-08-06 15:26:22', 'John1'), (154, 'David', 'davedunaway808@gmail.com', NULL, '$2y$10$VuiLdwEppVYc35Zaqj3hhe5O7OJN1d5Z9JTuaqhNCJdun2vsK2F8G', '7403612a0184b9e623caa034d7d1c620', 'user', 'active', 'C0593D75', 'pending', NULL, NULL, 0.00, '2026-08-06 01:48:41', '2026-08-06 01:50:37', 'Dunaway'), (155, 'Alexandra Sanders', 'alexandrasanders04@gmail.com', NULL, '$2y$10$Juv1uPpmsu4l/dbqqImUs.G.u0VC9B3DSnz6j3RNgZ2m7b6GZJyoq', 'cf722b2da652b6e6cd1fa41c2d9cec25', 'user', 'active', 'E0C41C17', 'pending', NULL, NULL, 0.00, '2026-08-06 03:07:12', '2026-08-06 03:08:36', 'Alexa1'), (156, 'Isabelle Sanders', 'isabellesanders21@gmail.com', NULL, '$2y$10$OstpLZKy.ueWP4Ju9HKrQOZ4kbEQZxcs.VrMjpOmUovzlWSdwa7c.', 'bfee0db1d13a155c4af8137b4ccc80d6', 'user', 'active', 'CC913E1E', 'pending', NULL, NULL, 0.00, '2026-08-06 03:29:30', '2026-08-06 03:30:03', 'Isabelle1'), (157, 'Carolina Soriano', 'sorianocarolina@aol.com', NULL, '$2y$10$KuhDrcYJeDl7SVjCehAtqOaFRgROaaQrfulklJVJU/xP3U.zrJYpe', 'f24e4703cc572d7cff923823569cbc62', 'user', 'active', 'CF5150FA', 'pending', NULL, NULL, 0.00, '2026-08-06 03:39:07', '2026-08-06 03:39:46', 'Carol1'), (158, 'Ernesto Amos', 'ernestoamos32@gmail.com', NULL, '$2y$10$RIvq8Uz7HJPCIOaV/LZSie17MaB/JnjoKLl7Ym8zcOnGjofDeO7Oa', '2ec9b282f73e2658ae115237ab8b151f', 'user', 'active', '82B84B5A', 'pending', NULL, NULL, 0.00, '2026-08-06 03:55:22', '2026-08-07 13:34:16', 'Ernie1'), (159, 'Dolores Amos', 'doloramos21@gmail.com', NULL, '$2y$10$0tMKf1ddCRYc0HxdHFzXVOSwDLTjJPcny2uIFPi2b/mA6rnQHBLLW', '9b0dcea91e92b9601b10c8a5b640c132', 'user', 'active', '4F127BA9', 'pending', NULL, NULL, 0.00, '2026-08-06 04:05:00', '2026-08-06 04:05:39', 'Dolor1'), (160, 'Nena Intal', 'nrintal@gmail.com', NULL, '$2y$10$UtDJImVEiDnBELf8kcal/uYi0.Gq3w9u0YRYfz/dZ9aq3zqo4h7Ge', '010ff471c9389ece49d1ac42d7564d06', 'user', 'active', '5D371001', 'pending', NULL, NULL, 0.00, '2026-08-06 04:10:50', '2026-08-06 04:11:16', 'Nena1'), (161, 'Pamela Miranda', 'pam_mir@yahoo.com', NULL, '$2y$10$b/wFdUVATrGr3ztKUQk0ZOzS6gQN7idQJTVFZZB6vQNcYN.sujHny', 'ba64ef3096cf3f2120c9a367775ad5a5', 'user', 'active', '639C084B', 'pending', NULL, NULL, 0.00, '2026-08-06 04:18:36', '2026-08-06 04:19:14', 'Pamela1'), (162, 'Maximiniano Castellanes', 'macas789@yahoo.com', NULL, '$2y$10$j.SXUpjCYXnqTvB6pXG14ujXdIAZImvfV6GynPyHV/QlP2p9/2Duq', '12e32c4a3d50154f874612305c9732b5', 'user', 'active', 'B313590A', 'pending', NULL, NULL, 0.00, '2026-08-06 04:30:54', '2026-08-06 04:31:57', 'Max1'), (163, 'Kiarah Hackworth', 'buysilver2022@gmail.com', NULL, '$2y$10$y.CiT.tuFrVy26ZeUuimVudQNM8ryGDvgt6xI5zDi7NQ65uQU7..6', '4fe6e909b9e1a8859115f358a5ed72aa', 'user', 'active', '64331002', 'pending', NULL, NULL, 0.00, '2026-08-06 07:25:14', '2026-08-06 07:55:45', 'Kiarah'), (164, 'Lovelyn Kenison', '888ismine@gmail.com', NULL, '$2y$10$Q4hwYTEPDGFGDbMgwgnmV.9zVU/qXNHRyTkXV7q3TQDLn5RjpL8Ti', NULL, 'user', 'active', '888D3D5D', 'pending', NULL, NULL, 0.00, '2026-08-06 07:44:12', '2026-08-06 07:44:12', 'Lucien'), (165, 'Lovelyn Kenison', 'aehikino@gmail.com', NULL, '$2y$10$hSi1lKtDKSR0kyEeqaI8p.ej238YvAewdwFZjeg7gKQ5iky44tJOW', 'd36ed2c624b305d7dcf85f0c63156001', 'user', 'active', 'AF235282', 'pending', NULL, NULL, 0.00, '2026-08-06 07:55:33', '2026-08-06 07:58:17', 'Lucien88'), (166, 'Starlyn Kenison', 'alohahawaiiteam@gmail.com', NULL, '$2y$10$3lESG4u4ZqFiQlX63ebn1u685EyOEKTgATxpf6KJENDGvuQ/7Wqm2', 'b60ef3cce75607b87e6e9821804f3dba', 'user', 'active', 'A355FE0E', 'pending', NULL, NULL, 0.00, '2026-08-06 08:14:12', '2026-08-06 08:14:59', 'Velcom'), (167, 'Mark Angelo Barranco', 'mgjose416@yahoo.com', NULL, '$2y$10$gMggOct8DC6Ev6FIjY.N/OvJ2Vahk62MIBXiNjWvL780PIrShvmsa', 'b5dbea91f8afe2149d4c01a9964e882e', 'user', 'active', '94BCE4F9', 'pending', NULL, NULL, 0.00, '2026-08-06 08:22:27', '2026-08-06 08:23:11', 'Mark'), (168, 'Jenesis Alonzo', 'alohamitz8@gmail.com', NULL, '$2y$10$vHOY1/1jn8uC3d56P/CdheOleFY57qxWDnIj/0myM9B4BeXppwj8m', '8113decbd5b01de6fd0d4f837b5774e1', 'user', 'active', 'A855DD44', 'pending', NULL, NULL, 0.00, '2026-08-06 08:51:25', '2026-08-06 08:52:04', 'Jenesis'), (169, 'Angelica-Ashley Jose', 'angelicaashleyjose@gmail.com', NULL, '$2y$10$fR0QMlFXB5LIwDDR5DN3TO7rlrXX6DIUCMMUb5gk0bXWSJYbgogrm', 'dde78de60d495cdcf0a3c0d38b138349', 'user', 'active', 'B3D71C3F', 'pending', NULL, NULL, 0.00, '2026-08-06 09:06:04', '2026-08-06 09:06:36', 'Angelica'), (170, 'Noel C. Ibarra', 'noelibarra1230@gmail.com', NULL, '$2y$10$mvFb9DFu0qRV7ItOVMju8O6Mp9yOVkVzytZQ55KlgK3UU9HmXwBA.', 'e044fb55cac7585bd7f62dcd03715258', 'user', 'active', 'A72C47A3', 'pending', NULL, NULL, 0.00, '2026-08-06 09:28:37', '2026-08-06 09:29:50', 'Noel C. Ibarra'), (171, 'Rey Magdangal', 'reymagdangal429@gmail.com', NULL, '$2y$10$Ie.QYNDKGuAiICltKvICEefpDjFmfKDmgG3OjmyN4kQ9Ppted8TRW', 'fdd635fea0d0b45f944deb2f7a2255f0', 'user', 'active', '1C4BB0BB', 'pending', NULL, NULL, 0.00, '2026-08-06 21:41:44', '2026-08-06 21:44:13', 'Deuteronomy303'), (172, 'Shari Yamashiro', 'shyamashiro@gmail.com', NULL, '$2y$10$nR2S2FRA3r18Hf2YekZj3usqPlI5ULNXhreRltq3jrhdzIPwfkCGG', '67d4650c9e84863baebbae33cb25ada5', 'user', 'active', '74C4E141', 'pending', NULL, NULL, 0.00, '2026-08-07 08:41:08', '2026-08-07 08:42:53', 'Shari'), (173, 'Jaclyn Yamashiro', 'cyclicy@gmail.com', NULL, '$2y$10$vkqM8z4u7y8cVd9jaurl7.csxQS5js5Nwaq7bVfchsi.eisejPg4i', '41546d54d488232f27d08dfc4f2e9721', 'user', 'active', 'EE3A860C', 'pending', NULL, NULL, 0.00, '2026-08-07 09:00:30', '2026-08-07 09:05:02', 'jaclyn'), (174, 'Joshua Yamashiro', 'kojoyamashiro@gmail.com', NULL, '$2y$10$4256IE8zDa7gVFMf0B9IjuYNcHApMru0wrm0dQr9xAoxcbxICQxY2', '0d9094541fe3a641b11d88273139a25d', 'user', 'active', 'AF132134', 'pending', NULL, NULL, 0.00, '2026-08-07 09:09:42', '2026-08-07 09:10:26', 'joshua'), (175, 'Madelyn Tigue', 'madztigue@yahoo.com', NULL, '$2y$10$sUCUBQjs6M2EBmRWcBmTOuUQefyuGZxSMW6jHWpldibhsmSYYXyR2', '1473e188f33024c30bf4fa5e4beaeaa6', 'user', 'active', '25F6CF26', 'pending', NULL, NULL, 0.00, '2026-08-07 16:55:39', '2026-08-07 16:56:26', 'Madelyn1'), (176, 'Mary Jean Romano', 'Hibiscuslady101@aol.com', NULL, '$2y$10$XWUEzf1EOJ0UNT7umPmlkudU3lYpgzCtaANYzN4f6EIqxIW4663si', 'c76a438d921ec1aeaa378e5242b88b27', 'user', 'active', 'FB3E3011', 'pending', NULL, NULL, 0.00, '2026-08-07 17:42:49', '2026-08-07 17:43:57', 'Mromano1954'); -- -------------------------------------------------------- -- -- Table structure for table `withdrawals` -- CREATE TABLE `withdrawals` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `amount` decimal(15,2) NOT NULL, `method` varchar(50) NOT NULL, `wallet_id` bigint(20) DEFAULT NULL, `account_info` text NOT NULL, `status` enum('pending','approved','rejected','completed') DEFAULT 'pending', `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `withdrawals` -- INSERT INTO `withdrawals` (`id`, `user_id`, `amount`, `method`, `wallet_id`, `account_info`, `status`, `created_at`) VALUES (1, 65, 110.00, 'USDT TRC20', NULL, 'TFcSvzYm88Pw64jTcSihmoBDjtWkKiESjR', 'rejected', '2026-08-04 05:20:53'), (4, 29, 100.00, 'USDT', NULL, 'e78f89d4578836a0d86b19cb99c6c724', 'approved', '2026-03-20 08:02:53'), (5, 29, 100.00, 'USDT', NULL, 'e78f89d4578836a0d86b19cb99c6c724', 'approved', '2026-03-20 08:09:29'), (6, 29, 10.00, 'USDT', NULL, 'e78f89d4578836a0d86b19cb99c6c724', 'approved', '2026-03-20 08:10:54'), (7, 29, 10.00, 'USDT', NULL, 'e78f89d4578836a0d86b19cb99c6c724', 'approved', '2026-03-20 08:15:38'), (8, 29, 10.00, 'USDT', NULL, 'e78f89d4578836a0d86b19cb99c6c724', 'approved', '2026-03-20 08:18:36'), (9, 29, 10.00, 'USDT', NULL, 'e78f89d4578836a0d86b19cb99c6c724', 'approved', '2026-03-20 08:29:49'), (10, 29, 10.00, 'USDT', NULL, 'e78f89d4578836a0d86b19cb99c6c724', 'approved', '2026-03-20 08:37:15'), (11, 29, 10.00, 'USDT', NULL, 'e78f89d4578836a0d86b19cb99c6c724', 'approved', '2026-03-20 08:37:53'), (12, 29, 10.00, 'USDT', NULL, 'e78f89d4578836a0d86b19cb99c6c724', 'approved', '2026-03-20 08:38:33'), (13, 29, 10.00, 'USDT', NULL, 'e78f89d4578836a0d86b19cb99c6c724', 'approved', '2026-03-20 08:57:54'), (14, 29, 10.00, 'USDT', NULL, 'e78f89d4578836a0d86b19cb99c6c724', 'approved', '2026-03-20 09:00:10'), (15, 29, 500.00, 'BTC', NULL, '4801a487ec764ec26abf0f406db77fa4', 'approved', '2026-03-20 16:02:32'), (16, 29, 500.00, 'BTC', NULL, '4801a487ec764ec26abf0f406db77fa4', 'approved', '2026-03-20 16:03:21'), (17, 34, 110.00, 'ETH', NULL, '0xec37ecb74543550891925b12ccfa5d67bcc62f6d', 'rejected', '2026-04-13 03:24:21'), (18, 34, 250.00, 'ETH', NULL, '0xEc37EcB74543550891925b12ccfa5D67bCc62f6D', 'rejected', '2026-04-13 16:01:24'), (19, 38, 337800.00, 'USDT TRC', NULL, 'TM8xm1Q67KDnRKEMb8FnbBp9uvyiVGK2w7', 'rejected', '2026-04-21 16:41:46'), (20, 44, 200.00, 'BTC', NULL, '76142197d431a4c427caab27a9fb4554', 'rejected', '2026-08-06 13:37:53'); -- -- Indexes for dumped tables -- -- -- Indexes for table `admin_notifications` -- ALTER TABLE `admin_notifications` ADD PRIMARY KEY (`id`); -- -- Indexes for table `crypto_wallets` -- ALTER TABLE `crypto_wallets` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `currency` (`currency`); -- -- Indexes for table `deposits` -- ALTER TABLE `deposits` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `idx_deposits_wallet_id` (`wallet_id`); -- -- Indexes for table `investments` -- ALTER TABLE `investments` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `plan_id` (`plan_id`); -- -- Indexes for table `plans` -- ALTER TABLE `plans` ADD PRIMARY KEY (`id`); -- -- Indexes for table `signals` -- ALTER TABLE `signals` ADD PRIMARY KEY (`id`), ADD KEY `trader_id` (`trader_id`); -- -- Indexes for table `subscriptions` -- ALTER TABLE `subscriptions` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `trader_id` (`trader_id`); -- -- Indexes for table `traders` -- ALTER TABLE `traders` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`), ADD UNIQUE KEY `referral_code` (`referral_code`); -- -- Indexes for table `withdrawals` -- ALTER TABLE `withdrawals` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin_notifications` -- ALTER TABLE `admin_notifications` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `crypto_wallets` -- ALTER TABLE `crypto_wallets` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `deposits` -- ALTER TABLE `deposits` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=128; -- -- AUTO_INCREMENT for table `investments` -- ALTER TABLE `investments` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50; -- -- AUTO_INCREMENT for table `plans` -- ALTER TABLE `plans` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=177; -- -- AUTO_INCREMENT for table `withdrawals` -- ALTER TABLE `withdrawals` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; 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 */;