Extension:Wigo3/wigotext table

mysql> DESCRIBE wigotext;
+---------+----------------+------+-----+---------+-------+
| Field   | Type           | Null | Key | Default | Extra |
+---------+----------------+------+-----+---------+-------+
| vote_id | varbinary(255) | NO   | PRI | NULL    |       |
| text    | mediumblob     | YES  |     | NULL    |       |
| is_cp   | tinyint(1)     | YES  |     | 0       |       |
+---------+----------------+------+-----+---------+-------+

Description

The wigotext table stores the poll question of a non-multi poll. Multi polls only have entries in the wigovote table once people have voted for said polls.

Fields

vote_id

The vote identifier, which is a string, not an integer. Corresponds to wigovote.id.

text

(Wiki)text of the non-multi poll.

is_cp

Boolean flag to indicate if the poll is one with the capture/Conservapedia links.