/*
MySQL Data Transfer
Source Host: localhost
Source Database: systembit
Target Host: localhost
Target Database: systembit
Date: 2007.03.03 15:12:05
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for vote_can_comment
-- ----------------------------
CREATE TABLE `vote_can_comment` (
  `poll_id` int(11) NOT NULL,
  `nick` varchar(32) NOT NULL,
  `option_id` int(11) NOT NULL,
  PRIMARY KEY  (`poll_id`,`nick`,`option_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for vote_cheaters
-- ----------------------------
CREATE TABLE `vote_cheaters` (
  `poll_id` int(11) NOT NULL,
  `org_nick` varchar(32) NOT NULL,
  `fake_nick` varchar(32) NOT NULL,
  `name` varchar(128) NOT NULL,
  `ident` varchar(32) NOT NULL,
  `host` varchar(256) NOT NULL,
  `vote_multiid` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY  (`poll_id`,`org_nick`,`fake_nick`,`name`,`ident`,`host`,`vote_multiid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for vote_comm
-- ----------------------------
CREATE TABLE `vote_comm` (
  `poll_id` int(11) NOT NULL,
  `nick` varchar(32) NOT NULL,
  `option_id` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `comment` varchar(256) NOT NULL,
  PRIMARY KEY  (`poll_id`,`nick`,`option_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for vote_desc
-- ----------------------------
CREATE TABLE `vote_desc` (
  `poll_id` int(11) NOT NULL auto_increment,
  `start_time` int(11) NOT NULL,
  `end_time` int(11) NOT NULL,
  `notify_delay` int(11) NOT NULL,
  `vote_desc` varchar(256) NOT NULL,
  `network` varchar(256) NOT NULL,
  `channels` varchar(256) NOT NULL,
  `is_grouped` decimal(1,0) NOT NULL default '0',
  `is_multiid` decimal(1,0) NOT NULL default '0',
  `language_template` varchar(6) NOT NULL default 'LT',
  `active` int(11) NOT NULL default '0',
  PRIMARY KEY  (`poll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for vote_groups
-- ----------------------------
CREATE TABLE `vote_groups` (
  `poll_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `group_text` varchar(128) NOT NULL,
  `votes` int(11) NOT NULL default '0',
  PRIMARY KEY  (`poll_id`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for vote_multiid
-- ----------------------------
CREATE TABLE `vote_multiid` (
  `poll_id` int(11) NOT NULL,
  `vote_multiid` int(11) NOT NULL,
  `text` varchar(256) NOT NULL,
  `votes` int(11) NOT NULL default '0',
  PRIMARY KEY  (`poll_id`,`vote_multiid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for vote_options
-- ----------------------------
CREATE TABLE `vote_options` (
  `poll_id` int(11) NOT NULL,
  `option_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `option_text` varchar(64) NOT NULL,
  `multivote_id` int(11) NOT NULL,
  `votes` int(11) NOT NULL default '0',
  PRIMARY KEY  (`poll_id`,`option_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for vote_voters
-- ----------------------------
CREATE TABLE `vote_voters` (
  `poll_id` int(11) NOT NULL,
  `nick` varchar(32) NOT NULL,
  `option_id` int(11) NOT NULL,
  PRIMARY KEY  (`poll_id`,`nick`,`option_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;