Mercurial > hg > orthanc-databases
view PostgreSQL/Plugins/SQL/Upgrades/Rev6ToRev699.sql @ 751:2bf57bc22a30 pg-next-699 tip
added support for ReserveQueueValue + AcknowledgeQueueValue
author | Alain Mazy <am@orthanc.team> |
---|---|
date | Thu, 09 Oct 2025 17:20:42 +0200 |
parents | 2382e6fab2b6 |
children |
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;