Mercurial > hg > orthanc-databases

changeset 773:36f4a9992d11

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
rename
author Alain Mazy <am@orthanc.team>
date Fri, 28 Nov 2025 15:43:35 +0100
parents 5019e732058d
children 923b00f7aa2d
files PostgreSQL/Plugins/SQL/Downgrades/Rev10ToRev6.sql PostgreSQL/Plugins/SQL/Downgrades/Rev699ToRev6.sql
diffstat 2 files changed, 8 insertions(+), 8 deletions(-) [+]
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/PostgreSQL/Plugins/SQL/Downgrades/Rev10ToRev6.sql	Fri Nov 28 15:43:35 2025 +0100
@@ -0,0 +1,8 @@
+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
--- a/PostgreSQL/Plugins/SQL/Downgrades/Rev699ToRev6.sql	Fri Nov 28 15:38:54 2025 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,8 +0,0 @@
-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