Import DB wiki from TC 335

1 files changed, 298 insertions, 18 deletions

diff --git a/docs/mail.md b/docs/mail.md
index f327980..9a235af 100644
--- a/docs/mail.md
+++ b/docs/mail.md
@@ -1,18 +1,298 @@
-[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [mail](mail)
-
-Column | Type | Description
---- | --- | ---
-Id | int(10) unsigned | 
-MessageType | tinyint(3) unsigned | 
-Stationery | tinyint(3) | 
-MailTemplateId | smallint(5) unsigned | 
-Sender | int(10) unsigned | 
-Receiver | int(10) unsigned | 
-Subject | longtext | 
-Body | longtext | 
-Has_items | tinyint(3) unsigned | 
-Expire_time | int(10) unsigned | 
-Deliver_time | int(10) unsigned | 
-Money | int(10) unsigned | 
-Cod | int(10) unsigned | 
-Checked | tinyint(3) unsigned | 
+# mail
+
+`Back-to:Characters`
+
+**The \`mail\` table**
+
+This table contains main data about all mails in the game.
+
+**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="#mail-id">id</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p>PRI</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p>Identifier</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#mail-messageType">messageType</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="#mail-stationery">stationery</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>41</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#mail-mailTemplateId_x">mailTemplateId</a></p></td>
+<td><p>mediumint(5)</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="#mail-sender">sender</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>0</p></td>
+<td><p> </p></td>
+<td><p>Character Global Unique Identifier</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#mail-receiver">receiver</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>0</p></td>
+<td><p> </p></td>
+<td><p>Character Global Unique Identifier</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#mail-subject">subject</a></p></td>
+<td><p>longtext</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>YES</p></td>
+<td><p>NULL</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#mail-body">body</a></p></td>
+<td><p>longtext</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>YES</p></td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="even">
+<td><p><a href="#mail-has_items">has_items</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td> </td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="odd">
+<td><p><a href="#mail-expire_time">expire_time</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td> </td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="even">
+<td><p><a href="#mail-deliver_time">deliver_time</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td> </td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="odd">
+<td><p><a href="#mail-money">money</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td> </td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="even">
+<td><p><a href="#mail-cod">cod</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td> </td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="odd">
+<td><p><a href="#mail-checked">checked</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td> </td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td> </td>
+<td> </td>
+</tr>
+</tbody>
+</table>
+
+**Description of the fields**
+
+### id
+
+This field contains unique ID of any messages.
+
+Don't have autoincrement !!!
+
+### messageType
+
+-   0 = Normal
+-   1 doesn't exist
+-   2 = Auction
+-   3 = Creature
+-   4 = Gameobject
+-   5 = Item
+
+### stationery
+
+This field can contain these values:
+
+-   1 = Test
+-   41 = Normal mail layout,
+
+<!-- -->
+
+-   61 = GM (Blizzard)
+-   62 = Auction
+-   64 = VAL (???)
+-   65 = CHR (???)
+
+### mailTemplateId
+
+Id from MailTemplate.dbc
+
+### sender
+
+In this field is entered sender [character.guid.](2129969.html#characters(table)-guid)
+
+### receiver
+
+Here is receiver's [character.guid.](2129969.html#characters(table)-guid)
+
+### subject
+
+Here is stored mail subject.
+
+### body
+
+The text contained in the mail.
+
+### has\_items
+
+Default: 0,
+
+When is set to 1, that mail can contain items.
+
+For items look at [mail\_items](mail_items) table.
+
+### expire\_time
+
+Here is timestamp which stores date for auto-return mail to sender.
+
+### deliver\_time
+
+Here is timestamp which stores date of send mail.
+
+### money
+
+The ammout of money in mail, or money to pay when is COD.
+
+### cod
+
+Default: 0 - No COD,
+
+when is set to 1, that field \`money\` stores gold for COD.
+
+### checked
+
+<table>
+<colgroup>
+<col width="50%" />
+<col width="50%" />
+</colgroup>
+<thead>
+<tr class="header">
+<th><p>Flag</p></th>
+<th><p>Comment</p></th>
+</tr>
+</thead>
+<tbody>
+<tr class="odd">
+<td><p>0</p></td>
+<td><p>MAIL_CHECK_MASK_NONE</p></td>
+</tr>
+<tr class="even">
+<td><p>1</p></td>
+<td><p>MAIL_CHECK_MASK_READ</p></td>
+</tr>
+<tr class="odd">
+<td><p>2</p></td>
+<td><p>MAIL_CHECK_MASK_RETURNED</p></td>
+</tr>
+<tr class="even">
+<td><p>4</p></td>
+<td><p>MAIL_CHECK_MASK_COPIED</p></td>
+</tr>
+<tr class="odd">
+<td><p>8</p></td>
+<td><p>MAIL_CHECK_MASK_COD_PAYMENT</p></td>
+</tr>
+<tr class="even">
+<td><p>16</p></td>
+<td><p>MAIL_CHECK_MASK_HAS_BODY</p></td>
+</tr>
+</tbody>
+</table>
+
+/td