Advertisement
Guest User

BSNL hacked Leaked Database - Laz4ru5 & Ov3rL0RD

a guest
Aug 6th, 2015
269
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.15 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 3.2.0.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Dec 15, 2011 at 04:55 PM
  7. -- Server version: 5.1.37
  8. -- PHP Version: 5.3.0
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11.  
  12.  
  13. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  14. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  15. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  16. /*!40101 SET NAMES utf8 */;
  17.  
  18. --
  19. -- Database: `rttc`
  20. --
  21.  
  22. -- --------------------------------------------------------
  23.  
  24. --
  25. -- Table structure for table `circ`
  26. --
  27.  
  28. CREATE TABLE IF NOT EXISTS `circ` (
  29. `id` int(11) NOT NULL AUTO_INCREMENT,
  30. `subject` varchar(255) NOT NULL,
  31. `filename` varchar(255) NOT NULL,
  32. `upd_by` text NOT NULL,
  33. `updated` datetime NOT NULL,
  34. `status` tinyint(4) NOT NULL DEFAULT '1',
  35. PRIMARY KEY (`id`)
  36. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
  37.  
  38. --
  39. -- Dumping data for table `circ`
  40. --
  41.  
  42. INSERT INTO `circ` (`id`, `subject`, `filename`, `upd_by`, `updated`, `status`) VALUES
  43. (1, 'test', '12107dc01353d801800837f75d66408142 and 43.xls', 'MAHESH MANGAL', '2011-12-13 15:33:25', 0),
  44. (2, 'ftyjdghjn', 'e8dd4a34cd3cb98c51196c26ce37aa27EASY GUIDE FOR NAVIGATION IN SAP CRM.doc', 'MAHESH MANGAL', '2011-12-13 16:18:09', 0),
  45. (3, 'dtyuhsrt', '90ee9c55d5a63e25f68996f752fa1173st.doc', 'MAHESH MANGAL', '2011-12-15 15:43:40', 0),
  46. (4, 'sdrf', '697fa3a71055c2948f161f070d790ea6tta.doc', 'MAHESH MANGAL', '2011-12-15 15:47:38', 0);
  47.  
  48. -- --------------------------------------------------------
  49.  
  50. --
  51. -- Table structure for table `notice`
  52. --
  53.  
  54. CREATE TABLE IF NOT EXISTS `notice` (
  55. `id` int(11) NOT NULL AUTO_INCREMENT,
  56. `name` varchar(255) NOT NULL,
  57. `notice` text NOT NULL,
  58. `status` tinyint(4) NOT NULL DEFAULT '1',
  59. `created` datetime NOT NULL,
  60. PRIMARY KEY (`id`)
  61. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
  62.  
  63. --
  64. -- Dumping data for table `notice`
  65. --
  66.  
  67. INSERT INTO `notice` (`id`, `name`, `notice`, `status`, `created`) VALUES
  68. (1, 'MAHESH MANGAL', 'Welcome to RTTC Staff Portal.\r\nKindly Provide suggestions for improvement', 1, '2011-12-09 11:40:19'),
  69. (2, 'P K SHARMA', 'you are great and we have born to win. love you dear', 0, '2011-12-09 15:38:24'),
  70. (3, 'MAHESH MANGAL', 'welcome', 0, '2011-12-12 10:53:36'),
  71. (4, 'MAHESH MANGAL', 'welcome', 0, '2011-12-12 11:30:42'),
  72. (5, 'MAHESH MANGAL', 'welcome', 0, '2011-12-13 10:46:55');
  73.  
  74. -- --------------------------------------------------------
  75.  
  76. --
  77. -- Table structure for table `staff`
  78. --
  79.  
  80. CREATE TABLE IF NOT EXISTS `staff` (
  81. `id` int(11) NOT NULL AUTO_INCREMENT,
  82. `name` varchar(30) NOT NULL,
  83. `hrno` bigint(9) NOT NULL,
  84. `desig` varchar(255) NOT NULL,
  85. `password` varchar(12) NOT NULL,
  86. `email` varchar(30) NOT NULL,
  87. `mobile` bigint(10) NOT NULL,
  88. `roomno` varchar(10) NOT NULL,
  89. `off` varchar(255) NOT NULL,
  90. `res` varchar(255) NOT NULL,
  91. `address` text NOT NULL,
  92. `dob` date NOT NULL,
  93. `updated` datetime NOT NULL,
  94. `status` tinyint(4) NOT NULL DEFAULT '1',
  95. PRIMARY KEY (`id`)
  96. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
  97.  
  98. --
  99. -- Dumping data for table `staff`
  100. --
  101.  
  102. INSERT INTO `staff` (`id`, `name`, `hrno`, `desig`, `password`, `email`, `mobile`, `roomno`, `off`, `res`, `address`, `dob`, `updated`, `status`) VALUES
  103. (1, 'MAHESH MANGAL', 200203993, 'TTA ( ERP )', 'password', 'maheshmangal78@gmail.com', 9414794001, '121-B', '0141-2460189', '0141-2460000', 'Qtr No 3/III\r\nRTTC,BSNL Campus\r\nVKIA-15\r\nJaipur', '1978-11-14', '2011-12-09 11:38:12', 1),
  104. (2, 'SANDEEP SAINI', 200305620, 'JTO', 'rttcjpjto', 'sandeep_saini@bsnl.co.in', 9414003351, '', '', '', '', '1979-05-01', '2011-12-09 14:26:45', 1),
  105. (3, 'Rajesh Nayak', 200205955, 'JTO', '200205955', 'rajesh_nayak@bsnl.co.in', 9414002291, '120B', '01412460255', '', '', '1979-02-06', '2011-12-09 14:30:29', 1),
  106. (4, 'P K SHARMA', 198703124, 'SDE', 'SONu3947', 'pks643@rediffmail.com', 9413394423, '2', '2460177', '2701248', '', '1962-02-23', '2011-12-09 15:37:00', 1),
  107. (5, 'M R JAT', 198604948, 'Sr. TOA G-3', 'mrjat', 'rttcjp@bsnl.co.in', 9462648513, '1', '0141-2460133', '0141-2420382', '6A, Vikas Nagar\r\nBypass Road \r\nDadi Ka Fatak\r\nJaipur', '1962-07-10', '2011-12-12 12:27:00', 1),
  108. (6, 'PREM SINGH GURJAR', 197604881, 'SDE', 'gurjar411', 'premsinghgurjar55@gmail.com', 9413394088, '120 A', '0141 2460838', '0141 2783517', 'H/no.69/411\r\n V.T Road\r\nMansarovar\r\nJaipur 302020', '1955-02-01', '2011-12-13 16:34:53', 1);
  109.  
  110. -- --------------------------------------------------------
  111.  
  112. --
  113. -- Table structure for table `tbl_voc_tr`
  114. --
  115.  
  116. CREATE TABLE IF NOT EXISTS `tbl_voc_tr` (
  117. `id` int(11) NOT NULL AUTO_INCREMENT,
  118. `name` text NOT NULL,
  119. `father` text NOT NULL,
  120. `edu` varchar(255) NOT NULL,
  121. `branch` text NOT NULL,
  122. `mobile` bigint(10) NOT NULL,
  123. `email` varchar(255) NOT NULL,
  124. `college` text NOT NULL,
  125. `address` text NOT NULL,
  126. `duration` int(11) NOT NULL,
  127. `dob` date NOT NULL,
  128. `reg_no` int(11) NOT NULL,
  129. `fee_amt` int(11) NOT NULL,
  130. `paid_on` date NOT NULL,
  131. `batch_no` int(11) NOT NULL,
  132. `status` tinyint(4) NOT NULL DEFAULT '1',
  133. `created` datetime NOT NULL,
  134. PRIMARY KEY (`id`)
  135. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
  136.  
  137. --
  138. -- Dumping data for table `tbl_voc_tr`
  139. --
  140.  
  141. INSERT INTO `tbl_voc_tr` (`id`, `name`, `father`, `edu`, `branch`, `mobile`, `email`, `college`, `address`, `duration`, `dob`, `reg_no`, `fee_amt`, `paid_on`, `batch_no`, `status`, `created`) VALUES
  142. (1, 'fdxth', 'sfgsdf', 'sdf', 'sdfgv', 8888888888, 'sxdfbxf', 'esargsaer', 'xzdfbvzdfb', 4, '1982-02-26', 20111001, 0, '0000-00-00', 0, 1, '2011-12-03 11:15:55'),
  143. (2, 'yukfhujgh', 'dfgthg', 'ftg', 'ghgfh', 7777777777, 'fghgfhgfh', 'fghgfhgfhbv ', 'dfgthtydethy', 6, '2011-12-11', 20111002, 3, '2012-09-28', 6, 1, '2011-12-03 20:38:28'),
  144. (3, 'qqqqqqqqqq', 'qqqqqqqq', 'qq', 'qqqq', 1111111111, 'qqqqqqqqqqqqqq', 'qqqqqqqqqq', 'qqqqqqq', 4, '2011-12-05', 20111003, 4, '2011-11-25', 6, 1, '2011-12-03 21:26:16'),
  145. (4, 'lllllllll', 'lllllllllllllll', 'kk', 'kkkkk', 5555555555, 'rrrrrrrrrrrr', 'iiiiiiiiiiiiii', 'hhhhhhhhhhh', 6, '1980-12-13', 20111004, 5, '2011-05-27', 6, 0, '2011-12-04 18:49:34'),
  146. (5, 'fsd', 'sdf', 'sdf', 'dfgsdfg', 4444444444, 'dddddddddd', 'sdf', 'dddddddddd', 2, '1990-11-14', 20111005, 4, '2012-11-26', 4, 1, '2011-12-04 18:52:44'),
  147. (6, 'xfgh', 'zdfgzd', 'dfgzhdfg', 'zdfgzd', 6666666666, 'dfgzdfg', 'fghfgh', 'zdfgzdfgzdfgds', 6, '1984-03-25', 20111006, 0, '0000-00-00', 0, 0, '2011-12-09 10:46:42'),
  148. (7, 'New ', 'Father', 'BE', 'ECE', 9856321474, 'email@email.com', 'College', 'Address\r\nline 1\r\nline2\r\nline3', 2, '1997-03-26', 20111007, 2, '2011-01-01', 0, 1, '2011-12-15 15:05:51');
  149.  
  150. -- --------------------------------------------------------
  151.  
  152. --
  153. -- Table structure for table `time_table`
  154. --
  155.  
  156. CREATE TABLE IF NOT EXISTS `time_table` (
  157. `id` int(11) NOT NULL AUTO_INCREMENT,
  158. `b_name` varchar(255) NOT NULL,
  159. `b_no` int(11) NOT NULL,
  160. `wef` date NOT NULL,
  161. `duration` int(11) NOT NULL,
  162. `upd_by` text NOT NULL,
  163. `ci` varchar(255) NOT NULL,
  164. `filename` varchar(255) NOT NULL,
  165. `status` tinyint(4) NOT NULL DEFAULT '1',
  166. `updated` datetime NOT NULL,
  167. PRIMARY KEY (`id`)
  168. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
  169.  
  170. --
  171. -- Dumping data for table `time_table`
  172. --
  173.  
  174. INSERT INTO `time_table` (`id`, `b_name`, `b_no`, `wef`, `duration`, `upd_by`, `ci`, `filename`, `status`, `updated`) VALUES
  175. (1, 'TTA Induction', 43, '2011-12-12', 5, 'MAHESH MANGAL', 'SANDEEP SAINI', '801af7871c2f32593f8cb75596565febtta.doc', 0, '2011-12-15 14:22:39'),
  176. (2, 'Summer Training', 12, '2011-12-12', 5, 'MAHESH MANGAL', 'PREM SINGH GURJAR', 'c6dc1ffe2e9186de68c41686dca50859st.doc', 0, '2011-12-15 14:23:15'),
  177. (3, 'Corporate Practice', 1, '2011-12-12', 2, 'MAHESH MANGAL', 'P K SHARMA', '3a78f7cef6a6aa80cf7bec64444b3b20cp.doc', 0, '2011-12-15 14:24:00'),
  178. (4, 'TTA Induction', 43, '2011-12-12', 5, 'MAHESH MANGAL', 'SANDEEP SAINI', '330ad48175230cc687f9a6ccc74a8421tta.doc', 1, '2011-12-15 15:51:45');
  179.  
  180. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  181. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  182. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement