View | Details | Raw Unified | Return to bug 24239
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_24239-add_date_due_to_illrequests.pl (+15 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "24239",
5
    description => "Add date_due to illrequests",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        # Do you stuffs here
10
        $dbh->do(q{
11
            ALTER TABLE `illrequests`
12
            ADD `date_due` datetime DEFAULT NULL AFTER `biblio_id`
13
        });
14
    },
15
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 2792-2797 CREATE TABLE `illrequests` ( Link Here
2792
  `illrequest_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ILL request number',
2792
  `illrequest_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ILL request number',
2793
  `borrowernumber` int(11) DEFAULT NULL COMMENT 'Patron associated with request',
2793
  `borrowernumber` int(11) DEFAULT NULL COMMENT 'Patron associated with request',
2794
  `biblio_id` int(11) DEFAULT NULL COMMENT 'Potential bib linked to request',
2794
  `biblio_id` int(11) DEFAULT NULL COMMENT 'Potential bib linked to request',
2795
  `date_due` datetime DEFAULT NULL COMMENT 'Custom date due specified by backend, leave NULL for default date_due calculation',
2795
  `branchcode` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The branch associated with the request',
2796
  `branchcode` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The branch associated with the request',
2796
  `status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Current Koha status of request',
2797
  `status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Current Koha status of request',
2797
  `status_alias` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Foreign key to relevant authorised_values.authorised_value',
2798
  `status_alias` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Foreign key to relevant authorised_values.authorised_value',
2798
- 

Return to bug 24239