· 8 years ago · Apr 10, 2018, 01:24 PM
1-- Adminer 4.6.2 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `feeds`;
9CREATE TABLE `feeds` (
10 `feed_no` int(6) NOT NULL AUTO_INCREMENT,
11 `st_username` varchar(50) NOT NULL,
12 `te_username` varchar(50) NOT NULL,
13 `sub_code` varchar(7) NOT NULL,
14 `sub_name` varchar(50) NOT NULL,
15 `class` varchar(20) NOT NULL,
16 `cover` int(2) DEFAULT NULL,
17 `discuss` int(2) DEFAULT NULL,
18 `knowledge` int(2) DEFAULT NULL,
19 `communicate` int(2) DEFAULT NULL,
20 `inspire` int(2) DEFAULT NULL,
21 `punctual` int(2) DEFAULT NULL,
22 `engage` int(2) DEFAULT NULL,
23 `prepare` int(2) DEFAULT NULL,
24 `guidance` int(2) DEFAULT NULL,
25 `available` int(2) DEFAULT NULL,
26 PRIMARY KEY (`feed_no`),
27 KEY `st_username` (`st_username`),
28 KEY `te_username` (`te_username`)
29) ENGINE=InnoDB DEFAULT CHARSET=latin1;
30
31INSERT INTO `feeds` (`feed_no`, `st_username`, `te_username`, `sub_code`, `sub_name`, `class`, `cover`, `discuss`, `knowledge`, `communicate`, `inspire`, `punctual`, `engage`, `prepare`, `guidance`, `available`) VALUES
32(12, 'shivam_ver', 'Miss_Ayushi_Alagh', 'CS306', 'BCA102', 'BCA', 3, 5, 4, 4, 5, 5, 5, 5, 4, 5),
33(13, 'shivam_ver', 'Mr_Sumeshwar_Singh', 'CS304', 'BCA506', 'BCA', 3, 5, 3, 4, 2, 4, 2, 4, 2, 3),
34(14, 'shivam_ver', 'Ms_Nancy', 'CS308', 'BCA407', 'BCA', 4, 3, 4, 4, 4, 3, 4, 4, 4, 2),
35(15, 'shivani', 'Mr_Sudhir_Kumar', 'CS302', 'BCA405', 'BCA', 3, 4, 3, 5, 3, 4, 5, 4, 5, 3),
36(16, 'shivani', 'Ms_Nancy', 'CS308', 'BCA407', 'BCA', 3, 4, 5, 3, 5, 3, 5, 4, 5, 3),
37(17, 'shivani', 'Mr_Sumeshwar_Singh', 'CS304', 'BCA506', 'BCA', 5, 5, 5, 5, 5, 5, 5, 5, 5, 5);
38
39DROP TABLE IF EXISTS `hods`;
40CREATE TABLE `hods` (
41 `hod_username` varchar(50) NOT NULL,
42 `password` varchar(30) NOT NULL,
43 `dept` varchar(4) NOT NULL,
44 PRIMARY KEY (`hod_username`),
45 KEY `hod_username` (`hod_username`)
46) ENGINE=InnoDB DEFAULT CHARSET=latin1;
47
48INSERT INTO `hods` (`hod_username`, `password`, `dept`) VALUES
49('admin', 'admin', 'CSE');
50
51DROP TABLE IF EXISTS `students`;
52CREATE TABLE `students` (
53 `rollno` varchar(10) NOT NULL,
54 `st_username` varchar(10) NOT NULL,
55 `class` varchar(8) NOT NULL,
56 `password` varchar(30) DEFAULT NULL,
57 `done` int(1) NOT NULL DEFAULT '0',
58 PRIMARY KEY (`st_username`),
59 KEY `st_username` (`st_username`),
60 KEY `rollno` (`rollno`)
61) ENGINE=InnoDB DEFAULT CHARSET=latin1;
62
63INSERT INTO `students` (`rollno`, `st_username`, `class`, `password`, `done`) VALUES
64('1591909051', 'himanshu_r', 'BCA', 'student@123', 0),
65('1591909092', 'mohit_kuma', 'BCA', 'student@123', 0),
66('1591909093', 'mohit_yada', 'BCA', 'student@123', 0),
67('1591909094', 'mukul_sing', 'BCA', 'student@123', 0),
68('1591909147', 'shivam_ver', 'BCA', 'student@123', 0),
69('1591909148', 'shivani', 'BCA', 'student@123', 0);
70
71DROP TABLE IF EXISTS `teachers`;
72CREATE TABLE `teachers` (
73 `te_username` varchar(50) NOT NULL,
74 `password` varchar(30) NOT NULL,
75 `dept` varchar(4) NOT NULL,
76 PRIMARY KEY (`te_username`),
77 KEY `te_username` (`te_username`)
78) ENGINE=InnoDB DEFAULT CHARSET=latin1;
79
80INSERT INTO `teachers` (`te_username`, `password`, `dept`) VALUES
81('Miss_Ayushi_Alagh', 'hello@123', 'CSE'),
82('Mr_Rohit_Kumar', 'hello@123', 'CSE'),
83('Mr_Sudhir_Kumar', 'hello@123', 'ECE'),
84('Mr_Sumeshwar_Singh', 'hello@123', 'CSE'),
85('Ms_Nancy', 'hello@123', 'CSE');
86
87DROP TABLE IF EXISTS `teachersinfo`;
88CREATE TABLE `teachersinfo` (
89 `info_no` int(6) NOT NULL AUTO_INCREMENT,
90 `te_username` varchar(50) NOT NULL,
91 `class` varchar(8) NOT NULL,
92 `sub_name` varchar(50) NOT NULL,
93 `sub_code` varchar(7) NOT NULL,
94 `dept` varchar(5) NOT NULL,
95 `class_strength` int(3) NOT NULL,
96 `feed_applied` int(3) NOT NULL DEFAULT '0',
97 UNIQUE KEY `info_no` (`info_no`)
98) ENGINE=InnoDB DEFAULT CHARSET=latin1;
99
100INSERT INTO `teachersinfo` (`info_no`, `te_username`, `class`, `sub_name`, `sub_code`, `dept`, `class_strength`, `feed_applied`) VALUES
101(1, 'Miss_Ayushi_Alagh', 'BCA', 'BCA102', 'CS306', 'IT', 40, 1),
102(2, 'Mr_Rohit_Kumar', 'BCA', 'BCA402', 'HS300', 'IT', 40, 0),
103(3, 'Mr_Sudhir_Kumar', 'BCA', 'BCA405', 'CS302', 'IT', 40, 1),
104(4, 'Mr_Sumeshwar_Singh', 'BCA', 'BCA506', 'CS304', 'IT', 40, 2),
105(5, 'Ms_Nancy', 'BCA', 'BCA407', 'CS308', 'IT', 40, 2);
106
107-- 2018-04-10 13:21:33