IP : 3.133.131.95Hostname : 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/
lve/
./
../
softaculous/
collab/
../
pimcore/
../
openb/
openb.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 */;
-- -- Table structure for table `[[dbprefix]]pages` --
CREATE TABLE `[[dbprefix]]pages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(200) DEFAULT NULL, `url_title` varchar(200) DEFAULT NULL, `author` int(11) DEFAULT '0', `date` date NOT NULL, `content` text, `status` enum('active','inactive') DEFAULT 'active', `is_home` int(1) NOT NULL DEFAULT '0', `meta_title` varchar(200) NOT NULL, `meta_keywords` varchar(200) NOT NULL, `meta_description` varchar(200) NOT NULL, `date_modified` date DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- -- Dumping data for table `[[dbprefix]]pages` --
INSERT INTO `[[dbprefix]]pages` VALUES (1, 'Welcome to Pubvana', 'welcome-to-pubvana', 1, '2016-12-22', '### Welcome\r\n\r\nIf you can see this page, Pubvana was successfully installed.\r\n\r\nIf you need help, don''t hesitate and visit the Pubvana website.\r\n\r\n*Since this is just an example post, feel free to delete it.*', 'active', 1, 'Pubvana Home Page', 'Pubvana, Blog, CMS, Website, personal, small business', 'The Pubvana Homepage', NULL);
-- -- Table structure for table `[[dbprefix]]posts` --
CREATE TABLE `[[dbprefix]]posts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `author` int(11) NOT NULL DEFAULT '0', `date_posted` date DEFAULT NULL, `title` varchar(200) NOT NULL, `url_title` varchar(200) NOT NULL, `excerpt` text NOT NULL, `content` longtext NOT NULL, `feature_image` varchar(255) DEFAULT NULL, `allow_comments` enum('0','1') NOT NULL DEFAULT '1', `sticky` enum('0','1') NOT NULL DEFAULT '0', `status` enum('draft','published') NOT NULL DEFAULT 'published', `meta_title` varchar(200) NOT NULL, `meta_keywords` varchar(200) NOT NULL, `meta_description` varchar(200) NOT NULL, `date_modified` date DEFAULT NULL, `post_count` int(20) DEFAULT '0', `featured` int(1) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- -- Dumping data for table `[[dbprefix]]posts` --
INSERT INTO `[[dbprefix]]posts` VALUES (1, 1, '2018-03-16', 'Welcome to Pubvana', 'welcome-to-pubvana', 'Congratulations! If you can see this page, Pubvana was successfully installed. If you need help, don''t hesitate and visit the Pubvana website.\r\n', '#### Congratulations!\r\n\r\nIf you can see this page, Pubvana was successfully installed.\r\n\r\nIf you need help, don''t hesitate and visit the Pubvana website.\r\n\r\n*Since this is just an example post, feel free to delete it.*', NULL, '1', '0', 'published', 'Pubvana Home Page', 'Pubvana, Blog, CMS, Website, personal, small business', 'The Pubvana Homepage', NULL, 0, 0);
-- -- Table structure for table `[[dbprefix]]widgets` --
CREATE TABLE `[[dbprefix]]widgets` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `description` varchar(200) NOT NULL, `author` varchar(50) NOT NULL, `author_email` varchar(50) NOT NULL, `author_website` varchar(50) NOT NULL, `version` varchar(50) NOT NULL, `slug` varchar(30) DEFAULT NULL, `options` text, `content` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
-- -- Dumping data for table `[[dbprefix]]widgets` --
INSERT INTO `[[dbprefix]]widgets` VALUES (1, 'HTML', 'Add arbitrary HTML to your site', 'Enliven Applications', 'info@pubvana.org', 'https://pubvana.com', '1.0.0', 'html', 'a:0:{}', ''), (2, 'Pubvana Links', 'Add Links to your website. Admin -> Links', 'Enliven Applications', 'info@pubvana.org', 'https://enlivenapp.com', '1.0.0', 'pubvana_links', 'a:1:{s:8:"numlinks";a:5:{s:10:"field_type";s:8:"dropdown";s:7:"default";s:1:"5";s:5:"label";s:15:"Number of Links";s:9:"help_text";s:55:"Choose the maximum number of links to display publicly.";s:7:"options";s:18:"1|3|5|7|9|10|15|20";}}', ''), (3, 'Pubvana Archives', 'Add Archived (Older) posts to your website.', 'Enliven Applications', 'info@pubvana.org', 'https://enlivenapp.com', '1.0.0', 'pubvana_archives', 'a:1:{s:11:"numarchives";a:5:{s:10:"field_type";s:8:"dropdown";s:7:"default";s:1:"5";s:5:"label";s:15:"Number of Links";s:9:"help_text";s:56:"Choose the maximum number of months to display publicly.";s:7:"options";s:18:"1|3|5|7|9|10|15|20";}}', ''), (4, 'Pubvana Categories', 'Display blog categories on your website. Admin -> Categories', 'Enliven Applications', 'info@pubvana.org', 'https://enlivenapp.com', '1.0.0', 'pubvana_categories', 'a:1:{s:7:"numcats";a:5:{s:10:"field_type";s:8:"dropdown";s:7:"default";s:1:"5";s:5:"label";s:20:"Number of Categories";s:9:"help_text";s:60:"Choose the maximum number of categories to display publicly.";s:7:"options";s:18:"1|3|5|7|9|10|15|20";}}', ''), (5, 'Pubvana Recent Posts', 'Show the most recent posts of your blog. Admin -> Posts', 'Enliven Applications', 'info@pubvana.org', 'https://enlivenapp.com', '1.0.0', 'pubvana_recent_posts', 'a:1:{s:8:"numposts";a:5:{s:10:"field_type";s:8:"dropdown";s:7:"default";s:1:"5";s:5:"label";s:15:"Number of Posts";s:9:"help_text";s:55:"Choose the maximum number of posts to display publicly.";s:7:"options";s:18:"1|3|5|7|9|10|15|20";}}', ''), (6, 'Login Widget', 'Widget to login to your website', 'Enliven Applications', 'info@pubvana.org', 'https://enlivenapp.com', '1.0.1', 'pubvana_login', 'a:5:{s:14:"lang_login_btn";a:4:{s:10:"field_type";s:4:"text";s:7:"default";s:5:"Login";s:5:"label";s:12:"Login Button";s:9:"help_text";s:46:"Change the language used for the login button.";}s:17:"lang_remember_btn";a:4:{s:10:"field_type";s:4:"text";s:7:"default";s:11:"Remember Me";s:5:"label";s:16:"Remember Me Text";s:9:"help_text";s:50:"Change the language used for Remember Me checkbox.";}s:15:"lang_forgot_btn";a:4:{s:10:"field_type";s:4:"text";s:7:"default";s:21:"Forgot Your Password?";s:5:"label";s:25:"Forgotten Password Button";s:9:"help_text";s:57:"Change the language used for the Forgotten Password link.";}s:16:"lang_place_ident";a:4:{s:10:"field_type";s:4:"text";s:7:"default";s:15:"you@example.com";s:5:"label";s:20:"Identity Placeholder";s:9:"help_text";s:51:"Change the language used for the Email Placeholder.";}s:15:"lang_pass_ident";a:4:{s:10:"field_type";s:4:"text";s:7:"default";s:8:"Password";s:5:"label";s:20:"Password Placeholder";s:9:"help_text";s:54:"Change the language used for the Password Placeholder.";}}', ''), (7, 'Pubvana Popular Posts', 'Show the most popular posts of your blog. Admin -> Posts', 'Enliven Applications', 'info@pubvana.org', 'https://enlivenapp.com', '1.0.0', 'pubvana_popular_posts', 'a:1:{s:8:"numposts";a:5:{s:10:"field_type";s:8:"dropdown";s:7:"default";s:1:"5";s:5:"label";s:15:"Number of Posts";s:9:"help_text";s:55:"Choose the maximum number of posts to display publicly.";s:7:"options";s:18:"1|3|5|7|9|10|15|20";}}', ''), (8, 'Featured Post', 'Shows the featured posts of your blog. Set featured post in Admin -> Posts', 'Enliven Applications', 'info@pubvana.org', 'https://enlivenapp.com', '1.0.0', 'pubvana_featured_post', 'a:0:{}', '');
-- -- Table structure for table `[[dbprefix]]widget_instances` --
CREATE TABLE `[[dbprefix]]widget_instances` ( `id` int(11) NOT NULL AUTO_INCREMENT, `widget_area_id` int(11) NOT NULL, `widget_id` int(11) NOT NULL, `title` varchar(50) NOT NULL, `show_title` int(1) NOT NULL DEFAULT '1', `options` text, `content` text, `order` int(1) NOT NULL, `active` int(1) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Constraints for dumped tables --
-- -- Constraints for table `[[dbprefix]]users_groups` -- ALTER TABLE `[[dbprefix]]users_groups` ADD CONSTRAINT `fk_[[dbprefix]]users_groups_groups1` FOREIGN KEY (`group_id`) REFERENCES `[[dbprefix]]groups` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `fk_[[dbprefix]]users_groups_users1` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`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 */;