USE `econexperiments2`;

--
-- Table structure for table `publicgoodexpdata`
--

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

CREATE TABLE IF NOT EXISTS `econexperiments2`.`publicgoodexpdata` 
(
  `UniqID` int unsigned NOT NULL AUTO_INCREMENT,
  `ExperimentID` varchar(45) NOT NULL,
  `UserID` int unsigned NOT NULL,
  `TreatNum` int unsigned NOT NULL,
  `RoundNum` int unsigned NOT NULL,
  `TokensInvested` int unsigned NOT NULL,
  `Name` varchar(45) NOT NULL,
  `GroupNum` int unsigned NOT NULL DEFAULT '0',
  `PendingSubmit` int unsigned NOT NULL DEFAULT '0',
  `PunAllotted` int unsigned DEFAULT NULL,
  `PunPenalty` int unsigned DEFAULT NULL,
  `Earnings` decimal(5,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`UniqID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
