CREATE TABLE `auctionhouse` ( `id` INT(10) UNSIGNED NOT NULL DEFAULT '0', `auctioneerguid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `itemguid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `itemowner` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `buyoutprice` INT(10) UNSIGNED NOT NULL DEFAULT '0', `time` INT(10) UNSIGNED NOT NULL DEFAULT '0', `buyguid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `lastbid` INT(10) UNSIGNED NOT NULL DEFAULT '0', `startbid` INT(10) UNSIGNED NOT NULL DEFAULT '0', `deposit` INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE INDEX `item_guid` (`itemguid`) ) COLLATE='utf8_general_ci' ENGINE=InnoDB ;