# HG changeset patch
# User Alain Mazy <am@orthanc.team>
# Date 1754906631 -7200
# Node ID 951d2ef62f5854bde559a0ce0ca2e1c6fbc6b550
# Parent  7c0157bf749c2c6be4251c123228320b8c30a074
add index on AuditLog.sourcePlugin

diff -r 7c0157bf749c -r 951d2ef62f58 PostgreSQL/Plugins/SQL/Downgrades/Rev6ToRev5.sql
--- a/PostgreSQL/Plugins/SQL/Downgrades/Rev6ToRev5.sql	Sun Aug 10 15:27:45 2025 +0200
+++ b/PostgreSQL/Plugins/SQL/Downgrades/Rev6ToRev5.sql	Mon Aug 11 12:03:51 2025 +0200
@@ -239,6 +239,7 @@
 DROP INDEX IF EXISTS AuditLogsUserId;
 DROP INDEX IF EXISTS AuditLogsResourceId;
 DROP INDEX IF EXISTS AuditLogsAction;
+DROP INDEX IF EXISTS AuditLogsSourcePlugin;
 DROP TABLE IF EXISTS AuditLogs;
 
 
diff -r 7c0157bf749c -r 951d2ef62f58 PostgreSQL/Plugins/SQL/PrepareIndex.sql
--- a/PostgreSQL/Plugins/SQL/PrepareIndex.sql	Sun Aug 10 15:27:45 2025 +0200
+++ b/PostgreSQL/Plugins/SQL/PrepareIndex.sql	Mon Aug 11 12:03:51 2025 +0200
@@ -837,6 +837,7 @@
 CREATE INDEX IF NOT EXISTS AuditLogsUserId ON AuditLogs (userId);
 CREATE INDEX IF NOT EXISTS AuditLogsResourceId ON AuditLogs (resourceId);
 CREATE INDEX IF NOT EXISTS AuditLogsAction ON AuditLogs (action);
+CREATE INDEX IF NOT EXISTS AuditLogsSourcePlugin ON AuditLogs (sourcePlugin);