Mercurial > hg > orthanc-databases

view Odbc/Plugins/PrepareStorage.sql @ 595:272eeb046a88 find-refactoring

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Introduced a new ChildCount table in PG to improve retrieval of NumberOfRelatedStudyInstances and other similar tags that could consume up to 95% of a request time + added a DB-Housekeeper thread to populate the new table
author Alain Mazy <am@orthanc.team>
date Tue, 26 Nov 2024 17:59:14 +0100
parents b5fb8b77ce4d
children
line wrap: on
line source

CREATE TABLE StorageArea(
       uuid VARCHAR(64) NOT NULL PRIMARY KEY,
       content ${BINARY} NOT NULL,
       type INTEGER NOT NULL);