From 4627a306d936a2f729a00590451a33e65912e872 Mon Sep 17 00:00:00 2001
From: Pedro Amorim <pedro.amorim@ptfs-europe.com>
Date: Mon, 3 Mar 2025 15:27:50 -0100
Subject: [PATCH] Bug 37901: atomicupdate: Add 'illrequest_id' column to
 statistics

---
 installer/data/mysql/atomicupdate/bug_37901.pl | 9 +++++++++
 1 file changed, 9 insertions(+)

diff --git a/installer/data/mysql/atomicupdate/bug_37901.pl b/installer/data/mysql/atomicupdate/bug_37901.pl
index 69bc27a7748..0619c990e68 100755
--- a/installer/data/mysql/atomicupdate/bug_37901.pl
+++ b/installer/data/mysql/atomicupdate/bug_37901.pl
@@ -36,6 +36,15 @@ return {
             $dbh->do(q{ DROP TABLE pseudonymized_borrower_attributes; });
         }
 
+        unless ( column_exists( 'statistics', 'illrequest_id' ) ) {
+            $dbh->do(
+                q{
+                ALTER TABLE statistics
+                ADD COLUMN `illrequest_id` int(11) DEFAULT NULL AFTER `other`
+            }
+            );
+        }
+
         say_success( $out, "Finished" );
     },
 };
-- 
2.39.5