CREATE TABLE IF NOT EXISTS `polls` (
  `poll_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`poll_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

INSERT INTO `polls` (`poll_id`, `title`, `time`) VALUES
(1, 'Which do you prefer?', 1314951807);

CREATE TABLE IF NOT EXISTS `poll_options` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `poll_id` int(11) NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`),
  KEY `poll_id` (`poll_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

INSERT INTO `poll_options` (`id`, `poll_id`, `title`) VALUES
(1, 1, 'jQuery'),
(2, 1, 'Prototype'),
(3, 1, 'MooTools'),
(4, 1, 'MochiKit'),
(5, 1, 'Rialto');

CREATE TABLE IF NOT EXISTS `poll_votes` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `poll_id` int(11) NOT NULL,
  `option_id` int(10) unsigned NOT NULL,
  `ip` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `poll_id` (`option_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=54 ;

INSERT INTO `poll_votes` (`id`, `poll_id`, `option_id`, `ip`) VALUES
(7, 1, 2, ''),
(8, 1, 5, ''),
(9, 1, 4, ''),
(10, 1, 3, ''),
(18, 1, 1, ''),
(19, 1, 1, ''),
(20, 1, 1, ''),
(21, 1, 1, ''),
(22, 1, 1, ''),
(23, 1, 1, ''),
(24, 1, 1, ''),
(25, 1, 3, ''),
(26, 1, 2, ''),
(27, 1, 3, ''),
(28, 1, 4, ''),
(29, 1, 2, ''),
(30, 1, 3, ''),
(31, 1, 3, ''),
(32, 1, 1, ''),
(33, 1, 1, ''),
(34, 1, 1, ''),
(35, 1, 3, ''),
(36, 1, 1, ''),
(37, 1, 3, ''),
(38, 1, 1, ''),
(39, 1, 1, ''),
(40, 1, 1, ''),
(41, 1, 1, ''),
(43, 1, 1, '');