Jump to content

Extension:VoteNY/Vote table

From mediawiki.org

Schema

[edit]
mysql> describe Vote;
+--------------+---------------------+------+-----+---------------------+----------------+
| Field        | Type                | Null | Key | Default             | Extra          |
+--------------+---------------------+------+-----+---------------------+----------------+
| vote_id      | int(11)             | NO   | PRI | NULL                | auto_increment |
| vote_actor   | bigint(20) unsigned | NO   | MUL | NULL                |                |
| username     | varbinary(255)      | NO   | MUL | 0                   |                |
| vote_user_id | int(11)             | NO   |     | 0                   |                |
| vote_page_id | int(11)             | NO   | MUL | 0                   |                |
| vote_value   | char(1)             | NO   | MUL |                     |                |
| vote_date    | datetime            | NO   | MUL | 1970-01-01 00:00:01 |                |
| vote_ip      | varbinary(45)       | NO   |     |                     |                |
+--------------+---------------------+------+-----+---------------------+----------------+