IP : 3.135.198.82Hostname : 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/
ely/
../
wp59/
../
webcal/
../
zikula/
./
zikula.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 `admin_category` --
CREATE TABLE `admin_category` ( `cid` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `icon` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `sortorder` int(11) NOT NULL, PRIMARY KEY (`cid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=7 ;
-- -- Dumping data for table `admin_category` --
INSERT INTO `admin_category` VALUES (1, 'System', 'Core modules at the heart of operation of the site.', 'fas fa-cogs', 0), (2, 'Layout', 'Layout modules for controlling the site''s look and feel.', 'fas fa-palette', 1), (3, 'Users', 'Modules for controlling user membership, access rights and profiles.', 'fas fa-users-cog', 2), (4, 'Content', 'Modules for providing content to your users.', 'fas fa-file-contract', 3), (5, 'Uncategorised', 'Newly-installed or uncategorized modules.', 'fas fa-cubes', 4), (6, 'Security', 'Modules for managing the site''s security.', 'fas fa-shield-alt', 5);
CREATE TABLE `blocks` ( `bid` int(11) NOT NULL AUTO_INCREMENT, `bkey` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `blocktype` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `properties` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)', `filter` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)', `active` int(11) NOT NULL, `last_update` datetime NOT NULL, `language` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `mid` int(11) DEFAULT NULL, PRIMARY KEY (`bid`), KEY `IDX_CEED957841AEF4CE` (`mid`), KEY `active_idx` (`active`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;
-- -- Dumping data for table `blocks` --
INSERT INTO `blocks` VALUES (1, 'Zikula\\SearchModule\\Block\\SearchBlock', 'Search', 'Search box', 'Search block', 'a:2:{s:16:"displaySearchBtn";b:1;s:6:"active";a:1:{s:17:"ZikulaUsersModule";i:1;}}', 'a:0:{}', 1, '[[regtime]]', '', 14), (2, 'Zikula\\BlocksModule\\Block\\HtmlBlock', 'Html', 'This site is powered by Zikula!', 'HTML block', 'a:1:{s:7:"content";s:1551:"<p><a href="https://ziku.la">Zikula</a> is an Open Source Content Application Framework built on top of Symfony.</p><p>With Zikula you get:</p><ul><li><strong>Power:</strong> You get the all the features of <a href="https://symfony.com">Symfony</a> PLUS: </li><li><strong>User Management:</strong> Built in User and Group management with Rights/Roles control</li><li><strong>Front end control:</strong> You can customise all aspects of the site''s appearance through themes, with support for <a href="http://jquery.com">jQuery</a>, <a href="http://getbootstrap.com">Bootstrap</a> and many other modern technologies</li><li><strong>Internationalization (i18n):</strong> You can mark content as being suitable for either a single language or for all languages, and can control all aspects of localisation of your site</li><li><strong>Extensibility:</strong> you get a standard application-programming interface (API) that lets you easily extend your site''s functionality through modules</li><li><strong>More:</strong> Admin UI, global categories, site-wide search, content blocks, menu creation, and more!</li><li><strong>Support:</strong> you can get help and support from the Zikula community of webmasters and developers at <a href="https://ziku.la">ziku.la</a>, <a href="https://github.com/zikula/core">Github</a> and <a href="https://zikula.slack.com/">Slack</a>.</li></ul><p>Enjoy using Zikula!</p><p><strong>The Zikula team</strong></p><p><em>Note: Zikula is Free Open Source Software (FOSS) licensed under the GNU General Public License.</em></p>";}', 'a:0:{}', 1, '[[regtime]]', '', 7), (3, 'Zikula\\UsersModule\\Block\\LoginBlock', 'Login', 'User log-in', 'Login block', 'a:0:{}', 'a:1:{i:0;a:4:{s:9:"attribute";s:6:"_route";s:14:"queryParameter";N;s:10:"comparator";s:2:"!=";s:5:"value";s:30:"zikulausersmodule_access_login";}}', 1, '[[regtime]]', '', 18), (4, 'Zikula\\MenuModule\\Block\\MenuBlock', 'Menu', 'Main menu', 'Main menu', 'a:2:{s:4:"name";s:8:"mainMenu";s:7:"options";s:74:"{"template": "@ZikulaMenuModule/Override/bootstrap_fontawesome.html.twig"}";}', 'a:0:{}', 1, '[[regtime]]', '', 11);
CREATE TABLE `groups` ( `gid` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL, `gtype` smallint(6) NOT NULL, `description` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `state` smallint(6) NOT NULL, `nbumax` int(11) NOT NULL, PRIMARY KEY (`gid`), UNIQUE KEY `UNIQ_F06D39705E237E06` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;
-- -- Dumping data for table `groups` --
INSERT INTO `groups` VALUES (1, 'Users', 0, 'By default, all users are made members of this group.', 0, 0), (2, 'Administrators', 0, 'Group of administrators of this site.', 0, 0);
-- -- Constraints for table `categories_registry` -- ALTER TABLE `categories_registry` ADD CONSTRAINT `FK_1B56B43312469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories_category` (`id`);
-- -- Constraints for table `group_applications` -- ALTER TABLE `group_applications` ADD CONSTRAINT `FK_1B8F2CC94C397118` FOREIGN KEY (`gid`) REFERENCES `groups` (`gid`);
-- -- Constraints for table `group_membership` -- ALTER TABLE `group_membership` ADD CONSTRAINT `FK_5132B337539B0606` FOREIGN KEY (`uid`) REFERENCES `users` (`uid`);
-- -- Constraints for table `menu_items` -- ALTER TABLE `menu_items` ADD CONSTRAINT `FK_70B2CA2A727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `menu_items` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_70B2CA2A79066886` FOREIGN KEY (`root_id`) REFERENCES `menu_items` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `users_attributes` -- ALTER TABLE `users_attributes` ADD CONSTRAINT `FK_E6F031E4A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`uid`) ON DELETE CASCADE;
/*!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 */;