Mercurial > hg > orthanc-databases
diff PostgreSQL/Plugins/SQL/Upgrades/Rev1ToRev2.sql @ 470:11c6bcc9d1f2
cleanup
author | Alain Mazy <am@osimis.io> |
---|---|
date | Mon, 05 Feb 2024 18:26:37 +0100 |
parents | ff84104f7842 |
children | f18e46d7dbf8 |
line wrap: on
line diff
--- a/PostgreSQL/Plugins/SQL/Upgrades/Rev1ToRev2.sql Mon Feb 05 09:48:11 2024 +0100 +++ b/PostgreSQL/Plugins/SQL/Upgrades/Rev1ToRev2.sql Mon Feb 05 18:26:37 2024 +0100 @@ -1,4 +1,4 @@ --- This file contains part of the changes required to upgrade from 6.1 to 6.2 (DB version 6 and revision 2) +-- This file contains part of the changes required to upgrade from Revision 1 to Revision 2 (DB version 6 and revision 1 or 2) -- It actually contains only the changes that: -- can not be executed with an idempotent statement in SQL -- or would polute the PrepareIndex.sql @@ -35,13 +35,13 @@ END $body$ LANGUAGE plpgsql; --- In V6.2, we'll now use temporary tables so we need to remove the old tables that might have been used in previous revisions ! +-- In Rev2, we'll now use temporary tables so we need to remove the old tables that might have been used in previous revisions ! -- these statements, although idempotent, are not part of PrepareIndexV2.sql to keep it clean DROP TABLE IF EXISTS DeletedFiles; DROP TABLE IF EXISTS RemainingAncestor; DROP TABLE IF EXISTS DeletedResources; --- These triggers disappears and are not replaced in V6.2 +-- These triggers disappears and are not replaced in Rev2 DROP TRIGGER IF EXISTS CountResourcesTracker ON Resources; -- The signature has changed so we must delete the function before replacing it.