· 8 years ago · May 30, 2018, 03:18 PM
1# ************************************************************
2# Sequel Pro SQL dump
3# Version 4541
4#
5# http://www.sequelpro.com/
6# https://github.com/sequelpro/sequelpro
7#
8# Host: 127.0.0.1 (MySQL 5.7.22-0ubuntu0.16.04.1)
9# Database: challengetrivia
10# Generation Time: 2018-05-30 15:13:04 +0000
11# ************************************************************
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
19/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
20/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
21
22
23# Dump of table answers
24# ------------------------------------------------------------
25
26DROP TABLE IF EXISTS `answers`;
27
28CREATE TABLE `answers` (
29 `id` int(11) NOT NULL AUTO_INCREMENT,
30 `question_number` varchar(20) NOT NULL,
31 `correct_answer` varchar(100) NOT NULL,
32 PRIMARY KEY (`id`)
33) ENGINE=MyISAM DEFAULT CHARSET=utf8;
34
35LOCK TABLES `answers` WRITE;
36/*!40000 ALTER TABLE `answers` DISABLE KEYS */;
37
38INSERT INTO `answers` (`id`, `question_number`, `correct_answer`)
39VALUES
40 (1,'R1Q1','McDonalds'),
41 (2,'R1Q2','The Wall'),
42 (3,'R1Q3','Rorschach'),
43 (4,'R1Q4','Nike'),
44 (5,'R1Q5','Treasure Island'),
45 (6,'R1Q6','Munich'),
46 (7,'AV1:','The Wicker Man'),
47 (8,'R2Q1','Green Bay Packers'),
48 (9,'R2Q2','Ramsay Bolton'),
49 (10,'R2Q3','Resource Location'),
50 (11,'R2Q4','Ashton Kutcher'),
51 (12,'R2Q5','Ontario'),
52 (13,'R2Q6','Kareem Abdul-Jabbar'),
53 (14,'R3Q1','Chicago'),
54 (15,'R3Q2','Trumpet'),
55 (16,'R3Q3','Isaac Newton'),
56 (17,'R3Q4','20 mph'),
57 (18,'R3Q5','Danger Mouse'),
58 (19,'R3Q6','4th Amendment'),
59 (20,'AV2:','Jason Priestley'),
60 (21,'R4Q1','Usain Bolt'),
61 (22,'R4Q2','A Gorgon'),
62 (23,'R4Q3','Buzz Aldrin'),
63 (24,'R4Q4','D'),
64 (25,'R4Q5','Rock the Baby'),
65 (26,'R4Q6','Captain Marvel'),
66 (27,'The ','An axe');
67
68/*!40000 ALTER TABLE `answers` ENABLE KEYS */;
69UNLOCK TABLES;
70
71
72# Dump of table questions
73# ------------------------------------------------------------
74
75DROP TABLE IF EXISTS `questions`;
76
77CREATE TABLE `questions` (
78 `question` varchar(200) NOT NULL,
79 `answer` varchar(100) NOT NULL,
80 `correct` varchar(3) NOT NULL,
81 `points_awarded` varchar(4) NOT NULL,
82 `player_name` varchar(50) NOT NULL,
83 `player_email` varchar(50) NOT NULL,
84 `answer_time` varchar(50) NOT NULL,
85 `id` int(11) NOT NULL AUTO_INCREMENT,
86 PRIMARY KEY (`id`)
87) ENGINE=MyISAM DEFAULT CHARSET=utf8;
88
89LOCK TABLES `questions` WRITE;
90/*!40000 ALTER TABLE `questions` DISABLE KEYS */;
91
92INSERT INTO `questions` (`question`, `answer`, `correct`, `points_awarded`, `player_name`, `player_email`, `answer_time`, `id`)
93VALUES
94 ('R1Q1: At the companys annual meeting on May 24th , which global fast-food giant rejected a proposal to stop using plastic straws?','McDonalds','3','0','Keepem Coming','-','May 30, 2018 12:07 AM',1),
95 ('R1Q1: At the companys annual meeting on May 24th , which global fast-food giant rejected a proposal to stop using plastic straws?','McDonalds','3','0','Alpha Squad','-','May 30, 2018 12:08 AM',2),
96 ('R1Q1: At the companys annual meeting on May 24th , which global fast-food giant rejected a proposal to stop using plastic straws?','McDonalds','3','0','Fortnite','-','May 30, 2018 12:08 AM',3),
97 ('R1Q1: At the companys annual meeting on May 24th , which global fast-food giant rejected a proposal to stop using plastic straws?','McDonalds','0','0','Uncle mo','-','May 30, 2018 12:08 AM',4),
98 ('R1Q2: Pink Floyd has 4 number one albums: The Dark Side of the Moon, Wish You Were Here, The Division Bell and what?','The Wall','3','40','Alpha Squad','-','May 30, 2018 12:10 AM',5),
99 ('R1Q2: Pink Floyd has 4 number one albums: The Dark Side of the Moon, Wish You Were Here, The Division Bell and what?','The Wall','3','0','Uncle mo','-','May 30, 2018 12:10 AM',6),
100 ('R1Q2: Pink Floyd has 4 number one albums: The Dark Side of the Moon, Wish You Were Here, The Division Bell and what?','The Wall','0','0','Fortnite','-','May 30, 2018 12:10 AM',7),
101 ('R1Q2: Pink Floyd has 4 number one albums: The Dark Side of the Moon, Wish You Were Here, The Division Bell and what?','The Wall','0','0','Keepem Coming','-','May 30, 2018 12:10 AM',8),
102 ('R1Q3: This image is an example of what famous psychological test?','Rorschach','3','80','Fortnite','-','May 30, 2018 12:11 AM',9),
103 ('R1Q3: This image is an example of what famous psychological test?','Rorschach','3','40','Uncle mo','-','May 30, 2018 12:11 AM',10),
104 ('R1Q3: This image is an example of what famous psychological test?','Rorschach','3','20','Alpha Squad','-','May 30, 2018 12:11 AM',11),
105 ('R1Q3: This image is an example of what famous psychological test?','Rorschach','3','0','Keepem Coming','-','May 30, 2018 12:12 AM',12),
106 ('R1Q4: What famous footwear company was founded in 1964 as Blue-Ribbon Sports?','Nike','3','20','Keepem Coming','-','May 30, 2018 12:14 AM',13),
107 ('R1Q4: What famous footwear company was founded in 1964 as Blue-Ribbon Sports?','Nike','0','0','Fortnite','-','May 30, 2018 12:14 AM',14),
108 ('R1Q4: What famous footwear company was founded in 1964 as Blue-Ribbon Sports?','Nike','0','0','Alpha Squad','-','May 30, 2018 12:15 AM',15),
109 ('R1Q4: What famous footwear company was founded in 1964 as Blue-Ribbon Sports?','Converse','0','0','Uncle mo','-','May 30, 2018 12:15 AM',16),
110 ('R1Q5: This is the cover of what book?','Treasure Island','0','0','Alpha Squad','-','May 30, 2018 12:17 AM',17),
111 ('R1Q5: This is the cover of what book?','Treasure Island','0','0','Keepem Coming','-','May 30, 2018 12:17 AM',18),
112 ('R1Q5: This is the cover of what book?','Treasure Island','0','0','Uncle mo','-','May 30, 2018 12:17 AM',19),
113 ('R1Q5: This is the cover of what book?','Treasure Island','0','0','Fortnite','-','May 30, 2018 12:17 AM',20),
114 ('R1Q6: Which of these Steven Spielberg films did Tom Hanks NOT appear in:','Munich','0','0','Alpha Squad','-','May 30, 2018 12:18 AM',21),
115 ('R1Q6: Which of these Steven Spielberg films did Tom Hanks NOT appear in:','Munich','0','0','Keepem Coming','-','May 30, 2018 12:19 AM',22),
116 ('R1Q6: Which of these Steven Spielberg films did Tom Hanks NOT appear in:','Munich','0','0','Uncle mo','-','May 30, 2018 12:19 AM',23),
117 ('R1Q6: Which of these Steven Spielberg films did Tom Hanks NOT appear in:','Munich','0','0','Fortnite','-','May 30, 2018 12:19 AM',24),
118 ('AV1: What movie is this Cage Clip from?','The Wicker Man','3','0','Alpha Squad','-','May 30, 2018 12:22 AM',25),
119 ('AV1: What movie is this Cage Clip from?','Dont know','0','0','Uncle mo','-','May 30, 2018 12:22 AM',26),
120 ('AV1: What movie is this Cage Clip from?','The Wicker Man','3','0','Keepem Coming','-','May 30, 2018 12:23 AM',27),
121 ('R2Q1: What NFL team won the first 2 Super Bowls?','Green Bay Packers','3','80','Fortnite','-','May 30, 2018 12:25 AM',28),
122 ('R2Q1: What NFL team won the first 2 Super Bowls?','Green Bay Packers','3','40','Keepem Coming','-','May 30, 2018 12:25 AM',29),
123 ('R2Q1: What NFL team won the first 2 Super Bowls?','Green Bay Packers','3','20','Uncle mo','-','May 30, 2018 12:25 AM',30),
124 ('R2Q1: What NFL team won the first 2 Super Bowls?','Green Bay Packers','0','0','Alpha Squad','-','May 30, 2018 12:26 AM',31),
125 ('R2Q2: In the \"Game of Thrones\" episode titled \"Battle of the Bastards\", Jon Snow battles for control of Winterfell against which bastard enemy?','Ramsay Bolton','3','60','Keepem Coming','-','May 30, 2018 12:27 AM',32),
126 ('R2Q2: In the \"Game of Thrones\" episode titled \"Battle of the Bastards\", Jon Snow battles for control of Winterfell against which bastard enemy?','Ramsay Bolton','3','0','Alpha Squad','-','May 30, 2018 12:29 AM',33),
127 ('R2Q2: In the \"Game of Thrones\" episode titled \"Battle of the Bastards\", Jon Snow battles for control of Winterfell against which bastard enemy?','Ramsay Bolton','3','0','Fortnite','-','May 30, 2018 12:29 AM',34),
128 ('R2Q3: URL in computing stands for Uniform ________ ________','Resource Location','3','0','Keepem Coming','-','May 30, 2018 12:31 AM',35),
129 ('R2Q3: URL in computing stands for Uniform ________ ________','Resource Location','3','0','Alpha Squad','-','May 30, 2018 12:31 AM',36),
130 ('R2Q3: URL in computing stands for Uniform ________ ________','Resource Location','3','0','Fortnite','-','May 30, 2018 12:32 AM',37),
131 ('R2Q4: What former sitcom star went on The Ellen DeGeneres Show on May 23rd , and donated $4 million to Ellens wildlife fund via his new money transfer app?','Ashton Kutcher','3','40','Uncle mo','-','May 30, 2018 12:34 AM',38),
132 ('R2Q4: What former sitcom star went on The Ellen DeGeneres Show on May 23rd , and donated $4 million to Ellens wildlife fund via his new money transfer app?','Ashton Kutcher','0','0','Keepem Coming','-','May 30, 2018 12:35 AM',39),
133 ('R2Q4: What former sitcom star went on The Ellen DeGeneres Show on May 23rd , and donated $4 million to Ellens wildlife fund via his new money transfer app?','Ashton Kutcher','0','0','Fortnite','-','May 30, 2018 12:35 AM',40),
134 ('R2Q4: What former sitcom star went on The Ellen DeGeneres Show on May 23rd , and donated $4 million to Ellens wildlife fund via his new money transfer app?','Ashton Kutcher','0','0','Alpha Squad','-','May 30, 2018 12:35 AM',41),
135 ('R2Q5: With almost 14 million residents, what is Canadas most populated province?','Ontario','3','80','Alpha Squad','-','May 30, 2018 12:36 AM',42),
136 ('R2Q5: With almost 14 million residents, what is Canadas most populated province?','Quebec','0','0','Fortnite','-','May 30, 2018 12:36 AM',43),
137 ('R2Q5: With almost 14 million residents, what is Canadas most populated province?','Ontario','0','0','Keepem Coming','-','May 30, 2018 12:36 AM',44),
138 ('R2Q5: With almost 14 million residents, what is Canadas most populated province?','Quebec','0','0','Uncle mo','-','May 30, 2018 12:37 AM',45),
139 ('R2Q6: What NBA star did Bruce Lee fight in his final film \"Game of Death\"?','Wilt Chamberlain','0','0','Keepem Coming','-','May 30, 2018 12:38 AM',46),
140 ('R2Q6: What NBA star did Bruce Lee fight in his final film \"Game of Death\"?','Kareem Abdul-Jabbar','3','40','Alpha Squad','-','May 30, 2018 12:38 AM',47),
141 ('R2Q6: What NBA star did Bruce Lee fight in his final film \"Game of Death\"?','Will Chamberlain','0','0','Uncle mo','-','May 30, 2018 12:39 AM',48),
142 ('R2Q6: What NBA star did Bruce Lee fight in his final film \"Game of Death\"?','Kareem Abdul-Jabbar','3','0','Fortnite','-','May 30, 2018 12:39 AM',49),
143 ('R3Q1: The ferris wheel debuted at the 1893 Worlds Fair in what city?','Chicago','0','0','Fortnite','-','May 30, 2018 12:58 AM',50),
144 ('R3Q1: The ferris wheel debuted at the 1893 Worlds Fair in what city?','Chicago','0','0','Keepem Coming','-','May 30, 2018 12:59 AM',51),
145 ('R3Q1: The ferris wheel debuted at the 1893 Worlds Fair in what city?','Chicago','0','0','Alpha Squad','-','May 30, 2018 12:59 AM',52),
146 ('R3Q1: The ferris wheel debuted at the 1893 Worlds Fair in what city?','Paris','0','0','Uncle mo','-','May 30, 2018 1:00 AM',53),
147 ('R3Q2: What instrument has the highest register in the brass family?','Trumpet','0','0','Keepem Coming','-','May 30, 2018 1:02 AM',54),
148 ('R3Q2: What instrument has the highest register in the brass family?','Trumpet','0','0','Fortnite','-','May 30, 2018 1:02 AM',55),
149 ('R3Q2: What instrument has the highest register in the brass family?','Oboe','0','0','Alpha Squad','-','May 30, 2018 1:02 AM',56),
150 ('R3Q2: What instrument has the highest register in the brass family?','Trumpet','0','0','Uncle mo','-','May 30, 2018 1:02 AM',57),
151 ('R3Q3: Who is said to have devised his theory of gravity while watching an apple fall from a tree?','Issac Newton','3','40','Keepem Coming','-','May 30, 2018 1:03 AM',58),
152 ('R3Q3: Who is said to have devised his theory of gravity while watching an apple fall from a tree?','Issac Newton','3','20','Alpha Squad','-','May 30, 2018 1:03 AM',59),
153 ('R3Q3: Who is said to have devised his theory of gravity while watching an apple fall from a tree?','Issac Newton','3','0','Uncle mo','-','May 30, 2018 1:03 AM',60),
154 ('R3Q3: Who is said to have devised his theory of gravity while watching an apple fall from a tree?','Issac Newton','3','0','Fortnite','-','May 30, 2018 1:04 AM',61),
155 ('R3Q4: Whats the speed limit of a school zone in MA?','20 mph','3','60','Fortnite','-','May 30, 2018 1:06 AM',62),
156 ('R3Q4: Whats the speed limit of a school zone in MA?','20 mph','3','40','Keepem Coming','-','May 30, 2018 1:06 AM',63),
157 ('R3Q4: Whats the speed limit of a school zone in MA?','20 mph','3','20','Uncle mo','-','May 30, 2018 1:06 AM',64),
158 ('R3Q4: Whats the speed limit of a school zone in MA?','25 MPH','0','0','Alpha Squad','-','May 30, 2018 1:06 AM',65),
159 ('R3Q5: Which famous 80s cartoon mouse is this?','Danger Mouse','0','0','Fortnite','-','May 30, 2018 1:09 AM',66),
160 ('R3Q5: Which famous 80s cartoon mouse is this?','Danger Mouse','0','0','Keepem Coming','-','May 30, 2018 1:09 AM',67),
161 ('R3Q6: Which Amendment protects us from unreasonable searches and seizures?','4th Amendment','3','20','Keepem Coming','-','May 30, 2018 1:11 AM',68),
162 ('R3Q6: Which Amendment protects us from unreasonable searches and seizures?','4th Amendment','3','0','Alpha Squad','-','May 30, 2018 1:11 AM',69),
163 ('R3Q6: Which Amendment protects us from unreasonable searches and seizures?','4th Amendment','3','0','Fortnite','-','May 30, 2018 1:11 AM',70),
164 ('R3Q6: Which Amendment protects us from unreasonable searches and seizures?','Third','0','0','Uncle mo','-','May 30, 2018 1:12 AM',71),
165 ('AV2: Study the Scene . . .','Tombstone','0','0','Fortnite','-','May 30, 2018 1:13 AM',72),
166 ('AV2: Study the Scene . . .','Kevin Costner','0','0','Keepem Coming','-','May 30, 2018 1:16 AM',73),
167 ('AV2: Study the Scene . . .','Kurt russel','0','0','Uncle mo','-','May 30, 2018 1:16 AM',74),
168 ('AV2: Study the Scene . . .','Kurt sitter','0','0','Alpha Squad','-','May 30, 2018 1:17 AM',75),
169 ('R4Q1: Who holds the world record for running the 100-meter dash in 9:58 seconds?','Usain Bolt','3','60','Keepem Coming','-','May 30, 2018 1:18 AM',76),
170 ('R4Q1: Who holds the world record for running the 100-meter dash in 9:58 seconds?','Usain Bolt','0','0','Alpha Squad','-','May 30, 2018 1:19 AM',77),
171 ('R4Q1: Who holds the world record for running the 100-meter dash in 9:58 seconds?','Usain Bolt','3','0','Fortnite','-','May 30, 2018 1:19 AM',78),
172 ('R4Q1: Who holds the world record for running the 100-meter dash in 9:58 seconds?','Usain Bolt','3','0','Uncle mo','-','May 30, 2018 1:19 AM',79),
173 ('R4Q2: What type of creature is Medusa?','I woman with snakes on her head','0','0','Uncle mo','-','May 30, 2018 1:20 AM',80),
174 ('R4Q2: What type of creature is Medusa?','Silica','0','0','Keepem Coming','-','May 30, 2018 1:21 AM',81),
175 ('R4Q2: What type of creature is Medusa?','Serpant ?','0','0','Fortnite','-','May 30, 2018 1:21 AM',82),
176 ('R4Q2: What type of creature is Medusa?','Jellyfish','0','0','Alpha Squad','-','May 30, 2018 1:21 AM',83),
177 ('R4Q3: In addition to Neil Armstrong and Michael Collins, who was the third member of the moon bound Apollo 11?','Buzz Aldrin','3','20','Alpha Squad','-','May 30, 2018 1:22 AM',84),
178 ('R4Q3: In addition to Neil Armstrong and Michael Collins, who was the third member of the moon bound Apollo 11?','Buzz Aldrin','0','0','Keepem Coming','-','May 30, 2018 1:22 AM',85),
179 ('R4Q3: In addition to Neil Armstrong and Michael Collins, who was the third member of the moon bound Apollo 11?','Buzz Aldrin','0','0','Fortnite','-','May 30, 2018 1:22 AM',86),
180 ('R4Q4: Whats the Roman numeral for 500?','D','3','40','Keepem Coming','-','May 30, 2018 1:25 AM',87),
181 ('R4Q4: Whats the Roman numeral for 500?','D','3','20','Fortnite','-','May 30, 2018 1:25 AM',88),
182 ('R4Q4: Whats the Roman numeral for 500?','D','0','0','Alpha Squad','-','May 30, 2018 1:26 AM',89),
183 ('R4Q5: Name this famous yo-yo trick.','Rock the Baby','3','60','Alpha Squad','-','May 30, 2018 1:27 AM',90),
184 ('R4Q5: Name this famous yo-yo trick.','Trapeze','0','0','Keepem Coming','-','May 30, 2018 1:28 AM',91),
185 ('R4Q5: Name this famous yo-yo trick.','Pendulum','0','0','Fortnite','-','May 30, 2018 1:29 AM',92),
186 ('R4Q6: Name this superhero:','Captain Marvel','3','60','Fortnite','-','May 30, 2018 1:30 AM',93),
187 ('R4Q6: Name this superhero:','Supergirl','0','0','Keepem Coming','-','May 30, 2018 1:31 AM',94),
188 ('R4Q6: Name this superhero:','Captain Marvel','0','0','Alpha Squad','-','May 30, 2018 1:32 AM',95),
189 ('The Equalizer: In a standard deck of playing cards, the king of hearts, spades and clubs are all pictured with a sword. What is the king of diamonds pictured with?','Staff','-20','0','Keepem Coming','-','May 30, 2018 1:37 AM',96),
190 ('The Equalizer: In a standard deck of playing cards, the king of hearts, spades and clubs are all pictured with a sword. What is the king of diamonds pictured with?','An axe','20','0','Alpha Squad','-','May 30, 2018 1:38 AM',97),
191 ('The Equalizer: In a standard deck of playing cards, the king of hearts, spades and clubs are all pictured with a sword. What is the king of diamonds pictured with?','Nothing ','-20','0','Fortnite','-','May 30, 2018 1:38 AM',98);
192
193/*!40000 ALTER TABLE `questions` ENABLE KEYS */;
194UNLOCK TABLES;
195
196/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
197/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
198/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
199/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
200/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
201/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;