Bugzilla – Attachment 178425 Details for
Bug 31642
Control locations for HTML customizations from new table or Authorised values
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 31642: Database revision for upgrades
Bug-31642-Database-revision-for-upgrades.patch (text/plain), 3.00 KB, created by
Marcel de Rooy
on 2025-02-20 15:35:06 UTC
(
hide
)
Description:
Bug 31642: Database revision for upgrades
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2025-02-20 15:35:06 UTC
Size:
3.00 KB
patch
obsolete
>From b2c9c6cee0e2cbe1b61c24c63f432c1da644ed1e Mon Sep 17 00:00:00 2001 >From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >Date: Thu, 20 Feb 2025 15:22:38 +0000 >Subject: [PATCH] Bug 31642: Database revision for upgrades >Content-Type: text/plain; charset=utf-8 > >Test plan: >Run updatedatabase.pl >Verify that the three new categories were added. > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > .../data/mysql/atomicupdate/bug_31642.pl | 52 +++++++++++++++++++ > 1 file changed, 52 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_31642.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_31642.pl b/installer/data/mysql/atomicupdate/bug_31642.pl >new file mode 100755 >index 0000000000..c13dc416cc >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_31642.pl >@@ -0,0 +1,52 @@ >+use Modern::Perl; >+use Koha::Installer::Output qw(say_warning say_success say_info); >+ >+return { >+ bug_number => "31642", >+ description => "Add three AV categories and values for HTML blocks", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ $dbh->do( >+ q{ >+INSERT IGNORE INTO authorised_value_categories (category_name, is_system) VALUES >+ ('ADD_CONT_HTML_OPAC_SYSTEM', 1), >+ ('ADD_CONT_HTML_STAFF_SYSTEM', 1), >+ ('ADD_CONT_HTML_CUSTOM', 0); >+} >+ ); >+ >+ foreach my $block_location ( >+ 'OpacNavRight', 'opacheader', 'OpacCustomSearch', 'OpacMainUserBlock', 'opaccredits', >+ 'OpacLoginInstructions', 'OpacNav', 'OpacNavBottom', 'OpacSuggestionInstructions', >+ 'ArticleRequestsDisclaimerText', 'OpacMoreSearches', 'OpacMySummaryNote', 'OpacLibraryInfo', >+ 'OpacMaintenanceNotice', 'OPACResultsSidebar', 'OpacSuppressionMessage', 'SCOMainUserBlock', >+ 'SelfCheckInMainUserBlock', 'SelfCheckHelpMessage', 'CatalogConcernHelp', 'CatalogConcernTemplate', >+ 'CookieConsentBar', 'CookieConsentPopup', 'PatronSelfRegistrationAdditionalInstructions', >+ 'ILLModuleCopyrightClearance' >+ ) >+ { >+ $dbh->do( >+ qq{ >+INSERT IGNORE INTO authorised_values ( category, authorised_value, lib, lib_opac ) >+VALUES ( 'ADD_CONT_HTML_OPAC_SYSTEM', '$block_location', '$block_location', '$block_location' ) >+ } >+ ); >+ } >+ >+ foreach my $block_location ( >+ 'IntranetmainUserblock', 'RoutingListNote', 'StaffAcquisitionsHome', >+ 'StaffAuthoritiesHome', 'StaffCataloguingHome', 'StaffListsHome', 'StaffLoginInstructions', >+ 'StaffPatronsHome', 'StaffPOSHome', 'StaffSerialsHome' >+ ) >+ { >+ $dbh->do( >+ qq{ >+INSERT IGNORE INTO authorised_values ( category, authorised_value, lib, lib_opac ) >+VALUES ( 'ADD_CONT_HTML_STAFF_SYSTEM', '$block_location', '$block_location', '$block_location' ) >+ } >+ ); >+ } >+ }, >+}; >-- >2.39.5
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 31642
:
178424
|
178425
|
178426
|
179183
|
179184
|
179185
|
179205
|
182904