Mercurial > hg > orthanc-databases
view PostgreSQL/Plugins/SQL/Downgrades/Rev10ToRev6.sql @ 773:36f4a9992d11
rename
| author | Alain Mazy <am@orthanc.team> |
|---|---|
| date | Fri, 28 Nov 2025 15:43:35 +0100 |
| parents | PostgreSQL/Plugins/SQL/Downgrades/Rev699ToRev6.sql@2382e6fab2b6 |
| children |
line wrap: on
line source
ALTER TABLE InvalidChildCounts DROP COLUMN pk; ALTER TABLE GlobalIntegersChanges DROP COLUMN pk; ---------- -- set the global properties that actually documents the DB version, revision and some of the capabilities -- modify only the ones that have changed DELETE FROM GlobalProperties WHERE property IN (4); INSERT INTO GlobalProperties VALUES (4, 6); -- GlobalProperty_DatabasePatchLevel
