Mercurial > hg > orthanc-databases
diff PostgreSQL/Plugins/PrepareIndex.sql @ 418:a7f0f27fe33c pg-transactions
wip: advisory lock around CreateInstance: not ok see WO-139
author | Alain Mazy <am@osimis.io> |
---|---|
date | Tue, 27 Jun 2023 15:17:39 +0200 |
parents | 7cea966b6829 |
children | 7c1fe5d6c12c |
line wrap: on
line diff
--- a/PostgreSQL/Plugins/PrepareIndex.sql Fri Jun 23 14:26:58 2023 +0200 +++ b/PostgreSQL/Plugins/PrepareIndex.sql Tue Jun 27 15:17:39 2023 +0200 @@ -8,6 +8,7 @@ resourceType INTEGER NOT NULL, publicId VARCHAR(64) NOT NULL, parentId BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE + -- UNIQUE (publicId) -- this is made unique in C++ code (new in plugin v X.Y.Z) ); CREATE TABLE MainDicomTags(