AzerothCore
Pages :
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.
guild_bank_item
The `guild_bank_item` table
This table holds all item information for items that are stored in the guild bank.
Table Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guildid | INT | UNSIGNED | PRI | NO | 0 | ||
| TabId | TINYINT | UNSIGNED | PRI | NO | 0 | ||
| SlotId | TINYINT | UNSIGNED | PRI | NO | 0 | ||
| item_guid | INT | UNSIGNED | NO | 0 |
Description of the fields
guildid
The guild ID who owns the bank. See guild.guildid.
TabId
The tab ID where the item is currently placed in. See guild_bank_tab.TabId.
SlotId
The slot that the item is placed in in the tab.
item_guid
The item guid. See item_instance.guid.