changeset 6192:9e1bf1a1af50 attach-custom-data

fix DeletedFiles.customData type
author Alain Mazy <am@orthanc.team>
date Fri, 13 Jun 2025 08:04:30 +0200
parents e1168108e57f
children a7e762b386f1
files OrthancServer/Sources/Database/InstallDeletedFiles.sql OrthancServer/Sources/Database/PrepareDatabase.sql
diffstat 2 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- 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".
--- 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)
        );