· 6 years ago · Sep 28, 2019, 05:36 AM
1-- Table for Auction House items
2
3CREATE TABLE IF NOT EXISTS `auction_house` (
4 `itemId` INT UNSIGNED NOT NULL DEFAULT 0,
5 `ownerId` INT UNSIGNED NOT NULL DEFAULT 0,
6 `count` MEDIUMINT UNSIGNED NOT NULL DEFAULT 0,
7 `sale_price` BIGINT UNSIGNED NOT NULL DEFAULT 0,
8 `expiration_time` BIGINT UNSIGNED NOT NULL DEFAULT 0,
9 PRIMARY KEY (`itemId`)
10) ENGINE=InnoDB DEFAULT CHARSET=utf8;