Zugriff auf Contao nicht mehr möglich

**mtbler999** · 05.02.2024, 18:59

Hallo,

ich habe vor 4-5 Jahren 2 Websiten mit Contao 4 erstellt. Ich hab diese dann nach kurzer Zeit deaktiviert.
Alle Dateien etc. liegen noch auf dem Server.

Wenn ich jetzt das Contao Backend oder den Contao Manager aufrufen will, kommt nur eine weiße Seite.

Hab ich noch eine Möglichkeit, diese beiden Seiten wieder zum laufen zu bringen?

**Spooky** · 05.02.2024, 19:22

Evt. liegt es an der PHP Version. Welche ist eingestellt?

**mtbler999** · 05.02.2024, 20:06

Da hab ich irgendwann einmal eine Benachrichtigung vom Webhosting Anbieter bekommen, dass sie veraltet ist und ich ein Update machen soll. Hab diese damals dann auf 7.1 geupdatet und sonst nichts weiter gemacht.

**Ainschy** · 06.02.2024, 10:58

PHP 7.1 erhält schon lange keinen Support mehr.

Welche Contao 4 Version hast du den verwendet?

**mtbler999** · 06.02.2024, 16:08

Das müsste Contao 4.4 und Contao 4.5 gewesen sein.

**Ainschy** · 06.02.2024, 16:22

Erst ab Version 4.9 wird PHP8 unterstützt.

Welchen Hoster nutzt du?

**Spooky** · 06.02.2024, 16:25

Zitat von mtbler999

Da hab ich irgendwann einmal eine Benachrichtigung vom Webhosting Anbieter bekommen, dass sie veraltet ist und ich ein Update machen soll. Hab diese damals dann auf 7.1 geupdatet und sonst nichts weiter gemacht.

Nach einem Update der PHP Version musst du auch immer eine vollständige Paketaktualisierung durchführen.

Du schreibst damals: welche PHP Version läuft jetzt?

**mtbler999** · 06.02.2024, 16:39

Zitat von Ainschy

Erst ab Version 4.9 wird PHP8 unterstützt.

Welchen Hoster nutzt du?

Netcup.

**mtbler999** · 06.02.2024, 16:41

Zitat von Spooky

Nach einem Update der PHP Version musst du auch immer eine vollständige Paketaktualisierung durchführen.

Du schreibst damals: welche PHP Version läuft jetzt?

Ich hab jetz 5.6 , 7.0 - 7.4 , 8.0 und 8.1 probiert. Es kommt immer die weiße Seite.

**Spooky** · 06.02.2024, 16:42

Dir wird nichts anderes über bleiben als per SSH und Composer 1.x ein composer update (mit der richtigen PHP Version) durchzuführen. Als PHP Version solltest du entweder 5.6 oder 7.4 wählen, nichts anderes.

**mtbler999** · 06.02.2024, 16:45

gibt es dafür irgendwo eine Anleitung?

**mtbler999** · 06.02.2024, 18:16

Auf meinem Webhosting Control Panel sieht es unter PHP Composer so aus wie auf dem Bild.
Es ist jetzt PHP 7.4 installiert.

Könnt ihr damit was anfangen?

Bildschirmfoto vom 2024-02-06 19-03-28.png

**Spooky** · 06.02.2024, 18:25

In welchem Ordner bist du da? Poste einen größeren Screenshot. Die Funktion von Plesk wirst du aber ohnehin vermutlich nicht nutzen können.

**mtbler999** · 06.02.2024, 18:34

Bildschirmfoto vom 2024-02-06 19-27-47.png

**mtbler999** · 06.02.2024, 18:59

Ich habe mich jetzt über das Terminal von Linux mit ssh verbunden.

Welche Befehle muss ich für das Update eingeben?

In welchem Ordner muss ich sein, wenn ich die Befehle ausführe?

**Spooky** · 06.02.2024, 19:39

Zitat von mtbler999

In welchem Ordner muss ich sein, wenn ich die Befehle ausführe?

In der Contao Installation.

Code:

wget https://getcomposer.org/download/1.10.27/composer.phar

Code:

/usr/local/php7.4/bin/php composer.phar update -o --prefer-dist --no-dev

**mtbler999** · 06.02.2024, 20:54

So sieht die Ordnerstruktur meiner Contao Installation aus.

**mtbler999** · 06.02.2024, 21:01

Zitat von Spooky

In der Contao Installation.

Code:

wget https://getcomposer.org/download/1.10.27/composer.phar

Code:

/usr/local/php7.4/bin/php composer.phar update -o --prefer-dist --no-dev

Ich habe die beiden Befehle ausgeführt.
Dann kommt folgende Meldung:
bash-5.0$ /usr/local/php74/bin/php composer.phar update -o --prefer-dist --no-dev
The "plesk/composer-command-info" plugin was skipped because it requires a Plugin API version ("^2.0") that does not match your Composer installation ("1.1.0"). You may need to run composer update with the "--no-plugins" option.
The "plesk/composer-command-info" plugin was skipped because it requires a Plugin API version ("^2.0") that does not match your Composer installation ("1.1.0"). You may need to run composer update with the "--no-plugins" option.
Composer could not find a composer.json file in /httpdocs
To initialize a project, please create a composer.json file as described in the https://getcomposer.org/ "Getting Started" section
bash-5.0$

Was bedeutet das?

**Spooky** · 06.02.2024, 21:04

Du musst diese Kommandos im Contao Installationsverzeichnis ausführen. Laut dieser Ausgabe hast du das nicht gemacht.

**mtbler999** · 06.02.2024, 21:07

Weil ich im Installationsverzeichniss keinen usr Ordner habe.

**Spooky** · 06.02.2024, 21:08

Zitat von mtbler999

Weil ich im Installationsverzeichniss keinen usr Ordner habe.

Warum willst du dort einen usr Ordner haben?

**mtbler999** · 06.02.2024, 21:10

Weil bei deinem Code der dort steht. Und wenn ich den Code im Installationsverzeichniss eingebe, heisst es immer Verzeichniss nicht gefunden.

bash-5.0$ /httpdocs/test/usr/local/php7.4/bin/php composer.phar update -o --prefer-dist --no-dev
bash: /httpdocs/test/usr/local/php7.4/bin/php: Datei oder Verzeichnis nicht gefunden
bash-5.0$

**Spooky** · 06.02.2024, 21:17

Zitat von mtbler999

Weil bei deinem Code der dort steht.

/usr/local/php7.4/bin/php ist ein absoluter Pfad und hats nichts mit deiner Contao Installation zu tun - das ist (möglicherweise) der Pfad zu deinem entsprechenden PHP CLI.

**mtbler999** · 06.02.2024, 21:19

Warum bekomme ich dann die Fehlermeldung im Beitrag 22?

**Spooky** · 06.02.2024, 21:20

Zitat von mtbler999

Und wenn ich den Code im Installationsverzeichniss eingebe, heisst es immer Verzeichniss nicht gefunden.

bash-5.0$ /httpdocs/test/usr/local/php7.4/bin/php composer.phar update -o --prefer-dist --no-dev
bash: /httpdocs/test/usr/local/php7.4/bin/php: Datei oder Verzeichnis nicht gefunden
bash-5.0$

Du gibst das Kommando falsch ein. Du musst es so eingeben wie oben beschreiben.

**mtbler999** · 06.02.2024, 21:27

Jetzt bin ich zuerst ín das Installationsverzeichnis und habe dann nochmal beide Befehle eingegeben.

bash-5.0$ wget https://getcomposer.org/download/1.10.27/composer.phar
--2024-02-06 22:24:41-- https://getcomposer.org/download/1.10.27/composer.phar
Auflösen des Hostnamens getcomposer.org (getcomposer.org)… 2001:41d0:302:1100::8:104f, 54.36.53.46
Verbindungsaufbau zu getcomposer.org (getcomposer.org)|2001:41d0:302:1100::8:104f|:443 … verbunden.
HTTP-Anforderung gesendet, auf Antwort wird gewartet … 200 OK
Länge: 2009199 (1,9M) [application/octet-stream]
Wird in »composer.phar« gespeichert.

composer.phar 100%[===================>] 1,92M --.-KB/s in 0,09s

2024-02-06 22:24:41 (20,8 MB/s) - »composer.phar« gespeichert [2009199/2009199]

bash-5.0$ /usr/local/php7.4/bin/php composer.phar update -o --prefer-dist --no-dev
bash: /usr/local/php7.4/bin/php: Datei oder Verzeichnis nicht gefunden
bash-5.0$

**Spooky** · 06.02.2024, 21:28

Zitat von mtbler999

bash: /usr/local/php7.4/bin/php: Datei oder Verzeichnis nicht gefunden

Du musst den korrekten Pfad zum PHP CLI für deine PHP Version ermitteln. Evt. musst du dafür den Hoster kontaktieren.

**mtbler999** · 06.02.2024, 21:36

Im Bild siehst du die Ordnerstruktur von meinem Webhosting Startverzeichnis.
Hier hätte ich den usr/local Ordner wo dann unterschiedliche PHP Versionsordner drin sind.
In dem httpdocs Ordner sind meine Contao Installationen.
Deshalb funktioniert es denke ich nicht.

Bildschirmfoto vom 2024-02-06 22-31-46.png

**Spooky** · 06.02.2024, 21:38

Du musst wie gesagt den Pfad zum entsprechenden PHP CLI ermitteln - und dazu evt. deinen Hoster fragen.

***xchs*** · 06.02.2024, 21:42

Das sollte der korrekte Pfad zum PHP CLI sein:

Code:

/usr/local/php74/bin/php

Führe also bitte den folgenden Befehl im Installationsverzeichnis Deiner Contao-Installation aus:

Code:

/usr/local/php74/bin/php composer.phar update -o --prefer-dist --no-dev

**mtbler999** · 06.02.2024, 21:49

Dann kommt folgendes.

bash-5.0$ ls
app composer.json composer.phar files templates vendor
assets composer.lock contao-manager system var web
bash-5.0$ /usr/local/php74/bin/php composer.phar update -o --prefer-dist --no-dev
Using config.component-dir has been deprecated. Please use extra.contao-component-dir instead.
The "plesk/composer-command-info" plugin was skipped because it requires a Plugin API version ("^2.0") that does not match your Composer installation ("1.1.0"). You may need to run composer update with the "--no-plugins" option.
Loading composer repositories with package information
Warning from https://repo.packagist.org: Support for Composer 1 is deprecated and some packages will not be available. You should upgrade to Composer 2. See https://blog.packagist.com/deprecati...ser-1-support/
Updating dependencies

Fatal error: Allowed memory size of 1610612736 bytes exhausted (tried to allocate 167772160 bytes) in phar:///httpdocs/test/composer.phar/src/Composer/DependencyResolver/RuleSet.php on line 90

Check https://getcomposer.org/doc/articles...y-limit-errors for more info on how to handle out of memory errors.bash-5.0$

***xchs*** · 06.02.2024, 21:55

Das ist natürlich jetzt etwas blöd, wenn der verfügbare Speicher grad nicht ausreicht, um die Paketabhängigkeiten aufzulösen.

Was steht denn alles in Deiner composer.json?

**mtbler999** · 06.02.2024, 22:03

Code:

{
    "name": "contao/managed-edition",
    "type": "project",
    "description": "Contao Open Source CMS",
    "license": "LGPL-3.0+",
    "authors": [
        {
            "name": "Leo Feyer",
            "homepage": "https://github.com/leofeyer"
        }
    ],
    "require": {
        "php": "^5.6|^7.0",
        "contao/calendar-bundle": "^4.4",
        "contao/comments-bundle": "^4.4",
        "contao/conflicts": "*@dev",
        "contao/faq-bundle": "^4.4",
        "contao/listing-bundle": "^4.4",
        "contao/manager-bundle": "4.4.*",
        "contao/news-bundle": "^4.4",
        "contao/newsletter-bundle": "^4.4"
    },
    "conflict": {
        "contao/core-bundle": "<4.4.8 4.4.39"
    },
    "config": {
        "component-dir": "assets"
    },
    "scripts": {
        "post-install-cmd": [
            "Contao\\ManagerBundle\\Composer\\ScriptHandler::initializeApplication"
        ],
        "post-update-cmd": [
            "Contao\\ManagerBundle\\Composer\\ScriptHandler::initializeApplication"
        ]
    }
}

Versteh ich das richtig, dass ich entweder php 5.6 oder 7.0 nutzen soll?

**Spooky** · 06.02.2024, 22:16

Du könntest versuchen direkt auf Contao 4.13 zu aktualisieren. Dazu änderst du die composer.json wie folgt:

Code:

{
    "name": "contao/managed-edition",
    "description": "Contao Managed Edition",
    "license": "LGPL-3.0-or-later",
    "type": "project",
    "require": {
        "contao/calendar-bundle": "^4.13",
        "contao/comments-bundle": "^4.13",
        "contao/conflicts": "@dev",
        "contao/faq-bundle": "^4.13",
        "contao/listing-bundle": "^4.13",
        "contao/manager-bundle": "4.13.*",
        "contao/news-bundle": "^4.13",
        "contao/newsletter-bundle": "^4.13"
    },
    "conflict": {
        "contao-components/installer": "<1.3"
    },
    "config": {
        "allow-plugins": {
            "composer/package-versions-deprecated": true,
            "contao-community-alliance/composer-plugin": true,
            "contao-components/installer": true,
            "contao/manager-plugin": true,
            "php-http/discovery": false
        }
    },
    "extra": {
        "contao-component-dir": "assets"
    },
    "scripts": {
        "post-install-cmd": [
            "@php vendor/bin/contao-setup"
        ],
        "post-update-cmd": [
            "@php vendor/bin/contao-setup"
        ]
    }
}

Danach folgende Kommandos ausführen:

Code:

/usr/local/php74/bin/php composer.phar self-update --2

Code:

/usr/local/php74/bin/php composer.phar update -o --prefer-dist --no-dev

Code:

/usr/local/php74/bin/php vendor/bin/contao-console contao:migrate --no-interaction

**mtbler999** · 06.02.2024, 22:29

er hat jetzt einiges gemacht. Die Seite bleibt weiterhin weiß.

Code:

bash-5.0$ /usr/local/php74/bin/php composer.phar self-update --2
The "plesk/composer-command-info" plugin was skipped because it requires a Plugin API version ("^2.0") that does not match your Composer installation ("1.1.0"). You may need to run composer update with the "--no-plugins" option.
Updating to version 2.6.6 (2.x channel).
   Downloading (100%)         
