--- /dev/null
+<?xml version="1.0"?>
+<custom-sql>
+ <sql id="selectInternalMessageWithWrongAttachments">
+ <![CDATA[
+ SELECT DISTINCT im.*
+ FROM messagerie_internalattachfile ia
+ JOIN messagerie_internalmessage im ON ia.messageId = im.messageId
+ WHERE im.pjFolderId = 0
+ ]]>
+ </sql>
+ <sql id="updateInternalMessageWithNewPjFolderId">
+ <![CDATA[
+ UPDATE messagerie_internalmessage
+ SET pjFolderId = ?
+ WHERE messageId = ? OR messageSendId = ?
+ ]]>
+ </sql>
+ <sql id="selectFileEntryForAttachments">
+ <![CDATA[
+ SELECT fe.*
+ FROM dlfileentry fe
+ JOIN cartable_dllink cl ON fe.fileEntryId = cl.sourceId
+ WHERE cl.targetId IN (?);
+ ]]>
+ </sql>
+ <sql id="insertFileEntryLinkFromSources">
+ <![CDATA[
+ INSERT INTO `dlfileentry` (`uuid_`, `fileEntryId`, `groupId`, `companyId`, `userId`, `userName`, `versionUserId`, `versionUserName`, `createDate`, `modifiedDate`, `folderId`, `name`, `title`, `description`, `version`, `pendingVersion`, `size_`, `readCount`, `extraSettings`, `extension`, `repositoryId`, `mimeType`, `fileEntryTypeId`, `smallImageId`, `largeImageId`, `custom1ImageId`, `custom2ImageId`)
+ VALUES
+ ]]>
+ </sql>
+ <sql id="selectInternalMessageHeadersForFolderId">
+ <![CDATA[
+ SELECT im.messageId, im.messageSubject, im.senderName, im.firstReceiverName, im.sendDate, im.isNew, im.messageSendId, im.pjFolderId
+ FROM messagerie_internalmessage im
+ WHERE im.folderMessageId = ?
+ ]]>
+ </sql>
+</custom-sql>
\ No newline at end of file