· 8 years ago · Sep 01, 2018, 04:58 PM
1-- Adminer 3.3.3 MySQL dump
2
3SET NAMES utf8;
4SET foreign_key_checks = 0;
5SET time_zone = 'SYSTEM';
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `course`;
9CREATE TABLE `course` (
10 `courID` int(11) NOT NULL AUTO_INCREMENT,
11 `courseName` varchar(50) NOT NULL,
12 `Dgree` char(2) NOT NULL,
13 PRIMARY KEY (`courID`)
14) ENGINE=InnoDB DEFAULT CHARSET=latin1;
15
16INSERT INTO `course` (`courID`, `courseName`, `Dgree`) VALUES
17(1, 'BA', 'bd'),
18(2, 'BSC', 'bd'),
19(3, 'BCOM', 'bd'),
20(4, 'MA', 'md'),
21(5, 'MSC', 'md'),
22(6, 'MCOM', 'md'),
23(7, 'High School', 'hs'),
24(8, 'Intermediate', 'ss'),
25(9, 'other', 'ot');
26
27DROP TABLE IF EXISTS `personalInformation`;
28CREATE TABLE `personalInformation` (
29 `stdId` int(11) NOT NULL AUTO_INCREMENT,
30 `stdFname` varchar(50) NOT NULL,
31 `stdMname` varchar(50) NOT NULL,
32 `stdDob` varchar(50) NOT NULL,
33 `stdSex` varchar(50) NOT NULL,
34 `stdNat` varchar(50) NOT NULL,
35 `stdCategory` varchar(50) NOT NULL,
36 `stdSubCategory` varchar(50) NOT NULL,
37 `stdOrgResd` varchar(50) NOT NULL,
38 `stdGarOccup` varchar(50) NOT NULL,
39 `stdGarIncome` varchar(50) NOT NULL,
40 `stdPernAddres` varchar(50) NOT NULL,
41 `stdPernAddresPin` varchar(50) NOT NULL,
42 `stdPernAddresPhone` varchar(50) NOT NULL,
43 `stdPernMob` varchar(50) NOT NULL,
44 `stdAddcorresp` varchar(50) NOT NULL,
45 `stdAddcorrespPin` varchar(50) NOT NULL,
46 `stdAddcorrespPhone` varchar(50) NOT NULL,
47 `stdAddcorrespMob` varchar(50) NOT NULL,
48 `stdParticipationSports` varchar(50) NOT NULL,
49 `stdGraduate` varchar(50) NOT NULL,
50 `stdRelative` varchar(50) NOT NULL,
51 `stdNCC` varchar(50) NOT NULL,
52 `stdScouts` varchar(50) NOT NULL,
53 `stdRover` varchar(50) NOT NULL,
54 `stdAnyotherweightage` varchar(250) NOT NULL,
55 PRIMARY KEY (`stdId`)
56) ENGINE=InnoDB DEFAULT CHARSET=latin1;
57
58INSERT INTO `personalInformation` (`stdId`, `stdFname`, `stdMname`, `stdDob`, `stdSex`, `stdNat`, `stdCategory`, `stdSubCategory`, `stdOrgResd`, `stdGarOccup`, `stdGarIncome`, `stdPernAddres`, `stdPernAddresPin`, `stdPernAddresPhone`, `stdPernMob`, `stdAddcorresp`, `stdAddcorrespPin`, `stdAddcorrespPhone`, `stdAddcorrespMob`, `stdParticipationSports`, `stdGraduate`, `stdRelative`, `stdNCC`, `stdScouts`, `stdRover`, `stdAnyotherweightage`) VALUES
59(39, 'bsing', 'soniya', '1987-01-07', 'M', 'IND', 'Gen', 'PH', 'up', 'techer', '2Lakh', 'mrt', '250005', '7895349331', '987654321', 'mrt', '250005', '9876543210', '7895349321', 'National level', 'CCS University', 'Yes', 'Yes', 'Yes', 'Yes', ''),
60(40, 'bsing', 'soniya', '1987-01-07', 'M', 'IND', 'Gen', 'PH', 'up', 'techer', '2Lakh', 'mrt', '250005', '7895349331', '987654321', 'mrt', '250005', '9876543210', '7895349321', 'National level', 'CCS University', 'Yes', 'Yes', 'Yes', 'Yes', ''),
61(41, 'bsing', 'soniya', '1987-01-07', 'M', 'IND', 'Gen', 'PH', 'up', 'techer', '2Lakh', 'mrt', '250005', '7895349331', '987654321', 'mrt', '250005', '9876543210', '7895349321', 'National level', 'CCS University', 'Yes', 'Yes', 'Yes', 'Yes', ''),
62(42, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
63(43, 'Mr Amitab', 'Mrs Sunita', '14-7-1987', 'M', 'IND', 'Gen', 'PH', 'up', 'doctor', '3Lakh', 'mrt', '250005', '7895349331', '7895349331', 'mrt1', '250005', '7895349331', '7895349321', 'National level', 'CCS University', 'Yes', 'Yes', 'Yes', 'Yes', ''),
64(44, 'bsing', 'soniya', '1987-01-07', 'M', 'IND', 'Gen', 'PH', 'up', 'doctor', '4Lakh', 'mrt', '250005', '7895349331', '7895349331', 'mrt1', '250005', '7895349331', '7895349321', 'National level', 'CCS University', 'Yes', 'Yes', 'Yes', 'Yes', ''),
65(45, 'kbnkk', 'bkn', 'bk', 'F', 'IND', 'ST', 'PH', 'other', 'Doctor', 'Below 2lakh', 'kbnkbnk', 'kbkbkb', 'bkbkbkb', 'bkbkbkb', 'bkbkbkbkbkmrt1', 'kjbkb', 'kbk', 'bk ', 'state level', 'Other University', 'Y', 'Y', 'Y', 'Y', 'kbkbkbkb');
66
67DROP TABLE IF EXISTS `previousEducation`;
68CREATE TABLE `previousEducation` (
69 `preId` int(11) NOT NULL AUTO_INCREMENT,
70 `CourseName` int(11) NOT NULL,
71 `PYear` varchar(10) NOT NULL,
72 `Divs` varchar(10) NOT NULL,
73 `Per` varchar(10) NOT NULL,
74 `SubTaken` varchar(50) NOT NULL,
75 `School` varchar(50) NOT NULL,
76 `Board` varchar(50) NOT NULL,
77 `stdId` int(11) NOT NULL,
78 PRIMARY KEY (`preId`)
79) ENGINE=InnoDB DEFAULT CHARSET=latin1;
80
81INSERT INTO `previousEducation` (`preId`, `CourseName`, `PYear`, `Divs`, `Per`, `SubTaken`, `School`, `Board`, `stdId`) VALUES
82(7, 8, '2004', '2', '55', 'science', 'ssm', 'up', 39),
83(8, 8, '2004', '2', '55', 'science', 'ssm', 'up', 40),
84(9, 8, '2004', '2', '55', 'science', 'ssm', 'up', 41),
85(10, 0, '', '', '', '', '', '', 42),
86(11, 8, '2004', '2', '55', 'science', 'ambedkar', 'up', 43),
87(12, 8, '2004', '2', '55', 'science', 'amd', 'up', 44),
88(13, 8, '', '', '', '', '', '', 45);
89
90DROP TABLE IF EXISTS `student`;
91CREATE TABLE `student` (
92 `studentId` int(11) NOT NULL AUTO_INCREMENT,
93 `stdId` int(11) NOT NULL,
94 `stdName` varchar(50) NOT NULL,
95 `collegeReg` varchar(50) NOT NULL,
96 `collegeDateofjoining` varchar(50) NOT NULL,
97 `DateOfRegistrationNo` varchar(50) NOT NULL,
98 `UniversityRegistrationNo` varchar(50) NOT NULL,
99 `className` int(11) NOT NULL,
100 `sub1` int(11) NOT NULL,
101 `sub2` int(11) NOT NULL,
102 `sub3` int(11) NOT NULL,
103 PRIMARY KEY (`studentId`)
104) ENGINE=InnoDB DEFAULT CHARSET=latin1;
105
106INSERT INTO `student` (`studentId`, `stdId`, `stdName`, `collegeReg`, `collegeDateofjoining`, `DateOfRegistrationNo`, `UniversityRegistrationNo`, `className`, `sub1`, `sub2`, `sub3`) VALUES
107(31, 44, 'dilip joshi', '0001', '14-4-2011', '14-14-2012', '000045', 1, 1, 2, 4),
108(32, 45, 'noby', '0000', '0000', '0000', '0000', 4, 1, 1, 1);
109
110DROP TABLE IF EXISTS `subject`;
111CREATE TABLE `subject` (
112 `subId` int(11) NOT NULL AUTO_INCREMENT,
113 `subName` varchar(50) NOT NULL,
114 `courseId` int(11) NOT NULL,
115 PRIMARY KEY (`subId`)
116) ENGINE=InnoDB DEFAULT CHARSET=latin1;
117
118INSERT INTO `subject` (`subId`, `subName`, `courseId`) VALUES
119(1, 'Hindi', 0),
120(2, 'Geography', 0),
121(3, 'History', 0),
122(4, 'Sociology', 0),
123(5, 'Journalism', 0);
124
125-- 2012-06-20 15:43:49