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;

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;