Edit: /var/softaculous/advpoll/advpoll.sql (44726B)
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `soft_advpoll30`
--
-- --------------------------------------------------------
--
-- Table structure for table `poll_comment`
--
CREATE TABLE `poll_comment` (
`com_id` int(9) NOT NULL AUTO_INCREMENT,
`poll_id` int(9) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`host` varchar(255) NOT NULL,
`browser` varchar(255) NOT NULL,
`name` varchar(60) NOT NULL,
`email` varchar(100) NOT NULL,
`message` text NOT NULL,
PRIMARY KEY (`com_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `poll_comment`
--
INSERT INTO `poll_comment` VALUES
(1, 1, [[timestamp]], 'localhost', 'Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)', 'nobody', 'nobody@server.com', 'This is the first comment!');
-- --------------------------------------------------------
--
-- Table structure for table `poll_config`
--
CREATE TABLE `poll_config` (
`config_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`base_gif` varchar(60) NOT NULL,
`lang` varchar(20) NOT NULL,
`title` varchar(60) NOT NULL,
`vote_button` varchar(30) NOT NULL,
`result_text` varchar(40) NOT NULL,
`total_text` varchar(40) NOT NULL,
`voted` varchar(40) NOT NULL,
`send_com` varchar(40) NOT NULL,
`img_height` int(5) NOT NULL DEFAULT '0',
`img_length` int(5) NOT NULL DEFAULT '0',
`table_width` varchar(6) NOT NULL,
`bgcolor_tab` varchar(7) NOT NULL,
`bgcolor_fr` varchar(7) NOT NULL,
`font_face` varchar(70) NOT NULL,
`font_color` varchar(7) NOT NULL,
`type` varchar(10) NOT NULL DEFAULT '0',
`check_ip` smallint(2) NOT NULL DEFAULT '0',
`lock_timeout` int(9) NOT NULL DEFAULT '0',
`time_offset` varchar(5) NOT NULL DEFAULT '0',
`entry_pp` int(4) unsigned NOT NULL DEFAULT '0',
`poll_version` varchar(5) NOT NULL DEFAULT '0',
`base_url` varchar(100) NOT NULL DEFAULT '',
`result_order` varchar(20) NOT NULL DEFAULT '',
`def_options` smallint(3) unsigned NOT NULL DEFAULT '0',
`polls_pp` int(5) unsigned NOT NULL DEFAULT '0',
`captcha` varchar(5) NOT NULL,
PRIMARY KEY (`config_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `poll_config`
--
INSERT INTO `poll_config` VALUES
(1, '[[relativeurl]]/image', '[[language]].php', 'Advanced Poll', 'Vote', 'View results', 'Total votes', 'You have already voted!', 'Send comment', 10, 42, '170', '#FFFFFF', '#666699', 'Verdana, Arial, Helvetica, sans-serif', '#000000', 'percent', 0, 2, '0', 5, '2.0.9', '[[relativeurl]]', 'desc', 10, 12, 'on');
-- --------------------------------------------------------
--
-- Table structure for table `poll_data`
--
CREATE TABLE `poll_data` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`poll_id` int(11) NOT NULL DEFAULT '0',
`option_id` int(11) NOT NULL DEFAULT '0',
`option_text` varchar(100) NOT NULL,
`color` varchar(20) NOT NULL,
`votes` int(14) NOT NULL DEFAULT '0',
PRIMARY KEY (`poll_id`,`option_id`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
--
-- Dumping data for table `poll_data`
--
INSERT INTO `poll_data` VALUES
(1, 1, 1, 'Linux', 'blue', 49),
(2, 1, 2, 'Solaris', 'yellow', 12),
(3, 1, 3, 'FreeBSD', 'green', 29),
(4, 1, 4, 'WindowsNT', 'brown', 17),
(5, 1, 5, 'Unix', 'grey', 10),
(6, 1, 6, 'BSD', 'red', 15),
(7, 1, 7, 'other', 'purple', 9),
(12, 2, 1, 'MySQL', 'pink', 23),
(11, 2, 2, 'PostgreSQL', 'gold', 6),
(10, 2, 3, 'Oracle', 'blue', 17),
(9, 2, 4, 'MS SQL', 'green', 9),
(8, 2, 5, 'Sybase', 'orange', 2),
(13, 2, 6, 'other', 'brown', 3),
(14, 2, 7, 'DB/2', 'grey', 4),
(15, 3, 1, 'PHP', 'red', 65),
(16, 3, 2, 'Perl', 'orange', 34),
(17, 3, 3, 'ASP', 'green', 17),
(18, 3, 4, 'JSP', 'purple', 20),
(19, 3, 5, 'Python', 'gold', 7),
(20, 3, 6, 'other', 'aqua', 16);
-- --------------------------------------------------------
--
-- Table structure for table `poll_index`
--
CREATE TABLE `poll_index` (
`poll_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`question` varchar(100) NOT NULL,
`timestamp` int(11) NOT NULL DEFAULT '0',
`status` smallint(2) NOT NULL DEFAULT '0',
`logging` smallint(2) NOT NULL DEFAULT '0',
`exp_time` int(11) NOT NULL DEFAULT '0',
`expire` smallint(2) NOT NULL DEFAULT '0',
`comments` smallint(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`poll_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `poll_index`
--
INSERT INTO `poll_index` VALUES
(1, 'Which OS is your Website running on?', [[timestamp]], 1, 1, 1480253595, 1, 1),
(2, 'Which database engine do you prefer?', [[timestamp]], 1, 0, 1480253595, 0, 1),
(3, 'What is your favourite scripting language?', [[timestamp]], 1, 0, 1480253595, 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `poll_ip`
--
CREATE TABLE `poll_ip` (
`ip_id` int(11) NOT NULL AUTO_INCREMENT,
`poll_id` int(11) NOT NULL DEFAULT '0',
`ip_addr` varchar(15) NOT NULL,
`timestamp` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`ip_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `poll_log`
--
CREATE TABLE `poll_log` (
`log_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`poll_id` int(11) NOT NULL DEFAULT '0',
`option_id` int(11) NOT NULL DEFAULT '0',
`timestamp` int(11) NOT NULL DEFAULT '0',
`ip_addr` varchar(15) NOT NULL,
`host` varchar(255) NOT NULL,
`agent` varchar(255) NOT NULL DEFAULT '0',
PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `poll_templates`
--
CREATE TABLE `poll_templates` (
`tpl_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tplset_id` int(10) unsigned NOT NULL DEFAULT '0',
`title` varchar(100) NOT NULL DEFAULT '',
`template` mediumtext NOT NULL,
PRIMARY KEY (`tpl_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;
--
-- Dumping data for table `poll_templates`
--
INSERT INTO `poll_templates` VALUES
(1, 1, 'display_head', '
\r\n \r\n | \r\n \r\n $pollvars[title] | \r\n
\r\n \r\n | \r\n \r\n | \r\n
\r\n
\r\n'),
(4, 1, 'result_head', '
\r\n\r\n| \r\n\r\n$pollvars[title] | \r\n
\r\n\r\n \r\n \r\n | $question | \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n'),
(5, 1, 'result_loop', '\r\n | $option_text | \r\n  $vote_val | \r\n \r\n'),
(6, 1, 'result_foot', ' \r\n
\r\n $pollvars[total_text]: $total_votes
\r\n $VOTE
\r\n $COMMENT \r\n | \r\n | | \r\n \r\n Version $pollvars[poll_version] | \r\n \r\n \r\n | \r\n
\r\n
\r\n'),
(7, 1, 'comment', '
\r\n \r\n | \r\n Send Your Comment | \r\n
\r\n \r\n \r\n \r\n \r\n | \r\n \r\n | \r\n \r\n \r\n | \r\n
\r\n
\r\n'),
(8, 2, 'display_head', '
\r\n'),
(11, 2, 'result_head', '
\r\n \r\n | $question | \r\n
\r\n\r\n'),
(12, 2, 'result_loop', ' \r\n | $option_text | \r\n
\r\n \r\n  | \r\n $vote_val | \r\n
\r\n'),
(13, 2, 'result_foot', ' \r\n \r\n $pollvars[total_text]: $total_votes\r\n
$VOTE
$COMMENT \r\n | \r\n
\r\n \r\n | Version $pollvars[poll_version] | \r\n
\r\n
\r\n'),
(14, 2, 'comment', '
\r\n \r\n | \r\n Send Your Comment | \r\n
\r\n \r\n \r\n \r\n \r\n | \r\n \r\n | \r\n \r\n \r\n | \r\n
\r\n
\r\n'),
(15, 3, 'display_head', '
\r\n \r\n | \r\n \r\n $pollvars[title] | \r\n
\r\n \r\n | \r\n \r\n | \r\n
\r\n
\r\n'),
(18, 3, 'result_head', '
\r\n \r\n \r\n \r\n \r\n | $question | \r\n \r\n'),
(19, 3, 'result_loop', ' \r\n | | \r\n $option_text | \r\n $vote_percent % ($vote_count) | \r\n \r\n'),
(20, 3, 'result_foot', ' \r\n | $pollvars[total_text]: \r\n $total_votes | \r\n \r\n \r\n $VOTE \r\n
\r\n $COMMENT | \r\n \r\n \r\n | Version $pollvars[poll_version] | \r\n \r\n \r\n | \r\n
\r\n
\r\n'),
(21, 3, 'comment', '
\r\n \r\n | \r\n Submit Your Comment | \r\n
\r\n \r\n \r\n \r\n \r\n | \r\n \r\n | \r\n \r\n \r\n | \r\n
\r\n
\r\n'),
(22, 4, 'display_head', '
\r\n \r\n | \r\n \r\n $pollvars[title] | \r\n
\r\n \r\n | \r\n \r\n | \r\n
\r\n
\r\n'),
(25, 4, 'result_head', '
\r\n \r\n | $question | \r\n
\r\n \r\n  | \r\n \r\n \r\n \r\n \r\n '),
(26, 4, 'result_loop', ' \r\n | \r\n $option_text -\r\n $vote_val | \r\n '),
(27, 4, 'result_foot', ' \r\n | | \r\n $pollvars[total_text]: \r\n $total_votes
\r\n $COMMENT | \r\n \r\n \r\n | \r\n \r\n \r\n | \r\n
\r\n
'),
(28, 4, 'comment', '
\r\n \r\n | \r\n Submit Your Comment | \r\n
\r\n \r\n \r\n \r\n \r\n | \r\n \r\n | \r\n \r\n \r\n | \r\n
\r\n
\r\n'),
(29, 5, 'display_head', '
\r\n \r\n \r\n \r\n \r\n \r\n | $question | \r\n \r\n \r\n | \r\n \r\n | \r\n \r\n \r\n | \r\n
\r\n
\r\n'),
(32, 5, 'result_head', '
\r\n \r\n \r\n \r\n \r\n | $question | \r\n \r\n'),
(33, 5, 'result_loop', ' \r\n | | \r\n $option_text | \r\n $vote_percent % ($vote_count) | \r\n \r\n'),
(34, 5, 'result_foot', ' \r\n | $pollvars[total_text]: \r\n $total_votes | \r\n \r\n \r\n $VOTE \r\n
\r\n $COMMENT | \r\n \r\n \r\n | Version $pollvars[poll_version] | \r\n \r\n \r\n | \r\n
\r\n
\r\n'),
(35, 5, 'comment', '
\r\n \r\n | \r\n Send Your Comment | \r\n
\r\n \r\n \r\n \r\n \r\n | \r\n \r\n | \r\n \r\n \r\n | \r\n
\r\n
\r\n'),
(36, 0, 'poll_comment', '
\r\n \r\n | $data[name] \r\n $data[email] \r\n - $data[time]\r\n | \r\n
\r\n \r\n | $data[message] \r\n | \r\n
\r\n \r\n | | \r\n
\r\n
\r\n'),
(37, 0, 'poll_list', '
\r\n'),
(38, 0, 'poll_form', '
\r\n \r\n | \r\n \r\n \r\n | \r\n
\r\n
\r\n'),
(40, 0, 'poll_captcha', '
\r\n');
-- --------------------------------------------------------
--
-- Table structure for table `poll_templateset`
--
CREATE TABLE `poll_templateset` (
`tplset_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tplset_name` varchar(50) NOT NULL DEFAULT '',
`created` datetime DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`tplset_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `poll_templateset`
--
INSERT INTO `poll_templateset` VALUES
(1, 'default', '[[regtime]]'),
(2, 'simple', '[[regtime]]'),
(3, 'popup', '[[regtime]]'),
(4, 'graphic', '[[regtime]]'),
(5, 'plain', '[[regtime]]');
-- --------------------------------------------------------
--
-- Table structure for table `poll_user`
--
CREATE TABLE `poll_user` (
`user_id` smallint(5) NOT NULL AUTO_INCREMENT,
`username` varchar(30) NOT NULL,
`userpass` varchar(32) NOT NULL,
`session` varchar(32) NOT NULL,
`last_visit` int(11) NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `poll_user`
--
INSERT INTO `poll_user` VALUES
(1, '[[admin_username]]', '[[admin_pass]]', '', [[timestamp]]);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
\r\n