4.13.x Datenbank-Migrationen - Datenbank-Problem gefunden

Datenbank-Migrationen - Datenbank-Problem gefunden

Hallo zusammen,

ich betreibe eine Contaowebseite in der Version 4.13.16 und habe ein Datenbank-Migrationsproblem. Wenn ich das Installtool öffne, werden mir auch schön die Zeilen aufgezeigt, die aktualisiert werden müssen, aber die Datenbamnk lässt sich nicht aktualisieren. Selbst mehrfache Versuche durch Klick auf den Button "Datenbank aktualisieren" wird diese nicht aktualisiert. Hat einer eine Idee, wie ich das Problem beheben kann?

Aktualisiere auf die neueste Contao 4.13 Version und poste danach die angezeigten Queries, die immer wieder kommen, falls das Problem weiterhin besteht.

Zitat:

Zitat von Spooky

Aktualisiere auf die neueste Contao 4.13 Version und poste danach die angezeigten Queries, die immer wieder kommen, falls das Problem weiterhin besteht.

Contao ist nun auf der aktuellen Version, aber das Migrationsproblem besteht weiterhin. Die Datenbank lässt sich im Installtool einfach nicht aktualsieren. Wenn ich auf "Datenbank aktualisieren" drücke, arbeitet der Browser, aber nach kurzer Zeit erscheint erscheint das Gleiche mit den gleichen Feldern, die aktualisiert werden müssen. Fakt: Es hat sich an dem Problem leider nicht geändert. Was meinst du mit Queries und wie kann ich mir diese anzeigen lassen?

Einfach das was du im Install Tool siehst.

Liste der Anhänge anzeigen (Anzahl: 1)

Zitat:

Zitat von Spooky

Einfach das was du im Install Tool siehst.

Anbei der Screenshot aus dem Installtool.

Code:

