[Gelöst] Update von 4.4.57 auf 4.13.12 - Installtool / DB Fehler

[cboublob]

Hi,

ich habe jetzt mehrere Versuche hinter mir eine bestehende Installtion von Version 4.4.57 auf die aktuelle 4.13er LTS Version zu aktualisieren, aber ich komme nicht weiter und hoffe ihr könnt mir ein paar Tipps geben wo es hängt.

Was habe ich gemacht:
- Neue Datenbank angelegt und die Daten der alten importiert
- 4.13.12 in der "Core"-Variante installiert
- 2 Erweiterungen (Notification Center und Leads) installiert
- Installtool gestartet um Datenbank zu aktualisieren, aber das klappt dann nicht mehr

Folgende Fehler bekomme ich im Debugmodus angezeigt:

Doctrine\DBAL\Exception:
Unknown database type bit requested, Doctrine\DBAL\Platforms\MySQL57Platform may not support it.

  at vendor/doctrine/dbal/src/Platforms/AbstractPlatform.php:441
  at Doctrine\DBAL\Platforms\AbstractPlatform->getDoctrineTypeMapping()
     (vendor/doctrine/dbal/src/Schema/MySQLSchemaManager.php:186)
  at Doctrine\DBAL\Schema\MySQLSchemaManager->_getPortableTableColumnDefinition()
     (vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php:1408)
  at Doctrine\DBAL\Schema\AbstractSchemaManager->_getPortableTableColumnList()
     (vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php:423)
  at Doctrine\DBAL\Schema\AbstractSchemaManager->doListTables()
     (vendor/doctrine/dbal/src/Schema/MySQLSchemaManager.php:66)
  at Doctrine\DBAL\Schema\MySQLSchemaManager->listTables()
     (vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php:1651)
  at Doctrine\DBAL\Schema\AbstractSchemaManager->createSchema()
     (vendor/contao/installation-bundle/src/Database/Installer.php:111)
  at Contao\InstallationBundle\Database\Installer->compileCommands()
     (vendor/contao/installation-bundle/src/Database/Installer.php:43)
  at Contao\InstallationBundle\Database\Installer->getCommands()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:374)
  at Contao\InstallationBundle\Controller\InstallationController->adjustDatabaseTables()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:100)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/http-kernel/HttpKernel.php:153)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:44)

ErrorException:
Warning: Cannot modify header information - headers already sent by (output started at /mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/http-foundation/Response.php:381)

  at /mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/contao/core-bundle/src/HttpKernel/Header/NativeHeaderStorage.php:27
  at Contao\CoreBundle\HttpKernel\Header\NativeHeaderStorage->add()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/contao/core-bundle/src/EventListener/MergeHttpHeadersListener.php:126)
  at Contao\CoreBundle\EventListener\MergeHttpHeadersListener->setResponseHeaders()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/contao/core-bundle/src/EventListener/MergeHttpHeadersListener.php:57)
  at Contao\CoreBundle\EventListener\MergeHttpHeadersListener->__invoke()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/event-dispatcher/Debug/WrappedListener.php:117)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/event-dispatcher/EventDispatcher.php:230)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/event-dispatcher/EventDispatcher.php:59)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/http-kernel/HttpKernel.php:186)
  at Symfony\Component\HttpKernel\HttpKernel->filterResponse()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/http-kernel/HttpKernel.php:174)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/http-kernel/EventListener/ErrorListener.php:91)
  at Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/event-dispatcher/Debug/WrappedListener.php:117)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/event-dispatcher/EventDispatcher.php:230)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/event-dispatcher/EventDispatcher.php:59)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/http-kernel/HttpKernel.php:213)
  at Symfony\Component\HttpKernel\HttpKernel->handleThrowable()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/http-kernel/HttpKernel.php:109)
  at Symfony\Component\HttpKernel\HttpKernel->terminateWithException()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/http-kernel/EventListener/DebugHandlersListener.php:131)
  at Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::Symfony\Component\HttpKernel\EventListener\{closure}()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/error-handler/ErrorHandler.php:607)
  at Symfony\Component\ErrorHandler\ErrorHandler->handleException()         )

Die hier gibt es dann gleich 3x

Doctrine\DBAL\Exception\TableNotFoundException:
An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs8950729.tl_search' doesn't exist

  at /mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:49
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/doctrine/dbal/src/Connection.php:1908)
  at Doctrine\DBAL\Connection->handleDriverException()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/doctrine/dbal/src/Connection.php:1851)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/doctrine/dbal/src/Connection.php:1070)
  at Doctrine\DBAL\Connection->executeQuery()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:284)
  at Contao\Database\Statement->query()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:240)
  at Contao\Database\Statement->execute()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/contao/core-bundle/src/Resources/contao/library/Contao/Search.php:790)
  at Contao\Search::removeEntry()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/contao/core-bundle/src/Framework/Adapter.php:46)
  at Contao\CoreBundle\Framework\Adapter->__call()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/contao/core-bundle/src/Search/Indexer/DefaultIndexer.php:115)
  at Contao\CoreBundle\Search\Indexer\DefaultIndexer->delete()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/contao/core-bundle/src/Search/Indexer/DelegatingIndexer.php:41)
  at Contao\CoreBundle\Search\Indexer\DelegatingIndexer->delete()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/contao/core-bundle/src/EventListener/SearchIndexListener.php:65)
  at Contao\CoreBundle\EventListener\SearchIndexListener->__invoke()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/event-dispatcher/Debug/WrappedListener.php:117)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/event-dispatcher/EventDispatcher.php:230)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/event-dispatcher/EventDispatcher.php:59)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/http-kernel/HttpKernel.php:97)
  at Symfony\Component\HttpKernel\HttpKernel->terminate()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/vendor/symfony/http-kernel/Kernel.php:159)
  at Symfony\Component\HttpKernel\Kernel->terminate()
     (/mnt/web007/b2/43/52544943/htdocs/contao4.13.12/public/index.php:48)

