Import DB wiki from TC 335

1 files changed, 318 insertions, 21 deletions

diff --git a/docs/groups.md b/docs/groups.md
index 9e27c8d..18d63ad 100644
--- a/docs/groups.md
+++ b/docs/groups.md
@@ -1,21 +1,318 @@
-[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [groups](groups)
-
-Column | Type | Description
---- | --- | ---
-Guid | int(10) unsigned | 
-LeaderGuid | int(10) unsigned | 
-LootMethod | tinyint(3) unsigned | 
-LooterGuid | int(10) unsigned | 
-LootThreshold | tinyint(3) unsigned | 
-Icon1 | int(10) unsigned | 
-Icon2 | int(10) unsigned | 
-Icon3 | int(10) unsigned | 
-Icon4 | int(10) unsigned | 
-Icon5 | int(10) unsigned | 
-Icon6 | int(10) unsigned | 
-Icon7 | int(10) unsigned | 
-Icon8 | int(10) unsigned | 
-GroupType | tinyint(3) unsigned | 
-Difficulty | tinyint(3) unsigned | 
-RaidDifficulty | tinyint(3) unsigned | 
-MasterLooterGuid | int(10) unsigned | 
+# groups
+
+`Back-to:Characters`
+
+**The \`groups\` table**
+
+This table holds basic info about groups.
+
+**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="#groups-guid">guid</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> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="odd">
+<td><p><a href="#groups-leaderGuid">leaderGuid</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td> </td>
+<td><p>NO</p></td>
+<td> </td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#groups-lootMethod">lootMethod</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="odd">
+<td><p><a href="#groups-looterGuid">looterGuid</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td> </td>
+<td><p>NO</p></td>
+<td> </td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#groups-lootThreshold">lootThreshold</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="odd">
+<td><p><a href="#groups-icon1-8">icon1</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td> </td>
+<td><p>NO</p></td>
+<td> </td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#groups-icon1-8">icon2</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="odd">
+<td><p><a href="#groups-icon1-8">icon3</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td> </td>
+<td><p>NO</p></td>
+<td> </td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#groups-icon1-8">icon4</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="odd">
+<td><p><a href="#groups-icon1-8">icon5</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td> </td>
+<td><p>NO</p></td>
+<td> </td>
+<td><p> </p></td>
+<td> </td>
+</tr>
+<tr class="even">
+<td><p><a href="#groups-icon1-8">icon6</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="odd">
+<td><p><a href="#groups-icon1-8">icon7</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td> </td>
+<td><p>NO</p></td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="even">
+<td><p><a href="#groups-icon1-8">icon8</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="odd">
+<td><p><a href="#groups-groupType">groupType</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td> </td>
+<td><p>NO</p></td>
+<td> </td>
+<td> </td>
+<td> </td>
+</tr>
+<tr class="even">
+<td><p><a href="#groups-difficulty">difficulty</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="odd">
+<td><p><a href="#groups-raiddifficulty">raiddifficulty</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>
+</tbody>
+</table>
+
+**Description of the fields**
+
+### guid
+
+The ID of the group. This number is unique to each group and is the main method to identify a group.
+
+### leaderGuid
+
+The GUID of the character. See characters.guid
+
+### lootMethod
+
+<table>
+<colgroup>
+<col width="33%" />
+<col width="33%" />
+<col width="33%" />
+</colgroup>
+<thead>
+<tr class="header">
+<th><p>Value</p></th>
+<th><p>Name</p></th>
+<th><p>Comments</p></th>
+</tr>
+</thead>
+<tbody>
+<tr class="odd">
+<td><p>0</p></td>
+<td><p>FREE_FOR_ALL</p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p>1</p></td>
+<td><p>ROUND_ROBIN</p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p>2</p></td>
+<td><p>MASTER_LOOT</p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p>3</p></td>
+<td><p>GROUP_LOOT</p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p>4</p></td>
+<td><p>NEED_BEFORE_GREED</p></td>
+<td><p> </p></td>
+</tr>
+</tbody>
+</table>
+
+### looterGuid
+
+Master looter's guid. See characters.guid
+If [lootMethod](#groups-lootMethod) is not 2, then it's group leader's guid.
+
+### lootThreshold
+
+`field-no-description|5`
+
+### icon1-8
+
+`field-no-description|6`
+
+### groupType
+
+<table>
+<colgroup>
+<col width="33%" />
+<col width="33%" />
+<col width="33%" />
+</colgroup>
+<thead>
+<tr class="header">
+<th><p>Value</p></th>
+<th><p>Name</p></th>
+<th><p>Comments</p></th>
+</tr>
+</thead>
+<tbody>
+<tr class="odd">
+<td><p>0</p></td>
+<td><p>GROUPTYPE_NORMAL</p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p>1</p></td>
+<td><p>GROUPTYPE_BG</p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p>2</p></td>
+<td><p>GROUPTYPE_RAID</p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p>3</p></td>
+<td><p>GROUPTYPE_BGRAID</p></td>
+<td><p>GROUPTYPE_BG + GROUPTYPE_RAID, // mask</p></td>
+</tr>
+<tr class="odd">
+<td><p>4</p></td>
+<td><p>GROUPTYPE_UNK1</p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p>8</p></td>
+<td><p>GROUPTYPE_LFG</p></td>
+<td><p> </p></td>
+</tr>
+</tbody>
+</table>
+
+### difficulty
+
+`field-no-description|8`
+
+### raiddifficulty
+
+`field-no-description|9`