blob: 93d25628fc2e5d2bee5b1bdd2818f5c370ad7858 (
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
|
# guild\_eventlog
[<-Back-to:Characters](database-characters.md)
**The \`guild\_eventlog\` table**
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
| ---------------- | ------- | ---------- | --- | ---- | ------- | ----- | ------------------------------------------- |
| [guildid][1] | INT | UNSIGNED | PRI | NO | | | Guild Identificator |
| [LogGuid][2] | INT | UNSIGNED | PRI | NO | | | Log record identificator - auxiliary column |
| [EventType][3] | TINYINT | UNSIGNED | | NO | | | Event type |
| [PlayerGuid1][4] | INT | UNSIGNED | | NO | | | Player 1 |
| [PlayerGuid2][5] | INT | UNSIGNED | | NO | | | Player 2 |
| [NewRank][6] | TINYINT | UNSIGNED | | NO | | | New rank(in case promotion/demotion) |
| [timestamp][7] | BIGINT | UNSIGNED | | NO | | | 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.
|
