Mercurial > hg > orthanc-databases

comparison SQLite/Plugins/InstallCustomData.sql @ 366:cd9521e04249 attach-custom-data

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
DatabaseBackendAdapterV4: added support for customData + revision when not already done
author Alain Mazy <am@osimis.io>
date Thu, 15 Sep 2022 18:12:34 +0200
parents
children
comparison
equal deleted inserted replaced
365:7671fa7f099e 366:cd9521e04249
1
2 -- Add new column for customData
3 ALTER TABLE AttachedFiles ADD COLUMN customData TEXT;
4 ALTER TABLE DeletedFiles ADD COLUMN revision INTEGER;
5 ALTER TABLE DeletedFiles ADD COLUMN customData TEXT;
6
7
8 DROP TRIGGER AttachedFileDeleted;
9
10 CREATE TRIGGER AttachedFileDeleted
11 AFTER DELETE ON AttachedFiles
12 BEGIN
13 INSERT INTO DeletedFiles VALUES(old.uuid, old.filetype, old.compressedSize,
14 old.uncompressedSize, old.compressionType,
15 old.uncompressedHash, old.compressedHash,
16 old.revision, old.customData);
17 END;