NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'ahbot_history' table for MaNGOSZero
Table Notes
This table uses the 'InnoDB' DB Engine
The Field definitions follow:
Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
---|---|---|---|---|---|---|
id | bigint(20) | NO | PRI | NULL | 'auto_increment' | |
buytime | bigint(20) | NO | NULL | |||
item | bigint(20) | NO | NULL | |||
bid | bigint(20) | NO | NULL | |||
buyout | bigint(20) | NO | NULL | |||
won | bigint(20) | NO | MUL | NULL | ||
category | varchar(45) | YES | MUL | {Blank String} | An Item category Id from the list below: | |
auction_house | bigint(20) | NO | MUL | NULL |
Description of the fields
id bigint(20)
buytime bigint(20)
item bigint(20)
bid bigint(20)
buyout bigint(20)
won bigint(20)
category varchar(45)
An Item category Id from the list below:
Item Category Enum | Category Id |
---|---|
ITEM_CLASS_CONSUMABLE | 0 |
ITEM_CLASS_CONTAINER | 1 |
ITEM_CLASS_WEAPON | 2 |
ITEM_CLASS_RESERVED_1 | 3 |
ITEM_CLASS_ARMOR | 4 |
ITEM_CLASS_REAGENT | 5 |
ITEM_CLASS_PROJECTILE | 6 |
ITEM_CLASS_TRADE_GOODS | 7 |
ITEM_CLASS_RESERVED_2 | 8 |
ITEM_CLASS_RECIPE | 9 |
ITEM_CLASS_RESERVED_3 | 10 |
ITEM_CLASS_QUIVER | 11 |
ITEM_CLASS_QUEST | 12 |
ITEM_CLASS_KEY | 13 |
ITEM_CLASS_RESERVED_4 | 14 |
ITEM_CLASS_MISC | 15 |
auction_house bigint(20)
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now