Mercurial > hg > orthanc

comparison OrthancServer/PrepareDatabase.sql @ 693:01d8611c4a60

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
md5 for attached files
author Sebastien Jodogne <s.jodogne@gmail.com>
date Tue, 04 Feb 2014 17:52:51 +0100
parents dbecea588ef5
children 72dc919a028c
comparison
equal deleted inserted replaced
692:1a3f9d90a2dd 693:01d8611c4a60
30 fileType INTEGER, 30 fileType INTEGER,
31 uuid TEXT, 31 uuid TEXT,
32 compressedSize INTEGER, 32 compressedSize INTEGER,
33 uncompressedSize INTEGER, 33 uncompressedSize INTEGER,
34 compressionType INTEGER, 34 compressionType INTEGER,
35 uncompressedMD5 TEXT, -- New in Orthanc 0.7.3 (database v4)
36 compressedMD5 TEXT, -- New in Orthanc 0.7.3 (database v4)
35 PRIMARY KEY(id, fileType) 37 PRIMARY KEY(id, fileType)
36 ); 38 );
37 39
38 CREATE TABLE Changes( 40 CREATE TABLE Changes(
39 seq INTEGER PRIMARY KEY AUTOINCREMENT, 41 seq INTEGER PRIMARY KEY AUTOINCREMENT,
73 75
74 CREATE TRIGGER AttachedFileDeleted 76 CREATE TRIGGER AttachedFileDeleted
75 AFTER DELETE ON AttachedFiles 77 AFTER DELETE ON AttachedFiles
76 BEGIN 78 BEGIN
77 SELECT SignalFileDeleted(old.uuid, old.fileType, old.uncompressedSize, 79 SELECT SignalFileDeleted(old.uuid, old.fileType, old.uncompressedSize,
78 old.compressionType, old.compressedSize); 80 old.compressionType, old.compressedSize,
81 old.uncompressedMD5, old.compressedMD5);
79 END; 82 END;
80 83
81 CREATE TRIGGER ResourceDeleted 84 CREATE TRIGGER ResourceDeleted
82 AFTER DELETE ON Resources 85 AFTER DELETE ON Resources
83 BEGIN 86 BEGIN
101 END; 104 END;
102 105
103 106
104 -- Set the version of the database schema 107 -- Set the version of the database schema
105 -- The "1" corresponds to the "GlobalProperty_DatabaseSchemaVersion" enumeration 108 -- The "1" corresponds to the "GlobalProperty_DatabaseSchemaVersion" enumeration
106 INSERT INTO GlobalProperties VALUES (1, "3"); 109 INSERT INTO GlobalProperties VALUES (1, "4");