

CREATE TABLE poll (
  poll_id int(11) NOT NULL auto_increment,
  poll_question text NOT NULL,
  poll_answer1 text NOT NULL,
  poll_answer2 text NOT NULL,
  poll_answer3 text NOT NULL,
  poll_answer4 text NOT NULL,
  poll_answer5 text NOT NULL,
  poll_answer6 text NOT NULL,
  poll_active int(1) default NULL,
  PRIMARY KEY  (poll_id)
) TYPE=MyISAM;





CREATE TABLE poll_log (
  poll_log_id int(11) NOT NULL auto_increment,
  poll_id int(11) default NULL,
  user_vote int(1) default NULL,
  user_ip varchar(15) default NULL,
  user_proxy varchar(15) default NULL,
  user_time int(11) default NULL,
  PRIMARY KEY  (poll_log_id)
) TYPE=MyISAM;


