USE `econexperiments2`;

--
-- Table structure for table `tempAsyncResults`
--

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

CREATE TABLE IF NOT EXISTS `econexperiments2`.`tempAsyncResults` 
(
  `id` int NOT NULL AUTO_INCREMENT,
  `startDate` timestamp NULL DEFAULT NULL,
  `updatedDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `pearsonUserID` varchar(255) DEFAULT NULL,
  `isEducator` tinyint DEFAULT NULL,
  `variant` varchar(10) DEFAULT NULL,
  `courseID` varchar(511) DEFAULT NULL,
  `fullName` varchar(255) DEFAULT NULL,
  `roundNumber` int DEFAULT NULL,
  `isCompleted` tinyint NOT NULL DEFAULT '0',
  `restoreData` mediumtext,
  `miscInfo` mediumtext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=101722 DEFAULT CHARSET=latin1;

