# 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.