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

START TRANSACTION;



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

--
-- Table structure for table `MLM_users`
--

CREATE TABLE `MLM_users` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `reference_number` varchar(255) DEFAULT NULL,
  `my_number` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `total_balance` decimal(10,2) DEFAULT '0.00',
  `approved` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `MLM_users`
--

INSERT INTO `MLM_users` (`id`, `name`, `phone`, `reference_number`, `my_number`, `created_at`, `total_balance`, `approved`) VALUES
(119, 'Guru', '6353818433', '', 'MLM@6627', '2024-10-18 07:38:00', '100.00', 1),
(120, 'guru 01', '6019521333', 'MLM@6627', 'MLM@1640', '2024-10-18 07:38:23', '250.00', 1),
(121, 'guru 3', '6019521344', 'MLM@1640', 'MLM@4340', '2024-10-18 07:38:52', '0.00', 1),
(122, 'guru 4', '6019521322', 'MLM@1640', 'MLM@9539', '2024-10-18 07:39:16', '0.00', 1),
(123, 'guru 5', '6019521311', 'MLM@1640', 'MLM@8118', '2024-10-18 07:40:09', '0.00', 1),
(124, 'guru 7', '6353818444', 'MLM@1640', 'MLM@5575', '2024-10-18 08:00:51', '0.00', 1),
(125, 'guru 8', '6353818400', 'MLM@1640', 'MLM@3879', '2024-10-18 08:01:03', '0.00', 1),
(126, 'gaurav', '6019521325', '', NULL, '2024-10-21 06:31:23', '0.00', 0);

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

--
-- Table structure for table `payment_withdrawals`
--

CREATE TABLE `payment_withdrawals` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `user_name` varchar(100) NOT NULL,
  `bank_name` varchar(100) NOT NULL,
  `bank_number` varchar(50) NOT NULL,
  `branch` varchar(255) DEFAULT NULL,
  `withdrawal_amount` decimal(10,2) NOT NULL,
  `type` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `payment_withdrawals`
--

INSERT INTO `payment_withdrawals` (`id`, `user_id`, `user_name`, `bank_name`, `bank_number`, `branch`, `withdrawal_amount`, `type`, `created_at`) VALUES
(11, 120, 'rahul', 'SBI', '3442434323', 'nikol ahm', '110.00', 'withdrawal', '2024-10-18 08:01:56'),
(12, 120, 'kamal', 'SBI', '34424', '3', '120.00', 'withdrawal', '2024-10-18 08:02:31');

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

--
-- Table structure for table `wallet_transactions`
--

CREATE TABLE `wallet_transactions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `description` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `wallet_type` varchar(50) NOT NULL DEFAULT 'credit'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wallet_transactions`
--

INSERT INTO `wallet_transactions` (`id`, `user_id`, `amount`, `description`, `created_at`, `wallet_type`) VALUES
(674, 119, '50.00', '25% bonus for referencing MLM@1640', '2024-10-18 07:38:32', 'add'),
(675, 120, '50.00', '25% bonus for referencing MLM@4340', '2024-10-18 07:38:58', 'add'),
(676, 119, '10.00', '5% bonus for referencing 120', '2024-10-18 07:38:58', 'add'),
(677, 120, '50.00', '25% bonus for referencing MLM@9539', '2024-10-18 07:39:29', 'add'),
(678, 119, '10.00', '5% bonus for referencing 120', '2024-10-18 07:39:29', 'add'),
(679, 120, '50.00', '25% bonus for referencing MLM@8118', '2024-10-18 07:40:16', 'add'),
(680, 119, '10.00', '5% bonus for referencing 120', '2024-10-18 07:40:16', 'add'),
(681, 120, '50.00', '25% bonus for referencing MLM@3879', '2024-10-18 08:01:10', 'add'),
(682, 119, '10.00', '5% bonus for referencing 120', '2024-10-18 08:01:10', 'add'),
(683, 120, '50.00', '25% bonus for referencing MLM@5575', '2024-10-18 08:01:15', 'add'),
(684, 119, '10.00', '5% bonus for referencing 120', '2024-10-18 08:01:15', 'add'),
(685, 120, '110.00', 'Successful withdrawal amount is: -110.00', '2024-10-18 09:56:15', 'withdrawal'),
(686, 120, '120.00', 'Successful withdrawal amount is: -120.00', '2024-10-18 11:34:39', 'withdrawal');

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

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

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

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

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

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

