Stores post data.
| !Field | Type | Null | Key | Default | Description |
|---|---|---|---|---|---|
| pid | int(10) | No | Primary | Post ID | |
| tid | int(10) | No | Multiple | 0 | Thread ID |
| replyto | int(10) | No | 0 | Parent post ID | |
| fid | smallint(5) | No | 0 | Forum ID | |
| subject | varchar(120) | No | Post subject | ||
| icon | smallint(5) | No | 0 | Post icon | |
| uid | int(10) | No | Multiple | 0 | Author's user ID |
| username | varchar(80) | No | Author's username | ||
| dateline | bigint(30) | No | Multiple | 0 | UNIX Timestamp of the posting time |
| message | text | No | Multiple | Post content | |
| ipaddress | varchar(30) | No | Author's IP address | ||
| longipaddress | int(11) | No | Index | 0 | Author's Long IP address |
| includesig | int(1) | No | 0 | '1'/'0' to include user's signature | |
| smilieoff | int(1) | No | 0 | '1'/'0' to disable/enable smilies | |
| edituid | int(10) | No | 0 | User ID of user who last edited the post | |
| edittime | int(10) | No | 0 | UNIX Timestamp when post was last edited | |
| visible | int(1) | No | Index | 0 | Status of the post (visible, unapproved, draft) |
| posthash | varchar(32) | No | Unique hash used to correlate and limit attachments with posts |
Indexes:
| Keyname | Type | Cardinality | Field |
|---|---|---|---|
| PRIMARY | PRIMARY | 0 | pid |
| tid | INDEX | None | tid, uid |
| uid | INDEX | None | uid |
| visible | INDEX | None | visible |
| dateline | INDEX | None | dateline |
| longipaddress | INDEX | None | longipaddress |
| message | FULLTEXT | None | message |
| 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 |