Use composer self-update --rollback to return to version 1.10.27
bash-5.0$ /usr/local/php74/bin/php composer.phar update -o --prefer-dist --no-dev
The "contao-components/installer" plugin was skipped because it requires a Plugin API version ("^1.0") that does not match your Composer installation ("2.6.0"). You may need to run composer update with the "--no-plugins" option.
The "contao-community-alliance/composer-plugin" plugin was skipped because it requires a Plugin API version ("^1.0") that does not match your Composer installation ("2.6.0"). You may need to run composer update with the "--no-plugins" option.
The "contao/manager-plugin" plugin was skipped because it requires a Plugin API version ("^1.1") that does not match your Composer installation ("2.6.0"). You may need to run composer update with the "--no-plugins" option.
The "robloach/component-installer" plugin was skipped because it requires a Plugin API version ("^1.0") that does not match your Composer installation ("2.6.0"). You may need to run composer update with the "--no-plugins" option.
Loading composer repositories with package information
Updating dependencies
Lock file operations: 102 installs, 71 updates, 53 removals
  - Removing cliffparnitzky/tiny-mce-font-awesome (2.1.1)
  - Removing cliffparnitzky/tiny-mce-noneditable (1.0.0)
  - Removing cliffparnitzky/tiny-mce-plugin-loader (2.1.9)
  - Removing cliffparnitzky/tiny-mce-text-color (1.1.0)
  - Removing codefog/contao-cookiebar (2.1.4)
  - Removing components/font-awesome (4.7.0)
  - Removing contao-community-alliance/composer-plugin (3.0.9)
  - Removing contao-community-alliance/meta-palettes (2.0.6)
  - Removing contao-components/compass (0.12.2.1)
  - Removing contao-components/highlight (8.9.1)
  - Removing contao-components/html5shiv (3.7.3)
  - Removing contao-components/mediaelement (4.2.10)
  - Removing contao-components/respimage (1.4.2)
  - Removing doctrine/doctrine-cache-bundle (1.3.5)
  - Removing doctrine/reflection (v1.0.0)
  - Removing erdmannfreunde/theme-toolbox (1.0.0)
  - Removing fig/link-util (1.0.0)
  - Removing guzzlehttp/guzzle (6.3.3)
  - Removing guzzlehttp/promises (v1.3.1)
  - Removing guzzlehttp/psr7 (1.5.2)
  - Removing jdorn/sql-formatter (v1.2.17)
  - Removing jeremykendall/php-domain-parser (3.0.0)
  - Removing kriswallsmith/assetic (v1.4.0)
  - Removing leafo/scssphp (v0.7.7)
  - Removing league/uri (4.2.2)
  - Removing lexik/maintenance-bundle (v2.1.5)
  - Removing michelf/php-markdown (1.8.0)
  - Removing netzmacht/contao-font-awesome (4.7.2)
  - Removing netzmacht/contao-font-awesome-inserttag (2.0.1)
  - Removing netzmacht/contao-iconwizard (1.2.3)
  - Removing oyejorge/less.php (v1.7.0.14)
  - Removing patchwork/utf8 (v1.3.1)
  - Removing php-http/guzzle6-adapter (v1.1.1)
  - Removing phpunit/php-token-stream (3.0.1)
  - Removing psr/link (1.0.0)
  - Removing psr/simple-cache (1.0.1)
  - Removing ralouphie/getallheaders (2.0.5)
  - Removing robloach/component-installer (0.2.3)
  - Removing sensio/distribution-bundle (v5.0.24)
  - Removing sensiolabs/security-checker (v5.0.3)
  - Removing swiftmailer/swiftmailer (v5.4.12)
  - Removing symfony/polyfill-apcu (v1.11.0)
  - Removing symfony/polyfill-intl-icu (v1.11.0)
  - Removing symfony/polyfill-php56 (v1.11.0)
  - Removing symfony/polyfill-php70 (v1.11.0)
  - Removing symfony/polyfill-util (v1.11.0)
  - Removing symfony/swiftmailer-bundle (v2.6.7)
  - Removing symfony/symfony (v3.4.27)
  - Removing tecnickcom/tcpdf (6.2.26)
  - Removing terminal42/header-replay-bundle (1.5.3)
  - Removing true/punycode (v2.1.1)
  - Removing webmozart/assert (1.4.0)
  - Removing webmozart/path-util (2.3.0)
  - Locking ausi/slug-generator (v1.1.1)
  - Locking bacon/bacon-qr-code (2.0.8)
  - Locking beberlei/assert (v3.3.2)
  - Upgrading clue/stream-filter (v1.4.1 => v1.7.0)
  - Upgrading composer/ca-bundle (1.1.4 => 1.4.0)
  - Upgrading contao-components/ace (1.4.2 => 1.32.5)
  - Upgrading contao-components/chosen (1.2.1 => 1.2.5)
  - Upgrading contao-components/colorbox (1.6.4.1 => 1.6.6)
  - Upgrading contao-components/colorpicker (1.5.0 => 1.5.3)
  - Upgrading contao-components/contao (7.1.5 => 9.3.4)
  - Upgrading contao-components/datepicker (2.3.0 => 2.3.2)
  - Upgrading contao-components/dropzone (4.3.0 => 5.9.3)
  - Upgrading contao-components/installer (1.3.1 => 1.4.1)
  - Upgrading contao-components/jquery (1.12.4 => 3.7.1)
  - Upgrading contao-components/jquery-ui (1.12.1.1 => 1.13.2)
  - Upgrading contao-components/mediabox (1.5.4.2 => 1.5.5)
  - Upgrading contao-components/mootools (1.6.0.5 => 1.6.0.7)
  - Upgrading contao-components/simplemodal (2.1.0 => 2.1.2)
  - Upgrading contao-components/swipe (2.1.2 => 2.2.1)
  - Upgrading contao-components/tablesort (3.4.11 => 4.0.1)
  - Upgrading contao-components/tablesorter (2.1.0 => 2.31.3)
  - Upgrading contao-components/tinymce4 (4.6.7.2 => 5.10.9)
  - Upgrading contao/calendar-bundle (4.4.32 => 4.13.36)
  - Upgrading contao/comments-bundle (4.4.32 => 4.13.36)
  - Upgrading contao/conflicts (dev-master a3fd5c0 => dev-main 8d5342f)
  - Upgrading contao/core-bundle (4.4.32 => 4.13.36)
  - Upgrading contao/faq-bundle (4.4.32 => 4.13.36)
  - Upgrading contao/image (0.3.9 => 1.2.0)
  - Upgrading contao/imagine-svg (0.2.2 => 1.0.3)
  - Upgrading contao/installation-bundle (4.4.32 => 4.13.36)
  - Upgrading contao/listing-bundle (4.4.32 => 4.13.36)
  - Upgrading contao/manager-bundle (4.4.32 => 4.13.36)
  - Upgrading contao/manager-plugin (2.7.0 => 2.13.1)
  - Upgrading contao/news-bundle (4.4.32 => 4.13.36)
  - Upgrading contao/newsletter-bundle (4.4.32 => 4.13.36)
  - Locking dasprid/enum (1.0.5)
  - Locking dflydev/dot-access-data (v3.0.2)
  - Upgrading doctrine/annotations (v1.6.1 => 2.0.1)
  - Upgrading doctrine/cache (v1.8.0 => 2.2.0)
  - Upgrading doctrine/collections (v1.6.1 => 1.8.0)
  - Upgrading doctrine/common (v2.10.0 => 3.4.3)
  - Upgrading doctrine/dbal (v2.8.1 => 3.8.1)
  - Locking doctrine/deprecations (1.1.3)
  - Upgrading doctrine/doctrine-bundle (1.10.2 => 2.11.2)
  - Upgrading doctrine/event-manager (v1.0.0 => 1.2.0)
  - Upgrading doctrine/inflector (v1.3.0 => 2.0.9)
  - Locking doctrine/instantiator (1.5.0)
  - Upgrading doctrine/lexer (v1.0.1 => 2.1.1)
  - Locking doctrine/orm (2.18.0)
  - Upgrading doctrine/persistence (1.1.1 => 2.5.7)
  - Locking doctrine/sql-formatter (1.1.3)
  - Locking dragonmantank/cron-expression (v2.3.1)
  - Locking egulias/email-validator (3.2.6)
  - Upgrading friendsofsymfony/http-cache (2.6.0 => 2.15.3)
  - Upgrading friendsofsymfony/http-cache-bundle (2.6.1 => 2.17.0)
  - Upgrading imagine/imagine (v0.7.1 => 1.3.5)
  - Upgrading knplabs/knp-menu (2.3.0 => v3.3.0)
  - Upgrading knplabs/knp-menu-bundle (v2.2.1 => v3.2.0)
  - Upgrading knplabs/knp-time-bundle (v1.9.1 => v1.20.0)
  - Locking lcobucci/clock (2.0.0)
  - Locking lcobucci/jwt (4.1.5)
  - Locking league/commonmark (2.4.2)
  - Locking league/config (v1.2.0)
  - Locking league/flysystem (2.5.0)
  - Locking league/flysystem-bundle (2.4.0)
  - Locking league/mime-type-detection (1.15.0)
  - Upgrading matthiasmullie/minify (1.3.61 => 1.3.71)
  - Upgrading matthiasmullie/path-converter (1.1.2 => 1.1.3)
  - Upgrading monolog/monolog (1.24.0 => 2.9.2)
  - Upgrading nelmio/cors-bundle (1.5.5 => 2.4.0)
  - Upgrading nelmio/security-bundle (2.7.0 => v2.12.0)
  - Locking nette/schema (v1.2.5)
  - Locking nette/utils (v3.2.10)
  - Locking nikic/php-parser (v4.18.0)
  - Locking nyholm/psr7 (1.8.1)
  - Locking paragonie/constant_time_encoding (v2.6.3)
  - Upgrading paragonie/random_compat (v9.99.99 => v9.99.100)
  - Upgrading php-http/client-common (1.9.1 => 2.7.1)
  - Upgrading php-http/discovery (1.6.1 => 1.19.2)
  - Upgrading php-http/httplug (v1.1.0 => 2.4.0)
  - Upgrading php-http/message (1.7.2 => 1.16.0)
  - Upgrading php-http/message-factory (v1.0.2 => 1.1.0)
  - Upgrading php-http/promise (v1.0.0 => 1.3.0)
  - Upgrading phpspec/php-diff (v1.1.0 => v1.1.3)
  - Upgrading psr/container (1.0.0 => 1.1.2)
  - Locking psr/event-dispatcher (1.0.0)
  - Locking psr/http-client (1.0.3)
  - Locking psr/http-factory (1.0.2)
  - Upgrading psr/http-message (1.0.1 => 1.1)
  - Upgrading psr/log (1.1.0 => 1.1.4)
  - Locking scheb/2fa-backup-code (v5.13.2)
  - Locking scheb/2fa-bundle (v5.13.2)
  - Locking scheb/2fa-trusted-device (v5.13.2)
  - Locking scrivo/highlight.php (v9.18.1.10)
  - Locking scssphp/scssphp (v1.12.1)
  - Upgrading sensiolabs/ansi-to-html (v1.1.3 => v1.2.1)
  - Upgrading simplepie/simplepie (1.5.2 => 1.8.0)
  - Locking spatie/schema-org (3.9.0)
  - Locking spomky-labs/otphp (v10.0.3)
  - Locking symfony-cmf/routing (2.3.4)
  - Locking symfony-cmf/routing-bundle (2.5.1)
  - Locking symfony/asset (v5.4.35)
  - Locking symfony/cache (v5.4.35)
  - Locking symfony/cache-contracts (v2.5.2)
  - Locking symfony/config (v5.4.35)
  - Locking symfony/console (v5.4.35)
  - Locking symfony/debug-bundle (v5.4.35)
  - Locking symfony/dependency-injection (v5.4.35)
  - Locking symfony/deprecation-contracts (v2.5.2)
  - Locking symfony/doctrine-bridge (v5.4.35)
  - Locking symfony/dom-crawler (v5.4.35)
  - Locking symfony/dotenv (v5.4.35)
  - Locking symfony/error-handler (v5.4.35)
  - Locking symfony/event-dispatcher (v5.4.35)
  - Locking symfony/event-dispatcher-contracts (v2.5.2)
  - Locking symfony/expression-language (v5.4.35)
  - Locking symfony/filesystem (v5.4.35)
  - Locking symfony/finder (v5.4.35)
  - Locking symfony/framework-bundle (v5.4.35)
  - Locking symfony/http-client (v5.4.35)
  - Locking symfony/http-client-contracts (v2.5.2)
  - Locking symfony/http-foundation (v5.4.35)
  - Locking symfony/http-kernel (v5.4.35)
  - Locking symfony/intl (v5.4.35)
  - Locking symfony/lock (v5.4.35)
  - Locking symfony/mailer (v5.4.35)
  - Locking symfony/mime (v5.4.35)
  - Locking symfony/monolog-bridge (v5.4.35)
  - Upgrading symfony/monolog-bundle (v3.3.1 => v3.10.0)
  - Locking symfony/options-resolver (v5.4.21)
  - Locking symfony/password-hasher (v5.4.35)
  - Upgrading symfony/polyfill-ctype (v1.11.0 => v1.29.0)
  - Locking symfony/polyfill-intl-grapheme (v1.29.0)
  - Locking symfony/polyfill-intl-idn (v1.29.0)
  - Locking symfony/polyfill-intl-normalizer (v1.29.0)
  - Upgrading symfony/polyfill-mbstring (v1.11.0 => v1.29.0)
  - Locking symfony/polyfill-php72 (v1.29.0)
  - Locking symfony/polyfill-php73 (v1.29.0)
  - Locking symfony/polyfill-php80 (v1.29.0)
  - Locking symfony/polyfill-php81 (v1.29.0)
  - Locking symfony/polyfill-uuid (v1.29.0)
  - Locking symfony/process (v5.4.35)
  - Locking symfony/property-access (v5.4.35)
  - Locking symfony/property-info (v5.4.35)
  - Locking symfony/routing (v5.4.35)
  - Locking symfony/security-bundle (v5.4.35)
  - Locking symfony/security-core (v5.4.35)
  - Locking symfony/security-csrf (v5.4.35)
  - Locking symfony/security-guard (v5.4.35)
  - Locking symfony/security-http (v5.4.35)
  - Locking symfony/service-contracts (v2.5.2)
  - Locking symfony/stopwatch (v5.4.35)
  - Locking symfony/string (v5.4.35)
  - Locking symfony/templating (v5.4.35)
  - Locking symfony/translation (v5.4.35)
  - Locking symfony/translation-contracts (v2.5.2)
  - Locking symfony/twig-bridge (v5.4.35)
  - Locking symfony/twig-bundle (v5.4.35)
  - Locking symfony/uid (v5.4.35)
  - Locking symfony/var-dumper (v5.4.35)
  - Locking symfony/var-exporter (v5.4.35)
  - Locking symfony/web-profiler-bundle (v5.4.35)
  - Locking symfony/yaml (v5.4.35)
  - Locking terminal42/escargot (1.5.3)
  - Locking terminal42/service-annotation-bundle (1.1.5)
  - Locking thecodingmachine/safe (v1.3.3)
  - Locking toflar/psr6-symfony-http-cache-store (3.0.1)
  - Locking twig/extra-bundle (v3.8.0)
  - Upgrading twig/twig (v1.40.1 => v3.8.0)
  - Upgrading ua-parser/uap-php (v3.8.8 => v3.9.14)
  - Locking webignition/disallowed-character-terminated-string (2.0)
  - Locking webignition/robots-txt-file (3.0)
  - Locking wikimedia/less.php (1.8.2)
