====== guild_eventlog 表 ======

[[数据库:characters数据库:首页|<-返回:Characters 数据库]]



**表结构**
^Field^Type^Attributes^Key^Null^Default^extra^Comment^
|[[#guildid|guildid]]|INT|UNSIGNED|PRI|NO| | |Guild Identificator|
|[[#LogGuid|LogGuid]]|INT|UNSIGNED|PRI|NO| | |Log record identificator - auxiliary column|
|[[#EventType|EventType]]|TINYINT|UNSIGNED| |NO| | |Event type|
|[[#PlayerGuid1|PlayerGuid1]]|INT|UNSIGNED| |NO| | |Player 1|
|[[#PlayerGuid2|PlayerGuid2]]|INT|UNSIGNED| |NO| | |Player 2|
|[[#NewRank|NewRank]]|TINYINT|UNSIGNED| |NO| | |New rank(in case promotion/demotion)|
|[[#timestamp|timestamp]]|BIGINT|UNSIGNED| |NO| | |Event UNIX time|



===== 字段说明 =====
----
==== 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.