From ef3d6a03de65a344b3dcf1cc5d2b7c6ecef60233 Mon Sep 17 00:00:00 2001
From: Katrin Fischer <katrin.fischer@bsz-bw.de>
Date: Fri, 25 Oct 2024 13:41:50 +0000
Subject: [PATCH] Bug 35906: (QA follow-up) Add AFTER to database update

Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de>
---
 installer/data/mysql/db_revs/240600045.pl | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/installer/data/mysql/db_revs/240600045.pl b/installer/data/mysql/db_revs/240600045.pl
index ebd09a5063..fa3423fc77 100755
--- a/installer/data/mysql/db_revs/240600045.pl
+++ b/installer/data/mysql/db_revs/240600045.pl
@@ -10,7 +10,7 @@ return {
 
         $dbh->do(
             q{
-            ALTER TABLE itemtypes ADD IF NOT EXISTS bookable INT(1) DEFAULT 0
+            ALTER TABLE itemtypes ADD IF NOT EXISTS bookable INT(1) DEFAULT 0 AFTER automatic_checkin
         }
         );
 
-- 
2.39.5