Mercurial > hg > orthanc-databases

comparison PostgreSQL/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 7cea966b6829
children
comparison
equal deleted inserted replaced
365:7671fa7f099e 366:cd9521e04249
28 28
29 CREATE TABLE Metadata( 29 CREATE TABLE Metadata(
30 id BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE, 30 id BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE,
31 type INTEGER NOT NULL, 31 type INTEGER NOT NULL,
32 value TEXT, 32 value TEXT,
33 -- revision INTEGER, -- new in v4.0 (this column is added in PostgreSQLIndex::ConfigureDatabase)
33 PRIMARY KEY(id, type) 34 PRIMARY KEY(id, type)
34 ); 35 );
35 36
36 CREATE TABLE AttachedFiles( 37 CREATE TABLE AttachedFiles(
37 id BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE, 38 id BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE,
40 compressedSize BIGINT, 41 compressedSize BIGINT,
41 uncompressedSize BIGINT, 42 uncompressedSize BIGINT,
42 compressionType INTEGER, 43 compressionType INTEGER,
43 uncompressedHash VARCHAR(40), 44 uncompressedHash VARCHAR(40),
44 compressedHash VARCHAR(40), 45 compressedHash VARCHAR(40),
46 -- revision BIGINT, -- new in v 4.0 (this column is added in PostgreSQLIndex::ConfigureDatabase)
47 -- customData TEXT, -- new in v 4.X (this column is added in PostgreSQLIndex::ConfigureDatabase)
45 PRIMARY KEY(id, fileType) 48 PRIMARY KEY(id, fileType)
46 ); 49 );
47 50
48 CREATE TABLE Changes( 51 CREATE TABLE Changes(
49 seq BIGSERIAL NOT NULL PRIMARY KEY, 52 seq BIGSERIAL NOT NULL PRIMARY KEY,
110 RETURNS TRIGGER AS $body$ 113 RETURNS TRIGGER AS $body$
111 BEGIN 114 BEGIN
112 INSERT INTO DeletedFiles VALUES 115 INSERT INTO DeletedFiles VALUES
113 (old.uuid, old.filetype, old.compressedSize, 116 (old.uuid, old.filetype, old.compressedSize,
114 old.uncompressedSize, old.compressionType, 117 old.uncompressedSize, old.compressionType,
115 old.uncompressedHash, old.compressedHash); 118 old.uncompressedHash, old.compressedHash
119 -- old.customData -- new in v 4.X (this column is added in PostgreSQLIndex::ConfigureDatabase)
120 );
116 RETURN NULL; 121 RETURN NULL;
117 END; 122 END;
118 $body$ LANGUAGE plpgsql; 123 $body$ LANGUAGE plpgsql;
119 124
120 CREATE TRIGGER AttachedFileDeleted 125 CREATE TRIGGER AttachedFileDeleted