USE `econexperiments2`;

--
-- Table structure for table `publicgoodexpsettings`
--

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

CREATE TABLE IF NOT EXISTS `econexperiments2`.`publicgoodexpsettings` 
(
  `UniqID` int unsigned NOT NULL AUTO_INCREMENT,
  `ExperimentID` varchar(45) NOT NULL,
  `ExperimentTitle` varchar(45) DEFAULT NULL,
  `CourseID` varchar(45) DEFAULT NULL,
  `ClassSize` int unsigned DEFAULT NULL,
  `GroupSize` int unsigned DEFAULT NULL,
  `NumOfTreatments` int unsigned DEFAULT NULL,
  `Treat1NumRounds` int unsigned DEFAULT NULL,
  `Treat1PunPoints` int unsigned DEFAULT NULL,
  `Treat1CostToReceive` decimal(5,2) DEFAULT NULL,
  `Treat1CostToSend` decimal(5,2) DEFAULT NULL,
  `Treat2NumRounds` int unsigned DEFAULT NULL,
  `Treat2PunPoints` int unsigned DEFAULT NULL,
  `Treat2CostToReceive` decimal(5,2) DEFAULT NULL,
  `Treat2CostToSend` decimal(5,2) DEFAULT NULL,
  `Treat3NumRounds` int unsigned DEFAULT NULL,
  `Treat3PunPoints` int unsigned DEFAULT NULL,
  `Treat3CostToReceive` decimal(5,2) DEFAULT NULL,
  `Treat3CostToSend` decimal(5,2) DEFAULT NULL,
  PRIMARY KEY (`UniqID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

