Import DB wiki from TC 335

1 files changed, 204 insertions, 16 deletions

diff --git a/docs/guild.md b/docs/guild.md
index ff874f9..542d772 100644
--- a/docs/guild.md
+++ b/docs/guild.md
@@ -1,16 +1,204 @@
-[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [guild](guild)
-
-Column | Type | Description
---- | --- | ---
-Guildid | int(10) unsigned | 
-Name | varchar(24) | 
-Leaderguid | int(10) unsigned | 
-EmblemStyle | tinyint(3) unsigned | 
-EmblemColor | tinyint(3) unsigned | 
-BorderStyle | tinyint(3) unsigned | 
-BorderColor | tinyint(3) unsigned | 
-BackgroundColor | tinyint(3) unsigned | 
-Info | varchar(500) | 
-Motd | varchar(128) | 
-Createdate | int(10) unsigned | 
-BankMoney | bigint(20) unsigned | 
+# guild
+
+`Back-to:Characters`
+
+**The \`guild\` table**
+
+This table holds the main guild information. All created guilds or all guilds in the process of being created have a record in this table.
+
+**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="#guild-guildid">guildid</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> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#guild-name">name</a></p></td>
+<td><p>varchar(24)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>&quot;</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#guild-leaderguid">leaderguid</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="#guild-EmblemStyle">EmblemStyle</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="#guild-EmblemColor">EmblemColor</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="#guild-BorderStyle">BorderStyle</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="#guild-BorderColor">BorderColor</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="#guild-BackgroundColor">BackgroundColor</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>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#guild-info">info</a></p></td>
+<td><p>text</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>&quot;</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#guild-motd">motd</a></p></td>
+<td><p>varchar(128)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>&quot;</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#guild-createdate">createdate</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="#guild-BankMoney">BankMoney</a></p></td>
+<td><p>bigint(20)</p></td>
+<td><p>signed</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**
+
+### guildid
+
+The ID of the guild. This number is unique to each guild and is the main method to identify a guild.
+
+### name
+
+The guild name.
+
+### leaderguid
+
+The GUID of the character who created the guild. See characters.guid
+
+### EmblemStyle
+
+The emblem style of the guild tabard.
+
+### EmblemColor
+
+The emblem color of the guild tabard.
+
+### BorderStyle
+
+The border style of the guild tabard.
+
+### BorderColor
+
+The border color of the guild tabard.
+
+### BackgroundColor
+
+The background color of the guild tabard.
+
+### info
+
+The text message that appears in the Guild Information box.
+
+### motd
+
+The text that appears in the Message Of The Day box.
+
+### createdate
+
+The date when the guild was created.
+
+### BankMoney
+
+The total money, in copper, that is currently in the guild's guild bank.