The only field in that table (from the copy I'm looking at) that is not required on INSERT is `gmtext` (because there wouldn't be any gmtext when the player first submits a ticket).
The structure also saves things like the level of urgency -- GMs/Guides can raise or lower an escalation level of the petition, checkouts -- should be a count of how many times the petition has been looked at with the in-game UI, lastgm -- name of the last person to have looked at the petition, etc.
Edit: I meant to include: unavailable is probably going to be the count of how many times a GM checked out the petition but the player wasn't around to respond.
Last edited by ndnet; 04-28-2008 at 05:27 PM..
Reason: Quick inclusion
|