ALTER TABLE tl_remember_me CHANGE expires expires DATETIME DEFAULT NULL ALTER TABLE tl_trusted_device CHANGE device_family device_family VARCHAR(255) DEFAULT NULL ALTER TABLE tl_trusted_device CHANGE os_family os_family VARCHAR(255) DEFAULT NULL ALTER TABLE tl_trusted_device CHANGE ua_family ua_family VARCHAR(255) DEFAULT NULL ALTER TABLE tl_trusted_device CHANGE userClass userClass VARCHAR(255) DEFAULT NULL ALTER TABLE tl_article CHANGE sharebuttons_theme sharebuttons_theme VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE sharebuttons_template sharebuttons_template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE background background CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE bgcolor bgcolor VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE bgimage bgimage VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE bgposition bgposition VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE bgrepeat bgrepeat VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE bgsize bgsize VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE size size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE bgcolor_css bgcolor_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE overlay overlay CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE ol_position ol_position VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE ol_width ol_width VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE ol_height ol_height VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE ol_bgcolor_css ol_bgcolor_css VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE ol_opacity ol_opacity VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE fullscreen fullscreen CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE offsetCssID offsetCssID VARCHAR(196) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE layout_css layout_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE color_css color_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE padding_t padding_t VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE padding_b padding_b VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE visibility_css visibility_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE guests guests CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE customTpl customTpl VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE printable printable VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE teaserCssID teaserCssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_article CHANGE showTeaser showTeaser CHAR(1) DEFAULT '' NOT NULL 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_article CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE sharebuttons_theme sharebuttons_theme VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE sharebuttons_template sharebuttons_template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE disableCaptcha disableCaptcha CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE requireLogin requireLogin CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE bbcode bbcode CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE moderate moderate CHAR(1) DEFAULT '' NOT NULL 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 CHANGE allowComments allowComments CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE noComments noComments CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE cssClass cssClass VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE target target CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE source source VARCHAR(32) DEFAULT 'default' NOT NULL ALTER TABLE tl_calendar_events CHANGE addEnclosure addEnclosure CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE repeatEach repeatEach VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE recurring recurring CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE floating floating VARCHAR(32) DEFAULT 'above' NOT NULL ALTER TABLE tl_calendar_events CHANGE caption caption VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE fullsize fullsize CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE imageUrl imageUrl VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE imagemargin imagemargin VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE size size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE imageTitle imageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE alt alt VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_calendar_events CHANGE overwriteMeta overwriteMeta CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE addImage addImage CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE address address VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE location location VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE robots robots VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE pageTitle pageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE addTime addTime CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_calendar_events CHANGE featured featured CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_events CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_feed CHANGE imgSize imgSize VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_feed CHANGE feedBase feedBase VARCHAR(255) DEFAULT '' 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 language language VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_calendar_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_calendar_feed CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE notifiedReply notifiedReply CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE notified notified CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE ip ip VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE addReply addReply CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE website website VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE email email VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE name name VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE date date VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_comments CHANGE source source VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_comments_notify CHANGE tokenRemove tokenRemove VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_comments_notify CHANGE active active CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_comments_notify CHANGE addedOn addedOn VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_comments_notify CHANGE url url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_comments_notify CHANGE email email VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_comments_notify CHANGE name name VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_comments_notify CHANGE source source VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE sharebuttons_theme sharebuttons_theme VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE sharebuttons_template sharebuttons_template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE align_css align_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE color_css color_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE bgcolor_css bgcolor_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE border_css border_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE style_css style_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE format_css format_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE width_css width_css VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE seo seo CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE visibility_css visibility_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_grid autogrid_grid VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_bgcolor autogrid_bgcolor VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_bgimage autogrid_bgimage VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_bgposition autogrid_bgposition VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_bgrepeat autogrid_bgrepeat VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_bgsize autogrid_bgsize VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_padding autogrid_padding VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_padding_css autogrid_padding_css VARCHAR(8) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_styles autogrid_styles VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_addStyling autogrid_addStyling CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid autogrid CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_css autogrid_css VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_mobile autogrid_mobile VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_tablet autogrid_tablet VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_offset autogrid_offset VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_align autogrid_align VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_align_mobile autogrid_align_mobile VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_gutter autogrid_gutter VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_sameheight autogrid_sameheight CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE autogrid_class autogrid_class VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE margin_t margin_t VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE margin_b margin_b VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE margin_t_m margin_t_m VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE margin_b_m margin_b_m VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_easing revolutionslider_data_easing VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_speed revolutionslider_data_speed VARCHAR(8) DEFAULT '0.5' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_start revolutionslider_data_start VARCHAR(4) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_animation_start revolutionslider_data_animation_start VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_animation_end revolutionslider_data_animation_end VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_position revolutionslider_data_position VARCHAR(96) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_position_m revolutionslider_data_position_m VARCHAR(96) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_pos9grid revolutionslider_data_pos9grid VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_linktoslide revolutionslider_data_linktoslide VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_autoplay revolutionslider_data_autoplay CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_nextslideatend revolutionslider_data_nextslideatend CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_OUT revolutionslider_OUT CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_videoType revolutionslider_videoType VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_video_controls revolutionslider_video_controls CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_video_loop revolutionslider_video_loop CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_video_size revolutionslider_video_size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_video_aspect revolutionslider_video_aspect VARCHAR(8) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_text_bold revolutionslider_text_bold CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_text_italic revolutionslider_text_italic CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_text_fontsize revolutionslider_text_fontsize VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_easing_OUT revolutionslider_data_easing_OUT VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_speed_OUT revolutionslider_data_speed_OUT VARCHAR(8) DEFAULT '0.5' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_data_start_OUT revolutionslider_data_start_OUT VARCHAR(4) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_frames revolutionslider_frames CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE useSVG useSVG CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_visibility revolutionslider_visibility CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE revolutionslider_parallax revolutionslider_parallax CHAR(2) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE privacy_size privacy_size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE addFontIcon addFontIcon CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE fontIcon fontIcon VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE com_template com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE com_requireLogin com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE com_bbcode com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE com_moderate com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE com_order com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE stop stop VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE start start VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE invisible invisible CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE guests guests CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE protected protected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE sliderContinuous sliderContinuous CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE playerColor playerColor VARCHAR(6) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE playerPreload playerPreload VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE splashImage splashImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE playerAspect playerAspect VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE playerCaption playerCaption VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE playerSize playerSize VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE posterSRC posterSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_content CHANGE vimeo vimeo VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE youtube youtube VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE galleryTpl galleryTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE metaIgnore metaIgnore CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE sortBy sortBy VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE useHomeDir useHomeDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE useImage useImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE rel rel VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE embed embed VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE linkTitle linkTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE titleText titleText VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE overwriteLink overwriteLink CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE target target CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE markdownSource markdownSource VARCHAR(12) CHARACTER SET ascii DEFAULT 'sourceText' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE highlight highlight VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE mooClasses mooClasses VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE mooStyle mooStyle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE mooHeadline mooHeadline VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE sortOrder sortOrder VARCHAR(32) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE sortable sortable CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE tleft tleft CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE tfoot tfoot CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE thead thead CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE summary summary VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE listtype listtype VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE floating floating VARCHAR(32) CHARACTER SET ascii DEFAULT 'above' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE caption caption VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE fullsize fullsize CHAR(1) 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` ALTER TABLE tl_content CHANGE size size VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE imageTitle imageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE alt alt VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_content CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_content CHANGE overwriteMeta overwriteMeta CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE inline inline CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE showPreview showPreview CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE addImage addImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE headline headline VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL ALTER TABLE tl_content CHANGE ptable ptable VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_content CHANGE type type VARCHAR(128) CHARACTER SET ascii DEFAULT 'text' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_faq CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE noComments noComments CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE addEnclosure addEnclosure CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE floating floating VARCHAR(12) DEFAULT 'above' NOT NULL ALTER TABLE tl_faq CHANGE caption caption VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE fullsize fullsize CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE imageUrl imageUrl VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE imagemargin imagemargin VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE size size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE imageTitle imageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE alt alt VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_faq CHANGE overwriteMeta overwriteMeta CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE addImage addImage CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE robots robots VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE pageTitle pageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_faq CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_faq CHANGE question question VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_faq_category CHANGE disableCaptcha disableCaptcha CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq_category CHANGE requireLogin requireLogin CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq_category CHANGE bbcode bbcode CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq_category CHANGE moderate moderate CHAR(1) DEFAULT '' NOT NULL 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_faq_category CHANGE allowComments allowComments CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_faq_category CHANGE headline headline VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_faq_category CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_files CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_files CHANGE found found CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_files CHANGE hash hash VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_files CHANGE extension extension VARCHAR(16) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_files CHANGE path path VARCHAR(1022) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_files CHANGE type type VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_files CHANGE uuid uuid BINARY(16) DEFAULT NULL ALTER TABLE tl_files CHANGE pid pid BINARY(16) DEFAULT NULL ALTER TABLE tl_form CHANGE allowTags allowTags CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE formID formID VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE attributes attributes VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE novalidate novalidate CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE method method VARCHAR(12) DEFAULT 'POST' NOT NULL ALTER TABLE tl_form CHANGE customTpl customTpl VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE targetTable targetTable VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE storeValues storeValues CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE skipEmpty skipEmpty CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE format format VARCHAR(12) DEFAULT 'raw' NOT NULL ALTER TABLE tl_form CHANGE subject subject VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE recipient recipient VARCHAR(1022) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE mailerTransport mailerTransport VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE sendViaEmail sendViaEmail CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_form CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE margin_t margin_t VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE margin_b margin_b VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE margin_t_m margin_t_m VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE margin_b_m margin_b_m VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid autogrid CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_css autogrid_css VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_mobile autogrid_mobile VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_tablet autogrid_tablet VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_offset autogrid_offset VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_align autogrid_align VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_align_mobile autogrid_align_mobile VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_gutter autogrid_gutter VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_sameheight autogrid_sameheight CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE autogrid_class autogrid_class VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE visibility_css visibility_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE addFontIcon addFontIcon CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE fontIcon fontIcon VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE invisible invisible CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_form_field CHANGE imageSubmit imageSubmit CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE slabel slabel VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE customTpl customTpl VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE accesskey accesskey CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE value value VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE class class VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE doNotOverwrite doNotOverwrite CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE useHomeDir useHomeDir CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE uploadFolder uploadFolder BINARY(16) DEFAULT NULL ALTER TABLE tl_form_field CHANGE storeFile storeFile CHAR(1) DEFAULT '' 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 ALTER TABLE tl_form_field CHANGE multiple multiple CHAR(1) DEFAULT '' 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 step step VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE maxval maxval VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE minval minval VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE errorMsg errorMsg VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE customRgxp customRgxp VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE placeholder placeholder VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE rgxp rgxp VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE mandatory mandatory CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE name name VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE `label` `label` VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_form_field CHANGE type type VARCHAR(64) DEFAULT 'text' NOT NULL ALTER TABLE tl_image_size CHANGE lazyLoading lazyLoading CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_image_size CHANGE skipIfDimensionsMatch skipIfDimensionsMatch CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_image_size CHANGE formats formats VARCHAR(1024) DEFAULT '' NOT NULL ALTER TABLE tl_image_size CHANGE resizeMode resizeMode VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_image_size CHANGE sizes sizes VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_image_size CHANGE densities densities VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_image_size CHANGE cssClass cssClass VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_image_size CHANGE name name VARCHAR(64) DEFAULT NULL ALTER TABLE tl_image_size_item CHANGE invisible invisible CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_image_size_item CHANGE resizeMode resizeMode VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_image_size_item CHANGE sizes sizes VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_image_size_item CHANGE densities densities VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_image_size_item CHANGE media media VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE webfonts_optin webfonts_optin CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE align align VARCHAR(32) DEFAULT 'center' NOT NULL ALTER TABLE tl_layout CHANGE width width VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE static static CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE addMooTools addMooTools CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE addJQuery addJQuery CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE onload onload VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE cssClass cssClass VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE titleTag titleTag VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE viewport viewport VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE defaultImageDensities defaultImageDensities VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE lightboxSize lightboxSize VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE minifyMarkup minifyMarkup CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_layout CHANGE template template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE combineScripts combineScripts CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_layout CHANGE loadingOrder loadingOrder VARCHAR(16) DEFAULT 'external_first' NOT NULL ALTER TABLE tl_layout CHANGE framework framework VARCHAR(255) DEFAULT 'a:2:{i:0;s:10:"layout.css";i:1;s:14:"responsive.css";}' NOT NULL ALTER TABLE tl_layout CHANGE widthRight widthRight VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE widthLeft widthLeft VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE cols cols VARCHAR(8) DEFAULT '2cll' NOT NULL ALTER TABLE tl_layout CHANGE footerHeight footerHeight VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE headerHeight headerHeight VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_layout CHANGE `rows` `rows` VARCHAR(8) DEFAULT '2rwh' NOT NULL ALTER TABLE tl_layout CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_log CHANGE browser browser VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_log CHANGE func func VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_log CHANGE username username VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_log CHANGE action action VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_log CHANGE source source VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE useTwoFactor useTwoFactor CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE secret secret BINARY(128) DEFAULT NULL ALTER TABLE tl_member CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE disable disable CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE homeDir homeDir BINARY(16) DEFAULT NULL ALTER TABLE tl_member CHANGE assignDir assignDir CHAR(1) DEFAULT '' 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_member CHANGE login login CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE website website VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE email email VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE fax fax VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE mobile mobile VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE phone phone VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE country country VARCHAR(2) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE state state VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE city city VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE postal postal VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE street street VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE company company VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE gender gender VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE dateOfBirth dateOfBirth VARCHAR(11) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE lastname lastname VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_member CHANGE firstname firstname VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_member_group CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_member_group CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_member_group CHANGE disable disable CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_member_group CHANGE redirect redirect CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_member_group CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE sharebuttons_theme sharebuttons_theme VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE sharebuttons_template sharebuttons_template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE align_css align_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE color_css color_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE style_css style_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE layout_css layout_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE news_sysfilter news_sysfilter CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE news_filter_multiple news_filter_multiple CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE bgposition bgposition VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE visibility_css visibility_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE privacy_lbl_1 privacy_lbl_1 VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE privacy_lbl_2 privacy_lbl_2 VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE privacy_lbl_3 privacy_lbl_3 VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE privacy_lbl_4 privacy_lbl_4 VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE privacy_url_1 privacy_url_1 VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE privacy_url_2 privacy_url_2 VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE privacy_preselect privacy_preselect VARCHAR(96) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE margin_t margin_t VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE margin_b margin_b VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE margin_t_m margin_t_m VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE margin_b_m margin_b_m VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE nl_template nl_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE nl_hideChannels nl_hideChannels CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_featured cal_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_showQuantity cal_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_ctemplate cal_ctemplate VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_template cal_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_order cal_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_ignoreDynamic cal_ignoreDynamic CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_format cal_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'cal_month' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_hideRunning cal_hideRunning CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cal_noSpan cal_noSpan CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE list_info_layout list_info_layout VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE list_layout list_layout VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE list_table list_table VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE news_showQuantity news_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE news_order news_order VARCHAR(32) CHARACTER SET ascii DEFAULT 'order_date_desc' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE news_format news_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'news_month' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE news_template news_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE news_metaFields news_metaFields VARCHAR(255) CHARACTER SET ascii DEFAULT 'a:2:{i:0;s:4:"date";i:1;s:6:"author";}' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE news_jumpToCurrent news_jumpToCurrent VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE news_featured news_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE com_template com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE com_requireLogin com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE com_bbcode com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE com_moderate com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE com_order com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE guests guests CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE protected protected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE reg_activate reg_activate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE reg_homeDir reg_homeDir BINARY(16) DEFAULT NULL ALTER TABLE tl_module CHANGE reg_assignDir reg_assignDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE reg_deleteDir reg_deleteDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE reg_close reg_close VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE reg_skipName reg_skipName CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE reg_allowLogin reg_allowLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE disableCaptcha disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE rss_template rss_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE useCaption useCaption CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE imgSize imgSize VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_module CHANGE loadFirst loadFirst CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE inColumn inColumn VARCHAR(32) CHARACTER SET ascii DEFAULT 'main' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE searchTpl searchTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE searchType searchType VARCHAR(16) CHARACTER SET ascii DEFAULT 'simple' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE contextLength contextLength VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE fuzzy fuzzy CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE queryType queryType VARCHAR(8) CHARACTER SET ascii DEFAULT 'and' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE memberTpl memberTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE redirectBack redirectBack CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE autologin autologin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE customLabel customLabel VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_module CHANGE showHidden showHidden CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE navigationTpl navigationTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE defineRoot defineRoot CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE showProtected showProtected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE hardLimit hardLimit CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_module CHANGE type type VARCHAR(128) DEFAULT '' 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_module CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE addFilter addFilter CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE noComments noComments CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE cssClass cssClass VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE target target CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE source source VARCHAR(12) DEFAULT 'default' NOT NULL ALTER TABLE tl_news CHANGE addEnclosure addEnclosure CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE floating floating VARCHAR(12) DEFAULT 'above' NOT NULL ALTER TABLE tl_news CHANGE caption caption VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE fullsize fullsize CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE imageUrl imageUrl VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE imagemargin imagemargin VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE size size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE imageTitle imageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE alt alt VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_news CHANGE overwriteMeta overwriteMeta CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE addImage addImage CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE subheadline subheadline VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE robots robots VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE pageTitle pageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_news CHANGE featured featured CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news CHANGE headline headline VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news_archive CHANGE sharebuttons_theme sharebuttons_theme VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_news_archive CHANGE sharebuttons_template sharebuttons_template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_news_archive CHANGE manualSorting manualSorting CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news_archive CHANGE disableCaptcha disableCaptcha CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news_archive CHANGE requireLogin requireLogin CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news_archive CHANGE bbcode bbcode CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news_archive CHANGE moderate moderate CHAR(1) DEFAULT '' NOT NULL 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_archive CHANGE allowComments allowComments CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news_archive CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_news_archive CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news_feed CHANGE imgSize imgSize VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_news_feed CHANGE feedBase feedBase VARCHAR(255) DEFAULT '' 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 language language VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_news_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_news_feed CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE date date VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE sent sent CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE senderName senderName VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE sender sender VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE mailerTransport mailerTransport VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE externalImages externalImages CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE sendText sendText CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE template template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE addFile addFile CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_newsletter CHANGE subject subject VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_channel CHANGE senderName senderName VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_channel CHANGE sender sender VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_channel CHANGE mailerTransport mailerTransport VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_channel CHANGE template template VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_channel CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_deny_list CHANGE hash hash VARCHAR(32) DEFAULT NULL ALTER TABLE tl_newsletter_recipients CHANGE addedOn addedOn VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_recipients CHANGE active active CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_newsletter_recipients CHANGE email email VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_opt_in CHANGE emailSubject emailSubject VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_opt_in CHANGE email email VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_opt_in CHANGE invalidatedThrough invalidatedThrough VARCHAR(24) DEFAULT '' NOT NULL ALTER TABLE tl_opt_in CHANGE token token VARCHAR(24) DEFAULT '' NOT NULL ALTER TABLE tl_opt_in_related CHANGE relTable relTable VARCHAR(64) DEFAULT NULL ALTER TABLE tl_page CHANGE addFavicon addFavicon CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE faviconSRC faviconSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_page CHANGE addAppleTouchIcon addAppleTouchIcon CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE appleTouchIconSRC appleTouchIconSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_page CHANGE ribbon ribbon VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE addImage addImage CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_page CHANGE style_css style_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE height_css height_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE imgHeadline imgHeadline VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE imgSubheadline imgSubheadline VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE addArticle addArticle CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE visibility_css visibility_css VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE analytics_google analytics_google VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE analytics_matomo analytics_matomo VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE google_maps google_maps VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE pct_theme pct_theme VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE pct_theme_import pct_theme_import CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE addFontIcon addFontIcon CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE fontIcon fontIcon VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE enforceTwoFactor enforceTwoFactor CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE accesskey accesskey CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE guests guests CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE hide hide CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE sitemap sitemap VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE cssClass cssClass VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE noSearch noSearch CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE chmod chmod VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE includeChmod includeChmod CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE alwaysLoadFromCache alwaysLoadFromCache CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE includeCache includeCache CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE includeLayout includeLayout CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE autoforward autoforward CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE useSSL useSSL CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_page CHANGE urlSuffix urlSuffix VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE urlPrefix urlPrefix VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_page CHANGE useFolderUrl useFolderUrl CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE validAliasCharacters validAliasCharacters VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE datimFormat datimFormat VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE timeFormat timeFormat VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE dateFormat dateFormat VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE adminEmail adminEmail VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE canonicalKeepParams canonicalKeepParams VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE canonicalLink canonicalLink VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE enableCanonical enableCanonical CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE mailerTransport mailerTransport VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE maintenanceMode maintenanceMode CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE favicon favicon BINARY(16) DEFAULT NULL ALTER TABLE tl_page CHANGE disableLanguageRedirect disableLanguageRedirect CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE fallback fallback CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE staticPlugins staticPlugins VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE staticFiles staticFiles VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE dns dns VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE target target CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE redirectBack redirectBack CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE redirect redirect VARCHAR(32) DEFAULT 'permanent' NOT NULL ALTER TABLE tl_page CHANGE robots robots VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE pageTitle pageTitle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE requireItem requireItem CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_page CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_page CHANGE type type VARCHAR(64) DEFAULT 'regular' NOT NULL ALTER TABLE tl_page CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement CHANGE template template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement CHANGE isWrapper isWrapper VARCHAR(8) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement CHANGE isFMD isFMD CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement CHANGE isCTE isCTE CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_pct_customelement_attribute CHANGE fontIcon fontIcon VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE addFontIcon addFontIcon CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE galleryTpl galleryTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_pct_customelement_attribute CHANGE number_format number_format VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE max_value max_value CHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE min_value min_value CHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE date_rgxp date_rgxp VARCHAR(8) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE date_format date_format VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE include_type include_type VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE size size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE isRadio isRadio CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE tinyTpl tinyTpl VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE sortBy sortBy VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE inline inline CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE isDownload isDownload CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE be_visible be_visible CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_tl_class_long eval_tl_class_long CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_tl_class_m12 eval_tl_class_m12 CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_tl_class_clr eval_tl_class_clr CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_tl_class_w50 eval_tl_class_w50 CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_tl_style eval_tl_style VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_pagepicker eval_pagepicker CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_datepicker eval_datepicker CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_includeBlankOption eval_includeBlankOption CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_attributeType eval_attributeType VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_path eval_path BINARY(16) DEFAULT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_extensions eval_extensions VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_filesOnly eval_filesOnly CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_files eval_files CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_allowHtml eval_allowHtml CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_submitOnChange eval_submitOnChange CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_rte eval_rte CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_size eval_size CHAR(3) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_multiple eval_multiple CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_rowscols eval_rowscols VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_rgxp eval_rgxp VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE eval_mandatory eval_mandatory CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE hidden hidden CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE template template VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE description description VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE type type VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_attribute CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_pct_customelement_attribute CHANGE uuid uuid VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE legend_hide legend_hide CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE hidden hidden CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE allowCut allowCut CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE allowCopy allowCopy CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_group CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_pct_customelement_plugin CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_plugin CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_plugin CHANGE exclude exclude CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_customelement_plugin CHANGE plugin plugin VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_themedesigner CHANGE active active CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_pct_themedesigner CHANGE description description VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_pct_themedesigner CHANGE theme theme VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_preview_link CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_preview_link CHANGE restrictToUrl restrictToUrl CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_preview_link CHANGE showUnpublished showUnpublished CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_preview_link CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE jsTemplate jsTemplate VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE sliderTemplate sliderTemplate VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE stopAfterLoops stopAfterLoops CHAR(3) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE stopAtSlide stopAtSlide CHAR(3) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE startWithSlide startWithSlide CHAR(3) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE overlay overlay VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE stopOnHover stopOnHover CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_revolutionslider CHANGE arrowStyle arrowStyle VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE navigationSize navigationSize VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE navigationType navigationType VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE shuffle shuffle CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE transition transition VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE fullScreenOffsetContainer fullScreenOffsetContainer VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE sliderType sliderType VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE sliderBreakPoint sliderBreakPoint VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE sliderSize sliderSize VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE sliderStyle sliderStyle VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE nextslideatend nextslideatend CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE `loop` `loop` CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE videoURL videoURL VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE videoSRC videoSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_revolutionslider_slides CHANGE published published CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE data_ease data_ease VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE data_bgscale data_bgscale VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE data_bgposition_OUT data_bgposition_OUT VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE kenburns kenburns CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE data_bgcolor data_bgcolor VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE data_bgrepeat data_bgrepeat CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE data_bgposition data_bgposition VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE data_bgfit data_bgfit VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE background background VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE size size VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL ALTER TABLE tl_revolutionslider_slides CHANGE singleSRC_thumb singleSRC_thumb BINARY(16) DEFAULT NULL ALTER TABLE tl_revolutionslider_slides CHANGE lazyload lazyload CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE delay delay VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE masterspeed masterspeed VARCHAR(16) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE newWindow newWindow CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE slideUrl slideUrl VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE transition transition VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_revolutionslider_slides CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_search CHANGE language language VARCHAR(5) DEFAULT '' NOT NULL ALTER TABLE tl_search CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_search CHANGE checksum checksum VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_search CHANGE url url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` ALTER TABLE tl_style CHANGE invisible invisible CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE liststyleimage liststyleimage VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE liststyletype liststyletype VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE list list CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE wordspacing wordspacing VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE letterspacing letterspacing VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE textindent textindent VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE texttransform texttransform VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE fontstyle fontstyle VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE lineheight lineheight VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE fontcolor fontcolor VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE fontsize fontsize VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE fontfamily fontfamily VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE font font CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE borderspacing borderspacing VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE bordercollapse bordercollapse VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE borderradius borderradius VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE bordercolor bordercolor VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE borderstyle borderstyle VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE borderwidth borderwidth VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE border border CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE gradientColors gradientColors VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE gradientAngle gradientAngle VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE shadowcolor shadowcolor VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE shadowsize shadowsize VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE bgrepeat bgrepeat VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE bgposition bgposition VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE bgimage bgimage VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE bgcolor bgcolor VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE background background CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE whitespace whitespace VARCHAR(8) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE textalign textalign VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE verticalalign verticalalign VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE align align VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE padding padding VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE margin margin VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE alignment alignment CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE display display VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE overflow overflow VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE clear clear VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE floating floating VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE position position VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE trbl trbl VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE positioning positioning CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE maxheight maxheight VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE maxwidth maxwidth VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE minheight minheight VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE minwidth minwidth VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE height height VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE width width VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE size size CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE comment comment VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE category category VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style CHANGE selector selector VARCHAR(1022) DEFAULT '' NOT NULL ALTER TABLE tl_style_sheet CHANGE media media VARCHAR(255) DEFAULT 'a:1:{i:0;s:3:"all";}' NOT NULL ALTER TABLE tl_style_sheet CHANGE cc cc VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_style_sheet CHANGE name name VARCHAR(64) DEFAULT NULL ALTER TABLE tl_theme CHANGE easy_themes_internalTitle easy_themes_internalTitle VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_theme CHANGE templates templates VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_theme CHANGE screenshot screenshot BINARY(16) DEFAULT NULL ALTER TABLE tl_theme CHANGE author author VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_theme CHANGE name name VARCHAR(128) DEFAULT '' NOT NULL ALTER TABLE tl_undo CHANGE fromTable fromTable VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE et_enable et_enable CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE et_mode et_mode VARCHAR(32) DEFAULT 'contextmenu' NOT NULL ALTER TABLE tl_user CHANGE et_bemodRef et_bemodRef VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE rocksolidFrontendHelper rocksolidFrontendHelper CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_user CHANGE rocksolidFrontendHelperLightbox rocksolidFrontendHelperLightbox CHAR(1) DEFAULT '1' NOT NULL ALTER TABLE tl_user CHANGE pct_frontend_quickedit pct_frontend_quickedit CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE useTwoFactor useTwoFactor CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE secret secret BINARY(128) DEFAULT NULL ALTER TABLE tl_user CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE disable disable CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE inherit inherit VARCHAR(12) DEFAULT 'group' NOT NULL ALTER TABLE tl_user CHANGE admin admin CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE pwChange pwChange CHAR(1) DEFAULT '' 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 uploader uploader VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE fullscreen fullscreen CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE backendTheme backendTheme VARCHAR(32) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE email email VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_user CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin` ALTER TABLE tl_user_group CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_user_group CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL ALTER TABLE tl_user_group CHANGE disable disable CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_user_group CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_version CHANGE active active CHAR(1) DEFAULT '' NOT NULL ALTER TABLE tl_version CHANGE description description VARCHAR(255) DEFAULT '' NOT NULL ALTER TABLE tl_version CHANGE username username VARCHAR(64) DEFAULT NULL ALTER TABLE tl_version CHANGE fromTable fromTable VARCHAR(255) DEFAULT '' NOT NULL

Das ist die vollständige Liste der notwendigen Aktualisierungen, die sich leider nicht aktualisieren lassen.

Welche MySQL/MariaDB Version nutzt du? Welche Version ist in deiner parameters.yml eingetragen (falls eingetragen)?

Zitat:

Zitat von Spooky

Welche MySQL/MariaDB Version nutzt du? Welche Version ist in deiner parameters.yml eingetragen (falls eingetragen)?

database_version: 10.1.37-MariaDB

Das beantwortet nur die Zweite meiner Fragen ;)

Liste der Anhänge anzeigen (Anzahl: 1)

Zitat:

Zitat von Spooky

Das beantwortet nur die Zweite meiner Fragen ;)

Hier die Info aus phpmyadmin. Ich hoffe, daraus geht alles hervor an Infos, was du benötigst, da ich keinen Zugriff auf alles habe (wird durch die Kevag Telekom gehostet) und die geben mir verständlicherweise keinen Vollzugriff.

In deiner parameters.yml ist die falsche Datenbank-Version eingetragen. Lösche den Eintrag aus der parameters.yml und baue danach den Symfony Application Cache neu auf.

Zitat:

Zitat von Spooky

In deiner parameters.yml ist die falsche Datenbank-Version eingetragen. Lösche den Eintrag aus der parameters.yml und baue danach den Symfony Application Cache neu auf.

Tatsächlich war die Datenbank auf eine falsche Version eingestellt. Hätte man auch mal mitteilen können. Ich danke dir vielmals für deine Unterstützung. Damit konnte das Problem gelöst werden.

contao:migrate (bzw. das Pendant davon im Contao Manager) teilt es glaube ich mit.

MySQL in parameters.yml eintragen

Zitat:

Zitat von Spooky

Welche MySQL/MariaDB Version nutzt du? Welche Version ist in deiner parameters.yml eingetragen (falls eingetragen)?

Wie würde denn der Eintrag in die parameters.yml lauten, um die aktuelle MySQL/MariaDB Version einzutragen?

Du kannst den Eintrag auch einfach löschen (danach Symfony Application Cache neu aufbauen).