Bugzilla – Attachment 136458 Details for
Bug 24239
Let the ILL module set ad hoc hard due dates
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 24239: Add column illrequests.date_due
Bug-24239-Add-column-illrequestsdatedue.patch (text/plain), 2.33 KB, created by
Tomás Cohen Arazi (tcohen)
on 2022-06-23 18:45:38 UTC
(
hide
)
Description:
Bug 24239: Add column illrequests.date_due
Filename:
MIME Type:
Creator:
Tomás Cohen Arazi (tcohen)
Created:
2022-06-23 18:45:38 UTC
Size:
2.33 KB
patch
obsolete
>From 60f3c899b8f1c57375e97966ad75e1c6106c9aca Mon Sep 17 00:00:00 2001 >From: Lari Taskula <lari.taskula@hypernova.fi> >Date: Wed, 9 Feb 2022 23:06:37 +0000 >Subject: [PATCH] Bug 24239: Add column illrequests.date_due > >Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de> >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io> >--- > .../bug_24239-add_date_due_to_illrequests.pl | 15 +++++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 16 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_24239-add_date_due_to_illrequests.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_24239-add_date_due_to_illrequests.pl b/installer/data/mysql/atomicupdate/bug_24239-add_date_due_to_illrequests.pl >new file mode 100755 >index 0000000000..a8eb9beda1 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_24239-add_date_due_to_illrequests.pl >@@ -0,0 +1,15 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "24239", >+ description => "Add date_due to illrequests", >+ up => sub { >+ my ($args) = @_; >+ my ($dbh, $out) = @$args{qw(dbh out)}; >+ # Do you stuffs here >+ $dbh->do(q{ >+ ALTER TABLE `illrequests` >+ ADD `date_due` datetime DEFAULT NULL AFTER `biblio_id` >+ }); >+ }, >+}; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index f3a73a50fa..93e06cbbc9 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -2792,6 +2792,7 @@ CREATE TABLE `illrequests` ( > `illrequest_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ILL request number', > `borrowernumber` int(11) DEFAULT NULL COMMENT 'Patron associated with request', > `biblio_id` int(11) DEFAULT NULL COMMENT 'Potential bib linked to request', >+ `date_due` datetime DEFAULT NULL COMMENT 'Custom date due specified by backend, leave NULL for default date_due calculation', > `branchcode` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The branch associated with the request', > `status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Current Koha status of request', > `status_alias` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Foreign key to relevant authorised_values.authorised_value', >-- >2.34.1
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 24239
:
96246
|
106409
|
130056
|
130057
|
130414
|
130415
|
130416
|
133475
|
133476
|
133477
|
135244
|
135245
|
135246
|
135943
|
135944
|
135945
| 136458 |
136459
|
136460
|
136461
|
136462
|
136463