heirloom
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| SourceText | text | YES | NULL | ||||
| ID | int | unsigned | PRI | NO | 0 | ||
| ItemID | int | signed | NO | 0 | |||
| LegacyUpgradedItemID | int | signed | NO | 0 | |||
| StaticUpgradedItemID | int | signed | NO | 0 | |||
| SourceTypeEnum | tinyint | signed | NO | 0 | |||
| Flags | tinyint | unsigned | NO | 0 | |||
| LegacyItemID | int | signed | NO | 0 | |||
| UpgradeItemID1 | int | signed | NO | 0 | |||
| UpgradeItemID2 | int | signed | NO | 0 | |||
| UpgradeItemID3 | int | signed | NO | 0 | |||
| UpgradeItemID4 | int | signed | NO | 0 | |||
| UpgradeItemID5 | int | signed | NO | 0 | |||
| UpgradeItemID6 | int | signed | NO | 0 | |||
| UpgradeItemBonusListID1 | smallint | unsigned | NO | 0 | |||
| UpgradeItemBonusListID2 | smallint | unsigned | NO | 0 | |||
| UpgradeItemBonusListID3 | smallint | unsigned | NO | 0 | |||
| UpgradeItemBonusListID4 | smallint | unsigned | NO | 0 | |||
| UpgradeItemBonusListID5 | smallint | unsigned | NO | 0 | |||
| UpgradeItemBonusListID6 | smallint | unsigned | NO | 0 | |||
| VerifiedBuild | int | signed | PRI | NO | 0 | ||
Description of fields
SourceText
- no description -
ID
- no description -
ItemID
- no description -
LegacyUpgradedItemID
- no description -
StaticUpgradedItemID
- no description -
SourceTypeEnum
- no description -
Flags
- no description -
LegacyItemID
- no description -
UpgradeItemID1
- no description -
UpgradeItemID2
- no description -
UpgradeItemID3
- no description -
UpgradeItemID4
- no description -
UpgradeItemID5
- no description -
UpgradeItemID6
- no description -
UpgradeItemBonusListID1
- no description -
UpgradeItemBonusListID2
- no description -
UpgradeItemBonusListID3
- no description -
UpgradeItemBonusListID4
- no description -
UpgradeItemBonusListID5
- no description -
UpgradeItemBonusListID6
- no description -
VerifiedBuild
This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files.
If value is 0 then it has not been parsed yet.
If value is above 0 then it has been parsed with WDB files from that specific client build.
If value is -1 then it is just a place holder until proper data are found on WDBs.
If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.