view PostgreSQL/Plugins/SQL/Upgrades/UnknownToRev1.sql @ 570:73e784792a51 attach-custom-data

added missing files
author Alain Mazy <am@orthanc.team>
date Wed, 25 Sep 2024 09:25:58 +0200
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$;