Extension:SecurePoll/securepoll votes table

From MediaWiki.org
Jump to navigation Jump to search
mysql> describe securepoll_votes;
+-------------------+----------------+------+-----+---------+----------------+
| Field             | Type           | Null | Key | Default | Extra          |
+-------------------+----------------+------+-----+---------+----------------+
| vote_id           | int(11)        | NO   | PRI | NULL    | auto_increment |
| vote_election     | int(11)        | NO   | MUL | NULL    |                |
| vote_voter        | int(11)        | NO   |     | NULL    |                |
| vote_voter_name   | varbinary(255) | NO   |     | NULL    |                |
| vote_voter_domain | varbinary(32)  | NO   |     | NULL    |                |
| vote_struck       | tinyint(4)     | NO   |     | NULL    |                |
| vote_record       | blob           | NO   |     | NULL    |                |
| vote_ip           | varbinary(35)  | NO   |     | NULL    |                |
| vote_xff          | varbinary(255) | NO   |     | NULL    |                |
| vote_ua           | varbinary(255) | NO   |     | NULL    |                |
| vote_timestamp    | varbinary(14)  | NO   |     | NULL    |                |
| vote_current      | tinyint(4)     | NO   |     | NULL    |                |
| vote_token_match  | tinyint(4)     | NO   |     | NULL    |                |
| vote_cookie_dup   | tinyint(4)     | NO   |     | NULL    |                |
+-------------------+----------------+------+-----+---------+----------------+