Attachment #141263 for bug #31503

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




use Modern::Perl;

return {
    bug_number => 31503,
    description => "Adjust patron_consent.type and add AV category",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};
        $dbh->do(q{
ALTER TABLE patron_consent CHANGE COLUMN `type` `type` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron consent type; controlled by authorised values';
        });
        $dbh->do(q{
INSERT IGNORE INTO authorised_value_categories (category_name) VALUES ('PATRON_CONSENT');
        });
    },
};

Lines 19-24 INSERT IGNORE INTO authorised_value_categories( category_name, is_system ) Link Here

(-)a/installer/data/mysql/mandatory/auth_val_cat.sql (-1 / +1 lines)
19	('PA_CLASS', 0),	19	('PA_CLASS', 0),
20	('HOLD_CANCELLATION', 0),	20	('HOLD_CANCELLATION', 0),
21	('ROADTYPE', 0),	21	('ROADTYPE', 0),
		22	('PATRON_CONSENT', 0),
22	('AR_CANCELLATION', 0);	23	('AR_CANCELLATION', 0);
23		24
24	INSERT IGNORE INTO authorised_value_categories( category_name, is_system )	25	INSERT IGNORE INTO authorised_value_categories( category_name, is_system )
25	-

Return to bug 31503

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_31503.pl (+16 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => 31503,
	5	description => "Adjust patron_consent.type and add AV category",
	6	up => sub {
	7	my ($args) = @_;
	8	my ($dbh, $out) = @$args{qw(dbh out)};
	9	$dbh->do(q{
	10	ALTER TABLE patron_consent CHANGE COLUMN `type` `type` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron consent type; controlled by authorised values';
	11	});
	12	$dbh->do(q{
	13	INSERT IGNORE INTO authorised_value_categories (category_name) VALUES ('PATRON_CONSENT');
	14	});
	15	},
	16	};