CREATE TABLE IF NOT EXISTS `cand_extraanswers` (
  `cand_id` int(11) NOT NULL,
  `question_id` int(11) NOT NULL,
  `answer` text NOT NULL,
  UNIQUE KEY `index` (`cand_id`,`question_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `cand_extraquestions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `candidatepost_id` int(11) NOT NULL,
  `question` varchar(255) NOT NULL,
  `maxlength` int(11) NOT NULL,
  `order` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
