CREATE TABLE IF NOT EXISTS `poll_votes` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`answer_id` INT(11) ,
`poll_id` INT(11) ,
`account_id` INT(11) NOT NULL,
PRIMARY KEY (`id`),
FOREIGN KEY (`answer_id`) REFERENCES `poll_answer` (`id`) ON DELETE CASCADE,
FOREIGN KEY (`poll_id`) REFERENCES `poll` (`id`) ON DELETE CASCADE,
FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;