Mercurial > hg > orthanc-databases

comparison MySQL/Plugins/InstallRevisionAndCustomData.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 ALTER TABLE AttachedFiles ADD COLUMN revision INTEGER;
2 ALTER TABLE DeletedFiles ADD COLUMN revision INTEGER;
3 ALTER TABLE Metadata ADD COLUMN revision INTEGER;
4
5 ALTER TABLE AttachedFiles ADD COLUMN customData LONGTEXT;
6 ALTER TABLE DeletedFiles ADD COLUMN customData LONGTEXT;
7
8 DROP TRIGGER AttachedFileDeleted;
9
10 CREATE TRIGGER AttachedFileDeleted
11 AFTER DELETE ON AttachedFiles
12 FOR EACH ROW
13 BEGIN
14 INSERT INTO DeletedFiles VALUES(old.uuid, old.filetype, old.compressedSize,
15 old.uncompressedSize, old.compressionType,
16 old.uncompressedHash, old.compressedHash,
17 old.revision, old.customData)@
18 END;
19
20
21 DROP TRIGGER ResourceDeleted;
22
23 CREATE TRIGGER ResourceDeleted
24 BEFORE DELETE ON Resources
25 FOR EACH ROW
26 BEGIN
27 INSERT INTO DeletedFiles SELECT uuid, fileType, compressedSize, uncompressedSize, compressionType, uncompressedHash, compressedHash, revision, customData FROM AttachedFiles WHERE id=old.internalId@
28 END;