Import DB wiki from TC 335

1 files changed, 145 insertions, 13 deletions

diff --git a/docs/account_tutorial.md b/docs/account_tutorial.md
index b543bf1..6ee1bf3 100644
--- a/docs/account_tutorial.md
+++ b/docs/account_tutorial.md
@@ -1,13 +1,145 @@
-[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [account_tutorial](account_tutorial)
-
-Column | Type | Description
---- | --- | ---
-AccountId | int(10) unsigned | 
-Tut0 | int(10) unsigned | 
-Tut1 | int(10) unsigned | 
-Tut2 | int(10) unsigned | 
-Tut3 | int(10) unsigned | 
-Tut4 | int(10) unsigned | 
-Tut5 | int(10) unsigned | 
-Tut6 | int(10) unsigned | 
-Tut7 | int(10) unsigned | 
+# account\_tutorial
+
+`Back-to:Characters`
+
+**The \`account\_tutorial\` table**
+
+This table is used to store the tutorial state of all the accounts.
+
+**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="#account_tutorial-accountId">accountId</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>Unique</p></td>
+<td><p>Account Identifier</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#account_tutorial-tut0-7">tut0</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> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#account_tutorial-tut0-7">tut1</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> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#account_tutorial-tut0-7">tut2</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> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#account_tutorial-tut0-7">tut3</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> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#account_tutorial-tut0-7">tut4</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> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#account_tutorial-tut0-7">tut5</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> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#account_tutorial-tut0-7">tut6</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> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#account_tutorial-tut0-7">tut7</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> </p></td>
+</tr>
+</tbody>
+</table>
+
+**Description of the fields**
+
+### guid
+
+Account of the player. See [account.id](account_2130004.html#account-id).
+
+### tut0-7
+
+These values 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status.
+
+Each bit means:
+
+``` cpp
+  0  -  Not yet shown
+  1  -  Shown
+```
+
+This is used to diplay only tutorial messages the character did not see before.
+
+Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed.