The `guild_bank_eventlog` table
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guildid | INT | UNSIGNED | PRI | NO | 0 | Guild Identificator | |
| LogGuid | INT | UNSIGNED | PRI | NO | 0 | Log record identificator - auxiliary column | |
| TabId | TINYINT | UNSIGNED | PRI | NO | 0 | Guild bank TabId | |
| EventType | TINYINT | UNSIGNED | NO | 0 | Event type | ||
| PlayerGuid | INT | UNSIGNED | NO | 0 | |||
| ItemOrMoney | INT | UNSIGNED | NO | 0 | |||
| ItemStackCount | SMALLINT | UNSIGNED | NO | 0 | |||
| DestTabId | TINYINT | UNSIGNED | NO | 0 | Destination Tab Id | ||
| TimeStamp | INT | UNSIGNED | NO | 0 | Event UNIX time |
Description of the fields
Guild Identificator.
Log record identification - auxiliary column.
Guild bank TabId.
| Value | Description |
|---|---|
| 1 | GUILD_BANK_LOG_DEPOSIT_ITEM |
| 2 | GUILD_BANK_LOG_WITHDRAW_ITEM |
| 3 | GUILD_BANK_LOG_MOVE_ITEM |
| 4 | GUILD_BANK_LOG_DEPOSIT_MONEY |
| 5 | GUILD_BANK_LOG_WITHDRAW_MONEY |
| 6 | GUILD_BANK_LOG_REPAIR_MONEY |
| 7 | GUILD_BANK_LOG_MOVE_ITEM2 |
| 8 | GUILD_BANK_LOG_UNK1 |
| 9 | GUILD_BANK_LOG_BUY_SLOT |
GUID of the Player.
field-no-description|6
field-no-description|7
Destination Tab Id.
Event UNIX time.