Edit File by line

[0] Fix | Delete

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

[1] Fix | Delete

SET time_zone = "+00:00";

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[6] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[7] Fix | Delete

/*!40101 SET NAMES utf8 */;

[8] Fix | Delete

[9] Fix | Delete

[10] Fix | Delete

-- Database: `zikula304`

[11] Fix | Delete

[12] Fix | Delete

[13] Fix | Delete

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

[14] Fix | Delete

[15] Fix | Delete

[16] Fix | Delete

-- Table structure for table `admin_category`

[17] Fix | Delete

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `admin_category` (

[20] Fix | Delete

`cid` int(11) NOT NULL AUTO_INCREMENT,

[21] Fix | Delete

`name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,

[22] Fix | Delete

`description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[23] Fix | Delete

`icon` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,

[24] Fix | Delete

`sortorder` int(11) NOT NULL,

[25] Fix | Delete

PRIMARY KEY (`cid`)

[26] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=7 ;

[27] Fix | Delete

[28] Fix | Delete

[29] Fix | Delete

-- Dumping data for table `admin_category`

[30] Fix | Delete

[31] Fix | Delete

[32] Fix | Delete

INSERT INTO `admin_category` VALUES

[33] Fix | Delete

(1, 'System', 'Core modules at the heart of operation of the site.', 'fas fa-cogs', 0),

[34] Fix | Delete

(2, 'Layout', 'Layout modules for controlling the site''s look and feel.', 'fas fa-palette', 1),

[35] Fix | Delete

(3, 'Users', 'Modules for controlling user membership, access rights and profiles.', 'fas fa-users-cog', 2),

[36] Fix | Delete

(4, 'Content', 'Modules for providing content to your users.', 'fas fa-file-contract', 3),

[37] Fix | Delete

(5, 'Uncategorised', 'Newly-installed or uncategorized modules.', 'fas fa-cubes', 4),

[38] Fix | Delete

(6, 'Security', 'Modules for managing the site''s security.', 'fas fa-shield-alt', 5);

[39] Fix | Delete

[40] Fix | Delete

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

[41] Fix | Delete

[42] Fix | Delete

[43] Fix | Delete

-- Table structure for table `admin_module`

[44] Fix | Delete

[45] Fix | Delete

[46] Fix | Delete

CREATE TABLE `admin_module` (

[47] Fix | Delete

`amid` int(11) NOT NULL AUTO_INCREMENT,

[48] Fix | Delete

`mid` int(11) NOT NULL,

[49] Fix | Delete

`cid` int(11) NOT NULL,

[50] Fix | Delete

`sortorder` int(11) NOT NULL,

[51] Fix | Delete

PRIMARY KEY (`amid`),

[52] Fix | Delete

KEY `mid_cid` (`mid`,`cid`)

[53] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=20 ;

[54] Fix | Delete

[55] Fix | Delete

[56] Fix | Delete

-- Dumping data for table `admin_module`

[57] Fix | Delete

[58] Fix | Delete

[59] Fix | Delete

INSERT INTO `admin_module` VALUES

[60] Fix | Delete

(1, 6, 1, 0),

[61] Fix | Delete

(2, 7, 2, 0),

[62] Fix | Delete

(3, 8, 4, 0),

[63] Fix | Delete

(4, 1, 1, 1),

[64] Fix | Delete

(5, 9, 3, 0),

[65] Fix | Delete

(6, 10, 1, 2),

[66] Fix | Delete

(7, 11, 4, 1),

[67] Fix | Delete

(8, 12, 3, 1),

[68] Fix | Delete

(9, 13, 1, 3),

[69] Fix | Delete

(10, 14, 4, 2),

[70] Fix | Delete

(11, 15, 6, 0),

[71] Fix | Delete

(12, 16, 1, 4),

[72] Fix | Delete

(13, 17, 2, 1),

[73] Fix | Delete

(14, 18, 3, 2),

[74] Fix | Delete

(15, 19, 3, 3),

[75] Fix | Delete

(16, 20, 2, 2),

[76] Fix | Delete

(17, 21, 2, 3),

[77] Fix | Delete

(18, 22, 2, 4),

[78] Fix | Delete

(19, 23, 2, 5);

[79] Fix | Delete

[80] Fix | Delete

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

[81] Fix | Delete

[82] Fix | Delete

[83] Fix | Delete

-- Table structure for table `blocks`

[84] Fix | Delete

[85] Fix | Delete

[86] Fix | Delete

CREATE TABLE `blocks` (

[87] Fix | Delete

`bid` int(11) NOT NULL AUTO_INCREMENT,

[88] Fix | Delete

`bkey` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[89] Fix | Delete

`blocktype` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[90] Fix | Delete

`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[91] Fix | Delete

`description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,

[92] Fix | Delete

`properties` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',

[93] Fix | Delete

`filter` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',

[94] Fix | Delete

`active` int(11) NOT NULL,

[95] Fix | Delete

`last_update` datetime NOT NULL,

[96] Fix | Delete

`language` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,

[97] Fix | Delete

`mid` int(11) DEFAULT NULL,

[98] Fix | Delete

PRIMARY KEY (`bid`),

[99] Fix | Delete

KEY `IDX_CEED957841AEF4CE` (`mid`),

[100] Fix | Delete

KEY `active_idx` (`active`)

[101] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;

[102] Fix | Delete

[103] Fix | Delete

[104] Fix | Delete

-- Dumping data for table `blocks`

[105] Fix | Delete

[106] Fix | Delete

[107] Fix | Delete

INSERT INTO `blocks` VALUES

[108] Fix | Delete

(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),

[109] Fix | Delete

(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),

[110] Fix | Delete

(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),

[111] Fix | Delete

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

[112] Fix | Delete

[113] Fix | Delete

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

[114] Fix | Delete

[115] Fix | Delete

[116] Fix | Delete

-- Table structure for table `block_placements`

[117] Fix | Delete

[118] Fix | Delete

[119] Fix | Delete

CREATE TABLE `block_placements` (

[120] Fix | Delete

`pid` int(11) NOT NULL,

[121] Fix | Delete

`bid` int(11) NOT NULL,

[122] Fix | Delete

`sortorder` int(11) NOT NULL,

[123] Fix | Delete

PRIMARY KEY (`pid`,`bid`),

[124] Fix | Delete

KEY `IDX_911332125550C4ED` (`pid`),

[125] Fix | Delete

KEY `IDX_911332124AF2B3F3` (`bid`),

[126] Fix | Delete

KEY `bid_pid_idx` (`bid`,`pid`)

[127] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

[128] Fix | Delete

[129] Fix | Delete

[130] Fix | Delete

-- Dumping data for table `block_placements`

[131] Fix | Delete

[132] Fix | Delete

[133] Fix | Delete

INSERT INTO `block_placements` VALUES

[134] Fix | Delete

(1, 1, 0),

[135] Fix | Delete

(3, 2, 0),

[136] Fix | Delete

(7, 3, 1),

[137] Fix | Delete

(7, 4, 0);

[138] Fix | Delete

[139] Fix | Delete

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

[140] Fix | Delete

[141] Fix | Delete

[142] Fix | Delete

-- Table structure for table `block_positions`

[143] Fix | Delete

[144] Fix | Delete

[145] Fix | Delete

CREATE TABLE `block_positions` (

[146] Fix | Delete

`pid` int(11) NOT NULL AUTO_INCREMENT,

[147] Fix | Delete

`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[148] Fix | Delete

`description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[149] Fix | Delete

PRIMARY KEY (`pid`)

[150] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=9 ;

[151] Fix | Delete

[152] Fix | Delete

[153] Fix | Delete

-- Dumping data for table `block_positions`

[154] Fix | Delete

[155] Fix | Delete

[156] Fix | Delete

INSERT INTO `block_positions` VALUES

[157] Fix | Delete

(1, 'left', 'Left blocks'),

[158] Fix | Delete

(2, 'right', 'Right blocks'),

[159] Fix | Delete

(3, 'center', 'Center blocks'),

[160] Fix | Delete

(4, 'search', 'Search block'),

[161] Fix | Delete

(5, 'header', 'Header block'),

[162] Fix | Delete

(6, 'footer', 'Footer block'),

[163] Fix | Delete

(7, 'topnav', 'Top navigation block'),

[164] Fix | Delete

(8, 'bottomnav', 'Bottom navigation block');

[165] Fix | Delete

[166] Fix | Delete

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

[167] Fix | Delete

[168] Fix | Delete

[169] Fix | Delete

-- Table structure for table `bundles`

[170] Fix | Delete

[171] Fix | Delete

[172] Fix | Delete

CREATE TABLE `bundles` (

[173] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[174] Fix | Delete

`bundlename` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,

[175] Fix | Delete

`autoload` varchar(384) COLLATE utf8mb4_unicode_ci NOT NULL,

[176] Fix | Delete

`bundleclass` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,

[177] Fix | Delete

`bundletype` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,

[178] Fix | Delete

PRIMARY KEY (`id`),

[179] Fix | Delete

UNIQUE KEY `UNIQ_D8A73A9867B776D8` (`bundlename`)

[180] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;

[181] Fix | Delete

[182] Fix | Delete

[183] Fix | Delete

-- Dumping data for table `bundles`

[184] Fix | Delete

[185] Fix | Delete

[186] Fix | Delete

INSERT INTO `bundles` VALUES

[187] Fix | Delete

(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'),

[188] Fix | Delete

(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'),

[189] Fix | Delete

(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'),

[190] Fix | Delete

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

[191] Fix | Delete

[192] Fix | Delete

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

[193] Fix | Delete

[194] Fix | Delete

[195] Fix | Delete

-- Table structure for table `categories_attributes`

[196] Fix | Delete

[197] Fix | Delete

[198] Fix | Delete

CREATE TABLE `categories_attributes` (

[199] Fix | Delete

`name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,

[200] Fix | Delete

`category_id` int(11) NOT NULL,

[201] Fix | Delete

`value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,

[202] Fix | Delete

PRIMARY KEY (`category_id`,`name`),

[203] Fix | Delete

KEY `IDX_9015DE7812469DE2` (`category_id`)

[204] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

[205] Fix | Delete

[206] Fix | Delete

[207] Fix | Delete

-- Dumping data for table `categories_attributes`

[208] Fix | Delete

[209] Fix | Delete

[210] Fix | Delete

INSERT INTO `categories_attributes` VALUES

[211] Fix | Delete

('code', 11, 'P'),

[212] Fix | Delete

('code', 12, 'C'),

[213] Fix | Delete

('code', 13, 'A'),

[214] Fix | Delete

('code', 14, 'O'),

[215] Fix | Delete

('code', 15, 'R'),

[216] Fix | Delete

('code', 26, 'A'),

[217] Fix | Delete

('code', 27, 'I'),

[218] Fix | Delete

('code', 29, 'P'),

[219] Fix | Delete

('code', 30, 'A');

[220] Fix | Delete

[221] Fix | Delete

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

[222] Fix | Delete

[223] Fix | Delete

[224] Fix | Delete

-- Table structure for table `categories_category`

[225] Fix | Delete

[226] Fix | Delete

[227] Fix | Delete

CREATE TABLE `categories_category` (

[228] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[229] Fix | Delete

`tree_root` int(11) DEFAULT NULL,

[230] Fix | Delete

`parent_id` int(11) DEFAULT NULL,

[231] Fix | Delete

`lft` int(11) NOT NULL,

[232] Fix | Delete

`lvl` int(11) NOT NULL,

[233] Fix | Delete

`rgt` int(11) NOT NULL,

[234] Fix | Delete

`is_locked` tinyint(1) NOT NULL,

[235] Fix | Delete

`is_leaf` tinyint(1) NOT NULL,

[236] Fix | Delete

`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[237] Fix | Delete

`value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[238] Fix | Delete

`display_name` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',

[239] Fix | Delete

`display_desc` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',

[240] Fix | Delete

`status` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,

[241] Fix | Delete

`icon` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,

[242] Fix | Delete

`cr_date` datetime NOT NULL,

[243] Fix | Delete

`lu_date` datetime NOT NULL,

[244] Fix | Delete

`cr_uid` int(11) DEFAULT NULL,

[245] Fix | Delete

`lu_uid` int(11) DEFAULT NULL,

[246] Fix | Delete

PRIMARY KEY (`id`),

[247] Fix | Delete

KEY `IDX_D0B2B0F8A977936C` (`tree_root`),

[248] Fix | Delete

KEY `IDX_D0B2B0F8727ACA70` (`parent_id`),

[249] Fix | Delete

KEY `IDX_D0B2B0F88304AF18` (`cr_uid`),

[250] Fix | Delete

KEY `IDX_D0B2B0F8C072C1DD` (`lu_uid`),

[251] Fix | Delete

KEY `idx_categories_is_leaf` (`is_leaf`),

[252] Fix | Delete

KEY `idx_categories_status` (`status`)

[253] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=10000 ;

[254] Fix | Delete

[255] Fix | Delete

[256] Fix | Delete

-- Dumping data for table `categories_category`

[257] Fix | Delete

[258] Fix | Delete

[259] Fix | Delete

INSERT INTO `categories_category` VALUES

[260] Fix | Delete

(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),

[261] Fix | Delete

(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),

[262] Fix | Delete

(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),

[263] Fix | Delete

(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),

[264] Fix | Delete

(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),

[265] Fix | Delete

(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),

[266] Fix | Delete

(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),

[267] Fix | Delete

(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),

[268] Fix | Delete

(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),

[269] Fix | Delete

(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),

[270] Fix | Delete

(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),

[271] Fix | Delete

(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),

[272] Fix | Delete

(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),

[273] Fix | Delete

(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),

[274] Fix | Delete

(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),

[275] Fix | Delete

(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),

[276] Fix | Delete

(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),

[277] Fix | Delete

(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),

[278] Fix | Delete

(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),

[279] Fix | Delete

(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),

[280] Fix | Delete

(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),

[281] Fix | Delete

(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),

[282] Fix | Delete

(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),

[283] Fix | Delete

(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),

[284] Fix | Delete

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

[285] Fix | Delete

[286] Fix | Delete

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

[287] Fix | Delete

[288] Fix | Delete

[289] Fix | Delete

-- Table structure for table `categories_registry`

[290] Fix | Delete

[291] Fix | Delete

[292] Fix | Delete

CREATE TABLE `categories_registry` (

[293] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[294] Fix | Delete

`category_id` int(11) DEFAULT NULL,

[295] Fix | Delete

`modname` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,

[296] Fix | Delete

`entityname` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,

[297] Fix | Delete

`property` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[298] Fix | Delete

`obj_status` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,

[299] Fix | Delete

`cr_date` datetime NOT NULL,

[300] Fix | Delete

`lu_date` datetime NOT NULL,

[301] Fix | Delete

`cr_uid` int(11) DEFAULT NULL,

[302] Fix | Delete

`lu_uid` int(11) DEFAULT NULL,

[303] Fix | Delete

PRIMARY KEY (`id`),

[304] Fix | Delete

KEY `IDX_1B56B43312469DE2` (`category_id`),

[305] Fix | Delete

KEY `IDX_1B56B4338304AF18` (`cr_uid`),

[306] Fix | Delete

KEY `IDX_1B56B433C072C1DD` (`lu_uid`),

[307] Fix | Delete

KEY `idx_categories_registry` (`modname`,`entityname`)

[308] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[309] Fix | Delete

[310] Fix | Delete

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

[311] Fix | Delete

[312] Fix | Delete

[313] Fix | Delete

-- Table structure for table `extensions`

[314] Fix | Delete

[315] Fix | Delete

[316] Fix | Delete

CREATE TABLE `extensions` (

[317] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[318] Fix | Delete

`name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,

[319] Fix | Delete

`type` int(11) NOT NULL,

[320] Fix | Delete

`displayname` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,

[321] Fix | Delete

`url` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,

[322] Fix | Delete

`description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[323] Fix | Delete

`version` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,

[324] Fix | Delete

`icon` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,

[325] Fix | Delete

`capabilities` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',

[326] Fix | Delete

`state` int(11) NOT NULL,

[327] Fix | Delete

`securityschema` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',

[328] Fix | Delete

`coreCompatibility` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,

[329] Fix | Delete

PRIMARY KEY (`id`)

[330] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=24 ;

[331] Fix | Delete

[332] Fix | Delete

[333] Fix | Delete

-- Dumping data for table `extensions`

[334] Fix | Delete

[335] Fix | Delete

[336] Fix | Delete

INSERT INTO `extensions` VALUES

[337] Fix | Delete

(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'),

[338] Fix | Delete

(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'),

[339] Fix | Delete

(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'),

[340] Fix | Delete

(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'),

[341] Fix | Delete

(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'),

[342] Fix | Delete

(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'),

[343] Fix | Delete

(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'),

[344] Fix | Delete

(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'),

[345] Fix | Delete

(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'),

[346] Fix | Delete

(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'),

[347] Fix | Delete

(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'),

[348] Fix | Delete

(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'),

[349] Fix | Delete

(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'),

[350] Fix | Delete

(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'),

[351] Fix | Delete

(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'),

[352] Fix | Delete

(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'),

[353] Fix | Delete

(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'),

[354] Fix | Delete

(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'),

[355] Fix | Delete

(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'),

[356] Fix | Delete

(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'),

[357] Fix | Delete

(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'),

[358] Fix | Delete

(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'),

[359] Fix | Delete

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

[360] Fix | Delete

[361] Fix | Delete

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

[362] Fix | Delete

[363] Fix | Delete

[364] Fix | Delete

-- Table structure for table `extension_deps`

[365] Fix | Delete

[366] Fix | Delete

[367] Fix | Delete

CREATE TABLE `extension_deps` (

[368] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[369] Fix | Delete

`modid` int(11) NOT NULL,

[370] Fix | Delete

`modname` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,

[371] Fix | Delete

`minversion` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,

[372] Fix | Delete

`maxversion` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,

[373] Fix | Delete

`status` int(11) NOT NULL,

[374] Fix | Delete

PRIMARY KEY (`id`)

[375] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=97 ;

[376] Fix | Delete

[377] Fix | Delete

[378] Fix | Delete

-- Dumping data for table `extension_deps`

[379] Fix | Delete

[380] Fix | Delete

[381] Fix | Delete

INSERT INTO `extension_deps` VALUES

[382] Fix | Delete

(1, 2, 'php', '>=7.2.5', '>=7.2.5', 1),

[383] Fix | Delete

(2, 3, 'php', '>=7.2.5', '>=7.2.5', 1),

[384] Fix | Delete

(3, 3, 'league/oauth2-facebook', '2.*', '2.*', 1),

[385] Fix | Delete

(4, 3, 'league/oauth2-github', '2.*', '2.*', 1),

[386] Fix | Delete

(5, 3, 'league/oauth2-google', '3.*', '3.*', 1),

[387] Fix | Delete

(6, 3, 'league/oauth2-instagram', '2.*', '2.*', 1),

[388] Fix | Delete

(7, 3, 'league/oauth2-linkedin', '4.*', '4.*', 1),

[389] Fix | Delete

(8, 4, 'php', '>=7.2.5', '>=7.2.5', 1),

[390] Fix | Delete

(9, 5, 'php', '>=7.2.5', '>=7.2.5', 1),

[391] Fix | Delete

(10, 6, 'php', '>=7.2.5', '>=7.2.5', 1),

[392] Fix | Delete

(11, 6, 'zikula/core-bundle', '3.*', '3.*', 1),

[393] Fix | Delete

(12, 6, 'frdh/mmenu.js', '8.*', '8.*', 1),

[394] Fix | Delete

(13, 7, 'php', '>=7.2.5', '>=7.2.5', 1),

[395] Fix | Delete

(14, 7, 'zikula/core-bundle', '3.*', '3.*', 1),

[396] Fix | Delete

(15, 7, 'zikula/theme-module', '3.*', '3.*', 1),

[397] Fix | Delete

(16, 7, 'Scribite', '>=6.0.2', '>=6.0.2', 2),

[398] Fix | Delete

(17, 8, 'php', '>=7.2.5', '>=7.2.5', 1),

[399] Fix | Delete

(18, 8, 'zikula/core-bundle', '3.*', '3.*', 1),

[400] Fix | Delete

(19, 1, 'php', '>=7.2.5', '>=7.2.5', 1),

[401] Fix | Delete

(20, 1, 'zikula/core-bundle', '3.*', '3.*', 1),

[402] Fix | Delete

(21, 1, 'composer/semver', '1.*', '1.*', 1),

[403] Fix | Delete

(22, 1, 'justinrainbow/json-schema', '5.*', '5.*', 1),

[404] Fix | Delete

(23, 9, 'php', '>=7.2.5', '>=7.2.5', 1),

[405] Fix | Delete

(24, 9, 'zikula/core-bundle', '3.*', '3.*', 1),

[406] Fix | Delete

(25, 9, 'zikula/users-module', '3.*', '3.*', 1),

[407] Fix | Delete

(26, 10, 'php', '>=7.2.5', '>=7.2.5', 1),

[408] Fix | Delete

(27, 10, 'zikula/core-bundle', '3.*', '3.*', 1),

[409] Fix | Delete

(28, 10, 'egulias/email-validator', '^2.1.10', '^2.1.10', 1),

[410] Fix | Delete

(29, 11, 'php', '>=7.2.5', '>=7.2.5', 1),

[411] Fix | Delete

(30, 11, 'zikula/core-bundle', '3.*', '3.*', 1),

[412] Fix | Delete

(31, 11, 'knplabs/knp-menu-bundle', '>=2.2.1', '>=2.2.1', 1),

[413] Fix | Delete

(32, 12, 'php', '>=7.2.5', '>=7.2.5', 1),

[414] Fix | Delete

(33, 12, 'zikula/core-bundle', '3.*', '3.*', 1),

[415] Fix | Delete

(34, 13, 'php', '>=7.2.5', '>=7.2.5', 1),

[416] Fix | Delete

(35, 13, 'zikula/core-bundle', '3.*', '3.*', 1),

[417] Fix | Delete

(36, 13, 'jms/i18n-routing-bundle', '3.*', '3.*', 1),

[418] Fix | Delete

(37, 13, 'friendsofsymfony/jsrouting-bundle', '2.*', '2.*', 1),

[419] Fix | Delete

(38, 14, 'php', '>=7.2.5', '>=7.2.5', 1),

[420] Fix | Delete

(39, 14, 'zikula/core-bundle', '3.*', '3.*', 1),

[421] Fix | Delete

(40, 15, 'php', '>=7.2.5', '>=7.2.5', 1),

[422] Fix | Delete

(41, 15, 'zikula/core-bundle', '3.*', '3.*', 1),

[423] Fix | Delete

(42, 15, 'phpids/phpids', 'dev-master', 'dev-master', 1),

[424] Fix | Delete

(43, 16, 'php', '>=7.2.5', '>=7.2.5', 1),

[425] Fix | Delete

(44, 16, 'zikula/core-bundle', '3.*', '3.*', 1),

[426] Fix | Delete

(45, 16, 'php-translation/extractor', '2.*', '2.*', 1),

[427] Fix | Delete

(46, 16, 'php-translation/symfony-bundle', '0.*', '0.*', 1),

[428] Fix | Delete

(47, 16, 'php-translation/symfony-storage', '2.*', '2.*', 1),

[429] Fix | Delete

(48, 16, 'willdurand/js-translation-bundle', '3.*', '3.*', 1),

[430] Fix | Delete

(49, 17, 'php', '>=7.2.5', '>=7.2.5', 1),

[431] Fix | Delete

(50, 17, 'zikula/core-bundle', '3.*', '3.*', 1),

[432] Fix | Delete

(51, 17, 'zikula/blocks-module', '3.*', '3.*', 1),

[433] Fix | Delete

(52, 17, 'zikula/bootstrap-theme', '3.*', '3.*', 1),

[434] Fix | Delete

(53, 17, 'zikula/rss-theme', '3.*', '3.*', 1),

[435] Fix | Delete

(54, 17, 'zikula/printer-theme', '3.*', '3.*', 1),

[436] Fix | Delete

(55, 17, 'zikula/atom-theme', '3.*', '3.*', 1),

[437] Fix | Delete

(56, 17, 'twig/twig', '3.*', '3.*', 1),

[438] Fix | Delete

(57, 17, 'twig/cssinliner-extra', '3.*', '3.*', 1),

[439] Fix | Delete

(58, 17, 'twig/html-extra', '3.*', '3.*', 1),

[440] Fix | Delete

(59, 17, 'twig/inky-extra', '3.*', '3.*', 1),

[441] Fix | Delete

(60, 17, 'twig/intl-extra', '3.*', '3.*', 1),

[442] Fix | Delete

(61, 17, 'twig/markdown-extra', '3.*', '3.*', 1),

[443] Fix | Delete

(62, 17, 'twig/string-extra', '3.*', '3.*', 1),

[444] Fix | Delete

(63, 17, 'twig/extra-bundle', '3.*', '3.*', 1),

[445] Fix | Delete

(64, 17, 'erusev/parsedown', '^1.7', '^1.7', 1),

[446] Fix | Delete

(65, 17, 'league/commonmark', '^1.0', '^1.0', 1),

[447] Fix | Delete

(66, 17, 'league/html-to-markdown', '^4.8', '^4.8', 1),

[448] Fix | Delete

(67, 17, 'michelf/php-markdown', '^1.9', '^1.9', 1),

[449] Fix | Delete

(68, 17, 'oro/twig-inspector', '1.*', '1.*', 1),

[450] Fix | Delete

(69, 17, 'components/jquery', '3.*', '3.*', 1),

[451] Fix | Delete

(70, 17, 'components/jqueryui', '1.*', '1.*', 1),

[452] Fix | Delete

(71, 17, 'components/bootstrap', '4.*', '4.*', 1),

[453] Fix | Delete

(72, 17, 'components/font-awesome', '5.*', '5.*', 1),

[454] Fix | Delete

(73, 17, 'itsjavi/fontawesome-iconpicker', '3.*', '3.*', 1),

[455] Fix | Delete

(74, 17, 'dimsemenov/magnific-popup', '1.*', '1.*', 1),

[456] Fix | Delete

(75, 17, 'vakata/jstree', '3.*', '3.*', 1),

[457] Fix | Delete

(76, 18, 'php', '>=7.2.5', '>=7.2.5', 1),

[458] Fix | Delete

(77, 18, 'zikula/core-bundle', '3.*', '3.*', 1),

[459] Fix | Delete

(78, 18, 'zikula/groups-module', '3.*', '3.*', 1),

[460] Fix | Delete

(79, 18, 'zikula/permissions-module', '3.*', '3.*', 1),

[461] Fix | Delete

(80, 19, 'php', '>=7.2.5', '>=7.2.5', 1),

[462] Fix | Delete

(81, 19, 'zikula/core-bundle', '3.*', '3.*', 1),

[463] Fix | Delete

(82, 19, 'zikula/users-module', '3.*', '3.*', 1),

[464] Fix | Delete

(83, 19, 'ircmaxell/random-lib', '1.*', '1.*', 1),

[465] Fix | Delete

(84, 20, 'php', '>=7.2.5', '>=7.2.5', 1),

[466] Fix | Delete

(85, 20, 'zikula/core-bundle', '3.*', '3.*', 1),

[467] Fix | Delete

(86, 20, 'zikula/theme-module', '3.*', '3.*', 1),

[468] Fix | Delete

(87, 21, 'php', '>=7.2.5', '>=7.2.5', 1),

[469] Fix | Delete

(88, 21, 'zikula/core-bundle', '3.*', '3.*', 1),

[470] Fix | Delete

(89, 21, 'zikula/theme-module', '3.*', '3.*', 1),

[471] Fix | Delete

(90, 21, 'thomaspark/bootswatch', '4.*', '4.*', 1),

[472] Fix | Delete

(91, 22, 'php', '>=7.2.5', '>=7.2.5', 1),

[473] Fix | Delete

(92, 22, 'zikula/core-bundle', '3.*', '3.*', 1),

[474] Fix | Delete

(93, 22, 'zikula/theme-module', '3.*', '3.*', 1),

[475] Fix | Delete

(94, 23, 'php', '>=7.2.5', '>=7.2.5', 1),

[476] Fix | Delete

(95, 23, 'zikula/core-bundle', '3.*', '3.*', 1),

[477] Fix | Delete

(96, 23, 'zikula/theme-module', '3.*', '3.*', 1);

[478] Fix | Delete

[479] Fix | Delete

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

[480] Fix | Delete

[481] Fix | Delete

[482] Fix | Delete

-- Table structure for table `groups`

[483] Fix | Delete

[484] Fix | Delete

[485] Fix | Delete

CREATE TABLE `groups` (

[486] Fix | Delete

`gid` int(11) NOT NULL AUTO_INCREMENT,

[487] Fix | Delete

`name` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,

[488] Fix | Delete

`gtype` smallint(6) NOT NULL,

[489] Fix | Delete

`description` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,

[490] Fix | Delete

`state` smallint(6) NOT NULL,

[491] Fix | Delete

`nbumax` int(11) NOT NULL,

[492] Fix | Delete

PRIMARY KEY (`gid`),

[493] Fix | Delete

UNIQUE KEY `UNIQ_F06D39705E237E06` (`name`)

[494] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;

[495] Fix | Delete

[496] Fix | Delete

[497] Fix | Delete

-- Dumping data for table `groups`

[498] Fix | Delete

[499] Fix | Delete

12 3