Untitled

# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.7.22-0ubuntu0.16.04.1)
# Database: challengetrivia
# Generation Time: 2018-05-30 15:13:04 +0000
# ************************************************************


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Dump of table answers
# ------------------------------------------------------------

DROP TABLE IF EXISTS `answers`;

CREATE TABLE `answers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question_number` varchar(20) NOT NULL,
  `correct_answer` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

LOCK TABLES `answers` WRITE;
/*!40000 ALTER TABLE `answers` DISABLE KEYS */;

INSERT INTO `answers` (`id`, `question_number`, `correct_answer`)
VALUES
    (1,'R1Q1','McDonalds'),
    (2,'R1Q2','The Wall'),
    (3,'R1Q3','Rorschach'),
    (4,'R1Q4','Nike'),
    (5,'R1Q5','Treasure Island'),
    (6,'R1Q6','Munich'),
    (7,'AV1:','The Wicker Man'),
    (8,'R2Q1','Green Bay Packers'),
    (9,'R2Q2','Ramsay Bolton'),
    (10,'R2Q3','Resource Location'),
    (11,'R2Q4','Ashton Kutcher'),
    (12,'R2Q5','Ontario'),
    (13,'R2Q6','Kareem Abdul-Jabbar'),
    (14,'R3Q1','Chicago'),
    (15,'R3Q2','Trumpet'),
    (16,'R3Q3','Isaac Newton'),
    (17,'R3Q4','20 mph'),
    (18,'R3Q5','Danger Mouse'),
    (19,'R3Q6','4th Amendment'),
    (20,'AV2:','Jason Priestley'),
    (21,'R4Q1','Usain Bolt'),
    (22,'R4Q2','A Gorgon'),
    (23,'R4Q3','Buzz Aldrin'),
    (24,'R4Q4','D'),
    (25,'R4Q5','Rock the Baby'),
    (26,'R4Q6','Captain Marvel'),
    (27,'The ','An axe');

/*!40000 ALTER TABLE `answers` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table questions
# ------------------------------------------------------------

DROP TABLE IF EXISTS `questions`;

CREATE TABLE `questions` (
  `question` varchar(200) NOT NULL,
  `answer` varchar(100) NOT NULL,
  `correct` varchar(3) NOT NULL,
  `points_awarded` varchar(4) NOT NULL,
  `player_name` varchar(50) NOT NULL,
  `player_email` varchar(50) NOT NULL,
  `answer_time` varchar(50) NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

LOCK TABLES `questions` WRITE;
/*!40000 ALTER TABLE `questions` DISABLE KEYS */;

