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

START TRANSACTION;



--
-- Database: `flovhggj_rock`
--

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

--
-- Table structure for table `commissions`
--

CREATE TABLE `commissions` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `referred_user_id` int NOT NULL,
  `amount` double NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `investments`
--

CREATE TABLE `investments` (
  `id` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `start_time` datetime DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `daily_percentage` decimal(5,2) DEFAULT '0.00',
  `last_earnings_time` datetime DEFAULT NULL,
  `daily_earnings` decimal(10,2) DEFAULT NULL,
  `total_earned` decimal(10,2) DEFAULT '0.00',
  `cycle_days` int DEFAULT '30'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `investments`
--

INSERT INTO `investments` (`id`, `user_id`, `amount`, `start_time`, `status`, `daily_percentage`, `last_earnings_time`, `daily_earnings`, `total_earned`, `cycle_days`) VALUES
(51, 251, 1000.00, '2025-09-21 22:48:41', 'active', 5.00, '2025-09-22 14:16:05', 50.00, 50.00, 45),
(52, 249, 100.00, '2025-09-22 18:35:17', 'active', 5.00, '2025-09-22 21:35:34', 5.00, 5.00, 45),
(53, 255, 500.00, '2025-09-23 19:28:48', 'active', 10.00, '2025-09-24 01:44:00', 50.00, 50.00, 45),
(54, 307, 300.00, '2025-09-24 05:20:44', 'active', 10.00, '0000-00-00 00:00:00', 30.00, 0.00, 45),
(55, 288, 300.00, '2025-09-24 05:22:38', 'active', 10.00, '2025-09-24 08:36:46', 30.00, 30.00, 45),
(56, 251, 150.00, '2025-09-24 06:00:05', 'active', 10.00, '0000-00-00 00:00:00', 15.00, 0.00, 45);

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

--
-- Table structure for table `mpesa_recharges`
--

CREATE TABLE `mpesa_recharges` (
  `id` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `sms` text,
  `status` varchar(20) DEFAULT 'pending',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mpesa_recharges`
--

INSERT INTO `mpesa_recharges` (`id`, `user_id`, `amount`, `sms`, `status`, `created_at`) VALUES
(38, 252, 140, 'Cskygsgy ksgsgs', 'approved', '2025-09-22 16:40:58'),
(39, 249, 100, 'Umetuma Tsh 50,000.00 sawa na KES 2442.93 (FX 0.04) kwenda +254789170537 ESTHER MUTINDI Tarehe 22/09/2025. Makato Tsh 820.00 Salio Jipya Tsh 5,128.99 TID XX250922.2048.X85677', 'approved', '2025-09-22 21:34:18'),
(40, 329, 150, 'Money sent to Walieta Walieta on 973334172.Amount ZMW 150.00. Your bal is ZMW 221.02.TID: PP250919.1357.Z46660.', 'pending', '2025-09-24 06:37:22'),
(41, 336, 150, 'You have transferred 150.00 ZMW to Namwila Namwila (260763776043) from your mobile money account 65021815 at 2025-09-24 06:34:26. Your new balance: 62.03 ZMW. Message from sender: investment. Message to receiver: investment. Financial Transaction ID: 7765873908.', 'pending', '2025-09-24 07:35:41');

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

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `task_name` varchar(255) DEFAULT NULL,
  `reward` decimal(10,2) DEFAULT NULL,
  `status` enum('pending','completed') DEFAULT 'pending',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `completed_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `users` (
  `id` int NOT NULL,
  `phone` varchar(20) NOT NULL,
  `password` varchar(255) NOT NULL,
  `fullname` varchar(100) DEFAULT NULL,
  `invite_code` varchar(20) DEFAULT NULL,
  `referred_by` varchar(20) DEFAULT NULL,
  `balance` decimal(10,2) DEFAULT '0.00',
  `referral_earnings` decimal(10,2) DEFAULT '0.00',
  `total_earnings` decimal(10,2) DEFAULT '0.00',
  `investment_amount` decimal(10,2) DEFAULT '0.00',
  `investment_start` datetime DEFAULT NULL,
  `investment_plan` varchar(50) DEFAULT NULL,
  `role` enum('user','admin') DEFAULT 'user',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `income` decimal(10,2) NOT NULL DEFAULT '0.00',
  `status` enum('active','blocked') DEFAULT 'active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `users` (`id`, `phone`, `password`, `fullname`, `invite_code`, `referred_by`, `balance`, `referral_earnings`, `total_earnings`, `investment_amount`, `investment_start`, `investment_plan`, `role`, `created_at`, `income`, `status`) VALUES
(248, '0746319452', '$2y$10$7Nl1poye6NXyxuLE9Fc.ZeGtxTvznymg9c.JprF4w23y9Xzkvibn6', NULL, '8a153e41', '439297', 182.50, 142.50, 0.00, 0.00, NULL, NULL, 'user', '2025-09-21 17:50:29', 0.00, 'active'),
(249, '0762345901', '$2y$10$X5YsyAm5wmDAuNjzscIk6edl6xQjWtM5z7krzo1S5aunhh9XZPhZK', NULL, '0ec27065', '6e2daec3', 5.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-21 18:23:19', 5.00, 'active'),
(250, '0705277400', '$2y$10$QfgR7LOE/pk43Tne5Sz17OvpzwnzQ2KyX87c5a6heNbiyr867wO8C', NULL, '32051682', '6e2daec3', 0.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-21 20:05:52', 0.00, 'active'),
(251, '0746319458', '$2y$10$aITs8QDfllT02TlOEuhCP.LSoR1Jte610AqQ8mRjSLl8DsmuIxrFW', NULL, '0bd2126d', '8a153e41', 311.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-21 22:47:55', 50.00, 'active'),
(252, '07463194587', '$2y$10$QeoPospn7n2gJGYEvnM/cu.fk9RevfSGApa7609jAn9009etyLawy', NULL, 'ddde9e08', '', 150.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-22 11:21:08', 0.00, 'active'),
(253, '0765809636', '$2y$10$9.vHyY6hJbabLeeNw00WI.bzXuJqBZqq9/0pycdL7w67V9wY.vm4y', NULL, '21300053', '', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-22 13:54:19', 0.00, 'active'),
(254, '0770618047', '$2y$10$jRYnWKsdAe3ORfgLQ2I9x.NpyuQqQc82v8Gd/0bAnB5aJCWCLeDwO', NULL, '6232beb8', '', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 14:10:24', 0.00, 'active'),
(255, '0774467466', '$2y$10$zZGQog5XOaHyByOTAX.aPO.cQ8B5fvG6RIx1YsPnW6uYFddh.8T6e', NULL, '7b5ae8ec', '', 60.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 14:39:18', 50.00, 'active'),
(256, '779597946', '$2y$10$.BL.mP7ts6cIs./7Ywm6uueaTJsoH5DJLHlcSZDssu3a.HkgzN5My', NULL, 'f06b9949', '', 55.00, 45.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 15:02:01', 0.00, 'active'),
(257, '0760259452', '$2y$10$kxjOm4r4.yRQFPMv94sEC.wDo6kHNcB7vgJIncGiSz66MAe5x65Pm', NULL, '136cbb54', 'f06b9949', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 15:08:01', 0.00, 'active'),
(258, '0979850666', '$2y$10$tmBmgH.IzsxI1mPBRP8Z7e8cV4zUwriI0T/ClTsL7wqLBWucjZKMq', NULL, 'aa310cc7', 'f06b9949', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 15:09:29', 0.00, 'active'),
(259, '0972777836', '$2y$10$hgSjOl9bAVF5E9oV/mvPFOLcyL.rOGGUGm3GmBWFoTAZI5T52ZHBO', NULL, '064dc9d8', 'f06b9949', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 15:11:18', 0.00, 'active'),
(260, '0960232592', '$2y$10$KqUmOzs5E0Y20/Eozc82ieR40lm6/qWBeyzTLueh0HKzqV9Wduhxu', NULL, '00974eab', 'f06b9949', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 15:16:30', 0.00, 'active'),
(261, '0777842731', '$2y$10$1D/G44tcuehwShHX7sXMdeQNscSv7bpFc03D3zLpcy/jbihsWaw6S', NULL, '0f92f6f5', '', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 15:28:54', 0.00, 'active'),
(262, '0973633968', '$2y$10$cmBb.qTfI/D1Mxdgsz/QQOOHQD8DJSjWVr.XEQaUN3cc.GbQs978u', NULL, '72b73eb7', 'f06b9949', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 15:42:27', 0.00, 'active'),
(263, '0571652173', '$2y$10$LhMurc1/an2.ux8/9k8vIeBZ51cW6mxa3Vc8rZ/FWuXESAaRAkoZm', NULL, '126f8670', 'f06b9949', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 16:11:42', 0.00, 'active'),
(264, '764674910', '$2y$10$dzxRy1smJKqyLiPpKpkLEOLRIWmtYseeMIztM3wIf3Rzv7guE5r3G', NULL, '4c335564', 'f06b9949', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 16:13:22', 0.00, 'active'),
(265, '0978207209', '$2y$10$nNUPgWR6gOOfcADmbfOg2.R2hgJYjhkDI/cjw17lzD.hJie3p2tfy', NULL, 'f8392845', 'f06b9949', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 16:14:30', 0.00, 'active'),
(266, '977438227', '$2y$10$4ivevH8czNhJxj9tCTSnCuJhz5KZKQBoIx5LQVKtWWLUqWO1Jd0bG', NULL, '2abd2a72', '', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 16:23:37', 0.00, 'active'),
(267, '621795469', '$2y$10$pe/9jt1zoK/V8/4ntlNOc.taRU50DHRzqU9QjwgO3TMVWCS0ikpdO', NULL, '09d33362', '', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 16:24:17', 0.00, 'active'),
(268, '0776630952', '$2y$10$CzteTjp26XE/5Y3iR0PhjuHDNVayqO/Bb7w0igXaME68j6h1yrCZa', NULL, 'e432cc39', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 16:44:24', 0.00, 'active'),
(269, '0968475054', '$2y$10$JlBl/d3j7eIhh4r172W/u.shgwYLpEQayYf1gtJERUCqSICRhP9/q', NULL, '04f26ad1', 'f06b9949', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 16:45:43', 0.00, 'active'),
(270, '0776560769', '$2y$10$CSQbMLct3V.y.llANdF84.ZSjacmmZG89etTLxG/DDBFoQX54rBZK', NULL, 'd0286d02', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 16:46:47', 0.00, 'active'),
(271, '753951456', '$2y$10$MqGGvevKL88Qndmq7/8i8OpCyTDyVcBnoOdxFA3E9fBjWp/vprpmu', NULL, 'c0ad4c77', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 16:48:21', 0.00, 'active'),
(272, '0970402503', '$2y$10$b9CuMVBsXA2Y1LPcPhE7IubjQiYkSVxoUNl2E76vOMoV5VyGcYSw2', NULL, '1226d3e5', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 16:48:50', 0.00, 'active'),
(273, '978820767', '$2y$10$oR7kZEVw2UK4K13D94Otuuq2dwHJqzJdbRLKl6mTgnHFBa0.aEmZ6', NULL, 'd445fc9e', 'f06b9949', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 16:50:37', 0.00, 'active'),
(274, '0123456789', '$2y$10$voIrusks7m4WM0bSxw0MXOCNi7WFTVcQc5t2SZR.o/gV2oRPBUjWC', NULL, '7d67d58b', '', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 16:54:42', 0.00, 'active'),
(275, '+260973840653', '$2y$10$aumqH.WRJohTOGELXon/T.A3KryOJyiSd4vBh4g1ggoikcfCfoniy', NULL, '1724747a', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 17:17:40', 0.00, 'active'),
(276, '0772864412', '$2y$10$zSHszAicpLUsoEYJ6JVBI.Q..9.Lt0uckQL/kFBIwoDMwChYIPpRa', NULL, '4f1aedbe', '1724747a', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 17:20:08', 0.00, 'active'),
(277, '260770153758', '$2y$10$5igyAX7NLYl5VGj2pAfXqeqCqPLIHoIznYYqtL6zB.cbXeK3rDqhu', NULL, 'cef86c3c', '1724747a', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 17:21:17', 0.00, 'active'),
(278, '0765943134', '$2y$10$dDtayh1sh1P9jD.NAtOMq.TZeqBnhzaPBBArrNGWbHxrOD3BDuHOu', NULL, '266a0341', 'f06b9949', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 17:29:24', 0.00, 'active'),
(279, '+260975542812', '$2y$10$iIuaCcao/va7tNCcbE4muuH1G3nVeIfA.f0W54NAZffu5c8pYx0HK', NULL, 'e0f75bdd', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 17:34:46', 0.00, 'active'),
(280, '0772111042', '$2y$10$TB7f.wIPxy97XFh3nZnvn.4QnlWxtvba8A1BH95WPYcKprGuZHo82', NULL, 'a1840262', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 17:42:58', 0.00, 'active'),
(281, '0770618251', '$2y$10$moc0woV72/2sBdsAdmOp2e5A/h7gKm6N48Zj6omvv3GlFWEPzs1Ay', NULL, 'd87eac2b', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 18:00:00', 0.00, 'active'),
(282, '+260771086691', '$2y$10$JhfZAbpheTc7.uHFGIJimerkYmyyN.4n5sta7ILmKPA0YGlXVokWu', NULL, '01ec11cd', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 18:52:31', 0.00, 'active'),
(283, '0978191399', '$2y$10$wej8K2h31IHdxncM1djW4OrJBct.u3ELvZWLy7kroNykN.0m0L/ai', NULL, '6dfd4dec', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 18:57:52', 0.00, 'active'),
(284, '0979968850', '$2y$10$9acqkEIWbchWdYfeqTh36OgVrMCdUKyEL1coSeMi/Scxpid6DfES.', NULL, 'e36900d1', '6dfd4dec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 19:03:16', 0.00, 'active'),
(285, '0962324819', '$2y$10$YdPVs7s6b2UK7gYBeBqwhOUPOnWSVLwlqEE6o80ecSZBpl5NrXiWK', NULL, 'c0d80f3d', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 19:04:32', 0.00, 'active'),
(286, '0770370339', '$2y$10$mb/pFDa3oCADPFqyreUOTO6DRDg4DZx5gD7n6UmtGHRSbvwLxPWqK', NULL, '2a719a0b', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 19:05:13', 0.00, 'active'),
(287, '0777893163', '$2y$10$pR4Tjw3Yn/gK7sJdQG1kv.SROHz3Rg/9uR.UhNgIsKwIlJc0epB2q', NULL, 'c791db65', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 19:08:53', 0.00, 'active'),
(288, '260978714755', '$2y$10$CrGt1p6xQe.gmE5lB.7peelu8DWON9v0Zyv5zG2Kpq/dIaNEHLq3W', NULL, '4ed6195f', '', 40.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 19:10:53', 30.00, 'active'),
(289, '976053934', '$2y$10$WZUDAwpH1ou4RWI/ecylLeor1FX2gipFfWvopS3OpBWV6xOlm.nmO', NULL, 'c9a23c7a', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 19:12:12', 0.00, 'active'),
(290, '0570549395', '$2y$10$aZSj18osMjTLa6FzntpzgueZScW5KUY8f5UUvOYjCmCUonO2JBf.m', NULL, '000b285c', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 19:18:34', 0.00, 'active'),
(291, '+260974304726', '$2y$10$jN/8BcMoyew4/arrUS18neGEX/Pk.78puunaMRdAMzVsp2eTfIcdW', NULL, '7e64fef7', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 19:20:10', 0.00, 'active'),
(292, '+260769693755', '$2y$10$9LP8liMorWuIhZFRm66rAeve2/0OCqlt/stUw.4zmpshZ8Dgo72Vu', NULL, 'fd783eeb', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 19:25:47', 0.00, 'active'),
(293, '0972391957', '$2y$10$Ow2ZxtDQXoWiuYAbtXRP.OYFU4QQ5UoMh5/nx0BBMN0iE6xoh9Uuy', NULL, '6457b886', '6dfd4dec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 19:35:01', 0.00, 'active'),
(294, '0971700955', '$2y$10$OmdsfdfmqbQEuKjUJ/RqMe8nkrCKYq3O3K25fA8d3lEesebBOqeNS', NULL, '17b8c892', '000b285c', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 19:41:38', 0.00, 'active'),
(295, '974348554', '$2y$10$sAVFVpz1Y8u4hw187Ol5XuFXYOOAI2WLIZuYpLgmBahS31lHUMSdC', NULL, '87688fcc', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 19:52:27', 0.00, 'active'),
(296, '0961873793', '$2y$10$uy76jwYex1x/R959TqwFW.MhBzkQldYKoHM8yVu2uv4gBkGxgxDKa', NULL, 'eb0615a5', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 19:58:33', 0.00, 'active'),
(297, '0766306871', '$2y$10$qiOiooXyIEQf7oMvfvJZZ.wMd5LHB684V3AdNSSPNEH9bkYS8U9pC', NULL, '7d541552', '', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 19:59:24', 0.00, 'active'),
(298, '0775653373', '$2y$10$2DMRMhoz1iNNiMfb.8jxRePpCXDh6iR1bkOxe5zHF5pXDLq49qD7G', NULL, 'b11b9b34', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 20:04:56', 0.00, 'active'),
(299, '+260972263347', '$2y$10$g/mwJzKC9MNpUSWzuFcFmehZS.Y3TDpiEHsk/Ii/RsVfihcm5MNom', NULL, 'e9c50ebc', '6232beb8', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 20:05:26', 0.00, 'active'),
(300, '972263347', '$2y$10$aoSJ0iZULFURIbMnUSTK5u3fgJlVAFznjEFL8RXBNqygHqjkAHdL.', NULL, '0cc5b6d2', '6232beb8', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 20:05:56', 0.00, 'active'),
(301, '+260772936304', '$2y$10$aozuq3IbD47WkJf52H33KuVsuj0Tv2IyJouhpz8vffzcoLd6Qb0lu', NULL, '114c4044', '87688fcc', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 20:07:15', 0.00, 'active'),
(302, '0979317100', '$2y$10$M5GLRc0hVtSPV32NcsmLZOD3CT8FivsVnoo2ZZUleu0jhyNvj9nTu', NULL, '0cd283c6', '87688fcc', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 20:17:29', 0.00, 'active'),
(303, '0973090122', '$2y$10$rzIGubVDv3.zuol/2wt8v.6TSNo2nY1T84cN7yaryS9UEiB7ha2vi', NULL, '3a837016', '7e64fef7', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 20:19:40', 0.00, 'active'),
(304, '+260979187481', '$2y$10$9tkE5X2/Z6WrQrvh/DBRfekzaicpN8X46r/RslJbkL9oMVnOa9OlG', NULL, '88f80927', '7d541552', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 20:30:58', 0.00, 'active'),
(305, '779852518', '$2y$10$owHhR10cPCBSOscG.yqeiuCHEDYRTCgMW0G0Awk9ufzd3dA.hG4x2', NULL, '93020ffb', 'eb0615a5', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 20:38:54', 0.00, 'active'),
(306, '0977397476', '$2y$10$i5.LOQxmDpesG89PEJY6tO.L.jyU/kVFMRfxa0WqJnBGkmw6Dwxne', NULL, 'a748e162', '3a837016', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 21:04:40', 0.00, 'active'),
(307, '0975363012', '$2y$10$Cad9sHoX91XVA2kynlxn9.CzgBxr/MyhwQ6CWo1Ej0SaYevpCbvTq', NULL, 'd445083c', 'f06b9949', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 21:06:24', 0.00, 'active'),
(308, '0764637029', '$2y$10$C/xQmwdPyDKg1ctdxtlO/O7RqZsZLKtRYvOuQ/JRQr5dRtpoXGpAa', NULL, '6091063d', '3a837016', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 21:09:06', 0.00, 'active'),
(309, '0778815253', '$2y$10$0K1R6Yuz77qXlU67F5SMgumzStsMlBF1kVyY9zxYxtIJGU0QGJ3eC', NULL, 'fdc90d4e', '0cc5b6d2', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 21:10:59', 0.00, 'active'),
(310, '0972476359', '$2y$10$u9euOlVppRBltyYrDzTQ6eREFIRQdDk66F9L38m5GSzaZ4b3jwgIq', NULL, 'a50001b6', '3a837016', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 21:12:29', 0.00, 'active'),
(311, '0967338327', '$2y$10$tmrsGF4yYPisA9lKfQ.odOSWFHEDBgkQsuz7HrC.ZGWT./IGqUDfu', NULL, '6f97029d', '3a837016', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 21:19:57', 0.00, 'active'),
(312, '260968573390', '$2y$10$easDUJ8MK7hEYsLZy5ilhOvHU1WW0IgyvRQSDAoaNW0.2miqF4g4i', NULL, 'ced696e7', '3a837016', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 21:20:35', 0.00, 'active'),
(313, '+260761373903', '$2y$10$AOSWkj.YflRA8RoomHyya.TOk5jEkfr39JqRv8LB6kMwmI2H.//Fa', NULL, '792dbaa1', 'ced696e7', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 21:39:29', 0.00, 'active'),
(314, '+260771922825', '$2y$10$8jWM3gbqpJaCVUY5oxhmXe.TyU4p33uAbEGzUtjyOtiHOvUhqHT3.', NULL, '5b90c29b', 'ced696e7', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 21:40:14', 0.00, 'active'),
(315, '+260770110014', '$2y$10$q7lGlTenhFfUpeaXFc3hj.WaVbKN1GnRgOKtTnKJiflRYh18XBFly', NULL, '2a3cbffa', '792dbaa1', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 21:42:46', 0.00, 'active'),
(316, '+260975909024', '$2y$10$WltgtftGUFEJGZhY9v.Fv.gldzIenA9HJM3RHi.o3ZzDzRvsKdz9q', NULL, 'a8569f1a', '2a3cbffa', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 21:44:43', 0.00, 'active'),
(317, '+260770416738', '$2y$10$.2Qa9nmEsQbTHyP6dNz5GOvDm9DvbriquN01N1oSSHnT0dSV9Wcxu', NULL, 'a82a5ce7', '93020ffb', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 21:46:09', 0.00, 'active'),
(318, '0771398307', '$2y$10$2.IYjG0WhybB4AhcNaSZ/eIADHGuMd1gnDipWxzD7R6mdajblm5De', NULL, '75d77a47', 'ced696e7', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 21:51:14', 0.00, 'active'),
(319, '0979675585', '$2y$10$DtolXYCdcF7M0WSmvFYwmuxQWFS9upAV9LzthiwQqSgyrCFYC.36W', NULL, '1584688c', 'ced696e7', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 22:06:52', 0.00, 'active'),
(320, '765573463', '$2y$10$MV4.8aWj550ArZ4acFJAfu/VTzSdenDVeurNyAeu6ThNvjHUQsRsq', NULL, '27a0ce8e', '3a837016', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 22:07:42', 0.00, 'active'),
(321, '0765727709', '$2y$10$c8roMqhMVqgKQSfJnhgsPeTND.eeI7Pmoxo/BhchidCDR1BduM3SO', NULL, '96fa38e2', 'eb0615a5', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 22:12:42', 0.00, 'active'),
(322, '+260779231511', '$2y$10$2liIPAPwKTJ7vFg9lYTk6ePm4ZhqTHXwnV1.OXtltB56U05NC3CDi', NULL, 'bd009e30', '3a837016', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 22:52:04', 0.00, 'active'),
(323, '+260770336669', '$2y$10$9AltECOJmDRyEX3HiCjqM.LUkkjwyD3poUv2.G5srZvjtv.FpTFua', NULL, '5c61ce34', '3a837016', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 23:33:59', 0.00, 'active'),
(324, '0974953824', '$2y$10$0hfaT.4qqJT9I2MXkYl0S.nDwvC7M.IFuZtU1Yd4ctT.FyBMzJjx2', NULL, '6a6832c1', '0cc5b6d2', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-23 23:41:55', 0.00, 'active'),
(325, '0979689341', '$2y$10$Kce3Il/PWEkqpmSqDzgvCevmnNRyXaaLt2FrmcNBWqsywOTNq6Bue', NULL, '683733a2', '3a837016', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 00:15:30', 0.00, 'active'),
(326, '0977990904', '$2y$10$Loigp2zO59IETgLpwmt/.et4MdGEgZ1aojxhFfMV/38lSHucDL13S', NULL, 'c5c2fec0', 'ced696e7', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 01:18:04', 0.00, 'active'),
(327, '768931632', '$2y$10$OdMep1Gjk6Gp/QjRgM/Uy.HV5mBmnDIu6C18XRfguV6J5qOToa4A2', NULL, '2ce189b9', 'ced696e7', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 01:55:31', 0.00, 'active'),
(328, '+260977650317', '$2y$10$wJThfglPhJBwo1zXIVq.IOmp6aDEQI/5ZnJqFsM5rWBOgc587P6sm', NULL, '83a60980', 'f06b9949', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 02:27:57', 0.00, 'active'),
(329, '0975859724', '$2y$10$gSsJAsVIjIY./g8l8t14neys69TKtcQkrDaCB2Q6u2Bd/AOLQzl2u', NULL, '638dfe7b', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 03:30:08', 0.00, 'active'),
(330, '0762242328', '$2y$10$UDHSfhtQPq43caFl6CuwJeI9QLz8wq7wKm5c3xwAkDFryxHmvWmQG', NULL, '80b48a74', '93020ffb', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 03:35:18', 0.00, 'active'),
(331, '963021921', '$2y$10$dVJODALuTiG5Y8GXv.//Iug/jDeQUyoCZSESr83Y9sqRlSYDHsZcO', NULL, 'bedf13d5', '93020ffb', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 03:49:06', 0.00, 'active'),
(332, '0763458500', '$2y$10$lfvUIZCaHdaUOj/FpnuRi.i3m/8lqyJDOEg7E8uzQpHHhlx0ZUGqe', NULL, '2a6c7fc3', '3a837016', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 03:49:45', 0.00, 'active'),
(333, '0960686543', '$2y$10$WLR/ij.o1mJfk/czvTw.je4R5YzJyY6Nc9x0WQi1q.qOp6VqWfevu', NULL, 'c2c41999', 'ced696e7', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 03:49:45', 0.00, 'active'),
(334, '0757077360', '$2y$10$UojzmtelNqjnSa19A6Lu5.0Fr/e92JZg/6s0Ze6z5SrNX319lQV.a', NULL, '39ab4cf9', '7bb45b05', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 03:54:53', 0.00, 'active'),
(335, '972476329', '$2y$10$RJbZCrV30owYwyWWYUbvKemr/ez7ccRrixpTQo07ymSHGcGOgJ9xy', NULL, '2bdd480b', 'ced696e7', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 03:55:57', 0.00, 'active'),
(336, '+260764561660', '$2y$10$cIZJg876rpJsyCYgp0ujT.4AsOR28VqpiR5ck8khuQ5F5bnzTozH.', NULL, 'eb31194c', '93020ffb', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 03:57:41', 0.00, 'active'),
(337, '+260972962722', '$2y$10$W5TuYAR.hLDqnOVDbXDcaO3w8e1MpBdppqD5Csa55LiNwcnfWRjOC', NULL, '18ad5ac8', '3a837016', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 04:01:55', 0.00, 'active'),
(338, '260978812338', '$2y$10$069.ItGeeVL4aEO2nE8LGuueO.b5h7868nquB4vAyPYfTRJUD.TAC', NULL, '8dd5b7b2', '3a837016', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 04:05:33', 0.00, 'active'),
(339, '0777832811', '$2y$10$Vm.VtB5em7/C1a1dn9q/cOPhGs3w2xuwYScMquE6QJ4lP5RM7S3n2', NULL, '6214afb9', '93020ffb', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 04:11:20', 0.00, 'active'),
(340, '0974794363', '$2y$10$dLz1vr5Iujhpo.gCFhVfX.Xn2CFzpotyBpp9P6QKlJh.tc5FqHYri', NULL, '62bc7c08', 'ced696e7', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 04:17:07', 0.00, 'active'),
(341, '966442591', '$2y$10$kw4ozE1gDSE.07lDq2SfOuBKLiBvDtEoHOr83IZU/2vpnUElorUsi', NULL, '93b7cc35', 'eb0615a5', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 04:17:18', 0.00, 'active'),
(342, '+260775116575', '$2y$10$bVtxpCOK3.X3cSLdjGqe9egjnUT.9cT4kIPhNRtFpaslWfm02sjia', NULL, '36aa0a2e', '93020ffb', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 04:22:33', 0.00, 'active'),
(343, '0770406628', '$2y$10$Q7bPXyi6VMZAWVdT/oSjvOV5f36g5/UNuo5sLnNVq7hXUhRmXgedK', NULL, 'd99e8405', '3a837016', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 04:23:58', 0.00, 'active'),
(344, '0777526532', '$2y$10$tv4STfbL8zYGH0d3Il1OMOcdGA4Erk6NHpNbJ2DjrvgRxIugtbftq', NULL, 'b812ec6a', 'bedf13d5', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 04:32:28', 0.00, 'active'),
(345, '0967663636', '$2y$10$TJEfRJGWW5PfHo8BLTpkOeTMCW3wu8XJp1TIEe1lgVb2nQkGi2QTu', NULL, 'eff622b4', '2a6c7fc3', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 04:34:06', 0.00, 'active'),
(346, '0971060547', '$2y$10$R9qCyJI5kmxS6eBv/1r.8e7MtX5uKroiag51ezNAs9KDfzUou2btG', NULL, '5b5013d7', 'ced696e7', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 04:42:10', 0.00, 'active'),
(347, '0770797874', '$2y$10$M/92f94mTseLvloBDZqZp.h1oj5vbhZtEiHJXzWYbo6/3WgIeErF6', NULL, '16efd447', 'f06b9949', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 04:48:30', 0.00, 'active'),
(348, '+260764314231', '$2y$10$NzC3OSfO0.jVUrp2PG0aheUatPDuFScV/s/2tivJI1xR0U4lmOMf6', NULL, '932f94c8', 'ced696e7', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 04:55:35', 0.00, 'active'),
(349, '0967029447', '$2y$10$3bjpT.tTvJnJddfcE7x22.PY9IRDmiKbWtskOIf8rEHUj/rc62vdq', NULL, '5f72c3ed', 'f06b9949', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 05:11:18', 0.00, 'active'),
(350, '0968917526', '$2y$10$GGC7TqRimKfuXbKoKrAiyuDsWyrX6WbchcHWC75g39.5jIKeQyMai', NULL, 'c39e0677', '62bc7c08', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 05:12:07', 0.00, 'active'),
(351, '+260776201066', '$2y$10$ZL64I5T.Z2.meAdql9DkPO7zo/N8IWNOM0mCxwPnjkYOohMyh8LIG', NULL, '10b6a2fd', '93020ffb', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 05:23:07', 0.00, 'active'),
(352, '0975902635', '$2y$10$2T/82YWWv22b/bC2ghxkauxjCu10pLB5bLn0B7GQbxXoz3r4wmj7y', NULL, 'b2c78ec0', '3a837016', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 05:29:27', 0.00, 'active'),
(353, '771983425', '$2y$10$tPjZNmDu0x/evATTWCUS4.DJLDAtXGvl3mTJlE3LpuRpR/kdL1rra', NULL, 'ec97b099', 'd445083c', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 05:29:47', 0.00, 'active'),
(354, '+260771107110', '$2y$10$JSgHsjN8VSTobDAckJcZq./wSWo.Si4GHLz9LWZGazRi4ey/hJwSC', NULL, 'b20abd72', '3a837016', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 05:50:33', 0.00, 'active'),
(355, '0978395511', '$2y$10$TtMniF59K3ib3CYESM1gD.zksRUkGKL/Ud5mnj13Lpxn4hDYxSCRq', NULL, 'aed512e3', '93020ffb', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 06:10:34', 0.00, 'active'),
(356, '977475554', '$2y$10$EMqS7pseh8XmKmrkym3nUeHBpMBK7gP6iQ5DjUVz9Y5IwljxRpZh6', NULL, 'df3db14a', '5b5013d7', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 06:16:54', 0.00, 'active'),
(357, '0777807371', '$2y$10$90WIZbqXhDL5ltbFFqfSEufxR8SuA7.8dg0ztqRmX70sIDeuqD1KS', NULL, 'bb9e0e69', '7b5ae8ec', 10.00, 0.00, 0.00, 0.00, NULL, NULL, 'user', '2025-09-24 06:18:12', 0.00, 'active');

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

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

CREATE TABLE `withdrawals` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` enum('pending','approved','rejected') DEFAULT 'pending',
  `method` varchar(50) DEFAULT 'M-PESA',
  `details` varchar(255) DEFAULT NULL,
  `requested_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `approved_at` datetime DEFAULT NULL,
  `mpesa_number` varchar(20) DEFAULT NULL,
  `mpesa_name` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `withdrawals` (`id`, `user_id`, `amount`, `status`, `method`, `details`, `requested_at`, `approved_at`, `mpesa_number`, `mpesa_name`) VALUES
(156, 251, 70.00, 'approved', 'M-PESA', NULL, '2025-09-22 14:10:47', '2025-09-22 11:11:41', '06', 'Alex Washinton'),
(157, 251, 100.00, 'approved', 'M-PESA', NULL, '2025-09-22 16:42:12', '2025-09-22 14:07:36', '070000000', 'Alex Washinton');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `commissions`
--
ALTER TABLE `commissions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `investments`
--
ALTER TABLE `investments`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;

--
-- AUTO_INCREMENT for table `mpesa_recharges`
--
ALTER TABLE `mpesa_recharges`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT for table `tasks`
--
ALTER TABLE `tasks`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=358;

--
-- AUTO_INCREMENT for table `withdrawals`
--
ALTER TABLE `withdrawals`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=158;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `withdrawals`
--
ALTER TABLE `withdrawals`
  ADD CONSTRAINT `withdrawals_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
COMMIT;

