Back to the characters database list of tables.
The `petition_sign` table
This table holds information on all the signatures of a petition for either a guild or an arena team.
Structure
Field |
Type |
Null |
Key |
Default |
Extra |
int(10) unsigned |
NO |
|
|
|
|
int(11) unsigned |
NO |
PRI |
0 |
|
|
int(11) unsigned |
NO |
PRI |
0 |
|
|
int(11) unsigned |
NO |
|
0 |
|
|
int(10) unsigned |
NO |
|
0 |
|
Description of the fields
ownerguid
The GUID of the owner that is trying to make the guild/arena team. See characters.guid
petitionguid
The GUID of the charter item. See item_template.guid
playerguid
The GUID of the player that has signed the charter. See characters.guid
player_account
The account ID of the player that has signed the charter. No two players can sign the same charter from the same account.
type
The type of the petition.
ID |
Type |
|---|---|
2 |
2vs2 Arena charter |
3 |
3vs3 Arena charter |
5 |
5vs5 Arena charter |
9 |
Guild charter |