From d96ce42e05a3b0c6f198a98004db1907f74d460a Mon Sep 17 00:00:00 2001
From: Imani Thomas <imani.thomas@bywatersolutions.com>
Date: Fri, 14 Feb 2025 21:03:23 +0000
Subject: [PATCH] Bug 39142 Add debug permission to allow user to toggle JS and
 CSS customizations on/off

Database changes for 39142
---
 .../data/mysql/atomicupdate/Bug_39142.pl      | 22 +++++++++++++++++++
 installer/data/mysql/mandatory/userflags.sql  |  3 ++-
 2 files changed, 24 insertions(+), 1 deletion(-)
 create mode 100755 installer/data/mysql/atomicupdate/Bug_39142.pl

diff --git a/installer/data/mysql/atomicupdate/Bug_39142.pl b/installer/data/mysql/atomicupdate/Bug_39142.pl
new file mode 100755
index 0000000000..4c46ddac91
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/Bug_39142.pl
@@ -0,0 +1,22 @@
+use Modern::Perl;
+use Koha::Installer::Output qw(say_warning say_success say_info);
+
+return {
+    bug_number  => "39142",
+    description => "Adding a Debug User permission",
+    up          => sub {
+        my ($args) = @_;
+        my ( $dbh, $out ) = @$args{qw(dbh out)};
+
+        # Do you stuffs here
+        $dbh->do(
+            q{
+            INSERT IGNORE INTO userflags (bit, flag, flagdesc, defaulton)
+            VALUES (31, 'debug', 'Show Debug Interface', 0)
+        }
+        );
+
+        # permissions
+        say $out "Added new permission 'Debug'";
+    },
+};
diff --git a/installer/data/mysql/mandatory/userflags.sql b/installer/data/mysql/mandatory/userflags.sql
index 8e9fad2526..45e552d6f8 100644
--- a/installer/data/mysql/mandatory/userflags.sql
+++ b/installer/data/mysql/mandatory/userflags.sql
@@ -27,5 +27,6 @@ INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES
 (27, 'recalls', 'Recalls', 0),
 (28, 'erm', 'Manage electronic resources', 0),
 (29, 'loggedinlibrary', 'Change logged in library', 0),
-(30, 'preservation', 'Preservation module', 0)
+(30, 'preservation', 'Preservation module', 0),
+(31, 'debug', 'Show Debug Interface', 0)
 ;
-- 
2.39.5