# HG changeset patch # User Alain Mazy # Date 1749794670 -7200 # Node ID 9e1bf1a1af501c573afdf798ef3ea698af1bd336 # Parent e1168108e57f4ac968f21364b36327a261580c87 fix DeletedFiles.customData type diff -r e1168108e57f -r 9e1bf1a1af50 OrthancServer/Sources/Database/InstallDeletedFiles.sql --- a/OrthancServer/Sources/Database/InstallDeletedFiles.sql Fri Jun 13 07:24:04 2025 +0200 +++ b/OrthancServer/Sources/Database/InstallDeletedFiles.sql Fri Jun 13 08:04:30 2025 +0200 @@ -20,7 +20,7 @@ CREATE TABLE DeletedFiles( uuid TEXT NOT NULL, -- 0 - customData TEXT -- 1 + customData BLOB -- 1 ); -- We need to use another AttachedFileDeleted trigger than the legacy one in "Upgrade4To5.sql". diff -r e1168108e57f -r 9e1bf1a1af50 OrthancServer/Sources/Database/PrepareDatabase.sql --- a/OrthancServer/Sources/Database/PrepareDatabase.sql Fri Jun 13 07:24:04 2025 +0200 +++ b/OrthancServer/Sources/Database/PrepareDatabase.sql Fri Jun 13 08:04:30 2025 +0200 @@ -69,7 +69,7 @@ uncompressedMD5 TEXT, -- New in Orthanc 0.7.3 (database v4) compressedMD5 TEXT, -- New in Orthanc 0.7.3 (database v4) revision INTEGER, -- New in Orthanc 1.12.8 (added in InstallRevisionAndCustomData.sql) - customData BLOB, -- New in Orthanc 1.12.8 (added in InstallRevisionAndCustomData.sql) + customData BLOB, -- New in Orthanc 1.12.8 (added in InstallDeletedFiles.sql) PRIMARY KEY(id, fileType) );