Mercurial > hg > orthanc

comparison OrthancServer/PrepareDatabase.sql @ 694:72dc919a028c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
upgrade database from v3 to v4
author Sebastien Jodogne <s.jodogne@gmail.com>
date Wed, 05 Feb 2014 13:26:19 +0100
parents 01d8611c4a60
children badc14fee61f
comparison
equal deleted inserted replaced
693:01d8611c4a60 694:72dc919a028c
76 CREATE TRIGGER AttachedFileDeleted 76 CREATE TRIGGER AttachedFileDeleted
77 AFTER DELETE ON AttachedFiles 77 AFTER DELETE ON AttachedFiles
78 BEGIN 78 BEGIN
79 SELECT SignalFileDeleted(old.uuid, old.fileType, old.uncompressedSize, 79 SELECT SignalFileDeleted(old.uuid, old.fileType, old.uncompressedSize,
80 old.compressionType, old.compressedSize, 80 old.compressionType, old.compressedSize,
81 -- These 2 arguments are new in Orthanc 0.7.3 (database v4)
81 old.uncompressedMD5, old.compressedMD5); 82 old.uncompressedMD5, old.compressedMD5);
82 END; 83 END;
83 84
84 CREATE TRIGGER ResourceDeleted 85 CREATE TRIGGER ResourceDeleted
85 AFTER DELETE ON Resources 86 AFTER DELETE ON Resources