--Using same users table from previous assignments
CREATE TABLE `users` (  
    `id` int(11) NOT NULL AUTO_INCREMENT,  
    `fname` VARCHAR(255) NOT NULL,  
    `email` VARCHAR(255) NOT NULL,  
    `username` VARCHAR(255) NOT NULL,  
    `password` VARCHAR(255) NOT NULL,
    PRIMARY KEY(`id`)
);

--Quiz 1 table
CREATE TABLE `quiz1` (
  `id` int(255) NOT NULL,
  `que` text NOT NULL,
  `option 1` varchar(222) NOT NULL,
  `option 2` varchar(222) NOT NULL,
  `option 3` varchar(222) NOT NULL,
  `option 4` varchar(222) NOT NULL,
  `ans` varchar(222) NOT NULL,
  `userans` text
);

INSERT INTO `quiz1` (`id`, `que`, `option 1`, `option 2`, `option 3`, `option 4`, `ans`, `userans`) VALUES
(1, 'What is the Hive Homeworld called? ', 'Fundament', 'Venus', 'Desolate', 'Cybertron', 'Fundament', 'Fundament'),
(2, 'Whose Ghost has the name Geppetto? ', 'Ikora Rey', 'The Drifter', 'Saint-14', 'Osiris', 'Saint-14', 'Saint-14'),
(3, 'Which activity does Lord Shaxx curate?', 'Strikes', 'Patrols', 'The Crucible', 'Iron Banner', 'The Crucible', 'The Crucible'),
(4, 'Who was Clovis Bray, and what did he do?', 'He was a Golden Age guardian who turned himself into a Servitor.', 'He was a Golden Age scientist who created the Deep Stone Crypt.', 'He was a Golden Age scientist who developed a way to harness the Light in man-made weaponry.', 'He was a Golden Age guardian who used the first recorded power of the Dark.', 'He was a Golden Age scientist who created the Deep Stone Crypt.', 'He was a Golden Age scientist who created the Deep Stone Crypt.'),
(5, 'The metal used to forge the Gjallarhorn came from broken armor found after which event?', 'The Battle of Six Fronts', 'The Great Disaster', 'The Battle of Twilight Gap', 'The Birth of the Last City', 'The Battle of Twilight Gap', 'The Battle of Twilight Gap'),
(6, 'Who kept the helmet on?', 'Saint-14', 'Osiris', 'Lord Shaxx', 'Mara Sov', 'Lord Shaxx', 'Lord Shaxx'),
(7, 'Who was Felwinter?', 'The Titan who led the remaining civilization to build the Last City.', 'The Hero of Twilight Gap.', 'An Iron Lord Warlock, who was the physical embodiement of the Warmind, Rasputin.', 'Your mom.', 'An Iron Lord Warlock, who was the physical embodiement of the Warmind, Rasputin.', 'An Iron Lord Warlock, who was the physical embodiement of the Warmind, Rasputin.'),
(8, 'Which Guardian died in their first life from drowning?', 'Zavala', 'Asher Mir', 'Osiris', 'Eris Morn', 'Eris Morn', 'Eris Morn'),
(9, 'Who was the character that killed Cayde-6?', 'Himself', 'Petra Venj', 'Uldren Sov', 'Osiris', 'Uldren Sov', 'Uldren Sov'),
(10, 'Who created the Gjallarhorn?', 'Lord Shaxx', 'Vell Tarlowe', 'Feizel Crux', 'Ana Bray', 'Feizel Crux','Feizel Crux');

CREATE TABLE `quiz2` (
  `id` int(255) NOT NULL,
  `que` text NOT NULL,
  `option 1` varchar(222) NOT NULL,
  `option 2` varchar(222) NOT NULL,
  `option 3` varchar(222) NOT NULL,
  `option 4` varchar(222) NOT NULL,
  `ans` varchar(222) NOT NULL,
  `userans` text
);

INSERT INTO `quiz2` (`id`, `que`, `option 1`, `option 2`, `option 3`, `option 4`, `ans`, `userans`) VALUES
(1, 'Chronologically, who was the first Super Saiyan?', 'Goku', 'Trunks', 'Bardock', 'King Vegeta', 'Bardock', 'Bardock'),
(2, 'Who has Goku, alone, never beaten in combat?', 'Yakon', 'Piccolo', 'Vegeta', 'Krillin', 'Vegeta', 'Vegeta'),
(3, 'Who almost killed Videl in the World Tounament?', 'Yakon', 'Spopovic', 'Android 18', 'Pui-pui', 'Spopovic', 'Spopovic'),
(4, 'Which member from the original Dragon Ball Squad is no longer in the anime?', 'Oolong', 'Puar', 'Launch', 'Chaiotzu', 'Launch', 'Launch'),
(5, 'What was the inspiration behind the Frieza/Namek arc?', 'Superman', 'Star Wars', 'Lord of the Flies', 'Green Lantern', 'Star Wars', 'Star Wars'),
(6, 'Who gave Trunks his sword?', 'Tapion', 'Vegeta', 'Kibito', 'No one, he created it', 'Tapion', 'Tapion'),
(7, 'What year did Dragon Ball Z first air in the US?', '1996', '1995', '1994', '1989', '1995', '1995'),
(8, 'How many of the Z-Fighters have never died?', '0', '1', '2', '3', '1', '1'),
(9, 'What were Android 17 and 18s real names?', 'Shu and Mai', 'Maloja and Marron', 'Lapis and Lazuli', 'Arame and Arale', 'Lapis and Lazuli', 'Lapis and Lazuli'),
(10, 'How many stars were on the Dragon Ball Gohan had on his hat as a child?', 'One', 'Two', 'Four', 'Seven', 'Four','Four');

