Skip to content
Snippets Groups Projects

ipa_haller_jan: QFQ-Wiki. refs #15634

Merged ipa_haller_jan: QFQ-Wiki. refs #15634
ipa_haller_jan into develop
Merged Jan Haller requested to merge ipa_haller_jan into develop
Viewing commit 5d955488
Prev
Show latest version
2 files
+ 21
− 19
Compare changes
  • Side-by-side
  • Inline
Files
2
extension/Classes/Core/Database/DatabaseUpdateData.php
+ 4
− 2
@@ -227,10 +227,12 @@ $UPDATE_ARRAY = array(
"ALTER TABLE `FormSubmitLog` ADD INDEX IF NOT EXISTS `createdFeUserFormId` (`created`, `feUser`, `formId`);",
],
'23.12.0' => [
'24.1.0.rc1' => [
"CREATE TABLE IF NOT EXISTS `FileUpload` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `pathFileName` VARCHAR(512) NOT NULL, `grId` INT(11) NOT NULL DEFAULT '0', `xId` INT(11) NOT NULL DEFAULT '0', `uploadId` INT(11) NOT NULL, `size` VARCHAR(32) NOT NULL DEFAULT '0' COMMENT 'Filesize in bytes', `type` VARCHAR(64) NOT NULL DEFAULT '', `ord` INT(11) NOT NULL DEFAULT '0', `modified` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `uploadId` (`uploadId`), KEY `pathFileNameGrIdXidUploadId` (`pathFileName`, `grId`, `xId`, `uploadId`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT = 0;",
"CREATE TABLE IF NOT EXISTS `WikiPage` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `wpIdParent` INT(11) DEFAULT NULL, `pageSlug` VARCHAR(255) NOT NULL, `name` VARCHAR(255) NOT NULL, `content` TEXT NOT NULL, `author` VARCHAR(64) NOT NULL, `roUser` VARCHAR(512) NOT NULL, `roGroup` VARCHAR(512) NOT NULL, `roPublic` ENUM ('on','off') NOT NULL, `rwUser` VARCHAR(512) NOT NULL, `rwGroup` VARCHAR(512) NOT NULL, `rwPublic` ENUM ('on','off') NOT NULL, `pageLock` VARCHAR(64) NOT NULL, `imageBorder` ENUM ('none','1pxblack','shadow') NOT NULL DEFAULT 'none', `wpIdCurrent` INT(11) DEFAULT NULL, `modified` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT = 0;",
"CREATE TABLE IF NOT EXISTS `WikiAttachment` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `wpId` INT(11) NOT NULL, `feUser` VARCHAR(64) NOT NULL, `pathFileName` VARCHAR(512) NOT NULL, `modified` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT = 0;"
"CREATE TABLE IF NOT EXISTS `WikiAttachment` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `wpId` INT(11) NOT NULL, `feUser` VARCHAR(64) NOT NULL, `pathFileName` VARCHAR(512) NOT NULL, `modified` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT = 0;",
// Save chat conversations.
"CREATE TABLE IF NOT EXISTS `Chat` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `xId` INT(11) NOT NULL DEFAULT '0', `pIdCreator` INT(11) NOT NULL DEFAULT '0', `pIdTeam` INT(11) NOT NULL DEFAULT '0', `cIdTopic` INT(11) NOT NULL DEFAULT '0', `cIdThread` INT(11) NOT NULL DEFAULT '0', `cIdTag` INT(11) NOT NULL DEFAULT '0', `cIdLastRead` INT(11) NOT NULL DEFAULT '0', `xGrIdStatus` INT(11) NOT NULL DEFAULT '0', `type` ENUM('message','topic','tag','reminder','read') NOT NULL DEFAULT 'message', `message` TEXT NOT NULL DEFAULT '', `username` VARCHAR(128) NOT NULL DEFAULT '', `emoticon` VARCHAR(255) NOT NULL DEFAULT '', `reference` VARCHAR(255) NOT NULL DEFAULT '', `modified` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `xId` (`xId`)) ENGINE = InnoDB DEFAULT CHARSET = utf8;"
],
);