character_stats - cmangos/issues GitHub Wiki
Back to the characters database list of tables.
This table holds characters’ stats data to be used by external tools. The core only populates the table, but does not rely on its content in any way. Related core configuration settings: `PlayerSave.Stats.MinLevel`, `PlayerSave.Stats.SaveOnlyOnLogout`
| Field | Type | Null | Key | Default | Extra |
| guid | int(10) unsigned | NO | PRIMARY | 0 | |
| maxhealth | int(10) unsigned | NO | 0 | ||
| maxpower1 | int(10) unsigned | NO | 0 | ||
| maxpower2 | int(10) unsigned | NO | 0 | ||
| maxpower3 | int(10) unsigned | NO | 0 | ||
| maxpower4 | int(10) unsigned | NO | 0 | ||
| maxpower5 | int(10) unsigned | NO | 0 | ||
| maxpower6 | int(10) unsigned | NO | 0 | ||
| maxpower7 | int(10) unsigned | NO | 0 | ||
| strength | int(10) unsigned | NO | 0 | ||
| agility | int(10) unsigned | NO | 0 | ||
| stamina | int(10) unsigned | NO | 0 | ||
| intellect | int(10) unsigned | NO | 0 | ||
| spirit | int(10) unsigned | NO | 0 | ||
| armor | int(10) unsigned | NO | 0 | ||
| resHoly | int(10) unsigned | NO | 0 | ||
| resFire | int(10) unsigned | NO | 0 | ||
| resNature | int(10) unsigned | NO | 0 | ||
| resFrost | int(10) unsigned | NO | 0 | ||
| resShadow | int(10) unsigned | NO | 0 | ||
| resArcane | int(10) unsigned | NO | 0 | ||
| blockPct | float unsigned | NO | 0 | ||
| dodgePct | float unsigned | NO | 0 | ||
| parryPct | float unsigned | NO | 0 | ||
| critPct | float unsigned | NO | 0 | ||
| rangedCritPct | float unsigned | NO | 0 | ||
| spellCritPct | int(10) unsigned | NO | 0 | ||
| attackPower | int(10) unsigned | NO | 0 | ||
| rangedAttackPower | int(10) unsigned | NO | 0 | ||
| spellPower | int(10) unsigned | NO | 0 |
The GUID of the character. See character.guid