Mercurial > hg > orthanc-databases

view PostgreSQL/Plugins/SQL/Upgrades/Rev6ToRev10.sql @ 779:6ae96abcc97a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
revert to libpq 13.1 since 13.23 requires patching for VS2008 + 2015
author Alain Mazy <am@orthanc.team>
date Mon, 01 Dec 2025 11:37:38 +0100
parents a07d176a4b58
children 135bd5b3228c
line wrap: on
line source

-- Adding a PK to these 2 table to allow pg_repack to process these tables, enabling reclaiming disk space and defragmenting the tables.

ALTER TABLE InvalidChildCounts ADD COLUMN pk BIGSERIAL PRIMARY KEY;
ALTER TABLE GlobalIntegersChanges ADD COLUMN pk BIGSERIAL PRIMARY KEY;

-- Adding the queues timeout
ALTER TABLE Queues ADD COLUMN reservedUntil BIGINT DEFAULT NULL;