Extension:Wigo3/wigovote table

mysql> DESCRIBE wigovote;
+------------+----------------+------+-----+---------+-------+
| Field      | Type           | Null | Key | Default | Extra |
+------------+----------------+------+-----+---------+-------+
| id         | varbinary(255) | NO   | PRI | NULL    |       |
| voter_name | varbinary(255) | NO   | PRI | NULL    |       |
| vote       | int(11)        | NO   |     | 0       |       |
| timestamp  | varbinary(14)  | YES  |     | NULL    |       |
+------------+----------------+------+-----+---------+-------+

Description

The wigovote table stores all the votes made to WIGO polls.

Fields

id

The vote identifier, which is a string, not an integer. Corresponds to wigotext.vote_id. Multi polls have the prefix "multi" whereas non-multi ones don't have a prefix.

voter_name

User name or IP address of the person who voted, depending on the value of the $wgWigo3ConfigStoreIPs configuration value.

vote

Numeric vote value; can be a negative value or a positive one.

timestamp

Timestamp in the usual TS_MW format used by MediaWiki, e.g. 20250829205136 for 2025-08-29 (29 August 2025) 20:51:36.