Kein DB-Update: Migration zu 4.13

**Traumkunst** · 22.03.2024, 17:52

Hallo,

ich migriere eine ältere Contao-Installation 3.5.40 nach 4.13 und gehe dabei nach den üblichen Anleitungen (z.B. der Contao Academy) vor.

Ich importiere die alte DB (MySQL 5.7) in eine neue (MariaDB 10.6), und lass den Contao Manager durchlaufen. Der spielt problemlos diverse Migrationsvorgänge durch, stolpert dann aber über die Datenbank-Änderungen mit den Meldung "Die Änderungen konnten nicht angewendet werden. Möglicherweise wurde die Datenbank geändert, bitte prüfe nochmals und versuche es erneut."

Darunter erscheinen dann die ganzen Fehlschläge -- es sind sehr viele:

HTML-Code:

Tabelle tl_crawl_queue hinzufügen
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
Tabelle tl_cron_job hinzufügen
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
Tabelle tl_remember_me hinzufügen
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
Tabelle tl_trusted_device hinzufügen
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
Tabelle tl_calendar hinzufügen
CREATE TABLE tl_calendar (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, jumpTo INT UNSIGNED DEFAULT 0 NOT NULL, protected CHAR(1) DEFAULT '' NOT NULL, groups BLOB DEFAULT NULL, allowComments CHAR(1) DEFAULT '' NOT NULL, notify VARCHAR(32) DEFAULT 'notify_admin' NOT NULL, sortOrder VARCHAR(32) DEFAULT 'ascending' NOT NULL, perPage SMALLINT UNSIGNED DEFAULT 0 NOT NULL, moderate CHAR(1) DEFAULT '' NOT NULL, bbcode CHAR(1) DEFAULT '' NOT NULL, requireLogin CHAR(1) DEFAULT '' NOT NULL, disableCaptcha CHAR(1) DEFAULT '' NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_calendar_events hinzufügen
CREATE TABLE tl_calendar_events (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, featured CHAR(1) DEFAULT '' NOT NULL, alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, author INT UNSIGNED DEFAULT 0 NOT NULL, addTime CHAR(1) DEFAULT '' NOT NULL, startTime BIGINT DEFAULT NULL, endTime BIGINT DEFAULT NULL, startDate BIGINT DEFAULT NULL, endDate BIGINT DEFAULT NULL, pageTitle VARCHAR(255) DEFAULT '' NOT NULL, robots VARCHAR(32) DEFAULT '' NOT NULL, description TEXT DEFAULT NULL, location VARCHAR(255) DEFAULT '' NOT NULL, address VARCHAR(255) DEFAULT '' NOT NULL, teaser TEXT DEFAULT NULL, addImage CHAR(1) DEFAULT '' NOT NULL, overwriteMeta CHAR(1) DEFAULT '' NOT NULL, singleSRC BINARY(16) DEFAULT NULL, alt VARCHAR(255) DEFAULT '' NOT NULL, imageTitle VARCHAR(255) DEFAULT '' NOT NULL, size VARCHAR(64) DEFAULT '' NOT NULL, imagemargin VARCHAR(128) DEFAULT '' NOT NULL, imageUrl VARCHAR(2048) DEFAULT '' NOT NULL, fullsize CHAR(1) DEFAULT '' NOT NULL, caption VARCHAR(255) DEFAULT '' NOT NULL, floating VARCHAR(32) DEFAULT 'above' NOT NULL, recurring CHAR(1) DEFAULT '' NOT NULL, repeatEach VARCHAR(64) DEFAULT '' NOT NULL, repeatEnd INT UNSIGNED DEFAULT 0 NOT NULL, recurrences SMALLINT UNSIGNED DEFAULT 0 NOT NULL, addEnclosure CHAR(1) DEFAULT '' NOT NULL, enclosure BLOB DEFAULT NULL, source VARCHAR(32) DEFAULT 'default' NOT NULL, jumpTo INT UNSIGNED DEFAULT 0 NOT NULL, articleId INT UNSIGNED DEFAULT 0 NOT NULL, url VARCHAR(2048) DEFAULT '' NOT NULL, target CHAR(1) DEFAULT '' NOT NULL, cssClass VARCHAR(255) DEFAULT '' NOT NULL, noComments CHAR(1) DEFAULT '' NOT NULL, published CHAR(1) DEFAULT '' NOT NULL, start VARCHAR(10) DEFAULT '' NOT NULL, stop VARCHAR(10) DEFAULT '' NOT NULL, INDEX alias (alias), INDEX pid_published_featured_start_stop (pid, published, featured, start, stop), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_calendar_feed hinzufügen
CREATE TABLE tl_calendar_feed (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, language VARCHAR(32) DEFAULT '' NOT NULL, calendars BLOB DEFAULT NULL, format VARCHAR(32) DEFAULT 'rss' NOT NULL, source VARCHAR(32) DEFAULT 'source_teaser' NOT NULL, maxItems SMALLINT UNSIGNED DEFAULT 25 NOT NULL, feedBase VARCHAR(255) DEFAULT '' NOT NULL, description TEXT DEFAULT NULL, imgSize VARCHAR(255) DEFAULT '' NOT NULL, INDEX alias (alias), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_comments hinzufügen
CREATE TABLE tl_comments (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, source VARCHAR(32) DEFAULT '' NOT NULL, parent INT UNSIGNED DEFAULT 0 NOT NULL, date VARCHAR(64) DEFAULT '' NOT NULL, name VARCHAR(64) DEFAULT '' NOT NULL, email VARCHAR(255) DEFAULT '' NOT NULL, website VARCHAR(128) DEFAULT '' NOT NULL, member INT UNSIGNED DEFAULT 0 NOT NULL, comment TEXT DEFAULT NULL, addReply CHAR(1) DEFAULT '' NOT NULL, author INT UNSIGNED DEFAULT 0 NOT NULL, reply TEXT DEFAULT NULL, published CHAR(1) DEFAULT '' NOT NULL, ip VARCHAR(64) DEFAULT '' NOT NULL, notified CHAR(1) DEFAULT '' NOT NULL, notifiedReply CHAR(1) DEFAULT '' NOT NULL, INDEX published (published), INDEX source_parent_published (source, parent, published), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_comments_notify hinzufügen
CREATE TABLE tl_comments_notify (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, source VARCHAR(32) DEFAULT '' NOT NULL, parent INT UNSIGNED DEFAULT 0 NOT NULL, name VARCHAR(128) DEFAULT '' NOT NULL, email VARCHAR(255) DEFAULT '' NOT NULL, url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`, addedOn VARCHAR(10) DEFAULT '' NOT NULL, active CHAR(1) DEFAULT '' NOT NULL, tokenRemove VARCHAR(32) DEFAULT '' NOT NULL, INDEX source_parent_active_email (source, parent, active, email), INDEX tokenremove (tokenremove), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_faq hinzufügen
CREATE TABLE tl_faq (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, sorting INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, question VARCHAR(255) DEFAULT '' NOT NULL, alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, author INT UNSIGNED DEFAULT 0 NOT NULL, answer TEXT DEFAULT NULL, pageTitle VARCHAR(255) DEFAULT '' NOT NULL, robots VARCHAR(32) DEFAULT '' NOT NULL, description TEXT DEFAULT NULL, addImage CHAR(1) DEFAULT '' NOT NULL, overwriteMeta CHAR(1) DEFAULT '' NOT NULL, singleSRC BINARY(16) DEFAULT NULL, alt VARCHAR(255) DEFAULT '' NOT NULL, imageTitle VARCHAR(255) DEFAULT '' NOT NULL, size VARCHAR(64) DEFAULT '' NOT NULL, imagemargin VARCHAR(128) DEFAULT '' NOT NULL, imageUrl VARCHAR(2048) DEFAULT '' NOT NULL, fullsize CHAR(1) DEFAULT '' NOT NULL, caption VARCHAR(255) DEFAULT '' NOT NULL, floating VARCHAR(12) DEFAULT 'above' NOT NULL, addEnclosure CHAR(1) DEFAULT '' NOT NULL, enclosure BLOB DEFAULT NULL, noComments CHAR(1) DEFAULT '' NOT NULL, published CHAR(1) DEFAULT '' NOT NULL, INDEX pid_published (pid, published), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_faq_category hinzufügen
CREATE TABLE tl_faq_category (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, headline VARCHAR(255) DEFAULT '' NOT NULL, jumpTo INT UNSIGNED DEFAULT 0 NOT NULL, allowComments CHAR(1) DEFAULT '' NOT NULL, notify VARCHAR(16) DEFAULT 'notify_admin' NOT NULL, sortOrder VARCHAR(12) DEFAULT 'ascending' NOT NULL, perPage SMALLINT UNSIGNED DEFAULT 0 NOT NULL, moderate CHAR(1) DEFAULT '' NOT NULL, bbcode CHAR(1) DEFAULT '' NOT NULL, requireLogin CHAR(1) DEFAULT '' NOT NULL, disableCaptcha CHAR(1) DEFAULT '' NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_news hinzufügen
CREATE TABLE tl_news (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, headline VARCHAR(255) DEFAULT '' NOT NULL, featured CHAR(1) DEFAULT '' NOT NULL, alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, author INT UNSIGNED DEFAULT 0 NOT NULL, date INT UNSIGNED DEFAULT 0 NOT NULL, time INT DEFAULT 0 NOT NULL, pageTitle VARCHAR(255) DEFAULT '' NOT NULL, robots VARCHAR(32) DEFAULT '' NOT NULL, description TEXT DEFAULT NULL, subheadline VARCHAR(255) DEFAULT '' NOT NULL, teaser TEXT DEFAULT NULL, addImage CHAR(1) DEFAULT '' NOT NULL, overwriteMeta CHAR(1) DEFAULT '' NOT NULL, singleSRC BINARY(16) DEFAULT NULL, alt VARCHAR(255) DEFAULT '' NOT NULL, imageTitle VARCHAR(255) DEFAULT '' NOT NULL, size VARCHAR(64) DEFAULT '' NOT NULL, imagemargin VARCHAR(128) DEFAULT '' NOT NULL, imageUrl VARCHAR(2048) DEFAULT '' NOT NULL, fullsize CHAR(1) DEFAULT '' NOT NULL, caption VARCHAR(255) DEFAULT '' NOT NULL, floating VARCHAR(12) DEFAULT 'above' NOT NULL, addEnclosure CHAR(1) DEFAULT '' NOT NULL, enclosure BLOB DEFAULT NULL, source VARCHAR(12) DEFAULT 'default' NOT NULL, jumpTo INT UNSIGNED DEFAULT 0 NOT NULL, articleId INT UNSIGNED DEFAULT 0 NOT NULL, url VARCHAR(2048) DEFAULT '' NOT NULL, target CHAR(1) DEFAULT '' NOT NULL, cssClass VARCHAR(255) DEFAULT '' NOT NULL, noComments CHAR(1) DEFAULT '' NOT NULL, published CHAR(1) DEFAULT '' NOT NULL, start VARCHAR(10) DEFAULT '' NOT NULL, stop VARCHAR(10) DEFAULT '' NOT NULL, INDEX alias (alias), INDEX pid_published_featured_start_stop (pid, published, featured, start, stop), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_news_archive hinzufügen
CREATE TABLE tl_news_archive (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, jumpTo INT UNSIGNED DEFAULT 0 NOT NULL, protected CHAR(1) DEFAULT '' NOT NULL, groups BLOB DEFAULT NULL, allowComments CHAR(1) DEFAULT '' NOT NULL, notify VARCHAR(16) DEFAULT 'notify_admin' NOT NULL, sortOrder VARCHAR(32) DEFAULT 'ascending' NOT NULL, perPage SMALLINT UNSIGNED DEFAULT 0 NOT NULL, moderate CHAR(1) DEFAULT '' NOT NULL, bbcode CHAR(1) DEFAULT '' NOT NULL, requireLogin CHAR(1) DEFAULT '' NOT NULL, disableCaptcha CHAR(1) DEFAULT '' NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_news_feed hinzufügen
CREATE TABLE tl_news_feed (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, language VARCHAR(32) DEFAULT '' NOT NULL, archives BLOB DEFAULT NULL, format VARCHAR(32) DEFAULT 'rss' NOT NULL, source VARCHAR(32) DEFAULT 'source_teaser' NOT NULL, maxItems SMALLINT UNSIGNED DEFAULT 25 NOT NULL, feedBase VARCHAR(255) DEFAULT '' NOT NULL, description TEXT DEFAULT NULL, imgSize VARCHAR(255) DEFAULT '' NOT NULL, INDEX alias (alias), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_newsletter hinzufügen
CREATE TABLE tl_newsletter (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, subject VARCHAR(255) DEFAULT '' NOT NULL, alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, content MEDIUMTEXT DEFAULT NULL, text MEDIUMTEXT DEFAULT NULL, addFile CHAR(1) DEFAULT '' NOT NULL, files BLOB DEFAULT NULL, template VARCHAR(64) DEFAULT '' NOT NULL, sendText CHAR(1) DEFAULT '' NOT NULL, externalImages CHAR(1) DEFAULT '' NOT NULL, mailerTransport VARCHAR(255) DEFAULT '' NOT NULL, sender VARCHAR(255) DEFAULT '' NOT NULL, senderName VARCHAR(128) DEFAULT '' NOT NULL, sent CHAR(1) DEFAULT '' NOT NULL, date VARCHAR(10) DEFAULT '' NOT NULL, INDEX pid (pid), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_newsletter_channel hinzufügen
CREATE TABLE tl_newsletter_channel (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, jumpTo INT UNSIGNED DEFAULT 0 NOT NULL, template VARCHAR(32) DEFAULT '' NOT NULL, mailerTransport VARCHAR(255) DEFAULT '' NOT NULL, sender VARCHAR(255) DEFAULT '' NOT NULL, senderName VARCHAR(128) DEFAULT '' NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_newsletter_deny_list hinzufügen
CREATE TABLE tl_newsletter_deny_list (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, hash VARCHAR(32) DEFAULT NULL, UNIQUE INDEX pid_hash (pid, hash), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_newsletter_recipients hinzufügen
CREATE TABLE tl_newsletter_recipients (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, email VARCHAR(255) DEFAULT '' NOT NULL, active CHAR(1) DEFAULT '' NOT NULL, addedOn VARCHAR(10) DEFAULT '' NOT NULL, UNIQUE INDEX pid_email (pid, email), INDEX email (email), INDEX active (active), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
Tabelle tl_opt_in hinzufügen
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
Tabelle tl_opt_in_related hinzufügen
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
Tabelle tl_preview_link hinzufügen
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
Tabelle tl_search hinzufügen
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
Tabelle tl_search_index hinzufügen
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
Tabelle tl_search_term hinzufügen
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
Tabelle tl_repository_installs löschen
Tabelle tl_repository_instfiles löschen
Tabelle tl_session löschen
Tabelle tl_rocksolid_slider löschen
Tabelle tl_rocksolid_mega_menu_column löschen
Tabelle tl_dma_eg_fields löschen
Tabelle tl_rocksolid_slide löschen
Tabelle tl_dma_eg löschen
Tabelle tl_rocksolid_mega_menu löschen
Tabelle tl_cron löschen
Index "pid_start_stop_published_sorting" aus tl_article löschen
Feld tl_article.teaser ändern

TEXT DEFAULT NULL
ALTER TABLE tl_article CHANGE teaser teaser TEXT DEFAULT NULL
Feld tl_article.keywords ändern

TEXT DEFAULT NULL
ALTER TABLE tl_article CHANGE keywords keywords TEXT DEFAULT NULL
Feld tl_article.inColumn ändern

VARCHAR(32) DEFAULT 'main' NOT NULL
ALTER TABLE tl_article CHANGE inColumn inColumn VARCHAR(32) DEFAULT 'main' NOT NULL
Feld tl_article.alias ändern

VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_article CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
Feld tl_article.space löschen
Index "pid_published_incolumn_start_stop" zu tl_article hinzufügen

pid, published, incolumn, start, stop
CREATE INDEX pid_published_incolumn_start_stop ON tl_article (pid, published, incolumn, start, stop)
Index "pid_ptable_invisible_sorting" aus tl_content löschen
Feld tl_content.vimeoOptions ändern

TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE vimeoOptions vimeoOptions TEXT DEFAULT NULL
Feld tl_content.playerOptions ändern

TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE playerOptions playerOptions TEXT DEFAULT NULL
Feld tl_content.overwriteLink ändern

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE overwriteLink overwriteLink CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.youtubeOptions ändern

TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE youtubeOptions youtubeOptions TEXT DEFAULT NULL
Feld tl_content.overwriteMeta ändern

CHAR(1) 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`
Feld tl_content.stop ändern

VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE stop stop VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.start ändern

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`
Feld tl_content.invisible ändern

CHAR(1) 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`
Feld tl_content.guests ändern

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`
Feld tl_content.protected ändern

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`
Feld tl_content.sliderContinuous ändern

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`
Feld tl_content.playerSize ändern

VARCHAR(64) 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`
Feld tl_content.youtube ändern

VARCHAR(16) 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`
Feld tl_content.customTpl ändern

VARCHAR(64) 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`
Feld tl_content.galleryTpl ändern

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`
Feld tl_content.metaIgnore ändern

CHAR(1) 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`
Feld tl_content.sortBy ändern

VARCHAR(32) 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`
Feld tl_content.perRow ändern

SMALLINT UNSIGNED DEFAULT 4 NOT NULL
ALTER TABLE tl_content CHANGE perRow perRow SMALLINT UNSIGNED DEFAULT 4 NOT NULL
Feld tl_content.useHomeDir ändern

CHAR(1) 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`
Feld tl_content.useImage ändern

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`
Feld tl_content.target ändern

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`
Feld tl_content.url ändern

TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE url url TEXT DEFAULT NULL
Feld tl_content.code ändern

TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE code code TEXT DEFAULT NULL
Feld tl_content.highlight ändern

VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE highlight highlight VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.sortOrder ändern

VARCHAR(32) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE sortOrder sortOrder VARCHAR(32) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
Feld tl_content.sortable ändern

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE sortable sortable CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.tleft ändern

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`
Feld tl_content.tfoot ändern

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`
Feld tl_content.thead ändern

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`
Feld tl_content.listtype ändern

VARCHAR(32) 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`
Feld tl_content.html ändern

MEDIUMTEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE html html MEDIUMTEXT DEFAULT NULL
Feld tl_content.floating ändern

VARCHAR(32) CHARACTER SET ascii DEFAULT 'above' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE floating floating VARCHAR(32) CHARACTER SET ascii DEFAULT 'above' NOT NULL COLLATE `ascii_bin`
Feld tl_content.fullsize ändern

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.imageUrl ändern

TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE imageUrl imageUrl TEXT DEFAULT NULL
Feld tl_content.imagemargin ändern

VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE imagemargin imagemargin VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.size ändern

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`
Feld tl_content.addImage ändern

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`
Feld tl_content.text ändern

MEDIUMTEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE text text MEDIUMTEXT DEFAULT NULL
Feld tl_content.headline ändern

VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' 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
Feld tl_content.type ändern

VARCHAR(64) CHARACTER SET ascii DEFAULT 'text' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'text' NOT NULL COLLATE `ascii_bin`
Feld tl_content.ptable ändern

VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE ptable ptable VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.youtubeStop löschen
Feld tl_content.youtubeStart löschen
Feld tl_content.rsts_visibleAreaAlign löschen
Feld tl_content.rsts_thumbControls löschen
Feld tl_content.rsts_import_settings_from löschen
Feld tl_content.rsts_import_settings löschen
Feld tl_content.dmaElementTpl löschen
Feld tl_content.dma_eg_data löschen
Feld tl_content.rsts_cssPrefix löschen
Feld tl_content.rsts_customSkin löschen
Feld tl_content.rsts_combineNavItems löschen
Feld tl_content.rsts_rowSlideRatio löschen
Feld tl_content.rsts_rowMinSize löschen
Feld tl_content.rsts_rowMaxCount löschen
Feld tl_content.rsts_slideMaxSize löschen
Feld tl_content.rsts_slideMinSize löschen
Feld tl_content.rsts_visibleAreaMax löschen
Feld tl_content.rsts_visibleArea löschen
Feld tl_content.rsts_prevNextSteps löschen
Feld tl_content.rsts_slideMaxCount löschen
Feld tl_content.rsts_thumbs_rowSlideRatio löschen
Feld tl_content.rsts_thumbs_rowMinSize löschen
Feld tl_content.rsts_thumbs_rowMaxCount löschen
Feld tl_content.rsts_thumbs_slideMaxSize löschen
Feld tl_content.rsts_thumbs_slideMinSize löschen
Feld tl_content.rsts_thumbs_visibleAreaMax löschen
Feld tl_content.rsts_thumbs_visibleArea löschen
Feld tl_content.rsts_thumbs_prevNextSteps löschen
Feld tl_content.rsts_thumbs_slideMaxCount löschen
Feld tl_content.rsts_thumbs_imgSize löschen
Feld tl_content.rsts_thumbs_controls löschen
Feld tl_content.rsts_thumbs_imagePosition löschen
Feld tl_content.rsts_thumbs_scaleMode löschen
Feld tl_content.rsts_thumbs_duration löschen
Feld tl_content.rsts_thumbs_gapSize löschen
Feld tl_content.rsts_thumbs_height löschen
Feld tl_content.rsts_thumbs_width löschen
Feld tl_content.rsts_thumbs löschen
Feld tl_content.rsts_captions löschen
Feld tl_content.rsts_keyboard löschen
Feld tl_content.rsts_deepLinkPrefix löschen
Feld tl_content.rsts_imagePosition löschen
Feld tl_content.rsts_scaleMode löschen
Feld tl_content.rsts_invertControls löschen
Feld tl_content.rsts_controls löschen
Feld tl_content.rsts_navType löschen
Feld tl_content.rsts_pauseAutoplayOnHover löschen
Feld tl_content.rsts_autoplayProgress löschen
Feld tl_content.rsts_autoplayRestart löschen
Feld tl_content.rsts_videoAutoplay löschen
Feld tl_content.rsts_autoplay löschen
Feld tl_content.rsts_duration löschen
Feld tl_content.rsts_gapSize löschen
Feld tl_content.rsts_preloadSlides löschen
Feld tl_content.rsts_height löschen
Feld tl_content.rsts_width löschen
Feld tl_content.rsts_skin löschen
Feld tl_content.rsts_centerContent löschen
Feld tl_content.rsts_loop löschen
Feld tl_content.rsts_random löschen
Feld tl_content.rsts_direction löschen
Feld tl_content.rsts_type löschen
Feld tl_content.rsts_template löschen
Feld tl_content.rsts_id löschen
Feld tl_content.rsts_content_type löschen
Feld tl_content.rsce_data löschen
Feld tl_content.rs_columns_small löschen
Feld tl_content.rs_columns_medium löschen
Feld tl_content.rs_columns_large löschen
Feld tl_content.space löschen
Feld tl_content.autoplay löschen
Feld tl_content.shClass löschen
Feld tl_content.com_template hinzufügen

VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.com_requireLogin hinzufügen

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.com_disableCaptcha hinzufügen

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.com_bbcode hinzufügen

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.com_moderate hinzufügen

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.com_perPage hinzufügen

SMALLINT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_content ADD com_perPage SMALLINT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_content.com_order hinzufügen

VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
Feld tl_content.data hinzufügen

TEXT DEFAULT NULL
ALTER TABLE tl_content ADD data TEXT DEFAULT NULL
Feld tl_content.playerColor hinzufügen

VARCHAR(6) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD playerColor VARCHAR(6) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.playerPreload hinzufügen

VARCHAR(8) 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`
Feld tl_content.splashImage hinzufügen

CHAR(1) 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`
Feld tl_content.playerAspect hinzufügen

VARCHAR(8) 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`
Feld tl_content.playerCaption hinzufügen

VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_content ADD playerCaption VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_content.vimeo hinzufügen

VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD vimeo VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.markdownSource hinzufügen

VARCHAR(12) CHARACTER SET ascii DEFAULT 'sourceText' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD markdownSource VARCHAR(12) CHARACTER SET ascii DEFAULT 'sourceText' NOT NULL COLLATE `ascii_bin`
Feld tl_content.inline hinzufügen

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD inline CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_content.showPreview hinzufügen

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`
Index "pid_ptable_invisible_start_stop" zu tl_content hinzufügen

pid, ptable, invisible, start, stop
CREATE INDEX pid_ptable_invisible_start_stop ON tl_content (pid, ptable, invisible, start, stop)
Index "type" zu tl_content hinzufügen

type
CREATE INDEX type ON tl_content (type)
Index "path" aus tl_files löschen
Feld tl_files.name ändern

VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_files CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
Feld tl_files.extension ändern

VARCHAR(16) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_files CHANGE extension extension VARCHAR(16) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
Feld tl_files.path ändern

VARCHAR(1022) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_files CHANGE path path VARCHAR(1022) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
Feld tl_files.lastModified hinzufügen

INT UNSIGNED DEFAULT NULL
ALTER TABLE tl_files ADD lastModified INT UNSIGNED DEFAULT NULL
CREATE INDEX path ON tl_files (path(768))
CREATE INDEX path ON tl_files (path(768))
Feld tl_form.method ändern

VARCHAR(12) DEFAULT 'POST' NOT NULL
ALTER TABLE tl_form CHANGE method method VARCHAR(12) DEFAULT 'POST' NOT NULL
Feld tl_form.format ändern

VARCHAR(12) DEFAULT 'raw' NOT NULL
ALTER TABLE tl_form CHANGE format format VARCHAR(12) DEFAULT 'raw' NOT NULL
Feld tl_form.alias ändern

VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_form CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
Feld tl_form.tableless löschen
Feld tl_form.customTpl hinzufügen

VARCHAR(64) DEFAULT '' NOT NULL
ALTER TABLE tl_form ADD customTpl VARCHAR(64) DEFAULT '' NOT NULL
Feld tl_form.mailerTransport hinzufügen

VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_form ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
Index "pid" aus tl_form_field löschen
Feld tl_form_field.extensions ändern

VARCHAR(255) DEFAULT 'jpg,jpeg
ALTER TABLE tl_form_field gif
ALTER TABLE tl_form_field png
ALTER TABLE tl_form_field pdf
ALTER TABLE tl_form_field doc
ALTER TABLE tl_form_field docx
ALTER TABLE tl_form_field xls
ALTER TABLE tl_form_field xlsx
ALTER TABLE tl_form_field ppt
ALTER TABLE tl_form_field pptx' NOT NULL
ALTER TABLE tl_form_field CHANGE extensions extensions VARCHAR(255) DEFAULT 'jpg,jpeg,gif,png,pdf,doc,docx,xls,xlsx,ppt,pptx' NOT NULL
Feld tl_form_field.size ändern

VARCHAR(255) DEFAULT 'a:2:{i:0;i:4;i:1;i:40;}' 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
Feld tl_form_field.html ändern

TEXT DEFAULT NULL
ALTER TABLE tl_form_field CHANGE html html TEXT DEFAULT NULL
Feld tl_form_field.text ändern

TEXT DEFAULT NULL
ALTER TABLE tl_form_field CHANGE text text TEXT DEFAULT NULL
Feld tl_form_field.type ändern

VARCHAR(64) DEFAULT 'text' NOT NULL
ALTER TABLE tl_form_field CHANGE type type VARCHAR(64) DEFAULT 'text' NOT NULL
Feld tl_form_field.rsce_data löschen
Feld tl_form_field.addSubmit löschen
Feld tl_form_field.fsType löschen
Feld tl_form_field.step hinzufügen

VARCHAR(10) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field ADD step VARCHAR(10) DEFAULT '' NOT NULL
Feld tl_form_field.maxval hinzufügen

VARCHAR(10) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field ADD maxval VARCHAR(10) DEFAULT '' NOT NULL
Feld tl_form_field.minval hinzufügen

VARCHAR(10) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field ADD minval VARCHAR(10) DEFAULT '' NOT NULL
Feld tl_form_field.maxImageHeight hinzufügen

INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_form_field ADD maxImageHeight INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_form_field.maxImageWidth hinzufügen

INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_form_field ADD maxImageWidth INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_form_field.errorMsg hinzufügen

VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field ADD errorMsg VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_form_field.customRgxp hinzufügen

VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field ADD customRgxp VARCHAR(255) DEFAULT '' NOT NULL
Index "pid_invisible" zu tl_form_field hinzufügen

pid, invisible
CREATE INDEX pid_invisible ON tl_form_field (pid, invisible)
Feld tl_image_size.lazyLoading hinzufügen

CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_image_size ADD lazyLoading CHAR(1) DEFAULT '' NOT NULL
Feld tl_image_size.formats hinzufügen

VARCHAR(1024) DEFAULT '' NOT NULL
ALTER TABLE tl_image_size ADD formats VARCHAR(1024) DEFAULT '' NOT NULL
Feld tl_image_size.cssClass hinzufügen

VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_image_size ADD cssClass VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_layout.minifyMarkup ändern

CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_layout CHANGE minifyMarkup minifyMarkup CHAR(1) DEFAULT '1' NOT NULL
Feld tl_layout.combineScripts ändern

CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_layout CHANGE combineScripts combineScripts CHAR(1) DEFAULT '1' NOT NULL
Feld tl_layout.scripts ändern

TEXT DEFAULT NULL
ALTER TABLE tl_layout CHANGE scripts scripts TEXT DEFAULT NULL
Feld tl_layout.align ändern

VARCHAR(32) DEFAULT 'center' NOT NULL
ALTER TABLE tl_layout CHANGE align align VARCHAR(32) DEFAULT 'center' NOT NULL
Feld tl_layout.script ändern

TEXT DEFAULT NULL
ALTER TABLE tl_layout CHANGE script script TEXT DEFAULT NULL
Feld tl_layout.analytics ändern

TEXT DEFAULT NULL
ALTER TABLE tl_layout CHANGE analytics analytics TEXT DEFAULT NULL
Feld tl_layout.mootools ändern

TEXT DEFAULT NULL
ALTER TABLE tl_layout CHANGE mootools mootools TEXT DEFAULT NULL
Feld tl_layout.jquery ändern

TEXT DEFAULT NULL
ALTER TABLE tl_layout CHANGE jquery jquery TEXT DEFAULT NULL
Feld tl_layout.head ändern

TEXT DEFAULT NULL
ALTER TABLE tl_layout CHANGE head head TEXT DEFAULT NULL
Feld tl_layout.loadingOrder ändern

VARCHAR(16) DEFAULT 'external_first' NOT NULL
ALTER TABLE tl_layout CHANGE loadingOrder loadingOrder VARCHAR(16) DEFAULT 'external_first' NOT NULL
Feld tl_layout.framework ändern

VARCHAR(255) DEFAULT 'a:2:{i:0;s:10:"layout.css";i:1;s:14:"responsive.css";}' 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
Feld tl_layout.cols ändern

VARCHAR(8) DEFAULT '2cll' NOT NULL
ALTER TABLE tl_layout CHANGE cols cols VARCHAR(8) DEFAULT '2cll' NOT NULL
Feld tl_layout.`rows` ändern

VARCHAR(8) DEFAULT '2rwh' NOT NULL
ALTER TABLE tl_layout CHANGE `rows` `rows` VARCHAR(8) DEFAULT '2rwh' NOT NULL
Feld tl_layout.rs_columns_load_css löschen
Feld tl_layout.mooSource löschen
Feld tl_layout.jSource löschen
Feld tl_layout.picturefill löschen
Feld tl_layout.doctype löschen
Feld tl_layout.sPosition löschen
Feld tl_layout.defaultImageDensities hinzufügen

VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_layout ADD defaultImageDensities VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_layout.lightboxSize hinzufügen

VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_layout ADD lightboxSize VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_log.text ändern

TEXT DEFAULT NULL
ALTER TABLE tl_log CHANGE text text TEXT DEFAULT NULL
Feld tl_log.ip löschen
Index "autologin" aus tl_member löschen
Index "activation" aus tl_member löschen
Feld tl_member.password ändern

VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_member CHANGE password password VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_member.username ändern

VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_member CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
Feld tl_member.language ändern

VARCHAR(64) DEFAULT '' NOT NULL
ALTER TABLE tl_member CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL
Feld tl_member.activation löschen
Feld tl_member.autologin löschen
Feld tl_member.loginCount löschen
Feld tl_member.newsletter hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_member ADD newsletter BLOB DEFAULT NULL
Feld tl_member.backupCodes hinzufügen

TEXT DEFAULT NULL
ALTER TABLE tl_member ADD backupCodes TEXT DEFAULT NULL
Feld tl_member.useTwoFactor hinzufügen

CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_member ADD useTwoFactor CHAR(1) DEFAULT '' NOT NULL
Feld tl_member.secret hinzufügen

BINARY(128) DEFAULT NULL
ALTER TABLE tl_member ADD secret BINARY(128) DEFAULT NULL
Feld tl_member.loginAttempts hinzufügen

SMALLINT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_member ADD loginAttempts SMALLINT UNSIGNED DEFAULT 0 NOT NULL
Index "login_disable_start_stop" zu tl_member hinzufügen

login, disable, start, stop
CREATE INDEX login_disable_start_stop ON tl_member (login, disable, start, stop)
Feld tl_member.createdOn löschen
Feld tl_member.trustedTokenVersion hinzufügen

INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_member ADD trustedTokenVersion INT UNSIGNED DEFAULT 0 NOT NULL
Index "disable_start_stop" zu tl_member_group hinzufügen

disable, start, stop
CREATE INDEX disable_start_stop ON tl_member_group (disable, start, stop)
Feld tl_module.list_info_layout ändern

VARCHAR(64) CHARACTER SET ascii DEFAULT '' 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`
Feld tl_module.list_layout ändern

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`
Feld tl_module.list_info_where ändern

TINYTEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE list_info_where list_info_where TINYTEXT DEFAULT NULL
Feld tl_module.list_info ändern

TINYTEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE list_info list_info TINYTEXT DEFAULT NULL
Feld tl_module.list_sort ändern

TINYTEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE list_sort list_sort TINYTEXT DEFAULT NULL
Feld tl_module.list_search ändern

TINYTEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE list_search list_search TINYTEXT DEFAULT NULL
Feld tl_module.list_where ändern

TINYTEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE list_where list_where TINYTEXT DEFAULT NULL
Feld tl_module.list_fields ändern

TINYTEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE list_fields list_fields TINYTEXT DEFAULT NULL
Feld tl_module.list_table ändern

VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE list_table list_table VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.guests ändern

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`
Feld tl_module.protected ändern

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`
Feld tl_module.reg_password ändern

TEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE reg_password reg_password TEXT DEFAULT NULL
Feld tl_module.reg_text ändern

TEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE reg_text reg_text TEXT DEFAULT NULL
Feld tl_module.reg_activate ändern

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`
Feld tl_module.reg_assignDir ändern

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`
Feld tl_module.reg_close ändern

VARCHAR(32) 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`
Feld tl_module.reg_skipName ändern

CHAR(1) 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`
Feld tl_module.reg_allowLogin ändern

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`
Feld tl_module.disableCaptcha ändern

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`
Feld tl_module.numberOfItems ändern

SMALLINT UNSIGNED DEFAULT 3 NOT NULL
ALTER TABLE tl_module CHANGE numberOfItems numberOfItems SMALLINT UNSIGNED DEFAULT 3 NOT NULL
Feld tl_module.rss_template ändern

VARCHAR(64) 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`
Feld tl_module.rss_feed ändern

TEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE rss_feed rss_feed TEXT DEFAULT NULL
Feld tl_module.rss_cache ändern

INT UNSIGNED DEFAULT 3600 NOT NULL
ALTER TABLE tl_module CHANGE rss_cache rss_cache INT UNSIGNED DEFAULT 3600 NOT NULL
Feld tl_module.html ändern

TEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE html html TEXT DEFAULT NULL
Feld tl_module.fullsize ändern

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.useCaption ändern

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`
Feld tl_module.imgSize ändern

VARCHAR(128) 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`
Feld tl_module.url ändern

TEXT DEFAULT NULL
ALTER TABLE tl_module CHANGE url url TEXT DEFAULT NULL
Feld tl_module.loadFirst ändern

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE loadFirst loadFirst CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.inColumn ändern

VARCHAR(32) CHARACTER SET ascii DEFAULT 'main' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE inColumn inColumn VARCHAR(32) CHARACTER SET ascii DEFAULT 'main' NOT NULL COLLATE `ascii_bin`
Feld tl_module.searchTpl ändern

VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE searchTpl searchTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.searchType ändern

VARCHAR(16) CHARACTER SET ascii DEFAULT 'simple' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE searchType searchType VARCHAR(16) CHARACTER SET ascii DEFAULT 'simple' NOT NULL COLLATE `ascii_bin`
Feld tl_module.contextLength ändern

VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE contextLength contextLength VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.fuzzy ändern

CHAR(1) 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`
Feld tl_module.queryType ändern

VARCHAR(8) CHARACTER SET ascii DEFAULT 'and' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE queryType queryType VARCHAR(8) CHARACTER SET ascii DEFAULT 'and' NOT NULL COLLATE `ascii_bin`
Feld tl_module.memberTpl ändern

VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE memberTpl memberTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.redirectBack ändern

CHAR(1) 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`
Feld tl_module.autologin ändern

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`
Feld tl_module.showHidden ändern

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`
Feld tl_module.customTpl ändern

VARCHAR(64) 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`
Feld tl_module.navigationTpl ändern

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`
Feld tl_module.defineRoot ändern

CHAR(1) 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`
Feld tl_module.showProtected ändern

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`
Feld tl_module.hardLimit ändern

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`
Feld tl_module.type ändern

VARCHAR(64) CHARACTER SET ascii DEFAULT 'navigation' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'navigation' NOT NULL COLLATE `ascii_bin`
Feld tl_module.headline ändern

VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' 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
Feld tl_module.rsts_visibleAreaAlign löschen
Feld tl_module.rsts_thumbControls löschen
Feld tl_module.rsts_import_settings_from löschen
Feld tl_module.rsts_import_settings löschen
Feld tl_module.dma_eg_data löschen
Feld tl_module.rsmm_template löschen
Feld tl_module.rsts_cssPrefix löschen
Feld tl_module.rsts_customSkin löschen
Feld tl_module.rsts_combineNavItems löschen
Feld tl_module.rsts_rowSlideRatio löschen
Feld tl_module.rsts_rowMinSize löschen
Feld tl_module.rsts_rowMaxCount löschen
Feld tl_module.rsts_slideMaxSize löschen
Feld tl_module.rsts_slideMinSize löschen
Feld tl_module.rsts_visibleAreaMax löschen
Feld tl_module.rsts_visibleArea löschen
Feld tl_module.rsts_prevNextSteps löschen
Feld tl_module.rsts_slideMaxCount löschen
Feld tl_module.rsts_thumbs_rowSlideRatio löschen
Feld tl_module.rsts_thumbs_rowMinSize löschen
Feld tl_module.rsts_thumbs_rowMaxCount löschen
Feld tl_module.rsts_thumbs_slideMaxSize löschen
Feld tl_module.rsts_thumbs_slideMinSize löschen
Feld tl_module.rsts_thumbs_visibleAreaMax löschen
Feld tl_module.rsts_thumbs_visibleArea löschen
Feld tl_module.rsts_thumbs_prevNextSteps löschen
Feld tl_module.rsts_thumbs_slideMaxCount löschen
Feld tl_module.rsts_thumbs_imgSize löschen
Feld tl_module.rsts_thumbs_controls löschen
Feld tl_module.rsts_thumbs_imagePosition löschen
Feld tl_module.rsts_thumbs_scaleMode löschen
Feld tl_module.rsts_thumbs_duration löschen
Feld tl_module.rsts_thumbs_gapSize löschen
Feld tl_module.rsts_thumbs_height löschen
Feld tl_module.rsts_thumbs_width löschen
Feld tl_module.rsts_thumbs löschen
Feld tl_module.rsts_captions löschen
Feld tl_module.rsts_keyboard löschen
Feld tl_module.rsts_deepLinkPrefix löschen
Feld tl_module.rsts_imagePosition löschen
Feld tl_module.rsts_scaleMode löschen
Feld tl_module.rsts_invertControls löschen
Feld tl_module.rsts_controls löschen
Feld tl_module.rsts_navType löschen
Feld tl_module.rsts_pauseAutoplayOnHover löschen
Feld tl_module.rsts_autoplayProgress löschen
Feld tl_module.rsts_autoplayRestart löschen
Feld tl_module.rsts_videoAutoplay löschen
Feld tl_module.rsts_autoplay löschen
Feld tl_module.rsts_duration löschen
Feld tl_module.rsts_gapSize löschen
Feld tl_module.rsts_preloadSlides löschen
Feld tl_module.rsts_height löschen
Feld tl_module.rsts_width löschen
Feld tl_module.rsts_skin löschen
Feld tl_module.rsts_centerContent löschen
Feld tl_module.rsts_loop löschen
Feld tl_module.rsts_random löschen
Feld tl_module.rsts_direction löschen
Feld tl_module.rsts_type löschen
Feld tl_module.rsts_template löschen
Feld tl_module.rsts_id löschen
Feld tl_module.rsts_content_type löschen
Feld tl_module.rsce_data löschen
Feld tl_module.space löschen
Feld tl_module.flashJS löschen
Feld tl_module.flashID löschen
Feld tl_module.interactive löschen
Feld tl_module.source löschen
Feld tl_module.altContent löschen
Feld tl_module.flashvars löschen
Feld tl_module.transparent löschen
Feld tl_module.size löschen
Feld tl_module.tableless löschen
Feld tl_module.cols löschen
Feld tl_module.nl_template hinzufügen

VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD nl_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.nl_unsubscribe hinzufügen

TEXT DEFAULT NULL
ALTER TABLE tl_module ADD nl_unsubscribe TEXT DEFAULT NULL
Feld tl_module.nl_subscribe hinzufügen

TEXT DEFAULT NULL
ALTER TABLE tl_module ADD nl_subscribe TEXT DEFAULT NULL
Feld tl_module.nl_hideChannels hinzufügen

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD nl_hideChannels CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.nl_text hinzufügen

TEXT DEFAULT NULL
ALTER TABLE tl_module ADD nl_text TEXT DEFAULT NULL
Feld tl_module.nl_channels hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_module ADD nl_channels BLOB DEFAULT NULL
Feld tl_module.newsletters hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_module ADD newsletters BLOB DEFAULT NULL
Feld tl_module.cal_featured hinzufügen

VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_showQuantity hinzufügen

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_ctemplate hinzufügen

VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_ctemplate VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_template hinzufügen

VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_limit hinzufügen

SMALLINT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_module ADD cal_limit SMALLINT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_module.cal_readerModule hinzufügen

INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_module ADD cal_readerModule INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_module.cal_order hinzufügen

VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_ignoreDynamic hinzufügen

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_ignoreDynamic CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_format hinzufügen

VARCHAR(32) CHARACTER SET ascii DEFAULT 'cal_month' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'cal_month' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_startDay hinzufügen

SMALLINT UNSIGNED DEFAULT 1 NOT NULL
ALTER TABLE tl_module ADD cal_startDay SMALLINT UNSIGNED DEFAULT 1 NOT NULL
Feld tl_module.cal_hideRunning hinzufügen

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_hideRunning CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_noSpan hinzufügen

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD cal_noSpan CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.cal_calendar hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_module ADD cal_calendar BLOB DEFAULT NULL
Feld tl_module.news_showQuantity hinzufügen

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD news_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.news_order hinzufügen

VARCHAR(32) CHARACTER SET ascii DEFAULT 'order_date_desc' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD news_order VARCHAR(32) CHARACTER SET ascii DEFAULT 'order_date_desc' NOT NULL COLLATE `ascii_bin`
Feld tl_module.news_startDay hinzufügen

SMALLINT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_module ADD news_startDay SMALLINT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_module.news_format hinzufügen

VARCHAR(32) CHARACTER SET ascii DEFAULT 'news_month' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD news_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'news_month' NOT NULL COLLATE `ascii_bin`
Feld tl_module.news_template hinzufügen

VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD news_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.news_metaFields hinzufügen

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 ADD 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`
Feld tl_module.news_readerModule hinzufügen

INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_module ADD news_readerModule INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_module.news_jumpToCurrent hinzufügen

VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD news_jumpToCurrent VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.news_featured hinzufügen

VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD news_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
Feld tl_module.news_archives hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_module ADD news_archives BLOB DEFAULT NULL
Feld tl_module.com_template hinzufügen

VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.com_disableCaptcha hinzufügen

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.com_requireLogin hinzufügen

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.com_bbcode hinzufügen

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.com_moderate hinzufügen

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.com_order hinzufügen

VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
Feld tl_module.faq_readerModule hinzufügen

INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_module ADD faq_readerModule INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_module.faq_categories hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_module ADD faq_categories BLOB DEFAULT NULL
Feld tl_module.rootPageDependentModules hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_module ADD rootPageDependentModules BLOB DEFAULT NULL
Feld tl_module.data hinzufügen

TEXT DEFAULT NULL
ALTER TABLE tl_module ADD data TEXT DEFAULT NULL
Feld tl_module.reg_deleteDir hinzufügen

CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD reg_deleteDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
Feld tl_module.overviewPage hinzufügen

INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_module ADD overviewPage INT UNSIGNED DEFAULT 0 NOT NULL
Index "pid_type_start_stop_published" aus tl_page löschen
Feld tl_page.urlSuffix ändern

VARCHAR(16) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE urlSuffix urlSuffix VARCHAR(16) DEFAULT '' NOT NULL
Feld tl_page.urlPrefix ändern

VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_page CHANGE urlPrefix urlPrefix VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
Feld tl_page.useSSL ändern

CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_page CHANGE useSSL useSSL CHAR(1) DEFAULT '1' NOT NULL
Feld tl_page.url ändern

VARCHAR(2048) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL
Feld tl_page.redirect ändern

VARCHAR(32) DEFAULT 'permanent' NOT NULL
ALTER TABLE tl_page CHANGE redirect redirect VARCHAR(32) DEFAULT 'permanent' NOT NULL
Feld tl_page.description ändern

TEXT DEFAULT NULL
ALTER TABLE tl_page CHANGE description description TEXT DEFAULT NULL
Feld tl_page.language ändern

VARCHAR(64) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL
Feld tl_page.type ändern

VARCHAR(64) DEFAULT 'regular' NOT NULL
ALTER TABLE tl_page CHANGE type type VARCHAR(64) DEFAULT 'regular' NOT NULL
Feld tl_page.alias ändern

VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_page CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
Feld tl_page.rsmm_id löschen
Feld tl_page.rsmm_enabled löschen
Feld tl_page.rsmm_color löschen
Feld tl_page.mobileLayout löschen
Feld tl_page.sitemapName löschen
Feld tl_page.createSitemap löschen
Feld tl_page.twoFactorJumpTo hinzufügen

INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_page ADD twoFactorJumpTo INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_page.enforceTwoFactor hinzufügen

CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD enforceTwoFactor CHAR(1) DEFAULT '' NOT NULL
Feld tl_page.clientCache hinzufügen

INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_page ADD clientCache INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_page.alwaysLoadFromCache hinzufügen

CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD alwaysLoadFromCache CHAR(1) DEFAULT '' NOT NULL
Feld tl_page.subpageLayout hinzufügen

INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_page ADD subpageLayout INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_page.validAliasCharacters hinzufügen

VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD validAliasCharacters VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_page.canonicalKeepParams hinzufügen

VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD canonicalKeepParams VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_page.canonicalLink hinzufügen

VARCHAR(2048) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD canonicalLink VARCHAR(2048) DEFAULT '' NOT NULL
Feld tl_page.enableCanonical hinzufügen

CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD enableCanonical CHAR(1) DEFAULT '' NOT NULL
Feld tl_page.maintenanceMode hinzufügen

CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD maintenanceMode CHAR(1) DEFAULT '' NOT NULL
Feld tl_page.robotsTxt hinzufügen

TEXT DEFAULT NULL
ALTER TABLE tl_page ADD robotsTxt TEXT DEFAULT NULL
Feld tl_page.disableLanguageRedirect hinzufügen

CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD disableLanguageRedirect CHAR(1) DEFAULT '' NOT NULL
Feld tl_page.redirectBack hinzufügen

CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD redirectBack CHAR(1) DEFAULT '' NOT NULL
Feld tl_page.routePriority hinzufügen

INT DEFAULT 0 NOT NULL
ALTER TABLE tl_page ADD routePriority INT DEFAULT 0 NOT NULL
Feld tl_page.requireItem hinzufügen

CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD requireItem CHAR(1) DEFAULT '' NOT NULL
Index "type_dns" zu tl_page hinzufügen

type, dns
CREATE INDEX type_dns ON tl_page (type, dns)
Index "pid_published_type_start_stop" zu tl_page hinzufügen

pid, published, type, start, stop
CREATE INDEX pid_published_type_start_stop ON tl_page (pid, published, type, start, stop)
Feld tl_page.rsmm_image löschen
Feld tl_page.favicon hinzufügen

BINARY(16) DEFAULT NULL
ALTER TABLE tl_page ADD favicon BINARY(16) DEFAULT NULL
Feld tl_page.rsmm_subtitle löschen
Feld tl_page.mailerTransport hinzufügen

VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_page ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_style.own ändern

TEXT DEFAULT NULL
ALTER TABLE tl_style CHANGE own own TEXT DEFAULT NULL
Feld tl_style_sheet.vars ändern

TEXT DEFAULT NULL
ALTER TABLE tl_style_sheet CHANGE vars vars TEXT DEFAULT NULL
Feld tl_style_sheet.mediaQuery ändern

TEXT DEFAULT NULL
ALTER TABLE tl_style_sheet CHANGE mediaQuery mediaQuery TEXT DEFAULT NULL
Feld tl_style_sheet.media ändern

VARCHAR(255) DEFAULT 'a:1:{i:0;s:3:"all";}' NOT NULL
ALTER TABLE tl_style_sheet CHANGE media media VARCHAR(255) DEFAULT 'a:1:{i:0;s:3:"all";}' NOT NULL
Feld tl_style_sheet.disablePie löschen
Feld tl_theme.vars ändern

TEXT DEFAULT NULL
ALTER TABLE tl_theme CHANGE vars vars TEXT DEFAULT NULL
Feld tl_undo.query ändern

TEXT DEFAULT NULL
ALTER TABLE tl_undo CHANGE query query TEXT DEFAULT NULL
Feld tl_undo.preview hinzufügen

MEDIUMBLOB DEFAULT NULL
ALTER TABLE tl_undo ADD preview MEDIUMBLOB DEFAULT NULL
Feld tl_user.inherit ändern

VARCHAR(12) DEFAULT 'group' NOT NULL
ALTER TABLE tl_user CHANGE inherit inherit VARCHAR(12) DEFAULT 'group' NOT NULL
Feld tl_user.password ändern

VARCHAR(255) DEFAULT '' NOT NULL
ALTER TABLE tl_user CHANGE password password VARCHAR(255) DEFAULT '' NOT NULL
Feld tl_user.useCE ändern

CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_user CHANGE useCE useCE CHAR(1) DEFAULT '1' NOT NULL
Feld tl_user.useRTE ändern

CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_user CHANGE useRTE useRTE CHAR(1) DEFAULT '1' NOT NULL
Feld tl_user.thumbnails ändern

CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_user CHANGE thumbnails thumbnails CHAR(1) DEFAULT '1' NOT NULL
Feld tl_user.showHelp ändern

CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_user CHANGE showHelp showHelp CHAR(1) DEFAULT '1' NOT NULL
Feld tl_user.language ändern

VARCHAR(64) DEFAULT '' NOT NULL
ALTER TABLE tl_user CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL
Feld tl_user.username ändern

VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_user CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
Feld tl_user.loginCount löschen
Feld tl_user.newsletterp hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user ADD newsletterp BLOB DEFAULT NULL
Feld tl_user.newsletters hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user ADD newsletters BLOB DEFAULT NULL
Feld tl_user.calendarfeedp hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user ADD calendarfeedp BLOB DEFAULT NULL
Feld tl_user.calendarfeeds hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user ADD calendarfeeds BLOB DEFAULT NULL
Feld tl_user.calendarp hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user ADD calendarp BLOB DEFAULT NULL
Feld tl_user.calendars hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user ADD calendars BLOB DEFAULT NULL
Feld tl_user.newsfeedp hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user ADD newsfeedp BLOB DEFAULT NULL
Feld tl_user.newsfeeds hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user ADD newsfeeds BLOB DEFAULT NULL
Feld tl_user.newp hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user ADD newp BLOB DEFAULT NULL
Feld tl_user.news hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user ADD news BLOB DEFAULT NULL
Feld tl_user.faqp hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user ADD faqp BLOB DEFAULT NULL
Feld tl_user.faqs hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user ADD faqs BLOB DEFAULT NULL
Feld tl_user.trustedTokenVersion hinzufügen

INT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_user ADD trustedTokenVersion INT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_user.backupCodes hinzufügen

TEXT DEFAULT NULL
ALTER TABLE tl_user ADD backupCodes TEXT DEFAULT NULL
Feld tl_user.loginAttempts hinzufügen

SMALLINT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_user ADD loginAttempts SMALLINT UNSIGNED DEFAULT 0 NOT NULL
Feld tl_user.useTwoFactor hinzufügen

CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_user ADD useTwoFactor CHAR(1) DEFAULT '' NOT NULL
Feld tl_user.secret hinzufügen

BINARY(128) DEFAULT NULL
ALTER TABLE tl_user ADD secret BINARY(128) DEFAULT NULL
Feld tl_user.amg hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user ADD amg BLOB DEFAULT NULL
Feld tl_user.fields hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user ADD fields BLOB DEFAULT NULL
Feld tl_user.elements hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user ADD elements BLOB DEFAULT NULL
Feld tl_user.fullscreen hinzufügen

CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_user ADD fullscreen CHAR(1) DEFAULT '' NOT NULL
Feld tl_user_group.newsletterp hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD newsletterp BLOB DEFAULT NULL
Feld tl_user_group.newsletters hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD newsletters BLOB DEFAULT NULL
Feld tl_user_group.calendarfeedp hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD calendarfeedp BLOB DEFAULT NULL
Feld tl_user_group.calendarfeeds hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD calendarfeeds BLOB DEFAULT NULL
Feld tl_user_group.calendarp hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD calendarp BLOB DEFAULT NULL
Feld tl_user_group.calendars hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD calendars BLOB DEFAULT NULL
Feld tl_user_group.newsfeedp hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD newsfeedp BLOB DEFAULT NULL
Feld tl_user_group.newsfeeds hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD newsfeeds BLOB DEFAULT NULL
Feld tl_user_group.newp hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD newp BLOB DEFAULT NULL
Feld tl_user_group.news hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD news BLOB DEFAULT NULL
Feld tl_user_group.faqp hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD faqp BLOB DEFAULT NULL
Feld tl_user_group.faqs hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD faqs BLOB DEFAULT NULL
Feld tl_user_group.amg hinzufügen

BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD amg BLOB DEFAULT NULL
Index "pid" aus tl_version löschen
Index "fromTable" aus tl_version löschen
Feld tl_version.editUrl ändern

TEXT DEFAULT NULL
ALTER TABLE tl_version CHANGE editUrl editUrl TEXT DEFAULT NULL
CREATE UNIQUE INDEX pid_fromtable_version ON tl_version (pid, fromtable, version)
CREATE UNIQUE INDEX pid_fromtable_version ON tl_version (pid, fromtable, version)
Index "userid" zu tl_version hinzufügen

userid
CREATE INDEX userid ON tl_version (userid)

Also jeder Eintrag ist halt mit einem roten x versehen.
Die Löschungen sind deaktiviert/übersprungen.

Der Contao Manager gibt leider keine schlüssige Fehlermeldung oder einen Hinweis, was das Problem ist.
Eine entsprechende Google/Foren-Suche liefert leider keine Ergebnisse, die mich weiterbringen.
Ich hatte die Kollation der neuen DB von utf8mb3_unicode_ci auf utf8mb4_unicode_ci geändert, weil das wohl bei einem User geholfen hat - bei mir leider nicht.

Was muss ich jetzt tun?

Danke!
Frank

**Spooky** · 22.03.2024, 17:55

Führe auf der Konsole contao:migrate --no-interaction -v aus und poste die Konsolenausgabe.

**Traumkunst** · 22.03.2024, 18:21

Sorry, der Konsolenzugriff scheint nicht richtig zu funktionieren (IONOS; bei Versuch das Verzeichnis zu wechseln ("cd contao") erhalte ich nur die Meldung, dass das Verzeichnis nicht existiert (obwohl es bei "ls" aufgelistet wird); hab es mit putty und mit der Konsole von winscp versucht).

Ich hab also offenbar leider keine Konsole zur Verfügung.
Was muss ich nun tun? Danke!

**mlweb** · 22.03.2024, 18:30

Migration der DB lokal würde ich versuchen.

**Traumkunst** · 22.03.2024, 18:51

Danke - das scheitert leider schon beim Versuch, die DB zu importieren (also quasi dem ersten Schritt, noch bevor der Contao Manager zum Zuge kommen würde)

Die mysql-Fehlermeldung beim Import lautet:

HTML-Code:

CREATE TABLE `tl_module` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `headline` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(64) NOT NULL DEFAULT '',
  `levelOffset` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `showLevel` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `hardLimit` char(1) NOT NULL DEFAULT '',
  `showProtected` char(1) NOT NULL DEFAULT '',
  `defineRoot` char(1) NOT NULL DEFAULT '',
  `rootPage` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `navigationTpl` varchar(64) NOT NULL DEFAULT '',
  `customTpl` varchar(64) NOT NULL DEFAULT '',
  `pages` blob,
  `orderPages` blob,
  `showHidden` char(1) NOT NULL DEFAULT '',
  `customLabel` varchar(64) NOT NULL DEFAULT '',
  `autologin` char(1) NOT NULL DEFAULT '',
  `jumpTo` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `redirectBack` char(1) NOT NULL DEFAULT '',
  `cols` varchar(32) NOT NULL DEFAULT '',[...]

MySQL meldet: Dokumentation
#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.

Es handelt sich auch hier um eine MariaDB in der Version 10 und PHP 8.2 (identisch wie auf dem Live-Server)

**Spooky** · 22.03.2024, 19:48

Zitat von Traumkunst

Ich hab also offenbar leider keine Konsole zur Verfügung.

Bei IONOS hast du auf jeden Fall einen funktionierenden SSH Zugriff.

Zitat von Traumkunst

(IONOS; bei Versuch das Verzeichnis zu wechseln ("cd contao") erhalte ich nur die Meldung, dass das Verzeichnis nicht existiert (obwohl es bei "ls" aufgelistet wird); hab es mit putty und mit der Konsole von winscp versucht).

Aus der Ferne ist schwer zu sagen, was du hier falsch machst. Poste mal die Ausgabe von pwd und ls -la

**Traumkunst** · 22.03.2024, 20:05

Ok, ich habe keine Ahnung warum, aber plötzlich funktionieren die Konsolen-Befehle in putty und ich kann Verzeichnisse wechseln. :/

Gut. Ich tue jetzt also folgendes: Ich gebe direkt im Contao-Installationsverzeichnis folgenden Befehl ein:

HTML-Code:

php vendor/bin/contao-console contao:migrate --nointeraction -v

Die Ausgabe lautet:

HTML-Code:

Content-type: text/html

Allerdings erzeugt der Befehl

HTML-Code:

php vendor/bin/contao-console list

die selbe Ausgabe.

**Spooky** · 22.03.2024, 20:09

php ist das falsche Kommando in deinem Fall. Du musst php mit dem Pfad zum richtigen PHP CLI ersetzen (also das PHP CLI der PHP Version, die du für die Seite verwendest oder verwenden willst). Siehe https://github.com/contao/contao-man...ki/1und1-IONOS für Hinweise diesbezüglich.

Darüberhinaus hast du bei --no-interaction einen Bindestrich vergessen.

**Traumkunst** · 22.03.2024, 20:21

Ok, vielen Dank!

Der Befehl lautet in meinem Fall so

HTML-Code:

/usr/bin/php8.2-cli contao/vendor/bin/contao-console contao:migrate --no-interaction -v

und er liefert am Ende diese Ausgabe:

HTML-Code:

[OK] Executed 319 SQL queries.
 [OK] All migrations completed.

-- oder macht es Sinn, die gesamte Ausgabe (840 Zeilen) hier zu posten?

**Traumkunst** · 22.03.2024, 20:25

Ok, das scheint irgendwie was gebracht zu haben: Der Contao-Manager will nun nur noch die Löschungen (noch) nicht vorhandener Tabellen durchführen, alles andere scheint soweit drin zu sein.

Ich mache nun weiter mit der Installation der benötigten Module.

Danke!!!

edit: ab hier hat dann alles weitere funktioniert, die Website läuft unter 4.13 inkl. aller Module - sogar der olle dma_elementgenerator läuft einwandfrei