character_pet - cmangos/issues GitHub Wiki
Back to the characters database list of tables.
This table holds the pet data for each pet summoned by anyone in the game.
| Field | Type | Null | Key | Default | Extra |
| id | int(11) unsigned | NO | PRI | 0 | |
| entry | int(11) unsigned | NO | 0 | ||
| owner | int(11) unsigned | NO | MUL | 0 | |
| modelid | int(11) unsigned | YES | 0 | ||
| CreatedBySpell | int(11) unsigned | NO | 0 | ||
| PetType | tinyint(3) unsigned | NO | 0 | ||
| level | int(11) unsigned | NO | 1 | ||
| exp | int(11) unsigned | NO | 0 | ||
| Reactstate | tinyint(1) unsigned | NO | 0 | ||
| talentpoints | int(11) unsigned | NO | 0 | ||
| name | varchar(100) | YES | Pet | ||
| renamed | tinyint(1) unsigned | NO | 0 | ||
| slot | int(11) unsigned | NO | 0 | ||
| curhealth | int(11) unsigned | NO | 1 | ||
| curmana | int(11) unsigned | NO | 0 | ||
| curhappiness | int(11) unsigned | NO | 0 | ||
| savetime | bigint(20) unsigned | NO | 0 | ||
| resettalents_cost | int(11) unsigned | NO | 0 | ||
| resettalents_time | bigint(20) unsigned | NO | 0 | ||
| abdata | longtext | YES | None | ||
| teachspelldata | longtext | YES | None |
The special pet ID. This is a unique identifier among all pets.
The creature entry of this pet. See creature_template.entry
The GUID of the pet’s owner. See character.guid
The model ID to use to display the pet.
The ID of the spell that has created this pet. For hunters, this is usually the Tame Beast spell. For warlocks or other classes (mages), it is the spell ID that summoned the creature. See Spell.dbc column 1
The type of pet that this is. 0 = summoned pet, 1 = tamed pet
The current level of the pet.
The current experience that this pet has. For summoned pets, this field is always 0.
The current reaction state of the pet (passive, aggressive, etc).
The pet’s name.
Boolean 1 or 0. 1 = Pet has been renamed, 0 = Pet has never been renamed and still uses the same name as the creature that was tamed.
The pet slot that the pet is in.
For Hunters: 0 = current active pet, 1..99 = stored in stable in corresponding storage slot, 100 = current dismissed pet.
For Warlocks: 0 = active minion, 100 = inactive minion.
The current pet health at the time it was saved to DB.
The current pet mana at the time it was saved to DB.
The current pet happiness.
The time when the pet was last saved, in Unix time.
data about pet action bar and action type ten pairs of action bar entry (from 1 to 10) and action or spell IDs
This field holds IDs of spells that have been taught to this pet, abilities that this pet has.