INSERT INTO `questions` (`question`, `answer`, `correct`, `points_awarded`, `player_name`, `player_email`, `answer_time`, `id`)
VALUES
    ('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),
    ('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),
    ('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),
    ('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),
    ('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),
    ('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),
    ('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),
    ('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),
    ('R1Q3: This image is an example of what famous psychological test?','Rorschach','3','80','Fortnite','-','May 30, 2018 12:11 AM',9),
    ('R1Q3: This image is an example of what famous psychological test?','Rorschach','3','40','Uncle mo','-','May 30, 2018 12:11 AM',10),
    ('R1Q3: This image is an example of what famous psychological test?','Rorschach','3','20','Alpha Squad','-','May 30, 2018 12:11 AM',11),
    ('R1Q3: This image is an example of what famous psychological test?','Rorschach','3','0','Keepem Coming','-','May 30, 2018 12:12 AM',12),
    ('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),
    ('R1Q4: What famous footwear company was founded in 1964 as Blue-Ribbon Sports?','Nike','0','0','Fortnite','-','May 30, 2018 12:14 AM',14),
    ('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),
    ('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),
    ('R1Q5: This is the cover of what book?','Treasure Island','0','0','Alpha Squad','-','May 30, 2018 12:17 AM',17),
    ('R1Q5: This is the cover of what book?','Treasure Island','0','0','Keepem Coming','-','May 30, 2018 12:17 AM',18),
    ('R1Q5: This is the cover of what book?','Treasure Island','0','0','Uncle mo','-','May 30, 2018 12:17 AM',19),
    ('R1Q5: This is the cover of what book?','Treasure Island','0','0','Fortnite','-','May 30, 2018 12:17 AM',20),
    ('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),
    ('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),
    ('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),
    ('R1Q6: Which of these Steven Spielberg films did Tom Hanks NOT appear in:','Munich','0','0','Fortnite','-','May 30, 2018 12:19 AM',24),
    ('AV1: What movie is this Cage Clip from?','The Wicker Man','3','0','Alpha Squad','-','May 30, 2018 12:22 AM',25),
    ('AV1: What movie is this Cage Clip from?','Dont know','0','0','Uncle mo','-','May 30, 2018 12:22 AM',26),
    ('AV1: What movie is this Cage Clip from?','The Wicker Man','3','0','Keepem Coming','-','May 30, 2018 12:23 AM',27),
    ('R2Q1: What NFL team won the first 2 Super Bowls?','Green Bay Packers','3','80','Fortnite','-','May 30, 2018 12:25 AM',28),
    ('R2Q1: What NFL team won the first 2 Super Bowls?','Green Bay Packers','3','40','Keepem Coming','-','May 30, 2018 12:25 AM',29),
    ('R2Q1: What NFL team won the first 2 Super Bowls?','Green Bay Packers','3','20','Uncle mo','-','May 30, 2018 12:25 AM',30),
    ('R2Q1: What NFL team won the first 2 Super Bowls?','Green Bay Packers','0','0','Alpha Squad','-','May 30, 2018 12:26 AM',31),
    ('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),
    ('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),
    ('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),
    ('R2Q3: URL in computing stands for Uniform ________  ________','Resource Location','3','0','Keepem Coming','-','May 30, 2018 12:31 AM',35),
    ('R2Q3: URL in computing stands for Uniform ________  ________','Resource Location','3','0','Alpha Squad','-','May 30, 2018 12:31 AM',36),
    ('R2Q3: URL in computing stands for Uniform ________  ________','Resource Location','3','0','Fortnite','-','May 30, 2018 12:32 AM',37),
    ('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),
    ('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),
    ('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),
    ('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),
    ('R2Q5: With almost 14 million residents, what is Canadas most populated province?','Ontario','3','80','Alpha Squad','-','May 30, 2018 12:36 AM',42),
    ('R2Q5: With almost 14 million residents, what is Canadas most populated province?','Quebec','0','0','Fortnite','-','May 30, 2018 12:36 AM',43),
    ('R2Q5: With almost 14 million residents, what is Canadas most populated province?','Ontario','0','0','Keepem Coming','-','May 30, 2018 12:36 AM',44),
    ('R2Q5: With almost 14 million residents, what is Canadas most populated province?','Quebec','0','0','Uncle mo','-','May 30, 2018 12:37 AM',45),
    ('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),
    ('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),
    ('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),
    ('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),
    ('R3Q1: The ferris wheel debuted at the 1893 Worlds Fair in what city?','Chicago','0','0','Fortnite','-','May 30, 2018 12:58 AM',50),
    ('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),
    ('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),
    ('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),
    ('R3Q2: What instrument has the highest register in the brass family?','Trumpet','0','0','Keepem Coming','-','May 30, 2018 1:02 AM',54),
    ('R3Q2: What instrument has the highest register in the brass family?','Trumpet','0','0','Fortnite','-','May 30, 2018 1:02 AM',55),
    ('R3Q2: What instrument has the highest register in the brass family?','Oboe','0','0','Alpha Squad','-','May 30, 2018 1:02 AM',56),
    ('R3Q2: What instrument has the highest register in the brass family?','Trumpet','0','0','Uncle mo','-','May 30, 2018 1:02 AM',57),
    ('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),
    ('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),
    ('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),
    ('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),
    ('R3Q4: Whats the speed limit of a school zone in MA?','20 mph','3','60','Fortnite','-','May 30, 2018 1:06 AM',62),
    ('R3Q4: Whats the speed limit of a school zone in MA?','20 mph','3','40','Keepem Coming','-','May 30, 2018 1:06 AM',63),
    ('R3Q4: Whats the speed limit of a school zone in MA?','20 mph','3','20','Uncle mo','-','May 30, 2018 1:06 AM',64),
    ('R3Q4: Whats the speed limit of a school zone in MA?','25 MPH','0','0','Alpha Squad','-','May 30, 2018 1:06 AM',65),
    ('R3Q5: Which famous 80s cartoon mouse is this?','Danger Mouse','0','0','Fortnite','-','May 30, 2018 1:09 AM',66),
    ('R3Q5: Which famous 80s cartoon mouse is this?','Danger Mouse','0','0','Keepem Coming','-','May 30, 2018 1:09 AM',67),
    ('R3Q6: Which Amendment protects us from unreasonable searches and seizures?','4th Amendment','3','20','Keepem Coming','-','May 30, 2018 1:11 AM',68),
    ('R3Q6: Which Amendment protects us from unreasonable searches and seizures?','4th Amendment','3','0','Alpha Squad','-','May 30, 2018 1:11 AM',69),
    ('R3Q6: Which Amendment protects us from unreasonable searches and seizures?','4th Amendment','3','0','Fortnite','-','May 30, 2018 1:11 AM',70),
    ('R3Q6: Which Amendment protects us from unreasonable searches and seizures?','Third','0','0','Uncle mo','-','May 30, 2018 1:12 AM',71),
    ('AV2: Study the Scene . . .','Tombstone','0','0','Fortnite','-','May 30, 2018 1:13 AM',72),
    ('AV2: Study the Scene . . .','Kevin Costner','0','0','Keepem Coming','-','May 30, 2018 1:16 AM',73),
    ('AV2: Study the Scene . . .','Kurt russel','0','0','Uncle mo','-','May 30, 2018 1:16 AM',74),
    ('AV2: Study the Scene . . .','Kurt sitter','0','0','Alpha Squad','-','May 30, 2018 1:17 AM',75),
    ('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),
    ('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),
    ('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),
    ('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),
    ('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),
    ('R4Q2: What type of creature is Medusa?','Silica','0','0','Keepem Coming','-','May 30, 2018 1:21 AM',81),
    ('R4Q2: What type of creature is Medusa?','Serpant ?','0','0','Fortnite','-','May 30, 2018 1:21 AM',82),
    ('R4Q2: What type of creature is Medusa?','Jellyfish','0','0','Alpha Squad','-','May 30, 2018 1:21 AM',83),
    ('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),
    ('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),
    ('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),
    ('R4Q4: Whats the Roman numeral for 500?','D','3','40','Keepem Coming','-','May 30, 2018 1:25 AM',87),
    ('R4Q4: Whats the Roman numeral for 500?','D','3','20','Fortnite','-','May 30, 2018 1:25 AM',88),
    ('R4Q4: Whats the Roman numeral for 500?','D','0','0','Alpha Squad','-','May 30, 2018 1:26 AM',89),
    ('R4Q5: Name this famous yo-yo trick.','Rock the Baby','3','60','Alpha Squad','-','May 30, 2018 1:27 AM',90),
    ('R4Q5: Name this famous yo-yo trick.','Trapeze','0','0','Keepem Coming','-','May 30, 2018 1:28 AM',91),
    ('R4Q5: Name this famous yo-yo trick.','Pendulum','0','0','Fortnite','-','May 30, 2018 1:29 AM',92),
    ('R4Q6: Name this superhero:','Captain Marvel','3','60','Fortnite','-','May 30, 2018 1:30 AM',93),
    ('R4Q6: Name this superhero:','Supergirl','0','0','Keepem Coming','-','May 30, 2018 1:31 AM',94),
    ('R4Q6: Name this superhero:','Captain Marvel','0','0','Alpha Squad','-','May 30, 2018 1:32 AM',95),
    ('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),
    ('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),
    ('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);

/*!40000 ALTER TABLE `questions` ENABLE KEYS */;
UNLOCK TABLES;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;