Add new Edit Delete History Source

Important: As of 19/09/24 all versions of MariaDB, MySQL 5.7 and 8.1 will no longer be supported. Consider upgrading to MySQL 8.0 or 8.4.

item_instance

<-Back-to:Characters

The `item_instance` table

This table holds individual item instance information for all items currently equipped in some kind of character bag or bank, in auction houses, in guild banks or in mails.

Table Structure

Field	Type	Attributes	Key	Null	Default
guid	INT	UNSIGNED	PRI	NO	0
itemEntry	MEDIUMINT	UNSIGNED		NO	0
owner_guid	INT	UNSIGNED		NO	0
creatorGuid	INT	UNSIGNED		NO	0
giftCreatorGuid	INT	UNSIGNED		NO	0
count	INT	UNSIGNED		NO	1
duration	INT	SIGNED		NO	0
charges	TINYTEXT	SIGNED		YES
flags	MEDIUMINT	UNSIGNED		NO	0
enchantments	TEXT	SIGNED		NO
randomPropertyId	SMALLINT	SIGNED		NO	0
durability	SMALLINT	UNSIGNED		NO	0
playedTime	INT	UNSIGNED		NO	0
text	TEXT	SIGNED		YES

Description of the fields

guid

The GUID of the item. This number is unique for each item instance.

itemEntry

Item_template.entry.

owner_guid

The GUID of the character who has ownership of this item. See characters.guid.

creatorGuid

Characters.guid of character who created the item.

giftCreatorGuid

Characters.guid of character who created the item.

count

Current number of item copies in the stack.

duration

field-no-description|6

charges

The number of charges for each of the five possible spellcharges on an item, specified via five space separated integers.

flags

field-no-description|8

enchantments

Enchantments from SpellItemEnchantment.dbc see: item_instance_enchantments

randomPropertyId

field-no-description|10

durability

Current item durability.

playedTime

Time in seconds.

text

The text contained in that specific item.