Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 3.2.0.1
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Dec 15, 2011 at 04:55 PM
- -- Server version: 5.1.37
- -- PHP Version: 5.3.0
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- --
- -- Database: `rttc`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `circ`
- --
- CREATE TABLE IF NOT EXISTS `circ` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `subject` varchar(255) NOT NULL,
- `filename` varchar(255) NOT NULL,
- `upd_by` text NOT NULL,
- `updated` datetime NOT NULL,
- `status` tinyint(4) NOT NULL DEFAULT '1',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
- --
- -- Dumping data for table `circ`
- --
- INSERT INTO `circ` (`id`, `subject`, `filename`, `upd_by`, `updated`, `status`) VALUES
- (1, 'test', '12107dc01353d801800837f75d66408142 and 43.xls', 'MAHESH MANGAL', '2011-12-13 15:33:25', 0),
- (2, 'ftyjdghjn', 'e8dd4a34cd3cb98c51196c26ce37aa27EASY GUIDE FOR NAVIGATION IN SAP CRM.doc', 'MAHESH MANGAL', '2011-12-13 16:18:09', 0),
- (3, 'dtyuhsrt', '90ee9c55d5a63e25f68996f752fa1173st.doc', 'MAHESH MANGAL', '2011-12-15 15:43:40', 0),
- (4, 'sdrf', '697fa3a71055c2948f161f070d790ea6tta.doc', 'MAHESH MANGAL', '2011-12-15 15:47:38', 0);
- -- --------------------------------------------------------
- --
- -- Table structure for table `notice`
- --
- CREATE TABLE IF NOT EXISTS `notice` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(255) NOT NULL,
- `notice` text NOT NULL,
- `status` tinyint(4) NOT NULL DEFAULT '1',
- `created` datetime NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
- --
- -- Dumping data for table `notice`
- --
- INSERT INTO `notice` (`id`, `name`, `notice`, `status`, `created`) VALUES
- (1, 'MAHESH MANGAL', 'Welcome to RTTC Staff Portal.\r\nKindly Provide suggestions for improvement', 1, '2011-12-09 11:40:19'),
- (2, 'P K SHARMA', 'you are great and we have born to win. love you dear', 0, '2011-12-09 15:38:24'),
- (3, 'MAHESH MANGAL', 'welcome', 0, '2011-12-12 10:53:36'),
- (4, 'MAHESH MANGAL', 'welcome', 0, '2011-12-12 11:30:42'),
- (5, 'MAHESH MANGAL', 'welcome', 0, '2011-12-13 10:46:55');
- -- --------------------------------------------------------
- --
- -- Table structure for table `staff`
- --
- CREATE TABLE IF NOT EXISTS `staff` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(30) NOT NULL,
- `hrno` bigint(9) NOT NULL,
- `desig` varchar(255) NOT NULL,
- `password` varchar(12) NOT NULL,
- `email` varchar(30) NOT NULL,
- `mobile` bigint(10) NOT NULL,
- `roomno` varchar(10) NOT NULL,
- `off` varchar(255) NOT NULL,
- `res` varchar(255) NOT NULL,
- `address` text NOT NULL,
- `dob` date NOT NULL,
- `updated` datetime NOT NULL,
- `status` tinyint(4) NOT NULL DEFAULT '1',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
- --
- -- Dumping data for table `staff`
- --
- INSERT INTO `staff` (`id`, `name`, `hrno`, `desig`, `password`, `email`, `mobile`, `roomno`, `off`, `res`, `address`, `dob`, `updated`, `status`) VALUES
- (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),
- (2, 'SANDEEP SAINI', 200305620, 'JTO', 'rttcjpjto', 'sandeep_saini@bsnl.co.in', 9414003351, '', '', '', '', '1979-05-01', '2011-12-09 14:26:45', 1),
- (3, 'Rajesh Nayak', 200205955, 'JTO', '200205955', 'rajesh_nayak@bsnl.co.in', 9414002291, '120B', '01412460255', '', '', '1979-02-06', '2011-12-09 14:30:29', 1),
- (4, 'P K SHARMA', 198703124, 'SDE', 'SONu3947', 'pks643@rediffmail.com', 9413394423, '2', '2460177', '2701248', '', '1962-02-23', '2011-12-09 15:37:00', 1),
- (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),
- (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);
- -- --------------------------------------------------------
- --
- -- Table structure for table `tbl_voc_tr`
- --
- CREATE TABLE IF NOT EXISTS `tbl_voc_tr` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` text NOT NULL,
- `father` text NOT NULL,
- `edu` varchar(255) NOT NULL,
- `branch` text NOT NULL,
- `mobile` bigint(10) NOT NULL,
- `email` varchar(255) NOT NULL,
- `college` text NOT NULL,
- `address` text NOT NULL,
- `duration` int(11) NOT NULL,
- `dob` date NOT NULL,
- `reg_no` int(11) NOT NULL,
- `fee_amt` int(11) NOT NULL,
- `paid_on` date NOT NULL,
- `batch_no` int(11) NOT NULL,
- `status` tinyint(4) NOT NULL DEFAULT '1',
- `created` datetime NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
- --
- -- Dumping data for table `tbl_voc_tr`
- --
- 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
- (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'),
- (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'),
- (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'),
- (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'),
- (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'),
- (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'),
- (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');
- -- --------------------------------------------------------
- --
- -- Table structure for table `time_table`
- --
- CREATE TABLE IF NOT EXISTS `time_table` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `b_name` varchar(255) NOT NULL,
- `b_no` int(11) NOT NULL,
- `wef` date NOT NULL,
- `duration` int(11) NOT NULL,
- `upd_by` text NOT NULL,
- `ci` varchar(255) NOT NULL,
- `filename` varchar(255) NOT NULL,
- `status` tinyint(4) NOT NULL DEFAULT '1',
- `updated` datetime NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
- --
- -- Dumping data for table `time_table`
- --
- INSERT INTO `time_table` (`id`, `b_name`, `b_no`, `wef`, `duration`, `upd_by`, `ci`, `filename`, `status`, `updated`) VALUES
- (1, 'TTA Induction', 43, '2011-12-12', 5, 'MAHESH MANGAL', 'SANDEEP SAINI', '801af7871c2f32593f8cb75596565febtta.doc', 0, '2011-12-15 14:22:39'),
- (2, 'Summer Training', 12, '2011-12-12', 5, 'MAHESH MANGAL', 'PREM SINGH GURJAR', 'c6dc1ffe2e9186de68c41686dca50859st.doc', 0, '2011-12-15 14:23:15'),
- (3, 'Corporate Practice', 1, '2011-12-12', 2, 'MAHESH MANGAL', 'P K SHARMA', '3a78f7cef6a6aa80cf7bec64444b3b20cp.doc', 0, '2011-12-15 14:24:00'),
- (4, 'TTA Induction', 43, '2011-12-12', 5, 'MAHESH MANGAL', 'SANDEEP SAINI', '330ad48175230cc687f9a6ccc74a8421tta.doc', 1, '2011-12-15 15:51:45');
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement