“character_stats” table

The character_stats table holds TODO

Table structure

Field Type Null Key Default Extra
guid int(11) unsigned NO PRI 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  
attackPower int(10) unsigned NO   0  
rangedAttackPower int(10) unsigned NO   0  

Fields

guid

maxhealth

maxpower1

maxpower2

maxpower3

maxpower4

maxpower5

maxpower6

maxpower7

strength

agility

stamina

intellect

spirit

armor

resHoly

resFire

resNature

resFrost

resShadow

resArcane

blockPct

dodgePct

parryPct

critPct

rangedCritPct

attackPower

rangedAttackPower