CREATE TABLE IF NOT EXISTS votes_template (
    vote_id INT NOT NULL AUTO_INCREMENT, -- unique ID of vote cast
    list_id INT NOT NULL, -- list that this vote belongs to
    submission_id INT NOT NULL, -- submission that this vote belongs to
    create_dt DATETIME NOT NULL, -- timestamp of vote
    facebook_uin BIGINT NOT NULL, -- Facebook user's uin of voter, storable indefinitely
    PRIMARY KEY pk_votes_template (vote_id),
    INDEX ik_votes_template_1 (submission_id),
    INDEX ik_votes_template_2 (create_dt),
    INDEX ik_votes_template_3 (facebook_uin)
) ENGINE=MyISAM;