Writing lock file
Installing dependencies from lock file
Package operations: 118 installs, 55 updates, 49 removals
  - Downloading php-http/discovery (1.19.2)
  - Downloading symfony/polyfill-mbstring (v1.29.0)
  - Downloading symfony/polyfill-ctype (v1.29.0)
  - Downloading symfony/deprecation-contracts (v2.5.2)
  - Downloading symfony/polyfill-php80 (v1.29.0)
  - Downloading symfony/polyfill-php73 (v1.29.0)
  - Downloading symfony/http-foundation (v5.4.35)
  - Downloading psr/event-dispatcher (1.0.0)
  - Downloading symfony/event-dispatcher-contracts (v2.5.2)
  - Downloading symfony/event-dispatcher (v5.4.35)
  - Downloading symfony/var-dumper (v5.4.35)
  - Downloading psr/log (1.1.4)
  - Downloading symfony/error-handler (v5.4.35)
  - Downloading symfony/http-kernel (v5.4.35)
  - Downloading psr/container (1.1.2)
  - Downloading symfony/service-contracts (v2.5.2)
  - Downloading symfony/polyfill-php81 (v1.29.0)
  - Downloading symfony/dependency-injection (v5.4.35)
  - Downloading symfony/filesystem (v5.4.35)
  - Downloading symfony/config (v5.4.35)
  - Downloading symfony/routing (v5.4.35)
  - Downloading contao/manager-plugin (2.13.1)
  - Downloading ausi/slug-generator (v1.1.1)
  - Downloading dasprid/enum (1.0.5)
  - Downloading bacon/bacon-qr-code (2.0.8)
  - Downloading contao-components/ace (1.32.5)
  - Downloading contao-components/chosen (1.2.5)
  - Downloading contao-components/colorbox (1.6.6)
  - Downloading contao-components/colorpicker (1.5.3)
  - Downloading contao-components/contao (9.3.4)
  - Downloading contao-components/datepicker (2.3.2)
  - Downloading contao-components/dropzone (5.9.3)
  - Downloading contao-components/jquery (3.7.1)
  - Downloading contao-components/jquery-ui (1.13.2)
  - Downloading contao-components/mediabox (1.5.5)
  - Downloading contao-components/mootools (1.6.0.7)
  - Downloading contao-components/simplemodal (2.1.2)
  - Downloading contao-components/swipe (2.2.1)
  - Downloading contao-components/tablesort (4.0.1)
  - Downloading contao-components/tablesorter (2.31.3)
  - Downloading contao-components/tinymce4 (5.10.9)
  - Downloading symfony/yaml (v5.4.35)
  - Downloading symfony/options-resolver (v5.4.21)
  - Downloading psr/http-message (1.1)
  - Downloading php-http/message-factory (1.1.0)
  - Downloading clue/stream-filter (v1.7.0)
  - Downloading php-http/message (1.16.0)
  - Downloading symfony/http-client-contracts (v2.5.2)
  - Downloading symfony/http-client (v5.4.35)
  - Downloading psr/http-factory (1.0.2)
  - Downloading psr/http-client (1.0.3)
  - Downloading php-http/promise (1.3.0)
  - Downloading php-http/httplug (2.4.0)
  - Downloading php-http/client-common (2.7.1)
  - Downloading friendsofsymfony/http-cache (2.15.3)
  - Downloading wikimedia/less.php (1.8.2)
  - Downloading webignition/disallowed-character-terminated-string (2.0)
  - Downloading webignition/robots-txt-file (3.0)
  - Downloading composer/ca-bundle (1.4.0)
  - Downloading ua-parser/uap-php (v3.9.14)
  - Downloading twig/twig (v3.8.0)
  - Downloading doctrine/deprecations (1.1.3)
  - Downloading doctrine/lexer (2.1.1)
  - Downloading doctrine/annotations (2.0.1)
  - Downloading terminal42/service-annotation-bundle (1.1.5)
  - Downloading symfony/dom-crawler (v5.4.35)
  - Downloading nyholm/psr7 (1.8.1)
  - Downloading terminal42/escargot (1.5.3)
  - Downloading symfony/polyfill-uuid (v1.29.0)
  - Downloading symfony/uid (v5.4.35)
  - Downloading symfony/translation-contracts (v2.5.2)
  - Downloading symfony/twig-bridge (v5.4.35)
  - Downloading symfony/twig-bundle (v5.4.35)
  - Downloading symfony/translation (v5.4.35)
  - Downloading symfony/polyfill-intl-normalizer (v1.29.0)
  - Downloading symfony/polyfill-intl-grapheme (v1.29.0)
  - Downloading symfony/string (v5.4.35)
  - Downloading symfony/password-hasher (v5.4.35)
  - Downloading symfony/security-core (v5.4.35)
  - Downloading symfony/property-info (v5.4.35)
  - Downloading symfony/property-access (v5.4.35)
  - Downloading symfony/security-http (v5.4.35)
  - Downloading symfony/security-csrf (v5.4.35)
  - Downloading symfony/security-guard (v5.4.35)
  - Downloading symfony/security-bundle (v5.4.35)
  - Downloading symfony/process (v5.4.35)
  - Downloading symfony/polyfill-php72 (v1.29.0)
  - Downloading symfony/polyfill-intl-idn (v1.29.0)
  - Downloading monolog/monolog (2.9.2)
  - Downloading symfony/monolog-bridge (v5.4.35)
  - Downloading symfony/mime (v5.4.35)
  - Downloading egulias/email-validator (3.2.6)
  - Downloading symfony/mailer (v5.4.35)
  - Downloading symfony/lock (v5.4.35)
  - Downloading symfony/intl (v5.4.35)
  - Downloading symfony/finder (v5.4.35)
  - Downloading symfony/var-exporter (v5.4.35)
  - Downloading symfony/cache-contracts (v2.5.2)
  - Downloading symfony/cache (v5.4.35)
  - Downloading symfony/framework-bundle (v5.4.35)
  - Downloading symfony/expression-language (v5.4.35)
  - Downloading doctrine/event-manager (1.2.0)
  - Downloading doctrine/collections (1.8.0)
  - Downloading doctrine/cache (2.2.0)
  - Downloading doctrine/persistence (2.5.7)
  - Downloading symfony/doctrine-bridge (v5.4.35)
  - Downloading symfony/console (v5.4.35)
  - Downloading symfony/asset (v5.4.35)
  - Downloading symfony-cmf/routing (2.3.4)
  - Downloading symfony-cmf/routing-bundle (2.5.1)
  - Downloading thecodingmachine/safe (v1.3.3)
  - Downloading paragonie/constant_time_encoding (v2.6.3)
  - Downloading beberlei/assert (v3.3.2)
  - Downloading spomky-labs/otphp (v10.0.3)
  - Downloading spatie/schema-org (3.9.0)
  - Downloading simplepie/simplepie (1.8.0)
  - Downloading scssphp/scssphp (v1.12.1)
  - Downloading scrivo/highlight.php (v9.18.1.10)
  - Downloading scheb/2fa-bundle (v5.13.2)
  - Downloading lcobucci/clock (2.0.0)
  - Downloading lcobucci/jwt (4.1.5)
  - Downloading scheb/2fa-trusted-device (v5.13.2)
  - Downloading scheb/2fa-backup-code (v5.13.2)
  - Downloading phpspec/php-diff (v1.1.3)
  - Downloading nikic/php-parser (v4.18.0)
  - Downloading paragonie/random_compat (v9.99.100)
  - Downloading nelmio/security-bundle (v2.12.0)
  - Downloading nelmio/cors-bundle (2.4.0)
  - Downloading matthiasmullie/path-converter (1.1.3)
  - Downloading matthiasmullie/minify (1.3.71)
  - Downloading league/mime-type-detection (1.15.0)
  - Downloading league/flysystem (2.5.0)
  - Downloading league/flysystem-bundle (2.4.0)
  - Downloading nette/utils (v3.2.10)
  - Downloading nette/schema (v1.2.5)
  - Downloading dflydev/dot-access-data (v3.0.2)
  - Downloading league/config (v1.2.0)
  - Downloading league/commonmark (2.4.2)
  - Downloading symfony/templating (v5.4.35)
  - Downloading knplabs/knp-time-bundle (v1.20.0)
  - Downloading knplabs/knp-menu (v3.3.0)
  - Downloading knplabs/knp-menu-bundle (v3.2.0)
  - Downloading imagine/imagine (1.3.5)
  - Downloading friendsofsymfony/http-cache-bundle (2.17.0)
  - Downloading dragonmantank/cron-expression (v2.3.1)
  - Downloading doctrine/instantiator (1.5.0)
  - Downloading doctrine/inflector (2.0.9)
  - Downloading doctrine/dbal (3.8.1)
  - Downloading doctrine/common (3.4.3)
  - Downloading doctrine/orm (2.18.0)
  - Downloading doctrine/sql-formatter (1.1.3)
  - Downloading doctrine/doctrine-bundle (2.11.2)
  - Downloading contao/imagine-svg (1.0.3)
  - Downloading contao/image (1.2.0)
  - Downloading contao/core-bundle (4.13.36)
  - Downloading contao/calendar-bundle (4.13.36)
  - Downloading contao/comments-bundle (4.13.36)
  - Downloading contao/faq-bundle (4.13.36)
  - Downloading contao/listing-bundle (4.13.36)
  - Downloading twig/extra-bundle (v3.8.0)
  - Downloading toflar/psr6-symfony-http-cache-store (3.0.1)
  - Downloading symfony/web-profiler-bundle (v5.4.35)
  - Downloading symfony/stopwatch (v5.4.35)
  - Downloading symfony/monolog-bundle (v3.10.0)
  - Downloading symfony/dotenv (v5.4.35)
  - Downloading symfony/debug-bundle (v5.4.35)
  - Downloading sensiolabs/ansi-to-html (v1.2.1)
  - Downloading contao/installation-bundle (4.13.36)
  - Downloading contao/manager-bundle (4.13.36)
  - Downloading contao/news-bundle (4.13.36)
  - Downloading contao/newsletter-bundle (4.13.36)
  - Removing webmozart/path-util (2.3.0)
  - Removing webmozart/assert (1.4.0)
  - Removing true/punycode (v2.1.1)
  - Removing terminal42/header-replay-bundle (1.5.3)
  - Removing tecnickcom/tcpdf (6.2.26)
  - Removing symfony/symfony (v3.4.27)
  - Removing symfony/swiftmailer-bundle (v2.6.7)
  - Removing symfony/polyfill-util (v1.11.0)
  - Removing symfony/polyfill-php70 (v1.11.0)
  - Removing symfony/polyfill-php56 (v1.11.0)
  - Removing symfony/polyfill-intl-icu (v1.11.0)
  - Removing symfony/polyfill-apcu (v1.11.0)
  - Removing swiftmailer/swiftmailer (v5.4.12)
  - Removing sensiolabs/security-checker (v5.0.3)
  - Removing sensio/distribution-bundle (v5.0.24)
  - Removing robloach/component-installer (0.2.3)
  - Removing ralouphie/getallheaders (2.0.5)
  - Removing psr/simple-cache (1.0.1)
  - Removing psr/link (1.0.0)
  - Removing phpunit/php-token-stream (3.0.1)
  - Removing php-http/guzzle6-adapter (v1.1.1)
  - Removing patchwork/utf8 (v1.3.1)
  - Removing oyejorge/less.php (v1.7.0.14)
  - Removing netzmacht/contao-iconwizard (1.2.3)
  - Removing netzmacht/contao-font-awesome-inserttag (2.0.1)
  - Removing netzmacht/contao-font-awesome (4.7.2)
  - Removing michelf/php-markdown (1.8.0)
  - Removing lexik/maintenance-bundle (v2.1.5)
  - Removing league/uri (4.2.2)
  - Removing leafo/scssphp (v0.7.7)
  - Removing kriswallsmith/assetic (v1.4.0)
  - Removing jeremykendall/php-domain-parser (3.0.0)
  - Removing jdorn/sql-formatter (v1.2.17)
  - Removing guzzlehttp/psr7 (1.5.2)
  - Removing guzzlehttp/promises (v1.3.1)
  - Removing guzzlehttp/guzzle (6.3.3)
  - Removing fig/link-util (1.0.0)
  - Removing erdmannfreunde/theme-toolbox (1.0.0)
  - Removing doctrine/reflection (v1.0.0)
  - Removing doctrine/doctrine-cache-bundle (1.3.5)
  - Removing contao-components/compass (0.12.2.1)
  - Removing contao-community-alliance/meta-palettes (2.0.6)
  - Removing contao-community-alliance/composer-plugin (3.0.9)
  - Removing components/font-awesome (4.7.0)
  - Removing codefog/contao-cookiebar (2.1.4)
  - Removing cliffparnitzky/tiny-mce-text-color (1.1.0)
  - Removing cliffparnitzky/tiny-mce-plugin-loader (2.1.9)
  - Removing cliffparnitzky/tiny-mce-noneditable (1.0.0)
  - Removing cliffparnitzky/tiny-mce-font-awesome (2.1.1)
  - Upgrading contao-components/installer (1.3.1 => 1.4.1): Extracting archive
  - Removing php-http/discovery (1.6.1)
  - Installing php-http/discovery (1.19.2): Extracting archive
  - Upgrading symfony/polyfill-mbstring (v1.11.0 => v1.29.0): Extracting archive
  - Upgrading symfony/polyfill-ctype (v1.11.0 => v1.29.0): Extracting archive
  - Installing symfony/deprecation-contracts (v2.5.2): Extracting archive
  - Installing symfony/polyfill-php80 (v1.29.0): Extracting archive
  - Installing symfony/polyfill-php73 (v1.29.0): Extracting archive
  - Installing symfony/http-foundation (v5.4.35): Extracting archive
  - Installing psr/event-dispatcher (1.0.0): Extracting archive
  - Installing symfony/event-dispatcher-contracts (v2.5.2): Extracting archive
  - Installing symfony/event-dispatcher (v5.4.35): Extracting archive
  - Installing symfony/var-dumper (v5.4.35): Extracting archive
  - Upgrading psr/log (1.1.0 => 1.1.4): Extracting archive
  - Installing symfony/error-handler (v5.4.35): Extracting archive
  - Installing symfony/http-kernel (v5.4.35): Extracting archive
  - Upgrading psr/container (1.0.0 => 1.1.2): Extracting archive
  - Installing symfony/service-contracts (v2.5.2): Extracting archive
  - Installing symfony/polyfill-php81 (v1.29.0): Extracting archive
  - Installing symfony/dependency-injection (v5.4.35): Extracting archive
  - Installing symfony/filesystem (v5.4.35): Extracting archive
  - Installing symfony/config (v5.4.35): Extracting archive
  - Installing symfony/routing (v5.4.35): Extracting archive
  - Upgrading contao/manager-plugin (2.7.0 => 2.13.1): Extracting archive
  - Installing ausi/slug-generator (v1.1.1): Extracting archive
  - Installing dasprid/enum (1.0.5): Extracting archive
  - Installing bacon/bacon-qr-code (2.0.8): Extracting archive
  - Installing contao-components/ace (1.32.5): Extracting archive
  - Installing contao-components/chosen (1.2.5): Extracting archive
  - Installing contao-components/colorbox (1.6.6): Extracting archive
  - Installing contao-components/colorpicker (1.5.3): Extracting archive
  - Installing contao-components/contao (9.3.4): Extracting archive
  - Installing contao-components/datepicker (2.3.2): Extracting archive
  - Installing contao-components/dropzone (5.9.3): Extracting archive
  - Installing contao-components/jquery (3.7.1): Extracting archive
  - Installing contao-components/jquery-ui (1.13.2): Extracting archive
  - Installing contao-components/mediabox (1.5.5): Extracting archive
  - Installing contao-components/mootools (1.6.0.7): Extracting archive
  - Installing contao-components/simplemodal (2.1.2): Extracting archive
  - Installing contao-components/swipe (2.2.1): Extracting archive
  - Installing contao-components/tablesort (4.0.1): Extracting archive
  - Installing contao-components/tablesorter (2.31.3): Extracting archive
  - Installing contao-components/tinymce4 (5.10.9): Extracting archive
  - Installing symfony/yaml (v5.4.35): Extracting archive
  - Installing symfony/options-resolver (v5.4.21): Extracting archive
  - Upgrading psr/http-message (1.0.1 => 1.1): Extracting archive
  - Upgrading php-http/message-factory (v1.0.2 => 1.1.0): Extracting archive
  - Upgrading clue/stream-filter (v1.4.1 => v1.7.0): Extracting archive
  - Upgrading php-http/message (1.7.2 => 1.16.0): Extracting archive
  - Installing symfony/http-client-contracts (v2.5.2): Extracting archive
  - Installing symfony/http-client (v5.4.35): Extracting archive
  - Installing psr/http-factory (1.0.2): Extracting archive
  - Installing psr/http-client (1.0.3): Extracting archive
  - Upgrading php-http/promise (v1.0.0 => 1.3.0): Extracting archive
  - Upgrading php-http/httplug (v1.1.0 => 2.4.0): Extracting archive
  - Upgrading php-http/client-common (1.9.1 => 2.7.1): Extracting archive
  - Upgrading friendsofsymfony/http-cache (2.6.0 => 2.15.3): Extracting archive
  - Installing wikimedia/less.php (1.8.2): Extracting archive
  - Installing webignition/disallowed-character-terminated-string (2.0): Extracting archive
  - Installing webignition/robots-txt-file (3.0): Extracting archive
  - Upgrading composer/ca-bundle (1.1.4 => 1.4.0): Extracting archive
  - Upgrading ua-parser/uap-php (v3.8.8 => v3.9.14): Extracting archive
  - Upgrading twig/twig (v1.40.1 => v3.8.0): Extracting archive
  - Installing doctrine/deprecations (1.1.3): Extracting archive
  - Upgrading doctrine/lexer (v1.0.1 => 2.1.1): Extracting archive
  - Upgrading doctrine/annotations (v1.6.1 => 2.0.1): Extracting archive
  - Installing terminal42/service-annotation-bundle (1.1.5): Extracting archive
  - Installing symfony/dom-crawler (v5.4.35): Extracting archive
  - Installing nyholm/psr7 (1.8.1): Extracting archive
  - Installing terminal42/escargot (1.5.3): Extracting archive
  - Installing symfony/polyfill-uuid (v1.29.0): Extracting archive
  - Installing symfony/uid (v5.4.35): Extracting archive
  - Installing symfony/translation-contracts (v2.5.2): Extracting archive
  - Installing symfony/twig-bridge (v5.4.35): Extracting archive
  - Installing symfony/twig-bundle (v5.4.35): Extracting archive
  - Installing symfony/translation (v5.4.35): Extracting archive
  - Installing symfony/polyfill-intl-normalizer (v1.29.0): Extracting archive
  - Installing symfony/polyfill-intl-grapheme (v1.29.0): Extracting archive
  - Installing symfony/string (v5.4.35): Extracting archive
  - Installing symfony/password-hasher (v5.4.35): Extracting archive
  - Installing symfony/security-core (v5.4.35): Extracting archive
  - Installing symfony/property-info (v5.4.35): Extracting archive
  - Installing symfony/property-access (v5.4.35): Extracting archive
  - Installing symfony/security-http (v5.4.35): Extracting archive
  - Installing symfony/security-csrf (v5.4.35): Extracting archive
  - Installing symfony/security-guard (v5.4.35): Extracting archive
  - Installing symfony/security-bundle (v5.4.35): Extracting archive
  - Installing symfony/process (v5.4.35): Extracting archive
  - Installing symfony/polyfill-php72 (v1.29.0): Extracting archive
  - Installing symfony/polyfill-intl-idn (v1.29.0): Extracting archive
  - Upgrading monolog/monolog (1.24.0 => 2.9.2): Extracting archive
  - Installing symfony/monolog-bridge (v5.4.35): Extracting archive
  - Installing symfony/mime (v5.4.35): Extracting archive
  - Installing egulias/email-validator (3.2.6): Extracting archive
  - Installing symfony/mailer (v5.4.35): Extracting archive
  - Installing symfony/lock (v5.4.35): Extracting archive
  - Installing symfony/intl (v5.4.35): Extracting archive
  - Installing symfony/finder (v5.4.35): Extracting archive
  - Installing symfony/var-exporter (v5.4.35): Extracting archive
  - Installing symfony/cache-contracts (v2.5.2): Extracting archive
  - Installing symfony/cache (v5.4.35): Extracting archive
  - Installing symfony/framework-bundle (v5.4.35): Extracting archive
  - Installing symfony/expression-language (v5.4.35): Extracting archive
  - Upgrading doctrine/event-manager (v1.0.0 => 1.2.0): Extracting archive
  - Upgrading doctrine/collections (v1.6.1 => 1.8.0): Extracting archive
  - Upgrading doctrine/cache (v1.8.0 => 2.2.0): Extracting archive
  - Upgrading doctrine/persistence (1.1.1 => 2.5.7): Extracting archive
  - Installing symfony/doctrine-bridge (v5.4.35): Extracting archive
  - Installing symfony/console (v5.4.35): Extracting archive
  - Installing symfony/asset (v5.4.35): Extracting archive
  - Installing symfony-cmf/routing (2.3.4): Extracting archive
  - Installing symfony-cmf/routing-bundle (2.5.1): Extracting archive
  - Installing thecodingmachine/safe (v1.3.3): Extracting archive
  - Installing paragonie/constant_time_encoding (v2.6.3): Extracting archive
  - Installing beberlei/assert (v3.3.2): Extracting archive
  - Installing spomky-labs/otphp (v10.0.3): Extracting archive
  - Installing spatie/schema-org (3.9.0): Extracting archive
  - Upgrading simplepie/simplepie (1.5.2 => 1.8.0): Extracting archive
  - Installing scssphp/scssphp (v1.12.1): Extracting archive
  - Installing scrivo/highlight.php (v9.18.1.10): Extracting archive
  - Installing scheb/2fa-bundle (v5.13.2): Extracting archive
  - Installing lcobucci/clock (2.0.0): Extracting archive
  - Installing lcobucci/jwt (4.1.5): Extracting archive
  - Installing scheb/2fa-trusted-device (v5.13.2): Extracting archive
  - Installing scheb/2fa-backup-code (v5.13.2): Extracting archive
  - Upgrading phpspec/php-diff (v1.1.0 => v1.1.3): Extracting archive
  - Installing nikic/php-parser (v4.18.0): Extracting archive
  - Upgrading paragonie/random_compat (v9.99.99 => v9.99.100): Extracting archive
  - Upgrading nelmio/security-bundle (2.7.0 => v2.12.0): Extracting archive
  - Upgrading nelmio/cors-bundle (1.5.5 => 2.4.0): Extracting archive
  - Upgrading matthiasmullie/path-converter (1.1.2 => 1.1.3): Extracting archive
  - Upgrading matthiasmullie/minify (1.3.61 => 1.3.71): Extracting archive
  - Installing league/mime-type-detection (1.15.0): Extracting archive
  - Installing league/flysystem (2.5.0): Extracting archive
  - Installing league/flysystem-bundle (2.4.0): Extracting archive
  - Installing nette/utils (v3.2.10): Extracting archive
  - Installing nette/schema (v1.2.5): Extracting archive
  - Installing dflydev/dot-access-data (v3.0.2): Extracting archive
  - Installing league/config (v1.2.0): Extracting archive
  - Installing league/commonmark (2.4.2): Extracting archive
  - Installing symfony/templating (v5.4.35): Extracting archive
  - Removing knplabs/knp-time-bundle (v1.9.1)
  - Upgrading knplabs/knp-menu (2.3.0 => v3.3.0): Extracting archive
  - Upgrading knplabs/knp-menu-bundle (v2.2.1 => v3.2.0): Extracting archive
  - Upgrading imagine/imagine (v0.7.1 => 1.3.5): Extracting archive
  - Upgrading friendsofsymfony/http-cache-bundle (2.6.1 => 2.17.0): Extracting archive
  - Installing dragonmantank/cron-expression (v2.3.1): Extracting archive
  - Installing doctrine/instantiator (1.5.0): Extracting archive
  - Upgrading doctrine/inflector (v1.3.0 => 2.0.9): Extracting archive
  - Upgrading doctrine/dbal (v2.8.1 => 3.8.1): Extracting archive
  - Upgrading doctrine/common (v2.10.0 => 3.4.3): Extracting archive
  - Installing doctrine/orm (2.18.0): Extracting archive
  - Installing doctrine/sql-formatter (1.1.3): Extracting archive
  - Upgrading doctrine/doctrine-bundle (1.10.2 => 2.11.2): Extracting archive
  - Upgrading contao/imagine-svg (0.2.2 => 1.0.3): Extracting archive
  - Upgrading contao/image (0.3.9 => 1.2.0): Extracting archive
  - Upgrading contao/core-bundle (4.4.32 => 4.13.36): Extracting archive
  - Upgrading contao/calendar-bundle (4.4.32 => 4.13.36): Extracting archive
  - Upgrading contao/comments-bundle (4.4.32 => 4.13.36): Extracting archive
  - Upgrading contao/conflicts (dev-master a3fd5c0 => dev-main 8d5342f)
  - Upgrading contao/faq-bundle (4.4.32 => 4.13.36): Extracting archive
  - Upgrading contao/listing-bundle (4.4.32 => 4.13.36): Extracting archive
  - Installing twig/extra-bundle (v3.8.0): Extracting archive
  - Installing toflar/psr6-symfony-http-cache-store (3.0.1): Extracting archive
  - Installing symfony/web-profiler-bundle (v5.4.35): Extracting archive
  - Installing symfony/stopwatch (v5.4.35): Extracting archive
  - Upgrading symfony/monolog-bundle (v3.3.1 => v3.10.0): Extracting archive
  - Installing symfony/dotenv (v5.4.35): Extracting archive
  - Installing symfony/debug-bundle (v5.4.35): Extracting archive
  - Upgrading sensiolabs/ansi-to-html (v1.1.3 => v1.2.1): Extracting archive
  - Upgrading contao/installation-bundle (4.4.32 => 4.13.36): Extracting archive
  - Upgrading contao/manager-bundle (4.4.32 => 4.13.36): Extracting archive
  - Upgrading contao/news-bundle (4.4.32 => 4.13.36): Extracting archive
  - Upgrading contao/newsletter-bundle (4.4.32 => 4.13.36): Extracting archive
 107/149 [====================>-------]  71%  - Installing knplabs/knp-time-bundle (v1.20.0): Extracting archive
