Mercurial > hg > orthanc-databases

view PostgreSQL/Plugins/SQL/Upgrades/Rev6ToRev699.sql @ 756:97da5aa716a0 pg-next-699

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
renaming supports_extended_queues as supports_reserve_queue_value
author Sebastien Jodogne <s.jodogne@gmail.com>
date Tue, 18 Nov 2025 18:37:45 +0100
parents 2bf57bc22a30
children 3327126233a6
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 TIMESTAMP DEFAULT NULL;