-- Generated by the Contao Open Source CMS Backup Manager (version: v1).
-- Generated at 2026-01-01T00:00:00+00:00
-- BEGIN STRUCTURE tl_article
CREATE TABLE `tl_article` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `pid` INT UNSIGNED DEFAULT 0 NOT NULL, `sorting` INT UNSIGNED DEFAULT 0 NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `title` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `alias` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, `author` INT UNSIGNED DEFAULT 0 NOT NULL, `inColumn` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT 'main' NOT NULL COLLATE `utf8mb4_unicode_ci`, `showTeaser` TINYINT DEFAULT 0 NOT NULL, `teaserCssID` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `teaser` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `printable` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `customTpl` VARCHAR(64) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `protected` TINYINT DEFAULT 0 NOT NULL, `groups` BLOB DEFAULT NULL, `cssID` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `published` TINYINT DEFAULT 0 NOT NULL, `start` VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `stop` VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, INDEX `alias` (`alias`), INDEX `pid_published_incolumn_start_stop` (`pid`, `published`, `inColumn`, `start`, `stop`), INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_article
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (1, 2, 128, 1676907541, 'Home', 'index', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', NULL, '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:5:\"grid6\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (2, 14, 128, 1195922456, 'Search', 'search', 1, 'main', 0, '', NULL, '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (9, 8, 128, 1358693051, 'News', 'news', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', NULL, '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (11, 18, 128, 1195926210, 'Confirmation', 'confirmation', 1, 'main', 0, '', NULL, '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (12, 43, 64, 1359898373, 'My account', 'my-account', 1, 'main', 0, '', NULL, '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (13, 16, 128, 1195841130, 'Not authenticated', 'not-authenticated', 1, 'main', 0, '', NULL, '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (14, 12, 128, 1195928016, 'Your data has been saved', 'your-data-has-been-saved', 1, 'main', 0, '', NULL, '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');

INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (19, 59, 256, 1400775369, 'Calendar', 'calendar', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', '', '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (30, 28, 128, 1349187402, 'Header Top', 'header-top', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', NULL, '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (34, 32, 128, 1349272455, 'Sitemap', 'sitemap', 1, 'main', 0, '', NULL, '', '', 0, NULL, '', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (36, 34, 128, 1349272508, 'Login', 'login-34', 1, 'main', 0, '', NULL, '', '', 0, NULL, '', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (37, 2, 256, 1676907557, 'FE and BE Login', 'fe-and-be-login', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', NULL, '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (38, 2, 64, 1676907558, 'Slider', 'slider', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', NULL, '', '', 0, NULL, 'a:2:{i:0;s:20:\"header-image-wrapper\";i:1;s:12:\"header-image\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (50, 28, 256, 1359204835, 'Footer', 'Footer', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', NULL, '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (52, 41, 128, 1737291696, 'Feed Reader', 'feed-reader', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', NULL, '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (59, 45, 128, 1360274200, 'Newsletter item', 'newsletter-item', 1, 'main', 0, '', NULL, '', '', 0, NULL, '', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (63, 48, 128, 1767374560, 'Content Elements', 'content-elements', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', '<p>The article explains the different types of content elements and this is just the corresponding article teaser.</p>', '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (64, 49, 128, 1366742599, 'Modules', 'modules', 1, 'main', 0, '', NULL, '', '', 0, NULL, '', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (65, 50, 128, 1366742625, 'About Contao', 'about-contao', 1, 'main', 0, '', NULL, '', '', 0, NULL, '', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (66, 51, 128, 1366742718, 'Text elements', 'text-elements', 1, 'main', 0, '', NULL, '', '', 0, NULL, '', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (67, 52, 128, 1423514963, 'Accordion', 'accordion', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', NULL, '', '', 0, NULL, 'a:2:{i:0;s:17:\"accordion-element\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (68, 53, 128, 1401089993, 'Content slider', 'content-slider', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', '', '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:10:\"sliderdemo\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (69, 54, 128, 1367243721, 'Link elements', 'link-elements', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', '', '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (70, 55, 128, 1367243750, 'Media elements', 'media-elements', 1, 'main', 0, '', NULL, '', '', 0, NULL, '', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (71, 56, 128, 1367243750, 'File elements', 'file-elements', 1, 'main', 0, '', NULL, '', '', 0, NULL, '', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (72, 57, 128, 1367243751, 'Include elements', 'include-elements', 1, 'main', 0, '', NULL, '', '', 0, NULL, '', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (73, 58, 128, 1367245749, 'News', 'news-2', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', '', '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (75, 60, 128, 1367244336, 'FAQ', 'faq-60', 1, 'main', 0, '', NULL, '', '', 0, NULL, '', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (76, 61, 128, 1366743198, 'Newsletter', 'newsletter-61', 1, 'main', 0, '', NULL, '', '', 0, NULL, '', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (77, 62, 128, 1400063803, 'Appliction examples', 'appliction-examples', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', NULL, '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (79, 64, 128, 1422920610, 'User', 'user', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', NULL, '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (80, 66, 128, 1366743380, 'Miscellaneous', 'miscellaneous', 1, 'main', 0, '', NULL, '', '', 0, NULL, '', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (81, 63, 256, 1366743484, 'Navigation', 'navigation-81', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', '', '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (82, 67, 128, 1367401087, 'Members Area', 'members-area', 1, 'main', 0, '', NULL, '', '', 0, NULL, '', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (86, 70, 128, 1680605303, 'Event Detail', 'event-detail', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', NULL, 'a:4:{i:0;s:5:\"print\";i:1;s:8:\"facebook\";i:2;s:7:\"twitter\";i:3;s:5:\"gplus\";}', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (87, 19, 128, 1680604618, 'Page not found', 'page-not-found', 1, 'main', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', NULL, '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (88, 71, 128, 1645136504, 'Service unavailable', '', 1, 'main', 0, '', NULL, '', '', 0, NULL, '', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (89, 2, 384, 1676907558, 'Prefooter', 'prefooter', 1, 'prefooter', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', NULL, '', '', 0, NULL, 'a:2:{i:0;s:0:\"\";i:1;s:9:\"prefooter\";}', 1, '', '');
INSERT INTO `tl_article` (`id`, `pid`, `sorting`, `tstamp`, `title`, `alias`, `author`, `inColumn`, `showTeaser`, `teaserCssID`, `teaser`, `printable`, `customTpl`, `protected`, `groups`, `cssID`, `published`, `start`, `stop`) VALUES (91, 73, 128, 1738501799, 'Element group', 'content-elements-element-group', 1, 'main', 0, '', NULL, '', '', 0, NULL, '', 1, '', '');
-- BEGIN STRUCTURE tl_calendar
CREATE TABLE `tl_calendar` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `title` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `jumpTo` INT UNSIGNED DEFAULT 0 NOT NULL, `protected` TINYINT DEFAULT 0 NOT NULL, `groups` BLOB DEFAULT NULL, `allowComments` TINYINT DEFAULT 0 NOT NULL, `notify` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT 'notify_admin' NOT NULL COLLATE `utf8mb4_unicode_ci`, `sortOrder` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT 'ascending' NOT NULL COLLATE `utf8mb4_unicode_ci`, `perPage` SMALLINT UNSIGNED DEFAULT 0 NOT NULL, `moderate` TINYINT DEFAULT 0 NOT NULL, `bbcode` TINYINT DEFAULT 0 NOT NULL, `requireLogin` TINYINT DEFAULT 0 NOT NULL, `disableCaptcha` TINYINT DEFAULT 0 NOT NULL, INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_calendar
INSERT INTO `tl_calendar` (`id`, `tstamp`, `title`, `jumpTo`, `protected`, `groups`, `allowComments`, `notify`, `sortOrder`, `perPage`, `moderate`, `bbcode`, `requireLogin`, `disableCaptcha`) VALUES (3, 1697114618, 'Contao Example Events', 70, 0, 'a:1:{i:0;s:1:\"2\";}', 0, '', '', 0, 0, 0, 0, 0);
-- BEGIN STRUCTURE tl_calendar_events
CREATE TABLE `tl_calendar_events` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `pid` INT UNSIGNED DEFAULT 0 NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `title` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `featured` TINYINT DEFAULT 0 NOT NULL, `alias` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, `author` INT UNSIGNED DEFAULT 0 NOT NULL, `addTime` TINYINT DEFAULT 0 NOT NULL, `startTime` BIGINT DEFAULT NULL, `endTime` BIGINT DEFAULT NULL, `startDate` BIGINT DEFAULT NULL, `endDate` BIGINT DEFAULT NULL, `pageTitle` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `robots` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `description` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `location` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `address` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `teaser` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `addImage` TINYINT DEFAULT 0 NOT NULL, `overwriteMeta` TINYINT DEFAULT 0 NOT NULL, `singleSRC` BINARY(16) DEFAULT NULL, `alt` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `imageTitle` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `size` VARCHAR(255) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`, `imageUrl` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `fullsize` TINYINT DEFAULT 0 NOT NULL, `caption` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `floating` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT 'above' NOT NULL COLLATE `utf8mb4_unicode_ci`, `recurring` TINYINT DEFAULT 0 NOT NULL, `repeatEach` VARCHAR(64) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `repeatEnd` INT UNSIGNED DEFAULT 0 NOT NULL, `recurrences` SMALLINT UNSIGNED DEFAULT 0 NOT NULL, `addEnclosure` TINYINT DEFAULT 0 NOT NULL, `enclosure` BLOB DEFAULT NULL, `source` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT 'default' NOT NULL COLLATE `utf8mb4_unicode_ci`, `jumpTo` INT UNSIGNED DEFAULT 0 NOT NULL, `articleId` INT UNSIGNED DEFAULT 0 NOT NULL, `url` VARCHAR(2048) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `target` TINYINT DEFAULT 0 NOT NULL, `cssClass` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `noComments` TINYINT DEFAULT 0 NOT NULL, `published` TINYINT DEFAULT 0 NOT NULL, `start` VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `stop` VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `linkText` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `canonicalLink` VARCHAR(2048) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `searchIndexer` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, INDEX `alias` (`alias`), INDEX `pid_published_featured_start_stop` (`pid`, `published`, `featured`, `start`, `stop`), INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_calendar_events
INSERT INTO `tl_calendar_events` (`id`, `pid`, `tstamp`, `title`, `featured`, `alias`, `author`, `addTime`, `startTime`, `endTime`, `startDate`, `endDate`, `pageTitle`, `robots`, `description`, `location`, `address`, `teaser`, `addImage`, `overwriteMeta`, `singleSRC`, `alt`, `imageTitle`, `size`, `imageUrl`, `fullsize`, `caption`, `floating`, `recurring`, `repeatEach`, `repeatEnd`, `recurrences`, `addEnclosure`, `enclosure`, `source`, `jumpTo`, `articleId`, `url`, `target`, `cssClass`, `noComments`, `published`, `start`, `stop`, `linkText`, `canonicalLink`, `searchIndexer`) VALUES (5, 3, 1697114643, 'Contao Example Event', 0, 'contao-example-event', 1, 1, '1691481600', '1691607600', '1691452800', '1691539200', '', '', NULL, '', '', '<p>Save the Date for this example event!</p>', 0, 0, 0x00000000000000000000000000000000, '', '', '', '', 0, '', '', 1, 'a:2:{s:4:\"unit\";s:5:\"years\";s:5:\"value\";s:1:\"1\";}', 4294967295, 0, 0, '', 'default', 0, 0, '', 0, '', 0, 1, '', '', '', '', '');
INSERT INTO `tl_calendar_events` (`id`, `pid`, `tstamp`, `title`, `featured`, `alias`, `author`, `addTime`, `startTime`, `endTime`, `startDate`, `endDate`, `pageTitle`, `robots`, `description`, `location`, `address`, `teaser`, `addImage`, `overwriteMeta`, `singleSRC`, `alt`, `imageTitle`, `size`, `imageUrl`, `fullsize`, `caption`, `floating`, `recurring`, `repeatEach`, `repeatEnd`, `recurrences`, `addEnclosure`, `enclosure`, `source`, `jumpTo`, `articleId`, `url`, `target`, `cssClass`, `noComments`, `published`, `start`, `stop`, `linkText`, `canonicalLink`, `searchIndexer`) VALUES (6, 3, 1697114370, 'Contao North-Day', 0, 'contao-north-day', 1, 0, '1517011200', '1517097599', '1517011200', NULL, '', '', NULL, '', '', '<p>The Contao North-Day is an event dedicated to Contao users, developers and supportes situated in the north of Germany. The event started in 2013 and takes place in Hamburg. In a series of presentations participants get the chance to learn from first hand experience from experts of varying fields and to expand their horizons in the website development context. &nbsp;</p>', 0, 0, 0x00000000000000000000000000000000, '', '', '', '', 0, '', '', 1, 'a:2:{s:4:\"unit\";s:5:\"years\";s:5:\"value\";s:1:\"1\";}', 4294967295, 0, 0, '', 'external', 0, 0, 'https://2018.nordtag.contao.org/', 1, '', 0, 1, '', '', '', '', '');
INSERT INTO `tl_calendar_events` (`id`, `pid`, `tstamp`, `title`, `featured`, `alias`, `author`, `addTime`, `startTime`, `endTime`, `startDate`, `endDate`, `pageTitle`, `robots`, `description`, `location`, `address`, `teaser`, `addImage`, `overwriteMeta`, `singleSRC`, `alt`, `imageTitle`, `size`, `imageUrl`, `fullsize`, `caption`, `floating`, `recurring`, `repeatEach`, `repeatEnd`, `recurrences`, `addEnclosure`, `enclosure`, `source`, `jumpTo`, `articleId`, `url`, `target`, `cssClass`, `noComments`, `published`, `start`, `stop`, `linkText`, `canonicalLink`, `searchIndexer`) VALUES (7, 3, 1697114265, 'Annual Contao Conference', 0, 'annual-contao-conference', 1, 0, '1697328000', '1697414399', '1697328000', NULL, '', 'index,follow', NULL, 'changing locations all over europe', 'address: see actual conference location', '<p>The official Contao Conference had its debut in 2011 and has been held each year since. During the 2-day event developers, users and supporters meet up to attain workshops and presentations, share knowledge and to network.</p>', 0, 0, 0x00000000000000000000000000000000, '', '', '', '', 0, '', '', 1, 'a:2:{s:4:\"unit\";s:5:\"years\";s:5:\"value\";s:1:\"1\";}', 4294967295, 0, 0, '', 'default', 0, 0, '', 0, '', 0, 1, '', '', '', '', '');
INSERT INTO `tl_calendar_events` (`id`, `pid`, `tstamp`, `title`, `featured`, `alias`, `author`, `addTime`, `startTime`, `endTime`, `startDate`, `endDate`, `pageTitle`, `robots`, `description`, `location`, `address`, `teaser`, `addImage`, `overwriteMeta`, `singleSRC`, `alt`, `imageTitle`, `size`, `imageUrl`, `fullsize`, `caption`, `floating`, `recurring`, `repeatEach`, `repeatEnd`, `recurrences`, `addEnclosure`, `enclosure`, `source`, `jumpTo`, `articleId`, `url`, `target`, `cssClass`, `noComments`, `published`, `start`, `stop`, `linkText`, `canonicalLink`, `searchIndexer`) VALUES (8, 3, 1697114548, 'Contao Camp', 0, 'contao-camp-2023', 1, 0, '1683331200', '1683503999', '1683331200', '1683417600', '', '', NULL, '', '', '<p>The Contao Camp 2023 takes place in Regensburg, Germany.</p>', 0, 0, 0x00000000000000000000000000000000, '', '', '', '', 0, '', '', 1, 'a:2:{s:4:\"unit\";s:5:\"years\";s:5:\"value\";s:1:\"1\";}', 4294967295, 0, 0, '', 'default', 0, 0, '', 0, '', 0, 1, '', '', '', '', '');
-- BEGIN STRUCTURE tl_calendar_feed
CREATE TABLE `tl_calendar_feed` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `title` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `alias` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, `language` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `calendars` BLOB DEFAULT NULL, `format` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT 'rss' NOT NULL COLLATE `utf8mb4_unicode_ci`, `source` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT 'source_teaser' NOT NULL COLLATE `utf8mb4_unicode_ci`, `maxItems` SMALLINT UNSIGNED DEFAULT 25 NOT NULL, `feedBase` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `description` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `imgSize` VARCHAR(255) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`, INDEX `alias` (`alias`), INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_calendar_feed
-- BEGIN STRUCTURE tl_comments
CREATE TABLE `tl_comments` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `source` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `parent` INT UNSIGNED DEFAULT 0 NOT NULL, `date` VARCHAR(64) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `name` VARCHAR(64) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `email` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `website` VARCHAR(128) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `member` INT UNSIGNED DEFAULT 0 NOT NULL, `comment` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `addReply` TINYINT DEFAULT 0 NOT NULL, `author` INT UNSIGNED DEFAULT 0 NOT NULL, `reply` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `published` TINYINT DEFAULT 0 NOT NULL, `ip` VARCHAR(64) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `notified` TINYINT DEFAULT 0 NOT NULL, `notifiedReply` TINYINT DEFAULT 0 NOT NULL, INDEX `published` (`published`), INDEX `source_parent_published` (`source`, `parent`, `published`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_comments
INSERT INTO `tl_comments` (`id`, `tstamp`, `source`, `parent`, `date`, `name`, `email`, `website`, `member`, `comment`, `addReply`, `author`, `reply`, `published`, `ip`, `notified`, `notifiedReply`) VALUES (1, 1359896156, 'tl_news', 1, '1676228000', 'John Smith', 'j.smith@example.com', '', 0, '<p>It is great to have him back!<br> He is the best!</p>', 1, 1, '<p>Thanks a lot, John. I am happy to be back.</p>', 1, '127.0.0.1', 0, 0);
INSERT INTO `tl_comments` (`id`, `tstamp`, `source`, `parent`, `date`, `name`, `email`, `website`, `member`, `comment`, `addReply`, `author`, `reply`, `published`, `ip`, `notified`, `notifiedReply`) VALUES (2, 1401000352, 'tl_content', 310, '1676228020', 'comment author', 'fake@mail.de', '', 0, '<p>This is a single short comment in the comment system.</p>', 1, 1, '<p>And here is a short answer from an admin as reaction of the comment</p>', 1, '77.20.148.0', 0, 0);
INSERT INTO `tl_comments` (`id`, `tstamp`, `source`, `parent`, `date`, `name`, `email`, `website`, `member`, `comment`, `addReply`, `author`, `reply`, `published`, `ip`, `notified`, `notifiedReply`) VALUES (3, 1680612477, 'tl_news', 7, '1676228050', 'Guest', 'guest@example.org', '', 0, '<p>This is an example news comment.</p>', 1, 1, '<p>This is an example news reply from kevin jones.</p>', 1, '77.189.38.0', 1, 1);
INSERT INTO `tl_comments` (`id`, `tstamp`, `source`, `parent`, `date`, `name`, `email`, `website`, `member`, `comment`, `addReply`, `author`, `reply`, `published`, `ip`, `notified`, `notifiedReply`) VALUES (4, 1676228095, 'tl_news', 7, '1676228095', 'Tester', 'fake@email.co', '', 0, '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Urna lectus velit odio nibh lacus, odio nunc elementum, tortor. Cursus congue habitant ipsum, commodo mattis mauris sit urna dui. Vel auctor in aliquam in cursus fermentum elit sit elit. Velit placerat scelerisque feugiat ut imperdiet enim sollicitudin lectus. Mauris amet, ac vitae et pellentesque eget feugiat hac. Amet posuere tempus pharetra, hendrerit morbi dictum adipiscing.<br>Ullamcorper rhoncus, massa urna scelerisque arcu mattis eget. Risus scelerisque posuere egestas eros sit amet, posuere. Quis platea venenatis, et arcu consequat justo, nunc eu. Facilisi molestie ultrices aliquet facilisis sapien, diam. Tempor ipsum, quis non faucibus venenatis non laoreet elit purus. Amet massa morbi praesent aliquam integer ut.   Tortor et, eget eget sem elit tempor. Volutpat eget lacus, sagittis in. Blandit volutpat neque senectus arcu a semper. Porta auctor quisque pellentesque euismod elementum. Diam non proin duis nunc. Ullamcorper nisl at odio semper facilisis pellentesque lacinia. Eget aliquam urna sit quis.  Tincidunt dictum enim ac tellus id imperdiet sapien. At ultrices in mi turpis sed. Habitasse tincidunt sit est eget vulputate egestas. Tincidunt porttitor egestas diam et a semper. Ut magna ipsum, tempor lorem porttitor. Diam duis velit sit commodo hendrerit dignissim duis morbi. Maecenas pharetra gravida tortor, consequat integer faucibus urna in semper. Hendrerit turpis consectetur tellus massa porta nisi, sit nunc in. Blandit maecenas phasellus amet nibh. Maecenas aliquam enim risus, consectetur mi. Quam eget leo egestas mauris eu non eget tincidunt. Fusce fusce malesuada vel diam, id pellentesque magnis viverra tincidunt. Venenatis mattis libero integer amet. Nisl sed sagittis vulputate vestibulum consectetur.</p>', 0, 1, NULL, 1, '77.20.141.31', 1, 0);
-- BEGIN STRUCTURE tl_comments_notify
CREATE TABLE `tl_comments_notify` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `source` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `parent` INT UNSIGNED DEFAULT 0 NOT NULL, `name` VARCHAR(128) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `email` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `url` VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`, `addedOn` VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `active` TINYINT DEFAULT 0 NOT NULL, `tokenRemove` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, INDEX `source_parent_active_email` (`source`, `parent`, `active`, `email`), INDEX `tokenremove` (`tokenRemove`), INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN STRUCTURE tl_faq
CREATE TABLE `tl_faq` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `pid` INT UNSIGNED DEFAULT 0 NOT NULL, `sorting` INT UNSIGNED DEFAULT 0 NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `question` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `alias` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, `author` INT UNSIGNED DEFAULT 0 NOT NULL, `answer` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `pageTitle` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `robots` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `description` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `addImage` TINYINT DEFAULT 0 NOT NULL, `overwriteMeta` TINYINT DEFAULT 0 NOT NULL, `singleSRC` BINARY(16) DEFAULT NULL, `alt` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `imageTitle` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `size` VARCHAR(255) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`, `imageUrl` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `fullsize` TINYINT DEFAULT 0 NOT NULL, `caption` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `floating` VARCHAR(12) CHARACTER SET utf8mb4 DEFAULT 'above' NOT NULL COLLATE `utf8mb4_unicode_ci`, `addEnclosure` TINYINT DEFAULT 0 NOT NULL, `enclosure` BLOB DEFAULT NULL, `noComments` TINYINT DEFAULT 0 NOT NULL, `published` TINYINT DEFAULT 0 NOT NULL, `searchIndexer` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, INDEX `pid_published` (`pid`, `published`), INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_faq
INSERT INTO `tl_faq` (`id`, `pid`, `sorting`, `tstamp`, `question`, `alias`, `author`, `answer`, `pageTitle`, `robots`, `description`, `addImage`, `overwriteMeta`, `singleSRC`, `alt`, `imageTitle`, `size`, `imageUrl`, `fullsize`, `caption`, `floating`, `addEnclosure`, `enclosure`, `noComments`, `published`, `searchIndexer`) VALUES (1, 3, 32, 1401260984, 'Do your users have any questions?', 'are-there-exams-how-do-they-work', 1, '<p>To display the FAQ on your website you can choose from three modules in the Contao back-end. Those offer the possibility to configure the output of your frequently asked questions in various ways.</p>\n<ul>\n<li>FAQ - List</li>\n<li>FAQ - Reader</li>\n<li>FAQ - Page</li>\n</ul>\n<p>The FAQ - List is a frontend module that lets you&nbsp;list your questions and answers from chosen categories. Only the title question and a link to the FAQ - Reader (which needs to be placed on a secondary site) are&nbsp;displayed. It might be a good option to choose this ouput if you have a longer list of questions.</p>\n<p>Another way to display information to the visitors is the FAQ - Page module. This module lists all your questions and answers on one page. Linking to another site is not necessary and therefore it is recommanded if you want to show just a few questions and keep all the information on one site. With a little additional code in the mod_faqpage.html5 template you can easily integrate a&nbsp;javascript&nbsp;accordion which will improve the usability of your FAQ greatly for your visitors.</p>', '', '', NULL, 0, 0, 0x00000000000000000000000000000000, '', '', '', '', 0, '', '', 0, NULL, 0, 1, '');
INSERT INTO `tl_faq` (`id`, `pid`, `sorting`, `tstamp`, `question`, `alias`, `author`, `answer`, `pageTitle`, `robots`, `description`, `addImage`, `overwriteMeta`, `singleSRC`, `alt`, `imageTitle`, `size`, `imageUrl`, `fullsize`, `caption`, `floating`, `addEnclosure`, `enclosure`, `noComments`, `published`, `searchIndexer`) VALUES (2, 3, 256, 1400845554, 'You want to hear the opinions of the website members?', 'can-i-participate-in-courses-on-a-mobile-device', 1, '<p>The FAQ also enable you to manage comments. With the tick on the checkbox \"Enable comments\"in your FAQ category configuration you allow your visitors to leave comments on your FAQs. Different options are integrated to fit your needs regarding the workflow of submitted comments.</p>\n<ul>\n<li>Moderate comments</li>\n<li>Get notified when a comment is posted (you can notify the System administrator, the author of the FAQ or both)</li>\n<li>Set the ordering and the \"Comments per page\", which automatically creates a pagination</li>\n<li>Allow your visitors to use BBCode within the comment field</li>\n</ul>', '', '', NULL, 0, 0, 0x00000000000000000000000000000000, '', '', '', '', 0, '', '', 0, NULL, 0, 1, '');
INSERT INTO `tl_faq` (`id`, `pid`, `sorting`, `tstamp`, `question`, `alias`, `author`, `answer`, `pageTitle`, `robots`, `description`, `addImage`, `overwriteMeta`, `singleSRC`, `alt`, `imageTitle`, `size`, `imageUrl`, `fullsize`, `caption`, `floating`, `addEnclosure`, `enclosure`, `noComments`, `published`, `searchIndexer`) VALUES (4, 3, 64, 1400845518, 'You have to answer the same over and over?', 'can-i-join-a-course-after-it-has-started', 1, '<p>Every single question and answer allows you to display a title question and a text (of course). You can also add an image and/or an enclosure next to your FAQ item. The predefined fields allow you to set an author of the item and lets you choose if you want to publish the item right away or keep it unpublished for the time being.</p>', '', '', NULL, 0, 0, 0x00000000000000000000000000000000, '', '', '', '', 0, '', '', 0, NULL, 0, 1, '');
-- BEGIN STRUCTURE tl_faq_category
CREATE TABLE `tl_faq_category` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `title` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `headline` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `jumpTo` INT UNSIGNED DEFAULT 0 NOT NULL, `allowComments` TINYINT DEFAULT 0 NOT NULL, `notify` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT 'notify_admin' NOT NULL COLLATE `utf8mb4_unicode_ci`, `sortOrder` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT 'ascending' NOT NULL COLLATE `utf8mb4_unicode_ci`, `perPage` SMALLINT UNSIGNED DEFAULT 0 NOT NULL, `moderate` TINYINT DEFAULT 0 NOT NULL, `bbcode` TINYINT DEFAULT 0 NOT NULL, `requireLogin` TINYINT DEFAULT 0 NOT NULL, `disableCaptcha` TINYINT DEFAULT 0 NOT NULL, INDEX `jumpto` (`jumpTo`), INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_faq_category
INSERT INTO `tl_faq_category` (`id`, `tstamp`, `title`, `headline`, `jumpTo`, `allowComments`, `notify`, `sortOrder`, `perPage`, `moderate`, `bbcode`, `requireLogin`, `disableCaptcha`) VALUES (3, 1680598741, 'How FAQs work', 'Example Questions & Answers', 60, 1, 'notify_admin', 'ascending', 0, 0, 0, 0, 0);
-- BEGIN STRUCTURE tl_favorites
CREATE TABLE `tl_favorites` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `pid` INT UNSIGNED DEFAULT 0 NOT NULL, `sorting` INT UNSIGNED DEFAULT 0 NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `user` INT UNSIGNED DEFAULT 0 NOT NULL, `title` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `url` VARCHAR(1022) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, INDEX `pid_user` (`pid`, `user`), INDEX `tstamp` (`tstamp`), INDEX `url` (`url`(768)), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_favorites
INSERT INTO `tl_favorites` (`id`, `pid`, `sorting`, `tstamp`, `user`, `title`, `url`) VALUES (1, 0, 8, 1714033715, 1, 'Official Demo Theme', '/contao?act=edit&do=themes&id=1');
INSERT INTO `tl_favorites` (`id`, `pid`, `sorting`, `tstamp`, `user`, `title`, `url`) VALUES (2, 1, 16, 1714033764, 1, 'Modules', '/contao?do=themes&id=1&table=tl_module');
INSERT INTO `tl_favorites` (`id`, `pid`, `sorting`, `tstamp`, `user`, `title`, `url`) VALUES (3, 1, 24, 1714033768, 1, 'Page layouts', '/contao?do=themes&id=1&table=tl_layout');
INSERT INTO `tl_favorites` (`id`, `pid`, `sorting`, `tstamp`, `user`, `title`, `url`) VALUES (4, 1, 32, 1714033742, 1, 'Image sizes', '/contao?do=themes&id=1&table=tl_image_size');
INSERT INTO `tl_favorites` (`id`, `pid`, `sorting`, `tstamp`, `user`, `title`, `url`) VALUES (5, 1, 8, 1767971504, 1, 'Content elements', '/contao?do=themes&id=1&table=tl_content');
-- BEGIN STRUCTURE tl_form
CREATE TABLE `tl_form` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `title` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `alias` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, `jumpTo` INT UNSIGNED DEFAULT 0 NOT NULL, `sendViaEmail` TINYINT DEFAULT 0 NOT NULL, `mailerTransport` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `recipient` VARCHAR(1022) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `subject` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `format` VARCHAR(12) CHARACTER SET utf8mb4 DEFAULT 'raw' NOT NULL COLLATE `utf8mb4_unicode_ci`, `skipEmpty` TINYINT DEFAULT 0 NOT NULL, `storeValues` TINYINT DEFAULT 0 NOT NULL, `targetTable` VARCHAR(64) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `customTpl` VARCHAR(64) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `method` VARCHAR(12) CHARACTER SET utf8mb4 DEFAULT 'POST' NOT NULL COLLATE `utf8mb4_unicode_ci`, `novalidate` TINYINT DEFAULT 0 NOT NULL, `attributes` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `formID` VARCHAR(64) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `allowTags` TINYINT DEFAULT 0 NOT NULL, `ajax` TINYINT DEFAULT 0 NOT NULL, `confirmation` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `storeSession` TINYINT DEFAULT 0 NOT NULL, INDEX `alias` (`alias`), INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_form
INSERT INTO `tl_form` (`id`, `tstamp`, `title`, `alias`, `jumpTo`, `sendViaEmail`, `mailerTransport`, `recipient`, `subject`, `format`, `skipEmpty`, `storeValues`, `targetTable`, `customTpl`, `method`, `novalidate`, `attributes`, `formID`, `allowTags`, `ajax`, `confirmation`, `storeSession`) VALUES (3, 1358289627, 'Search', 'search', 14, 0, '', '', '', 'raw', 0, 0, '', '', 'GET', 0, 'a:2:{i:0;s:11:\"form-search\";i:1;s:0:\"\";}', '', 0, 0, NULL, 1);
INSERT INTO `tl_form` (`id`, `tstamp`, `title`, `alias`, `jumpTo`, `sendViaEmail`, `mailerTransport`, `recipient`, `subject`, `format`, `skipEmpty`, `storeValues`, `targetTable`, `customTpl`, `method`, `novalidate`, `attributes`, `formID`, `allowTags`, `ajax`, `confirmation`, `storeSession`) VALUES (5, 1676905587, 'Contact', 'contact', 0, 0, '', '', '', 'raw', 0, 0, '', '', 'POST', 0, 'a:2:{i:0;s:0:\"\";i:1;s:0:\"\";}', '', 0, 0, NULL, 1);
-- BEGIN STRUCTURE tl_image_size
CREATE TABLE `tl_image_size` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `pid` INT UNSIGNED DEFAULT 0 NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `name` VARCHAR(64) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `cssClass` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `densities` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `sizes` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `width` INT DEFAULT NULL, `height` INT DEFAULT NULL, `resizeMode` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `zoom` INT DEFAULT NULL, `formats` VARCHAR(1024) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `skipIfDimensionsMatch` TINYINT DEFAULT 0 NOT NULL, `lazyLoading` TINYINT DEFAULT 0 NOT NULL, `imageQuality` INT DEFAULT NULL, `preserveMetadata` VARCHAR(12) CHARACTER SET utf8mb4 DEFAULT 'default' NOT NULL COLLATE `utf8mb4_unicode_ci`, `preserveMetadataFields` BLOB DEFAULT NULL, INDEX `pid` (`pid`), INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_image_size
INSERT INTO `tl_image_size` (`id`, `pid`, `tstamp`, `name`, `cssClass`, `densities`, `sizes`, `width`, `height`, `resizeMode`, `zoom`, `formats`, `skipIfDimensionsMatch`, `lazyLoading`, `imageQuality`, `preserveMetadata`, `preserveMetadataFields`) VALUES (1, 1, 1682583593, 'content image', 'image-size--6-12', '455w, 910w, 1365w, 1820w', '(min-width: 1024px) 50vw, 100vw', 910, NULL, 'proportional', NULL, '', 0, 1, NULL, 'default', NULL);
INSERT INTO `tl_image_size` (`id`, `pid`, `tstamp`, `name`, `cssClass`, `densities`, `sizes`, `width`, `height`, `resizeMode`, `zoom`, `formats`, `skipIfDimensionsMatch`, `lazyLoading`, `imageQuality`, `preserveMetadata`, `preserveMetadataFields`) VALUES (3, 1, 1682583657, 'Hero slider image | 6/12 columns', 'img--full-width', '400w, 800w, 1200w, 1600w', '(min-width: 1024px) 50vw, 100vw', 800, 480, 'crop', NULL, '', 0, 1, NULL, 'default', NULL);
INSERT INTO `tl_image_size` (`id`, `pid`, `tstamp`, `name`, `cssClass`, `densities`, `sizes`, `width`, `height`, `resizeMode`, `zoom`, `formats`, `skipIfDimensionsMatch`, `lazyLoading`, `imageQuality`, `preserveMetadata`, `preserveMetadataFields`) VALUES (5, 1, 1680791309, 'gallery image | 3 / 12', 'img--width-auto', '376w, 564w, 752w, 940w', '(min-width: 480px) 50vw, 100vw', 376, NULL, 'proportional', NULL, '', 0, 1, NULL, 'default', NULL);
-- BEGIN STRUCTURE tl_image_size_item
CREATE TABLE `tl_image_size_item` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `pid` INT UNSIGNED DEFAULT 0 NOT NULL, `sorting` INT UNSIGNED DEFAULT 0 NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `media` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `densities` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `sizes` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `width` INT DEFAULT NULL, `height` INT DEFAULT NULL, `resizeMode` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `zoom` INT DEFAULT NULL, `invisible` TINYINT DEFAULT 0 NOT NULL, INDEX `pid` (`pid`), INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_image_size_item
-- BEGIN STRUCTURE tl_job
CREATE TABLE `tl_job` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `uuid` VARCHAR(36) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `pid` INT UNSIGNED DEFAULT 0 NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `type` VARCHAR(255) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, `owner` INT UNSIGNED DEFAULT 0 NOT NULL, `status` VARCHAR(255) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, `public` TINYINT DEFAULT 0 NOT NULL, `jobData` LONGTEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `createdAt` INT UNSIGNED DEFAULT 0 NOT NULL, INDEX `createdat` (`createdAt`), INDEX `pid_owner_public_status_tstamp` (`pid`, `owner`, `public`, `status`, `tstamp`), INDEX `uuid` (`uuid`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_job
-- BEGIN STRUCTURE tl_layout
CREATE TABLE `tl_layout` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `pid` INT UNSIGNED DEFAULT 0 NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `name` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `rows` VARCHAR(8) CHARACTER SET utf8mb4 DEFAULT '2rwh' NOT NULL COLLATE `utf8mb4_unicode_ci`, `headerHeight` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `footerHeight` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `cols` VARCHAR(8) CHARACTER SET utf8mb4 DEFAULT '2cll' NOT NULL COLLATE `utf8mb4_unicode_ci`, `widthLeft` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `widthRight` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `sections` BLOB DEFAULT NULL, `framework` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT 'a:2:{i:0;s:10:"layout.css";i:1;s:14:"responsive.css";}' NOT NULL COLLATE `utf8mb4_unicode_ci`, `external` BLOB DEFAULT NULL, `combineScripts` TINYINT DEFAULT 1 NOT NULL, `modules` BLOB DEFAULT NULL, `template` VARCHAR(64) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `minifyMarkup` TINYINT DEFAULT 1 NOT NULL, `lightboxSize` VARCHAR(255) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`, `defaultImageDensities` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `viewport` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT 'width=device-width,initial-scale=1.0,shrink-to-fit=no' NOT NULL COLLATE `utf8mb4_unicode_ci`, `titleTag` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `cssClass` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `onload` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `head` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `addJQuery` TINYINT DEFAULT 0 NOT NULL, `jquery` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `addMooTools` TINYINT DEFAULT 0 NOT NULL, `mootools` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `analytics` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `externalJs` BLOB DEFAULT NULL, `scripts` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `script` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `static` TINYINT DEFAULT 0 NOT NULL, `width` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `align` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT 'center' NOT NULL COLLATE `utf8mb4_unicode_ci`, `newsfeeds` BLOB DEFAULT NULL, `calendarfeeds` BLOB DEFAULT NULL, `type` VARCHAR(7) CHARACTER SET utf8mb4 DEFAULT 'default' NOT NULL COLLATE `utf8mb4_unicode_ci`, INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_layout
INSERT INTO `tl_layout` (`id`, `pid`, `tstamp`, `name`, `rows`, `headerHeight`, `footerHeight`, `cols`, `widthLeft`, `widthRight`, `sections`, `framework`, `external`, `combineScripts`, `modules`, `template`, `minifyMarkup`, `lightboxSize`, `defaultImageDensities`, `viewport`, `titleTag`, `cssClass`, `onload`, `head`, `addJQuery`, `jquery`, `addMooTools`, `mootools`, `analytics`, `externalJs`, `scripts`, `script`, `static`, `width`, `align`, `newsfeeds`, `calendarfeeds`, `type`) VALUES (1, 1, 1767980256, '2 columns - default - Sidebar', '3rw', 'a:2:{s:4:\"unit\";s:0:\"\";s:5:\"value\";s:0:\"\";}', 'a:2:{s:4:\"unit\";s:0:\"\";s:5:\"value\";s:0:\"\";}', '2cll', 'a:2:{s:4:\"unit\";s:2:\"px\";s:5:\"value\";s:0:\"\";}', 'a:2:{s:5:\"value\";s:1:\"0\";s:4:\"unit\";s:2:\"px\";}', 'a:1:{i:0;a:4:{s:5:\"title\";s:10:\"sub-header\";s:2:\"id\";s:10:\"sub-header\";s:8:\"template\";s:13:\"block_section\";s:8:\"position\";s:6:\"before\";}}', '', 0x613a313a7b693a303b733a31363a223a067b64797c11ed8c84477216a987a9223b7d, 0, 'a:11:{i:0;a:3:{s:3:\"mod\";s:2:\"23\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:1;a:3:{s:3:\"mod\";s:11:\"content-149\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:2;a:3:{s:3:\"mod\";s:2:\"24\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:3;a:3:{s:3:\"mod\";s:1:\"1\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:4;a:3:{s:3:\"mod\";s:1:\"3\";s:3:\"col\";s:10:\"sub-header\";s:6:\"enable\";s:1:\"1\";}i:5;a:3:{s:3:\"mod\";s:2:\"28\";s:3:\"col\";s:4:\"left\";s:6:\"enable\";s:1:\"1\";}i:6;a:3:{s:3:\"mod\";s:1:\"0\";s:3:\"col\";s:4:\"left\";s:6:\"enable\";s:1:\"1\";}i:7;a:3:{s:3:\"mod\";s:1:\"0\";s:3:\"col\";s:4:\"main\";s:6:\"enable\";s:1:\"1\";}i:8;a:3:{s:3:\"mod\";s:11:\"content-149\";s:3:\"col\";s:6:\"footer\";s:6:\"enable\";s:1:\"1\";}i:9;a:3:{s:3:\"mod\";s:2:\"38\";s:3:\"col\";s:6:\"footer\";s:6:\"enable\";s:1:\"1\";}i:10;a:3:{s:3:\"mod\";s:2:\"64\";s:3:\"col\";s:6:\"footer\";s:6:\"enable\";s:1:\"1\";}}', 'fe_page', 1, 'a:3:{i:0;s:0:\"\";i:1;s:0:\"\";i:2;s:0:\"\";}', '', 'width=device-width,initial-scale=1.0', '', 'layout--2-column', '', NULL, 1, 'a:2:{i:0;s:10:\"j_colorbox\";i:1;s:11:\"j_tablesort\";}', 0, 'a:3:{i:0;s:13:\"moo_accordion\";i:1;s:12:\"moo_mediabox\";i:2;s:10:\"moo_slider\";}', NULL, NULL, 'a:2:{i:0;s:9:\"js_slider\";i:1;s:12:\"js_autofocus\";}', '<script src=\"files/contaodemo/theme/src/js/scripts.js\"></script>\n<script src=\"files/contaodemo/theme/src/js/a11y-nav.js\"></script>\n<script>\n	window.addEventListener(\'load\', () => {\n		new A11yNav({\n			ariaLabels: {\n                \'main\': \'Main menu\',\n                \'expand\': \'Expand menu: \',\n                \'collapse\': \'Collapse menu: \'\n            }\n		});\n	})\n</script>', 0, 'a:2:{s:4:\"unit\";s:2:\"px\";s:5:\"value\";s:4:\"1000\";}', 'center', NULL, NULL, 'default');
INSERT INTO `tl_layout` (`id`, `pid`, `tstamp`, `name`, `rows`, `headerHeight`, `footerHeight`, `cols`, `widthLeft`, `widthRight`, `sections`, `framework`, `external`, `combineScripts`, `modules`, `template`, `minifyMarkup`, `lightboxSize`, `defaultImageDensities`, `viewport`, `titleTag`, `cssClass`, `onload`, `head`, `addJQuery`, `jquery`, `addMooTools`, `mootools`, `analytics`, `externalJs`, `scripts`, `script`, `static`, `width`, `align`, `newsfeeds`, `calendarfeeds`, `type`) VALUES (20, 1, 1767974359, '1 column | start - no breadcrumb', '3rw', 'a:2:{s:4:\"unit\";s:0:\"\";s:5:\"value\";s:0:\"\";}', 'a:2:{s:4:\"unit\";s:0:\"\";s:5:\"value\";s:0:\"\";}', '2cll', 'a:2:{s:4:\"unit\";s:2:\"px\";s:5:\"value\";s:0:\"\";}', 'a:2:{s:5:\"value\";s:1:\"0\";s:4:\"unit\";s:2:\"px\";}', 'a:1:{i:0;a:4:{s:5:\"title\";s:9:\"prefooter\";s:2:\"id\";s:9:\"prefooter\";s:8:\"template\";s:13:\"block_section\";s:8:\"position\";s:5:\"after\";}}', '', 0x613a313a7b693a303b733a31363a223a067b64797c11ed8c84477216a987a9223b7d, 0, 'a:11:{i:0;a:3:{s:3:\"mod\";s:2:\"23\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:1;a:3:{s:3:\"mod\";s:11:\"content-149\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:2;a:3:{s:3:\"mod\";s:2:\"24\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:3;a:3:{s:3:\"mod\";s:1:\"1\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:4;a:3:{s:3:\"mod\";s:2:\"28\";s:3:\"col\";s:4:\"left\";s:6:\"enable\";s:1:\"1\";}i:5;a:3:{s:3:\"mod\";s:1:\"0\";s:3:\"col\";s:4:\"left\";s:6:\"enable\";s:1:\"1\";}i:6;a:3:{s:3:\"mod\";s:1:\"0\";s:3:\"col\";s:4:\"main\";s:6:\"enable\";s:1:\"1\";}i:7;a:3:{s:3:\"mod\";s:1:\"0\";s:3:\"col\";s:9:\"prefooter\";s:6:\"enable\";s:1:\"1\";}i:8;a:3:{s:3:\"mod\";s:11:\"content-149\";s:3:\"col\";s:6:\"footer\";s:6:\"enable\";s:1:\"1\";}i:9;a:3:{s:3:\"mod\";s:2:\"38\";s:3:\"col\";s:6:\"footer\";s:6:\"enable\";s:1:\"1\";}i:10;a:3:{s:3:\"mod\";s:2:\"64\";s:3:\"col\";s:6:\"footer\";s:6:\"enable\";s:1:\"1\";}}', 'fe_page', 1, 'a:3:{i:0;s:0:\"\";i:1;s:0:\"\";i:2;s:0:\"\";}', '', 'width=device-width,initial-scale=1.0', '', 'layout--1-column', '', NULL, 1, 'a:2:{i:0;s:10:\"j_colorbox\";i:1;s:11:\"j_tablesort\";}', 0, 'a:3:{i:0;s:13:\"moo_accordion\";i:1;s:12:\"moo_mediabox\";i:2;s:10:\"moo_slider\";}', NULL, NULL, 'a:2:{i:0;s:9:\"js_slider\";i:1;s:12:\"js_autofocus\";}', '<script src=\"files/contaodemo/theme/src/js/scripts.js\"></script>\n<script src=\"files/contaodemo/theme/src/js/a11y-nav.js\"></script>\n<script>\n	window.addEventListener(\'load\', () => {\n		new A11yNav({\n			ariaLabels: {\n                \'main\': \'Main menu\',\n                \'expand\': \'Expand menu: \',\n                \'collapse\': \'Collapse menu: \'\n            }\n		});\n	})\n</script>', 0, 'a:2:{s:4:\"unit\";s:2:\"px\";s:5:\"value\";s:4:\"1000\";}', 'center', NULL, NULL, 'default');
INSERT INTO `tl_layout` (`id`, `pid`, `tstamp`, `name`, `rows`, `headerHeight`, `footerHeight`, `cols`, `widthLeft`, `widthRight`, `sections`, `framework`, `external`, `combineScripts`, `modules`, `template`, `minifyMarkup`, `lightboxSize`, `defaultImageDensities`, `viewport`, `titleTag`, `cssClass`, `onload`, `head`, `addJQuery`, `jquery`, `addMooTools`, `mootools`, `analytics`, `externalJs`, `scripts`, `script`, `static`, `width`, `align`, `newsfeeds`, `calendarfeeds`, `type`) VALUES (21, 1, 1767980161, '1 column  | 12/12 columns', '3rw', 'a:2:{s:4:\"unit\";s:0:\"\";s:5:\"value\";s:0:\"\";}', 'a:2:{s:4:\"unit\";s:0:\"\";s:5:\"value\";s:0:\"\";}', '2cll', 'a:2:{s:4:\"unit\";s:2:\"px\";s:5:\"value\";s:0:\"\";}', 'a:2:{s:5:\"value\";s:1:\"0\";s:4:\"unit\";s:2:\"px\";}', 'a:1:{i:0;a:4:{s:5:\"title\";s:10:\"sub-header\";s:2:\"id\";s:10:\"sub-header\";s:8:\"template\";s:13:\"block_section\";s:8:\"position\";s:6:\"before\";}}', '', 0x613a313a7b693a303b733a31363a223a067b64797c11ed8c84477216a987a9223b7d, 0, 'a:11:{i:0;a:3:{s:3:\"mod\";s:2:\"23\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:1;a:3:{s:3:\"mod\";s:11:\"content-149\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:2;a:3:{s:3:\"mod\";s:2:\"24\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:3;a:3:{s:3:\"mod\";s:1:\"1\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:4;a:3:{s:3:\"mod\";s:1:\"3\";s:3:\"col\";s:10:\"sub-header\";s:6:\"enable\";s:1:\"1\";}i:5;a:3:{s:3:\"mod\";s:2:\"28\";s:3:\"col\";s:4:\"left\";s:6:\"enable\";s:1:\"1\";}i:6;a:3:{s:3:\"mod\";s:1:\"0\";s:3:\"col\";s:4:\"left\";s:6:\"enable\";s:1:\"1\";}i:7;a:3:{s:3:\"mod\";s:1:\"0\";s:3:\"col\";s:4:\"main\";s:6:\"enable\";s:1:\"1\";}i:8;a:3:{s:3:\"mod\";s:11:\"content-149\";s:3:\"col\";s:6:\"footer\";s:6:\"enable\";s:1:\"1\";}i:9;a:3:{s:3:\"mod\";s:2:\"38\";s:3:\"col\";s:6:\"footer\";s:6:\"enable\";s:1:\"1\";}i:10;a:3:{s:3:\"mod\";s:2:\"64\";s:3:\"col\";s:6:\"footer\";s:6:\"enable\";s:1:\"1\";}}', 'fe_page', 1, 'a:3:{i:0;s:0:\"\";i:1;s:0:\"\";i:2;s:0:\"\";}', '', 'width=device-width,initial-scale=1.0', '', 'layout--1-column', '', NULL, 1, 'a:2:{i:0;s:10:\"j_colorbox\";i:1;s:11:\"j_tablesort\";}', 0, 'a:3:{i:0;s:13:\"moo_accordion\";i:1;s:12:\"moo_mediabox\";i:2;s:10:\"moo_slider\";}', NULL, NULL, 'a:2:{i:0;s:9:\"js_slider\";i:1;s:12:\"js_autofocus\";}', '<script src=\"files/contaodemo/theme/src/js/scripts.js\"></script>\n<script src=\"files/contaodemo/theme/src/js/a11y-nav.js\"></script>\n<script>\n	window.addEventListener(\'load\', () => {\n		new A11yNav({\n			ariaLabels: {\n                \'main\': \'Main menu\',\n                \'expand\': \'Expand menu: \',\n                \'collapse\': \'Collapse menu: \'\n            }\n		});\n	})\n</script>', 0, 'a:2:{s:4:\"unit\";s:2:\"px\";s:5:\"value\";s:4:\"1000\";}', 'center', NULL, NULL, 'default');
INSERT INTO `tl_layout` (`id`, `pid`, `tstamp`, `name`, `rows`, `headerHeight`, `footerHeight`, `cols`, `widthLeft`, `widthRight`, `sections`, `framework`, `external`, `combineScripts`, `modules`, `template`, `minifyMarkup`, `lightboxSize`, `defaultImageDensities`, `viewport`, `titleTag`, `cssClass`, `onload`, `head`, `addJQuery`, `jquery`, `addMooTools`, `mootools`, `analytics`, `externalJs`, `scripts`, `script`, `static`, `width`, `align`, `newsfeeds`, `calendarfeeds`, `type`) VALUES (22, 1, 1767980210, '1 column | 8/12 columns centered', '3rw', 'a:2:{s:4:\"unit\";s:0:\"\";s:5:\"value\";s:0:\"\";}', 'a:2:{s:4:\"unit\";s:0:\"\";s:5:\"value\";s:0:\"\";}', '2cll', 'a:2:{s:4:\"unit\";s:2:\"px\";s:5:\"value\";s:0:\"\";}', 'a:2:{s:5:\"value\";s:1:\"0\";s:4:\"unit\";s:2:\"px\";}', 'a:1:{i:0;a:4:{s:5:\"title\";s:10:\"sub-header\";s:2:\"id\";s:10:\"sub-header\";s:8:\"template\";s:13:\"block_section\";s:8:\"position\";s:6:\"before\";}}', '', 0x613a313a7b693a303b733a31363a223a067b64797c11ed8c84477216a987a9223b7d, 0, 'a:9:{i:0;a:3:{s:3:\"mod\";s:2:\"23\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:1;a:3:{s:3:\"mod\";s:11:\"content-149\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:2;a:3:{s:3:\"mod\";s:2:\"24\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:3;a:3:{s:3:\"mod\";s:1:\"1\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:4;a:3:{s:3:\"mod\";s:1:\"3\";s:3:\"col\";s:10:\"sub-header\";s:6:\"enable\";s:1:\"1\";}i:5;a:3:{s:3:\"mod\";s:1:\"0\";s:3:\"col\";s:4:\"main\";s:6:\"enable\";s:1:\"1\";}i:6;a:3:{s:3:\"mod\";s:11:\"content-149\";s:3:\"col\";s:6:\"footer\";s:6:\"enable\";s:1:\"1\";}i:7;a:3:{s:3:\"mod\";s:2:\"38\";s:3:\"col\";s:6:\"footer\";s:6:\"enable\";s:1:\"1\";}i:8;a:3:{s:3:\"mod\";s:2:\"64\";s:3:\"col\";s:6:\"footer\";s:6:\"enable\";s:1:\"1\";}}', 'fe_page', 1, 'a:3:{i:0;s:0:\"\";i:1;s:0:\"\";i:2;s:0:\"\";}', '', 'width=device-width,initial-scale=1.0', '', 'layout--1-column-8-12', '', NULL, 1, 'a:2:{i:0;s:10:\"j_colorbox\";i:1;s:11:\"j_tablesort\";}', 0, 'a:3:{i:0;s:13:\"moo_accordion\";i:1;s:12:\"moo_mediabox\";i:2;s:10:\"moo_slider\";}', NULL, NULL, 'a:2:{i:0;s:9:\"js_slider\";i:1;s:12:\"js_autofocus\";}', '<script src=\"files/contaodemo/theme/src/js/scripts.js\"></script>\n<script src=\"files/contaodemo/theme/src/js/a11y-nav.js\"></script>\n<script>\n	window.addEventListener(\'load\', () => {\n		new A11yNav({\n			ariaLabels: {\n                \'main\': \'Main menu\',\n                \'expand\': \'Expand menu: \',\n                \'collapse\': \'Collapse menu: \'\n            }\n		});\n	})\n</script>', 0, 'a:2:{s:4:\"unit\";s:2:\"px\";s:5:\"value\";s:4:\"1000\";}', 'center', NULL, NULL, 'default');
INSERT INTO `tl_layout` (`id`, `pid`, `tstamp`, `name`, `rows`, `headerHeight`, `footerHeight`, `cols`, `widthLeft`, `widthRight`, `sections`, `framework`, `external`, `combineScripts`, `modules`, `template`, `minifyMarkup`, `lightboxSize`, `defaultImageDensities`, `viewport`, `titleTag`, `cssClass`, `onload`, `head`, `addJQuery`, `jquery`, `addMooTools`, `mootools`, `analytics`, `externalJs`, `scripts`, `script`, `static`, `width`, `align`, `newsfeeds`, `calendarfeeds`, `type`) VALUES (24, 1, 1767980297, '2 columns - news-details  - Sidebar', '3rw', 'a:2:{s:4:\"unit\";s:0:\"\";s:5:\"value\";s:0:\"\";}', 'a:2:{s:4:\"unit\";s:0:\"\";s:5:\"value\";s:0:\"\";}', '2cll', 'a:2:{s:4:\"unit\";s:2:\"px\";s:5:\"value\";s:0:\"\";}', 'a:2:{s:5:\"value\";s:1:\"0\";s:4:\"unit\";s:2:\"px\";}', 'a:1:{i:0;a:4:{s:5:\"title\";s:10:\"sub-header\";s:2:\"id\";s:10:\"sub-header\";s:8:\"template\";s:13:\"block_section\";s:8:\"position\";s:6:\"before\";}}', '', 0x613a313a7b693a303b733a31363a223a067b64797c11ed8c84477216a987a9223b7d, 0, 'a:10:{i:0;a:3:{s:3:\"mod\";s:2:\"23\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:1;a:3:{s:3:\"mod\";s:11:\"content-149\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:2;a:3:{s:3:\"mod\";s:2:\"24\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:3;a:3:{s:3:\"mod\";s:1:\"1\";s:3:\"col\";s:6:\"header\";s:6:\"enable\";s:1:\"1\";}i:4;a:3:{s:3:\"mod\";s:1:\"3\";s:3:\"col\";s:10:\"sub-header\";s:6:\"enable\";s:1:\"1\";}i:5;a:3:{s:3:\"mod\";s:2:\"14\";s:3:\"col\";s:4:\"left\";s:6:\"enable\";s:1:\"1\";}i:6;a:3:{s:3:\"mod\";s:1:\"0\";s:3:\"col\";s:4:\"main\";s:6:\"enable\";s:1:\"1\";}i:7;a:3:{s:3:\"mod\";s:11:\"content-149\";s:3:\"col\";s:6:\"footer\";s:6:\"enable\";s:1:\"1\";}i:8;a:3:{s:3:\"mod\";s:2:\"38\";s:3:\"col\";s:6:\"footer\";s:6:\"enable\";s:1:\"1\";}i:9;a:3:{s:3:\"mod\";s:2:\"64\";s:3:\"col\";s:6:\"footer\";s:6:\"enable\";s:1:\"1\";}}', 'fe_page', 1, 'a:3:{i:0;s:0:\"\";i:1;s:0:\"\";i:2;s:0:\"\";}', '', 'width=device-width,initial-scale=1.0', '', 'layout--2-column', '', NULL, 1, 'a:2:{i:0;s:10:\"j_colorbox\";i:1;s:11:\"j_tablesort\";}', 0, 'a:3:{i:0;s:13:\"moo_accordion\";i:1;s:12:\"moo_mediabox\";i:2;s:10:\"moo_slider\";}', NULL, NULL, 'a:2:{i:0;s:9:\"js_slider\";i:1;s:12:\"js_autofocus\";}', '<script src=\"files/contaodemo/theme/src/js/scripts.js\"></script>\n<script src=\"files/contaodemo/theme/src/js/a11y-nav.js\"></script>\n<script>\n	window.addEventListener(\'load\', () => {\n		new A11yNav({\n			ariaLabels: {\n                \'main\': \'Main menu\',\n                \'expand\': \'Expand menu: \',\n                \'collapse\': \'Collapse menu: \'\n            }\n		});\n	})\n</script>', 0, 'a:2:{s:4:\"unit\";s:2:\"px\";s:5:\"value\";s:4:\"1000\";}', 'center', NULL, NULL, 'default');
-- BEGIN STRUCTURE tl_member_group
CREATE TABLE `tl_member_group` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `name` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `redirect` TINYINT DEFAULT 0 NOT NULL, `jumpTo` INT UNSIGNED DEFAULT 0 NOT NULL, `disable` TINYINT DEFAULT 0 NOT NULL, `start` VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `stop` VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, INDEX `disable_start_stop` (`disable`, `start`, `stop`), INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_member_group
INSERT INTO `tl_member_group` (`id`, `tstamp`, `name`, `redirect`, `jumpTo`, `disable`, `start`, `stop`) VALUES (1, 1709064349, 'Violin Students', 1, 67, 0, '', '');
INSERT INTO `tl_member_group` (`id`, `tstamp`, `name`, `redirect`, `jumpTo`, `disable`, `start`, `stop`) VALUES (2, 1709064340, 'Piano Students', 1, 67, 0, '', '');
INSERT INTO `tl_member_group` (`id`, `tstamp`, `name`, `redirect`, `jumpTo`, `disable`, `start`, `stop`) VALUES (3, 1367401146, 'General Members', 1, 67, 0, '', '');
-- BEGIN STRUCTURE tl_news
CREATE TABLE `tl_news` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `pid` INT UNSIGNED DEFAULT 0 NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `headline` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `featured` TINYINT DEFAULT 0 NOT NULL, `alias` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, `author` INT UNSIGNED DEFAULT 0 NOT NULL, `date` INT UNSIGNED DEFAULT 0 NOT NULL, `time` INT DEFAULT 0 NOT NULL, `pageTitle` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `robots` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `description` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `subheadline` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `teaser` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `addImage` TINYINT DEFAULT 0 NOT NULL, `overwriteMeta` TINYINT DEFAULT 0 NOT NULL, `singleSRC` BINARY(16) DEFAULT NULL, `alt` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `imageTitle` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `size` VARCHAR(255) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`, `imageUrl` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `fullsize` TINYINT DEFAULT 0 NOT NULL, `caption` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `floating` VARCHAR(12) CHARACTER SET utf8mb4 DEFAULT 'above' NOT NULL COLLATE `utf8mb4_unicode_ci`, `addEnclosure` TINYINT DEFAULT 0 NOT NULL, `enclosure` BLOB DEFAULT NULL, `source` VARCHAR(12) CHARACTER SET utf8mb4 DEFAULT 'default' NOT NULL COLLATE `utf8mb4_unicode_ci`, `jumpTo` INT UNSIGNED DEFAULT 0 NOT NULL, `articleId` INT UNSIGNED DEFAULT 0 NOT NULL, `url` VARCHAR(2048) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `target` TINYINT DEFAULT 0 NOT NULL, `cssClass` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `noComments` TINYINT DEFAULT 0 NOT NULL, `published` TINYINT DEFAULT 0 NOT NULL, `start` VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `stop` VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `linkText` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `canonicalLink` VARCHAR(2048) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `searchIndexer` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, INDEX `alias` (`alias`), INDEX `pid_published_featured_start_stop` (`pid`, `published`, `featured`, `start`, `stop`), INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_news
INSERT INTO `tl_news` (`id`, `pid`, `tstamp`, `headline`, `featured`, `alias`, `author`, `date`, `time`, `pageTitle`, `robots`, `description`, `subheadline`, `teaser`, `addImage`, `overwriteMeta`, `singleSRC`, `alt`, `imageTitle`, `size`, `imageUrl`, `fullsize`, `caption`, `floating`, `addEnclosure`, `enclosure`, `source`, `jumpTo`, `articleId`, `url`, `target`, `cssClass`, `noComments`, `published`, `start`, `stop`, `linkText`, `canonicalLink`, `searchIndexer`) VALUES (3, 1, 1697113635, 'New Contao Community Members each day', 0, 'new-contao-community-members-each-day', 3, 1682406900, 1682406900, '', '', NULL, 'The community is growing steadily', '<p>More and more web developers join the Contao community each day. Therefore Contao is able to evolve contantly.</p>', 1, 0, 0xcf694d76b13f11eda857525400fc3de0, '', '', 'a:3:{i:0;s:0:\"\";i:1;s:0:\"\";i:2;s:1:\"1\";}', '', 0, '', '', 1, 0x613a313a7b693a303b733a31363a2282337884a4c311e38e29000c29e44aea223b7d, 'default', 13, 0, '', 0, '', 0, 1, '', '', '', '', '');
INSERT INTO `tl_news` (`id`, `pid`, `tstamp`, `headline`, `featured`, `alias`, `author`, `date`, `time`, `pageTitle`, `robots`, `description`, `subheadline`, `teaser`, `addImage`, `overwriteMeta`, `singleSRC`, `alt`, `imageTitle`, `size`, `imageUrl`, `fullsize`, `caption`, `floating`, `addEnclosure`, `enclosure`, `source`, `jumpTo`, `articleId`, `url`, `target`, `cssClass`, `noComments`, `published`, `start`, `stop`, `linkText`, `canonicalLink`, `searchIndexer`) VALUES (7, 1, 1697113635, 'New Contao Versions in short intervalls', 0, 'new-contao-versions-in-short-intervalls', 1, 1684843260, 1684843260, '', 'index,follow', NULL, 'New versions of Contao are released frequently', '<p>The Contao community works hard to continuously improve Contao. Therefore several updates are released each year. The last release was Contao 3.3.</p>', 1, 0, 0xcf694d6bb13f11eda857525400fc3de0, '', '', 'a:3:{i:0;s:0:\"\";i:1;s:0:\"\";i:2;s:1:\"1\";}', '', 0, '', '', 1, 0x613a313a7b693a303b733a31363a2282337884a4c311e38e29000c29e44aea223b7d, 'default', 13, 0, '', 0, '', 0, 1, '', '', '', '', '');
INSERT INTO `tl_news` (`id`, `pid`, `tstamp`, `headline`, `featured`, `alias`, `author`, `date`, `time`, `pageTitle`, `robots`, `description`, `subheadline`, `teaser`, `addImage`, `overwriteMeta`, `singleSRC`, `alt`, `imageTitle`, `size`, `imageUrl`, `fullsize`, `caption`, `floating`, `addEnclosure`, `enclosure`, `source`, `jumpTo`, `articleId`, `url`, `target`, `cssClass`, `noComments`, `published`, `start`, `stop`, `linkText`, `canonicalLink`, `searchIndexer`) VALUES (8, 1, 1706727356, 'Contao is popular', 0, 'contao-is-popular', 3, 1676640420, 1676640420, '', '', NULL, 'Contao ranked in the Top5 among popular CMS&#39;s', '<p>In a recent security level comparison&nbsp;Contao excelled as one of the most secure Open Source CMS&#39;s.</p>', 0, 0, NULL, '', '', '', '', 0, '', '', 0, '', 'default', 13, 0, '', 0, '', 0, 1, '', '', '', '', '');
-- BEGIN STRUCTURE tl_news_archive
CREATE TABLE `tl_news_archive` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `title` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `jumpTo` INT UNSIGNED DEFAULT 0 NOT NULL, `protected` TINYINT DEFAULT 0 NOT NULL, `groups` BLOB DEFAULT NULL, `allowComments` TINYINT DEFAULT 0 NOT NULL, `notify` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT 'notify_admin' NOT NULL COLLATE `utf8mb4_unicode_ci`, `sortOrder` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT 'ascending' NOT NULL COLLATE `utf8mb4_unicode_ci`, `perPage` SMALLINT UNSIGNED DEFAULT 0 NOT NULL, `moderate` TINYINT DEFAULT 0 NOT NULL, `bbcode` TINYINT DEFAULT 0 NOT NULL, `requireLogin` TINYINT DEFAULT 0 NOT NULL, `disableCaptcha` TINYINT DEFAULT 0 NOT NULL, INDEX `jumpto` (`jumpTo`), INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_news_archive
INSERT INTO `tl_news_archive` (`id`, `tstamp`, `title`, `jumpTo`, `protected`, `groups`, `allowComments`, `notify`, `sortOrder`, `perPage`, `moderate`, `bbcode`, `requireLogin`, `disableCaptcha`) VALUES (1, 1697113612, 'Contao Demo News', 8, 0, NULL, 1, 'notify_admin', 'ascending', 0, 0, 0, 0, 0);
-- BEGIN STRUCTURE tl_newsletter
CREATE TABLE `tl_newsletter` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `pid` INT UNSIGNED DEFAULT 0 NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `subject` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `alias` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, `content` MEDIUMTEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `text` MEDIUMTEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `addFile` TINYINT DEFAULT 0 NOT NULL, `files` BLOB DEFAULT NULL, `template` VARCHAR(64) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `sendText` TINYINT DEFAULT 0 NOT NULL, `externalImages` TINYINT DEFAULT 0 NOT NULL, `mailerTransport` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `sender` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `senderName` VARCHAR(128) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `sent` TINYINT DEFAULT 0 NOT NULL, `date` VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `preheader` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, INDEX `pid` (`pid`), INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_newsletter
INSERT INTO `tl_newsletter` (`id`, `pid`, `tstamp`, `subject`, `alias`, `content`, `text`, `addFile`, `files`, `template`, `sendText`, `externalImages`, `mailerTransport`, `sender`, `senderName`, `sent`, `date`, `preheader`) VALUES (2, 3, 1400844354, 'The right newsletter for everyone', 'ma2-benefit-concert', '<p><b>The right newsletter for everyone</b></p>\n<p>The newsletter functionalities of Contao allows you to create different \"Channels\". So it\'s possible to adress visitors or regular users of your site with their specific interests. Before you send a newsletter to a list of subscribers you can make the use of the option to send a preview. Better check your newsletters on all mail clients. Some of you might know that a lot of mail servers just allow a certain amount of Emails sent within a time-amount: The \"Mails per cycle\" function will help here with larger lists.<b><br><br></b>SATURDAY<br>December 24<sup>th</sup>, 2013<br>7:30 pm</p>\n<p>SUNDAY<br>December 26<sup>th</sup>, 2013<br>3:00 pm</p>\n<p><b>Tickets $20[nbsp]to[nbsp]$40</b></p>\n<p>Call (416) 872-4255</p>', 'TEXT Content', 0, 'a:1:{i:0;N;}', 'mail_default', 0, 0, '', '', '', 1, '1360273849', '');
INSERT INTO `tl_newsletter` (`id`, `pid`, `tstamp`, `subject`, `alias`, `content`, `text`, `addFile`, `files`, `template`, `sendText`, `externalImages`, `mailerTransport`, `sender`, `senderName`, `sent`, `date`, `preheader`) VALUES (3, 3, 1400844298, 'Keeping everyone up to date', 'music-academy-christmals-concert', '<p><b>Keeping everyone up to date</b></p>\n<p>Contao has a built in Newsletter administration system. It offers some features to create newsletters on a regular basis. Your are able to set up an HTML template, create your newsletters just as plain text or use both functionalities. Even attachments or external images can optionally be integrated.<b><br><br></b>SATURDAY<br>December 24<sup>th</sup>, 2013<br>7:30 pm</p>\n<p>SUNDAY<br>December 26<sup>th</sup>, 2013<br>3:00 pm</p>\n<p><b>Tickets $20[nbsp]to[nbsp]$40</b></p>\n<p>Call (416) 872-4255</p>', '', 0, 'a:1:{i:0;N;}', 'mail_default', 0, 0, '', '', '', 1, '1360274551', '');
-- BEGIN STRUCTURE tl_newsletter_channel
CREATE TABLE `tl_newsletter_channel` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `title` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `jumpTo` INT UNSIGNED DEFAULT 0 NOT NULL, `template` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `mailerTransport` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `sender` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `senderName` VARCHAR(128) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_newsletter_channel
INSERT INTO `tl_newsletter_channel` (`id`, `tstamp`, `title`, `jumpTo`, `template`, `mailerTransport`, `sender`, `senderName`) VALUES (3, 1400846527, 'Newsletter - Demo', 45, '', '', '', '');
-- BEGIN STRUCTURE tl_newsletter_deny_list
CREATE TABLE `tl_newsletter_deny_list` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `pid` INT UNSIGNED DEFAULT 0 NOT NULL, `hash` VARCHAR(32) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, UNIQUE INDEX `pid_hash` (`pid`, `hash`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_newsletter_deny_list
-- BEGIN STRUCTURE tl_newsletter_recipients
CREATE TABLE `tl_newsletter_recipients` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `pid` INT UNSIGNED DEFAULT 0 NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `email` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `active` TINYINT DEFAULT 0 NOT NULL, `addedOn` VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, INDEX `active` (`active`), INDEX `email` (`email`), UNIQUE INDEX `pid_email` (`pid`, `email`), INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_newsletter_recipients
-- BEGIN STRUCTURE tl_opt_in
CREATE TABLE `tl_opt_in` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `token` VARCHAR(24) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `createdOn` INT UNSIGNED DEFAULT 0 NOT NULL, `confirmedOn` INT UNSIGNED DEFAULT 0 NOT NULL, `removeOn` INT UNSIGNED DEFAULT 0 NOT NULL, `invalidatedThrough` VARCHAR(24) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `email` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `emailSubject` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `emailText` TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, INDEX `removeon_confirmedon` (`removeOn`, `confirmedOn`), UNIQUE INDEX `token` (`token`), INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_opt_in
-- BEGIN STRUCTURE tl_opt_in_related
CREATE TABLE `tl_opt_in_related` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `pid` INT UNSIGNED DEFAULT 0 NOT NULL, `relTable` VARCHAR(64) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, `relId` INT UNSIGNED DEFAULT 0 NOT NULL, INDEX `pid` (`pid`), INDEX `reltable_relid` (`relTable`, `relId`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_opt_in_related
INSERT INTO `tl_opt_in_related` (`id`, `pid`, `relTable`, `relId`) VALUES (2, 2, 'tl_newsletter_recipients', 4);
-- BEGIN STRUCTURE tl_preview_link
CREATE TABLE `tl_preview_link` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `url` VARCHAR(2048) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `showUnpublished` TINYINT DEFAULT 0 NOT NULL, `restrictToUrl` TINYINT DEFAULT 1 NOT NULL, `createdAt` INT UNSIGNED DEFAULT 0 NOT NULL, `expiresAt` INT UNSIGNED DEFAULT 0 NOT NULL, `published` TINYINT DEFAULT 0 NOT NULL, `createdBy` INT UNSIGNED DEFAULT 0 NOT NULL, INDEX `id_published_expiresat` (`id`, `published`, `expiresAt`), INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_preview_link
-- BEGIN STRUCTURE tl_theme
CREATE TABLE `tl_theme` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `name` VARCHAR(128) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `author` VARCHAR(128) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `folders` BLOB DEFAULT NULL, `screenshot` BINARY(16) DEFAULT NULL, `templates` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_theme
INSERT INTO `tl_theme` (`id`, `tstamp`, `name`, `author`, `folders`, `screenshot`, `templates`) VALUES (1, 1755787967, 'Contao Official Demo', 'Joe Ray Gregory, Sascha Müller, Felix Pfeiffer, Stefan Melz, Cliff Parnitzky', 0x613a323a7b693a303b733a31363a22823078a8a4c311e38e29000c29e44aea223b693a313b733a31363a2282247cc5a4c311e38e29000c29e44aea223b7d, 0x043b657ea80311ee8c4b03657cc17326, '');
-- BEGIN STRUCTURE tl_user_group
CREATE TABLE `tl_user_group` (`id` INT UNSIGNED AUTO_INCREMENT NOT NULL, `tstamp` INT UNSIGNED DEFAULT 0 NOT NULL, `name` VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `modules` BLOB DEFAULT NULL, `themes` BLOB DEFAULT NULL, `elements` BLOB DEFAULT NULL, `fields` BLOB DEFAULT NULL, `pagemounts` BLOB DEFAULT NULL, `alpty` BLOB DEFAULT NULL, `filemounts` BLOB DEFAULT NULL, `fop` BLOB DEFAULT NULL, `imageSizes` BLOB DEFAULT NULL, `forms` BLOB DEFAULT NULL, `amg` BLOB DEFAULT NULL, `alexf` BLOB DEFAULT NULL, `disable` TINYINT DEFAULT 0 NOT NULL, `start` VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `stop` VARCHAR(10) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci`, `faqs` BLOB DEFAULT NULL, `news` BLOB DEFAULT NULL, `calendars` BLOB DEFAULT NULL, `calendarfeeds` BLOB DEFAULT NULL, `newsletters` BLOB DEFAULT NULL, `frontendModules` BLOB DEFAULT NULL, `cud` BLOB DEFAULT NULL, INDEX `tstamp` (`tstamp`), PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA tl_user_group
INSERT INTO `tl_user_group` (`id`, `tstamp`, `name`, `modules`, `themes`, `elements`, `fields`, `pagemounts`, `alpty`, `filemounts`, `fop`, `imageSizes`, `forms`, `amg`, `alexf`, `disable`, `start`, `stop`, `faqs`, `news`, `calendars`, `calendarfeeds`, `newsletters`, `frontendModules`, `cud`) VALUES (1, 1709064282, 'Editors', 'a:5:{i:0;s:4:\"page\";i:1;s:7:\"article\";i:2;s:5:\"files\";i:3;s:4:\"news\";i:4;s:8:\"calendar\";}', NULL, 'a:27:{i:0;s:4:\"code\";i:1;s:8:\"headline\";i:2;s:4:\"html\";i:3;s:4:\"list\";i:4;s:8:\"markdown\";i:5;s:5:\"table\";i:6;s:4:\"text\";i:7;s:9:\"hyperlink\";i:8;s:7:\"toplink\";i:9;s:8:\"download\";i:10;s:9:\"downloads\";i:11;s:5:\"image\";i:12;s:7:\"gallery\";i:13;s:6:\"player\";i:14;s:5:\"vimeo\";i:15;s:7:\"youtube\";i:16;s:7:\"article\";i:17;s:5:\"alias\";i:18;s:4:\"form\";i:19;s:6:\"module\";i:20;s:8:\"comments\";i:21;s:6:\"teaser\";i:22;s:15:\"accordionSingle\";i:23;s:14:\"accordionStart\";i:24;s:13:\"accordionStop\";i:25;s:11:\"sliderStart\";i:26;s:10:\"sliderStop\";}', 'a:15:{i:0;s:11:\"explanation\";i:1;s:4:\"html\";i:2;s:13:\"fieldsetStart\";i:3;s:12:\"fieldsetStop\";i:4;s:4:\"text\";i:5;s:8:\"password\";i:6;s:8:\"textarea\";i:7;s:6:\"select\";i:8;s:5:\"radio\";i:9;s:8:\"checkbox\";i:10;s:6:\"upload\";i:11;s:5:\"range\";i:12;s:6:\"hidden\";i:13;s:7:\"captcha\";i:14;s:6:\"submit\";}', 'a:1:{i:0;i:1;}', 'a:3:{i:0;s:7:\"regular\";i:1;s:7:\"forward\";i:2;s:8:\"redirect\";}', NULL, 'a:3:{i:0;s:2:\"f1\";i:1;s:2:\"f2\";i:2;s:2:\"f3\";}', 'a:3:{i:0;s:4:\"crop\";i:1;s:12:\"proportional\";i:2;s:3:\"box\";}', NULL, NULL, 'a:180:{i:0;s:17:\"tl_article::title\";i:1;s:17:\"tl_article::alias\";i:2;s:18:\"tl_article::author\";i:3;s:20:\"tl_article::inColumn\";i:4;s:22:\"tl_article::showTeaser\";i:5;s:23:\"tl_article::teaserCssID\";i:6;s:18:\"tl_article::teaser\";i:7;s:21:\"tl_article::printable\";i:8;s:17:\"tl_article::cssID\";i:9;s:18:\"tl_calendar::title\";i:10;s:19:\"tl_calendar::jumpTo\";i:11;s:22:\"tl_calendar::protected\";i:12;s:19:\"tl_calendar::groups\";i:13;s:26:\"tl_calendar::allowComments\";i:14;s:19:\"tl_calendar::notify\";i:15;s:22:\"tl_calendar::sortOrder\";i:16;s:20:\"tl_calendar::perPage\";i:17;s:21:\"tl_calendar::moderate\";i:18;s:19:\"tl_calendar::bbcode\";i:19;s:25:\"tl_calendar::requireLogin\";i:20;s:27:\"tl_calendar::disableCaptcha\";i:21;s:25:\"tl_calendar_events::title\";i:22;s:25:\"tl_calendar_events::alias\";i:23;s:26:\"tl_calendar_events::author\";i:24;s:27:\"tl_calendar_events::addTime\";i:25;s:29:\"tl_calendar_events::startTime\";i:26;s:27:\"tl_calendar_events::endTime\";i:27;s:29:\"tl_calendar_events::startDate\";i:28;s:27:\"tl_calendar_events::endDate\";i:29;s:26:\"tl_calendar_events::teaser\";i:30;s:28:\"tl_calendar_events::addImage\";i:31;s:29:\"tl_calendar_events::singleSRC\";i:32;s:23:\"tl_calendar_events::alt\";i:33;s:24:\"tl_calendar_events::size\";i:34;s:28:\"tl_calendar_events::imageUrl\";i:35;s:28:\"tl_calendar_events::fullsize\";i:36;s:27:\"tl_calendar_events::caption\";i:37;s:28:\"tl_calendar_events::floating\";i:38;s:29:\"tl_calendar_events::recurring\";i:39;s:30:\"tl_calendar_events::repeatEach\";i:40;s:31:\"tl_calendar_events::recurrences\";i:41;s:32:\"tl_calendar_events::addEnclosure\";i:42;s:29:\"tl_calendar_events::enclosure\";i:43;s:26:\"tl_calendar_events::source\";i:44;s:26:\"tl_calendar_events::jumpTo\";i:45;s:29:\"tl_calendar_events::articleId\";i:46;s:23:\"tl_calendar_events::url\";i:47;s:26:\"tl_calendar_events::target\";i:48;s:28:\"tl_calendar_events::cssClass\";i:49;s:30:\"tl_calendar_events::noComments\";i:50;s:16:\"tl_content::type\";i:51;s:20:\"tl_content::headline\";i:52;s:16:\"tl_content::text\";i:53;s:20:\"tl_content::addImage\";i:54;s:21:\"tl_content::singleSRC\";i:55;s:15:\"tl_content::alt\";i:56;s:16:\"tl_content::size\";i:57;s:20:\"tl_content::imageUrl\";i:58;s:20:\"tl_content::fullsize\";i:59;s:19:\"tl_content::caption\";i:60;s:20:\"tl_content::floating\";i:61;s:16:\"tl_content::html\";i:62;s:20:\"tl_content::listtype\";i:63;s:21:\"tl_content::listitems\";i:64;s:22:\"tl_content::tableitems\";i:65;s:19:\"tl_content::summary\";i:66;s:17:\"tl_content::thead\";i:67;s:17:\"tl_content::tfoot\";i:68;s:17:\"tl_content::tleft\";i:69;s:20:\"tl_content::sortable\";i:70;s:21:\"tl_content::sortIndex\";i:71;s:21:\"tl_content::sortOrder\";i:72;s:23:\"tl_content::mooHeadline\";i:73;s:20:\"tl_content::mooStyle\";i:74;s:22:\"tl_content::mooClasses\";i:75;s:21:\"tl_content::highlight\";i:76;s:16:\"tl_content::code\";i:77;s:15:\"tl_content::url\";i:78;s:18:\"tl_content::target\";i:79;s:21:\"tl_content::linkTitle\";i:80;s:17:\"tl_content::embed\";i:81;s:15:\"tl_content::rel\";i:82;s:20:\"tl_content::useImage\";i:83;s:20:\"tl_content::multiSRC\";i:84;s:22:\"tl_content::useHomeDir\";i:85;s:18:\"tl_content::perRow\";i:86;s:19:\"tl_content::perPage\";i:87;s:25:\"tl_content::numberOfItems\";i:88;s:18:\"tl_content::sortBy\";i:89;s:22:\"tl_content::galleryTpl\";i:90;s:20:\"tl_content::cteAlias\";i:91;s:24:\"tl_content::articleAlias\";i:92;s:19:\"tl_content::article\";i:93;s:16:\"tl_content::form\";i:94;s:18:\"tl_content::module\";i:95;s:21:\"tl_content::protected\";i:96;s:18:\"tl_content::groups\";i:97;s:17:\"tl_content::cssID\";i:98;s:21:\"tl_content::com_order\";i:99;s:23:\"tl_content::com_perPage\";i:100;s:24:\"tl_content::com_moderate\";i:101;s:22:\"tl_content::com_bbcode\";i:102;s:30:\"tl_content::com_disableCaptcha\";i:103;s:28:\"tl_content::com_requireLogin\";i:104;s:24:\"tl_content::com_template\";i:105;s:14:\"tl_files::name\";i:106;s:19:\"tl_files::protected\";i:107;s:21:\"tl_files::syncExclude\";i:108;s:24:\"tl_files::importantPartX\";i:109;s:24:\"tl_files::importantPartY\";i:110;s:28:\"tl_files::importantPartWidth\";i:111;s:29:\"tl_files::importantPartHeight\";i:112;s:14:\"tl_files::meta\";i:113;s:17:\"tl_news::headline\";i:114;s:17:\"tl_news::featured\";i:115;s:14:\"tl_news::alias\";i:116;s:15:\"tl_news::author\";i:117;s:13:\"tl_news::date\";i:118;s:13:\"tl_news::time\";i:119;s:20:\"tl_news::subheadline\";i:120;s:15:\"tl_news::teaser\";i:121;s:17:\"tl_news::addImage\";i:122;s:18:\"tl_news::singleSRC\";i:123;s:12:\"tl_news::alt\";i:124;s:13:\"tl_news::size\";i:125;s:17:\"tl_news::imageUrl\";i:126;s:17:\"tl_news::fullsize\";i:127;s:16:\"tl_news::caption\";i:128;s:17:\"tl_news::floating\";i:129;s:21:\"tl_news::addEnclosure\";i:130;s:18:\"tl_news::enclosure\";i:131;s:15:\"tl_news::source\";i:132;s:15:\"tl_news::jumpTo\";i:133;s:18:\"tl_news::articleId\";i:134;s:12:\"tl_news::url\";i:135;s:15:\"tl_news::target\";i:136;s:17:\"tl_news::cssClass\";i:137;s:19:\"tl_news::noComments\";i:138;s:22:\"tl_news_archive::title\";i:139;s:23:\"tl_news_archive::jumpTo\";i:140;s:26:\"tl_news_archive::protected\";i:141;s:23:\"tl_news_archive::groups\";i:142;s:30:\"tl_news_archive::allowComments\";i:143;s:23:\"tl_news_archive::notify\";i:144;s:26:\"tl_news_archive::sortOrder\";i:145;s:24:\"tl_news_archive::perPage\";i:146;s:25:\"tl_news_archive::moderate\";i:147;s:23:\"tl_news_archive::bbcode\";i:148;s:29:\"tl_news_archive::requireLogin\";i:149;s:31:\"tl_news_archive::disableCaptcha\";i:150;s:14:\"tl_page::title\";i:151;s:13:\"tl_page::type\";i:152;s:14:\"tl_page::alias\";i:153;s:18:\"tl_page::pageTitle\";i:154;s:17:\"tl_page::language\";i:155;s:15:\"tl_page::robots\";i:156;s:20:\"tl_page::description\";i:157;s:17:\"tl_page::redirect\";i:158;s:15:\"tl_page::jumpTo\";i:159;s:12:\"tl_page::url\";i:160;s:15:\"tl_page::target\";i:161;s:12:\"tl_page::dns\";i:162;s:17:\"tl_page::fallback\";i:163;s:19:\"tl_page::adminEmail\";i:164;s:19:\"tl_page::dateFormat\";i:165;s:19:\"tl_page::timeFormat\";i:166;s:20:\"tl_page::datimFormat\";i:167;s:15:\"tl_page::useSSL\";i:168;s:20:\"tl_page::autoforward\";i:169;s:18:\"tl_page::protected\";i:170;s:15:\"tl_page::groups\";i:171;s:22:\"tl_page::includeLayout\";i:172;s:15:\"tl_page::layout\";i:173;s:21:\"tl_page::includeCache\";i:174;s:14:\"tl_page::cache\";i:175;s:17:\"tl_page::noSearch\";i:176;s:17:\"tl_page::cssClass\";i:177;s:16:\"tl_page::sitemap\";i:178;s:13:\"tl_page::hide\";i:179;s:18:\"tl_page::accesskey\";}', 0, '', '', NULL, 'a:1:{i:0;s:1:\"1\";}', 'a:1:{i:0;s:1:\"3\";}', NULL, NULL, 'a:42:{i:0;s:10:\"navigation\";i:1;s:9:\"customnav\";i:2;s:10:\"breadcrumb\";i:3;s:8:\"quicknav\";i:4;s:9:\"quicklink\";i:5;s:7:\"booknav\";i:6;s:10:\"articlenav\";i:7;s:7:\"sitemap\";i:8;s:5:\"login\";i:9;s:12:\"personalData\";i:10;s:12:\"registration\";i:11;s:14:\"changePassword\";i:12;s:12:\"lostPassword\";i:13;s:12:\"closeAccount\";i:14;s:10:\"two_factor\";i:15;s:4:\"form\";i:16;s:6:\"search\";i:17;s:7:\"listing\";i:18;s:8:\"comments\";i:19;s:11:\"articlelist\";i:20;s:11:\"randomImage\";i:21;s:4:\"html\";i:22;s:9:\"rssReader\";i:23;s:11:\"feed_reader\";i:24;s:27:\"root_page_dependent_modules\";i:25;s:8:\"template\";i:26;s:15:\"unfiltered_html\";i:27;s:7:\"faqlist\";i:28;s:9:\"faqreader\";i:29;s:7:\"faqpage\";i:30;s:8:\"newslist\";i:31;s:10:\"newsreader\";i:32;s:11:\"newsarchive\";i:33;s:8:\"newsmenu\";i:34;s:8:\"calendar\";i:35;s:11:\"eventreader\";i:36;s:9:\"eventlist\";i:37;s:9:\"eventmenu\";i:38;s:9:\"subscribe\";i:39;s:11:\"unsubscribe\";i:40;s:14:\"newsletterlist\";i:41;s:16:\"newsletterreader\";}', 'a:60:{i:0;s:21:\"tl_form_field::create\";i:1;s:21:\"tl_form_field::update\";i:2;s:21:\"tl_form_field::delete\";i:3;s:15:\"tl_user::create\";i:4;s:15:\"tl_user::update\";i:5;s:15:\"tl_user::delete\";i:6;s:18:\"tl_content::create\";i:7;s:18:\"tl_content::update\";i:8;s:18:\"tl_content::delete\";i:9;s:17:\"tl_member::create\";i:10;s:17:\"tl_member::update\";i:11;s:17:\"tl_member::delete\";i:12;s:23:\"tl_preview_link::create\";i:13;s:23:\"tl_preview_link::update\";i:14;s:23:\"tl_preview_link::delete\";i:15;s:21:\"tl_user_group::create\";i:16;s:21:\"tl_user_group::update\";i:17;s:21:\"tl_user_group::delete\";i:18;s:26:\"tl_image_size_item::create\";i:19;s:26:\"tl_image_size_item::update\";i:20;s:26:\"tl_image_size_item::delete\";i:22;s:15:\"tl_form::update\";i:24;s:23:\"tl_member_group::create\";i:25;s:23:\"tl_member_group::update\";i:26;s:23:\"tl_member_group::delete\";i:27;s:21:\"tl_image_size::create\";i:28;s:21:\"tl_image_size::update\";i:29;s:21:\"tl_image_size::delete\";i:30;s:17:\"tl_layout::create\";i:31;s:17:\"tl_layout::update\";i:32;s:17:\"tl_layout::delete\";i:33;s:17:\"tl_module::create\";i:34;s:17:\"tl_module::update\";i:35;s:17:\"tl_module::delete\";i:36;s:16:\"tl_theme::create\";i:37;s:16:\"tl_theme::update\";i:38;s:16:\"tl_theme::delete\";i:39;s:14:\"tl_faq::create\";i:40;s:14:\"tl_faq::update\";i:41;s:14:\"tl_faq::delete\";i:43;s:23:\"tl_faq_category::update\";i:46;s:23:\"tl_news_archive::update\";i:48;s:15:\"tl_news::create\";i:49;s:15:\"tl_news::update\";i:50;s:15:\"tl_news::delete\";i:52;s:19:\"tl_calendar::update\";i:54;s:26:\"tl_calendar_events::create\";i:55;s:26:\"tl_calendar_events::update\";i:56;s:26:\"tl_calendar_events::delete\";i:58;s:24:\"tl_calendar_feed::update\";i:60;s:21:\"tl_newsletter::create\";i:61;s:21:\"tl_newsletter::update\";i:62;s:21:\"tl_newsletter::delete\";i:64;s:29:\"tl_newsletter_channel::update\";i:66;s:32:\"tl_newsletter_recipients::create\";i:67;s:32:\"tl_newsletter_recipients::update\";i:68;s:32:\"tl_newsletter_recipients::delete\";i:69;s:19:\"tl_comments::create\";i:70;s:19:\"tl_comments::update\";i:71;s:19:\"tl_comments::delete\";}');
-- BEGIN STRUCTURE webauthn_credentials
CREATE TABLE `webauthn_credentials` (`id` VARCHAR(255) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, `publicKeyCredentialId` LONGTEXT CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, `type` VARCHAR(255) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, `transports` JSON NOT NULL, `attestationType` VARCHAR(255) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, `trustPath` JSON NOT NULL, `aaguid` TINYTEXT CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, `credentialPublicKey` LONGTEXT CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, `userHandle` VARCHAR(255) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, `counter` INT NOT NULL, `otherUI` JSON DEFAULT NULL, `backupEligible` TINYINT DEFAULT NULL, `backupStatus` TINYINT DEFAULT NULL, `uvInitialized` TINYINT DEFAULT NULL, `name` VARCHAR(255) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, `createdAt` DATETIME NOT NULL, PRIMARY KEY (`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB COMMENT = '' ;
-- BEGIN DATA webauthn_credentials
