From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001
From: FrancescoBorzi <borzifrancesco@gmail.com>
Date: Mon, 25 Feb 2019 19:24:20 +0100
Subject: Import DB wiki from TC 335

---
 docs/petition.md | 133 +++++++++++++++++++++++++++++++++++++++++++++++++++----
 1 file changed, 125 insertions(+), 8 deletions(-)

(limited to 'docs/petition.md')

diff --git a/docs/petition.md b/docs/petition.md
index 24cf369..444e1f2 100644
--- a/docs/petition.md
+++ b/docs/petition.md
@@ -1,8 +1,125 @@
-[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [petition](petition)
-
-Column | Type | Description
---- | --- | ---
-Ownerguid | int(10) unsigned | 
-Petitionguid | int(10) unsigned | 
-Name | varchar(24) | 
-Type | tinyint(3) unsigned | 
+# petition
+
+`Back-to:Characters`
+
+**The \`petition\` table**
+
+This table holds information on all ongoing petitions for a guild or for an arena team.
+
+**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="#petition-ownerguid">ownerguid</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> </p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#petition-petitionguid">petitionguid</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>YES</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#petition-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> </p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#petition-type">type</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p>PRI</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**
+
+### ownerguid
+
+The petition's owner's GUID. See characters.guid
+
+### petitionguid
+
+The GUID of the petition item. See item\_instance.guid
+
+### name
+
+The name of the guild or arena team that the player is trying to ask for petitions for.
+
+### type
+
+The type of the petition.
+
+<table>
+<colgroup>
+<col width="50%" />
+<col width="50%" />
+</colgroup>
+<thead>
+<tr class="header">
+<th><p>ID</p></th>
+<th><p>Type</p></th>
+</tr>
+</thead>
+<tbody>
+<tr class="odd">
+<td><p>2</p></td>
+<td><p>2vs2 Arena charter</p></td>
+</tr>
+<tr class="even">
+<td><p>3</p></td>
+<td><p>3vs3 Arena charter</p></td>
+</tr>
+<tr class="odd">
+<td><p>5</p></td>
+<td><p>5vs5 Arena charter</p></td>
+</tr>
+<tr class="even">
+<td><p>9</p></td>
+<td><p>Guild charter</p></td>
+</tr>
+</tbody>
+</table>
+
+
-- 
cgit