fud30_announce - fudforum/FUDforum GitHub Wiki
Description of FUDforum table fud30_announce. This table stores information about forum announcements. For more details, see Announcement Manager.
| Column Name | Datatype | Can be Null? | Key? | Default | Description |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | - | auto_increment |
| date_started | bigint(20) | NO | MUL | 0 | Start date/time. |
| date_ended | bigint(20) | NO | - | 0 | Stop date/time. |
| subject | varchar(255) | NO | - | - | Subject of announcement. |
| text | text | NO | - | - | Body of announcement. |
| ann_opt | int(11) | NO | - | 0 | Announcement options. Added in FUDforum 3.0.3. |
| Index Name | Uniqueness | Column Name | Seq in index | Comments |
|---|---|---|---|---|
| PRIMARY | UNIQUE | id | 1 | |
| fud30_announce_i_dd | NOT UNIQUE | date_started | 1 | |
| fud30_announce_i_dd | NOT UNIQUE | date_ended | 2 |
Binary values for ann_opt:
- 1 = show on front page (ON/OFF)