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

--
-- 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,
  `caption` varchar(50) DEFAULT NULL,
  `pkey` varchar(300) DEFAULT NULL,
  `cy` int(11) NOT NULL DEFAULT '0',
  `cn` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`poll_id`),
  KEY `pkey` (`pkey`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1002;

--
-- Dumping data for table `tbl_poll`
--

INSERT INTO `tbl_poll` (`poll_id`, `dt_create`, `caption`, `pkey`, `cy`, `cn`) VALUES
(1001, '2000-01-01 00:00:00', NULL, '_preview_', 1000, 1000);

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

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

CREATE TABLE IF NOT EXISTS `tbl_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `status` tinyint(4) NOT NULL,
  `create_dt` datetime DEFAULT NULL,
  `b_admin` tinyint(4) NOT NULL DEFAULT '0',
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(24) DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  KEY `status` (`status`),
  KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1002;

--
-- Dumping data for table `tbl_user`
--

INSERT INTO `tbl_user` (`user_id`, `status`, `create_dt`, `b_admin`, `username`, `password`) VALUES
(1001, 1, '2000-01-01 00:00:00', 1, 'admin', 'password');

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

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

CREATE TABLE IF NOT EXISTS `tbl_voter` (
  `voter_id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_create` datetime NOT NULL,
  `poll_id` int(11) NOT NULL,
  `vtype` varchar(2) NOT NULL,
  `vkey` varchar(50) NOT NULL,
  `ans` varchar(1) NOT NULL,
  PRIMARY KEY (`voter_id`),
  KEY `vtype` (`vtype`),
  KEY `poll_id` (`poll_id`),
  KEY `vkey` (`vkey`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001;

