[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
|