23 package suggestions were added by new dependencies, use `composer suggest` to see details.
Package php-http/message-factory is abandoned, you should avoid using it. Use psr/http-factory instead.
Generating optimized autoload files
Class Contao\ManagerPlugin\PluginLoader located in ./vendor/contao/manager-plugin/src/Resources/PluginLoader.php does not comply with psr-4 autoloading standard. Skipping.
102 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
contao/manager-plugin: Dumping generated plugins file...
contao/manager-plugin: ...done dumping generated plugins file
> @php vendor/bin/contao-setup
Added the /httpdocs/cmd-eberl/web/index.php file.
Added the /httpdocs/cmd-eberl/web/app.php file.
Added the /httpdocs/cmd-eberl/web/preview.php file.
Deleted the /httpdocs/cmd-eberl/web/app_dev.php file.

 Trying to install assets as relative symbolic links.

 --- ------------------------ ------------------ 
      Bundle                   Method / Error    
 --- ------------------------ ------------------ 
  ?   ContaoCoreBundle         relative symlink  
  ?   ContaoFaqBundle          relative symlink  
  ?   ContaoCommentsBundle     relative symlink  
  ?   ContaoNewsBundle         relative symlink  
  ?   ContaoCalendarBundle     relative symlink  
  ?   ContaoNewsletterBundle   relative symlink  
 --- ------------------------ ------------------ 

                                                                                
 [OK] All assets were successfully installed.                                   
                                                                                


 * assets/js
 * web/system


 --- ---------------------------------------- ---------------------------------------------------------------- 
      Symlink                                  Target / Error                                                  
 --- ---------------------------------------- ---------------------------------------------------------------- 
  ?   web/files/Bilder                         files/Bilder                                                    
  ?   web/files/CSS-Stylsheets                 files/CSS-Stylsheets                                            
  ?   system/themes/flexible                   vendor/contao/core-bundle/src/Resources/contao/themes/flexible  
  ?   web/assets                               assets                                                          
  ?   web/system/themes                        system/themes                                                   
  ?   system/logs                              var/logs                                                        
  ?   web/vendor/scrivo/highlight_php/styles   vendor/scrivo/highlight.php/styles                              
 --- ---------------------------------------- ---------------------------------------------------------------- 


 // Clearing the cache for the prod environment with debug                      
 // false                                                                       

                                                                                
 [OK] Cache for the "prod" environment (debug=false) was successfully cleared.  
                                                                                


 // Clearing the cache for the dev environment with debug                       
 // true                                                                        

                                                                                
 [OK] Cache for the "dev" environment (debug=true) was successfully cleared.    
                                                                                


 // Warming up the cache for the prod environment with debug                    
 // false                                                                       

                                                                                
 [OK] Cache for the "prod" environment (debug=false) was successfully warmed.   
                                                                                


                                                                                
 [INFO] Done! Please open the Contao install tool or run the contao:migrate     
        command to make sure the database is up-to-date.                        
                                                                                

No security vulnerability advisories found.
bash-5.0$ pwd
/httpdocs/cmd-eberl
bash-5.0$ /usr/local/php74/bin/php vendor/bin/contao-console contao:migrate --no-interaction

                                                                                
 [INFO] Creating a database dump to "backup__20240206222329.sql.gz" with the    
        default options. Use --no-backup to disable this feature.               
                                                                                

Pending migrations
------------------

 * Contao 4.5.0 Update
 * Contao 4.6.0 Update
 * Contao 4.7.0 Update
 * Contao 4.8.0 Update
 * Contao\CoreBundle\Migration\Version409\CeAccessMigration
 * Contao\CoreBundle\Migration\Version410\DropSearchMigration
 * Contao\CoreBundle\Migration\Version410\OrderFieldMigration
 * Contao\CoreBundle\Migration\Version410\RoutingMigration
 * Contao\CoreBundle\Migration\Version411\MergeWebfontsMigration
 * Contao\CoreBundle\Migration\Version413\AlwaysForwardMigration
 * Contao\NewsletterBundle\Migration\Version410\DenyListMigration

Execute migrations
------------------

 * Contao 4.5.0 Update executed successfully
 * Contao 4.6.0 Update executed successfully
 * Contao 4.7.0 Update executed successfully
 * Contao 4.8.0 Update executed successfully
 * Contao\CoreBundle\Migration\Version409\CeAccessMigration executed successfully
 * Contao\CoreBundle\Migration\Version410\DropSearchMigration executed successfully
 * Contao\CoreBundle\Migration\Version410\OrderFieldMigration executed successfully
 * Contao\CoreBundle\Migration\Version410\RoutingMigration executed successfully
 * Contao\CoreBundle\Migration\Version411\MergeWebfontsMigration executed successfully
 * Contao\CoreBundle\Migration\Version413\AlwaysForwardMigration executed successfully
 * Contao\NewsletterBundle\Migration\Version410\DenyListMigration executed successfully

                                                                                
 [OK] Executed 11 migrations.                                                   
                                                                                

