ORSC/Databases/Addons/add_auctionhouse.sql

DROP TABLE IF EXISTS `expired_auctions`;
CREATE TABLE IF NOT EXISTS `expired_auctions`
(
    `playerID`    int(10) UNSIGNED NOT NULL,
    `claim_id`    int(11)          NOT NULL AUTO_INCREMENT,
    `item_id`     int(11)          NOT NULL,
    `item_amount` int(11)          NOT NULL,
    `time`        varchar(255)     NOT NULL,
    `claim_time`  varchar(255)     NOT NULL DEFAULT '0',
    `claimed`     tinyint(1)       NOT NULL DEFAULT 0,
    `explanation` varchar(255)     NOT NULL DEFAULT ' ',
    PRIMARY KEY (`claim_id`)
) ENGINE = MyISAM
  DEFAULT CHARSET = utf8;

DROP TABLE IF EXISTS `auctions`;
CREATE TABLE IF NOT EXISTS `auctions`
(
    `auctionID`       bigint(20)       NOT NULL AUTO_INCREMENT,
    `itemID`          int(11)          NOT NULL,
    `amount`          int(11)          NOT NULL,
    `amount_left`     int(11)          NOT NULL,
    `price`           int(11)          NOT NULL,
    `seller`          int(10) UNSIGNED NOT NULL,
    `seller_username` varchar(12)      NOT NULL,
    `buyer_info`      text             NOT NULL,
    `sold-out`        tinyint(4)       NOT NULL DEFAULT 0,
    `time`            varchar(255)     NOT NULL DEFAULT '0',
    `was_cancel`      tinyint(1)       NOT NULL DEFAULT 0,
    PRIMARY KEY (`auctionID`),
    KEY `auctionID` (`auctionID`),
    KEY `itemID` (`itemID`),
    KEY `seller_username_2` (`seller_username`),
    KEY `time` (`time`),
    KEY `seller_username` (`seller_username`),
    KEY `buyer_info` (`buyer_info`)
) ENGINE = MyISAM
  DEFAULT CHARSET = utf8;