IP : 3.133.122.16Hostname : 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/
drupal10/
../
bagisto/
../
goffice6/
../
zentao/
../
zikula15/
./
zikula15.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 utf8_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `sortorder` int(11) NOT NULL, PRIMARY KEY (`cid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_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.', 0), (2, 'Layout', 'Layout modules for controlling the site''s look and feel.', 1), (3, 'Users', 'Modules for controlling user membership, access rights and profiles.', 2), (4, 'Content', 'Modules for providing content to your users.', 3), (5, 'Uncategorised', 'Newly-installed or uncategorized modules.', 4), (6, 'Security', 'Modules for managing the site''s security.', 5);
CREATE TABLE `blocks` ( `bid` int(11) NOT NULL AUTO_INCREMENT, `bkey` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `blocktype` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` longtext COLLATE utf8_unicode_ci NOT NULL, `properties` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)', `filter` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)', `active` int(11) NOT NULL, `last_update` datetime NOT NULL COMMENT '(DC2Type:datetime)', `language` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `mid` int(11) DEFAULT NULL, PRIMARY KEY (`bid`), KEY `IDX_CEED957841AEF4CE` (`mid`), KEY `active_idx` (`active`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
-- -- Dumping data for table `blocks` --
INSERT INTO `blocks` VALUES (1, 'ZikulaSearchModule:\\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]]', '', 2), (2, 'ZikulaBlocksModule:\\Zikula\\BlocksModule\\Block\\HtmlBlock', 'Html', 'This site is powered by Zikula!', 'HTML block', 'a:1:{s:7:"content";s:1548:"<p><a href="https://ziku.la">Zikula</a> is an Open Source Content Application Framework (CMF) built on top of Symfony.</p><p>With Zikula:</p><ul><li><strong>Power:</strong> You get the all the features of <a href="http://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]]', '', 5), (3, 'ZikulaUsersModule:\\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]]', '', 13), (4, 'ZikulaMenuModule:\\Zikula\\MenuModule\\Block\\MenuBlock', 'Menu', 'Main menu', 'Main menu', 'a:2:{s:4:"name";s:8:"mainMenu";s:7:"options";s:73:"{"template": "ZikulaMenuModule:Override:bootstrap_fontawesome.html.twig"}";}', 'a:0:{}', 1, '[[regtime]]', '', 14);
CREATE TABLE `groups` ( `gid` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `gtype` smallint(6) NOT NULL, `description` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `prefix` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `state` smallint(6) NOT NULL, `nbuser` int(11) NOT NULL, `nbumax` int(11) NOT NULL, `link` int(11) NOT NULL, `uidmaster` int(11) NOT NULL, PRIMARY KEY (`gid`), UNIQUE KEY `UNIQ_F06D39705E237E06` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_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.', 'usr', 0, 0, 0, 0, 0), (2, 'Administrators', 0, 'Group of administrators of this site.', 'adm', 0, 0, 0, 0, 0);
CREATE TABLE `themes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `type` smallint(6) NOT NULL, `displayname` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `directory` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `version` varchar(10) COLLATE utf8_unicode_ci NOT NULL, `contact` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `admin` smallint(6) NOT NULL, `user` smallint(6) NOT NULL, `system` smallint(6) NOT NULL, `state` smallint(6) NOT NULL, `xhtml` smallint(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;
-- -- Dumping data for table `themes` --
INSERT INTO `themes` VALUES (1, 'ZikulaRssTheme', 3, 'Rss', 'The RSS theme is an auxiliary theme designed specially for outputting pages as an RSS feed.', 'RssTheme', '2.0.0', '3', 0, 1, 0, 1, 1), (2, 'ZikulaAtomTheme', 3, 'Atom', 'The Atom theme is an auxiliary theme specially designed for rendering pages in Atom mark-up.', 'AtomTheme', '2.0.0', '3', 0, 1, 0, 1, 1), (3, 'ZikulaAndreas08Theme', 3, 'Andreas08', 'Based on the theme Andreas08 by Andreas Viklund', 'zikula/andreas08-theme', '2.0.3', '3', 1, 1, 0, 1, 1), (4, 'ZikulaSeaBreezeTheme', 3, 'SeaBreeze', 'The SeaBreeze theme is a browser-oriented theme.', 'zikula/seabreeze-theme', '4.0.3', '3', 1, 1, 0, 1, 1), (5, 'ZikulaPrinterTheme', 3, 'Printer', 'The Printer theme is an auxiliary theme designed specially for outputting pages in a printer-friendly format.', 'PrinterTheme', '3.0.0', '3', 0, 1, 0, 1, 1), (6, 'ZikulaBootstrapTheme', 3, 'Bootstrap', 'Bootstrap based theme', 'BootstrapTheme', '1.0.0', '3', 1, 1, 0, 1, 1);
-- -- 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 */;