· 11 years ago · Aug 06, 2015, 10:46 AM
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
10SET 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
28CREATE 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
42INSERT 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
54CREATE 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
67INSERT 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
80CREATE 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
102INSERT 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
116CREATE 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
141INSERT 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
156CREATE 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
174INSERT 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 */;