API tools faq
paste
Guest User

Untitled

a guest
Jun 19th, 2018
174
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.72 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.7.7
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Jun 19, 2018 at 09:05 AM
  7. -- Server version: 10.1.30-MariaDB
  8. -- PHP Version: 5.6.33
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET AUTOCOMMIT = 0;
  12. START TRANSACTION;
  13. SET time_zone = "+00:00";
  14.  
  15.  
  16. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  17. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  18. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  19. /*!40101 SET NAMES utf8mb4 */;
  20.  
  21. --
  22. -- Database: `mydb`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Table structure for table `doc`
  29. --
  30.  
  31. CREATE TABLE `doc` (
  32. `id` int(20) NOT NULL,
  33. `username` varchar(50) NOT NULL,
  34. `name` varchar(50) NOT NULL
  35. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  36.  
  37. --
  38. -- Dumping data for table `doc`
  39. --
  40.  
  41. INSERT INTO `doc` (`id`, `username`, `name`) VALUES
  42. (1, 'doc123', 'doc 123'),
  43. (2, 'doc234', 'doc 234'),
  44. (4, 'docwho123', 'doc who'),
  45. (3, 'taimur', 'doc 456');
  46.  
  47. -- --------------------------------------------------------
  48.  
  49. --
  50. -- Table structure for table `notify`
  51. --
  52.  
  53. CREATE TABLE `notify` (
  54. `id` int(11) NOT NULL,
  55. `from_id` varchar(30) NOT NULL
  56. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  57.  
  58. -- --------------------------------------------------------
  59.  
  60. --
  61. -- Table structure for table `sessions`
  62. --
  63.  
  64. CREATE TABLE `sessions` (
  65. `session_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  66. `expires` int(11) UNSIGNED NOT NULL,
  67. `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin
  68. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  69.  
  70. --
  71. -- Dumping data for table `sessions`
  72. --
  73.  
  74. INSERT INTO `sessions` (`session_id`, `expires`, `data`) VALUES
  75. ('9XDfymk6GNDbN7CyZfLuCqG0j9LM1yl6', 1529474101, '{\"cookie\":{\"originalMaxAge\":null,\"expires\":null,\"httpOnly\":true,\"path\":\"/\"},\"passport\":{\"user\":87}}'),
  76. ('YH_LTqyvD3Hz6dOmWJWg6Z8SByxkCRrl', 1529472701, '{\"cookie\":{\"originalMaxAge\":null,\"expires\":null,\"httpOnly\":true,\"path\":\"/\"},\"passport\":{\"user\":86}}');
  77.  
  78. -- --------------------------------------------------------
  79.  
  80. --
  81. -- Table structure for table `test`
  82. --
  83.  
  84. CREATE TABLE `test` (
  85. `id` int(50) NOT NULL,
  86. `name` varchar(50) NOT NULL,
  87. `phone` bigint(10) NOT NULL,
  88. `disease` varchar(50) NOT NULL,
  89. `date` datetime NOT NULL
  90. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  91.  
  92. --
  93. -- Dumping data for table `test`
  94. --
  95.  
  96. INSERT INTO `test` (`id`, `name`, `phone`, `disease`, `date`) VALUES
  97. (1, 'afzal', 123456789, 'nightfall', '2018-01-17 00:00:00'),
  98. (2, 'arafat', 9898989898, 'mental issues', '2018-01-29 00:00:00'),
  99. (5, 'shubham', 5555555556, 'errrttt', '2018-02-04 00:00:00'),
  100. (8, 'anand', 123456789, 'aaaaa', '2018-02-21 00:00:00'),
  101. (9, '', 0, '', '0000-00-00 00:00:00');
  102.  
  103. -- --------------------------------------------------------
  104.  
  105. --
  106. -- Table structure for table `users`
  107. --
  108.  
  109. CREATE TABLE `users` (
  110. `id` int(10) NOT NULL,
  111. `name` varchar(30) NOT NULL,
  112. `email` varchar(50) NOT NULL,
  113. `password` varchar(255) NOT NULL,
  114. `username` varchar(50) NOT NULL,
  115. `requests` varchar(10000) NOT NULL,
  116. `req_count` int(5) NOT NULL DEFAULT '0'
  117. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  118.  
  119. --
  120. -- Dumping data for table `users`
  121. --
  122.  
  123. INSERT INTO `users` (`id`, `name`, `email`, `password`, `username`, `requests`, `req_count`) VALUES
  124. (1, 'afzal', 'abc@gmail.com', '12345', '', '', 0),
  125. (2, 'arafat', 'khanarafa@gmail.com', '12345', '', '', 0),
  126. (3, 'anand', 'anandsensingh4@gmail.com', '12345', '', '', 0),
  127. (4, 'chirag', 'chiragbatra18@gmail.com', '12345', '', '', 0),
  128. (5, 'gaurav', 'gauravraja100@gmail.com', '12345', '', '', 0),
  129. (8, 'abc', 'abcd@gmail.com', '12345', '', '', 0),
  130. (15, 'afzalali', 'asda@gmail.com', 'Aditya@99555', '', '', 0),
  131. (16, 'shubham', 'soft@tajoo.com', '$2a$10$m7yo2SSI.CTsrdZ7NLInDOPm3i5pY6DR15jHZTKpa56zfLpXVnGtq', '', '', 0),
  132. (19, 'deepak', 'singhdeepak@gmail.com', '$2a$10$zug5J2.liqv9/BWRh/yL7eEa3oUt6uNm4AeTkK57kbRQ1TuRI6Rhu', '', '', 0),
  133. (21, 'clinic', 'clinic@gmail.com', '$2a$10$o2nK8MoX.1nB1AKgWilC0.nqp4i4PMsQ1t/zQYrrgQue6xfhfaXG6', '', '', 0),
  134. (22, 'heyy', 'hlo@gmaio.com', '$2a$10$QOjR/x/DFbeOmsVLO12YGOeDzxkRCyW4YAQM33GUQU4Z9EMH0SUL6', '', '', 0),
  135. (24, 'kdvdkvkvv', 'kckcckd@gmail.com', '$2a$10$USZI1fkECfGL7Uz7klnQIOwWDTW84hrF34J59jvUXfvx7yr6MVsXi', '', '', 0),
  136. (25, 'fkvfvkfvkkfv', 'dcdkv@gmail.co', '$2a$10$ieG1LTeppjx0EWxHz0QGVeo5eYq6SCnN/sBWcOGmotPDGkV22lxJ2', '', '', 0),
  137. (27, 'dkvvovfovk', 'dcdvolvf@gmail.com', '$2a$10$c2Om5IlZ1unF7gG88m.LNO.18cEreM9JXFdeO385eBQFeJIHd47zC', '', '', 0),
  138. (28, 'jfvfkvjfkvjfvf', 'hleee@gmail.com', '$2a$10$pIy0JE6xnoEQ18xzFhwApOnV4F6LYIWc7kIo3l7cjg0d22iY/JUGC', '', '', 0),
  139. (29, 'jfvfvofvkofv', 'cndklfvkfvl@gmail.com', '$2a$10$qdD8IqYTpbxCBcEfzOJnwun8KQM8/sSOhdimKViTy/G2fWHQZm..e', '', '', 0),
  140. (30, 'jjjhjhiiiiyfyy', 'jhgygyyf@gmail.com', '$2a$10$6qRzZ0hAajEJxtnN523.du8iclI4jP3eJpkluA4hIZtI0oYnKWebC', '', '', 0),
  141. (31, 'VBGGHHTHT', 'NGGG@GMAIL.COM', '$2a$10$ARMLqtGrVBKzUvigqsfZ.ebvaa1UssTlEQnopuleaKdmaDUH5zaQq', '', '', 0),
  142. (32, 'dcbcjdndjc', 'knckd@gmail.com', '$2a$10$lM9gU02M5jYviXTySnCr4.EJYIyH1r/A7zMdA.SxZmgrTnacQjeA6', '', '', 0),
  143. (33, 'duck', 'duck@gmail.com', '$2a$10$RR1KTQcptaePPxBLgqDLpu.fhJWhTwHR0FUBvHQJBM6MdN.3WICsW', '', '', 0),
  144. (34, 'hyyyyyh', 'jjbjbjb@gmail.com', '$2a$10$/ZEJmdJonUYJtmLgtYSATehwGpwdYOq38geM4RPkMd/0Vs4Qh3akW', '', '', 0),
  145. (44, 'billy', 'billy@gmail.com', '$2a$10$rEn8z7J8sOsKvGtVPIWsvOyb0SmYp9WX28fKUfxbchgiSsAar8NLa', '', '', 0),
  146. (45, 'dcdcdkcj', 'dnjneccjjk@gma.com', '$2a$10$dPTYLj9wbrgAP/jsEQDUie3nTijk8EuwPaZsgfy1X/tMnBofAWCdq', '', '', 0),
  147. (47, 'dmjedejde', 'dncdjcdcj@hgm.ij', '$2a$10$r3NfmbmdfUWaZRK8fnplYupANQgtyhw9QSQspKfY3NpcK.iy8uOCa', '', '', 0),
  148. (49, 'ddjejejeed', 'ndjnjnj@yahoo.com', '$2a$10$eX16Mi6c16hgzCnoviTT1.gqfeEsJ/uLID5RzI17byfm0UB8FMZZq', '', '', 0),
  149. (50, 'ffjjfrjfn', 'dmdmvmm@yag.vom', '$2a$10$YR9FcepuhA5FP1Zx.jBXF.E8N9YQp0x4hNXfHFf8LAdWLERVTzeCy', '', '', 0),
  150. (52, 'dkkkkk', 'dcdkdkk@ynaa.com', '$2a$10$Id1pJs/8H6qobK8e0M5EO.PalWWhppmgm4ucQTnhV2q6ipW3PXZtO', '', '', 0),
  151. (53, 'hhhuuu', 'jiiiuyv@guu.vim', '$2a$10$gaOfkUmkofKpF1ouvZilieXRYOlrU3aFR0jTv8zxtXTo7hOqqK5Ea', '', '', 0),
  152. (54, 'jfkfkenjnwje', 'dkkdk@yan.omd', '$2a$10$ZsuIBcUUVjvXsSLioaI3tuUTcZJ8EoF1SNh6RX8I3BmkOMzkyQmGS', '', '', 0),
  153. (55, 'dkkfkddl', 'slkkk@fkkf.vo', '$2a$10$nFdLd/qB/irfPoAmZTMqguWzauRu6RSA3.VTb5bpXC.GRzpHLgRbe', '', '', 0),
  154. (56, 'gtuii', 'hjhihih@hjj.viko', '$2a$10$MavTJkx44ViU/VCdAKgtmO/Q3SlZpzU9geeXS8CAljvkk83JL1aoe', '', '', 0),
  155. (57, 'dddddddd', 'ddddd@gjd.col', '$2a$10$Bo2Q1ISrB7MH2PuyGX.Jf.XrKnbdE9CQuE2Dgcz52arl8.EBW0AUq', '', '', 0),
  156. (58, 'dckfvfv', 'dcjdck@kdc.ckk', '$2a$10$/juKJtTKtbKoR0HCrLDWTuRkzrPglzhPCSTbrielez1n4VVOPemEi', '', '', 0),
  157. (59, 'jnjjjk', 'jjbjbjhb@gmail.com', '$2a$10$kKQMMl9W/f53RhNfnDqE3.QGYmztoGwvWiQkPTA8F.olFb2uHnADG', '', '', 0),
  158. (60, 'jjjjjjjj', 'jkkkkkk@gj.mko', '$2a$10$3xXdXosAZqHEGH0TbMWZLeV.vfm6iY.zYMdr57/JmR9eawCXGPurO', '', '', 0),
  159. (61, 'njjjjjkk', 'jhjjj@fh.nj', '$2a$10$hdykNc8w23NfGmGJFAPHkuFCKwegZJgKv1Hd2g4JtbPgSSuTYX4yi', '', '', 0),
  160. (62, 'nkjikjiii', 'mkkmk@fgh.vom', '$2a$10$/kyxYjFGkdHCVzfaL72AHOa8MzQoqQmuUQfYhsYH20ApMKUxGgGHm', '', '', 0),
  161. (63, 'jnjjjjjkk', 'njnjnjjk@hh.cim', '$2a$10$U6i8kn.xCsW/jJoLpqQ.ce1k3QiW8W/PnCHyZLxGmEidrVRK.8EJ2', '', '', 0),
  162. (64, 'ajducbdcdkdf', 'ndcsdjcdsn@bdcjdc.com', '$2a$10$Ucon6K7A7h2/bvYOoW/ru.KjCBFtJMjbYVRybj9TGwCsJ5CJF8amu', '', '', 0),
  163. (65, 'asdvfbgbnhnh', 'hnghhjhj@hjmj.vik', '$2a$10$BOxmNE4BPcy14A.Gi6w8zu8TA6pAcomGKgN9/dbTUqvOnMXZQBt7m', '', '', 0),
  164. (66, 'sdvfvdf', 'snjcnj@ndjcd.com', '$2a$10$JBM/cZnOKnfevthbmXy2tOkWMokO45dBJ9Ac0SWLbszpg/XerPGVK', '', '', 0),
  165. (67, 'asicjdicsdc', 'asnicjid@ncd.xjjd', '$2a$10$nKVmQ/0AMCqkOwX3nKEvYeNTnte7wAj/UV4I6.Z4uOjukXqZfEXwK', '', '', 0),
  166. (68, 'taimur', 'taimur@gmail.com', '$2a$10$N7a.GXQ.jWjMdEq938Uuse0Lg1oz9kE5aMOZzCZ/a.6wOYigSkEVG', 'taimur', '', 0),
  167. (69, 'hahaha', 'hahaha@gmail.com', '$2a$10$Ap/OYmvKGFSLuPruRNJ9QuyYCfX.rrjMHPvw8McWzAY9rDufGqO4G', '', '', 0),
  168. (70, 'check', 'check@gmail.com', '$2a$10$OBqoTA7NAypyZ1SfHBLHROlskZn9mKV2sZ1.avTr1EqkLAGxvFakm', '', '', 0),
  169. (71, 'checker', 'checker@gmail.com', '$2a$10$931xTcyLIZoXlUUsCwW6Iesvji73H7uGbaqLkB4Yef1/ohKfD7bG.', '', '', 0),
  170. (72, 'amkmdkacmdkc', 'taimur12344@gmail.com', '$2a$10$WymudBHE7z5eOhU/D7fvSOL1JawZrAsy0zdqeVWmXUM1xDeUO/qT6', '', '', 0),
  171. (73, 'tgtgjbnfdbjvd', 'taimur1234567@gmail.com', '$2a$10$PKcsVFXHDJ25HamAhjoWCO1Cck1kLfbcb3zljzigmjY8Nb5.cqRkC', '', '', 0),
  172. (75, 'toooooooo', 'taim123@gmail.com', '$2a$10$xirBm3shjwuBBfEGjzQTO.2IFhD8aXCUPaXoIrQLdTZ5mXPE5KaYi', '', '', 0),
  173. (76, 'abcoldckodcd', 'taimurabcd@gmail.com', '$2a$10$yl3FBDVe6aeiL6jwO52ble8VIn.HxK2nN6mzwOKR.qpJWiSpRvdJm', '', '', 0),
  174. (77, 'arafatkhan', 'landura@gmail.com', '$2a$10$zZY/q8VPehCrT607XnmjSuhF.tkR297KTs.bMn3Zn8EDbWSxM4V1e', '', '', 0),
  175. (81, 'asjccsdks', 'taimur12345qw@gmail.com', '$2a$10$9fB5t0X7qOeJnWYGkbMRrevqR7CJh07od9o9RzfJm/6PpM1zBtxlm', '', '', 0),
  176. (82, 'library', 'library@gmail.com', '$2a$10$e97wdSyi1J5siQV6zL9iYOgIHhP7QEkAJc8xyhhKcMnUrpj3CsROG', '', '', 0),
  177. (83, 'check123', 'check123@gmail.com', '$2a$10$cSapvXdBBhKi/blAfQnaaeeBe0Wlag.cJnkCiNoaxrHIw7u/rXMeO', '', '', 0),
  178. (84, 'finally', 'finally@gmail.com', '$2a$10$AnV6gUoMYsfqnW/5N7zr8eb5kVGsbo.sgqRJdOtrnEJ29fSq1vpFe', '', '', 0),
  179. (85, 'checkreg', 'checkreg@gmail.com', '$2a$10$2FD9P1vBoCE2SS1BZwoLKe9jWHz2mq5wir9GCNuQUG2tL7zfg9X8O', '', '', 0),
  180. (86, 'doc123', 'doc123@gmail.com', '$2a$10$48KwwrsY1gt7ScDVi9qGE.GK87EFfFlRIbh6K5l2nPcqliIfEvCxK', 'doc123', 'doc234', 1),
  181. (87, 'doc234', 'doc234@gmail.com', '$2a$10$JT4J57LjwbSUvevq69p6M.aCNg0wuzMpmA9fI/Nie5NhR8RHv76Yi', 'doc234', 'doc123', 1);
  182.  
  183. --
  184. -- Indexes for dumped tables
  185. --
  186.  
  187. --
  188. -- Indexes for table `doc`
  189. --
  190. ALTER TABLE `doc`
  191. ADD PRIMARY KEY (`username`),
  192. ADD UNIQUE KEY `id` (`id`);
  193.  
  194. --
  195. -- Indexes for table `notify`
  196. --
  197. ALTER TABLE `notify`
  198. ADD PRIMARY KEY (`id`);
  199.  
  200. --
  201. -- Indexes for table `sessions`
  202. --
  203. ALTER TABLE `sessions`
  204. ADD PRIMARY KEY (`session_id`);
  205.  
  206. --
  207. -- Indexes for table `test`
  208. --
  209. ALTER TABLE `test`
  210. ADD PRIMARY KEY (`id`);
  211.  
  212. --
  213. -- Indexes for table `users`
  214. --
  215. ALTER TABLE `users`
  216. ADD PRIMARY KEY (`id`),
  217. ADD UNIQUE KEY `name` (`name`),
  218. ADD UNIQUE KEY `email` (`email`);
  219.  
  220. --
  221. -- AUTO_INCREMENT for dumped tables
  222. --
  223.  
  224. --
  225. -- AUTO_INCREMENT for table `doc`
  226. --
  227. ALTER TABLE `doc`
  228. MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  229.  
  230. --
  231. -- AUTO_INCREMENT for table `test`
  232. --
  233. ALTER TABLE `test`
  234. MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
  235.  
  236. --
  237. -- AUTO_INCREMENT for table `users`
  238. --
  239. ALTER TABLE `users`
  240. MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=88;
  241. COMMIT;
  242.  
  243. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  244. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  245. /*!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!