
CREATE TABLE `#TABLEPREFIX#pollresults` (
  `pollid` bigint(20) NOT NULL default '0',
  `result` int(11) NOT NULL default '0',
  `user` varchar(100) default '',
  `ipaddress` varchar(100)default '',
  `timestamp` timestamp(14)
); 


CREATE TABLE `#TABLEPREFIX#polls` (
  `pollid` bigint(20) NOT NULL auto_increment,
  `quiz` text NOT NULL,
  `option1` tinytext NOT NULL,
  `option2` tinytext,
  `option3` tinytext,
  `option4` tinytext,
  `option5` tinytext,
  `acceptanonymous` tinyint(1)default '0',
  `creationdate` datetime default '0000-00-00 00:00:00',
  PRIMARY KEY  (`pollid`)
); 


