Mercurial > hg > orthanc
comparison OrthancServer/PrepareDatabase.sql @ 273:d384af918264
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 |