SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";



CREATE TABLE `ip` (
  `id` int(9) NOT NULL auto_increment,
  `ip` varchar(15) NOT NULL,
  `poll_id` int(9) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;



INSERT INTO `ip` VALUES(12, '76.217.61.249', 1);
INSERT INTO `ip` VALUES(11, '99.132.134.126', 1);


CREATE TABLE `items` (
  `id` int(9) NOT NULL auto_increment,
  `poll_id` int(9) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;


INSERT INTO `items` VALUES(1, 1, 'item 1', 'images/klickers/krew18_franklin.jpg');
INSERT INTO `items` VALUES(2, 1, 'other', 'images/klickers/krew18_franklin.jpg');
INSERT INTO `items` VALUES(3, 1, 'pen4', 'images/klickers/krew18_franklin.jpg');
INSERT INTO `items` VALUES(4, 1, 'pen3', 'images/klickers/krew18_franklin.jpg');


CREATE TABLE `polls` (
  `id` int(9) NOT NULL auto_increment,
  `date` int(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `active` int(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;


INSERT INTO `polls` VALUES(1, 112111111, 'Dev poll', 1);


CREATE TABLE `votes` (
  `id` int(9) NOT NULL auto_increment,
  `poll_id` int(9) NOT NULL,
  `item_id` int(9) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;

INSERT INTO `votes` VALUES(42, 1, 4);
INSERT INTO `votes` VALUES(41, 1, 3);
INSERT INTO `votes` VALUES(40, 1, 2);
INSERT INTO `votes` VALUES(39, 1, 3);
INSERT INTO `votes` VALUES(38, 1, 2);
INSERT INTO `votes` VALUES(37, 1, 1);
INSERT INTO `votes` VALUES(36, 1, 3);
INSERT INTO `votes` VALUES(35, 1, 2);
INSERT INTO `votes` VALUES(34, 1, 1);