Database Tables/mybb announcements
[edit] mybb_announcements
Stores the forum announcements.
| Field | Type | Null | Key | Default | Description |
|---|---|---|---|---|---|
| aid | int | No | Primary | Announcement ID | |
| fid | int(10) | No | Multiple | 0 | Forum ID |
| uid | int | No | 0 | User ID of the author | |
| subject | varchar(120) | No | Announcement subject | ||
| message | text | No | Announcement message | ||
| startdate | bigint(30) | No | 0 | UNIX timestamp form of the date to start displaying this announcement | |
| enddate | bigint(30) | No | 0 | UNIX timestamp form of the date to stop displaying this announcement | |
| allowhtml | char(3) | No | 'yes'/'no' permission to allow raw HTML in the announcement | ||
| allowmycode | char(3) | No | 'yes'/'no' permission to parse MyCode in the announcement | ||
| allowsmilies | char(3) | No | 'yes'/'no' permission to parse Smilies in the announcement |
Indexes:
| Keyname | Type | Cardinality | Field |
|---|---|---|---|
| PRIMARY | PRIMARY | 0 | aid |
| fid | INDEX | None | fid |