USE `econexperiments2`;

--
-- Table structure for table `bidask`
--

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

CREATE TABLE IF NOT EXISTS `econexperiments2`.`bidask` 
(
  `bidaskID` int NOT NULL AUTO_INCREMENT,
  `bidaskTime` datetime DEFAULT NULL,
  `bidaskType` int DEFAULT NULL,
  `bidaskPrice` float DEFAULT NULL,
  `bidaskInitialPrice` float DEFAULT NULL,
  `bidaskUserID` int DEFAULT NULL,
  `bidaskRoomID` varchar(255) DEFAULT NULL,
  `bidaskOpenTime` int DEFAULT NULL,
  `bidaskCloseTime` int DEFAULT NULL,
  `transactionPrice` float DEFAULT NULL,
  `transactionWithUserID` int DEFAULT NULL,
  `roundNumber` int DEFAULT NULL,
  `reservationPrice` float DEFAULT NULL,
  `active` tinyint DEFAULT '1',
  PRIMARY KEY (`bidaskID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

