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.

recovery_item

<-Back-to:Characters

The `recovery_item` table

This table holds information about saved items into database when the player sells items to vendor Items which were kept back in the database after being deleted and are older than the specified amount of days, will be completely deleted.

Table Structure

Field	Type	Attributes	Key	Null	Default	Extra
Id	INT	UNSIGNED	PRI	NO		AUTO_INCREMENT
Guid	INT	UNSIGNED		NO	0
ItemEntry	MEDIUMINT	UNSIGNED		NO	0
Count	INT	UNSIGNED		NO	0

Description of the fields

Id

The ordinal number of the record in this table.

Guid

Character guid

See characters.guid.

ItemEntry

See item_template.entry.

Count

The amount of items.