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

--
-- Table structure for table `tbl_opt`
--

CREATE TABLE `tbl_opt` (
  `opt_id` int(11) NOT NULL AUTO_INCREMENT,
  `poll_id` int(11) NOT NULL,
  `oid` varchar(300) NOT NULL,
  `vcnt` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`opt_id`),
  KEY `poll_id` (`poll_id`),
  KEY `oid` (`oid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001 ;

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

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

CREATE TABLE `tbl_poll` (
  `poll_id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_create` datetime NOT NULL,
  `pid` varchar(300) NOT NULL,
  PRIMARY KEY (`poll_id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001 ;

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

--
-- Table structure for table `tbl_voter`
--

CREATE TABLE `tbl_voter` (
  `voter_id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_create` datetime NOT NULL,
  `poll_id` int(11) NOT NULL,
  `ipsig` varchar(100) DEFAULT NULL,
  `cksig` varchar(100) DEFAULT NULL,
  `ans` text DEFAULT NULL,
  `cnt` int(11) NOT NULL,
  PRIMARY KEY (`voter_id`),
  KEY `poll_id` (`poll_id`),
  KEY `ipsig` (`ipsig`),
  KEY `cksig` (`cksig`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001 ;

