Stores the promotion logs.
| Field | Type | Null | Key | Default | Description |
|---|---|---|---|---|---|
| plid | int(10) | No | Primary | Promotion Log ID | |
| pid | int(10) | No | 0 | Promotion ID | |
| uid | int(10) | No | 0 | User ID | |
| oldusergroup | varchar(200) | No | 0 | Original user group | |
| newusergroup | smallint(6) | No | 0 | New usergroup | |
| dateline | bigint(30) | No | 0 | UNIX timestamp when user was promoted | |
| type | varchar(9) | No | primary | The type of promotion |
Indexes:
| Keyname | Type | Cardinality | Field |
|---|---|---|---|
| PRIMARY | PRIMARY | 0 | plid |
| 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 |