Mercurial > hg > orthanc-databases

comparison PostgreSQL/Plugins/PrepareIndex.sql @ 418:a7f0f27fe33c pg-transactions

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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,