# HG changeset patch
# User Alain Mazy <am@orthanc.team>
# Date 1758548901 -7200
# Node ID 9097dd8235b810148749cab4592ea23fe6149298
# Parent  2382e6fab2b67980245a0d08b9ca9005f0bda6cd
fix

diff -r 2382e6fab2b6 -r 9097dd8235b8 PostgreSQL/Plugins/SQL/PrepareIndex.sql
--- a/PostgreSQL/Plugins/SQL/PrepareIndex.sql	Mon Sep 22 11:02:20 2025 +0200
+++ b/PostgreSQL/Plugins/SQL/PrepareIndex.sql	Mon Sep 22 15:48:21 2025 +0200
@@ -85,7 +85,6 @@
         );
 
 CREATE TABLE IF NOT EXISTS GlobalIntegers(
-       pk BIGSERIAL PRIMARY KEY,   -- new in rev699 required for pg_repack to be able to reclaim space
        key INTEGER PRIMARY KEY,
        value BIGINT);
 -- GlobalIntegers keys:
@@ -401,6 +400,7 @@
 -- These changes will be applied at regular interval by an external thread or when someone
 -- requests the statistics
 CREATE TABLE IF NOT EXISTS GlobalIntegersChanges(
+    pk BIGSERIAL PRIMARY KEY,   -- new in rev699 required for pg_repack to be able to reclaim space
     key INTEGER,
     value BIGINT);