From Thundering Motmot, 1 Year ago, written in Plain Text.
Embed
  1. CREATE TABLE `auctionhouse` (
  2.         `id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  3.         `auctioneerguid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  4.         `itemguid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  5.         `itemowner` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  6.         `buyoutprice` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  7.         `time` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  8.         `buyguid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  9.         `lastbid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  10.         `startbid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  11.         `deposit` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  12.         PRIMARY KEY (`id`),
  13.         UNIQUE INDEX `item_guid` (`itemguid`)
  14. )
  15. COLLATE='utf8_general_ci'
  16. ENGINE=InnoDB
  17. ;
  18.