blob: f29581e7caf53e117c39c7f88489be260055b1dd (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
# petition
[<-Back-to:Characters](database-characters.md)
**The \`petition\` table**
This table holds information on all ongoing petitions for a guild or for an arena team.
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
| ----------------- | ----------- | ---------- | --- | ---- | ------- | ----- | ------- |
| [ownerguid][1] | INT | UNSIGNED | PRI | NO | | | |
| [petitionguid][2] | INT | UNSIGNED | | YES | 0 | | |
| [name][3] | VARCHAR(24) | SIGNED | | NO | | | |
| [type][4] | TINYINT | UNSIGNED | PRI | NO | 0 | | |
[1]: #ownerguid
[2]: #petitionguid
[3]: #name
[4]: #type
**Description of the fields**
### ownerguid
The petition's owner's GUID. See [characters.guid](characters#guid).
### petitionguid
The GUID of the petition item. See [item\_instance.guid](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.
| ID | Type |
|--- | ------------------ |
| 2 | 2vs2 Arena charter |
| 3 | 3vs3 Arena charter |
| 5 | 5vs5 Arena charter |
| 9 | Guild charter |
|
