phpMyAdmin can provide a detailed look at the current table definition (if you have the needed permissions).
Notes:
| Field | Notes | Valid Values |
|---|---|---|
| queue_id | identifies the queue(s) the rule applies to | the name of a queue, or "*" if the rule applies for all queues. |
| auth_key | authentication key, deprecated. | |
| user_id | identifies the actor (usually person) that the rule applies to | an "id", which is a canonicalized e-mail address, or '*' or '=' which match anyone. |
| date_updated | timestamp when this record was last updated | a Unix ctime |
| date_expires | timestamp when this record is no longer valid | a Unix ctime |
| can_create | can create requests | a permission value (see below) |
| comment | can comment on requests | a permission value (see below) |
| reply | can reply to requests | a permission value (see below) |
| summary | can display a request | a permission value (see below) |
| history | can display a request's history | a permission value (see below) |
| manipulate | can manipulate this queue | a permission value (see below) |
| admin | can admin this queue | a permission value (see below) |
| is a 'member' of this queue, that will receive mail about activity if queues.m_members_correspond is true. | a permission value (see below) |
The permission values in the above fields are small integers, with these meanings:
| Internal Name | Value | Meaning |
|---|---|---|
| perm_no | 0 | No |
| perm_yes | 1 | Yes |
| perm_own | 2 | Yes, if owner or requestor |
| perm_public | 3 | Yes, if owner or requestor, or record not private |
| perm_fields | 4 | Yes, if owner or requestor, or specific field not private |
Not all fields above can have all permission values, as some don't make sense. E.g. perm_fields makes no sense for "reply".
It is assumed that all user_id's are authenticated. Internally, there's an "identified" field which means not authenticated, only identified. It's used for the email gateway, where authentication isn't practical. In theory, that field should be added to the above.