DROP TABLE IF EXISTS `poller`;
CREATE TABLE `poller` (
  `ID` int(11) NOT NULL auto_increment,
  `pollerTitle` varchar(255) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;



INSERT INTO `poller` VALUES (1, 'How would you rate this script?');


DROP TABLE IF EXISTS `poller_option`;
CREATE TABLE `poller_option` (
  `ID` int(11) NOT NULL auto_increment,
  `pollerID` int(11) default NULL,
  `optionText` varchar(255) default NULL,
  `pollerOrder` int(11) default NULL,
  `defaultChecked` char(1) default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;



INSERT INTO `poller_option` VALUES (1, 1, 'Excellent', 1, '1');
INSERT INTO `poller_option` VALUES (2, 1, 'Very good', 2, '0');
INSERT INTO `poller_option` VALUES (3, 1, 'Good', 3, '0');
INSERT INTO `poller_option` VALUES (4, 1, 'Fair', 3, '0');
INSERT INTO `poller_option` VALUES (5, 1, 'Poor', 4, '0');



DROP TABLE IF EXISTS `poller_vote`;
CREATE TABLE `poller_vote` (
  `ID` int(11) NOT NULL auto_increment,
  `optionID` int(11) default NULL,
  `ipAddress` varchar(255) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;