Ich habe ein wenig hier quergelesen und habe probiert ob Änderungen in der config.yml den ersten Fehler beheben können, aber ich habe es leider nicht hinbekommen. Ich bin für alle Hinweise dankbar!

[Spooky]

Poste mal den SQL Dump exkl. der INSERTs (also nur die CREATE TABLE queries).

[cboublob]

Hi Spooky,

danke für deine Antwort. Hier der Dump:

CREATE TABLE `tl_article` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `sorting` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `author` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `inColumn` varchar(32) NOT NULL DEFAULT '',
  `keywords` text,
  `showTeaser` char(1) NOT NULL DEFAULT '',
  `teaserCssID` varchar(255) NOT NULL DEFAULT '',
  `teaser` text,
  `printable` varchar(255) NOT NULL DEFAULT '',
  `customTpl` varchar(64) NOT NULL DEFAULT '',
  `protected` char(1) NOT NULL DEFAULT '',
  `groups` blob,
  `guests` char(1) NOT NULL DEFAULT '',
  `cssID` varchar(255) NOT NULL DEFAULT '',
  `published` char(1) NOT NULL DEFAULT '',
  `start` varchar(10) NOT NULL DEFAULT '',
  `stop` varchar(10) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_content` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ptable` varchar(64) NOT NULL DEFAULT '',
  `sorting` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` varchar(64) NOT NULL DEFAULT '',
  `headline` varchar(255) NOT NULL DEFAULT '',
  `text` mediumtext,
  `addImage` char(1) NOT NULL DEFAULT '',
  `singleSRC` binary(16) DEFAULT NULL,
  `alt` varchar(255) NOT NULL DEFAULT '',
  `imageTitle` varchar(255) NOT NULL DEFAULT '',
  `size` varchar(64) NOT NULL DEFAULT '',
  `imagemargin` varchar(128) NOT NULL DEFAULT '',
  `imageUrl` varchar(255) NOT NULL DEFAULT '',
  `fullsize` char(1) NOT NULL DEFAULT '',
  `caption` varchar(255) NOT NULL DEFAULT '',
  `floating` varchar(32) NOT NULL DEFAULT '',
  `html` mediumtext,
  `listtype` varchar(32) NOT NULL DEFAULT '',
  `listitems` blob,
  `tableitems` mediumblob,
  `summary` varchar(255) NOT NULL DEFAULT '',
  `thead` char(1) NOT NULL DEFAULT '',
  `tfoot` char(1) NOT NULL DEFAULT '',
  `tleft` char(1) NOT NULL DEFAULT '',
  `sortable` char(1) NOT NULL DEFAULT '',
  `sortIndex` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `sortOrder` varchar(32) NOT NULL DEFAULT '',
  `mooHeadline` varchar(255) NOT NULL DEFAULT '',
  `mooStyle` varchar(255) NOT NULL DEFAULT '',
  `mooClasses` varchar(255) NOT NULL DEFAULT '',
  `highlight` varchar(32) NOT NULL DEFAULT '',
  `code` text,
  `url` varchar(255) NOT NULL DEFAULT '',
  `target` char(1) NOT NULL DEFAULT '',
  `titleText` varchar(255) NOT NULL DEFAULT '',
  `linkTitle` varchar(255) NOT NULL DEFAULT '',
  `embed` varchar(255) NOT NULL DEFAULT '',
  `rel` varchar(64) NOT NULL DEFAULT '',
  `useImage` char(1) NOT NULL DEFAULT '',
  `multiSRC` blob,
  `orderSRC` blob,
  `useHomeDir` char(1) NOT NULL DEFAULT '',
  `perRow` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `perPage` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `numberOfItems` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `sortBy` varchar(32) NOT NULL DEFAULT '',
  `metaIgnore` char(1) NOT NULL DEFAULT '',
  `galleryTpl` varchar(64) NOT NULL DEFAULT '',
  `customTpl` varchar(64) NOT NULL DEFAULT '',
  `playerSRC` blob,
  `youtube` varchar(16) NOT NULL DEFAULT '',
  `posterSRC` binary(16) DEFAULT NULL,
  `playerSize` varchar(64) NOT NULL DEFAULT '',
  `autoplay` char(1) NOT NULL DEFAULT '',
  `sliderDelay` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `sliderSpeed` int(10) UNSIGNED NOT NULL DEFAULT '300',
  `sliderStartSlide` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `sliderContinuous` char(1) NOT NULL DEFAULT '',
  `cteAlias` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `articleAlias` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `article` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `form` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `module` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `protected` char(1) NOT NULL DEFAULT '',
  `groups` blob,
  `guests` char(1) NOT NULL DEFAULT '',
  `cssID` varchar(255) NOT NULL DEFAULT '',
  `invisible` char(1) NOT NULL DEFAULT '',
  `start` varchar(10) NOT NULL DEFAULT '',
  `stop` varchar(10) NOT NULL DEFAULT '',
  `galerie` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `imagesFolder` blob,
  `overwriteMeta` char(1) NOT NULL DEFAULT '',
  `vimeo` varchar(16) NOT NULL DEFAULT '',
  `youtubeOptions` text,
  `youtubeStart` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `youtubeStop` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `overwriteLink` char(1) NOT NULL DEFAULT '',
  `playerOptions` text,
  `vimeoOptions` text,
  `playerStart` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `playerStop` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_cron` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(32) DEFAULT NULL,
  `value` varchar(32) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_files` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` binary(16) DEFAULT NULL,
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `uuid` binary(16) DEFAULT NULL,
  `type` varchar(16) NOT NULL DEFAULT '',
  `path` varchar(1022) NOT NULL DEFAULT '',
  `extension` varchar(16) NOT NULL DEFAULT '',
  `hash` varchar(32) NOT NULL DEFAULT '',
  `found` char(1) NOT NULL DEFAULT '1',
  `name` varchar(255) NOT NULL DEFAULT '',
  `importantPartX` double UNSIGNED NOT NULL DEFAULT '0',
  `importantPartY` double UNSIGNED NOT NULL DEFAULT '0',
  `importantPartWidth` double UNSIGNED NOT NULL DEFAULT '0',
  `importantPartHeight` double UNSIGNED NOT NULL DEFAULT '0',
  `meta` blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_form` (
  `id` int(10) UNSIGNED NOT NULL,
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `jumpTo` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `sendViaEmail` char(1) NOT NULL DEFAULT '',
  `recipient` varchar(1022) NOT NULL DEFAULT '',
  `subject` varchar(255) NOT NULL DEFAULT '',
  `format` varchar(12) NOT NULL DEFAULT '',
  `skipEmpty` char(1) NOT NULL DEFAULT '',
  `storeValues` char(1) NOT NULL DEFAULT '',
  `targetTable` varchar(64) NOT NULL DEFAULT '',
  `method` varchar(12) NOT NULL DEFAULT '',
  `novalidate` char(1) NOT NULL DEFAULT '',
  `attributes` varchar(255) NOT NULL DEFAULT '',
  `formID` varchar(64) NOT NULL DEFAULT '',
  `allowTags` char(1) NOT NULL DEFAULT '',
  `customTpl` varchar(64) NOT NULL DEFAULT '',
  `nc_notification` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `leadLabel` text,
  `leadMenuLabel` varchar(255) NOT NULL DEFAULT '',
  `leadMaster` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `leadEnabled` char(1) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_form_field` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `sorting` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `invisible` char(1) NOT NULL DEFAULT '',
  `type` varchar(64) NOT NULL DEFAULT '',
  `name` varchar(64) NOT NULL DEFAULT '',
  `label` varchar(255) NOT NULL DEFAULT '',
  `text` text,
  `html` text,
  `options` blob,
  `mandatory` char(1) NOT NULL DEFAULT '',
  `rgxp` varchar(32) NOT NULL DEFAULT '',
  `placeholder` varchar(255) NOT NULL DEFAULT '',
  `minlength` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `maxlength` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `size` varchar(255) NOT NULL DEFAULT '',
  `multiple` char(1) NOT NULL DEFAULT '',
  `mSize` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `extensions` varchar(255) NOT NULL DEFAULT '',
  `storeFile` char(1) NOT NULL DEFAULT '',
  `uploadFolder` binary(16) DEFAULT NULL,
  `useHomeDir` char(1) NOT NULL DEFAULT '',
  `doNotOverwrite` char(1) NOT NULL DEFAULT '',
  `fsType` varchar(32) NOT NULL DEFAULT '',
  `class` varchar(255) NOT NULL DEFAULT '',
  `value` varchar(255) NOT NULL DEFAULT '',
  `accesskey` char(1) NOT NULL DEFAULT '',
  `tabindex` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `fSize` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `customTpl` varchar(64) NOT NULL DEFAULT '',
  `slabel` varchar(255) NOT NULL DEFAULT '',
  `imageSubmit` char(1) NOT NULL DEFAULT '',
  `singleSRC` binary(16) DEFAULT NULL,
  `leadStore` varchar(10) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_galerie` (
  `id` int(10) UNSIGNED NOT NULL,
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `published` char(1) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(128) NOT NULL DEFAULT '',
  `themesSRC` binary(16) DEFAULT NULL,
  `width` varchar(32) NOT NULL DEFAULT 'auto',
  `height` double UNSIGNED NOT NULL DEFAULT '0',
  `transition` varchar(32) NOT NULL DEFAULT '',
  `fullscreenTransition` varchar(32) NOT NULL DEFAULT '',
  `touchTransition` varchar(32) NOT NULL DEFAULT '',
  `initialTransition` varchar(32) NOT NULL DEFAULT '',
  `transitionSpeed` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `clicknext` char(1) NOT NULL DEFAULT '',
  `gShow` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `showInfo` char(1) NOT NULL DEFAULT '',
  `showImagenav` char(1) NOT NULL DEFAULT '',
  `showCounter` char(1) NOT NULL DEFAULT '',
  `lightbox` char(1) NOT NULL DEFAULT '',
  `lightboxFadeSpeed` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lightboxTransitionSpeed` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `overlayBackground` varchar(6) NOT NULL DEFAULT '',
  `overlayOpacity` float UNSIGNED NOT NULL DEFAULT '0',
  `imageCrop` varchar(32) NOT NULL DEFAULT '',
  `imageMargin` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `imagePan` char(1) NOT NULL DEFAULT '',
  `imagePanSmoothness` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `imagePosition` varchar(32) NOT NULL DEFAULT '',
  `thumbPosition` varchar(32) NOT NULL DEFAULT 'center',
  `maxScaleRatio` float UNSIGNED NOT NULL DEFAULT '0',
  `autoplay` char(1) NOT NULL DEFAULT '',
  `autoplayInterval` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `pauseOnInteraction` char(1) NOT NULL DEFAULT '',
  `carousel` char(1) NOT NULL DEFAULT '',
  `carouselSpeed` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `carouselSteps` varchar(32) NOT NULL DEFAULT '',
  `thumbnails` varchar(32) NOT NULL DEFAULT '',
  `thumbCrop` varchar(32) NOT NULL DEFAULT '',
  `thumbMargin` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `thumbQuality` varchar(32) NOT NULL DEFAULT '',
  `easing` varchar(32) NOT NULL DEFAULT '',
  `popupLinks` char(1) NOT NULL DEFAULT '',
  `extend` text,
  `dataConfig` text,
  `preload` varchar(32) NOT NULL DEFAULT '',
  `debug` char(1) NOT NULL DEFAULT '',
  `queue` char(1) NOT NULL DEFAULT '',
  `swipe` char(1) NOT NULL DEFAULT '',
  `fullscreenDoubleTap` char(1) NOT NULL DEFAULT '',
  `flickr` char(1) NOT NULL DEFAULT '',
  `flickrMethods` varchar(32) NOT NULL DEFAULT '',
  `flickrMethodsValue` varchar(32) NOT NULL DEFAULT '',
  `flickrOptMax` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `flickrOptImageSize` varchar(32) NOT NULL DEFAULT '',
  `flickrOptThumbSize` varchar(32) NOT NULL DEFAULT '',
  `flickrOptSort` varchar(32) NOT NULL DEFAULT '',
  `flickrOptDescription` char(1) NOT NULL DEFAULT '',
  `history` char(1) NOT NULL DEFAULT '',
  `dummy` binary(16) DEFAULT NULL,
  `layerFollow` char(1) NOT NULL DEFAULT '',
  `imageTimeout` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `fullscreenCrop` varchar(32) NOT NULL DEFAULT '',
  `picasa` char(1) NOT NULL DEFAULT '',
  `picasaMethods` varchar(32) NOT NULL DEFAULT '',
  `picasaMethodsValue` varchar(32) NOT NULL DEFAULT '',
  `picasaOptMax` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `picasaOptImageSize` varchar(32) NOT NULL DEFAULT '',
  `picasaOptThumbSize` varchar(32) NOT NULL DEFAULT '',
  `dailymotion` text,
  `vimeo` text,
  `youtube` text,
  `trueFullscreen` char(1) NOT NULL DEFAULT '',
  `responsive` char(1) NOT NULL DEFAULT '',
  `wait` varchar(32) NOT NULL DEFAULT '',
  `dataSource` varchar(32) NOT NULL DEFAULT '',
  `dataSelector` varchar(32) NOT NULL DEFAULT '',
  `keepSource` char(1) NOT NULL DEFAULT '',
  `json` text,
  `idleMode` varchar(32) NOT NULL DEFAULT 'true',
  `idleTime` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `idleSpeed` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `thumbDisplayOrder` char(1) NOT NULL DEFAULT '1',
  `dataSort` text,
  `maxVideoSize` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `variation` varchar(32) NOT NULL DEFAULT '',
  `videoPoster` char(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_galerie_pictures` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `sorting` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `published` char(1) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `fullscreenSingleSRC` binary(16) DEFAULT NULL,
  `singleSRC` binary(16) DEFAULT NULL,
  `thumbSRC` binary(16) DEFAULT NULL,
  `alt` text,
  `imageUrl` varchar(255) NOT NULL DEFAULT '',
  `size` varchar(64) NOT NULL DEFAULT '',
  `thumbSize` varchar(64) NOT NULL DEFAULT '',
  `video` varchar(255) NOT NULL DEFAULT '',
  `iframe` varchar(255) NOT NULL DEFAULT '',
  `iframeThumb` char(1) NOT NULL DEFAULT '',
  `dataConfigHTML` text,
  `layerHTML` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_image_size` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(64) DEFAULT NULL,
  `sizes` varchar(255) NOT NULL DEFAULT '',
  `densities` varchar(255) NOT NULL DEFAULT '',
  `width` int(10) DEFAULT NULL,
  `height` int(10) DEFAULT NULL,
  `resizeMode` varchar(255) NOT NULL DEFAULT '',
  `zoom` int(10) DEFAULT NULL,
  `cssClass` varchar(255) NOT NULL DEFAULT '',
  `skipIfDimensionsMatch` char(1) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_image_size_item` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `sorting` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `media` varchar(255) NOT NULL DEFAULT '',
  `sizes` varchar(255) NOT NULL DEFAULT '',
  `densities` varchar(255) NOT NULL DEFAULT '',
  `width` int(10) DEFAULT NULL,
  `height` int(10) DEFAULT NULL,
  `resizeMode` varchar(255) NOT NULL DEFAULT '',
  `zoom` int(10) DEFAULT NULL,
  `invisible` char(1) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_inserttags` (
  `tag` varchar(255) NOT NULL DEFAULT '',
  `replacement` text,
  `disableRTE` char(1) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  `timing` char(1) NOT NULL DEFAULT '',
  `start_date` varchar(255) NOT NULL DEFAULT '',
  `start_time` varchar(255) NOT NULL DEFAULT '',
  `end_date` varchar(255) NOT NULL DEFAULT '',
  `end_time` varchar(255) NOT NULL DEFAULT '',
  `limitpages` char(1) NOT NULL DEFAULT '',
  `pages` blob,
  `includesubpages` char(1) NOT NULL DEFAULT '',
  `limitLanguages` char(1) NOT NULL DEFAULT '',
  `languages` blob,
  `mode` varchar(2) NOT NULL DEFAULT '',
  `cacheOutput` char(1) NOT NULL DEFAULT '',
  `useCondition` char(1) NOT NULL DEFAULT '',
  `conditionType` varchar(255) NOT NULL DEFAULT '',
  `conditionQuery` varchar(255) NOT NULL DEFAULT '',
  `conditionFormula` varchar(255) NOT NULL DEFAULT '',
  `conditionValue` varchar(255) NOT NULL DEFAULT '',
  `useCounter` char(1) NOT NULL DEFAULT '',
  `counterValue` int(5) NOT NULL DEFAULT '0',
  `counterDefault` int(5) NOT NULL DEFAULT '0',
  `counterRepeat` char(1) NOT NULL DEFAULT '',
  `protected` char(1) NOT NULL DEFAULT '',
  `groups` blob,
  `guests` char(1) NOT NULL DEFAULT '',
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `sorting` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_layout` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `rows` varchar(8) NOT NULL DEFAULT '',
  `headerHeight` varchar(255) NOT NULL DEFAULT '',
  `footerHeight` varchar(255) NOT NULL DEFAULT '',
  `cols` varchar(8) NOT NULL DEFAULT '',
  `widthLeft` varchar(255) NOT NULL DEFAULT '',
  `widthRight` varchar(255) NOT NULL DEFAULT '',
  `sections` blob,
  `framework` varchar(255) NOT NULL DEFAULT '',
  `stylesheet` blob,
  `external` blob,
  `loadingOrder` varchar(16) NOT NULL DEFAULT '',
  `modules` blob,
  `template` varchar(64) NOT NULL DEFAULT '',
  `doctype` varchar(32) NOT NULL DEFAULT '',
  `picturefill` char(1) NOT NULL DEFAULT '',
  `viewport` varchar(255) NOT NULL DEFAULT '',
  `titleTag` varchar(255) NOT NULL DEFAULT '',
  `cssClass` varchar(255) NOT NULL DEFAULT '',
  `onload` varchar(255) NOT NULL DEFAULT '',
  `head` text,
  `addJQuery` char(1) NOT NULL DEFAULT '',
  `jSource` varchar(16) NOT NULL DEFAULT '',
  `jquery` text,
  `addMooTools` char(1) NOT NULL DEFAULT '',
  `mooSource` varchar(16) NOT NULL DEFAULT '',
  `mootools` text,
  `analytics` text,
  `script` text,
  `static` char(1) NOT NULL DEFAULT '',
  `width` varchar(255) NOT NULL DEFAULT '',
  `align` varchar(32) NOT NULL DEFAULT '',
  `scripts` text,
  `combineScripts` char(1) NOT NULL DEFAULT '',
  `externalJs` blob,
  `minifyMarkup` char(1) NOT NULL DEFAULT '',
  `defaultImageDensities` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_lead` (
  `id` int(10) UNSIGNED NOT NULL,
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `master_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `form_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `language` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `created` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `member_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `post_data` mediumblob
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_lead_data` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `sorting` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `master_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `field_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value` text COLLATE utf8_unicode_ci,
  `label` text COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_lead_export` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `filename` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `useTemplate` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `template` binary(16) DEFAULT NULL,
  `startIndex` int(11) NOT NULL DEFAULT '0',
  `sheetIndex` int(11) NOT NULL DEFAULT '0',
  `headerFields` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `export` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `fields` blob,
  `tokenFields` blob,
  `lastRun` int(11) DEFAULT NULL,
  `skipLastRun` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `source` varchar(32) NOT NULL DEFAULT '',
  `action` varchar(32) NOT NULL DEFAULT '',
  `username` varchar(64) NOT NULL DEFAULT '',
  `text` text,
  `func` varchar(255) NOT NULL DEFAULT '',
  `ip` varchar(64) NOT NULL DEFAULT '',
  `browser` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_member` (
  `id` int(10) UNSIGNED NOT NULL,
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `firstname` varchar(255) NOT NULL DEFAULT '',
  `lastname` varchar(255) NOT NULL DEFAULT '',
  `dateOfBirth` varchar(11) NOT NULL DEFAULT '',
  `gender` varchar(32) NOT NULL DEFAULT '',
  `company` varchar(255) NOT NULL DEFAULT '',
  `street` varchar(255) NOT NULL DEFAULT '',
  `postal` varchar(32) NOT NULL DEFAULT '',
  `city` varchar(255) NOT NULL DEFAULT '',
  `state` varchar(64) NOT NULL DEFAULT '',
  `country` varchar(2) NOT NULL DEFAULT '',
  `phone` varchar(64) NOT NULL DEFAULT '',
  `mobile` varchar(64) NOT NULL DEFAULT '',
  `fax` varchar(64) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `website` varchar(255) NOT NULL DEFAULT '',
  `language` varchar(5) NOT NULL DEFAULT '',
  `groups` blob,
  `login` char(1) NOT NULL DEFAULT '',
  `username` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `password` varchar(255) NOT NULL DEFAULT '',
  `assignDir` char(1) NOT NULL DEFAULT '',
  `homeDir` binary(16) DEFAULT NULL,
  `disable` char(1) NOT NULL DEFAULT '',
  `start` varchar(10) NOT NULL DEFAULT '',
  `stop` varchar(10) NOT NULL DEFAULT '',
  `dateAdded` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastLogin` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `currentLogin` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `loginCount` smallint(5) UNSIGNED NOT NULL DEFAULT '3',
  `locked` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `session` blob,
  `autologin` varchar(64) DEFAULT NULL,
  `createdOn` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `activation` varchar(32) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_member_group` (
  `id` int(10) UNSIGNED NOT NULL,
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `redirect` char(1) NOT NULL DEFAULT '',
  `jumpTo` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `disable` char(1) NOT NULL DEFAULT '',
  `start` varchar(10) NOT NULL DEFAULT '',
  `stop` varchar(10) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_module` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `headline` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(64) NOT NULL DEFAULT '',
  `levelOffset` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `showLevel` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `hardLimit` char(1) NOT NULL DEFAULT '',
  `showProtected` char(1) NOT NULL DEFAULT '',
  `defineRoot` char(1) NOT NULL DEFAULT '',
  `rootPage` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `navigationTpl` varchar(64) NOT NULL DEFAULT '',
  `customTpl` varchar(64) NOT NULL DEFAULT '',
  `pages` blob,
  `showHidden` char(1) NOT NULL DEFAULT '',
  `customLabel` varchar(64) NOT NULL DEFAULT '',
  `autologin` char(1) NOT NULL DEFAULT '',
  `jumpTo` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `redirectBack` char(1) NOT NULL DEFAULT '',
  `cols` varchar(32) NOT NULL DEFAULT '',
  `editable` blob,
  `memberTpl` varchar(64) NOT NULL DEFAULT '',
  `form` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `queryType` varchar(32) NOT NULL DEFAULT '',
  `fuzzy` char(1) NOT NULL DEFAULT '',
  `contextLength` varchar(64) NOT NULL DEFAULT '',
  `minKeywordLength` smallint(5) UNSIGNED NOT NULL DEFAULT '4',
  `perPage` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `searchType` varchar(32) NOT NULL DEFAULT '',
  `searchTpl` varchar(64) NOT NULL DEFAULT '',
  `inColumn` varchar(32) NOT NULL DEFAULT '',
  `skipFirst` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `loadFirst` char(1) NOT NULL DEFAULT '',
  `size` varchar(64) NOT NULL DEFAULT '',
  `transparent` char(1) NOT NULL DEFAULT '',
  `flashvars` varchar(255) NOT NULL DEFAULT '',
  `altContent` text,
  `source` varchar(32) NOT NULL DEFAULT '',
  `singleSRC` binary(16) DEFAULT NULL,
  `url` varchar(255) NOT NULL DEFAULT '',
  `interactive` char(1) NOT NULL DEFAULT '',
  `flashID` varchar(64) NOT NULL DEFAULT '',
  `flashJS` text,
  `imgSize` varchar(64) NOT NULL DEFAULT '',
  `useCaption` char(1) NOT NULL DEFAULT '',
  `fullsize` char(1) NOT NULL DEFAULT '',
  `multiSRC` blob,
  `orderSRC` blob,
  `html` text,
  `rss_cache` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `rss_feed` text,
  `rss_template` varchar(64) NOT NULL DEFAULT '',
  `numberOfItems` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `disableCaptcha` char(1) NOT NULL DEFAULT '',
  `reg_groups` blob,
  `reg_allowLogin` char(1) NOT NULL DEFAULT '',
  `reg_skipName` char(1) NOT NULL DEFAULT '',
  `reg_close` varchar(32) NOT NULL DEFAULT '',
  `reg_assignDir` char(1) NOT NULL DEFAULT '',
  `reg_homeDir` binary(16) DEFAULT NULL,
  `reg_activate` char(1) NOT NULL DEFAULT '',
  `reg_jumpTo` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `reg_text` text,
  `reg_password` text,
  `protected` char(1) NOT NULL DEFAULT '',
  `groups` blob,
  `guests` char(1) NOT NULL DEFAULT '',
  `cssID` varchar(255) NOT NULL DEFAULT '',
  `galerie` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `imagesFolder` blob,
  `sortBy` varchar(32) NOT NULL DEFAULT '',
  `groupImgSize` varchar(64) NOT NULL DEFAULT '',
  `nc_activation_notification` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `nc_notification` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_nc_gateway` (
  `id` int(10) UNSIGNED NOT NULL,
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `queue_targetGateway` int(11) NOT NULL DEFAULT '0',
  `queue_delay` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `queue_cronEnable` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `queue_cronInterval` varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `queue_cronMessages` int(11) NOT NULL DEFAULT '0',
  `email_overrideSmtp` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email_smtpHost` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email_smtpUser` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email_smtpPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email_smtpEnc` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email_smtpPort` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `file_type` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `file_connection` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `file_host` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `file_port` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `file_username` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `file_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `file_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `postmark_key` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `postmark_test` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `postmark_ssl` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `mailerTransport` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_nc_language` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `gateway_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `language` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `fallback` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `recipients` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `attachment_tokens` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `attachments` blob,
  `attachment_templates` blob,
  `email_sender_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email_sender_address` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email_recipient_cc` text COLLATE utf8_unicode_ci,
  `email_recipient_bcc` text COLLATE utf8_unicode_ci,
  `email_replyTo` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email_subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email_mode` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email_text` text COLLATE utf8_unicode_ci,
  `email_html` text COLLATE utf8_unicode_ci,
  `email_external_images` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `file_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `file_storage_mode` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `file_content` text COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_nc_message` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `gateway` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `gateway_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email_priority` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `email_template` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `postmark_tag` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `postmark_trackOpens` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `published` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_nc_notification` (
  `id` int(10) UNSIGNED NOT NULL,
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `flatten_delimiter` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `templates` blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_nc_queue` (
  `id` int(10) UNSIGNED NOT NULL,
  `sourceQueue` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `targetGateway` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `message` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateAdded` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateDelay` int(10) UNSIGNED DEFAULT NULL,
  `dateSent` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `error` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `tokens` blob,
  `language` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `attachments` blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_page` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `sorting` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `type` varchar(32) NOT NULL DEFAULT '',
  `pageTitle` varchar(255) NOT NULL DEFAULT '',
  `language` varchar(5) NOT NULL DEFAULT '',
  `robots` varchar(32) NOT NULL DEFAULT '',
  `description` text,
  `redirect` varchar(32) NOT NULL DEFAULT '',
  `jumpTo` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `url` varchar(255) NOT NULL DEFAULT '',
  `target` char(1) NOT NULL DEFAULT '',
  `dns` varchar(255) NOT NULL DEFAULT '',
  `staticFiles` varchar(255) NOT NULL DEFAULT '',
  `staticPlugins` varchar(255) NOT NULL DEFAULT '',
  `fallback` char(1) NOT NULL DEFAULT '',
  `adminEmail` varchar(255) NOT NULL DEFAULT '',
  `dateFormat` varchar(32) NOT NULL DEFAULT '',
  `timeFormat` varchar(32) NOT NULL DEFAULT '',
  `datimFormat` varchar(32) NOT NULL DEFAULT '',
  `createSitemap` char(1) NOT NULL DEFAULT '',
  `sitemapName` varchar(32) NOT NULL DEFAULT '',
  `useSSL` char(1) NOT NULL DEFAULT '',
  `autoforward` char(1) NOT NULL DEFAULT '',
  `protected` char(1) NOT NULL DEFAULT '',
  `groups` blob,
  `includeLayout` char(1) NOT NULL DEFAULT '',
  `layout` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `mobileLayout` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `includeCache` char(1) NOT NULL DEFAULT '',
  `cache` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `includeChmod` char(1) NOT NULL DEFAULT '',
  `cuser` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `cgroup` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `chmod` varchar(255) NOT NULL DEFAULT '',
  `noSearch` char(1) NOT NULL DEFAULT '',
  `cssClass` varchar(64) NOT NULL DEFAULT '',
  `sitemap` varchar(32) NOT NULL DEFAULT '',
  `hide` char(1) NOT NULL DEFAULT '',
  `guests` char(1) NOT NULL DEFAULT '',
  `tabindex` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `accesskey` char(1) NOT NULL DEFAULT '',
  `published` char(1) NOT NULL DEFAULT '',
  `start` varchar(10) NOT NULL DEFAULT '',
  `stop` varchar(10) NOT NULL DEFAULT '',
  `clientCache` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `redirectBack` char(1) NOT NULL DEFAULT '',
  `urlPrefix` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `urlSuffix` varchar(16) NOT NULL DEFAULT '.html',
  `useFolderUrl` char(1) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_session` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `sessionID` varchar(128) NOT NULL DEFAULT '',
  `hash` varchar(40) DEFAULT NULL,
  `ip` varchar(64) NOT NULL DEFAULT '',
  `su` char(1) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_style` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `sorting` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `selector` varchar(1022) NOT NULL DEFAULT '',
  `category` varchar(32) NOT NULL DEFAULT '',
  `comment` varchar(255) NOT NULL DEFAULT '',
  `size` char(1) NOT NULL DEFAULT '',
  `width` varchar(64) NOT NULL DEFAULT '',
  `height` varchar(64) NOT NULL DEFAULT '',
  `minwidth` varchar(64) NOT NULL DEFAULT '',
  `minheight` varchar(64) NOT NULL DEFAULT '',
  `maxwidth` varchar(64) NOT NULL DEFAULT '',
  `maxheight` varchar(64) NOT NULL DEFAULT '',
  `positioning` char(1) NOT NULL DEFAULT '',
  `trbl` varchar(128) NOT NULL DEFAULT '',
  `position` varchar(32) NOT NULL DEFAULT '',
  `floating` varchar(32) NOT NULL DEFAULT '',
  `clear` varchar(32) NOT NULL DEFAULT '',
  `overflow` varchar(32) NOT NULL DEFAULT '',
  `display` varchar(32) NOT NULL DEFAULT '',
  `alignment` char(1) NOT NULL DEFAULT '',
  `margin` varchar(128) NOT NULL DEFAULT '',
  `padding` varchar(128) NOT NULL DEFAULT '',
  `align` varchar(32) NOT NULL DEFAULT '',
  `verticalalign` varchar(32) NOT NULL DEFAULT '',
  `textalign` varchar(32) NOT NULL DEFAULT '',
  `whitespace` varchar(8) NOT NULL DEFAULT '',
  `background` char(1) NOT NULL DEFAULT '',
  `bgcolor` varchar(64) NOT NULL DEFAULT '',
  `bgimage` varchar(255) NOT NULL DEFAULT '',
  `bgposition` varchar(32) NOT NULL DEFAULT '',
  `bgrepeat` varchar(32) NOT NULL DEFAULT '',
  `shadowsize` varchar(128) NOT NULL DEFAULT '',
  `shadowcolor` varchar(64) NOT NULL DEFAULT '',
  `gradientAngle` varchar(32) NOT NULL DEFAULT '',
  `gradientColors` varchar(128) NOT NULL DEFAULT '',
  `border` char(1) NOT NULL DEFAULT '',
  `borderwidth` varchar(128) NOT NULL DEFAULT '',
  `borderstyle` varchar(32) NOT NULL DEFAULT '',
  `bordercolor` varchar(64) NOT NULL DEFAULT '',
  `borderradius` varchar(128) NOT NULL DEFAULT '',
  `bordercollapse` varchar(32) NOT NULL DEFAULT '',
  `borderspacing` varchar(64) NOT NULL DEFAULT '',
  `font` char(1) NOT NULL DEFAULT '',
  `fontfamily` varchar(255) NOT NULL DEFAULT '',
  `fontsize` varchar(64) NOT NULL DEFAULT '',
  `fontcolor` varchar(64) NOT NULL DEFAULT '',
  `lineheight` varchar(64) NOT NULL DEFAULT '',
  `fontstyle` varchar(255) NOT NULL DEFAULT '',
  `texttransform` varchar(32) NOT NULL DEFAULT '',
  `textindent` varchar(64) NOT NULL DEFAULT '',
  `letterspacing` varchar(64) NOT NULL DEFAULT '',
  `wordspacing` varchar(64) NOT NULL DEFAULT '',
  `list` char(1) NOT NULL DEFAULT '',
  `liststyletype` varchar(32) NOT NULL DEFAULT '',
  `liststyleimage` varchar(255) NOT NULL DEFAULT '',
  `own` text,
  `invisible` char(1) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_style_sheet` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(64) DEFAULT NULL,
  `embedImages` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `cc` varchar(32) NOT NULL DEFAULT '',
  `media` varchar(255) NOT NULL DEFAULT '',
  `mediaQuery` text,
  `vars` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_theme` (
  `id` int(10) UNSIGNED NOT NULL,
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(128) NOT NULL DEFAULT '',
  `author` varchar(128) NOT NULL DEFAULT '',
  `folders` blob,
  `screenshot` binary(16) DEFAULT NULL,
  `templates` varchar(255) NOT NULL DEFAULT '',
  `vars` text,
  `defaultImageDensities` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_undo` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `fromTable` varchar(255) NOT NULL DEFAULT '',
  `query` text,
  `affectedRows` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `data` mediumblob,
  `haste_data` blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_user` (
  `id` int(10) UNSIGNED NOT NULL,
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `username` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `language` varchar(5) NOT NULL DEFAULT '',
  `backendTheme` varchar(32) NOT NULL DEFAULT '',
  `uploader` varchar(32) NOT NULL DEFAULT '',
  `showHelp` char(1) NOT NULL DEFAULT '',
  `thumbnails` char(1) NOT NULL DEFAULT '',
  `useRTE` char(1) NOT NULL DEFAULT '',
  `useCE` char(1) NOT NULL DEFAULT '',
  `password` varchar(255) NOT NULL DEFAULT '',
  `pwChange` char(1) NOT NULL DEFAULT '',
  `admin` char(1) NOT NULL DEFAULT '',
  `groups` blob,
  `inherit` varchar(12) NOT NULL DEFAULT '',
  `modules` blob,
  `themes` blob,
  `pagemounts` blob,
  `alpty` blob,
  `filemounts` blob,
  `fop` blob,
  `forms` blob,
  `formp` blob,
  `disable` char(1) NOT NULL DEFAULT '',
  `start` varchar(10) NOT NULL DEFAULT '',
  `stop` varchar(10) NOT NULL DEFAULT '',
  `session` blob,
  `dateAdded` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastLogin` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `currentLogin` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `loginCount` smallint(5) UNSIGNED NOT NULL DEFAULT '3',
  `locked` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `galleria` blob,
  `galleria_permission` blob,
  `imageSizes` blob,
  `amg` blob,
  `limitWidth` char(1) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_user_group` (
  `id` int(10) UNSIGNED NOT NULL,
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `modules` blob,
  `themes` blob,
  `pagemounts` blob,
  `alpty` blob,
  `filemounts` blob,
  `fop` blob,
  `forms` blob,
  `formp` blob,
  `alexf` blob,
  `disable` char(1) NOT NULL DEFAULT '',
  `start` varchar(10) NOT NULL DEFAULT '',
  `stop` varchar(10) NOT NULL DEFAULT '',
  `galleria` blob,
  `galleria_permission` blob,
  `imageSizes` blob,
  `amg` blob,
  `elements` blob,
  `fields` blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

CREATE TABLE `tl_version` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `version` smallint(5) UNSIGNED NOT NULL DEFAULT '1',
  `fromTable` varchar(255) NOT NULL DEFAULT '',
  `userid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `username` varchar(64) DEFAULT NULL,
  `description` varchar(255) NOT NULL DEFAULT '',
  `editUrl` text,
  `active` char(1) NOT NULL DEFAULT '',
  `data` mediumblob
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

[cboublob]

Ok, ich habe es selbst gefunden: Da waren noch 2 selbst angelegte Tabellen, die ich hier aus Versehen nicht mit reingepackt habe. Dort war ein Feld vom Typ "Bit". Habe das jetzt über die config.yml auf boolean gemapped und das scheint zu klappen.

Danke für die Hilfe!