Import DB wiki from TC 335

1 files changed, 144 insertions, 11 deletions

diff --git a/docs/guild_eventlog.md b/docs/guild_eventlog.md
index 8b3f2af..1cb6620 100644
--- a/docs/guild_eventlog.md
+++ b/docs/guild_eventlog.md
@@ -1,11 +1,144 @@
-[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [guild_eventlog](guild_eventlog)
-
-Column | Type | Description
---- | --- | ---
-Guildid | int(10) unsigned | 
-LogGuid | int(10) unsigned | 
-EventType | tinyint(3) unsigned | 
-PlayerGuid1 | int(10) unsigned | 
-PlayerGuid2 | int(10) unsigned | 
-NewRank | tinyint(3) unsigned | 
-TimeStamp | int(10) unsigned | 
+# guild\_eventlog
+
+`Back-to:Characters`
+
+**The \`guild\_eventlog\` table**
+
+`table-no-description`
+
+**Structure**
+
+<table>
+<colgroup>
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+</colgroup>
+<tbody>
+<tr class="odd">
+<td><p><strong>Field</strong></p></td>
+<td><p><strong>Type</strong></p></td>
+<td><p><strong>Attributes</strong></p></td>
+<td><p><strong>Key</strong></p></td>
+<td><p><strong>Null</strong></p></td>
+<td><p><strong>Default</strong></p></td>
+<td><p><strong>Extra</strong></p></td>
+<td><p><strong>Comment</strong></p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#guild_eventlog-guildid">guildid</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p>PRI</p></td>
+<td><p>NO</p></td>
+<td><p>NULL</p></td>
+<td><p> </p></td>
+<td><p>Guild Identificator</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#guild_eventlog-LogGuid">LogGuid</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p>PRI</p></td>
+<td><p>NO</p></td>
+<td><p>NULL</p></td>
+<td><p> </p></td>
+<td><p>Log record identificator - auxiliary column</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#guild_eventlog-EventType">EventType</a></p></td>
+<td><p>tinyint(1)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>NULL</p></td>
+<td><p> </p></td>
+<td><p>Event type</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#guild_eventlog-PlayerGuid1">PlayerGuid1</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>NULL</p></td>
+<td><p> </p></td>
+<td><p>Player 1</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#guild_eventlog-PlayerGuid2">PlayerGuid2</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>NULL</p></td>
+<td><p> </p></td>
+<td><p>Player 2</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#guild_eventlog-NewRank">NewRank</a></p></td>
+<td><p>tinyint(2)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>NULL</p></td>
+<td><p> </p></td>
+<td><p>New rank(in case promotion/demotion)</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#guild_eventlog-TimeStamp">TimeStamp</a></p></td>
+<td><p>bigint(20)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>NULL</p></td>
+<td><p> </p></td>
+<td><p>Event UNIX time</p></td>
+</tr>
+</tbody>
+</table>
+
+**Description of the fields**
+
+### guildid
+
+`Guild Identificator`
+
+### LogGuid
+
+`Log record identificator - auxiliary column`
+
+### EventType
+
+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`