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

START TRANSACTION;



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

