USE `econexperiments2`;

--
-- Table structure for table `publicgoodparticipant`
--

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

CREATE TABLE IF NOT EXISTS `econexperiments2`.`publicgoodparticipant` 
(
  `UniqueID` int unsigned NOT NULL AUTO_INCREMENT,
  `ExperimentID` varchar(45) NOT NULL,
  `UserID` int unsigned NOT NULL,
  `CumulativeEarnings` decimal(5,2) NOT NULL,
  `GroupNum` int unsigned NOT NULL,
  `Status` varchar(45) NOT NULL DEFAULT 'dormant',
  `PPtsTreat1Allotted` int unsigned NOT NULL DEFAULT '0',
  `PPtsTreat1Penalty` int unsigned NOT NULL DEFAULT '0',
  `PPtsTreat2Allotted` int unsigned NOT NULL DEFAULT '0',
  `PPtsTreat2Penalty` int unsigned NOT NULL DEFAULT '0',
  `PPtsTreat3Allotted` int unsigned NOT NULL DEFAULT '0',
  `PPtsTreat3Penalty` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`UniqueID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

