Public feed
#379712
/*
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;