Mercurial > hg > orthanc

diff OrthancServer/Sources/Database/PrepareDatabase.sql @ 5080:d7274e43ea7c attach-custom-data

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
allow plugins to store a customData in the Attachments table to e.g. store custom paths without requiring an external DB
author Alain Mazy <am@osimis.io>
date Thu, 08 Sep 2022 17:42:08 +0200
parents 6eff25f70121
children 9770d537880d
line wrap: on
line diff
--- a/OrthancServer/Sources/Database/PrepareDatabase.sql	Wed Aug 31 10:36:38 2022 +0200
+++ b/OrthancServer/Sources/Database/PrepareDatabase.sql	Thu Sep 08 17:42:08 2022 +0200
@@ -63,6 +63,7 @@
        compressionType INTEGER,
        uncompressedMD5 TEXT,  -- New in Orthanc 0.7.3 (database v4)
        compressedMD5 TEXT,    -- New in Orthanc 0.7.3 (database v4)
+       customData TEXT,       -- New in Orthanc 1.12.0 (database v7)
        PRIMARY KEY(id, fileType)
        );              
 
@@ -114,7 +115,9 @@
   SELECT SignalFileDeleted(old.uuid, old.fileType, old.uncompressedSize, 
                            old.compressionType, old.compressedSize,
                            -- These 2 arguments are new in Orthanc 0.7.3 (database v4)
-                           old.uncompressedMD5, old.compressedMD5);
+                           old.uncompressedMD5, old.compressedMD5,
+                           -- customData is new in Orthanc 1.12.0 (database v7)
+                           old.customData);
 END;
 
 CREATE TRIGGER ResourceDeleted
@@ -143,4 +146,4 @@
 
 -- Set the version of the database schema
 -- The "1" corresponds to the "GlobalProperty_DatabaseSchemaVersion" enumeration
-INSERT INTO GlobalProperties VALUES (1, "6");
+INSERT INTO GlobalProperties VALUES (1, "7");