Attachment #173562 for bug #33641

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




use Modern::Perl;
use Koha::Installer::Output qw(say_warning say_failure say_success say_info);

return {
    bug_number  => "33641",
    description => "Added issues.return_branch and old_issues.return_branch",
    up          => sub {
        my ($args) = @_;
        my ( $dbh, $out ) = @$args{qw(dbh out)};

        if ( !column_exists( 'issues', 'return_branch' ) ) {
            $dbh->do(
                q{
                ALTER TABLE issues
                ADD COLUMN return_branch varchar(10) DEFAULT NULL
                COMMENT 'foreign key, linking to the branches table for the location the item was returned'
                AFTER returndate
             }
            );
            say_success( $out, "Added column 'issues.return_branch'" );
        }
        if ( !column_exists( 'old_issues', 'return_branch' ) ) {
            $dbh->do(
                q{
                ALTER TABLE old_issues
                ADD COLUMN return_branch varchar(10) DEFAULT NULL
                COMMENT 'foreign key, linking to the branches table for the location the item was returned'
                AFTER returndate
             }
            );
            say_success( $out, "Added column 'old_issues.return_branch'" );
        }

    },
};

Return to bug 33641

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_33641.pl (+35 lines)
	1	use Modern::Perl;
	2	use Koha::Installer::Output qw(say_warning say_failure say_success say_info);
	3
	4	return {
	5	bug_number => "33641",
	6	description => "Added issues.return_branch and old_issues.return_branch",
	7	up => sub {
	8	my ($args) = @_;
	9	my ( $dbh, $out ) = @$args{qw(dbh out)};
	10
	11	if ( !column_exists( 'issues', 'return_branch' ) ) {
	12	$dbh->do(
	13	q{
	14	ALTER TABLE issues
	15	ADD COLUMN return_branch varchar(10) DEFAULT NULL
	16	COMMENT 'foreign key, linking to the branches table for the location the item was returned'
	17	AFTER returndate
	18	}
	19	);
	20	say_success( $out, "Added column 'issues.return_branch'" );
	21	}
	22	if ( !column_exists( 'old_issues', 'return_branch' ) ) {
	23	$dbh->do(
	24	q{
	25	ALTER TABLE old_issues
	26	ADD COLUMN return_branch varchar(10) DEFAULT NULL
	27	COMMENT 'foreign key, linking to the branches table for the location the item was returned'
	28	AFTER returndate
	29	}
	30	);
	31	say_success( $out, "Added column 'old_issues.return_branch'" );
	32	}
	33
	34	},
	35	};

Lines 3885-3890 CREATE TABLE `issues` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
3885	`date_due` datetime DEFAULT NULL COMMENT 'datetime the item is due (yyyy-mm-dd hh:mm::ss)',	3885	`date_due` datetime DEFAULT NULL COMMENT 'datetime the item is due (yyyy-mm-dd hh:mm::ss)',
3886	`branchcode` varchar(10) DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was checked out',	3886	`branchcode` varchar(10) DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was checked out',
3887	`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned, will be NULL until moved to old_issues',	3887	`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned, will be NULL until moved to old_issues',
		3888	`return_branch` varchar(10) DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was returned',
3888	`lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed',	3889	`lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed',
3889	`renewals_count` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed',	3890	`renewals_count` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed',
3890	`unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen',	3891	`unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen',
Lines 4888-4893 CREATE TABLE `old_issues` ( Link Here
4888	`date_due` datetime DEFAULT NULL COMMENT 'date the item is due (yyyy-mm-dd)',	4889	`date_due` datetime DEFAULT NULL COMMENT 'date the item is due (yyyy-mm-dd)',
4889	`branchcode` varchar(10) DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was checked out',	4890	`branchcode` varchar(10) DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was checked out',
4890	`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned',	4891	`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned',
		4892	`return_branch` varchar(10) DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was returned',
4891	`lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed',	4893	`lastreneweddate` datetime DEFAULT NULL COMMENT 'date the item was last renewed',
4892	`renewals_count` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed',	4894	`renewals_count` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of times the item was renewed',
4893	`unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen',	4895	`unseen_renewals` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'lists the number of consecutive times the item was renewed without being seen',
4894	-