Back to the characters database list of tables.
The `guild_eventlog` table
table-no-description
Structure
Field |
Type |
Attributes |
Key |
Null |
Default |
Extra |
Comment |
int(11) |
signed |
PRI |
NO |
NULL |
|
Guild Identificator |
|
int(11) |
signed |
PRI |
NO |
NULL |
|
Log record identificator - auxiliary column |
|
tinyint(1) |
signed |
|
NO |
NULL |
|
Event type |
|
int(11) |
signed |
|
NO |
NULL |
|
Player 1 |
|
int(11) |
signed |
|
NO |
NULL |
|
Player 2 |
|
tinyint(2) |
signed |
|
NO |
NULL |
|
New rank(in case promotion/demotion) |
|
bigint(20) |
signed |
|
NO |
NULL |
|
Event UNIX time |
Description of the fields
guildid
field-no-description|1
LogGuid
field-no-description|2
EventType
field-no-description|3
PlayerGuid1
field-no-description|4
PlayerGuid2
field-no-description|5
NewRank
field-no-description|6
TimeStamp
field-no-description|7