Contao Version 3.5.35 ist verfügbar. Das Bugfix-Release behebt eine XSS-Lücke im System-Log des Backends (CVE-2018-10125).
Ganzen Beitrag zu 'Contao 3.5.35 verfügbar' lesen
Contao Version 3.5.35 ist verfügbar. Das Bugfix-Release behebt eine XSS-Lücke im System-Log des Backends (CVE-2018-10125).
Ganzen Beitrag zu 'Contao 3.5.35 verfügbar' lesen
Lässt sich die XSS-Lücke nur ausnutzen, wenn ein angemeldeter Benutzer zuvor einen manipulierten Link aufruft oder kann ein Angreifer den Request zu einem beliebigen Zeitpunkt ausführen und die Schwachstelle wird erst ausgenutzt, wenn ein Backendbenutzer die Log-Files aufruft?
Ist dafür ein Zugriff auf Formularfelder im FE erforderlich oder reicht es aus, wenn ein Angreifer bestimmte interne URls aufruft?
soweit ich es verstehe: ein Angreifer kann deine URLs soweit manipulieren, dass sie im Contao-Error-Log landen. Wenn du dann als Admin dir das Error-Log im Backenend anschaust, dann kommt die XXS-Lücke zum tragen.
Die Lösung ist dein letzter Teil deiner Frage: "kann ein Angreifer den Request zu einem beliebigen Zeitpunkt ausführen und die Schwachstelle wird erst ausgenutzt, wenn ein Backendbenutzer die Log-Files aufruft"
Kann mir bitte jemand einen Download-Link zu der Version 3.5.35 geben? Auf der Download-Seite ist bereits die neuere LTS-Version (Version 4.4) zu finden.
https://download.contao.org/3.5/zip
https://contao.org/de/download.html
„Ältere Versionen” und auf den 3.5 Link klicken.
---------------------------------
Beste Grüße planepix
Contao für Webdesigner (Website), Twitter: @contaowebdesign
weitzeldesign
Contao-Sprechstunde
Contao Schulungen: https://www.weitzeldesign.com/cms-co...chulungen.html
Contao Jahrbuch: www.contao-jahrbuch.de
Contao Agenturtag: www.contao-agenturtag.de
Contao Stammtisch Stuttgart: www.contao-stammtisch-stuttgart.de
Contao 4 Erfahrungen als Gitbook: https://app.gitbook.com/@planepix/s/...-mit-contao-4/
Contao 4 & Manager Hosterhinweise: https://github.com/contao/contao-manager/wiki
Schon wieder ein Update?
Glücklich sind die, die den Wert erkennen – und wertschätzen.
„Muss man machen wie beim Zahnarzt. Der bestraft einen auch mit hohen Rechnungen wenn man die Pflege vernachlässigt.”
https://download.contao.org/3.5/zip
Auf der Downloadseite übrigens unten rechts zu finden bei "Ältere Versionen"
Grüße, BugBuster"view source" is your guide.Danke an alle Amazon Wunschlisten Erfüller
Besten Dank!
Wer scrollen und lesen kann ist klar im Vorteil
Vielen Dank, so habe ich den Text letztendlich auch interpretiert. Leos Meldung ist diesbezüglich (wahrscheinlich absichtlich) leider nicht ganz eindeutig.
Kommt diese Schwachstelle auch zum Tragen, wenn die Speicherzeit für Log-Einträge auf "0" gesetzt ist und wenn zudem keine Error-Logs angelegt werden?
Kurzform: Wer Zugriff auf die Systemlogs im Backend hat und dort Logeinträge einsehen kann, ist ein potenzielles Opfer der XSS-Lücke.
Der Angriffsvektor ist extrem einfach und die potenziellen Schäden sehr gross, also auf jeden Fall updaten und nicht irgendwie die Logeinträge auf 0 stellen oder sowas
Contao Core-Entwickler @terminal42 gmbh
Wir sind Contao Premium-Partner!
Für Individuallösungen kannst du uns gerne kontaktieren.
PS: Heute schon getrakked?
Hallo zusammen,
habe ich es richtig verstanden, das der Angriff über das Backend von außen erfolgt, um dort über die Logeinträge die XSS-Lücke zu nutzen.
Wäre ein .htaccess Schutz für das /contao/ Verzeichnis eine schnelle Lösung, um den Angriff zu minimieren?
Klar, das man langfristig die Updates einspielen sollte ist keine Frage, aber wer viele Installationen anheben muss, ist da schon ganz schön beschäftigt.
Viele Grüße
Markus
Contao Partner aus Rosenheim und München
codesache.de
---
Mitglied der Contao Community Bayern
Aktuelle Termine zur Contao Community Bayern: contao-bayern.de
So wie ich das verstanden habe, wird das nicht helfen. Der Angriff erfolgt über das Frontend, da wird es nichts helfen, das contao-Unterverzeichnis zu schützen.
Das Update mit easyupdate3 von Glen hat bei mir keine 5 Minuten gedauert. Ich halte das für eine sehr schnelle Lösung.
Extensions :: Github
Sponsering: Amazon Wunschliste :: Github :: PayPal
Composer Version prüfen https://jubianchi.github.io/semver-check
Der Angriff kann überall erfolgen. Frontend, Backend, Core-Module, Extensions. Von überall.
Contao Core-Entwickler @terminal42 gmbh
Wir sind Contao Premium-Partner!
Für Individuallösungen kannst du uns gerne kontaktieren.
PS: Heute schon getrakked?
Mit der .htaccess könntest du also höchstens verhindern, dass sich jemand ins Backend einloggt und sich eventuell dort die Logs anschaut. Also Passwort festlegen, vergessen und Zettel wegwerfen . Am besten FTP auch gleich mit.
Kann man herausfinden ob schon was passiert ist?
Ursache und Wirkung habe ich verstanden.
Bei den Projekten die ich betreue, bin ich eigentlich der Einzige der sich ins System einloggt bzw. der überhaupt unter System-Log nachsehen würde.
Da diese Situation wahrscheinlich bei vielen von euch ähnlich ist, würde es also für weniger Zeitdruck sorgen, richtig?
Idee für eine weitere Notlösung
Wäre es kurzfristig eine Lösung, per Systemwartung den System-Log zu löschen? (Mir ist schon bewusst, dass danach jederzeit wieder ein Angriff erfolgen kann)
Ahoi, ich habe heute mittels Bugbusters easyupdate3 15 Installationen geupdated. Der Zeitaufwand war unter 60 min.
Gesendet von iPhone mit Tapatalk Pro
Grüße, Stefko
Geändert von lucina (21.04.2018 um 07:10 Uhr) Grund: Tippfehler
Contao in Kiel: kikmedia webdevelopment | Contao-Partnerin | Contao Usergroup Kiel | github | Contao-Community-Alliance | MetaModels-Team
Reines Update ja aber mit Backup und ggf. parallel Installation wird's dann mit den 2 Minuten schon knapp und unter 4.x ggf. noch länger.
Aber hey, bei 2 Minuten rechne ich mit dir gerne auch 5 Minuten von deinem Stundensatz ab ;-)
Geändert von Y-Nell (20.04.2018 um 23:07 Uhr) Grund: Tippfehler
Wenn Du vorher sauber gearbeitet hast, dann ist das kein Problem. Wobei ich dann auch sagen muss, dass sich etliche meiner Server entweder qua Dateisystem (ich setze gerne ZFS ein) oder per Cronjobs selbständig um die Backups kümmern. Beim Setup möglicherweise etwas mehr Aufwand, aber das macht sich schnell bezahlt.
In 4.x ist das übrigens eher einfacher, weil Du ja auch komplett simpel wieder zurück zur Vorversion kannst.
Contao in Kiel: kikmedia webdevelopment | Contao-Partnerin | Contao Usergroup Kiel | github | Contao-Community-Alliance | MetaModels-Team
Wenn man entsprechende Projekte hat, die dies erforderlich machen bzw. man diesen Aufwand auch entsprechend bezahlt bekommt, ist ein solches Deployment sicherlich nützlich, keine Frage.
Wie einfach das mit 4.x konnte ich diese Nacht wieder erleben. "Mal eben" versucht per Contao-Manager eine neuere Version für eine Extension unter 4.4.18 zu installieren. Ein Satz mit X. CM, FE & BE tot und dann über die Konsole wieder fixen müssen.
Aber um wieder mehr beim Thema zu bleiben, ich schließe mich der Frage von folkfreund an, kann man überhaupt erkennen, ob ein Angriff schon erfolgt ist und ggf. erfolgreich ausgeführt wurde?
Hallo ihr lieben,
kann mir jemand auf die Sprünge helfen, warum ich nach dem Update von 3.5.31 auf 3.5.35 im Installtool ständig die Meldung "Die Datenbank ist nicht aktuell!" bekomme. Ich habe nun schon mehrfach den Haken "Alle auswählen" gesetzt und die DB aktualisiert. Es ändert sich nichts. Das Backend ist weiterhin aufrufbar.
Die Dateien wurden mit Filezilla auf den Webserer hochgeladen (nur Quelldateien die neuer als die vorhandenen sind). Ich verwende für die Vereinsseite das kostenlose "Open Sauce Rocksolid Theme".
Grüßle
Michael
Grüßle
Michael
Poste die SQL Queries, die dir das Install Tool anzeigt.
Das sind allerdings 860 Zeilen.
Code:ALTER TABLE `tl_article` CHANGE `title` `title` varchar(255) NOT NULL default ''; ALTER TABLE `tl_article` CHANGE `inColumn` `inColumn` varchar(32) NOT NULL default ''; ALTER TABLE `tl_article` CHANGE `keywords` `keywords` text NULL; ALTER TABLE `tl_article` CHANGE `showTeaser` `showTeaser` char(1) NOT NULL default ''; ALTER TABLE `tl_article` CHANGE `teaserCssID` `teaserCssID` varchar(255) NOT NULL default ''; ALTER TABLE `tl_article` CHANGE `teaser` `teaser` text NULL; ALTER TABLE `tl_article` CHANGE `printable` `printable` varchar(255) NOT NULL default ''; ALTER TABLE `tl_article` CHANGE `customTpl` `customTpl` varchar(64) NOT NULL default ''; ALTER TABLE `tl_article` CHANGE `protected` `protected` char(1) NOT NULL default ''; ALTER TABLE `tl_article` CHANGE `guests` `guests` char(1) NOT NULL default ''; ALTER TABLE `tl_article` CHANGE `cssID` `cssID` varchar(255) NOT NULL default ''; ALTER TABLE `tl_article` CHANGE `space` `space` varchar(64) NOT NULL default ''; ALTER TABLE `tl_article` CHANGE `published` `published` char(1) NOT NULL default ''; ALTER TABLE `tl_article` CHANGE `start` `start` varchar(10) NOT NULL default ''; ALTER TABLE `tl_article` CHANGE `stop` `stop` varchar(10) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `ptable` `ptable` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `type` `type` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `headline` `headline` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `text` `text` mediumtext NULL; ALTER TABLE `tl_content` CHANGE `addImage` `addImage` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `alt` `alt` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `title` `title` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `size` `size` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `imagemargin` `imagemargin` varchar(128) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `imageUrl` `imageUrl` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `fullsize` `fullsize` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `caption` `caption` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `floating` `floating` varchar(32) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `html` `html` mediumtext NULL; ALTER TABLE `tl_content` CHANGE `listtype` `listtype` varchar(32) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `summary` `summary` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `thead` `thead` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `tfoot` `tfoot` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `tleft` `tleft` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `sortable` `sortable` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `sortOrder` `sortOrder` varchar(32) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `mooHeadline` `mooHeadline` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `mooStyle` `mooStyle` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `mooClasses` `mooClasses` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `highlight` `highlight` varchar(32) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `shClass` `shClass` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `code` `code` text NULL; ALTER TABLE `tl_content` CHANGE `url` `url` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `target` `target` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `titleText` `titleText` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `linkTitle` `linkTitle` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `embed` `embed` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rel` `rel` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `useImage` `useImage` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `useHomeDir` `useHomeDir` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `sortBy` `sortBy` varchar(32) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `metaIgnore` `metaIgnore` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `galleryTpl` `galleryTpl` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `customTpl` `customTpl` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `youtube` `youtube` varchar(16) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `playerSize` `playerSize` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `autoplay` `autoplay` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `sliderContinuous` `sliderContinuous` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `protected` `protected` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `guests` `guests` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `cssID` `cssID` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `space` `space` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `invisible` `invisible` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `start` `start` varchar(10) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `stop` `stop` varchar(10) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `ical_prefix` `ical_prefix` varchar(128) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `ical_start` `ical_start` varchar(12) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `ical_end` `ical_end` varchar(12) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `com_order` `com_order` varchar(32) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `com_moderate` `com_moderate` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `com_bbcode` `com_bbcode` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `com_disableCaptcha` `com_disableCaptcha` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `com_requireLogin` `com_requireLogin` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `com_template` `com_template` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rs_columns_large` `rs_columns_large` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rs_columns_medium` `rs_columns_medium` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rs_columns_small` `rs_columns_small` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_content_type` `rsts_content_type` varchar(64) NOT NULL default 'rsts_default'; ALTER TABLE `tl_content` CHANGE `rsts_import_settings` `rsts_import_settings` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_template` `rsts_template` varchar(32) NOT NULL default 'rsts_default'; ALTER TABLE `tl_content` CHANGE `rsts_type` `rsts_type` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_direction` `rsts_direction` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_random` `rsts_random` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_loop` `rsts_loop` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_centerContent` `rsts_centerContent` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_skin` `rsts_skin` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_width` `rsts_width` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_height` `rsts_height` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_gapSize` `rsts_gapSize` varchar(64) NOT NULL default '0%'; ALTER TABLE `tl_content` CHANGE `rsts_videoAutoplay` `rsts_videoAutoplay` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_autoplayProgress` `rsts_autoplayProgress` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_pauseAutoplayOnHover` `rsts_pauseAutoplayOnHover` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_navType` `rsts_navType` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_controls` `rsts_controls` char(1) NOT NULL default '1'; ALTER TABLE `tl_content` CHANGE `rsts_thumbControls` `rsts_thumbControls` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_invertControls` `rsts_invertControls` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_scaleMode` `rsts_scaleMode` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_imagePosition` `rsts_imagePosition` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_deepLinkPrefix` `rsts_deepLinkPrefix` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_keyboard` `rsts_keyboard` char(1) NOT NULL default '1'; ALTER TABLE `tl_content` CHANGE `rsts_captions` `rsts_captions` char(1) NOT NULL default '1'; ALTER TABLE `tl_content` CHANGE `rsts_thumbs` `rsts_thumbs` char(1) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_thumbs_width` `rsts_thumbs_width` varchar(64) NOT NULL default '100%'; ALTER TABLE `tl_content` CHANGE `rsts_thumbs_height` `rsts_thumbs_height` varchar(64) NOT NULL default '1x1'; ALTER TABLE `tl_content` CHANGE `rsts_thumbs_gapSize` `rsts_thumbs_gapSize` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_thumbs_scaleMode` `rsts_thumbs_scaleMode` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_thumbs_imagePosition` `rsts_thumbs_imagePosition` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_thumbs_controls` `rsts_thumbs_controls` char(1) NOT NULL default '1'; ALTER TABLE `tl_content` CHANGE `rsts_thumbs_imgSize` `rsts_thumbs_imgSize` varchar(64) NOT NULL default 'a:3:{i:0;s:2:"50";i:1;s:2:"50";i:2;s:4:"crop";}'; ALTER TABLE `tl_content` CHANGE `rsts_thumbs_rowSlideRatio` `rsts_thumbs_rowSlideRatio` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_rowSlideRatio` `rsts_rowSlideRatio` varchar(255) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_combineNavItems` `rsts_combineNavItems` char(1) NOT NULL default '1'; ALTER TABLE `tl_content` CHANGE `rsts_customSkin` `rsts_customSkin` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `rsts_cssPrefix` `rsts_cssPrefix` varchar(64) NOT NULL default ''; ALTER TABLE `tl_content` CHANGE `surveyTpl` `surveyTpl` varchar(64) NOT NULL default ''; ALTER TABLE `tl_cron` CHANGE `name` `name` varchar(32) NULL; ALTER TABLE `tl_cron` CHANGE `value` `value` varchar(32) NOT NULL default ''; ALTER TABLE `tl_files` CHANGE `type` `type` varchar(16) NOT NULL default ''; ALTER TABLE `tl_files` CHANGE `path` `path` varchar(1022) NOT NULL default ''; ALTER TABLE `tl_files` CHANGE `extension` `extension` varchar(16) NOT NULL default ''; ALTER TABLE `tl_files` CHANGE `hash` `hash` varchar(32) NOT NULL default ''; ALTER TABLE `tl_files` CHANGE `found` `found` char(1) NOT NULL default '1'; ALTER TABLE `tl_files` CHANGE `name` `name` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `title` `title` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `sendViaEmail` `sendViaEmail` char(1) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `recipient` `recipient` varchar(1022) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `subject` `subject` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `format` `format` varchar(12) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `skipEmpty` `skipEmpty` char(1) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `storeValues` `storeValues` char(1) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `targetTable` `targetTable` varchar(64) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `method` `method` varchar(12) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `novalidate` `novalidate` char(1) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `attributes` `attributes` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `formID` `formID` varchar(64) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `tableless` `tableless` char(1) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `allowTags` `allowTags` char(1) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `storeFormdata` `storeFormdata` char(1) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `efgStoreValues` `efgStoreValues` char(1) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `useFormValues` `useFormValues` char(1) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `useFieldNames` `useFieldNames` char(1) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `efgAliasField` `efgAliasField` varchar(64) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `sendConfirmationMail` `sendConfirmationMail` char(1) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `confirmationMailRecipientField` `confirmationMailRecipientField` varchar(64) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `confirmationMailRecipient` `confirmationMailRecipient` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `confirmationMailSender` `confirmationMailSender` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `confirmationMailReplyto` `confirmationMailReplyto` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `confirmationMailSubject` `confirmationMailSubject` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `confirmationMailText` `confirmationMailText` text NULL; ALTER TABLE `tl_form` CHANGE `confirmationMailSkipEmpty` `confirmationMailSkipEmpty` char(1) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `sendFormattedMail` `sendFormattedMail` char(1) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `formattedMailRecipient` `formattedMailRecipient` text NULL; ALTER TABLE `tl_form` CHANGE `formattedMailSubject` `formattedMailSubject` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `formattedMailText` `formattedMailText` text NULL; ALTER TABLE `tl_form` CHANGE `formattedMailSkipEmpty` `formattedMailSkipEmpty` char(1) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `addConfirmationMailAttachments` `addConfirmationMailAttachments` char(1) NOT NULL default ''; ALTER TABLE `tl_form` CHANGE `addFormattedMailAttachments` `addFormattedMailAttachments` char(1) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `invisible` `invisible` char(1) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `type` `type` varchar(64) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `name` `name` varchar(64) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `label` `label` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `text` `text` text NULL; ALTER TABLE `tl_form_field` CHANGE `html` `html` text NULL; ALTER TABLE `tl_form_field` CHANGE `mandatory` `mandatory` char(1) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `rgxp` `rgxp` varchar(32) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `placeholder` `placeholder` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `size` `size` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `multiple` `multiple` char(1) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `extensions` `extensions` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `storeFile` `storeFile` char(1) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `useHomeDir` `useHomeDir` char(1) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `doNotOverwrite` `doNotOverwrite` char(1) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `fsType` `fsType` varchar(32) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `class` `class` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `value` `value` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `accesskey` `accesskey` char(1) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `customTpl` `customTpl` varchar(64) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `addSubmit` `addSubmit` char(1) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `slabel` `slabel` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `imageSubmit` `imageSubmit` char(1) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `efgLookupOptions` `efgLookupOptions` text NULL; ALTER TABLE `tl_form_field` CHANGE `efgImageMultiple` `efgImageMultiple` char(1) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `efgImageUseHomeDir` `efgImageUseHomeDir` char(1) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `efgImageSortBy` `efgImageSortBy` varchar(32) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `efgImageSize` `efgImageSize` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `efgImageMargin` `efgImageMargin` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `efgImageFullsize` `efgImageFullsize` char(1) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `efgAddBackButton` `efgAddBackButton` char(1) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `efgBackSlabel` `efgBackSlabel` varchar(255) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `efgSwitchButtonOrder` `efgSwitchButtonOrder` char(1) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `efgBackStoreSessionValues` `efgBackStoreSessionValues` char(1) NOT NULL default ''; ALTER TABLE `tl_form_field` CHANGE `efgBackImageSubmit` `efgBackImageSubmit` char(1) NOT NULL default ''; ALTER TABLE `tl_image_size` CHANGE `name` `name` varchar(64) NULL; ALTER TABLE `tl_image_size` CHANGE `sizes` `sizes` varchar(255) NOT NULL default ''; ALTER TABLE `tl_image_size` CHANGE `densities` `densities` varchar(255) NOT NULL default ''; ALTER TABLE `tl_image_size` CHANGE `resizeMode` `resizeMode` varchar(255) NOT NULL default ''; ALTER TABLE `tl_image_size_item` CHANGE `media` `media` varchar(255) NOT NULL default ''; ALTER TABLE `tl_image_size_item` CHANGE `sizes` `sizes` varchar(255) NOT NULL default ''; ALTER TABLE `tl_image_size_item` CHANGE `densities` `densities` varchar(255) NOT NULL default ''; ALTER TABLE `tl_image_size_item` CHANGE `resizeMode` `resizeMode` varchar(255) NOT NULL default ''; ALTER TABLE `tl_image_size_item` CHANGE `invisible` `invisible` char(1) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `name` `name` varchar(255) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `rows` `rows` varchar(8) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `headerHeight` `headerHeight` varchar(255) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `footerHeight` `footerHeight` varchar(255) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `cols` `cols` varchar(8) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `widthLeft` `widthLeft` varchar(255) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `widthRight` `widthRight` varchar(255) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `sections` `sections` varchar(1022) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `sPosition` `sPosition` varchar(32) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `framework` `framework` varchar(255) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `loadingOrder` `loadingOrder` varchar(16) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `template` `template` varchar(64) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `doctype` `doctype` varchar(32) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `webfonts` `webfonts` varchar(255) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `picturefill` `picturefill` char(1) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `viewport` `viewport` varchar(255) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `titleTag` `titleTag` varchar(255) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `cssClass` `cssClass` varchar(255) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `onload` `onload` varchar(255) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `head` `head` text NULL; ALTER TABLE `tl_layout` CHANGE `addJQuery` `addJQuery` char(1) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `jSource` `jSource` varchar(16) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `jquery` `jquery` text NULL; ALTER TABLE `tl_layout` CHANGE `addMooTools` `addMooTools` char(1) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `mooSource` `mooSource` varchar(16) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `mootools` `mootools` text NULL; ALTER TABLE `tl_layout` CHANGE `analytics` `analytics` text NULL; ALTER TABLE `tl_layout` CHANGE `script` `script` text NULL; ALTER TABLE `tl_layout` CHANGE `static` `static` char(1) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `width` `width` varchar(255) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `align` `align` varchar(32) NOT NULL default ''; ALTER TABLE `tl_layout` CHANGE `rs_columns_load_css` `rs_columns_load_css` char(1) NOT NULL default '1'; ALTER TABLE `tl_log` CHANGE `source` `source` varchar(32) NOT NULL default ''; ALTER TABLE `tl_log` CHANGE `action` `action` varchar(32) NOT NULL default ''; ALTER TABLE `tl_log` CHANGE `username` `username` varchar(64) NOT NULL default ''; ALTER TABLE `tl_log` CHANGE `text` `text` text NULL; ALTER TABLE `tl_log` CHANGE `func` `func` varchar(255) NOT NULL default ''; ALTER TABLE `tl_log` CHANGE `ip` `ip` varchar(64) NOT NULL default ''; ALTER TABLE `tl_log` CHANGE `browser` `browser` varchar(255) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `firstname` `firstname` varchar(255) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `lastname` `lastname` varchar(255) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `dateOfBirth` `dateOfBirth` varchar(11) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `gender` `gender` varchar(32) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `company` `company` varchar(255) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `street` `street` varchar(255) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `postal` `postal` varchar(32) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `city` `city` varchar(255) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `state` `state` varchar(64) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `country` `country` varchar(2) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `phone` `phone` varchar(64) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `mobile` `mobile` varchar(64) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `fax` `fax` varchar(64) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `email` `email` varchar(255) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `website` `website` varchar(255) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `language` `language` varchar(5) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `login` `login` char(1) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `password` `password` varchar(128) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `assignDir` `assignDir` char(1) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `disable` `disable` char(1) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `start` `start` varchar(10) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `stop` `stop` varchar(10) NOT NULL default ''; ALTER TABLE `tl_member` CHANGE `autologin` `autologin` varchar(32) NULL; ALTER TABLE `tl_member` CHANGE `activation` `activation` varchar(32) NOT NULL default ''; ALTER TABLE `tl_member_group` CHANGE `name` `name` varchar(255) NOT NULL default ''; ALTER TABLE `tl_member_group` CHANGE `redirect` `redirect` char(1) NOT NULL default ''; ALTER TABLE `tl_member_group` CHANGE `disable` `disable` char(1) NOT NULL default ''; ALTER TABLE `tl_member_group` CHANGE `start` `start` varchar(10) NOT NULL default ''; ALTER TABLE `tl_member_group` CHANGE `stop` `stop` varchar(10) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `name` `name` varchar(255) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `headline` `headline` varchar(255) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `type` `type` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `hardLimit` `hardLimit` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `showProtected` `showProtected` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `defineRoot` `defineRoot` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `navigationTpl` `navigationTpl` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `customTpl` `customTpl` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `showHidden` `showHidden` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `customLabel` `customLabel` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `autologin` `autologin` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `redirectBack` `redirectBack` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `cols` `cols` varchar(32) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `memberTpl` `memberTpl` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `tableless` `tableless` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `queryType` `queryType` varchar(32) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `fuzzy` `fuzzy` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `searchType` `searchType` varchar(32) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `searchTpl` `searchTpl` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `inColumn` `inColumn` varchar(32) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `loadFirst` `loadFirst` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `size` `size` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `transparent` `transparent` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `flashvars` `flashvars` varchar(255) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `altContent` `altContent` text NULL; ALTER TABLE `tl_module` CHANGE `source` `source` varchar(32) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `url` `url` varchar(255) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `interactive` `interactive` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `flashID` `flashID` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `flashJS` `flashJS` text NULL; ALTER TABLE `tl_module` CHANGE `imgSize` `imgSize` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `useCaption` `useCaption` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `fullsize` `fullsize` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `html` `html` text NULL; ALTER TABLE `tl_module` CHANGE `rss_feed` `rss_feed` text NULL; ALTER TABLE `tl_module` CHANGE `rss_template` `rss_template` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `disableCaptcha` `disableCaptcha` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `reg_allowLogin` `reg_allowLogin` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `reg_skipName` `reg_skipName` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `reg_close` `reg_close` varchar(32) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `reg_assignDir` `reg_assignDir` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `reg_activate` `reg_activate` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `reg_text` `reg_text` text NULL; ALTER TABLE `tl_module` CHANGE `reg_password` `reg_password` text NULL; ALTER TABLE `tl_module` CHANGE `protected` `protected` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `guests` `guests` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `cssID` `cssID` varchar(255) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `space` `space` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `cal_calendar` `cal_calendar` text NULL; ALTER TABLE `tl_module` CHANGE `cal_noSpan` `cal_noSpan` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `cal_format` `cal_format` varchar(32) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `cal_ignoreDynamic` `cal_ignoreDynamic` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `cal_order` `cal_order` varchar(32) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `cal_template` `cal_template` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `cal_ctemplate` `cal_ctemplate` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `cal_showQuantity` `cal_showQuantity` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `regtype` `regtype` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `cal_holiday` `cal_holiday` text NULL; ALTER TABLE `tl_module` CHANGE `show_holiday` `show_holiday` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `pubTimeRecurrences` `pubTimeRecurrences` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `cal_format_ext` `cal_format_ext` varchar(128) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `displayDuration` `displayDuration` varchar(128) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `showOnlyNext` `showOnlyNext` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `showRecurrences` `showRecurrences` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `use_horizontal` `use_horizontal` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `use_navigation` `use_navigation` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `showDate` `showDate` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `linkCurrent` `linkCurrent` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `hideEmptyDays` `hideEmptyDays` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `cal_times` `cal_times` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `cal_times_range` `cal_times_range` text NULL; ALTER TABLE `tl_module` CHANGE `cellhight` `cellhight` varchar(10) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `hide_started` `hide_started` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `range_date` `range_date` text NULL; ALTER TABLE `tl_module` CHANGE `com_order` `com_order` varchar(32) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `com_moderate` `com_moderate` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `com_bbcode` `com_bbcode` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `com_requireLogin` `com_requireLogin` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `com_disableCaptcha` `com_disableCaptcha` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `com_template` `com_template` varchar(32) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `list_formdata` `list_formdata` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `list_where` `list_where` varchar(255) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `list_sort` `list_sort` varchar(255) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `list_fields` `list_fields` varchar(255) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `efg_list_searchtype` `efg_list_searchtype` varchar(32) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `list_search` `list_search` varchar(255) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `list_info` `list_info` varchar(255) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `efg_list_access` `efg_list_access` varchar(32) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `efg_fe_edit_access` `efg_fe_edit_access` varchar(32) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `efg_fe_delete_access` `efg_fe_delete_access` varchar(32) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `efg_fe_export_access` `efg_fe_export_access` varchar(32) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `efg_DetailsKey` `efg_DetailsKey` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `efg_iconfolder` `efg_iconfolder` varchar(255) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `efg_fe_keep_id` `efg_fe_keep_id` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `efg_fe_no_formatted_mail` `efg_fe_no_formatted_mail` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `efg_fe_no_confirmation_mail` `efg_fe_no_confirmation_mail` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `efg_com_allow_comments` `efg_com_allow_comments` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `efg_com_notify` `efg_com_notify` varchar(32) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `list_table` `list_table` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `list_info_where` `list_info_where` varchar(255) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `list_layout` `list_layout` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `list_info_layout` `list_info_layout` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `news_featured` `news_featured` varchar(16) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `news_jumpToCurrent` `news_jumpToCurrent` varchar(16) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `news_metaFields` `news_metaFields` varchar(255) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `news_template` `news_template` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `news_format` `news_format` varchar(32) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `news_order` `news_order` varchar(255) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `news_showQuantity` `news_showQuantity` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `nl_hideChannels` `nl_hideChannels` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `nl_subscribe` `nl_subscribe` text NULL; ALTER TABLE `tl_module` CHANGE `nl_unsubscribe` `nl_unsubscribe` text NULL; ALTER TABLE `tl_module` CHANGE `nl_template` `nl_template` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_content_type` `rsts_content_type` varchar(64) NOT NULL default 'rsts_default'; ALTER TABLE `tl_module` CHANGE `rsts_import_settings` `rsts_import_settings` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_template` `rsts_template` varchar(32) NOT NULL default 'rsts_default'; ALTER TABLE `tl_module` CHANGE `rsts_type` `rsts_type` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_direction` `rsts_direction` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_random` `rsts_random` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_loop` `rsts_loop` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_centerContent` `rsts_centerContent` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_skin` `rsts_skin` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_width` `rsts_width` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_height` `rsts_height` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_gapSize` `rsts_gapSize` varchar(64) NOT NULL default '0%'; ALTER TABLE `tl_module` CHANGE `rsts_videoAutoplay` `rsts_videoAutoplay` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_autoplayProgress` `rsts_autoplayProgress` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_pauseAutoplayOnHover` `rsts_pauseAutoplayOnHover` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_navType` `rsts_navType` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_controls` `rsts_controls` char(1) NOT NULL default '1'; ALTER TABLE `tl_module` CHANGE `rsts_thumbControls` `rsts_thumbControls` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_invertControls` `rsts_invertControls` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_scaleMode` `rsts_scaleMode` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_imagePosition` `rsts_imagePosition` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_deepLinkPrefix` `rsts_deepLinkPrefix` varchar(255) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_keyboard` `rsts_keyboard` char(1) NOT NULL default '1'; ALTER TABLE `tl_module` CHANGE `rsts_captions` `rsts_captions` char(1) NOT NULL default '1'; ALTER TABLE `tl_module` CHANGE `rsts_thumbs` `rsts_thumbs` char(1) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_thumbs_width` `rsts_thumbs_width` varchar(64) NOT NULL default '100%'; ALTER TABLE `tl_module` CHANGE `rsts_thumbs_height` `rsts_thumbs_height` varchar(64) NOT NULL default '1x1'; ALTER TABLE `tl_module` CHANGE `rsts_thumbs_gapSize` `rsts_thumbs_gapSize` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_thumbs_scaleMode` `rsts_thumbs_scaleMode` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_thumbs_imagePosition` `rsts_thumbs_imagePosition` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_thumbs_controls` `rsts_thumbs_controls` char(1) NOT NULL default '1'; ALTER TABLE `tl_module` CHANGE `rsts_thumbs_imgSize` `rsts_thumbs_imgSize` varchar(64) NOT NULL default 'a:3:{i:0;s:2:"50";i:1;s:2:"50";i:2;s:4:"crop";}'; ALTER TABLE `tl_module` CHANGE `rsts_thumbs_rowSlideRatio` `rsts_thumbs_rowSlideRatio` varchar(255) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_rowSlideRatio` `rsts_rowSlideRatio` varchar(255) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_combineNavItems` `rsts_combineNavItems` char(1) NOT NULL default '1'; ALTER TABLE `tl_module` CHANGE `rsts_customSkin` `rsts_customSkin` varchar(64) NOT NULL default ''; ALTER TABLE `tl_module` CHANGE `rsts_cssPrefix` `rsts_cssPrefix` varchar(64) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `title` `title` varchar(255) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `type` `type` varchar(32) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `pageTitle` `pageTitle` varchar(255) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `language` `language` varchar(5) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `robots` `robots` varchar(32) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `description` `description` text NULL; ALTER TABLE `tl_page` CHANGE `redirect` `redirect` varchar(32) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `url` `url` varchar(255) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `target` `target` char(1) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `dns` `dns` varchar(255) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `staticFiles` `staticFiles` varchar(255) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `staticPlugins` `staticPlugins` varchar(255) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `fallback` `fallback` char(1) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `adminEmail` `adminEmail` varchar(255) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `dateFormat` `dateFormat` varchar(32) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `timeFormat` `timeFormat` varchar(32) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `datimFormat` `datimFormat` varchar(32) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `createSitemap` `createSitemap` char(1) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `sitemapName` `sitemapName` varchar(32) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `useSSL` `useSSL` char(1) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `autoforward` `autoforward` char(1) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `protected` `protected` char(1) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `includeLayout` `includeLayout` char(1) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `includeCache` `includeCache` char(1) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `includeChmod` `includeChmod` char(1) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `chmod` `chmod` varchar(255) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `noSearch` `noSearch` char(1) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `cssClass` `cssClass` varchar(64) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `sitemap` `sitemap` varchar(32) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `hide` `hide` char(1) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `guests` `guests` char(1) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `accesskey` `accesskey` char(1) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `published` `published` char(1) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `start` `start` varchar(10) NOT NULL default ''; ALTER TABLE `tl_page` CHANGE `stop` `stop` varchar(10) NOT NULL default ''; ALTER TABLE `tl_search_index` CHANGE `language` `language` varchar(5) NOT NULL default ''; ALTER TABLE `tl_session` CHANGE `name` `name` varchar(255) NOT NULL default ''; ALTER TABLE `tl_session` CHANGE `sessionID` `sessionID` varchar(128) NOT NULL default ''; ALTER TABLE `tl_session` CHANGE `hash` `hash` varchar(40) NULL; ALTER TABLE `tl_session` CHANGE `ip` `ip` varchar(64) NOT NULL default ''; ALTER TABLE `tl_session` CHANGE `su` `su` char(1) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `selector` `selector` varchar(1022) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `category` `category` varchar(32) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `comment` `comment` varchar(255) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `size` `size` char(1) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `width` `width` varchar(64) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `height` `height` varchar(64) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `minwidth` `minwidth` varchar(64) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `minheight` `minheight` varchar(64) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `maxwidth` `maxwidth` varchar(64) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `maxheight` `maxheight` varchar(64) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `positioning` `positioning` char(1) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `trbl` `trbl` varchar(128) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `position` `position` varchar(32) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `floating` `floating` varchar(32) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `clear` `clear` varchar(32) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `overflow` `overflow` varchar(32) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `display` `display` varchar(32) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `alignment` `alignment` char(1) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `margin` `margin` varchar(128) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `padding` `padding` varchar(128) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `align` `align` varchar(32) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `verticalalign` `verticalalign` varchar(32) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `textalign` `textalign` varchar(32) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `whitespace` `whitespace` varchar(8) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `background` `background` char(1) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `bgcolor` `bgcolor` varchar(64) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `bgimage` `bgimage` varchar(255) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `bgposition` `bgposition` varchar(32) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `bgrepeat` `bgrepeat` varchar(32) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `shadowsize` `shadowsize` varchar(128) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `shadowcolor` `shadowcolor` varchar(64) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `gradientAngle` `gradientAngle` varchar(32) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `gradientColors` `gradientColors` varchar(128) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `border` `border` char(1) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `borderwidth` `borderwidth` varchar(128) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `borderstyle` `borderstyle` varchar(32) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `bordercolor` `bordercolor` varchar(64) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `borderradius` `borderradius` varchar(128) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `bordercollapse` `bordercollapse` varchar(32) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `borderspacing` `borderspacing` varchar(64) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `font` `font` char(1) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `fontfamily` `fontfamily` varchar(255) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `fontsize` `fontsize` varchar(64) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `fontcolor` `fontcolor` varchar(64) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `lineheight` `lineheight` varchar(64) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `fontstyle` `fontstyle` varchar(255) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `texttransform` `texttransform` varchar(32) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `textindent` `textindent` varchar(64) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `letterspacing` `letterspacing` varchar(64) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `wordspacing` `wordspacing` varchar(64) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `list` `list` char(1) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `liststyletype` `liststyletype` varchar(32) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `liststyleimage` `liststyleimage` varchar(255) NOT NULL default ''; ALTER TABLE `tl_style` CHANGE `own` `own` text NULL; ALTER TABLE `tl_style` CHANGE `invisible` `invisible` char(1) NOT NULL default ''; ALTER TABLE `tl_style_sheet` CHANGE `name` `name` varchar(64) NULL; ALTER TABLE `tl_style_sheet` CHANGE `disablePie` `disablePie` char(1) NOT NULL default ''; ALTER TABLE `tl_style_sheet` CHANGE `cc` `cc` varchar(32) NOT NULL default ''; ALTER TABLE `tl_style_sheet` CHANGE `media` `media` varchar(255) NOT NULL default ''; ALTER TABLE `tl_style_sheet` CHANGE `mediaQuery` `mediaQuery` text NULL; ALTER TABLE `tl_style_sheet` CHANGE `vars` `vars` text NULL; ALTER TABLE `tl_theme` CHANGE `name` `name` varchar(128) NOT NULL default ''; ALTER TABLE `tl_theme` CHANGE `author` `author` varchar(128) NOT NULL default ''; ALTER TABLE `tl_theme` CHANGE `templates` `templates` varchar(255) NOT NULL default ''; ALTER TABLE `tl_theme` CHANGE `vars` `vars` text NULL; ALTER TABLE `tl_undo` CHANGE `fromTable` `fromTable` varchar(255) NOT NULL default ''; ALTER TABLE `tl_undo` CHANGE `query` `query` text NULL; ALTER TABLE `tl_user` CHANGE `name` `name` varchar(255) NOT NULL default ''; ALTER TABLE `tl_user` CHANGE `email` `email` varchar(255) NOT NULL default ''; ALTER TABLE `tl_user` CHANGE `language` `language` varchar(5) NOT NULL default ''; ALTER TABLE `tl_user` CHANGE `backendTheme` `backendTheme` varchar(32) NOT NULL default ''; ALTER TABLE `tl_user` CHANGE `uploader` `uploader` varchar(32) NOT NULL default ''; ALTER TABLE `tl_user` CHANGE `showHelp` `showHelp` char(1) NOT NULL default ''; ALTER TABLE `tl_user` CHANGE `thumbnails` `thumbnails` char(1) NOT NULL default ''; ALTER TABLE `tl_user` CHANGE `useRTE` `useRTE` char(1) NOT NULL default ''; ALTER TABLE `tl_user` CHANGE `useCE` `useCE` char(1) NOT NULL default ''; ALTER TABLE `tl_user` CHANGE `password` `password` varchar(128) NOT NULL default ''; ALTER TABLE `tl_user` CHANGE `pwChange` `pwChange` char(1) NOT NULL default ''; ALTER TABLE `tl_user` CHANGE `admin` `admin` char(1) NOT NULL default ''; ALTER TABLE `tl_user` CHANGE `inherit` `inherit` varchar(12) NOT NULL default ''; ALTER TABLE `tl_user` CHANGE `disable` `disable` char(1) NOT NULL default ''; ALTER TABLE `tl_user` CHANGE `start` `start` varchar(10) NOT NULL default ''; ALTER TABLE `tl_user` CHANGE `stop` `stop` varchar(10) NOT NULL default ''; ALTER TABLE `tl_user_group` CHANGE `name` `name` varchar(255) NOT NULL default ''; ALTER TABLE `tl_user_group` CHANGE `disable` `disable` char(1) NOT NULL default ''; ALTER TABLE `tl_user_group` CHANGE `start` `start` varchar(10) NOT NULL default ''; ALTER TABLE `tl_user_group` CHANGE `stop` `stop` varchar(10) NOT NULL default ''; ALTER TABLE `tl_version` CHANGE `fromTable` `fromTable` varchar(255) NOT NULL default ''; ALTER TABLE `tl_version` CHANGE `username` `username` varchar(64) NULL; ALTER TABLE `tl_version` CHANGE `description` `description` varchar(255) NOT NULL default ''; ALTER TABLE `tl_version` CHANGE `editUrl` `editUrl` varchar(255) NOT NULL default ''; ALTER TABLE `tl_version` CHANGE `active` `active` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `title` `title` varchar(255) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `protected` `protected` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `allowComments` `allowComments` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `notify` `notify` varchar(32) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `sortOrder` `sortOrder` varchar(32) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `moderate` `moderate` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `bbcode` `bbcode` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `requireLogin` `requireLogin` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `disableCaptcha` `disableCaptcha` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `bg_color` `bg_color` varchar(64) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `fg_color` `fg_color` varchar(64) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `isHolidayCal` `isHolidayCal` char(1) NOT NULL default '0'; ALTER TABLE `tl_calendar` CHANGE `allowEvents` `allowEvents` char(1) NOT NULL default '0'; ALTER TABLE `tl_calendar` CHANGE `uniqueEvents` `uniqueEvents` char(1) NOT NULL default '0'; ALTER TABLE `tl_calendar` CHANGE `make_ical` `make_ical` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `ical_timezone` `ical_timezone` varchar(128) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `ical_source` `ical_source` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `ical_prefix` `ical_prefix` varchar(128) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `ical_description` `ical_description` text NULL; ALTER TABLE `tl_calendar` CHANGE `ical_url` `ical_url` text NULL; ALTER TABLE `tl_calendar` CHANGE `ical_start` `ical_start` varchar(12) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `ical_end` `ical_end` varchar(12) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `ical_source_start` `ical_source_start` varchar(12) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `ical_source_end` `ical_source_end` varchar(12) NOT NULL default ''; ALTER TABLE `tl_calendar` CHANGE `ical_importing` `ical_importing` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `title` `title` varchar(255) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `addTime` `addTime` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `location` `location` varchar(255) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `teaser` `teaser` text NULL; ALTER TABLE `tl_calendar_events` CHANGE `addImage` `addImage` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `alt` `alt` varchar(255) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `size` `size` varchar(64) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `imagemargin` `imagemargin` varchar(128) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `imageUrl` `imageUrl` varchar(255) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `fullsize` `fullsize` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `caption` `caption` varchar(255) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `floating` `floating` varchar(32) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `recurring` `recurring` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `repeatEach` `repeatEach` varchar(64) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `addEnclosure` `addEnclosure` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `source` `source` varchar(32) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `url` `url` varchar(255) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `target` `target` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `cssClass` `cssClass` varchar(255) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `noComments` `noComments` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `published` `published` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `start` `start` varchar(10) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `stop` `stop` varchar(10) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `repeatWeekday` `repeatWeekday` varchar(128) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `ignoreEndTime` `ignoreEndTime` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `useExceptions` `useExceptions` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `showOnFreeDay` `showOnFreeDay` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `weekday` `weekday` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `hideOnWeekend` `hideOnWeekend` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `useRegistration` `useRegistration` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `regconfirm` `regconfirm` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `regperson` `regperson` text NULL; ALTER TABLE `tl_calendar_events` CHANGE `recurringExt` `recurringExt` char(1) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `location_name` `location_name` varchar(255) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `location_str` `location_str` varchar(255) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `location_plz` `location_plz` varchar(10) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `location_ort` `location_ort` varchar(255) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `location_link` `location_link` varchar(255) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `location_contact` `location_contact` varchar(255) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `location_mail` `location_mail` varchar(255) NOT NULL default ''; ALTER TABLE `tl_calendar_events` CHANGE `repeatEachExt` `repeatEachExt` text NULL; ALTER TABLE `tl_calendar_events` CHANGE `repeatExceptions` `repeatExceptions` text NULL; ALTER TABLE `tl_calendar_events` CHANGE `repeatExceptionsInt` `repeatExceptionsInt` text NULL; ALTER TABLE `tl_calendar_events` CHANGE `repeatExceptionsPer` `repeatExceptionsPer` text NULL; ALTER TABLE `tl_calendar_events` CHANGE `repeatDates` `repeatDates` text NULL; ALTER TABLE `tl_calendar_events` CHANGE `allRecurrences` `allRecurrences` text NULL; ALTER TABLE `tl_calendar_events` CHANGE `exceptionList` `exceptionList` text NULL; ALTER TABLE `tl_calendar_feed` CHANGE `title` `title` varchar(255) NOT NULL default ''; ALTER TABLE `tl_calendar_feed` CHANGE `language` `language` varchar(32) NOT NULL default ''; ALTER TABLE `tl_calendar_feed` CHANGE `format` `format` varchar(32) NOT NULL default ''; ALTER TABLE `tl_calendar_feed` CHANGE `source` `source` varchar(32) NOT NULL default ''; ALTER TABLE `tl_calendar_feed` CHANGE `feedBase` `feedBase` varchar(255) NOT NULL default ''; ALTER TABLE `tl_calendar_feed` CHANGE `description` `description` text NULL; ALTER TABLE `tl_comments` CHANGE `source` `source` varchar(32) NOT NULL default ''; ALTER TABLE `tl_comments` CHANGE `date` `date` varchar(64) NOT NULL default ''; ALTER TABLE `tl_comments` CHANGE `name` `name` varchar(64) NOT NULL default ''; ALTER TABLE `tl_comments` CHANGE `email` `email` varchar(255) NOT NULL default ''; ALTER TABLE `tl_comments` CHANGE `website` `website` varchar(128) NOT NULL default ''; ALTER TABLE `tl_comments` CHANGE `comment` `comment` text NULL; ALTER TABLE `tl_comments` CHANGE `addReply` `addReply` char(1) NOT NULL default ''; ALTER TABLE `tl_comments` CHANGE `reply` `reply` text NULL; ALTER TABLE `tl_comments` CHANGE `published` `published` char(1) NOT NULL default ''; ALTER TABLE `tl_comments` CHANGE `ip` `ip` varchar(64) NOT NULL default ''; ALTER TABLE `tl_comments` CHANGE `notified` `notified` char(1) NOT NULL default ''; ALTER TABLE `tl_comments_notify` CHANGE `source` `source` varchar(32) NOT NULL default ''; ALTER TABLE `tl_comments_notify` CHANGE `name` `name` varchar(128) NOT NULL default ''; ALTER TABLE `tl_comments_notify` CHANGE `email` `email` varchar(128) NOT NULL default ''; ALTER TABLE `tl_comments_notify` CHANGE `url` `url` varchar(255) NOT NULL default ''; ALTER TABLE `tl_comments_notify` CHANGE `addedOn` `addedOn` varchar(10) NOT NULL default ''; ALTER TABLE `tl_comments_notify` CHANGE `ip` `ip` varchar(64) NOT NULL default ''; ALTER TABLE `tl_comments_notify` CHANGE `tokenConfirm` `tokenConfirm` varchar(32) NOT NULL default ''; ALTER TABLE `tl_comments_notify` CHANGE `tokenRemove` `tokenRemove` varchar(32) NOT NULL default ''; ALTER TABLE `tl_extension` CHANGE `title` `title` varchar(64) NOT NULL default ''; ALTER TABLE `tl_extension` CHANGE `folder` `folder` varchar(48) NOT NULL default ''; ALTER TABLE `tl_extension` CHANGE `author` `author` varchar(128) NOT NULL default ''; ALTER TABLE `tl_extension` CHANGE `copyright` `copyright` varchar(128) NOT NULL default ''; ALTER TABLE `tl_extension` CHANGE `package` `package` varchar(64) NOT NULL default ''; ALTER TABLE `tl_extension` CHANGE `license` `license` varchar(64) NOT NULL default ''; ALTER TABLE `tl_extension` CHANGE `addBeMod` `addBeMod` char(1) NOT NULL default ''; ALTER TABLE `tl_extension` CHANGE `beClasses` `beClasses` varchar(255) NOT NULL default ''; ALTER TABLE `tl_extension` CHANGE `beTables` `beTables` varchar(255) NOT NULL default ''; ALTER TABLE `tl_extension` CHANGE `beTemplates` `beTemplates` varchar(255) NOT NULL default ''; ALTER TABLE `tl_extension` CHANGE `addFeMod` `addFeMod` char(1) NOT NULL default ''; ALTER TABLE `tl_extension` CHANGE `feClasses` `feClasses` varchar(255) NOT NULL default ''; ALTER TABLE `tl_extension` CHANGE `feTables` `feTables` varchar(255) NOT NULL default ''; ALTER TABLE `tl_extension` CHANGE `feTemplates` `feTemplates` varchar(255) NOT NULL default ''; ALTER TABLE `tl_extension` CHANGE `addLanguage` `addLanguage` char(1) NOT NULL default ''; ALTER TABLE `tl_extension` CHANGE `languages` `languages` varchar(255) NOT NULL default ''; ALTER TABLE `tl_formdata` CHANGE `form` `form` varchar(64) NOT NULL default ''; ALTER TABLE `tl_formdata` CHANGE `ip` `ip` varchar(64) NOT NULL default ''; ALTER TABLE `tl_formdata` CHANGE `published` `published` char(1) NOT NULL default ''; ALTER TABLE `tl_formdata` CHANGE `alias` `alias` varchar(64) NOT NULL default ''; ALTER TABLE `tl_formdata` CHANGE `confirmationSent` `confirmationSent` char(1) NOT NULL default ''; ALTER TABLE `tl_formdata` CHANGE `confirmationDate` `confirmationDate` varchar(10) NOT NULL default ''; ALTER TABLE `tl_formdata` CHANGE `be_notes` `be_notes` text NULL; ALTER TABLE `tl_formdata_details` CHANGE `ff_name` `ff_name` varchar(64) NOT NULL default ''; ALTER TABLE `tl_formdata_details` CHANGE `value` `value` text NULL; ALTER TABLE `tl_faq` CHANGE `question` `question` varchar(255) NOT NULL default ''; ALTER TABLE `tl_faq` CHANGE `answer` `answer` text NULL; ALTER TABLE `tl_faq` CHANGE `addImage` `addImage` char(1) NOT NULL default ''; ALTER TABLE `tl_faq` CHANGE `alt` `alt` varchar(255) NOT NULL default ''; ALTER TABLE `tl_faq` CHANGE `size` `size` varchar(64) NOT NULL default ''; ALTER TABLE `tl_faq` CHANGE `imagemargin` `imagemargin` varchar(128) NOT NULL default ''; ALTER TABLE `tl_faq` CHANGE `imageUrl` `imageUrl` varchar(255) NOT NULL default ''; ALTER TABLE `tl_faq` CHANGE `fullsize` `fullsize` char(1) NOT NULL default ''; ALTER TABLE `tl_faq` CHANGE `caption` `caption` varchar(255) NOT NULL default ''; ALTER TABLE `tl_faq` CHANGE `floating` `floating` varchar(12) NOT NULL default ''; ALTER TABLE `tl_faq` CHANGE `addEnclosure` `addEnclosure` char(1) NOT NULL default ''; ALTER TABLE `tl_faq` CHANGE `noComments` `noComments` char(1) NOT NULL default ''; ALTER TABLE `tl_faq` CHANGE `published` `published` char(1) NOT NULL default ''; ALTER TABLE `tl_faq_category` CHANGE `title` `title` varchar(255) NOT NULL default ''; ALTER TABLE `tl_faq_category` CHANGE `headline` `headline` varchar(255) NOT NULL default ''; ALTER TABLE `tl_faq_category` CHANGE `allowComments` `allowComments` char(1) NOT NULL default ''; ALTER TABLE `tl_faq_category` CHANGE `notify` `notify` varchar(16) NOT NULL default ''; ALTER TABLE `tl_faq_category` CHANGE `sortOrder` `sortOrder` varchar(12) NOT NULL default ''; ALTER TABLE `tl_faq_category` CHANGE `moderate` `moderate` char(1) NOT NULL default ''; ALTER TABLE `tl_faq_category` CHANGE `bbcode` `bbcode` char(1) NOT NULL default ''; ALTER TABLE `tl_faq_category` CHANGE `requireLogin` `requireLogin` char(1) NOT NULL default ''; ALTER TABLE `tl_faq_category` CHANGE `disableCaptcha` `disableCaptcha` char(1) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `headline` `headline` varchar(255) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `subheadline` `subheadline` varchar(255) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `teaser` `teaser` text NULL; ALTER TABLE `tl_news` CHANGE `addImage` `addImage` char(1) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `alt` `alt` varchar(255) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `size` `size` varchar(64) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `imagemargin` `imagemargin` varchar(128) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `imageUrl` `imageUrl` varchar(255) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `fullsize` `fullsize` char(1) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `caption` `caption` varchar(255) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `floating` `floating` varchar(12) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `addEnclosure` `addEnclosure` char(1) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `source` `source` varchar(12) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `url` `url` varchar(255) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `target` `target` char(1) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `cssClass` `cssClass` varchar(255) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `noComments` `noComments` char(1) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `featured` `featured` char(1) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `published` `published` char(1) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `start` `start` varchar(10) NOT NULL default ''; ALTER TABLE `tl_news` CHANGE `stop` `stop` varchar(10) NOT NULL default ''; ALTER TABLE `tl_news_archive` CHANGE `title` `title` varchar(255) NOT NULL default ''; ALTER TABLE `tl_news_archive` CHANGE `protected` `protected` char(1) NOT NULL default ''; ALTER TABLE `tl_news_archive` CHANGE `allowComments` `allowComments` char(1) NOT NULL default ''; ALTER TABLE `tl_news_archive` CHANGE `notify` `notify` varchar(16) NOT NULL default ''; ALTER TABLE `tl_news_archive` CHANGE `sortOrder` `sortOrder` varchar(32) NOT NULL default ''; ALTER TABLE `tl_news_archive` CHANGE `moderate` `moderate` char(1) NOT NULL default ''; ALTER TABLE `tl_news_archive` CHANGE `bbcode` `bbcode` char(1) NOT NULL default ''; ALTER TABLE `tl_news_archive` CHANGE `requireLogin` `requireLogin` char(1) NOT NULL default ''; ALTER TABLE `tl_news_archive` CHANGE `disableCaptcha` `disableCaptcha` char(1) NOT NULL default ''; ALTER TABLE `tl_news_feed` CHANGE `title` `title` varchar(255) NOT NULL default ''; ALTER TABLE `tl_news_feed` CHANGE `language` `language` varchar(32) NOT NULL default ''; ALTER TABLE `tl_news_feed` CHANGE `format` `format` varchar(32) NOT NULL default ''; ALTER TABLE `tl_news_feed` CHANGE `source` `source` varchar(32) NOT NULL default ''; ALTER TABLE `tl_news_feed` CHANGE `feedBase` `feedBase` varchar(255) NOT NULL default ''; ALTER TABLE `tl_news_feed` CHANGE `description` `description` text NULL; ALTER TABLE `tl_newsletter` CHANGE `subject` `subject` varchar(255) NOT NULL default ''; ALTER TABLE `tl_newsletter` CHANGE `content` `content` mediumtext NULL; ALTER TABLE `tl_newsletter` CHANGE `text` `text` mediumtext NULL; ALTER TABLE `tl_newsletter` CHANGE `addFile` `addFile` char(1) NOT NULL default ''; ALTER TABLE `tl_newsletter` CHANGE `template` `template` varchar(64) NOT NULL default ''; ALTER TABLE `tl_newsletter` CHANGE `sendText` `sendText` char(1) NOT NULL default ''; ALTER TABLE `tl_newsletter` CHANGE `externalImages` `externalImages` char(1) NOT NULL default ''; ALTER TABLE `tl_newsletter` CHANGE `sender` `sender` varchar(128) NOT NULL default ''; ALTER TABLE `tl_newsletter` CHANGE `senderName` `senderName` varchar(128) NOT NULL default ''; ALTER TABLE `tl_newsletter` CHANGE `sent` `sent` char(1) NOT NULL default ''; ALTER TABLE `tl_newsletter` CHANGE `date` `date` varchar(10) NOT NULL default ''; ALTER TABLE `tl_newsletter_channel` CHANGE `title` `title` varchar(255) NOT NULL default ''; ALTER TABLE `tl_newsletter_channel` CHANGE `useSMTP` `useSMTP` char(1) NOT NULL default ''; ALTER TABLE `tl_newsletter_channel` CHANGE `smtpHost` `smtpHost` varchar(64) NOT NULL default ''; ALTER TABLE `tl_newsletter_channel` CHANGE `smtpUser` `smtpUser` varchar(128) NOT NULL default ''; ALTER TABLE `tl_newsletter_channel` CHANGE `smtpPass` `smtpPass` varchar(32) NOT NULL default ''; ALTER TABLE `tl_newsletter_channel` CHANGE `smtpEnc` `smtpEnc` varchar(3) NOT NULL default ''; ALTER TABLE `tl_newsletter_recipients` CHANGE `email` `email` varchar(255) NOT NULL default ''; ALTER TABLE `tl_newsletter_recipients` CHANGE `active` `active` char(1) NOT NULL default ''; ALTER TABLE `tl_newsletter_recipients` CHANGE `addedOn` `addedOn` varchar(10) NOT NULL default ''; ALTER TABLE `tl_newsletter_recipients` CHANGE `confirmed` `confirmed` varchar(10) NOT NULL default ''; ALTER TABLE `tl_newsletter_recipients` CHANGE `ip` `ip` varchar(64) NOT NULL default ''; ALTER TABLE `tl_newsletter_recipients` CHANGE `token` `token` varchar(32) NOT NULL default ''; ALTER TABLE `tl_repository_installs` CHANGE `extension` `extension` varchar(32) NOT NULL default ''; ALTER TABLE `tl_repository_installs` CHANGE `alpha` `alpha` char(1) NOT NULL default ''; ALTER TABLE `tl_repository_installs` CHANGE `beta` `beta` char(1) NOT NULL default ''; ALTER TABLE `tl_repository_installs` CHANGE `rc` `rc` char(1) NOT NULL default ''; ALTER TABLE `tl_repository_installs` CHANGE `stable` `stable` char(1) NOT NULL default '1'; ALTER TABLE `tl_repository_installs` CHANGE `lickey` `lickey` varchar(255) NOT NULL default ''; ALTER TABLE `tl_repository_installs` CHANGE `delprot` `delprot` char(1) NOT NULL default ''; ALTER TABLE `tl_repository_installs` CHANGE `updprot` `updprot` char(1) NOT NULL default ''; ALTER TABLE `tl_repository_installs` CHANGE `error` `error` char(1) NOT NULL default ''; ALTER TABLE `tl_repository_instfiles` CHANGE `filename` `filename` varchar(255) NOT NULL default ''; ALTER TABLE `tl_repository_instfiles` CHANGE `filetype` `filetype` char(1) NOT NULL default 'F'; ALTER TABLE `tl_repository_instfiles` CHANGE `flag` `flag` char(1) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `title` `title` varchar(255) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `type` `type` varchar(255) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `videoURL` `videoURL` varchar(255) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `thumbTitle` `thumbTitle` varchar(255) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `thumbClass` `thumbClass` varchar(255) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `thumbText` `thumbText` mediumtext NULL; ALTER TABLE `tl_rocksolid_slide` CHANGE `scaleMode` `scaleMode` varchar(64) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `imagePosition` `imagePosition` varchar(64) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `centerContent` `centerContent` varchar(64) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `invertControls` `invertControls` char(1) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `linkUrl` `linkUrl` varchar(255) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `linkNewWindow` `linkNewWindow` char(1) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `backgroundImageSize` `backgroundImageSize` varchar(64) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `backgroundScaleMode` `backgroundScaleMode` varchar(64) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `backgroundPosition` `backgroundPosition` varchar(64) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `slideClass` `slideClass` varchar(255) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `sliderClass` `sliderClass` varchar(255) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `published` `published` char(1) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `start` `start` varchar(10) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slide` CHANGE `stop` `stop` varchar(10) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slider` CHANGE `name` `name` varchar(255) NOT NULL default ''; ALTER TABLE `tl_rocksolid_slider` CHANGE `type` `type` varchar(255) NOT NULL default ''; ALTER TABLE `tl_survey` CHANGE `title` `title` varchar(255) NOT NULL default ''; ALTER TABLE `tl_survey` CHANGE `language` `language` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey` CHANGE `online_start` `online_start` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey` CHANGE `online_end` `online_end` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey` CHANGE `description` `description` text NULL; ALTER TABLE `tl_survey` CHANGE `access` `access` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey` CHANGE `usecookie` `usecookie` char(1) NOT NULL default ''; ALTER TABLE `tl_survey` CHANGE `limit_groups` `limit_groups` char(1) NOT NULL default '0'; ALTER TABLE `tl_survey` CHANGE `show_title` `show_title` char(1) NOT NULL default '1'; ALTER TABLE `tl_survey` CHANGE `show_cancel` `show_cancel` char(1) NOT NULL default '1'; ALTER TABLE `tl_survey` CHANGE `introduction` `introduction` text NOT NULL; ALTER TABLE `tl_survey` CHANGE `finalsubmission` `finalsubmission` text NOT NULL; ALTER TABLE `tl_survey` CHANGE `allowback` `allowback` char(1) NOT NULL default ''; ALTER TABLE `tl_survey_page` CHANGE `title` `title` varchar(255) NOT NULL default ''; ALTER TABLE `tl_survey_page` CHANGE `description` `description` text NULL; ALTER TABLE `tl_survey_page` CHANGE `language` `language` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey_page` CHANGE `introduction` `introduction` text NOT NULL; ALTER TABLE `tl_survey_page` CHANGE `page_template` `page_template` varchar(255) NOT NULL default 'survey_questionblock'; ALTER TABLE `tl_survey_page` CHANGE `pagetype` `pagetype` varchar(30) NOT NULL default 'standard'; ALTER TABLE `tl_survey_participant` CHANGE `pin` `pin` varchar(16) NOT NULL default ''; ALTER TABLE `tl_survey_participant` CHANGE `finished` `finished` char(1) NOT NULL default ''; ALTER TABLE `tl_survey_participant` CHANGE `email` `email` varchar(255) NOT NULL default ''; ALTER TABLE `tl_survey_participant` CHANGE `firstname` `firstname` varchar(255) NOT NULL default ''; ALTER TABLE `tl_survey_participant` CHANGE `lastname` `lastname` varchar(255) NOT NULL default ''; ALTER TABLE `tl_survey_participant` CHANGE `company` `company` varchar(255) NOT NULL default ''; ALTER TABLE `tl_survey_pin_tan` CHANGE `pin` `pin` varchar(16) NOT NULL default ''; ALTER TABLE `tl_survey_pin_tan` CHANGE `tan` `tan` varchar(16) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `questiontype` `questiontype` varchar(20) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `title` `title` varchar(255) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `description` `description` text NULL; ALTER TABLE `tl_survey_question` CHANGE `language` `language` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `question` `question` text NOT NULL; ALTER TABLE `tl_survey_question` CHANGE `introduction` `introduction` text NOT NULL; ALTER TABLE `tl_survey_question` CHANGE `obligatory` `obligatory` char(1) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `complete` `complete` char(1) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `original` `original` char(1) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `help` `help` varchar(255) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `hidetitle` `hidetitle` char(1) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `lower_bound` `lower_bound` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `upper_bound` `upper_bound` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `lower_bound_date` `lower_bound_date` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `upper_bound_date` `upper_bound_date` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `lower_bound_time` `lower_bound_time` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `upper_bound_time` `upper_bound_time` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `openended_subtype` `openended_subtype` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `openended_textbefore` `openended_textbefore` varchar(150) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `openended_textafter` `openended_textafter` varchar(150) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `openended_width` `openended_width` varchar(4) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `openended_maxlen` `openended_maxlen` varchar(5) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `openended_textinside` `openended_textinside` varchar(150) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `multiplechoice_subtype` `multiplechoice_subtype` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `matrix_subtype` `matrix_subtype` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `mc_style` `mc_style` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `addneutralcolumn` `addneutralcolumn` char(1) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `neutralcolumn` `neutralcolumn` varchar(255) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `addother` `addother` char(1) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `addbipolar` `addbipolar` char(1) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `adjective1` `adjective1` varchar(255) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `adjective2` `adjective2` varchar(255) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `bipolarposition` `bipolarposition` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `othertitle` `othertitle` varchar(150) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `inputfirst` `inputfirst` char(1) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `sumoption` `sumoption` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey_question` CHANGE `cssClass` `cssClass` varchar(255) NOT NULL default ''; ALTER TABLE `tl_survey_result` CHANGE `pin` `pin` varchar(16) NOT NULL default ''; ALTER TABLE `tl_survey_result` CHANGE `result` `result` text NULL; ALTER TABLE `tl_survey_scale` CHANGE `title` `title` varchar(255) NOT NULL default ''; ALTER TABLE `tl_survey_scale` CHANGE `description` `description` text NULL; ALTER TABLE `tl_survey_scale` CHANGE `language` `language` varchar(32) NOT NULL default ''; ALTER TABLE `tl_survey_scale_folder` CHANGE `title` `title` varchar(255) NOT NULL default ''; ALTER TABLE `tl_survey_scale_folder` CHANGE `description` `description` text NULL;
Grüßle
Michael
Aus irgendeinem Grund glaubt Contao, dass die Felder nicht eh schon genau diese Eigenschaften haben. Also aus irgendeinem Grund sind die von Contao ermittelten Eigenschaften der jeweiligen Felder in der Datenbank nicht das, was Contao erwartet.
Und nun?
Muss ich nun alle Tabellen manuell durchschauen oder kann ich die Meldungen einfach ignorieren?
Ergänzung 1:
Ich habe mal alle Zeilen mit phpMyadmin direkt auf der Datenbank ausgeführt.
Aber alle laut Contao zu ändernden Stellen waren in Ordnung.
Meldung: # MySQL lieferte ein leeres Resultat zurück (d.h. null Datensätze).
Ergänzung 2:
Das selbe passiert bei der Aktualisierung in der Erweitungsverwaltung.
Geht man wieder auf die Übersicht der Erweiterungen sind dann doch alle aktualisiert.
Geändert von osterwaldi (23.04.2018 um 18:16 Uhr)
Grüßle
Michael
Danke für deine Mühe.
Dann schau ich mal was bei meiner anderen Seite passiert.
Vielleicht ist es ja auch nur ein kleiner Bug in Contao selbst.
Grüßle
Michael
Aktive Benutzer in diesem Thema: 1 (Registrierte Benutzer: 0, Gäste: 1)
Lesezeichen