“character_pet” table

The character_pet table holds TODO

Table structure

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  
loyaltypoints int(11) NO   0  
loyalty int(11) unsigned NO   0  
trainpoint int(11) 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   NULL  
teachspelldata longtext YES   NULL  

Fields

id

entry

owner

modelid

CreatedBySpell

PetType

level

exp

Reactstate

loyaltypoints

loyalty

trainpoint

name

renamed

slot

curhealth

curmana

curhappiness

savetime

resettalents_cost

resettalents_time

abdata

teachspelldata