Stores the e-mail logs.
Field | Type | Null | Key | Default | Description |
---|---|---|---|---|---|
mid | int(10) | No | Primary | Message ID | |
subject | varchar(200) | No | E-mail subject | ||
message | text | No | E-mail message | ||
dateline | bigint(30) | No | 0 | UNIX timestamp when message was sent | |
fromuid | int(10) | No | 0 | User ID of sending user | |
fromemail | varchar(200) | No | E-mail address of sending user | ||
touid | bigint(30) | No | 0 | User ID of receiving user | |
toemail | varchar(200) | No | E-mail address of receiving user | ||
tid | int(10) | No | 0 | Thread ID | |
ipaddress | varchar(20) | No | IP address of sending user |
Indexes:
Keyname | Type | Cardinality | Field |
---|---|---|---|
PRIMARY | PRIMARY | 0 | mid |
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 |