CREATE TABLE `quiz3` (
  `id` int(255) NOT NULL,
  `que` text NOT NULL,
  `option 1` varchar(222) NOT NULL,
  `option 2` varchar(222) NOT NULL,
  `option 3` varchar(222) NOT NULL,
  `option 4` varchar(222) NOT NULL,
  `ans` varchar(222) NOT NULL,
  `userans` text
);

INSERT INTO `quiz3` (`id`, `que`, `option 1`, `option 2`, `option 3`, `option 4`, `ans`, `userans`) VALUES
(1, 'How many bolts did the Harbinger cost in Deadlocked?', '1 million', '2 million', '5 million', '10 million', '2 million', '2 million'),
(2, 'In which game did the Winterizor first appear?', 'Deadlocked', 'Secret Agent Clank', 'Quest for Booty', 'Into the Nexus', 'Into the Nexus', 'Into the Nexus'),
(3, 'What planet does Ratchet first meet Captain Qwark?', 'Rilgar', 'Veldin', 'Orxon', 'Umbris', 'Rilgar', 'Rilgar'),
(4, 'What species is Ratchet?', 'Termite', 'Markazian', 'Blarg', 'Lombax', 'Lombax', 'Lombax'),
(5, 'In the third game, what animal does Captain Qwark think he has turned into?', 'Rat', 'Blargian Snagglebeast', 'Monkey', 'Bird', 'Monkey', 'Monkey'),
(6, 'His first appearance, Ratchet is said to be from planet Veldin, but where is he actually from?', 'Sargasso', 'Fastoon', 'Kortog', 'Quackton VIII', 'Fastoon', 'Fastoon'),
(7, 'In Quest for Booty, who helps Ratchet find Clank?', 'Zephyr', 'Cronk', 'Captain Qwark', 'Talwyn', 'Talwyn', 'Talwyn'),
(8, 'Which game has the Plumber NOT been in?', 'Deadlocked', 'All 4 One', 'Quest for Booty', 'Ratchet and Clank (2016)', 'Deadlocked', 'Deadlocked'),
(9, 'What is the name of the robot that Dr. Nefarious gives to the robot made to replace Clank?', 'Clamp', 'Klank', 'Klunk', 'Klump', 'Klunk', 'Klunk'),
(10, 'What is the name of Dr. Nefarious butler?', 'Ratchet', 'Sasha', 'AI', 'Lawrence', 'Lawrence','Lawrence');

CREATE TABLE `quiz4` (
  `id` int(255) NOT NULL,
  `que` text NOT NULL,
  `option 1` varchar(222) NOT NULL,
  `option 2` varchar(222) NOT NULL,
  `option 3` varchar(222) NOT NULL,
  `option 4` varchar(222) NOT NULL,
  `ans` varchar(222) NOT NULL,
  `userans` text
);

INSERT INTO `quiz4` (`id`, `que`, `option 1`, `option 2`, `option 3`, `option 4`, `ans`, `userans`) VALUES
(1, 'How many magic rings are there in Middle-Earth?', '12', '17', '3', '20', '20', '20'),
(2, 'How many Wizards were sent to Middle-Earth?', 'Seven', 'Two', 'Five', 'Ten', 'Five', 'Five'),
(3, 'Who was Aragorns father?', 'Isildir', 'Gimli', 'Valandil', 'Arathorn', 'Arathorn', 'Arathorn'),
(4, 'What gifts did Lady Galadriel give to Boromir?', 'The One Ring and a Sword', 'A Golden Belt and Elven Cloak', 'A Horn and The One Ring', 'An Iron Sword and Elven Shield', 'A Golden Belt and Elven Cloak', 'A Golden Belt and Elven Cloak'),
(5, 'How many years did Frodo hide the One Ring?', '10 years', '17 years', '20 years', '33 years', '17 years', '17 years'),
(6, 'What is the canonical name for the Lothlórien people?', 'Noldor', 'Sinadrin', 'Uruk', 'Galadhrim', 'Galadhrim', 'Galadhrim'),
(7, 'How did Frodos parents die?', 'Gollum strangled them', 'They died from overeating at a great feast', 'They drowned during a boating accident', 'Sauron had them executed', 'They drowned during a boating accident', 'They drowned during a boating accident'),
(8, 'Which event led to the destruction of Númenor?', 'Númenóreans were willing to forge a new Ring of Power', 'Númenóreans planned to exterminate the Elven', 'Númenóreans tried resisting Saurons army', 'Númenóreans tried to sail to the Undying Lands', 'Númenóreans tried to sail to the Undying Lands', 'Númenóreans tried to sail to the Undying Lands'),
(9, 'What is the other name for Azanulbizars Battle?', 'The Battle of Moria', 'The Battle of Mina Ithil', 'The Battle of the Two Towers', 'The Battle of the Five Armies', 'The Battle of Moria', 'The Battle of Moria'),
(10, 'How did Dwarves come into the world?', 'They had always been there', 'They came out of the hearth of the mountains', 'They sailed from the island of Valinor', 'They were made by the Valar Aulë', 'They were made by the Valar Aulë','They were made by the Valar Aulë');