USE `econexperiments2`;

--
-- Table structure for table `asyncResults`
--

-- DROP TABLE IF EXISTS `econexperiments2`.`asyncResults`;
CREATE TABLE IF NOT EXISTS `econexperiments2`.`asyncResults` 
(
  `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,
  `role` varchar(10) DEFAULT NULL,
  `wtp` varchar(10) DEFAULT NULL,
  `cost` varchar(10) DEFAULT NULL,
  `bid` varchar(10) DEFAULT NULL,
  `ask` varchar(10) DEFAULT NULL,
  `transactionPrice` varchar(10) DEFAULT NULL,
  `actualGain` varchar(10) DEFAULT NULL,
  `eqPrice` varchar(10) DEFAULT NULL,
  `potentialGain` varchar(10) DEFAULT NULL,
  `relativeGain` varchar(255) DEFAULT NULL,
  `participation` varchar(11) DEFAULT NULL,
  `score` float DEFAULT NULL,
  `extra` varchar(10) DEFAULT NULL,
  `restoreData` mediumtext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=537068 DEFAULT CHARSET=latin1;

