This article or section is outdated.
- Parts of this article or section have been written for MyBB version 1.2 and is no longer up to date.
Contributors: Please update the article to reflect the current MyBB version, and remove this template when finished.
[edit] mybb_privatemessages
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
|
| 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
|
| message | text | No |
|
| PM message
|
| dateline | bigint(30) | No |
| 0
| UNIX Timestamp when PM was sent
|
| status | int(1) | No |
| 0
| Read/unread/replied/forwarded status of the PM
|
| includesig | char(3) | No |
|
| 'yes'/'no' to include user's signature
|
| smilieoff | char(3) | No |
|
| 'yes'/'no' 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
|