From d0479b1972488f15edd3f94af56df654befa3fd7 Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Wed, 5 Jun 2024 22:10:34 +0000 Subject: [PATCH] Bug 35635: DB Updates Signed-off-by: Brendan Lawlor Signed-off-by: Jonathan Druart --- .../data/mysql/atomicupdate/bug_35635_add_opac_mandatory.pl | 6 ++++-- installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 5 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_35635_add_opac_mandatory.pl b/installer/data/mysql/atomicupdate/bug_35635_add_opac_mandatory.pl index 61fa3815518..ea1cf91637c 100755 --- a/installer/data/mysql/atomicupdate/bug_35635_add_opac_mandatory.pl +++ b/installer/data/mysql/atomicupdate/bug_35635_add_opac_mandatory.pl @@ -19,10 +19,12 @@ return { say $out "Added column 'borrower_attribute_types.opac_mandatory'"; - $dbh->do(q{ + $dbh->do( + q{ UPDATE borrower_attribute_types SET opac_mandatory = 1 WHERE mandatory = 1; - }); + } + ); say $out "Update opac_mandatory to match mandatory column"; } }, diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 4c639f1e497..1a1fb8b6d89 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -6756,4 +6756,4 @@ CREATE TABLE `zebraqueue` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-11-25 12:13:27 +-- Dump completed on 2024-11-25 12:13:27 \ No newline at end of file -- 2.39.5