Wir möchten eine 3.5.40 wie gewohnt migrieren auf 4.9.3, der Installer läuft hoch und macht die DB-Zwischen-Updates der Contao-Versionen. Wir arbeiten beim Provider unseres Vertrauens (metanet), PHP 7.4 ist am Laufen mit 2GB Memory. Die anschliessenden DB Query hingegen stürzen ab. Könnte jemand helfen?
Fehlermeldung in /manager/var/logs:
Es ist ein Fehler aufgetreten.
Bei der Ausführung des Skriptes ist ein Fehler aufgetreten. Irgendetwas funktioniert nicht richtig.
Code:
[2020-05-26 15:42:55] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_route":"contao_install","_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction"},"request_uri":"https://cn4.domain.ch/contao/install","method":"POST"} []
[2020-05-26 15:42:56] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC': SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline." at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 106 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC':\n\nSQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:83, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78)"} []
Hier sind die vorgeschlagenen SQL Updates
(Extensions habe ich noch keine installiert):
Code:
Tabellen ändern
Alle auswählen
ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_content CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX name ON tl_cron
ALTER TABLE tl_cron ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_cron CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX pid_published_sorting ON tl_faq
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 path 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
DROP INDEX pid ON tl_form_field
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 username ON tl_member
DROP INDEX email ON tl_member
DROP INDEX autologin ON tl_member
DROP INDEX activation 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
DROP INDEX pid_start_stop_published 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_email ON tl_newsletter_recipients
DROP INDEX pid ON tl_newsletter_recipients
DROP INDEX 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
DROP INDEX pid_type_start_stop_published 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 url ON tl_search
DROP INDEX checksum_pid ON tl_search
DROP INDEX text ON tl_search
ALTER TABLE tl_search ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_search CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX pid ON tl_search_index
DROP INDEX word ON tl_search_index
ALTER TABLE tl_search_index ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_search_index 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
DROP INDEX fromTable ON tl_version
DROP INDEX pid ON tl_version
ALTER TABLE tl_version ENGINE = InnoDB ROW_FORMAT = DYNAMIC
ALTER TABLE tl_version CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
Spalten ändern
Alle auswählen
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`
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
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 endTime endTime INT DEFAULT NULL
ALTER TABLE tl_calendar_events CHANGE startTime startTime INT DEFAULT NULL
ALTER TABLE tl_calendar_events CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
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_comments_notify CHANGE email email VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_content CHANGE com_template com_template VARCHAR(64) DEFAULT 'com_default' NOT NULL
ALTER TABLE tl_content CHANGE com_order com_order VARCHAR(32) DEFAULT 'ascending' NOT NULL
ALTER TABLE tl_content CHANGE perRow perRow SMALLINT UNSIGNED DEFAULT 4 NOT NULL
ALTER TABLE tl_content CHANGE sortOrder sortOrder VARCHAR(32) DEFAULT 'ascending' NOT NULL
ALTER TABLE tl_content CHANGE floating floating VARCHAR(32) DEFAULT 'above' NOT NULL
ALTER TABLE tl_content CHANGE size size VARCHAR(255) DEFAULT '' NOT NULL
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) DEFAULT 'text' NOT NULL
ALTER TABLE tl_faq CHANGE floating floating VARCHAR(12) DEFAULT 'above' NOT NULL
ALTER TABLE tl_faq CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
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
ALTER TABLE tl_files CHANGE importantPartHeight importantPartHeight DOUBLE PRECISION UNSIGNED DEFAULT '0' NOT NULL
ALTER TABLE tl_files CHANGE importantPartWidth importantPartWidth DOUBLE PRECISION UNSIGNED DEFAULT '0' NOT NULL
ALTER TABLE tl_files CHANGE importantPartY importantPartY DOUBLE PRECISION UNSIGNED DEFAULT '0' NOT NULL
ALTER TABLE tl_files CHANGE importantPartX importantPartX DOUBLE PRECISION UNSIGNED DEFAULT '0' NOT NULL
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_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_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_layout CHANGE minifyMarkup minifyMarkup CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_layout CHANGE combineScripts combineScripts CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_layout CHANGE align align VARCHAR(32) DEFAULT 'center' NOT NULL
ALTER TABLE tl_layout CHANGE mooSource mooSource VARCHAR(16) DEFAULT 'moo_local' 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_member CHANGE password password VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_member CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_module CHANGE nl_template nl_template VARCHAR(64) DEFAULT 'nl_simple' NOT NULL
ALTER TABLE tl_module CHANGE news_order news_order VARCHAR(32) DEFAULT 'order_date_desc' NOT NULL
ALTER TABLE tl_module CHANGE news_format news_format VARCHAR(32) DEFAULT 'news_month' NOT NULL
ALTER TABLE tl_module CHANGE news_template news_template VARCHAR(64) DEFAULT 'news_latest' NOT NULL
ALTER TABLE tl_module CHANGE news_metaFields news_metaFields VARCHAR(255) DEFAULT 'a:2:{i:0;s:4:"date";i:1;s:6:"author";}' NOT NULL
ALTER TABLE tl_module CHANGE news_featured news_featured VARCHAR(16) DEFAULT 'all_items' NOT NULL
ALTER TABLE tl_module CHANGE list_info_layout list_info_layout VARCHAR(64) DEFAULT 'info_default' NOT NULL
ALTER TABLE tl_module CHANGE list_layout list_layout VARCHAR(64) DEFAULT 'list_default' NOT NULL
ALTER TABLE tl_module CHANGE com_template com_template VARCHAR(64) DEFAULT 'com_default' NOT NULL
ALTER TABLE tl_module CHANGE com_order com_order VARCHAR(32) DEFAULT 'ascending' NOT NULL
ALTER TABLE tl_module CHANGE cal_ctemplate cal_ctemplate VARCHAR(64) DEFAULT 'cal_default' NOT NULL
ALTER TABLE tl_module CHANGE cal_template cal_template VARCHAR(64) DEFAULT 'event_full' NOT NULL
ALTER TABLE tl_module CHANGE cal_order cal_order VARCHAR(32) DEFAULT 'ascending' NOT NULL
ALTER TABLE tl_module CHANGE cal_format cal_format VARCHAR(32) DEFAULT 'cal_month' NOT NULL
ALTER TABLE tl_module CHANGE numberOfItems numberOfItems SMALLINT UNSIGNED DEFAULT 3 NOT NULL
ALTER TABLE tl_module CHANGE rss_template rss_template VARCHAR(64) DEFAULT 'rss_default' NOT NULL
ALTER TABLE tl_module CHANGE rss_cache rss_cache INT UNSIGNED DEFAULT 3600 NOT NULL
ALTER TABLE tl_module CHANGE imgSize imgSize VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_module CHANGE inColumn inColumn VARCHAR(32) DEFAULT 'main' NOT NULL
ALTER TABLE tl_module CHANGE searchType searchType VARCHAR(32) DEFAULT 'simple' NOT NULL
ALTER TABLE tl_module CHANGE queryType queryType VARCHAR(32) DEFAULT 'and' NOT NULL
ALTER TABLE tl_module CHANGE type type VARCHAR(64) DEFAULT 'navigation' NOT NULL
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_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 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_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_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_channel CHANGE smtpuser senderName VARCHAR(128) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE mobilelayout clientCache INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_page CHANGE redirect redirect VARCHAR(32) DEFAULT 'permanent' 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_search CHANGE filesize filesize DOUBLE PRECISION DEFAULT '0' NOT NULL
ALTER TABLE tl_search_index CHANGE word word VARCHAR(64) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_style_sheet CHANGE media media VARCHAR(255) DEFAULT 'a:1:{i:0;s:3:"all";}' NOT NULL
ALTER TABLE tl_user CHANGE photo amg BLOB DEFAULT NULL
ALTER TABLE tl_user CHANGE inherit inherit VARCHAR(12) DEFAULT 'group' NOT NULL
ALTER TABLE tl_user CHANGE password password VARCHAR(255) DEFAULT '' 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 username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_version CHANGE editUrl editUrl TEXT DEFAULT NULL
Spalten anlegen
Alle auswählen
CREATE INDEX alias ON tl_article (alias)
CREATE INDEX pid_start_stop_published_sorting ON tl_article (
pid, start, stop, published, sorting
)
CREATE INDEX alias ON tl_calendar_events (alias)
CREATE INDEX pid_start_stop_published ON tl_calendar_events (pid, start, stop, published)
CREATE INDEX alias ON tl_calendar_feed (alias)
CREATE INDEX published ON tl_comments (published)
CREATE INDEX source_parent_published ON tl_comments (source, parent, published)
CREATE INDEX tokenremove ON tl_comments_notify (tokenremove)
CREATE INDEX pid_ptable_invisible_sorting ON tl_content (pid, ptable, invisible, sorting)
CREATE INDEX path ON tl_files (
path(768)
)
ALTER TABLE tl_form ADD customTpl VARCHAR(64) 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_image_size ADD formats VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_image_size ADD cssClass VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_layout ADD orderExtJs BLOB DEFAULT NULL
ALTER TABLE tl_layout ADD lightboxSize VARCHAR(255) DEFAULT '' NOT 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_module ADD cal_hideRunning CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_module ADD nl_text TEXT DEFAULT NULL
ALTER TABLE tl_news ADD orderEnclosure BLOB DEFAULT NULL
ALTER TABLE tl_news ADD imageTitle VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_news ADD description TEXT DEFAULT NULL
ALTER TABLE tl_news ADD pageTitle VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_newsletter_channel ADD sender VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_newsletter_channel ADD template VARCHAR(32) DEFAULT 'mail_default' NOT NULL
CREATE INDEX active ON tl_newsletter_recipients (active)
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 requireItem 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 redirectBack CHAR(1) DEFAULT '' NOT NULL
CREATE INDEX type_dns ON tl_page (type, dns)
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 fullscreen CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_user_group ADD amg BLOB DEFAULT NULL