Mercurial > hg > orthanc-databases

changeset 665:3ef7ca114790 attach-custom-data

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fixes
author Alain Mazy <am@orthanc.team>
date Thu, 22 May 2025 10:13:54 +0200
parents 48460f653628
children fb71c140ce2d
files Framework/Plugins/IndexBackend.cpp PostgreSQL/Plugins/SQL/PrepareIndex.sql
diffstat 2 files changed, 5 insertions(+), 5 deletions(-) [+]
line wrap: on
line diff
--- a/Framework/Plugins/IndexBackend.cpp	Wed May 21 23:42:55 2025 +0200
+++ b/Framework/Plugins/IndexBackend.cpp	Thu May 22 10:13:54 2025 +0200
@@ -4497,7 +4497,7 @@
     {
       DatabaseManager::CachedStatement statement(
         STATEMENT_FROM_HERE, manager,
-        "INSERT INTO Queues VALUES(${queueId}, ${value})");
+        "INSERT INTO Queues VALUES(${AUTOINCREMENT} ${queueId}, ${value})");
 
       Dictionary args;
 
@@ -4525,13 +4525,13 @@
       {
         statement.reset(new DatabaseManager::CachedStatement(
                         STATEMENT_FROM_HERE, manager,
-                        "SELECT id, value FROM Queues WHERE storeId= " + queueIdParameter + " ORDER BY id ASC " + formatter.FormatLimits(0, 1)));
+                        "SELECT id, value FROM Queues WHERE queueId= " + queueIdParameter + " ORDER BY id ASC " + formatter.FormatLimits(0, 1)));
       }
       else
       {
         statement.reset(new DatabaseManager::CachedStatement(
                         STATEMENT_FROM_HERE, manager,
-                        "SELECT id, value FROM Queues WHERE storeId= " + queueIdParameter + " ORDER BY id DESC " + formatter.FormatLimits(0, 1)));
+                        "SELECT id, value FROM Queues WHERE queueId= " + queueIdParameter + " ORDER BY id DESC " + formatter.FormatLimits(0, 1)));
       }
         
       statement->Execute(formatter.GetDictionary());
--- a/PostgreSQL/Plugins/SQL/PrepareIndex.sql	Wed May 21 23:42:55 2025 +0200
+++ b/PostgreSQL/Plugins/SQL/PrepareIndex.sql	Thu May 22 10:13:54 2025 +0200
@@ -1,4 +1,4 @@
--- This SQL file creates a DB in Rev2 directly
+-- This SQL file creates a DB in Rev5 directly
 -- It is also run after upgrade scripts to create new tables and or create/replace triggers and functions.
 -- This script is self contained, it contains everything that needs to be run to create an Orthanc DB.
 -- Note to developers: 
@@ -721,7 +721,7 @@
 EXECUTE PROCEDURE UpdateChildCount();
 
 
--- new in 1.12.99
+-- new in 1.12.99 (rev 5 ?)
 
 CREATE TABLE KeyValueStores(
        storeId TEXT NOT NULL,