poll —
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| pollid | int unsigned auto_increment | |||
| itemid | int unsigned | 0 | ||
| journalid | int unsigned | 0 | ||
| posterid | int unsigned | 0 | ||
| whovote | enum('all','friends') | all | ||
| whoview | enum('all','friends','none') | all | ||
| name | varchar(255) | YES |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| itemid | INDEX | |
| journalid | INDEX | |
| posterid | INDEX |