|
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