Bugzilla – Attachment 175526 Details for
Bug 30301
Add a system preference to allow specifying the patron expiration notices as mandatory
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 30301: Add a new column to enforce the expiry notice
Bug-30301-Add-a-new-column-to-enforce-the-expiry-n.patch (text/plain), 2.71 KB, created by
Andrew Fuerste-Henry
on 2024-12-16 16:40:28 UTC
(
hide
)
Description:
Bug 30301: Add a new column to enforce the expiry notice
Filename:
MIME Type:
Creator:
Andrew Fuerste-Henry
Created:
2024-12-16 16:40:28 UTC
Size:
2.71 KB
patch
obsolete
>From d6f0413fc85c04de65e353db48b91af410df194e Mon Sep 17 00:00:00 2001 >From: Matt Blenkinsop <matt.blenkinsop@ptfs-europe.com> >Date: Tue, 3 Dec 2024 16:50:43 +0000 >Subject: [PATCH] Bug 30301: Add a new column to enforce the expiry notice > >Signed-off-by: Hanna Leiker <tech.hanna@salinapublic.org> >--- > ...30301-add_flag_to_enforce_expiry_notice.pl | 23 +++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 24 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_30301-add_flag_to_enforce_expiry_notice.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_30301-add_flag_to_enforce_expiry_notice.pl b/installer/data/mysql/atomicupdate/bug_30301-add_flag_to_enforce_expiry_notice.pl >new file mode 100755 >index 0000000000..42fcd222de >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_30301-add_flag_to_enforce_expiry_notice.pl >@@ -0,0 +1,23 @@ >+use Modern::Perl; >+use Koha::Installer::Output qw(say_warning say_success say_info); >+ >+return { >+ bug_number => "30301", >+ description => "Add a flag to enforce expiry notices", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ unless ( column_exists( 'categories', 'enforce_expiry_notice' ) ) { >+ $dbh->do( >+ q{ >+ ALTER TABLE categories ADD COLUMN `enforce_expiry_notice` tinyint(1) NOT NULL DEFAULT 0 >+ COMMENT "enforce the patron expiry notice for this category" >+ AFTER `noissueschargeguarantorswithguarantees` >+ } >+ ); >+ >+ say_success( $out, "Added column 'enforce_expiry_notice' to categories" ); >+ } >+ }, >+}; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 3bf15c1007..3770a5d6a9 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1819,6 +1819,7 @@ CREATE TABLE `categories` ( > `noissuescharge` int(11) DEFAULT NULL COMMENT 'define maximum amount outstanding before checkouts are blocked', > `noissueschargeguarantees` int(11) DEFAULT NULL COMMENT 'define maximum amount that the guarantees of a patron in this category can have outstanding before checkouts are blocked', > `noissueschargeguarantorswithguarantees` int(11) DEFAULT NULL COMMENT 'define maximum amount that the guarantors with guarantees of a patron in this category can have outstanding before checkouts are blocked', >+ `enforce_expiry_notice` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'enforce the patron expiry notice for this category', > PRIMARY KEY (`categorycode`), > UNIQUE KEY `categorycode` (`categorycode`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >-- >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 30301
:
175086
|
175087
|
175088
|
175089
|
175526
|
175527
|
175528
|
175529
|
181102
|
181103
|
181104
|
181105
|
181106
|
181107
|
181108
|
182152
|
182153
|
182154
|
182155
|
182156
|
182157
|
182158
|
182527
|
182529
|
182530
|
182531
|
182532
|
182533
|
182534
|
182535
|
182536
|
182537
|
182538