# Table: 'poll_answers'
# 
CREATE TABLE `poll_answers` (
  `answerID` int(11) NOT NULL auto_increment,
  `questionID` int(11) NOT NULL default '0',
  `result` int(10) NOT NULL default '0',
  `text` varchar(255) NOT NULL default '',
  `ordre` int(11) default NULL,
  PRIMARY KEY  (`answerID`)
) TYPE=MyISAM;


# Table: 'poll_number'
# 
CREATE TABLE `poll_number` (
  `numberID` int(11) NOT NULL auto_increment,
  `questionID` int(11) NOT NULL default '0',
  `login` char(8) NOT NULL default '',
  PRIMARY KEY  (`numberID`)
) TYPE=MyISAM;


# Table: 'poll_questions'
# 
CREATE TABLE `poll_questions` (
  `questionID` int(11) NOT NULL auto_increment,
  `question` varchar(255) NOT NULL default '',
  `begin` datetime NOT NULL default '0000-00-00 00:00:00',
  `end` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`questionID`)
) TYPE=MyISAM; 
