-- --------------------------------------------------------

--
-- Table structure for table `tbl_poll`
--

CREATE TABLE IF NOT EXISTS `tbl_poll` (
  `poll_id` int(11) NOT NULL AUTO_INCREMENT,
  `tclass` varchar(200) NOT NULL,
  PRIMARY KEY (`poll_id`),
  KEY `tclass` (`tclass`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_item`
--

CREATE TABLE IF NOT EXISTS `tbl_item` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `poll_id` int(11) NOT NULL,
  `ikey` varchar(200) NOT NULL,
  `cnt` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`item_id`),
  KEY `poll_id` (`poll_id`,`ikey`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_ipblock`
--

CREATE TABLE IF NOT EXISTS `tbl_ipblock` (
  `ipblock_id` int(11) NOT NULL AUTO_INCREMENT,
  `poll_id` int(11) NOT NULL,
  `ipaddr` varchar(50) NOT NULL,
  PRIMARY KEY (`ipblock_id`),
  KEY `poll_id` (`poll_id`,`ipaddr`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001;


