Import DB wiki from TC 335

1 files changed, 339 insertions, 24 deletions

diff --git a/docs/gm_ticket.md b/docs/gm_ticket.md
index 8f284b0..33a2154 100644
--- a/docs/gm_ticket.md
+++ b/docs/gm_ticket.md
@@ -1,24 +1,339 @@
-[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [gm_ticket](gm_ticket)
-
-Column | Type | Description
---- | --- | ---
-Id | int(10) unsigned | 
-Type | tinyint(3) unsigned | 
-PlayerGuid | int(10) unsigned | 
-Name | varchar(12) | 
-Description | text | 
-CreateTime | int(10) unsigned | 
-MapId | smallint(5) unsigned | 
-PosX | float | 
-PosY | float | 
-PosZ | float | 
-LastModifiedTime | int(10) unsigned | 
-ClosedBy | int(10) unsigned | 
-AssignedTo | int(10) unsigned | 
-Comment | text | 
-Response | text | 
-Completed | tinyint(3) unsigned | 
-Escalated | tinyint(3) unsigned | 
-Viewed | tinyint(3) unsigned | 
-NeedMoreHelp | tinyint(3) unsigned | 
-ResolvedBy | int(10) unsigned | 
+# gm\_ticket
+
+`Back-to:Characters`
+
+**The \`gm\_tickets\` table**
+
+This table stores all tickets
+
+**Structure**
+
+<table>
+<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="#gm_ticket-Id">Id</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>signed</p></td>
+<td><p>PRI</p></td>
+<td><p>NO</p></td>
+<td><p><br />
+</p></td>
+<td><p>Auto increment</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#gm_ticket-playerGuid">playerGuid</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p>Global Unique Identifier of ticket creator</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#gm_ticket-name">name</a></p></td>
+<td><p>varchar(12)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>NULL</p></td>
+<td><p><br />
+</p></td>
+<td><p>Name of ticket creator</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#gm_ticket-description">description</a></p></td>
+<td><p>text</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p><br />
+</p></td>
+<td><br />
+</td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#gm_ticket-createtime">createtime</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><br />
+</td>
+<td><p>NO</p></td>
+<td>0</td>
+<td><br />
+</td>
+<td><br />
+</td>
+</tr>
+<tr class="odd">
+<td><p><a href="#gm_ticket-mapId">mapId</a></p></td>
+<td><p>smallint(5)</p></td>
+<td><p>unsigned</p></td>
+<td><br />
+</td>
+<td><p>NO</p></td>
+<td>0</td>
+<td><br />
+</td>
+<td><br />
+</td>
+</tr>
+<tr class="even">
+<td><p><a href="#gm_ticket-posX">posX</a></p></td>
+<td><p>float</p></td>
+<td><p>signed</p></td>
+<td><br />
+</td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><br />
+</td>
+<td><br />
+</td>
+</tr>
+<tr class="odd">
+<td><p><a href="#gm_ticket-posY">posY</a></p></td>
+<td><p>float</p></td>
+<td><p>signed</p></td>
+<td><br />
+</td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><br />
+</td>
+<td><br />
+</td>
+</tr>
+<tr class="even">
+<td><p><a href="#gm_ticket-posZ">posZ</a></p></td>
+<td><p>float</p></td>
+<td><p>signed</p></td>
+<td><br />
+</td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><br />
+</td>
+<td><br />
+</td>
+</tr>
+<tr class="odd">
+<td><p><a href="#gm_ticket-lastModifiedTime">lastModifiedTime</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>signed</p></td>
+<td><br />
+</td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><br />
+</td>
+<td><br />
+</td>
+</tr>
+<tr class="even">
+<td><p><a href="#gm_ticket-closedBy">closedBy</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>signed</p></td>
+<td><br />
+</td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><br />
+</td>
+<td><br />
+</td>
+</tr>
+<tr class="odd">
+<td><p><a href="#gm_ticket-assignedTo">assignedTo</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><br />
+</td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><br />
+</td>
+<td><p>GUID of admin to whom ticket is assigned</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#gm_ticket-comment">comment</a></p></td>
+<td><p>text</p></td>
+<td><p>signed</p></td>
+<td><br />
+</td>
+<td><p>NO</p></td>
+<td><br />
+</td>
+<td><br />
+</td>
+<td><br />
+</td>
+</tr>
+<tr class="odd">
+<td><p><a href="#gm_ticket-response">response</a></p></td>
+<td><p>text</p></td>
+<td><p>signed</p></td>
+<td><br />
+</td>
+<td><p>NO</p></td>
+<td><br />
+</td>
+<td><br />
+</td>
+<td><br />
+</td>
+</tr>
+<tr class="even">
+<td><p><a href="#gm_ticket-completed">completed</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><br />
+</td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><br />
+</td>
+<td><br />
+</td>
+</tr>
+<tr class="odd">
+<td><p><a href="#gm_ticket-escalated">escalated</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><br />
+</td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><br />
+</td>
+<td><br />
+</td>
+</tr>
+<tr class="even">
+<td><p><a href="#gm_ticket-viewed">viewed</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><br />
+</td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><br />
+</td>
+<td><br />
+</td>
+</tr>
+<tr class="odd">
+<td><p><a href="#gm_ticket-needMoreHelp">needMoreHelp</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><br />
+</td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><br />
+</td>
+<td><br />
+</td>
+</tr>
+</tbody>
+</table>
+
+'Description of the fields'''
+
+### Id
+
+The ticket global unique identifier. This number must be unique and is the best way to identify separate tickets.
+
+### playerGuid
+
+Player's GUID. See characters.guid
+
+### name
+
+The name of the character who created that ticket
+
+### description
+
+The content of the ticket
+
+### createTime
+
+The creation time of the ticket as linux timestamp
+
+### mapId
+
+Map where ticket has ben created. See Map.dbc
+
+### posX
+
+Position X Where ticket has ben created.
+
+### posY
+
+Position Y Where ticket has ben created.
+
+### posZ
+
+Position Z Where ticket has ben created.
+
+### lastModifiedTime
+
+The time when the ticket was closed or deleted by the issuer as linux timestamp
+
+### closedBy
+
+0 : Open
+
+-1 : Closed by Console
+
+&gt;0 : player who abandoned ticket or GM who closed ticket
+
+### assignedTo
+
+Specify account number of GameMaster that have this ticket assigned.
+
+### comment
+
+The comment to the ticket, only visible to game masters
+
+### response
+
+Requires GM response. 17 = true, 1 = false (17 is default)
+
+### completed
+
+`field-no-description|14`
+
+### escalated
+
+`field-no-description|15`
+
+### viewed
+
+0 : no one has viewed the ticket.
+
+&gt;0 : How many times the ticket has been viewed.
+
+### needMoreHelp
+
+Requests further GM interaction on a ticket to which a GM has already responded. Basically means "has a new ticket"
+
+td class=