Mercurial > hg > orthanc-databases
comparison PostgreSQL/Plugins/SQL/Upgrades/UnknownToRev1.sql @ 467:ff84104f7842 pg-transactions
renamed v6.2 to REV2 + removed 'default' TransactionMode + renamed 'READ COMMITTED' into 'ReadCommitted'
| author | Alain Mazy <am@osimis.io> |
|---|---|
| date | Mon, 05 Feb 2024 09:43:14 +0100 |
| parents | PostgreSQL/Plugins/SQL/Upgrades/UnknownToV6.1.sql@f2427f94d879 |
| children |
comparison
equal
deleted
inserted
replaced
| 466:daaa35ddba54 | 467:ff84104f7842 |
|---|---|
| 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 |