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

--
-- Table structure for table `tbl_hist`
--

CREATE TABLE IF NOT EXISTS `tbl_hist` (
  `hist_id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_create` datetime NOT NULL,
  `user_id` int(11) NOT NULL,
  `poll_id` int(11) NOT NULL,
  `vikey` varchar(100) DEFAULT NULL,
  `vbtype` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`hist_id`),
  KEY `dt_create` (`dt_create`),
  KEY `user_id` (`user_id`),
  KEY `poll_id` (`poll_id`),
  KEY `vikey` (`vikey`),
  KEY `vbtype` (`vbtype`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001 ;

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

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

CREATE TABLE IF NOT EXISTS `tbl_poll` (
  `poll_id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_create` datetime NOT NULL,
  `pkey` varchar(100) DEFAULT NULL,
  `tplsize` int(11) NOT NULL DEFAULT '0',
  `lst` text DEFAULT NULL,
  `dt_end` datetime DEFAULT NULL,
  `dt_user` datetime DEFAULT NULL,
  `dt_acnt` datetime DEFAULT NULL,
  `dt_sort` datetime DEFAULT NULL,
  PRIMARY KEY (`poll_id`),
  KEY `pkey` (`pkey`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001 ;

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

--
-- Table structure for table `tbl_user`
--

CREATE TABLE IF NOT EXISTS `tbl_user` (
  `user_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,
  PRIMARY KEY (`user_id`),
  KEY `dt_create` (`dt_create`),
  KEY `poll_id` (`poll_id`),
  KEY `ipsig` (`ipsig`),
  KEY `cksig` (`cksig`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001 ;

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

--
-- Table structure for table `tbl_vbtn`
--

CREATE TABLE IF NOT EXISTS `tbl_vbtn` (
  `vbtn_id` int(11) NOT NULL AUTO_INCREMENT,
  `poll_id` int(11) NOT NULL DEFAULT '0',
  `vikey` varchar(100) DEFAULT NULL,
  `vbtype` varchar(100) DEFAULT NULL,
  `vcnt` int(11) NOT NULL DEFAULT '0',
  `acnt` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`vbtn_id`),
  KEY `poll_id` (`poll_id`),
  KEY `vikey` (`vikey`),
  KEY `vbtype` (`vbtype`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001 ;

