-
Notifications
You must be signed in to change notification settings - Fork 6
/
Copy pathican.sql
100 lines (86 loc) · 4.18 KB
/
ican.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
-- Adminer 4.3.1 MySQL dump
SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`password` varchar(25) NOT NULL,
`email_id` varchar(50) NOT NULL,
`image` varchar(300) NOT NULL,
`description` varchar(500) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `quiz_choices`;
CREATE TABLE `quiz_choices` (
`id` int(11) NOT NULL,
`quiz_question_id` int(11) NOT NULL,
`choice` int(11) NOT NULL,
`is_right_choice` enum('(''1'',''0'')') NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `quiz_questions`;
CREATE TABLE `quiz_questions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`quiz_type_id` int(11) NOT NULL,
`question` varchar(300) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `quiz_types`;
CREATE TABLE `quiz_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`quiz_name` varchar(50) NOT NULL,
`quiz_type` int(11) NOT NULL,
`quiz_level` int(11) NOT NULL,
`no_of_questions` int(11) NOT NULL,
`quiz_image` varchar(300) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `quiz_types` (`id`, `quiz_name`, `quiz_type`, `quiz_level`, `no_of_questions`, `quiz_image`) VALUES
(1, 'Android', 1, 1, 10, 'androidlogo.png');
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`student_id` int(20) NOT NULL AUTO_INCREMENT,
`first_name` varchar(50) NOT NULL,
`last_name` varchar(50) NOT NULL,
`username` varchar(50) NOT NULL,
`email_id` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`DOB` date NOT NULL,
`gender` int(11) NOT NULL,
`image` longtext NOT NULL,
`phone` varchar(20) NOT NULL,
PRIMARY KEY (`student_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `student` (`student_id`, `first_name`, `last_name`, `username`, `email_id`, `password`, `DOB`, `gender`, `image`, `phone`) VALUES
(1, 'Khalid', 'Ali', 'ka123', 'ka@gmail.com', 'ka123', '1988-05-20', 0, 'khalid.jpg', '4578963215'),
(2, 'yrtyret', 'ertert', 'ertetr', 'ertte', 'ertetr', '1987-06-05', 0, '0339616.jpg', 'ertert'),
(3, 'ffff', 'ff', 'dsf', 'aaaaaaa', 'aaaaaaaa', '1998-02-03', 1, 'BRO_ResponsiveDesign_Main2.png', '54654654654'),
(4, 'ffff', 'ff', 'dsf', 'aaaaaaa', 'aaaaaaaa', '1998-02-03', 1, 'BRO_ResponsiveDesign_Main2.png', '54654654654'),
(5, 'aa', 'aa', 'aa', 'aa@gmail.com', 'aa', '1993-07-06', 0, 'chat.png', '458963217'),
(6, 'aa', 'aa', 'aa', 'aa@gmail.com', 'aa', '1993-07-06', 0, 'chat.png', '458963217'),
(7, 'ww', 'ww', 'ww', 'ww', 'ww', '1988-05-20', 0, '004-teamwork-1.png', '785496321'),
(8, 'ww', 'ww', 'ww', 'ww', 'ww', '1988-05-20', 0, '004-teamwork-1.png', '785496321'),
(9, 'ww', 'ww', 'ww', 'ww', 'ww', '1988-05-20', 0, '004-teamwork-1.png', '785496321'),
(10, 'ww', 'ww', 'ww', 'ww', 'ww', '1988-05-20', 0, '004-teamwork-1.png', '785496321'),
(11, 'ww', 'ww', 'ww', 'ww', 'ww', '1988-05-20', 0, '004-teamwork-1.png', '785496321'),
(12, 'ww', 'ww', 'ww', 'ww', 'ww', '1988-05-20', 0, '004-teamwork-1.png', '785496321'),
(13, 'ww', 'ww', 'ww', 'ww', 'ww', '1988-05-20', 0, '004-teamwork-1.png', '785496321'),
(14, 'ww', 'ww', 'ww', 'ww', 'ww', '1988-05-20', 0, '004-teamwork-1.png', '785496321'),
(15, 'ww', 'ww', 'ww', 'ww', 'ww', '1988-05-20', 0, '004-teamwork-1.png', '785496321'),
(16, 'ww', 'ww', 'ww', 'ww', 'ww', '1988-05-20', 0, '004-teamwork-1.png', '785496321'),
(17, 'ww', 'ww', 'ww', 'ww', 'ww', '1988-05-20', 0, '004-teamwork-1.png', '785496321'),
(18, 'Ritu', 'Raghani', 'rits.raghani', 'rits.raghani@gmail.com', 'ritu123', '1993-07-06', 1, '10511184_686912181381712_2511078281845367562_n.jpg', '9167731358'),
(19, 'muzammil', 'shaikh', 'ms', 'ms@gmail.com', 'ms123', '1993-04-23', 0, 'operator.png', '91677');
DROP TABLE IF EXISTS `student_quiz`;
CREATE TABLE `student_quiz` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`student_id` int(11) NOT NULL,
`quiz_type_id` int(11) NOT NULL,
`question_id` int(11) NOT NULL,
`choice_id` int(11) NOT NULL,
`is_right` enum('(''1'',''0'')') NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- 2018-02-02 13:35:26