Mercurial > hg > orthanc-databases
view PostgreSQL/Plugins/SQL/Upgrades/UnknownToRev1.sql @ 618:20d7c9471e8e
fix pg unit tests (1)
author | Alain Mazy <am@orthanc.team> |
---|---|
date | Wed, 18 Dec 2024 11:23:35 +0100 |
parents | ff84104f7842 |
children |
line wrap: on
line source
-- add the revision columns if not yet done DO $body$ BEGIN IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_schema='public' AND table_name='metadata' AND column_name='revision') THEN ALTER TABLE Metadata ADD COLUMN revision INTEGER; ELSE raise notice 'the metadata.revision column already exists'; END IF; IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_schema='public' AND table_name='attachedfiles' AND column_name='revision') THEN ALTER TABLE AttachedFiles ADD COLUMN revision INTEGER; ELSE raise notice 'the attachedfiles.revision column already exists'; END IF; END $body$;