CREATE TABLE `question` (
  `id` int(11) NOT NULL auto_increment,
  `category_id` int(11) NOT NULL default '0',
  `question` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

INSERT INTO `question` VALUES (1, 1, 'poll1');
INSERT INTO `question` VALUES (2, 1, 'poll2');
INSERT INTO `question` VALUES (3, 1, 'poll3');
INSERT INTO `question` VALUES (4, 1, 'poll4');

CREATE TABLE `vote` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `question_id` int(11) NOT NULL default '0',
  `answer` text NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

INSERT INTO `vote` VALUES (1, 1, 1, 'answer1');
INSERT INTO `vote` VALUES (2, 1, 2, 'answer2');

CREATE TABLE `user` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `usertype` (`usertype`),
  KEY `idx_name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 AUTO_INCREMENT=1 ;

INSERT INTO `user` VALUES (1, 'User1');
INSERT INTO `user` VALUES (2, 'User2');