IP : 18.219.211.7Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
./
../
var/
softaculous/
moodle43/
../
nextcloud/
../
wp60/
../
./
seo/
seo.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!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 */;
CREATE TABLE `directories` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `domain` varchar(255) CHARACTER SET latin1 DEFAULT NULL, `submit_url` varchar(255) CHARACTER SET latin1 DEFAULT NULL, `captcha_script` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT 'captcha.php', `search_script` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT 'index.php?q=[--keyword--]', `title_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'TITLE', `url_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'URL', `description_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'DESCRIPTION', `name_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'OWNER_NAME', `email_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'OWNER_EMAIL', `category_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'CATEGORY_ID', `cptcha_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'CAPTCHA', `imagehash_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'IMAGEHASH', `imagehashurl_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'imagehash', `reciprocal_col` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'RECPR_URL', `extra_val` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', `is_captcha` tinyint(1) NOT NULL DEFAULT '0', `working` tinyint(1) NOT NULL DEFAULT '1', `google_pagerank` smallint(6) NOT NULL DEFAULT '0', `alexa_rank` int(11) NOT NULL DEFAULT '-1', `lang_code` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en', `checked` tinyint(1) NOT NULL DEFAULT '0', `script_type_id` int(11) NOT NULL DEFAULT '1', `rank` int(11) NOT NULL DEFAULT '0', `is_reciprocal` tinyint(1) NOT NULL DEFAULT '0', `pagerank` float NOT NULL DEFAULT '0', `domain_authority` float NOT NULL, `page_authority` float NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `submit_url` (`submit_url`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=160 ;
-- -- Table structure for table `di_directory_meta` --
CREATE TABLE `di_directory_meta` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL, `captcha_script` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT 'captcha.php', `search_script` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT 'index.php?q=[--keyword--]', `title_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'TITLE', `url_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'URL', `description_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'DESCRIPTION', `name_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'OWNER_NAME', `email_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'OWNER_EMAIL', `category_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'CATEGORY_ID', `cptcha_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'CAPTCHA', `imagehash_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'IMAGEHASH', `imagehashurl_col` varchar(16) CHARACTER SET latin1 NOT NULL DEFAULT 'imagehash', `reciprocal_col` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'RECPR_URL', `extra_val` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT 'LINK_TYPE=normal&submit=Continue&AGREERULES=on', `link_type_col` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'LINK_TYPE', `normal` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'normal', `free` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'free', `reciprocal` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'reciprocal', `status` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
-- -- Dumping data for table `di_directory_meta` --
-- -- Table structure for table `information_list` --
CREATE TABLE `information_list` ( `id` int(11) NOT NULL AUTO_INCREMENT, `info_type` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'news', `content` text COLLATE utf8_unicode_ci NOT NULL, `update_date` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
-- -- Dumping data for table `information_list` --
INSERT INTO `information_list` VALUES (2, 'news', ' <a style="text-decoration: none" href="https://www.seopanel.org/plugin/l/23/social-media-engine/" target="_blank" id=''news_info''>\n <b style="color:red;">*NEW*</b> <b>Download Social Media Plugin</b> to <b>automatically send and schedule status updates</b> to the popular social media\n websites like <b>facebook, LinkedIn and Twitter</b>\n </a>\n ', '[[date]]');
CREATE TABLE `qwp_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `set_label` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `set_name` varchar(64) CHARACTER SET latin1 NOT NULL, `set_val` text COLLATE utf8_unicode_ci NOT NULL, `set_type` enum('small','bool','medium','large','text') CHARACTER SET latin1 DEFAULT 'small', PRIMARY KEY (`id`), UNIQUE KEY `set_name` (`set_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
-- -- Dumping data for table `qwp_settings` --
INSERT INTO `qwp_settings` VALUES (2, 'Allow user to access the web proxy', 'QWP_ALLOW_USER_WEB_PROXY', '0', 'bool'), (3, 'Allow web server to act as a proxy', 'QWP_ALLOW_WEB_SERVER_ACT_AS_PROXY', '1', 'bool'), (4, 'Blocked Urls In Proxy', 'QWP_PROXY_BLOCK_URLS', '', 'text');
INSERT INTO `seoplugins` VALUES (1, 'Meta Tag Generator', 'MetaTagGenerator', 'Geo Varghese', 'Meta Tag Generator', '1.0.0', 'http://www.seopanel.in/plugins/', 1, 1, 100), (2, 'Test Plugin', 'TestPlugin', 'Geo Varghese', 'Seo Panel Test Plugin: Check the structure of test plugin and it will help you to create new Seo Panel Plugins.', '1.0.0', 'http://www.seopanel.in/plugins/', 0, 1, 100), (3, 'Quick Web Proxy', 'QuickWebProxy', 'Seo Panel', 'It will help you to create a web proxy server using your hosting server or external proxy servers', '2.1.0', 'https://www.seopanel.in/plugin/l/94/quick-web-proxy/', 1, 1, 100);
CREATE TABLE `translators` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `lang_code` varchar(8) NOT NULL, `trans_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `trans_company` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `trans_website` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;
-- -- Table structure for table `website_search_analytics` --
CREATE TABLE `website_search_analytics` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `website_id` int(11) NOT NULL, `clicks` int(11) NOT NULL, `impressions` int(11) NOT NULL, `ctr` float NOT NULL, `average_position` float NOT NULL, `report_date` date NOT NULL, `source` enum('google','yahoo','bing','baidu','yandex') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'google', PRIMARY KEY (`id`), KEY `website_id` (`website_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- -- Constraints for dumped tables --
-- -- Constraints for table `alerts` -- ALTER TABLE `alerts` ADD CONSTRAINT `alert_user_delete` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `review_links` -- ALTER TABLE `review_links` ADD CONSTRAINT `review_links_web_rel` FOREIGN KEY (`website_id`) REFERENCES `websites` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `review_link_results` -- ALTER TABLE `review_link_results` ADD CONSTRAINT `review_link_rel` FOREIGN KEY (`review_link_id`) REFERENCES `review_links` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `social_media_links` -- ALTER TABLE `social_media_links` ADD CONSTRAINT `social_media_links_web_rel` FOREIGN KEY (`website_id`) REFERENCES `websites` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `social_media_link_results` -- ALTER TABLE `social_media_link_results` ADD CONSTRAINT `social_media_link_rel` FOREIGN KEY (`sm_link_id`) REFERENCES `social_media_links` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `user_website_access` -- ALTER TABLE `user_website_access` ADD CONSTRAINT `website_id_user_access_delete` FOREIGN KEY (`website_id`) REFERENCES `websites` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `user_id_website_access_delete` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `website_analytics` -- ALTER TABLE `website_analytics` ADD CONSTRAINT `source_analytics_delete` FOREIGN KEY (`source_id`) REFERENCES `analytic_sources` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `website_analytics_delete` FOREIGN KEY (`website_id`) REFERENCES `websites` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
/*!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 */;