Mercurial > hg > orthanc-databases
view SQLite/Plugins/InstallCustomData.sql @ 569:f18e46d7dbf8 attach-custom-data
merged find-refactoring -> attach-custom-data
author | Alain Mazy <am@orthanc.team> |
---|---|
date | Tue, 24 Sep 2024 15:04:21 +0200 |
parents | cd9521e04249 |
children |
line wrap: on
line source
-- Add new column for customData ALTER TABLE AttachedFiles ADD COLUMN customData TEXT; ALTER TABLE DeletedFiles ADD COLUMN revision INTEGER; ALTER TABLE DeletedFiles ADD COLUMN customData TEXT; DROP TRIGGER AttachedFileDeleted; CREATE TRIGGER AttachedFileDeleted AFTER DELETE ON AttachedFiles BEGIN INSERT INTO DeletedFiles VALUES(old.uuid, old.filetype, old.compressedSize, old.uncompressedSize, old.compressionType, old.uncompressedHash, old.compressedHash, old.revision, old.customData); END;