The `calendar_invites` table
Table Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| id | BIGINT | UNSIGNED | PRI | NO | 0 | ||
| event | BIGINT | UNSIGNED | NO | 0 | |||
| invitee | INT | UNSIGNED | NO | 0 | |||
| sender | INT | UNSIGNED | NO | 0 | |||
| status | TINYINT | UNSIGNED | NO | 0 | |||
| statustime | INT | UNSIGNED | NO | 0 | |||
| rank | TINYINT | UNSIGNED | NO | 0 | |||
| text | VARCHAR(255) | NO | '' |
Description of the fields
The unique ID of the invite.
The calendar event the invite is for. See calendar_events.id.
GUID of the invited character. See characters.guid.
GUID of the character that sent the invite. See characters.guid.
| Value | Status |
|---|---|
| 0 | Invited |
| 1 | Accepted |
| 2 | Declined |
| 3 | Confirmed |
| 4 | Out |
| 5 | Standby |
| 6 | Signed up |
| 7 | Not signed up |
| 8 | Tentative |
| 9 | Removed |
The time the status was last changed, in Unix time.
| Value | Rank |
|---|---|
| 0 | Player |
| 1 | Moderator |
| 2 | Owner |
The owner and moderators can invite other characters and change the event.
A note added to the invite.