|
-- phpMyAdmin SQL Dump
|
|
-- version 5.1.0
|
|
-- https://www.phpmyadmin.net/
|
|
--
|
|
-- Host: db
|
|
-- Erstellungszeit: 12. Mai 2022 um 11:01
|
|
-- Server-Version: 10.3.34-MariaDB-1:10.3.34+maria~focal-log
|
|
-- PHP-Version: 7.4.19
|
|
|
|
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
|
START TRANSACTION;
|
|
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 utf8mb4 */;
|
|
|
|
--
|
|
-- Datenbank: `db`
|
|
--
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `pages`
|
|
--
|
|
|
|
CREATE TABLE `pages` (
|
|
`uid` int(10) UNSIGNED NOT NULL,
|
|
`pid` int(11) NOT NULL DEFAULT 0,
|
|
`tstamp` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`crdate` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`cruser_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`deleted` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`hidden` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`starttime` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`endtime` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`fe_group` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
|
|
`sorting` int(11) NOT NULL DEFAULT 0,
|
|
`rowDescription` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`editlock` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`sys_language_uid` int(11) NOT NULL DEFAULT 0,
|
|
`l10n_parent` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`l10n_source` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`l10n_state` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`t3_origuid` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`l10n_diffsource` mediumblob DEFAULT NULL,
|
|
`t3ver_oid` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`t3ver_wsid` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`t3ver_state` smallint(6) NOT NULL DEFAULT 0,
|
|
`t3ver_stage` int(11) NOT NULL DEFAULT 0,
|
|
`perms_userid` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`perms_groupid` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`perms_user` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`perms_group` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`perms_everybody` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`slug` varchar(2048) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`doktype` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`TSconfig` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`is_siteroot` smallint(6) NOT NULL DEFAULT 0,
|
|
`php_tree_stop` smallint(6) NOT NULL DEFAULT 0,
|
|
`url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`shortcut` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`shortcut_mode` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`subtitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`layout` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`target` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`media` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`lastUpdated` int(11) NOT NULL DEFAULT 0,
|
|
`keywords` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`cache_timeout` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`cache_tags` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`newUntil` int(11) NOT NULL DEFAULT 0,
|
|
`description` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`no_search` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`SYS_LASTCHANGED` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`abstract` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`module` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`extendToSubpages` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`author` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`author_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`nav_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`nav_hide` smallint(6) NOT NULL DEFAULT 0,
|
|
`content_from_pid` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`mount_pid` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`mount_pid_ol` smallint(6) NOT NULL DEFAULT 0,
|
|
`l18n_cfg` smallint(6) NOT NULL DEFAULT 0,
|
|
`backend_layout` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`backend_layout_next_level` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`tsconfig_includes` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`categories` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`tx_impexp_origuid` int(11) NOT NULL DEFAULT 0,
|
|
`seo_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`no_index` smallint(6) NOT NULL DEFAULT 0,
|
|
`no_follow` smallint(6) NOT NULL DEFAULT 0,
|
|
`og_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`og_description` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`og_image` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`twitter_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`twitter_description` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`twitter_image` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`twitter_card` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`canonical_link` varchar(2048) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`sitemap_priority` decimal(2,1) NOT NULL DEFAULT 0.5,
|
|
`sitemap_changefreq` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
|
--
|
|
-- Daten für Tabelle `pages`
|
|
--
|
|
|
|
INSERT INTO `pages` (`uid`, `pid`, `tstamp`, `crdate`, `cruser_id`, `deleted`, `hidden`, `starttime`, `endtime`, `fe_group`, `sorting`, `rowDescription`, `editlock`, `sys_language_uid`, `l10n_parent`, `l10n_source`, `l10n_state`, `t3_origuid`, `l10n_diffsource`, `t3ver_oid`, `t3ver_wsid`, `t3ver_state`, `t3ver_stage`, `perms_userid`, `perms_groupid`, `perms_user`, `perms_group`, `perms_everybody`, `title`, `slug`, `doktype`, `TSconfig`, `is_siteroot`, `php_tree_stop`, `url`, `shortcut`, `shortcut_mode`, `subtitle`, `layout`, `target`, `media`, `lastUpdated`, `keywords`, `cache_timeout`, `cache_tags`, `newUntil`, `description`, `no_search`, `SYS_LASTCHANGED`, `abstract`, `module`, `extendToSubpages`, `author`, `author_email`, `nav_title`, `nav_hide`, `content_from_pid`, `mount_pid`, `mount_pid_ol`, `l18n_cfg`, `backend_layout`, `backend_layout_next_level`, `tsconfig_includes`, `categories`, `tx_impexp_origuid`, `seo_title`, `no_index`, `no_follow`, `og_title`, `og_description`, `og_image`, `twitter_title`, `twitter_description`, `twitter_image`, `twitter_card`, `canonical_link`, `sitemap_priority`, `sitemap_changefreq`) VALUES
|
|
(1, 0, 1646322165, 1646322165, 1, 0, 0, 0, 0, '0', 512, NULL, 0, 0, 0, 0, NULL, 0, NULL, 0, 0, 0, 0, 1, 1, 31, 31, 1, 'Home', '/', 1, NULL, 1, 0, '', 0, 0, '', 0, '', 0, 0, NULL, 0, '', 0, NULL, 0, 1652353153, NULL, '', 0, '', '', '', 0, 0, 0, 0, 0, '', '', NULL, 0, 0, '', 0, 0, '', NULL, 0, '', NULL, 0, '', '', '0.5', ''),
|
|
(2, 0, 1652352676, 1652352654, 1, 0, 0, 0, 0, '', 512, NULL, 0, 1, 1, 1, '{\"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, 0x7b22646f6b74797065223a2231222c227469746c65223a22486f6d65222c22736c7567223a225c2f222c226e61765f7469746c65223a22222c227375627469746c65223a22222c2273656f5f7469746c65223a22222c226465736372697074696f6e223a22222c2263616e6f6e6963616c5f6c696e6b223a22222c22736974656d61705f6368616e676566726571223a22222c22736974656d61705f7072696f72697479223a22302e35222c226f675f7469746c65223a22222c226f675f6465736372697074696f6e223a22222c22747769747465725f7469746c65223a22222c22747769747465725f6465736372697074696f6e223a22222c22747769747465725f63617264223a22222c226162737472616374223a22222c226b6579776f726473223a22222c2268696464656e223a2230222c2263617465676f72696573223a2230222c22726f774465736372697074696f6e223a22222c225453636f6e666967223a22222c227068705f747265655f73746f70223a2230222c22656469746c6f636b223a2230222c226c61796f7574223a2230222c2266655f67726f7570223a2230222c22657874656e64546f5375627061676573223a2230222c22746172676574223a22222c2263616368655f74696d656f7574223a2230222c2263616368655f74616773223a22222c226d6f756e745f706964223a2230222c2269735f73697465726f6f74223a2231222c226d6f756e745f7069645f6f6c223a2230222c226d6f64756c65223a22222c226c31386e5f636667223a2230222c226261636b656e645f6c61796f7574223a22222c226261636b656e645f6c61796f75745f6e6578745f6c6576656c223a22222c227473636f6e6669675f696e636c75646573223a22222c226e6f5f696e646578223a2230222c226e6f5f666f6c6c6f77223a2230227d, 0, 0, 0, 0, 1, 1, 31, 31, 1, 'Home DE', '/', 1, NULL, 1, 0, '', 0, 0, '', 0, '', 0, 0, NULL, 0, '', 0, NULL, 0, 1652353074, NULL, '', 0, '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, '', 0, 0, '', NULL, 0, '', NULL, 0, 'summary', '', '0.5', '');
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `sys_template`
|
|
--
|
|
|
|
CREATE TABLE `sys_template` (
|
|
`uid` int(10) UNSIGNED NOT NULL,
|
|
`pid` int(11) NOT NULL DEFAULT 0,
|
|
`tstamp` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`crdate` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`cruser_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`deleted` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`hidden` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`starttime` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`endtime` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`sorting` int(11) NOT NULL DEFAULT 0,
|
|
`description` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`t3_origuid` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`t3ver_oid` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`t3ver_wsid` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`t3ver_state` smallint(6) NOT NULL DEFAULT 0,
|
|
`t3ver_stage` int(11) NOT NULL DEFAULT 0,
|
|
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`root` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`clear` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`include_static_file` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`constants` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`config` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`basedOn` tinytext COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`includeStaticAfterBasedOn` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`static_file_mode` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`tx_impexp_origuid` int(11) NOT NULL DEFAULT 0
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
|
--
|
|
-- Daten für Tabelle `sys_template`
|
|
--
|
|
|
|
INSERT INTO `sys_template` (`uid`, `pid`, `tstamp`, `crdate`, `cruser_id`, `deleted`, `hidden`, `starttime`, `endtime`, `sorting`, `description`, `t3_origuid`, `t3ver_oid`, `t3ver_wsid`, `t3ver_state`, `t3ver_stage`, `title`, `root`, `clear`, `include_static_file`, `constants`, `config`, `basedOn`, `includeStaticAfterBasedOn`, `static_file_mode`, `tx_impexp_origuid`) VALUES
|
|
(1, 1, 1652352987, 1646322165, 1, 0, 0, 0, 0, 0, 'This is an Empty Site Package TypoScript template.\r\n\r\nFor each website you need a TypoScript template on the main page of your website (on the top level). For better maintenance all TypoScript should be extracted into external files via @import \'EXT:site_myproject/Configuration/TypoScript/setup.typoscript\'', 0, 0, 0, 0, 0, 'Main TypoScript Rendering', 1, 1, 'EXT:fluid_styled_content/Configuration/TypoScript/,EXT:fluid_styled_content/Configuration/TypoScript/Styling/', '', 'page.config.contentObjectExceptionHandler = 0\r\npage = PAGE\r\npage.typeNum = 0\r\n\r\n# The CONTENT object executes a database query and loads the content.\r\npage.10 = CONTENT\r\npage.10.table = tt_content\r\npage.10.select {\r\n\r\n # \"sorting\" is a column from the tt_content table and\r\n # keeps track of the sorting order, which was specified in\r\n # the backend.\r\n orderBy = sorting\r\n\r\n # Only select content from column \"0\" (the column called\r\n # \"normal\") and quote the database identifier (column name)\r\n # \"colPos\" (indicated by wrapping with {#})\r\n where = {#colPos}=0\r\n}\r\n\r\n# For every result line from the database query (that means for every content\r\n# element) the renderObj is executed and the internal data array is filled\r\n# with the content. This ensures that we can call the .field property and we\r\n# get the according value.\r\npage.10.renderObj = COA\r\npage.10.renderObj {\r\n\r\n 10 = TEXT\r\n\r\n # The field tt_content.header normally holds the headline.\r\n 10.stdWrap.field = header\r\n\r\n 10.stdWrap.wrap = <h1>|</h1>\r\n\r\n 20 = TEXT\r\n\r\n # The field tt_content.bodytext holds the content text.\r\n 20.stdWrap.field = bodytext\r\n\r\n 20.stdWrap.wrap = <p>|</p>\r\n}', NULL, 0, 0, 0);
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Tabellenstruktur für Tabelle `tt_content`
|
|
--
|
|
|
|
CREATE TABLE `tt_content` (
|
|
`uid` int(10) UNSIGNED NOT NULL,
|
|
`rowDescription` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`pid` int(11) NOT NULL DEFAULT 0,
|
|
`tstamp` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`crdate` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`cruser_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`deleted` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`hidden` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`starttime` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`endtime` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`fe_group` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
|
|
`sorting` int(11) NOT NULL DEFAULT 0,
|
|
`editlock` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`sys_language_uid` int(11) NOT NULL DEFAULT 0,
|
|
`l18n_parent` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`l10n_source` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`l10n_state` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`t3_origuid` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`l18n_diffsource` mediumblob DEFAULT NULL,
|
|
`t3ver_oid` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`t3ver_wsid` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`t3ver_state` smallint(6) NOT NULL DEFAULT 0,
|
|
`t3ver_stage` int(11) NOT NULL DEFAULT 0,
|
|
`CType` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`header` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`header_position` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`bodytext` mediumtext COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`bullets_type` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`uploads_description` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`uploads_type` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`assets` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`image` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`imagewidth` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`imageorient` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`imagecols` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`imageborder` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`media` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`layout` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`frame_class` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',
|
|
`cols` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`space_before_class` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`space_after_class` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`records` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`pages` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`colPos` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`subheader` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`header_link` varchar(1024) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`image_zoom` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`header_layout` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
|
|
`list_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`sectionIndex` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`linkToTop` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`file_collections` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`filelink_size` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`filelink_sorting` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`filelink_sorting_direction` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`target` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`date` int(11) NOT NULL DEFAULT 0,
|
|
`recursive` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`imageheight` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`pi_flexform` mediumtext COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`accessibility_title` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`accessibility_bypass` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`accessibility_bypass_text` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`category_field` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`table_class` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
|
`table_caption` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`table_delimiter` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`table_enclosure` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`table_header_position` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`table_tfoot` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
|
|
`categories` int(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
`selected_categories` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
|
|
`tx_impexp_origuid` int(11) NOT NULL DEFAULT 0
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
|
|
--
|
|
-- Daten für Tabelle `tt_content`
|
|
--
|
|
|
|
INSERT INTO `tt_content` (`uid`, `rowDescription`, `pid`, `tstamp`, `crdate`, `cruser_id`, `deleted`, `hidden`, `starttime`, `endtime`, `fe_group`, `sorting`, `editlock`, `sys_language_uid`, `l18n_parent`, `l10n_source`, `l10n_state`, `t3_origuid`, `l18n_diffsource`, `t3ver_oid`, `t3ver_wsid`, `t3ver_state`, `t3ver_stage`, `CType`, `header`, `header_position`, `bodytext`, `bullets_type`, `uploads_description`, `uploads_type`, `assets`, `image`, `imagewidth`, `imageorient`, `imagecols`, `imageborder`, `media`, `layout`, `frame_class`, `cols`, `space_before_class`, `space_after_class`, `records`, `pages`, `colPos`, `subheader`, `header_link`, `image_zoom`, `header_layout`, `list_type`, `sectionIndex`, `linkToTop`, `file_collections`, `filelink_size`, `filelink_sorting`, `filelink_sorting_direction`, `target`, `date`, `recursive`, `imageheight`, `pi_flexform`, `accessibility_title`, `accessibility_bypass`, `accessibility_bypass_text`, `category_field`, `table_class`, `table_caption`, `table_delimiter`, `table_enclosure`, `table_header_position`, `table_tfoot`, `categories`, `selected_categories`, `tx_impexp_origuid`) VALUES
|
|
(1, '', 1, 1652353153, 1652352481, 1, 0, 0, 0, 0, '', 256, 0, 0, 0, 0, NULL, 0, 0x7b224354797065223a22222c22636f6c506f73223a22222c22686561646572223a22222c226865616465725f6c61796f7574223a22222c226865616465725f706f736974696f6e223a22222c2264617465223a22222c226865616465725f6c696e6b223a22222c22737562686561646572223a22222c22626f647974657874223a22222c22617373657473223a22222c22696d6167657769647468223a22222c22696d616765686569676874223a22222c22696d616765626f72646572223a22222c22696d6167656f7269656e74223a22222c22696d616765636f6c73223a22222c22696d6167655f7a6f6f6d223a22222c226c61796f7574223a22222c226672616d655f636c617373223a22222c2273706163655f6265666f72655f636c617373223a22222c2273706163655f61667465725f636c617373223a22222c2273656374696f6e496e646578223a22222c226c696e6b546f546f70223a22222c227379735f6c616e67756167655f756964223a22222c2268696464656e223a22222c22737461727474696d65223a22222c22656e6474696d65223a22222c2266655f67726f7570223a22222c22656469746c6f636b223a22222c2263617465676f72696573223a22222c22726f774465736372697074696f6e223a22227d, 0, 0, 0, 0, 'textmedia', 'Initial created as Header Element and switched to Text & Media after translation', '', '<p>Default Lang Text</p>', 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, 124, 0, 0, 0, 0, NULL, 0),
|
|
(2, '', 1, 1652353074, 1652353005, 1, 0, 0, 0, 0, '', 512, 0, 1, 1, 1, NULL, 1, 0x7b2268696464656e223a2230222c22737461727474696d65223a2230222c22656e6474696d65223a2230222c224354797065223a22746578746d65646961222c22636f6c506f73223a2230222c22686561646572223a2248656164657220456c656d656e74222c226865616465725f6c61796f7574223a2230222c226865616465725f706f736974696f6e223a22222c2264617465223a2230222c226865616465725f6c696e6b223a22222c22737562686561646572223a22222c226c61796f7574223a2230222c226672616d655f636c617373223a2264656661756c74222c2273706163655f6265666f72655f636c617373223a22222c2273706163655f61667465725f636c617373223a22222c2273656374696f6e496e646578223a2231222c226c696e6b546f546f70223a2230222c227379735f6c616e67756167655f756964223a2230222c226c31386e5f706172656e74223a2230222c2266655f67726f7570223a22222c22656469746c6f636b223a2230222c2263617465676f72696573223a2230222c22726f774465736372697074696f6e223a22222c22626f647974657874223a223c703e44656661756c74204c616e6720546578743c5c2f703e222c22617373657473223a2230222c22696d6167657769647468223a2230222c22696d616765686569676874223a2230222c22696d616765626f72646572223a2230222c22696d6167656f7269656e74223a2230222c22696d616765636f6c73223a2232222c22696d6167655f7a6f6f6d223a2230227d, 0, 0, 0, 0, 'textmedia', 'Header Element DE', '', 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);
|
|
|
|
--
|
|
-- Indizes der exportierten Tabellen
|
|
--
|
|
|
|
--
|
|
-- Indizes für die Tabelle `pages`
|
|
--
|
|
ALTER TABLE `pages`
|
|
ADD PRIMARY KEY (`uid`),
|
|
ADD KEY `determineSiteRoot` (`is_siteroot`),
|
|
ADD KEY `language_identifier` (`l10n_parent`,`sys_language_uid`),
|
|
ADD KEY `slug` (`slug`(127)),
|
|
ADD KEY `parent` (`pid`,`deleted`,`hidden`),
|
|
ADD KEY `translation_source` (`l10n_source`),
|
|
ADD KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `sys_template`
|
|
--
|
|
ALTER TABLE `sys_template`
|
|
ADD PRIMARY KEY (`uid`),
|
|
ADD KEY `roottemplate` (`deleted`,`hidden`,`root`),
|
|
ADD KEY `parent` (`pid`,`deleted`,`hidden`),
|
|
ADD KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`);
|
|
|
|
--
|
|
-- Indizes für die Tabelle `tt_content`
|
|
--
|
|
ALTER TABLE `tt_content`
|
|
ADD PRIMARY KEY (`uid`),
|
|
ADD KEY `parent` (`pid`,`sorting`),
|
|
ADD KEY `t3ver_oid` (`t3ver_oid`,`t3ver_wsid`),
|
|
ADD KEY `language` (`l18n_parent`,`sys_language_uid`),
|
|
ADD KEY `translation_source` (`l10n_source`);
|
|
|
|
--
|
|
-- AUTO_INCREMENT für exportierte Tabellen
|
|
--
|
|
|
|
--
|
|
-- AUTO_INCREMENT für Tabelle `pages`
|
|
--
|
|
ALTER TABLE `pages`
|
|
MODIFY `uid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
|
|
|
|
--
|
|
-- AUTO_INCREMENT für Tabelle `sys_template`
|
|
--
|
|
ALTER TABLE `sys_template`
|
|
MODIFY `uid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
|
|
|
|
--
|
|
-- AUTO_INCREMENT für Tabelle `tt_content`
|
|
--
|
|
ALTER TABLE `tt_content`
|
|
MODIFY `uid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
|
|
COMMIT;
|
|
|
|
/*!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 */;
|