-
Notifications
You must be signed in to change notification settings - Fork 6
/
quiz_choices.sql
60 lines (56 loc) · 2.05 KB
/
quiz_choices.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
-- 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 `quiz_choices`;
CREATE TABLE `quiz_choices` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`quiz_question_id` int(11) NOT NULL,
`choice` varchar(200) NOT NULL,
`is_right_choice` enum('1','0') NOT NULL,
PRIMARY KEY (`id`),
KEY `quiz_question_id` (`quiz_question_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `quiz_choices` (`id`, `quiz_question_id`, `choice`, `is_right_choice`) VALUES
(1, 1, 'Hyperlinks and Text Markup Language', '0'),
(2, 1, 'Hyper Text Markup Language', '1'),
(3, 1, 'Hyper Tool Markup Language', '0'),
(4, 1, 'Home Tool Markup Language', '0'),
(5, 2, 'Mozilla', '0'),
(6, 2, 'Microsoft', '0'),
(7, 2, 'World Wide Web', '1'),
(8, 2, 'Google', '0'),
(9, 3, '<heading>', '0'),
(10, 3, '<h1>', '1'),
(11, 3, '<h6>', '0'),
(12, 3, '<head>', '0'),
(13, 4, '<lb>', '0'),
(14, 4, '<br>', '1'),
(15, 4, '<break>', '0'),
(16, 4, '<bl>', '0'),
(17, 5, '<body bg=\"yellow\">', '0'),
(18, 5, '<background> Yellow </background>', '0'),
(19, 5, '<body style=\"background-color:yellow;\">', '1'),
(20, 5, '<body bg-color=\"yellow\">', '0'),
(21, 6, '<important>', '0'),
(22, 6, '<b>', '0'),
(23, 6, '<strong>', '1'),
(24, 6, '<li>', '0'),
(25, 7, '<em>', '0'),
(26, 7, '<i>', '1'),
(27, 7, '<italic>', '0'),
(28, 7, '<it>', '0'),
(29, 8, '<a href=\"www.google.com\"> google </a>', '1'),
(30, 8, '<a name=\"www.google.com\"> google </a>', '0'),
(31, 8, '<a URL=\"www.google.com\"> google </a>', '0'),
(32, 8, '<a> www.google.com </a>', '0'),
(33, 9, '<', '0'),
(34, 9, '*', '0'),
(35, 9, '?', '0'),
(36, 9, '/', '1'),
(37, 10, '<a href=\"url\" target=\"new\">', '0'),
(38, 10, '<a href=\"url\" target=\"_blank\">', '1'),
(39, 10, '<a href=\"url\">', '0'),
(40, 10, '<a href=\"url\" new>', '0');
-- 2018-02-07 17:21:14