관리-도구

편집 파일: typo8.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: `typo1342` -- -- -------------------------------------------------------- -- -- Table structure for table `backend_layout` -- CREATE TABLE `backend_layout` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `crdate` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `hidden` smallint unsigned NOT NULL DEFAULT '0', `sorting` int NOT NULL DEFAULT '0', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `t3ver_oid` int unsigned NOT NULL DEFAULT '0', `t3ver_wsid` int unsigned NOT NULL DEFAULT '0', `t3ver_state` smallint NOT NULL DEFAULT '0', `t3ver_stage` int NOT NULL DEFAULT '0', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `config` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `icon` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`uid`), KEY `parent` (`pid`,`deleted`,`hidden`), KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `be_dashboards` -- CREATE TABLE `be_dashboards` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `crdate` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `hidden` smallint unsigned NOT NULL DEFAULT '0', `starttime` int unsigned NOT NULL DEFAULT '0', `endtime` int unsigned NOT NULL DEFAULT '0', `cruser_id` int unsigned NOT NULL DEFAULT '0', `widgets` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `identifier` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`uid`), KEY `identifier` (`identifier`), KEY `parent` (`pid`,`deleted`,`hidden`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `be_groups` -- CREATE TABLE `be_groups` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `crdate` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `hidden` smallint unsigned NOT NULL DEFAULT '0', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `tables_select` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `db_mountpoints` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `file_mountpoints` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '', `file_permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `workspace_perms` smallint unsigned NOT NULL DEFAULT '0', `pagetypes_select` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `tables_modify` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `non_exclude_fields` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `explicit_allowdeny` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `allowed_languages` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `custom_options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `groupMods` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `mfa_providers` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `TSconfig` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `subgroup` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '', `category_perms` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `availableWidgets` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), PRIMARY KEY (`uid`), KEY `parent` (`pid`,`deleted`,`hidden`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `be_sessions` -- CREATE TABLE `be_sessions` ( `ses_id` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `ses_iplock` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `ses_userid` int unsigned NOT NULL DEFAULT '0', `ses_tstamp` int unsigned NOT NULL DEFAULT '0', `ses_data` longblob DEFAULT (NULL), PRIMARY KEY (`ses_id`), KEY `ses_tstamp` (`ses_tstamp`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `be_users` -- CREATE TABLE `be_users` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `crdate` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `disable` smallint unsigned NOT NULL DEFAULT '0', `starttime` int unsigned NOT NULL DEFAULT '0', `endtime` int unsigned NOT NULL DEFAULT '0', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `lang` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default', `uc` mediumblob DEFAULT (NULL), `workspace_id` int NOT NULL DEFAULT '0', `mfa` mediumblob DEFAULT (NULL), `password_reset_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `usergroup` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '', `avatar` int unsigned NOT NULL DEFAULT '0', `db_mountpoints` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `file_mountpoints` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '', `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `realName` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `admin` smallint unsigned NOT NULL DEFAULT '0', `options` smallint unsigned NOT NULL DEFAULT '3', `file_permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `workspace_perms` smallint unsigned NOT NULL DEFAULT '1', `userMods` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `allowed_languages` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `TSconfig` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `lastlogin` bigint NOT NULL DEFAULT '0', `category_perms` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), PRIMARY KEY (`uid`), KEY `username` (`username`), KEY `parent` (`pid`,`deleted`,`disable`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Dumping data for table `be_users` -- INSERT INTO `be_users` VALUES (1, 0, [[timestamp]], [[timestamp]], 0, 0, 0, 0, NULL, 'default', NULL, 0, NULL, '', '[[admin_username]]', '[[admin_pass]]', '', 0, NULL, '', '[[admin_email]]', '', 1, 3, NULL, 1, NULL, '', NULL, 0, NULL); -- -------------------------------------------------------- -- -- Table structure for table `cache_hash` -- CREATE TABLE `cache_hash` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `expires` int unsigned NOT NULL DEFAULT '0', `content` longblob DEFAULT (NULL), PRIMARY KEY (`id`), KEY `cache_id` (`identifier`(180),`expires`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `cache_hash_tags` -- CREATE TABLE `cache_hash_tags` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `tag` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `cache_id` (`identifier`(191)), KEY `cache_tag` (`tag`(191)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `cache_pages` -- CREATE TABLE `cache_pages` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `expires` int unsigned NOT NULL DEFAULT '0', `content` longblob DEFAULT (NULL), PRIMARY KEY (`id`), KEY `cache_id` (`identifier`(180),`expires`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `cache_pages_tags` -- CREATE TABLE `cache_pages_tags` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `tag` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `cache_id` (`identifier`(191)), KEY `cache_tag` (`tag`(191)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `cache_rootline` -- CREATE TABLE `cache_rootline` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `expires` int unsigned NOT NULL DEFAULT '0', `content` longblob DEFAULT (NULL), PRIMARY KEY (`id`), KEY `cache_id` (`identifier`(180),`expires`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `cache_rootline_tags` -- CREATE TABLE `cache_rootline_tags` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `tag` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `cache_id` (`identifier`(191)), KEY `cache_tag` (`tag`(191)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `fe_groups` -- CREATE TABLE `fe_groups` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `crdate` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `hidden` smallint unsigned NOT NULL DEFAULT '0', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `subgroup` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '', `felogin_redirectPid` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), PRIMARY KEY (`uid`), KEY `parent` (`pid`,`deleted`,`hidden`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `fe_sessions` -- CREATE TABLE `fe_sessions` ( `ses_id` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `ses_iplock` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `ses_userid` int unsigned NOT NULL DEFAULT '0', `ses_tstamp` int unsigned NOT NULL DEFAULT '0', `ses_data` mediumblob DEFAULT (NULL), `ses_permanent` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ses_id`), KEY `ses_tstamp` (`ses_tstamp`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `fe_users` -- CREATE TABLE `fe_users` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `crdate` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `disable` smallint unsigned NOT NULL DEFAULT '0', `starttime` int unsigned NOT NULL DEFAULT '0', `endtime` int unsigned NOT NULL DEFAULT '0', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `tx_extbase_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `uc` blob DEFAULT (NULL), `is_online` int unsigned NOT NULL DEFAULT '0', `mfa` mediumblob DEFAULT (NULL), `felogin_forgotHash` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '', `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `usergroup` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '', `name` varchar(160) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `first_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `middle_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `last_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `address` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `telephone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `fax` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `title` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `zip` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `city` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `country` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `www` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `company` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `image` int unsigned NOT NULL DEFAULT '0', `lastlogin` bigint NOT NULL DEFAULT '0', `felogin_redirectPid` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), PRIMARY KEY (`uid`), KEY `parent` (`pid`,`username`(100)), KEY `username` (`username`(100)), KEY `is_online` (`is_online`), KEY `felogin_forgotHash` (`felogin_forgotHash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `pages` -- CREATE TABLE `pages` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `crdate` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `hidden` smallint unsigned NOT NULL DEFAULT '0', `starttime` int unsigned NOT NULL DEFAULT '0', `endtime` int unsigned NOT NULL DEFAULT '0', `fe_group` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `sorting` int NOT NULL DEFAULT '0', `rowDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `editlock` smallint unsigned NOT NULL DEFAULT '0', `sys_language_uid` int NOT NULL DEFAULT '0', `l10n_parent` int unsigned NOT NULL DEFAULT '0', `l10n_source` int unsigned NOT NULL DEFAULT '0', `l10n_state` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `l10n_diffsource` mediumblob DEFAULT (NULL), `t3ver_oid` int unsigned NOT NULL DEFAULT '0', `t3ver_wsid` int unsigned NOT NULL DEFAULT '0', `t3ver_state` smallint NOT NULL DEFAULT '0', `t3ver_stage` int NOT NULL DEFAULT '0', `perms_userid` int unsigned NOT NULL DEFAULT '0', `perms_groupid` int unsigned NOT NULL DEFAULT '0', `perms_user` smallint unsigned NOT NULL DEFAULT '0', `perms_group` smallint unsigned NOT NULL DEFAULT '0', `perms_everybody` smallint unsigned NOT NULL DEFAULT '0', `SYS_LASTCHANGED` int unsigned NOT NULL DEFAULT '0', `shortcut` int unsigned NOT NULL DEFAULT '0', `content_from_pid` int unsigned NOT NULL DEFAULT '0', `mount_pid` int unsigned NOT NULL DEFAULT '0', `tx_impexp_origuid` int NOT NULL DEFAULT '0', `sitemap_priority` decimal(2,1) NOT NULL DEFAULT '0.5', `doktype` int unsigned NOT NULL DEFAULT '0', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `slug` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `TSconfig` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `php_tree_stop` smallint unsigned NOT NULL DEFAULT '0', `categories` int unsigned NOT NULL DEFAULT '0', `layout` int unsigned NOT NULL DEFAULT '0', `extendToSubpages` smallint unsigned NOT NULL DEFAULT '0', `nav_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `nav_hide` smallint unsigned NOT NULL DEFAULT '0', `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `target` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `lastUpdated` bigint NOT NULL DEFAULT '0', `newUntil` bigint NOT NULL DEFAULT '0', `cache_timeout` int unsigned NOT NULL DEFAULT '0', `cache_tags` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `no_search` smallint unsigned NOT NULL DEFAULT '0', `shortcut_mode` int unsigned NOT NULL DEFAULT '0', `keywords` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `abstract` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `author_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `media` int unsigned NOT NULL DEFAULT '0', `is_siteroot` smallint unsigned NOT NULL DEFAULT '0', `mount_pid_ol` smallint NOT NULL DEFAULT '0', `module` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `l18n_cfg` smallint unsigned NOT NULL DEFAULT '0', `backend_layout` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `backend_layout_next_level` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `tsconfig_includes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '', `seo_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `no_index` smallint unsigned NOT NULL DEFAULT '0', `no_follow` smallint unsigned NOT NULL DEFAULT '0', `sitemap_changefreq` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `canonical_link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT (_utf8mb4''), `og_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `og_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `og_image` int unsigned NOT NULL DEFAULT '0', `twitter_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `twitter_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `twitter_image` int unsigned NOT NULL DEFAULT '0', `twitter_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`uid`), KEY `determineSiteRoot` (`is_siteroot`), KEY `language_identifier` (`l10n_parent`,`sys_language_uid`), KEY `slug` (`slug`(127)), KEY `parent` (`pid`,`deleted`,`hidden`), KEY `translation_source` (`l10n_source`), KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_be_shortcuts` -- CREATE TABLE `sys_be_shortcuts` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `userid` int unsigned NOT NULL DEFAULT '0', `route` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `arguments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `sorting` int NOT NULL DEFAULT '0', `sc_group` smallint NOT NULL DEFAULT '0', PRIMARY KEY (`uid`), KEY `event` (`userid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_category` -- CREATE TABLE `sys_category` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `crdate` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `hidden` smallint unsigned NOT NULL DEFAULT '0', `starttime` int unsigned NOT NULL DEFAULT '0', `endtime` int unsigned NOT NULL DEFAULT '0', `sorting` int NOT NULL DEFAULT '0', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `sys_language_uid` int NOT NULL DEFAULT '0', `l10n_parent` int unsigned NOT NULL DEFAULT '0', `l10n_state` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `l10n_diffsource` mediumblob DEFAULT (NULL), `t3ver_oid` int unsigned NOT NULL DEFAULT '0', `t3ver_wsid` int unsigned NOT NULL DEFAULT '0', `t3ver_state` smallint NOT NULL DEFAULT '0', `t3ver_stage` int NOT NULL DEFAULT '0', `items` int NOT NULL DEFAULT '0', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `parent` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`uid`), KEY `category_parent` (`parent`), KEY `category_list` (`pid`,`deleted`,`sys_language_uid`), KEY `parent` (`pid`,`deleted`,`hidden`), KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_category_record_mm` -- CREATE TABLE `sys_category_record_mm` ( `uid_local` int unsigned NOT NULL DEFAULT '0', `uid_foreign` int unsigned NOT NULL DEFAULT '0', `sorting` int unsigned NOT NULL DEFAULT '0', `sorting_foreign` int unsigned NOT NULL DEFAULT '0', `tablenames` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `fieldname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`uid_local`,`uid_foreign`,`tablenames`,`fieldname`), KEY `uid_local` (`uid_local`), KEY `uid_foreign` (`uid_foreign`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_csp_resolution` -- CREATE TABLE `sys_csp_resolution` ( `summary` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created` int unsigned NOT NULL, `scope` varchar(264) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `mutation_identifier` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `mutation_collection` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `meta` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), PRIMARY KEY (`summary`), KEY `created` (`created`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_file` -- CREATE TABLE `sys_file` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `last_indexed` int NOT NULL DEFAULT '0', `identifier` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `identifier_hash` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `folder_hash` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `name` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `sha1` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `creation_date` int NOT NULL DEFAULT '0', `modification_date` int NOT NULL DEFAULT '0', `storage` int unsigned NOT NULL DEFAULT '0', `type` int unsigned NOT NULL DEFAULT '0', `mime_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `size` int NOT NULL DEFAULT '0', `missing` smallint unsigned NOT NULL DEFAULT '0', `metadata` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`uid`), KEY `sel01` (`storage`,`identifier_hash`), KEY `folder` (`storage`,`folder_hash`), KEY `tstamp` (`tstamp`), KEY `lastindex` (`last_indexed`), KEY `sha1` (`sha1`), KEY `parent` (`pid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_filemounts` -- CREATE TABLE `sys_filemounts` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `hidden` smallint unsigned NOT NULL DEFAULT '0', `sorting` int NOT NULL DEFAULT '0', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `identifier` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `read_only` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`uid`), KEY `parent` (`pid`,`deleted`,`hidden`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_file_collection` -- CREATE TABLE `sys_file_collection` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `crdate` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `hidden` smallint unsigned NOT NULL DEFAULT '0', `starttime` int unsigned NOT NULL DEFAULT '0', `endtime` int unsigned NOT NULL DEFAULT '0', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `sys_language_uid` int NOT NULL DEFAULT '0', `l10n_parent` int unsigned NOT NULL DEFAULT '0', `l10n_state` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `l10n_diffsource` mediumblob DEFAULT (NULL), `t3ver_oid` int unsigned NOT NULL DEFAULT '0', `t3ver_wsid` int unsigned NOT NULL DEFAULT '0', `t3ver_state` smallint NOT NULL DEFAULT '0', `t3ver_stage` int NOT NULL DEFAULT '0', `title` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'static', `files` int unsigned NOT NULL DEFAULT '0', `folder_identifier` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `recursive` smallint unsigned NOT NULL DEFAULT '0', `category` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`uid`), KEY `parent` (`pid`,`deleted`,`hidden`), KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_file_metadata` -- CREATE TABLE `sys_file_metadata` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `crdate` int unsigned NOT NULL DEFAULT '0', `sys_language_uid` int NOT NULL DEFAULT '0', `l10n_parent` int unsigned NOT NULL DEFAULT '0', `l10n_state` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `l10n_diffsource` mediumblob DEFAULT (NULL), `t3ver_oid` int unsigned NOT NULL DEFAULT '0', `t3ver_wsid` int unsigned NOT NULL DEFAULT '0', `t3ver_state` smallint NOT NULL DEFAULT '0', `t3ver_stage` int NOT NULL DEFAULT '0', `title` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `alternative` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `categories` int unsigned NOT NULL DEFAULT '0', `file` int unsigned NOT NULL DEFAULT '0', `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `width` int NOT NULL DEFAULT '0', `height` int NOT NULL DEFAULT '0', PRIMARY KEY (`uid`), KEY `file` (`file`), KEY `fal_filelist` (`l10n_parent`,`sys_language_uid`), KEY `parent` (`pid`), KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_file_processedfile` -- CREATE TABLE `sys_file_processedfile` ( `uid` int NOT NULL AUTO_INCREMENT, `tstamp` int NOT NULL DEFAULT '0', `crdate` int NOT NULL DEFAULT '0', `storage` int NOT NULL DEFAULT '0', `original` int NOT NULL DEFAULT '0', `identifier` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `name` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `processing_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `configuration` blob DEFAULT (NULL), `configurationsha1` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `originalfilesha1` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `task_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `checksum` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `width` int DEFAULT '0', `height` int DEFAULT '0', PRIMARY KEY (`uid`), KEY `combined_1` (`original`,`task_type`(100),`configurationsha1`), KEY `identifier` (`storage`,`identifier`(180)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_file_reference` -- CREATE TABLE `sys_file_reference` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `crdate` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `hidden` smallint unsigned NOT NULL DEFAULT '0', `sys_language_uid` int NOT NULL DEFAULT '0', `l10n_parent` int unsigned NOT NULL DEFAULT '0', `l10n_state` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `l10n_diffsource` mediumblob DEFAULT (NULL), `t3ver_oid` int unsigned NOT NULL DEFAULT '0', `t3ver_wsid` int unsigned NOT NULL DEFAULT '0', `t3ver_state` smallint NOT NULL DEFAULT '0', `t3ver_stage` int NOT NULL DEFAULT '0', `uid_local` int NOT NULL DEFAULT '0', `title` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `alternative` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `uid_foreign` int NOT NULL DEFAULT '0', `tablenames` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `fieldname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `sorting_foreign` int NOT NULL DEFAULT '0', `link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT (_utf8mb4''), `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `crop` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `autoplay` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`uid`), KEY `tablenames_fieldname` (`tablenames`(32),`fieldname`(12)), KEY `deleted` (`deleted`), KEY `uid_local` (`uid_local`), KEY `uid_foreign` (`uid_foreign`), KEY `combined_1` (`l10n_parent`,`t3ver_oid`,`t3ver_wsid`,`t3ver_state`,`deleted`), KEY `parent` (`pid`,`deleted`,`hidden`), KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_file_storage` -- CREATE TABLE `sys_file_storage` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `crdate` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `is_public` smallint NOT NULL DEFAULT '0', `processingfolder` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `is_browsable` smallint unsigned NOT NULL DEFAULT '1', `is_default` smallint unsigned NOT NULL DEFAULT '0', `is_writable` smallint unsigned NOT NULL DEFAULT '1', `is_online` smallint unsigned NOT NULL DEFAULT '1', `auto_extract_metadata` smallint unsigned NOT NULL DEFAULT '1', `driver` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `configuration` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), PRIMARY KEY (`uid`), KEY `parent` (`pid`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_history` -- CREATE TABLE `sys_history` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `tstamp` int unsigned NOT NULL DEFAULT '0', `actiontype` smallint NOT NULL DEFAULT '0', `usertype` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'BE', `userid` int unsigned DEFAULT NULL, `originaluserid` int unsigned DEFAULT NULL, `recuid` int NOT NULL DEFAULT '0', `tablename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `history_data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `workspace` int DEFAULT '0', `correlation_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`uid`), KEY `recordident_1` (`tablename`(100),`recuid`), KEY `recordident_2` (`tablename`(100),`tstamp`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_http_report` -- CREATE TABLE `sys_http_report` ( `uuid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` smallint unsigned NOT NULL DEFAULT '0', `created` int unsigned NOT NULL, `changed` int unsigned NOT NULL, `type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `scope` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `request_time` bigint unsigned NOT NULL, `meta` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `details` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `summary` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`uuid`), KEY `type_scope` (`type`,`scope`), KEY `created` (`created`), KEY `changed` (`changed`), KEY `request_time` (`request_time`), KEY `summary_created` (`summary`,`created`), KEY `all_conditions` (`type`,`status`,`scope`,`summary`,`request_time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_lockedrecords` -- CREATE TABLE `sys_lockedrecords` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `userid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `record_table` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `record_uid` int NOT NULL DEFAULT '0', `record_pid` int NOT NULL DEFAULT '0', `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `feuserid` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`uid`), KEY `event` (`userid`,`tstamp`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_log` -- CREATE TABLE `sys_log` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `tstamp` int unsigned NOT NULL DEFAULT '0', `userid` int unsigned NOT NULL DEFAULT '0', `action` smallint unsigned NOT NULL DEFAULT '0', `recuid` int unsigned NOT NULL DEFAULT '0', `tablename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `recpid` int NOT NULL DEFAULT '0', `error` smallint unsigned NOT NULL DEFAULT '0', `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `type` smallint unsigned NOT NULL DEFAULT '0', `channel` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default', `details_nr` smallint NOT NULL DEFAULT '0', `IP` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `log_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `event_pid` int NOT NULL DEFAULT '-1', `workspace` int NOT NULL DEFAULT '0', `NEWid` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `request_id` varchar(13) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `time_micro` double NOT NULL DEFAULT '0', `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `level` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'info', `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), PRIMARY KEY (`uid`), KEY `event` (`userid`,`event_pid`), KEY `recuidIdx` (`recuid`), KEY `user_auth` (`type`,`action`,`tstamp`), KEY `request` (`request_id`), KEY `combined_1` (`tstamp`,`type`,`userid`), KEY `errorcount` (`tstamp`,`error`), KEY `index_channel` (`channel`), KEY `index_level` (`level`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_messenger_messages` -- CREATE TABLE `sys_messenger_messages` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `headers` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `queue_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime NOT NULL, `available_at` datetime NOT NULL, `delivered_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `queue_name` (`queue_name`), KEY `available_at` (`available_at`), KEY `delivered_at` (`delivered_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_news` -- CREATE TABLE `sys_news` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `crdate` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `hidden` smallint unsigned NOT NULL DEFAULT '0', `starttime` int unsigned NOT NULL DEFAULT '0', `endtime` int unsigned NOT NULL DEFAULT '0', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), PRIMARY KEY (`uid`), KEY `parent` (`pid`,`deleted`,`hidden`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `sys_note` -- CREATE TABLE `sys_note` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `crdate` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `sorting` int NOT NULL DEFAULT '0', `cruser` int unsigned NOT NULL DEFAULT '0', `category` int unsigned NOT NULL DEFAULT '0', `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `personal` smallint unsigned NOT NULL DEFAULT '0', `position` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`uid`), KEY `parent` (`pid`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_reaction` -- CREATE TABLE `sys_reaction` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `updatedon` int unsigned NOT NULL DEFAULT '0', `createdon` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `disabled` smallint unsigned NOT NULL DEFAULT '0', `starttime` int unsigned NOT NULL DEFAULT '0', `endtime` int unsigned NOT NULL DEFAULT '0', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `impersonate_user` int unsigned NOT NULL DEFAULT '0', `storage_pid` int unsigned NOT NULL DEFAULT '0', `reaction_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `identifier` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `secret` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `table_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `fields` json DEFAULT (NULL), PRIMARY KEY (`uid`), UNIQUE KEY `identifier_key` (`identifier`), KEY `index_source` (`reaction_type`(5)), KEY `parent` (`pid`,`deleted`,`disabled`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_refindex` -- CREATE TABLE `sys_refindex` ( `hash` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `tablename` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `recuid` int unsigned NOT NULL DEFAULT '0', `field` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `hidden` smallint unsigned NOT NULL DEFAULT '0', `starttime` int unsigned NOT NULL DEFAULT '0', `endtime` int unsigned NOT NULL DEFAULT '2147483647', `t3ver_state` int unsigned NOT NULL DEFAULT '0', `flexpointer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `softref_key` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `softref_id` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `sorting` int NOT NULL DEFAULT '0', `workspace` int unsigned NOT NULL DEFAULT '0', `ref_table` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `ref_uid` int NOT NULL DEFAULT '0', `ref_field` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `ref_hidden` smallint unsigned NOT NULL DEFAULT '0', `ref_starttime` int unsigned NOT NULL DEFAULT '0', `ref_endtime` int unsigned NOT NULL DEFAULT '2147483647', `ref_t3ver_state` int unsigned NOT NULL DEFAULT '0', `ref_sorting` int NOT NULL DEFAULT '0', `ref_string` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`hash`), KEY `lookup_rec` (`tablename`,`recuid`,`field`,`workspace`,`ref_t3ver_state`,`ref_hidden`,`ref_starttime`,`ref_endtime`), KEY `lookup_ref` (`ref_table`,`ref_uid`,`tablename`,`workspace`,`t3ver_state`,`hidden`,`starttime`,`endtime`), KEY `lookup_string` (`ref_string`(191)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_registry` -- CREATE TABLE `sys_registry` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `entry_namespace` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `entry_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `entry_value` mediumblob DEFAULT (NULL), PRIMARY KEY (`uid`), UNIQUE KEY `entry_identifier` (`entry_namespace`,`entry_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -- Dumping data for table `sys_registry` -- INSERT INTO `sys_registry` VALUES (1, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\BackendGroupsExplicitAllowDenyMigration', 'i:1;'), (2, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\BackendModulePermissionMigration', 'i:1;'), (3, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\IndexedSearchCTypeMigration', 'i:1;'), (4, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\MigrateSiteSettingsConfigUpdate', 'i:1;'), (5, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\PagesRecyclerDoktypeMigration', 'i:1;'), (6, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\SynchronizeColPosAndCTypeWithDefaultLanguage', 'i:1;'), (7, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\SysFileCollectionIdentifierMigration', 'i:1;'), (8, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\SysFileMountIdentifierMigration', 'i:1;'), (9, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\SysLogSerializationUpdate', 'i:1;'), (10, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\SysTemplateNoWorkspaceMigration', 'i:1;'), (11, 'installUpdate', 'TYPO3\\CMS\\Extensionmanager\\Updates\\FeLoginModeExtractionUpdate', 'i:1;'), (12, 'installUpdateRows', 'rowUpdatersDone', 'a:1:{i:0;s:69:"TYPO3\\CMS\\Install\\Updates\\RowUpdater\\SysRedirectRootPageMoveMigration";}'); -- -------------------------------------------------------- -- -- Table structure for table `sys_template` -- CREATE TABLE `sys_template` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `crdate` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `hidden` smallint unsigned NOT NULL DEFAULT '0', `starttime` int unsigned NOT NULL DEFAULT '0', `endtime` int unsigned NOT NULL DEFAULT '0', `sorting` int NOT NULL DEFAULT '0', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `tx_impexp_origuid` int NOT NULL DEFAULT '0', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `root` smallint unsigned NOT NULL DEFAULT '0', `clear` smallint unsigned NOT NULL DEFAULT '0', `constants` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `include_static_file` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `basedOn` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `includeStaticAfterBasedOn` smallint unsigned NOT NULL DEFAULT '0', `config` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `static_file_mode` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`uid`), KEY `roottemplate` (`deleted`,`hidden`,`root`), KEY `parent` (`pid`,`deleted`,`hidden`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `sys_webhook` -- CREATE TABLE `sys_webhook` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `updatedon` int unsigned NOT NULL DEFAULT '0', `createdon` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `disabled` smallint unsigned NOT NULL DEFAULT '0', `starttime` int unsigned NOT NULL DEFAULT '0', `endtime` int unsigned NOT NULL DEFAULT '0', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `webhook_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `identifier` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `secret` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT (_utf8mb4''), `method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `verify_ssl` smallint unsigned NOT NULL DEFAULT '1', `additional_headers` json DEFAULT (NULL), PRIMARY KEY (`uid`), UNIQUE KEY `identifier_key` (`identifier`), KEY `index_source` (`webhook_type`(5)), KEY `parent` (`pid`,`deleted`,`disabled`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `tt_content` -- CREATE TABLE `tt_content` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `crdate` int unsigned NOT NULL DEFAULT '0', `deleted` smallint unsigned NOT NULL DEFAULT '0', `hidden` smallint unsigned NOT NULL DEFAULT '0', `starttime` int unsigned NOT NULL DEFAULT '0', `endtime` int unsigned NOT NULL DEFAULT '0', `fe_group` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `sorting` int NOT NULL DEFAULT '0', `rowDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `editlock` smallint unsigned NOT NULL DEFAULT '0', `sys_language_uid` int NOT NULL DEFAULT '0', `l18n_parent` int unsigned NOT NULL DEFAULT '0', `l10n_source` int unsigned NOT NULL DEFAULT '0', `l10n_state` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `l18n_diffsource` mediumblob DEFAULT (NULL), `t3ver_oid` int unsigned NOT NULL DEFAULT '0', `t3ver_wsid` int unsigned NOT NULL DEFAULT '0', `t3ver_state` smallint NOT NULL DEFAULT '0', `t3ver_stage` int NOT NULL DEFAULT '0', `frame_class` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default', `colPos` int unsigned NOT NULL DEFAULT '0', `table_caption` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `tx_impexp_origuid` int NOT NULL DEFAULT '0', `CType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `categories` int unsigned NOT NULL DEFAULT '0', `layout` int unsigned NOT NULL DEFAULT '0', `space_before_class` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `space_after_class` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `date` bigint NOT NULL DEFAULT '0', `header` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `header_layout` int unsigned NOT NULL DEFAULT '0', `header_position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `header_link` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT (_utf8mb4''), `subheader` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `bodytext` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `image` int unsigned NOT NULL DEFAULT '0', `assets` int unsigned NOT NULL DEFAULT '0', `imagewidth` int unsigned NOT NULL DEFAULT '0', `imageheight` int unsigned NOT NULL DEFAULT '0', `imageorient` int unsigned NOT NULL DEFAULT '0', `imageborder` smallint unsigned NOT NULL DEFAULT '0', `image_zoom` smallint unsigned NOT NULL DEFAULT '0', `imagecols` int unsigned NOT NULL DEFAULT '0', `pages` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `recursive` int unsigned NOT NULL DEFAULT '0', `list_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `media` int unsigned NOT NULL DEFAULT '0', `records` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `sectionIndex` smallint unsigned NOT NULL DEFAULT '1', `linkToTop` smallint unsigned NOT NULL DEFAULT '0', `pi_flexform` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `selected_categories` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `category_field` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `bullets_type` int unsigned NOT NULL DEFAULT '0', `cols` int unsigned NOT NULL DEFAULT '0', `table_class` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `table_delimiter` int unsigned NOT NULL DEFAULT '0', `table_enclosure` int unsigned NOT NULL DEFAULT '0', `table_header_position` int unsigned NOT NULL DEFAULT '0', `table_tfoot` smallint unsigned NOT NULL DEFAULT '0', `file_collections` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `filelink_size` smallint unsigned NOT NULL DEFAULT '0', `filelink_sorting` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `filelink_sorting_direction` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `target` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `uploads_description` smallint unsigned NOT NULL DEFAULT '0', `uploads_type` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`uid`), KEY `parent` (`pid`,`sorting`), KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`), KEY `language` (`l18n_parent`,`sys_language_uid`), KEY `translation_source` (`l10n_source`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `tx_extensionmanager_domain_model_extension` -- CREATE TABLE `tx_extensionmanager_domain_model_extension` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `extension_key` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `remote` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ter', `version` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `alldownloadcounter` int unsigned NOT NULL DEFAULT '0', `downloadcounter` int unsigned NOT NULL DEFAULT '0', `title` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `serialized_dependencies` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `author_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `author_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `ownerusername` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `md5hash` varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `authorcompany` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `integer_version` int NOT NULL DEFAULT '0', `lastreviewedversion` int NOT NULL DEFAULT '0', `documentation_link` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `distribution_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `distribution_welcome_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `state` int unsigned NOT NULL DEFAULT '0', `category` int unsigned NOT NULL DEFAULT '0', `last_updated` bigint NOT NULL DEFAULT '0', `update_comment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT (NULL), `current_version` smallint unsigned NOT NULL DEFAULT '0', `review_state` int NOT NULL DEFAULT '0', PRIMARY KEY (`uid`), UNIQUE KEY `versionextrepo` (`extension_key`,`version`,`remote`), KEY `index_extrepo` (`extension_key`,`remote`), KEY `index_versionrepo` (`integer_version`,`remote`,`extension_key`), KEY `index_currentversions` (`current_version`,`review_state`), KEY `parent` (`pid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `tx_impexp_presets` -- CREATE TABLE `tx_impexp_presets` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `tstamp` int unsigned NOT NULL DEFAULT '0', `crdate` int unsigned NOT NULL DEFAULT '0', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `public` smallint NOT NULL DEFAULT '0', `item_uid` int NOT NULL DEFAULT '0', `user_uid` int unsigned NOT NULL DEFAULT '0', `preset_data` blob DEFAULT (NULL), PRIMARY KEY (`uid`), KEY `lookup` (`item_uid`), KEY `parent` (`pid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; /*!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 */;