item_auction.sql 374 B

123456789
  1. CREATE TABLE IF NOT EXISTS `item_auction` (
  2. `auctionId` int(11) NOT NULL,
  3. `instanceId` int(11) NOT NULL,
  4. `auctionItemId` int(11) NOT NULL,
  5. `startingTime` bigint(13) unsigned NOT NULL DEFAULT '0',
  6. `endingTime` bigint(13) unsigned NOT NULL DEFAULT '0',
  7. `auctionStateId` tinyint(1) NOT NULL,
  8. PRIMARY KEY (`auctionId`)
  9. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;