-- Database chema on 3 Sep 2002

CREATE TABLE poll (
  id smallint(6) NOT NULL auto_increment,
  page smallint(6) NOT NULL default '0',
  active enum('y','n') NOT NULL default 'n',
  last date default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;


CREATE TABLE poll_data (
  id int(11) NOT NULL auto_increment,
  poll smallint(6) NOT NULL default '0',
  vote smallint(6) NOT NULL default '0',
  count int(11) NOT NULL default '0',
  opt varchar(50) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY poll (poll)
) TYPE=MyISAM;


CREATE TABLE poll_id_seq (
  id smallint(6) NOT NULL default '0'
) TYPE=MyISAM;