Extension:VoteNY/Vote table
Appearance
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 | | | | +--------------+---------------------+------+-----+---------------------+----------------+