API tools faq
paste
Guest User

Untitled

a guest
Nov 15th, 2018
64
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.73 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.5.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: Nov 15, 2018 at 03:39 PM
  7. -- Server version: 10.1.10-MariaDB
  8. -- PHP Version: 5.6.19
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8mb4 */;
  18.  
  19. --
  20. -- Database: `mlm`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Table structure for table `binary_tree`
  27. --
  28.  
  29. CREATE TABLE `binary_tree` (
  30. `binary_id` int(9) NOT NULL,
  31. `login_id` varchar(12) NOT NULL COMMENT 'this field depicts the user itself who is entering the binary being child',
  32. `referal_code` varchar(20) NOT NULL COMMENT 'this field wil take us to the parent in users table when matched with referal code of that table',
  33. `parent_login_id` varchar(12) NOT NULL,
  34. `side` varchar(1) NOT NULL,
  35. `added_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  36. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  37.  
  38. --
  39. -- Dumping data for table `binary_tree`
  40. --
  41.  
  42. INSERT INTO `binary_tree` (`binary_id`, `login_id`, `referal_code`, `parent_login_id`, `side`, `added_time`) VALUES
  43. (1, 'rajumecwan', 'R', 'Root', 'P', '2018-11-03 13:29:47'),
  44. (2, 'jariaakash', 'abc123', 'rajumecwan', 'L', '2018-11-03 13:36:16'),
  45. (3, 'akashk', 'abc123', 'rajumecwan', 'R', '2018-11-03 13:58:23'),
  46. (4, 'vinit', 'abc123', 'jariaakash', 'L', '2018-11-03 14:07:00');
  47.  
  48. -- --------------------------------------------------------
  49.  
  50. --
  51. -- Table structure for table `users`
  52. --
  53.  
  54. CREATE TABLE `users` (
  55. `u_id` int(7) NOT NULL,
  56. `login_id` varchar(12) NOT NULL,
  57. `password` varchar(128) NOT NULL,
  58. `user_fname` varchar(20) NOT NULL,
  59. `user_lname` varchar(50) NOT NULL,
  60. `gender` varchar(1) NOT NULL,
  61. `dob` date NOT NULL,
  62. `address` text NOT NULL,
  63. `zip_code` varchar(6) NOT NULL,
  64. `email` varchar(250) NOT NULL,
  65. `mobile_no` varchar(13) NOT NULL,
  66. `bank_name` varchar(50) NOT NULL,
  67. `account_holder_name` varchar(30) NOT NULL,
  68. `branch_code` varchar(20) NOT NULL,
  69. `account_number` varchar(18) NOT NULL,
  70. `ifsc_code` varchar(11) NOT NULL,
  71. `pan_no` varchar(12) NOT NULL,
  72. `date_of_joining` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  73. `referal_code` varchar(20) NOT NULL
  74. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  75.  
  76. --
  77. -- Dumping data for table `users`
  78. --
  79.  
  80. INSERT INTO `users` (`u_id`, `login_id`, `password`, `user_fname`, `user_lname`, `gender`, `dob`, `address`, `zip_code`, `email`, `mobile_no`, `bank_name`, `account_holder_name`, `branch_code`, `account_number`, `ifsc_code`, `pan_no`, `date_of_joining`, `referal_code`) VALUES
  81. (1, '1', 'aa', '3nJMCUSsCX', 'u7FdVNyf1U', 'f', '0000-00-00', '7GrEh3grUw', '2U2dpk', 'o88um5kuVY', 'oY2DYTU56F', 'RyxEo5Lntl', 'iEcW27adTB', '4AokSgA5ua', '521JusNvrA', 'LNuycPQpCi', 'Lz1nlu8jmG', '2018-10-31 16:18:43', ''),
  82. (2, '1', 'aa', 'BV21vDeZg8', 'UMZR9N4Tdc', 'f', '0000-00-00', 'zQnmp00iHi', 'qjkA75', 'V6U3cWvZJF', 'HLFRtkpQbM', 'U3wjc2tlVc', 'qeaWgyH88b', 'jmDPTfbMtZ', 'ourkpv6zae', 'aYn7t5ysce', 'gOK3n7IuXz', '2018-10-31 16:24:31', ''),
  83. (3, '1', 'aa', 'KZBZARIuhO', 'AruN90PW3S', 'M', '0000-00-00', 'qqecZXfAqZ', 'SaZyt0', 'LPNXHRwAde', 'INg44xWtVk', 'MVDoHFEfWQ', '9wn731bQZ0', 'dVb7GclZlM', 'M5uUPc2FVz', 'EkJyyCTDJm', '1kX2uFoWgg', '2018-10-31 16:29:12', '12345'),
  84. (4, '1', 'aa', 'TTAFfplTY2', 'IV6rPRfDR5', 'f', '0000-00-00', 'VWofeBc0s4', 'K7ImFU', 'jp5neR6RpL', 'JWB7uW1TEf', 'JojP4JUBGa', 'ZmomPBLpo8', 'ubcyWdixoI', 'Evf5vanAZL', 'wulxHMzLBZ', '4mpunTmgnx', '2018-10-31 16:38:48', '12345'),
  85. (5, '1', 'aa', 'hYfG1mfx3f', 'MhuS9qLaGd', 'f', '0000-00-00', 'IHrzWtzJWN', 'Xqg7wp', 't5jkWI2yNB', 'uIPjpnbkWm', 'jmQS85uiXP', 'RG177XlvnT', 'ejsxhV4Igi', '76a2TzApKx', 'strIOxIGq8', 'SW5Z9oBw7l', '2018-10-31 16:39:06', '12345'),
  86. (6, '1', 'aa', '8E4njHR1un', 'SxSBj2GnhQ', 'f', '1994-08-28', 'VafHssu7IW', 'yktHiZ', 'EBpaNHUdom', 'GIiXvfaUsI', 'U6svN2ZUlB', 's7hFG4Vfz7', 'BnH22E5ld3', 'X4jeddsUiw', 'takWkUqCij', 'k2eOHeQoiV', '2018-10-31 16:40:31', '12345'),
  87. (7, 'archit', 'archit', 'Tk60wCZWjt', 'jxvTFktQ5y', 'f', '1994-08-28', '07EYsHwfHN', '5n63w8', 'QB8GN2ukco', '5692977310', 'NOzY8CccK8', 'kYqnfI0ndl', 'ziNHYCSBaa', '0243013832', 'RcLbyR2uJV', 'BYqQ10llWX', '2018-11-01 11:41:52', '12345'),
  88. (8, 'archit', 'archit', 'Tk60wCZWjt', 'jxvTFktQ5y', 'f', '1994-08-28', '07EYsHwfHN', '5n63w8', 'QB8GN2ukco', '5692977310', 'NOzY8CccK8', 'kYqnfI0ndl', 'ziNHYCSBaa', '0243013832', 'RcLbyR2uJV', 'BYqQ10llWX', '2018-11-01 11:42:12', '12345'),
  89. (9, 'archit', '$2y$10$hlZLz.ipol.PSlDrsE5.n.8AJ3b/STglye5ZcqaqeegwMSq0soiSS', 'eQSV04DMyi', 'Xjvj2pujlO', 'M', '1994-08-28', 'DGeY6EtXST', 'jqMyHt', 'fAh61EVs4Q', '9119763178', 'ewfDL1sCoA', 'cIjNGlkSCt', 'm3S44fBQBP', '8803718834', 'g8zIClhj4S', 'shktYL1vUG', '2018-11-01 11:43:34', '12345'),
  90. (10, 'rajumecwan', '$2y$10$K8WqXdQN9VjcpoUwrxVbJemoEkNT1.bttT7Y90SMUY3kHmElKGEkm', 'Raju', 'Mecwan', 'M', '1994-08-18', '19, Narayan Krupa Society\nNear Narayan Vidyalaya, Shaktinath\n(aa address ni pase j)', '392001', 'rajuraju@gmail.com', '(906) 720-985', 'Global Ambitions', 'Archit Kayasth', 'glo32', '090909090909', 'ifscsq3', 'adpqsr12434', '2018-11-01 12:05:49', 'abc123'),
  91. (11, 'archit', '$2y$10$CgdTDmjiUw5Eug8UV62Zk.2goJH.e6pABJ3KwqCWQP5xcJ3roDAae', 'QYIp4BqaEo', 'N69oo5Lnho', 'M', '1994-08-28', 'hYklNbpe39', 'v7zmTO', 'UrBKVNYMqD', '0204058811', 'MoF4KFgrq5', 'esjf2cYQ1w', 'QFgoO7uwic', '3336869505', 'tj13YDwAIX', 'Xzhcb0HPwF', '2018-11-01 12:19:03', '12345'),
  92. (12, 'archit', '$2y$10$lIwNhF5ntrZWUmTBziCmQOmLkOaX6Fjid3NUVkJNT1dhDYn4gJspe', 'yYtYItVqDT', 'O6zz18X5Qr', 'M', '1994-08-28', 'XWiV0TvjbQ', 'FPiVdt', 'qKQaUMLqhj', '8249079921', '6OPqnB63MQ', 'mSUVJbsWbl', '2AHdX0rdJA', '5147704462', 'ms5fGOCEzC', 'dZvuVFDbws', '2018-11-01 12:19:30', '12345'),
  93. (13, 'archit', '$2y$10$x1pjknUH0EQpwIw6L.wBQeUBlb9OEgWgbSe9HJzVlLmWYu2RsNzq.', '1Bak6ITSfG', '0IGw9JIIe9', 'M', '1994-08-28', 'KDRKMtudpX', 'L6C3U8', '1tAI4gPEGl', '6028224563', 'shEU733E1J', 'AcN8row5yR', 'jp3ASXoTNm', '4823954507', 'rVP4MVbsfG', 'pVwqs7LqEK', '2018-11-01 12:21:09', '12345'),
  94. (14, 'archit', '$2y$10$xH7w.pcUskKloWlYh8b9OeYXurcWupzTn2oM8avvrDUnmiONHp2BK', 'FRRJ8BHBwE', 'bZpfTaW7qs', 'M', '1994-08-28', 'WqBKi49fJV', 'g1hqX3', '7KMV3T8MPX', '4161731721', '21ttIlSodr', '248EOUgPFG', 'BtnSAfWMtS', '7427366226', 'YzCHGqOabq', 'Fyf0CivjYk', '2018-11-01 12:23:39', '12345'),
  95. (15, 'archit', '$2y$10$ZSFwYiheUM8VQWL4tmBBduQR/F97SI/Z/RBaT4VcZ3N3FXcuRuuA6', 'JGlSzjr5vM', '1BdYJ9J314', 'M', '1994-08-28', 'qmasvYdcpt', 'gZFX93', 'PgyKxbtiRF', '9044589649', 'EChQOd2OwM', 'bAtvbfqYqE', 'BJWwTFRlLW', '9668810127', 'NkcnD7h3Yn', 'VfkHxHFkUa', '2018-11-01 12:24:26', '12345'),
  96. (16, 'archit', '$2y$10$rE6hZOHa3jggEzpmTNj6Au9oCF3nbIZTsAS5hws0uTSxlGWtKPjre', 'yN0rQHzNXy', 'vku3lPbNKv', 'M', '1994-08-28', 'nHad6fDVzX', 'aj7dQD', '1dym0cNsX4', '2112947014', 'YJ6W8Zqrcx', 'gW67gTVMfJ', 'cM92gyIbwR', '6034301601', 'ceZ88ozDqt', '18wpMoBcRX', '2018-11-01 12:25:36', '12345'),
  97. (17, 'archit', '$2y$10$CB1PjByB8QqMOZbBYMD0Pu9STF8RQg/TCEJpllg6wc.1xUe7Kxb2m', '2IPIk8wAJf', 'WJSD2e3Cbi', 'M', '1994-08-28', '8BGvynjQzC', 'suf7Bp', '3QvMqMKqCb', '0025880107', 'vddumnPath', 'Z6XuiAnA9p', 'qBcUqRJy6Z', '6518122979', 'NlobS1ivGO', 'hymB5wzTec', '2018-11-01 12:25:53', '12345'),
  98. (18, 'archit', '$2y$10$b1yH2vsDNK8jWK1W1.QkXOA80bDUTYn64hXipiZiEIZtXDJOt6OXa', 'fXVoSCPUy1', 'inujPF8ZX1', 'M', '1994-08-28', 'jtLrt0Nzp5', 'X046bA', 'B2X5OyyKgQ', '8433336401', 'bReKGmm8yZ', 'AnDDUlzyk7', 'HSGV5QJIEU', '4868997674', 'J53ClLSE9w', 'So1aRQqQIh', '2018-11-01 12:29:59', '12345'),
  99. (19, 'archit', '$2y$10$7p42GeiveedFnmftAdAa7OFg7q.Cix.Lhg0OjtW2MvorSoCG9hYdK', '4LaDZWQlGh', 'dp0GMJqGJm', 'M', '1994-08-28', 'UIRk9p2RQR', 'a4Ybuh', 'ozT7rxGYoa', '7302188886', 'oXveWqE6Iq', '0EMhXvL7vZ', 'wgMDZZiOmM', '9191189891', '17FIgbKnH2', 'zvuLLojbGP', '2018-11-01 12:31:55', '12345'),
  100. (20, 'archit', '$2y$10$7oRbBhqQjcgEciRpMC/qcuIaD.UcRH3NcYBf/8okl7nFH4UP8mn8W', 'g38eddsRXF', 'N4r9I2qENs', 'M', '1994-08-28', 'MeIXrImhmm', '3YfOkb', 'ysWisagrFv', '7898958142', 'wkQwA5aVNT', 'ZxAkNzYXcG', 'fcJrvDN76k', '0745045935', 'UekHqCWLWq', 'BEOVEx0ccg', '2018-11-01 12:37:27', '12345'),
  101. (21, 'archit', '$2y$10$.UUuEAiMB3fKJUCCmsLMs.cAt3leP9nJgz40aMzfXDmSLzLTJygl2', 'wetnruhImz', '2EOFiXS9Li', 'M', '1994-08-28', '2XLNcinnHt', 'fCqvZb', 'jwIwzywmKI', '1990383126', 'clZlEBU0iV', '0gnZZpxEdi', 'uklBmm7vec', '8257321112', 'Y2yseaHkMz', 'HQmOWTqdOE', '2018-11-01 12:38:39', '12345'),
  102. (22, 'archit', '$2y$10$G1oMnO0SBXZYvLOEIEGLkuxEwIgiff9ur.BCO0CbMhl3wJoWRnMlO', 'fDckxlKZUG', 'Wad9f0d3Zm', 'M', '1994-08-28', '9oq42uaWxZ', 'OwRVcs', 'hu1mqxaZhb', '3667163067', 'Fa3cRzejvv', 'OBBXq0rPDx', 'JsWgsRKAdT', '8095953683', 'X1ajM6EqdM', 'USWguw9kD0', '2018-11-01 12:45:28', '12345'),
  103. (23, 'archit', '$2y$10$iA9uB9AUHnt9XTgkV3g9vujRG/UXAXV6ZOQ.OsWjhvPwbncenuO/G', 'A1kQi1eond', 'EJdMhpflz3', 'M', '1994-08-28', 'Ch4OdYsXLD', 'CI3TsI', 'G4tjk8QKk6', '8139018227', 'KpQ7z36YL7', 'hZYddu07Ew', 'cr6tZ1vDDZ', '0254609587', 'Wu7RY5q4Ba', 'Iq5rRTDYj1', '2018-11-01 12:57:59', '12345'),
  104. (24, 'archit', '$2y$10$5fXm3Mx/iA3rOPhE19h/T.agbW2S75xRhuHsfoH113k4PHGuiIYaa', 'nsYNKil8cz', 'vLpxjR2zBx', 'M', '1994-08-28', 'pcsUCjCry8', 'yWBlCc', 'bSW0D6L2Ov', '8077096412', 'MyR3MnGg1j', 'ZlhKlyZE8m', '5ocF7PZAU9', '0026789753', '2N8C9e5jYl', 'YeZdSvQpmt', '2018-11-01 13:07:00', '12345'),
  105. (25, 'archit', '$2y$10$2TJeYsSv82a3ADEB.ywNOuOa/i/GwO7JSb8ss.jZf0CDlZpJ1DO7W', 'zHYYR6q3Sl', 'VrCRPjxvtB', 'M', '1994-08-28', 'OA0cqDTdtp', 'IjqfAC', 'NIXNWe3ewt', '8802297110', 'MQPYbR230l', 'dAcHWGMBnW', 'vyTEa4v1fW', '4896401375', 'JtF9b9cZy2', '60ypFwvdFm', '2018-11-01 13:09:46', '12345'),
  106. (26, 'archit', '$2y$10$EAI9W7FUeSv4EteC0ZFM5OOPA7FoGUUKkB4umA1r0jL1Nyq6UuK.y', 'qqK4uERSBJ', '6fv55i7CSU', 'M', '1994-08-28', 'gkvvBamoDB', 'td97rI', 'eZw87PIR4z', '0644068921', '598TzMRxVh', 'uklsnOa2d8', 'W1Q3cNT6Th', '3637252788', 'G8ipEN5aFr', 'rC10X6hOpm', '2018-11-01 13:10:55', '12345'),
  107. (27, 'archit', '$2y$10$BdrUG3xW01fSefT6DWQ9vug9hZXhBAPkH4SkFjp0AlNrNpsPE6uFu', 'v3tdxDCIao', 'diR69nzp3m', 'M', '1994-08-28', 'YFuYb5lUjm', 'Wl9I3K', '80Lf4qwlXm', '5143952622', 'lxsbF69f4l', 'JLAYS89vqQ', 'jisLEEyR3O', '4487284295', '3StiN6KsGm', 'hRjhKstjqf', '2018-11-01 13:13:24', '12345'),
  108. (28, 'archit', '$2y$10$zT/WGmBqpVDRqYHJXXjg4efDv9WPVHXjWTqnsXAltZ4TPvrMzCyq.', 'amUwugQAsc', 'DKknFsGrTS', 'M', '1994-08-28', 'EbRmd9rqK2', 'frJJe5', 'FfamrSRKlM', '3353211448', '7aGizC3dZO', 'PwhQ9HUye1', 'd6sIiRf7cM', '1115647321', '4sOv23lZOJ', '5gQOxr17V3', '2018-11-01 13:15:21', '12345'),
  109. (29, 'archit', '$2y$10$WECwxlu3x6mstZMBlo2Qd.b8xxmdX0pgZBnhwl7GlWY5VwKRrTsMq', 'bdEKPuNwTn', 'sSrR3XFuvE', 'M', '1994-08-28', 'S8US9jn7nL', 'q8B1d8', 'nb7AvSAlfr', '4180766925', 'nKfMU5HR0g', 'MkTHRMunbF', 'WaNEWcZ8hM', '5122416434', 'eOp0r5BJLH', 'yryvT666nH', '2018-11-01 13:16:23', '12345'),
  110. (30, 'akashk', '$2y$10$fizN8ieWZP.283tjFfIkaucb8i2kkg345b8UfaqlCMKjA8N.VN7ha', 'Akash', 'Kayasth', 'M', '1994-08-11', '19, Narayan Krupa Society\nNear Narayan Vidyalaya, Shaktinath', '392001', 'asdarchit0311@gmail.com', '(906) 720-985', 'aa', 'akash k', 'r4940', 'a3433', '435', 'azpq', '2018-11-01 13:18:34', '392001'),
  111. (31, 'vinit', '$2y$10$F1RoGo6xCE0LCnqBlgMDp.ucyrfroVgLBk.gguM7a55qMGfHNGJDK', 'babul', 'carpenter', 'M', '1994-08-10', 'najk ma j chhe', '909090', 'carpenterW@gma', '(658) 655-865', 'icici', 'hohoh', '5545', '555454', 'dfjfd3', '4389349834', '2018-11-01 13:19:52', '324'),
  112. (32, 'jariaakash', '$2y$10$NrcuT6niB5fAeKM6o0EzfeX5Qaa0uBDFcO7wKlLiXSBI9ohEkZCxm', 'akash jaria', 'jaria', 'M', '1994-08-20', 'Near to 19, Narayan Krupa Society\nNear Narayan Vidyalaya, Shaktinath ', '344343', 'archit0311@gmail.com', '(906) 720-985', 'we3434', '4343', 'weew', '35533', '4343', '433', '2018-11-01 13:21:04', '392001'),
  113. (33, 'archit', '$2y$10$EOA/MfCOGNVUjMSzPhaMO.Jl2H8RDqdapmpg2WBkgV2GlFnItCFlu', 'yqHoX9k3Eb', 'mXE4l6RFLq', 'M', '1994-08-28', 'aPa2i1Wf0W', 'x5WLcP', 'iB3k3yx1MB', '3774633310', 'RAtGRgScs2', 'g01ROF0HZA', 'yHVLqKU3RP', '6959503161', 'vmz5I6ilr0', 'DRVgLoepsJ', '2018-11-01 14:26:24', '12345');
  114.  
  115. --
  116. -- Indexes for dumped tables
  117. --
  118.  
  119. --
  120. -- Indexes for table `binary_tree`
  121. --
  122. ALTER TABLE `binary_tree`
  123. ADD PRIMARY KEY (`binary_id`);
  124.  
  125. --
  126. -- Indexes for table `users`
  127. --
  128. ALTER TABLE `users`
  129. ADD PRIMARY KEY (`u_id`);
  130.  
  131. --
  132. -- AUTO_INCREMENT for dumped tables
  133. --
  134.  
  135. --
  136. -- AUTO_INCREMENT for table `binary_tree`
  137. --
  138. ALTER TABLE `binary_tree`
  139. MODIFY `binary_id` int(9) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  140. --
  141. -- AUTO_INCREMENT for table `users`
  142. --
  143. ALTER TABLE `users`
  144. MODIFY `u_id` int(7) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;
  145. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  146. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  147. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!