D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
proc
/
self
/
root
/
proc
/
self
/
root
/
var
/
softaculous
/
typo7
/
Filename :
typo7.sql
back
Copy
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: `typo12424` -- -- -------------------------------------------------------- -- -- 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 COLLATE utf8mb4_unicode_ci, `t3_origuid` int unsigned NOT NULL DEFAULT '0', `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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `config` text COLLATE utf8mb4_unicode_ci NOT NULL, `icon` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`uid`), KEY `parent` (`pid`,`deleted`,`hidden`), KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- 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', `identifier` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `cruser_id` int unsigned NOT NULL DEFAULT '0', `title` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `widgets` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`uid`), KEY `identifier` (`identifier`), KEY `parent` (`pid`,`deleted`,`hidden`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- 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 COLLATE utf8mb4_unicode_ci, `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `non_exclude_fields` text COLLATE utf8mb4_unicode_ci, `explicit_allowdeny` text COLLATE utf8mb4_unicode_ci, `allowed_languages` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `custom_options` text COLLATE utf8mb4_unicode_ci, `db_mountpoints` text COLLATE utf8mb4_unicode_ci, `pagetypes_select` text COLLATE utf8mb4_unicode_ci, `tables_select` text COLLATE utf8mb4_unicode_ci, `tables_modify` text COLLATE utf8mb4_unicode_ci, `groupMods` text COLLATE utf8mb4_unicode_ci, `availableWidgets` text COLLATE utf8mb4_unicode_ci, `mfa_providers` text COLLATE utf8mb4_unicode_ci, `file_mountpoints` text COLLATE utf8mb4_unicode_ci, `file_permissions` text COLLATE utf8mb4_unicode_ci, `TSconfig` text COLLATE utf8mb4_unicode_ci, `subgroup` text COLLATE utf8mb4_unicode_ci, `workspace_perms` smallint NOT NULL DEFAULT '1', `category_perms` longtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`uid`), KEY `parent` (`pid`,`deleted`,`hidden`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `be_sessions` -- CREATE TABLE `be_sessions` ( `ses_id` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `ses_iplock` varchar(39) 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, PRIMARY KEY (`ses_id`), KEY `ses_tstamp` (`ses_tstamp`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- 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 COLLATE utf8mb4_unicode_ci, `username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `avatar` int unsigned NOT NULL DEFAULT '0', `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `admin` smallint unsigned NOT NULL DEFAULT '0', `usergroup` text COLLATE utf8mb4_unicode_ci, `lang` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default', `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `db_mountpoints` text COLLATE utf8mb4_unicode_ci, `options` smallint unsigned NOT NULL DEFAULT '0', `realName` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `userMods` text COLLATE utf8mb4_unicode_ci, `allowed_languages` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `uc` mediumblob, `file_mountpoints` text COLLATE utf8mb4_unicode_ci, `file_permissions` text COLLATE utf8mb4_unicode_ci, `workspace_perms` smallint NOT NULL DEFAULT '1', `TSconfig` text COLLATE utf8mb4_unicode_ci, `workspace_id` int NOT NULL DEFAULT '0', `mfa` mediumblob, `category_perms` longtext COLLATE utf8mb4_unicode_ci, `lastlogin` int NOT NULL DEFAULT '0', `password_reset_token` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`uid`), KEY `username` (`username`), KEY `parent` (`pid`,`deleted`,`disable`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `be_users` -- INSERT INTO `be_users` VALUES (1, 0, [[timestamp]], [[timestamp]], 0, 0, 0, 0, NULL, '[[admin_username]]', 0, '[[admin_pass]]', 1, NULL, 'default', '[[admin_email]]', NULL, 0, '', NULL, '', NULL, NULL, NULL, 1, NULL, 0, NULL, NULL, 0, ''); -- -------------------------------------------------------- -- -- Table structure for table `cache_hash` -- CREATE TABLE `cache_hash` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `expires` int unsigned NOT NULL DEFAULT '0', `content` longblob, PRIMARY KEY (`id`), KEY `cache_id` (`identifier`(180),`expires`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache_hash_tags` -- CREATE TABLE `cache_hash_tags` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `tag` varchar(250) 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; -- -------------------------------------------------------- -- -- Table structure for table `cache_imagesizes` -- CREATE TABLE `cache_imagesizes` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `expires` int unsigned NOT NULL DEFAULT '0', `content` longblob, PRIMARY KEY (`id`), KEY `cache_id` (`identifier`(180),`expires`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache_imagesizes_tags` -- CREATE TABLE `cache_imagesizes_tags` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `tag` varchar(250) 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; -- -------------------------------------------------------- -- -- Table structure for table `cache_pages` -- CREATE TABLE `cache_pages` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `expires` int unsigned NOT NULL DEFAULT '0', `content` longblob, PRIMARY KEY (`id`), KEY `cache_id` (`identifier`(180),`expires`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache_pages_tags` -- CREATE TABLE `cache_pages_tags` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `tag` varchar(250) 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; -- -------------------------------------------------------- -- -- Table structure for table `cache_rootline` -- CREATE TABLE `cache_rootline` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `expires` int unsigned NOT NULL DEFAULT '0', `content` longblob, PRIMARY KEY (`id`), KEY `cache_id` (`identifier`(180),`expires`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache_rootline_tags` -- CREATE TABLE `cache_rootline_tags` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `tag` varchar(250) 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; -- -------------------------------------------------------- -- -- Table structure for table `cache_treelist` -- CREATE TABLE `cache_treelist` ( `md5hash` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `pid` int NOT NULL DEFAULT '0', `treelist` mediumtext COLLATE utf8mb4_unicode_ci, `tstamp` int NOT NULL DEFAULT '0', `expires` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`md5hash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- 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 COLLATE utf8mb4_unicode_ci, `tx_extbase_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `subgroup` tinytext COLLATE utf8mb4_unicode_ci, `TSconfig` text COLLATE utf8mb4_unicode_ci, `felogin_redirectPid` tinytext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`uid`), KEY `parent` (`pid`,`deleted`,`hidden`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `fe_sessions` -- CREATE TABLE `fe_sessions` ( `ses_id` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `ses_iplock` varchar(39) 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, `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; -- -------------------------------------------------------- -- -- 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 COLLATE utf8mb4_unicode_ci, `tx_extbase_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `lastlogin` int NOT NULL DEFAULT '0', `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `usergroup` text COLLATE utf8mb4_unicode_ci, `name` varchar(160) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `first_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `middle_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `last_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `telephone` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `fax` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `uc` blob, `title` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `zip` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `city` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `country` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `www` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `company` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `image` tinytext COLLATE utf8mb4_unicode_ci, `TSconfig` text COLLATE utf8mb4_unicode_ci, `is_online` int unsigned NOT NULL DEFAULT '0', `mfa` mediumblob, `felogin_redirectPid` tinytext COLLATE utf8mb4_unicode_ci, `felogin_forgotHash` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT '', 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; -- -------------------------------------------------------- -- -- 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `sorting` int NOT NULL DEFAULT '0', `rowDescription` text COLLATE utf8mb4_unicode_ci, `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 COLLATE utf8mb4_unicode_ci, `t3_origuid` int unsigned NOT NULL DEFAULT '0', `l10n_diffsource` mediumblob, `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', `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `doktype` int unsigned NOT NULL DEFAULT '0', `TSconfig` text COLLATE utf8mb4_unicode_ci, `is_siteroot` smallint NOT NULL DEFAULT '0', `php_tree_stop` smallint NOT NULL DEFAULT '0', `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `shortcut` int unsigned NOT NULL DEFAULT '0', `shortcut_mode` int unsigned NOT NULL DEFAULT '0', `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `layout` int unsigned NOT NULL DEFAULT '0', `target` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `media` int unsigned NOT NULL DEFAULT '0', `keywords` text COLLATE utf8mb4_unicode_ci, `cache_timeout` int unsigned NOT NULL DEFAULT '0', `cache_tags` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `description` text COLLATE utf8mb4_unicode_ci, `no_search` smallint unsigned NOT NULL DEFAULT '0', `SYS_LASTCHANGED` int unsigned NOT NULL DEFAULT '0', `abstract` text COLLATE utf8mb4_unicode_ci, `module` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `extendToSubpages` smallint unsigned NOT NULL DEFAULT '0', `author` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `author_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `nav_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `nav_hide` smallint NOT NULL DEFAULT '0', `content_from_pid` int unsigned NOT NULL DEFAULT '0', `mount_pid` int unsigned NOT NULL DEFAULT '0', `mount_pid_ol` smallint NOT NULL DEFAULT '0', `l18n_cfg` smallint NOT NULL DEFAULT '0', `backend_layout` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `backend_layout_next_level` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `tsconfig_includes` text COLLATE utf8mb4_unicode_ci, `categories` int unsigned NOT NULL DEFAULT '0', `lastUpdated` int NOT NULL DEFAULT '0', `newUntil` int NOT NULL DEFAULT '0', `slug` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `tx_impexp_origuid` int NOT NULL DEFAULT '0', `seo_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `no_index` smallint NOT NULL DEFAULT '0', `no_follow` smallint NOT NULL DEFAULT '0', `og_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `og_description` text COLLATE utf8mb4_unicode_ci, `og_image` int unsigned NOT NULL DEFAULT '0', `twitter_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `twitter_description` text COLLATE utf8mb4_unicode_ci, `twitter_image` int unsigned NOT NULL DEFAULT '0', `twitter_card` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `canonical_link` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `sitemap_priority` decimal(2,1) NOT NULL DEFAULT '0.5', `sitemap_changefreq` varchar(10) 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; -- -------------------------------------------------------- -- -- 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `arguments` text COLLATE utf8mb4_unicode_ci, `description` varchar(255) 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; -- -------------------------------------------------------- -- -- 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 COLLATE utf8mb4_unicode_ci, `sys_language_uid` int NOT NULL DEFAULT '0', `l10n_parent` int unsigned NOT NULL DEFAULT '0', `l10n_state` text COLLATE utf8mb4_unicode_ci, `t3_origuid` int unsigned NOT NULL DEFAULT '0', `l10n_diffsource` mediumblob, `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 COLLATE utf8mb4_unicode_ci NOT NULL, `items` int NOT NULL DEFAULT '0', `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; -- -------------------------------------------------------- -- -- 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', `tablenames` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `fieldname` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `sorting` int unsigned NOT NULL DEFAULT '0', `sorting_foreign` int unsigned NOT NULL DEFAULT '0', 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; -- -------------------------------------------------------- -- -- Table structure for table `sys_csp_resolution` -- CREATE TABLE `sys_csp_resolution` ( `summary` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL, `created` int unsigned NOT NULL, `scope` varchar(264) COLLATE utf8mb4_unicode_ci NOT NULL, `mutation_identifier` text COLLATE utf8mb4_unicode_ci, `mutation_collection` mediumtext COLLATE utf8mb4_unicode_ci, `meta` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`summary`), KEY `created` (`created`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- 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', `missing` smallint NOT NULL DEFAULT '0', `storage` int NOT NULL DEFAULT '0', `type` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `metadata` int NOT NULL DEFAULT '0', `identifier` text COLLATE utf8mb4_unicode_ci, `identifier_hash` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `folder_hash` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `extension` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `mime_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `name` tinytext COLLATE utf8mb4_unicode_ci, `sha1` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `size` bigint unsigned NOT NULL DEFAULT '0', `creation_date` int NOT NULL DEFAULT '0', `modification_date` int 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; -- -------------------------------------------------------- -- -- 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 COLLATE utf8mb4_unicode_ci, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `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; -- -------------------------------------------------------- -- -- 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 COLLATE utf8mb4_unicode_ci, `sys_language_uid` int NOT NULL DEFAULT '0', `l10n_parent` int unsigned NOT NULL DEFAULT '0', `l10n_state` text COLLATE utf8mb4_unicode_ci, `t3_origuid` int unsigned NOT NULL DEFAULT '0', `l10n_diffsource` mediumblob, `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 COLLATE utf8mb4_unicode_ci, `type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'static', `files` int NOT NULL DEFAULT '0', `folder_identifier` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `recursive` smallint 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; -- -------------------------------------------------------- -- -- 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 COLLATE utf8mb4_unicode_ci, `t3_origuid` int unsigned NOT NULL DEFAULT '0', `l10n_diffsource` mediumblob, `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', `file` int NOT NULL DEFAULT '0', `title` tinytext COLLATE utf8mb4_unicode_ci, `width` int NOT NULL DEFAULT '0', `height` int NOT NULL DEFAULT '0', `description` text COLLATE utf8mb4_unicode_ci, `alternative` text COLLATE utf8mb4_unicode_ci, `categories` int unsigned 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; -- -------------------------------------------------------- -- -- 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `name` tinytext COLLATE utf8mb4_unicode_ci, `processing_url` text COLLATE utf8mb4_unicode_ci, `configuration` blob, `configurationsha1` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `originalfilesha1` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `task_type` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `checksum` varchar(32) 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; -- -------------------------------------------------------- -- -- 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 COLLATE utf8mb4_unicode_ci, `l10n_diffsource` mediumblob, `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', `uid_foreign` int NOT NULL DEFAULT '0', `tablenames` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `fieldname` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `sorting_foreign` int NOT NULL DEFAULT '0', `title` tinytext COLLATE utf8mb4_unicode_ci, `description` text COLLATE utf8mb4_unicode_ci, `alternative` text COLLATE utf8mb4_unicode_ci, `link` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `crop` varchar(4000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `autoplay` smallint 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; -- -------------------------------------------------------- -- -- 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 COLLATE utf8mb4_unicode_ci, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `driver` tinytext COLLATE utf8mb4_unicode_ci, `configuration` text COLLATE utf8mb4_unicode_ci, `is_default` smallint NOT NULL DEFAULT '0', `is_browsable` smallint NOT NULL DEFAULT '0', `is_public` smallint NOT NULL DEFAULT '0', `is_writable` smallint NOT NULL DEFAULT '0', `is_online` smallint NOT NULL DEFAULT '1', `auto_extract_metadata` smallint NOT NULL DEFAULT '1', `processingfolder` tinytext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`uid`), KEY `parent` (`pid`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- 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) 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `history_data` mediumtext COLLATE utf8mb4_unicode_ci, `workspace` int DEFAULT '0', `correlation_id` varchar(255) 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; -- -------------------------------------------------------- -- -- Table structure for table `sys_http_report` -- CREATE TABLE `sys_http_report` ( `uuid` varchar(36) 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) COLLATE utf8mb4_unicode_ci NOT NULL, `scope` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `request_time` bigint unsigned NOT NULL, `meta` mediumtext COLLATE utf8mb4_unicode_ci, `details` mediumtext COLLATE utf8mb4_unicode_ci, `summary` varchar(40) 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; -- -------------------------------------------------------- -- -- 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `record_uid` int NOT NULL DEFAULT '0', `record_pid` int NOT NULL DEFAULT '0', `username` varchar(50) 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; -- -------------------------------------------------------- -- -- Table structure for table `sys_log` -- CREATE TABLE `sys_log` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `pid` int unsigned NOT NULL DEFAULT '0', `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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `recpid` int NOT NULL DEFAULT '0', `error` smallint unsigned NOT NULL DEFAULT '0', `details` text COLLATE utf8mb4_unicode_ci, `type` smallint unsigned NOT NULL DEFAULT '0', `channel` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default', `details_nr` smallint NOT NULL DEFAULT '0', `IP` varchar(39) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `log_data` text COLLATE utf8mb4_unicode_ci, `event_pid` int NOT NULL DEFAULT '-1', `workspace` int NOT NULL DEFAULT '0', `NEWid` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `request_id` varchar(13) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `time_micro` double NOT NULL DEFAULT '0', `component` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `level` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'info', `message` text COLLATE utf8mb4_unicode_ci, `data` text COLLATE utf8mb4_unicode_ci, 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 `channel` (`channel`), KEY `level` (`level`), KEY `parent` (`pid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `sys_messenger_messages` -- CREATE TABLE `sys_messenger_messages` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `headers` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `queue_name` varchar(190) 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; -- -------------------------------------------------------- -- -- 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `content` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`uid`), KEY `parent` (`pid`,`deleted`,`hidden`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci 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', `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `cruser` int unsigned NOT NULL DEFAULT '0', `message` text COLLATE utf8mb4_unicode_ci, `personal` smallint unsigned NOT NULL DEFAULT '0', `category` smallint unsigned NOT NULL DEFAULT '0', `position` int NOT NULL DEFAULT '0', PRIMARY KEY (`uid`), KEY `parent` (`pid`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- 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 COLLATE utf8mb4_unicode_ci, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `reaction_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `secret` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `impersonate_user` int unsigned NOT NULL DEFAULT '0', `table_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `storage_pid` int unsigned NOT NULL DEFAULT '0', `fields` json DEFAULT NULL, `identifier` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', 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; -- -------------------------------------------------------- -- -- Table structure for table `sys_refindex` -- CREATE TABLE `sys_refindex` ( `hash` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `tablename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `recuid` int NOT NULL DEFAULT '0', `field` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `flexpointer` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `softref_key` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `softref_id` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `sorting` int NOT NULL DEFAULT '0', `workspace` int NOT NULL DEFAULT '0', `ref_table` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `ref_uid` int NOT NULL DEFAULT '0', `ref_string` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`hash`), KEY `lookup_rec` (`tablename`(100),`recuid`), KEY `lookup_uid` (`ref_table`(100),`ref_uid`), KEY `lookup_string` (`ref_string`(191)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `sys_registry` -- CREATE TABLE `sys_registry` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `entry_namespace` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `entry_key` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `entry_value` mediumblob, PRIMARY KEY (`uid`), UNIQUE KEY `entry_identifier` (`entry_namespace`,`entry_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci 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\\BackendUserLanguageMigration', 'i:1;'), (4, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\FeLoginModeExtractionUpdate', 'i:1;'), (5, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\CollectionsExtractionUpdate', 'i:1;'), (6, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\MigrateSiteSettingsConfigUpdate', 'i:1;'), (7, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\PasswordPolicyForFrontendUsersUpdate', 'i:1;'), (8, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\ShortcutRecordsMigration', 'i:1;'), (9, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\SvgFilesSanitization', 'i:1;'), (10, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\SysFileCollectionIdentifierMigration', 'i:1;'), (11, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\SysFileMountIdentifierMigration', 'i:1;'), (12, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\SysLogChannel', 'i:1;'), (13, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\SysLogSerializationUpdate', 'i:1;'), (14, 'installUpdate', 'TYPO3\\CMS\\Install\\Updates\\SysTemplateNoWorkspaceMigration', 'i:1;'), (15, 'installUpdateRows', 'rowUpdatersDone', 'a:4:{i:0;s:66:"TYPO3\\CMS\\Install\\Updates\\RowUpdater\\L18nDiffsourceToJsonMigration";i:1;s:77:"TYPO3\\CMS\\Install\\Updates\\RowUpdater\\WorkspaceMovePlaceholderRemovalMigration";i:2;s:76:"TYPO3\\CMS\\Install\\Updates\\RowUpdater\\WorkspaceNewPlaceholderRemovalMigration";i:3;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 COLLATE utf8mb4_unicode_ci, `t3_origuid` int unsigned NOT NULL DEFAULT '0', `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `root` smallint unsigned NOT NULL DEFAULT '0', `clear` smallint unsigned NOT NULL DEFAULT '0', `include_static_file` text COLLATE utf8mb4_unicode_ci, `constants` text COLLATE utf8mb4_unicode_ci, `config` text COLLATE utf8mb4_unicode_ci, `basedOn` tinytext COLLATE utf8mb4_unicode_ci, `includeStaticAfterBasedOn` smallint unsigned NOT NULL DEFAULT '0', `static_file_mode` smallint unsigned NOT NULL DEFAULT '0', `tx_impexp_origuid` int 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; -- -------------------------------------------------------- -- -- 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 COLLATE utf8mb4_unicode_ci, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `url` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `method` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `secret` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `webhook_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `verify_ssl` int NOT NULL DEFAULT '1', `additional_headers` json DEFAULT NULL, `identifier` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', 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; -- -------------------------------------------------------- -- -- Table structure for table `tt_content` -- CREATE TABLE `tt_content` ( `uid` int unsigned NOT NULL AUTO_INCREMENT, `rowDescription` text COLLATE utf8mb4_unicode_ci, `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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `sorting` int NOT NULL DEFAULT '0', `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 COLLATE utf8mb4_unicode_ci, `t3_origuid` int unsigned NOT NULL DEFAULT '0', `l18n_diffsource` mediumblob, `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', `CType` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `header` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `header_position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `bodytext` mediumtext COLLATE utf8mb4_unicode_ci, `bullets_type` smallint unsigned NOT NULL DEFAULT '0', `uploads_description` smallint unsigned NOT NULL DEFAULT '0', `uploads_type` smallint unsigned NOT NULL DEFAULT '0', `assets` int unsigned NOT NULL DEFAULT '0', `image` int unsigned NOT NULL DEFAULT '0', `imagewidth` int unsigned NOT NULL DEFAULT '0', `imageorient` smallint unsigned NOT NULL DEFAULT '0', `imagecols` smallint unsigned NOT NULL DEFAULT '0', `imageborder` smallint unsigned NOT NULL DEFAULT '0', `media` int unsigned NOT NULL DEFAULT '0', `layout` int unsigned NOT NULL DEFAULT '0', `frame_class` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default', `cols` int unsigned NOT NULL DEFAULT '0', `space_before_class` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `space_after_class` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `records` text COLLATE utf8mb4_unicode_ci, `pages` text COLLATE utf8mb4_unicode_ci, `colPos` int unsigned NOT NULL DEFAULT '0', `subheader` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `header_link` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `image_zoom` smallint unsigned NOT NULL DEFAULT '0', `header_layout` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `list_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `sectionIndex` smallint unsigned NOT NULL DEFAULT '0', `linkToTop` smallint unsigned NOT NULL DEFAULT '0', `file_collections` text COLLATE utf8mb4_unicode_ci, `filelink_size` smallint unsigned NOT NULL DEFAULT '0', `filelink_sorting` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `filelink_sorting_direction` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `target` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `recursive` smallint unsigned NOT NULL DEFAULT '0', `imageheight` int unsigned NOT NULL DEFAULT '0', `pi_flexform` mediumtext COLLATE utf8mb4_unicode_ci, `accessibility_title` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `accessibility_bypass` smallint unsigned NOT NULL DEFAULT '0', `accessibility_bypass_text` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `category_field` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `table_class` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `table_caption` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `table_delimiter` smallint unsigned NOT NULL DEFAULT '0', `table_enclosure` smallint unsigned NOT NULL DEFAULT '0', `table_header_position` smallint unsigned NOT NULL DEFAULT '0', `table_tfoot` smallint unsigned NOT NULL DEFAULT '0', `categories` int unsigned NOT NULL DEFAULT '0', `selected_categories` longtext COLLATE utf8mb4_unicode_ci, `date` int NOT NULL DEFAULT '0', `tx_impexp_origuid` int 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; -- -------------------------------------------------------- -- -- 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `repository` int NOT NULL DEFAULT '1', `remote` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ter', `version` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `alldownloadcounter` int unsigned NOT NULL DEFAULT '0', `downloadcounter` int unsigned NOT NULL DEFAULT '0', `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `description` mediumtext COLLATE utf8mb4_unicode_ci, `state` int NOT NULL DEFAULT '0', `review_state` int NOT NULL DEFAULT '0', `category` int NOT NULL DEFAULT '0', `serialized_dependencies` mediumtext COLLATE utf8mb4_unicode_ci, `author_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `author_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `ownerusername` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `md5hash` varchar(35) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `update_comment` mediumtext COLLATE utf8mb4_unicode_ci, `authorcompany` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `integer_version` int NOT NULL DEFAULT '0', `current_version` int NOT NULL DEFAULT '0', `lastreviewedversion` int NOT NULL DEFAULT '0', `documentation_link` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `distribution_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `distribution_welcome_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_updated` 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; -- -------------------------------------------------------- -- -- 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) 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, PRIMARY KEY (`uid`), KEY `lookup` (`item_uid`), KEY `parent` (`pid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!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 */;