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: `subrion421`
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]acl_objects`
CREATE TABLE `[[dbprefix]]acl_objects` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pre_object` char(40) NOT NULL,
`object` char(30) NOT NULL,
`action` char(15) NOT NULL DEFAULT 'read',
`access` tinyint(1) unsigned NOT NULL DEFAULT '1',
`module` char(40) NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=54 ;
-- Dumping data for table `[[dbprefix]]acl_objects`
INSERT INTO `[[dbprefix]]acl_objects` VALUES
(1, 'admin_access', 'admin_access', 'read', 0, ''),
(2, 'admin_page', 'blocks', 'smarty', 1, ''),
(3, 'admin_page', 'blocks', 'plain', 1, ''),
(4, 'admin_page', 'blocks', 'php', 1, ''),
(5, 'admin_page', 'blocks', 'html', 1, ''),
(6, 'admin_page', 'blocks', 'edit', 1, ''),
(7, 'admin_page', 'blocks', 'visual', 0, ''),
(8, 'admin_page', 'blocks', 'order', 0, ''),
(9, 'admin_page', 'configuration', 'edit', 0, ''),
(10, 'admin_page', 'currencies', 'add', 1, ''),
(11, 'admin_page', 'currencies', 'edit', 1, ''),
(12, 'admin_page', 'currencies', 'delete', 1, ''),
(13, 'admin_page', 'database', 'sql', 1, ''),
(14, 'admin_page', 'database', 'export', 0, ''),
(15, 'admin_page', 'database', 'import', 0, ''),
(16, 'admin_page', 'database', 'consistency', 1, ''),
(17, 'admin_page', 'database', 'reset', 1, ''),
(18, 'admin_page', 'fields', 'members', 0, ''),
(19, 'admin_page', 'index', 'cache', 1, ''),
(20, 'admin_page', 'index', 'debugmode', 0, ''),
(21, 'admin_page', 'index', 'phpinfo', 0, ''),
(22, 'admin_page', 'index', 'sitemap', 1, ''),
(23, 'admin_page', 'members', 'add', 1, ''),
(24, 'admin_page', 'members', 'edit', 0, ''),
(25, 'admin_page', 'members', 'password', 0, ''),
(26, 'admin_page', 'members', 'usergroup', 0, ''),
(27, 'admin_page', 'menus', 'add', 1, ''),
(28, 'admin_page', 'menus', 'edit', 1, ''),
(29, 'admin_page', 'packages', 'activate', 0, ''),
(30, 'admin_page', 'packages', 'set_default', 0, ''),
(31, 'admin_page', 'packages', 'uninstall', 0, ''),
(32, 'admin_page', 'packages', 'install', 0, ''),
(33, 'admin_page', 'packages', 'upgrade', 0, ''),
(34, 'admin_page', 'pages', 'add', 1, ''),
(35, 'admin_page', 'pages', 'edit', 1, ''),
(36, 'admin_page', 'pages', 'home', 0, ''),
(37, 'admin_page', 'permissions', 'read', 0, ''),
(38, 'admin_page', 'permissions', 'edit', 0, ''),
(39, 'admin_page', 'plans', 'add', 1, ''),
(40, 'admin_page', 'plans', 'edit', 1, ''),
(41, 'admin_page', 'plans', 'delete', 1, ''),
(42, 'admin_page', 'plugins', 'install', 1, ''),
(43, 'admin_page', 'plugins', 'uninstall', 0, ''),
(44, 'admin_page', 'plugins', 'reinstall', 0, ''),
(45, 'admin_page', 'plugins', 'update', 0, ''),
(46, 'admin_page', 'blog', 'read', 1, 'blog'),
(47, 'admin_page', 'blog', 'add', 1, 'blog'),
(48, 'admin_page', 'blog', 'edit', 1, 'blog'),
(49, 'admin_page', 'blog', 'delete', 1, 'blog'),
(50, 'page', 'blog', 'read', 1, 'blog'),
(51, 'page', 'blog', 'add', 1, 'blog'),
(52, 'page', 'blog', 'edit', 1, 'blog'),
(53, 'page', 'blog', 'delete', 1, 'blog');
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]acl_privileges`
CREATE TABLE `[[dbprefix]]acl_privileges` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` enum('user','group','plan') NOT NULL DEFAULT 'group',
`type_id` mediumint(8) unsigned NOT NULL,
`access` tinyint(1) unsigned NOT NULL,
`action` varchar(15) NOT NULL DEFAULT 'read',
`object` varchar(50) NOT NULL,
`object_id` varchar(150) NOT NULL DEFAULT '0',
`module` varchar(40) NOT NULL,
UNIQUE KEY `UNIQUE` (`type`,`type_id`,`action`,`object`,`object_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=5 ;
-- Dumping data for table `[[dbprefix]]acl_privileges`
INSERT INTO `[[dbprefix]]acl_privileges` VALUES
(1, 'group', 2, 1, 'read', 'admin_access', '0', ''),
(2, 'group', 4, 0, 'read', 'page', 'member_funds', ''),
(3, 'group', 4, 0, 'read', 'page', 'profile', ''),
(4, 'group', 8, 1, 'read', 'page', 'profile', '');
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]admin_actions`
CREATE TABLE `[[dbprefix]]admin_actions` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`url` varchar(100) NOT NULL,
`icon` varchar(50) DEFAULT NULL,
`attributes` tinytext NOT NULL,
`module` varchar(40) NOT NULL,
`pages` tinytext NOT NULL,
`text` varchar(50) DEFAULT NULL,
`type` enum('regular','dashboard') DEFAULT 'regular',
`order` smallint(5) unsigned NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=43 ;
-- Dumping data for table `[[dbprefix]]admin_actions`
INSERT INTO `[[dbprefix]]admin_actions` VALUES
(1, 'members', 'members/', 'list', '', '', 'members:add,members:edit,usergroups:read', '', 'regular', 1),
(2, 'add_member', 'members/add/', 'user', '', '', 'members:read,members:edit,usergroups', '', 'regular', 2),
(3, 'usergroups', 'usergroups/', 'grid', '', '', 'members,usergroups:add', '', 'regular', 3),
(4, 'add_usergroup', 'usergroups/add/', 'users', '', '', 'usergroups:read', '', 'regular', 4),
(5, 'fields', 'fields/members/', 'signup', '', '', 'members,usergroups', '', 'regular', 5),
(6, 'delete', 'javascript:;', 'remove', 'id="js-delete-block"', '', 'blocks:edit', '', 'regular', 1),
(7, 'blocks', 'blocks/', 'grid', '', '', 'blocks:add,blocks:edit', '', 'regular', 2),
(8, 'add_block', 'blocks/create/', 'plus-alt', '', '', 'blocks', '', 'regular', 3),
(9, 'sql_management', 'database/sql/', 'database', '', '', 'database', '', 'regular', 1),
(10, 'reset', 'database/reset/', 'loop', '', '', 'database', '', 'regular', 2),
(11, 'consistency', 'database/consistency/', 'spinner', '', '', 'database', '', 'regular', 3),
(12, 'export', 'database/export/', 'box-remove', '', '', 'database', '', 'regular', 5),
(13, 'import', 'database/import/', 'box-add', '', '', 'database', '', 'regular', 6),
(14, 'fields', 'fields/', 'list', '', '', 'fields:edit,member_fields', '', 'regular', 1),
(15, 'add_field', 'fields/add/', 'plus-alt', '', '', 'fields,member_fields', '', 'regular', 2),
(16, 'field_groups', 'fieldgroups/', 'list-2', '', '', 'fieldgroups,member_fields', '', 'regular', 3),
(17, 'add_fieldgroup', 'fieldgroups/add/', 'folder-plus', '', '', 'fieldgroups,member_fields', '', 'regular', 4),
(18, 'image_types', 'image-types/', 'list', '', '', 'imagetypes:edit', '', 'regular', 1),
(19, 'add_image_type', 'image-types/add/', 'plus-alt', '', '', 'imagetypes', '', 'regular', 2),
(20, 'add_invoice', 'invoices/add/', 'plus-alt', '', '', 'invoices,invoices:edit', '', 'regular', 1),
(21, 'languages', 'languages/', 'list', '', '', 'languages', '', 'regular', 1),
(22, 'new_language', 'languages/add/', 'copy', '', '', 'languages', '', 'regular', 2),
(23, 'download', 'languages/download/', 'box-remove', '', '', 'languages', '', 'regular', 3),
(24, 'add_phrase', 'phrases/add/', 'plus-alt', '', '', 'languages,phrases', '', 'regular', 4),
(25, 'languages_comparison', 'languages/comparison/', 'link-2', '', '', 'languages', '', 'regular', 5),
(26, 'menus', 'menus/', 'list', '', '', 'menus:add,menus:edit', '', 'regular', 3),
(27, 'add_menu', 'menus/add/', 'plus-alt', '', '', 'menus', '', 'regular', 4),
(28, 'delete', 'javascript:;', 'remove', 'id="js-delete-page"', '', 'pages:edit', '', 'regular', 1),
(29, 'pages', 'pages/', 'list', '', '', 'pages:add,pages:edit', '', 'regular', 2),
(30, 'add_page', 'pages/add/', 'plus-alt', '', '', 'pages', '', 'regular', 3),
(31, 'plans', 'plans/', 'list', '', '', 'plans:add,plans:edit', '', 'regular', 3),
(32, 'add_plan', 'plans/add/', 'plus-alt', '', '', 'plans', '', 'regular', 4),
(33, 'print_invoice', 'invoices/printable/:id/', 'file', 'target="_blank"', '', 'invoices:edit', '', 'regular', 2),
(34, 'add_transaction', 'javascript:;', 'plus', 'id="js-add-transaction-cmd"', '', 'transactions', '', 'regular', 1),
(35, 'tags', 'javascript:;', 'eye', 'id="js-view-tags"', '', 'email_templates', '', 'regular', 1),
(36, 'add_currency', 'currencies/add/', 'plus-alt', '', '', 'currencies', '', 'regular', 3),
(37, 'list_currencies', 'currencies/', 'list', '', '', 'currencies:add,currencies:edit', '', 'regular', 3),
(38, 'blocks', 'blocks/', 'grid', '', '', '', '', 'dashboard', 0),
(39, 'add_page', 'pages/add/', 'copy', '', '', '', '', 'dashboard', 0),
(40, 'blogposts', 'blog/', 'list', '', 'blog', 'blog:add,blog:edit', '', 'regular', 7),
(41, 'add_blog_entry', 'blog/add/', 'plus', '', 'blog', 'blog:read,blog:edit', '', 'regular', 8),
(42, 'dashboard_blogpost_add', 'blog/add/', 'quill', '', 'blog', '', '', 'dashboard', 9);
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]admin_pages`
CREATE TABLE `[[dbprefix]]admin_pages` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`group` smallint(4) unsigned NOT NULL,
`name` varchar(50) NOT NULL,
`order` smallint(5) unsigned NOT NULL,
`alias` varchar(150) NOT NULL,
`module` varchar(40) NOT NULL,
`filename` varchar(50) NOT NULL,
`attr` varchar(150) DEFAULT NULL,
`menus` set('menu','header') NOT NULL DEFAULT 'menu',
`status` enum('active','inactive') NOT NULL DEFAULT 'active',
`readonly` tinyint(1) unsigned NOT NULL DEFAULT '0',
`action` char(15) NOT NULL DEFAULT 'read',
`parent` varchar(50) NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=46 ;
-- Dumping data for table `[[dbprefix]]admin_pages`
INSERT INTO `[[dbprefix]]admin_pages` VALUES
(1, 0, 'index', 0, '', '', 'index', NULL, 'menu', 'active', 0, 'read', ''),
(2, 0, 'actions', 0, 'actions/', '', 'actions', NULL, '', 'active', 1, 'read', ''),
(3, 0, '', 20, '', '', '', NULL, 'header', 'active', 0, '', ''),
(4, 0, 'adminer', 25, 'adminer/', '', 'adminer', NULL, 'header', 'active', 0, 'read', ''),
(5, 0, '', 30, '', '', '', NULL, 'header', 'active', 0, '', ''),
(6, 0, 'visual_mode', 0, 'visual-mode/', '', 'visual', 'target="_blank"', '', 'active', 1, 'visual', 'blocks'),
(7, 1, '', 0, '', '', '', 'sys_mgmt', 'menu', 'active', 0, '', ''),
(8, 1, 'configuration', 5, 'configuration/', '', 'configuration', NULL, 'header', 'active', 0, 'read', ''),
(9, 1, 'database', 10, 'database/', '', 'database', NULL, 'menu,header', 'active', 0, 'read', ''),
(10, 1, 'languages', 15, 'languages/', '', 'languages', NULL, 'menu', 'active', 0, 'read', ''),
(11, 1, 'hooks', 20, 'hooks/', '', 'hooks', NULL, 'menu', 'active', 0, 'read', ''),
(12, 1, 'scheduled_tasks', 22, 'scheduled-tasks/', '', 'scheduled-tasks', NULL, 'menu', 'active', 0, 'read', ''),
(13, 1, '', 25, '', '', '', 'sys_email', 'menu', 'active', 0, '', ''),
(14, 1, 'email_templates', 30, 'email-templates/', '', 'email-templates', NULL, 'menu', 'active', 0, 'read', ''),
(15, 1, '', 35, '', '', '', 'sys_extra', 'menu', 'active', 0, '', ''),
(16, 1, 'clear_cache', 37, 'clear/cache/', '', 'index', NULL, 'menu,header', 'active', 0, 'cache', 'index'),
(17, 1, 'phpinfo', 40, 'phpinfo/', '', 'index', NULL, 'menu,header', 'active', 0, 'phpinfo', 'index'),
(18, 1, 'debugmode', 41, 'debug-mode/', '', 'index', NULL, '', 'active', 0, 'debugmode', 'index'),
(19, 1, 'sitemap', 45, 'sitemap/', '', 'index', NULL, 'menu,header', 'active', 0, 'sitemap', 'index'),
(20, 2, 'pages', 5, 'pages/', '', 'pages', NULL, 'menu', 'active', 0, 'read', ''),
(21, 2, 'menus', 10, 'menus/', '', 'menus', NULL, 'menu', 'active', 0, 'read', ''),
(22, 2, 'blocks', 15, 'blocks/', '', 'blocks', NULL, 'menu', 'active', 0, 'read', ''),
(23, 2, 'phrases', 20, 'phrases/', '', 'phrases', NULL, 'menu', 'active', 0, 'read', ''),
(24, 2, 'uploads', 23, 'uploads/', '', 'uploads', NULL, 'menu', 'active', 0, 'read', ''),
(25, 2, '', 25, '', '', '', 'ctnt_ext', 'menu', 'active', 0, '', ''),
(26, 2, 'fieldgroups', 30, 'fieldgroups/', '', 'fieldgroups', NULL, 'menu', 'active', 0, 'read', ''),
(27, 2, 'fields', 35, 'fields/', '', 'fields', NULL, 'menu', 'active', 0, 'read', ''),
(28, 2, 'imagetypes', 40, 'image-types/', '', 'image-types', NULL, 'menu', 'active', 0, 'read', ''),
(29, 2, '', 45, '', '', '', 'ctnt_xtns', 'menu', 'active', 0, '', ''),
(30, 3, 'members', 5, 'members/', '', 'members', NULL, 'menu', 'active', 0, 'read', ''),
(31, 3, 'usergroups', 10, 'usergroups/', '', 'usergroups', NULL, 'menu,header', 'active', 0, 'read', ''),
(32, 3, '', 15, '', '', '', 'mbr_ext', 'menu', 'active', 0, '', ''),
(33, 3, 'permissions', 20, 'permissions/', '', 'permissions', NULL, 'menu', 'active', 0, 'read', ''),
(34, 3, 'member_fields', 25, 'fields/members/', '', 'fields', NULL, 'menu', 'active', 0, 'member', 'fields'),
(35, 4, 'currencies', 0, 'currencies/', '', 'currencies', NULL, 'menu', 'active', 0, 'read', ''),
(36, 4, '', 5, '', '', '', 'fin_mgmt', 'menu', 'active', 0, '', ''),
(37, 4, 'plans', 10, 'plans/', '', 'plans', NULL, 'menu', 'active', 0, 'read', ''),
(38, 4, 'subscriptions', 15, 'subscriptions/', '', 'subscriptions', NULL, 'menu', 'active', 0, 'read', ''),
(39, 4, 'transactions', 20, 'transactions/', '', 'transactions', NULL, 'menu', 'active', 0, 'read', ''),
(40, 4, 'invoices', 25, 'invoices/', '', 'invoices', NULL, 'menu', 'active', 0, 'read', ''),
(41, 5, 'templates', 5, 'modules/templates/', '', 'modules', NULL, 'menu', 'active', 0, 'read', ''),
(42, 5, 'plugins', 10, 'modules/plugins/', '', 'modules', NULL, 'menu', 'active', 0, 'read', ''),
(43, 5, 'packages', 15, 'modules/packages/', '', 'modules', NULL, 'menu', 'active', 0, 'read', ''),
(44, 5, '', 20, '', '', '', 'xtns_empt', 'menu', 'active', 0, '', ''),
(45, 2, 'blog', 50, 'blog/', 'blog', '', NULL, 'menu', 'active', 0, 'read', '');
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]admin_pages_groups`
CREATE TABLE `[[dbprefix]]admin_pages_groups` (
`id` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
`order` smallint(4) unsigned NOT NULL,
`name` varchar(50) NOT NULL,
`module` varchar(40) NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=6 ;
-- Dumping data for table `[[dbprefix]]admin_pages_groups`
INSERT INTO `[[dbprefix]]admin_pages_groups` VALUES
(5, 0, 'extensions', '');
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]api_tokens`
CREATE TABLE `[[dbprefix]]api_tokens` (
`member_id` int(11) unsigned DEFAULT NULL,
`expires` datetime NOT NULL,
`ip` bigint(12) NOT NULL,
`session` char(32) NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]blocks`
CREATE TABLE `[[dbprefix]]blocks` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
`order` smallint(5) unsigned NOT NULL,
`position` varchar(30) NOT NULL DEFAULT 'left',
`type` enum('plain','smarty','php','html','menu') NOT NULL DEFAULT 'plain',
`module` varchar(40) NOT NULL,
`status` enum('active','inactive') NOT NULL DEFAULT 'active',
`header` tinyint(1) unsigned NOT NULL DEFAULT '1',
`collapsible` tinyint(1) unsigned NOT NULL DEFAULT '1',
`collapsed` tinyint(1) unsigned NOT NULL DEFAULT '0',
`sticky` tinyint(1) unsigned NOT NULL,
`tpl` varchar(64) NOT NULL DEFAULT '',
`external` tinyint(1) NOT NULL DEFAULT '0',
`removable` tinyint(1) unsigned NOT NULL DEFAULT '1',
`classname` varchar(50) NOT NULL,
UNIQUE KEY `UNIQUE` (`name`,`module`),
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=22 ;
-- Dumping data for table `[[dbprefix]]blocks`
INSERT INTO `[[dbprefix]]blocks` VALUES
(2, 'inventory', '', 0, 'inventory', 'menu', '', 'active', 0, 0, 0, 1, '', 'render-menu.tpl', 0, '', 0, '', ''),
(3, 'main', '', 0, 'mainmenu', 'menu', '', 'active', 0, 0, 0, 1, '', 'render-menu.tpl', 0, '', 0, '', ''),
(4, 'account', '', 0, 'account', 'menu', '', 'active', 0, 0, 0, 1, '', 'render-menu.tpl', 0, '', 0, '', ''),
(5, 'bottom', '', 0, 'copyright', 'menu', '', 'active', 0, 0, 0, 1, '', 'render-menu.tpl', 0, '', 0, '', ''),
(6, 'common_statistics', '', 1, 'right', 'smarty', '', 'active', 1, 0, 0, 0, '', '', 1, 'block.common-statistics.tpl', 0, '', 'box--border'),
(7, 'filters', '$iaView = &$iaCore->iaView;\r\n\r\nif (($itemName = $iaView->get(''filtersItemName''))\r\n || (($itemName = str_replace(''search_'', '''', $iaView->name())) && $itemName != $iaView->name()))\r\n{\r\n $iaView->iaSmarty->assign(''filters'', $iaCore->factory(''search'', iaCore::FRONT)->getFilters($itemName));\r\n\r\n echo $iaView->iaSmarty->fetch(''block.filters.tpl'');\r\n}', 1, 'left', 'php', '', 'active', 1, 1, 0, 1, '', '', 0, '', 1, '', 'box--border'),
(8, 'header', NULL, 2, 'teaser', 'html', 'kickstart', 'active', 0, 0, 0, 0, '', '', 0, '', 1, NULL, ''),
(9, 'landing_what_is_this', '<div class="row text-center m-t-md">\n <div class="col-md-4">\n <img src="{$img}browser.png" width="64" alt=""/>\n <h4 class="m-t">Landing page</h4>\n <p class="text-fade-75">This is a starting page for your website. You can change it (switch off) to display content and blocks. This can be done on Template configuration page.</p>\n </div>\n <div class="col-md-4">\n <img src="{$img}computer.png" width="64" alt=""/>\n <h4 class="m-t">Configuration options</h4>\n <p class="text-fade-75"><b>Kickstart</b> template has many configuration options to play with. Go to admin panel and try to change, for example, background of header block.</p>\n </div>\n <div class="col-md-4">\n <img src="{$img}computer2.png" width="64" alt=""/>\n <h4 class="m-t">Blocks management</h4>\n <p class="text-fade-75">Each section on this page can be changed in Admin Dashboard in Blocks section, as well as all other blocks on all pages. Go give it a try!</p>\n </div>\n</div>\n<div class="text-center m-t-lg">\n <a class="btn btn-primary text-uppercase" href="{$smarty.const.IA_ADMIN_URL}">Go to admin dashboard</a>\n</div>', 200, 'landing', 'smarty', 'kickstart', 'active', 1, 0, 0, 0, '', '', 0, '', 1, NULL, 'section section-what'),
(10, 'landing_features', NULL, 201, 'landing', 'html', 'kickstart', 'active', 1, 0, 0, 0, '', '', 0, '', 1, NULL, 'section section-features'),
(11, 'landing_mobile', '<div class="row">\n <div class="col-md-6 col-md-offset-2">\n <div class="section-mobile__text">\n <h2>{$block.title}</h2>\n <p class="lead">Lorem ipsum dolor sit amet, consectetur adipisicing elit. Fuga ipsa distinctio vel aspernatur, reiciendis excepturi.</p>\n <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit. At animi corporis laboriosam. Maiores voluptatibus dicta ea, quo repellendus eum officiis enim non? Porro aut harum pariatur sit adipisci accusantium rem!\n </p>\n </div>\n </div>\n</div>', 202, 'landing', 'smarty', 'kickstart', 'active', 0, 0, 0, 0, '', '', 0, '', 1, NULL, 'section section-mobile'),
(12, 'top', NULL, 203, 'top', 'html', 'kickstart', 'active', 1, 1, 0, 0, '', '', 0, '', 1, NULL, ''),
(13, 'bottom_block', NULL, 204, 'bottom', 'html', 'kickstart', 'active', 1, 1, 0, 0, '', '', 0, '', 1, NULL, ''),
(14, 'html_block1', NULL, 99, 'left', 'html', 'kickstart', 'active', 1, 1, 0, 1, '', '', 0, '', 1, NULL, 'box--border'),
(15, 'footer1', NULL, 205, 'footer1', 'html', 'kickstart', 'active', 1, 0, 0, 1, '', '', 0, '', 1, NULL, ''),
(16, 'footer2', NULL, 206, 'footer2', 'html', 'kickstart', 'active', 1, 0, 0, 1, '', '', 0, '', 1, NULL, ''),
(17, 'footer3', NULL, 207, 'footer3', 'html', 'kickstart', 'active', 1, 0, 0, 1, '', '', 0, '', 1, NULL, ''),
(18, 'footer4', NULL, 208, 'footer4', 'html', 'kickstart', 'active', 1, 0, 0, 1, '', '', 0, '', 1, NULL, ''),
(19, 'blogroll', '', 1, 'verybottom', 'smarty', 'blog', 'active', 1, 0, 0, 0, '', '', 1, 'module:blog/block.blogroll.tpl', 1, NULL, ''),
(20, 'new_blog_posts', '', 5, 'left', 'smarty', 'blog', 'active', 1, 0, 0, 1, '', '', 1, 'module:blog/block.new-posts.tpl', 1, NULL, ''),
(21, 'blogs_archive', '', 5, 'left', 'smarty', 'blog', 'active', 1, 0, 0, 1, '', '', 1, 'module:blog/block.blogs-archive.tpl', 1, NULL, '');
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]blog_entries`
CREATE TABLE `[[dbprefix]]blog_entries` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`member_id` int(11) unsigned NOT NULL,
`title` tinytext NOT NULL,
`alias` varchar(155) NOT NULL,
`date_added` datetime NOT NULL,
`image` tinytext NOT NULL,
`status` enum('inactive','active') NOT NULL DEFAULT 'inactive',
FULLTEXT KEY `SEARCH` (`title`,`body`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]blog_entries_tags`
CREATE TABLE `[[dbprefix]]blog_entries_tags` (
`blog_id` mediumint(8) unsigned NOT NULL,
`tag_id` mediumint(8) unsigned NOT NULL,
UNIQUE KEY `UNIQUE` (`tag_id`,`blog_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]blog_tags`
CREATE TABLE `[[dbprefix]]blog_tags` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(50) NOT NULL,
`alias` varchar(50) NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `[[dbprefix]]config`
CREATE TABLE `[[dbprefix]]config` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`config_group` varchar(50) NOT NULL,
`name` varchar(64) NOT NULL,
`type` enum('text','textarea','checkbox','radio','select','combo','divider','hidden','password','image','itemscheckbox','tpl','colorpicker') NOT NULL DEFAULT 'text',
`order` smallint(5) unsigned NOT NULL,
`module` varchar(40) NOT NULL,
`private` tinyint(1) unsigned NOT NULL,
`custom` tinyint(1) unsigned NOT NULL DEFAULT '0',
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=187 ;
-- Dumping data for table `[[dbprefix]]config`
INSERT INTO `[[dbprefix]]config` VALUES
(1, '', 'debug_pass', '', NULL, 'hidden', 0, '', 1, 0, NULL),
(2, '', 'tmpl', 'kickstart', NULL, 'hidden', 0, '', 0, 0, NULL),
(3, '', 'backup', 'backup/', NULL, 'hidden', 0, '', 1, 0, NULL),
(4, '', 'version', '4.2.1', NULL, 'hidden', 0, '', 1, 0, NULL),
(5, '', 'cron', '1', NULL, 'hidden', 0, '', 1, 0, NULL),
(6, '', 'admin_tmpl', 'default', NULL, 'hidden', 0, '', 1, 0, NULL),
(7, '', 'default_package', '', NULL, 'hidden', 0, '', 1, 0, NULL),
(8, '', 'home_page', 'index', NULL, 'hidden', 0, '', 1, 0, NULL),
(9, '', 'tmpl_rollback_data', '', NULL, 'hidden', 0, '', 1, 0, NULL),
(10, '', 'tmpl_layout_data', 'a:2:{s:7:"content";a:3:{s:4:"left";a:2:{s:5:"width";i:3;s:5:"fixed";b:1;}s:6:"center";a:2:{s:5:"width";i:6;s:5:"fixed";b:0;}s:5:"right";a:2:{s:5:"width";i:3;s:5:"fixed";b:1;}}s:13:"footer-blocks";a:4:{s:7:"footer1";a:2:{s:5:"width";i:3;s:5:"fixed";b:0;}s:7:"footer2";a:2:{s:5:"width";i:3;s:5:"fixed";b:0;}s:7:"footer3";a:2:{s:5:"width";i:3;s:5:"fixed";b:0;}s:7:"footer4";a:2:{s:5:"width";i:3;s:5:"fixed";b:0;}}}', NULL, 'hidden', 0, '', 1, 0, NULL),
(11, 'general', '', 'General', '1', 'divider', 0, '', 1, 1, ''),
(12, 'general', 'site', '{"en":"Subrion CMS"}', '1', 'text', 2, '', 0, 1, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":1}'),
(13, 'general', 'bc_home', '{"en":"Home"}', NULL, 'text', 3, '', 1, 1, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":1}'),
(14, 'general', 'suffix', '{"en":":: Powered by Subrion 4.2"}', '1', 'text', 9, '', 0, 1, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":1}'),
(15, 'general', 'site_logo', '', '', 'image', 12, '', 0, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(16, 'general', 'site_favicon', '', '', 'image', 13, '', 0, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(17, 'general', '', 'Regional', '1', 'divider', 20, '', 1, 1, ''),
(18, 'general', 'lang', 'en', '1', 'select', 33, '', 0, 1, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(19, 'general', 'language_switch', '1', '''1'',''0''', 'radio', 36, '', 0, 1, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(20, 'general', 'timezone', 'America/New_York', '', 'select', 45, '', 0, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(21, 'members', '', 'General', '1', 'divider', 1, '', 1, 0, ''),
(22, 'members', 'members_enabled', '1', '''1'',''0''', 'radio', 2, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(23, 'members', 'members_autoapproval', '1', '''1'',''0''', 'radio', 3, '', 0, 0, '{"wysiwyg":0,"code_editor":0,"show":"members_enabled|1","multilingual":0}'),
(24, 'members', 'members_per_page', '20', '0', 'text', 4, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"members_enabled|1","multilingual":0}'),
(25, 'members', '', 'HybridAuth', '1', 'divider', 5, '', 1, 0, ''),
(26, 'members', 'hybrid_enabled', '0', '''1'',''0''', 'radio', 6, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(27, 'members', 'hybrid_debug_mode', '0', '''1'',''0''', 'radio', 7, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"hybrid_enabled|1","multilingual":0}'),
(28, 'members', '', 'Gravatar', '1', 'divider', 10, '', 1, 0, ''),
(29, 'members', 'gravatar_enabled', '1', '''1'',''0''', 'radio', 11, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(30, 'members', 'gravatar_size', '100', '1', 'text', 12, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"gravatar_enabled|1","multilingual":0}'),
(31, 'members', 'gravatar_type', 'mm', '''mm'',''identicon'',''monsterid'',''wavatar'',''retro''', 'select', 13, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"gravatar_enabled|1","multilingual":0}'),
(32, 'members', 'gravatar_rating', 'g', '''g'',''pg'',''r'',''x''', 'select', 14, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"gravatar_enabled|1","multilingual":0}'),
(33, 'members', 'gravatar_default_image', '', '', 'image', 16, '', 0, 0, '{"wysiwyg":0,"code_editor":0,"show":"gravatar_enabled|1","multilingual":0}'),
(34, 'mail', '', 'General', '1', 'divider', 1, '', 1, 0, ''),
(35, 'mail', 'site_from_name', '{"en":"Subrion CMS"}', '1', 'text', 5, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":1}'),
(36, 'mail', 'site_email', '[[admin_email]]', '1', 'text', 8, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(37, 'mail', 'bcc_email', '', '1', 'text', 10, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(38, 'mail', 'default_email_signature', '{"en":"<p>______________________________</p>\\r\\n<p>Thank you,<br>\\r\\n{%SITE_NAME%} Team<br>\\r\\n{%SITE_URL%}</p>","ru":"<p>______________________________</p>\\r\\n<p>Thank you,<br>\\r\\n{%SITE_NAME%} Team<br>\\r\\n{%SITE_URL%}</p>","kg":"<p>______________________________</p>\\r\\n<p>Thank you,<br>\\r\\n{%SITE_NAME%} Team<br>\\r\\n{%SITE_URL%}</p>"}', '1', 'textarea', 15, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":1}'),
(39, 'mail', 'mail_function', 'php mail', '''php mail'',''sendmail'',''smtp''', 'select', 18, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(40, 'mail', 'mail_test', '', 'admin/templates/default/configuration-test-email-btn.tpl', 'tpl', 21, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(41, 'mail', '', 'SMTP Settings', '', 'divider', 24, '', 9, 0, '{"wysiwyg":0,"code_editor":0,"show":"mail_function|smtp","multilingual":0}'),
(42, 'mail', 'smtp_debug', '0', '''1'',''0''', 'radio', 25, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"mail_function|smtp","multilingual":0}'),
(43, 'mail', 'smtp_debug_output', 'echo', '''echo'',''html'',''error_log''', 'select', 26, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"smtp_debug|1","multilingual":0}'),
(44, 'mail', 'smtp_auth', '1', '''1'',''0''', 'radio', 27, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"mail_function|smtp","multilingual":0}'),
(45, 'mail', 'smtp_server', 'smtp.example.org', '', 'text', 30, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"mail_function|smtp","multilingual":0}'),
(46, 'mail', 'smtp_port', '', '', 'text', 33, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"mail_function|smtp","multilingual":0}'),
(47, 'mail', 'smtp_secure', 'TLS', '''TLS'',''SSL''', 'select', 36, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"mail_function|smtp","multilingual":0}'),
(48, 'mail', 'smtp_user', '', '', 'text', 39, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"mail_function|smtp","multilingual":0}'),
(49, 'mail', 'smtp_password', '', '', 'password', 42, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"mail_function|smtp","multilingual":0}'),
(50, 'mail', '', 'Sendmail Settings', '', 'divider', 45, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"mail_function|sendmail","multilingual":0}'),
(51, 'mail', 'sendmail_path', '/usr/sbin/sendmail', '', 'text', 48, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"mail_function|sendmail","multilingual":0}'),
(52, 'mail', 'mimetype', '1', '''1'',''0''', 'radio', 51, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(53, 'system', '', 'Setup', '1', 'divider', 0, '', 1, 0, ''),
(54, 'system', 'baseurl', '[[softurl]]/', NULL, 'text', 0, '', 0, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(55, 'system', 'admin_page', 'panel', NULL, 'text', 0, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(56, 'system', 'https', '0', '''1'',''0''', 'radio', 1, '', 1, 1, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(57, 'system', 'frontend', '1', '''1'',''0''', 'radio', 2, '', 1, 1, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(58, 'system', 'underconstruction', 'We are sorry. Our site is under construction.', '', 'textarea', 3, '', 1, 1, '{"wysiwyg":1,"code_editor":0,"show":"frontend|0","multilingual":0}'),
(59, 'system', '', 'Admin Panel settings', '1', 'divider', 10, '', 1, 0, ''),
(60, 'system', 'display_feedbacks', '1', '''1'',''0''', 'radio', 11, '', 0, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(61, 'system', 'display_changelog', '1', '''1'',''0''', 'radio', 12, '', 0, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(62, 'system', 'display_twitter', '1', '''1'',''0''', 'hidden', 13, '', 0, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(63, 'system', 'check_for_updates', '1', '''1'',''0''', 'radio', 14, '', 0, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),
(64, 'system', 'auto_apply_critical_upgrades', '0', '''1'',''0''', 'radio', 15, '', 1, 0, '{"wysiwyg":0,"code_editor":0,"show":"check_for_updates|1","multilingual":0}'),
(65, 'system', 'allow_remote_templates', '1', '''1'',''0''', 'radio', 16, '', 0, 0, '{"wysiwyg":0,"code_editor":0,"show":"","multilingual":0}'),