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

START TRANSACTION;



--
-- Database: `gapmagic_db`
--

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

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

CREATE TABLE `users` (
  `user_id` int(11) NOT NULL,
  `sponsor_name` varchar(20) NOT NULL DEFAULT '0',
  `full_name` varchar(50) NOT NULL DEFAULT '0',
  `user_name` varchar(20) NOT NULL DEFAULT '0',
  `email_id` varchar(50) DEFAULT NULL,
  `password` varchar(50) NOT NULL DEFAULT '0',
  `t_password` varchar(11) NOT NULL DEFAULT '0',
  `phone_number` varchar(20) DEFAULT NULL,
  `user_status` int(11) NOT NULL DEFAULT '2',
  `user_paid` int(11) NOT NULL DEFAULT '2' COMMENT '1:paid 2:unpaid ',
  `activation_date` varchar(20) DEFAULT NULL,
  `joining_date` varchar(20) DEFAULT NULL,
  `position` int(11) NOT NULL DEFAULT '0',
  `left_id` int(11) NOT NULL DEFAULT '0',
  `right_id` varchar(11) NOT NULL DEFAULT '0',
  `a_match` int(11) NOT NULL DEFAULT '0',
  `a_autopool` int(11) NOT NULL DEFAULT '0',
  `two_direct` int(11) NOT NULL DEFAULT '0',
  `fast_track` int(11) NOT NULL DEFAULT '0',
  `user_address` varchar(200) NOT NULL DEFAULT '0',
  `pin_code` varchar(20) NOT NULL DEFAULT '0',
  `user_profile` varchar(50) NOT NULL DEFAULT '0',
  `distribution` int(11) NOT NULL DEFAULT '0',
  `join_us` varchar(200) DEFAULT NULL,
  `user_rank` varchar(50) DEFAULT NULL,
  `update_login` varchar(20) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `users` (`user_id`, `sponsor_name`, `full_name`, `user_name`, `email_id`, `password`, `t_password`, `phone_number`, `user_status`, `user_paid`, `activation_date`, `joining_date`, `position`, `left_id`, `right_id`, `a_match`, `a_autopool`, `two_direct`, `fast_track`, `user_address`, `pin_code`, `user_profile`, `distribution`, `join_us`, `user_rank`, `update_login`) VALUES
(100001, '0', 'Software ', 'GRC100001', 'prab.kaku@gmail.com', '12345', '123456', '821951953115', 2, 1, '2022-11-28 14:55:27', '2020-02-03', 0, 100002, '0', 0, 1, 1, 1, '1905 Basant vihar kalka', '133301', 'uploads/profile_picture/2022/05/1653530098img_2016', 1, NULL, '', '2023-08-19 11:40:02');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`),
  ADD UNIQUE KEY `user_id` (`user_id`),
  ADD UNIQUE KEY `user_name` (`user_name`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100041;
COMMIT;

