Mercurial > hg > orthanc-databases
diff PostgreSQL/Plugins/PrepareIndex.sql @ 366:cd9521e04249 attach-custom-data
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 |
line wrap: on
line diff
--- a/PostgreSQL/Plugins/PrepareIndex.sql Tue Jul 05 08:44:26 2022 +0200 +++ b/PostgreSQL/Plugins/PrepareIndex.sql Thu Sep 15 18:12:34 2022 +0200 @@ -30,6 +30,7 @@ id BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE, type INTEGER NOT NULL, value TEXT, + -- revision INTEGER, -- new in v4.0 (this column is added in PostgreSQLIndex::ConfigureDatabase) PRIMARY KEY(id, type) ); @@ -42,6 +43,8 @@ compressionType INTEGER, uncompressedHash VARCHAR(40), compressedHash VARCHAR(40), + -- revision BIGINT, -- new in v 4.0 (this column is added in PostgreSQLIndex::ConfigureDatabase) + -- customData TEXT, -- new in v 4.X (this column is added in PostgreSQLIndex::ConfigureDatabase) PRIMARY KEY(id, fileType) ); @@ -112,7 +115,9 @@ INSERT INTO DeletedFiles VALUES (old.uuid, old.filetype, old.compressedSize, old.uncompressedSize, old.compressionType, - old.uncompressedHash, old.compressedHash); + old.uncompressedHash, old.compressedHash + -- old.customData -- new in v 4.X (this column is added in PostgreSQLIndex::ConfigureDatabase) + ); RETURN NULL; END; $body$ LANGUAGE plpgsql;