|
-- MySQL dump 10.13 Distrib 8.0.23, for Linux (x86_64)
|
|
--
|
|
-- Host: localhost Database: t3_core
|
|
-- ------------------------------------------------------
|
|
-- Server version 8.0.23-0ubuntu0.20.04.1
|
|
|
|
/*!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 */;
|
|
/*!50503 SET NAMES utf8mb4 */;
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
|
--
|
|
-- Table structure for table `pages`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `pages`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `pages` (
|
|
`uid` int unsigned NOT NULL AUTO_INCREMENT,
|
|
`pid` int NOT NULL DEFAULT '0',
|
|
`tstamp` int unsigned NOT NULL DEFAULT '0',
|
|
`crdate` int unsigned NOT NULL DEFAULT '0',
|
|
`cruser_id` 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',
|
|
`t3ver_count` int unsigned NOT NULL DEFAULT '0',
|
|
`t3ver_tstamp` int unsigned NOT NULL DEFAULT '0',
|
|
`t3ver_move_id` int unsigned 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 '',
|
|
`slug` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`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',
|
|
`lastUpdated` 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 '',
|
|
`newUntil` int unsigned NOT NULL DEFAULT '0',
|
|
`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',
|
|
`fe_login_mode` 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,
|
|
`legacy_overlay_uid` int unsigned NOT NULL DEFAULT '0',
|
|
`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 '',
|
|
`categories` int NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`uid`),
|
|
KEY `determineSiteRoot` (`is_siteroot`),
|
|
KEY `language_identifier` (`l10n_parent`,`sys_language_uid`),
|
|
KEY `legacy_overlay` (`legacy_overlay_uid`),
|
|
KEY `slug` (`slug`(127)),
|
|
KEY `parent` (`pid`,`deleted`,`hidden`),
|
|
KEY `translation_source` (`l10n_source`),
|
|
KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `pages`
|
|
--
|
|
|
|
LOCK TABLES `pages` WRITE;
|
|
/*!40000 ALTER TABLE `pages` DISABLE KEYS */;
|
|
INSERT INTO `pages` VALUES (1,0,0,0,0,0,0,0,0,'0',0,NULL,0,0,0,0,NULL,0,NULL,0,0,0,0,0,0,0,0,0,0,0,0,'page-1','/',0,NULL,0,0,'',0,0,'',0,'',0,0,NULL,0,'',0,NULL,0,0,NULL,'',0,'','','',0,0,0,0,0,0,'','',NULL,0,0,'',0,0,'',NULL,0,'',NULL,0,'','',0.5,'',0),(2,1,1612528549,0,0,0,0,0,0,'',0,NULL,0,0,0,0,NULL,0,_binary 'a:50:{s:7:\"doktype\";N;s:5:\"title\";N;s:4:\"slug\";N;s:9:\"nav_title\";N;s:8:\"subtitle\";N;s:9:\"seo_title\";N;s:11:\"description\";N;s:8:\"no_index\";N;s:9:\"no_follow\";N;s:14:\"canonical_link\";N;s:18:\"sitemap_changefreq\";N;s:16:\"sitemap_priority\";N;s:8:\"og_title\";N;s:14:\"og_description\";N;s:8:\"og_image\";N;s:13:\"twitter_title\";N;s:19:\"twitter_description\";N;s:13:\"twitter_image\";N;s:12:\"twitter_card\";N;s:8:\"abstract\";N;s:8:\"keywords\";N;s:6:\"author\";N;s:12:\"author_email\";N;s:11:\"lastUpdated\";N;s:6:\"layout\";N;s:8:\"newUntil\";N;s:14:\"backend_layout\";N;s:25:\"backend_layout_next_level\";N;s:16:\"content_from_pid\";N;s:6:\"target\";N;s:13:\"cache_timeout\";N;s:10:\"cache_tags\";N;s:11:\"is_siteroot\";N;s:9:\"no_search\";N;s:13:\"php_tree_stop\";N;s:6:\"module\";N;s:5:\"media\";N;s:17:\"tsconfig_includes\";N;s:8:\"TSconfig\";N;s:8:\"l18n_cfg\";N;s:6:\"hidden\";N;s:8:\"nav_hide\";N;s:9:\"starttime\";N;s:7:\"endtime\";N;s:16:\"extendToSubpages\";N;s:8:\"fe_group\";N;s:13:\"fe_login_mode\";N;s:8:\"editlock\";N;s:10:\"categories\";N;s:14:\"rowDescription\";N;}',0,0,0,0,0,0,0,0,0,0,0,0,'page-2','/page-2',1,NULL,0,0,'',0,0,'',0,'',0,0,NULL,0,'',0,NULL,0,0,NULL,'',0,'','','',0,0,0,0,0,0,'','',NULL,0,0,'',0,0,'',NULL,0,'',NULL,0,'summary','',0.5,'',0),(3,0,0,0,0,0,0,0,0,'0',0,NULL,0,1,1,1,NULL,0,NULL,0,0,0,0,0,0,0,0,0,0,0,0,'page-1-localized','/',0,NULL,0,0,'',0,0,'',0,'',0,0,NULL,0,'',0,NULL,0,1612528608,NULL,'',0,'','','',0,0,0,0,0,0,'','',NULL,0,0,'',0,0,'',NULL,0,'',NULL,0,'','',0.5,'',0),(4,0,1612528541,0,0,0,0,0,0,'',0,NULL,0,1,2,2,'{\"starttime\":\"parent\",\"endtime\":\"parent\",\"nav_hide\":\"parent\",\"url\":\"parent\",\"lastUpdated\":\"parent\",\"newUntil\":\"parent\",\"no_search\":\"parent\",\"shortcut\":\"parent\",\"shortcut_mode\":\"parent\",\"content_from_pid\":\"parent\",\"author\":\"parent\",\"author_email\":\"parent\",\"media\":\"parent\",\"og_image\":\"parent\",\"twitter_image\":\"parent\"}',0,_binary 'a:35:{s:9:\"starttime\";i:0;s:7:\"endtime\";i:0;s:8:\"nav_hide\";i:0;s:3:\"url\";s:0:\"\";s:11:\"lastUpdated\";i:0;s:8:\"newUntil\";i:0;s:9:\"no_search\";i:0;s:8:\"shortcut\";i:0;s:13:\"shortcut_mode\";i:0;s:16:\"content_from_pid\";i:0;s:6:\"author\";s:0:\"\";s:12:\"author_email\";s:0:\"\";s:5:\"media\";i:0;s:8:\"og_image\";i:0;s:13:\"twitter_image\";i:0;s:8:\"TSconfig\";N;s:13:\"php_tree_stop\";i:0;s:8:\"editlock\";i:0;s:6:\"layout\";i:0;s:8:\"fe_group\";s:0:\"\";s:16:\"extendToSubpages\";i:0;s:6:\"target\";s:0:\"\";s:13:\"cache_timeout\";i:0;s:10:\"cache_tags\";s:0:\"\";s:9:\"mount_pid\";i:0;s:11:\"is_siteroot\";i:0;s:12:\"mount_pid_ol\";i:0;s:6:\"module\";s:0:\"\";s:13:\"fe_login_mode\";i:0;s:8:\"l18n_cfg\";i:0;s:14:\"backend_layout\";s:0:\"\";s:25:\"backend_layout_next_level\";s:0:\"\";s:17:\"tsconfig_includes\";N;s:8:\"no_index\";i:0;s:9:\"no_follow\";i:0;}',0,0,0,0,0,0,0,0,0,0,0,0,'page-3-localized',NULL,0,NULL,0,0,'',0,0,'',0,'',0,0,NULL,0,'',0,NULL,0,1612528541,NULL,'',0,'','','',0,0,0,0,0,0,'','',NULL,0,0,'',0,0,'',NULL,0,'',NULL,0,'','',0.5,'',0);
|
|
/*!40000 ALTER TABLE `pages` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `sys_workspace`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `sys_workspace`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `sys_workspace` (
|
|
`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',
|
|
`description` text COLLATE utf8mb4_unicode_ci,
|
|
`title` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
|
|
`adminusers` varchar(4000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
|
|
`members` varchar(4000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
|
|
`db_mountpoints` text COLLATE utf8mb4_unicode_ci,
|
|
`file_mountpoints` text COLLATE utf8mb4_unicode_ci,
|
|
`publish_time` int NOT NULL DEFAULT '0',
|
|
`freeze` smallint NOT NULL DEFAULT '0',
|
|
`live_edit` smallint NOT NULL DEFAULT '0',
|
|
`swap_modes` smallint NOT NULL DEFAULT '0',
|
|
`publish_access` smallint NOT NULL DEFAULT '0',
|
|
`previewlink_lifetime` int NOT NULL DEFAULT '0',
|
|
`custom_stages` int NOT NULL DEFAULT '0',
|
|
`stagechg_notification` smallint NOT NULL DEFAULT '0',
|
|
`edit_notification_defaults` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
|
|
`edit_notification_preselection` smallint NOT NULL DEFAULT '3',
|
|
`edit_allow_notificaton_settings` smallint NOT NULL DEFAULT '0',
|
|
`publish_notification_defaults` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
|
|
`publish_notification_preselection` smallint NOT NULL DEFAULT '3',
|
|
`publish_allow_notificaton_settings` smallint NOT NULL DEFAULT '0',
|
|
`execute_notification_defaults` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
|
|
`execute_notification_preselection` smallint NOT NULL DEFAULT '3',
|
|
`execute_allow_notificaton_settings` smallint NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`uid`),
|
|
KEY `parent` (`pid`,`deleted`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `sys_workspace`
|
|
--
|
|
|
|
LOCK TABLES `sys_workspace` WRITE;
|
|
/*!40000 ALTER TABLE `sys_workspace` DISABLE KEYS */;
|
|
INSERT INTO `sys_workspace` VALUES (1,0,1610796526,0,'','ws','','','',NULL,0,0,0,2,0,48,0,0,'',2,3,'',1,3,'',3,3);
|
|
/*!40000 ALTER TABLE `sys_workspace` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `sys_language`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `sys_language`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `sys_language` (
|
|
`uid` int unsigned NOT NULL AUTO_INCREMENT,
|
|
`pid` int unsigned NOT NULL DEFAULT '0',
|
|
`tstamp` int unsigned NOT NULL DEFAULT '0',
|
|
`hidden` smallint unsigned NOT NULL DEFAULT '0',
|
|
`sorting` int NOT NULL DEFAULT '0',
|
|
`title` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
|
|
`flag` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
|
|
`language_isocode` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
|
|
PRIMARY KEY (`uid`),
|
|
KEY `parent` (`pid`,`hidden`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `sys_language`
|
|
--
|
|
|
|
LOCK TABLES `sys_language` WRITE;
|
|
/*!40000 ALTER TABLE `sys_language` DISABLE KEYS */;
|
|
INSERT INTO `sys_language` VALUES (1,0,1610553470,0,256,'de','de','de');
|
|
/*!40000 ALTER TABLE `sys_language` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `tt_content`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `tt_content`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `tt_content` (
|
|
`uid` int unsigned NOT NULL AUTO_INCREMENT,
|
|
`rowDescription` text COLLATE utf8mb4_unicode_ci,
|
|
`pid` int NOT NULL DEFAULT '0',
|
|
`tstamp` int unsigned NOT NULL DEFAULT '0',
|
|
`crdate` int unsigned NOT NULL DEFAULT '0',
|
|
`cruser_id` 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',
|
|
`t3ver_count` int unsigned NOT NULL DEFAULT '0',
|
|
`t3ver_tstamp` int unsigned NOT NULL DEFAULT '0',
|
|
`t3ver_move_id` int unsigned 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 '',
|
|
`date` int unsigned NOT NULL DEFAULT '0',
|
|
`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 '',
|
|
`selected_categories` text COLLATE utf8mb4_unicode_ci,
|
|
`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',
|
|
`tx_impexp_origuid` int NOT NULL DEFAULT '0',
|
|
`tx_container_parent` int NOT NULL DEFAULT '0',
|
|
`categories` 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`),
|
|
KEY `container_parent` (`tx_container_parent`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `tt_content`
|
|
--
|
|
|
|
LOCK TABLES `tt_content` WRITE;
|
|
/*!40000 ALTER TABLE `tt_content` DISABLE KEYS */;
|
|
INSERT INTO `tt_content` VALUES (1,'',1,1612529736,1612529736,1,0,0,0,0,'',256,0,0,0,0,NULL,0,'',0,0,0,0,0,0,0,'header','a1','',NULL,0,0,0,0,0,0,0,2,0,0,0,'default',0,'','',NULL,NULL,0,'','',0,'0','',1,0,NULL,0,'','','',0,0,0,NULL,'',0,'',NULL,'','',NULL,124,0,0,0,0,0,0),(2,'',1,1612529747,1612529747,1,0,0,0,0,'',512,0,1,1,1,NULL,1,'',0,1,1,0,0,0,0,'header','[Translate to de:] a1','',NULL,0,0,0,0,0,0,0,2,0,0,0,'default',0,'','','','',0,'','',0,'0','',1,0,'',0,'','','',0,0,0,NULL,'',0,'','','','',NULL,124,0,0,0,0,0,0),(3,'',1,1612529750,1612529747,1,0,0,0,0,'',512,0,1,1,1,NULL,1,_binary 'a:1:{s:6:\"hidden\";i:0;}',2,1,-1,0,0,0,0,'header','[Translate to de:] a1','',NULL,0,0,0,0,0,0,0,2,0,0,0,'default',0,'','','','',0,'','',0,'0','',1,0,'',0,'','','',0,0,0,NULL,'',0,'','','','',NULL,124,0,0,0,0,0,0);
|
|
/*!40000 ALTER TABLE `tt_content` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
/*!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 */;
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|
|
-- Dump completed on 2021-02-05 14:19:43
|