USE `econexperiments2`;

--
-- Table structure for table `asyncResultsLemons`
--

-- DROP TABLE IF EXISTS `econexperiments2`.`asyncResultsLemons`;

CREATE TABLE IF NOT EXISTS `econexperiments2`.`asyncResultsLemons` 
(
  `id` int NOT NULL AUTO_INCREMENT,
  `active` tinyint NOT NULL DEFAULT '1',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `pearsonUserID` varchar(255) DEFAULT NULL,
  `isEducator` tinyint DEFAULT NULL,
  `variant` varchar(10) DEFAULT NULL,
  `courseID` varchar(511) DEFAULT NULL,
  `resultID` varchar(255) DEFAULT NULL,
  `attemptID` int DEFAULT NULL,
  `attemptMode` varchar(50) DEFAULT NULL,
  `roundNumber` int DEFAULT NULL,
  `fullName` varchar(255) DEFAULT NULL,
  `extra` varchar(10) DEFAULT NULL,
  `restoreData` mediumtext,
  `score` float DEFAULT NULL,
  `relativeGains` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13842 DEFAULT CHARSET=latin1;
