AzerothCore
Pages :
recovery_item
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 | Comment |
|---|---|---|---|---|---|---|---|
| Id | INT | UNSIGNED | PRI | NO | AUTO_INCREMENT | ||
| Guid | INT | UNSIGNED | NO | 0 | |||
| ItemEntry | MEDIUMINT | UNSIGNED | NO | 0 | |||
| Count | INT | UNSIGNED | NO | 0 | |||
| DeleteDate | INT | UNSIGNED | YES | NULL |
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.
DeleteDate
Unix timestamp of when the item was deleted. Used to determine when the record is old enough to be purged permanently. NULL if not set.