|
Server IP : 68.65.122.142 / Your IP : 18.219.109.150 Web Server : LiteSpeed System : Linux server167.web-hosting.com 4.18.0-513.18.1.lve.el8.x86_64 #1 SMP Thu Feb 22 12:55:50 UTC 2024 x86_64 User : glenirhm ( 1318) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /var/softaculous/elgg2/../spip/../popoji/../eengine/../typo8/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
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: `typo1340`
--
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
-- --------------------------------------------------------
--
-- 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;
/*!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 */;