Import DB wiki from TC 335

1 files changed, 125 insertions, 9 deletions

diff --git a/docs/logs.md b/docs/logs.md
index 6f1d31b..318b420 100644
--- a/docs/logs.md
+++ b/docs/logs.md
@@ -1,9 +1,125 @@
-[Database Structure](Database-Structure) > [Auth-Database](Auth-Database) > [logs](logs)
-
-Column | Type | Description
---- | --- | ---
-Time | int(10) unsigned | 
-Realm | int(10) unsigned | 
-Type | varchar(250) | 
-Level | tinyint(3) unsigned | 
-String | text | 
+# logs
+
+`Back-to:Auth`
+
+**The \`logs\` table**
+
+This table stores all logs from authserver if database logging in config is enabled.
+
+**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="#logs-time">time</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#logs-realm">realm</a></p></td>
+<td><p>realm(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#logs-type">type</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#logs-level">level</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#logs-string">string</a></p></td>
+<td><p>text</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>YES</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+</tbody>
+</table>
+
+**Description of the fields**
+
+### time
+
+A unixtime timestamp indicating when this string was logged.
+
+### realm
+
+The [RealmID](realmlist_2130016.html#realmlist-id) of the realm this log string came from. 0 if realmd.
+
+### type
+
+The type of log this is:
+
+LOG\_TYPE\_STRING = 0 — a normal informative string
+LOG\_TYPE\_ERROR = 1 — some sort of error
+LOG\_TYPE\_BASIC = 2 — basic information
+LOG\_TYPE\_DETAIL = 3 — detailed information
+LOG\_TYPE\_DEBUG = 4 — debugging information
+LOG\_TYPE\_CHAR = 5 — character-related
+LOG\_TYPE\_WORLD = 6 — world packet dump
+LOG\_TYPE\_RA = 7 — remote access logs
+LOG\_TYPE\_GM = 8 — gm command logs
+LOG\_TYPE\_CRASH = 9 — crash alarm logs
+LOG\_TYPE\_CHAT = 10 – chat/message logs
+
+### level
+
+Depends on LogLevel in authserver.conf
+
+-   1 - (Trace)
+-   2 - (Debug)
+-   3 - (Info)
+-   4 - (Warn)
+-   5 - (Error)
+-   6 - (Fatal)
+
+### string
+
+The actual string that has been logged.