Code:
CREATE TABLE IF NOT EXISTS `offervotes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`offerid` int(10) unsigned NOT NULL DEFAULT '0',
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`vote` enum('yeah','against') NOT NULL DEFAULT 'yeah',
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;