USE `econexperiments2`;


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

CREATE TABLE IF NOT EXISTS `econexperiments2`.`asyncAssessmentSummaries` 
(
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `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,
  `active` tinyint DEFAULT NULL,
  `summary` text,
  `score` float DEFAULT NULL,
  `relativeGains` float DEFAULT NULL,
  `possiblePoints` float DEFAULT NULL,
  `useScale` tinyint(1) DEFAULT NULL,
  `adjustedRelativeGain` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) 
ENGINE=MyISAM AUTO_INCREMENT=55513 DEFAULT CHARSET=latin1;

