Mercurial > hg > orthanc

comparison OrthancServer/PrepareDatabase.sql @ 273:d384af918264

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
more detailed signal about deleted file
author Sebastien Jodogne <s.jodogne@gmail.com>
date Sat, 08 Dec 2012 22:34:56 +0100
parents 2354560daf2f
children c2be0a0e049e
comparison
equal deleted inserted replaced
272:337c506461d2 273:d384af918264
72 CREATE INDEX ChangesIndex ON Changes(internalId); 72 CREATE INDEX ChangesIndex ON Changes(internalId);
73 73
74 CREATE TRIGGER AttachedFileDeleted 74 CREATE TRIGGER AttachedFileDeleted
75 AFTER DELETE ON AttachedFiles 75 AFTER DELETE ON AttachedFiles
76 BEGIN 76 BEGIN
77 SELECT SignalFileDeleted(old.uuid); 77 SELECT SignalFileDeleted(old.uuid, old.fileType, old.uncompressedSize,
78 old.compressionType, old.compressedSize);
78 END; 79 END;
79 80
80 CREATE TRIGGER ResourceDeleted 81 CREATE TRIGGER ResourceDeleted
81 AFTER DELETE ON Resources 82 AFTER DELETE ON Resources
82 BEGIN 83 BEGIN