item_instance

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
guid	bigint	unsigned	PRI	NO	0
itemEntry	int	unsigned		NO	0
owner_guid	bigint	unsigned	MUL	NO	0
creatorGuid	bigint	unsigned		NO	0
giftCreatorGuid	bigint	unsigned		NO	0
count	int	unsigned		NO	1
duration	int	signed		NO	0
charges	tinytext			YES	NULL
flags	int	unsigned		NO	0
enchantments	text			NO
randomBonusListId	int	unsigned		NO	0
durability	smallint	unsigned		NO	0
playedTime	int	unsigned		NO	0
createTime	bigint	signed		NO	0
text	text			YES	NULL
battlePetSpeciesId	int	unsigned		NO	0
battlePetBreedData	int	unsigned		NO	0
battlePetLevel	smallint	unsigned		NO	0
battlePetDisplayId	int	unsigned		NO	0
context	tinyint	unsigned		NO	0
bonusListIDs	text			YES	NULL

Description of fields

guid

- no description -  

itemEntry

- no description -  

owner_guid

- no description -  

creatorGuid

- no description -  

giftCreatorGuid

- no description -  

count

- no description -  

duration

- no description -  

charges

- no description -  

flags

- no description -  

enchantments

- no description -  

randomBonusListId

- no description -  

durability

- no description -  

playedTime

- no description -  

createTime

- no description -  

text

- no description -  

battlePetSpeciesId

- no description -  

battlePetBreedData

- no description -  

battlePetLevel

- no description -  

battlePetDisplayId

- no description -  

context

- no description -  

bonusListIDs

- no description -