· 7 years ago · Sep 30, 2018, 11:38 AM
1-- phpMyAdmin SQL Dump
2-- version 3.2.4
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Apr 17, 2017 at 06:03 PM
7-- Server version: 5.1.41
8-- PHP Version: 5.3.1
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: `collegetimetable`
20--
21CREATE DATABASE `collegetimetable` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
22USE `collegetimetable`;
23
24-- --------------------------------------------------------
25
26--
27-- Table structure for table `admindetails`
28--
29
30CREATE TABLE IF NOT EXISTS `admindetails` (
31 `AdminId` int(11) NOT NULL AUTO_INCREMENT,
32 `Username` varchar(250) NOT NULL,
33 `Password` varchar(250) NOT NULL,
34 PRIMARY KEY (`AdminId`)
35) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3001 ;
36
37--
38-- Dumping data for table `admindetails`
39--
40
41INSERT INTO `admindetails` (`AdminId`, `Username`, `Password`) VALUES
42(3000, 'admin', 'admin');
43
44-- --------------------------------------------------------
45
46--
47-- Table structure for table `grade`
48--
49
50CREATE TABLE IF NOT EXISTS `grade` (
51 `gradeid` int(11) NOT NULL AUTO_INCREMENT,
52 `gradename` varchar(250) NOT NULL,
53 PRIMARY KEY (`gradeid`)
54) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
55
56--
57-- Dumping data for table `grade`
58--
59
60INSERT INTO `grade` (`gradeid`, `gradename`) VALUES
61(1, 'ECE'),
62(2, 'CSE'),
63(3, 'MECH'),
64(4, 'CIVIL'),
65(5, 'E&I');
66
67-- --------------------------------------------------------
68
69--
70-- Table structure for table `sections`
71--
72
73CREATE TABLE IF NOT EXISTS `sections` (
74 `sectionid` int(11) NOT NULL AUTO_INCREMENT,
75 `sectionsname` varchar(250) NOT NULL,
76 PRIMARY KEY (`sectionid`)
77) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
78
79--
80-- Dumping data for table `sections`
81--
82
83INSERT INTO `sections` (`sectionid`, `sectionsname`) VALUES
84(1, 'W'),
85(2, 'I'),
86(3, 'S'),
87(4, 'N'),
88(5, 'Q');
89
90-- --------------------------------------------------------
91
92--
93-- Table structure for table `subject`
94--
95
96CREATE TABLE IF NOT EXISTS `subject` (
97 `subjectid` int(11) NOT NULL AUTO_INCREMENT,
98 `subjectname` varchar(250) NOT NULL,
99 PRIMARY KEY (`subjectid`)
100) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
101
102--
103-- Dumping data for table `subject`
104--
105
106INSERT INTO `subject` (`subjectid`, `subjectname`) VALUES
107(1, 'Literature'),
108(2, 'Language'),
109(3, 'Maths'),
110(4, 'Science'),
111(5, 'Social Studies'),
112(6, 'Humanities'),
113(7, 'Arabic'),
114(8, 'Islamic'),
115(9, 'ICT'),
116(10, 'Art'),
117(11, 'PE'),
118(12, 'English');
119
120-- --------------------------------------------------------
121
122--
123-- Table structure for table `subject_grade`
124--
125
126CREATE TABLE IF NOT EXISTS `subject_grade` (
127 `subject_gradeid` int(11) NOT NULL AUTO_INCREMENT,
128 `subjectid` int(11) NOT NULL,
129 `gradeid` int(11) NOT NULL,
130 `NoOfClasses` int(11) NOT NULL,
131 PRIMARY KEY (`subject_gradeid`),
132 KEY `subjectid` (`subjectid`),
133 KEY `gradeid` (`gradeid`)
134) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=144 ;
135
136--
137-- Dumping data for table `subject_grade`
138--
139
140INSERT INTO `subject_grade` (`subject_gradeid`, `subjectid`, `gradeid`, `NoOfClasses`) VALUES
141(1, 3, 1, 8),
142(2, 4, 1, 3),
143(3, 12, 1, 8),
144(4, 5, 1, 3),
145(5, 7, 1, 2),
146(6, 8, 1, 2),
147(7, 9, 1, 3),
148(8, 10, 1, 3),
149(9, 11, 1, 3),
150(10, 3, 2, 8),
151(11, 12, 2, 8),
152(12, 4, 2, 3),
153(13, 5, 2, 3),
154(14, 7, 2, 2),
155(15, 8, 2, 2),
156(16, 9, 2, 3),
157(17, 10, 2, 3),
158(18, 11, 2, 3),
159(28, 3, 3, 8),
160(29, 12, 3, 8),
161(30, 4, 3, 4),
162(31, 5, 3, 4),
163(32, 7, 3, 4),
164(33, 8, 3, 3),
165(34, 9, 3, 1),
166(35, 10, 3, 2),
167(36, 11, 3, 1),
168(37, 3, 4, 8),
169(38, 12, 4, 8),
170(39, 4, 4, 4),
171(40, 5, 4, 4),
172(41, 7, 4, 4),
173(42, 8, 4, 3),
174(43, 9, 4, 1),
175(44, 10, 4, 2),
176(45, 11, 4, 1),
177(64, 3, 5, 7),
178(65, 12, 5, 6),
179(66, 1, 5, 4),
180(67, 4, 5, 4),
181(68, 5, 5, 4),
182(69, 7, 5, 4),
183(70, 8, 5, 3),
184(71, 9, 5, 1),
185(72, 10, 5, 1),
186(73, 11, 5, 1);
187
188-- --------------------------------------------------------
189
190--
191-- Table structure for table `teacher_grades`
192--
193
194CREATE TABLE IF NOT EXISTS `teacher_grades` (
195 `teacher_grades_id` int(11) NOT NULL AUTO_INCREMENT,
196 `teacherid` int(11) NOT NULL,
197 `gradeid` int(11) NOT NULL,
198 PRIMARY KEY (`teacher_grades_id`),
199 KEY `teacherid` (`teacherid`),
200 KEY `gradeid` (`gradeid`)
201) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ;
202
203--
204-- Dumping data for table `teacher_grades`
205--
206
207INSERT INTO `teacher_grades` (`teacher_grades_id`, `teacherid`, `gradeid`) VALUES
208(11, 2, 1),
209(12, 2, 3),
210(37, 15, 1),
211(38, 15, 2),
212(43, 17, 1),
213(44, 17, 2);
214
215-- --------------------------------------------------------
216
217--
218-- Table structure for table `teacher_sections`
219--
220
221CREATE TABLE IF NOT EXISTS `teacher_sections` (
222 `teacher_sections_id` int(11) NOT NULL AUTO_INCREMENT,
223 `teacherid` int(11) NOT NULL,
224 `sectionid` int(11) NOT NULL,
225 PRIMARY KEY (`teacher_sections_id`),
226 KEY `teacherid` (`teacherid`),
227 KEY `sectionid` (`sectionid`)
228) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;
229
230--
231-- Dumping data for table `teacher_sections`
232--
233
234INSERT INTO `teacher_sections` (`teacher_sections_id`, `teacherid`, `sectionid`) VALUES
235(11, 2, 1),
236(12, 2, 3),
237(34, 15, 1),
238(35, 15, 2),
239(36, 16, 1),
240(37, 16, 2),
241(38, 16, 3),
242(40, 17, 1),
243(41, 17, 3);
244
245-- --------------------------------------------------------
246
247--
248-- Table structure for table `teacher_subjects`
249--
250
251CREATE TABLE IF NOT EXISTS `teacher_subjects` (
252 `teacher_subjects_id` int(11) NOT NULL AUTO_INCREMENT,
253 `teacherid` int(11) NOT NULL,
254 `subjectid` int(11) NOT NULL,
255 PRIMARY KEY (`teacher_subjects_id`),
256 KEY `teacherid` (`teacherid`),
257 KEY `subjectid` (`subjectid`)
258) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;
259
260--
261-- Dumping data for table `teacher_subjects`
262--
263
264INSERT INTO `teacher_subjects` (`teacher_subjects_id`, `teacherid`, `subjectid`) VALUES
265(11, 2, 8),
266(12, 2, 9),
267(35, 15, 10),
268(36, 15, 11),
269(37, 16, 9),
270(38, 16, 10),
271(39, 16, 11),
272(41, 17, 1),
273(42, 17, 2);
274
275-- --------------------------------------------------------
276
277--
278-- Table structure for table `teacherinfo`
279--
280
281CREATE TABLE IF NOT EXISTS `teacherinfo` (
282 `teacherid` int(11) NOT NULL AUTO_INCREMENT,
283 `FullName` varchar(250) NOT NULL,
284 `Age` int(11) NOT NULL,
285 `Nationality` varchar(250) NOT NULL,
286 `ContactNo` bigint(20) NOT NULL,
287 `Address` varchar(250) NOT NULL,
288 `PassportNo` varchar(250) NOT NULL,
289 `PassportExpiryDate` date NOT NULL,
290 `VisaType` varchar(250) NOT NULL,
291 `SchoolAccommodation` varchar(250) NOT NULL,
292 `Tutor` varchar(250) NOT NULL,
293 `Grade` varchar(250) NOT NULL,
294 `RecordedDate` date NOT NULL,
295 PRIMARY KEY (`teacherid`)
296) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
297
298--
299-- Dumping data for table `teacherinfo`
300--
301
302INSERT INTO `teacherinfo` (`teacherid`, `FullName`, `Age`, `Nationality`, `ContactNo`, `Address`, `PassportNo`, `PassportExpiryDate`, `VisaType`, `SchoolAccommodation`, `Tutor`, `Grade`, `RecordedDate`) VALUES
303(2, 'Kalam', 87, 'Indian', 9043963074, 'chennai', '1233', '2015-08-06', 'H1B', 'on', 'on', 'A', '2015-08-06'),
304(15, 'kiruba', 87, 'Indian', 9043963074, 'chennai', '1233', '2015-08-09', 'H1B', 'on', 'on', 'A', '2015-08-12'),
305(16, 'Tamil', 87, 'Indian', 9043963074, 'dde', '1233', '2015-08-09', 'H1B', 'on', 'on', 'A', '2015-08-18'),
306(17, 'kiruba karan', 23, 'India', 9043963074, 'south sivan kovil street', '1222', '2016-09-12', 'HIB', 'Yes', 'y', 'Grade 1', '2016-03-30');
307
308-- --------------------------------------------------------
309
310--
311-- Table structure for table `timetable_i`
312--
313
314CREATE TABLE IF NOT EXISTS `timetable_i` (
315 `sno` int(11) NOT NULL AUTO_INCREMENT,
316 `Day` varchar(250) NOT NULL,
317 `8_9` int(11) NOT NULL,
318 `9_10` int(11) NOT NULL,
319 `10_11` int(11) NOT NULL,
320 `11_12` int(11) NOT NULL,
321 `1_2` int(11) NOT NULL,
322 `2_3` int(11) NOT NULL,
323 `3_4` int(11) NOT NULL,
324 `Grade` int(11) NOT NULL,
325 PRIMARY KEY (`sno`),
326 KEY `8_9` (`8_9`),
327 KEY `9_10` (`9_10`),
328 KEY `10_11` (`10_11`),
329 KEY `11_12` (`11_12`),
330 KEY `1_2` (`1_2`),
331 KEY `2_3` (`2_3`),
332 KEY `3_4` (`3_4`),
333 KEY `Grade` (`Grade`)
334) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;
335
336--
337-- Dumping data for table `timetable_i`
338--
339
340INSERT INTO `timetable_i` (`sno`, `Day`, `8_9`, `9_10`, `10_11`, `11_12`, `1_2`, `2_3`, `3_4`, `Grade`) VALUES
341(26, 'Monday', 12, 9, 10, 8, 12, 12, 5, 1),
342(27, 'Tueday', 12, 12, 3, 12, 11, 3, 4, 1),
343(28, 'Wednesday', 8, 3, 3, 3, 4, 5, 10, 1),
344(29, 'Thursday', 7, 12, 4, 5, 11, 3, 11, 1),
345(30, 'Friday', 3, 9, 12, 10, 7, 9, 3, 1),
346(31, 'Monday', 3, 12, 3, 3, 12, 5, 3, 2),
347(32, 'Tueday', 5, 4, 3, 12, 10, 5, 11, 2),
348(33, 'Wednesday', 12, 8, 7, 12, 3, 4, 12, 2),
349(34, 'Thursday', 11, 8, 7, 10, 3, 4, 3, 2),
350(35, 'Friday', 9, 9, 11, 12, 10, 12, 9, 2),
351(36, 'Monday', 8, 8, 7, 5, 5, 12, 3, 3),
352(37, 'Tueday', 3, 12, 12, 4, 3, 5, 4, 3),
353(38, 'Wednesday', 10, 12, 7, 3, 3, 11, 12, 3),
354(39, 'Thursday', 4, 3, 12, 9, 10, 4, 3, 3),
355(40, 'Friday', 8, 7, 3, 12, 5, 7, 12, 3),
356(41, 'Monday', 3, 4, 12, 11, 10, 3, 8, 4),
357(42, 'Tueday', 3, 7, 7, 12, 3, 12, 8, 4),
358(43, 'Wednesday', 10, 5, 5, 12, 5, 12, 7, 4),
359(44, 'Thursday', 12, 12, 9, 4, 8, 4, 3, 4),
360(45, 'Friday', 3, 4, 3, 3, 5, 12, 7, 4),
361(46, 'Monday', 4, 4, 5, 3, 9, 3, 3, 5),
362(47, 'Tueday', 12, 3, 7, 4, 8, 11, 7, 5),
363(48, 'Wednesday', 12, 3, 3, 12, 5, 7, 8, 5),
364(49, 'Thursday', 5, 12, 7, 10, 3, 12, 1, 5),
365(50, 'Friday', 1, 5, 4, 1, 8, 1, 12, 5);
366
367-- --------------------------------------------------------
368
369--
370-- Table structure for table `timetable_kalam`
371--
372
373CREATE TABLE IF NOT EXISTS `timetable_kalam` (
374 `sno` int(11) NOT NULL AUTO_INCREMENT,
375 `Day` varchar(250) NOT NULL,
376 `8_9` int(11) NOT NULL,
377 `9_10` int(11) NOT NULL,
378 `10_11` int(11) NOT NULL,
379 `11_12` int(11) NOT NULL,
380 `1_2` int(11) NOT NULL,
381 `2_3` int(11) NOT NULL,
382 `3_4` int(11) NOT NULL,
383 `gradeid` int(11) NOT NULL,
384 `sectionid` int(11) NOT NULL,
385 PRIMARY KEY (`sno`),
386 KEY `8_9` (`8_9`),
387 KEY `9_10` (`9_10`),
388 KEY `10_11` (`10_11`),
389 KEY `11_12` (`11_12`),
390 KEY `1_2` (`1_2`),
391 KEY `2_3` (`2_3`),
392 KEY `3_4` (`3_4`),
393 KEY `gradeid` (`gradeid`),
394 KEY `sectionid` (`sectionid`)
395) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
396
397--
398-- Dumping data for table `timetable_kalam`
399--
400
401INSERT INTO `timetable_kalam` (`sno`, `Day`, `8_9`, `9_10`, `10_11`, `11_12`, `1_2`, `2_3`, `3_4`, `gradeid`, `sectionid`) VALUES
402(1, 'Sunday', 9, 0, 0, 0, 0, 0, 0, 1, 1),
403(2, 'Monday', 0, 0, 0, 0, 0, 0, 0, 1, 1),
404(3, 'Tueday', 0, 0, 0, 0, 8, 9, 0, 1, 1),
405(4, 'Wednesday', 0, 0, 0, 0, 0, 9, 0, 1, 1),
406(5, 'Thursday', 0, 0, 0, 0, 0, 8, 0, 1, 1),
407(6, 'Sunday', 9, 0, 0, 0, 0, 0, 0, 1, 3),
408(7, 'Monday', 0, 0, 0, 0, 0, 0, 0, 1, 3),
409(8, 'Tueday', 0, 0, 0, 0, 8, 9, 0, 1, 3),
410(9, 'Wednesday', 0, 0, 0, 0, 0, 9, 0, 1, 3),
411(10, 'Thursday', 0, 0, 0, 0, 0, 8, 0, 1, 3),
412(11, 'Sunday', 0, 0, 0, 0, 8, 8, 0, 3, 1),
413(12, 'Monday', 8, 0, 0, 0, 0, 0, 0, 3, 1),
414(13, 'Tueday', 0, 0, 0, 9, 0, 0, 0, 3, 1),
415(14, 'Wednesday', 0, 0, 0, 0, 0, 0, 0, 3, 1),
416(15, 'Thursday', 0, 0, 0, 0, 0, 0, 0, 3, 1),
417(16, 'Sunday', 0, 0, 0, 0, 8, 8, 0, 3, 3),
418(17, 'Monday', 8, 0, 0, 0, 0, 0, 0, 3, 3),
419(18, 'Tueday', 0, 0, 0, 9, 0, 0, 0, 3, 3),
420(19, 'Wednesday', 0, 0, 0, 0, 0, 0, 0, 3, 3),
421(20, 'Thursday', 0, 0, 0, 0, 0, 0, 0, 3, 3);
422
423-- --------------------------------------------------------
424
425--
426-- Table structure for table `timetable_kiruba`
427--
428
429CREATE TABLE IF NOT EXISTS `timetable_kiruba` (
430 `sno` int(11) NOT NULL AUTO_INCREMENT,
431 `Day` varchar(250) NOT NULL,
432 `8_9` int(11) NOT NULL,
433 `9_10` int(11) NOT NULL,
434 `10_11` int(11) NOT NULL,
435 `11_12` int(11) NOT NULL,
436 `1_2` int(11) NOT NULL,
437 `2_3` int(11) NOT NULL,
438 `3_4` int(11) NOT NULL,
439 `gradeid` int(11) NOT NULL,
440 `sectionid` int(11) NOT NULL,
441 PRIMARY KEY (`sno`),
442 KEY `8_9` (`8_9`),
443 KEY `9_10` (`9_10`),
444 KEY `10_11` (`10_11`),
445 KEY `11_12` (`11_12`),
446 KEY `1_2` (`1_2`),
447 KEY `2_3` (`2_3`),
448 KEY `3_4` (`3_4`),
449 KEY `gradeid` (`gradeid`),
450 KEY `sectionid` (`sectionid`)
451) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
452
453--
454-- Dumping data for table `timetable_kiruba`
455--
456
457INSERT INTO `timetable_kiruba` (`sno`, `Day`, `8_9`, `9_10`, `10_11`, `11_12`, `1_2`, `2_3`, `3_4`, `gradeid`, `sectionid`) VALUES
458(1, 'Sunday', 0, 0, 0, 0, 0, 10, 0, 1, 1),
459(2, 'Monday', 0, 0, 10, 0, 0, 0, 0, 1, 1),
460(3, 'Tueday', 0, 0, 11, 0, 0, 0, 0, 1, 1),
461(4, 'Wednesday', 0, 11, 0, 11, 0, 0, 0, 1, 1),
462(5, 'Thursday', 0, 10, 0, 0, 0, 0, 0, 1, 1),
463(6, 'Sunday', 0, 0, 0, 0, 0, 10, 0, 1, 2),
464(7, 'Monday', 0, 0, 10, 0, 0, 0, 0, 1, 2),
465(8, 'Tueday', 0, 0, 11, 0, 0, 0, 0, 1, 2),
466(9, 'Wednesday', 0, 11, 0, 11, 0, 0, 0, 1, 2),
467(10, 'Thursday', 0, 10, 0, 0, 0, 0, 0, 1, 2),
468(11, 'Sunday', 0, 10, 0, 0, 0, 0, 0, 2, 1),
469(12, 'Monday', 0, 0, 0, 0, 0, 0, 0, 2, 1),
470(13, 'Tueday', 0, 0, 11, 10, 0, 0, 0, 2, 1),
471(14, 'Wednesday', 0, 0, 0, 10, 0, 11, 0, 2, 1),
472(15, 'Thursday', 0, 0, 0, 0, 0, 0, 11, 2, 1),
473(16, 'Sunday', 0, 10, 0, 0, 0, 0, 0, 2, 2),
474(17, 'Monday', 0, 0, 0, 0, 0, 0, 0, 2, 2),
475(18, 'Tueday', 0, 0, 11, 10, 0, 0, 0, 2, 2),
476(19, 'Wednesday', 0, 0, 0, 10, 0, 11, 0, 2, 2),
477(20, 'Thursday', 0, 0, 0, 0, 0, 0, 11, 2, 2);
478
479-- --------------------------------------------------------
480
481--
482-- Table structure for table `timetable_n`
483--
484
485CREATE TABLE IF NOT EXISTS `timetable_n` (
486 `sno` int(11) NOT NULL AUTO_INCREMENT,
487 `Day` varchar(250) NOT NULL,
488 `8_9` int(11) NOT NULL,
489 `9_10` int(11) NOT NULL,
490 `10_11` int(11) NOT NULL,
491 `11_12` int(11) NOT NULL,
492 `1_2` int(11) NOT NULL,
493 `2_3` int(11) NOT NULL,
494 `3_4` int(11) NOT NULL,
495 `Grade` int(11) NOT NULL,
496 PRIMARY KEY (`sno`),
497 KEY `8_9` (`8_9`),
498 KEY `9_10` (`9_10`),
499 KEY `10_11` (`10_11`),
500 KEY `11_12` (`11_12`),
501 KEY `1_2` (`1_2`),
502 KEY `2_3` (`2_3`),
503 KEY `3_4` (`3_4`),
504 KEY `Grade` (`Grade`)
505) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;
506
507--
508-- Dumping data for table `timetable_n`
509--
510
511INSERT INTO `timetable_n` (`sno`, `Day`, `8_9`, `9_10`, `10_11`, `11_12`, `1_2`, `2_3`, `3_4`, `Grade`) VALUES
512(26, 'Monday', 9, 10, 4, 8, 3, 11, 9, 1),
513(27, 'Tueday', 12, 12, 7, 3, 3, 12, 4, 1),
514(28, 'Wednesday', 12, 11, 4, 12, 7, 3, 8, 1),
515(29, 'Thursday', 12, 3, 3, 11, 5, 12, 5, 1),
516(30, 'Friday', 12, 9, 5, 10, 3, 3, 10, 1),
517(31, 'Monday', 10, 3, 5, 4, 11, 11, 8, 2),
518(32, 'Tueday', 12, 3, 4, 5, 9, 12, 3, 2),
519(33, 'Wednesday', 10, 11, 9, 12, 8, 3, 3, 2),
520(34, 'Thursday', 4, 10, 3, 5, 12, 3, 7, 2),
521(35, 'Friday', 9, 7, 12, 12, 12, 12, 3, 2),
522(36, 'Monday', 8, 12, 12, 4, 3, 3, 3, 3),
523(37, 'Tueday', 8, 12, 5, 12, 4, 5, 7, 3),
524(38, 'Wednesday', 4, 7, 12, 9, 12, 12, 3, 3),
525(39, 'Thursday', 3, 11, 10, 3, 4, 12, 3, 3),
526(40, 'Friday', 10, 7, 3, 7, 5, 8, 5, 3),
527(41, 'Monday', 3, 9, 12, 5, 3, 7, 7, 4),
528(42, 'Tueday', 4, 7, 12, 11, 12, 3, 5, 4),
529(43, 'Wednesday', 7, 12, 8, 12, 4, 3, 10, 4),
530(44, 'Thursday', 3, 5, 10, 3, 3, 12, 12, 4),
531(45, 'Friday', 4, 12, 8, 8, 5, 4, 3, 4),
532(46, 'Monday', 4, 1, 1, 8, 7, 4, 10, 5),
533(47, 'Tueday', 3, 9, 4, 7, 3, 3, 7, 5),
534(48, 'Wednesday', 5, 3, 3, 5, 1, 1, 12, 5),
535(49, 'Thursday', 5, 11, 12, 12, 8, 5, 12, 5),
536(50, 'Friday', 8, 12, 3, 7, 4, 3, 12, 5);
537
538-- --------------------------------------------------------
539
540--
541-- Table structure for table `timetable_q`
542--
543
544CREATE TABLE IF NOT EXISTS `timetable_q` (
545 `sno` int(11) NOT NULL AUTO_INCREMENT,
546 `Day` varchar(250) NOT NULL,
547 `8_9` int(11) NOT NULL,
548 `9_10` int(11) NOT NULL,
549 `10_11` int(11) NOT NULL,
550 `11_12` int(11) NOT NULL,
551 `1_2` int(11) NOT NULL,
552 `2_3` int(11) NOT NULL,
553 `3_4` int(11) NOT NULL,
554 `Grade` int(11) NOT NULL,
555 PRIMARY KEY (`sno`),
556 KEY `8_9` (`8_9`),
557 KEY `9_10` (`9_10`),
558 KEY `10_11` (`10_11`),
559 KEY `11_12` (`11_12`),
560 KEY `1_2` (`1_2`),
561 KEY `2_3` (`2_3`),
562 KEY `3_4` (`3_4`),
563 KEY `Grade` (`Grade`)
564) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;
565
566--
567-- Dumping data for table `timetable_q`
568--
569
570INSERT INTO `timetable_q` (`sno`, `Day`, `8_9`, `9_10`, `10_11`, `11_12`, `1_2`, `2_3`, `3_4`, `Grade`) VALUES
571(26, 'Monday', 5, 10, 7, 11, 3, 3, 10, 1),
572(27, 'Tueday', 12, 8, 3, 12, 12, 12, 9, 1),
573(28, 'Wednesday', 3, 4, 11, 9, 12, 3, 12, 1),
574(29, 'Thursday', 12, 8, 9, 5, 12, 3, 3, 1),
575(30, 'Friday', 7, 10, 3, 4, 11, 4, 5, 1),
576(31, 'Monday', 3, 9, 8, 7, 12, 3, 10, 2),
577(32, 'Tueday', 12, 11, 4, 3, 5, 12, 10, 2),
578(33, 'Wednesday', 10, 12, 3, 3, 5, 9, 4, 2),
579(34, 'Thursday', 12, 12, 8, 11, 3, 12, 3, 2),
580(35, 'Friday', 9, 12, 4, 7, 5, 3, 11, 2),
581(36, 'Monday', 8, 4, 7, 12, 5, 10, 5, 3),
582(37, 'Tueday', 3, 7, 3, 4, 12, 12, 3, 3),
583(38, 'Wednesday', 11, 7, 3, 12, 4, 8, 8, 3),
584(39, 'Thursday', 3, 3, 12, 9, 12, 4, 7, 3),
585(40, 'Friday', 5, 12, 10, 3, 12, 5, 3, 3),
586(41, 'Monday', 7, 12, 3, 12, 3, 8, 5, 4),
587(42, 'Tueday', 3, 12, 4, 5, 4, 12, 10, 4),
588(43, 'Wednesday', 12, 12, 7, 5, 7, 11, 10, 4),
589(44, 'Thursday', 3, 3, 9, 5, 8, 4, 8, 4),
590(45, 'Friday', 7, 3, 4, 12, 3, 12, 3, 4),
591(46, 'Monday', 3, 5, 5, 3, 11, 12, 8, 5),
592(47, 'Tueday', 7, 7, 7, 1, 9, 3, 4, 5),
593(48, 'Wednesday', 12, 1, 8, 3, 4, 7, 1, 5),
594(49, 'Thursday', 12, 3, 5, 10, 12, 3, 12, 5),
595(50, 'Friday', 3, 4, 8, 5, 4, 1, 12, 5);
596
597-- --------------------------------------------------------
598
599--
600-- Table structure for table `timetable_s`
601--
602
603CREATE TABLE IF NOT EXISTS `timetable_s` (
604 `sno` int(11) NOT NULL AUTO_INCREMENT,
605 `Day` varchar(250) NOT NULL,
606 `8_9` int(11) NOT NULL,
607 `9_10` int(11) NOT NULL,
608 `10_11` int(11) NOT NULL,
609 `11_12` int(11) NOT NULL,
610 `1_2` int(11) NOT NULL,
611 `2_3` int(11) NOT NULL,
612 `3_4` int(11) NOT NULL,
613 `Grade` int(11) NOT NULL,
614 PRIMARY KEY (`sno`),
615 KEY `8_9` (`8_9`),
616 KEY `9_10` (`9_10`),
617 KEY `10_11` (`10_11`),
618 KEY `11_12` (`11_12`),
619 KEY `1_2` (`1_2`),
620 KEY `2_3` (`2_3`),
621 KEY `3_4` (`3_4`),
622 KEY `Grade` (`Grade`)
623) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;
624
625--
626-- Dumping data for table `timetable_s`
627--
628
629INSERT INTO `timetable_s` (`sno`, `Day`, `8_9`, `9_10`, `10_11`, `11_12`, `1_2`, `2_3`, `3_4`, `Grade`) VALUES
630(26, 'Monday', 3, 4, 11, 12, 12, 3, 9, 1),
631(27, 'Tueday', 3, 12, 3, 3, 10, 12, 11, 1),
632(28, 'Wednesday', 11, 8, 8, 5, 7, 5, 4, 1),
633(29, 'Thursday', 4, 12, 5, 9, 7, 12, 12, 1),
634(30, 'Friday', 12, 3, 9, 3, 3, 10, 10, 1),
635(31, 'Monday', 11, 12, 12, 10, 12, 4, 3, 2),
636(32, 'Tueday', 7, 12, 4, 3, 9, 3, 11, 2),
637(33, 'Wednesday', 3, 8, 9, 4, 3, 7, 10, 2),
638(34, 'Thursday', 5, 3, 5, 12, 12, 10, 5, 2),
639(35, 'Friday', 3, 11, 3, 9, 12, 12, 8, 2),
640(36, 'Monday', 12, 8, 10, 12, 8, 4, 3, 3),
641(37, 'Tueday', 3, 3, 3, 12, 10, 4, 12, 3),
642(38, 'Wednesday', 3, 11, 3, 12, 3, 7, 5, 3),
643(39, 'Thursday', 7, 5, 9, 4, 12, 3, 4, 3),
644(40, 'Friday', 12, 8, 7, 5, 7, 12, 5, 3),
645(41, 'Monday', 4, 12, 3, 5, 8, 9, 12, 4),
646(42, 'Tueday', 4, 3, 12, 12, 4, 12, 3, 4),
647(43, 'Wednesday', 10, 5, 8, 12, 5, 7, 10, 4),
648(44, 'Thursday', 7, 3, 4, 12, 8, 7, 3, 4),
649(45, 'Friday', 7, 3, 11, 12, 5, 3, 3, 4),
650(46, 'Monday', 8, 7, 9, 3, 3, 5, 3, 5),
651(47, 'Tueday', 12, 8, 1, 5, 4, 1, 3, 5),
652(48, 'Wednesday', 7, 5, 12, 5, 1, 1, 10, 5),
653(49, 'Thursday', 3, 11, 12, 12, 4, 3, 7, 5),
654(50, 'Friday', 7, 4, 12, 8, 12, 3, 4, 5);
655
656-- --------------------------------------------------------
657
658--
659-- Table structure for table `timetable_tamil`
660--
661
662CREATE TABLE IF NOT EXISTS `timetable_tamil` (
663 `sno` int(11) NOT NULL AUTO_INCREMENT,
664 `Day` varchar(250) NOT NULL,
665 `8_9` int(11) NOT NULL,
666 `9_10` int(11) NOT NULL,
667 `10_11` int(11) NOT NULL,
668 `11_12` int(11) NOT NULL,
669 `1_2` int(11) NOT NULL,
670 `2_3` int(11) NOT NULL,
671 `3_4` int(11) NOT NULL,
672 `gradeid` int(11) NOT NULL,
673 `sectionid` int(11) NOT NULL,
674 PRIMARY KEY (`sno`),
675 KEY `8_9` (`8_9`),
676 KEY `9_10` (`9_10`),
677 KEY `10_11` (`10_11`),
678 KEY `11_12` (`11_12`),
679 KEY `1_2` (`1_2`),
680 KEY `2_3` (`2_3`),
681 KEY `3_4` (`3_4`),
682 KEY `gradeid` (`gradeid`),
683 KEY `sectionid` (`sectionid`)
684) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
685
686--
687-- Dumping data for table `timetable_tamil`
688--
689
690
691-- --------------------------------------------------------
692
693--
694-- Table structure for table `timetable_w`
695--
696
697CREATE TABLE IF NOT EXISTS `timetable_w` (
698 `sno` int(11) NOT NULL AUTO_INCREMENT,
699 `Day` varchar(250) NOT NULL,
700 `8_9` int(11) NOT NULL,
701 `9_10` int(11) NOT NULL,
702 `10_11` int(11) NOT NULL,
703 `11_12` int(11) NOT NULL,
704 `1_2` int(11) NOT NULL,
705 `2_3` int(11) NOT NULL,
706 `3_4` int(11) NOT NULL,
707 `Grade` int(11) NOT NULL,
708 PRIMARY KEY (`sno`),
709 KEY `8_9` (`8_9`),
710 KEY `9_10` (`9_10`),
711 KEY `10_11` (`10_11`),
712 KEY `11_12` (`11_12`),
713 KEY `1_2` (`1_2`),
714 KEY `2_3` (`2_3`),
715 KEY `3_4` (`3_4`),
716 KEY `Grade` (`Grade`)
717) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;
718
719--
720-- Dumping data for table `timetable_w`
721--
722
723INSERT INTO `timetable_w` (`sno`, `Day`, `8_9`, `9_10`, `10_11`, `11_12`, `1_2`, `2_3`, `3_4`, `Grade`) VALUES
724(26, 'Monday', 12, 4, 10, 9, 10, 9, 12, 1),
725(27, 'Tueday', 12, 7, 8, 3, 7, 11, 4, 1),
726(28, 'Wednesday', 12, 5, 3, 12, 3, 12, 3, 1),
727(29, 'Thursday', 11, 5, 12, 3, 12, 10, 3, 1),
728(30, 'Friday', 11, 4, 3, 9, 5, 8, 3, 1),
729(31, 'Monday', 5, 3, 9, 3, 3, 3, 12, 2),
730(32, 'Tueday', 5, 12, 10, 11, 12, 5, 12, 2),
731(33, 'Wednesday', 10, 10, 9, 4, 9, 12, 7, 2),
732(34, 'Thursday', 12, 7, 8, 3, 4, 12, 12, 2),
733(35, 'Friday', 11, 3, 4, 3, 11, 3, 8, 2),
734(36, 'Monday', 12, 12, 10, 5, 12, 5, 12, 3),
735(37, 'Tueday', 10, 4, 8, 8, 12, 8, 5, 3),
736(38, 'Wednesday', 3, 7, 5, 11, 7, 3, 4, 3),
737(39, 'Thursday', 3, 3, 4, 9, 12, 12, 3, 3),
738(40, 'Friday', 4, 3, 7, 12, 7, 3, 3, 3),
739(41, 'Monday', 12, 3, 4, 7, 12, 5, 9, 4),
740(42, 'Tueday', 5, 3, 12, 3, 12, 5, 4, 4),
741(43, 'Wednesday', 8, 4, 3, 3, 8, 3, 8, 4),
742(44, 'Thursday', 7, 10, 5, 4, 7, 12, 12, 4),
743(45, 'Friday', 3, 3, 12, 10, 7, 12, 11, 4),
744(46, 'Monday', 4, 3, 7, 8, 5, 3, 5, 5),
745(47, 'Tueday', 12, 5, 1, 11, 1, 3, 10, 5),
746(48, 'Wednesday', 4, 4, 1, 1, 4, 3, 3, 5),
747(49, 'Thursday', 12, 12, 12, 7, 8, 3, 7, 5),
748(50, 'Friday', 9, 3, 7, 8, 5, 12, 12, 5);
749
750-- --------------------------------------------------------
751
752--
753-- Table structure for table `userinfo`
754--
755
756CREATE TABLE IF NOT EXISTS `userinfo` (
757 `UserId` int(11) NOT NULL AUTO_INCREMENT,
758 `Name` varchar(250) NOT NULL,
759 `PhoneNo` bigint(20) NOT NULL,
760 `Email` varchar(250) NOT NULL,
761 `Address` text NOT NULL,
762 `UserName` varchar(250) NOT NULL,
763 `Password` varchar(250) NOT NULL,
764 `RecordedDate` date NOT NULL,
765 PRIMARY KEY (`UserId`),
766 UNIQUE KEY `UserName` (`UserName`)
767) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
768
769--
770-- Dumping data for table `userinfo`
771--
772
773INSERT INTO `userinfo` (`UserId`, `Name`, `PhoneNo`, `Email`, `Address`, `UserName`, `Password`, `RecordedDate`) VALUES
774(1, 'kiruba', 9043963074, ' kirubakarans2009@gmail.com', 'chennai', 'kiruba', 'kiruba', '2015-07-30'),
775(2, 'ganga', 9043963074, 'ganaga2009@gmail.com', 'chennai', 'ganga', 'ganga', '2015-08-05');
776
777--
778-- Constraints for dumped tables
779--
780
781--
782-- Constraints for table `subject_grade`
783--
784ALTER TABLE `subject_grade`
785 ADD CONSTRAINT `subject_grade_ibfk_1` FOREIGN KEY (`subjectid`) REFERENCES `subject` (`subjectid`) ON DELETE CASCADE ON UPDATE CASCADE,
786 ADD CONSTRAINT `subject_grade_ibfk_2` FOREIGN KEY (`gradeid`) REFERENCES `grade` (`gradeid`) ON DELETE CASCADE ON UPDATE CASCADE;
787
788--
789-- Constraints for table `teacher_grades`
790--
791ALTER TABLE `teacher_grades`
792 ADD CONSTRAINT `teacher_grades_ibfk_1` FOREIGN KEY (`teacherid`) REFERENCES `teacherinfo` (`teacherid`) ON DELETE CASCADE,
793 ADD CONSTRAINT `teacher_grades_ibfk_2` FOREIGN KEY (`gradeid`) REFERENCES `grade` (`gradeid`) ON DELETE CASCADE;
794
795--
796-- Constraints for table `teacher_sections`
797--
798ALTER TABLE `teacher_sections`
799 ADD CONSTRAINT `teacher_sections_ibfk_1` FOREIGN KEY (`teacherid`) REFERENCES `teacherinfo` (`teacherid`) ON DELETE CASCADE,
800 ADD CONSTRAINT `teacher_sections_ibfk_2` FOREIGN KEY (`sectionid`) REFERENCES `sections` (`sectionid`) ON DELETE CASCADE;
801
802--
803-- Constraints for table `teacher_subjects`
804--
805ALTER TABLE `teacher_subjects`
806 ADD CONSTRAINT `teacher_subjects_ibfk_1` FOREIGN KEY (`teacherid`) REFERENCES `teacherinfo` (`teacherid`) ON DELETE CASCADE,
807 ADD CONSTRAINT `teacher_subjects_ibfk_2` FOREIGN KEY (`subjectid`) REFERENCES `subject` (`subjectid`) ON DELETE CASCADE;
808
809/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
810/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
811/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;