Import DB wiki from TC 335

1 files changed, 178 insertions, 9 deletions

diff --git a/docs/group_member.md b/docs/group_member.md
index fb25ee8..9ed789b 100644
--- a/docs/group_member.md
+++ b/docs/group_member.md
@@ -1,9 +1,178 @@
-[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [group_member](group_member)
-
-Column | Type | Description
---- | --- | ---
-Guid | int(10) unsigned | 
-MemberGuid | int(10) unsigned | 
-MemberFlags | tinyint(3) unsigned | 
-Subgroup | tinyint(3) unsigned | 
-Roles | tinyint(3) unsigned | 
+# group\_member
+
+`Back-to:Characters`
+
+**The \`group\_member\` table**
+
+This table holds info about group members.
+
+**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="#group_member-guid">guid</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> </td>
+<td> </td>
+</tr>
+<tr class="odd">
+<td><p><a href="#group_member-memberGuid">memberGuid</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><p>Unique</p></td>
+<td> </td>
+</tr>
+<tr class="even">
+<td><p><a href="#group_member-memberFlags">memberFlags</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="#group_member-subgroup">subgroup</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="even">
+<td><p><a href="#group_member-roles">roles</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**
+
+#### guid
+
+GUID of the group. See [groups.guid](http://collab.kpsn.org/display/tc/Groups+tc2#Groupstc2-guid).
+
+#### memberGuid
+
+GUID of the character member of the group. See [characters.guid](http://collab.kpsn.org/display/tc/Characters+tc2#Characterstc2-guid).
+
+<table>
+<colgroup>
+<col width="33%" />
+<col width="33%" />
+<col width="33%" />
+</colgroup>
+<tbody>
+<tr class="odd">
+<td><pre><code>MEMBER_FLAG_ASSISTANT</code></pre></td>
+<td><pre><code>0x01</code></pre></td>
+<td> </td>
+</tr>
+<tr class="even">
+<td><pre><code>MEMBER_FLAG_MAINTANK</code></pre></td>
+<td><pre><code>0x02</code></pre></td>
+<td><pre><code>(U)</code></pre></td>
+</tr>
+<tr class="odd">
+<td><pre><code>MEMBER_FLAG_MAINASSIST</code></pre></td>
+<td><pre><code>0x04</code></pre></td>
+<td><pre><code>(U)</code></pre></td>
+</tr>
+</tbody>
+</table>
+
+ 
+
+*(U) = Unique per group.*
+
+### subgroup
+
+Ranging 0-7 (1-8 in client), representing the subgroups of a raid group.
+There can only be 5 membes in one subgroup per raid group.
+
+### roles
+
+<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>ROLE_NONE</p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p>1</p></td>
+<td><p>ROLE_LEADER</p></td>
+<td><p>The character has signed to Random Dungeon Finder as experienced</p></td>
+</tr>
+<tr class="odd">
+<td><p>2</p></td>
+<td><p>ROLE_TANK</p></td>
+<td><p>The character has signed to Random Dungeon Finder as tank</p></td>
+</tr>
+<tr class="even">
+<td><p>4</p></td>
+<td><p>ROLE_HEALER</p></td>
+<td><p>The character has signed to Random Dungeon Finder as healer</p></td>
+</tr>
+<tr class="odd">
+<td><p>8</p></td>
+<td><p>ROLE_DAMAGE</p></td>
+<td><p>The character has signed to Random Dungeon Finder as dps</p></td>
+</tr>
+</tbody>
+</table>
+
+