From 399a0d9960e492d204a59e61c2c8f20db3a100c4 Mon Sep 17 00:00:00 2001 From: "Cameron E. Tidd" Date: Sun, 27 Jul 2025 00:36:30 +0000 Subject: [PATCH 2/3] Bug 16631: Fix bug_16631.pl --- installer/data/mysql/atomicupdate/bug_16631.pl | 10 +++++++--- 1 file changed, 7 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_16631.pl b/installer/data/mysql/atomicupdate/bug_16631.pl index 791831163f..c2656e161b 100755 --- a/installer/data/mysql/atomicupdate/bug_16631.pl +++ b/installer/data/mysql/atomicupdate/bug_16631.pl @@ -16,12 +16,16 @@ return { KEY `branchcode` (`branchcode`), CONSTRAINT `reports_branches_ibfk_1` FOREIGN KEY (`report_id`) REFERENCES `saved_sql` (`id`) ON DELETE CASCADE, CONSTRAINT `reports_branches_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE - ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; - INSERT IGNORE INTO systempreferences - (variable,value,options,explanation,type) VALUES ('EnableFilteringReports', '0', NULL, 'Enable ability for staff to filter report access based on home library.', 'YesNo');} + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci} ); say $out "Added new table 'reports_branches'"; + + $dbh->do( + q{INSERT IGNORE INTO systempreferences + (variable,value,options,explanation,type) VALUES ('EnableFilteringReports', '0', NULL, 'Enable ability for staff to filter report access based on home library.', 'YesNo')} + ); + say $out "Added new system preference 'EnableFilteringReports'"; }, }; -- 2.15.0