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

--
-- Table structure for table `tbl_block`
--

CREATE TABLE IF NOT EXISTS `tbl_block` (
  `block_id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_create` datetime NOT NULL,
  `poll_id` int(11) NOT NULL,
  `block_type` varchar(2) DEFAULT NULL,
  `sig` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`block_id`),
  KEY `sig` (`sig`),
  KEY `rlog_create_date_time` (`dt_create`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001;


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

--
-- Table structure for table `tbl_cfgdb`
--

CREATE TABLE IF NOT EXISTS `tbl_cfgdb` (
  `cfgdb_id` int(11) NOT NULL AUTO_INCREMENT,
  `ckey` varchar(50) DEFAULT NULL,
  `cval` text,
  PRIMARY KEY (`cfgdb_id`),
  KEY `ckey` (`ckey`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001 ;

--
-- Dumping data for table `tbl_cfgdb`
--

INSERT INTO `tbl_cfgdb` (`cfgdb_id`, `ckey`, `cval`) VALUES
(1, 'tpl.mail.entry-reg', '{"subject":"Photo Contest Entry Registration","body":"Dear {{first_name}},\\r\\n\\r\\nThank you for your entry \\"{{option_title}}\\" to \\"{{poll_title}}\\"!\\r\\n\\r\\nWe''ll inform you as soon as your entry is reviewed and approved."}'),
(2, 'tpl.mail.user-reg', '{"subject":"Photo Contest Fundraising Registration","body":"Dear {{first_name}},\\r\\n\\r\\nThank you for your registration!\\r\\n\\r\\nTo log into the Photo Contest Fundraising admin panel, click the link below and enter your username and password.\\r\\n\\r\\nAdmin Panel:\\r\\n{{url_admin}}\\r\\n\\r\\nUsername : {{username}}\\r\\nPassword : {{password}}"}'),
(3, 'tpl.mail.entry-approve', '{"subject":"Your entry has been approved","body":"Dear {{first_name}},\\r\\n\\r\\nWe''d like to inform you that your entry, \\"{{option_title}}\\" has been added to \\"{{poll_title}}\\"!"}'),
(4, 'tpl.mail.vote-notify', '{"subject":"Thank you for voting for \\"{{option_title}}\\"!","body":"Dear {{first_name}},\\r\\n\\r\\nThank you for voting for \\"{{option_title}}\\"!\\r\\n\\r\\nThe total votes of \\"{{option_title}}\\" has risen to {{count}}!"}'),
(5, 'smtp', '{"hostname":"localhost","sender":"webuser@wapp.solar.lan","auth":"NONE"}'),
(6, 'sapaypal', '{"ppemail":"webuser@wapp.solar.lan","thankyou_page":null,"cancel_page":null}');

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

--
-- Table structure for table `tbl_entry`
--

CREATE TABLE IF NOT EXISTS `tbl_entry` (
  `entry_id` int(11) NOT NULL AUTO_INCREMENT,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `dt_create` datetime NOT NULL,
  `poll_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `pic` varchar(100) DEFAULT NULL,
  `ipnlog_id` int(11) DEFAULT NULL,
  `mc_gross` decimal(10,2) DEFAULT NULL,
  `mc_currency` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`entry_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001 ;


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

--
-- Table structure for table `tbl_ipnlog`
--

CREATE TABLE IF NOT EXISTS `tbl_ipnlog` (
  `ipnlog_id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_create` datetime NOT NULL,
  `mode` varchar(10) DEFAULT NULL,
  `ipaddr` varchar(15) DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `txn_id` varchar(30) DEFAULT NULL,
  `result` varchar(100) DEFAULT NULL,
  `logtxt` text,
  PRIMARY KEY (`ipnlog_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001 ;


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

--
-- Table structure for table `tbl_maillog`
--

CREATE TABLE IF NOT EXISTS `tbl_maillog` (
  `maillog_id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_create` datetime NOT NULL,
  `mtype` varchar(20) DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `result` varchar(100) DEFAULT NULL,
  `logtxt` text,
  PRIMARY KEY (`maillog_id`)
) 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=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,
  `user_id` int(11) NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `settings` text,
  `golive_user` tinyint(4) NOT NULL DEFAULT '0',
  `golive_sa` tinyint(4) NOT NULL DEFAULT '0',
  `b_listing` tinyint(1) NOT NULL DEFAULT '0',
  `site_url` varchar(200) DEFAULT NULL,
  `entry_accept` varchar(10) DEFAULT NULL,
  `entry_ppemail` varchar(100) DEFAULT NULL,
  `entry_price` decimal(10,2) DEFAULT NULL,
  `entry_currency_code` varchar(3) DEFAULT NULL,
  `entry_thankyou_page` varchar(200) DEFAULT NULL,
  `entry_cancel_page` varchar(200) DEFAULT NULL,
  `vote_accept` varchar(10) DEFAULT NULL,
  `vote_ppemail` varchar(100) DEFAULT NULL,
  `vote_price` decimal(10,2) DEFAULT NULL,
  `vote_currency_code` varchar(3) DEFAULT NULL,
  `vote_thankyou_page` varchar(200) DEFAULT NULL,
  `vote_cancel_page` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`poll_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001 ;


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

--
-- Table structure for table `tbl_upfile`
--

CREATE TABLE IF NOT EXISTS `tbl_upfile` (
  `upfile_id` int(11) NOT NULL AUTO_INCREMENT,
  `status` tinyint(1) NOT NULL,
  `dt_create` datetime NOT NULL,
  `poll_id` int(11) NOT NULL,
  `fkey` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`upfile_id`),
  KEY `poll_id` (`poll_id`)
) 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,
  `status` tinyint(4) NOT NULL,
  `dt_create` datetime DEFAULT NULL,
  `b_super` tinyint(4) NOT NULL DEFAULT '0',
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(24) DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `usess_token` varchar(100) DEFAULT NULL,
  `golive` varchar(10) DEFAULT NULL,
  `user_type` varchar(10) DEFAULT NULL,
  `payment_options` varchar(10) DEFAULT NULL,
  `organization` varchar(100) DEFAULT NULL,
  `comments` text,
  `ipnlog_id` int(11) DEFAULT NULL,
  `mc_gross` decimal(10,2) DEFAULT NULL,
  `mc_currency` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  KEY `active` (`status`),
  KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1003 ;

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

INSERT INTO `tbl_user` (`user_id`, `status`, `dt_create`, `b_super`, `username`, `password`, `first_name`, `last_name`, `email`, `usess_token`, `golive`, `user_type`, `payment_options`, `organization`, `comments`, `ipnlog_id`, `mc_gross`, `mc_currency`) VALUES
(1001, 1, '2000-01-01 00:00:00', 1, 'admin', 'password', 'super', 'admin', 'admin@admin.com', NULL, 'allow', 'indiv', '0', NULL, NULL, NULL, NULL, NULL);


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

--
-- Table structure for table `tbl_vote`
--

CREATE TABLE IF NOT EXISTS `tbl_vote` (
  `vote_id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_create` datetime NOT NULL,
  `option_id` int(11) NOT NULL,
  `poll_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `ipnlog_id` int(11) DEFAULT NULL,
  `mc_gross` decimal(10,2) DEFAULT NULL,
  `mc_currency` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`vote_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001 ;


