PetitionsTable
Requests from players to GMs (petition window)
| UE | Field | Type | Key Type | Default | Extra | Description |
|---|---|---|---|---|---|---|
| id | int(10) unsigned | PRI | auto_increment | |||
| player | int(10) | MUL | 0 | |||
| petition | blob | |||||
| status | varchar(20) | MUL | Open | |||
| category | varchar(30) | Not Assigned | ||||
| created_date | datetime | |||||
| closed_date | datetime | 0000-00-00 00:00:00 | ||||
| assigned_gm | int(10) | -1 | ||||
| resolution | blob | |||||
| escalation_level | int(10) unsigned | MUL | 1 |