...
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
| ID | int(10) | unsigned | PRI | NO | 0 | ||
| Quality | int(10) | unsigned | NO | 0 | |||
| Flags | int(10) | unsigned | NO | 0 | |||
| Unk1 | float | signed | NO | 0 | |||
| Unk2 | float | signed | NO | 0 | |||
| BuyCount | int(10) | unsigned | NO | 0 | |||
| BuyPrice | int(10) | unsigned | NO | 0 | |||
| SellPrice | int(10) | unsigned | NO | 0 | |||
| InventoryType | int(10) | unsigned | NO | 0 | |||
| AllowableClass | int(11) | signed | NO | 0 | |||
| AllowableRace | int(11) | signed | NO | 0 | |||
| ItemLevel | int(10) | unsigned | NO | 0 | |||
| RequiredLevel | int(10) | signed | NO | 0 | |||
| RequiredSkill | int(10) | unsigned | NO | 0 | |||
| RequiredSkillRank | int(10) | unsigned | NO | 0 | |||
| RequiredSpell | int(10) | unsigned | NO | 0 | |||
| RequiredHonorRank | int(10) | unsigned | NO | 0 | |||
| RequiredCityRank | int(10) | unsigned | NO | 0 | |||
| RequiredReputationFaction | int(10) | unsigned | NO | 0 | |||
| RequiredReputationRank | int(10) | unsigned | NO | 0 | |||
| MaxCount | int(10) | unsigned | NO | 0 | |||
| Stackable | int(10) | unsigned | NO | 0 | |||
| ContainerSlots | int(10) | unsigned | NO | 0 | |||
| ItemStatType | int(11) | signed | NO | 0 | |||
| ItemStatValue | int(11) | signed | NO | 0 | |||
| ItemStatAllocation | int(11) | signed | NO | 0 | |||
| ItemStatSocketCostMultiplier | float | signed | NO | 0 | |||
| ScalingStatDistribution | int(10) | unsigned | NO | 0 | |||
| DamageType | int(10) | unsigned | NO | 0 | |||
| Delay | int(10) | unsigned | NO | 0 | |||
| RangedModRange | float | signed | NO | 0 | |||
| Bonding | int(10) | unsigned | NO | 0 | |||
| Name | TEXT | YES | |||||
| Description | TEXT | YES | |||||
| PageText | int(10) | unsigned | NO | 0 | |||
| LanguageID | int(10) | unsigned | NO | 0 | |||
| PageMaterial | int(10) | unsigned | NO | 0 | |||
| StartQuest | int(10) | unsigned | NO | 0 | |||
| LockID | int(10) | unsigned | NO | 0 | |||
| Material | int(11) | signed | NO | 0 | |||
| Sheath | int(10) | unsigned | NO | 0 | |||
| RandomProperty | int(10) | unsigned | NO | 0 | |||
| RandomSuffix | int(10) | unsigned | NO | 0 | |||
| ItemSet | int(10) | unsigned | NO | 0 | |||
| Area | int(10) | unsigned | NO | 0 | |||
| Map | int(10) | unsigned | NO | 0 | |||
| BagFamily | int(10) | unsigned | NO | 0 | |||
| TotemCategory | int(10) | unsigned | NO | 0 | |||
| SocketColor | int(10) | unsigned | NO | 0 | SocketColor1 can be NULL | ||
| SocketBonus | int(10) | unsigned | NO | 0 | |||
| GemProperties | int(10) | unsigned | NO | 0 | |||
| ArmorDamageModifier | float | signed | NO | 0 | |||
| Duration | int(10) | unsigned | NO | 0 | |||
| ItemLimitCategory | int(10) | unsigned | NO | 0 | |||
| HolidayID | int(10) | unsigned | NO | 0 | |||
| StatScalingFactor | float | signed | NO | 0 | |||
| CurrencySubstitutionID | int(10) | unsigned | NO | 0 | |||
| CurrencySubstitutionCount | int(10) | unsigned | NO | 0 | |||
| ItemNameDescriptionID | int(10) | unsigned | NO | 0 | |||
| VerifiedBuild | smallint(6) | signed | NO | 0 |
Description of the fields
...
The color of the socket that can be placed in this item. A maximum of 3 socket colors can be set as seen by the column count.
| ID | Color |
1 | Meta |
2 | Red |
4 | Yellow |
8 | Blue |
...