Skip to content

character_pet Table

Persistent pet data (hunter pets and permanent warlock minions): stats, spells, loyalty, rename state.

Schema Summary

Field Type Key Null Default Extra
id int(11) unsigned PRI NO 0
entry int(11) unsigned NO 0
owner_guid int(11) unsigned MUL NO 0
display_id int(11) unsigned YES 0
created_by_spell int(11) unsigned NO 0
pet_type tinyint(3) unsigned NO 0
level int(11) unsigned NO 1
xp int(11) unsigned NO 0
react_state tinyint(1) unsigned NO 0
loyalty_points int(11) NO 0
loyalty int(11) unsigned NO 0
training_points int(11) NO 0
name varchar(100) YES 'Pet'
renamed tinyint(1) unsigned NO 0
slot int(11) unsigned NO 0
current_health int(11) unsigned NO 1
current_mana int(11) unsigned NO 0
current_happiness int(11) unsigned NO 0
save_time bigint(20) unsigned NO 0
reset_talents_cost int(11) unsigned NO 0
reset_talents_time bigint(20) unsigned NO 0
action_bar_data longtext YES
teach_spell_data longtext YES

Field Breakdown

  • id - Primary Key. Persistent pet id (referenced by pet_aura, pet_spell, and pet_spell_cooldown tables).
  • entry - Creature template entry (creature_template.entry).
  • owner_guid - Owner character guid (characters.guid).
  • display_id - Native (base) display model.
  • created_by_spell - Spell that created/tamed the pet.
  • pet_type - Pet type: 0 = summoned pet (warlock minion etc.), 1 = hunter pet; only these two values are ever persisted.
  • level - Pet level.
  • xp - Experience towards next level.
  • react_state - Reaction: 0 passive, 1 defensive, 2 aggressive.
  • loyalty_points - Accumulated loyalty experience points.
  • loyalty - Loyalty rank level (1-6).
  • training_points - Points available for teaching abilities.
  • name - Current pet name.
  • renamed - Whether the owner already renamed the pet.
  • slot - Pet save slot (PetSaveMode): 0 = active pet, 1-2 = stable slots, 100 = not in any slot, 101 = not in slot with reagent refund pending.
  • current_health - Saved vitals.
  • current_mana - Saved vitals.
  • current_happiness - Happiness level (affects damage).
  • save_time - Unix timestamp of last save.
  • reset_talents_cost - Cost paid at the last talent reset; scales the next price (10s → 50s → 1g → +1g per attempt, cap 10g).
  • reset_talents_time - Game time of the last talent reset (drives day-based price decay).
  • action_bar_data - Serialized action bar assignment blob.
  • teach_spell_data - Serialized spell-teaching queue/state.