# HG changeset patch
# User Alain Mazy <am@osimis.io>
# Date 1707405516 -3600
# Node ID d1e1cb3ab741b0a17cde275f1a9e639a30e64613
# Parent  11c6bcc9d1f2ceaf2d2c83bd6ceb4f9b5d870232# Parent  19d40a152e49ea0c3d96796a550660bc172e1dd8
back to mainline

diff -r 11c6bcc9d1f2 -r d1e1cb3ab741 PostgreSQL/CMakeLists.txt
diff -r 11c6bcc9d1f2 -r d1e1cb3ab741 PostgreSQL/NEWS
--- a/PostgreSQL/NEWS	Mon Feb 05 18:26:37 2024 +0100
+++ b/PostgreSQL/NEWS	Thu Feb 08 16:18:36 2024 +0100
@@ -1,22 +1,30 @@
 Pending changes in the mainline
 ===============================
 
+
+Release 6.0 (2024-02-08)
+========================
+
+DB schema revision: 2
+
+* The DB schema has been updated to Revision 2.  If you need to reinstall the previous
+  version of the plugin, you should run this script:
+  https://orthanc.uclouvain.be/hg/orthanc-databases/file/tip/PostgreSQL/Plugins/SQL/Downgrades/Rev2ToRev1.sql
 * Transaction Mode:
-  Introduced a new configuration to select the transaction isolation level
-    "TransactionMode": "Serializable"
+  Introduced a new configuration "TransactionMode" to select the transaction isolation level.
   Allowed values: "Serializable", "ReadCommitted".
   The "Serializable" mode was the only available value up to now.  It is still the default
   value now.
   The "ReadCommitted" is possible now due to rewrites of SQL queries and notably improves
   the Orthanc ability to ingest data from multiple sources in parallel.
-* internals:
-  - Added a UNIQUE constraint on Resources.publicId to detect DB inconsistencies
 * New "EnableVerboseLogs" configuration to show SQL statements being executed.
 
 
 Release 5.1 (2023-06-27)
 ========================
 
+DB schema revision: 1
+
 * Optimization of LookupResources mainly used in tools/find, C-Find and QIDO-RS.
 
 Release 5.0 (2023-04-15)