The `guild_eventlog` table
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guildid | INT | UNSIGNED | PRI | NO | Guild Identificator | ||
| LogGuid | INT | UNSIGNED | PRI | NO | Log record identificator - auxiliary column | ||
| EventType | TINYINT | UNSIGNED | NO | Event type | |||
| PlayerGuid1 | INT | UNSIGNED | NO | Player 1 | |||
| PlayerGuid2 | INT | UNSIGNED | NO | Player 2 | |||
| NewRank | TINYINT | UNSIGNED | NO | New rank(in case promotion/demotion) | |||
| timestamp | BIGINT | UNSIGNED | NO | Event UNIX time |
Description of the fields
Guild Identificator.
Log record identificator - auxiliary column.
| Value | Description |
|---|---|
| 1 | GUILD_EVENT_LOG_INVITE_PLAYER |
| 2 | GUILD_EVENT_LOG_JOIN_GUILD |
| 3 | GUILD_EVENT_LOG_PROMOTE_PLAYER |
| 4 | GUILD_EVENT_LOG_DEMOTE_PLAYER |
| 5 | GUILD_EVENT_LOG_UNINVITE_PLAYER |
| 6 | GUILD_EVENT_LOG_LEAVE_GUILD |
GUID of Player1.
GUID of Player2.
New rank (in case of promotion/demotion).
Event UNIX time.