Default page

Edit File: 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 */;

--
-- Database: `zikula304`
--

-- --------------------------------------------------------

--
-- 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);

-- --------------------------------------------------------

--
-- Table structure for table `admin_module`
--

CREATE TABLE `admin_module` (
  `amid` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `sortorder` int(11) NOT NULL,
  PRIMARY KEY (`amid`),
  KEY `mid_cid` (`mid`,`cid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=20 ;

--
-- Dumping data for table `admin_module`
--

INSERT INTO `admin_module` VALUES
(1, 6, 1, 0),
(2, 7, 2, 0),
(3, 8, 4, 0),
(4, 1, 1, 1),
(5, 9, 3, 0),
(6, 10, 1, 2),
(7, 11, 4, 1),
(8, 12, 3, 1),
(9, 13, 1, 3),
(10, 14, 4, 2),
(11, 15, 6, 0),
(12, 16, 1, 4),
(13, 17, 2, 1),
(14, 18, 3, 2),
(15, 19, 3, 3),
(16, 20, 2, 2),
(17, 21, 2, 3),
(18, 22, 2, 4),
(19, 23, 2, 5);

-- --------------------------------------------------------

--
-- Table structure for table `blocks`
--

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:"<a href="https://ziku.la">Zikula</a> is an Open Source Content Application Framework built on top of Symfony.With Zikula you get:<ul><li>Power: You get the all the features of <a href="https://symfony.com">Symfony</a> PLUS: </li><li>User Management: Built in User and Group management with Rights/Roles control</li><li>Front end control: 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>Internationalization (i18n): 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>Extensibility: you get a standard application-programming interface (API) that lets you easily extend your site''s functionality through modules</li><li>More: Admin UI, global categories, site-wide search, content blocks, menu creation, and more!</li><li>Support: 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>Enjoy using Zikula!The Zikula teamNote: Zikula is Free Open Source Software (FOSS) licensed under the GNU General Public License.";}', '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);

-- --------------------------------------------------------

--
-- Table structure for table `block_placements`
--

CREATE TABLE `block_placements` (
  `pid` int(11) NOT NULL,
  `bid` int(11) NOT NULL,
  `sortorder` int(11) NOT NULL,
  PRIMARY KEY (`pid`,`bid`),
  KEY `IDX_911332125550C4ED` (`pid`),
  KEY `IDX_911332124AF2B3F3` (`bid`),
  KEY `bid_pid_idx` (`bid`,`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `block_placements`
--

INSERT INTO `block_placements` VALUES
(1, 1, 0),
(3, 2, 0),
(7, 3, 1),
(7, 4, 0);

-- --------------------------------------------------------

--
-- Table structure for table `block_positions`
--

CREATE TABLE `block_positions` (
  `pid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=9 ;

--
-- Dumping data for table `block_positions`
--

INSERT INTO `block_positions` VALUES
(1, 'left', 'Left blocks'),
(2, 'right', 'Right blocks'),
(3, 'center', 'Center blocks'),
(4, 'search', 'Search block'),
(5, 'header', 'Header block'),
(6, 'footer', 'Footer block'),
(7, 'topnav', 'Top navigation block'),
(8, 'bottomnav', 'Bottom navigation block');

-- --------------------------------------------------------

--
-- Table structure for table `bundles`
--

CREATE TABLE `bundles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bundlename` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `autoload` varchar(384) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bundleclass` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bundletype` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_D8A73A9867B776D8` (`bundlename`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `bundles`
--

INSERT INTO `bundles` VALUES
(1, 'zikula/legal-module', 'a:1:{s:5:"psr-4";a:1:{s:19:"Zikula\\LegalModule\\";s:30:"extensions/zikula/legal-module";}}', 'Zikula\\LegalModule\\ZikulaLegalModule', 'M'),
(2, 'zikula/oauth-module', 'a:1:{s:5:"psr-4";a:1:{s:19:"Zikula\\OAuthModule\\";s:30:"extensions/zikula/oauth-module";}}', 'Zikula\\OAuthModule\\ZikulaOAuthModule', 'M'),
(3, 'zikula/pagelock-module', 'a:1:{s:5:"psr-4";a:1:{s:22:"Zikula\\PageLockModule\\";s:33:"extensions/zikula/pagelock-module";}}', 'Zikula\\PageLockModule\\ZikulaPageLockModule', 'M'),
(4, 'zikula/profile-module', 'a:1:{s:5:"psr-4";a:1:{s:21:"Zikula\\ProfileModule\\";s:32:"extensions/zikula/profile-module";}}', 'Zikula\\ProfileModule\\ZikulaProfileModule', 'M');

-- --------------------------------------------------------

--
-- Table structure for table `categories_attributes`
--

CREATE TABLE `categories_attributes` (
  `name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` int(11) NOT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`category_id`,`name`),
  KEY `IDX_9015DE7812469DE2` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories_attributes`
--

INSERT INTO `categories_attributes` VALUES
('code', 11, 'P'),
('code', 12, 'C'),
('code', 13, 'A'),
('code', 14, 'O'),
('code', 15, 'R'),
('code', 26, 'A'),
('code', 27, 'I'),
('code', 29, 'P'),
('code', 30, 'A');

-- --------------------------------------------------------

--
-- Table structure for table `categories_category`
--

CREATE TABLE `categories_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tree_root` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `lft` int(11) NOT NULL,
  `lvl` int(11) NOT NULL,
  `rgt` int(11) NOT NULL,
  `is_locked` tinyint(1) NOT NULL,
  `is_leaf` tinyint(1) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `display_desc` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `status` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cr_date` datetime NOT NULL,
  `lu_date` datetime NOT NULL,
  `cr_uid` int(11) DEFAULT NULL,
  `lu_uid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D0B2B0F8A977936C` (`tree_root`),
  KEY `IDX_D0B2B0F8727ACA70` (`parent_id`),
  KEY `IDX_D0B2B0F88304AF18` (`cr_uid`),
  KEY `IDX_D0B2B0F8C072C1DD` (`lu_uid`),
  KEY `idx_categories_is_leaf` (`is_leaf`),
  KEY `idx_categories_status` (`status`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=10000 ;

--
-- Dumping data for table `categories_category`
--

INSERT INTO `categories_category` VALUES
(1, 1, NULL, 1, 0, 50, 1, 0, '__SYSTEM__', '', 'a:1:{s:2:"en";s:13:"Category root";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(2, 1, 1, 2, 1, 23, 0, 0, 'Modules', '', 'a:1:{s:2:"en";s:7:"Modules";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(3, 1, 1, 24, 1, 49, 0, 0, 'General', '', 'a:1:{s:2:"en";s:7:"General";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(10, 1, 3, 25, 2, 36, 0, 0, 'Publication Status (extended)', '', 'a:1:{s:2:"en";s:29:"Publication status (extended)";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(11, 1, 10, 26, 3, 27, 0, 1, 'Pending', 'P', 'a:1:{s:2:"en";s:7:"Pending";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(12, 1, 10, 28, 3, 29, 0, 1, 'Checked', 'C', 'a:1:{s:2:"en";s:7:"Checked";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(13, 1, 10, 30, 3, 31, 0, 1, 'Approved', 'A', 'a:1:{s:2:"en";s:8:"Approved";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(14, 1, 10, 32, 3, 33, 0, 1, 'On-line', 'O', 'a:1:{s:2:"en";s:7:"On-line";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(15, 1, 10, 34, 3, 35, 0, 1, 'Rejected', 'R', 'a:1:{s:2:"en";s:8:"Rejected";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(25, 1, 3, 37, 2, 42, 0, 0, 'ActiveStatus', '', 'a:1:{s:2:"en";s:15:"Activity status";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(26, 1, 25, 38, 3, 39, 0, 1, 'Active', 'A', 'a:1:{s:2:"en";s:6:"Active";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(27, 1, 25, 40, 3, 41, 0, 1, 'Inactive', 'I', 'a:1:{s:2:"en";s:8:"Inactive";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(28, 1, 3, 43, 2, 48, 0, 0, 'Publication status (basic)', '', 'a:1:{s:2:"en";s:26:"Publication status (basic)";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(29, 1, 28, 44, 3, 45, 0, 1, 'Pending', 'P', 'a:1:{s:2:"en";s:7:"Pending";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(30, 1, 28, 46, 3, 47, 0, 1, 'Approved', 'A', 'a:1:{s:2:"en";s:8:"Approved";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(32, 1, 2, 3, 2, 22, 0, 0, 'Global', '', 'a:1:{s:2:"en";s:6:"Global";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(33, 1, 32, 4, 3, 5, 0, 1, 'Blogging', '', 'a:1:{s:2:"en";s:8:"Blogging";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(34, 1, 32, 6, 3, 7, 0, 1, 'Music and audio', '', 'a:1:{s:2:"en";s:15:"Music and audio";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(35, 1, 32, 8, 3, 9, 0, 1, 'Art and photography', '', 'a:1:{s:2:"en";s:19:"Art and photography";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(36, 1, 32, 10, 3, 11, 0, 1, 'Writing and thinking', '', 'a:1:{s:2:"en";s:20:"Writing and thinking";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(37, 1, 32, 12, 3, 13, 0, 1, 'Communications and media', '', 'a:1:{s:2:"en";s:24:"Communications and media";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(38, 1, 32, 14, 3, 15, 0, 1, 'Travel and culture', '', 'a:1:{s:2:"en";s:18:"Travel and culture";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(39, 1, 32, 16, 3, 17, 0, 1, 'Science and technology', '', 'a:1:{s:2:"en";s:22:"Science and technology";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(40, 1, 32, 18, 3, 19, 0, 1, 'Sport and activities', '', 'a:1:{s:2:"en";s:20:"Sport and activities";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2),
(41, 1, 32, 20, 3, 21, 0, 1, 'Business and work', '', 'a:1:{s:2:"en";s:17:"Business and work";}', 'a:1:{s:2:"en";s:0:"";}', 'A', '', '[[regtime]]', '[[regtime]]', 2, 2);

-- --------------------------------------------------------

--
-- Table structure for table `categories_registry`
--

CREATE TABLE `categories_registry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `modname` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `entityname` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `property` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `obj_status` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cr_date` datetime NOT NULL,
  `lu_date` datetime NOT NULL,
  `cr_uid` int(11) DEFAULT NULL,
  `lu_uid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_1B56B43312469DE2` (`category_id`),
  KEY `IDX_1B56B4338304AF18` (`cr_uid`),
  KEY `IDX_1B56B433C072C1DD` (`lu_uid`),
  KEY `idx_categories_registry` (`modname`,`entityname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `extensions`
--

CREATE TABLE `extensions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` int(11) NOT NULL,
  `displayname` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `capabilities` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `state` int(11) NOT NULL,
  `securityschema` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `coreCompatibility` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=24 ;

--
-- Dumping data for table `extensions`
--

INSERT INTO `extensions` VALUES
(1, 'ZikulaExtensionsModule', 3, 'Extensions', 'extensions', 'Extensions administration', '3.0.4', 'fas fa-plug', 'a:1:{s:5:"admin";a:1:{s:5:"route";s:37:"zikulaextensionsmodule_extension_list";}}', 3, 'a:2:{s:24:"ZikulaExtensionsModule::";s:2:"::";s:30:"ZikulaExtensionsModule::modify";s:27:"extensionName::extensionsId";}', '>=3.0.0'),
(2, 'ZikulaLegalModule', 2, 'Legal', 'legal', 'Provides an interface for managing the site''s legal documents.', '3.2.10', 'fas fa-gavel', 'a:2:{s:5:"admin";a:1:{s:5:"route";s:31:"zikulalegalmodule_config_config";}s:4:"user";a:1:{s:5:"route";s:33:"zikulalegalmodule_user_termsofuse";}}', 1, 'a:8:{s:19:"ZikulaLegalModule::";s:2:"::";s:30:"ZikulaLegalModule::legalNotice";s:2:"::";s:29:"ZikulaLegalModule::termsOfUse";s:2:"::";s:32:"ZikulaLegalModule::privacyPolicy";s:2:"::";s:28:"ZikulaLegalModule::agePolicy";s:2:"::";s:41:"ZikulaLegalModule::accessibilityStatement";s:2:"::";s:42:"ZikulaLegalModule::cancellationRightPolicy";s:2:"::";s:34:"ZikulaLegalModule::tradeConditions";s:2:"::";}', '>=3.0.0'),
(3, 'ZikulaOAuthModule', 2, 'OAuthModule', 'oauth', 'Integrates league/oauth2-client and various providers.', '1.2.3', 'fas fa-network-wired', 'a:1:{s:5:"admin";a:1:{s:5:"route";s:33:"zikulaoauthmodule_config_settings";}}', 1, 'a:1:{s:19:"ZikulaOAuthModule::";s:2:"::";}', '>=3.0.0'),
(4, 'ZikulaPageLockModule', 2, 'Page lock', 'pagelock', 'Page locking support', '1.3.9', 'fas fa-lock', 'a:0:{}', 1, 'a:1:{s:22:"ZikulaPageLockModule::";s:2:"::";}', '>=3.0.0'),
(5, 'ZikulaProfileModule', 2, 'Profile', 'profile', 'User profiles and member list', '3.1.18', 'fas fa-id-card', 'a:2:{s:5:"admin";a:1:{s:5:"route";s:43:"zikulaprofilemodule_property_listproperties";}s:4:"user";a:1:{s:5:"route";s:35:"zikulaprofilemodule_profile_display";}}', 1, 'a:11:{s:21:"ZikulaProfileModule::";s:2:"::";s:25:"ZikulaProfileModule::view";s:2:"::";s:25:"ZikulaProfileModule::item";s:12:"PropertyId::";s:28:"ZikulaProfileModule:Members:";s:2:"::";s:34:"ZikulaProfileModule:Members:recent";s:2:"::";s:34:"ZikulaProfileModule:Members:online";s:2:"::";s:38:"ZikulaProfileModule:FeaturedUserblock:";s:13:"Block title::";s:34:"ZikulaProfileModule:LastSeenblock:";s:13:"Block title::";s:36:"ZikulaProfileModule:LastXUsersblock:";s:13:"Block title::";s:39:"ZikulaProfileModule:MembersOnlineblock:";s:13:"Block title::";s:11:"Userblock::";s:13:"Block title::";}', '>=3.0.0'),
(6, 'ZikulaAdminModule', 3, 'Administration panel', 'adminpanel', 'Backend administration interface', '3.0.4', 'fas fa-object-group', 'a:1:{s:5:"admin";a:1:{s:5:"route";s:28:"zikulaadminmodule_admin_view";}}', 3, 'a:3:{s:19:"ZikulaAdminModule::";s:2:"::";s:27:"ZikulaAdminModule:Category:";s:38:"Admin Category name::Admin Category ID";s:32:"ZikulaAdminModule:adminnavblock:";s:21:"Block title::Block ID";}', '>=3.0.0'),
(7, 'ZikulaBlocksModule', 3, 'Blocks Module', 'blocks', 'Blocks administration', '3.0.4', 'fas fa-table', 'a:1:{s:5:"admin";a:1:{s:5:"route";s:29:"zikulablocksmodule_admin_view";}}', 3, 'a:9:{s:20:"ZikulaBlocksModule::";s:30:"Block key:Block title:Block ID";s:28:"ZikulaBlocksModule::position";s:26:"Position name::Position ID";s:15:"fincludeblock::";s:13:"Block title::";s:11:"HTMLblock::";s:13:"Block title::";s:14:"HTMLblock::bid";s:5:"::bid";s:16:"PendingContent::";s:13:"Block title::";s:11:"Textblock::";s:13:"Block title::";s:14:"Textblock::bid";s:5:"::bid";s:11:"xsltblock::";s:13:"Block title::";}', '>=3.0.0'),
(8, 'ZikulaCategoriesModule', 3, 'Categories', 'categories', 'Categories administration', '3.0.4', 'fas fa-sitemap', 'a:1:{s:5:"admin";a:1:{s:5:"route";s:36:"zikulacategoriesmodule_category_list";}}', 3, 'a:2:{s:24:"ZikulaCategoriesModule::";s:2:"::";s:44:"ZikulaCategoriesModule:PropertyId:CategoryId";s:15:"$propId::$catId";}', '>=3.0.0'),
(9, 'ZikulaGroupsModule', 3, 'Groups', 'groups', 'User group administration', '3.0.4', 'fas fa-users', 'a:2:{s:5:"admin";a:1:{s:5:"route";s:34:"zikulagroupsmodule_group_adminlist";}s:4:"user";a:1:{s:5:"route";s:29:"zikulagroupsmodule_group_list";}}', 3, 'a:2:{s:20:"ZikulaGroupsModule::";s:10:"Group ID::";s:31:"ZikulaGroupsModule::memberslist";s:2:"::";}', '>=3.0.0'),
(10, 'ZikulaMailerModule', 3, 'Mailer Module', 'mailer', 'Mailer support', '3.0.4', 'fas fa-envelope', 'a:1:{s:5:"admin";a:1:{s:5:"route";s:32:"zikulamailermodule_config_config";}}', 3, 'a:1:{s:20:"ZikulaMailerModule::";s:2:"::";}', '>=3.0.0'),
(11, 'ZikulaMenuModule', 3, 'Menu Module', 'menu', 'Menu management', '3.0.4', 'fas fa-compass', 'a:1:{s:5:"admin";a:1:{s:5:"route";s:26:"zikulamenumodule_menu_list";}}', 3, 'a:2:{s:18:"ZikulaMenuModule::";s:2:"::";s:20:"ZikulaMenuModule::id";s:4:"::id";}', '>=3.0.0'),
(12, 'ZikulaPermissionsModule', 3, 'Permissions', 'permissions', 'User permissions manager', '3.0.4', 'fas fa-key', 'a:1:{s:5:"admin";a:1:{s:5:"route";s:39:"zikulapermissionsmodule_permission_list";}}', 3, 'a:1:{s:25:"ZikulaPermissionsModule::";s:2:"::";}', '>=3.0.0'),
(13, 'ZikulaRoutesModule', 3, 'Routes', 'routes', 'Routes management', '3.0.4', 'fas fa-map-marked-alt', 'a:2:{s:5:"admin";a:1:{s:5:"route";s:35:"zikularoutesmodule_route_adminindex";}s:4:"user";a:1:{s:5:"route";s:30:"zikularoutesmodule_route_index";}}', 3, 'a:3:{s:20:"ZikulaRoutesModule::";s:2:"::";s:25:"ZikulaRoutesModule:Route:";s:10:"Route ID::";s:24:"ZikulaRoutesModule::Ajax";s:2:"::";}', '>=3.0.0 <4.0.0'),
(14, 'ZikulaSearchModule', 3, 'Site search', 'search', 'Site search support', '3.0.4', 'fas fa-search', 'a:2:{s:5:"admin";a:1:{s:5:"route";s:32:"zikulasearchmodule_config_config";}s:4:"user";a:1:{s:5:"route";s:33:"zikulasearchmodule_search_execute";}}', 3, 'a:2:{s:20:"ZikulaSearchModule::";s:13:"Module name::";s:13:"Searchblock::";s:13:"Block title::";}', '>=3.0.0'),
(15, 'ZikulaSecurityCenterModule', 3, 'Security Center', 'securitycenter', 'Security administration', '3.0.4', 'fas fa-shield-alt', 'a:1:{s:5:"admin";a:1:{s:5:"route";s:40:"zikulasecuritycentermodule_config_config";}}', 3, 'a:1:{s:28:"ZikulaSecurityCenterModule::";s:2:"::";}', '>=3.0.0'),
(16, 'ZikulaSettingsModule', 3, 'General settings', 'settings', 'System settings administration', '3.0.4', 'fas fa-tools', 'a:1:{s:5:"admin";a:1:{s:5:"route";s:34:"zikulasettingsmodule_settings_main";}}', 3, 'a:3:{s:22:"ZikulaSettingsModule::";s:2:"::";s:13:"LocaleBlock::";s:2:"::";s:16:"LocaleBlock::bid";s:5:"::bid";}', '>=3.0.0'),
(17, 'ZikulaThemeModule', 3, 'Theme Module', 'theme', 'Theme system and administration', '3.0.4', 'fas fa-palette', 'a:1:{s:5:"admin";a:1:{s:5:"route";s:31:"zikulathememodule_config_config";}}', 3, 'a:0:{}', '>=3.0.0'),
(18, 'ZikulaUsersModule', 3, 'Users Module', 'users', 'User account administration', '3.0.4', 'fas fa-users-cog', 'a:2:{s:5:"admin";a:1:{s:5:"route";s:41:"zikulausersmodule_useradministration_list";}s:4:"user";a:1:{s:5:"route";s:30:"zikulausersmodule_account_menu";}}', 3, 'a:6:{s:19:"ZikulaUsersModule::";s:14:"Uname::User ID";s:29:"ZikulaUsersModule::LiveSearch";s:2:"::";s:28:"ZikulaUsersModule::MailUsers";s:2:"::";s:14:"Accountlinks::";s:13:"Block title::";s:12:"Loginblock::";s:13:"Block title::";s:13:"Onlineblock::";s:10:"Block ID::";}', '>=3.0.0'),
(19, 'ZikulaZAuthModule', 3, 'Zikula Native Authorization', 'zauth', 'Native zikula authentication', '3.0.4', 'fas fa-user-lock', 'a:1:{s:5:"admin";a:1:{s:5:"route";s:41:"zikulazauthmodule_useradministration_list";}}', 3, 'a:1:{s:19:"ZikulaZAuthModule::";s:2:"::";}', '>=3.0.0'),
(20, 'ZikulaAtomTheme', 5, 'Atom Theme', '', 'The Atom theme is an auxiliary theme specially designed for rendering pages in Atom mark-up.', '3.0.4', 'fas fa-atom', 'a:2:{s:4:"user";a:1:{s:5:"theme";b:1;}s:5:"admin";a:1:{s:5:"theme";b:0;}}', 3, 'a:0:{}', '>=3.0.0'),
(21, 'ZikulaBootstrapTheme', 5, 'Bootstrap Theme', '', 'Bootstrap based theme', '3.0.4', 'fab fa-bootstrap', 'a:2:{s:4:"user";a:1:{s:5:"theme";b:1;}s:5:"admin";a:1:{s:5:"theme";b:1;}}', 3, 'a:0:{}', '>=3.0.0'),
(22, 'ZikulaPrinterTheme', 5, 'Printer Theme', '', 'The Printer theme is an auxiliary theme designed specially for outputting pages in a printer-friendly format.', '3.0.4', 'fas fa-print', 'a:2:{s:4:"user";a:1:{s:5:"theme";b:1;}s:5:"admin";a:1:{s:5:"theme";b:0;}}', 3, 'a:0:{}', '>=3.0.0'),
(23, 'ZikulaRssTheme', 5, 'Rss Theme', '', 'The RSS theme is an auxiliary theme designed specially for outputting pages as an RSS feed.', '3.0.4', 'fas fa-rss', 'a:2:{s:4:"user";a:1:{s:5:"theme";b:1;}s:5:"admin";a:1:{s:5:"theme";b:0;}}', 3, 'a:0:{}', '>=3.0.0');

-- --------------------------------------------------------

--
-- Table structure for table `extension_deps`
--

CREATE TABLE `extension_deps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modid` int(11) NOT NULL,
  `modname` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `minversion` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `maxversion` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=97 ;

--
-- Dumping data for table `extension_deps`
--

INSERT INTO `extension_deps` VALUES
(1, 2, 'php', '>=7.2.5', '>=7.2.5', 1),
(2, 3, 'php', '>=7.2.5', '>=7.2.5', 1),
(3, 3, 'league/oauth2-facebook', '2.*', '2.*', 1),
(4, 3, 'league/oauth2-github', '2.*', '2.*', 1),
(5, 3, 'league/oauth2-google', '3.*', '3.*', 1),
(6, 3, 'league/oauth2-instagram', '2.*', '2.*', 1),
(7, 3, 'league/oauth2-linkedin', '4.*', '4.*', 1),
(8, 4, 'php', '>=7.2.5', '>=7.2.5', 1),
(9, 5, 'php', '>=7.2.5', '>=7.2.5', 1),
(10, 6, 'php', '>=7.2.5', '>=7.2.5', 1),
(11, 6, 'zikula/core-bundle', '3.*', '3.*', 1),
(12, 6, 'frdh/mmenu.js', '8.*', '8.*', 1),
(13, 7, 'php', '>=7.2.5', '>=7.2.5', 1),
(14, 7, 'zikula/core-bundle', '3.*', '3.*', 1),
(15, 7, 'zikula/theme-module', '3.*', '3.*', 1),
(16, 7, 'Scribite', '>=6.0.2', '>=6.0.2', 2),
(17, 8, 'php', '>=7.2.5', '>=7.2.5', 1),
(18, 8, 'zikula/core-bundle', '3.*', '3.*', 1),
(19, 1, 'php', '>=7.2.5', '>=7.2.5', 1),
(20, 1, 'zikula/core-bundle', '3.*', '3.*', 1),
(21, 1, 'composer/semver', '1.*', '1.*', 1),
(22, 1, 'justinrainbow/json-schema', '5.*', '5.*', 1),
(23, 9, 'php', '>=7.2.5', '>=7.2.5', 1),
(24, 9, 'zikula/core-bundle', '3.*', '3.*', 1),
(25, 9, 'zikula/users-module', '3.*', '3.*', 1),
(26, 10, 'php', '>=7.2.5', '>=7.2.5', 1),
(27, 10, 'zikula/core-bundle', '3.*', '3.*', 1),
(28, 10, 'egulias/email-validator', '^2.1.10', '^2.1.10', 1),
(29, 11, 'php', '>=7.2.5', '>=7.2.5', 1),
(30, 11, 'zikula/core-bundle', '3.*', '3.*', 1),
(31, 11, 'knplabs/knp-menu-bundle', '>=2.2.1', '>=2.2.1', 1),
(32, 12, 'php', '>=7.2.5', '>=7.2.5', 1),
(33, 12, 'zikula/core-bundle', '3.*', '3.*', 1),
(34, 13, 'php', '>=7.2.5', '>=7.2.5', 1),
(35, 13, 'zikula/core-bundle', '3.*', '3.*', 1),
(36, 13, 'jms/i18n-routing-bundle', '3.*', '3.*', 1),
(37, 13, 'friendsofsymfony/jsrouting-bundle', '2.*', '2.*', 1),
(38, 14, 'php', '>=7.2.5', '>=7.2.5', 1),
(39, 14, 'zikula/core-bundle', '3.*', '3.*', 1),
(40, 15, 'php', '>=7.2.5', '>=7.2.5', 1),
(41, 15, 'zikula/core-bundle', '3.*', '3.*', 1),
(42, 15, 'phpids/phpids', 'dev-master', 'dev-master', 1),
(43, 16, 'php', '>=7.2.5', '>=7.2.5', 1),
(44, 16, 'zikula/core-bundle', '3.*', '3.*', 1),
(45, 16, 'php-translation/extractor', '2.*', '2.*', 1),
(46, 16, 'php-translation/symfony-bundle', '0.*', '0.*', 1),
(47, 16, 'php-translation/symfony-storage', '2.*', '2.*', 1),
(48, 16, 'willdurand/js-translation-bundle', '3.*', '3.*', 1),
(49, 17, 'php', '>=7.2.5', '>=7.2.5', 1),
(50, 17, 'zikula/core-bundle', '3.*', '3.*', 1),
(51, 17, 'zikula/blocks-module', '3.*', '3.*', 1),
(52, 17, 'zikula/bootstrap-theme', '3.*', '3.*', 1),
(53, 17, 'zikula/rss-theme', '3.*', '3.*', 1),
(54, 17, 'zikula/printer-theme', '3.*', '3.*', 1),
(55, 17, 'zikula/atom-theme', '3.*', '3.*', 1),
(56, 17, 'twig/twig', '3.*', '3.*', 1),
(57, 17, 'twig/cssinliner-extra', '3.*', '3.*', 1),
(58, 17, 'twig/html-extra', '3.*', '3.*', 1),
(59, 17, 'twig/inky-extra', '3.*', '3.*', 1),
(60, 17, 'twig/intl-extra', '3.*', '3.*', 1),
(61, 17, 'twig/markdown-extra', '3.*', '3.*', 1),
(62, 17, 'twig/string-extra', '3.*', '3.*', 1),
(63, 17, 'twig/extra-bundle', '3.*', '3.*', 1),
(64, 17, 'erusev/parsedown', '^1.7', '^1.7', 1),
(65, 17, 'league/commonmark', '^1.0', '^1.0', 1),
(66, 17, 'league/html-to-markdown', '^4.8', '^4.8', 1),
(67, 17, 'michelf/php-markdown', '^1.9', '^1.9', 1),
(68, 17, 'oro/twig-inspector', '1.*', '1.*', 1),
(69, 17, 'components/jquery', '3.*', '3.*', 1),
(70, 17, 'components/jqueryui', '1.*', '1.*', 1),
(71, 17, 'components/bootstrap', '4.*', '4.*', 1),
(72, 17, 'components/font-awesome', '5.*', '5.*', 1),
(73, 17, 'itsjavi/fontawesome-iconpicker', '3.*', '3.*', 1),
(74, 17, 'dimsemenov/magnific-popup', '1.*', '1.*', 1),
(75, 17, 'vakata/jstree', '3.*', '3.*', 1),
(76, 18, 'php', '>=7.2.5', '>=7.2.5', 1),
(77, 18, 'zikula/core-bundle', '3.*', '3.*', 1),
(78, 18, 'zikula/groups-module', '3.*', '3.*', 1),
(79, 18, 'zikula/permissions-module', '3.*', '3.*', 1),
(80, 19, 'php', '>=7.2.5', '>=7.2.5', 1),
(81, 19, 'zikula/core-bundle', '3.*', '3.*', 1),
(82, 19, 'zikula/users-module', '3.*', '3.*', 1),
(83, 19, 'ircmaxell/random-lib', '1.*', '1.*', 1),
(84, 20, 'php', '>=7.2.5', '>=7.2.5', 1),
(85, 20, 'zikula/core-bundle', '3.*', '3.*', 1),
(86, 20, 'zikula/theme-module', '3.*', '3.*', 1),
(87, 21, 'php', '>=7.2.5', '>=7.2.5', 1),
(88, 21, 'zikula/core-bundle', '3.*', '3.*', 1),
(89, 21, 'zikula/theme-module', '3.*', '3.*', 1),
(90, 21, 'thomaspark/bootswatch', '4.*', '4.*', 1),
(91, 22, 'php', '>=7.2.5', '>=7.2.5', 1),
(92, 22, 'zikula/core-bundle', '3.*', '3.*', 1),
(93, 22, 'zikula/theme-module', '3.*', '3.*', 1),
(94, 23, 'php', '>=7.2.5', '>=7.2.5', 1),
(95, 23, 'zikula/core-bundle', '3.*', '3.*', 1),
(96, 23, 'zikula/theme-module', '3.*', '3.*', 1);

-- --------------------------------------------------------

--
-- Table structure for table `groups`
--

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);

-- --------------------------------------------------------

--
-- Table structure for table `group_applications`
--

CREATE TABLE `group_applications` (
  `app_id` int(11) NOT NULL AUTO_INCREMENT,
  `gid` int(11) DEFAULT NULL,
  `application` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` smallint(6) NOT NULL,
  `uid` int(11) DEFAULT NULL,
  PRIMARY KEY (`app_id`),
  KEY `IDX_1B8F2CC9539B0606` (`uid`),
  KEY `IDX_1B8F2CC94C397118` (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `group_membership`
--

CREATE TABLE `group_membership` (
  `uid` int(11) NOT NULL,
  `gid` int(11) NOT NULL,
  PRIMARY KEY (`uid`,`gid`),
  KEY `IDX_5132B337539B0606` (`uid`),
  KEY `IDX_5132B3374C397118` (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `group_membership`
--

INSERT INTO `group_membership` VALUES
(2, 1),
(2, 2);

-- --------------------------------------------------------

--
-- Table structure for table `group_perms`
--

CREATE TABLE `group_perms` (
  `pid` int(11) NOT NULL AUTO_INCREMENT,
  `gid` int(11) NOT NULL,
  `sequence` int(11) NOT NULL,
  `component` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `instance` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `level` int(11) NOT NULL,
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `colour` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `group_perms`
--

INSERT INTO `group_perms` VALUES
(1, 2, 1, '.*', '.*', 800, '', ''),
(2, 1, 2, '.*', '.*', 300, '', ''),
(3, 0, 3, '.*', '.*', 200, '', '');

-- --------------------------------------------------------

--
-- Table structure for table `hook_binding`
--

CREATE TABLE `hook_binding` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sowner` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `powner` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sareaid` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pareaid` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sortorder` smallint(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `hook_runtime`
--

CREATE TABLE `hook_runtime` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sowner` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `powner` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sareaid` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pareaid` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
  `eventname` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `classname` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `method` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `priority` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `menu_items`
--

CREATE TABLE `menu_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `root_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `title` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lft` int(11) NOT NULL,
  `lvl` int(11) NOT NULL,
  `rgt` int(11) NOT NULL,
  `options` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  KEY `IDX_70B2CA2A79066886` (`root_id`),
  KEY `IDX_70B2CA2A727ACA70` (`parent_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `menu_items`
--

INSERT INTO `menu_items` VALUES
(1, 1, NULL, 'mainMenu', 1, 0, 6, 'a:1:{s:18:"childrenAttributes";a:1:{s:5:"class";s:14:"nav navbar-nav";}}'),
(2, 1, 1, 'Home', 2, 1, 3, 'a:2:{s:5:"route";s:4:"home";s:10:"attributes";a:1:{s:4:"icon";s:11:"fas fa-home";}}'),
(3, 1, 1, 'Site search', 4, 1, 5, 'a:2:{s:5:"route";s:33:"zikulasearchmodule_search_execute";s:10:"attributes";a:1:{s:4:"icon";s:13:"fas fa-search";}}');

-- --------------------------------------------------------

--
-- Table structure for table `module_vars`
--

CREATE TABLE `module_vars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modname` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=144 ;

--
-- Dumping data for table `module_vars`
--

INSERT INTO `module_vars` VALUES
(1, 'ZikulaExtensionsModule', 'itemsperpage', 'i:40;'),
(2, 'ZikulaExtensionsModule', 'helpUiMode', 's:5:"modal";'),
(3, 'ZConfig', 'startdate', '[[startdate]]'),
(4, 'ZConfig', 'adminmail', '[[adminmail_ser]]'),
(5, 'ZConfig', 'Default_Theme', 's:20:"ZikulaBootstrapTheme";'),
(6, 'ZConfig', 'timezone', 's:3:"UTC";'),
(7, 'ZConfig', 'Version_Num', 's:5:"3.0.4";'),
(8, 'ZConfig', 'multilingual', 's:1:"1";'),
(9, 'ZConfig', 'theme_change', 's:1:"0";'),
(10, 'ZConfig', 'UseCompression', 's:1:"0";'),
(11, 'ZConfig', 'siteoff', 'i:0;'),
(12, 'ZConfig', 'siteoffreason', 's:0:"";'),
(13, 'ZConfig', 'language_detect', 'i:0;'),
(14, 'ZConfig', 'sitename_en', 's:9:"Site name";'),
(15, 'ZConfig', 'slogan_en', 's:16:"Site description";'),
(16, 'ZConfig', 'defaultpagetitle_en', 's:9:"Site name";'),
(17, 'ZConfig', 'defaultmetadescription_en', 's:16:"Site description";'),
(18, 'ZConfig', 'startController_en', 'a:4:{s:10:"controller";s:0:"";s:5:"query";s:0:"";s:7:"request";s:0:"";s:10:"attributes";s:0:"";}'),
(19, 'ZConfig', 'profilemodule', 's:0:"";'),
(20, 'ZConfig', 'messagemodule', 's:0:"";'),
(21, 'ZConfig', 'languageurl', 'i:0;'),
(22, 'ZConfig', 'ajaxtimeout', 'i:5000;'),
(23, 'ZConfig', 'permasearch', 's:161:"À,Á,Â,Ã,Å,à,á,â,ã,å,Ò,Ó,Ô,Õ,Ø,ò,ó,ô,õ,ø,È,É,Ê,Ë,è,é,ê,ë,Ç,ç,Ì,Í,Î,Ï,ì,í,î,ï,Ù,Ú,Û,ù,ú,û,ÿ,Ñ,ñ,ß,ä,Ä,ö,Ö,ü,Ü";'),
(24, 'ZConfig', 'permareplace', 's:114:"A,A,A,A,A,a,a,a,a,a,O,O,O,O,O,o,o,o,o,o,E,E,E,E,e,e,e,e,C,c,I,I,I,I,i,i,i,i,U,U,U,u,u,u,y,N,n,ss,ae,Ae,oe,Oe,ue,Ue";'),
(25, 'ZConfig', 'locale', 's:2:"en";'),
(26, 'ZikulaThemeModule', 'modulesnocache', 's:0:"";'),
(27, 'ZikulaThemeModule', 'enablecache', 'b:0;'),
(28, 'ZikulaThemeModule', 'compile_check', 'b:1;'),
(29, 'ZikulaThemeModule', 'cache_lifetime', 'i:1800;'),
(30, 'ZikulaThemeModule', 'cache_lifetime_mods', 'i:1800;'),
(31, 'ZikulaThemeModule', 'force_compile', 'b:0;'),
(32, 'ZikulaThemeModule', 'trimwhitespace', 'b:0;'),
(33, 'ZikulaThemeModule', 'maxsizeforlinks', 'i:30;'),
(34, 'ZikulaThemeModule', 'itemsperpage', 'i:25;'),
(35, 'ZikulaThemeModule', 'cssjscombine', 'b:0;'),
(36, 'ZikulaThemeModule', 'cssjscompress', 'b:0;'),
(37, 'ZikulaThemeModule', 'cssjsminify', 'b:0;'),
(38, 'ZikulaThemeModule', 'cssjscombine_lifetime', 'i:3600;'),
(39, 'ZikulaThemeModule', 'render_compile_check', 'b:1;'),
(40, 'ZikulaThemeModule', 'render_force_compile', 'b:0;'),
(41, 'ZikulaThemeModule', 'render_cache', 'b:0;'),
(42, 'ZikulaThemeModule', 'render_expose_template', 'b:0;'),
(43, 'ZikulaThemeModule', 'render_lifetime', 'i:3600;'),
(44, 'ZikulaAdminModule', 'modulesperrow', 'i:3;'),
(45, 'ZikulaAdminModule', 'itemsperpage', 'i:15;'),
(46, 'ZikulaAdminModule', 'defaultcategory', 'i:5;'),
(47, 'ZikulaAdminModule', 'admingraphic', 'i:1;'),
(48, 'ZikulaAdminModule', 'startcategory', 'i:1;'),
(49, 'ZikulaAdminModule', 'ignoreinstallercheck', 'i:0;'),
(50, 'ZikulaAdminModule', 'admintheme', 's:0:"";'),
(51, 'ZikulaAdminModule', 'displaynametype', 'i:1;'),
(52, 'ZikulaPermissionsModule', 'lockadmin', 'i:1;'),
(53, 'ZikulaPermissionsModule', 'adminid', 'i:1;'),
(54, 'ZikulaPermissionsModule', 'filter', 'i:1;'),
(55, 'ZikulaUsersModule', 'accountdisplaygraphics', 'b:1;'),
(56, 'ZikulaUsersModule', 'anonymous', 's:5:"Guest";'),
(57, 'ZikulaUsersModule', 'itemsperpage', 'i:25;'),
(58, 'ZikulaUsersModule', 'login_displayapproval', 'b:0;'),
(59, 'ZikulaUsersModule', 'login_displaydelete', 'b:0;'),
(60, 'ZikulaUsersModule', 'login_displayinactive', 'b:0;'),
(61, 'ZikulaUsersModule', 'login_displayverify', 'b:0;'),
(62, 'ZikulaUsersModule', 'reg_notifyemail', 's:0:"";'),
(63, 'ZikulaUsersModule', 'moderation', 'b:0;'),
(64, 'ZikulaUsersModule', 'reg_autologin', 'b:1;'),
(65, 'ZikulaUsersModule', 'reg_noregreasons', 's:51:"Sorry! New user registration is currently disabled.";'),
(66, 'ZikulaUsersModule', 'reg_allowreg', 'b:1;'),
(67, 'ZikulaUsersModule', 'reg_Illegaluseragents', 's:0:"";'),
(68, 'ZikulaUsersModule', 'reg_Illegaldomains', 's:0:"";'),
(69, 'ZikulaUsersModule', 'reg_Illegalusername', 's:66:"root, webmaster, admin, administrator, nobody, anonymous, username";'),
(70, 'ZikulaUsersModule', 'usersallowedtoghost', 'b:0;'),
(71, 'ZConfig', 'authenticationMethodsStatus', 'a:1:{s:12:"native_uname";b:1;}'),
(72, 'ZikulaZAuthModule', 'minpass', 'i:8;'),
(73, 'ZikulaZAuthModule', 'non_compromised_password', 'b:0;'),
(74, 'ZikulaZAuthModule', 'use_password_strength_meter', 'b:0;'),
(75, 'ZikulaZAuthModule', 'chgemail_expiredays', 'i:0;'),
(76, 'ZikulaZAuthModule', 'chgpass_expiredays', 'i:0;'),
(77, 'ZikulaZAuthModule', 'reg_expiredays', 'i:0;'),
(78, 'ZikulaZAuthModule', 'email_verification_required', 'b:1;'),
(79, 'ZikulaZAuthModule', 'reg_answer', 's:0:"";'),
(80, 'ZikulaZAuthModule', 'reg_question', 's:0:"";'),
(81, 'ZikulaZAuthModule', 'itemsperpage', 'i:25;'),
(82, 'ZikulaGroupsModule', 'itemsperpage', 'i:25;'),
(83, 'ZikulaGroupsModule', 'defaultgroup', 'i:1;'),
(84, 'ZikulaGroupsModule', 'mailwarning', 'b:0;'),
(85, 'ZikulaGroupsModule', 'hideclosed', 'b:0;'),
(86, 'ZikulaGroupsModule', 'hidePrivate', 'b:0;'),
(87, 'ZikulaBlocksModule', 'collapseable', 'b:0;'),
(88, 'ZikulaSecurityCenterModule', 'itemsperpage', 'i:10;'),
(89, 'ZConfig', 'updatecheck', 'i:1;'),
(90, 'ZConfig', 'updatefrequency', 'i:7;'),
(91, 'ZConfig', 'updatelastchecked', 'i:[[timestamp]];'),
(92, 'ZConfig', 'updateversion', 's:5:"3.1.0";'),
(93, 'ZConfig', 'seclevel', 's:6:"Medium";'),
(94, 'ZConfig', 'secmeddays', 'i:7;'),
(95, 'ZConfig', 'secinactivemins', 'i:20;'),
(96, 'ZConfig', 'sessionstoretofile', 'i:1;'),
(97, 'ZConfig', 'sessionsavepath', 's:0:"";'),
(98, 'ZConfig', 'gc_probability', 'i:100;'),
(99, 'ZConfig', 'sessionregenerate', 'i:1;'),
(100, 'ZConfig', 'sessionregeneratefreq', 'i:10;'),
(101, 'ZConfig', 'sessionname', 's:5:"_zsid";'),
(102, 'ZConfig', 'filtergetvars', 'i:1;'),
(103, 'ZConfig', 'filterpostvars', 'i:1;'),
(104, 'ZConfig', 'filtercookievars', 'i:1;'),
(105, 'ZikulaSecurityCenterModule', 'htmlpurifierConfig', 's:33685:"O:19:"HTMLPurifier_Config":12:{s:7:"version";s:6:"4.13.0";s:12:"autoFinalize";b:1;s:10:"\0*\0serials";a:4:{s:4:"Attr";b:0;s:4:"HTML";b:0;s:6:"Output";b:0;s:5:"Cache";b:0;}s:9:"\0*\0serial";N;s:9:"\0*\0parser";N;s:3:"def";O:25:"HTMLPurifier_ConfigSchema":3:{s:8:"defaults";a:127:{s:19:"Attr.AllowedClasses";N;s:24:"Attr.AllowedFrameTargets";a:0:{}s:15:"Attr.AllowedRel";a:0:{}s:15:"Attr.AllowedRev";a:0:{}s:18:"Attr.ClassUseCDATA";N;s:20:"Attr.DefaultImageAlt";N;s:24:"Attr.DefaultInvalidImage";s:0:"";s:27:"Attr.DefaultInvalidImageAlt";s:13:"Invalid image";s:19:"Attr.DefaultTextDir";s:3:"ltr";s:13:"Attr.EnableID";b:0;s:21:"Attr.ForbiddenClasses";a:0:{}s:13:"Attr.ID.HTML5";N;s:16:"Attr.IDBlacklist";a:0:{}s:22:"Attr.IDBlacklistRegexp";N;s:13:"Attr.IDPrefix";s:0:"";s:18:"Attr.IDPrefixLocal";s:0:"";s:24:"AutoFormat.AutoParagraph";b:0;s:17:"AutoFormat.Custom";a:0:{}s:25:"AutoFormat.DisplayLinkURI";b:0;s:18:"AutoFormat.Linkify";b:0;s:33:"AutoFormat.PurifierLinkify.DocURL";s:3:"#%s";s:26:"AutoFormat.PurifierLinkify";b:0;s:32:"AutoFormat.RemoveEmpty.Predicate";a:4:{s:8:"colgroup";a:0:{}s:2:"th";a:0:{}s:2:"td";a:0:{}s:6:"iframe";a:1:{i:0;s:3:"src";}}s:44:"AutoFormat.RemoveEmpty.RemoveNbsp.Exceptions";a:2:{s:2:"td";b:1;s:2:"th";b:1;}s:33:"AutoFormat.RemoveEmpty.RemoveNbsp";b:0;s:22:"AutoFormat.RemoveEmpty";b:0;s:39:"AutoFormat.RemoveSpansWithoutAttributes";b:0;s:19:"CSS.AllowDuplicates";b:0;s:18:"CSS.AllowImportant";b:0;s:15:"CSS.AllowTricky";b:0;s:16:"CSS.AllowedFonts";N;s:21:"CSS.AllowedProperties";N;s:17:"CSS.DefinitionRev";i:1;s:23:"CSS.ForbiddenProperties";a:0:{}s:16:"CSS.MaxImgLength";s:6:"1200px";s:15:"CSS.Proprietary";b:0;s:11:"CSS.Trusted";b:0;s:20:"Cache.DefinitionImpl";s:10:"Serializer";s:20:"Cache.SerializerPath";N;s:27:"Cache.SerializerPermissions";i:493;s:22:"Core.AggressivelyFixLt";b:1;s:29:"Core.AggressivelyRemoveScript";b:1;s:28:"Core.AllowHostnameUnderscore";b:0;s:23:"Core.AllowParseManyTags";b:0;s:18:"Core.CollectErrors";b:0;s:18:"Core.ColorKeywords";a:148:{s:9:"aliceblue";s:7:"#F0F8FF";s:12:"antiquewhite";s:7:"#FAEBD7";s:4:"aqua";s:7:"#00FFFF";s:10:"aquamarine";s:7:"#7FFFD4";s:5:"azure";s:7:"#F0FFFF";s:5:"beige";s:7:"#F5F5DC";s:6:"bisque";s:7:"#FFE4C4";s:5:"black";s:7:"#000000";s:14:"blanchedalmond";s:7:"#FFEBCD";s:4:"blue";s:7:"#0000FF";s:10:"blueviolet";s:7:"#8A2BE2";s:5:"brown";s:7:"#A52A2A";s:9:"burlywood";s:7:"#DEB887";s:9:"cadetblue";s:7:"#5F9EA0";s:10:"chartreuse";s:7:"#7FFF00";s:9:"chocolate";s:7:"#D2691E";s:5:"coral";s:7:"#FF7F50";s:14:"cornflowerblue";s:7:"#6495ED";s:8:"cornsilk";s:7:"#FFF8DC";s:7:"crimson";s:7:"#DC143C";s:4:"cyan";s:7:"#00FFFF";s:8:"darkblue";s:7:"#00008B";s:8:"darkcyan";s:7:"#008B8B";s:13:"darkgoldenrod";s:7:"#B8860B";s:8:"darkgray";s:7:"#A9A9A9";s:8:"darkgrey";s:7:"#A9A9A9";s:9:"darkgreen";s:7:"#006400";s:9:"darkkhaki";s:7:"#BDB76B";s:11:"darkmagenta";s:7:"#8B008B";s:14:"darkolivegreen";s:7:"#556B2F";s:10:"darkorange";s:7:"#FF8C00";s:10:"darkorchid";s:7:"#9932CC";s:7:"darkred";s:7:"#8B0000";s:10:"darksalmon";s:7:"#E9967A";s:12:"darkseagreen";s:7:"#8FBC8F";s:13:"darkslateblue";s:7:"#483D8B";s:13:"darkslategray";s:7:"#2F4F4F";s:13:"darkslategrey";s:7:"#2F4F4F";s:13:"darkturquoise";s:7:"#00CED1";s:10:"darkviolet";s:7:"#9400D3";s:8:"deeppink";s:7:"#FF1493";s:11:"deepskyblue";s:7:"#00BFFF";s:7:"dimgray";s:7:"#696969";s:7:"dimgrey";s:7:"#696969";s:10:"dodgerblue";s:7:"#1E90FF";s:9:"firebrick";s:7:"#B22222";s:11:"floralwhite";s:7:"#FFFAF0";s:11:"forestgreen";s:7:"#228B22";s:7:"fuchsia";s:7:"#FF00FF";s:9:"gainsboro";s:7:"#DCDCDC";s:10:"ghostwhite";s:7:"#F8F8FF";s:4:"gold";s:7:"#FFD700";s:9:"goldenrod";s:7:"#DAA520";s:4:"gray";s:7:"#808080";s:4:"grey";s:7:"#808080";s:5:"green";s:7:"#008000";s:11:"greenyellow";s:7:"#ADFF2F";s:8:"honeydew";s:7:"#F0FFF0";s:7:"hotpink";s:7:"#FF69B4";s:9:"indianred";s:7:"#CD5C5C";s:6:"indigo";s:7:"#4B0082";s:5:"ivory";s:7:"#FFFFF0";s:5:"khaki";s:7:"#F0E68C";s:8:"lavender";s:7:"#E6E6FA";s:13:"lavenderblush";s:7:"#FFF0F5";s:9:"lawngreen";s:7:"#7CFC00";s:12:"lemonchiffon";s:7:"#FFFACD";s:9:"lightblue";s:7:"#ADD8E6";s:10:"lightcoral";s:7:"#F08080";s:9:"lightcyan";s:7:"#E0FFFF";s:20:"lightgoldenrodyellow";s:7:"#FAFAD2";s:9:"lightgray";s:7:"#D3D3D3";s:9:"lightgrey";s:7:"#D3D3D3";s:10:"lightgreen";s:7:"#90EE90";s:9:"lightpink";s:7:"#FFB6C1";s:11:"lightsalmon";s:7:"#FFA07A";s:13:"lightseagreen";s:7:"#20B2AA";s:12:"lightskyblue";s:7:"#87CEFA";s:14:"lightslategray";s:7:"#778899";s:14:"lightslategrey";s:7:"#778899";s:14:"lightsteelblue";s:7:"#B0C4DE";s:11:"lightyellow";s:7:"#FFFFE0";s:4:"lime";s:7:"#00FF00";s:9:"limegreen";s:7:"#32CD32";s:5:"linen";s:7:"#FAF0E6";s:7:"magenta";s:7:"#FF00FF";s:6:"maroon";s:7:"#800000";s:16:"mediumaquamarine";s:7:"#66CDAA";s:10:"mediumblue";s:7:"#0000CD";s:12:"mediumorchid";s:7:"#BA55D3";s:12:"mediumpurple";s:7:"#9370DB";s:14:"mediumseagreen";s:7:"#3CB371";s:15:"mediumslateblue";s:7:"#7B68EE";s:17:"mediumspringgreen";s:7:"#00FA9A";s:15:"mediumturquoise";s:7:"#48D1CC";s:15:"mediumvioletred";s:7:"#C71585";s:12:"midnightblue";s:7:"#191970";s:9:"mintcream";s:7:"#F5FFFA";s:9:"mistyrose";s:7:"#FFE4E1";s:8:"moccasin";s:7:"#FFE4B5";s:11:"navajowhite";s:7:"#FFDEAD";s:4:"navy";s:7:"#000080";s:7:"oldlace";s:7:"#FDF5E6";s:5:"olive";s:7:"#808000";s:9:"olivedrab";s:7:"#6B8E23";s:6:"orange";s:7:"#FFA500";s:9:"orangered";s:7:"#FF4500";s:6:"orchid";s:7:"#DA70D6";s:13:"palegoldenrod";s:7:"#EEE8AA";s:9:"palegreen";s:7:"#98FB98";s:13:"paleturquoise";s:7:"#AFEEEE";s:13:"palevioletred";s:7:"#DB7093";s:10:"papayawhip";s:7:"#FFEFD5";s:9:"peachpuff";s:7:"#FFDAB9";s:4:"peru";s:7:"#CD853F";s:4:"pink";s:7:"#FFC0CB";s:4:"plum";s:7:"#DDA0DD";s:10:"powderblue";s:7:"#B0E0E6";s:6:"purple";s:7:"#800080";s:13:"rebeccapurple";s:7:"#663399";s:3:"red";s:7:"#FF0000";s:9:"rosybrown";s:7:"#BC8F8F";s:9:"royalblue";s:7:"#4169E1";s:11:"saddlebrown";s:7:"#8B4513";s:6:"salmon";s:7:"#FA8072";s:10:"sandybrown";s:7:"#F4A460";s:8:"seagreen";s:7:"#2E8B57";s:8:"seashell";s:7:"#FFF5EE";s:6:"sienna";s:7:"#A0522D";s:6:"silver";s:7:"#C0C0C0";s:7:"skyblue";s:7:"#87CEEB";s:9:"slateblue";s:7:"#6A5ACD";s:9:"slategray";s:7:"#708090";s:9:"slategrey";s:7:"#708090";s:4:"snow";s:7:"#FFFAFA";s:11:"springgreen";s:7:"#00FF7F";s:9:"steelblue";s:7:"#4682B4";s:3:"tan";s:7:"#D2B48C";s:4:"teal";s:7:"#008080";s:7:"thistle";s:7:"#D8BFD8";s:6:"tomato";s:7:"#FF6347";s:9:"turquoise";s:7:"#40E0D0";s:6:"violet";s:7:"#EE82EE";s:5:"wheat";s:7:"#F5DEB3";s:5:"white";s:7:"#FFFFFF";s:10:"whitesmoke";s:7:"#F5F5F5";s:6:"yellow";s:7:"#FFFF00";s:11:"yellowgreen";s:7:"#9ACD32";}s:30:"Core.ConvertDocumentToFragment";b:1;s:36:"Core.DirectLexLineNumberSyncInterval";i:0;s:20:"Core.DisableExcludes";b:0;s:15:"Core.EnableIDNA";b:0;s:13:"Core.Encoding";s:5:"utf-8";s:26:"Core.EscapeInvalidChildren";b:0;s:22:"Core.EscapeInvalidTags";b:0;s:29:"Core.EscapeNonASCIICharacters";b:0;s:19:"Core.HiddenElements";a:2:{s:6:"script";b:1;s:5:"style";b:1;}s:13:"Core.Language";s:2:"en";s:24:"Core.LegacyEntityDecoder";b:0;s:14:"Core.LexerImpl";N;s:24:"Core.MaintainLineNumbers";N;s:22:"Core.NormalizeNewlines";b:1;s:21:"Core.RemoveInvalidImg";b:1;s:33:"Core.RemoveProcessingInstructions";b:0;s:25:"Core.RemoveScriptContents";N;s:13:"Filter.Custom";a:0:{}s:34:"Filter.ExtractStyleBlocks.Escaping";b:1;s:31:"Filter.ExtractStyleBlocks.Scope";N;s:34:"Filter.ExtractStyleBlocks.TidyImpl";N;s:25:"Filter.ExtractStyleBlocks";b:0;s:14:"Filter.YouTube";b:0;s:12:"HTML.Allowed";N;s:22:"HTML.AllowedAttributes";N;s:20:"HTML.AllowedComments";a:0:{}s:26:"HTML.AllowedCommentsRegexp";N;s:20:"HTML.AllowedElements";N;s:19:"HTML.AllowedModules";N;s:23:"HTML.Attr.Name.UseCDATA";b:0;s:17:"HTML.BlockWrapper";s:1:"p";s:16:"HTML.CoreModules";a:7:{s:9:"Structure";b:1;s:4:"Text";b:1;s:9:"Hypertext";b:1;s:4:"List";b:1;s:22:"NonXMLCommonAttributes";b:1;s:19:"XMLCommonAttributes";b:1;s:16:"CommonAttributes";b:1;}s:18:"HTML.CustomDoctype";N;s:17:"HTML.DefinitionID";N;s:18:"HTML.DefinitionRev";i:1;s:12:"HTML.Doctype";N;s:25:"HTML.FlashAllowFullScreen";b:0;s:24:"HTML.ForbiddenAttributes";a:0:{}s:22:"HTML.ForbiddenElements";a:0:{}s:10:"HTML.Forms";b:0;s:17:"HTML.MaxImgLength";i:1200;s:13:"HTML.Nofollow";b:0;s:11:"HTML.Parent";s:3:"div";s:16:"HTML.Proprietary";b:0;s:14:"HTML.SafeEmbed";b:0;s:15:"HTML.SafeIframe";b:0;s:15:"HTML.SafeObject";b:0;s:18:"HTML.SafeScripting";a:0:{}s:11:"HTML.Strict";b:0;s:16:"HTML.TargetBlank";b:0;s:19:"HTML.TargetNoopener";b:1;s:21:"HTML.TargetNoreferrer";b:1;s:12:"HTML.TidyAdd";a:0:{}s:14:"HTML.TidyLevel";s:6:"medium";s:15:"HTML.TidyRemove";a:0:{}s:12:"HTML.Trusted";b:0;s:10:"HTML.XHTML";b:1;s:28:"Output.CommentScriptContents";b:1;s:19:"Output.FixInnerHTML";b:1;s:18:"Output.FlashCompat";b:0;s:14:"Output.Newline";N;s:15:"Output.SortAttr";b:0;s:17:"Output.TidyFormat";b:0;s:17:"Test.ForceNoIconv";b:0;s:18:"URI.AllowedSchemes";a:7:{s:4:"http";b:1;s:5:"https";b:1;s:6:"mailto";b:1;s:3:"ftp";b:1;s:4:"nntp";b:1;s:4:"news";b:1;s:3:"tel";b:1;}s:8:"URI.Base";N;s:17:"URI.DefaultScheme";s:4:"http";s:16:"URI.DefinitionID";N;s:17:"URI.DefinitionRev";i:1;s:11:"URI.Disable";b:0;s:19:"URI.DisableExternal";b:0;s:28:"URI.DisableExternalResources";b:0;s:20:"URI.DisableResources";b:0;s:8:"URI.Host";N;s:17:"URI.HostBlacklist";a:0:{}s:16:"URI.MakeAbsolute";b:0;s:9:"URI.Munge";N;s:18:"URI.MungeResources";b:0;s:18:"URI.MungeSecretKey";N;s:26:"URI.OverrideAllowedSchemes";b:1;s:20:"URI.SafeIframeRegexp";N;}s:12:"defaultPlist";O:25:"HTMLPurifier_PropertyList":3:{s:7:"\0*\0data";a:127:{s:19:"Attr.AllowedClasses";N;s:24:"Attr.AllowedFrameTargets";a:0:{}s:15:"Attr.AllowedRel";a:0:{}s:15:"Attr.AllowedRev";a:0:{}s:18:"Attr.ClassUseCDATA";N;s:20:"Attr.DefaultImageAlt";N;s:24:"Attr.DefaultInvalidImage";s:0:"";s:27:"Attr.DefaultInvalidImageAlt";s:13:"Invalid image";s:19:"Attr.DefaultTextDir";s:3:"ltr";s:13:"Attr.EnableID";b:0;s:21:"Attr.ForbiddenClasses";a:0:{}s:13:"Attr.ID.HTML5";N;s:16:"Attr.IDBlacklist";a:0:{}s:22:"Attr.IDBlacklistRegexp";N;s:13:"Attr.IDPrefix";s:0:"";s:18:"Attr.IDPrefixLocal";s:0:"";s:24:"AutoFormat.AutoParagraph";b:0;s:17:"AutoFormat.Custom";a:0:{}s:25:"AutoFormat.DisplayLinkURI";b:0;s:18:"AutoFormat.Linkify";b:0;s:33:"AutoFormat.PurifierLinkify.DocURL";s:3:"#%s";s:26:"AutoFormat.PurifierLinkify";b:0;s:32:"AutoFormat.RemoveEmpty.Predicate";a:4:{s:8:"colgroup";a:0:{}s:2:"th";a:0:{}s:2:"td";a:0:{}s:6:"iframe";a:1:{i:0;s:3:"src";}}s:44:"AutoFormat.RemoveEmpty.RemoveNbsp.Exceptions";a:2:{s:2:"td";b:1;s:2:"th";b:1;}s:33:"AutoFormat.RemoveEmpty.RemoveNbsp";b:0;s:22:"AutoFormat.RemoveEmpty";b:0;s:39:"AutoFormat.RemoveSpansWithoutAttributes";b:0;s:19:"CSS.AllowDuplicates";b:0;s:18:"CSS.AllowImportant";b:0;s:15:"CSS.AllowTricky";b:0;s:16:"CSS.AllowedFonts";N;s:21:"CSS.AllowedProperties";N;s:17:"CSS.DefinitionRev";i:1;s:23:"CSS.ForbiddenProperties";a:0:{}s:16:"CSS.MaxImgLength";s:6:"1200px";s:15:"CSS.Proprietary";b:0;s:11:"CSS.Trusted";b:0;s:20:"Cache.DefinitionImpl";s:10:"Serializer";s:20:"Cache.SerializerPath";N;s:27:"Cache.SerializerPermissions";i:493;s:22:"Core.AggressivelyFixLt";b:1;s:29:"Core.AggressivelyRemoveScript";b:1;s:28:"Core.AllowHostnameUnderscore";b:0;s:23:"Core.AllowParseManyTags";b:0;s:18:"Core.CollectErrors";b:0;s:18:"Core.ColorKeywords";a:148:{s:9:"aliceblue";s:7:"#F0F8FF";s:12:"antiquewhite";s:7:"#FAEBD7";s:4:"aqua";s:7:"#00FFFF";s:10:"aquamarine";s:7:"#7FFFD4";s:5:"azure";s:7:"#F0FFFF";s:5:"beige";s:7:"#F5F5DC";s:6:"bisque";s:7:"#FFE4C4";s:5:"black";s:7:"#000000";s:14:"blanchedalmond";s:7:"#FFEBCD";s:4:"blue";s:7:"#0000FF";s:10:"blueviolet";s:7:"#8A2BE2";s:5:"brown";s:7:"#A52A2A";s:9:"burlywood";s:7:"#DEB887";s:9:"cadetblue";s:7:"#5F9EA0";s:10:"chartreuse";s:7:"#7FFF00";s:9:"chocolate";s:7:"#D2691E";s:5:"coral";s:7:"#FF7F50";s:14:"cornflowerblue";s:7:"#6495ED";s:8:"cornsilk";s:7:"#FFF8DC";s:7:"crimson";s:7:"#DC143C";s:4:"cyan";s:7:"#00FFFF";s:8:"darkblue";s:7:"#00008B";s:8:"darkcyan";s:7:"#008B8B";s:13:"darkgoldenrod";s:7:"#B8860B";s:8:"darkgray";s:7:"#A9A9A9";s:8:"darkgrey";s:7:"#A9A9A9";s:9:"darkgreen";s:7:"#006400";s:9:"darkkhaki";s:7:"#BDB76B";s:11:"darkmagenta";s:7:"#8B008B";s:14:"darkolivegreen";s:7:"#556B2F";s:10:"darkorange";s:7:"#FF8C00";s:10:"darkorchid";s:7:"#9932CC";s:7:"darkred";s:7:"#8B0000";s:10:"darksalmon";s:7:"#E9967A";s:12:"darkseagreen";s:7:"#8FBC8F";s:13:"darkslateblue";s:7:"#483D8B";s:13:"darkslategray";s:7:"#2F4F4F";s:13:"darkslategrey";s:7:"#2F4F4F";s:13:"darkturquoise";s:7:"#00CED1";s:10:"darkviolet";s:7:"#9400D3";s:8:"deeppink";s:7:"#FF1493";s:11:"deepskyblue";s:7:"#00BFFF";s:7:"dimgray";s:7:"#696969";s:7:"dimgrey";s:7:"#696969";s:10:"dodgerblue";s:7:"#1E90FF";s:9:"firebrick";s:7:"#B22222";s:11:"floralwhite";s:7:"#FFFAF0";s:11:"forestgreen";s:7:"#228B22";s:7:"fuchsia";s:7:"#FF00FF";s:9:"gainsboro";s:7:"#DCDCDC";s:10:"ghostwhite";s:7:"#F8F8FF";s:4:"gold";s:7:"#FFD700";s:9:"goldenrod";s:7:"#DAA520";s:4:"gray";s:7:"#808080";s:4:"grey";s:7:"#808080";s:5:"green";s:7:"#008000";s:11:"greenyellow";s:7:"#ADFF2F";s:8:"honeydew";s:7:"#F0FFF0";s:7:"hotpink";s:7:"#FF69B4";s:9:"indianred";s:7:"#CD5C5C";s:6:"indigo";s:7:"#4B0082";s:5:"ivory";s:7:"#FFFFF0";s:5:"khaki";s:7:"#F0E68C";s:8:"lavender";s:7:"#E6E6FA";s:13:"lavenderblush";s:7:"#FFF0F5";s:9:"lawngreen";s:7:"#7CFC00";s:12:"lemonchiffon";s:7:"#FFFACD";s:9:"lightblue";s:7:"#ADD8E6";s:10:"lightcoral";s:7:"#F08080";s:9:"lightcyan";s:7:"#E0FFFF";s:20:"lightgoldenrodyellow";s:7:"#FAFAD2";s:9:"lightgray";s:7:"#D3D3D3";s:9:"lightgrey";s:7:"#D3D3D3";s:10:"lightgreen";s:7:"#90EE90";s:9:"lightpink";s:7:"#FFB6C1";s:11:"lightsalmon";s:7:"#FFA07A";s:13:"lightseagreen";s:7:"#20B2AA";s:12:"lightskyblue";s:7:"#87CEFA";s:14:"lightslategray";s:7:"#778899";s:14:"lightslategrey";s:7:"#778899";s:14:"lightsteelblue";s:7:"#B0C4DE";s:11:"lightyellow";s:7:"#FFFFE0";s:4:"lime";s:7:"#00FF00";s:9:"limegreen";s:7:"#32CD32";s:5:"linen";s:7:"#FAF0E6";s:7:"magenta";s:7:"#FF00FF";s:6:"maroon";s:7:"#800000";s:16:"mediumaquamarine";s:7:"#66CDAA";s:10:"mediumblue";s:7:"#0000CD";s:12:"mediumorchid";s:7:"#BA55D3";s:12:"mediumpurple";s:7:"#9370DB";s:14:"mediumseagreen";s:7:"#3CB371";s:15:"mediumslateblue";s:7:"#7B68EE";s:17:"mediumspringgreen";s:7:"#00FA9A";s:15:"mediumturquoise";s:7:"#48D1CC";s:15:"mediumvioletred";s:7:"#C71585";s:12:"midnightblue";s:7:"#191970";s:9:"mintcream";s:7:"#F5FFFA";s:9:"mistyrose";s:7:"#FFE4E1";s:8:"moccasin";s:7:"#FFE4B5";s:11:"navajowhite";s:7:"#FFDEAD";s:4:"navy";s:7:"#000080";s:7:"oldlace";s:7:"#FDF5E6";s:5:"olive";s:7:"#808000";s:9:"olivedrab";s:7:"#6B8E23";s:6:"orange";s:7:"#FFA500";s:9:"orangered";s:7:"#FF4500";s:6:"orchid";s:7:"#DA70D6";s:13:"palegoldenrod";s:7:"#EEE8AA";s:9:"palegreen";s:7:"#98FB98";s:13:"paleturquoise";s:7:"#AFEEEE";s:13:"palevioletred";s:7:"#DB7093";s:10:"papayawhip";s:7:"#FFEFD5";s:9:"peachpuff";s:7:"#FFDAB9";s:4:"peru";s:7:"#CD853F";s:4:"pink";s:7:"#FFC0CB";s:4:"plum";s:7:"#DDA0DD";s:10:"powderblue";s:7:"#B0E0E6";s:6:"purple";s:7:"#800080";s:13:"rebeccapurple";s:7:"#663399";s:3:"red";s:7:"#FF0000";s:9:"rosybrown";s:7:"#BC8F8F";s:9:"royalblue";s:7:"#4169E1";s:11:"saddlebrown";s:7:"#8B4513";s:6:"salmon";s:7:"#FA8072";s:10:"sandybrown";s:7:"#F4A460";s:8:"seagreen";s:7:"#2E8B57";s:8:"seashell";s:7:"#FFF5EE";s:6:"sienna";s:7:"#A0522D";s:6:"silver";s:7:"#C0C0C0";s:7:"skyblue";s:7:"#87CEEB";s:9:"slateblue";s:7:"#6A5ACD";s:9:"slategray";s:7:"#708090";s:9:"slategrey";s:7:"#708090";s:4:"snow";s:7:"#FFFAFA";s:11:"springgreen";s:7:"#00FF7F";s:9:"steelblue";s:7:"#4682B4";s:3:"tan";s:7:"#D2B48C";s:4:"teal";s:7:"#008080";s:7:"thistle";s:7:"#D8BFD8";s:6:"tomato";s:7:"#FF6347";s:9:"turquoise";s:7:"#40E0D0";s:6:"violet";s:7:"#EE82EE";s:5:"wheat";s:7:"#F5DEB3";s:5:"white";s:7:"#FFFFFF";s:10:"whitesmoke";s:7:"#F5F5F5";s:6:"yellow";s:7:"#FFFF00";s:11:"yellowgreen";s:7:"#9ACD32";}s:30:"Core.ConvertDocumentToFragment";b:1;s:36:"Core.DirectLexLineNumberSyncInterval";i:0;s:20:"Core.DisableExcludes";b:0;s:15:"Core.EnableIDNA";b:0;s:13:"Core.Encoding";s:5:"utf-8";s:26:"Core.EscapeInvalidChildren";b:0;s:22:"Core.EscapeInvalidTags";b:0;s:29:"Core.EscapeNonASCIICharacters";b:0;s:19:"Core.HiddenElements";a:2:{s:6:"script";b:1;s:5:"style";b:1;}s:13:"Core.Language";s:2:"en";s:24:"Core.LegacyEntityDecoder";b:0;s:14:"Core.LexerImpl";N;s:24:"Core.MaintainLineNumbers";N;s:22:"Core.NormalizeNewlines";b:1;s:21:"Core.RemoveInvalidImg";b:1;s:33:"Core.RemoveProcessingInstructions";b:0;s:25:"Core.RemoveScriptContents";N;s:13:"Filter.Custom";a:0:{}s:34:"Filter.ExtractStyleBlocks.Escaping";b:1;s:31:"Filter.ExtractStyleBlocks.Scope";N;s:34:"Filter.ExtractStyleBlocks.TidyImpl";N;s:25:"Filter.ExtractStyleBlocks";b:0;s:14:"Filter.YouTube";b:0;s:12:"HTML.Allowed";N;s:22:"HTML.AllowedAttributes";N;s:20:"HTML.AllowedComments";a:0:{}s:26:"HTML.AllowedCommentsRegexp";N;s:20:"HTML.AllowedElements";N;s:19:"HTML.AllowedModules";N;s:23:"HTML.Attr.Name.UseCDATA";b:0;s:17:"HTML.BlockWrapper";s:1:"p";s:16:"HTML.CoreModules";a:7:{s:9:"Structure";b:1;s:4:"Text";b:1;s:9:"Hypertext";b:1;s:4:"List";b:1;s:22:"NonXMLCommonAttributes";b:1;s:19:"XMLCommonAttributes";b:1;s:16:"CommonAttributes";b:1;}s:18:"HTML.CustomDoctype";N;s:17:"HTML.DefinitionID";N;s:18:"HTML.DefinitionRev";i:1;s:12:"HTML.Doctype";N;s:25:"HTML.FlashAllowFullScreen";b:0;s:24:"HTML.ForbiddenAttributes";a:0:{}s:22:"HTML.ForbiddenElements";a:0:{}s:10:"HTML.Forms";b:0;s:17:"HTML.MaxImgLength";i:1200;s:13:"HTML.Nofollow";b:0;s:11:"HTML.Parent";s:3:"div";s:16:"HTML.Proprietary";b:0;s:14:"HTML.SafeEmbed";b:0;s:15:"HTML.SafeIframe";b:0;s:15:"HTML.SafeObject";b:0;s:18:"HTML.SafeScripting";a:0:{}s:11:"HTML.Strict";b:0;s:16:"HTML.TargetBlank";b:0;s:19:"HTML.TargetNoopener";b:1;s:21:"HTML.TargetNoreferrer";b:1;s:12:"HTML.TidyAdd";a:0:{}s:14:"HTML.TidyLevel";s:6:"medium";s:15:"HTML.TidyRemove";a:0:{}s:12:"HTML.Trusted";b:0;s:10:"HTML.XHTML";b:1;s:28:"Output.CommentScriptContents";b:1;s:19:"Output.FixInnerHTML";b:1;s:18:"Output.FlashCompat";b:0;s:14:"Output.Newline";N;s:15:"Output.SortAttr";b:0;s:17:"Output.TidyFormat";b:0;s:17:"Test.ForceNoIconv";b:0;s:18:"URI.AllowedSchemes";a:7:{s:4:"http";b:1;s:5:"https";b:1;s:6:"mailto";b:1;s:3:"ftp";b:1;s:4:"nntp";b:1;s:4:"news";b:1;s:3:"tel";b:1;}s:8:"URI.Base";N;s:17:"URI.DefaultScheme";s:4:"http";s:16:"URI.DefinitionID";N;s:17:"URI.DefinitionRev";i:1;s:11:"URI.Disable";b:0;s:19:"URI.DisableExternal";b:0;s:28:"URI.DisableExternalResources";b:0;s:20:"URI.DisableResources";b:0;s:8:"URI.Host";N;s:17:"URI.HostBlacklist";a:0:{}s:16:"URI.MakeAbsolute";b:0;s:9:"URI.Munge";N;s:18:"URI.MungeResources";b:0;s:18:"URI.MungeSecretKey";N;s:26:"URI.OverrideAllowedSchemes";b:1;s:20:"URI.SafeIframeRegexp";N;}s:9:"\0*\0parent";N;s:8:"\0*\0cache";N;}s:4:"info";a:140:{s:19:"Attr.AllowedClasses";i:-8;s:24:"Attr.AllowedFrameTargets";i:8;s:15:"Attr.AllowedRel";i:8;s:15:"Attr.AllowedRev";i:8;s:18:"Attr.ClassUseCDATA";i:-7;s:20:"Attr.DefaultImageAlt";i:-1;s:24:"Attr.DefaultInvalidImage";i:1;s:27:"Attr.DefaultInvalidImageAlt";i:1;s:19:"Attr.DefaultTextDir";O:8:"stdClass":2:{s:4:"type";i:1;s:7:"allowed";a:2:{s:3:"ltr";b:1;s:3:"rtl";b:1;}}s:13:"Attr.EnableID";i:7;s:17:"HTML.EnableAttrID";O:8:"stdClass":2:{s:3:"key";s:13:"Attr.EnableID";s:7:"isAlias";b:1;}s:21:"Attr.ForbiddenClasses";i:8;s:13:"Attr.ID.HTML5";i:-7;s:16:"Attr.IDBlacklist";i:9;s:22:"Attr.IDBlacklistRegexp";i:-1;s:13:"Attr.IDPrefix";i:1;s:18:"Attr.IDPrefixLocal";i:1;s:24:"AutoFormat.AutoParagraph";i:7;s:17:"AutoFormat.Custom";i:9;s:25:"AutoFormat.DisplayLinkURI";i:7;s:18:"AutoFormat.Linkify";i:7;s:33:"AutoFormat.PurifierLinkify.DocURL";i:1;s:37:"AutoFormatParam.PurifierLinkifyDocURL";O:8:"stdClass":2:{s:3:"key";s:33:"AutoFormat.PurifierLinkify.DocURL";s:7:"isAlias";b:1;}s:26:"AutoFormat.PurifierLinkify";i:7;s:32:"AutoFormat.RemoveEmpty.Predicate";i:10;s:44:"AutoFormat.RemoveEmpty.RemoveNbsp.Exceptions";i:8;s:33:"AutoFormat.RemoveEmpty.RemoveNbsp";i:7;s:22:"AutoFormat.RemoveEmpty";i:7;s:39:"AutoFormat.RemoveSpansWithoutAttributes";i:7;s:19:"CSS.AllowDuplicates";i:7;s:18:"CSS.AllowImportant";i:7;s:15:"CSS.AllowTricky";i:7;s:16:"CSS.AllowedFonts";i:-8;s:21:"CSS.AllowedProperties";i:-8;s:17:"CSS.DefinitionRev";i:5;s:23:"CSS.ForbiddenProperties";i:8;s:16:"CSS.MaxImgLength";i:-1;s:15:"CSS.Proprietary";i:7;s:11:"CSS.Trusted";i:7;s:20:"Cache.DefinitionImpl";i:-1;s:20:"Core.DefinitionCache";O:8:"stdClass":2:{s:3:"key";s:20:"Cache.DefinitionImpl";s:7:"isAlias";b:1;}s:20:"Cache.SerializerPath";i:-1;s:27:"Cache.SerializerPermissions";i:-5;s:22:"Core.AggressivelyFixLt";i:7;s:29:"Core.AggressivelyRemoveScript";i:7;s:28:"Core.AllowHostnameUnderscore";i:7;s:23:"Core.AllowParseManyTags";i:7;s:18:"Core.CollectErrors";i:7;s:18:"Core.ColorKeywords";i:10;s:30:"Core.ConvertDocumentToFragment";i:7;s:24:"Core.AcceptFullDocuments";O:8:"stdClass":2:{s:3:"key";s:30:"Core.ConvertDocumentToFragment";s:7:"isAlias";b:1;}s:36:"Core.DirectLexLineNumberSyncInterval";i:5;s:20:"Core.DisableExcludes";i:7;s:15:"Core.EnableIDNA";i:7;s:13:"Core.Encoding";i:2;s:26:"Core.EscapeInvalidChildren";i:7;s:22:"Core.EscapeInvalidTags";i:7;s:29:"Core.EscapeNonASCIICharacters";i:7;s:19:"Core.HiddenElements";i:8;s:13:"Core.Language";i:1;s:24:"Core.LegacyEntityDecoder";i:7;s:14:"Core.LexerImpl";i:-11;s:24:"Core.MaintainLineNumbers";i:-7;s:22:"Core.NormalizeNewlines";i:7;s:21:"Core.RemoveInvalidImg";i:7;s:33:"Core.RemoveProcessingInstructions";i:7;s:25:"Core.RemoveScriptContents";i:-7;s:13:"Filter.Custom";i:9;s:34:"Filter.ExtractStyleBlocks.Escaping";i:7;s:33:"Filter.ExtractStyleBlocksEscaping";O:8:"stdClass":2:{s:3:"key";s:34:"Filter.ExtractStyleBlocks.Escaping";s:7:"isAlias";b:1;}s:38:"FilterParam.ExtractStyleBlocksEscaping";O:8:"stdClass":2:{s:3:"key";s:34:"Filter.ExtractStyleBlocks.Escaping";s:7:"isAlias";b:1;}s:31:"Filter.ExtractStyleBlocks.Scope";i:-1;s:30:"Filter.ExtractStyleBlocksScope";O:8:"stdClass":2:{s:3:"key";s:31:"Filter.ExtractStyleBlocks.Scope";s:7:"isAlias";b:1;}s:35:"FilterParam.ExtractStyleBlocksScope";O:8:"stdClass":2:{s:3:"key";s:31:"Filter.ExtractStyleBlocks.Scope";s:7:"isAlias";b:1;}s:34:"Filter.ExtractStyleBlocks.TidyImpl";i:-11;s:38:"FilterParam.ExtractStyleBlocksTidyImpl";O:8:"stdClass":2:{s:3:"key";s:34:"Filter.ExtractStyleBlocks.TidyImpl";s:7:"isAlias";b:1;}s:25:"Filter.ExtractStyleBlocks";i:7;s:14:"Filter.YouTube";i:7;s:12:"HTML.Allowed";i:-4;s:22:"HTML.AllowedAttributes";i:-8;s:20:"HTML.AllowedComments";i:8;s:26:"HTML.AllowedCommentsRegexp";i:-1;s:20:"HTML.AllowedElements";i:-8;s:19:"HTML.AllowedModules";i:-8;s:23:"HTML.Attr.Name.UseCDATA";i:7;s:17:"HTML.BlockWrapper";i:1;s:16:"HTML.CoreModules";i:8;s:18:"HTML.CustomDoctype";i:-1;s:17:"HTML.DefinitionID";i:-1;s:18:"HTML.DefinitionRev";i:5;s:12:"HTML.Doctype";O:8:"stdClass":3:{s:4:"type";i:1;s:10:"allow_null";b:1;s:7:"allowed";a:5:{s:22:"HTML 4.01 Transitional";b:1;s:16:"HTML 4.01 Strict";b:1;s:22:"XHTML 1.0 Transitional";b:1;s:16:"XHTML 1.0 Strict";b:1;s:9:"XHTML 1.1";b:1;}}s:25:"HTML.FlashAllowFullScreen";i:7;s:24:"HTML.ForbiddenAttributes";i:8;s:22:"HTML.ForbiddenElements";i:8;s:10:"HTML.Forms";i:7;s:17:"HTML.MaxImgLength";i:-5;s:13:"HTML.Nofollow";i:7;s:11:"HTML.Parent";i:1;s:16:"HTML.Proprietary";i:7;s:14:"HTML.SafeEmbed";i:7;s:15:"HTML.SafeIframe";i:7;s:15:"HTML.SafeObject";i:7;s:18:"HTML.SafeScripting";i:8;s:11:"HTML.Strict";i:7;s:16:"HTML.TargetBlank";i:7;s:19:"HTML.TargetNoopener";i:7;s:21:"HTML.TargetNoreferrer";i:7;s:12:"HTML.TidyAdd";i:8;s:14:"HTML.TidyLevel";O:8:"stdClass":2:{s:4:"type";i:1;s:7:"allowed";a:4:{s:4:"none";b:1;s:5:"light";b:1;s:6:"medium";b:1;s:5:"heavy";b:1;}}s:15:"HTML.TidyRemove";i:8;s:12:"HTML.Trusted";i:7;s:10:"HTML.XHTML";i:7;s:10:"Core.XHTML";O:8:"stdClass":2:{s:3:"key";s:10:"HTML.XHTML";s:7:"isAlias";b:1;}s:28:"Output.CommentScriptContents";i:7;s:26:"Core.CommentScriptContents";O:8:"stdClass":2:{s:3:"key";s:28:"Output.CommentScriptContents";s:7:"isAlias";b:1;}s:19:"Output.FixInnerHTML";i:7;s:18:"Output.FlashCompat";i:7;s:14:"Output.Newline";i:-1;s:15:"Output.SortAttr";i:7;s:17:"Output.TidyFormat";i:7;s:15:"Core.TidyFormat";O:8:"stdClass":2:{s:3:"key";s:17:"Output.TidyFormat";s:7:"isAlias";b:1;}s:17:"Test.ForceNoIconv";i:7;s:18:"URI.AllowedSchemes";i:8;s:8:"URI.Base";i:-1;s:17:"URI.DefaultScheme";i:-1;s:16:"URI.DefinitionID";i:-1;s:17:"URI.DefinitionRev";i:5;s:11:"URI.Disable";i:7;s:15:"Attr.DisableURI";O:8:"stdClass":2:{s:3:"key";s:11:"URI.Disable";s:7:"isAlias";b:1;}s:19:"URI.DisableExternal";i:7;s:28:"URI.DisableExternalResources";i:7;s:20:"URI.DisableResources";i:7;s:8:"URI.Host";i:-1;s:17:"URI.HostBlacklist";i:9;s:16:"URI.MakeAbsolute";i:7;s:9:"URI.Munge";i:-1;s:18:"URI.MungeResources";i:7;s:18:"URI.MungeSecretKey";i:-1;s:26:"URI.OverrideAllowedSchemes";i:7;s:20:"URI.SafeIframeRegexp";i:-1;}}s:14:"\0*\0definitions";a:1:{s:4:"HTML";O:27:"HTMLPurifier_HTMLDefinition":16:{s:4:"info";a:0:{}s:16:"info_global_attr";a:0:{}s:11:"info_parent";s:3:"div";s:15:"info_parent_def";N;s:18:"info_block_wrapper";s:1:"p";s:18:"info_tag_transform";a:0:{}s:23:"info_attr_transform_pre";a:0:{}s:24:"info_attr_transform_post";a:0:{}s:17:"info_content_sets";a:0:{}s:13:"info_injector";a:0:{}s:7:"doctype";N;s:40:"\0HTMLPurifier_HTMLDefinition\0_anonModule";O:23:"HTMLPurifier_HTMLModule":11:{s:4:"name";s:9:"Anonymous";s:8:"elements";a:1:{i:0;s:6:"iframe";}s:4:"info";a:1:{s:6:"iframe";O:23:"HTMLPurifier_ElementDef":13:{s:10:"standalone";b:0;s:4:"attr";a:1:{s:15:"allowfullscreen";s:4:"Bool";}s:18:"attr_transform_pre";a:0:{}s:19:"attr_transform_post";a:0:{}s:5:"child";N;s:13:"content_model";N;s:18:"content_model_type";N;s:22:"descendants_are_inline";b:0;s:13:"required_attr";a:0:{}s:8:"excludes";a:0:{}s:9:"autoclose";a:0:{}s:4:"wrap";N;s:10:"formatting";N;}}s:12:"content_sets";a:0:{}s:16:"attr_collections";a:0:{}s:18:"info_tag_transform";a:0:{}s:23:"info_attr_transform_pre";a:0:{}s:24:"info_attr_transform_post";a:0:{}s:13:"info_injector";a:0:{}s:17:"defines_child_def";b:0;s:4:"safe";b:1;}s:4:"type";s:4:"HTML";s:7:"manager";O:30:"HTMLPurifier_HTMLModuleManager":11:{s:8:"doctypes";O:28:"HTMLPurifier_DoctypeRegistry":2:{s:11:"\0*\0doctypes";a:5:{s:22:"HTML 4.01 Transitional";O:20:"HTMLPurifier_Doctype":7:{s:4:"name";s:22:"HTML 4.01 Transitional";s:7:"modules";a:18:{i:0;s:16:"CommonAttributes";i:1;s:4:"Text";i:2;s:9:"Hypertext";i:3;s:4:"List";i:4;s:12:"Presentation";i:5;s:4:"Edit";i:6;s:3:"Bdo";i:7;s:6:"Tables";i:8;s:5:"Image";i:9;s:14:"StyleAttribute";i:10;s:9:"Scripting";i:11;s:6:"Object";i:12;s:5:"Forms";i:13;s:4:"Name";i:14;s:6:"Legacy";i:15;s:6:"Target";i:16;s:6:"Iframe";i:17;s:22:"NonXMLCommonAttributes";}s:11:"tidyModules";a:2:{i:0;s:17:"Tidy_Transitional";i:1;s:16:"Tidy_Proprietary";}s:3:"xml";b:0;s:7:"aliases";a:0:{}s:9:"dtdPublic";s:38:"-//W3C//DTD HTML 4.01 Transitional//EN";s:9:"dtdSystem";s:36:"http://www.w3.org/TR/html4/loose.dtd";}s:16:"HTML 4.01 Strict";O:20:"HTMLPurifier_Doctype":7:{s:4:"name";s:16:"HTML 4.01 Strict";s:7:"modules";a:15:{i:0;s:16:"CommonAttributes";i:1;s:4:"Text";i:2;s:9:"Hypertext";i:3;s:4:"List";i:4;s:12:"Presentation";i:5;s:4:"Edit";i:6;s:3:"Bdo";i:7;s:6:"Tables";i:8;s:5:"Image";i:9;s:14:"StyleAttribute";i:10;s:9:"Scripting";i:11;s:6:"Object";i:12;s:5:"Forms";i:13;s:4:"Name";i:14;s:22:"NonXMLCommonAttributes";}s:11:"tidyModules";a:3:{i:0;s:11:"Tidy_Strict";i:1;s:16:"Tidy_Proprietary";i:2;s:9:"Tidy_Name";}s:3:"xml";b:0;s:7:"aliases";a:0:{}s:9:"dtdPublic";s:25:"-//W3C//DTD HTML 4.01//EN";s:9:"dtdSystem";s:37:"http://www.w3.org/TR/html4/strict.dtd";}s:22:"XHTML 1.0 Transitional";O:20:"HTMLPurifier_Doctype":7:{s:4:"name";s:22:"XHTML 1.0 Transitional";s:7:"modules";a:19:{i:0;s:16:"CommonAttributes";i:1;s:4:"Text";i:2;s:9:"Hypertext";i:3;s:4:"List";i:4;s:12:"Presentation";i:5;s:4:"Edit";i:6;s:3:"Bdo";i:7;s:6:"Tables";i:8;s:5:"Image";i:9;s:14:"StyleAttribute";i:10;s:9:"Scripting";i:11;s:6:"Object";i:12;s:5:"Forms";i:13;s:4:"Name";i:14;s:6:"Legacy";i:15;s:6:"Target";i:16;s:6:"Iframe";i:17;s:19:"XMLCommonAttributes";i:18;s:22:"NonXMLCommonAttributes";}s:11:"tidyModules";a:4:{i:0;s:17:"Tidy_Transitional";i:1;s:10:"Tidy_XHTML";i:2;s:16:"Tidy_Proprietary";i:3;s:9:"Tidy_Name";}s:3:"xml";b:1;s:7:"aliases";a:0:{}s:9:"dtdPublic";s:38:"-//W3C//DTD XHTML 1.0 Transitional//EN";s:9:"dtdSystem";s:55:"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";}s:16:"XHTML 1.0 Strict";O:20:"HTMLPurifier_Doctype":7:{s:4:"name";s:16:"XHTML 1.0 Strict";s:7:"modules";a:16:{i:0;s:16:"CommonAttributes";i:1;s:4:"Text";i:2;s:9:"Hypertext";i:3;s:4:"List";i:4;s:12:"Presentation";i:5;s:4:"Edit";i:6;s:3:"Bdo";i:7;s:6:"Tables";i:8;s:5:"Image";i:9;s:14:"StyleAttribute";i:10;s:9:"Scripting";i:11;s:6:"Object";i:12;s:5:"Forms";i:13;s:4:"Name";i:14;s:19:"XMLCommonAttributes";i:15;s:22:"NonXMLCommonAttributes";}s:11:"tidyModules";a:5:{i:0;s:11:"Tidy_Strict";i:1;s:10:"Tidy_XHTML";i:2;s:11:"Tidy_Strict";i:3;s:16:"Tidy_Proprietary";i:4;s:9:"Tidy_Name";}s:3:"xml";b:1;s:7:"aliases";a:0:{}s:9:"dtdPublic";s:32:"-//W3C//DTD XHTML 1.0 Strict//EN";s:9:"dtdSystem";s:49:"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";}s:9:"XHTML 1.1";O:20:"HTMLPurifier_Doctype":7:{s:4:"name";s:9:"XHTML 1.1";s:7:"modules";a:17:{i:0;s:16:"CommonAttributes";i:1;s:4:"Text";i:2;s:9:"Hypertext";i:3;s:4:"List";i:4;s:12:"Presentation";i:5;s:4:"Edit";i:6;s:3:"Bdo";i:7;s:6:"Tables";i:8;s:5:"Image";i:9;s:14:"StyleAttribute";i:10;s:9:"Scripting";i:11;s:6:"Object";i:12;s:5:"Forms";i:13;s:4:"Name";i:14;s:19:"XMLCommonAttributes";i:15;s:4:"Ruby";i:16;s:6:"Iframe";}s:11:"tidyModules";a:5:{i:0;s:11:"Tidy_Strict";i:1;s:10:"Tidy_XHTML";i:2;s:16:"Tidy_Proprietary";i:3;s:11:"Tidy_Strict";i:4;s:9:"Tidy_Name";}s:3:"xml";b:1;s:7:"aliases";a:0:{}s:9:"dtdPublic";s:25:"-//W3C//DTD XHTML 1.1//EN";s:9:"dtdSystem";s:44:"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd";}}s:10:"\0*\0aliases";N;}s:7:"doctype";N;s:9:"attrTypes";O:22:"HTMLPurifier_AttrTypes":1:{s:7:"\0*\0info";a:21:{s:4:"Enum";O:25:"HTMLPurifier_AttrDef_Enum":4:{s:12:"valid_values";a:0:{}s:17:"\0*\0case_sensitive";b:0;s:9:"minimized";b:0;s:8:"required";b:0;}s:4:"Bool";O:30:"HTMLPurifier_AttrDef_HTML_Bool":3:{s:7:"\0*\0name";b:0;s:9:"minimized";b:1;s:8:"required";b:0;}s:5:"CDATA";O:25:"HTMLPurifier_AttrDef_Text":2:{s:9:"minimized";b:0;s:8:"required";b:0;}s:2:"ID";O:28:"HTMLPurifier_AttrDef_HTML_ID":3:{s:11:"\0*\0selector";b:0;s:9:"minimized";b:0;s:8:"required";b:0;}s:6:"Length";O:32:"HTMLPurifier_AttrDef_HTML_Length":3:{s:6:"\0*\0max";N;s:9:"minimized";b:0;s:8:"required";b:0;}s:11:"MultiLength";O:37:"HTMLPurifier_AttrDef_HTML_MultiLength":3:{s:6:"\0*\0max";N;s:9:"minimized";b:0;s:8:"required";b:0;}s:8:"NMTOKENS";O:34:"HTMLPurifier_AttrDef_HTML_Nmtokens":2:{s:9:"minimized";b:0;s:8:"required";b:0;}s:6:"Pixels";O:32:"HTMLPurifier_AttrDef_HTML_Pixels":3:{s:6:"\0*\0max";N;s:9:"minimized";b:0;s:8:"required";b:0;}s:4:"Text";O:25:"HTMLPurifier_AttrDef_Text":2:{s:9:"minimized";b:0;s:8:"required";b:0;}s:3:"URI";O:24:"HTMLPurifier_AttrDef_URI":4:{s:9:"\0*\0parser";O:22:"HTMLPurifier_URIParser":1:{s:17:"\0*\0percentEncoder";O:27:"HTMLPurifier_PercentEncoder":1:{s:11:"\0*\0preserve";a:66:{i:48;b:1;i:49;b:1;i:50;b:1;i:51;b:1;i:52;b:1;i:53;b:1;i:54;b:1;i:55;b:1;i:56;b:1;i:57;b:1;i:65;b:1;i:66;b:1;i:67;b:1;i:68;b:1;i:69;b:1;i:70;b:1;i:71;b:1;i:72;b:1;i:73;b:1;i:74;b:1;i:75;b:1;i:76;b:1;i:77;b:1;i:78;b:1;i:79;b:1;i:80;b:1;i:81;b:1;i:82;b:1;i:83;b:1;i:84;b:1;i:85;b:1;i:86;b:1;i:87;b:1;i:88;b:1;i:89;b:1;i:90;b:1;i:97;b:1;i:98;b:1;i:99;b:1;i:100;b:1;i:101;b:1;i:102;b:1;i:103;b:1;i:104;b:1;i:105;b:1;i:106;b:1;i:107;b:1;i:108;b:1;i:109;b:1;i:110;b:1;i:111;b:1;i:112;b:1;i:113;b:1;i:114;b:1;i:115;b:1;i:116;b:1;i:117;b:1;i:118;b:1;i:119;b:1;i:120;b:1;i:121;b:1;i:122;b:1;i:45;b:1;i:46;b:1;i:95;b:1;i:126;b:1;}}}s:17:"\0*\0embedsResource";b:0;s:9:"minimized";b:0;s:8:"required";b:0;}s:12:"LanguageCode";O:25:"HTMLPurifier_AttrDef_Lang":2:{s:9:"minimized";b:0;s:8:"required";b:0;}s:5:"Color";O:31:"HTMLPurifier_AttrDef_HTML_Color":2:{s:9:"minimized";b:0;s:8:"required";b:0;}s:6:"IAlign";O:26:"HTMLPurifier_AttrDef_Clone":3:{s:8:"\0*\0clone";O:25:"HTMLPurifier_AttrDef_Enum":4:{s:12:"valid_values";a:5:{s:3:"top";i:0;s:6:"middle";i:1;s:6:"bottom";i:2;s:4:"left";i:3;s:5:"right";i:4;}s:17:"\0*\0case_sensitive";b:0;s:9:"minimized";b:0;s:8:"required";b:0;}s:9:"minimized";b:0;s:8:"required";b:0;}s:6:"LAlign";O:26:"HTMLPurifier_AttrDef_Clone":3:{s:8:"\0*\0clone";O:25:"HTMLPurifier_AttrDef_Enum":4:{s:12:"valid_values";a:4:{s:3:"top";i:0;s:6:"bottom";i:1;s:4:"left";i:2;s:5:"right";i:3;}s:17:"\0*\0case_sensitive";b:0;s:9:"minimized";b:0;s:8:"required";b:0;}s:9:"minimized";b:0;s:8:"required";b:0;}s:11:"FrameTarget";O:37:"HTMLPurifier_AttrDef_HTML_FrameTarget":4:{s:12:"valid_values";b:0;s:17:"\0*\0case_sensitive";b:0;s:9:"minimized";b:0;s:8:"required";b:0;}s:11:"ContentType";O:25:"HTMLPurifier_AttrDef_Text":2:{s:9:"minimized";b:0;s:8:"required";b:0;}s:12:"ContentTypes";O:25:"HTMLPurifier_AttrDef_Text":2:{s:9:"minimized";b:0;s:8:"required";b:0;}s:8:"Charsets";O:25:"HTMLPurifier_AttrDef_Text":2:{s:9:"minimized";b:0;s:8:"required";b:0;}s:9:"Character";O:25:"HTMLPurifier_AttrDef_Text":2:{s:9:"minimized";b:0;s:8:"required";b:0;}s:5:"Class";O:31:"HTMLPurifier_AttrDef_HTML_Class":2:{s:9:"minimized";b:0;s:8:"required";b:0;}s:6:"Number";O:28:"HTMLPurifier_AttrDef_Integer":5:{s:11:"\0*\0negative";b:0;s:7:"\0*\0zero";b:0;s:11:"\0*\0positive";b:1;s:9:"minimized";b:0;s:8:"required";b:0;}}}s:7:"modules";a:0:{}s:17:"registeredModules";a:0:{}s:11:"userModules";a:0:{}s:13:"elementLookup";a:0:{}s:8:"prefixes";a:1:{i:0;s:24:"HTMLPurifier_HTMLModule_";}s:11:"contentSets";N;s:15:"attrCollections";N;s:7:"trusted";b:0;}s:5:"setup";b:0;s:9:"optimized";b:0;}}s:12:"\0*\0finalized";b:1;s:8:"\0*\0plist";O:25:"HTMLPurifier_PropertyList":3:{s:7:"\0*\0data";a:5:{s:15:"Attr.AllowedRel";a:3:{s:8:"nofollow";b:1;s:11:"imageviewer";b:1;s:8:"lightbox";b:1;}s:15:"HTML.SafeObject";b:1;s:18:"Output.FlashCompat";b:1;s:14:"HTML.SafeEmbed";b:1;s:20:"Cache.SerializerPath";[[ser_cache_prod_purifier]]}s:9:"\0*\0parent";r:311;s:8:"\0*\0cache";N;}s:30:"\0HTMLPurifier_Config\0aliasMode";N;s:6:"chatty";b:1;s:25:"\0HTMLPurifier_Config\0lock";N;}";'),
(106, 'ZConfig', 'useids', 'i:0;'),
(107, 'ZConfig', 'idsmail', 'i:0;'),
(108, 'ZConfig', 'idsrulepath', 's:42:"Resources/config/phpids_zikula_default.xml";'),
(109, 'ZConfig', 'idssoftblock', 'i:1;'),
(110, 'ZConfig', 'idsfilter', 's:3:"xml";'),
(111, 'ZConfig', 'idsimpactthresholdone', 'i:1;'),
(112, 'ZConfig', 'idsimpactthresholdtwo', 'i:10;'),
(113, 'ZConfig', 'idsimpactthresholdthree', 'i:25;'),
(114, 'ZConfig', 'idsimpactthresholdfour', 'i:75;'),
(115, 'ZConfig', 'idsimpactmode', 'i:1;'),
(116, 'ZConfig', 'idshtmlfields', 'a:1:{i:0;s:14:"POST.__wysiwyg";}'),
(117, 'ZConfig', 'idsjsonfields', 'a:1:{i:0;s:15:"POST.__jsondata";}'),
(118, 'ZConfig', 'idsexceptions', 'a:12:{i:0;s:10:"GET.__utmz";i:1;s:10:"GET.__utmc";i:2;s:18:"REQUEST.linksorder";i:3;s:15:"POST.linksorder";i:4;s:19:"REQUEST.fullcontent";i:5;s:16:"POST.fullcontent";i:6;s:22:"REQUEST.summarycontent";i:7;s:19:"POST.summarycontent";i:8;s:19:"REQUEST.filter.page";i:9;s:16:"POST.filter.page";i:10;s:20:"REQUEST.filter.value";i:11;s:17:"POST.filter.value";}'),
(119, 'ZConfig', 'idscachingtype', 's:4:"none";'),
(120, 'ZConfig', 'idscachingexpiration', 'i:600;'),
(121, 'ZConfig', 'outputfilter', 'i:1;'),
(122, 'ZConfig', 'htmlentities', 'i:1;'),
(123, 'ZConfig', 'AllowableHTML', 'a:110:{s:3:"!--";i:2;s:1:"a";i:2;s:4:"abbr";i:1;s:7:"acronym";i:1;s:7:"address";i:1;s:6:"applet";i:0;s:4:"area";i:0;s:7:"article";i:1;s:5:"aside";i:1;s:5:"audio";i:0;s:1:"b";i:1;s:4:"base";i:0;s:8:"basefont";i:0;s:3:"bdo";i:0;s:3:"big";i:0;s:10:"blockquote";i:2;s:2:"br";i:2;s:6:"button";i:0;s:6:"canvas";i:0;s:7:"caption";i:1;s:6:"center";i:2;s:4:"cite";i:1;s:4:"code";i:0;s:3:"col";i:1;s:8:"colgroup";i:1;s:7:"command";i:0;s:8:"datalist";i:0;s:2:"dd";i:1;s:3:"del";i:0;s:7:"details";i:1;s:3:"dfn";i:0;s:3:"dir";i:0;s:3:"div";i:2;s:2:"dl";i:1;s:2:"dt";i:1;s:2:"em";i:2;s:5:"embed";i:0;s:8:"fieldset";i:1;s:10:"figcaption";i:0;s:6:"figure";i:0;s:6:"footer";i:0;s:4:"font";i:0;s:4:"form";i:0;s:2:"h1";i:1;s:2:"h2";i:1;s:2:"h3";i:1;s:2:"h4";i:1;s:2:"h5";i:1;s:2:"h6";i:1;s:6:"header";i:0;s:6:"hgroup";i:0;s:2:"hr";i:2;s:1:"i";i:1;s:6:"iframe";i:0;s:3:"img";i:2;s:5:"input";i:0;s:3:"ins";i:0;s:6:"keygen";i:0;s:3:"kbd";i:0;s:5:"label";i:1;s:6:"legend";i:1;s:2:"li";i:2;s:3:"map";i:0;s:4:"mark";i:0;s:4:"menu";i:0;s:7:"marquee";i:0;s:5:"meter";i:0;s:3:"nav";i:0;s:4:"nobr";i:0;s:6:"object";i:0;s:2:"ol";i:2;s:8:"optgroup";i:0;s:6:"option";i:0;s:6:"output";i:0;s:1:"p";i:2;s:5:"param";i:0;s:3:"pre";i:2;s:8:"progress";i:0;s:1:"q";i:0;s:2:"rp";i:0;s:2:"rt";i:0;s:4:"ruby";i:0;s:1:"s";i:0;s:4:"samp";i:0;s:6:"script";i:0;s:7:"section";i:0;s:6:"select";i:0;s:5:"small";i:0;s:6:"source";i:0;s:4:"span";i:2;s:6:"strike";i:0;s:6:"strong";i:2;s:3:"sub";i:1;s:7:"summary";i:1;s:3:"sup";i:0;s:5:"table";i:2;s:5:"tbody";i:1;s:2:"td";i:2;s:8:"textarea";i:0;s:5:"tfoot";i:1;s:2:"th";i:2;s:5:"thead";i:0;s:4:"time";i:0;s:2:"tr";i:2;s:2:"tt";i:2;s:1:"u";i:0;s:2:"ul";i:2;s:3:"var";i:0;s:5:"video";i:0;s:3:"wbr";i:0;}'),
(124, 'ZikulaMailerModule', 'enableLogging', 'b:0;'),
(125, 'ZikulaSearchModule', 'itemsperpage', 'i:10;'),
(126, 'ZikulaSearchModule', 'limitsummary', 'i:255;'),
(127, 'ZikulaSearchModule', 'opensearch_enabled', 'b:1;'),
(128, 'ZikulaSearchModule', 'opensearch_adult_content', 'b:0;'),
(129, 'ZikulaRoutesModule', 'routeEntriesPerPage', 'i:10;'),
(130, 'ZikulaRoutesModule', 'showOnlyOwnEntries', 'b:0;'),
(131, 'ZikulaRoutesModule', 'allowModerationSpecificCreatorForRoute', 'b:0;'),
(132, 'ZikulaRoutesModule', 'allowModerationSpecificCreationDateForRoute', 'b:0;'),
(133, 'ZConfig', 'system_identifier', '[[ser_system_identifier]]'),
(134, 'ZikulaMailerModule', 'transport', 's:6:"amazon";'),
(135, 'ZikulaMailerModule', 'mailer_id', 'N;'),
(136, 'ZikulaMailerModule', 'host', 'N;'),
(137, 'ZikulaMailerModule', 'port', 'N;'),
(138, 'ZikulaMailerModule', 'customParameters', 'N;'),
(139, 'ZikulaBootstrapTheme', 'home_template', 's:18:"3col_w_centerblock";'),
(140, 'ZikulaBootstrapTheme', 'master_template', 's:4:"2col";'),
(141, 'ZikulaBootstrapTheme', 'admin_template', 's:4:"1col";'),
(142, 'ZikulaBootstrapTheme', 'theme_style', 's:8:"cerulean";'),
(143, 'ZikulaBootstrapTheme', 'allow_style_change', 'b:0;');

-- --------------------------------------------------------

--
-- Table structure for table `sc_intrusion`
--

CREATE TABLE `sc_intrusion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tag` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `page` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `impact` int(11) NOT NULL,
  `filters` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  `uid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_8595CE46539B0606` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `search_result`
--

CREATE TABLE `search_result` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `text` longtext COLLATE utf8mb4_unicode_ci,
  `module` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `extra` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `created` datetime DEFAULT NULL,
  `found` datetime DEFAULT NULL,
  `sesid` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:object)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `search_stat`
--

CREATE TABLE `search_stat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `search` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `scount` int(11) NOT NULL,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `session_info`
--

CREATE TABLE `session_info` (
  `sessid` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ipaddr` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastused` datetime NOT NULL,
  `uid` int(11) NOT NULL,
  `remember` smallint(6) NOT NULL,
  `vars` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`sessid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `uname` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `activated` smallint(6) NOT NULL,
  `approved_date` datetime NOT NULL,
  `approved_by` int(11) NOT NULL,
  `user_regdate` datetime NOT NULL,
  `lastlogin` datetime NOT NULL,
  `tz` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `locale` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`uid`),
  KEY `uname` (`uname`),
  KEY `email` (`email`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES
(1, 'guest', '', 1, '1970-01-01 00:00:00', 2, '1970-01-01 00:00:00', '1970-01-01 00:00:00', '', ''),
(2, '[[admin_username]]', '[[admin_email]]', 1, '[[regtime]]', 2, '[[regtime]]', '[[regtime]]', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `users_attributes`
--

CREATE TABLE `users_attributes` (
  `name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`user_id`,`name`),
  KEY `IDX_E6F031E4A76ED395` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users_attributes`
--

INSERT INTO `users_attributes` VALUES
('authenticationMethod', 2, 'native_uname');

-- --------------------------------------------------------

--
-- Table structure for table `users_verifychg`
--

CREATE TABLE `users_verifychg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `changetype` smallint(6) NOT NULL,
  `uid` int(11) NOT NULL,
  `newemail` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `verifycode` varchar(138) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_dt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `zauth_authentication_mapping`
--

CREATE TABLE `zauth_authentication_mapping` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uid` int(11) NOT NULL,
  `uname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `verifiedEmail` tinyint(1) NOT NULL,
  `pass` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `zauth_authentication_mapping`
--

INSERT INTO `zauth_authentication_mapping` VALUES
(1, 'native_uname', 2, '[[admin_username]]', '[[admin_email]]', 1, '[[admin_pass]]');

-- --------------------------------------------------------

--
-- Table structure for table `zikula_routes_route`
--

CREATE TABLE `zikula_routes_route` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `workflowState` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bundle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `controller` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `route_action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `route_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `schemes` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `methods` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `prependBundlePrefix` tinyint(1) NOT NULL,
  `translatable` tinyint(1) NOT NULL,
  `translationPrefix` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `route_defaults` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `requirements` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `options` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `route_condition` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort` int(11) NOT NULL,
  `createdDate` datetime NOT NULL,
  `updatedDate` datetime NOT NULL,
  `createdBy_id` int(11) DEFAULT NULL,
  `updatedBy_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_516F46283174800F` (`createdBy_id`),
  KEY `IDX_516F462865FF1AEC` (`updatedBy_id`),
  KEY `workflowstateindex` (`workflowState`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `block_placements`
--
ALTER TABLE `block_placements`
  ADD CONSTRAINT `FK_911332124AF2B3F3` FOREIGN KEY (`bid`) REFERENCES `blocks` (`bid`),
  ADD CONSTRAINT `FK_911332125550C4ED` FOREIGN KEY (`pid`) REFERENCES `block_positions` (`pid`);

--
-- Constraints for table `categories_attributes`
--
ALTER TABLE `categories_attributes`
  ADD CONSTRAINT `FK_9015DE7812469DE2` FOREIGN KEY (`category_id`) REFERENCES `categories_category` (`id`);

--
-- Constraints for table `categories_category`
--
ALTER TABLE `categories_category`
  ADD CONSTRAINT `FK_D0B2B0F8727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `categories_category` (`id`),
  ADD CONSTRAINT `FK_D0B2B0F8A977936C` FOREIGN KEY (`tree_root`) REFERENCES `categories_category` (`id`) ON DELETE CASCADE;

--
-- 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 */;