Attachment #136458 for bug #24239

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




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`
        });
    },
};

Lines 2792-2797 CREATE TABLE `illrequests` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
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

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_24239-add_date_due_to_illrequests.pl (+15 lines)
	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	};