Mercurial > hg > orthanc-databases
comparison 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 |
comparison
equal
deleted
inserted
replaced
417:15bfd9a76f8d | 418:a7f0f27fe33c |
---|---|
6 CREATE TABLE Resources( | 6 CREATE TABLE Resources( |
7 internalId BIGSERIAL NOT NULL PRIMARY KEY, | 7 internalId BIGSERIAL NOT NULL PRIMARY KEY, |
8 resourceType INTEGER NOT NULL, | 8 resourceType INTEGER NOT NULL, |
9 publicId VARCHAR(64) NOT NULL, | 9 publicId VARCHAR(64) NOT NULL, |
10 parentId BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE | 10 parentId BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE |
11 -- UNIQUE (publicId) -- this is made unique in C++ code (new in plugin v X.Y.Z) | |
11 ); | 12 ); |
12 | 13 |
13 CREATE TABLE MainDicomTags( | 14 CREATE TABLE MainDicomTags( |
14 id BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE, | 15 id BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE, |
15 tagGroup INTEGER, | 16 tagGroup INTEGER, |