spamreports —
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| reporttime | int unsigned | 0 | ||
| posttime | int unsigned | 0 | ||
| state | enum('open','closed') | open | ||
| ip | varchar(15) | YES | ||
| journalid | int unsigned | 0 | ||
| posterid | int unsigned | 0 | ||
| subject | varchar(255) binary | YES | ||
| body | blob |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| ip | INDEX | |
| posterid | INDEX |