Implements #17257 - QFQ System tables with defaults

extension/Classes/Core/Database/DatabaseUpdateData.php

@@ -227,6 +227,62 @@ $UPDATE_ARRAY = array(
         "ALTER TABLE `FormSubmitLog` ADD INDEX IF NOT EXISTS `createdFeUserFormId` (`created`, `feUser`, `formId`);",
     ],
 
+    '23.11.0' => [
+        "ALTER TABLE `Cron` CHANGE `lastStatus` `lastStatus` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `Cron` CHANGE `frequency` `frequency` varchar(32) NOT NULL DEFAULT '';",
+        "ALTER TABLE `Cron` CHANGE `sql1` `sql1` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `Cron` CHANGE `content` `content` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `Cron` CHANGE `comment` `comment` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `Cron` CHANGE `outputFile` `outputFile` varchar(255) NOT NULL DEFAULT '';",
+        "ALTER TABLE `Cron` CHANGE `outputPattern` `outputPattern` varchar(255) NOT NULL DEFAULT '';",
+        "ALTER TABLE `Dirty` CHANGE `sip` `sip` varchar(255) NOT NULL DEFAULT '';",
+        "ALTER TABLE `Dirty` CHANGE `tableName` `tableName` varchar(255) NOT NULL DEFAULT '';",
+        "ALTER TABLE `Dirty` CHANGE `expire` `expire` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';",
+        "ALTER TABLE `Dirty` CHANGE `recordHashMd5` `recordHashMd5` char(32) NOT NULL DEFAULT '';",
+        "ALTER TABLE `Dirty` CHANGE `tabUniqId` `tabUniqId` char(32) NOT NULL DEFAULT '';",
+        "ALTER TABLE `Dirty` CHANGE `feUser` `feUser` varchar(255) NOT NULL DEFAULT '';",
+        "ALTER TABLE `Dirty` CHANGE `qfqUserSessionCookie` `qfqUserSessionCookie` varchar(255) NOT NULL DEFAULT '';",
+        "ALTER TABLE `Dirty` CHANGE `remoteAddress` `remoteAddress` varchar(45) NOT NULL DEFAULT '';",
+        "ALTER TABLE `Form` CHANGE `noteInternal` `noteInternal` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `Form` CHANGE `multiSql` `multiSql` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `Form` CHANGE `parameter` `parameter` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `Form` CHANGE `parameterLanguageA` `parameterLanguageA` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `Form` CHANGE `parameterLanguageB` `parameterLanguageB` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `Form` CHANGE `parameterLanguageC` `parameterLanguageC` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `Form` CHANGE `parameterLanguageD` `parameterLanguageD` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormElement` CHANGE `modeSql` `modeSql` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormElement` CHANGE `note` `note` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormElement` CHANGE `adminNote` `adminNote` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormElement` CHANGE `value` `value` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormElement` CHANGE `sql1` `sql1` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormElement` CHANGE `parameter` `parameter` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormElement` CHANGE `parameterLanguageA` `parameterLanguageA` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormElement` CHANGE `parameterLanguageB` `parameterLanguageB` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormElement` CHANGE `parameterLanguageC` `parameterLanguageC` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormElement` CHANGE `parameterLanguageD` `parameterLanguageD` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormElement` CHANGE `clientJs` `clientJs` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormSubmitLog` CHANGE `formData` `formData` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormSubmitLog` CHANGE `sipData` `sipData` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormSubmitLog` CHANGE `clientIp` `clientIp` varchar(64) NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormSubmitLog` CHANGE `feUser` `feUser` varchar(64) NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormSubmitLog` CHANGE `userAgent` `userAgent` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormSubmitLog` CHANGE `formName` `formName` varchar(255) NOT NULL DEFAULT '';",
+        "ALTER TABLE `FormSubmitLog` CHANGE `pageId` `pageId` int(11) NOT NULL DEFAULT 0;",
+        "ALTER TABLE `FormSubmitLog` CHANGE `sessionId` `sessionId` varchar(32) NOT NULL DEFAULT '';",
+        "ALTER TABLE `MailLog` CHANGE `receiver` `receiver` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `MailLog` CHANGE `cc` `cc` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `MailLog` CHANGE `bcc` `bcc` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `MailLog` CHANGE `body` `body` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `Setting` CHANGE `type` `type` enum('','tablesorter') NOT NULL DEFAULT '';",
+        "ALTER TABLE `Setting` CHANGE `name` `name` varchar(64) NOT NULL DEFAULT '';",
+        "ALTER TABLE `Setting` CHANGE `feUser` `feUser` varchar(32) NOT NULL DEFAULT '' COMMENT 'In case there is no logged in user, take QFQ cookie.';",
+        "ALTER TABLE `Setting` CHANGE `tableId` `tableId` varchar(64) NOT NULL DEFAULT '';",
+        "ALTER TABLE `Setting` CHANGE `view` `view` text NOT NULL DEFAULT '';",
+        "ALTER TABLE `Split` CHANGE `tableName` `tableName` varchar(255) NOT NULL DEFAULT '';",
+        "ALTER TABLE `Split` CHANGE `pathFileName` `pathFileName` varchar(255) NOT NULL DEFAULT '';",
+    ],
+
+
 );