[Sommaire] [Imprimer]

   1  CREATE TABLE polls (
   2    poll_id int(10) unsigned NOT NULL auto_increment,
   3    poll_datestamp int(10) unsigned NOT NULL default '0',
   4    poll_start_datestamp int(10) unsigned NOT NULL default '0',
   5    poll_end_datestamp int(10) unsigned NOT NULL default '0',
   6    poll_admin_id int(10) unsigned NOT NULL default '0',
   7    poll_title varchar(250) NOT NULL default '',
   8    poll_options text NOT NULL,
   9    poll_votes text NOT NULL,
  10    poll_ip text NOT NULL,
  11    poll_type tinyint(1) unsigned NOT NULL default '0',
  12    poll_comment tinyint(1) unsigned NOT NULL default '1',
  13    poll_allow_multiple tinyint(1) unsigned NOT NULL default '0',
  14    poll_result_type tinyint(2) unsigned NOT NULL default '0',
  15    poll_vote_userclass tinyint(3) unsigned NOT NULL default '0',
  16    poll_storage_method tinyint(1) unsigned NOT NULL default '0',
  17    PRIMARY KEY  (poll_id)
  18  ) TYPE=MyISAM;