blob: 6bea1c2d2f77a333bdff9f826b4b795ca6ade41e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
# 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 | SIGNED | PRI | NO | NULL | | Guild Identificator |
| [LogGuid][2] | INT | SIGNED | PRI | NO | NULL | | Log record identificator - auxiliary column |
| [EventType][3] | TINYINT | SIGNED | | NO | NULL | | Event type |
| [PlayerGuid1][4] | INT | SIGNED | | NO | NULL | | Player 1 |
| [PlayerGuid2][5] | INT | SIGNED | | NO | NULL | | Player 2 |
| [NewRank][6] | TINYINT | SIGNED | | NO | NULL | | New rank(in case promotion/demotion) |
| [timestamp][7] | BIGINT | 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`
|
