# guild\_eventlog

[<-Back-to:Characters](database-characters.md)

**The \`guild\_eventlog\` table**

`table-no-description`

**Structure**

| Field            | Type       | Attributes | Key | Null | Default | Extra | Comment                                     |
|------------------|------------|------------|-----|------|---------|-------|---------------------------------------------|
| [guildid][1]     | int(11)    | signed     | PRI | NO   | NULL    |       | Guild Identificator                         |
| [LogGuid][2]     | int(11)    | signed     | PRI | NO   | NULL    |       | Log record identificator - auxiliary column |
| [EventType][3]   | tinyint(1) | signed     |     | NO   | NULL    |       | Event type                                  |
| [PlayerGuid1][4] | int(11)    | signed     |     | NO   | NULL    |       | Player 1                                    |
| [PlayerGuid2][5] | int(11)    | signed     |     | NO   | NULL    |       | Player 2                                    |
| [NewRank][6]     | tinyint(2) | signed     |     | NO   | NULL    |       | New rank(in case promotion/demotion)        |
| [TimeStamp][7]   | bigint(20) | signed     |     | NO   | NULL    |       | Event UNIX time                             |

[1]: #guildid
[2]: #logguid
[3]: #eventtype
[4]: #playerguid1
[5]: #playerguid2
[6]: #newrank
[7]: #timestamp

**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`