Pending database migrations (bad014c0afacb94ae23cd272faa594b19f50ca98ec78ac57efdb90c0c125424f)
----------------------------------------------------------------------------------------------

 * CREATE TABLE tl_crawl_queue (id INT UNSIGNED AUTO_INCREMENT NOT NULL, job_id CHAR(128) NOT NULL, uri LONGTEXT NOT NULL, uri_hash CHAR(40) NOT NULL, found_on LONGTEXT DEFAULT NULL, level SMALLINT NOT NULL, processed TINYINT(1) NOT NULL, tags LONGTEXT DEFAULT NULL, INDEX job_id (job_id), INDEX uri_hash (uri_hash), INDEX processed (processed), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_trusted_device (id INT AUTO_INCREMENT NOT NULL, created DATETIME NOT NULL, userClass VARCHAR(255) DEFAULT NULL, userId INT DEFAULT NULL, user_agent LONGTEXT DEFAULT NULL, ua_family VARCHAR(255) DEFAULT NULL, os_family VARCHAR(255) DEFAULT NULL, device_family VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_cron_job (id INT UNSIGNED AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, lastRun DATETIME NOT NULL, INDEX name (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_remember_me (id INT UNSIGNED AUTO_INCREMENT NOT NULL, series BINARY(32) NOT NULL COMMENT '(DC2Type:binary_string)', value BINARY(64) NOT NULL COMMENT '(DC2Type:binary_string)', lastUsed DATETIME NOT NULL, expires DATETIME DEFAULT NULL, class VARCHAR(100) NOT NULL, username VARCHAR(200) NOT NULL, INDEX series (series), UNIQUE INDEX value (value), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_opt_in (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, token VARCHAR(24) DEFAULT '' NOT NULL, createdOn INT UNSIGNED DEFAULT 0 NOT NULL, confirmedOn INT UNSIGNED DEFAULT 0 NOT NULL, removeOn INT UNSIGNED DEFAULT 0 NOT NULL, invalidatedThrough VARCHAR(24) DEFAULT '' NOT NULL, email VARCHAR(255) DEFAULT '' NOT NULL, emailSubject VARCHAR(255) DEFAULT '' NOT NULL, emailText TEXT DEFAULT NULL, UNIQUE INDEX token (token), INDEX removeon (removeon), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_opt_in_related (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, relTable VARCHAR(64) DEFAULT NULL, relId INT UNSIGNED DEFAULT 0 NOT NULL, INDEX reltable_relid (reltable, relid), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_preview_link (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, url VARCHAR(2048) DEFAULT '' NOT NULL, showUnpublished CHAR(1) DEFAULT '' NOT NULL, restrictToUrl CHAR(1) DEFAULT '1' NOT NULL, createdAt INT UNSIGNED DEFAULT 0 NOT NULL, expiresAt INT UNSIGNED DEFAULT 0 NOT NULL, published CHAR(1) DEFAULT '' NOT NULL, createdBy INT UNSIGNED DEFAULT 0 NOT NULL, INDEX id_published_expiresat (id, published, expiresat), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_search (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title TEXT DEFAULT NULL, url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`, text MEDIUMTEXT DEFAULT NULL, filesize DOUBLE PRECISION DEFAULT '0' NOT NULL, checksum VARCHAR(32) DEFAULT '' NOT NULL, protected CHAR(1) DEFAULT '' NOT NULL, `groups` BLOB DEFAULT NULL, language VARCHAR(5) DEFAULT '' NOT NULL, vectorLength DOUBLE PRECISION DEFAULT '0' NOT NULL, meta MEDIUMTEXT DEFAULT NULL, UNIQUE INDEX url (url), UNIQUE INDEX checksum_pid (checksum, pid), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_search_index (pid INT UNSIGNED NOT NULL, termId INT UNSIGNED NOT NULL, relevance SMALLINT UNSIGNED NOT NULL, INDEX pid (pid), PRIMARY KEY(termid, pid)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_search_term (id INT UNSIGNED AUTO_INCREMENT NOT NULL, term VARCHAR(64) NOT NULL COLLATE `utf8mb4_bin`, documentFrequency INT UNSIGNED NOT NULL, UNIQUE INDEX term (term), INDEX documentfrequency (documentfrequency), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * DROP TABLE tl_cron
 * DROP TABLE tl_session
 * DROP INDEX pid_start_stop_published_sorting ON tl_article
 * ALTER TABLE tl_article CHANGE inColumn inColumn VARCHAR(32) DEFAULT 'main' NOT NULL
 * ALTER TABLE tl_article CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * CREATE INDEX pid_published_incolumn_start_stop ON tl_article (pid, published, incolumn, start, stop)
 * ALTER TABLE tl_calendar CHANGE sortOrder sortOrder VARCHAR(32) DEFAULT 'ascending' NOT NULL
 * ALTER TABLE tl_calendar CHANGE notify notify VARCHAR(32) DEFAULT 'notify_admin' NOT NULL
 * DROP INDEX pid_start_stop_published ON tl_calendar_events
 * ALTER TABLE tl_calendar_events CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL
 * ALTER TABLE tl_calendar_events CHANGE source source VARCHAR(32) DEFAULT 'default' NOT NULL
 * ALTER TABLE tl_calendar_events CHANGE floating floating VARCHAR(32) DEFAULT 'above' NOT NULL
 * ALTER TABLE tl_calendar_events CHANGE imageUrl imageUrl VARCHAR(2048) DEFAULT '' NOT NULL
 * ALTER TABLE tl_calendar_events CHANGE endDate endDate BIGINT DEFAULT NULL
 * ALTER TABLE tl_calendar_events CHANGE startDate startDate BIGINT DEFAULT NULL
 * ALTER TABLE tl_calendar_events CHANGE endTime endTime BIGINT DEFAULT NULL
 * ALTER TABLE tl_calendar_events CHANGE startTime startTime BIGINT DEFAULT NULL
 * ALTER TABLE tl_calendar_events CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_calendar_events ADD address VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_calendar_events ADD description TEXT DEFAULT NULL
 * ALTER TABLE tl_calendar_events ADD robots VARCHAR(32) DEFAULT '' NOT NULL
 * ALTER TABLE tl_calendar_events ADD pageTitle VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_calendar_events ADD featured CHAR(1) DEFAULT '' NOT NULL
 * CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)
 * ALTER TABLE tl_calendar_feed CHANGE maxItems maxItems SMALLINT UNSIGNED DEFAULT 25 NOT NULL
 * ALTER TABLE tl_calendar_feed CHANGE source source VARCHAR(32) DEFAULT 'source_teaser' NOT NULL
 * ALTER TABLE tl_calendar_feed CHANGE format format VARCHAR(32) DEFAULT 'rss' NOT NULL
 * ALTER TABLE tl_calendar_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_calendar_feed ADD imgSize VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_comments ADD `member` INT UNSIGNED DEFAULT 0 NOT NULL
 * DROP INDEX source_parent_tokenconfirm ON tl_comments_notify
 * ALTER TABLE tl_comments_notify CHANGE url url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_comments_notify DROP tokenConfirm
 * ALTER TABLE tl_comments_notify DROP ip
 * CREATE INDEX source_parent_active_email ON tl_comments_notify (source, parent, active, email)
 * DROP INDEX pid_ptable_invisible_sorting ON tl_content
 * ALTER TABLE tl_content CHANGE overwriteLink overwriteLink CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_template com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_requireLogin com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_bbcode com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_moderate com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_order com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE stop stop VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE start start VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE invisible invisible CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE guests guests CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE protected protected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE sliderContinuous sliderContinuous CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE playerSize playerSize VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE vimeo vimeo VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE youtube youtube VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE galleryTpl galleryTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE metaIgnore metaIgnore CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE sortBy sortBy VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE perRow perRow SMALLINT UNSIGNED DEFAULT 4 NOT NULL
 * ALTER TABLE tl_content CHANGE useHomeDir useHomeDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE useImage useImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE target target CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE url url TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE highlight highlight VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE sortOrder sortOrder VARCHAR(32) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE sortable sortable CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE tleft tleft CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE tfoot tfoot CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE thead thead CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE listtype listtype VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE floating floating VARCHAR(32) CHARACTER SET ascii DEFAULT 'above' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE imageUrl imageUrl TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE imagemargin imagemargin VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE size size VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE overwriteMeta overwriteMeta CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE addImage addImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE headline headline VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL
 * ALTER TABLE tl_content CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'text' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE ptable ptable VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content DROP youtubeStop
 * ALTER TABLE tl_content DROP youtubeStart
 * ALTER TABLE tl_content DROP fontAwesome_icon
 * ALTER TABLE tl_content DROP fontAwesome_iconRotation
 * ALTER TABLE tl_content DROP fontAwesome_iconSize
 * ALTER TABLE tl_content DROP fontAwesome_iconStyle
 * ALTER TABLE tl_content DROP fontAwesome_iconColor
 * ALTER TABLE tl_content DROP fontAwesome_iconStack
 * ALTER TABLE tl_content DROP fontAwesome_iconStackBase
 * ALTER TABLE tl_content DROP fontAwesome_iconStackBaseColor
 * ALTER TABLE tl_content DROP autoplay
 * ALTER TABLE tl_content ADD data TEXT DEFAULT NULL
 * ALTER TABLE tl_content ADD playerColor VARCHAR(6) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content ADD playerPreload VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content ADD splashImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content ADD playerAspect VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content ADD playerCaption VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_content ADD markdownSource VARCHAR(12) CHARACTER SET ascii DEFAULT 'sourceText' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content ADD inline CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content ADD showPreview CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * CREATE INDEX pid_ptable_invisible_start_stop ON tl_content (pid, ptable, invisible, start, stop)
 * CREATE INDEX type ON tl_content (type)
 * DROP INDEX pid_published_sorting ON tl_faq
 * ALTER TABLE tl_faq CHANGE floating floating VARCHAR(12) DEFAULT 'above' NOT NULL
 * ALTER TABLE tl_faq CHANGE imageUrl imageUrl VARCHAR(2048) DEFAULT '' NOT NULL
 * ALTER TABLE tl_faq CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_faq ADD description TEXT DEFAULT NULL
 * ALTER TABLE tl_faq ADD robots VARCHAR(32) DEFAULT '' NOT NULL
 * ALTER TABLE tl_faq ADD pageTitle VARCHAR(255) DEFAULT '' NOT NULL
 * CREATE INDEX pid_published ON tl_faq (pid, published)
 * ALTER TABLE tl_faq_category CHANGE sortOrder sortOrder VARCHAR(12) DEFAULT 'ascending' NOT NULL
 * ALTER TABLE tl_faq_category CHANGE notify notify VARCHAR(16) DEFAULT 'notify_admin' NOT NULL
 * DROP INDEX path ON tl_files
 * ALTER TABLE tl_files CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_files CHANGE extension extension VARCHAR(16) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_files CHANGE path path VARCHAR(1022) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_files ADD lastModified INT UNSIGNED DEFAULT NULL
 * CREATE INDEX path ON tl_files (path(768))
 * ALTER TABLE tl_form CHANGE method method VARCHAR(12) DEFAULT 'POST' NOT NULL
 * ALTER TABLE tl_form CHANGE format format VARCHAR(12) DEFAULT 'raw' NOT NULL
 * ALTER TABLE tl_form CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_form ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
 * DROP INDEX pid ON tl_form_field
 * ALTER TABLE tl_form_field CHANGE extensions extensions VARCHAR(255) DEFAULT 'jpg,jpeg,gif,png,pdf,doc,docx,xls,xlsx,ppt,pptx' NOT NULL
 * ALTER TABLE tl_form_field CHANGE size size VARCHAR(255) DEFAULT 'a:2:{i:0;i:4;i:1;i:40;}' NOT NULL
 * ALTER TABLE tl_form_field CHANGE type type VARCHAR(64) DEFAULT 'text' NOT NULL
 * ALTER TABLE tl_form_field DROP fsType
 * ALTER TABLE tl_form_field ADD step VARCHAR(10) DEFAULT '' NOT NULL
 * ALTER TABLE tl_form_field ADD maxval VARCHAR(10) DEFAULT '' NOT NULL
 * ALTER TABLE tl_form_field ADD minval VARCHAR(10) DEFAULT '' NOT NULL
 * ALTER TABLE tl_form_field ADD maxImageHeight INT UNSIGNED DEFAULT 0 NOT NULL
 * ALTER TABLE tl_form_field ADD maxImageWidth INT UNSIGNED DEFAULT 0 NOT NULL
 * ALTER TABLE tl_form_field ADD errorMsg VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_form_field ADD customRgxp VARCHAR(255) DEFAULT '' NOT NULL
 * CREATE INDEX pid_invisible ON tl_form_field (pid, invisible)
 * ALTER TABLE tl_image_size ADD lazyLoading CHAR(1) DEFAULT '' NOT NULL
 * ALTER TABLE tl_image_size ADD formats VARCHAR(1024) DEFAULT '' NOT NULL
 * ALTER TABLE tl_layout CHANGE minifyMarkup minifyMarkup CHAR(1) DEFAULT '1' NOT NULL
 * ALTER TABLE tl_layout CHANGE align align VARCHAR(32) DEFAULT 'center' NOT NULL
 * ALTER TABLE tl_layout CHANGE combineScripts combineScripts CHAR(1) DEFAULT '1' NOT NULL
 * ALTER TABLE tl_layout CHANGE loadingOrder loadingOrder VARCHAR(16) DEFAULT 'external_first' NOT NULL
 * ALTER TABLE tl_layout CHANGE framework framework VARCHAR(255) DEFAULT 'a:2:{i:0;s:10:"layout.css";i:1;s:14:"responsive.css";}' NOT NULL
 * ALTER TABLE tl_layout CHANGE cols cols VARCHAR(8) DEFAULT '2cll' NOT NULL
 * ALTER TABLE tl_layout CHANGE `rows` `rows` VARCHAR(8) DEFAULT '2rwh' NOT NULL
 * ALTER TABLE tl_layout DROP tinyMceFontAwesome
 * ALTER TABLE tl_layout DROP fontAwesome
 * ALTER TABLE tl_layout DROP picturefill
 * ALTER TABLE tl_layout DROP mooSource
 * ALTER TABLE tl_layout DROP jSource
 * ALTER TABLE tl_layout DROP doctype
 * ALTER TABLE tl_layout ADD lightboxSize VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_log DROP ip
 * DROP INDEX activation ON tl_member
 * DROP INDEX autologin ON tl_member
 * ALTER TABLE tl_member CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_member CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL
 * ALTER TABLE tl_member DROP activation
 * ALTER TABLE tl_member DROP autologin
 * ALTER TABLE tl_member DROP loginCount
 * ALTER TABLE tl_member ADD backupCodes TEXT DEFAULT NULL
 * ALTER TABLE tl_member ADD useTwoFactor CHAR(1) DEFAULT '' NOT NULL
 * ALTER TABLE tl_member ADD secret BINARY(128) DEFAULT NULL
 * ALTER TABLE tl_member ADD loginAttempts SMALLINT UNSIGNED DEFAULT 0 NOT NULL
 * CREATE INDEX login_disable_start_stop ON tl_member (login, disable, start, stop)
 * ALTER TABLE tl_member DROP createdOn
 * ALTER TABLE tl_member ADD trustedTokenVersion INT UNSIGNED DEFAULT 0 NOT NULL
 * CREATE INDEX disable_start_stop ON tl_member_group (disable, start, stop)
 * ALTER TABLE tl_module CHANGE nl_template nl_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE nl_hideChannels nl_hideChannels CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_showQuantity news_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_order news_order VARCHAR(32) CHARACTER SET ascii DEFAULT 'order_date_desc' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_format news_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'news_month' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_template news_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_metaFields news_metaFields VARCHAR(255) CHARACTER SET ascii DEFAULT 'a:2:{i:0;s:4:"date";i:1;s:6:"author";}' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_jumpToCurrent news_jumpToCurrent VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_featured news_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE list_info_layout list_info_layout VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE list_layout list_layout VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE list_info_where list_info_where TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_info list_info TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_sort list_sort TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_search list_search TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_where list_where TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_fields list_fields TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_table list_table VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_template com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_requireLogin com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_bbcode com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_moderate com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_order com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_showQuantity cal_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_ctemplate cal_ctemplate VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_template cal_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_order cal_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_ignoreDynamic cal_ignoreDynamic CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_format cal_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'cal_month' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_hideRunning cal_hideRunning CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_noSpan cal_noSpan CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE guests guests CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE protected protected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_activate reg_activate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_assignDir reg_assignDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_close reg_close VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_skipName reg_skipName CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_allowLogin reg_allowLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE disableCaptcha disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE numberOfItems numberOfItems SMALLINT UNSIGNED DEFAULT 3 NOT NULL
 * ALTER TABLE tl_module CHANGE rss_template rss_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE rss_cache rss_cache INT UNSIGNED DEFAULT 3600 NOT NULL
 * ALTER TABLE tl_module CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE useCaption useCaption CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE imgSize imgSize VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE url url TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE loadFirst loadFirst CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE inColumn inColumn VARCHAR(32) CHARACTER SET ascii DEFAULT 'main' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE searchTpl searchTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE searchType searchType VARCHAR(16) CHARACTER SET ascii DEFAULT 'simple' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE contextLength contextLength VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE fuzzy fuzzy CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE queryType queryType VARCHAR(8) CHARACTER SET ascii DEFAULT 'and' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE memberTpl memberTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE redirectBack redirectBack CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE autologin autologin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE showHidden showHidden CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE navigationTpl navigationTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE defineRoot defineRoot CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE showProtected showProtected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE hardLimit hardLimit CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'navigation' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE headline headline VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL
 * ALTER TABLE tl_module DROP flashJS
 * ALTER TABLE tl_module DROP flashID
 * ALTER TABLE tl_module DROP interactive
 * ALTER TABLE tl_module DROP source
 * ALTER TABLE tl_module DROP altContent
 * ALTER TABLE tl_module DROP flashvars
 * ALTER TABLE tl_module DROP transparent
 * ALTER TABLE tl_module DROP size
 * ALTER TABLE tl_module DROP cols
 * ALTER TABLE tl_module ADD nl_text TEXT DEFAULT NULL
 * ALTER TABLE tl_module ADD cal_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module ADD rootPageDependentModules BLOB DEFAULT NULL
 * ALTER TABLE tl_module ADD data TEXT DEFAULT NULL
 * ALTER TABLE tl_module ADD reg_deleteDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module ADD overviewPage INT UNSIGNED DEFAULT 0 NOT NULL
 * DROP INDEX pid_start_stop_published ON tl_news
 * ALTER TABLE tl_news CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL
 * ALTER TABLE tl_news CHANGE source source VARCHAR(12) DEFAULT 'default' NOT NULL
 * ALTER TABLE tl_news CHANGE floating floating VARCHAR(12) DEFAULT 'above' NOT NULL
 * ALTER TABLE tl_news CHANGE imageUrl imageUrl VARCHAR(2048) DEFAULT '' NOT NULL
 * ALTER TABLE tl_news CHANGE time time INT DEFAULT 0 NOT NULL
 * ALTER TABLE tl_news CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_news ADD description TEXT DEFAULT NULL
 * ALTER TABLE tl_news ADD robots VARCHAR(32) DEFAULT '' NOT NULL
 * ALTER TABLE tl_news ADD pageTitle VARCHAR(255) DEFAULT '' NOT NULL
 * CREATE INDEX pid_published_featured_start_stop ON tl_news (pid, published, featured, start, stop)
 * ALTER TABLE tl_news_archive CHANGE sortOrder sortOrder VARCHAR(32) DEFAULT 'ascending' NOT NULL
 * ALTER TABLE tl_news_archive CHANGE notify notify VARCHAR(16) DEFAULT 'notify_admin' NOT NULL
 * ALTER TABLE tl_news_feed CHANGE maxItems maxItems SMALLINT UNSIGNED DEFAULT 25 NOT NULL
 * ALTER TABLE tl_news_feed CHANGE source source VARCHAR(32) DEFAULT 'source_teaser' NOT NULL
 * ALTER TABLE tl_news_feed CHANGE format format VARCHAR(32) DEFAULT 'rss' NOT NULL
 * ALTER TABLE tl_news_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_news_feed ADD imgSize VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_newsletter CHANGE sender sender VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_newsletter CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_newsletter ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_newsletter_channel CHANGE sender sender VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_newsletter_channel ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_newsletter_recipients DROP token
 * ALTER TABLE tl_newsletter_recipients DROP ip
 * ALTER TABLE tl_newsletter_recipients DROP confirmed
 * CREATE INDEX active ON tl_newsletter_recipients (active)
 * DROP INDEX pid_type_start_stop_published ON tl_page
 * ALTER TABLE tl_page CHANGE urlSuffix urlSuffix VARCHAR(16) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page CHANGE urlPrefix urlPrefix VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_page CHANGE useSSL useSSL CHAR(1) DEFAULT '1' NOT NULL
 * ALTER TABLE tl_page CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page CHANGE redirect redirect VARCHAR(32) DEFAULT 'permanent' NOT NULL
 * ALTER TABLE tl_page CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page CHANGE type type VARCHAR(64) DEFAULT 'regular' NOT NULL
 * ALTER TABLE tl_page CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_page DROP cookiebar_enable
 * ALTER TABLE tl_page DROP cookiebar_position
 * ALTER TABLE tl_page DROP cookiebar_placement
 * ALTER TABLE tl_page DROP cookiebar_button
 * ALTER TABLE tl_page DROP cookiebar_link
 * ALTER TABLE tl_page DROP cookiebar_combineAssets
 * ALTER TABLE tl_page DROP cookiebar_includeCss
 * ALTER TABLE tl_page DROP cookiebar_ttl
 * ALTER TABLE tl_page DROP cookiebar_analyticsCheckbox
 * ALTER TABLE tl_page DROP cookiebar_analyticsLabel
 * ALTER TABLE tl_page DROP sitemapName
 * ALTER TABLE tl_page DROP createSitemap
 * ALTER TABLE tl_page ADD twoFactorJumpTo INT UNSIGNED DEFAULT 0 NOT NULL
 * ALTER TABLE tl_page ADD enforceTwoFactor CHAR(1) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page ADD alwaysLoadFromCache CHAR(1) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page ADD validAliasCharacters VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page ADD canonicalKeepParams VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page ADD canonicalLink VARCHAR(2048) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page ADD enableCanonical CHAR(1) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page ADD maintenanceMode CHAR(1) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page ADD favicon BINARY(16) DEFAULT NULL
 * ALTER TABLE tl_page ADD disableLanguageRedirect CHAR(1) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page ADD routePriority INT DEFAULT 0 NOT NULL
 * ALTER TABLE tl_page ADD requireItem CHAR(1) DEFAULT '' NOT NULL
 * CREATE INDEX type_dns ON tl_page (type, dns)
 * CREATE INDEX pid_published_type_start_stop ON tl_page (pid, published, type, start, stop)
 * ALTER TABLE tl_page DROP cookiebar_message
 * ALTER TABLE tl_page ADD robotsTxt TEXT DEFAULT NULL
 * ALTER TABLE tl_page DROP cookiebar_url
 * ALTER TABLE tl_page ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page DROP mobileLayout
 * ALTER TABLE tl_page ADD subpageLayout INT UNSIGNED DEFAULT 0 NOT NULL
 * ALTER TABLE tl_style_sheet CHANGE media media VARCHAR(255) DEFAULT 'a:1:{i:0;s:3:"all";}' NOT NULL
 * ALTER TABLE tl_theme DROP defaultImageDensities
 * ALTER TABLE tl_undo ADD preview MEDIUMBLOB DEFAULT NULL
 * ALTER TABLE tl_user CHANGE inherit inherit VARCHAR(12) DEFAULT 'group' NOT NULL
 * ALTER TABLE tl_user CHANGE useCE useCE CHAR(1) DEFAULT '1' NOT NULL
 * ALTER TABLE tl_user CHANGE useRTE useRTE CHAR(1) DEFAULT '1' NOT NULL
 * ALTER TABLE tl_user CHANGE thumbnails thumbnails CHAR(1) DEFAULT '1' NOT NULL
 * ALTER TABLE tl_user CHANGE showHelp showHelp CHAR(1) DEFAULT '1' NOT NULL
 * ALTER TABLE tl_user CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL
 * ALTER TABLE tl_user CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_user DROP loginCount
 * ALTER TABLE tl_user ADD trustedTokenVersion INT UNSIGNED DEFAULT 0 NOT NULL
 * ALTER TABLE tl_user ADD backupCodes TEXT DEFAULT NULL
 * ALTER TABLE tl_user ADD loginAttempts SMALLINT UNSIGNED DEFAULT 0 NOT NULL
 * ALTER TABLE tl_user ADD useTwoFactor CHAR(1) DEFAULT '' NOT NULL
 * ALTER TABLE tl_user ADD secret BINARY(128) DEFAULT NULL
 * ALTER TABLE tl_user ADD fields BLOB DEFAULT NULL
 * ALTER TABLE tl_user ADD elements BLOB DEFAULT NULL
 * ALTER TABLE tl_user DROP limitWidth
 * ALTER TABLE tl_user ADD fullscreen CHAR(1) DEFAULT '' NOT NULL
 * DROP INDEX fromtable ON tl_version
 * DROP INDEX pid ON tl_version
 * CREATE UNIQUE INDEX pid_fromtable_version ON tl_version (pid, fromtable, version)
 * CREATE INDEX userid ON tl_version (userid)
 * DROP INDEX alias ON tl_article
 * ALTER TABLE tl_article ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_article CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_calendar ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_calendar CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX alias ON tl_calendar_events
 * ALTER TABLE tl_calendar_events ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_calendar_events CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX alias ON tl_calendar_feed
 * ALTER TABLE tl_calendar_feed ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_calendar_feed CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX published ON tl_comments
 * DROP INDEX source_parent_published ON tl_comments
 * ALTER TABLE tl_comments ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_comments CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX tokenremove ON tl_comments_notify
 * ALTER TABLE tl_comments_notify ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_comments_notify CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_content CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_faq ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_faq CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_faq_category ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_faq_category CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX extension ON tl_files
 * DROP INDEX pid ON tl_files
 * DROP INDEX uuid ON tl_files
 * ALTER TABLE tl_files ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_files CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX alias ON tl_form
 * ALTER TABLE tl_form ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_form CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_form_field ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_form_field CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX pid ON tl_image_size
 * ALTER TABLE tl_image_size ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_image_size CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX pid ON tl_image_size_item
 * ALTER TABLE tl_image_size_item ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_image_size_item CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_layout ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_layout CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_log ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_log CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX email ON tl_member
 * DROP INDEX username ON tl_member
 * ALTER TABLE tl_member ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_member CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_member_group ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_member_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_module CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX alias ON tl_news
 * ALTER TABLE tl_news ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_news CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_news_archive ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_news_archive CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX alias ON tl_news_feed
 * ALTER TABLE tl_news_feed ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_news_feed CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX pid ON tl_newsletter
 * ALTER TABLE tl_newsletter ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_newsletter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_newsletter_channel ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_newsletter_channel CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX pid_hash ON tl_newsletter_deny_list
 * ALTER TABLE tl_newsletter_deny_list ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_newsletter_deny_list CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX email ON tl_newsletter_recipients
 * DROP INDEX pid_email ON tl_newsletter_recipients
 * ALTER TABLE tl_newsletter_recipients ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_newsletter_recipients CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX alias ON tl_page
 * ALTER TABLE tl_page ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_page CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX pid ON tl_style
 * ALTER TABLE tl_style ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_style CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX name ON tl_style_sheet
 * ALTER TABLE tl_style_sheet ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_style_sheet CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_theme ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_theme CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_undo ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_undo CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX email ON tl_user
 * DROP INDEX username ON tl_user
 * ALTER TABLE tl_user ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_user CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_user_group ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_user_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_version ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_version CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

Execute database migrations
---------------------------

 * CREATE TABLE tl_crawl_queue (id INT UNSIGNED AUTO_INCREMENT NOT NULL, job_id CHAR(128) NOT NULL, uri LONGTEXT NOT NULL, uri_hash CHAR(40) NOT NULL, found_on LONGTEXT DEFAULT NULL, level SMALLINT NOT NULL, processed TINYINT(1) NOT NULL, tags LONGTEXT DEFAULT NULL, INDEX job_id (job_id), INDEX uri_hash (uri_hash), INDEX processed (processed), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_trusted_device (id INT AUTO_INCREMENT NOT NULL, created DATETIME NOT NULL, userClass VARCHAR(255) DEFAULT NULL, userId INT DEFAULT NULL, user_agent LONGTEXT DEFAULT NULL, ua_family VARCHAR(255) DEFAULT NULL, os_family VARCHAR(255) DEFAULT NULL, device_family VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_cron_job (id INT UNSIGNED AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, lastRun DATETIME NOT NULL, INDEX name (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_remember_me (id INT UNSIGNED AUTO_INCREMENT NOT NULL, series BINARY(32) NOT NULL COMMENT '(DC2Type:binary_string)', value BINARY(64) NOT NULL COMMENT '(DC2Type:binary_string)', lastUsed DATETIME NOT NULL, expires DATETIME DEFAULT NULL, class VARCHAR(100) NOT NULL, username VARCHAR(200) NOT NULL, INDEX series (series), UNIQUE INDEX value (value), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_opt_in (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, token VARCHAR(24) DEFAULT '' NOT NULL, createdOn INT UNSIGNED DEFAULT 0 NOT NULL, confirmedOn INT UNSIGNED DEFAULT 0 NOT NULL, removeOn INT UNSIGNED DEFAULT 0 NOT NULL, invalidatedThrough VARCHAR(24) DEFAULT '' NOT NULL, email VARCHAR(255) DEFAULT '' NOT NULL, emailSubject VARCHAR(255) DEFAULT '' NOT NULL, emailText TEXT DEFAULT NULL, UNIQUE INDEX token (token), INDEX removeon (removeon), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_opt_in_related (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, relTable VARCHAR(64) DEFAULT NULL, relId INT UNSIGNED DEFAULT 0 NOT NULL, INDEX reltable_relid (reltable, relid), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_preview_link (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, url VARCHAR(2048) DEFAULT '' NOT NULL, showUnpublished CHAR(1) DEFAULT '' NOT NULL, restrictToUrl CHAR(1) DEFAULT '1' NOT NULL, createdAt INT UNSIGNED DEFAULT 0 NOT NULL, expiresAt INT UNSIGNED DEFAULT 0 NOT NULL, published CHAR(1) DEFAULT '' NOT NULL, createdBy INT UNSIGNED DEFAULT 0 NOT NULL, INDEX id_published_expiresat (id, published, expiresat), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_search (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title TEXT DEFAULT NULL, url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`, text MEDIUMTEXT DEFAULT NULL, filesize DOUBLE PRECISION DEFAULT '0' NOT NULL, checksum VARCHAR(32) DEFAULT '' NOT NULL, protected CHAR(1) DEFAULT '' NOT NULL, `groups` BLOB DEFAULT NULL, language VARCHAR(5) DEFAULT '' NOT NULL, vectorLength DOUBLE PRECISION DEFAULT '0' NOT NULL, meta MEDIUMTEXT DEFAULT NULL, UNIQUE INDEX url (url), UNIQUE INDEX checksum_pid (checksum, pid), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_search_index (pid INT UNSIGNED NOT NULL, termId INT UNSIGNED NOT NULL, relevance SMALLINT UNSIGNED NOT NULL, INDEX pid (pid), PRIMARY KEY(termid, pid)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * CREATE TABLE tl_search_term (id INT UNSIGNED AUTO_INCREMENT NOT NULL, term VARCHAR(64) NOT NULL COLLATE `utf8mb4_bin`, documentFrequency INT UNSIGNED NOT NULL, UNIQUE INDEX term (term), INDEX documentfrequency (documentfrequency), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * DROP INDEX pid_start_stop_published_sorting ON tl_article
 * ALTER TABLE tl_article CHANGE inColumn inColumn VARCHAR(32) DEFAULT 'main' NOT NULL
 * ALTER TABLE tl_article CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`......FAILED
 * CREATE INDEX pid_published_incolumn_start_stop ON tl_article (pid, published, incolumn, start, stop)
 * ALTER TABLE tl_calendar CHANGE sortOrder sortOrder VARCHAR(32) DEFAULT 'ascending' NOT NULL
 * ALTER TABLE tl_calendar CHANGE notify notify VARCHAR(32) DEFAULT 'notify_admin' NOT NULL
 * DROP INDEX pid_start_stop_published ON tl_calendar_events
 * ALTER TABLE tl_calendar_events CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL
 * ALTER TABLE tl_calendar_events CHANGE source source VARCHAR(32) DEFAULT 'default' NOT NULL
 * ALTER TABLE tl_calendar_events CHANGE floating floating VARCHAR(32) DEFAULT 'above' NOT NULL
 * ALTER TABLE tl_calendar_events CHANGE imageUrl imageUrl VARCHAR(2048) DEFAULT '' NOT NULL
 * ALTER TABLE tl_calendar_events CHANGE endDate endDate BIGINT DEFAULT NULL
 * ALTER TABLE tl_calendar_events CHANGE startDate startDate BIGINT DEFAULT NULL
 * ALTER TABLE tl_calendar_events CHANGE endTime endTime BIGINT DEFAULT NULL
 * ALTER TABLE tl_calendar_events CHANGE startTime startTime BIGINT DEFAULT NULL
 * ALTER TABLE tl_calendar_events CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`......FAILED
 * ALTER TABLE tl_calendar_events ADD address VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_calendar_events ADD description TEXT DEFAULT NULL
 * ALTER TABLE tl_calendar_events ADD robots VARCHAR(32) DEFAULT '' NOT NULL
 * ALTER TABLE tl_calendar_events ADD pageTitle VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_calendar_events ADD featured CHAR(1) DEFAULT '' NOT NULL
 * CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)
 * ALTER TABLE tl_calendar_feed CHANGE maxItems maxItems SMALLINT UNSIGNED DEFAULT 25 NOT NULL
 * ALTER TABLE tl_calendar_feed CHANGE source source VARCHAR(32) DEFAULT 'source_teaser' NOT NULL
 * ALTER TABLE tl_calendar_feed CHANGE format format VARCHAR(32) DEFAULT 'rss' NOT NULL
 * ALTER TABLE tl_calendar_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`......FAILED
 * ALTER TABLE tl_calendar_feed ADD imgSize VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_comments ADD `member` INT UNSIGNED DEFAULT 0 NOT NULL
 * DROP INDEX source_parent_tokenconfirm ON tl_comments_notify
 * ALTER TABLE tl_comments_notify CHANGE url url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * CREATE INDEX source_parent_active_email ON tl_comments_notify (source, parent, active, email)
 * DROP INDEX pid_ptable_invisible_sorting ON tl_content
 * ALTER TABLE tl_content CHANGE overwriteLink overwriteLink CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_template com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_requireLogin com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_bbcode com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_moderate com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_order com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE stop stop VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE start start VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE invisible invisible CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE guests guests CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE protected protected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE sliderContinuous sliderContinuous CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE playerSize playerSize VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE vimeo vimeo VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE youtube youtube VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE galleryTpl galleryTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE metaIgnore metaIgnore CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE sortBy sortBy VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE perRow perRow SMALLINT UNSIGNED DEFAULT 4 NOT NULL
 * ALTER TABLE tl_content CHANGE useHomeDir useHomeDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE useImage useImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE target target CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE url url TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE highlight highlight VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE sortOrder sortOrder VARCHAR(32) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE sortable sortable CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE tleft tleft CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE tfoot tfoot CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE thead thead CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE listtype listtype VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE floating floating VARCHAR(32) CHARACTER SET ascii DEFAULT 'above' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE imageUrl imageUrl TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE imagemargin imagemargin VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE size size VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE overwriteMeta overwriteMeta CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE addImage addImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE headline headline VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL
 * ALTER TABLE tl_content CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'text' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE ptable ptable VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content ADD data TEXT DEFAULT NULL
 * ALTER TABLE tl_content ADD playerColor VARCHAR(6) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content ADD playerPreload VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content ADD splashImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content ADD playerAspect VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content ADD playerCaption VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_content ADD markdownSource VARCHAR(12) CHARACTER SET ascii DEFAULT 'sourceText' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content ADD inline CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content ADD showPreview CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * CREATE INDEX pid_ptable_invisible_start_stop ON tl_content (pid, ptable, invisible, start, stop)
 * CREATE INDEX type ON tl_content (type)
 * DROP INDEX pid_published_sorting ON tl_faq
 * ALTER TABLE tl_faq CHANGE floating floating VARCHAR(12) DEFAULT 'above' NOT NULL
 * ALTER TABLE tl_faq CHANGE imageUrl imageUrl VARCHAR(2048) DEFAULT '' NOT NULL
 * ALTER TABLE tl_faq CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_faq ADD description TEXT DEFAULT NULL
 * ALTER TABLE tl_faq ADD robots VARCHAR(32) DEFAULT '' NOT NULL
 * ALTER TABLE tl_faq ADD pageTitle VARCHAR(255) DEFAULT '' NOT NULL
 * CREATE INDEX pid_published ON tl_faq (pid, published)
 * ALTER TABLE tl_faq_category CHANGE sortOrder sortOrder VARCHAR(12) DEFAULT 'ascending' NOT NULL
 * ALTER TABLE tl_faq_category CHANGE notify notify VARCHAR(16) DEFAULT 'notify_admin' NOT NULL
 * DROP INDEX path ON tl_files
 * ALTER TABLE tl_files CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_files CHANGE extension extension VARCHAR(16) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_files CHANGE path path VARCHAR(1022) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_files ADD lastModified INT UNSIGNED DEFAULT NULL
 * CREATE INDEX path ON tl_files (path(768))......FAILED
 * ALTER TABLE tl_form CHANGE method method VARCHAR(12) DEFAULT 'POST' NOT NULL
 * ALTER TABLE tl_form CHANGE format format VARCHAR(12) DEFAULT 'raw' NOT NULL
 * ALTER TABLE tl_form CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`......FAILED
 * ALTER TABLE tl_form ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
 * DROP INDEX pid ON tl_form_field
 * ALTER TABLE tl_form_field CHANGE extensions extensions VARCHAR(255) DEFAULT 'jpg,jpeg,gif,png,pdf,doc,docx,xls,xlsx,ppt,pptx' NOT NULL
 * ALTER TABLE tl_form_field CHANGE size size VARCHAR(255) DEFAULT 'a:2:{i:0;i:4;i:1;i:40;}' NOT NULL
 * ALTER TABLE tl_form_field CHANGE type type VARCHAR(64) DEFAULT 'text' NOT NULL
 * ALTER TABLE tl_form_field ADD step VARCHAR(10) DEFAULT '' NOT NULL
 * ALTER TABLE tl_form_field ADD maxval VARCHAR(10) DEFAULT '' NOT NULL
 * ALTER TABLE tl_form_field ADD minval VARCHAR(10) DEFAULT '' NOT NULL
 * ALTER TABLE tl_form_field ADD maxImageHeight INT UNSIGNED DEFAULT 0 NOT NULL
 * ALTER TABLE tl_form_field ADD maxImageWidth INT UNSIGNED DEFAULT 0 NOT NULL
 * ALTER TABLE tl_form_field ADD errorMsg VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_form_field ADD customRgxp VARCHAR(255) DEFAULT '' NOT NULL
 * CREATE INDEX pid_invisible ON tl_form_field (pid, invisible)
 * ALTER TABLE tl_image_size ADD lazyLoading CHAR(1) DEFAULT '' NOT NULL
 * ALTER TABLE tl_image_size ADD formats VARCHAR(1024) DEFAULT '' NOT NULL
 * ALTER TABLE tl_layout CHANGE minifyMarkup minifyMarkup CHAR(1) DEFAULT '1' NOT NULL
 * ALTER TABLE tl_layout CHANGE align align VARCHAR(32) DEFAULT 'center' NOT NULL
 * ALTER TABLE tl_layout CHANGE combineScripts combineScripts CHAR(1) DEFAULT '1' NOT NULL
 * ALTER TABLE tl_layout CHANGE loadingOrder loadingOrder VARCHAR(16) DEFAULT 'external_first' NOT NULL
 * ALTER TABLE tl_layout CHANGE framework framework VARCHAR(255) DEFAULT 'a:2:{i:0;s:10:"layout.css";i:1;s:14:"responsive.css";}' NOT NULL
 * ALTER TABLE tl_layout CHANGE cols cols VARCHAR(8) DEFAULT '2cll' NOT NULL
 * ALTER TABLE tl_layout CHANGE `rows` `rows` VARCHAR(8) DEFAULT '2rwh' NOT NULL
 * ALTER TABLE tl_layout ADD lightboxSize VARCHAR(255) DEFAULT '' NOT NULL
 * DROP INDEX activation ON tl_member
 * DROP INDEX autologin ON tl_member
 * ALTER TABLE tl_member CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_member CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL
 * ALTER TABLE tl_member ADD backupCodes TEXT DEFAULT NULL
 * ALTER TABLE tl_member ADD useTwoFactor CHAR(1) DEFAULT '' NOT NULL
 * ALTER TABLE tl_member ADD secret BINARY(128) DEFAULT NULL
 * ALTER TABLE tl_member ADD loginAttempts SMALLINT UNSIGNED DEFAULT 0 NOT NULL
 * CREATE INDEX login_disable_start_stop ON tl_member (login, disable, start, stop)
 * ALTER TABLE tl_member ADD trustedTokenVersion INT UNSIGNED DEFAULT 0 NOT NULL
 * CREATE INDEX disable_start_stop ON tl_member_group (disable, start, stop)
 * ALTER TABLE tl_module CHANGE nl_template nl_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE nl_hideChannels nl_hideChannels CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_showQuantity news_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_order news_order VARCHAR(32) CHARACTER SET ascii DEFAULT 'order_date_desc' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_format news_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'news_month' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_template news_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_metaFields news_metaFields VARCHAR(255) CHARACTER SET ascii DEFAULT 'a:2:{i:0;s:4:"date";i:1;s:6:"author";}' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_jumpToCurrent news_jumpToCurrent VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_featured news_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE list_info_layout list_info_layout VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE list_layout list_layout VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE list_info_where list_info_where TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_info list_info TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_sort list_sort TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_search list_search TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_where list_where TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_fields list_fields TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_table list_table VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_template com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_requireLogin com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_bbcode com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_moderate com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_order com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_showQuantity cal_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_ctemplate cal_ctemplate VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_template cal_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_order cal_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_ignoreDynamic cal_ignoreDynamic CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_format cal_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'cal_month' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_hideRunning cal_hideRunning CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_noSpan cal_noSpan CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE guests guests CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE protected protected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_activate reg_activate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_assignDir reg_assignDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_close reg_close VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_skipName reg_skipName CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_allowLogin reg_allowLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE disableCaptcha disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE numberOfItems numberOfItems SMALLINT UNSIGNED DEFAULT 3 NOT NULL
 * ALTER TABLE tl_module CHANGE rss_template rss_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE rss_cache rss_cache INT UNSIGNED DEFAULT 3600 NOT NULL
 * ALTER TABLE tl_module CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE useCaption useCaption CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE imgSize imgSize VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE url url TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE loadFirst loadFirst CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE inColumn inColumn VARCHAR(32) CHARACTER SET ascii DEFAULT 'main' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE searchTpl searchTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE searchType searchType VARCHAR(16) CHARACTER SET ascii DEFAULT 'simple' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE contextLength contextLength VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE fuzzy fuzzy CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE queryType queryType VARCHAR(8) CHARACTER SET ascii DEFAULT 'and' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE memberTpl memberTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE redirectBack redirectBack CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE autologin autologin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE showHidden showHidden CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE navigationTpl navigationTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE defineRoot defineRoot CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE showProtected showProtected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE hardLimit hardLimit CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'navigation' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE headline headline VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL
 * ALTER TABLE tl_module ADD nl_text TEXT DEFAULT NULL
 * ALTER TABLE tl_module ADD cal_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module ADD rootPageDependentModules BLOB DEFAULT NULL
 * ALTER TABLE tl_module ADD data TEXT DEFAULT NULL
 * ALTER TABLE tl_module ADD reg_deleteDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module ADD overviewPage INT UNSIGNED DEFAULT 0 NOT NULL
 * DROP INDEX pid_start_stop_published ON tl_news
 * ALTER TABLE tl_news CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL
 * ALTER TABLE tl_news CHANGE source source VARCHAR(12) DEFAULT 'default' NOT NULL
 * ALTER TABLE tl_news CHANGE floating floating VARCHAR(12) DEFAULT 'above' NOT NULL
 * ALTER TABLE tl_news CHANGE imageUrl imageUrl VARCHAR(2048) DEFAULT '' NOT NULL
 * ALTER TABLE tl_news CHANGE time time INT DEFAULT 0 NOT NULL
 * ALTER TABLE tl_news CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`......FAILED
 * ALTER TABLE tl_news ADD description TEXT DEFAULT NULL
 * ALTER TABLE tl_news ADD robots VARCHAR(32) DEFAULT '' NOT NULL
 * ALTER TABLE tl_news ADD pageTitle VARCHAR(255) DEFAULT '' NOT NULL
 * CREATE INDEX pid_published_featured_start_stop ON tl_news (pid, published, featured, start, stop)
 * ALTER TABLE tl_news_archive CHANGE sortOrder sortOrder VARCHAR(32) DEFAULT 'ascending' NOT NULL
 * ALTER TABLE tl_news_archive CHANGE notify notify VARCHAR(16) DEFAULT 'notify_admin' NOT NULL
 * ALTER TABLE tl_news_feed CHANGE maxItems maxItems SMALLINT UNSIGNED DEFAULT 25 NOT NULL
 * ALTER TABLE tl_news_feed CHANGE source source VARCHAR(32) DEFAULT 'source_teaser' NOT NULL
 * ALTER TABLE tl_news_feed CHANGE format format VARCHAR(32) DEFAULT 'rss' NOT NULL
 * ALTER TABLE tl_news_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`......FAILED
 * ALTER TABLE tl_news_feed ADD imgSize VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_newsletter CHANGE sender sender VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_newsletter CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_newsletter ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_newsletter_channel CHANGE sender sender VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_newsletter_channel ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
 * CREATE INDEX active ON tl_newsletter_recipients (active)
 * DROP INDEX pid_type_start_stop_published ON tl_page
 * ALTER TABLE tl_page CHANGE urlSuffix urlSuffix VARCHAR(16) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page CHANGE urlPrefix urlPrefix VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_page CHANGE useSSL useSSL CHAR(1) DEFAULT '1' NOT NULL
 * ALTER TABLE tl_page CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page CHANGE redirect redirect VARCHAR(32) DEFAULT 'permanent' NOT NULL
 * ALTER TABLE tl_page CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page CHANGE type type VARCHAR(64) DEFAULT 'regular' NOT NULL
 * ALTER TABLE tl_page CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`......FAILED
 * ALTER TABLE tl_page ADD twoFactorJumpTo INT UNSIGNED DEFAULT 0 NOT NULL
 * ALTER TABLE tl_page ADD enforceTwoFactor CHAR(1) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page ADD alwaysLoadFromCache CHAR(1) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page ADD validAliasCharacters VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page ADD canonicalKeepParams VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page ADD canonicalLink VARCHAR(2048) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page ADD enableCanonical CHAR(1) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page ADD maintenanceMode CHAR(1) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page ADD favicon BINARY(16) DEFAULT NULL
 * ALTER TABLE tl_page ADD disableLanguageRedirect CHAR(1) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page ADD routePriority INT DEFAULT 0 NOT NULL
 * ALTER TABLE tl_page ADD requireItem CHAR(1) DEFAULT '' NOT NULL
 * CREATE INDEX type_dns ON tl_page (type, dns)
 * CREATE INDEX pid_published_type_start_stop ON tl_page (pid, published, type, start, stop)
 * ALTER TABLE tl_page ADD robotsTxt TEXT DEFAULT NULL
 * ALTER TABLE tl_page ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
 * ALTER TABLE tl_page ADD subpageLayout INT UNSIGNED DEFAULT 0 NOT NULL
 * ALTER TABLE tl_style_sheet CHANGE media media VARCHAR(255) DEFAULT 'a:1:{i:0;s:3:"all";}' NOT NULL
 * ALTER TABLE tl_undo ADD preview MEDIUMBLOB DEFAULT NULL
 * ALTER TABLE tl_user CHANGE inherit inherit VARCHAR(12) DEFAULT 'group' NOT NULL
 * ALTER TABLE tl_user CHANGE useCE useCE CHAR(1) DEFAULT '1' NOT NULL
 * ALTER TABLE tl_user CHANGE useRTE useRTE CHAR(1) DEFAULT '1' NOT NULL
 * ALTER TABLE tl_user CHANGE thumbnails thumbnails CHAR(1) DEFAULT '1' NOT NULL
 * ALTER TABLE tl_user CHANGE showHelp showHelp CHAR(1) DEFAULT '1' NOT NULL
 * ALTER TABLE tl_user CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL
 * ALTER TABLE tl_user CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_user ADD trustedTokenVersion INT UNSIGNED DEFAULT 0 NOT NULL
 * ALTER TABLE tl_user ADD backupCodes TEXT DEFAULT NULL
 * ALTER TABLE tl_user ADD loginAttempts SMALLINT UNSIGNED DEFAULT 0 NOT NULL
 * ALTER TABLE tl_user ADD useTwoFactor CHAR(1) DEFAULT '' NOT NULL
 * ALTER TABLE tl_user ADD secret BINARY(128) DEFAULT NULL
 * ALTER TABLE tl_user ADD fields BLOB DEFAULT NULL
 * ALTER TABLE tl_user ADD elements BLOB DEFAULT NULL
 * ALTER TABLE tl_user ADD fullscreen CHAR(1) DEFAULT '' NOT NULL
 * DROP INDEX fromtable ON tl_version
 * DROP INDEX pid ON tl_version
 * CREATE UNIQUE INDEX pid_fromtable_version ON tl_version (pid, fromtable, version)
 * CREATE INDEX userid ON tl_version (userid)
 * DROP INDEX alias ON tl_article
 * ALTER TABLE tl_article ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_article CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_calendar ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_calendar CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX alias ON tl_calendar_events
 * ALTER TABLE tl_calendar_events ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_calendar_events CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX alias ON tl_calendar_feed
 * ALTER TABLE tl_calendar_feed ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_calendar_feed CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX published ON tl_comments
 * DROP INDEX source_parent_published ON tl_comments
 * ALTER TABLE tl_comments ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_comments CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX tokenremove ON tl_comments_notify
 * ALTER TABLE tl_comments_notify ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_comments_notify CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_content CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_faq ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_faq CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_faq_category ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_faq_category CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX extension ON tl_files
 * DROP INDEX pid ON tl_files
 * DROP INDEX uuid ON tl_files
 * ALTER TABLE tl_files ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_files CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX alias ON tl_form
 * ALTER TABLE tl_form ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_form CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_form_field ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_form_field CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX pid ON tl_image_size
 * ALTER TABLE tl_image_size ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_image_size CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX pid ON tl_image_size_item
 * ALTER TABLE tl_image_size_item ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_image_size_item CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_layout ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_layout CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_log ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_log CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX email ON tl_member
 * DROP INDEX username ON tl_member
 * ALTER TABLE tl_member ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_member CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_member_group ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_member_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_module CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX alias ON tl_news
 * ALTER TABLE tl_news ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_news CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_news_archive ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_news_archive CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX alias ON tl_news_feed
 * ALTER TABLE tl_news_feed ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_news_feed CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX pid ON tl_newsletter
 * ALTER TABLE tl_newsletter ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_newsletter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_newsletter_channel ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_newsletter_channel CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX pid_hash ON tl_newsletter_deny_list
 * ALTER TABLE tl_newsletter_deny_list ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_newsletter_deny_list CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX email ON tl_newsletter_recipients
 * DROP INDEX pid_email ON tl_newsletter_recipients
 * ALTER TABLE tl_newsletter_recipients ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_newsletter_recipients CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX alias ON tl_page
 * ALTER TABLE tl_page ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_page CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX pid ON tl_style
 * ALTER TABLE tl_style ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_style CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX name ON tl_style_sheet
 * ALTER TABLE tl_style_sheet ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_style_sheet CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_theme ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_theme CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_undo ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_undo CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * DROP INDEX email ON tl_user
 * DROP INDEX username ON tl_user
 * ALTER TABLE tl_user ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_user CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_user_group ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_user_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_version ENGINE = InnoDB ROW_FORMAT = DYNAMIC
 * ALTER TABLE tl_version CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 * ALTER TABLE tl_article CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_calendar_events CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_calendar_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * CREATE INDEX path ON tl_files (path(768))
 * ALTER TABLE tl_form CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_news CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_news_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_page CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`

                                                                                
 [OK] Executed 383 SQL queries.                                                 
                                                                                

Pending database migrations (d7bddd0ae3791e8b531420617ff584ce2340f83dcd1c787e46d0c286899b9c06)
----------------------------------------------------------------------------------------------

 * DROP TABLE tl_cron
 * DROP TABLE tl_session
 * ALTER TABLE tl_article CHANGE teaser teaser TEXT DEFAULT NULL
 * ALTER TABLE tl_article CHANGE keywords keywords TEXT DEFAULT NULL
 * CREATE INDEX alias ON tl_article (alias)
 * ALTER TABLE tl_calendar_events CHANGE description description TEXT DEFAULT NULL
 * ALTER TABLE tl_calendar_events CHANGE teaser teaser TEXT DEFAULT NULL
 * CREATE INDEX alias ON tl_calendar_events (alias)
 * ALTER TABLE tl_calendar_feed CHANGE description description TEXT DEFAULT NULL
 * CREATE INDEX alias ON tl_calendar_feed (alias)
 * ALTER TABLE tl_comments CHANGE reply reply TEXT DEFAULT NULL
 * ALTER TABLE tl_comments CHANGE comment comment TEXT DEFAULT NULL
 * CREATE INDEX published ON tl_comments (published)
 * CREATE INDEX source_parent_published ON tl_comments (source, parent, published)
 * ALTER TABLE tl_comments_notify CHANGE url url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_comments_notify DROP tokenConfirm
 * ALTER TABLE tl_comments_notify DROP ip
 * CREATE INDEX tokenremove ON tl_comments_notify (tokenremove)
 * ALTER TABLE tl_content CHANGE showPreview showPreview CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE inline inline CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE markdownSource markdownSource VARCHAR(12) CHARACTER SET ascii DEFAULT 'sourceText' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE playerAspect playerAspect VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE splashImage splashImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE playerPreload playerPreload VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE playerColor playerColor VARCHAR(6) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE data data TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE vimeoOptions vimeoOptions TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE playerOptions playerOptions TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE overwriteLink overwriteLink CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE youtubeOptions youtubeOptions TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE com_template com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_requireLogin com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_bbcode com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_moderate com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_order com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE stop stop VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE start start VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE invisible invisible CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE guests guests CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE protected protected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE sliderContinuous sliderContinuous CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE playerSize playerSize VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE vimeo vimeo VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE youtube youtube VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE galleryTpl galleryTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE metaIgnore metaIgnore CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE sortBy sortBy VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE useHomeDir useHomeDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE useImage useImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE target target CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE url url TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE code code TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE highlight highlight VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE sortOrder sortOrder VARCHAR(32) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE sortable sortable CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE tleft tleft CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE tfoot tfoot CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE thead thead CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE listtype listtype VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE html html MEDIUMTEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE floating floating VARCHAR(32) CHARACTER SET ascii DEFAULT 'above' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE imageUrl imageUrl TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE imagemargin imagemargin VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE size size VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE overwriteMeta overwriteMeta CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE addImage addImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE text text MEDIUMTEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'text' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE ptable ptable VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content DROP youtubeStop
 * ALTER TABLE tl_content DROP youtubeStart
 * ALTER TABLE tl_content DROP fontAwesome_icon
 * ALTER TABLE tl_content DROP fontAwesome_iconRotation
 * ALTER TABLE tl_content DROP fontAwesome_iconSize
 * ALTER TABLE tl_content DROP fontAwesome_iconStyle
 * ALTER TABLE tl_content DROP fontAwesome_iconColor
 * ALTER TABLE tl_content DROP fontAwesome_iconStack
 * ALTER TABLE tl_content DROP fontAwesome_iconStackBase
 * ALTER TABLE tl_content DROP fontAwesome_iconStackBaseColor
 * ALTER TABLE tl_content DROP autoplay
 * ALTER TABLE tl_faq CHANGE description description TEXT DEFAULT NULL
 * ALTER TABLE tl_faq CHANGE answer answer TEXT DEFAULT NULL
 * ALTER TABLE tl_faq CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_files CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_files CHANGE extension extension VARCHAR(16) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_files CHANGE path path VARCHAR(1022) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * CREATE INDEX pid ON tl_files (pid)
 * CREATE UNIQUE INDEX uuid ON tl_files (uuid)
 * CREATE INDEX extension ON tl_files (extension)
 * CREATE INDEX alias ON tl_form (alias)
 * ALTER TABLE tl_form_field CHANGE html html TEXT DEFAULT NULL
 * ALTER TABLE tl_form_field CHANGE text text TEXT DEFAULT NULL
 * ALTER TABLE tl_form_field DROP fsType
 * CREATE INDEX pid ON tl_image_size (pid)
 * CREATE INDEX pid ON tl_image_size_item (pid)
 * ALTER TABLE tl_layout CHANGE script script TEXT DEFAULT NULL
 * ALTER TABLE tl_layout CHANGE scripts scripts TEXT DEFAULT NULL
 * ALTER TABLE tl_layout CHANGE analytics analytics TEXT DEFAULT NULL
 * ALTER TABLE tl_layout CHANGE mootools mootools TEXT DEFAULT NULL
 * ALTER TABLE tl_layout CHANGE jquery jquery TEXT DEFAULT NULL
 * ALTER TABLE tl_layout CHANGE head head TEXT DEFAULT NULL
 * ALTER TABLE tl_layout DROP tinyMceFontAwesome
 * ALTER TABLE tl_layout DROP fontAwesome
 * ALTER TABLE tl_layout DROP picturefill
 * ALTER TABLE tl_layout DROP mooSource
 * ALTER TABLE tl_layout DROP jSource
 * ALTER TABLE tl_layout DROP doctype
 * ALTER TABLE tl_log CHANGE text text TEXT DEFAULT NULL
 * ALTER TABLE tl_log DROP ip
 * ALTER TABLE tl_member CHANGE backupCodes backupCodes TEXT DEFAULT NULL
 * ALTER TABLE tl_member CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_member DROP activation
 * ALTER TABLE tl_member DROP createdOn
 * ALTER TABLE tl_member DROP autologin
 * ALTER TABLE tl_member DROP loginCount
 * CREATE UNIQUE INDEX username ON tl_member (username)
 * CREATE INDEX email ON tl_member (email)
 * ALTER TABLE tl_module CHANGE reg_deleteDir reg_deleteDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE data data TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE cal_featured cal_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE nl_text nl_text TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE nl_template nl_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE nl_unsubscribe nl_unsubscribe TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE nl_subscribe nl_subscribe TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE nl_hideChannels nl_hideChannels CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_showQuantity news_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_order news_order VARCHAR(32) CHARACTER SET ascii DEFAULT 'order_date_desc' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_format news_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'news_month' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_template news_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_metaFields news_metaFields VARCHAR(255) CHARACTER SET ascii DEFAULT 'a:2:{i:0;s:4:"date";i:1;s:6:"author";}' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_jumpToCurrent news_jumpToCurrent VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_featured news_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE list_info_layout list_info_layout VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE list_layout list_layout VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE list_info_where list_info_where TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_info list_info TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_sort list_sort TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_search list_search TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_where list_where TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_fields list_fields TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_table list_table VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_template com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_requireLogin com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_bbcode com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_moderate com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_order com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_showQuantity cal_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_ctemplate cal_ctemplate VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_template cal_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_order cal_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_ignoreDynamic cal_ignoreDynamic CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_format cal_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'cal_month' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_hideRunning cal_hideRunning CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_noSpan cal_noSpan CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE guests guests CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE protected protected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_password reg_password TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE reg_text reg_text TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE reg_activate reg_activate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_assignDir reg_assignDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_close reg_close VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_skipName reg_skipName CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_allowLogin reg_allowLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE disableCaptcha disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE rss_template rss_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE rss_feed rss_feed TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE html html TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE useCaption useCaption CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE imgSize imgSize VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE url url TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE loadFirst loadFirst CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE inColumn inColumn VARCHAR(32) CHARACTER SET ascii DEFAULT 'main' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE searchTpl searchTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE searchType searchType VARCHAR(16) CHARACTER SET ascii DEFAULT 'simple' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE contextLength contextLength VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE fuzzy fuzzy CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE queryType queryType VARCHAR(8) CHARACTER SET ascii DEFAULT 'and' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE memberTpl memberTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE redirectBack redirectBack CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE autologin autologin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE showHidden showHidden CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE navigationTpl navigationTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE defineRoot defineRoot CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE showProtected showProtected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE hardLimit hardLimit CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'navigation' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module DROP flashJS
 * ALTER TABLE tl_module DROP flashID
 * ALTER TABLE tl_module DROP interactive
 * ALTER TABLE tl_module DROP source
 * ALTER TABLE tl_module DROP altContent
 * ALTER TABLE tl_module DROP flashvars
 * ALTER TABLE tl_module DROP transparent
 * ALTER TABLE tl_module DROP size
 * ALTER TABLE tl_module DROP cols
 * ALTER TABLE tl_news CHANGE description description TEXT DEFAULT NULL
 * ALTER TABLE tl_news CHANGE teaser teaser TEXT DEFAULT NULL
 * CREATE INDEX alias ON tl_news (alias)
 * ALTER TABLE tl_news_feed CHANGE description description TEXT DEFAULT NULL
 * CREATE INDEX alias ON tl_news_feed (alias)
 * ALTER TABLE tl_newsletter CHANGE text text MEDIUMTEXT DEFAULT NULL
 * ALTER TABLE tl_newsletter CHANGE content content MEDIUMTEXT DEFAULT NULL
 * ALTER TABLE tl_newsletter CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * CREATE INDEX pid ON tl_newsletter (pid)
 * CREATE UNIQUE INDEX pid_hash ON tl_newsletter_deny_list (pid, hash)
 * ALTER TABLE tl_newsletter_recipients DROP token
 * ALTER TABLE tl_newsletter_recipients DROP ip
 * ALTER TABLE tl_newsletter_recipients DROP confirmed
 * CREATE UNIQUE INDEX pid_email ON tl_newsletter_recipients (pid, email)
 * CREATE INDEX email ON tl_newsletter_recipients (email)
 * ALTER TABLE tl_page CHANGE robotsTxt robotsTxt TEXT DEFAULT NULL
 * ALTER TABLE tl_page CHANGE urlPrefix urlPrefix VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_page CHANGE description description TEXT DEFAULT NULL
 * ALTER TABLE tl_page DROP cookiebar_enable
 * ALTER TABLE tl_page DROP cookiebar_message
 * ALTER TABLE tl_page DROP cookiebar_url
 * ALTER TABLE tl_page DROP cookiebar_position
 * ALTER TABLE tl_page DROP cookiebar_placement
 * ALTER TABLE tl_page DROP cookiebar_button
 * ALTER TABLE tl_page DROP cookiebar_link
 * ALTER TABLE tl_page DROP cookiebar_combineAssets
 * ALTER TABLE tl_page DROP cookiebar_includeCss
 * ALTER TABLE tl_page DROP cookiebar_ttl
 * ALTER TABLE tl_page DROP cookiebar_analyticsCheckbox
 * ALTER TABLE tl_page DROP cookiebar_analyticsLabel
 * ALTER TABLE tl_page DROP mobileLayout
 * ALTER TABLE tl_page DROP sitemapName
 * ALTER TABLE tl_page DROP createSitemap
 * CREATE INDEX alias ON tl_page (alias)
 * ALTER TABLE tl_style CHANGE own own TEXT DEFAULT NULL
 * CREATE INDEX pid ON tl_style (pid)
 * ALTER TABLE tl_style_sheet CHANGE vars vars TEXT DEFAULT NULL
 * ALTER TABLE tl_style_sheet CHANGE mediaQuery mediaQuery TEXT DEFAULT NULL
 * CREATE UNIQUE INDEX name ON tl_style_sheet (name)
 * ALTER TABLE tl_theme CHANGE vars vars TEXT DEFAULT NULL
 * ALTER TABLE tl_theme DROP defaultImageDensities
 * ALTER TABLE tl_undo CHANGE query query TEXT DEFAULT NULL
 * ALTER TABLE tl_user CHANGE backupCodes backupCodes TEXT DEFAULT NULL
 * ALTER TABLE tl_user CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_user DROP loginCount
 * ALTER TABLE tl_user DROP limitWidth
 * CREATE UNIQUE INDEX username ON tl_user (username)
 * CREATE INDEX email ON tl_user (email)
 * ALTER TABLE tl_version CHANGE editUrl editUrl TEXT DEFAULT NULL

Execute database migrations
---------------------------

 * ALTER TABLE tl_article CHANGE teaser teaser TEXT DEFAULT NULL
 * ALTER TABLE tl_article CHANGE keywords keywords TEXT DEFAULT NULL
 * CREATE INDEX alias ON tl_article (alias)
 * ALTER TABLE tl_calendar_events CHANGE description description TEXT DEFAULT NULL
 * ALTER TABLE tl_calendar_events CHANGE teaser teaser TEXT DEFAULT NULL
 * CREATE INDEX alias ON tl_calendar_events (alias)
 * ALTER TABLE tl_calendar_feed CHANGE description description TEXT DEFAULT NULL
 * CREATE INDEX alias ON tl_calendar_feed (alias)
 * ALTER TABLE tl_comments CHANGE reply reply TEXT DEFAULT NULL
 * ALTER TABLE tl_comments CHANGE comment comment TEXT DEFAULT NULL
 * CREATE INDEX published ON tl_comments (published)
 * CREATE INDEX source_parent_published ON tl_comments (source, parent, published)
 * ALTER TABLE tl_comments_notify CHANGE url url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * CREATE INDEX tokenremove ON tl_comments_notify (tokenremove)
 * ALTER TABLE tl_content CHANGE showPreview showPreview CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE inline inline CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE markdownSource markdownSource VARCHAR(12) CHARACTER SET ascii DEFAULT 'sourceText' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE playerAspect playerAspect VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE splashImage splashImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE playerPreload playerPreload VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE playerColor playerColor VARCHAR(6) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE data data TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE vimeoOptions vimeoOptions TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE playerOptions playerOptions TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE overwriteLink overwriteLink CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE youtubeOptions youtubeOptions TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE com_template com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_requireLogin com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_bbcode com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_moderate com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE com_order com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE stop stop VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE start start VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE invisible invisible CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE guests guests CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE protected protected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE sliderContinuous sliderContinuous CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE playerSize playerSize VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE vimeo vimeo VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE youtube youtube VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE galleryTpl galleryTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE metaIgnore metaIgnore CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE sortBy sortBy VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE useHomeDir useHomeDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE useImage useImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE target target CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE url url TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE code code TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE highlight highlight VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE sortOrder sortOrder VARCHAR(32) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE sortable sortable CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE tleft tleft CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE tfoot tfoot CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE thead thead CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE listtype listtype VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE html html MEDIUMTEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE floating floating VARCHAR(32) CHARACTER SET ascii DEFAULT 'above' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE imageUrl imageUrl TEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE imagemargin imagemargin VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE size size VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE overwriteMeta overwriteMeta CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE addImage addImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE text text MEDIUMTEXT DEFAULT NULL
 * ALTER TABLE tl_content CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'text' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_content CHANGE ptable ptable VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_faq CHANGE description description TEXT DEFAULT NULL
 * ALTER TABLE tl_faq CHANGE answer answer TEXT DEFAULT NULL
 * ALTER TABLE tl_faq CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_files CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_files CHANGE extension extension VARCHAR(16) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_files CHANGE path path VARCHAR(1022) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * CREATE INDEX pid ON tl_files (pid)
 * CREATE UNIQUE INDEX uuid ON tl_files (uuid)
 * CREATE INDEX extension ON tl_files (extension)
 * CREATE INDEX alias ON tl_form (alias)
 * ALTER TABLE tl_form_field CHANGE html html TEXT DEFAULT NULL
 * ALTER TABLE tl_form_field CHANGE text text TEXT DEFAULT NULL
 * CREATE INDEX pid ON tl_image_size (pid)
 * CREATE INDEX pid ON tl_image_size_item (pid)
 * ALTER TABLE tl_layout CHANGE script script TEXT DEFAULT NULL
 * ALTER TABLE tl_layout CHANGE scripts scripts TEXT DEFAULT NULL
 * ALTER TABLE tl_layout CHANGE analytics analytics TEXT DEFAULT NULL
 * ALTER TABLE tl_layout CHANGE mootools mootools TEXT DEFAULT NULL
 * ALTER TABLE tl_layout CHANGE jquery jquery TEXT DEFAULT NULL
 * ALTER TABLE tl_layout CHANGE head head TEXT DEFAULT NULL
 * ALTER TABLE tl_log CHANGE text text TEXT DEFAULT NULL
 * ALTER TABLE tl_member CHANGE backupCodes backupCodes TEXT DEFAULT NULL
 * ALTER TABLE tl_member CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
 * CREATE UNIQUE INDEX username ON tl_member (username)
 * CREATE INDEX email ON tl_member (email)
 * ALTER TABLE tl_module CHANGE reg_deleteDir reg_deleteDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE data data TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE cal_featured cal_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE nl_text nl_text TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE nl_template nl_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE nl_unsubscribe nl_unsubscribe TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE nl_subscribe nl_subscribe TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE nl_hideChannels nl_hideChannels CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_showQuantity news_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_order news_order VARCHAR(32) CHARACTER SET ascii DEFAULT 'order_date_desc' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_format news_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'news_month' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_template news_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_metaFields news_metaFields VARCHAR(255) CHARACTER SET ascii DEFAULT 'a:2:{i:0;s:4:"date";i:1;s:6:"author";}' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_jumpToCurrent news_jumpToCurrent VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE news_featured news_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE list_info_layout list_info_layout VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE list_layout list_layout VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE list_info_where list_info_where TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_info list_info TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_sort list_sort TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_search list_search TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_where list_where TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_fields list_fields TINYTEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE list_table list_table VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_template com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_requireLogin com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_bbcode com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_moderate com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE com_order com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_showQuantity cal_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_ctemplate cal_ctemplate VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_template cal_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_order cal_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_ignoreDynamic cal_ignoreDynamic CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_format cal_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'cal_month' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_hideRunning cal_hideRunning CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE cal_noSpan cal_noSpan CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE guests guests CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE protected protected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_password reg_password TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE reg_text reg_text TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE reg_activate reg_activate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_assignDir reg_assignDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_close reg_close VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_skipName reg_skipName CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE reg_allowLogin reg_allowLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE disableCaptcha disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE rss_template rss_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE rss_feed rss_feed TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE html html TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE useCaption useCaption CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE imgSize imgSize VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE url url TEXT DEFAULT NULL
 * ALTER TABLE tl_module CHANGE loadFirst loadFirst CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE inColumn inColumn VARCHAR(32) CHARACTER SET ascii DEFAULT 'main' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE searchTpl searchTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE searchType searchType VARCHAR(16) CHARACTER SET ascii DEFAULT 'simple' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE contextLength contextLength VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE fuzzy fuzzy CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE queryType queryType VARCHAR(8) CHARACTER SET ascii DEFAULT 'and' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE memberTpl memberTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE redirectBack redirectBack CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE autologin autologin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE showHidden showHidden CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE navigationTpl navigationTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE defineRoot defineRoot CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE showProtected showProtected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE hardLimit hardLimit CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_module CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'navigation' NOT NULL COLLATE `ascii_bin`
 * ALTER TABLE tl_news CHANGE description description TEXT DEFAULT NULL
 * ALTER TABLE tl_news CHANGE teaser teaser TEXT DEFAULT NULL
 * CREATE INDEX alias ON tl_news (alias)
 * ALTER TABLE tl_news_feed CHANGE description description TEXT DEFAULT NULL
 * CREATE INDEX alias ON tl_news_feed (alias)
 * ALTER TABLE tl_newsletter CHANGE text text MEDIUMTEXT DEFAULT NULL
 * ALTER TABLE tl_newsletter CHANGE content content MEDIUMTEXT DEFAULT NULL
 * ALTER TABLE tl_newsletter CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * CREATE INDEX pid ON tl_newsletter (pid)
 * CREATE UNIQUE INDEX pid_hash ON tl_newsletter_deny_list (pid, hash)
 * CREATE UNIQUE INDEX pid_email ON tl_newsletter_recipients (pid, email)
 * CREATE INDEX email ON tl_newsletter_recipients (email)
 * ALTER TABLE tl_page CHANGE robotsTxt robotsTxt TEXT DEFAULT NULL
 * ALTER TABLE tl_page CHANGE urlPrefix urlPrefix VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
 * ALTER TABLE tl_page CHANGE description description TEXT DEFAULT NULL
 * CREATE INDEX alias ON tl_page (alias)
 * ALTER TABLE tl_style CHANGE own own TEXT DEFAULT NULL
 * CREATE INDEX pid ON tl_style (pid)
 * ALTER TABLE tl_style_sheet CHANGE vars vars TEXT DEFAULT NULL
 * ALTER TABLE tl_style_sheet CHANGE mediaQuery mediaQuery TEXT DEFAULT NULL
 * CREATE UNIQUE INDEX name ON tl_style_sheet (name)
 * ALTER TABLE tl_theme CHANGE vars vars TEXT DEFAULT NULL
 * ALTER TABLE tl_undo CHANGE query query TEXT DEFAULT NULL
 * ALTER TABLE tl_user CHANGE backupCodes backupCodes TEXT DEFAULT NULL
 * ALTER TABLE tl_user CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
 * CREATE UNIQUE INDEX username ON tl_user (username)
 * CREATE INDEX email ON tl_user (email)
 * ALTER TABLE tl_version CHANGE editUrl editUrl TEXT DEFAULT NULL

                                                                                
 [OK] Executed 193 SQL queries.                                                 
                                                                                

                                                                                
 [OK] All migrations completed.