目录

guild_eventlog

<-Back-to:Characters

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

guildid

Guild Identificator.

LogGuid

Log record identificator - auxiliary column.

EventType

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

PlayerGuid1

GUID of Player1.

PlayerGuid2

GUID of Player2.

NewRank

New rank (in case of promotion/demotion).

timestamp

Event UNIX time.