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

--
-- 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(15) DEFAULT NULL,
  PRIMARY KEY (`ipblock_id`),
  KEY `poll_id` (`poll_id`),
  KEY `ipaddr` (`ipaddr`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001;

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

--
-- Table structure for table `tbl_option`
--

CREATE TABLE IF NOT EXISTS `tbl_option` (
  `option_id` int(11) NOT NULL AUTO_INCREMENT,
  `poll_id` int(11) NOT NULL,
  `cnt` int(11) DEFAULT NULL,
  PRIMARY KEY (`option_id`),
  KEY `poll_id` (`poll_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1004 ;

INSERT INTO `tbl_option` (`option_id`, `poll_id`, `cnt`) VALUES
(1001, 1001, 7453),
(1002, 1001, 5533),
(1003, 1001, 4220);

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

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

CREATE TABLE IF NOT EXISTS `tbl_poll` (
  `poll_id` int(11) NOT NULL AUTO_INCREMENT,
  `active` varchar(1) NOT NULL,
  `rlog_create_date_time` datetime DEFAULT NULL,
  `rlog_create_user_type` varchar(1) DEFAULT NULL,
  `rlog_create_user_id` int(11) DEFAULT NULL,
  `rlog_create_user_name` varchar(15) DEFAULT NULL,
  `rlog_edit_date_time` datetime DEFAULT NULL,
  `rlog_edit_user_type` varchar(1) DEFAULT NULL,
  `rlog_edit_user_id` int(11) DEFAULT NULL,
  `rlog_edit_user_name` varchar(15) DEFAULT NULL,
  `title` varchar(200) DEFAULT NULL,
  `settings` text,
  PRIMARY KEY (`poll_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1002 ;

INSERT INTO `tbl_poll` (`poll_id`, `active`, `rlog_create_date_time`, `rlog_create_user_type`, `rlog_create_user_id`, `rlog_create_user_name`, `rlog_edit_date_time`, `rlog_edit_user_type`, `rlog_edit_user_id`, `rlog_edit_user_name`, `title`, `settings`) VALUES
(1001, 'Y', '2000-01-01 00:00:00', 'S', 1001, 'admin', '2000-01-01 00:00:00', 'S', 1001, 'admin', 'Which Movie Do You Like Best?', '{"ver":"1.00","active":"Y","title":"Which Movie Do You Like Best?","options":[{"option_id":1001,"label":"Harry Potter"},{"option_id":1002,"label":"Titanic"},{"option_id":1003,"label":"Forest Gump"}],"skin_type":"gradient-green","dt_start":"","dt_end":"","multiple":"N","enable_ip_block":"Y","enable_cookie_block":"Y","b_reset_block":"N","tip_box_duration":"2500"}');

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

--
-- Table structure for table `tbl_staff`
--

CREATE TABLE IF NOT EXISTS `tbl_staff` (
  `staff_id` int(11) NOT NULL AUTO_INCREMENT,
  `active` varchar(1) NOT NULL,
  `group_id` int(11) NOT NULL,
  `username` varchar(15) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `rlog_create_date_time` datetime DEFAULT NULL,
  `rlog_create_user_type` varchar(1) DEFAULT NULL,
  `rlog_create_user_id` int(11) DEFAULT NULL,
  `rlog_create_user_name` varchar(15) DEFAULT NULL,
  `rlog_edit_date_time` datetime DEFAULT NULL,
  `rlog_edit_user_type` varchar(1) DEFAULT NULL,
  `rlog_edit_user_id` int(11) DEFAULT NULL,
  `rlog_edit_user_name` varchar(15) DEFAULT NULL,
  `rlog_last_login_date_time` datetime DEFAULT NULL,
  PRIMARY KEY (`staff_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1002 ;


INSERT INTO `tbl_staff` (`staff_id`, `active`, `group_id`, `username`, `password`, `rlog_create_date_time`, `rlog_create_user_type`, `rlog_create_user_id`, `rlog_create_user_name`, `rlog_edit_date_time`, `rlog_edit_user_type`, `rlog_edit_user_id`, `rlog_edit_user_name`, `rlog_last_login_date_time`) VALUES
(1001, 'Y', 1001, 'admin', 'password', '2010-01-01 00:00:00', 'S', 1001, 'admin', '2010-01-01 00:00:00', 'S', 1001, 'admin', '2010-01-01 00:00:00' );

