Stores private messages.
| Field | Type | Null | Key | Default | Description |
|---|---|---|---|---|---|
| pmid | int(10) | No | Primary | Private message ID | |
| uid | int(10) | No | Multiple | 0 | User ID of the user who 'owns' the message |
| toid | int(10) | No | 0 | User ID of the recipient | |
| fromid | int(10) | No | 0 | User ID of the sender | |
| recipients | text | No | Array of additional recipients of this PM | ||
| folder | smallint(5) | No | 1 | Folder that the PM is stored in | |
| subject | varchar(120) | No | PM subject | ||
| icon | smallint(5) | No | 0 | Post Icon ID | |
| message | text | No | PM message | ||
| dateline | bigint(30) | No | 0 | UNIX Timestamp when PM was sent | |
| deletetime | bigint(30) | No | 0 | UNIX Timestamp when PM was moved to the trash | |
| status | int(1) | No | 0 | Read/unread/replied/forwarded status of the PM | |
| statustime | bigint(30) | No | 0 | UNIX Timestamp when PM status was last updated | |
| includesig | int(1) | No | 0 | Option to include user's signature | |
| smilieoff | int(1) | No | 0 | Option to disable/enable smilies | |
| receipt | int(1) | No | 0 | Indicates receipt status | |
| readtime | bigint(30) | No | 0 | UNIX timestamp of the time when PM was read |
Indexes:
| Keyname | Type | Cardinality | Field |
|---|---|---|---|
| PRIMARY | PRIMARY | 0 | pmid |
| uid | INDEX | None | uid, folder |
| Moderation | Standard Thread Moderation - Inline Thread Moderation - Inline Post Moderation - Warning System |
| Mod CP | Home - Forums and Posts - Users |
| Admin CP | Home - Configuration - Forums & Posts - Users & Groups - Templates & Style - Tools & Maintenance |
| Templates & Themes | Images - Postbit - Templates - Themes |
| Developer | Database Methods - Database Tables |
| Miscellaneous | Cookies - UTF8 Setup - Default Settings |