Mercurial > hg > orthanc-databases
comparison PostgreSQL/Plugins/SQL/Upgrades/UnknownToRev1.sql @ 569:f18e46d7dbf8 attach-custom-data
merged find-refactoring -> attach-custom-data
author | Alain Mazy <am@orthanc.team> |
---|---|
date | Tue, 24 Sep 2024 15:04:21 +0200 |
parents | ff84104f7842 |
children |
comparison
equal
deleted
inserted
replaced
368:82f73188b58d | 569:f18e46d7dbf8 |
---|---|
1 -- add the revision columns if not yet done | |
2 | |
3 DO $body$ | |
4 BEGIN | |
5 IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_schema='public' AND table_name='metadata' AND column_name='revision') THEN | |
6 ALTER TABLE Metadata ADD COLUMN revision INTEGER; | |
7 ELSE | |
8 raise notice 'the metadata.revision column already exists'; | |
9 END IF; | |
10 | |
11 IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_schema='public' AND table_name='attachedfiles' AND column_name='revision') THEN | |
12 ALTER TABLE AttachedFiles ADD COLUMN revision INTEGER; | |
13 ELSE | |
14 raise notice 'the attachedfiles.revision column already exists'; | |
15 END IF; | |
16 | |
17 END $body$; | |
18 |