Ergebnis 1 bis 4 von 4

Thema: contao-news_categories php8

  1. #1
    Contao-Nutzer
    Registriert seit
    18.06.2017.
    Beiträge
    219

    Standard contao-news_categories php8

    Hallo,

    ich habe gerade eine Installation von mir auf php8-Tauglicheit getestet. Jedoch kommt folgenden Meldung:

    Problem 1
    - codefog/contao-news_categories[3.1.0, ..., 3.4.7] require php ^5.6|^7.0 -> your php version (8.0.7) does not satisfy that requirement.
    Wird die Erweiterung auf php8 umgestellt werden?

    Danke und Gruß

  2. #2
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    34.088
    Partner-ID
    10107

    Standard

    Vermutlich schon. Du könntest es mit --ignore-platform-reqs trotzdem installieren und vorab testen.
    Geändert von Spooky (25.06.2021 um 09:25 Uhr)
    » sponsor me via GitHub or PayPal or Revolut

  3. #3
    Contao-Nutzer
    Registriert seit
    18.06.2017.
    Beiträge
    219

    Standard

    Danke Spooky.
    Es läuft zwar ohne Fehler durch. Danach möchte das Install-Tool einige Tabellen ändern. Auch wenn ich es bestätige, kommt immer diese Änderung:


    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 userId userId INT DEFAULT NULL
    ALTER TABLE tl_trusted_device CHANGE userClass userClass VARCHAR(255) DEFAULT NULL
    ALTER TABLE tl_article CHANGE pdir_th_tag pdir_th_tag VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_article CHANGE pdir_th_domain pdir_th_domain VARCHAR(64) 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 bg_color bg_color VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar CHANGE fg_color fg_color VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar CHANGE isHolidayCal isHolidayCal CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar CHANGE allowEvents allowEvents CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar CHANGE uniqueEvents uniqueEvents CHAR(1) 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 repeatWeekday repeatWeekday VARCHAR(128) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE ignoreEndTime ignoreEndTime CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE useExceptions useExceptions CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE showOnFreeDay showOnFreeDay CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE weekday weekday CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE hideOnWeekend hideOnWeekend CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE useRegistration useRegistration CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE regconfirm regconfirm CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE regstartdate regstartdate INT UNSIGNED DEFAULT NULL
    ALTER TABLE tl_calendar_events CHANGE regenddate regenddate INT UNSIGNED DEFAULT NULL
    ALTER TABLE tl_calendar_events CHANGE recurringExt recurringExt CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE location_name location_name VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE location_str location_str VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE location_plz location_plz VARCHAR(10) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE location_ort location_ort VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE location_link location_link VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE location_contact location_contact VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE location_mail location_mail VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE pageTitle pageTitle VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE address address 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(255) 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(255) 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 location location VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE endDate endDate INT UNSIGNED DEFAULT NULL
    ALTER TABLE tl_calendar_events CHANGE startDate startDate INT UNSIGNED DEFAULT NULL
    ALTER TABLE tl_calendar_events CHANGE endTime endTime INT DEFAULT NULL
    ALTER TABLE tl_calendar_events CHANGE startTime startTime INT DEFAULT NULL
    ALTER TABLE tl_calendar_events CHANGE 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 title title 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_content CHANGE sliderSlidesPerView sliderSlidesPerView VARCHAR(4) DEFAULT '1' NOT NULL
    ALTER TABLE tl_content CHANGE sliderEffect sliderEffect VARCHAR(16) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE sliderWrapperClass sliderWrapperClass VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE sliderButtons sliderButtons CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE sliderPagination sliderPagination CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE sliderPaginationType sliderPaginationType VARCHAR(16) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE sliderAutoheight sliderAutoheight CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE sliderCenteredSlides sliderCenteredSlides CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE textModal_customTpl textModal_customTpl VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE news_categoryImgSize news_categoryImgSize VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE playerCaption playerCaption VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE playerAspect playerAspect VARCHAR(8) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE splashImage splashImage CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE playerPreload playerPreload VARCHAR(8) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE playerColor playerColor VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE overwriteLink overwriteLink CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE advancedCss advancedCss VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE ct_contentBox_customTpl ct_contentBox_customTpl VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE ct_featureIcon ct_featureIcon VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE ct_featureElement_customTpl ct_featureElement_customTpl VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE ct_price ct_price VARCHAR(20) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE ct_priceLabel ct_priceLabel VARCHAR(50) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE ct_popularPriceBox ct_popularPriceBox VARCHAR(50) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE ct_priceBox_customTpl ct_priceBox_customTpl VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE ct_teaserBox_customTpl ct_teaserBox_customTpl VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE ct_sliderElement_page ct_sliderElement_page VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE ct_sliderElement_linkText ct_sliderElement_linkText VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE ct_sliderElement_target ct_sliderElement_target CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE ct_sliderElement_subHeadline ct_sliderElement_subHeadline VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE stop stop VARCHAR(10) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE start start VARCHAR(10) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE invisible invisible CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE guests guests CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE sliderContinuous sliderContinuous CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE inline inline CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE playerSize playerSize VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE posterSRC posterSRC BINARY(16) DEFAULT NULL
    ALTER TABLE tl_content CHANGE vimeo vimeo VARCHAR(16) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE youtube youtube VARCHAR(16) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE customTpl customTpl VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE galleryTpl galleryTpl VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE metaIgnore metaIgnore CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE sortBy sortBy VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE useHomeDir useHomeDir CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE useImage useImage CHAR(1) DEFAULT '' NOT NULL
    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 target target CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE url url VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE highlight highlight VARCHAR(32) DEFAULT '' NOT NULL
    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) DEFAULT 'ascending' NOT NULL
    ALTER TABLE tl_content CHANGE sortable sortable CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE tleft tleft CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE tfoot tfoot CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE thead thead CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE summary summary VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE listtype listtype VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE floating floating VARCHAR(32) DEFAULT 'above' NOT NULL
    ALTER TABLE tl_content CHANGE caption caption VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE fullsize fullsize CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE imageUrl imageUrl VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE imagemargin imagemargin VARCHAR(128) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE size size VARCHAR(255) DEFAULT '' NOT NULL
    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) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE addImage addImage CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_content CHANGE headline headline VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL
    ALTER TABLE tl_content CHANGE type type VARCHAR(64) DEFAULT 'text' NOT NULL
    ALTER TABLE tl_content CHANGE ptable ptable VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_css_style_selector CHANGE cssClasses cssClasses VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_css_style_selector CHANGE styleDesignation styleDesignation VARCHAR(255) DEFAULT '' NOT NULL
    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(255) 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 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 advancedCss advancedCss VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_form CHANGE leadEnabled leadEnabled CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_form CHANGE leadMenuLabel leadMenuLabel VARCHAR(255) DEFAULT '' NOT 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 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 step step VARCHAR(10) DEFAULT '' NOT NULL
    ALTER TABLE tl_form_field CHANGE leadStore leadStore VARCHAR(10) DEFAULT '' NOT NULL
    ALTER TABLE tl_form_field CHANGE minval minval VARCHAR(10) DEFAULT '' NOT NULL
    ALTER TABLE tl_form_field CHANGE maxval maxval VARCHAR(10) 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 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 formats formats VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_image_size CHANGE skipIfDimensionsMatch skipIfDimensionsMatch CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_image_size CHANGE zoom zoom INT DEFAULT NULL
    ALTER TABLE tl_image_size CHANGE resizeMode resizeMode VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_image_size CHANGE height height INT DEFAULT NULL
    ALTER TABLE tl_image_size CHANGE width width INT DEFAULT 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 zoom zoom INT DEFAULT NULL
    ALTER TABLE tl_image_size_item CHANGE resizeMode resizeMode VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_image_size_item CHANGE height height INT DEFAULT NULL
    ALTER TABLE tl_image_size_item CHANGE width width INT DEFAULT 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 add_swiper_scripts add_swiper_scripts CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_layout CHANGE lightboxSize lightboxSize VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_layout CHANGE defaultImageDensities defaultImageDensities VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_layout CHANGE minifyMarkup minifyMarkup CHAR(1) DEFAULT '1' NOT NULL
    ALTER TABLE tl_layout CHANGE align align VARCHAR(32) DEFAULT 'center' NOT NULL
    ALTER TABLE tl_layout CHANGE width width VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_layout CHANGE static static CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_layout CHANGE mooSource mooSource VARCHAR(16) DEFAULT 'moo_local' NOT NULL
    ALTER TABLE tl_layout CHANGE addMooTools addMooTools CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_layout CHANGE jSource jSource VARCHAR(16) 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 webfonts webfonts VARCHAR(255) DEFAULT '' 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_lead CHANGE language language VARCHAR(5) DEFAULT '' NOT NULL
    ALTER TABLE tl_lead_data CHANGE name name VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_lead_export CHANGE skipLastRun skipLastRun CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_lead_export CHANGE lastRun lastRun INT DEFAULT NULL
    ALTER TABLE tl_lead_export CHANGE export export VARCHAR(8) DEFAULT '' NOT NULL
    ALTER TABLE tl_lead_export CHANGE headerFields headerFields CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_lead_export CHANGE template template BINARY(16) DEFAULT NULL
    ALTER TABLE tl_lead_export CHANGE useTemplate useTemplate CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_lead_export CHANGE filename filename VARCHAR(128) DEFAULT '' NOT NULL
    ALTER TABLE tl_lead_export CHANGE type type VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_lead_export 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 forward_mail forward_mail VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_member CHANGE rank rank VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_member CHANGE allowEmail allowEmail VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_member CHANGE secret secret BINARY(128) DEFAULT NULL
    ALTER TABLE tl_member CHANGE useTwoFactor useTwoFactor CHAR(1) DEFAULT '' NOT 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(5) 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 visitors_categories visitors_categories VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE visitors_template visitors_template VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE visitors_useragent visitors_useragent VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE regtype regtype CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE show_holiday show_holiday CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE ignore_urlparameter ignore_urlparameter CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE pubTimeRecurrences pubTimeRecurrences CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE cal_format_ext cal_format_ext VARCHAR(128) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE displayDuration displayDuration VARCHAR(128) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE showOnlyNext showOnlyNext CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE showRecurrences showRecurrences CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE use_horizontal use_horizontal CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE use_navigation use_navigation CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE showDate showDate CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE linkCurrent linkCurrent CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE hideEmptyDays hideEmptyDays CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE cal_times cal_times CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE cellhight cellhight VARCHAR(10) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE hide_started hide_started CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE eventLimit eventLimit CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE fc_editable fc_editable CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE businessHours businessHours CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE weekNumbers weekNumbers CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE weekNumbersWithinDays weekNumbersWithinDays CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE news_relatedCategoriesOrder news_relatedCategoriesOrder VARCHAR(10) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE news_categoryImgSize news_categoryImgSize VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE modal_linkText modal_linkText VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE modal_linkClass modal_linkClass VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE modal_customTpl modal_customTpl VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE modal_class modal_class VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE nl_template nl_template VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE nl_hideChannels nl_hideChannels CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE news_showQuantity news_showQuantity CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE news_order news_order VARCHAR(32) DEFAULT 'order_date_desc' NOT NULL
    ALTER TABLE tl_module CHANGE news_format news_format VARCHAR(32) DEFAULT 'news_month' NOT NULL
    ALTER TABLE tl_module CHANGE news_template news_template VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE news_metaFields news_metaFields VARCHAR(255) DEFAULT 'a:2:{i:0;s:4:"date";i:1;s:6:"author";}' NOT NULL
    ALTER TABLE tl_module CHANGE news_jumpToCurrent news_jumpToCurrent VARCHAR(16) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE news_featured news_featured VARCHAR(16) DEFAULT 'all_items' NOT NULL
    ALTER TABLE tl_module CHANGE list_info_layout list_info_layout VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE list_layout list_layout VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE list_info_where list_info_where VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE list_info list_info VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE list_sort list_sort VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE list_search list_search VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE list_where list_where VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE list_fields list_fields VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE list_table list_table VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE cal_showQuantity cal_showQuantity CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE cal_ctemplate cal_ctemplate VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE cal_template cal_template VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE cal_order cal_order VARCHAR(32) DEFAULT 'ascending' NOT NULL
    ALTER TABLE tl_module CHANGE cal_ignoreDynamic cal_ignoreDynamic CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE cal_format cal_format VARCHAR(32) DEFAULT 'cal_month' NOT NULL
    ALTER TABLE tl_module CHANGE cal_hideRunning cal_hideRunning CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE cal_noSpan cal_noSpan CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE guests guests CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE reg_activate reg_activate CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE reg_homeDir reg_homeDir BINARY(16) DEFAULT NULL
    ALTER TABLE tl_module CHANGE reg_assignDir reg_assignDir CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE reg_close reg_close VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE reg_skipName reg_skipName CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE reg_allowLogin reg_allowLogin CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE disableCaptcha disableCaptcha CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE rss_template rss_template VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE fullsize fullsize CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE useCaption useCaption CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE imgSize imgSize VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE url url VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE singleSRC singleSRC BINARY(16) DEFAULT NULL
    ALTER TABLE tl_module CHANGE loadFirst loadFirst CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE inColumn inColumn VARCHAR(32) DEFAULT 'main' NOT NULL
    ALTER TABLE tl_module CHANGE searchTpl searchTpl VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE searchType searchType VARCHAR(32) DEFAULT 'simple' NOT NULL
    ALTER TABLE tl_module CHANGE contextLength contextLength VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE fuzzy fuzzy CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE queryType queryType VARCHAR(32) DEFAULT 'and' NOT NULL
    ALTER TABLE tl_module CHANGE memberTpl memberTpl VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE redirectBack redirectBack CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE autologin autologin CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE customLabel customLabel VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE showHidden showHidden CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE customTpl customTpl VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE navigationTpl navigationTpl VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE defineRoot defineRoot CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE showProtected showProtected CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE hardLimit hardLimit CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_module CHANGE type type VARCHAR(64) DEFAULT 'navigation' NOT NULL
    ALTER TABLE tl_module CHANGE headline headline VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL
    ALTER TABLE tl_module CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_monitoring CHANGE client_scan_active client_scan_active CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_monitoring CHANGE client_url client_url VARCHAR(512) DEFAULT '' NOT NULL
    ALTER TABLE tl_monitoring CHANGE client_token client_token VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_monitoring CHANGE disable disable CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_monitoring CHANGE disableMailing disableMailing CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_monitoring CHANGE last_test_status last_test_status VARCHAR(64) DEFAULT 'UNTESTED' NOT NULL
    ALTER TABLE tl_monitoring CHANGE last_test_date last_test_date VARCHAR(10) DEFAULT '' NOT NULL
    ALTER TABLE tl_monitoring CHANGE url url VARCHAR(512) DEFAULT '' NOT NULL
    ALTER TABLE tl_monitoring CHANGE system system VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_monitoring CHANGE website website VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_monitoring CHANGE customer customer VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_monitoring_test CHANGE repetitions repetitions VARCHAR(2) DEFAULT '1' NOT NULL
    ALTER TABLE tl_monitoring_test CHANGE status status VARCHAR(64) DEFAULT 'OKAY' NOT NULL
    ALTER TABLE tl_monitoring_test CHANGE type type VARCHAR(64) DEFAULT 'MANUAL' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE mailerTransport mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE postmark_ssl postmark_ssl CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE postmark_test postmark_test CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE postmark_key postmark_key VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE file_path file_path VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE file_password file_password VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE file_username file_username VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE file_port file_port VARCHAR(5) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE file_host file_host VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE file_connection file_connection VARCHAR(8) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE file_type file_type VARCHAR(4) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE email_smtpPort email_smtpPort VARCHAR(16) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE email_smtpEnc email_smtpEnc VARCHAR(3) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE email_smtpPass email_smtpPass VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE email_smtpUser email_smtpUser VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE email_smtpHost email_smtpHost VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE email_overrideSmtp email_overrideSmtp CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE queue_cronInterval queue_cronInterval VARCHAR(12) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE queue_cronEnable queue_cronEnable CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE queue_delay queue_delay VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE type type VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_gateway CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_language CHANGE file_storage_mode file_storage_mode VARCHAR(8) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_language CHANGE file_name file_name VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_language CHANGE email_external_images email_external_images CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_language CHANGE email_mode email_mode VARCHAR(16) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_language CHANGE email_subject email_subject VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_language CHANGE email_replyTo email_replyTo VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_language CHANGE email_sender_address email_sender_address VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_language CHANGE email_sender_name email_sender_name VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_language CHANGE attachment_tokens attachment_tokens VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_language CHANGE recipients recipients VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_language CHANGE fallback fallback CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_language CHANGE language language VARCHAR(5) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_language CHANGE gateway_type gateway_type VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_message CHANGE published published CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_message CHANGE postmark_trackOpens postmark_trackOpens CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_message CHANGE postmark_tag postmark_tag VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_message CHANGE email_template email_template VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_message CHANGE gateway_type gateway_type VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_message CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_notification CHANGE flatten_delimiter flatten_delimiter VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_notification CHANGE type type VARCHAR(128) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_notification CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_queue CHANGE language language VARCHAR(5) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_queue CHANGE error error CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_queue CHANGE dateSent dateSent VARCHAR(10) DEFAULT '' NOT NULL
    ALTER TABLE tl_nc_queue CHANGE dateDelay dateDelay INT UNSIGNED DEFAULT NULL
    ALTER TABLE tl_news CHANGE einsatzkat einsatzkat VARCHAR(2) DEFAULT '-' NOT NULL
    ALTER TABLE tl_news CHANGE pageTitle pageTitle VARCHAR(255) 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 featured featured 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(255) 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(255) 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 alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_news CHANGE headline headline VARCHAR(255) 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_category CHANGE image image VARBINARY(16) DEFAULT NULL
    ALTER TABLE tl_news_category CHANGE cssClass cssClass VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_news_category CHANGE alias alias VARBINARY(128) DEFAULT '' NOT NULL
    ALTER TABLE tl_news_category CHANGE frontendTitle frontendTitle VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_news_category CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_news_feed CHANGE categories_show categories_show VARCHAR(16) 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 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_blacklist CHANGE hash hash VARCHAR(32) DEFAULT 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 template template VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_newsletter_channel CHANGE title title VARCHAR(255) DEFAULT '' NOT 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 favicon favicon BINARY(16) DEFAULT NULL
    ALTER TABLE tl_page CHANGE newsCategories_param newsCategories_param VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_page CHANGE validAliasCharacters validAliasCharacters VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_page CHANGE alwaysLoadFromCache alwaysLoadFromCache CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_page CHANGE requireItem requireItem CHAR(1) 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 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 '' NOT NULL
    ALTER TABLE tl_page CHANGE sitemapName sitemapName VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_page CHANGE createSitemap createSitemap CHAR(1) 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 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(255) 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(5) DEFAULT '' NOT NULL
    ALTER TABLE tl_page CHANGE pageTitle pageTitle VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_page CHANGE type type VARCHAR(64) DEFAULT 'regular' NOT NULL
    ALTER TABLE tl_page CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_page 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(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_search CHANGE title title VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_search_index CHANGE language language VARCHAR(5) DEFAULT '' NOT NULL
    ALTER TABLE tl_search_index CHANGE word word VARCHAR(64) DEFAULT '' NOT NULL COLLATE `utf8mb4_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 pdir_th_license_domain pdir_th_license_domain VARCHAR(128) DEFAULT '' NOT NULL
    ALTER TABLE tl_theme CHANGE pdir_th_short_code pdir_th_short_code VARCHAR(32) 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 newscategories newscategories VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_user CHANGE secret secret BINARY(128) DEFAULT NULL
    ALTER TABLE tl_user CHANGE useTwoFactor useTwoFactor CHAR(1) DEFAULT '' NOT 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(5) 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 newscategories newscategories VARCHAR(32) DEFAULT '' NOT NULL
    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
    ALTER TABLE tl_visitors CHANGE visitors_expert_debug_screenresolutioncount visitors_expert_debug_screenresolutioncount CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_visitors CHANGE visitors_expert_debug_searchengine visitors_expert_debug_searchengine CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_visitors CHANGE visitors_expert_debug_referrer visitors_expert_debug_referrer CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_visitors CHANGE visitors_expert_debug_checks visitors_expert_debug_checks CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_visitors CHANGE visitors_expert_debug_tag visitors_expert_debug_tag CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_visitors CHANGE published published CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_visitors CHANGE visitors_thousands_separator visitors_thousands_separator CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_visitors CHANGE visitors_average visitors_average CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_visitors CHANGE visitors_startdate visitors_startdate VARCHAR(10) DEFAULT '' NOT NULL
    ALTER TABLE tl_visitors CHANGE visitors_name visitors_name VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_visitors_blocker CHANGE visitors_type visitors_type CHAR(1) DEFAULT 'v' NOT NULL
    ALTER TABLE tl_visitors_blocker CHANGE visitors_ip visitors_ip VARCHAR(40) DEFAULT '0.0.0.0' NOT NULL
    ALTER TABLE tl_visitors_blocker CHANGE visitors_tstamp visitors_tstamp DATETIME DEFAULT NULL
    ALTER TABLE tl_visitors_browser CHANGE visitors_lang visitors_lang VARCHAR(10) DEFAULT 'Unknown' NOT NULL
    ALTER TABLE tl_visitors_browser CHANGE visitors_os visitors_os VARCHAR(60) DEFAULT 'Unknown' NOT NULL
    ALTER TABLE tl_visitors_browser CHANGE visitors_browser visitors_browser VARCHAR(60) DEFAULT 'Unknown' NOT NULL
    ALTER TABLE tl_visitors_category CHANGE visitors_statreset_groups visitors_statreset_groups VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_visitors_category CHANGE visitors_statreset_protected visitors_statreset_protected CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_visitors_category CHANGE visitors_stat_groups visitors_stat_groups VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_visitors_category CHANGE visitors_stat_protected visitors_stat_protected CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_visitors_category CHANGE title title VARCHAR(60) DEFAULT '' NOT NULL
    ALTER TABLE tl_visitors_counter CHANGE visitors_date visitors_date DATE DEFAULT '1999-01-01' NOT NULL
    ALTER TABLE tl_visitors_pages CHANGE visitors_page_lang visitors_page_lang VARCHAR(5) DEFAULT '' NOT NULL
    ALTER TABLE tl_visitors_pages CHANGE visitors_page_date visitors_page_date DATE DEFAULT '1999-01-01' NOT NULL
    ALTER TABLE tl_visitors_referrer CHANGE visitors_referrer_dns visitors_referrer_dns VARCHAR(255) DEFAULT '-' NOT NULL
    ALTER TABLE tl_visitors_screen_counter CHANGE v_date v_date DATE DEFAULT '1999-01-01' NOT NULL
    ALTER TABLE tl_visitors_searchengines CHANGE visitors_keywords visitors_keywords VARCHAR(255) DEFAULT 'Unknown' NOT NULL
    ALTER TABLE tl_visitors_searchengines CHANGE visitors_searchengine visitors_searchengine VARCHAR(60) DEFAULT 'Unknown' NOT NULL

  4. #4
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    34.088
    Partner-ID
    10107

    Standard

    Das hat nichts mit der News Categories Erweiterung zu tun, das ist ein separates Problem.
    » sponsor me via GitHub or PayPal or Revolut

Aktive Benutzer

Aktive Benutzer

Aktive Benutzer in diesem Thema: 1 (Registrierte Benutzer: 0, Gäste: 1)

Lesezeichen

Lesezeichen

Berechtigungen

  • Neue Themen erstellen: Nein
  • Themen beantworten: Nein
  • Anhänge hochladen: Nein
  • Beiträge bearbeiten: Nein
  •