Mercurial > hg > orthanc-databases

comparison MySQL/Plugins/PrepareIndex.sql @ 366:cd9521e04249 attach-custom-data

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
DatabaseBackendAdapterV4: added support for customData + revision when not already done
author Alain Mazy <am@osimis.io>
date Thu, 15 Sep 2022 18:12:34 +0200
parents 9e419261f1c9
children
comparison
equal deleted inserted replaced
365:7671fa7f099e 366:cd9521e04249
46 compressedSize BIGINT, 46 compressedSize BIGINT,
47 uncompressedSize BIGINT, 47 uncompressedSize BIGINT,
48 compressionType INTEGER, 48 compressionType INTEGER,
49 uncompressedHash VARCHAR(40), 49 uncompressedHash VARCHAR(40),
50 compressedHash VARCHAR(40), 50 compressedHash VARCHAR(40),
51 -- revision INTEGER, -- new in v 4.X, added in MySQLIndex::ConfigureDatabase
52 -- customData LONGTEXT, -- new in v 4.X, added in MySQLIndex::ConfigureDatabase
51 PRIMARY KEY(id, fileType), 53 PRIMARY KEY(id, fileType),
52 CONSTRAINT AttachedFiles1 FOREIGN KEY (id) REFERENCES Resources(internalId) ON DELETE CASCADE 54 CONSTRAINT AttachedFiles1 FOREIGN KEY (id) REFERENCES Resources(internalId) ON DELETE CASCADE
53 ); 55 );
54 56
55 CREATE TABLE Changes( 57 CREATE TABLE Changes(
102 compressedSize BIGINT, -- 2 104 compressedSize BIGINT, -- 2
103 uncompressedSize BIGINT, -- 3 105 uncompressedSize BIGINT, -- 3
104 compressionType INTEGER, -- 4 106 compressionType INTEGER, -- 4
105 uncompressedHash VARCHAR(40), -- 5 107 uncompressedHash VARCHAR(40), -- 5
106 compressedHash VARCHAR(40) -- 6 108 compressedHash VARCHAR(40) -- 6
109 -- revision INTEGER, -- new in v 4.X, added in MySQLIndex::ConfigureDatabase
110 -- customData LONGTEXT, -- new in v 4.X, added in MySQLIndex::ConfigureDatabase
107 ); 111 );
108 -- End of differences 112 -- End of differences
109 113
110 114
111 115
117 FOR EACH ROW 121 FOR EACH ROW
118 BEGIN 122 BEGIN
119 INSERT INTO DeletedFiles VALUES(old.uuid, old.filetype, old.compressedSize, 123 INSERT INTO DeletedFiles VALUES(old.uuid, old.filetype, old.compressedSize,
120 old.uncompressedSize, old.compressionType, 124 old.uncompressedSize, old.compressionType,
121 old.uncompressedHash, old.compressedHash)@ 125 old.uncompressedHash, old.compressedHash)@
126 -- old.revision, old.customData -- new in v 4.X, added in MySQLIndex::ConfigureDatabase
127
122 END; 128 END;
123 129
124 130
125 CREATE TRIGGER ResourceDeleted 131 CREATE TRIGGER ResourceDeleted
126 BEFORE DELETE ON Resources -- WARNING: Must be "BEFORE", otherwise the attached file is already deleted 132 BEFORE DELETE ON Resources -- WARNING: Must be "BEFORE", otherwise the attached file is already deleted
127 FOR EACH ROW 133 FOR EACH ROW
128 BEGIN 134 BEGIN
129 INSERT INTO DeletedFiles SELECT uuid, fileType, compressedSize, uncompressedSize, compressionType, uncompressedHash, compressedHash FROM AttachedFiles WHERE id=old.internalId@ 135 INSERT INTO DeletedFiles SELECT uuid, fileType, compressedSize, uncompressedSize, compressionType, uncompressedHash, compressedHash FROM AttachedFiles WHERE id=old.internalId@
136 -- revision, customData -- new in v 4.X, added in MySQLIndex::ConfigureDatabase
130 END; 137 END;
131 138
132 139
133 CREATE TRIGGER PatientAdded 140 CREATE TRIGGER PatientAdded
134 AFTER INSERT ON Resources 141 AFTER INSERT ON Resources