-- http://www.phpmyadmin.net
--




--
-- Database: `serious`
--

-- --------------------------------------------------------

--
-- Table structure for table `quiz_choices`
--

CREATE TABLE IF NOT EXISTS `quiz_choices` (
  `quiz_choice_id` int(11) NOT NULL auto_increment,
  `quiz_question_id` int(11) NOT NULL,
  `choice` text NOT NULL,
  `choice_id` smallint(6) NOT NULL,
  PRIMARY KEY  (`quiz_choice_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;

--
-- Dumping data for table `quiz_choices`
--

INSERT INTO `quiz_choices` (`quiz_choice_id`, `quiz_question_id`, `choice`, `choice_id`) VALUES
(1, 1, 'Jupiter', 1),
(2, 1, 'Earth', 2),
(3, 1, 'Venus', 3),
(4, 1, 'Neptune', 4),
(5, 2, 'Water', 1),
(6, 2, 'Carbon Dioxide', 2),
(7, 2, 'Oxygen', 3),
(8, 2, 'Helium', 4),
(9, 3, 'Isaac Newton', 1),
(10, 3, 'Stephen Hawking', 2),
(11, 3, 'Rube Goldberg', 3),
(12, 3, 'Albert Einstein', 4),
(13, 4, 'Neptune', 1),
(14, 4, 'Pluto', 2),
(15, 4, 'Saturn', 3),
(16, 4, 'Earth', 4),
(17, 5, 'Visible light', 1),
(18, 5, 'Microwaves', 2),
(19, 5, 'Infrared', 3),
(20, 5, 'Sound', 4),
(21, 6, 'True', 1),
(22, 6, 'False', 2),
(23, 7, 'Mars', 1),
(24, 7, 'Earth', 2),
(25, 7, 'Saturn', 3),
(26, 7, 'Neptune', 4),
(27, 7, 'There are fewer than 4 planets in our solar system', 5),
(28, 8, 'Feet/minute', 1),
(29, 8, 'Centimeters/Hour^2', 2),
(30, 8, 'Meters/second', 3),
(31, 8, 'Nautical miles', 4),
(32, 9, 'Trees', 1),
(33, 9, 'Metal', 2),
(34, 9, 'Oil', 3),
(35, 9, 'Animal byproducts', 4),
(36, 10, 'Fruits and vegetables', 1),
(37, 10, 'Beef and pork', 2),
(38, 10, 'Fish and shellfish', 3),
(39, 10, 'Milk and dairy', 4),
(40, 11, 'Satellites are closer to the sun.', 1),
(41, 11, 'Satellites don''t have an atmosphere.', 2),
(42, 11, 'Satellites rotate faster than planets.', 3),
(43, 11, 'Satellites are not more efficient as solar collectors.', 4),
(44, 12, 'Neptune', 1),
(45, 12, 'Earth', 2),
(46, 12, 'Moon', 3),
(47, 12, 'Venus', 4);

-- --------------------------------------------------------

--
-- Table structure for table `quiz_questions`
--

CREATE TABLE IF NOT EXISTS `quiz_questions` (
  `quiz_question_id` int(11) NOT NULL auto_increment,
  `quiz_level` int(11) NOT NULL COMMENT 'Difficulty level.',
  `question_type` int(11) NOT NULL,
  `question` text NOT NULL,
  `answer_type` int(11) NOT NULL,
  `answer` text NOT NULL,
  `user_id` int(11) NOT NULL COMMENT 'ID of user who submitted this question.',
  `important` tinyint(1) NOT NULL default '0' COMMENT 'If true, question will be repeated to users who get the question correct.',
  PRIMARY KEY  (`quiz_question_id`),
  KEY `quiz_level` (`quiz_level`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `quiz_questions`
--

INSERT INTO `quiz_questions` (`quiz_question_id`, `quiz_level`, `question_type`, `question`, `answer_type`, `answer`, `user_id`, `important`) VALUES
(1, 0, 0, 'Which of the following planets is closest to the sun?', 0, '3', 0, 0),
(2, 0, 0, 'Which of the following is a potential source of hydrogen?', 0, '1', 0, 0),
(3, 0, 0, 'What famous scientist developed the theory of relativity?', 0, '4', 0, 0),
(4, 0, 0, 'Which of the following has an irregular orbit?', 0, '2', 0, 0),
(5, 0, 0, 'Which does NOT travel through empty space?', 0, '4', 0, 0),
(6, 0, 0, 'The word "satellite" refers only to man-made objects.', 0, '2', 0, 0),
(7, 0, 0, 'What is the fourth planet from the sun?', 0, '1', 0, 0),
(8, 0, 0, 'The gravitational constant can be measured in:', 0, '2', 0, 0),
(9, 0, 0, 'What is plastic made from?', 0, '3', 0, 0),
(10, 0, 0, 'Which type of food requires less energy to produce?', 0, '1', 0, 0),
(11, 0, 0, 'What''s the primary reason solar collectors are more efficient on satellites than on planetary surfaces?', 0, '2', 0, 0),
(12, 0, 0, 'Which planetary body does NOT orbit on the same plane?', 0, '3', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `quiz_questions_answered`
--

CREATE TABLE IF NOT EXISTS `quiz_questions_answered` (
  `quiz_question_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `was_correct` tinyint(1) NOT NULL,
  KEY `quiz_question_id` (`quiz_question_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `quiz_questions_answered`
--

INSERT INTO `quiz_questions_answered` (`quiz_question_id`, `user_id`, `was_correct`) VALUES
(12, 1, 1),
(10, 1, 0),
(5, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `teams`
--

CREATE TABLE IF NOT EXISTS `teams` (
  `team_id` int(11) NOT NULL auto_increment,
  `teamname` varchar(16) NOT NULL,
  `color` int(11) NOT NULL default '0',
  UNIQUE KEY `team_id` (`team_id`),
  KEY `teamname` (`teamname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `teams`
--

INSERT INTO `teams` (`team_id`, `teamname`, `color`) VALUES
(0, 'None', 0);
